Questions tagged [fme-form]

Form (previously know as FME) is an desktop ETL tool from Safe Software.

Filter by
Sorted by
Tagged with
0 votes
1 answer
240 views

Quick Import FME Reader Gallery Not Populated with FDS (ArcGIS 10.5 Adv Licence)

I wanted to import GeoJSON files, but after installing the Background GP and Data Interop packages, I find that the FME Gallery contains only GML and WFS formats. This is with both ArcGIS 10.4 and ...
1 vote
1 answer
25 views

Deleting features based on matching attributes in Feature Service using FME (similar to row selection)

I am trying to recreate something I successfully did using geodatabases, but I want to edit in a Feature Service on Portal instead. Essentially, I am performing bulk edits in a feature service by ...
0 votes
1 answer
30 views

FME discard destructive operations in the table handling drop-down list for PostgreSQL / PostGIS writers

In FME 2023, one can use a PostGIS writer to write some spatial data to a PostGIS database and that's great. In the table section, one can select one of several Feature Operations: When using upsert ...
0 votes
1 answer
35 views

FME restart identity sequence when using Truncate Existing in the writer table handling drop-down menu

In FME 2023+, when using Truncate Existing in the Table Handling drop-down list in a PostgreSQL/PostGIS writer, is it possible to reset the numbering sequence associated to the primary key when this ...
1 vote
1 answer
333 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] ...
1 vote
1 answer
43 views

FME Counter transformer - Assign a grid with numbers, change order that features are counted

I have a 100x100 grid made up of square (1x1) polygons. I would like to assign each square a unique number. I have used the Counter transformer in FME, but this assigns the numbers in the grid ...
0 votes
1 answer
21 views

Write a raster to an Esri ArcSDE geodatabase using FME

I would like to write a raster (ECW) to an Esri ArcSDE Geodatabase using FME. I think this should be possible as I have been able to copy and paste the raster layer in ArcGIS from it's original ...
4 votes
2 answers
5k views

Center Point On Line in FME

I have a line feature. I need to create a point feature from it. The point should ideally fall at the center of the line. I used both CenterPointReplacer and CenterOfGravityReplacer but in some ...
-1 votes
1 answer
44 views

FME Postgres Serial - Red Attribute

I have a small table of wells with just a name, lat, lon, and geometry in an Esri Shapefile. I am putting them into a PostGIS database and it works well, so I added an arbitrary well_id as a serial ...
0 votes
1 answer
27 views

How to make labels in AGOL look exactly the same as they do in ArcGIS Pro

I recently prepared a very good looking map with labels in ArcGIS Pro (v3.2.1) and published it in AGOL. Now in AGOL labels are not looking the same way as they do in ArcGIS Pro! How can I export my ...
2 votes
1 answer
209 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. ...
5 votes
3 answers
2k views

Reprojecting raster with FME?

I have multiple .tiff + .tfw files in EPSG:3067, which I need to reproject to EPSG:3878. I tried to do it with FME, and succeeded, kind of. The geotiffs are placed well, but some weird white area ...
1 vote
1 answer
291 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 ...
1 vote
3 answers
102 views

FME DateFormatter is not correctly setting white spaces to null and DateTimeConverter doesn't offert this option

Using FME(R) 2023.1.1.1 (20231011 - Build 23636 - WIN64) at the time of writing, I'd like to format a date field from an Excel spreadsheet into an ISO date which should then be written to a PostgreSQL ...
3 votes
0 answers
75 views

FME PostGIS reader results in a data set with no geometries

Using FME(R) 2023.0.0.1 [build:23288] (the same behaviour occurs on 2023.1.1.1 [build:23636]) at the time of writing, I'm facing a severe bug(?) with a PostGIS reader. Indeed, when connecting to a ...
1 vote
1 answer
199 views

Merge overlapping portions from two polygons to one or the other using FME

I have a shapefile with many polygons, of which some portions overlap. When I use the AreaGapAndOverlapCleaner, it disconnects the overlapping portion, but makes it an independent feature with data of ...
7 votes
6 answers
2k views

Determining if polygon not enclosed by other polygons [closed]

Does anyone know of a routine/function or transformer that would identify if a polygon is not fully enclosed/surrounded by other polygons? The polygons have no gaps or slivers between them so if a ...
0 votes
1 answer
355 views

Where to place workspace runner while running second FME workspace inside another workspace?

Case 1 : I am facing issue is when I placing WorkSpaceRunner at starting it taking all records which is not required but files are getting generated(Output is getting as per expected). Case 2: ...
2 votes
1 answer
1k views

Merge DWGs to 1DWG and put all corresponding objects to one new layer named as the original filename

​I have 1000 dwg that has text and lines on 2 layer, i want to merge them all in one dwg and the final dwg should have as layer names all the filename and all the objects (text,lines) should be in ...
2 votes
3 answers
534 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 ...
0 votes
0 answers
20 views

Displaying Multiple Results in FME with a Spatial Intersection

I have a workspace that outputs planning scheme data against properties. Quite a few properties have multiple overlays and some have multiple planning zones. However, I am finding no matter which ...
0 votes
1 answer
894 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 ...
0 votes
0 answers
30 views

Revit pipe to GIS automated junction connection using FME

I have a revit model of pipes network having fittings and valves and network. I can export the pipes using FME workbench as 3D polylines and junctions as 3D points. How can I snap polyline edges to ...
2 votes
1 answer
41 views

Calculating area of vegetated areas within building buffers in FME

I have two feature layers, buildings buffered with 50 meter and a polygon layer containing vegetation occurence. I want to compute the area of vegetation within each 50 meter buffer. How do I go ahead ...
5 votes
2 answers
693 views

How to find points that lay on polygons in which another point layer exists by using FME 2021?

I have 3 point feature classes (A,B and C) and 1 polygon feature class. I am trying to extract only features from feature class A that lay inside polygons which already containg features from feature ...
1 vote
0 answers
45 views

Reprojection from EPSG:4167 to EPSG:2193

I have PostgreSQL database with defined EPSG:2193. WMS service that I need to use and upload data from it is in EPSG:4167. https://data.linz.govt.nz/layer/105689-nz-addresses/ https://data.linz.govt....
3 votes
1 answer
365 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 ...
0 votes
2 answers
178 views

Writing multiple geometries to Interlis using FME

I have to write Features with more than one geometry to interlis. In the Interlis model there is a class which has an optional second geometry as an attribute. Enabling the (Oracle-) Reader to read ...
2 votes
1 answer
564 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 ...
0 votes
1 answer
37 views

Using FME Stringpadder

Trying to use this in a workbench and not getting the output i'd expect, i.e. no apparaent padding in the output. The SAFE documention seems inadequate: https://docs.safe.com/fme/html/FME-Form-...
1 vote
1 answer
591 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 ...
1 vote
2 answers
170 views

Translating custom coordinate system for MyCoordSysDefs.fme

I have a custom coordinate system that I was confused how to translate it to the MyCoordSysDefs.fme for use in Safe Desktop. Here's how it is represented in the prj file: GEOGCS['GCS_ETRS_1989',DATUM['...
2 votes
1 answer
1k 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'...
1 vote
1 answer
3k views

How to Export Shapefile Attribute to Text Layer in CAD Using FME

How can I export a Shapefile's Attribute to Text Layer in CAD Using FME. For example I have a Shapefile of Parcels and it contains a ParcelID field. Now I would like to display that field attributes ...
0 votes
1 answer
77 views

FME data conversion from CityGML to GeoJSON results in multiline not multipolygon

I am using FME to convert my CityGML data into GeoJSON format to import it my 3D mapbox application. Mapbox uses extrusions to visualize 2D GeoJSON objects in 3D with their height values. (https://...
3 votes
1 answer
83 views

SR-ORG:8369: _MI_0 - What coordinate system is it?

I have a TAB file with strange coordinate system. QGIS shows coordinate system as unnamed: But places objects in the correct place on the map. FME (2023 version) recognizes it as _MI_0. I have found ...
0 votes
1 answer
62 views

Install FME Server on 2 nodes sharing the same FME Flow System Share and FME Flow Database (PostgreSQL SQL DB)

Is it valid to install FME Server (version 2023.1 Build 23619 x64) on 2 nodes (2 separate express installs) with both the nodes sharing the same FME Flow System Share and FME Flow Database (PostgreSQL ...
1 vote
1 answer
92 views

FME Server - Can't Enter to FME GUI

I have an issue with FME Server. I can't entre GUI under admin user. I was doing some work in there, while it got freezed. (I resubmitted running job). I decided to log out and log in. After that I ...
3 votes
3 answers
2k views

FME-pass the parameter to the reprojector transformer

Let me describe the scenario. I have to make a statistical maps for a bunch of countries. The FME workbench is going to use ESRI Reprojector to reproject the shape of given country to Lambert ...
0 votes
2 answers
3k views

Correct SQL statement in FME?

I am trying to write SQL statement in WHERE Clause FME in Navigator but it does not work. WHERE Clause: NAME IN SELECT CONCAT(''$(',SELECT REPLACE ('Roman Ann Jack',' ',','),')'') This sql code ...
1 vote
1 answer
51 views

How to write AGOL data into an Excel sheet using FME

I am using the AGOL feature service reader to read in the data and then writing to an Excel file. In the Excel writer parameters I have set the template file and sheet and set the mode to "update&...
0 votes
1 answer
136 views

FME Form (Desktop) - Dissolver Transformer Generates Redundant Remnants

I have line geometry that I buffered with 50 feet buffer. Now I need to dissolve common boundaries for overlapped polygons, to reduce the size of the file in general. Source lines Buffer "...
1 vote
1 answer
54 views

FME Form - Measure FME transformers execution time in the FME workbench

One of my FME workbenches takes too long time for processing data. I am trying to optimize it. Therefore, looking for the stage where data being processed the longest. Is there a way to measure ...
2 votes
1 answer
238 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 ...
1 vote
1 answer
90 views

How to get a notification or email through FME desktop or FME server if downloaded table all the fieldvalues are "NULL"

Every week, I download a CSV table from an FTP server, which contains a variable number of rows ranging from 700,000 to 800,000. This CSV table serves as the foundation for subsequent data processing ...
1 vote
1 answer
25 views

How to use a shared .py file across multiple workflows in FME? [closed]

I have a python methods "toto" that I would like to use in multiple FeatureProcessors of multiple workflows. In FME (2023) options O added a new shared folder and put there my python file (...
1 vote
1 answer
510 views

Fetching the geometry and attributes from PostgreSQL Using FME Workbench

I have 2 fetching administrative areas one inside the other. For that, I am having servers to get the data. When I am running anyone query in SQLCreator, it is working fine separately, but while ...
0 votes
1 answer
112 views

Set value to a new created (named ID) attribute for an Excel writer with number format in FME

I modified the schema of my Excel writer and now I have some new attributes one of which is ID and it must be number. Then I added an attribute manager to set value to my new attribute. I am trying to ...
2 votes
2 answers
460 views

Cannot read PostGIS RASTER into ArcGIS using the interoperability extension, either directly by Query Layer

This post Accessing PostGIS raster data using Query Layer in ArcGIS Desktop? was created in Jul-12. Since then, I have not found any other related-post published. Using QGIS with DBManager ON, my ...
1 vote
1 answer
174 views

FME issue while updating AND inserting data in Esri Geodatabase (File Geodb) writer

I have a geodatabase file to update with FME Desktop : some features must be updated, et some new features must be inserted in that geodatabase file. Those features are polygons with several ...

1
2 3 4 5
18