Transformers

Hi,I'm having this error when I try to write the values in postgres through fme tool. The attribute has 6 possible values (0-6). what is the best way of solving this problems.Value of attribute 'n_lane' could not be converted to type 'int2'. Feature will be logged and skipped.And then at last the tool throws an error of insufficient memory available.I mean I really don't understand how to solve this issue..Please someone help me out with this.I'm attaching a photo so that you can have a clear vision of this error.​

I have an 8-bit mixed raster, where there are numeric values from 0 to 100, and then certain values over 200 are classified, 200 = water, 205 = snow, etc.Unfortunately there is a bit of noise in the data where there are single pixels coded as water (200). I would like to remove these individual pixels, replacing them with either a mean or majority filter (of 0-100 values only), without affecting any other pixel including 200 value pixels that are contiguous (so a straight convolution of the raster is out).The closest thing I can find is the Erdas Imagine Clump (to identify contiguous pixel groups) and either Sieve or Eliminate to replace groups smaller than a given threshold.

First, I have straight lines that are connected, then i extract end points and mid point (which I offset in direction of Z axis). From there I use these points to manually draw arc that connects these points. I want to know is there a possibility to automate this process. These lines are representation of wires between poles. I'm new to this software and don't have much of knowledge so any help would be appreciated.

I'm working with the ChartGenerator Transformer to create a bar chart and have two questions:1) How can I change the bar colour so each bar is a different color? I did find a post to change the RGB to (0-1,0-1,0-1), but my entry is still pink, so I can't use that.2) How can I add a label showing the number of items at the top of each bar? The PowerPiontStyler has an option for "Label Data", but I don't see one within the ChartGenerator. Currently, my table is shown like this:

In the training examples for converting from ifc to citygml, the site information is not taken into account.How can I keep the site information after converting it to citygml?in another meaningIn the attached file there is a structure in .ifc format and I want to create a writer on FME DESKTOP in CITYGML format. How can I transfer the location information to the CITYGML writer without lossing any of it?

Hello! I have two data set that I want to join spatially and not by attributes because there are no common fields. I want to merge (for example a layer of cities and a layer of population (I want to merge to know how many people they are per city). I tried spatialrelator and featureMerger but I failed Thank you for helping 

Hi altruist, I have a set of data MITAB data in LL-GDA94. Which transformer should I use if I want to transform it into GDA94?

I have created a colored mesh from a LAS file using PointCloudSurfaceBuilder and would like to write it to an OSGB file. My overall intention is to convert the OSGB to SLPK using ArcGIS Pro, as the FME I3S SLPK writer does not produce good results.  After writing the OSGB file using FME, the colors are gone, as the front appearance is set to one single ambient and diffuse color. Is it possible to multiple colors per mesh part?  Thanks in advance for Your help!  

What does ifc coordinate 0 mean as shown in the pictures What is the coordinate system for the reader that we have to add? Do we add ll84 or x-y M?

I'm attempting to extract a link from html that looks something like this: <a class="email-link" href="https://app.myapp.com/results/a7696ced77454dd39d8241e79f981b3d">here</a>. using the xquery extractor. the x-query //a/@href seems to work in the online testers but not in FME. Any ideas?

I have dynamically transformed CRS system of the tables (MGA94-56) from MSSQL database and then written into another MSSQL database (MGA2020-56) with same table schema. I can see the new tables exist in the SQL server. Also When I am checking the tables on FME workspace by using CoordinateSystemExtractor, I can see the tables are transformed. But the data is not displayed on QGIS, though attribute table can be seen. Also in QGIS property option, the CRS system is still showing the old one. Can anyone kindly tell me what could be the likely reason/s?

Looking for alternative ideas/methods to texture a set of 3D terrain TINs which are tiled with images from some kind of image service (WMTS, WMS etc). The images and TIN tiles don't share the same extents My current process involves the following steps: Fetching and georeferencing the images, Merging the images in to one mosaicClipping/Tiling the mosaic to match the TIN tiles (here I also pick up the tiles ID)Use the AppearenceSetter (Grouping by the TileID to set the texture on each TIN tile). Here i use the TopDownGeoreference methodWrite the tiles out to format X (e.g, OBJ) Performance is slow(est) at the Mosaicking, Clipping and the Writing out parts (2, 3 and 5). Now, I see that FME 2022.1 has the option to now Clip surfaces which are textured. I'm thinking about changing the order a bit here to try and take advantage of it but before I did I was curious to see if any

I am currently switching a project from Arc to FME and I am replicating different Arc operators to FME ones. I currently have a problem regarding RasterResampler as outputs from Arc and FME differs though using the same specifications (cell 0.05 and bilinear transformation).I am including a zip folder containing input maps, output after transformation from Arc and FME and the FME tool. I also tried a workaround, but it creates more transformers, doesn't get better results in general, and defies the point regarding processing time. Thanks Sébastien

Hi, Basically, I have two point clouds that overlap. One with colour, and one without. I want to find the nearest point with colour to every point without it so that I can use the colour from the nearest point I can do it by:Coercing the subset of points without colour into individual pointsMapping the XYZ of the coerced points to an attributeMaking a small buffer around these points (say 2.5cm/1 Inch)Then clipping the remaining cloud to a small area around each buffer (creating a large number of small point clouds that have the XYZ of each original point without colour)Turning the coerced XYZ attribute values into a component of the small coloured point cloudsFinding the smallest distance of each point cloud between the coerced XYZ component and the coloured XYZ component Using that smallest distance to find one point in each cloudReplacing the XYZ of the nearest neighbour with th

Hello, I have in my attribute, words separated by comma. I would like to have a word by attribute not all the words in an only attribute. I used "AttributeSplitter" , a list has been created, then I used "Listexploder" and I have my words (which were in an only attribute) separated but not in several attributes for the same feature, it created several features! I want separate word (which were separated by comma in a attribute), in different attributes (one word by attribute) with the same number of featuresThanks ! 

I would like to have overlaps of the features by creating attribute with all the names of the other features which overlaps. I used AreaOverAreaLayer but It's not what I'm looking for. With this transformer, I only had the number of overlap.Moreover, with this transformer, if a feature (polygon) is overlaped at two different location of this polygon, it creates me 2 features different, but I want an only feature for a polygon. A feature by polygon. Thank you !

I have two datasets from OSM for a small region: roads and waterways. I want to count the "bridges" resp. all kinds of crossings between roads and waterways in FME. I can't find the right Transformer to do this (or I just don't see the right options if I already found a suitable transformer). I tried e.g. "Intersector", "LineOnLineOverlayer", "SpatialFilter". Maybe I'm just missing a small detail. What Transformer and options should I use? I got helpful hints here at gis.stackexchange.com, saying that I could use an Intsersector, a ListHistogrammer and a Tester. Unfortunately, this does not work for me: 

How to convert from IFC to CITYGML with correct georeference to UTM84-37S ?

I have connected to an API to download data to create an automatic process. The data covers the whole UK so comes group by region in folders, but I can not figure out how to expand these folder to have the remaining SHP files inside for clipping and symbolising etc. Im sure there is a tool for this I am probbaly unaware off. (See image)

Hi Altruist, I would like to bulk reproject on a number of database table in SQL spatial server and write (update) the tables into same database after the reprojection. All tables are in same CRS currently but obviously schema are different. Can anyone kindly suggest a tutorial/workspace of same sort?  best regards and thanks in advance.

Hello,I am trying to set up a simple flow to automatically copy new or changed data from multiple excel sheets into the master Excel sheet that lot of PowerBi dashboards feed from. The flow is simple as follows:-Read from sheets -> Attribute Manager (rename to match main excel) -> Change Detector -> Attribute Creator (fme_db_operation (UPDATE)) -> NullAttributeMapper -> Writer. Problem is at the last stage, the writer is not updating the main sheet and could not find the correct setting messing around with the writer parameters. Any help would be appreciated, I have attached the screenshots below.

I have a dataset which contain null/non-null values in a particular column, I have to segregate it in the way that if any null value exists, all null/non-null values will go in 1 direction else only the non-null values will go in 2 direction (port), help?

I'm having trouble pivoting a table. Here is what I am trying to accomplish: Is the AttributePivoter the correct transformer to use? Thanks in advance, M

Good day, I would like to ask. I am currently solving the tracks in the WS in the attachment. I ran into a data "loss" issue happening on featureMerger. Points from the polygon of interest go to the Requestor's input, and points with the same ID as the requestor's input go to the Supplier's input - these points are part of the RouteSegment. Now to my problem. I believe that I don't have all the data on the FeatureMerger output because I only have each point once on the requestor input, however, I can have a point multiple times on the suplier input and it can be part of different routeSegments. At the moment when a point at the requestor input is "reserved" by the first point of the same ID on the supplier, at that moment the rest of the data goes to the Rejected output. I can think of creating X featuremergers, where I would send the rejected data to the input of the supplier and the original polygon_selection_topsky s

I'm new to FME and impressed by what can be done with it. However, I got stuck regarding some details. I have a PointOnAreaOverlayer transformer and I wonder why the Point output port let's me use all attributes, whereas the Area output port generates no output for some attributes that I need to use. What is the solution here? Thank you!