Transformers

An issue that's got me puzzled  A geometry from an oracle table a (Object a1) is used to clip a geometry from another oracle table b (Object b1)  These geometries visually appear identical, they are valid geometries and Oracle returns their relationship as EQUAL when tolerance is set to 0.005  If you clip object b1 with object a1, object b1 remains untouched and it is output untouched via the outside port.  if you clip object a1 with object b1, object a1 is clipped as expected, with geometry exiting both the input and output ports  A spatialrelator gives the interactions as OVERLAPS and INTERSECTS irrespective of which object is the requestor/supplier  Any ideas?

HiI have a raster with the following properties:I want to use the RasterExpressionEvaluator to set new values to each cell. I have written this expression: @if(A[0]<0.07, 0, @if(A[0]<0.5, 1, @if(A[0]<1, 2, @if(A[0]<1.5,3, @if(A[0]<2,4,5))))) but I can't get it work.Any suggestion?

I have gps points, each with a creation_time attribute. I would like calculate the elapsed time for each point using the creation_time of the first point as the start_time.My thoughts are to write the start_time to each feature and use DateTimeCalculator. Any ideas how I can select the creation_time from feature 1 and write it to all other features as start_time?If there is a better, I would love to here it.regardsMartin

Hi,I have a set of lines that make up a set of polygons. Is there a way to separate lines that goes around the edge of data set? (see picture below, only yellow lines)Thank you.

Hello, I have the following problem and hope you can give me a tip. For a statistical analysis of my city, I have to know how much building space is on a landparcel. For this I have a source with the parcels and one for the buildings. I wanted to solve the problem with the AreaOnAreaOverlayer Transformer. Now I have the problem that some buildings are on more than one parcel. In this case, the common parcels must be merged and all buildings identified. Here's an example:The Buildung 1 is located on the parcels A,B,C. Buildung 2 is located on the parcels B,D.At the end the parcels A,B,C,D must be dissolved.When i use the AreaOnAreaOverlayer with Buildings and Landparcels, i have a lot of areaparts with several combinations of building and parcel-ID. When i start to dissolve the areas again with the id of one common building, i loose IDs of the others. Please can you give me a tip how this problem can be solved? Thanks, David

Hello!We would like to apply a 4x4 Matrix from the alignment process to other pointcloud files to bring them to the correct position.  I tried the pointcloudtransformationapplier but I didn't manage to make it work, as I did not fully understand how this transformer works. Thanks a lot and with best regards, Matthias

Hi, I am new here,  I tried to convert a colored „jpg“ raster image to „grayscale".   Until now i used the programm „IrfanView“, where I set the saturation-value to „-255“,  but i had to do it for every image seperatly.   Now I want to use FME for conversion of multiple pictures at once.  Could you help me to find the correct transformer for this work?   Or is there any other simply way to convert a various number of colored jpeg images into grayscale?  Thanks for answers ……

Can someone explain how FME handles raster cell origins?  In the RasterNumericCreator and RasterRGBCreator changing the X|Y Cell Origin values does not affect the extents of the image, the X|Y Upper Left Coordinate is always the edge of the pixel, not the origin.Likewise changing the cell origin via RasterCellOriginSetter has no effect on the resultant raster.

Hi all,  I'm trying to merge two data-sets when they don't have a common field. What I would like to do is merge them using keywords that I have in one of the lists, so it should be a kind of a Feature merger with "contains" function, but so far I'm not really successful in finding a solution.   Here's an example:   List of IDs and keywords (1st data set): ID Keyword 111 Mc'Donalds 545454 Starbucks 1234 KFC 222 Burger King 343434 Golden Tulip List of places that I would like to assign ID to (2nd data set):  Place_name ID Mc'Donalds Amsterdam Central Starbucks Airport Stations' KFC Piazza Burger King Amsterdam Golden Tulip Hotel So in the end it should simply look like this: Place_nameIDMc'Donalds Amsterdam Central111Starbucks Airport545454Stations' KFC1234Piazza Burger King222Amsterdam Golden Tulip Hotel343434 Any suggestions?  Thanks

I'm generating a large GML based on data that i get from the SQL creator. The whole workbench is meant to be database driven. There is a main workflow that triggers this one: SQL_creator has dataset part A and SQL_creator2 contain part B, both are the same dataset and should be merged by ID (only attribute that they both have). They are split because of the amount of joins that the SQLcreator can handle is reached. I have a parameter $(sql_statement) that contains the SQL statement that is used in the SQL Creator. The attributes itself are dynamically named, so they cannot be exposed by setting value "attributes to expose". The Attribute exposer exposes the ID of the records, this is the only attribute that both creators have in common.Schemasetter exposes the dynamic attributes so they will be exported in the dynamic GML export.It works with the tester directly to GML but it does not show the dynamically created attributes that are created with the SQL_creator2 after th

This seems like a fairly simple task but I'm struggling to think my way around the problem.Middle point: master = it's unique idprevious = the id of the point to the left of itnext = the unique id on the point to the right of itHow would I connect these points to form lines by relating the master, previous and next attributes.

Is there a way to smooth a line so the resulting line passes through all the original vertices?

For the life of me, I cannot figure out today how to eliminate dangle lines. End goal here is I am looking at which fire hydrants we have, that can be easily accessed by a fire truck that are not on a dead end street. Any assistance will be greatly appreciated.

I want to compare parts of street in the same data set. Street's parts with the same value of the attribute 'street_name' and geometric shapes whose bounding box overlap or are located within a distance of less than 10 meters, should be assigned the value of a common aggregate bounding box. Hhow this could be done? I will appreciate any help.

Hello,I have one feature reader where I read filter polygons from table A. As a result I get few of them.Then I have separate reader where I read polygons from different table B. I have like 2000 of them.Then I would like to get as a result only those polygons from table B which are inside any of the polygons from tabel A or % of the area inside one of the polygons from table B is let's say 90%.What would be the best way of doing that?

I need to join 3 bands of an image, a band 3, 4 and 5 but when using RasterbandCombiner it comes out with 5 bands, why?

Hi FME'rsI would like to add land classifications stored in a polygon layer to a XYZ point cloud in an attempt to fudge an LAS-like dataset. My approach so far was been to use to PointCloudCoercer to turn to XYZ to point, SpatialRelator to add the classification attribute from the polygon, then PointCloudCombiner to turn it back into a point cloud. As you can image, this is incredibly slow going. Can anyone out there offer an alternative?David

Hi,I am trying to convert a .shp to a .dwg (RealDWG) file. I was able to successfully write all "fme_donut" to "autocad_region", however all my attempts to write "fme_aggregate" (multi-patch polygons) to "autocad_region" were unsuccessful. This is my understanding that FME can handle autocad_region by subtraction (donut) but not by addition (multi-patch). I am wondering if you have any solution to do the job.Many thanksRegards,Hani

I have a string such as: 3R3002 - Oneri finanziari su derivati - COLLAR I use the SrtingSearcher tranformer to find all after the first dash (Oneri finanziari su derivati - COLLAR) with the regular expression: -[\\s\\S]*$ but I receive an error: couldn't compile regular expression pattern: invalid escape \\ sequence

HI guys, I have a question, in FME 2017.1 when we execute a command line with the SystemCaller, the command is prompt in the log and the password is in clear .... Do you have any tips to fixe it ? (I was thinking to rewrite the log to erase or hide it) .  The passwords are from private parameters and contains the word "password" inside.

I am trying to create a workflow that checks a spreadsheet with new updated information against an older feature class. I am using FeatureJoiner to determine if there are any new or added rows to the spreadsheet so that ultimately, i will be able to add the coordinate points for any new rows. I have connected the unjoined left port of the FeatureJoiner to a counter transformer to determine how many new rows were added to the spreadsheet and therefore show the user how many new coordinate pairs need to be added to update the feature class. So far I have been able to generate an error message using a logger transformer (FeatureJoiner > Counter > TestFilter) to indicate if there are new additional rows, however I would also like to generate a message if there are no new rows added so that the user knows and so that they can be directed to another workflow. I have set the TestFilter so that if the counter transformer attribute has value it will lead to one Logger, otherwise it will l

I want to use spatial relator to find out which building is in dangerous area. But when I run my workspace, it only runs requestor side without supplier side, and gives me a feedback that all things are rejected. My question is, how could a spatial relator work without supplier? It is really wired. Why workspace doesnt read the dangerous area at the same time? Thank you so much!

Hi. I want to make a line from a single point (based on distance in meter), and then change the direction. I want to do this for multiple point. I have the line length, x and y coordinates, and line direction.  Line have to start from x and y point. I'm using FME 2015.   Thanks.

Hi,Using FME Server, I am writing a large amount of data to a gdb to then be zipped up, using the custom transformer ZipArchiver. It works until it reaches its 2GB limit and then fails with the following lines:Ideas for a workaround for this would be gratefully received! Is there a quick fix? Would Gzip work better?Kind regards

Hi,I have some errors coming up in FME Server when I'm trying to read in rasters which, when I'm running locally through Desktop, do not occur.I am reading in several GEOTIFFs using S3Downloader and saving them to a location. Then from that location I use a FeatureReader and send them to a VectorOnRasterOverlayer. (The vector features coming in are fine).As I said, running locally is fine, but through Server I'm getting the following warnings and errors:I appreciate this could be a simple fix but I'm new to raster handling in FME. I've already tried a few things using a GeometryValidator after the FeatureReader, such as processing measures containing NaN, but with no joy.Thanks in advance!