Transformers

I have polygons admin division and streets lines, I would like to find lines (streets) in the borders, The orange lines.Blue Squares = Polygonal Admin borderYellow, Green, Orange = Street linesTarget = Orange lines

Hi,A users' progress is being tracked being creating new rows of data, with an incrementing counter in a column like so:I want to only keep the rows with the highest counter value for each users (A, 5; B,3; etc). So only keep the highlighted rows. How can I do this in workbench? Thanks!

I build two topologies (used TopologyBilder) which have nodes on the same coordinate (red and blue nodes on the picture). Now I would like somehow "move" (or offset) one of the nodes. The problem is, the endpoints of the connected edges should follow the node. How can I solve this problem?

Hi there,I have a bunch of small polygons that each have an AREA attribute, showing their square footage. These are contained within several much larger polygons.What I need is if Large polygon A contains 3 small polygons, one 100ft, one 50ft, and one 75ft, I want to generate a new attribute in my output that says Large polygon A contains 225ft. The same happens for Large Polygon B, C, so on. My output is essentially the Large polygon layer, but with the additional new attribute.I did try a spatial relator between the small and large polygons, and then a Statistics Calculator outputting SUM and grouping by the unique ID each Large polygon has, but it seems like the output attribute is the first small polygon contained, not all of them together.Any insight in what I can do different here to get the correct results?

When using AppearanceSetter you can for instance drape an ortophoto on top of a terrain modell. However it seems the texture gets scaled down to a lower resolution. What is the maximum raster pixel*pixel allowed for a single surface? Is it possible to increas this to get a more detailed model? Are there also some limitations when writing this surface with texture to formats like Sketchup 3ds etc?

When I try to use RasterPyramider for freshly created GeoTIFF or JPG rasters - it creates separate raster files (the number of these equals the number of pyramid layers) - instead of pyramids of individual raster file. Is there anything in Parameters I am missing?

Want to write NURBS with FME. Found that IFC supports it, however I guess FME can not write it. Any other format FME can write that create NURBS? (http://www.buildingsmart-tech.org/ifc/)

Hello All,Question regarding the InlineQuerier transformer that harnesses SQL. I'm trying to select a random subset of records from a table. Here's the SQL code in MS-Access that works (different syntax).SELECT TOP 200 *FROM (SELECT Rnd(ID) AS RandomID, * FROM TableNameHere)  AS TableNameRandomSelectionORDER BY RandomID;I think the InlineQuerier uses SQLite...correct me if I'm wrong. I'm uncertain as to which random function I should use and where to implement it within the code string.RND()? RANDOM()? RAND()?And can I add an argument to this function? I need to generate a random sample of records based off the table's primary key ("ID" in this case).This code works, but it only returns the first 200 records in the table (not the random sample I'm looking for), but I feel like I'm close and just need to work a random function in there...SELECT *FROM TableNameLIMIT 200

I have a json file with 3 lists. Zip Code, Occupation Code and Number of Jobs. The index of each array is related to the two other lists by index. I've posted a screen grab. How do I write these to excel such that the columns are ZIP, Occupation Code and Number of Jobs? I have tried hours of experimenting. Thanks in advance for help.

Hi, i have a problem to write my INSPIRE XLM-File with the attribute pointOfContact.We had create a Inspire-Writer with the Schema of GovernmentalService30.xsdThere is a Attribute inside called pointOfContact{} but I cant fill this attribute with any value. Can somebody help me what can we do .?Jens

Hi,  I georeference a few images in ArcMap and .tfwx files are generated.  For some reason, FME doesn't recognise the georeferencing until I rename .tfwx files to a .tfw extension.  Should FME be able to recognise the tfwx file directly?  Thanks,  Annette

Some software (ARCHICAD) Supports Morph geometry. Can FME create these?https://helpcenter.graphisoft.com/videos/archicad/3d-modeling/morph/advanced-morph-modeling-techniques/archicad-16-the-morph-tool-toggling-the-display-of-hidden-morph-geometry/

I need to extract from a raster imagery (Geotiff ) only the pixel with a specific range of valuesI mean I need to return points that corresponding to the pixels with these valuesRed between 245-255Green between 245-255Blue between 245-255

Hi,Using FME desktop 17 I have a series of HTTPCallers containing GET and POST SOAP requests, however I cannot find either the suitable transformer or parameters to extract the fields required.Attached sample XML file and parameter I need to extract and store are -<report_id>form_name<report_date_time><report_uprn><report_usrn><report_status><questionnaires> (all que_key & que_ans fields) Failed attempts using XMLFlattener & XMLFragmenter. Cheers

TIFF and TFW file validationThis is a bit of a cry for help as I’m still quite new to using FME. I am looking to create a FME workbench that can validate some specific parameters for TIFF and TFW files. It is a TIFF file TIFF file size – This should be equal to or greater than 46MB – Equal to or less than 47MB TIFF dimensions – they should be 4000 * 4000 pixels in size It has three colour bands It has an associated, valid TFW file I’ll roughly have to check 100 TIFF and 100 TFW files at a time. The TIFF and TFW files have the corresponding 1KM grid reference as their names, for example I have TQ7926.tif and TQ7926.tfw.What would be the best way to achieve this in FME? I’m happy to answer any questions to assist with the answering of my question.

Hello, I have a rasterdataset in a Raster-FGDB. This rasterdataset should be expanded by adding other rasterdatasets (a successive expansion as needed). Is it possible to do this expansion? Thank you very much!

Hi all,I’m trying to extract 3D data from a 3DCityDB (PostgreSQL) and write them into a sketchup file.I have no problem handling the surfaces and writing them into the .skp file as buildings.But I have an issue with the textures. I manage to get the right images on the right surfaces but they are not in the right place. I get the texture coordinates in a field, and they are stored as below (u,v coordinates list) : But I don't know what to do with these coordinates... And how ta handle them with TextureCoordinateSetter... Any ideas ?The idea would be to create a custom reader for the 3DCityDB format and a workbench to extract data from the DB in sktechup, multipatch,… It’s already done without the textures, but it would be great (and usefull) to get the textures right. Thank you in advance, Fabien Laganne

Hi. I tried a lot of formats to convert 3d tiles, but the result was not good.I mainly want to talk about some of the problems with the coordinate system during COLLADA's conversion of 3d tiles.There are two sources for my COLLADA files, the first one is exported from Blender software and the second one is exported using the openCOLLADA plugin for Autodesk 3dsmax software. In order to find a suitable coordinate system, I used a model with only one green sphere to do the test. I use the default parameter settings to read the COLLADA file and select unknown and EPSG: 4326 (wgs84) coordinate system.The coordinate system of 3d tiles file is same as source.When I load the exported 3d tiles into cesium, there are three results. 1?The model appears in the center of the earth.Cesium currently does not support placing models under the ground, so nothing can be seen. 2?The model disappears in a flash, and the camera catches the ocean. 3?There is the strange result, I do not know how to descr

Hi,Is there a transformer that undo a densifier? I used the densifier to get a better snapping with points, but after the snapping I want to get rid of all that vertex because the file is getting too heavy.Thx!

I have a problem which seems to be quite random. I am creating a Raster from polyline feature class. I use SDE Feature Class reader, AttributeCreator/3DForcer/NumericRasterizer - and SDE Raster Dataset as writer.Strangely - this arrangement works for some reader FCs - it fails for others with the message: Failed to write raster data tile when writing to raster dataset.The readers (both successful and not) - are derived from the same large FC (same attributes) - so can't find any obvious relationship on this side... Any ideas what to look for? Thanks

I am a new FME user and am trying to create a solid model consisting of terrain, roads and buildings to be printed out with a 3D printer. With help of transformers I created an aggregate of a terrain model from a point could and clipped out the roads that run on the terrain. I have also made another aggregate consisting of buildings that are created by extrusion from roof faces to the DEMRraster. I aggregated these 2 aggregates into one it looked complete but when I printed out the object, it appeared clearly that there are two separate components set together. How can I create only one solid object? End result is to be a WaveOBJ file which I will use in 3D printing. I passed the aggregate through a SolidBuilder transformer but the resulting solid has holes. I have also tried using the Solid Dissolver instead of the Solid Builder but was also unsuccessful. Please help. I am working in FME Workbench 2017

We have numerous Statistics workspaces analysing Oracle data on a daily basis. After updating FME from Build 17259 to 17539 (also 17650), our Workspaces produced nothing anymore.The results of the statistics are written to Excel-sheets, so I began debugging the workspaces and found the statistics calculators producing only null-values.Even after creating new workspaces with simple example data (creator, randomnumbergenerator) statisticscalculator outputs null-values.

The TESTER transformer let pass only 32bit INTs when using 'type is' Integer as operand. I need to test if the value is 64bit Integer or smaller (but no double or float).I used also AttributeValidator with the same result.