Transformers

My organisation keeps its data in epsg:314685783, which is an extension of the GK4-epsg:31468 with the epsg:5783 altitude reference system ( https://epsg.io/5783 )How can I read such data from an oracle db and convert it to epsg:31468 for further storage in a postgis database.Currently my server job fails with "ORACLE Reader: No exceptions match for SRID `314685783' was found -- determining coordinate system using Well Known Text"

Hello FME'rsI have a problem that either I've been staring at for too long or maybe I'm just way off base on. Either way, I can't seem to get the desired output:I have (2) datasets: an oracle non-spatial table and a xlsx fileI am trying to add rows from my xlsx file to the db tableThere is no "ID" field in my xlsx file, so I would like the new rows from the xlsx to populate the "ID" field(s) where the existing table left off (max+1)I have tried to add the existing table as a reader --> run through a StatisticsCalculator to get "_max" --> through AttributeCreator for the new features, set "ID" to @Value(_max)+1 --> my result is "+1" on all of the "ID" fields instead of a sequential numbering.What step(s) am I missing?Thank you for your help!

Hi everybody,Why FME calculates different area in compare with Qgis.I have one area calculates in FME as: 46,56, but in Qgis the area is: 56,56.Thank´s

Hi there,I've been toying a lot with rasters lately, but I've hit a bit of a snag. I need to create a raster from shape files that has a resolution based on another step that takes place in my workbench. I'll explain:So first thing I have is a set of polyline geometries. In quite few steps (BoundingBoxAccumilator ->GeometryCoarcer ->Chopper ->LengthCalculator-> StatisticsCalculator) I know what the longest and shortest edge is of the bounding box of my geometry, by using the Minimum and Maximum based on the lengths calculated. Anyway, this is just to give some context, it is not the problem area. I did inspect this output and I do get for example Minimum:1000, Maximum 1500.I also have a FeatureReader separately attached to the BoundingBoxAccumilator mentioned above, which calls a WMS layer and outputs a raster based on the inside of the bounding box. Naturally this will also have a Rows/Columns of 1000x1500 as it uses the same bounding box as my geometries.Now t

We have a need to read some spatial data that is zipped up, but several of the zips are then nested inside another zip, just to make things fun. Like this:c:\\temp\\top.zip\\1.zip\\1.gmlc:\\temp\\top.zip\\2.zip\\2.gmlFME can read say GML from inside a Zip, but not GML from a Zip inside a Zip. Anyone got any magic to unpack the top level Zip? I suspect the answer is Python, perhaps as either a PythonCaller or Startup script and then I could use a FeatureReader to get at the data at the next level.Seems a bit contrived but its a genuine requirement as its the way a product is shipped. 1 zip file was clearly not enough!Thanks

Hi guys,We have a problem. We have a CAD file and we need the original color to be displayed automatically in ArcGIS. We are able to map the CAD color index to RGB values. Do you have an idea? Can you help us?

I don't know if it's reasonable the FeatureJoiner will assign the <null> to missing attributes with an outer join mode (Left or Full).

Hi,I am using CoordinateExtractor to get the start and end points of around 200k lines in a shapefile. This is working fine for around 90% of the lines, but for around 20k of them the coordinates are the same. I have inspected many of these lines and the start and end points are clearly in different places and there's nothing about them that would indicate why i'm getting a different result to all other lines in the shapefile.Any ideas?

Hello! I am getting errors while trying to delete records from using the Informix ODBC writers. I am putting the columns to match in the delete column row and getting an error that those columns do not exist:IBM Informix Spatial Writer: Error - No column named ltt_id found in table xxxxxA fatal error has occurred. Check the logfile above for detailsOr just that there was error:A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...and the only other thing written is a warning about assuming the geometry is 2D.Has anyone else had any trouble with this?

I've been trying to apply an image as a texture to a vertical wall (from CAD 3D solid to Geodatabase multipatch format). As a brief summary my current workflow is:1. de-aggregate CAD 3D solid and select vertical wall of interest to apply texture to2. swap coordinates Y<>Z so that the vertical wall has a top-down view3. use the AppearanceSetter transformer to apply a GeoTiff using the 'texture coordinate generation parameters' settings: 'Use Existing Texture Coordinates = Yes and 'Texture Mapping Type = Top Down Georeferenced'4. swap coordinates Y<>Z again so that the wall moves back to its vertical position5. write to an ESRI geodatabase as a multipatchThe result is that the geotiff is applied at the correct location as a texture BUT then areas of nothing (ie. area where the background colour can't be modified, but the multipatch is still there) are tiled alternately with the image across the rest of the mulitpatch.I've tried changing various

Hi everyone,In my organization we have some users of FME desktop and up till now I have done manual installations on every computer. But now I would like our technicians to deploy it automatically. But they are have trouble with the msi-file that can be downloaded on Customer downloads page. Is there an other msi-file that doesn´t hold 3 other msi-files or an exe-file somewhere for download? 2018 and 64-bit version is the one I´m looking for.Thanks in advanceJenny

Hello,I'm using the PointOnPoint Overlayer to find if any points overlap. When I use the transformer and let the workbench run, I get an attribute value of _overlap: 72, for each individual point. None of the points overlap (see attached picture). I thought I would get an overlap value of 1 because the points do not overlap. Is there a reason why each point is getting an overlap of 72?*the total number of points in the file is 72*Thanks! David

Hello allIm trying to Drape 2D FME points, (Which are centre points of trees extracted from LAS data) and trying to drape these points on a Surface model. At the moments all the points are level under by surface. I cant seem to be able to drapeI have tried using the SurfaceDrapper but my points stay the same level. Any ideasThanks in advance

Hello AllIm hoping someone can help me with a particular problem i am having trying to edit a Tin Suface.I have created some FBX files of ground surfaces using point cloud data. Easy However i now want to feed FME a DGN or DWG that contains outlines shapes, that i can use to cut holes in my FBX TinSurface. I feel i have tried everything :( I have tried also to remove the points from the point cloud and remake the mesh, with added holes, but the surface modeller joins the holes back up. eeerrrr!Any help would be much appricated

Can fme creat a hemisphere like this below? Thanks a lot.

Does FME support reading/writing Navigation Data Standard?

Hi guysI need to detect two parallel line within certain distance (15m) in a road network

I have 4 workspaces that follow the same process (they each just calculate different fields on different feature classes). Within these workspaces, I use a VariableSetter and a Variable Retriever. In order to get the Setter to run before the Retriever, I have Set the Connection Runtime Order (as recommended in this post), as well as adding a Sorter in front of the VariableRetriever. This has worked in 3 out of the 4 workspaces, but for some reason, is not working in the 4th. Again, these workflows have an identical setup, they each just manage different attributes in an AttributeManager (that runs after the Variable Retriever). Has anyone had experience with additional methods of getting the Retriever to run AFTER the Setter (other than Set Connection Runtime Order and adding a Sorter)? Thanks.

How can we use AttributeCreator which receives an array of data to only pull the last index of that array?

Is there any way I can pass a non numeric attribute to the RasterExpressionEvaluator?  Specifically I want to pass a conditional statement.  ex. If(A[0]==somevalue || A[0]==someothervalue,0,255)  I can't really build the statement in the expression evaluator directly because I don't know in advance how many parts the conditional will have.  I keep getting the error Expression Evaluator: Attribute '_Recode' has non-numeric value, but if I hardcode the resolved expression directly in the RasterExpressionEvaluator it works exactly as expected. 

Hi, I am carrying out data quality tests and I would like the results of failed tests in an excel doc. I would normally use the AttributeValidator and the _fme_validation_message but I need to use testers. An example of one test: if the 'type' = individual then the 'industry sector' should be null. So in the table below, I would want to see the last line in an error reportTypeIndustry sectorindividualcompanyagriculturecompanyconstructionindividualretailAny suggestions welcome.

Hello, there I am looking to extract data from a public web site, I used the HTML Table reader, but I am not getting the expected value in the table website: https://www.stats.gov.sa/en/160 

Hi Guys,I have a text file that contains both header information with necessary attribute fields and a fixed width set of sequential coordinates with bearing and distances that create the polygons of a cadastre. I need to create the polygons with the attributes attached. If I read in the file as a CAT, I can't find a way to retrieve the attribute information at the topIf I read it as a text file, then split on the ----, I can sort of retrieve the header information as attributes, but then can't figure out how to extract the fixed width stuff into lists. Also, all the the blank spaces are causing me issues in creating a set of headings, especially as the first line of the definition is blanks until you get to the radial, OR the E/N.I was going to try to read these in as a sequential list - ie, each feature is also referencing the one before and the one after... it should be relatively easy to do! Any thoughts on the best way to do this? Sample text file attached.(Definitions: I

Hi I have a point and polygon layer. I need to populate different counts of points in each polygon satisfying different attribute queries on the point layer.e.g count of supermarkets, sports centre in each polygons. I have 8 such queries, so would populate 8 fields in the polygon layer.I tried using TestFilter on point fc then PointOnAreaOverlay, but this doesn't work as I cannot get multiple If and If statements from TestFilter. Instead It gives me If Else If.I would like to avoid having 8 different TestFilters and PointOnAreaOverlay transformers if possible.Any ideas?

I'm using the AreaOnAreaOverlayer to intersect two large sets of polygons (Polygon 1 & Polygon 2 for clarity), one of which (Polygon 1) contains overlapping polygons which are sometimes coincident with each other, but with different attributes. The transformer is only overlaying one of several polygons from Polygon 1 with Polygon 2 and dropping the others from the output, but I need all of them to be intersected and output.What other transformers can I use to prepare the data so that all polygons are intersected?I'm using FME Workbench 2016.1, and can't currently upgrade.Thanks,Matt