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).

Filter by
Sorted by
Tagged with
1
vote
2answers
21 views

FME Workbench Reader select tables to import using wildcards

In FME Workbench for various database format readers one can coose which tables to import: Because all in all I have thousands of tables, I would like to select tables that begin with certain ...
2
votes
2answers
46 views

How to handle with “no-Geometry” shapes in FME?

I have many shape files that I am reading on FME (points, lines and polygons), editing them little bit and writing back the same format. However I am having an issue that I as far as process comes to ...
0
votes
0answers
31 views

Reader character encoding problems in Oracle layers with where parameters in FME Desktop

I am using FME Desktop 2020 and trying to read an Oracle layer with -where- condition but i have problem because it failed with reading of character Ë or Ç. I get this error: ORA-01756: quoted ...
3
votes
1answer
29 views

INSERT only non-existing features into PostgreSQL/PostGIS table with FME

I have a PostGIS table of, lets say, adresses, for example id | adr | geom ---------------------------- 1 | Rathausplatz 1 | POINT 2 | Dorfstraße 2 | POINT 3 | Kirchenweg 3 | POINT ...
1
vote
2answers
33 views

Count number of features that matches a (minimum) value for each group (id)

Context In FME I want to count for each group (defined by a "group by" id in any kind of aggregation-like transformer, such as the StatisticsCalculator), how many occurrences equal to a certain value ...
1
vote
3answers
27 views

Attribute-spliter to parse a text file containing key=values into separate variables in FME

Context Using FME, I want to read a text file containing several lines of variables I already defined, given in the following format: var_name = "var value" There are many lines, each one contains ...
4
votes
1answer
40 views

Write *.sql file with FME

Is it possible to write sql files containing all the CREATE TABLE... and INSERT... statements etc. with FME instead of directly execute them against the database (here: PostGIS)? Background is that I ...
0
votes
0answers
32 views

ArcSDE - AutoIncrementing Object ID in table stored in ORACLE when doing INSERT or UPDATE or DELETE using FME SDE Writer

I have data in an Oracle table (11 million records) and would like to insert 2000 records approximately using the FME ArcSDE Writer to maintain ObjectID put on the Oracle table by ArcSDE via ArcGIS. ...
0
votes
1answer
18 views

FME Desktop 2019.2 Geodatabase_SDE writer copies Dataset parameter from reader when I said not to

I'm using FME 2019.2, Geodatabase_SDE reader and writer with different connection files. I have one database "Operations" with user1 and another database "Data_Sources" with user2. They both support ...
1
vote
1answer
43 views

FME workspace slashes ('/') missing in resulting attribute values

I have a MS Access DB table with attributes containing slashes /: When I process it with an FME workspace like (MSACCESS_JDBC reader) the slashes disappear in the resulting attributes (FME data ...
-1
votes
1answer
37 views

Convert XML files in to shapefiles using ArcGIS or FME? [closed]

I have attached a short text from XML file. Can this file be transferred to the spatial domain? How to convert XML files in to shapefiles using ArcGIS or FME?
2
votes
2answers
28 views

Rename workbench on FME Server

I'd like to change the name of a workbench I published on FME Server. I'm afraid I didn't find a way to do this. As I want to keep the history of commits I cannot add the workbench as an new file to ...
2
votes
1answer
41 views

FME - Cannot load versions in ArcSDE Geodb Writer

I'm attempting to write to a version in a 10.6.1 ArcGIS Enterprise Geodatabase with a SQL Server 2017 Backend. I have created a version in the database and I want FME to write directly to it. I'm ...
1
vote
1answer
59 views

Converting 32 bit image to 8 bit palette raster image

I need to convert 32-bit TIFF image (input) to 8-bit palette TIFF image (output) by using FME. How can I do this by using palette of output image?
1
vote
1answer
54 views

Join tables using FME

I have a line .kml which is needed to converted to shape. And I need to make a relation between "Folder" and "Placemark". I have a common field (kml_id in "Folder" and kml_parent in Placemark). How ...
0
votes
1answer
40 views

Using WMS in FME inspector

I want to use Finland national WMS map (MML Kapsi) as background map in FME inspector. Is it possible? What information is needed? WMS URL is: http://tiles.kartat.kapsi.fi/peruskartta
1
vote
1answer
37 views

FME 2017 transformer AreaOnAreaOverlayer does not have Remnants port

Remnant port of the AreaOnAreaOverlayer FME transformer does only exists on the 2018 (or newer) version of FME. However, I only have access the 2017 version for now. Do you know a way to round it by ...
2
votes
2answers
173 views

Convert geometry type from Polygon to Multipolygon using FME?

I don't want to alter the geometry, just change the geometry type from Polygon to Multipolygon, in order to comply with a constraint.
8
votes
1answer
382 views

Filtering layers in QGIS atlas

In processing several spatial data sets (tbl_data_01, tbl_data_02, tbl_data_03, etc) using FME I establish a spatial table called "tbl_metadata" with information about each of the data set. This table ...
0
votes
1answer
118 views

Generate Cesium 3-D tiles from shapefile with FME

I'm trying to generate 3-D tiles from a shapefile. Just simple shp reader directly to Cesium 3D tiles writer. It does generate files, but after uploading them to Cesium Ion it does not work. It can'...
2
votes
3answers
122 views

Running second FME workspace when first workspace is completed

I've got a workspace that inserts data in a database. It runs on FME Desktop and FME Server. After the insertion (the first workspace) is completely done, I'd like to run a second workspace that ...
3
votes
1answer
139 views

Controlling processing order in FME workspace?

I have created a workbench with 3 bookmarks: a Creator/ProjectWise connector which downloads an Excel file from ProjectWise a processing workflow a second Creator/ProjectWise connector which ...
2
votes
1answer
87 views

Transforming CAD File To shapefile (with Projection) Using FME Batch File

I want to convert files from within my application. I've tried a lot, but I can't find a solution. I have a DXF file with which I know the projection system (EPSG:4326). And I want to transform it to ...
2
votes
1answer
149 views

FME Use Output of reader in another reader

I have a ESRI geodatabase reader to read input table and i am using where clause to limit data based on date. write now i am using the user parameter to ask user latest date for input table. and then ...
0
votes
1answer
32 views

Does FME retain a log of the last run process

The hard drive where my FMW was has crashed and I was wondering if there is somewhere in the user profile or in the install location of FME that retains a log of what processes were run in the FMW? ...
1
vote
0answers
37 views

Getting geodatabase to SQL Server

I am currently attempting to load in 1000 data sets I have in 1000 different tables. I need to do this in Microsoft SQL Server. My data sources are either in Excel or geodatabases. The plan is to ...
4
votes
1answer
190 views

PyQGIS Problem adding certain vector layers to QGIS from postgres

I've created a tool to find layers from our PostGIS database based on a string match and add them to the current QGIS project. In the example below I'm searching for 'landscape' in the dataset name. ...
0
votes
1answer
81 views

Query to intersect polygons in PostGIS with points in MongoDB

Question: Is it possible to intersect geometries from No-SQL and SQL databases? Background: I need to delete the polygons from a PostGIS database that intersects with points (Lat/Long) in a MongoDB. ...
1
vote
1answer
172 views

Reprojecting ECW raster in FME gives black border?

Using FME i want to reproject an ECW image to EPSG:3857 from EPSG:28354. I intend to sit this image(and many more) over a large mosiac. Using CSMapReprojector this re-projects with a boarder. I've ...
1
vote
1answer
60 views

FME metafile multi-writer could not be opened

I run a workflow and FME showed me that message : 2019-08-23 12:46:05| 1.9| 0.0|ERROR |BADNEWS: File C:\Program Files\FME\metafile\MULTI_WRITER.fmf could not be opened (tabrdr.cpp:161) It ...
0
votes
1answer
64 views

Esri file geodatabase data migrated to PostGIS through FME becomes non-editable in QGIS

I loaded a layer (point) from Esri file geodatabase to PostGIS (PostgreSQL) using FME and when I load it in QGIS, I cannot edit the layer. Am I missing any step in FME data migration process? I used ...
2
votes
1answer
61 views

Converting tabular data with multiline string field using FME?

I have data in a table. One of the fields has pairs of coordinates. The coordinate pairs represent a point and the points joined in order to represent a line. The number of coordinate pairs varies. ...
0
votes
1answer
39 views

Replacing three parts string in FME? [closed]

How to replace three parts string with (like John Doe Street) to form where first word has only one letter like (J. Doe Street)? I am using FME (StringReplacer) so RegExp should be fine method for ...
2
votes
1answer
44 views

Turning off cache in FME?

I did not find what I am looking for neither here nor in FME Website. When I run some workflow I get that warning message (it is displayed in French I am not really sure of the accurate translation) : ...
1
vote
1answer
53 views

Seeking tutorials about GIS workflows in FME? [closed]

I have never used FME for spatial processes before. However, I would like to use it in automating some GIS processes and learn. Are there are any specific tutorials that explain this?
2
votes
2answers
70 views

FME spatial join by PointOnAreaOverlayer transformer rejects Invalid Polygon Geometry Type

I would like to perform a spatial join of points and polygons in FME Workbench by PointOnAreaOverlayer transformer. The result should be a country polygons with additional attributes from points. I ...
2
votes
1answer
72 views

Using shape to find and merge photos in FME?

We have a directory with over 300 aerial photos of our town. Every photo has an unique name. Using an georeferenced Esri shapefile of a specific area we want to copy the photos that are coverd by the ...
1
vote
1answer
98 views

Extracting Oracle geometry with FME's SQL Executor transformer

I am wondering why my SQL executor can't extract the geometry from my Oracle database. The geometry are polygons. I added the 'SHAPE' column to the query in the executor, and I exposed the attribute ...
1
vote
1answer
65 views

Accelerate Clipper, Performance Tuning

I'am using a Clipper transformer in my workbench with ~30.000 features of clippers an ~20 clippees and running it takes a lot of time. So I was wondering if there is any possibility to accelerate the ...
1
vote
1answer
83 views

In FME I want to copy all the styles from a dataset but not the geometry or attributes

I tried reading it in and exposing all the format attributes and then I connected it to the writer that does the last step of a larger process. It copies the formatting across but also the features. I ...
0
votes
1answer
68 views

Iterative execution of an FME workflow

I'm new to FME. I have a process that intersects a line buffer from Oracle with a shp stored in local. In the end there is a dissolver to reduce the number of polygons and write it in a shp. The ...
0
votes
1answer
44 views

FME Repeat features when a record matches an expression

I am working on automating the production of a land/parcel spatial table based on a state supplied cadastre (property layer) and injects from internal mssql systems. See this question for some further ...
5
votes
1answer
201 views

Getting FME to write features in order provided?

I have a simple model that just does a series of queries/data cleanups and then puts the data into a csv. Unfortunately it's being put into the CSV in a random order. How can I get it to write in ...
1
vote
2answers
54 views

Does an FME fmw file include the processed data in it?

If I share an FMW file does it include the actual data or is it just the steps in the model and links to the data sources but not actual data. Some models have links to Microsoft SQL Server databases,...
2
votes
2answers
182 views

FME Many to One to append attribute and not create new feature

I have a land cadastre spatial table where the Land_no is unique for each parcel. I am joining this to a non-spatial mssql search where the property number is repeated whenever there is more than one ...
0
votes
1answer
141 views

Limit FME regex to just the first match

In FME I have the following in the AttributeManager transformer to replace a value in a column @ReplaceRegEx(@Value(Street_Address),"^([UNITunit]*.?\d+[\/-]?\d*\w).*",\1) This should work as in the ...
0
votes
1answer
92 views

FME Querying an Microsoft SQL Server Non-Spatial to perform an attribute join

I am trying to join a spatial table with some values coming from a MS SQL table. I have it working properly with an excel but when I try to use SQLExecutor or SQLCreator I get stuck where the ...
1
vote
4answers
468 views

FME Merge two files that only have some attributes the same

I am trying to join 2 spatial files that have some but not all attribution the same. One of them (property_template.tab) has no data but has the schema that I want. The other one (cadastre_bpoly.tab) ...
1
vote
2answers
123 views

Need a specific field in FME KMZ to shapefile conversion

I am converting a KMZ to shapefile and need to see a field called "Type Name", but it is not in any of the shapefiles' attribute tables. I have every name exposed in Format Attributes in the Reader ...
2
votes
1answer
125 views

Spatially join point and polygon attributes in FME

I'm new to FME, and most of the time I work with ArcGIS Pro. I have a few building polygons, and a few points containing additional information. Now, in ArcGIS Pro I can spatially join these two, ...

1
2 3 4 5
14