Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,711 Replies
10000 Posts
Y
yanyu
asked in Transformers
How to transform KML to CAD with 3D shape

Hello. I would like to know How can I use FME to transform KML to CAD with 3D shape.The first image below is my KML file in Google Earth which I use 3DForcer to generate the height of buildings.I also want to see them in AutoCAD, so I transform this KML file to DWG without any transformers.Only the reader and the writer.I refered this question:https://community.safe.com/s/question/0D54Q000080hgkVSAQ/converting-kml-to-dwg-stretches-the-original-shapeBut the result seems that there's no height line in CADI want CAD shows just what I saw in the Google Earth, How can I do that ?

1190
nampreetatsafe
Safer
fme_hans
Contributor
fme_hansContributor
asked in Transformers
Argis online feature layer writer creates wrong area?

I am reading an Oracle spatial table and writing the content to an ArcGIS Online feature layer (hosted). There are no transformers in between. The shape_area in the ArcGIS Online feature layer is larger than the actual area the object has in Oracle. there is a factor of 2.61 between them.There seems to be a new area calculation taking place in the writer writing to the ArcGIS Online feature layer that does not seem to be right.How can I prevent that? Greetings, Hans

890
debbiatsafe
Safer
A
a.engberg
asked in Transformers
Transformer to add merge spatial data set with non-spatial data set

I've got two data sets with some commonality in length data, one coming from KMZ (S1) and one a csv with no spatial data (S2). I would like to merge the datasets. S1 stores lengths as stationing with start and stop (St. 0, End 100)S2 stores lengths as stationing but more granular (St 0, End 25 etc) My first thought is to try and split stationing from S1 to match S2 then merge the geometry to S2 since that has the data I want to keep but I'm wondering if there is a way to do this I haven't come across yet. Any Ideas?

80
jkr_wrk
Influencer
M
m_breithecker
asked in Transformers
I want to find the biggest possible box inside an area, like the opposite of a bounding box. It should also be oriented.

I want to find the biggest possible box inside an area, like the opposite of a bounding box. It should also be oriented.

710
M
F
fd44nm
asked in Transformers
I am looking for a sumproduct like function in excel that i can use on data i have in FME. What i am really after is a weighted average of certain groups of data. I have the products solved for in separate fields but i can't sum within their groups

I am looking for a sumproduct like function in excel that i can use on data i have in FME. What i am really after is a weighted average of certain groups of data. I have the products solved for in separate fields but i can't sum within their groups.

240
gazza
Contributor
spiderman
Contributor
spidermanContributor
asked in Transformers
OSM Openstreetmap ,which extension should i download to use in FME ?How to use it ?

i would like to use OSM Openstreemap , i have downloaded BPF for a city from Geofabrik Download server ,is that the correct extension or which extension should i download ?  could someone provide me with an example for OSM Workspace ?and what shoud i do ? i would like to show output geographical map for polygon as Google maps . FME 2018Thanks in advance

3200
rahulsharma
Safer
ingalla
Contributor
ingallaContributor
asked in Transformers
How to split an attribute using regular expression

I am trying to split an attribute using a regular expression as there may be differences within the attribute. For Example the attribute may be as AA9A or B7BHowever some of the attributes are formatted as CC7 or DD6 I therefore do not want to remove the last character from these, all I need to extract is AA9 or B7. Is there a way with a regular expression to search for a character, potential character and then a digit?Or is there a better way to achieve what i am trying to do??Thanks in advanceAndy  

3703
hkingsbury
Celebrity
S
samgeo2
asked in Transformers
Hi, I would like to find out how to best implement the attached workflow by using the most efficient means possible. I currently have a working model, but I designed it over 6 years ago. I believe it's outdated and would like a more efficient one.

The aim is to use the current transformers that FME has to offer. Any help with this is much appreciated. Thanks,Sam

10
S
G
geohab
asked in Transformers
SQL Executor results not mapped in Schema Mapper

Hi All,I created a SchemaMapper lookup table in PostgreSQL and used it to map schemas in two scenarios.When I used ESRI SDE feature class as a reader and PostgreSQL as a writer the SchemaMapper mapped all and no problemWhen I used SQLExecutor reading from Microsoft SQL Server database that creates a query from four tables and writing to a Single PostgreSQL table, the SchemaMapper outputs the results as unmapped. I have used AttributeExposer transformer and it still didn't change. please see the screen shot below:Can anyone please help me fix the issue or let me know if I'm missing anything?Thank you in advance

360
G
axcel.fme
Contributor
axcel.fmeContributor
asked in Transformers
Cascaded polygon clipping

Hello to the community!I'm new to the FME and I'm quite impressed with what it can do and also with the very helpful tips and solutions which I read in this forum! As a newbee, I'm struggling to get the result which I want, but for most of the experts here, it's probably quite simple: I'm working with polygons which represent the chart coverages of Electrionic Navigational Charts. They are categorized into "usages" with usage 6 having the largest scale (inside harbours) and usage 1 having the smallest scale (covering entire oceans). The set of polygons is currently overlapping each other and my goal is to have a non-overlapping set of polygons - perfectly touching each other's boundaries - which give me the best chart usage at any given point. I have already created a workflow where I dissolved usages 2 to 6 and then used the Clipper to clip usage 1 with this. Similarly, I dissolved usage 3 to 6 and clipped usage 2 with it - and so forth. Doing it thi

70
axcel.fme
Contributor
S
steve731
asked in Transformers
Hi All, I have some shapefiles which include various geometry types (polygons, line, points) and they are located in different folders based on regions. I want to filter these based on geometry type . Can someone help please.

I used the Directory and File Pathnames reader to go through folders and select all shapefiles. Then trying to use GeometryExtractor and GeometryFilter to filter line shapefiles but GeometryExtractor output has no geometry. Then I'm using the GeometryReplacer to replace the geometry but again the output has no geometry and the GeometryFilter cannot filter lines.I'm very new to FME so please go easy!Thanks in advance.

9710
hkingsbury
Celebrity
bgeorges
Contributor
bgeorgesContributor
asked in Transformers
How to resize geodatabase image attachment using pythonCaller (Python 3.7)

I would like to use the PIL module to resize an image stored in a blob (geodatabase attachment table) but I cannot create the Image object from the string representation in the pythonCaller This is what I have tried so far:import fme, fmeobjectsfrom PIL import Imagefrom io import StringIO def processFeature(feature):  string_io = StringIO(feature.getAttribute("data"))  img = Image.open(string_io) #here I have the following error: Python Exception <OSError>: cannot identify image file <_io.StringIO object at 0x0000000007CE4438>   img = img.resize((1000, int(round((width / float(img.size[0])) * img.size[1]))), Image.ANTIALIAS) I have the following error Python Exception <OSError>: cannot identify image file <_io.StringIO object at 0x0000000007CE4438>   

350
bgeorges
Contributor
topotoma
Contributor
topotomaContributor
asked in Transformers
HTMLExtractor - How to extract a specific value of a table in HTML page

Hello Community, I am trying to extract values of attributes in a table that is in a HTML page.Actually the table is updated every 20 minutes or so on this URL:  https://www.hydrodaten.admin.ch/fr/2174.html The table looks like this:I have tried to use a HTML Table reader but unfortunately the attributes names contain also a date / time and they are changing all the time, so if I extract it at regular intervals, it doesnt work anymore as the field name will have changed in between:  Then I have tried the Http Caller + HTML Extractor but I can't figure out which CSS Selector I should use to extract the values of the table. Here is the HTML part of the webpage that contains the information I am looking for: <div class="horizontal-scroll-wrapper"> <table class="table table-bordered table-narrow">  <thead>  <tr>   <th width="30%" scope="col">Mesures</th>    <th class="text-center" scope="col&q

4986
chrisatsafe
Contributor
dannymeus
Contributor
dannymeusContributor
asked in Transformers
Mosaic raster files loading into an ArcSDE Geodatabase Failed

hello everyone, I'am trying to load a mosaic raster into aan ArcSDE Geodatabase. I made a simple workspace (build 20825) white a GEODATABASE_FILE_RASTER_DATASET reader and GEODATABASE_SDE_RASTER_DATASET writer.   These are my settings of the writer:When I publish this workspace to FME server (same build 20825) and run I get the following error:   73 2021-6-11 07:57:48 | A default z-value of '0' will be used for all 3D features where z-values are not provided74 2021-6-11 07:57:48 | Geodatabase Writer: Not simplifying geometries being written to the Geodatabase75 2021-6-11 07:57:48 | Transactions are being used by the Geodatabase Writer76 2021-6-11 07:57:51 | Failed to write raster data tile when writing to raster dataset 'GEO_OWNER.AHN3_TEST_FEMSERACC'. The error number from ArcObjects is: '-2147155566'77 2021-6-11 07:57:51 | Storing feature(s) to FME feature store file `D:\Applic\Safe Software\FME Server\resources\logs\engine\current\jobs\0\job_172_log.ffs'78 2021-6-11 07:57:51 | +++++

450
g_karssenberg
Contributor
V
virre
asked in Transformers
Reprojector not uniform

Hi!In a project, I want to plot the bounding points of an area onto a map. To do that I am mainly using the Featurereader to grab the map from a WMS using said bounding points (as a polygon). In order to do this to grab the map, I need to change the coordinate system. Thats why I'm using a Reprojector to convert from the national coordinate system SWEREF991800 to EPSG:4326, which is the proper one for the WMS.The operation kind of works, I manage to grab the map including my bounding points, and I can confirm it is the correct area. However, the reprojected points and the WSM appear scaled in the X-axis, instead of being almost a square. Please see the attached pictures. Why am I seeing this, is it a Reprojection problem?

70
V
mattebridges
Contributor
mattebridgesContributor
asked in Transformers
Error with SQL Executor - query executes correctly in Microsoft SQL Server Management Studio.

Hi - I'm trying to run a SQL query on a MS SQL Server database using a SQL Executor in an FME Desktop workbench. The SQL query executes successfully in SQL Server Management Studio but fails in workbench. I'd be grateful for any advice on this. The SQL Executor returns the following error: Provider error `(-2147467259) Unknown token received from SQL Server' The query is quite long so I wouldn't expect anyone to try and identify the exact problem but would be grateful for any ideas on where to start looking and an explanation of what the error basically means (i.e. what is an unknown token?). Thanks for any advice you can offer. 

8960
mattebridges
Contributor
sunsilk11
Contributor
sunsilk11Contributor
asked in Transformers
Json Query

Hi, I have a json string, which I have flattened to a bunch of attributes (about 30), all have values 0 or 1. I'd like to query each attribute and output the list of attributes which have value 1 only. All of the attributes may be 0 for some records.Any suggestions what's the best way to achieve this. I could use a stringConcatenator, and find whether 1 exists, but it wouldn't give me list of attributes

2600
geomancer
Evangelist
F
fst
asked in Transformers
moving coordinates of polygon

Hi,I've a polygon/square ( 4 corners). The leftside should be extended to 2 metres to the left/east. I tried offsetter, but it moves thecomplete polygon. I only need 2 points/coordinates).Is this somehow possible?

1060
A
rmcgregor
rmcgregor
asked in Transformers
Workspace Runner and Locking

I'll start simple and add detail as necessary. I am working with the workspace runner. I have a table that I want to select unique values on and export as separate point feature classes (a simple iteration).I have four unique values on 200,000 ish records.I have set up a workspace runner and plugged it into a unique attribute logger that creates the four values I want to use to make feature classes.It is being so finnicky I don't know where to start. Usually, it will create the first feature class, but with not nearly enough records - and not make the other three. The log file usually will say a lock caused a crash.However, it works perfectly sometimes and I can't figure out why. At noon I thought I was in business, after a good run. By 5:00, I was stumped. I set 'wait for job to complete' to 'yes' and it seems like it made all four feature classes four times - way too many records and it took forever.Is there a way to control locking? I don't know why i

450
rmcgregor
sunhenry617
Contributor
sunhenry617Contributor
asked in Transformers
Extract polygon with certain width

I need help with ideas on how to extract areas where the width >=1.1m within a polygon. I have attached a file (file geodatabase) here for anyone who wants to give it a shot. It is a long and skinny polygon reflecting sidewalks with curb and gutter all connected together in reality.I have a solution working okay for a small number of such polygons. But it is not working efficiently enough for a large number of records. I have a total of more than 20,000 records to be processed.Please share your thoughts.Thanks!

990
H
S
spirou01
asked in Transformers
Can I set "lower case Table Name" in PostGIS writer parameters, produced with "generate workspace" workaround

Hi. I want to transform data from Oracle spatial to PostGIS. There are over 100 classes to transform. That's why I go with the option "generate workspace". For the writer I choose a PostGIS connection. In the Parameters I have to click the option "lower case attributs name". The same I need for the table name. If the table name is in uppercase letter, I'm not able to open the PostGIS database anymore. If I manualy set it in lower case letter, it works. But there are over 100 writers. Is there a posiblitity to set that generaly? To choose the function "import feature tye" is no option. In this case there is a lower case table name, but reader and writer attributes doesn't finde eache other.

110
chrisatsafe
Contributor
jbradfor
Contributor
jbradforContributor
asked in Transformers
BigQuery Reader SQL with regexp_contains fails before execution

I have a SQL statement that contains a regexp_contains.  It works fine in BigQuery SQL Editor, but FME chokes on it before it even executes it in BiqQuery.  Even if I comment out the statement it still throws the same error unless I remove it completely.regexp_contains(table1.col1, '^[[:digit:]]+$')Do I have to escape this somehow? Error :Using Java Reader Interface Version 2.0 (Oct 31, 2000) with module GOOGLEBIGQUERY to read dataGoogle BigQuery: Using billing project xxxjava.lang.IllegalArgumentException: Illegal group reference

240
jbradfor
Contributor
D
davidlan
asked in Transformers
FME AR: Using google drive on iPhone 11

Hi,I am able to use iCloud as data provider in the FME AR app, but when I try to open the same file in Google Drive the file is greyed out.Does anyone else have the same problem? Read More ( vietnamese languae ) : thay pin iphone 11 and more sửa iPhone hcm

50
andreaatsafe
Safer
judy_fme
judy_fme
asked in Transformers
I have FME case C657637 generated yesterday. but is any support to open the case?

I am new for FME actually. I have FME case C657637 generated. but is any support to open the case? it is about dissolving line segments.

40
judy_fme
K
kcarlsonham
asked in Transformers
SpatialFilter

I want to filter out duplicate points from two point feature classes, however, every SpatialFilter configuration I have tried returns the duplicate points as failing all predicate test. Am I missing a configuration step?

290
K

Badge Winners

  • Welcome Back
    nataliarojashas earned the badge Welcome Back
  • Integrate Spatial Data
    dezuviriamhas earned the badge Integrate Spatial Data
  • FME Form Basic Training
    johnrochehas earned the badge FME Form Basic Training
  • FME Form Advanced Training
    sahan969has earned the badge FME Form Advanced Training
  • Student (Bronze)
    marionmahothas earned the badge Student (Bronze)
Show all badges

Community Stats

31,800
Posts
120,801
Replies
39,417
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.