Transformers

Hi I have a point and polygon feature class.I need to find out the ids of polygons which contains greater or equal to than specified numbers of points. Also I need to get the point attributes for each of these polygons.The number of points are defined in an xml file (see attached). I will need to create an alert record in a table when the number of point reaches the defined count values.Any suggestions ?  testconfig.xml

Dear FME's specialists,I'm busy to validate the geometry of 3D City model LOD2 with the geometry validator transformer (Surface and Solid issues) For the same building, I have different results if the input data is a multipatch from ESRI or a CityGML data.I have much more error with my cityGml format, and no errors with my multipatch.Somebody has similar experience or an explanation or any advice?Thanks! 

I am trying to run a Python Caller in a workbench on FME Server 2018.1 which imports botharcpy (ArcGIS Pro 2.3 is installed on the server and I'm running in compatibility mode Esri ArcGIS Pro 2.1/2.2/2.3 (Python 3.6))pymssql (3rd party SQL Server package not installed in the base argispro-py3 Conda environment)As of the later releases of ArcGIS Pro, packages can only be installed in clones of the base argispro-py3 Conda environment. I have created a cloned environment and installed pymssql there. Is there any way to direct FME Server to use that specific environment when running the workbench? It picks up the base arcgispro-py3 environment which is missing the pymssql package. I'm hoping to not override server wide Python settings if possible as there are already many Python scripts being executed on FME Server I'm deploying to and I'm hoping to avoid breaking them.

I have a point asset details and Polygon features with address details in two Feature classes. I want to find the points falling under polygon features along with the asset id of point falling under address details of polygon feature. Basically to get the details of asset along with its location. Pls suggest.  

Hello everybody,please, is there any way, how to snap polygon and its features (floorplan) in shapefile from local coordinate system to polygon in EPSG coordinate system written in WKT? I have tried Affiner, it is way, but do You have another idea?Thanks a lot!Lubo

MapText Labeller is an awesome plugin for producing labels in FME. However, it seems a little out of date with expected FME functionality.  Specifically, I was wondering if there are any plans to update the plugin to include functionality such as :* Allow Ground Units to be linked to an attribute rather than a parameter. * Allow ground units to not have to be available at the start of a workbench so they can be derived from a calculation in the workbench and then used. * Allow things such as text size and font style to be linked to an attribute. * Provide a group by functionality so you can pass multiple map frames into one transformer. Currently you need to use a looper as a workaround. * General upgrade - the map text labeller version that this plug in is using is quite behind the actual version Maptext uses outside of FME now.  

I need a work around for this error. I am using XML reader to extract XLE files to CSV. Anyone have any suggestions? It's weird because some XLE files work, while others dont, all depending on how the file was originaly downloaded. PLEASE SEE COMMENT THREAD How to format CSV Output for more information on my issue.

Hello. I have to correct the road network geometry by shifting road polyline it to the point(that I created using FME to fix the road) beside it.Below, the dark line is the existing line and to the left is the existing point at a certain distance. Now, I need to shift the full line geometry as it is overlapping the point and maintaining the same distance overall. The dashed line is the required line to be the output.I tried Neighbourfinder to find the distance and stuck there. AnchoredSnapper(segment snapper) should work, but not purely working. Any ideas about how do I take it ahead.Thanks!

 name = feature.getAttribute('Chain')query = {'Name': name}params = {'query': json.dumps(query), 'fields': 'Name,Id', "OrderBy": "Name", 'limit': 5}r = requests.get('https://location.chainxy.com/api/Chains', params=params, headers=headers) for whatever in json.loads(r.content)['Records']:<space> chainid = whatever['Id']<space> chainname = whatever['Name']<space> feature.setAttribute('CXY Name', chainname)<space> feature.setAttribute('CXY Id', chainid)------------------------------------------------------------------------------------------Let's say that my list has three items and I expect my output to be as the following but apparently, my for loop is overwriting my record so I only end up with one record instead of three. How can I fix this problem?------------------------------------------------------------------------------------------Expec

I have a line feature with points nearby that I have created 1. line buffer polygon 2. Points polygon from hull replacer and then hull accumulator. I now want to merge these into 1 polygon and combine the attributes of the 2. I tried using spatialRelator and the attributes come across from the 2 features but it only preserve the base geometry which is the line buffer polygon. I tried using aggregator but no luck. The screenshot shows the 2 features with the narrow strip is the hull accumulator polygon. Thanks in advance for the help.

I have a list of multilinestring values (WKT) that I want to convert to geometry and I am able to convert successfully using the "GeometryReplacer" transformer. But the issue is, the output is rotated incorrectly, I'm assuming because the latitude value precedes the longitude; MULTILINESTRING ((-44.7015317625899 169.11857955951024, -44.7016055333 169.11847676667, -44.701775304303375 169.1184517619954))MULTILINESTRING ((-44.701775304303375 169.1184517619954, -44.7021002667 169.1184039, -44.7024581167 169.11867501667))MULTILINESTRING ((-44.9492277 168.83416295, -44.9493422667 168.8342806, -44.95023849319257 168.8351577308208))MULTILINESTRING ((-44.95023849319257 168.8351577308208, -44.9508926333 168.83579793333, -44.9527597167 168.83769603333))MULTILINESTRING ((-44.95023849319257 168.8351577308208, -44.94992568966844 168.83576309491352, -44.94992568966844 168.8358054239898)) Does the longitude value need to precede the latitude value? and if so, is there anything I can do

HI everybody,is it possible to georeference a raster image without the four border coordinates (I already checked the "Georeferencer") ? I have several tiff files and within the image I`ve got four GCPs with image and world coordinates. I would like use these GCPs to georeference the images. One approach I tried was to set the 4 GCPs in the image with the RasterGCPSetter because the documententation for Ground Control Points says "GCPs can either be applied to the raster resulting in the image being georeferenced and tagged with the GCP coordinate system" Unfortunately I can't perform this last step of georeferencing on basis of these GCPs.Is there a way to perform this task? Thanks in advanceAnnika

GCMMessenger Transformer and GCM Services Deprecation article now published. This article talks about the deprecation of the Google Cloud Messaging service that has been deprecated by Google as of May 29, 2019. Please see the article for more details.  There is currently no direct workaround, but the Amazon SNS can be used via the SNSSender Transformer.

Dear community, I just started with FME. I have an excel document with contains multiple columns. One column is called ‘Land Cover’. Depending on the values of 'Land Cover', I want to fill another column called 'classname' with new string values (‘Onkruid’ or ‘Gras’). The main idea is shown in the attached figure. I was trying to get this working with String Replacer or String Searcher. However, I did not manage. Could you help me out? Kind regards, Lambertus 

HI, I need to filter/select the points which are in the polygones.I have many points and a 35 polygons. The result should be 35 layers of polygones in which will be this points which are overlaping polygons. I tried to do it with PointOnAreaOverlayer, but it does not work how I want to. I tried it now only with 3 Polygones. The reprojecting system is ok, and they are overlaping. As a result I get separate polygone and points-which is the same result as at the beginning. How to merge this points and polygones together?The result:

I am running a summary worksheet which basically identifies all the features which are tagged with the input catchment ID and then puts them through an attribute pivoter with rows grouped by the ID and columns grouped by landuse type and the area of these features are analysed. The output of this pivoter is written using an XLSX writer with a dynamic definition as that seems to be the only way I can access the table that the pivoter outputs. The output works great:IDRuralUrbanWaterGW01209320098 So I run this workflow using a workspace runner where the user can select a number of catchments to produce a report for. The workspace is run for each catchment ID. All the runs write into the same excel worksheet, with a new row for each catchment ID being added for each run. This works, however each run seems to consider columns in isolation of what is already in the worksheet. e.g.IDRuralUrban WaterGW012093 200 98 GW023870105 In this example GW02 doesn't actually have any urban landuses

I'm trying to load raster datasets into a Esri Raster Catalog. However when I use the writer'Esri Legacy ArcSDE Raster Catalog' it does not create a raster catalog but instead a standalone table. Is there another way to create a raster catalog by FME?

In my classified raster image I have 3 different green colors and there are also other colors in the image. I would like to remove the green areas or make them transparent. Is there a way to do this automatically for multiple images?

Hi,I need to insert data into different tables and some of them are linked by a relationship (example : a table that contains buildings and a table with the parcels). I need all the parcels to be insert into the database before to start the insert of the building as I want to know for each building the unique ID (generated by a PostgreSQL serial type) of the related parcel.All my Readers are linked to a single FeatureWriter. Is there a way to specify that this feature writer must process the data one after the other (the order is defined by the list in featureTypes) ? Or any other possibility ? Thanks

Hi,I faced with issue: regex with cyrillic symbols don't return any 'found' result in ListSearcher, while it works for StringSearcher and in Regex Editor test.Regular expression: (?i:^??\\.?????\\s?\\d+\\/?\\d*\\s?[?-??-?]?$) Test list values: _list_{0} (encoded: UTF-8): ??????? ?????????? ?? _list_{1} (encoded: UTF-8): ??? 1? _list_{2} (encoded: UTF-8): ??? "????????" _list_{3} (encoded: UTF-8): 2 ????  Expected result: Regex should match on string _list_{1} (encoded: UTF-8): ??? 1? and index attribute should be set to 1. Parameters of ListSearcher on below picture:  I have checked other regex without cyrillic and it return result in ListSearcher. So I wonder is that any issue with handling regex with cyrillic inside ListSearcher or it is something else?Thanks in advance for answers! 

I have two datasets that are in two different projections and am trying to figure out if it is possible to undertake spatial intersection functions like spatialfilter. Do I need to re-project one or both datasets or is there a way to have FME to reproject on the fly?

I have a bunch of points in a feature class that are stacked all throughout my GIS network. Is it possible to select and un-stack those points with FME?

 I am new to FME and would like some feedback if possible on a workspace I have set up. I’m sure there is a better way to structure it but I am stuck for ideas.I am wanting to join one attribute (site_code) from three different polygon feature classes (Facility sites, Open Space sites, and Road sites) to another polygon feature class (landfill sites).Before I start assigning site codes I am wanting to temporarily convert my landfill site data from a polygon to a point to get the centroid inside the polygon. I have used the CentrePointReplacer Transformer to do this with the Mode set to ‘Inside Point’. Is this the best approach?I then want to run the temporary landfill points through a series of checks to assign them a site code:The first check needs to find what Facility sites the landfill sites fall on and assign them a facility site code. Anything that didn’t get a facility site code moves onto the next check.The second check needs to find what Open Space sites the landfill sites fal

I am running validation rules on a SDE network. I have various point features which must meet given location rules, i.e.:Coupling Fitting => Must meet 2 Main end pointsTee Fitting => Must meet 3 Main end pointsCross Fitting => Must meet 4 Main end pointsAt the moment I can achieve this check by doing the following: 1. Create start/end points for each Main Vector2. Use Spatial Relator a. with the various Fittings/Valves as requestors and b. with the Main start/end points as suppliers3. Use separate Testers to check where related candidates = 1, 2, 3 etc..4. Output failed results as errorsAs the various Fittings/Valves have to be checked against every start/end point this obviously takes a while to process. I've used Workspace Runner to cut these down but is there potentially a more efficient way to run this, i.e.: using Topology or Geometry transformers? I haven't used either before so wouldn't be sure where to start. Does anyone have any advice on a alternative

I have two spatially identical line datasets and need to find where they differ by the "type" field that is in both feature classes.  which transformer is best suited for this type of comparison?