Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,711 Replies
10000 Posts
M
marknewman
asked in Transformers
Extract features from an excel file and merge with polygon Some of the rows will have a ‘Y’ against a ward or some wards that the informati

I have a large excel file with multiple columns with different attribute information, some of these columns have information about the local authority wards, for example; Some of the rows will have a ‘Y’ against a ward or some wards that the information relates to.For each row I want to match fields that have a ‘Y’ and merge with the ward polygon file creating a polygon of the matched wards, so for the above example there with a polygon file with 4 wards.Any suggestions on the best way to approach this? Thank you in advance.

110
M
femo
Contributor
femoContributor
asked in Transformers
FME as a client for a WebCoverageService (WCS)?

Hi,I can call a WCS by means of my browser, using a getcoverage request. The service returns a geotiff, for example, that i can save to my disk.It would be great to use FME instead. However, I only find WMS and WFS Reader.Do you know a way to do it anyway, do I have to use the HTTPcaller?Best wishes!

420
vince_j
Contributor
gpt_geoinfo
Contributor
gpt_geoinfoContributor
asked in Transformers
Trouble with Custom Transformer and published parameters

Hey Y'all,I'm having troubles with creating a custom transformer and its published parameters. The goal is to add a number (calculated with SQL and a chosen leading number) to different (existing) numbers. These numbers are stored in different attribute names, i.e. id, type. When I create a custom transformer with the 'id' and want to use it with the attribute 'type' it keeps calculating the 'id' OR if I edit the parameter I can't choose it from an attribute anymore. I'm stuck!A sample workspace is attached (FME 2021).Any ideas appreciated.Cheers,Maria

240
gpt_geoinfo
Contributor
mahbouberezaiee
mahbouberezaiee
asked in Transformers
Optimization of processing time for a large dataset

Hi. I have prepared a workflow that is full of many tansformers. I've tested it for just 3 Buildings and that works perfect but when I run it for a large dataset, the processing takes too much time(3 or 4 hours). Can somebody helps me to know how to reduce this time?Thanks

40
virtualcitymatt
Celebrity
N
neel_d
asked in Transformers
How to use a User parameter in the 'Feature Types to read' parameter of the Feature Reader

Hello,I have set-up a workflow that needs to be run several times using different set of input-data. The names of the input data are all the same except for a number at the end (for example: 'WSbekken_1', 'WSbekken_2' etc.). The input data is in shapefile, geodatabase and tiff format. I want to use a user parameter ("RHS_2") indicating the number of the input datasets to use and have different FeatureReaders reading the input data. I managed to get the shapefiles and tiffs read like so: but not the geodatabase because the user parameters do not seem to work in the 'Feature types to read' parameter field, which I need in the case of geodatabase. I tried the following but it is not working, in the log file I see it tries to read a file "WSbekken_" so it seems to completely ignore the "@Value($(RHS_2))". I figure I could split up my geodatabase so that I have one dataset per database and set the parameter to 'all feature types &#3

4700
N
W
walker_henry
asked in Transformers
How to transform JSON file from Esri Extract Changes API call back into features I can write to another hosted feature service.

I'm trying to build an archive off a feature service hosted in ArcGIS Online by getting the changes and writing them to a second hosted feature service. I can get the changes in JSON, but I'm struggling to turn them back into usable features. The format looks like this: "edits" : [      {         "id" : 0,         "features" : {            "adds" : [               {                  "geometry" : {                     "x" : -119.58448584499996,                     "y" : 32.10688862600006                  },                  "attributes" : {                     "OBJECTID" : 93,                     "GlobalID" : "1DF7CAF6-D3CC-4E8D-8FB3-C6714C06890A",                     "IncidentName" : "Testing",                     "Label" : "DIV X",                     "Label2" : null,                     "LabelType" : "Division",                     "Other" : null,                     "CreateName" : "test_nifc",                     "CreateDate" : 1621322205148,                     "EditName" : "test_n

2010
debbiatsafe
Safer
yourusername
Participant
yourusernameParticipant
asked in Transformers
Create bounding box from Bounding Rectangle of a feature

I have this Oracle database that has a trigger that automatically creates a bounding box around any feature, in this case they are parking lots. The index database stores the northernmost and southernmost latitude as well as the corresponding eastern and wester most longitude of the minimum bounding rectangle. I'm trying to crate this bounding box using FME and I'm not seeing the best way to accomplish this. My thought process:Create 4 points for the four corners of each box and then create the areas for them.Create the top left and bottom right corners of each box and then have FME figure out the polygonFind a transformer that just knows what to do with these 4 fields and then get a cup of coffeeOf course the 3rd one is what I'd love to see but I'm not sure that exists. I'd rather not create a ton of points just to create a polygon but I might need to do this.  Any thoughts?  

8690
DanAtSafe
Safer
mikamattila
Contributor
mikamattilaContributor
asked in Transformers
How to set up the Query String Parameters in HTTPCALLER with a URL that ends with /1729/1774.mvt where the two numbers are variables in a CSV file.

When using HTTPCALLER I cannot figure out how to use the Query String Parameters. The URL ends with /1729/1774.mvt these two number are in two columns in a CSV file (attached).  The whole URL is the one below and if I use that as a Request URL it works (its password protected).https://maps-ver.lantmateriet.se/vt/fastighetsindelning/v1/wmts/1.0.0/fastighetsindelning/default/3006/10/1729/1774.mvt

2370
david_r
Celebrity
M
mauliem
asked in Transformers
please guide to convert the xml file to excel to get all the fields information

please guide to convert the xml file to excel to get all the fields information

80
danilo_fme
Evangelist
jatoxa
Contributor
jatoxaContributor
asked in Transformers
Style Excel cell values

Hi,  I know the ExcelStyler is in beta but here goes the question anyway. Is it possible to style individual cells based on the attribute value?  I have tried different approaches that all color the entire row or entire colum as you see below. Result if I filter through a tester and chose to style attribute "c".   Result if any of the attributes fail the tester, the entire row is colored.  This is what I need, to style individual cells based on their value   Thanks!  /Jacob

42817
ebygomm
Influencer
toedeledokie
toedeledokie
asked in Transformers
How can I extract XML attributes used as containers for data?

Your input would be much appreciated. I don't know how to proceed and would like to avoid manipulating the source data manually to get it to do what I want. I've received data which is formatted in the following manner. I'm posting the first item and closing it off just as it ends in the file with </markers>:<markers> <marker name="Tilburg"    straat="Vloeiveldweg 6a"    postcode="5048 TD"    plaats="Tilburg"    site=""    lat="51.600739"    lng="5.064299"    linkurl="tilburg"    status="0"    dot="red.png"    ></markers> I used an XMLFragmenter and it's configured as:Elements to Match: markers/markerFlatten Options: EnabledFeature Information shows:How do I go about extracting marker.name etc. into their own attributes with values? I've tried various combinations in Elements as XML Fragments but no dice.

1390
toedeledokie
P
psmaaaron
asked in Transformers
I'm using the new FME 2021 WMTS reader with a basic authentication. I had to change the password for the user and now the reader down't work. Any ideas on why this is happening?

Listing the available layers works with the authentication and using a HTTP caller to the getcapabilites with the authentication works. It's just when the reader is running.It would be great if there was a way to capture the HTTP(S) request and responses.

60
P
lifalin2016
Supporter
lifalin2016Supporter
asked in Transformers
Parameters for custom transformer doesn't accept variables ?

Hi.I've now run into this issue several times now.If I create a custom transformer in my workspace, and create some parameters in it to be given values in the main part, some of those parameters doesn't accept variables, only text editor and workspace parameters.What is triggering this odd behaviour ?Attaching a screen dump from 2021.0 

70
lifalin2016
Supporter
mathiku
Supporter
mathikuSupporter
asked in Transformers
Create area from line input

I have a road network represented by a centerline (brown) and 2 edges (pink). I am looking to create an area from it.The network is rather complicated so linecloser->areauilder doesn't work. I then tried buffering the centerline, polygoncutter and spatialFilter, which doesn't really work for round-about and junctions. At the moment I am trying to create cross-sections (blue) at a given sample dsitance, using neighbourfinder, which seems to work very well. However, I can't figure out a way to create a hull-like area from the cross-sections. I am considering trying to write the vertices into a list and then to a polygon, but it feels overly complicated.Does anybody have any leads. I can provide sample data tomorrow.

90
M
M
michelle_onasse
asked in Transformers
I would like to transform a GeoJSON file into a line feature

Hello everyone, I'm currently trying to make a path from a GEOJSON "link" which was return from a HTTPCaller. Is there any way to transform the link below into a line feature? Thank you in advance. {"code":"Ok","waypoints":[{"hint":"xPMEgEswB4AKAAAAAAAAAFcAAAAAAAAAJ0k3QQAAAADB2cBCAAAAAAoAAAAAAAAAVwAAAAAAAADaAAAAC07F-1foygJzT8X7X-bKAggAnw0GXKGa","location":[-70.955509,46.852183],"name":"Rue du Moulin"},{"hint":"4nEJgIjqCYAMAAAABQAAAH0AAAAaAAAAUXXHQaFyEkF2A31DScJOQgwAAAAFAAAAfQAAABoAAADaAAAAAVjF-47pygK1V8X7u-nKAgUA3w0GXKGa","location":[-70.952959,46.852494],"name":"Route du Fleuve"}],"routes":[{"legs":[{"steps":[{"intersections":[{"out":0,"entry":[true],"location":[-70.955509,46.852183],"bearings":[37]}],"driving_side":"right","geometry":

410
nampreetatsafe
Safer
spiderman
Contributor
spidermanContributor
asked in Transformers
How to merge multiple Tiff (Tagged image file format ) georefrenced to create one full image with correct coordinates

 my example i have folder that contains lots of files that contain tiff extension and tfw extension .i would like to import all images to fme workbench and build one image with the correct cordinates then i could merge with polygon border coordinates ,to check which image suitable to which polygon bordereach image has different min and max extents as pic down,i would like to rearrange them together .How could i achieve it ?Thanks in advance

6010
spiderman
Contributor
M
maschlin
asked in Transformers
Replace feature z-value with point z-value

In the first step Im doing a PointOnAreaOverlay which connects the features with a point inside the features. The next step I want to replace the z-value of the feature with the z-value of the point. I have tried with both CoordinateReplacer and GeometryReplacer. So how to replace z-value of the feature with the z-value of the point?

1320
caracadrian
Contributor
T
theunderwood07
asked in Transformers
Rename image file name to match data in spreadsheet

I have hundreds of image files that require renaming. I have an Excel sheet with the oringinal file names in one column and in another colomn the prefered file name. I would like to replace the image file (.jpg) name with the new name the column in the spreadsheet. I found an article on how to do this, but I can't seem to get the script to work. I am new to FME. I have provided the workbench file and the spread sheet and a image file.Can some one please help guide me with where I am going wrong?

1191
nielsgerrits
VIP
M
michaeld
asked in Transformers
Missing nodes from LineOnLineOverlayer

Hi all. I'm struggling to get the LineOnLineOverlayer transformer to work. I'm working with MI tab files. I want to create a node at the crossing locations of an linear infrastructure data set 'A' with three other liner datasets 'B', 'C' and 'D'. The results I'm looking for is nodes at the crossing of A and B, A and C, A and D. The problem I have is not all intersections are being generated. The attached image shows an example of this. On the eastern side the blue dot represents an intersection between A and B. However, further to the west I would expect to see another two intersections but nothing has been generated. The green polygon is one of may regions that is used to clip the poly line datasets to a manageable size before processing. The parent datasets are nationwide in geographic extent. What have I missed? Do I need to deaggregate lines somewhere? (I've tried a few locations) Thanks,Michael 

100
david_r
Celebrity
B
badieeau
asked in Transformers
How to write on LandXML from DXF/DWG files

I have got a LandXML schema and I am wondering how can I export a LandXML file based on that from a DWG/DXF reader.Can you please give me some samples/tutorial or guide me how can I map the DXF data to LandXML file? Thank you & Regards,FB

4340
mik_w_thomsen
Contributor
H
holyg
asked in Transformers
How to extract Populated Places from Openstreetmap

HiHopping this is the correct forumI'm trying to work out how to extract place names from OpenStreetMap(.osm) files from geofabrik.deFor testing I picked WalesUltimately I will push into PostgreSQL / PostGIS database hopefullywithout corrupting non English names  In the attached Workbench I used AttributeExposer to show everything thiswas done using the cache My first question how do I make that dynamic?There will be some distinct attributes like name, osm_id, is_in, wikidata etc and some dynamic ones especially non English names  My Second question is how do I group similar attributes together and merge into a JSON stringfor instance alt_name:en, alt_name:fr, alt_name:* grouped into alt_namejson this with then be held as a jsonb database type Similarly name: en, name:fr, name:* grouped into official_names json I couldn't see how to do this using AttributeFilter or Tester All other attributes not yet accounted for grouped into all_tags json string I've done something simila

500
chrisatsafe
Contributor
spiderman
Contributor
spidermanContributor
asked in Transformers
how to avoid black fill color in dgn and change it to yellow background of a map in dgn output file

how to avoid black fill color in dgn file output , i would like to change the background of map to yellow instead of black by default in dgn file .what should i do in fme workbench to modify the background .i have used dgnstyler but it is useless in output ,i see only the changes in inspector in fme but no effects at output dgn filei am using dgn writer at the end of FME workbench FME 2018 Thanks in advance

770
chrisatsafe
Contributor
K
ksm65
asked in Transformers
Hallo , In the excel table I have, there are street name, house number and post code information. Can I create point data of type Shapefile from this information. Or should it have a value of X and Y? Thanks...

30
K
L
larsec
asked in Transformers
Change Detection adds duplicates

Hi all,I have a workspace, where I am detecting the hange between my original data in an SDE and revised data coming from a public source.  I'm using the fme_db_operation to push Inserts, Updates and Deletes to my SDE. However it apparantly just keeps adding the data as duplicates.  I have 6 exactly same polygons for each feature, with the only difference being a Version ID... Any thoughts?

2010
L
M
michelle_onasse
asked in Transformers
I would like to modify a comment section in my table

Hi,I would like to modify a comment section in my table. The comment section is intended when there's a change between two roads. For example, when Road 6 is changing for Road 6-A, the comment section writes : Road 6 is becoming Road 6-A. Now, I got a lot of these examples but the comment section is almost blank (with some examples as above). I want to describe those Roads change when the comment section is blank. I got 4 000+ roads changes, so a formula would be appreciated. Thanks.

200
chrisatsafe
Contributor

Badge Winners

Show all badges

Community Stats

31,802
Posts
120,809
Replies
39,420
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.