Transformers

Hi,Please, any transformer suggestion about how transpose the Table1 into Table2 ? Table1ID Field2005 Field2006 Field2009 Field20181 10.0    28.0  23.8    -3.82 80.0    34.0    -3.8    40.0 Table2ID YEAR VALUE1 2005 10.01 2006 28.01 2009 23.81 2018 -3.82 2005 80.02 2006 34.02 2009 -3.82 2018 40.0 Neither of List transformers nor AttributeExploder + Aggregator transformers work in this case. I have been working with these examples [1] but I don't get exactly what I need.  Before using PythonCaller I would like to inspect other transformer possiblities. So, any FME workpace example or transformer suggestion is apreciated.  Thank you [1]

I read in map drawings that have the coordinate system defined. There are many files so they have multiple systems (mostly state plane but still varied systems) I have opened the dwgs and they have a coordinate system defined correctly in AutoCAD Map 3D. I have also used the geomap command and they are all correctly located in the state plane cs they say they are in. I use the csExtractor then a test filter to test for whether there is a CS defined. Then near the end prior to writing to fgdb I have CsmapReprojector to reproject the data (with read from feature) to LL84. After the wb completes successfully i open the fgdb to find that (only some) of the data has been reprojected too far south of the US. In reality they are not IN south america. but they are south of Mexico in the ocean. (see screen shot)The only thing i can find go

How could i force the shortest path finder to go through some specific points ? i have used 20 points (from to line ) , and my network .and 10 points,i would like the path to go through them if there is a path . i used the shortest path finder to find the shortest path and it works great but i have some points , in network .i would like to go through this point if there is a path . as example , i have Pt.a - Pt.b (i found the path in network between A - B) but i have some points inside the network as Pt.c ,i would like to check if there is a path through pt.c or not even if it is longer .so, if there is a path then the path will be A-C-B ,if not ,the path will be A-B .i think , i should add to cost attribute but i am not sure ,how could i consider the Points.Thanks for help .

I'm trying to convert GTFS transport data to Shapefile using  FME 2020.0.0.0 (20200309 - Build 20200 - macosx) Quick Translator, but I get this exception: << FME 2020.0.0.0 (20200309 - Build 20200 - macosx) FME Home Edition (node locked-crc) Temporary License: 234 days left. Machine host name is: YOS0897 Operating System: Mac OS X Version 10.15.3 (Build 19D76) Copyright (c) 1994 - 2020, Safe Software Inc. Safe Software Inc.Creating reader for format: General Transit Feed Specification (GTFS)Trying to find a PYTHON plugin for reader named `GTFS'The workspace does not contain user Python. FME will attempt to use a Python 3.7+ interpreterUsing Python interpreter from `/Library/FME/2020.0/fmepython37/lib/libpython3.7m.dylib' with PYTHONHOME `/Librar

Hi Guys, Is there a way to sort linear polygon features by spatial continuity and then merge then until they reach an specific size? I have the following features which are basically a polygon which was chopped into different parts by a specific length of its center line.  To give you a bit of context, I am basically trying to build a workspace that would split linear complex polygon (as the one below) into parts with a maximum of 1km2. However, these parts have to be continuity and not be multipart as they will be used to make separate enquiries in a website. For example sorting by Easting or Northing wouldn't work here as I would end up with separate parts mainly in the top right corner. Is there a way to do this using FME?  Thanks

I have an ArcSDE Geodatabase created and stored in a PostgreSQL 11.1 Server. There is a Feature Class within the Geodatabase that has attachments. I have a ArcSDE GeoDB Feature Reader Transformer added to a Workspace, configured to read the Feature Class and its attachments and it does not read the attachments.

I have a request to produce files in a custom format that is almost but not quite an esri ascii grid. The header is different and the raster portion is individually hex encoded. I can deal with the header easily enough, but I'm a bit stuck on how to produce the hex encoded body. I can write an ascii grid file, read it back in as a text file, strip the header and then hex encoded it but that seems a bit elaborate. The RasterExtractor doesn't have ascii grid as a format, otherwise I would use that. Thoughts? Ex snip of a file 512512200000200000-31500  0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 6 6 6 6 6 6 6 6 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 4 6 6 6 6 6 6 6 6 6 6 6 6 0 0 0 0 1 1 5 6 6 6 6 6 6 6 7 a 10 28 43 60 7e 9c b9 d3 ee fe ff ff ff ff ff ff ff 0 1 4 4 6 6 6 6 6 11 22 37 54 71 8e ab c9 e5 f1 fb ff ff ff ff f

How do I georeference a set of lines in fme? I know how to geofence the raster. But without georeferencing the lines the overlay will not match up?

Hi list.I'm using a SQLCreator to read (!) some data from our administration database. The query fails, because FME wraps my query into a SELECT-INTO construct, that requires "CREATE TABLE" permission, which my task (of course) doesn't have.Q1: Why does FME wrap my query into such a construct?Q2: What other ways do I have to accomplish a guaranteed read-only query?Using 2020.1Cheers

Hi guys. I have created ca 40 000 annotations for a basemap im working on and some of the angled texts overlap. Is there a good way to displace them, like a "negative snapper"? thanks for all the help i can get!

I am trying to read an esri file geodatabase that is zipped but I get this error Geodatabase Error (-2147024893): The system cannot find the path specified.Could not open File Geodatabase dataset `C:\\Instaplat\\workspaces\\TexasWorkspaces\\INSTAPLAT_PROTOTYPE.gdb.zip' for readingA fatal error has occurred. Check the logfile above for details I have attached a workspace that produces this behavior, any help is appreciated. 

Looking above my CurveFitter doesnt seem to consist of a set of lines which i could then test? How do I get the image to be a defined set of line data? My project is attached. I just want to get rid of all the small lines and dots present after the last CurveFitter transformer. But I'm not sure each line is its own 'object' so Icant get LengthCalculator and Tester to work?

After the workspace opens up, the transaction log has the following msg.  Download Url: https://fmehubproducti

I currently have four identical methods, the only difference is the input and output datasets.  Basically the script looks like this:Reader of dataset 1-> processing method X -> writer to dataset 1 Reader of dataset 2-> processing method X -> writer to dataset 2 Reader of dataset 3-> processing method X -> writer to dataset 3Reader of dataset 4-> processing method X -> writer to dataset 4  As you can see the processing method X does not change because all of the input datasets/output are similar, and is simply repeated, copy and pasted. Is there a better way to do this that isn't as cluttered? Is it possible to loop through readers /writers to avoid having to copy and paste the method over and over? Thanks.  

Thank you. I've done the everything just not quite seeing the lines appear ontop of the rasta. It seems as if the lines are condensed together at the top left of the rasta once they are combined. Image below.    The yellow lines now seem to be top right? Why are they not overlayed to look the same as above?

I have a counter transformer in a workspace and it is giving me a weird count value. The value that comes out is : @Value(__fme_ft_return_value73e8b8c0-7916-4466-bd7c-e869a55224a1)  I have never seen anything but a number come out so I am baffled.

With in the context of of using the MapnikRasterize Transformer?

How do I overlay a set of lines on an image? See below…. I cant see the lines on the image?

I have a bunch of the data in MicroStation GG format(DGN with MDB -Database).In that data we have line & Area geometry type data. & with We have common geometry with another lines in 2D or 3d as per the feature list as project requirement.Need to identify the vertex missing in the in the common geometry lines or areas,if any line has 2d or 3d snap in the common geometry then this also need to identify,If any line which is near to another line(within 10CM) this also need to identify.Please suggest the possibilities of the transformers. I have tried Line on line overlay, convert the lines into points and used point of line overlay, neighbor finder option and more . . But I am not able to get the desired output. Thank you in advance for your support. .

i have several points and i want to connect each point to another points to find the shortest path between each point and another points if exist . as shown as in image .connect Points A with B,C,D,E,F,G,H,I,J .connects Point B with A,C,D,E,F,G,H,I,J .connects Point C with A,B,D,E,F,G,H,I,J .and connect each point with the rest of the points.then i would like to cancel the duplicate connection ,as above if Point A connects to Point B ,so it is the same connection from Point B to Point A .so i want to delete the duplicate connection.i have tried to use line builder ,he connects all points together but when i used it as input for (from ... to )in shortest path finder ,and i used also for the another input network properly noded ,i got no paths output .so i was thinking that i should use vertex creator instead of line builder ,so i need to create several lines from each point to the rest of points .then i want to

How dow you set an image as a background on FME and then superimpose a point cloud or polygons on top of the image

I need to do some comparison and tricks with z-coordinates in AttributeCreator transformer. Of course I can use CoordinateExtractor before AttributeCreator but it would be more useful to do the stuff inside AttributeCreator.Something like (z-value for fourth coordinate in polyline) : @Evaluate($(fme_geometry).{3}.z)

We have a geological 3D (voxel) model that contains the geological formation code for each voxel. The voxel model can be stored as csv file that contains xcoord, ycoord, zcoord and the formation code of each voxel. The x, y and z coordinates represent the voxel centers. We are able to generate a vectorized representation of each voxel cell (see image) , this is however very heavy. The goal is to create a brep solid or csg that represents all voxels containing the same formation code and sharing at least one common edge or side. These Solids may contain holes, where another formation is present. Formations may occur multiple times spatially disconnected. In this way we want to reduce the amount of elements/features and the size for visualization purposes.Kind regards, Philip

I cannot find any practical examples of this and cannot get it to work in practice.

I would like to fill polygons with Circles of a designated size. Basically show me how many full circles will fit inside each polygon. This is of course related to figuring out a maximum number of people could physically fit within the various areas of our airport and maintain a certain level of physical distancing. I could figure out some methods using the Tiler transformer but these would be squares and will impact the results. Here is a link to someone else who was trying to figure out the same issue.https://gis.stackexchange.com/questions/193482/how-to-calculate-how-many-polygons-i-can-put-inside-a-polygon