Best Answers

Hello FME Gurus, I have a list which contains a known sequence of values that represent different things but are linked.I have created a list and I am then searching in the list for a specific word, in this case 'PM'The ID for the PM is located two spots in the list before the word PM.I am trying to extract the ID from the list dynamically but can't seem to get the syntax correct in Attribute Manager. @Value(_surveytable{@Evaluate(@sub((_list_index),2))}.autocad_text_string) Can anyone help is getting the index value syntax correct so I get the value that is located in the index minus 2?ThanksDean 

I have a list of features like the followingABCDEFGH But want to get it in a table likeA B C DE F G HThe values of A and E are a known format so want to be able to find A and add B C and D to the table row and do the same for E, adding F G and H and so on.I have tried the following using LIstBuilder, List Exploder, Tester and Attribute Manager but can't figure out how to get the results into the attribute manager.  

What does this error refer to?  Warning: Unable to perform SE_layer_alter operation. (Continuing):SDE_ERROR_CODE(-20) Layer not found(Table: 'TAMISADMIN.T_TRANSMISSIONSTRUCTURE' may be in use.)  I have two pipelines off a Feature Merger, and I'm testing just one (I have the connection disabled for the other one.).  I'm reading from ESRI using the SDE30 reader and writing to an SDE30 table, T_TRANSMISSIONSTRUCTURE.  and i'm updating the data in table, so my writer mode = UPDATE.  I have a 2nd writer to the same database with the same T_TRANSMISSIONSTRUCURE feature class.  on this writer/feature class i'm inserting records.  Could the error be related to the existance of the same feature class being accessed in this translation?  Sarah 

Hi,I would like to use the FeatureReader to read the data from the PostgreSQL (PostGIS) and save it to the GML (3.2.1), Esri Shapefile and Mapinfo TAB.The source table contains multiple geometry columns.Do those formats and/or writers support multiple geometries.Best regards, Damian

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.  

Hi,I have a multi-columns table with the first column contsing the Record Id and decription of the polygon. Each record can have one or more polygons in the description where each group is separated by blank lines as shown.N1139-26 PositionCentroid : 49° 24.230'N 064° 33.127'WPt 1: 49° 41.000'N 065° 00.000'WPt 2: 49° 20.000'N 065° 00.000'WPt 3: 49° 11.001'N 064° 00.005'WPt 4: 49° 22.002'N 064° 00.005'W Centroid : 49° 05.088'N 063° 29.568'WPt 1: 49° 22.000'N 064° 00.000'WPt 2: 49° 11.000'N 064° 00.000'WPt 3: 48° 48.002'N 063° 00.005'WPt 4: 49° 00.002'N 063° 00.005'WI am able to extract the coordinates and plot the points. However I am unable to group the points to form proper polygons. Without grouping properly, they form zigzag lines.The table consists of hundreds of similar records. Can anyone suggest how to plot these correctly.Thanks.

Hi,Every time I try to remove a reader, my workbench crashes. Are there users with the same problem who has a solution?I use version 2019.0.ThxNathalie   

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!

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

I have a pipeline route and make an areaonarea overlay with a buffer to analyze how many buildings are in this buffer beneath both sides of the route to classify this segment (for example 1 mile long and 220 yards on both sides....thats clear so farbut i want a loop to shift the buffer (for example 200meters along the route) to get a new classification...so first overlay for example from 0 to 1000meters on the route...next from 200 to 1200meters and so on...how can i build this looping? (or do i need a looping?)simple for you i thinkCheeers Franco

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 have a workbench that uses a python shutdown script using the "ESRI ArcGIS Pro 2.1/2.2/2.3(Python 3.6)" python compatibility. It works fine on desktop but when published to FME server (2019) I get the following error: ArcObjects could not be initialized. ArcGIS required for the specified Python Compatibility 'Esri ArcGIS Pro 2.1/2.2/2.3 (Python 3.6+)'. I have read the following: https://knowledge.safe.com/questions/73555/the-arcgis-python-36-interpreter-could-not-be-foun.html but I am unsure that this applies to my case as I we are running FME Server 2019.0.The same versions of FME and ArcGIS Pro are installed on both my desktop and on the machine running FME Server.What else am I missing to get this to work on FME Server?

Hi, I am looking at returning modified JSON requests from a Government geocoding service - the call would be issued from a Geocortex application.Geocortex issues the call (with an address or XY parameter) - the workspace issues the request, receives the JSON response, does a match on an external ESRI geodatabase to draw in an extra key:value pair, appends this to the response and returns the modified JSON to Geocortex.This is all working well, apart from the last bit - which I haven't got my head around yet. I could, but would prefer not to, write a JSON file out for Geocortex to read, although this would add more time.Any help would be much appreciated.Further information: Currently takes around 7+ seconds to run (700k records in the geodatabase, but I am using a 5m radius spatial filter) - a C# routine (using an address CSV) takes less than a second, so any performance ideas would be welcome.This would eventually be hosted on FME Server.Many thanks,Mark

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 am running on Windows 10, FME Desktop 2018.1 writing from ArcSDE Environment to a File Geodatabase.If i write directly over I find the SDE Editor (NCGIS_GIS) is written into the name of the dataset (Roads), if I change the dataset (Roads-->Road) than the SDE parent prefix is not written out. I am unable to determine how to remove the Parent SDE naming from the dataset and I have 550 feature classes to migrate over that I do not want to manually (via user parameter) set.Thanks!

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?

Hello, I have few workspaces created in FME 2016. If I would run them as they are in FME 2019 would they use old version of transformers or new (potentially with some improvements)?

I want to read features from a WFS service version 1.0 , which has a limitation of maximum 10000 features per call .How to split my bounding box , when reaching the max number? It should loop the reading, unti I get all my features.

Hi all, The image you can see the attribute table of my datasets. I would like to change the attribute position based on a logic like thisIf the position of an object is UNDEFINED, I would like to find an object that has same _id value and then if the object with same _id's position is RIGHT, assign the position value as LEFT. For example, the object with _id_rule 14 has position as UNDEFINED, so i would like the find the other object that has _id 11 (it is common in both object). In my case, It would be the object with _id_rule 10. Then I would like the check the position value of the object with _id_rule 10. If it is RIGHT, I would like to change UNDEFINED value to LEFT for the object with _id_rule 14I have tried to use combination of tester & sampler but could not figure out so far. Any idea? Thanks in advance.

I've just started using FME. We have a few feature-services in ArcGIS Online with a lot of features (+/- 150.00). We are creating replica's every night on our server by using a Python script from esri. In essence the script works fine. But the replica's fail at least half the time because of time-outs, or sudden server error's on esri's side. I want to know if we can replace some of our workflows by using FME. I've created a script that reads the AGOL feature service and checks for changes/new features. This gets written to our Postgres database. The script works fine, but again, I get the same errors.I've changed the batch size to 10 features, but no luck. There's an option in the reader to start reading from a certain feature. I thought this might be a solution, but it still starts from 0 (maybe it's not reading / downloading it, but it still runs every 10 features. The corresponding log is: "ArcGIS Online Feature Service Reader: Getting featu

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 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