Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,717 Replies
10000 Posts
A
arthur
asked in Transformers
How to process many .dwg files

I need to combine the attached drawings following this procedure:drawing A contains geometry);drawing B contains some attributes defined in AutoCAD with the ATTDEF command, but doesn't have any geometry featuresHow can I build, inside FME, the drawing C using the geometry stored in drawing A and the attributes defined in drawing B?How can I extend this kind of workflow to have in input an entire directory (in which there are hundreds of .dwg files) instead of a single drawing A?So far I tried toconnect directly a reader and a writer, setting drawing B as template file but it didn't work.Thanks for your help.

110
A
L
lizzygradidge
asked in Transformers
convert tiff to pdf

How would i go about converting single tiff and multipage tiffs to pdf?

830
L
L
laimonasliskaus
asked in Transformers
How to convert heights from WGS84 to CGVD2013?

Hi, I need to convert some heights from WGS84 (GPS) to CGVD2013. I am trying to use CsmapReprojector and for vertical handling I used Geocentric or ellipsoid height -> Orthometric height and selected BCGG2013-ITRF2008_CGVD2013.gdc height grid. But I have no idea if this is the correct way to go.  Thanks!

740
palhermans
Contributor
akeeri
Contributor
akeeriContributor
asked in Transformers
Identification of coordinate system

HiI use FME mostly for conversion of dwg/dxf/Shape files and changing their coordinate system with the help of GtransReprojector In Sweden all the county’s have different types like, SWEREF 99 15.00, SWEREF 99 14.15 SWEREF 99 16.30 SWEREF 99 18.45 and so on and we use SWEREF 99 TM Sometimes I haven’t been told the source coordinate system and I have trouble finding (guessing) what it isIs there a way that I can identify the source coordinate system with the data inspector or any other tool?

610
palhermans
Contributor
J
joe_gerner
asked in Transformers
Zip mutiple GeoPackage files

Hi,I have multiple GeoPackage files with different schemes.I want to store them in a zip folder, but in separate GeoPackages not in one.Which transformers can I use for that? Thanks and best regards? 

200
david_r
Celebrity
A
alex_chris
asked in Transformers
python scripted private parameter not parsed as code

I am trying to create a simple scripted parameter that creates a unique random id to insert into a DB for reporting purposes.I am following step by step the example in the FME help pages:https://knowledge.safe.com/articles/60080/python-scripted-parameters.htmlI create a variable and I assign to it a UUID using the python module (interpreter 3.4+)https://docs.python.org/3.4/library/uuid.htmlimport uuidimport fmecustom_uuid = str(uuid.uuid4())# I tried both with and without conversion to string # custom_uuid = uuid.uuid4()return custom_uuidFME workbench does not read the parameter as the result of what is returned in the script, but reads the text of the script (adding some custom FME tags).See from logger:Logger: UUID is: import<space>uuid<lf>import<space>fme<lf><lf>custom_uuid<space>=<space>uuid.uuid4<openparen><closeparen><lf><lf>return<space>custom_uuid<lf>what I am doing wrong for FME not reading the retur

390
david_r
Celebrity
jugoslaviaa
Enthusiast
jugoslaviaaEnthusiast
asked in Transformers
Search Envelope value changes depending on the filter

Hi, I have polygon datasets, where I would like to filter one object based on id and I would like to set the parameter of Search Envelope based on this filtered object. I will extract the bbox of the polygon. How can I pass these values to Search Envelope? Thanks in advance.  Best, N

150
jugoslaviaa
Enthusiast
bjudes
Enthusiast
bjudesEnthusiast
asked in Transformers
EPSG 29903

Is the naming of EPSG 29903 incorrect? On the website https://epsg.io/ , EPSG:29903 is labelled as TM75/ Irish Grid. Whereas within FME EPSG:29903 is labelled as TM65 (See below). I understand the epsg.io is correct (but I may be wrong). Thanks for the help. Bepsg.ioFME

1260
bjudes
Enthusiast
gogopotter90
Contributor
gogopotter90Contributor
asked in Transformers
change values in attribute that has has the same values in another attribute to new value

  ID DIESEL last 1 2 2 23 5  4 5  5 3 1 1 1 6 5 10 3 2 1    i want to check for every id ,if it has a value in last attribute or not if it has soit should check also if this id is repeated in same attribute ID or notif yes so it will check which value in last attribute that it hasbcs both of them has the same id so i want to take the two values that it has found as example above 1 and 2and search in Diesel attribute which contains 1 and 2 and change to new value say 15 but it is important the new value not include in Diesel attribute any number does not matter but new value not include in diesel attribute but if the id has only one value in last attribute and no common id in id attribute soi want to take this value and change all value that has the same number in Diesel attribute to new value not included in diesel attribute . I spent too much hours with if condition in attribute manager and attribute creator and null attribute mapper but no success .could u guide me ,how could i do th

1600
gogopotter90
Contributor
gisgeek
Contributor
gisgeekContributor
asked in Transformers
Renaming fieldnames

I have census data in csv format and would like to rename several fields. Basically I want to rename fields by renaming specific words Private to Pvt, Dwelling to Dwlg. I also want each word in Proper case so the fieldnames aren't so long. Hopefully someone can help me with how to tackle this.

600
bwn
Evangelist
F
fmeuser99
asked in Transformers
Angle between intersections

I have a road network where I have to find intersections with more than 2 streets. I used Intersector to find nodes and filtered nodes with more than 2 overlaps, eventually finding intersections with more than 2 streets. But this approach has resulted in finding undesirable intersections marked as cross in attached image.To avoid those intersections I decided to find angle between lines. I cannot use AzimuthCalculator as I don't have a previous WB referencing this transformer. I used PolylineAnalyzer but it outputs angle between segments and not lines. Is there any way I can filter out these undesirable intersections?

2070
bwn
Evangelist
W
woody
asked in Transformers
pivot table rows into columns

Hi  i'm trying to pivot (transpose) some data, but all the examples i can find on here turn rows into columns, and i want to turn columns into rows.  DATA   RegionUnder 1616-1718-1920-2425-3435-4445 and overDurham572025263520Darlington351827284425Gateshead8152535262835 what i want it to look like RegionAge BandValueDurhamUnder 165Durham 16-177Durham18-1920Durham 20-2425Durham 25-3426Durham 35-4435Durham 45 and over20DarlingtonUnder 163Darlington16-175Darlington18-1918Darlington20-2427Darlington25-3428Darlington35-4444Darlington45 and over25 etc. Any help in much appreciated.  ThanksMark 

590
M
salvaleonrp
Enthusiast
salvaleonrpEnthusiast
asked in Transformers
JSON Result contains schema array and features array - how can I use the schema array to expose attribute names when I flatten the features array

The gist of the problem was defined in this question. https://knowledge.safe.com/questions/46298/how-can-i-easily-expose-attributes-from-xmlflatten.html In my case the JSON has the schema (name, alias and field type of a feature). Shown below.Sample attached.I got the schema array in rows.I have feautes JSON fragmented with json["features"][*]["attributes"] with the following output.Instead of exposing each attribute one at a time or importing a temporary csv file created by aggregation, i'd like to use the schema from the fields array for the features output.Hope to get some ideas to use using derived schema in my workflow.Thanks!

1260
salvaleonrp
Enthusiast
B
binabina
asked in Transformers
How can i create a 3D City Model from 2D polygons?

Hey,I have polygons with a height information (in meter) in the attributes. (Those are buildings) How can I use this z value (height) and create a 3D model from my polygons?  For some Objects i dont have the height information, could I set some default height for all of the Objects which do not have any hight information? - if yes, how?  Kind Regards!

1860
B
R
robertdbuckley
asked in Transformers
how to use regex to capture string and create attribute

I am trying to find a string with regex and put it in an attribute. I have used the stringReplacer, but this means I would have to search for what I don't want to capture and replace it with nothing so that what is left is the string I want to capture.It seems as though capture-groups do not capture strings for subsequent use in fme.     

640
david_r
Celebrity
lambertus
Enthusiast
lambertusEnthusiast
asked in Transformers
Select by location - along a line

Hi,For my current task I have a road network (purple lines) and 2 datasets with points.Dataset 1: green pointsDataset 2: red pointsWhat I want to do now is to select points from dataset 2 which intersect or are close to dataset 1. See the attached figure for examples.However, I want to limit my search for the test 'are close to' within a single line. The FME method/tool should not look at points which are postioned at parallel running lines. In the figure below I do not want to select the red point indicated as 'not intersecting'. There are green points closeby. However, they aren't postioned at the same line which should be the case to be considered as a closeby points.I tried something with the NeighborFinder. This works fine. Only situtations like the one below I did not solve yet. Any suggestions? 

1630
ebygomm
Influencer
T
tonyjordan
asked in Transformers
Why do I get Warning and "Assumed Default" when Translating from GDA94 to GDA2020

I have started testing of translating our data from GDA94 to GDA2020 in preparation for Australia's new datum change. I have tried a simple translation however have a 'Warning' in the FME translation process saying "MapInfo does not support datum/ellipsoid GDA2020 -- assuming default of WGS84", why?? How do I correct this?

650
andreaatsafe
Safer
S
stef1_dnd
asked in Transformers
Can we Add DTED2 (elevation data) to an OGC GeoPackage (tiles)? If yes, what is the work flow? Thanks.

I am new with FME and I have been testing several GIS software to add elevation data to a GeoPackage. No luck so far and I was wondering if FME had the capabilities to do it. Thank you

100
M
jhu_20
Contributor
jhu_20Contributor
asked in Transformers
SQLExecutor does not work when getting a list of values

I am trying to pass a list of API and Date values from a StatisticsCalculator to a SQLExecutor to execute a joint query from a SQL Server database, and it does not work for me. The following is my query inside SQLExecutor, and I cannot get any results. Please help. Thanks in advance.SELECT a.PROPNUM,LEFT(a.API,10) as API100, a.WELL_NAME,a.AREA AS [MGY_AREA],a.RSV_CAT,a.STATE,a.COUNTY,a.OPERATOR,b.[D_DATE],b.[GAS],b.[OIL],b.[WATER],b.[FTP],b.[CSG],b.[CHK]FROM [dbo].[MAGNOLIA_AC_PROPERTY] a, [dbo].[AC_DAILY] bWHERE a.PROPNUM = b.PROPNUM and a.API = 'value@(API10)'

800
steveatsafe
Safer
ingalla
Contributor
ingallaContributor
asked in Transformers
Point on Area Overlayer

I know i am missing something obvious here, but i need to select all of the polygons containing points. I have tried the point on area overlapper which works fine for those polygons containing only one point, but if it contains more than one point it will only select the polygon once.How can i export the same polygon with the merged data for each point the is selected?I.e. 3 points = 3 polygons albeit the same geometry but different attributes.Thanks for your help?Andy

190
ebygomm
Influencer
K
kees_v
asked in Transformers
can a primary key be a timestamp value

I am reading from a postgresql database. Attribute [publication_time] has a primary key and type timestamp. In the postgresql database this attribute has values, but FME 2018.1 inspector shows no (blank) values.Can timestamp as primarykey be the cause? Kind regards Kees 

3820
K
I
ivdkooij
asked in Transformers
RegEx help needed. Separate one attribute into four attributes

I'm new with FME. I have one attribute with this value "Zonne-energie in woonplaats vermogen 0,2394 MW, beschikte productie per jaar 227,43 MWh, looptijd 15 jaar. Het project is nog niet gerealiseerd (peildatum januari 2020)."I want 4 values out of this values and put them into 4 attributes.- 0,2394 MW into VERMOGEN- 227,43 into PRODUCTIE- 15 into LOOPTIJD- januari 2020 into PEILDATUMI want to use StringSearcher but i don't what Regular Expression to use. CWho can help me?

45
I
mikiekelly
Participant
mikiekellyParticipant
asked in Transformers
Georeference IFC File

I have IFC data that originally used a local cartesian coordinate system. It originated in Navisworks and I used Intergraph Smart Interop Publisher to convert it to IFC format so I could use it in FME. I want to use the data in GIS software (ArcGIS Pro/Online) so will likely convert to multipatch/revit.What is the best approach for georeferencing this data/working out control points, etc.? Some of the IFC files are quite large (500MB+). Any suggestions appreciated!

3350
mikiekelly
Participant
P
prpa_gis
asked in Transformers
Conversion from file geodatabase raster to TIFF

I have an orthophoto in ESRI GRID format stored in a file geodatabase. It works really well in ArcGIS and ArcGIS Pro; however, I need to convert this image into a GeoTIFF for a contractor that does not have an ESRI based GIS. I have tried to do this in ArcGIS Pro but I keep running into resolution and grainy output problems, and the documented fixes and remedies are not helping.  As I have FME Desktop, and I have seen that FME is capable of converting raster imagery from one format to another, I thought I would give that a try...but now my output is even worse than before.  Not being one to give up I thought I would come here to see how I should approach this using FME. Is there a trick to converting raster images? I thought it would be something quite straight forward (e.g. Geodatabase raster reader --> TIFF writer), but obviously the process will be a little more complex than that, at least this is my current thinking.What is the best way to convert an image from one format to

4390
P
fikusas
Contributor
fikusasContributor
asked in Transformers
Multiple files to read as a parameter

Is it possible to read in multiple files from a parameter with FeatureReader? For example:C:/some_path/fileA.shpC:/some_path/fileB.shpSourceDataset parameter value would be: C:/some_path/fileA.shp,C:/some_path/fileB.shpBut this approach doesn't work, it gives an error.

112
fikusas
Contributor

Badge Winners

  • Welcome Back
    arxit_cbuhas earned the badge Welcome Back
  • Integrate Spatial Data
    remcodigireghas earned the badge Integrate Spatial Data
  • FME Form Advanced Training
    jvadvianhas earned the badge FME Form Advanced Training
  • Teacher (Grey)
    lenabaghhas earned the badge Teacher (Grey)
  • Webinar Watcher (Grey)
    aqueehas earned the badge Webinar Watcher (Grey)
Show all badges

Community Stats

31,818
Posts
120,840
Replies
39,446
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.