Data

 Hi,I am using the Matcher transformer to find pairs of features with the same attribute value.Now I want to create a new attribute rel_obj that stores the ObjectID of the other feature in the matched pair as in the image. What is the best way to implement this in FME?Thanks 

I have a network of connected points and lines, and I’m looking for a way to create a selection set of points along the network, the key being I want to only select every other point. I tried modular selection counts (odd vs even numbering), network topology build for start and end node, but I can’t seem to get the results I’m looking for. Below is a screen capture - I want to eliminate the grey colored points in between. At intersections these points would be retained if necessary according to the ordering.  Select all points in Orange, skip points in Grey 

Transaction #26 was successfully committedMULTI_WRITER: multi_writer_id `1': Writing feature 27000 FME Objects Worker [1944] > Failed to read features using the 'STADIA' readerTransaction #27 was successfully committedMULTI_WRITER: multi_writer_id `1': Writing feature 28000 Transaction #28 was successfully committed

Hallo everyone,I copied and upgraded an ArcGIS Dimension Feature Class (File GDB) using ArcPy.However, when trying to read it in FME 2024 (FeatureReader / File Geodatabase Reader), I get this error:Unable to convert row to 'DimensionFeature'FME can see the schema, but fails when reading the features.Does FME support reading Dimension Feature Classes, or is there a known workaround?Thanks.

Hello everybody,I am trying to build a flow app: The user has an Excel file with 3 columns.  the flow app must show the values of theses columns as one parameter (I want to have the chance to filter the list using one of the 3 columns). My Problem is to get the contents of the excel file. If I try it with the User Paramters Window, I can import from dataset or reader formats. But with these options I do not get the contents but the headers or the name of the readers.I can save the contents of the File in a SQL Database. But I do not know how I can read them and show them in the user parameter List. Has anyone any Idea, how I can get a List with a filter to show those values of the excel?Thanks in advance!Manuel

Hi, I want to import the WFS service from Digitaal Vlaanderen, specifically the address registry, but my FME only imports a maximum of 10,000 features.I had found that it was possible via paging, but apparently that is no longer supported, or at least I can’t find it. It should then be done via loops, but I’m stuck. I found that it should be possible using an HTTP caller and JSON fragmenter, but I’m already stuck with my HTTP caller. Could someone help me set this up correctly? The URL is https://geo.api.vlaanderen.be/Adressenregister/wfs?REQUEST=GetCapabilities&SERVICE=WFS      

I have attempted to use the NeighborFinder transformer to achieve a one-to-many join; however, it is not producing the expected results.In my case, the base dataset contains values such as 30,511 and 55,867, and my expectation is to match all records where the base value is greater than 30,511.Since NeighborFinder does not seem suitable for this requirement, could you please suggest an alternative transformer or approach to achieve this condition-based matching?Thank you. 

Hi FME gurus. I am trying to extract values from a list to populate columns with the associated values in the fields.  In my list (called _columns) I have a caption field which has the name of the column I want to create and the date value I want to populate into the field so the example I have in the screenshot I want to look like this: Application ID Last Inspection Next Inspn Due 648343 2025-06-23 2026-06-16 15456.. 2025…. 2026….  The list exploding only brings out the name of the original column ‘caption’ but I am looking to use the values in the list itself to build the attributes and populate the values. There are rec

When using ArcGIS Feature Service (reader, writer, featurereader, featurewriter) I am only able to reference items using Folder and then featureservice name + itemid (in paranthesis after the name). Is it possible to directly refer to a service using only itemid?(for my case the data is hosted on my institution’s AGOL)

I’m creating a workspace that reads 7-8 tables from a file geodatabase and then writes them into tables in a SQL database.  One of the tables is sometimes present and sometimes missing (that is expected).  I need to create a workflow where when the table is present we write the data into the SQL table and when it is not present we just truncate that same table in the SQL database.  I currently have a gdb reader connected to a tester that passes when fme_feature_type Like MSAG_To_RCL_Synchronization. This works when the table is there but when it’s missing the reader just closes and gives the message “The table name 'MSAG_To_RCL_Synchronization' could not be found in the Geodatabase as either a feature class or a table” and closes before any input gets to the tester. Any ideas on how to conditionally test if a table exist or not and then either write the data or truncate a SQL table.

I have the exact same issue as is described here: That topic is closed, so I'm starting a new one over here. I got the error “Check the geometry of such feature is valid and is not too small for the resolution”, while updating a feature. I use FME Form and Flow 2025.1.2 and ArcGIS Pro 3.3.1 with ArcGIS Enterprise 11.3.At first I also thought the issue only occurred in FME Flow, not in FME Form. But now I'm checking the issue again and it is also in Form.In my case I use the ChangeDetector to check if the feature exists and if so if it is changed. If it existed and is changed, I'm also using the Update Mode in a FeatureWriter. I tested with not updating the spatial column, but that didn't make any difference. I still got the error. And I am positive the geometry didn't even change: setting the ChangeDetector to only check geometry sends the f

Hello everyone,I am having difficulty correctly assigning a spatial reference to GOES satellite imagery (Band 13) stored in NetCDF (.nc) format when working with FME Flow 4.0 / FME Workbench.Environment•Product: FME Flow 4.0•Workbench: Yes•Data type: GOES satellite imagery (ABI sensor)•Band: Band 13 (Infrared – Brightness Temperature) Full Disk•Format: NetCDF (.nc)•Satellite: GOES (GOES‑16/18/19 – ABI)Problem descriptionThe NetCDF file opens correctly in FME, and the raster data for Band 13 is read without errors. However, no coordinate system is automatically assigned, and I am unable to manually define the correct projection in a way that allows proper georeferencing.I understand that GOES ABI imagery does not use a traditional map projection (such as EPSG:4326, Mercator, or UTM). Instead, the data is provided in the so‑called ABI Fixed Grid / Geostationary projection, where pixel positions are defined by scan angle

I know I’m using an older version but upgrading is not an option. I was using a background map that is no longer supported so trying other ones. I have a Bing API key but get this error when attempting to display the background:“(1):Python Exception <IndexError>: list index out of rangeAn error has occurred. Check the logfile above for details(2):Python Exception <IndexError>: list index out of rangeAn error has occurred. Check the logfile above for details”And I can’t find anything in the log file about it. This error message is listed as a known error for later versions of FME Desktop and Flow, but not for 2022.Can anyone offer any advice or assistance in getting a simple background map to work? 

Hi, I was wondering if anyone has succeeded in reading an ESRI SDE geometric network configuration - rules etc. ?I would like to export to a readable format for reporting.  From research , all Arc Catalog 10.6. tools are no longer available for these kind of things. No arcpy either.So possibly an SQL approach, but I don’t know even in which tables such things might be found. 

there is a feature service layer (i’m the owner) with a filter statement on it.when I view the layer’s properties on AGO, I can see the filter. When I add it to an arcpro project, I can see the filter in the definition query. Looking at the REST end point (the one that has the <organization>.maps.gis.com address), i see all records. When I add the layer into FME either by AGOL reader or feature Service reader, I only see the filtered records and I don’t know how to get all the records. AI is telling me to put 1=1 in the where statement to bypass, but it didnt. 

Hi, I have a query that reads data from a view. When I run the workspace that executes the query locally, it executes.If I then set the workspace to FMEflow, the query no longer works. Local and FMEflow use the same Oracle client version.The error message is meaningless: SQLCreator_11_<Rejected>: Termination Message: 'SQLCreator_11 output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''The query does an select with a group by on a view. The same query runs in SQLdeveloper without errors.The only strange thing i see is when i skip the 'group by' that there are fields with the value "<Missing>" Normally i see Null.

Hello, I’m trying to convert decimal coordinates into a DMS format with hemisphere indication. Example : 1.4861803 ; 43.5713123 Target format : 1°29’10.2491” E ; 43°34’16.7243” NIn my workflow, i used DMSCalculator transformer to split the coordinates into degrees, minutes and seconds. This part works correctly.However, I am now stuck when trying to reconstruct the final formatted string. Does anyone know the best approach to rebuild this format ?Thanks advanced,

I’m writing data from FME into an existing Excel sheet (XLSX writer) that is later edited by others in Google Sheets. Some columns are manually updated after the file is generated.When the workspace runs again, FME starts writing at Start Row = 2, which overwrites the existing rows and removes those manual edits.Is there a recommended way to append new rows to the bottom of an existing worksheet in FME while preserving existing rows and user edits? I saw a somewhat similar question in a different post, but didn’t know if there was an easier way?

I am working on a project creating building footprints from a lidar point cloud. However, the original lidar point cloud being used has some portions of buildings classified with “unassigned” values which has created incomplete building footprints. Are there any suggestions how I could identify these “unassigned” building values to fix the building footprint?

Hello,I am trying to convert decimal coordinates into a DMS format with hemisphere indication.Example:Decimal format:1.4861803 ; 43.5713123Target format:1°29'10.2491" E ; 43°34'16.7243" NIn my workflow, I used the DMSCalculator transformer to split the coordinates into degrees, minutes and seconds. This part works correctly.However, I am now stuck when trying to reconstruct the final formatted string. I am not sure what is the best way to: concatenate degrees, minutes and seconds into a single formatted value add the correct hemisphere suffix (E/W for longitude and N/S for latitude) My goal is to automatically produce a final attribute formatted like:1°29'10.2491" Eand43°34'16.7243" NDoes anyone know the best approach in FME to rebuild this format after using

I am loading a small raster/tiff into CesiumJS via ion for a limited area of interest, which works, but I am getting a sharp “cliff” between this raster and the surrounding Cesium-terrain (I assume it is the Ellipsoid, it sits at roughly 35m above MSL). My initial idea was to see if I can “lift” the surrounding terrain up to the level of my custom raster-tif, but I guess that’s not possible, so my second idea is to expand my raster to continue outward at a set height (say 80m) for a few hundred meters instead to better mask the impression of the vertical cliff, and maybe have it ramp downhill until it meets the default terrain. However, I have no idea how to do this in FME, and ChatGPT is hallucinating around FME as per usual :)Does anyone have an idea of a solution for this? Ultimately, I just want something nicer than the sharp cliff a la Grand Canyon into something that is not too distracting for users. I’ll include a screenshot of my Cesium-app the way it looks in the brow

Hi everyone,I’m currently building a tool in FME to compare a point cloud with a .000 layer that contains point soundings.Because the two datasets have different geometry types, I rounded the coordinates in both datasets to the same decimal precision (0 decimal places), using the CoordinateRounder. After that, I extracted the X and Y coordinates as attributes so that I could compare them directly using the CoordinateExtractor.When using the Matcher, I intentionally excluded the geometries and matched the features purely based on the coordinate attributes. The matcher does find some matches between the two datasets, but it does not capture all of them.I also tried using both FeatureJoiner and FeatureMerger, but these transformers merge all attributes, which I would prefer to avoid for this workflow.Initially, I suspected the issue might be related t

I have JSON response from an API that looks a bit like this (tidied up for the purpose of showing here):{ "member": [ { "id": "OBF-123", "fieldspec": [ { "assetattrid": "FIELD01", "assetattribute": [ { "datatype": "NUMERIC", "description": "Length" } ], "numvalue": 13.4 }, { "assetattrid": "FIELD02", "assetattribute": [ { "datatype": "ALN", "description": "Fruit type" } ], "alnvalue": "Banana" }, { "assetattrid": "FIELD03", "assetattribute": [ { "datatype": "ALN", "description": "Class" } ], "alnvalue": "N" } ] }, { "id": "OBF-124", "fieldspec": [ { "asset

Hello all!I have a question regarding accessing data in an Enterprise Geodatabase in a branch-versioned Feature Service scenario:Using FME’s Esri Geodatabase (ArcSDE Geodb) Reader, can I read branch-versioned feature classes directly from my Enterprise Geodatabase (SDE connection) now that I have published a branch-versioned Feature Service? If I point it to the “sde.DEFAULT” version, will it access the features correctly?I would like to perform some heavy geoprocessing tasks, and my Feature Service performance isn’t keeping up, so the Esri ArcGIS Connector is a no-go

Hi.I'm looking for a way to compute the average while excluding outliers. This average is based on 5 attribute values for each record. To expand, i am QCing pole counts within permits. Each permit is a record. There are a bit over 10k records. I have 5 attributes, with pole counts, each coming from a different source.Example:permit a, pole counts = 1, 4, 5, 28, 6permit b, pole counts = 2, 10, 14, 80, 12Manually, for permit a, i'd exclude 1 and 28 and my avg would be 5. For permit b, i'd exclude 2 and 80 and my avg would be 12. The final goal for this exercise is to pick the value closest to the average computed without outliers. Pls help. Thank you.