Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 12,682 Posts
  • 50,741 Replies
12682 Posts
john_gis4
Contributor
john_gis4Contributor
asked in Transformers
Create TMS tiles from tiled source rasters using WebMapTiler

I have a directory structure containing source raster tiles (512x512 pixel png files) in TMS (XYZ) format at level 10. These have been provided to me by a third-party.From these I'd like to generate levels 9 & 8 so additional layers can be shown in a leaflet app. I thought FME and the WebMapTiler would be the answer, but I'm struggling to get this working. So far I have the following in workbench: A PNGRASTER reader that reads all the source files from the existing directory structure.A PythonCaller to calculate the bounding coordinates of the source tiles using a python function from here - https://wiki.openstreetmap.org/wiki/Slippy_map_tilenames.A RasterGeoreferencer to georeference the rasters usign the above coordinates.A RasterMosaicker to generate a single raster.A WebMapTiler (set to GlobalCRS84Scale, Minimum Zoom=8, Maximum Zoom=10) to generate the raster tiles at level 10, 9 & 8. A PNGRASTER writer with the name set as the Y (row) attribute and a fanout express

1118
V
3 years ago
Z
zacharylee1204
asked in Transformers
How to valid a date time input data in FME

Hello,​So I have a data, which is called "Amendment Date". The format is as followDD/MM/YYYY HH:MM:SS. ​I would like to make a checker to check if the input data are correct. I tried the attached steps and it seem ONLY works on correct order. If the data is wrong, it said ERRORS and cannot run the transformer. Would someone please guide me how to do valid the format. Thank you.

873
ebygomm
Contributor
3 years ago
R
robeesafe
asked in Transformers
How do I convert a date such as 12/31/1979 to Julian date in FME?

How do I convert a date such as 12/31/1979 to Julian date in FME?

353
R
3 years ago
C
chanduguda
asked in Transformers
How to add Suffix value to specific attribute value?

Hi All,I am working a project ,where client asked us to add suffix to a attribute value .This attribute value is not a Unique , in order to make it unique we have ad suffix values as shown below image , requesting you all to provide a solution ? to reach this requirement! (the suffix number should be 4 numbers)Thanks in advance.

794
C
3 years ago
aharport
Contributor
aharportContributor
asked in Transformers
Create Line Buffer to receive Polygon with z-coordinates

291 / 5000  ÜbersetzungsergebnisseI'm looking for a transformer with which I can create a buffer around a line. This buffer should have a defined width. The line has z-coordinates.At the end I would like to continue using the buffer polygon that was created and the polygon should receive the z-coordinates of the line.  

4414
aharport
Contributor
3 years ago
P
pieter_kok
asked in Transformers
I need a way of creating a new attribute from existing attributes, the name of the new attribute should be derived from a different attributes string value and the value of the new attribute should be derived from the value of a another attribute?

I am currently using a ChangeDetector to determine which fields have been updated in two different databases. The change detector works as intended and creates a list of different fields have that have been updated. The problem I have is that all the updates need to be written to a database on a one-by-one basis and currently I cannot find a way of sorting the updates by the specific field that has been updated. The updated list created by the ChangeDetector has specific attributes called "attributeName" and "revisedValue". I want to use those two attributes to create a new single attribute which is named after "attributeName" and has the value from "revisedValue" that indicates to my database which field need to be updated and the value that has changed.

822
P
3 years ago
giuseppecfgeo
giuseppecfgeo
asked in Transformers
To invert Y/Z AXIS for a correct OBJ

Hey community! how can I convert a point cloud in this sense? When I put my obj in Unity I have this problem....

541
virtualcitymatt
Evangelist
3 years ago
C
coreyunger
asked in Transformers
3D DGN -> FMEAR, not showing up in the FME AR App. Are there any other transformers or other considerations I need to take into account?

I've got a 3D DGN of a bridge out of Bently. I'm following the instructions in the Creating FMEAR Datasets from 2D Cad models article. Since it's already a 3d model, I'm assuming that I dont need the extruder or offsetter. So it should just show up if I convert it, right? I do get a layer list and scale information in the app, but the surface dots disappear once it loads, and nothing else shows up.

72
kailinatsafe
Safer
3 years ago
L
lmawhinney7175
asked in Transformers
I have a workbench that is using an excel reader for an excel spreadsheet that gets updated with one new record everyday. The workbench is not pulling this new record automatically.

The work flow of this process is that there is an excel spreadsheet from another department that is updated with one new record everyday. This excel document is the source for another spreadsheet that we use in our department where there are formulas that update columns. What we are noticing is that when the workbench is run the next day it will not pull the new record automatically. If I open this excel spreadsheet and save it manually then the FME excel reader will pull the new record. What can I do to get the FME workbench to pull the new record?  Thank you, Laura

265
kailinatsafe
Safer
3 years ago
tim_wood
Contributor
tim_woodContributor
asked in Transformers
Find polygons that overlap more than just a bit

I have data for various sites and some sites have been digitised more than once and have overlapping polygons. However, these are not virtually identical polygons. They only partially overlap. I want to find the sites that have overlapping polygons. I tried using SpatialRelator with "Intersect", using the same data as both Requestor and Supplier but it picked up instances where one polygon was actually adjacent to another but probably just overlaps a tiny bit. This resulted in 3700 out of 3900 having more than 1 related candidate which doesn't really shortcut the process. "Contains" wouldn't work because not all overlapping polygons are completely contained.

40716
Z
3 years ago
G
gbazzz
asked in Transformers
Version in ESRI SDE database made in workbench by featurereader cannot be removed after posting because it is in use

I have a workbench in which I translate XML files to featureclasses in an ESRI SDE geodatabase. The featureclasses are versioned. I use a featurereader in which I specify the child version. That version is then created by the featureader since it doesn't exist before the start of the translation. Updates are done with an SDE geodatabase writer in this version. I specify in the parameters that the version is to be reconciled and posted after the translation. After posting, the version should be deleted. This is also indicated by setting the appropriate parameter. When I run this workbench in FME desktop, this works fine. However, when I publish the workbench to FME server and run it via an automation, the version is reconciled and posted, but it is not deleted. The log displays the following error:Error deleting the version 'versionname'. The error number from ArcObjects is: '-2147217140'. The error message from ArcObjects is: {The version is currently in use. [versi

61
rahulsharma
Safer
3 years ago
S
slamon
asked in Transformers
Trying to read Enterprise GDB data that includes arcade expressions / attribute rules with FME 2021

I have some data that i am trying to replicate from 1 DB to another, but I cannot create the readers for several FCs that contain arcade expressions. I get the The error number from ArcObjects is: '-2147211773' message. I am running FME 2021 (64 bit), and have ArcPro installed and the Esri ArcGIS Capability is set to Pro. One thing I can't seem to get is the ArcPro Python listed under Python Compatibility. But I do see that listed in FME 2019 on the same machine. Any thoughts on whether or not this should be working and if so, how I can get it to work?

552
S
3 years ago
T
toebr
asked in Transformers
Rcaller - Lags on "processing R script"

I'm new to FME and tried to use the Rcaller transformer. However, the software lags at the log point "processing Rscript" and does not finish the translation but does not give back an error. This is also the case if I try to run the Rcaller example dataframe() script without any input data. See screenshots for details. Any help much appreciated.I'm using FME 2019.2 with R >=3.6. Translation log:Rcaller parameters:FME Translation Options:

31
T
3 years ago
J
jonathanklarup
asked in Transformers
Why does my scripted parameter fail, when I use a User Parameter as input ?

I need to check the encoding of several files. For this I can use a scripted parameter like so: featureType =open('F:\\PGV\\Projektarbejdsmapper\\P4\\SCSV_til_kontrol\\scsv_2021e1_2021e3\\\\2021e1_lev_k_fortidsminde.scsv')t = str(featureType)return t With a Creator and a ParameterFetcher i get the following attribute:<_io.TextIOWrapper name='F:\\\\PGV\\\\Projektarbejdsmapper\\\\P4\\\\SCSV_til_kontrol\\\\scsv_2021e1_2021e3\\\\2021e1_lev_k_fortidsminde.scsv' mode='r' encoding='cp1252'> When I try to do this with a useparameter like so: file = FME_MacroValues['SCSV_file']featureType =open(file)t = str(featureType)return t This returns the following log:Starting translation...INFORM: Using Python interpreter from `C:\\Program Files\\FME\\fmepython38\\python38.dll' with PYTHONHOME `C:\\Program Files\\FME\\fmepython38'INFORM: Python version 3.8 loaded successfullyERROR : Python Exception <KeyError>: 'SCSV_file'INCLUDE -- fai

502
J
3 years ago
T
twain
asked in Transformers
SurfaceFootprintReplacer and Polygons with holes

Hi everyone,I wonder if there is any way to force the SurfaceFootprintReplacer to not ignore holes in polygons?I have 3D cityGML data and want to get only the footprint, using the SurfaceFootprintReplacer the result is image Nr.2, all holes are gone and merged to one polygon. There is a custom converter called "GroundSurfaceExtractor" (I found somewhere in the web), what does it correct but this one takes around 10 times longer to calculate. Any hints?(btw: the cityGML does not include "ground_surface" elements to query for, I tried this one...)Thanks a lot!Building Polygon in 2D:SurfaceFootprintReplacer Result:

1477
jackfanzhang
Contributor
3 years ago
S
sparki
asked in Transformers
File Geodatabase Date Value vs Enterprise Geodatabase Date Value

Hello,An enterprise geodatabase reader interprets a value in a date field as: 20130426000000A file geodatabase reader interprets the same date value as: 20130426This is a problem when comparing date values in ChangeDetector, as they are always noted as an update, even though they are essentially the same value.Does anyone have any ideas on how to make the 2 dates comparable?

384
gmbutler2
Contributor
3 years ago
I
ieukcoca
asked in Transformers
decimal #s with trailing zeros compared with same #s without trailing zeros

Hi there, I'm using the UpdateDetector transformer and it's detecting changes with lat/long fields where numerically there's no difference. This is because in one reader (the CVS reader) these two fields have trailing zeros, while in the other reader (an oracle table) they do not. What's the best way to resolve this?

775
gmbutler2
Contributor
3 years ago
jonas_nelson
Enthusiast
jonas_nelsonEnthusiast
asked in Transformers
Convert a text character to another Unicode character and use as a label?

RegEx, FontEncoder and StringReplacer experts, please help! I want to replace regular text characters in a text string attribute with entirely different unicode characters, and be able to use them as geographical labels.For instance, let's say that I want to convert the character "A" (unicode U+0041) in my text attribute, to the Roman numeral "I" (unicode U+2160), and label my map with that.  Some other characters should use other conversion codes - maybe using a lookup table. Is it possible?

2417
ebygomm
Contributor
3 years ago
fmelizard
Contributor
fmelizardContributor
asked in Transformers
Support of ESRI Representations When Mapping of Data Between ESRI File Geodatabases

Does FME support ESRI Representation when mapping data between two file geodatabases? If so how do you go about setting this up?  Thank you, Sam

157
kailinatsafe
Safer
3 years ago
itay
Contributor
itayContributor
asked in Transformers
Table/Feature class name too long

Hi, I am trying to IMPORT an EXISTING relationship feature class and FME complains about the name being too long....I cannot rename the Relationship feature class since it is a part of an existing data model. The table/feature class name 'WaterstaatswerkWaterkering_Waterkering' is too long for Oracle (!!??) to accept. Please shorten the name and try again I think this is a FME limitation that should apply if you are going to CREATE the table, but should not apply if the table/relationship feature class already exists! Anybody any thoughts/ ideas on how to go about this?

529
itay
Contributor
3 years ago
juliarozema
Contributor
juliarozemaContributor
asked in Transformers
How to use the PointOnPointOverlayer (POPO) with 600,000+ records without having "creating spatial index" writing to the logfile for 7+ hours.

When using PointOnPointOverlayer (POPO), after FME 2018, I experience performance issues. With FME 2018.1.2.0 (20190225 - Build 18590 - WIN64) I could use the POPO with 600,000 records and this portion of the job use to run in 30+ minutes. Now with FME 2020.2.1.0 (20201130 - Build 20806 - WIN64) it takes 7+ hours. I also tested briefly with FME 2021.1.3 (Build 21631 - win64) but saw no significant improvement. What options are available for removing this additional 6.5 hours of processing time? Similar issue to this article from 2017. Thank you in advance for your time :) Julia Highlights from the logfile:2021-10-21 14:11:59|  0.4| 0.4|INFORM|FME 2020.2.1.0 (20201130 - Build 20806 - WIN64)2021-10-21 14:11:59|  0.4| 0.0|INFORM|FME_HOME is 'C:\\Program Files\\FME2020\\'2021-10-21 14:11:59|  0.4| 0.0|INFORM|FME Desktop ESRI Edition (floating)...2021-10-21 14:12:50| 50.4| 0.0|INFORM|Creating spatial index of 2 point features2021-10-21 14:12:50| 50.4| 0.0|INFORM|Completed spatial in

113
virtualcitymatt
Evangelist
3 years ago
S
soutowendel
asked in Transformers
BulkAttributeRenamer VS PythonCaller - Rename Attribute Names

Hi. I was trying to figure out a way to rename all the fields of my output shape using a PythonCaller. I used the "BulkAttributeRenamer" to rename the fields, but just using a single parameter as: prefix, sufix, lowercase, uppercase etc and it's not enough. When I tried to use PythonCaller, I could change only the attributes itself, but not their field's name (I used the function setAttribute(name, new_value))Is there a python function that can set the AttributteName ?

6115
ebygomm
Contributor
3 years ago
G
goro13
asked in Transformers
How to define an ESRI geodatabase multipoint feature class using an external schema table definition?

I’m trying to define a transformation process between Intergraph GeoMedia SQL Server Warehouse (Reader) and Esri Geodatabase (File Geodb API) (Writer) using FME Workbench 2015. I have defined a schema file in a spreadsheet that is added in the Workspace Resources (Schema - From Table) to be used as Schema Source for my writer. The features that I am reading are coming with geometries like: `fme_geometry' has value `fme_aggregate' and `fme_type' has value `fme_point' OR `fme_geometry' has value `fme_point' and `fme_type' has value `fme_point'. Basicly this means that my source contains multipoint features and single point features. In my schema file I have defined the Geometry Type Value as fme_point. When the process tries to write the multipoint feature it fails with the message: Failed to write Geometry to feature class … with geometry type 'esriGeometryPoint'. The process works if I manually set the geometry output to geodb_multipoint but I w

131
francescodb
3 years ago
juanmahere
Supporter
juanmahereSupporter
asked in Transformers
How to access Portal Feature Service from Public source?

Hi all,I was wondering if the same way that I can easily access to the layer content via ArcGIS Online, ArcGIS... can be made too via FME Desktop. I've tried the "Esri ArcGIS Portal Feature Service" reader, but not sure if I needed to have credentials for authentication. The URL:https://geodata.antwerpen.be/arcgissql/rest/services/P_Portal/portal_publiek2/MapServer/83 My purpose is to only read features from that service.Thanks,

1352
juanmahere
Supporter
3 years ago
aron
Contributor
aronContributor
asked in Transformers
Count shared edges of a polygon?

I want to single out polygons that share only one edge with other polygons. In the example below the polygon circled in red has one shared edge whilst the blue polygons have two neighbouring edges.  I have tried everything I could think of using TopologyBuilder but have not found a way to separate "reds" from "blues". I can't find a useful patern amongst lists and attributes. Any suggestions on how to count how many of a polygons edges are shared with other polygons? 

603
aron
Contributor
3 years ago

Badge winners

Show all badges
30,176
Posts
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.