Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 12,595 Posts
  • 50,447 Replies
12595 Posts
Z
z77
asked in Transformers
Raster size

Hi, I have a problem with outputed raster size and i am trying to find best solution for it on behalf of quality and size. I tried to play with compression, but it does not help as expected (it helps but I need less size of file). Of course, played also with interpolation methods at the same time. I found transformer RasterResampler, but do not understand how it differs from compression using featureType parameters. Is that the same thing actually? Kind regards,

3
Z
11 years ago
D
dr_ysg
asked in Transformers
Monitoring progress of a Spawned FME command Line workspace

I am spawning the execution of an FME workspace from (running FME.exe from .NET System.Diagnositcs.START() ) works fine and I can catch the errors and the completion.  Now the issue is that this is acutally a long running job (I am using WebMapTiler to create about 5K - 25K PNG map tiles). It can take up to 10 minutes to run.  I would like to provide status messages to the spawning .NET program (let's caller it spawner.exe) and the workspace that it spawns MakeTiles.fmw. I am using FME Desktop 2013 (Budget will not handle FME server, since we would need hundreds of engines. Besides it is overkill for what the sponsor wants).  I want messages of the format: "Created 456 of 5,674 tiles" "Estimated completion in 5.32 minutes"  I can think of three methods, but I need more information on how to do this (or which one is the best).  1. Polling the log file I can have spawner.exe do a 2-5 (sec.) repeating read/parse of the FME log file. I see the log does provide a har

4
D
11 years ago
G
geokarta
asked in Transformers
Problem with aggragation of features at the same position

Hi folks,   I’m trying to store in a geodatabase all points from a layer that shares the exact same location. These points are before aggregate in order to have only 1 point to represent the share location.   My workspace works well, but when I execute it, even if the FME log tells me that only 7598 points has been inserted in the database, when I look in it there are 42903 points added.  Here is my log file: https://docs.google.com/file/d/0B6AQWwPegRg6ZXFvTEE5bmlmTms/edit?usp=sharing  Here is the select count in the database: https://docs.google.com/file/d/0B6AQWwPegRg6a2pnaWVuY0Y1MDA/edit?usp=sharing  Now here is an extract of my workspace: https://docs.google.com/file/d/0B6AQWwPegRg6TDE1T3gtbXdyMUk/edit?usp=sharing  As you can see the number of elements before the Aggregator is the same as the one in the database.  Finally here is the inspection done with ArcMap: https://docs.google.com/file/d/0B6AQWwPegRg6ZnJVOHV1elV5dEk/edit?usp=sharing  So I would like to understand what I missin

2
mark2atsafe
Safer
11 years ago
gpt_geoinfo
Contributor
gpt_geoinfoContributor
asked in Transformers
Creating Geometry corresponding input database (schema)

Hi Community!  I hope someone could help me or give me a hint.  I have a script which transforms a database (ORACLE8I) to SDF3 (FDO). It is a simple script since the input data is configured as "Single Merged Feature Type" and the output data as "Dynamic Schema" (so the properties are dynamic corresponding to the incoming features). The result is a "copy" of the database in an SDF3, each table of the database is one Feature Type within the SDF3.  My wish is to have the empty tables of the database, too. I already know that it won't be possible to have empty Feature Types / Tables in the SDF3. So, I would like to create some dummy features, for each database-table one dummy feature. So that there is at least one feature for every table. Is there a way to solve that issue?  I need the SDF3 for a WebGIS. The stylization should be fix. The SDF3 is then updated weekly. It could happen that a table will be filled. To avoid checking it I would like to have at

3
gpt_geoinfo
Contributor
11 years ago
sdepriest
Contributor
sdepriestContributor
asked in Transformers
Date is being set to null with AttributeRenamer

Does an AttributeRenamer not handle attributes with a Date data type very well?   I have a DATECREATED attribute on an SDE table.  The SDE table, Dampers, is the source data set and destination data set (both are using the ESRI ARCSDE30 format).  I’m updating some fields in the Dampers table by getting values using a joiner from another SQL Server table.  I have a DATEMODIFIED attribute that I’m setting with a TimeStamper field.  So I’m using the fme_db_operation = UPDATE in an AttributeRenamer.   And I don’t want the DATECREATED attribute value to change. The format is YYYYMMDD.  But it’s being set to null when I run the translation.   I’ve been trying a combination of things and can’t seem to get the DATECREATED attribute to save its value.  I've used the Feature Inspector to step through and the attribute disappears after the AttributeRenamer.  I must be going at this in the wrong way.  How do I keep an attribute value the same when i'm updating other attributes? 

15
sdepriest
Contributor
11 years ago
J
jryan
asked in Transformers
Traceback error with Statistics Calculator

I am getting the following error that is causing a fatal crash in my workbench.  Appears to be a problem with the native python code of the statistics calculator.   Has anyone every seen this and is there a work around?  Note that the it does not fail and any specific feature so difficult to troubleshoot if the data is causing the issue.     2013-04-14 19:27:53|1787.9|  0.0|WARN  |Traceback (most recent call last):   File "C:\\Program Files\\FME\\transformers\\StatisticsCalculator.py", line 87, in summarizeStatistics     Transformer.instance(xformerName).summarizeStatistics(feat,outputType)   File "C:\\Program Files\\FME\\transformers\\StatisticsCalculator.py", line 131, in summarizeStatistics     results = statisticians[groupKey].outputStats()   File "C:\\Program Files\\FME\\transformers\\StatisticsCalculator.py", line 232, in outputStats     FMELogfile().logMessageWithParams(917353,[xformer.instanceName(),xformer.paramMap()['STDEV_ATTR&#

5
J
11 years ago
J
joan_in_danvill
asked in Transformers
Add attribute to parcels from irregular area overlay

I have a layer that is of scenic hillsides and I need to add an attribute indicating that to the parcels that are touched by the area.  When I used the AreaonAreaOverlayer, it clipped the parcels to match the scenic hillside area.  I need a way to add an attribute to the required parcels without changing their shape.

2
J
11 years ago
A
abaumgarden
asked in Transformers
MRF2DCleaner and CAD data cleanup

Hi,  I'm working with some CAD data that was recently converted to GIS and I'm attempting to clean up the data using a trail version of the MRF2DCleaner.  I've ran through the process a couple of times but I'm still not getting the desired output.  Does this tool need to read the original CAD data for it to be fully functional or will it operate properly reading GIS data?  Also, the first couple of times I ran the transformer it failed to complete referencing an error regarding short elements.  I went back into the original data and deleted out any features less than a half foot in length (with the "Cleaning Tolerance" set to 25 feet) but then it kept giving me the same error saying, "Set 'Delete Short Geometries' to 'Yes' with 'Cleaning Tolerance' no less than 0.236845."  Since several short geometries do exist that are longer than the length specified, is there any reason it is forcing me to set this parameter?  Lastly, I&#3

4
A
11 years ago
redgeographics
Evangelist
redgeographicsEvangelist
asked in Transformers
Which transformers are supported in FME Base?

Is there a list somewhere of which transformers are available in which FME edition?

2
redgeographics
Evangelist
11 years ago
A
anandak
asked in Transformers
SQLExecutor Stored Procedure

Can we use a SQLExecutor to run a stored procedure which will accept ref cursor and then process the entire recordset in the stored procedure? Can we pass the entire record set to a stored procedure or FME will process it one row at a time?  Also how can we fetch the list of column names from the passing features and store them into a attribute list?

2
A
11 years ago
J
justinv
asked in Transformers
Flatten duplicate points

I have duplicate points with different IDs that I would like to flatten out based on the lowest ID number. For example, I have four duplicate points with different IDs, point:A1 point:A2 point:A3 Point:A4, I would like to turn those four points into one point with the point IDs in separate fields ordered from lowest to highest like this point;A 1 2 3 4.  What is the best way to do this?

3
david_r
Influencer
11 years ago
I
ifitch
asked in Transformers
Trouble with StringConcatenator.

Hi all. I need to put values of all attributes from source table to one field in target table. Of course, i used StringConcatenator and everything works great. But problem is that i need to put only attributes with values. For example i have table with fields CITY, STREET, BLD_NUMBER:          CITY         STREET    BLD_NUMBER 1. New-York   42 street               150 2.    Albany           null                    17  and strings wich i got [CITY:New-York, STREET:42 street, BLD_NUMBER:150] - ok, that's what i need [CITY:Albany, STREET:, BLD_NUMBER:150] - but i need string like this [CITY:Albany, BLD_NUMBER:150]  the question is how to get what i need? Thanks for answers

4
I
11 years ago
R
rvgeneug
asked in Transformers
Hold transformer untill writer is done

Hi,  Is it possible to prevent a transformer from starting until a certain writer is done? This needs to be used in following case: 1. Read data 2. Process data 3. Write data 4. Read written data in same workbench and continue processing  Working with a workbench with workspacerunners performing the actions seperately and consecutively won't work as this needs to be executed on an FME Server with one engine (I noticed the workspacerunner searches for a second engine). Secondly I was thinking to do the writing with an SQLexecutor instead of a writer. But it's a bit tricky to compose the writing statement everytime correctly and I was not able yet to keep the geometry when writing.  Any suggestions on this?  thx, R.

5
A
11 years ago
E
eljeeg
asked in Transformers
Scale Text size

Hi,  Im trying to scale a text with a factor 1000.0. In the Parameters I set the Text Scaling to Location and Size. But only the Location is scaled, not the size. When I convert the database data to an AutoCAD drawing and I open the drawing, the text has still the wrong size. Is this a bug, am I doing something wrong or.....? I'm using Workbench 2010.  TIA  Regards Leo

1
sigtill
Contributor
11 years ago
G
geospatiallover
asked in Transformers
Spatially attributing a list of polygons based on an intersection with a linear feature

I'm looking for a solution that produces an output of a spatially ordered list of parcel features using the intersection of the parcel and a linear feature.   To assign the spatial order, an attribute numeric integer field will be added in the writer feature type called listing and it would be populated beginning with "1" for the 1st parcel intersected by the beginning point of that line. Then the next parcel intersected by the line would have a listing attribute number of '2', and so on until the last intersected parcel at the end point of the line is reached.  Any suggestions?

1
david_r
Influencer
11 years ago
D
dorian
asked in Transformers
DWG labels to Feature class attribute

Hi folks,  how do I populate a user attribute in a writer from  text label in reader? The reader is a dwg file.  Thanks in advance

1
david_r
Influencer
11 years ago
J
joergschroeder
asked in Transformers
Java-Factories in FME2013

Hi! I'm installed the FME2013 an put my own Java-Readers/Writers/Factories in the plugin directory. The Readers and Writers run without problems. When I use my factories, FME send message: ------- This FME edition does not recognize the `de.geocalc.fme.factory.ColorizerFactory' factory. Please ensure that the current platform supports this factory, the factory name is spelled correctly, and that you have installed all required plug-ins -------  Must I register the Java-Factories under FME2013?    2. Question:  Can I use a shared plugins-directory? I need the plugins under 32bit and 64bit version of FME.

1
tino
Contributor
11 years ago
J
josh_k
asked in Transformers
BoundingBoxReplacer crashing

In FME2013 I am having a problem with BoundingBoxReplacer crashing when set to Oriented Bounding Box. I am feeding it output from the Aggregator transformer.  Has anyone else had this issue? It worked fine in FME2011.

3
J
11 years ago
davideagle
Contributor
davideagleContributor
asked in Transformers
Extract Geometry Traits

I have a bunch of features that have Geometry Traits attached as a result of an upstream process I have carried out to find out if they are valid. I now want to manipulate those traits and I'm pretty confident that I need to use the GeometryPropertyExtractor. But no matter what I enter into the parameter 'Traits to Extract' I cannot get anything to be extracted. If I inspect the features I can see the traits but I'm not clear how to reference them so I can get at them... does anyone have any experinece with traits that they can share? Thanks!

2
mark2atsafe
Safer
11 years ago
M
mrr
asked in Transformers
LineCloser does not work!

I have a lot of lines like a grid. So I trying to use Intersect, Selfintersect and LineCloser but It does not work. I need to become those lines to polygon's. So how can do that?  

3
mark2atsafe
Safer
11 years ago
S
sjc1999
asked in Transformers
Linking a Parameter to the Prefetch Query on Joiner

I'm trying to build a dynamic SQL string to use as my Prefetch query on a Joiner transformer.  I am linking a Python script Private Parameter to the Prefetch query parameter on the Joiner.  I am using the Python script to construct the query, something like  return "select * from " + FME_MacroValues["SchemaOwner"] + ".TABLE_NAME".  When I run the workspace I get the message  An error occurred while accessing a table result for feature type `__fme_execute_sql_results__'; message was `Execution of statement `select' did not succeed; error was `ORA-00936: missing expression'.  However, if I copy the SQL statement from the Python script with the parameter substitution for the database schema name into the Prefetch query parameter on the Joiner, the query executes successfully.  Is there a way to create a dynamic SQL statement for a Prefetch query?  I am currently using a beta copy of FME 2013.  Thanks, Steve   

6
S
11 years ago
J
jaya
asked in Transformers
Finding Nearest Neighbor

Hi,  I have two oracle tables ABC and DEF with lat-long fields where each record include detail of a site. I want to find a site from table DEF which is 20 mile away for each record of table ABC.  Logic I am using is below 1. Two oracle non spatial reader for each table. 2. Assigning LL84 coordinate system to both teh reader 3. Using 2DPointReplacer to convert the lat/long into point 4. Using Reprojector to convert the coordinate system from LL84 to US48MI  When I run this flow M getting following error Geometry Type: Point (1) Number of Coordinates: 1 -- Coordinate Dimension: 2 -- Coordinate System: `LL84' (-118.2666667,34.0333333) =========================================================================== Reprojector_2: Reproject: Could not reproject the geometry of the preceeding feature: Reprojector: Could not create reprojection engine Reprojector_2: Reproject: Could not reproject the geometry of the preceeding feature: Reprojector: Could not create reprojection engine  Can an

4
david_r
Influencer
11 years ago
ben_vanderford
Contributor
ben_vanderfordContributor
asked in Transformers
How to geocode with FME

Can anyone give me a "How to" or an example workbench on geocodeing within FME. For example I have an excell spreadsheet, lets assume all the address are good and are in a single field and have information like state and zipcode. I want to add that spreadsheet as a reader, geocode the address and write out a shapfile. How do I do it?  I don't really care which geocodeing service we use. I saw this covered briefly on the world tour and am curious. Many thanks.

2
davideagle
Contributor
11 years ago
J
jaya
asked in Transformers
Using Neighbor Finder

Hi,  I am using neighbor finder to find the candidates which are at 20 miles distance from base records. It is working fine, giving me the matching records which include the base records with the attributes of neighbor finder(_distance....etc)   Is it possible to add candidates record fields in the matching record output. How can I do that

1
davideagle
Contributor
11 years ago
G
goatboy
asked in Transformers
snapping gps trails to road centreline

Hi All,  i have a city wide road centreline shpfile and i have gps trail data gathered by buses. I need to select the roads that the gps trails on them. IE the bus routes.  I have tried a range of options. Select within roads within x of the gps trail, but this selects side roads that buses dont travel down.   I have tried selecting any road that the gps trail intersects with but again the side road problem defeats me.   I have tried the Anchor Snapper but all my records passed thru unsnapped?  Does anyone have any suggestions that im missing ?I was thinking about some conviluted approach using the angle of the intersection. if its > x then its a side road ?  Many Thanks Steve

2
davideagle
Contributor
11 years ago

Badge winners

  • FME Form Basic Training
    hobbehas earned the badge FME Form Basic Training
  • Student (Grey)
    maaykehas earned the badge Student (Grey)
  • Expert (Grey)
    maaykehas earned the badge Expert (Grey)
  • Teacher (Bronze)
    maaykehas earned the badge Teacher (Bronze)
  • Teacher (Grey)
    maaykehas earned the badge Teacher (Grey)
Show all badges
29,895
Posts
Terms & ConditionsCookie settings