Data

I have line features . When two lines really intersect, I would like to create a new vertex at the intersection point .My requirement is:if two lines intersect, create a vertex on the lines at the intersection location if it does not exist the new vertex should get a Z value that is 1 meter lower than the other existing vertices of the lineFor example, if the line vertices have Z = 145, then the new intersection vertex should have Z = 144.Currently I am using Insector, and to filter out the nodes that share a node between consecutive lines, I cobination of coordinate extractor and FeatureJoiner. Afterwards, I extract all coordinates of the lines and join them again with the remaining points from Insector to identify the real intersecting points, as well as the intersecting points that do not exist as vertices on the line.Then I gave new z values to this vertex candidate but how can i insert them onto l

Hi,I have a strange issue when writing to excel. I have a feature writer to excel in dynamic mode. To prevent numbers being converted to a scientific notation I added a Excel Styler where I set the custom numer format to 0. This works perfect.The problem is that now my dates and datetimes are suddenly shown as number. When I change the cell format to date it shows the date, but I want it to directly show the date. When I remove the ExcelStyler, dates are shown as dates. Anyone any idea how to fix this?I use FME 2023.2.5.

I am trying to get the labels in this map to offset so that they “print” on their lines (two different labels, one is for pipes and the other one is for manholes).Manholes - is the label like 71100144 - the first row of this label should sit perfectly above the line there.The pipes are the values like KM_… - this one should offset entirely to sit on top of the pipe lines.I hope that makes sense.Is there an attribute I can set? I am using AtributeCreator + TextAdder + PDFStyler.Thanks a lot! 

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 

I have an AGOL feature layer with a DateOnly field that I am trying to filter out the last 365 days worth of data. Is there an easy way to complete this?The data is formatted in the following way:2021-01-01

Hello - a colleague has set up a table in an MS SQL Esri SDE and they are trying to use the FME Esri Geodatabase (ArcSDE Geodb) writer to truncate the table and insert new data.However, when the table was created (using ArcGIS Pro) they chose some long attribute names (e.g. 45 characters). This is now causing an issue as the FME ArcSDE writer enforces a 31 character limit for attribute names. This means that we cannot get the writer schema to match the schema of the database table.It seems that the FME Esri SDE writer is enforcing a character limit to attribute names that is stricter than the limits applied by the Esri SDE itself. Is there any way to override this limit on the FME writer?  I think we could use an MS SQL writer to truncate and insert the data but would prefer to use the Esri SDE specific writer if at all possible.Thanks in advance.

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 FME Community,I came across this presentation from the 2017 FME User Conference on integrating GIS data into PSS®SINCAL:https://fme.safe.com/presentations/pss-sincal-network-modelling-from-gis-data-using-fme/From what I understand, the workflow relies on a custom FME process combined with a third-party DLL to generate and populate the SINCAL database schema.I’m currently exploring a similar use case (GIS → electrical network modeling in SINCAL), and I’d like to ask:Has anyone implemented a more recent workflow for integrating FME with PSS®SINCAL? Are there any newer approaches using FME (e.g., PythonCaller, APIs, CIM, etc.) instead of direct database writing? Is there any official or community-supported FME reader/writer for SINCAL available today?From wh

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.

I have a COG with a scale factor (excerpt from GDALInfo)Band 1 Block=1024x1024 Type=Int32, ColorInterp=Gray  Min=-50313.000 Max=57304.000  Minimum=-50313.000, Maximum=57304.000, Mean=4745.177, StdDev=7550.452  NoData Value=-32767  Offset: 0,   Scale:0.1How do I apply this scale factor in FME?   If I clip the input and create a new tif,  the scale factor is dropped and the values are 10 times the expected.In this particular case I can just scale the value back down, but in general, is there a way to retrieve the scale factor and apply it? 

I'm quite new to CAD. I have an Oracle database with parcels. I would like to convert these to DGN (for users in Microstation) and DWG (for users in Autocad). The parcelnumbers should be a text field as the centroid of the parcels.  I have only a licence for Microstation to test the DWG's over there before I can sent them to the users using Autocad. I can create and convert the parcels and texts to DGN. These work fine.When converting the parcels to DWG I can see the number of features (elements) in Microstation, but not the geometry itself.What should I do get the geometry right?  

 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 

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,