Transformers

Hi all  I'm about to make a spatial query from two tables. One is a SQL-Creater with a MSSQL Spatial driver. The other is a WFS with polygons. (I have to read from MSSQL by SQLCreater because of a complex nested query that won't fit into the MSSQLSpatial Reader. I've tested the query in MSSQL Server Management Studio and it works just fine with geometry attached).  I've loaded the PointOnAreaOverlayer, however it doesn't seem to fetch the GEOMETRI-column in which the geographic data is.  Is it a setting in the SQLCreater or in the POAO that has to be made for it in order to make a spatial join?  

Hello FME community!I am working on a project to identify traffic congestion within our mining operations. My data source includes GPS points of all vehicles and I have done the work to 'connect the dots' of all GPS points to create speed segments. As you can see in the image below, I now have traffic routes for each individual vehicle.What I am trying to do now is create a "Median Line" for each side of the road, by determining the median value for the segments within a certain distance (i.e. 100m), just like the Traffic layer in Google Maps. My thoughts are to use a "Line Splitter" to split each segment into 100m parts, and then "Nearest Neighbor Aggregator", followed by a "List Exploder", then an aggregator to calculate the median.Input: Desired output:

Hi all,What's the best way of getting FME to populate an attribute field in ArcGIS geodatabase point feature class A (areas of interest) with the total count of features from dataset B (assets)? I.e. find the total number of assets within 10m distance of sites?I thought the Neighbourhood Finder or Point on Point transformers followed by a Statistics Calculator should do the trick, but can't get it to work.Thank you!

Hi, I am trying to convert 12Dxml string data to other datasets but really struggling with the way the geometries are being read by the 12Dxml reader.I am not trying to do anything fancy just read the file. from 12Da file  from FME

Hello everyoneI am new using FME Workbench and I am having some difficulties. My problem it is related to LAS dataset. I have two lasdatasets from differents providers, the first one is Spanish Geographic Institute and the second one was generated from Agisoft photoscan after processing Drone made ortophotography. I have convertedboth into the same coordintate system, concretely, ETRS89 (the legal one in Spain) and when I trate to fuse both clouds using aggregator, x and y points fix perfectly but Z values has a difference of 50,96 m. I applied too 3D forcer and Offsetter but the results are the same. How I must to proceed in order to fuse both Las dataset without the 50.96m difference in Z field?Thank you very much!

i would like to ask ,after i read my data from reader .i have around 8 reader and i would like the first reader that reads polygon to start processing through some transformers and stop when it reachs clipperbut i found after it reads the data ,it did not pass through the first transformer and the workspace continues reading the data from another readers and after all readers finish ,it comes bk to continue work on this reader for polygon .what i would like exactly,i need to extract the data from the first reader and continues till it reaches clipper and wait another data .because,i think that clipper is working at end of my workspace so it takes too much time to process . i read some articles about runtime order but i think it is only working for creators that has no input if i understood correct but if i have transformer with input .How could i let this transformer work before another path .as featuremerger and clipper

Hello, Would you be how to merge the linear array of a Dwg file to form a single polyline. I had thought of NetworkTopologyCalculator I do not know what you think? After having combined (merge) the linear network all together, I have to put it in the same direction and after that I cut it at the points that belong to the layers of my Dwg file that I specify. I would tend to use Linecombiner or LineExtender. If you have an idea of how to proceed I am a taker? In all thank you in advance for your help.

Hello, is it possible that someone share with me the knowledge how DecimalDegreesCalculator transformer exactly is calculating the decimal degrees from Degrees Minutes Seconds (DMS)? Is this the formula for it? Decimal Deg = Deg + Min / 60 + sec / 3600

Hi All,I am trying to split the attribute in the text string, which has old and new attributes with same id and then make selection for specific attributes like surface ,highway. Final action is to create the column for each split attribute . Attribute listed in the text string are different every time and not in sequence so i am not sure how i can create columns dynamically. screenshot of the input dataTried solutions : I have tried to do this using the attribute splitter and list expolder and then extracting attribute per columns but now i am getting too many columns for each id.can somebody suggest ?

HiI would like to create two new attributes from a linear WKT text file. I need to create one new attribute for the first pair of coordinates and one new attribute for the last pair of coordinates. (It's critiacl that the number of decimal places is retained)I have managed get this to work in a fashion by using the attribute splitter then attribute creator. As the first pair is always at _list{0} in the list.I have more problem with identiying the last pair of coordinates as there could be over 200 pairs of coordingates in the linear WKT field.I've managed to create a new column that identifies the number of coordinates in the string and thought about using a test filter to split the data by number of coordinate pairs then assing the correct _list{x} value however this isn't practival when I have over 200 variations in the count of pair of coordiantes.Is there a simpler way to extract the first and last pair of coordinates from a sting

Hi,i have ca. 13000 lines (always two vertex) and i need to write the coordinates into an attribute.I know i can use the Feature Function @XValue and @YValue and the list value 0 for the first point and 1 for the last point but I cannot find the right syntax...can someone make an example for me please?Like....@XValue(<0>) ?@Xvalue().0?Thank you,Davide

Hi there! I'm using MapnikRasterizer, PDFStyler and PDFPageFormatter for creating PDF documents.  There is some static text content in my PDFs like Title, Subtitle, Copyright etc. This static text content is created by Creators and the text is defined as Geometry Type:Text and set as Text String. All works fine.  Now, I want to print the current date (today) into the PDF using DateTimeStamper and DateTimeConverter. I formated the date attribute using PDFStyler and connected it to the PDFPageFormatter, but the date (frame) is missing in the resulting PDF.  Any idea how to print the current date into a PDF? For example by replacing the Text String of the Creation instance dynamically by the current date? Or any other way?  Best regards  Oliver

Hello everyone, So I have 4 georeferenced JPG images that I need to paste together. I wanted to use the RasterMosaicker to do this, but it seems like FME is not picking up the georeferenced data behind the images. The 4 JPG's should lay nicely next to the other, but instead they lay on top of each other.I have tried a few things but I don't know how to fix it. I already told the Reader which coordinate system the images were georeferenced in. I tried different types of readers as well.I'm just trying to paste these images together without the color changing. When I tried to paste them together using the Mosaic to New Raster tool in ArcGIS Pro, the color of the map changed to a lighter shade. The color is very important since I use the color of the images to classify it later using Supervised Classification.Does anyone know how to fix this?Thank you in advance! Edit: I have added two of the images in a

Hi guysI'm trying to understand how to extract data from website but it's very hard (I'm not a python expert so FME is the perfect solution but......)If I inspect the webpage it's very easy to extract the css selector then ........ it's very hard to use in FME for ex I have this css selector for different value#ctl00_mainIndexContent_pnlRisultati > table > tbody > tr:nth-child(3) > td:nth-child(1)#ctl00_mainIndexContent_pnlRisultati > table > tbody > tr:nth-child(3) > td:nth-child(2)#ctl00_mainIndexContent_pnlRisultati > table > tbody > tr:nth-child(3) > td:nth-child(3) what I have to write in the field css selector of FME to retrieve the data ? thx in advance Francesco

I want to create multiple zip files of folders and sub folders but only want it to include AutoCAD drawing files, not any other files that may be in the folders and subfolders.I have tried the ziparchiver which is very nice but it zips all files.Any help would be greatfully appreciated.

Opening WFS data inFME loses geographical coordinates present in database and geometry type info?

I have a dataset where in some column the numbers are "N/A" and that attribute is in char. Which transformer I can use, so that it can read N/A and gives me N/A in writer.

I only need a certain dateTime values from a json source (a tide gauge) to get the water level associated with a coastal Sentinel-2 scene. I can get the water level for a particular time from the json data as it is the same list value (the satellite always comes around the same time) but the only way to set the date seems to be in the source urlhttp://environment.data.gov.uk/flood-monitoring/id/stations/E71739/readings.json?date=2020-04-15The date I can get from the filename of the downloaded Sentinel tiff file but there seems to be no way to pass the date into the reader URL string.Any simple ways to do this would be great :-)

Trying to file a problem using https://www.safe.com/support/report-a-problem/ But... when I hit send it says page expired

hi Conditional statement "Attribute has a value" fails to ignore null /blanks.and formats the date as 1900-01-01 00:00:00.Not every record in my dataset has a value in comnDate . I need these dates to remain blank or null  How do I get the output to be null if it has no value or is null, but still format the date values that exist in the table. Thanks Lizzy

Hello, When I open my Dwg file in autocad I notice that I no longer have any vertex in my output Dwg file after performing the transformations, can you help me recover them? here is my FME file if you could correct it for me or add the transformers necessary for it to work.  thank you in advance

Hey everybody, As this community has always helped me this far. I got a question which seems pretty easy but I just can't seem to make it work. I have polygons each with a fixed elevation. Now I have to replace this elevation attribute value with a minimum value of a staticscalculator. I have been working around with the 3D enforcer but nothing so far yet. I always get an error that the elevation parameter is invalid. What is the way to set the value of this elevation to a value i got from a staticscalculator? Thanks in advance,

Hi!I have a lot of elevation profiles. These profiles have polyline geometry. I want to add additional vertices to profile lines with custom step of elevation (f.e. each 1 meter of elevation).Do you have any ideas how to do this task?Many thanks beforehand!

Hi there,I am struggeling how to solve the problem.I have got 80000 Polygones and need to filter them into a smaller groups.see the screenshot:they have one attribute, lets say "CODE" with which I could filter them (01001; or 01002 etc.).this should gives about 430 groupsOf course I do not want to filter them manually. is there any option to filter them with something like a batch filter? To find the same values > when the same value > write them in the 1 group, or somethng simmilar.  after that need to write theese "group infos" into a polygone geometry.  I have a polygones which have the same attribute "CODE" (01001; 01002...) was thinking again about "featuremerger"But I do need to keep for example all 13 features from

Hi guys,in Arcmap i usualy calculate a attribute/field value "Vertices", where are noted numbers of vertices on polyline feature. I do it with Python phraser and simple code: !shape!.pointcount. Can be this field value calculated via fmes Python caller and how?  Thanks in advance for any help or other solutuion.Bye, Miha