Transformers

I need to create a heat map that splits up square polygons into all of their overlapping portions and attributes each with a count of how many overlaps there are.First I ran a dissolver and assigned IDs to each region:And then I ran an AreaOnAreaOverlayer with a Group By assigned to the IDs for each region. This meant that the polygons were only compared against other polygons that they might actually intersect rather than everything in the whole world. From this I got a count per box which I can use to create a heat map:The problem is that in the Middle East region of the map, there are so many polygons (~14,000) that the AreaOnAreaOverlayer is failing long before it has managed to process all of the polygons in that area. This means that this is the only area for which I cannot create a heat map. Going forward, it might be that there are far more polygons than that that all overlap so potentially this problem is going to get even worse.Does anyone have any tips on how I can create a

Does any know of a method of finding all 'kickbacks' within a polyline or polygon dataset, and then repairing/removing these?A kickback is defined as:The internal and external angles between two segments are less than the set parameter in degrees e.g. 45 degreesThe distance between the external spike and the external polygon boundary and the internal spike and the internal polygon boundary is less than the set parameter in metres e.g. 10mFME has a transformer that deals with Spikes, but I cannot see an equivalent for kickbacks.Thanks in advance

Some of my team attended the World Tour in Austin yesterday, and we wanted to share some of the AR presentations with our directors. Are these available anywhere? The AR leveraging the indoors mapping for intraoffice route finding was especially interesting.

Hi all, I have a JSON file. Each object in the file has the coordinate of the start and end point of a line. I would like to transform it to geojson file with linestring. Any ideas how can i do this? Example:{        "cityName" : "Brussel",        "endPoint.x" : "4.31888222694397",        "endPoint.y" : 50.79171001911163,        "startPoint.x" : "4.3186622858047485",        "startPoint.y" : 50.79149007797241 }Best

Hi! I'm new to work with Autocad and SVG-files in FME. I'm trying to convert 500+ Autocad-files to SVG-files and most of the SVG files get correct. Attached is a workspace with an Autocad-file that doesn't get correct. Open the Autocad file in Autocad to see how it should look like. Why does the SVG get incorrect, and is there anything I can do to get it correct?  Best regards, Ken Karlsson

Is it possible to keep the order of the query fields when you get the attributes using 'Populate from SQL Query...'? I use it very often and the attributes are ordered alphabetically instead of the order in the query.Thank you

I am trying to use the 2DEllipseReplacer, with the same minor and major axis properties but different rotation angles(30 vs 60). The output received doesn't look right. Please see attachments for more details on parameters being used and result received. Thanks in advance for inputs and suggestions to fix this issue

Hello All, I am using API for retrieving data, post call need be formatted to specific format I have used template to create and upload by post call in HTTPCaller. Template created from ESRI Shapefile it is working fine. The problem that everything is being loaded into the JSON upload body. But i would like it to be split by e features before it hits the HTTPCaller. If the count is limited it is working but with heavy data API get overloaded so I would like to hit one by one does any one have solution how could I can be done please find attached FME Workbench for reference.  

Hi,I have a big workspace that can potentially stop at different steps because the workspace is going through multiple readers and some of them can have no features.Is there a way to execute a SQL script whenever the workspace is stopping ?The goal of this script is to check some integrity rules in the database (Postgres).Maybe the python shutdown script could do that but maybe there is a simpler way.Thank you for any help.

I'm trying to create a word doc report containing photos and tables for each feature in a points shape file. I've managed to get 1 photo and relevant table per feature using MSWordStyler transformers and grouping/sort to pass in order. But some features have 2 photos which I'd like to display side by side (above the table). Can anyone advise? Thanks Chris

I have an existing FME 2015 workspace that writes records to a PostgreSQL database.With FME 2015, it writes 2626 records to the database.With a FME 2018 workspace i count with SQLcreator the number of records in the PostgreSQL database using the next SQL statement. Select Nspname AS SchemaName, Relname, ReltuplesWHERE Nspname NOT IN (' Pg_catalog ', ' information_schema ') AND Relkind = ' R 'ORDER BY reltuples DESC; It returns as result 2626 records Now I open that same FME2015 workspace and save it as FME2018, I run that workspace again and it writes again 2626 Records.Only, when I run workspace with the SQLcreator again, it returns as result only 1000 records. In both cases, the PostgreSQL database has the correct number of records, only if they are written with 2015 The SQL statement gives the correct number of records and if they are written with 2018 then the SQLstatement gives a wrong number of records. Does someone know what i do wrong?

@steveatsafeGood morning,I am having issues with writing to our Azure Database. We have a bunch of features that have correlating Ids. The objective is to find the latest and greatest feature(s) based on a uuid that is assigned to each feature and the features that relate to it. The SQL query I wrote before worked up until now. Now I receive this error message "com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting from a character string to uniqueidentifier." Unsure why all of sudden this is happening.  DECLARE @aprt_id INT = $(Arpt_ID), @address_id UNIQUEIDENTIFIER; ;WITH idetails AS ( SELECT *, ROW_NUMBER() OVER (PARTITION BY venue_id ORDER BY record_id DESC) AS recency FROM airport WHERE ARPT_ID = @arpt_id ) SELECT @address_id = address_id FROM idetails WHERE recency = 1; SELECT * FROM airport, dbo.[building] as building, dbo.[utility_pipe] as utility_pipe WH

I am trying to add a custom transformation from Romanian national projection to WGS84.I have added the .gsb file and the XFORM_DEF to MyCoordSysDefs.fme and the horizontal transformation works with CSMapReprojector.I tried adding a Vertical transformation but I keep getting the error:Couldn't open file named C:\\Program Files\\FME\\Reproject\\GeoidHeightGrids\\World\\..\\..\\GridData\\WW15MGH.GRD.CS-MAP Reprojector: Unable to load geoid height grid 'C:\\Program Files\\FME/Reproject\\GeoidHeightGrids\\World\\Egm96-Wgs84.gdc'Reprojector: Could not create reprojection engineI tried a custom GRD file and that doesn't work either. The same error:Couldn't open file named C:\\Program Files\\FME\\Reproject\\GeoidHeightGrids\\Romania\\..\\..\\GridData\\Romania\\EGG97_QGR.grd.CS-MAP Reprojector: Unable to load geoid height grid 'C:\\Program Files\\FME/Reproject\\GeoidHeightGrids\\Romania\\EGM96_QGR1.gdc'Reprojector: Could not create reprojection engineI tried using th

Hey FME'ites,I'm having issues trying to bring over a georeferenced JPG to an esri raster GDB. The long story short is I have a folder filled with different images that had been georeferenced in ArcMap. I wanted to migrate all of it to a raster GDB. I'm attempting this on just one JPG to start; a simple JPG reader and Raster GDB writer. I do not set a CRS on the reader or writer because the supplemental georeference file should take care of that. The workbench outputs successfully and the image has the correct coordinate system, but the image is nowhere near its correct destination and it is at a tiny scale. Does the JPG reader not correctly read the supplemental .jgwx georeference data file? Thanks for your time.

Hi,I'm making to convert .TAB file to .mbtiles, but I got errors :MBTILES writer: Failed to obtain raster from feature. Only features with raster geometry are expectedA fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details Could you please tell me why? Thank you

actually what I am trying to do is reading two GDBs one with updated values and one having old entries. Suppose in GDB 1 there are entries like 1,2,3,4and 5 and in updated GDB2 the entries are like 1,2,4,& 6. So I don't want to create new GDB I just want to add entry 6 in GDB1 and remove entry 3 & 5 from GDB1. For finding out the change I have made use of Change detector but after that when I am trying to insert it in the GDB I am able to update just one feature type at once but not all feature types

Hallo everybody, Thanks to fme user @erik_jan i made my first FME model converter for rd coordinates.I use AttributeReprojector too do the job but i dont know what coordinate system i have too use.my source coordinate system is Netherland-RDOld- 2008. that seems right because it gave me the same x,y (111114, 566230) coordinate as the original file. I want too convert it too 53.08111, 4.73228 coordinates but i dont know what destination coordinate systeem i have too use. I try different things but didnt get the desire result. My attempts to google it, search on this forum was without results. So i hope i can put the question here so somebody can help me with it.Greetings,Charaf  

Hi All,  I am currently trying to load in some raster tiles that I have downloaded from the European Space Agency in FME. I have already successfully displayed them in ArcMap and are in a D_WGS_1984 projection. FME does not seem to recognize the spatial reference as it cannot display them in the visualizer and when any transformers are used, they seem to turn them upside down and out them at the origin of any projection that they are set to.  Has anyone else found this problem before who could maybe help out or is this just a problem that is unique to the dataset I am using?  Many Thanks

Hi,  I have a set of vector grids in FGD, I want to overlay these on some rasters. I have managed to achieve this but I want to make the grid slightly transparent, I have tried adding 0.4 after the third colour value but that doesn't seem to hold when I run it through VectorOnRasterOverlayer. Has anyone got any other ideas on how to achieve this?I have attached my workbench so far.  ThanksBGrid_ADD.fmw

The expansion of FME into the local government space has grown beyond spatial solutions, leading FME to become the enterprise solution of choice. We are excited to announce that pricing for population-based pricing as a subscription model is now available on our website. Please note that this is an additional offer and we are not removing the FME purchase option. If you have any questions, please reach out to your Channel Account Manager, or find more details on our blog post.

Hey good people of FME and beyond,I have hundreds of MapInfo workspaces that need their Coordinate System converted from Irish Grid to ITM. All associated tables which make up each workspace have to be updated also. Is there any way to read in a MapInfo workspace to FME and update?At present the only way to do it is batch convert the tables and then rebuild the workspaces individually.Would value any ideas?Thanks all,Irene

Hello FME-rs,I am wondering if it is possible to run FME as in Commandline with the source and destination dataset and other parameters from within GE Smallworld Magik?TxSRG

Hallo everybody, This will be my first model. I have seen the power of FME and i want too learn it.My first problem that i want to solve in FME is;  i have a excel file contains x,y rijksdriehoek coordinates i want to convert it too gps location.Can somebody help me with a model or tell me what handler i can use to get the desire results. The output should be a column with gps coordinates in excel. Thank you for your time and helpGreets,Charaf from the Netherlands

Using a S3Connector on our FME2019 desktop using an authenticated S3 connection I get the following message.I have Cloudberry connected to the S3 bucket on this same machine and it works using the same authentication details.Could it be our authenticated firewall proxy? Or is it something else?

Hello,I am trying to update a square footage attribute on a room within an Enterprise Asset Management (EAM) System using web services. The new square footage is coming from a revised AutoCAD file.Here is my workflow so far. I read in the AutoCAD file and use the room values to construct XML to hit a GET web service for each room. I then extract the FLOORAREA attribute using a XML Fragmenter and compare this FLOORAREA value with the AREA attribute in the AutoCAD records to find the differences. When a difference is found I want to take the AREA record from the AutoCAD file and update the FLOORAREA attribute within the XML responseBody. I have looked at several posts and examples on here but I am a complete beginner at Xquery. I am not sure what I am doing wrong.After the FLOORAREA value is updated, I then have to reformat the XML within the responseBody so I can send it along to the SYNC web service and update EAM.I have attached a FMW with only the relevant portion of my ETL in hopes