Questions tagged [fme]
FME (Feature Manipulation Engine) is an ETL (Extract Transform Load) tool by Safe Software. It reads and writes a wide range of data formats and services. Loaded with tools for manipulation of vector, raster, point cloud data and also non-spatial tabular data and code (XML/JSON).
819
questions
2
votes
1
answer
53
views
Compacting table in FME?
How to compact table using FME which table has grouped by CODE and different value of class are as columns?
Before
After
- 443
1
vote
0
answers
17
views
Problems reading in JP2 files in FME [closed]
I'm trying to add JP2 files to fme and it gives me a very vague error when reading in the file. I have plenty of space and ram memory available for the process. I have also tried it on a more powerful ...
- 21
5
votes
2
answers
56
views
How to calculate distance to nearest neighbor when new candidates are created over the years?
I want to calculate distances between sold properties and the nearest wind power turbine over the years 2013-2022, in FME. QGIS is also an option. I have coordinates for them both and also dates for ...
- 51
1
vote
0
answers
40
views
Outliers in the resulting TIFF exceeding values of millions when creating a Pyramid TIFF from XYZ
I'm creating TIFF files from XYZ files, which goes well and works fine.
Now I want to create pyramids (6 levels). But for some reason the statistics are all up in the millions. Minimum and maximum... ...
- 11
0
votes
1
answer
36
views
Why are features showing up near Malaysia when using the Michigan State Plan South coordinate system?
I am using FME to write in shapefile and then read them to dwg's. The shapefiles have are assigned the Michigan South coordinate system, but show up near Malaysia when translated to CAD. What am I ...
- 9
1
vote
1
answer
43
views
FME Compare polygons from two datasets
I'm trying to compare and see what the differences are between polygons from two different datasets, they have matching unique IDs. What I want to end up with are features where the two polygons don't ...
- 11
1
vote
1
answer
24
views
Why does the FME AdjacentFeatureNullAttributeMapper not work?
I have a set of feature types for which I need to fill in some missing values. I thought the AdjacentFeatureNullAttributeMapper was exactly what I need, but when I try the dummy example from the ...
- 670
2
votes
0
answers
51
views
automatic extraction of contour lines from a scanned paper map
I'm currently trying to detect contour lines from a georeferenced raster image, which looks like this:
With the help of FME I could extract the lines very good. But they are divided at every section. ...
- 21
1
vote
1
answer
49
views
FME - SpatialRelator Transformer Settings
could you help to validate and adjust my FME workbench, please?
Input info:
Polygon layer A with counties.
Polygon Layer B with areas of the random shape that may intersect or fall inside of the ...
0
votes
0
answers
23
views
Working within FME and trying to snap newly created line features together within a certain distance of each other
I have two features, a point feature (addresses) and a line feature (fiber). My end goal is to create a new line feature from the point to the nearest spot on the existing line. I have that process ...
- 19
2
votes
2
answers
66
views
FME Loop: Many to many connection
I have two tables with lines.
The 1st table has an attribute end_point
The 2nd table has an attribute start_point
I want to join the first table with the second table (end_point = start_point).
It ...
0
votes
1
answer
54
views
How to order attributes by suffix in FME?
I have a table with attributes containing a suffix of the form _DIGIT. FME displays the table like this:
country
name_0
name_1
name_2
platforms_0
platforms_1
platforms_2
The Netherlands
Utrecht ...
- 670
1
vote
1
answer
26
views
FME: Feature Name when feature is empty
I am exporting all the feature names and the count for each in an Excel Sheet.
Enable the feature names in all features
Custom Transformer:
StatisticCalculator --> Count
StatisticCalculator --&...
1
vote
1
answer
96
views
How to transpose a list attribute in FME?
Suppose I have one feature per attribute country that is linked to a complex list attribute called stations with the sub-attributes name and platforms that looks like this:
station{0}.name Gare du ...
- 670
1
vote
1
answer
44
views
Extract polygons which contain an attribute of a list
I have a problem regarding a shapefile and a list. To make it simple, I try to depict the problem using an image:
I have a list of elements:
List_Elements={"Apple", Carrot", "...
- 119
1
vote
0
answers
59
views
Extract railroad from Orthophoto and / or LiDAR
I would like to automate the creation of a vector line from either orthophoto or aerial LiDAR data. This line (or these lines in fact) represent both sides of a railway. We can see those pretty ...
1
vote
1
answer
82
views
FME: Import an Excel table as user parameter list
I have a list of possible errors in an Excel table and I am importing it as a Reader. I run more than 100 controls on my data and I generate a txt file with the data that don't pass the tests and what ...
2
votes
1
answer
34
views
Case Sensitivity in FME Schema Mapper
I am using FME to translate data from one database to another and am using Schema Mapper to help set attribute values where needed.
Unfortunately, it appears that Schema Mapper is case sensitive on ...
- 29.4k
0
votes
1
answer
72
views
Converting geodatabase into Geopackage in FME
I have never used FME and need to convert some geodatabase files into Geopackages. So the data can be stored in a GeoServer and published online.
- 161
2
votes
1
answer
85
views
In FME: how to handle NULL values in numeric expressions as 0 using the attribute manager
i stumbled across the following challenge in FME:
how to deal with NULL values if you want to perform a calculation for a new attribute. For example, I want to sum up values (could be any other kind ...
- 323
2
votes
2
answers
242
views
How to escape an invalid character (0x1F) in an XML file?
I want to convert an XML-file to something else. However, when I try to read it using the FeatureReader, it throws an error. I'm using FME Workbench 2021.2, and read the file without any special ...
- 670
0
votes
2
answers
141
views
In FME, I want to copy a .tab file, place it in a new folder called 'GDA94 Archive' and rename the file with a prefix 'GDA94_'
I am very new to FME.
As part of my GDA2020 process, I would like to copy a .tab file from its current location, add a prefix to it called 'GDA94_' and then place it into a new folder in the same ...
- 21
1
vote
1
answer
53
views
How to consolidate FME readers into one?
I have an FME Workbench file that was built up slowly over time and has ended with many readers and many writers (each to a separate feature class), even though every reader points to the same ...
- 29.4k
2
votes
2
answers
65
views
A reader that requires a user to choose a file
I'd like to add a reader to a canvas, that instead of me already having a certain file that it is using, when run, it will force the user to add in a file.
It seems like when I add readers, I can't ...
- 21
2
votes
1
answer
88
views
Upload shapefile through GeoServer REST API?
I am trying to upload a shapefile to GeoServer over the REST API by using FME.
This should be possible with the HTTPCaller! I am using the following option: - HTTP-methode: PUT
Upload from data
But I ...
2
votes
2
answers
41
views
Run FME with subprocess Modul
This is working but i have no idear how to give user_parameter to the process.
import subprocess
args = [r"C:\Program Files\FME2021\fme.exe","test.fmw"]
subprocess.Popen(args)
2
votes
1
answer
40
views
Turn a specific attribute of all features into a list in FME
I am trying to update an SQL table using the SQLExecuter. I do have all the features the table should be updated with, but what I ideally need is a list of IDs from those features, since the only ...
- 1,167
2
votes
2
answers
217
views
FME merge features (many-to-one) with priority
I'm new to FME.
Suppose I want to join Table A to Table B based on the ID column (see below).
If table B has more features for a certain ID, than table A, I want the merger to join only the most ...
- 670
1
vote
1
answer
42
views
Does FME support block-comments via a keyboard shortcut?
Is there a way to comment out entire blocks of code in FME with a keyboard shortcut?
All keyboard shortcuts I could find were not related to scripting windows (like the PythonCaller-transformer) in ...
- 670
1
vote
1
answer
169
views
Which Python modules are pre-installed in FME?
I'm writing a script to be used in a PythonCaller-transformer in FME Workbench. I'm wondering which modules/packages are already installed during the installation of FME WB itself, and which ones I ...
- 670
2
votes
1
answer
127
views
Get emailer to send FME log files to my email address once work bench has run
I would like to receive and email with a log file in attached or in the body of the email when a workspace is run. I'm using FME Desktop. I thought about reading the logfile using a feature reader ...
- 21
1
vote
1
answer
91
views
How to point FME Feature Type to a different Reader?
I have a workspace with dozens of Readers & Writers that all point to the same database, all using the same connection. How to point all the relevant Feature Types to a single Reader/Writer ...
- 27.9k
0
votes
1
answer
29
views
Fanout feature classes in different feature datasets
I am using ArcGIS Pro 2.9 with the Data Interoperability Extension. I try to fan out different feature classes with FME. Using the "fanout dataset"-function, I manage to create multiple ...
- 15
0
votes
1
answer
40
views
Attributes generating no output using PointOnAreaOverlayer transformer in FME
I have a PointOnAreaOverlayer transformer and I wonder why the Point outpot port let's me use all attributes, whereas the Area output port generates no output for some attributes that I need to use.
...
- 93
1
vote
1
answer
173
views
FME: SQLExecutor [PostGIS Format] ST_Intersects() Not Recognized
Scenario:
[A] 5,784 polygon geometries + [B] 2,100,000 address points
Source Format: [A] GDB Feature Class, [B] PostGIS Table
Goal:
Find which address points [B] intersect with polygon geometries [A]
...
- 315
1
vote
2
answers
98
views
FME: Count crossings of roads and waterways
I have two datasets from OSM for a small region: roads and waterways. I want to count the "bridges" resp. all kinds of crossings between roads and waterways in FME. I can't find the right ...
- 93
0
votes
1
answer
237
views
How to write GML with features inside FeatureCollection.FeatureCollectionMembers element
I received a sample ready-made GML file (60 MB) along with a corresponding XSD file, with the aim of converting some of my databases to an identical GML form.
I first opened this GML in the FME Data ...
- 13
1
vote
1
answer
513
views
In FME, how can I extract the last few characters from a string where each string is a different length?
I have two string attributes, for both of which I need to extract the last 5 characters from each string. The length of the strings varies, with some 6 and some 7 characters.
In this example, I have ...
- 33
1
vote
1
answer
226
views
Split Line at Point in FME
I need to split a network consisting of connected lines in FME by points. Do you know which transformation works in FME the same way as 'split line at point' in ArcGIS. PointOnLineOverlayer couldn't ...
- 11
1
vote
2
answers
132
views
Filter Date field in the file geodatabase
I am reading data from a file geodatabase in my FME workspace. The data is huge and takes time to process. I have set up a query to only filter data that ends with .2022 but the workspaces are still ...
- 17
1
vote
1
answer
177
views
FME - Find and calculate part of area that is a rectangle in a polygon feature
I'm looking for a way to find the largest part of an polygon feature that is whole rectangle. Don't know if it make sense, but maybe the picture helps explain it.
So far I've been using Chopper with 5-...
- 13
0
votes
1
answer
81
views
GIS layers created using FME 2021 not visible in QGIS
QGIS 3.24
SQL Server 2015
I have GIS layers in SQL Server created using ogr2ogr and FME2021
All the layers are created using my machine.
In my QGIS Desktop I can see all layers irrespective of how ...
1
vote
0
answers
53
views
Find the average of pairs with the same first element in FME
I have a list of pairs in FME:
and need to calculate the average of each set of pairs with the same first element.
I came up with this code, but it takes a lot of time to paste and copy the list. Is ...
- 11
1
vote
1
answer
143
views
Combine readers for single line of processing before splitting out to writers in FME
I have a relatively simple but repetitive FME workbench where I have approx 30 readers that go through much the same processing before being written by approx 30 writers (one-to-one), something like ...
- 29.4k
1
vote
2
answers
94
views
FME unwanted conversion of RGB to palette in PNG writer
I have a pile of TIFF images (aerial photography) that I want to convert to PNG. Band interpretation of my source TIFF files is allways RGB, cp. gdalinfo:
C:\OSGeo4W>gdalinfo -mm -stats s:\ER-GIS-...
- 14.2k
1
vote
2
answers
249
views
Extending lines to edge of polygon, but not where start/end point intersects another line
I have made center line dataset from polygons. However, at the endpoints these lines didn't extend to the edge of the polygons.
So I used the FME line extender tool, to extend the lines by large ...
- 470
0
votes
1
answer
370
views
Using dynamic feature types in FeatureReader (Excel) constraints
I am new to FME.
I have 100+ Excel workbooks, each of which has 2-4 worksheets in them. To prep to do some schema mapping, I'm trying to read out all of the attribute names to a new spreadsheet (Excel ...
- 63
0
votes
3
answers
221
views
Looping through directory to use gdb with current date from folder using FME BatchFile
I created a batch file using the command line from the FME workspace and need to run it through a task scheduler. The file gdb is a parameter that needs to change in this batch file on every run. I am ...
- 17
1
vote
1
answer
219
views
Python + FME Objects : print log in the cmd
I'm running a FME Workbench from my Python script and I struggle to print the log in the cmd.
When I run the FME Workbench (from FME without Python), I got this error in the FME translation log :
2022-...
3
votes
2
answers
202
views
FME GeometryReplacer, WKT Error
I am trying to load POINT WKT Geometry from MS SQL Server, it is in WKT Format. Using the GeometryReplacer, I am receiving an Error, and everything looks right as far as I can see, it continues to ...
- 505