Best Answers

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?

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

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 ……

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.

 Which rights/configurations that a simple user (not administrator) needs to be able to Extend/Rovert FME Extension for ArcGIS on FME Integrator console ?

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.

We would like to translate a citygml file - but we cannot enable the FME CityGML Importer with the files supplied by FME (.oemlic and .dat). It does not recognise them as liscense files. Has someone managed to do that? Could this Person please post a help? Kind regards, L. Muller

How can I expose the "table name" parameter in the dialog box of the Oracle reader as an attribute I can use in a writer (to force it lowercase)?

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 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.

Hello,Is there a way to convert LiDAR Cloud Point (.las) to DEM Raster With Spectrum Colors Based On Elevation Values?I see the following post (https://knowledge.safe.com/articles/1345/creating-a-raster-from-a-point-cloud.html), but just hope the expert may show me how to colorize the raster image with Spectrum Color like following image:Thanks a lot,Reno

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

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.

I download the example from the article "Batch Processing Using the WorkspaceRunner"When i run it an the fme2018 and don't change anything it works well. When i update the workspace runner to fme2018 ,it can not work any more. I don't know why. It troubles me a lot.This is the ordinary one?Then i update the workspacerunner

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!

I have created a workbench that includes a DatabaseJoiner transformer that I want to pass a specific file too that will change each day (basically the file has the days date as its filename). However if I do this, I then cannot join on a field as the transformer reads the Dataset as a text string.I did try an alternative to this using FeatureReaders (excel and generic) and passing them the dataset, however that has its own problems identifying the data fields.What might be the best way to avoid these issues?

Hi everyone,Does anyone know how to convert DEM/DTM gray8 tif to rgb32 tif with the desired elevation color scheme by using FME Desktop?Gray8RGB32I know a lot of online GIS software may do it on the fly...but I am using MapGuide which seems allowing me to change the color scheme of my gray8 dem tif.Thanks a lot,Reno

Version 2018 of FME supports LAZ 1.1, 1.2, 1.3 but not LAZ 1.4 that was released on https://laszip.org/

Hello. I realize there are several different date range topics, and I can't seem to find one that applies to my needs.My goal is to query or tag records within 90-, 270-, 365-day date ranges based on CurrentDate. I have not been able to get anything to work with FME tools, but normally the SQL query would be:Select * from [layer] where "expiration_date" >= CurrentDate+90Any ideas?Thanks.