- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,739 Posts
50,959 Replies

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

12739 Posts

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.

145

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 ], [

1070

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 } }

245

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:

110

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 !

1260

7 years ago

aquamarine

asked in Transformers

Possible TestFilter bug

Hi,I am using FME2016 1.0.1 Desktop, and have encountered, on random occasions, a strange occurrence with the TestFilter transformer.I can't replicate it as it only happens randomly, but sometimes, after I have added a couple of tests into the TestFilter, a yellow right-pointing triangle appears on the top section of the transformer as well as coming out of the TestFilter streams. Whenever this happens, the workbench fails when I try to run it. I then have to delete the TestFilter and recreate it. Usually the second time it is recreated with just with the yellow triangles coming out of the different streams, as expected.Is this a bug? Has anyone else experienced this?Thanks

100

7 years ago

lemzip

asked in Transformers

road network extraction

Hi,I am trying to build a network using the OSM roads dataset. From this i would like to extract all roads within a set distance from a point. This should not be a simple as the crow flies buffer selection but by road distance on each road from the point.Thoughts?

570

7 years ago

aoakes

asked in Transformers

Missing object data tables

When using the FME Quick Translator to convert CAD from Autodesk AutoCAD Map 3D Object Data to Esri Geodatabase (File Geodb ArcObjects) as raw relational static schema conversion, tables with "_od_table" are created. When using FME Workbench using the exact same settings, the "_od_table" are not created. How can I replicate the production of these tables using FME Workbench?

7 years ago

1011analyst

asked in Transformers

What is the best tool/tools for concactenating (shp) results into a csv file?

Hello, I am using FME(R) 2017.1.0.0. I have prepared a workflow consisting of several calculations and selecting attributes from SHP format. I want to output the results into a CSV format. More specifically, I want to transpose results into a custom format which automatically populate a spreadsheet. I am having trouble figuring out the right transformer/writers to transpose and design the spreadsheet the way I need to. I would appreciate this board's feedback.Thanks in advance.

100

7 years ago

kirstynalex

asked in Transformers

ArcGIS Online Layer Slow to Read and Process Updates

I have a question about integrating FME with ArcGIS Online (which I will be using to create an Open Data site). I am exploring using FME as the method for pushing data updates to our feature services. I have tested this successfully with small datasets, but ran into issues (understandably) with our large parcel dataset (~400,000 parcels). This is very slow to run with the Update Detector method as well as a Truncate and re-populate method. Has anyone ran into this issue and do you have any suggestions for how to do this with larger datasets like this? Any tips or tricks I'm missing? I am thinking that for large datasets we may have to manually publish from ArcMap or Pro (since it takes less than 5 mins), but it would be ideal for us to use an FME workspace for each dataset to keep it clean and consistend. However, if processing time is 2+ hours then that is definitely not the best solution. Here is a screenshot of my (currently running) workspace. I have limited the revised source

1360

7 years ago

1011analyst

asked in Transformers

What is the best transformer/s for transposing (shp) results into a csv file?

7 years ago

proudgis

asked in Transformers

Extruding building heights from 3D terrain model creates sloped buildings

I have asked this on GIS SE but seem to have had little interest. I imagine it would be more suitable to post here.How can i prevent sloped buildings when I extrude building footprints over sloped terrain? I am using FME to drape 2D features over terrain (SurfaceDraper), then using the Extruder transformer to create 3D buildings from OS Building Heights. Unfortunately the height value seems to apply itself to each vertex, which creates sloped building tops (roof geom is not relevant here) - example below: Is there an extrusion method that uses a single vertex, or is there another method entirely?

1160

7 years ago

geosander

asked in Transformers

Is it possible to extract the character encoding of an attribute?

Text attributes can have a character encoding in FME, as we all know. The encoding that is used is shown in the Data Inspector, for instance: I would like to fetch that "iso-8895-1", "utf-8" or "windows-1252" value. My guess is that the answer is no but the question is: is it possible to extract the encoding somehow? I know that the FME Objects Python API allows me to detect if the attribute is an encoded string (FMEFeature.getAttributeType() ==> FME_ATTR_ENCODED_STRING), but it doesn't tell me what the encoding is. It seems to be stored as a (hidden) attribute property though, otherwise the Data Inspector could not show it.Depending on the answer(s) I will get here, I'm thinking of posting an idea for an EncodingExtractor transformer.

1650

7 years ago

tobiasp

asked in Transformers

Calculate volume from TINSurface?

Hello, I have measured some points on some piles of dirt that I need to calculate the volumes of. I have got some points by the foot of the piles and some on top of them to define their geometries. Now is the question how to use this data to get the volumes? I have managed to get a TIN surface from the TIN Generator but I cannot calculate the volume unless it is a solid, right? Any ideas..?

1337

7 years ago

judyz

asked in Transformers

CAD Blocks with Multiple Visibility States to GIS Conversion

Hi,I'm trying to convert a CAD file contains blocks with multiple visibility states as labels. any idea how to convert that to GIS? Thanks

200

7 years ago

mjoarder_pln

asked in Transformers

Deleteing an XML element completely if the value is NULL in XML Templater?

Hello everybody, i have mapped my sql server table to an xml schema and final output we are getting metadata of tables. To input related Foreignkey information inside metadata we have a field and we mapped it, problem is for many rows we dont have values, we have NULL. From current mapping values are coming and NULL values are creating empty elements in final xml file. Please see the screenshort. We want to delete the total bnr:foreignkey element for NULL values. Please correct my code if someone can help me. Thanks a lot. Looking forward.

1438

7 years ago

hoa_leContributor

asked in Transformers

How to convert from shapefile to .mdb?

Hi everybody,I have a shapefile (line) and it includes fields:year, time, commune, province... and I have a .mdb that has a table empty have fields: a_xa, b_ti.I want to get spatial data from shapefile to table in .mdb and get attribute (commune = a_xa, province = b_ti). How can I do? Thank you

320

7 years ago

arxitContributor

asked in Transformers

Change detector attribute no matching problem

Hi everyone,I am using a ChangeDetector, only on one attribute "parcelle", to compare differences between polygon layers, but there is a problem because all of the polygons are detected as "changed" (then they should not, because values of "parcelle" attributes are the same in the two layers) :Port 1 (Added) :Port 2 (Deleted) :I thought that the problem was because of the encoding of these attributes. So I have tried to use the AttributeEncoder Transformer, but it changes nothing :I also have tried a FeatureMerger on these attributes and it works.Thank you.Aurélien

810

7 years ago

lazarlubomirContributor

asked in Transformers

Line joining/tracing till getting elevation value

Hello,please, I wanna solve one problem with line elevation on wastewater network. I have really big network of lines in 2D, but every line has 2 attributes (BOTTOM_ELEVATION_FIRST - elevation of first line vertex and BOTTOM_ELEVATION_LAST - elevation of last line vertex). Unfortunately, values of these 2 attributes are not filled for all features. So, I have situation when some features have both values, some features have just one value and some features have none values. :-/ What I need is to join lines according to fact if the attribute of elevation is filled or not - the goal is getting lines which have filled both attribute values.Do you have any idea, how to figure out this issue, please?Thank You so much!Lubo

7 years ago

mark2atsafeSafer

asked in Transformers

FME Community: Flavour of the Month (July 2017)

Hi FME'ers,What with vacation and the eventual .1 release, this is a little late - but I certainly didn't forget we need to honour July's Flavour of the Month.This - you'll remember - is the person who earned most reputation during a calendar month (and you had to be in the top ten with at least 100 points, and haven't won this before!)Anyway, the winner for July is: @erik_janErik scored 687 reputation for July, enough to put him into 3rd place overall, and earn a spot among the previous winners (@takashi, @david_r, @jeroenstiers, @jdh, @itay and @gisinnovations)The top ten for July:david_r: 1822takashi: 1534erik_jan: 687redgeographics: 662lars_de_vries: 625egomm: 612Mark2AtSafe: 584jdh: 477stalknecht: 445velasquezvictor: 394Congratulations to you all, but particularly Erik, who earns the custom Flavour of the Month badge for his efforts.Mark

7 years ago

patiaserica

asked in Transformers

Spatial query with SQLExecutor

I am trying to make a spatial query with SQLExecutor and having some issues. My filter is some point buffer features in a ESRI geodatabase and the feature points I want to filter are in an Oracle database. I am extracting the geometry and using SDO_RELATE as shown bellow. Using FME 2016.My SQL query:select * from gds.emb a where a.DATAHORA >=to_date('01/01/2017 00:00:00', 'DD/MM/YYYY HH24:MI:SS') and a.DATAHORA <to_date('01/02/2017 00:00:00', 'DD/MM/YYYY HH24:MI:SS') and sdo_RELATE(a.GEOM,@Value(_geometry),'mask=anyinteract')='TRUE'

4310

7 years ago

fmelizardContributor

asked in Transformers

Recommendations for setting up a fault tolerant file system for FME Server?

When setting up FME Server and configuring for Fault Tolerance, it's recommended that a fault tolerant file system is set up for storing the FME Server system share folders. For anyone who has set this up before, do you have any recommendations for how to create/set up the fault tolerant file system?

100

7 years ago

vkiContributor

asked in Transformers

change units of coordinates from mm to m

I have some data with coordinates in milimeters (swiss LV95) and I need to change them to meters. How do I do that? thanks, Vera

3050

7 years ago

bakkermans

asked in Transformers

Snipper does not work properly

I want to snip the first and the last meter of a line (which is 10 meters). I therefore take a Snipper, set at "Distance (Value)" with Starting Location = 1 and Ending Location = -1. The Snipper only cuts off the first meter as a remnant, but leaves the last meter untouched. Am I doing something wrong here, or is the Snipper not working as it should?PS: FME 2016.1

11314

7 years ago

Page 383 / 510

Badge winners

sieblisthas earned the badge Welcome Back
followersindiahas earned the badge English Speaker
james_c_452has earned the badge Webinar Watcher (Bronze)
vidhyarhas earned the badge Integrate Spatial Data
boostpadhas earned the badge FME Flow Authoring Training

Show all badges

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