- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,684 Posts
50,749 Replies

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

12684 Posts

dansaintg16

asked in Transformers

Is it possible to modify a DTED 2 (.dt2) file through FME Desktop?

I have some DTED2 files that I am using to retrieve elevation values from WGS84 coordinates. I would like to modify certain elevation values in the DTED2 file for certain WGS84 coordinates, becuause I have surveyed them with highly accurate GPS equipment and have found certain values to be incorrect. Is this something that FME Desktop is capable of doing.

490

7 years ago

dominik

asked in Transformers

Add Attributes to AutoCAD Block after creating block by aggregate some graphics with FME Aggregator

Hi FME Team I have a MicroStation dgn-File with sewer-manhole drawn by two circles and I would like to first combine these two circles to an block. This works perfectly with the aggregator function in FME. Afterwards I would like to add some attributes to this block (eg. the dimension of the sewer-manhole). I tried the "attribute creator". This works fine within FME - but when I export the block to AutoCAD I have lost the attributes. It would bi great if someone has an idea how to fix the problem. ... and if someone knows a way to change the name of the block (created with the aggregator function) you made my day :-) Kind regards Dominik

1290

7 years ago

dwired

asked in Transformers

How do I create an attribute of all coordinate pairs for the vertices of a polygon?

I have a polygon feature of almost 700k records with a lot of vertices for each polygon (a lot of coastlines etc) and I need to create a csv with a record for each polygon including a list of coordinate pairs for the vertices of the polygon in the format y1 x1, y2 x2, y3 x3... I was doing this by extracting the coordinates into a list and then creating an attribute of coordinate pairs and aggregating all of those pairs into another attribute by UUID. However, I was only able to do this by generalizing the polygons in order to get this workspace to actually run. If I remove the generalization (preferred), then when the polygons are exploded into lists of vertices the workspace runs out of memory before it can aggregate all back together to get the attribute of coordinate pairs. I think I need to do this without creating a list. I've tried using a geometry extractor instead of the coordinate extractor and creating an XML attribute, but I still cannot figure out how to get the format

450

7 years ago

bakkermans

asked in Transformers

Download FME build 16177

Hi,I need to download the build 16177 64bit windows version of FME. I can however not find it on the "Past FME Downloads" page (https://www.safe.com/support/support-resources/fme-downloads/archived/). Where would I be able to find the install file for this?PS: The reason I need this specific version is because the client is using this build for his FME Server and I need to modify their models.

100

7 years ago

jonathanchiang0

asked in Transformers

Can I pass multiple features to a Python Caller and use ArcPy in the script?

Hi all,I've got a question about integrating ArcPy in FME. It would appear that FME won't let me to read in multiple features and process them using ArcPy functions through PythonCaller. This can be easily done outside FME with one line of code such as:arcpy.LocateFeaturesAlongRoutes_lr(feats, rts, rid, tol, tbl, props)What I would hope to achieve with PythonCaller is that it can be used just like one of the transformers like clipper and buffer. Not sure anybody else has experienced the same issue?Thanks!

460

7 years ago

nathContributor

asked in Transformers

Does anyone know how you merge lines with the same ID together but hold the attributes from the line with the longest length?

1200

7 years ago

sigtillContributor

asked in Transformers

Raster: Handle large areas with no data

I have a huge ECW-file with not much data. Seen below is a simplification. The black area is "nodata area" and the red area is the actual data (ortophotos following a road).I want to convert this to a BigTIFF (tiled). The issue is that the resulting file is too large to be stored in memory (according to stats, 60 GB of RAM ++ is needed) so it slows down alot. By dividing this area with the RasterTiler I can get approx 20 tiles that does not need that much RAM while processing. However I wonder if it is possible to somehow "not read" the no-data,black,transparent data (as mentioned in the 4th band) - but only only read the relevant pixels.On VECTOR datasets when you use the Tiler - it will only send the tiles containing vector-data, and remove the "empty tiles" - this does not seem to work with rasters. A solution would be to calculate band 4 on data within that raster-tile - and if all values are transparent then skip that tile. Or preferrably it might be

600

7 years ago

fmelizardContributor

asked in Transformers

How to convert polylines to polygons with an attribute to group by?

I am trying to convert a polyline feature to a polygon by grouping using an attribute. I have around 5,000 distinct values and would expect to produce 5,000 polygons. But for some reason I'm getting 30,000 polygons. I've been using the AreaBuilder. I'm also seeing: 'Duplicate segment detected at location..' Any suggestions? Thanks

370

7 years ago

pinkopoContributor

asked in Transformers

Schema validation between two datasets

Hi guys,I am trying to find a way to get a list of matched and unmatched fields between two datasets. The situation is our agency needs to reguarly download data from external sources and after download we need to check if there is any schema changes on the newly downloaded data.Thank you!

1330

7 years ago

francism

asked in Transformers

Many to One Address Points to Polygon Parcels

I am attempting to make a spatial relation between a point and a polygon file. The point file holds unit level address information. This is a point feature class that will have a point location for a street address. For example, 234 First Street will have one point representing it. However, in this point file, if there are many Units at a single street address, there will be many points lying on top of each other. Say there are two units at 234 First Street, there will be two points directly on top of each other, say, A-234 First Street and B-234 First Street. The polygon file holds all of the parcel information. This parcel information has the zoning and parcel information attached. Say, Parcel A is zoned R1, Parcel B is zoned R1 and RR2, etc... We want to surface this information in our Web GIS at a unit level. Displaying all pertinent info for each unit address individually. We would like to join each single address point to a single parcel. Essentially creating a many to one relati

1000

7 years ago

martinkochSupporter

asked in Transformers

What does mode CLASSIC mean, and are there any other modes?

I regularely see the following line in my log-windowprocessing [#####] elements with mode CLASSICSometimes I stop and wonder about this, so now I thought it time to ask 'the world':What does this mode CLASSIC mean, and are there any other modes?Kind regards,Martin

180

7 years ago

amitaman001

asked in Transformers

Using multiple SQL queries in Inline Querier

I have two datasets:1) DBF1 - It contains demand and patterns corresponding to a particular ID2) DBF2 - It contains the factor corresponding to each PATTERNI need to create a new column for each type and add the factor corresponding to PATTERN_ID, otherwise the default factor is 0.The output result result would look as follows:I tried using Feature Merger, but I felt that it would require multiple Feature Mergers to achieve the same.I even tried Inline Querier but it does not permit more than one SQL statements.Is there an alternative of doing the same

283

7 years ago

jimbob

asked in Transformers

reading uk land registry data

Hey Everyone, i am trying to read some INSPIRE uk Land Registry data (.GML) i have read this very helpfull doc http://cdn.safe.com/training/course-materials/fmeuc/Complex-GML-manual.pdf in this file, it says i need to load a local Custom .XSD i have downloaded the FMEDATA2014 folder but i cant seem to find the Schema they use as the example. can anyone point me in the right direction to use the .XSD that they use in this example,. cheers, thanks alot for your help For your reference https://www.gov.uk/government/collections/download-inspire-index-polygons

300

7 years ago

amitaman001

asked in Transformers

Working across Different tables

I have data stored across multiple DBF files.DBF1 contains data stored as follows (sample):ID ---------DEMAND-------PATTERN1123-----------5---------------0.34553456-----------3---------------0.32122322-----------2---------------0.2112DBF2 contains data stored as follows (sample):ID----------------ZONE1123------------ZONE13456------------ZONE22322------------ZONE1TOTAL_DEMAND for a particular zone is calculated as the sum of products of the demand and pattern for all the ID that lie within that ZONE.Ex. for ZONE1(which contains 1123 and 2322), TOTAL_DEMAND= 5*0.3455+2*0.2112I need to create the final results tabulated as follows:ZONE-------------TOTAL_DEMANDZONE1-----------(calculated as above)ZONE2-----------(calculated as above)The task is easier with VLOOKUP in excel, but I am not able to find suitable transformers to do the same in FME. Please suggest a suitable method.Suggestions regading use of a programming language(such as python) to achieve the same are also welcome.PS- Hiphens

7 years ago

rdellar17

asked in Transformers

Microsoft SQL Spacial Table -> (Something) -> Google Maps Workflow Suggestions

This is more of a workflow question, but using FME to do so. New to FME, but basically I have a Microsoft SQL Spacial Table that has geometries/polygons in it that I want to display on a Google Map. These polygons represent land ownership, which is basically what Google Maps shows when you fully zoom in. (See the attached image below. i.e. For Crafton Tull you can see the 3d building and then the polygon around it that is the property boundary.) What I want to do is automate the transfer of the Microsoft SQL Spacial Table geometries & associated data into a format that Google Maps can use. The simplest option seems to be to pull it into a Google Fusion Table, but I didn't know if others had recommendations. I found this old FME blog post that talks about using Google Cloud SQL but that seems more complex. (Fusion tables are very easy to use... But the future support for them is unclear.)https://blog.safe.com/2015/01/6-google-maps-engine-alternatives/Any other / better s

140

7 years ago

andyew

asked in Transformers

Complex co-located CAD block placement for CAD writing

Folks,I have a challenge and I'm not sure if FME has this capacity. I have some Mapinfo co-located points that need to be written as attributed blocks. This I know FME can do and I have done this successfully. Now the challenge has been set to come up with "placement rules" that "move" each block insertion such that it DOES NOT overlap its co-located partners.As far as the logic is concerned what I would want to do is test each input object(point) to see if there are co-located points. Then based on the number of co-located objects loop through the objects placing them at some fixed incrementing\\decrementing Y(North South axis) coordinate.eg var NumPoints = 5for i = 2 to Numpointsfetch rec(i)insert block X,Y+(i*-10)next Is there any sort of construct that would support this?I'm also aware I'd need a way to ensure I didn't test an already tested point and inserted\\offset block.Any advice appreciated.

7 years ago

hectorborromadr

asked in Transformers

XLS writer: set specific cell value

Hi, I'm creating a transformer and getting an XLS output starting to write on row 2. I've successfully set a template for the header and format, however I need to write specific data such as date or file description in the top row. How can I write the Document title on cell A1, Author on cell B1, DDMMYY on cell C1?

2270

7 years ago

rylanatsafeSafer

asked in Transformers

Translation problems? Have you tried throwing Lumberjacks at it? The curious case of the Logger.

I recently noticed that the beloved Logger transformer – number 49 on the popularity list, as of this writing – also has a very interesting alias.Behold,.. the Lumberjack transformer!Next time you are debugging your workflow, why don't you try throwing some Lumberjacks at the problem?Which has me wondering... Are there any other aliases out there which are equally amusing? Or what transformer do you insist referring by its alias rather than its "proper" name? What alias do you want to see!?

170

7 years ago

jonlibby

asked in Transformers

Row of data with hwy and mp. i want to find unique hwy min(mp) and max(mp) and create a single row.

I have a set of data that contains on each row a highway, start_mp. I want to find, for each highway, the min(start_mp) and the max_start_mp and combine them into a single row of data ordered like: HWY, MIN(START_MP), MAX(START_MP), other attributes.

7 years ago

paulbushnell

asked in Transformers

Creating unique buildings from surface model based on footprints defined separately

I have a little challenge that i am not sure how to tackle. Hoping for some hints. I have a large obj model. I can import this and it describes a surface of a land area. What I think I want to do is take a seperate set of polygons (3D) I have for building footprints (all flat but in 3D) I then wish to use these polygons to "slice" the bottom of the buildings to generate building shapes which I want to assign an attribute (its identifier) from the polygons which do the slicing. I am thinking clipper and buffer but not sure whether it preserves Z values for the surface bottom. My data also has an arbitary 0,0 so will have to move the origin and stuff doesn't 100% line up. That's something new for me also.

135

7 years ago

sdv

asked in Transformers

Trying to create features from JSON (following JSONFragmenter)

I'm trying to create (FME-)features from a JSON-ouput (source: JSONFragmenter).I am not able to subtract/expose "geometry" and can't figure out why.My JSONFragmenter parameters are:JSON Query: json["features"][*]Attributes to expose: id geometryCan someone help me out ?Example of JSON-output:{ "type": "FeatureCollection", "totalFeatures": 1681523, "features": [ { "type": "Feature", "id": "GBG.23662", "geometry": { "type": "Polygon", "coordinates": [ [ [ 134465.638337, 192310.473928 ], [ 134465.881025, 192308.624072 ], [ 134470.076353, 192309.29684 ], [

1000

7 years ago

pilgrimjake

asked in Transformers

Will the ChartGenerator be fixed to allow Correct display of DATES on the X Axis?

Could really use this function extensively, but almost all our data is Date variable - eg Groundwater and chemistry. Is there any news about fixing this bug? Eg FME 2018.Gecko On. Gecko Up.

7 years ago

gerardbrazil

asked in Transformers

oData and Well-known text (WKT)

Hello... What transformers would I need to extract the Well-known text (WKT) from the following oData entry? Thanks!{ "id":"97051464","GeoInstance":{ "Geography":{ "CoordinateSystemId":4326,"WellKnownText":"POLYGON ((-111.854 54.5259, -111.738 54.0571, -111.738 54.0571, -111.086 54.219, -111.086 54.219, -111.145 54.4751, -111.145 54.4751, -111.854 54.5259))","WellKnownBinary":null } }

185

7 years ago

redgeographicsCelebrity

asked in Transformers

Schemamapper error

If somebody from Safe's support could take a look at this.As mentioned in this thread the SchemaMapper is showing some odd behaviour. I'm doing a simple attribute map and specify that the old attributes should be removed. However, they remain and the new ones aren't automatically exposed.Sample template attached:

100

7 years ago

nmattonContributor

asked in Transformers

max value of two attribute of a feature

Hi !I have a set of feature, for each feature, multiple attributes (A,B,C), all having numbers. I have to extract, for each feature, the maximum value value among the attributes A,B and C.Since the StatisticCalculator limit to compute the max/min/... value of an attribute among all feature, how can archive my goal ?thanks in advance !

1220

7 years ago

Page 380 / 508

Badge winners

kurbakovskayaahas earned the badge 12 Days Participant (2024)
baileyatsafehas earned the badge 12 Days Participant (2024)
dos_gishas earned the badge 12 Days Participant (2024)
j.botterillhas earned the badge 12 Days Participant (2024)
fme_studenthas earned the badge Welcome Back

Show all badges

30,185: 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.