- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,684 Posts
50,749 Replies

When you subscribe we will email you when there is a new topic in this category

12684 Posts

arnold_bijlsmaEnthusiast

asked in Transformers

How do I get the raster cell(s) with the maximum value?

A very simple question, hopefully with a simple answer.I have a single-band raster file with flood depths, and want to put a point or label at the deepest point ("X marks the spot"). I can get the deepest value using the RasterBandMinMaxExtractor, but how do I get the location of the deepest value.The solution I've come up with so far is using a RasterCellCoercer converting the entire raster into a point feature class, and then extract the deepest point using a Tester transformer. But this feels to be a bit of a roundabout way, having to vectorise the raster first.Hopefully/Surely there is a shortcut....?

1030

7 years ago

arthyContributor

asked in Transformers

how to save an attribute to an oracle date type column?

Hi, I have an attribute (timeattribute) that I would like to save to an oracle table timeattribute = '2017-06-30 18:39:05'Within a sqlexecuor, I'm doing something like: INSERT INTO TEST_T ( OBJECTID, TIMEATTRIBUTE ) VALUES ( @Value(OBJECTID), '@Value(TIMEATTRIBUTE)' ) and it failed. How can I make it work? FYI, the queryINSERT INTO TEST_T ( OBJECTID, TIMEATTRIBUTE ) VALUES ( @Value(OBJECTID), sysdate ) worked perfectly within the sqlexecutor.Thanks

134

7 years ago

arthyContributor

asked in Transformers

How to compare two json without looking the order of their attribute?

Hi, I have two json and I would like to test if they are equal without knowing their attribute name? How can I automatize it using either a transformer or python caller?_result= [{"attributes":{"OBJECTID":objectid, "ATTRIBUTE1": A1 , "ATTRIBUTE2": A2 , "ATTRIBUTE3": A3,"ATTRIBUTE4": A4, ... ,"ATTRIBUTEN": AN}}]_result if the generic syntax of my json document. Thanks@takashi

633

7 years ago

arthyContributor

asked in Transformers

how to format all the date and time properties from a json to a specific format using python

Hi, I have a json and I would like to format all the date and time attribute to a specific format using python._result= [{"attributes":{"OBJECTID":objectid, "ATTRIBUTE1": A1 , "DATE1": "%Y-%m-%dT%H:%M:%SZ", "ATTRIBUTE3": A3,"DATE2": "%Y-%m-%dT%H:%M:%SZ", ... ,"ATTRIBUTEN": AN}}]I would like to have _result= [{"attributes":{"OBJECTID":objectid, "ATTRIBUTE1": A1 , "DATE1": "%Y-%m-%d %H:%M:%S", "ATTRIBUTE3": A3,"DATE2": "%Y-%m-%d %H:%M:%S", ... ,"ATTRIBUTEN": AN}}]I tried this:import datetimeimport jsondef formatting_date(feature): array = json.loads(feature.getAttribute('_result')) for m in array: for k, v in m['attributes'].items(): if instance (v,datetime.dateime): v=datetime.strptime(v,'%y-%m-%d %h:%m:%s') feature.setAttribute('prop_', json.dumps(array))but it failed. Any suggestions?

3356

7 years ago

nic_ranContributor

asked in Transformers

Running an FME Server job as a specific user

I need to force an FME Server job to run under a specific Windows user account. I have Active Directory authentication turned on for FME Server and I have granted permission to the user account (via a role) to the job that I need to run. I need a way of forcing the job to run under a specific account, no matter who is logged in and running the actual job. The reason I need to force to run under a specific account is that the job needs access to data in a network drive location that only that user account can see. I know that I can set FME Server up to use a default account at the Service level (e.g. Job Submitter, Data Download, etc.) but I need to be able to do this for just a specific job. Is this possible? Nic

870

7 years ago

wrodzina

asked in Transformers

How to create shp with proper coordinates from a dwg without proper cooordinates

Hi I have been given a exact map of road system in dwg in metric scale but without proper coordinates (none know coordinate system- they just put 0,0 in the left down corner of the map). I have reference map (axis of the roads) in desired metric system. I tried offseter, scaller, affine wrapper and other tools but I failed to reach acceptable accuracy. Is there any tools in FME in which I would create a list of a reference points (e.g. 30 cross roads) and on the base of the distanced between these points on both maps (reference and unknown) the data of the elements with unknown system would be transformed to expected coordinate system. I did such tries in qgis with pdf files.

290

7 years ago

mitra

asked in Transformers

How colorize raster

Hi, I am writing to ask a question about RasterExpressionEvaluator. I have a buffer layer around one point, and I created a raster out of this buffer layer. In this buffer layer, I used red color for distance 0-100 meter, purple for 100-300 meter and blue for 300-400 meter. Now I would like to overlay the buffer on the Geotiff. So, I need the colors to be transparent so the background color of Geotiff can also be visible. I have used RasterExpressionEvaluator with raster buffer as input for port B and Geotif as input for port A. Then I have used this band expression list: if(B[0]==0,A[0],A[0]+B[0]/5);if(B[0]==0,A[0],A[0]+B[0]/5);if(B[0]==0,A[0],A[0]+B[0]/5). However, when I run the work space the color of raster buffer will not as I specified before using RasterExpressionEvaluator. Any help would be highly appreciated, Regards, Mitra

1720

7 years ago

lavairyeContributor

asked in Transformers

Count number of vertex and triangle of a 3D geometry that will be export to OBJ

Hello,I have CityGML files for buildings and I want to know and expose the number of vertex and triangles that will be exported by the OBJ writer.I use the aggregator transformer to merge all the geometries and count the number of vertex, then remove all duplicated vertex (not immediate, but feasible), but I don't know how to find the number of triangles.Is somebody having an idea ? Maybe using the pythocaller, but I'm not a specialist !

463

7 years ago

jaircasti

asked in Transformers

how to convert 3D Multipatch to DGN as cell

I have a multipatch Geodatabase or multipatch shapefile and I need to convert as DGN. The DGN output always are lines and I need to have the output a cell for every feature. Thus, when I click on the DGN feature I want to select the entire object and not only multiple lines as I am getting the output now.Does anyone know how to solve this issue?Jairo Castillo

260

7 years ago

thomask

asked in Transformers

Splitting Strings

Hi there, is there a simple way (like a regular expression) to remove a substring and to split the string on every capital letter by inserting a whitespace? Example: Attribute value of "Hello/DearFmeCommunity" should become "Dear Fme Community" --> "Hello/" should be eliminated in the string and the rest should be splitted on every upper letter.. Many thanks. Kind regards Thomas

6010

7 years ago

rob14

asked in Transformers

Attribute Validation without AttributeValidator (integer regex)

Hi,I am using FME Desktop 2015.1 and need to test an attribute field for integer status.passes are any whole number including;zeronegative numbers where prefixed with "-"positive numbers where NOT prefixed with "-"In the absence of having attributeValidator (2016) can anyone advise me of the correct regex string?Does ^(\\-)?\\d+$ look correct?Thanks in advance,Rob

7 years ago

thedeeleys04Contributor

asked in Transformers

count number of points in a polygon

Hi there,I'm using a PointOnAreaOverlayer to try and count the number of features ("UPRN") in a polygon ("DMA"). However, its not working. What group by or parameters might I need to set?

2450

7 years ago

kumarbangaram

asked in Transformers

Problem in City GML to Shape file conversion

Hi All.I am having a problem while converting a CityGML file to shape file. In CityGML i have polygons in Counter Clock wise direction. After converting them in to shape file all are converted in to Clock Wise direction.Please some body help me how avoid this.Thanks,Kumar.

7 years ago

arthyContributor

asked in Transformers

how to remove empty property from a json with python

Hi, I have a json that I'm going to use to update features on an arcgis server. The syntax of my json is:_result= [{"attributes":{"OBJECTID":objectid, "ATTRIBUTE1": A1 , "ATTRIBUTE2": A2 , "ATTRIBUTE3": A3,"ATTRIBUTE4": A4, ... ,"ATTRIBUTEN": AN}}]How can I automatically remove the entries with null values? For the example above, if A2 is NULL or '' then the json should be: _result= [{"attributes":{"OBJECTID":objectid, "ATTRIBUTE1": A1 , "ATTRIBUTE3": A3,"ATTRIBUTE4": A4, ... ,"ATTRIBUTEN": AN}}]I tried the fillowing code inside a python caller without success. def remove_null(feature): js = feature.getAttribute('_result') for key, value in js.items(): if value == None or str(value)='': del js[key] feature.setAttribute('_result_bis',js)Thanks

7573

7 years ago

jgillespie

asked in Transformers

Dull pixel strips while using RasterResampler

I've been using a basic FME workbench to resample 8000*8000 RGB 12.5cm tifs to 4000*4000 RGB 25cm tifs and have recently come across a problem in some of my re sampled images. As you can see in the image there is a strip of black looking pixels, after further investigation I found that they were not black pixels but just very low value pixels, i.e with RGB values of 10/11/12 and the strips were always at the edge of images.I was wondering if anyone else had come across this while using RasterResampler ? if it's something that can be avoid and is potentially an error on my behalf. Part of me thinks it may be something to do with how FME is re sampling the pixels from 4 to 2 and in some areas is struggling to get the correct pixel value. Please see a clip of my workbench below and don't hesitate to ask if you require anymore information.

7 years ago

metabiolo

asked in Transformers

Est-il possible s'il vous plaît de manipuler des données au format Geoconcept (.gcm) avec la version FME desktop?

7 years ago

mgreenfrog

asked in Transformers

Bulk Attribute Renamer renaming column not attributes

I am attempting what should be a simple renaming of attributes using the BulkAttributeRenamer however the results I am getting are applying the rename to column rather the attribute values.I am using a PostGIS reader and writer. Any suggestions on what I might be doing wrong?

110

7 years ago

fmelizardContributor

asked in Transformers

How Can I match on an ASCII Control Character inside the StringReplacer?

I have an attribute that contains a string with ASCII control characters in it. I'd like to use the StringReplacer to either remove or replace those characters with something else. I see that I can select some characters (like the backspace character or the carriage return) from the Special Characters list inside FME's text editor, but the one I need isn't listed there. For example, the SOH (or start of heading) character is present in my data, but I can't match on it directly. What can I do to handle this?

840

7 years ago

ruby

asked in Transformers

Extracting tree height/location from lidar data

Hi, I hope you can help me. I have LiDAR and NIR data where I need to extract the location and possibly the height of the trees along the city boulevard. Thanks so much.

910

7 years ago

cwarren

asked in Transformers

Creating line between points based on condition?

What I'm trying to do is create a line between the 2 weld points that share a common JOINT_AHEAD or JOINT_BEHIND common attribute and set the attributes of the created line from the corresponding JOINT_AHEAD_HEAT or JOINT_BEHIND_HEAT common attribute value. I've been experimenting with the neighborfinder, vertex creator, and the linebuilder, but was unsure of the way to go about this.An example below of the lines I would like to create between the points. Any suggestions would be greatly appreciated.Thanks,Chris

260

7 years ago

alicedevereux

asked in Transformers

Irish Grid to British National Grid like Mapinfo

Hi, we used to have a process where we would open up some Irish national grid in MapInfo create points and then re-save the file as British National Grid. I'm trying to replicate this in FME, however when using either the reprojector or setting within the read/write i'm seeing a few metres difference. are you able to advise?

9123

7 years ago

rimonku

asked in Transformers

Buffer on real surface.

Hi,I am new to FME. I have a 3d surface model from laser scanning data and I want to create buffers from selected points. The buffers shuld be calculated counting the real distance over surface which will not be a rounded look a like indeed. I tried surfacedraper but the buffer polygons looks very rounded. Any body can help me with ideas ? Thanks in advance.

110

7 years ago

pratapContributor

asked in Transformers

AttributeRenamer - Not Showing Error

In AttributeRenamer transformer, I have added Input attribute "ATTR1" and Output Attribute as "ATTR2". Later I have added Attribute Keeper before AttributeRenamer and did not selected the "ATTR1" attribute.But AttributeRenamer is not showing any error (Red Wheel) as it is shown in earlier version of FME.Does any one is having same problem or not...

7 years ago

aaronContributor

asked in Transformers

How to get values from a raster band and palette

I have a raster with text descriptions of vegetative classes that I wish to place on some points. I know the band and palette where the description resides (band 0, palette 2), which I have exposed using the RasterSelector. I can see the values correctly output in the Feature Information window of an Inspector but not in the Table View window of the Inspector. In other words, I can't find how to expose the values (text descriptions) as attributes. I've tried the ListExploder, ListIndexer, RasterPaletteExtractor, and Format Attributes of the Reader. I can see _band{}.palette{}.value listed as an attribute in the PointOnRasterValueExtractor so it seems all I need to do is expose _band{0}.palette{2}.value. The question is how? Hoping someone can point me in the right direction.Thanks,Aaron

1080

7 years ago

bbbutler

asked in Transformers

donut/sliver elimination

I regularly received shapefiles from helicopter flights over wildfires where the crew was mapping the perimeter of the fire. Many times these polygon shapefiles have donut holes/slivers and I have a need to remove them as part of my workflow. I'd like to build a workspace that would detect and eliminate these types of holes but cannot seem to find the right transformer. I've tried all of the donut hole tools with no success. I wonder if anyone might have some thoughts on how best to tackle this problem?Here's a typical example of the types of holes I see. Immagine the helicopter flying back on the path it just came in on...

440

7 years ago

Page 387 / 508

Badge winners

romerslhas earned the badge Welcome Back
mmestrovhas earned the badge Student (Grey)
mmestrovhas earned the badge Teacher (Grey)
mark.baggetthas earned the badge Welcome Back
skjalghas earned the badge Welcome Back

Show all badges

30,180: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.