Transformers

Hello FME community, I have two feature classes and I want to know which features have identical shapes. It's somewhat like a FeatureJoiner, but I want to join based on identical shapes. Thank you

Hi All, I’m trying to create a 10m node line from a 2.5m node line. I have tried ‘Densifier’, ‘Line Combiner’ and also ‘Chopper’ but can’t get it to work, How can I reduce the number of vertices and to obtain a 10m node line? Thanks

Hi everyone, I'm using the AreaBuilder transformer in FME to create polygons from line features. However, I've noticed that some lines disappear after processing. It seems like the AreaBuilder ignores or removes them in certain cases.The lines are neither in the Area nor in Incomplete nor in Rejected. The lines that have disappeared are marked in yellow. after Areabuilder before Areabuilder What could be the reason for this? Are there any settings or common issues that might cause lines to disappear? Thanks in advance for your help!

I was tasked with determing raster statistics (e.g. flood height and DEM elevations) for a large number of building footprints. I didn’t expect that the Clipper transformer would treat the following input Clipper polygons the same as outside Clipper polygons: With the “Determine Cell Location By: Centers” parameter, any clipper polygon that doesn’t intersect a raster cell center is treated as being outside, even though it intersects the raster. That is the polygons labelled below as “bounds only” and “no point or bounds” are treated as being outside the raster. With the “Determine Cell Location By: Bounds” parameter, any clipper polygon that doesn’t intersect a raster cell boundary is treated as being outside, even though it intersects the raster. In this situation the clipper polygon can have an area much greater than the raster cells. That is the polygons labelled below as “point only” and “no point or bounds” are treated as being outside. A raster (green grid with red centers) being

I am performing data validation of a excel source data. I have configured multiple validations in Attribute validator. Issue:FME validates the not null validation and all other validations given, but what I require is if any of the attribute is null, I don't want to do any other validations. How do I perform these in FME?

I have a a workflow of moving several tables from one database to another one. I needed to make a change and wanted to test the workflow writing to my localhost instead of production database. So i changed the postgis writer from “Truncate existing” to “Create if needed” targeting my local test environemnt. Still i get an error complaining that the tables does not exist?.. It does not matter if I hardcode the Table Qualifier or not. Or if i remove it all together. I have tried to not running the wb in cached mode etc..Tried running the WB in both 2023 version which it was created in and in 2024 version. “POSTGIS Writer: Table 'rplan.PblMidlByggAnleggOmråde' does not exist. Please check the Table Name specified, or modify the Table Handling value under Format Parameters” And yes the schema “rplan” does exisit in my localhost database. I have no explanation to why FME would struggle with this?

Is it possible to get the owner information using the ArcGISOnlineConnector? if not, is there something else I can use? I used the List Action and was able to get a list of the services/maps, but because there are the same item in two different AGOs in this group, I am unable to get the right one unless I know the owner. Thanks

Good day , I have these 4 lines. Each line is an aggregation of two different lines (blue and yellow). I want to split these 4 lines into 2 lines each where they intersect with a given point (red dot). I used the intersector and the point on line overlayer. But in both cases I get 3 lines as a result instead of 2. These two transformers split the lines at point intersection as well as desaggregating the blue and yellow line part. This is not what I want. I only want to 2 lines (split at point intersection) as a result of the transformation. How can I achieve it ? I can not split lines at point intersection before I combine the lines. It’s a complex workbench.

How do i read LAZ raster files from Azure Cloud?

Hello folks, I want to split data from below data as shown. I want the output format in CSV as this - where the target quantity is Quantity / No. of days in months. The problem I am getting here is I am not able to split the data of month into number of dats because as I need the date as 01-Jan-25 for all the days in the month How can iterate these values. Kindly help!

I appreciate that’s a wordy question. Hopefully, this pic will clarify. A and B - green polys, low detail at edge - are a dataset I am using to run into a SpatialFilter to determine areas of intersection with the more detailed dataset in pink (amber where there is overlap). You can see that part of the upper example polygon I have coloured part of area 1 in blue, and sits mostly inside A. The smaller, black part of 1 sits inside B. I want to join the entire area of the intersected polygon fully to the feature from the green dataset that contains the largest part of it - in this case, to A. Any ideas how best to proceed? I currently foresee: Check for intersection of area 1 with areas A & B Calculate area of overlay Test for largest Join all of the area of 1 to A Feels like there may be a fair few transformers involved. It’s a national dataset. Just trying to figure out how best to do it. In Esri, I think there might be a simple option to ‘join to largest’…? (Not that I want to jump out

Hello, I would like to do the following (see attachment): Select these three lines (black, green, red) from a db table (how the table is structured I have to select the three of them and not only two) Create a 2m buffer around each line Identify the two lines (black, green), as they are the lines with a smaller angle to each other, and create a point where their buffers intersect /diverge (red dot) Create a perpendicular line to the green and black line starting from that point Create a point (yellow dots) 4m away from the intersection of the perpendicular line with black/green line on the black/green line The first two steps are easy to do but I have troubles with steps 3-5. What transformers shall I use ?

I’m trying to split an ArcGIS sde table of rooms into multiple CSVs based on floors, and then upload the resulting CSVs into a Google Drive directory. I have the first part, but when I run the Google Drive connector it says the translation is successful, but nothing gets uploaded to the GD directory. I have admin access to GD and there is nothing wrong with my connection. Has anyone else had a similar problem?

Hello am new to FME I in the process of Automating the import of invoices and G/L transactions. Our CitySuite by Harris. Is the anyone who is or who has been involved with the integration of these. My biggest hurdle at the moment is the format of dollar amounts in XML. I have tried using the xquery formula but then the XML Templater fails. Any assistance would be appreciated.

I used PointToPoint overlay to find out which two points are a repeat in two datasets. How can I still grab two columns of information from dataset 1 into dataset 2 if they are overlap? the two datasets do not have FKs, is there a way to join them spatially and then have the tables join instead of union? ---Thanks---

I have finally started using FME Workbench (Form) 2024 a bit more consistently now that I built a new instance of FME Server (Flow Hosted) 2024.1.1.1. I like the updated look, but am missing a few things and noticing some inconsistencies in how the transformers render on the canvas: The newer look is more modern and although it’s just “ok” for me (looks like a card and less “fussy” than the previous transformer look), I like it. I miss the cog-wheel to access settings with a single click at the top-right of each transformer. Now you have to highlight the transformer and then you can click to access the settings. Doubling the mouse clicks isn’t a great enhancement. Would love to see this make a come-back, maybe as a minimalist “dot” or something... I can double click to get to the settings, but still not thrilled about it. It is forcing me to use the Parameter Editor window more now, docked to the right of the screen. Still getting used to it in an effort to reduce the clicking but with

Hi,How can get the green dot on the blue polygons.I have created the polygon centroid using center of polygon and with neighbor finder I get the green dot on red line. What I need the green dot on blue polygon and the small segment connecting the red line to blue polygons.I tried lion on area but I cat extract the segment marked in black.Any help is appreciated

Hi, It seems that the SpatialFilter does not always work as expected when the Filters First option is enabled. I have taken several steps to fix the incoming data (such as using the GeometryValidator and applying reprojections), but the SpatialFilter only works consistently when the Multiple Filters option is enabled. Below, I have included an image of my workbench, where—after multiple test attempts—only the top SpatialFilter suddenly works as expected. Is this a bug? I am comparing .dwg files with a feature class in a geodatabase (area) I work with the DataInteroperability extention by ESRI, in a workbench created outside of ArcGIS PRO, FME(R) 2024.0.1.0 (20240328 - Build 24202 - WIN64)

Hi, I would like to use a simple function in the SchemaMapper for Attribute value for a new attribute. In an AttributeCreator I would use @Value(Lat)#@Value(Lng). This concatenates two values seperated by a #. I can't get it to work in a SchemaMapper. I tried @EvaluateExpression(@Value(Lat)#@Value(Lng)), but the SchemaMapper interprets this as a string and not a function. How can I make this work? Btw, I use FME 2023.2.5. Thank you, Arno

Hi, Is it possible to choose a line “connector” between a polygon and text object using MapnikRasterizer? Similar to attached image where the black text and lines are desired layouts. It would be good if an auto placement could be used for no overlapping of text, lines and polygons.

Hello, I am generating an orthophoto from a point cloud using the ImageRasterizer transformer, with intensity as the input for pixel values. However, the only available option is grayscale, and I would like to apply a high-contrast color scale (e.g., green to red) instead of grayscale. Is there a way to change the intensity palette before rasterizing the point cloud, so the resulting raster already has the desired colors? Alternatively, can I modify the color palette during or after rasterizing to achieve a similar effect? Attached is an example of the desired output, where intensity is mapped to a high-contrast color scale. Thanks in advance for any suggestions! High contrast with colors Greyscale Orthophoto in greyscale

Hello, I am currently running into issues when reading a gml file.I have two files, build exactly the same way.It reads perfectly well the coordinate system from one file, but not from the other. File 1 File 2 It seams to me that the the connection is not beeing read perfectly.cables is a table “CableElectrique” whereas “my” is the geometry I am sorry, I cannot provide more than snippets :(

Hi, I have a point dataset of vehicle locations being turned into lines using the LineBuilder and self-intersections are being created. While I can write successfully to the MSSQL SDE using the SDE writer, I’d prefer to use the SQLSpatial writer (due to speed and licencing). SQLSpatial fails due to what looks like the self-intersections. GeometryValidator can’t seem to fix the issues, with the repair failing. The source points are the last hour of locations so they’re continuous being added and removed per vehicle. I thought this would a common situation for FME users to be in. Processing tracking data. Also, would it make more sense to add the line segments on to the end of the line rather than rebuild the line? I’m not sure how to go about that in FME. Thanks

I have a JSON-schema. A part of it looks like this: "dct_license_sm": { "type": "array", "items": { "type": "string" } } I feed data into a featurewriter pointed at the schema-file. The corresponding data from the input looks like this: dct_license_sm (string: UTF-8): https://creativecommons.org/licenses/by/4.0/ So - a string, but in the schema it is declared that this is to be an array with string-items. Then I would expect the output to be like: "dct_license_sm": [ "https://creativecommons.org/licenses/by/4.0/" ], Obviously declared as an array containing a single string. But my results in FME via the FeatureWriter comes out like this: "dct_license_sm" : "https://creativecommons.org/licenses/by/4.0/", In the FeatureWriter I can't change the datatype. What would be a good way around this?

Hi , I am ussing a sqlexecutor for update or insert data in tables. But how do i get the rows updates, inserted ?? so i use this in a Emailer ??