Transformers

I am using a CsmapAttributeReprojector to convert between a source coordinate system and my own local destination coordinate system. I expect that the Y value should only change, however, this change does not take into account a negative value So if the source Y value is -50 Instead of adding 200 to - 50, it adds 200 and 50 which results in 250 instead of 150. I have a python script that reads the header of my CSV file and finds the Y column in the header and this value is given to the reprojector, this does find the right column but as said above, my transformations aren't subtracting

Hi Guys, no so sure if this questions belongs here: 1st> what's the best way to have an internal (to the workbench) datasheet (4 columns x 20 raws of values). Is it in the workspace resources? 2nd: I am reading +storing a sequence of characters from a file (a file that I am uploading and processing). I want to compare this sequence (a name) with the aforementioned database in question 1 (actually with one column of the database), So when getting a coincidence name=cell A1 , I will store or been able to retrieve the values of the other cells within the same raw (cell A2, cell A3, and cell A4) . Thank you very much! Jorge

I am trying to use CurveFitter on a set of contour lines but am not getting useful results. As you can see some of the lines overlap, even after a very light processing. How can this be avoided? I tried both settings of Preserve boundries, but that did not make much difference.

Is it possible to containerize a dataflow ? Something like this: Where we split our dataflow, we apply some specific transformation on one of the containers and then the rest of the dataflow is similar for both container. During the end of the workflow, both container will be isolated. Is that possible ? For simple workbench this is useless, but if, for example, I have a lot of "group by" transformer in the "End of the workflow" part, then it will be useful.

I have 2 large Mapinfo tables - Hedges (lines) and Gardens (polygons). I want to retain all hedges outside gardens, including those which have ends touching the gardens. I want to remove all hedges running along (coincident with) garden boundaries. I attach an image showing with red crosses these lines. All others should be kept including those touching the boundary at an angle. Is this possible using the SpatialFilter or SpatialRelator? I've tried various ways with both these but I am not able to achieve this. In Mapinfo I achieved it by the SQL query "Not Obj Within Any (Select Obj from Gardens)". Is there an equivalent in an FME transformer? The only other way I can think of is by buffering the gardens slightly and then using the Clipper to remove all hedges within the gardens (and the buffer would remove those running round the garden boundaries). Many thanks if you can help! Jane

Hi, We are implementing Informatica in our gas/electric utility. We will use this information to test calling the FME Server job from Informatica: https://knowledge.safe.com/articles/636/integrating-fme-server-and-informatica-powercenter.html What is the best way to let the Informatica job know that the FME Server job is finished? Also does anyone know of other organisations that use an Informatica/FME Server integration? Thanks, Annette

Hello There is it possible to get access to the GDB Schema of the utility network of Esri, without having An ArcGIS product Thanks

I am using a SQLExecutor transformer to execute a large number of SQL queries (writing to a Sybase IQ DB via JDBC connection as a work around for the Sybase Writer that didn't work for my specific translation). I've found that not all of the features that are routed through the translation and should be written via the SQLExecutor are actually getting written. There is an error "java.sql.SQLException: JZ006: Caught IOException: com.sybase.jdbc4.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.". I'm thinking that this is related to the "Query Timeout" default of 30 seconds. However I'd like to confirm this so when does the commit part of the SQLExecutor query actually happens. For instance if 30 features get routed to the SQLExecutor do each of those get written one by one or all in a batch at the end? Thanks in advance to anyone who has any info on this!

Hi. I have trouble using the csgbuilder to form a unified solid(IFMECSG). In my database, every building has so many small parts and I need to union them. Every building should be a unique(one) building. I want to write them later to Citygml as building. The writer does not accept a multiSolid, so I need to do the union through csgbuilder. But the problem ist that this transformer do the union just for one small part and reject all the remaining parts. I also used the group by parameter but the result is the same. Can you please help me?

I have a workspace that is run on a daily basis. Its duration is about 6 minutes. Sometimes it gets stuck on the line: Processing base feature(s)... If I compare the logs of a succesfull and failed execution there aren't any different numbers that are about to be processed. There's also no warning of resources, memory etc.. The failed workspace just gets stuck (and stops logging) and after 20 minutes it's timeout (as scheduled). Execution time for both succesfull and failed processes up to the 'Processing base feature(s)...' line is about the same: 5 to 6 minutes. Does anybody have advice on how and where to look for clues to prevent the workspace getting stuck

Hey, I have multiple xyz-Files that I would like to Clip with a shapefile. And then save it as xyz-Files again. I used the reader POINTCLOUDXYZ as well as the writer POINTCLOUDXYZ. I tried the transformer Clipper as well as PointOnArea. Somehow it won't work. Is there a transformer/ or multiple transformer connected that I could use to clip xyz-Files, that you can recommend to try? Thank you,

Hi I am trying to extract the EXIF GPS coordinates from a .TIF file. I have managed to extract EXIF from a JPEG, but it seems .TIF readers doesn't expose the right additional attributes: The .TIF file I am trying to extract: Anyone know of an alternative way to do this?

Y ((@YValue()/0.999604)-5447183.654)-(((@XValue()/0.999604)-482902.876)*0.000039706) X ((@XValue()/0.999604)-482902.876)+(((@YValue()/0.999604)-5447183.654)*0.000039706) Thanks

We have created a dataset in a WebViewer with Google Charts in the maptips. Now we got the request to print a weekly snapshot to pdf. I wonder if anyone had this same challenge and found a solution. We can always reproduce the charts in the ChartGenerator but we really prefer the Google Charts layout.

Hi, For a client we are developing a system to preview survey data (bathymetry) in a browser. Additionally, we also need to indicate differences between surveys over time. These survey data are supplied as rasters. I have some troubles when reprojecting rasters with different extents to Web Mercator, please find attached a document with more information and screenschots. Raster 1 CRS EPSG:32643 - WGS 84 / UTM zone 43N - Projected Extent 272800,2092300 : 276600,2097600 Unit meters Width 3800 Height 5300 Origin 272800,2097600 Pixel Size 1, -1 Raster 2 CRS EPSG:32643 - WGS 84 / UTM zone 43N - Projected Extent 261500,2088600 : 281600,2100300 Unit meters Width 20100 Height 11700 Origin 261500,2100300 Pixel Size 1, -1 I'm looking for a way to prevent small displacements using a correct combination of FME transformers, using FME 2020.1 Thanks, Richard.

I am using an Area on Area Overlayer and Expression Evaluator to calculate the percentage of overlap of one polygon dataset with another -the scenario is percentage ownership. I have noticed that those polygons that should have 100% overlap / ownership because they are completely within the other, do not show as a nice round 100%, always 99.something up to 101.something. I'm guessing this is something to do with geometry and /or tolerance, but how to solve it? 101% ownership will raise questions when the data is presented!

I was looking at ways to create Elevation profiles but did not find any transformers or other easy ways to do this in FME. Should I be searching for some other word? I don't need anything fancy, the sources are some polylines and a DEM file. I would be happy with something as simple as a csv file as output.

Hi, I make an attempt at removing the effects of building heights on a DSM (Digital Surface Model) in order to obtain a result looking more like a DTM (Digital Terrain Model), in other words something closer to the bare soil elevation. My thought was to use a RasterResampler transformer and define a cell size a bit larger than the buildings, and also assigning the minimum elevation value to the new pixel. However I don't see a minimum value method for RasterResampler. I looked at the RasterConvolver but there is no way to define the kernel size in terms of distance instead of pixels. Correct me if I'm wrong. In other words I need to find the minimum over a great number of neighboring pixels (much more than the traditional kernel sizes). How would you achieve such a raster operation using FME Desktop? Thanks in advance! Best regards, Olivier

What is the fme_where syntax for specifying multiple fields to update by? I've tried this syntax, but it doesn't seem to work in my scenario. New Attribute: fme_where Attribute Value: YEAR = @Value(YEAR) AND MONTH = @Value(MONTH) AND PLANT = @Value(PLANT) AND UNIT = @Value(UNIT) I'm using a DB2 writer and I have to handle inserts and updates coming through. It seems that the single DB2 writer can only handle INSERTS or UPDATES, not both. When I enter values in the "Update Key Columns" property on the DB2 Writer, all incoming rows are treated as Updates even though the fme_db_operation value says INSERT. And vice versa. When I remove the value in the "Update Key Columns", all rows are treated as Inserts, even when the fme_db_operation values says UPDATE. I thought I could delete the values from the "Update Key Columns" property on the DB2 writer, and then create the fme_where attribute and specify the key columns to use for the UPDATE. But it didn't work. I had one UPDATE and one INSERT

I have 2 versions of data in autocad format: 1 old and 1 newer The difference between these 2 versions and that the insertion point (blue square) of the blocks has been changed. For the oldest version it is located at the bottom right image 1 and in the most recent and in the middle of the block see image 2 I need to move this insertion point inside the block, it is good to move the coordinates of the insert point and not the polyline coordinates of the block. I have established the formulas for the displacement of the insert point with the unit of angles in grades and wish to be able to apply it to evolve my files from the oldest version to the most recent image 3. I am new to FME and admit not knowing how to go about it. Can you guide me to solve my problem

According to https://community.safe.com/s/article/working-with-geodatabase-field-aliases , when reading aliases from a GDB, an additional attribute with fieldname_alias is created, containing the alias. When writing to a GDB, this field is used to write the corresponding field's alias. So I figured formatting an Excel table like below would work, but the fields are written to the GDB normally, and there don't seem to be any options to flag the fields as alias fields.

I am working with a 3D city model (composed of meshes), where the vertex normal pool is simply a copy of the vertex pool. Obviously, this is incorrect and I do not know why that is the case, as I was simply handed the model ready-made. I am wondering therefore if there is a possibility to do a reset for these measurements? To calculate the vertex normals in some automatic way anew? I appreciate any input on this matter! Many thanks.

I have a folder of ~300 2gb DEM files. I want to produce hillshades of these 300 individual tiles so that when viewed together the colour ramp is the same across file boundaries. Rasterhillshade doesn't work well if the min-max values on a file is 5m-300m and the adjacent file is 5m-900m. I've previously put DEMS through a raster mosaic and then produced a hillshade but with this size of data that's not feasible. Any ideas how this can be done?

I would like to know about difference between inside point, centre of gravity and centre point transformer ? if any example to see differences. I tried with general shape file didn't find any differences.

These jobs currently take 1-2 hours to run on FME Server (6 CPU, 48 GB) each day. Due to the nature of the data source, incremental updates are not possible at this time.