Transformers

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?

Hi everyone! I need to convert some coordinates from geographic to geocentric, X any Y are in SWEREF99 which can be easily converted, but Z is in RH2000 which is used in Sweden and other Scandinavian countries. I am trying to use CsmapReprojector and for vertical handling I used Orthometric height -> Geocentric or ellipsoid height. But then some "geoid height grid" file is needed! I downloaded grid files for FME desktop but nothing for Sweden id available! what shall be done now??

I have lines in a cad drawing that have labels that represent the line length. This label is not always the closest label to the line but is normally parallel to the line. Is there a way to find labels that share the same angle as the line?

Does the SHortestPathFinder consider all FROM-TO routes when generating routes or does it calculate a route for each input? I'd ideally want the generated routes to produce the lowest overall length, where routes that join together are preferred to routes that find their own path. For example if I've got two residential areas and I want to generate a route from these to the city centre, using the shortest path finder may generate two separate routes for these areas, but I want them to converge on a road almost like rivers draining a catchment. SO I'd prefer routes to converge if possible

I have a set of PNG images downloaded from a service like: http://tile.openstreetmap.org/{z}/{x}/{y}.png The images are named: 09_118_180.PNG 09_119_180.PNG etc.How can I combine these image in FME and project them correctly?

In the attached screen grab useful for your reference

Hello everyone!  I was searching and trying out examples from other posts with similar issues, but could not really achieve satisfying result to my needs. I have roof construction lines in 3D which need to be assigned to building footprint polygons. Essentially my task is to provide a building part ID to respective roof lines. I am struggling with overlapping lines where building part polygons meet (blue lines in the first image).  Seemingly, most of the topology and line connecting tools work either in 2D mode or height is uniformly assigned according to some rule which does not work on the large and diverse dataset. As a result, I could not find straightforward ways to assign section lines to a respective building part.  All suggestions are welcome! I attatch a template workspace with one building so data is available for trying out.    Thanks in advance!

I am attempting to filter a table for any records containing characters which fall between Ascii code 128 and 255.In a Tester, the regex [^\\x00-\\x7F] correctly identifies matches (copied & pasted from an Inspector) in the ‘Test String’ box. However, when I run the full table through it, all records fail.This seems like a bug. Or am I just missing something about Regex in a Tester?

 Here, you can see that total hits for 'chevron' is 1910 and 'exxonmobil' is 96, but on the output, it only gives 20 rows. 10 rows for each Company name

I am using FME to extract API data and pull the JSON string into a SQL table. I am able to work with most of the tables but there are a couple of them that are nested and am having trouble getting to format properly.I have attached how the results need to look and sample of the JSON resultsI tried using JSON Fragmenter but i cannot get the results. Can someone advise the best way to get this.

Hi,When we draw the big river line in both edges, each side we have to draw in same height is too difficult.my question is, we draw one side in exact height ,another side we draw not in correct height.using FME how to correct the incorrect water line to correct height according to exact waterline ? 

 Column AColumn BB Sort AlphB Sort NumB Sort NatB Sort DesiredNYC51NYC1NYC1NYC11CHI1A11A11A1A51A5CHI511151111CHI5CHI11CHI1ANYC11NYCCHI I'm trying to figure out how to sort column B to match column A's order. For my needs column B will not necessarily match column A but it will be a subset of column A

I have a simple list n=74 codes which I read using the regular ROOT and SUB template expression: {fme:get-attribute("code")} but because of a nested comparison, they are nested as shown below. I get errors for the missing closing tags (</inv:And>) and If I pre-fill the closing tags, I get an error because they do not match the opening tags.This is perfect for a recursive loop, but a function would be needed within the xmlTemplater? or a script? or 2 loops one for the top half and another for the bottom half? Below is the end result (partial code) of the desired end result. I can manually add the last code <code>code n</code>. The rest is symmetrical. FME desktop 2018.Addition: terribly sorry I did not mention that code is a string.

I am working on FME 2019.0.1 I am trying to find out a center line(Approx. Center Line in FME 2019) of the polygon in the below geometry. The polygon is the input and polyline is the output.I tried using Generalizer with Douglas(Generalize)with varied Tolerance (after using converting it to LL-84) and McMaster (Smooth) and above is the best output. In the ideal scenario, the output should look something like below: Basically, the polylines touching the center end parts of the polygon.My approach: Create a bounding box. Put weights at the points touching the polygons. Join the polyline output at weights. Will that be a possibility? I have still not worked on it. Just an idea.Any other ideas I can work upon! Thanks.

like in sql, select company_name, filing date, count(*) c from index would give able of company_name, date of when it was entered or filed, and counts the number of files on a particular day