- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,686 Posts
50,750 Replies

When you subscribe we will email you when there is a new topic in this category

12686 Posts

umapper1Contributor

asked in Transformers

Create tunnel shape using 3D ellipses

Hi community!Looking for some advice on how to tackle a scenario...I'm trying to get an egg shaped (or ellipse) 3d buffer around some line work. My thoughts were to create some offsets for the sides, centre and top of the ellipse, generate a surface over these using them as break lines then do a similar process for the bottom half. I'm stuck on how to orientate the ellipses in 3D as well as simply creating them from the points and lines that I have. Any suggestions on how to tackle this would be great, be it the ellipses or a new approach to modelling this 'tunnel' shape entirely. Some top notch paint illustrations below. Sample .fmwt data attached.Top view3D view3D view again

120

4 years ago

gellerroma

asked in Transformers

MeasureExtractor don't have value

Hello.I have input line data in EPSG:3857. And I break the line data into vertices and get points. (by Chopper)Next, I use the MeasureExtractor tool in the hope of getting M - values.However, the tool does not work and issues MISSING_GEOMETRY_MEASURE.Tell me pls, how can I get m - values for vertex?

610

4 years ago

mackenziebudda

asked in Transformers

Updating polyline attributes from overlapping polygons

I have a polyline (.shp) feature that is essentially just a road network in my city and I wish to update one of its attributes from an overlapping area (.shp). The overlapping area is a buffered corridor of a bikepath that I want to use to update the polyline attribute wherever they overlap. I'm using the lineonareaoverlayer with the following parameters:I want to preserve all the other attributes of the polyline road network. I just want to update the status attribute from overlapping area status attribute. See below:Line feature attributes: Area feature attributes:I want the Status to switch from Not ridden to Ridden anywhere on the line that overlaps with the area. From what I can tell I should be using the listexposer to access the list generated from the lineonareaoverlap transformer but no matter what I try I can't get it to work.

200

4 years ago

lizzygradidge

asked in Transformers

Splitting delimited addresses into attributes (exposing individual list elements)

I followed the esxample here to split my comma separated addresses .https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/attributesplitter.htm# However this is not working I exposed the elements of the AttributeSplitterBut they are not available in the AttributeSplitter output nor the AttributeManagerI also tried ListExploder but that gave me a multipe row of the address elements And I want the address parts in a single row in columns What Am I missing here?thanks

190

4 years ago

alex_apeldoorn

asked in Transformers

Featurereader error using DB/2 via ODBC - wrong SQL syntax

Hi,I am trying to read features from a DB/2 database using an ODBC connection. This is the statement that throws an error; Database Generated Error Information:Database Error Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token [ is ongeldig. Geldige tokens: ( NEW FINAL TABLE UNNEST LATERAL XMLTABLE JSON_TABLE <IDENTIFIER>.Database SQL Statement Text: SELECT * FROM [BZSAART00] WHERE 1=0 The problem seems to be with the [ ] around the table name. When I use an SQL executor without the [] it works just fine However since the attributes might differ (I want to loop thru 27 tables to read it's content) using an sqlexecutor is not an option since the attributes to expose will differ per table. Anyone knows a way to get the featurereader to use the right syntax? Is this a bug? Regards,Alex

960

4 years ago

wishmaste

asked in Transformers

how to use texture atlas in obj to b3dm translation?

We use fme when converting obj files to b3dm format. There were so many buildings and Each building has texture. We created texture atlas(100 building in one texture) due to poor performance of cesiums bad. But fme import the texture atlas to b3dm file for each building. Is it possible to use the external atlas in b3dm.

150

4 years ago

wjloy

asked in Transformers

Need to change date from 20190100 to 20190101

I have some bad data from an outside source and some of the days are 00 and not 01 (YYYY:MM:DD). The SQL db I am trying to write is dropping these records. Stringreplacer? A little direction would be much appreciated.One of the errors from the log:Microsoft SQL Server Non-Spatial Writer: Failed to parse '19810400' as a datetime value. For FME datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/standard_fme_date_time_format.htm. For ISO datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/standard_fme_date_time_format.htm#ISO-8601-Duration-Format2020-06-26 10:36:20| 5.2| 0.0|WARN |Microsoft SQL Server Non-Spatial Writer: Failed to parse `Date' from attribute value `19810400' for column `prc_date_last_sale'Thanks!!

340

4 years ago

hear_it_here

asked in Transformers

The sorter transformer does not seem to be sorting correctly in 2019.1?

I've recently installed the 2019.1 betaEdition: FME Desktop ESRI Edition (floating) Version: FME(R) 2019.1.0.0 (20190618 - Build 19594 - WIN64) The sorter transformer does not seem to be sorting correctly.I am trying to sort a large list of alphanumeric location codes like CAON0696, CABC0002, USFL0788, etc.I am sorting alphabetically, ascending. I have tried grouping by other attributes like country and province codes but it is not putting them in the correct order.Sorting obviously worked fine in 2018. Is this a known issue?

640

4 years ago

pascalfilippi

asked in Transformers

Need explanation how to iterate on the reader

Hello guys,i would like to iterate on my reader, i have one reader who read the county feature of the state of New York and a other one who read 8 millon of small polygon who are a mix with slope + swamp and forest. Well i would like to iterate each county of new york than clip each county by this small polygon and result will be a county with holes and finaly i write all the county with holes in geodatabase. (evry data come from an esri geodatabase) I read that i can create a master workbench and child workbench and use workbenchrunner. well i ve seen in this forum a guy who write that "If nothing else works, you could iterate over the input features using a master workspace that runs the clipping workspace using e.g. the WorkspaceRunner. You can there parametrize which block to process using a published parameter. But my tip is to start with the top two recommendations first. " the thing i can not really visualize what he mean, so if somebody can send me schema or picture

1600

4 years ago

thewindgone

asked in Transformers

Converting polygon into lines

I have searched some methods to convert polygon into lines on FME. But none of these could do it.Firstly, I extract a closed polyline of a polygon with GeometryPartExtractor, and then try to decompose it with Chopper. But instead of four lines, the result is many of broken segments. Secondly, I turn a polygon to a closed polyline with GeometryCoercer, and then try to decompose it to four lines. But the result is also many of broken segments with Chopper, or only one closed polyline with Intersector. Why is that? Can anyone help me? Thank you so much.

11720

4 years ago

rohan

asked in Transformers

Excel FeatureReader reading empty row

I have a simple workbench consisting of a FeatureReader, a VertexCreator and a FeatureWriter writing to a postGIS table. I am reading an Excel spreadsheet.The problem is that the FeatureReader is reading an extra row beyond the data and passing null coordinates into the VertexCreator. I have 103 records, but for some reason it is reading 104. The columns in the last row are all marked as missing. I have checked to see if there is any spurious data, like white space in the last row that might be getting registered as data, but I can't find anything.

1637

4 years ago

hektopascal

asked in Transformers

How to cite FME in academic paper?

Any recommendations on how to reference FME in academic papers? For comparison, QGIS has this guideline: https://www.qgis.org/en/site/getinvolved/faq/index.html

300

4 years ago

jamal

asked in Transformers

How to convert polygons to lines and vice versa?

How to convert polygons to lines and vice versa? I couldn’t figure out how the conversions are implemented in the FME. For example, how polygons are converted to polylines and vice versa? Thank you Best Jamal

22150

4 years ago

nicholasContributor

asked in Transformers

Transformer that splits line by measure?

I am using NetworkCostCalculator to calculate driven distance along a network, storing the cost as a Z-value (though I could switch to Measure)Is there a way of splitting the line at a specific value (3500 metres) of the Measure?And then keeping those streets below the same value (3500 metres)?I am currently using a Contour Generator, but that gives bad results when a road loops around and comes back with the tail end getting caught inside the contour even though the driven distance is too long

550

4 years ago

goatboy

asked in Transformers

Distance down road

Hi, I am trying to create a service area of 2km down a road network from a known starting point. Ie select any road/or part of road within 2km of my starting point (via the road (not an isochrone)). The equivalent of ArcGIS service area. I have read and downloaded the FME "Calculate Emergency Travel Times" example but am a bit lost. Im guessing i need to use the Network Cost Calculator... Any suggestions or ways forward would be appreciated. Thanks Goatboy.

600

4 years ago

fhilding

asked in Transformers

Expose attributes that match a pattern

Hello,I have a set of features, which have specific(but varying) attributes that I want to expose. All these attributes are uppercase, but all features do not have these attributes, and the names of the attributes vary quite a lot. The only thing they all have in common is being upperspace. I can filter them out with the PythonCaller, but I am unsure about how to input them to the AttributeExposer. The only input I can give the AttributeExposer is to open a file and read from there. Seems like a big workaround to read all the attributes, filter them, then write to a file and then open it.

4 years ago

bastianr95

asked in Transformers

How to trim lines with multiple ends to get only the "best"/longest line?

Hi! I got several lines made of polygons with the CenterLineReplacer (medial axis), but i only want to keep the longest line with only two ends of each line. Is there a way for that? In the picture below you can first see the line with several ends, in the second picture you see the line as it should look. Thank you in advance!

280

4 years ago

ahmad_saleh

asked in Transformers

How to remove “Self intersections” Polygons using FME

How to remove “Self intersections” using FME I wonder if there is a method to repair the self-intersections in the FME such as the ArcGIS tools “(Check geometry and repair geometry). I have used GeometryValidator but it fails to repair the polygons, What might be the issue here ? Regards, Ahmad Saleh

6330

4 years ago

thewindgone

asked in Transformers

Adding a line to another lines, and breaking at the intersection?

Hi,there are two sets of line feature. The lines of the first set are interrupted, figure 1. The second set is a whole boundary line extracted from a polygon, figure 2. The coordinates of point 1 and point 3 are equal, so do point 2 and point 4. Now I want to add the bottom line from the second set to the first set, leaving this yellow line, and breaking at the intersection. What should I do? Thank you so much.

4 years ago

ronan

asked in Transformers

Merge gaps between polygons using attribute value

We face a problem correcting the geometry between multiple polygons in a layer.There are some gaps between polygons and we need to automatically fill them. We identified 2 ways to fill the gaps between 2 polygons, explained in the following chart. We tried the first solution using dossolver and Donut Hole extractor, but there are some line left after the process (maybe due to the different positions of the shape vertex on the grid). So we don’t know if our process is the best to succed ? if yes , how to fix this problem ?

740

4 years ago

nmartinParticipant

asked in Transformers

How to escape single quote (') in SQLExecutor

Is there an escape character for the SQL text box in the SQLExecutor?If I try the following SQL against and Oracle database - select OFFICER from officer where lower(email) = '@Value(userName)'where userName value is in the format of it will fail because FME turns @Value(userName) into a string (evidenced by highlights in this picture).If I format my userName field to 'myemail@address.com' and remove the single quotes in the query as per this picture, the query will succeed Obviously I can run this through extra transformers to format my values beforehand but this is adding unnecessary processing and workbench bulk.Here https://knowledge.safe.com/questions/36933/how-to-prevent-single-quotes-turning-my-parameter.html @daleatsafe has stated that FME doesn't touch single quotes, but it appears from my first picture that it does? Or I have misunderstood something in that post.Also select OFFICER from officer where lower(email) = '''@Value(userName)' run

1532

4 years ago

v.martin_96

asked in Transformers

3D distance between points and polygon

Hello,I would like to create the Dist CLoud/Mesh tool of CloudCompare.I have 2 input files. One is individual points (PointCloudCoercer : Individual Points) from the class Building of a Lidar point Cloud and second is polygons representing roofs in SHAPEFILE. I wanted to measure the (vertical) distance from each point to the nearest polygon.I firstly used the SurfaceDraper to drape the points into the roof, then measure the distance between the draped point and the original points, but it didn't work as you can see below. Do you have a solution to my issue ?Thank you in advance,VictorPoint cloud : You can find the Shapefile polygon via this link: https://wetransfer.com/downloads/291f3edefb457b27a0f286ca68e3420120200624124047/919a8805a20a2c4b08eee3a830f2776e20200624124104/84c603

1160

4 years ago

virtualcitymattEvangelist

asked in Transformers

Multiple format output - dealing with textures

Hey fellow FME'ers, I'm working on a process to export multiple formats some of which support textures. Now I know that FME has the capability to deal with shared items buuut does anyone know a way not output multiple copies of the same textures or overwrite existing ones? is there a way for the writers to use the shared items? Thanks in advance for any input

210

4 years ago

ebygommContributor

asked in Transformers

Sorting date fields from Oracle numerically - error unless bulk mode broken

Possibly something that may already be addressed - this is in FME 2019.2.3.1If reading a date time field from Oracle, if you try to sort this field numerically you get an error message, presumably because the date times are seen as stringsFailed to sort Feature Table. Ensure fields you wish to sort by are of a sortable typeBreaking bulk mode, e.g. with a python caller, addresses the issue and the sorter works.

200

4 years ago

virtualcitymattEvangelist

asked in Transformers

Bulk Mode - What are the Performance killers?

I've been working on a new workflow and in 2020 I've been excited to see the increased support for Bulk Mode - It's awesome. However, I feel like in the workflow that I've been creating Bulk Mode has been causing some performance issues. In a few places in the log I see things like this 2020-06-23 09:47:51| 5.8| 1.4|INFORM|Aggregator_4 (AggregateFactory): Group 1 / 1: Preparing to divide 11 features into groups2020-06-23 09:47:52| 6.1| 0.3|INFORM|Aggregator_4 (AggregateFactory): Group 1 / 1: Dividing 11 features into groups2020-06-23 09:47:52| 6.3| 0.2|INFORM|Aggregator_4 (AggregateFactory): Group 1 / 1: Splitting bulk mode features into features2020-06-23 09:47:53| 8.0| 1.8|INFORM|Aggregator_6 (AggregateFactory): Group 1 / 1: Preparing to divide 4 features into groups2020-06-23 09:47:54| 8.5| 0.5|INFORM|Aggregator_6 (AggregateFactory): Group 1 / 1: Dividing 4 features into groups2020-06-23 09:47:54| 8.7| 0.2|INFORM|Aggregator_6 (AggregateFactory): Group 1 / 1: Spli

1070

4 years ago

Page 196 / 508

Badge winners

davidmooneyhas earned the badge 12 Days Participant (2024)
nordpilhas earned the badge 12 Days Participant (2024)
davidleehas earned the badge Welcome Back
karin_hooghas earned the badge Welcome Back
danilo_fmehas earned the badge 12 Days Participant (2024)

Show all badges

30,190: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.