Transformers

Hello, I have a shapefile where some connected lines have to get connected and merged into one feature. However, it seems like there is a problem in my use of LineCombiner and MRF2DJoiner.Here is my shapefile : https://drive.google.com/open?id=1Iwe0FDMePozczihABOvJ_PBlre7xRAisAttached : a picture of a linear feature who has passed through the LineCombiner but still divided in 2 llines altough there are both connected. Thank you.

I am having a problem with the TopologyBuilder transformer. I have "Assume clean data" set to "No", but it is not cleaning the data properly. Some of the edges are broken up according to the other lines, but others are not. These images are the result of my TopologyBuilder transformer, with the vertical line in the middle starting as one long line before being sent to it. As you can see from the highlights, some of the lines are not being split properly.I have zoomed in on these features as far as I can go with QGIS and I do not see a gap between them. I would assume that this is due to some imprecision in the snapping tolerance but I cannot find such a parameter to adjust.This is the transformer as seen in the workbench:

Hello, I have a problem with the LenghtCalculator transformer. The point is that, when I calculate distances of linear segments I expect that visually long ones have bigger distance values but it's not exactly what happend. I want to use it along with a TestFilter to delete lines of lenght below a value of my choice. Thank you in advance. Here is the shapefile I'm working in : https://drive.google.com/open?id=1-vycWGAvos7pjCxE7tLXHroA69G1M5-G

Hi everybody, ik am trying to read an url that gives me json-format answer.the url is like: https://geodata.nationaalgeoregister.nl/locatieserver/v3/suggest?wt=json&q;=Nieuwe Steen 1 Hoorni want to read the values of the attributes "type" "weergavenaam" "id" "score"regard,Bert punt

I am trying to convert a dataset from XML (KuntaGML) to shape but cant get it to behave properly. I am using a dynamic workspace and the output is 80:ish shapefiles. Everything exports but loses its coordinate system and gets is geometry from the first feature read. I have tried adding the desired coordinate system up in the left corner of the workspace but it only seems to be written to half, or so, of the files output. As for the geometry I have tried both "from schema" and "first feature defines geometry" none of them make any difference, everything is output as points, even though all geometries are in the XML. What am I doing wrong?

Hi,I am currently trying to get a PDF2D file with several layers (a background map and some additionnal information). To do this, I used a sorter, a PDFPageFormatter and a Geospatial PDF writer.Everything works fine, except for the background part. I use a JPG2000 reader. No matter how I try to make a PDF out it, it fails (by failing I mean, the pdf file is created but no background is visible or it even makes Adobe Reader crash). I have tried with only JPEG2000 reader and PDF2D writer or this some intermediate transformers, nothing seems to work.Are there any parameters I missed?(I use FME 2015.1.0.0 and Acrobat 8). Acrobat 8 always crashes when loading the resulting file. Acrobat Reader XI somehow manages to load the file, but even if the layers are there, the background layer is empty and so are most of the other layers)

I'm trying to calculate the percentage of null values per feature class in a dataset. Null values are defined by '-99999' or 'noinformation' or 'No Information'.I have hundreds of feature classes, each with hundreds of attributes named differently. So building a workbench calling out each attribute specifically would be very time consuming. This needs to be a dynamic solution.So far I've tried an AttributeExploder followed by ListSearcher, but I'm having trouble calculating totals based on feature class.

The attched FFS file contains multi-geometry objects where one or more of the parts are arcs. I need to do some checks on the parts that are not arcs. So far I haven't been succesful in getting only the non-arc segments out, so any suggestions would be very welcome.I tried the GeometryPartExtractor (checking for child elements of type IFMEArc) but that only selects the entire object, I want to break it up.And stroking the arcs is not an option...

Hi, I use XML flattener like this to expose an element. What I want, and what this does, is make a column with the element name as its name, and put the value of the xml element that was matched as its value. The problem is when "ElementToMatch" occurs multiple times in the XML file. It only makes one new column and puts the first occurring value that was matched inside. Is there a way to make as many columns as needed so that each found value ends up in the results? Order and empty values (if only one is found for example) don't matter.Thanks a bunch in advance.

Hi there,I'm looking for a way how to bring together these two data-sets.  1st data-set contains records with unique ID and several attributes: Connect_ID Facility TypeName 3 Cafe Ice-creamAAA 12 Store GroceryBBB 25 Store ElectronicsCCC   2nd data-set contains IDs, days and operational hours:Connect_IDDay of the weekOpensCloses3Monday8:00:0018:00:00 3Tuesday8:00:0018:00:00 3Wednesday8:00:0018:00:00 3Thursday8:00:0018:00:00 3Friday8:00:0018:00:00 3Saturday9:00:0014:00:00 3Sunday12Monday8:00:0017:00:00 12Tuesday8:00:0017:00:00 12Wednesday8:00:0017:00:00 12Thursday8:00:0017:00:00 12Friday8:00:0017:00:00 12Saturday9:00:0015:00:00 12Sunday25Monday8:00:0018:00:00 25Tuesday8:00:0018:00:00 25Wednesday8:00:0018:00:00 25Thursday8:00:0018:00:00 25Friday8:00:0018:00:00 25Saturday9:00:0018:00:00 25Sunday   What I would like to do is bring these tables together, but they should have 1 row per ID, so the days and the opening hours should be transposed to

Hello all,I have a problem with catching Turkish Unicode characters in StringReplacer and StringSearcher transformers. "\\w" function doesn't catch " Ç ç ? ? ? ? Ö ö ? ? Ü ü" letters. It works when I put these letters in the search bar. Also, I checked the same letters on www.regexpal.com and it didn't work too. Is there any solution to catch these letters with "\\w"? Otherwise, I need to change these letters with other special characters which don't exist in Turkish Alphabet at the beginning and the end of the Workspace. ThanksDeniz

Is there an easy way to populate an entire column (I have multiple columns) based on the value in that column that has a comma in it?Basically, if I have a column named pole and all attributes in that column have the value of "pole_status" except for one value that has this value: "Con, PLA, MRC, MRE". How can I populate the entire column with "Con, PLA, MRC, MRE".I've tried Attribute Manager using a Conditional Value to filter out all records that don't have comma in it but then I'm not sure how I can actually use the "Con, PLA, MRC, MRE" value as the output value. Maybe there's a better option. Custom Python might do the trick - but I want to exhaust all of my transformer options before I go that route. Note: I cant simply write "Con, PLA, MRC, MRE" in the AttributeManager since these values will change and there's multiple columns - si it wouldn't be sustainable I also know I can probably accomplish this by us

I am trying to troubleshoot why a cloud workspace won't run with data and I am getting this response from the server."request": "\\"DataProcessing/FieldDataLineCreator/FieldDataLineCreator.fmw\\" -XML_PARAMETER {\\"remote-addr\\":\\"127.0.0.1\\",\\"host\\":\\"production-tgs.fmecloud.com\\",\\"user-agent\\":\\"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0\\"}C:\\\\fakepath\\\\1801116-012618RF(TGS_Export_v2).csvhttps://production-tgs.fmecloud.com/fmedatadownload/DataProcessing/FieldDataLineCreator.fmw?detail=high{\\"opt_responseformat\\":\\"json\\",\\"SourceDataset_CSV2\\":\\"C:\\\\\\\\fakepath\\\\\\\\1801116-012618RF(TGS_Export_v2).csv\\",\\"detail\\":\\"high\\",\\"opt_showresult\\":\\"true\\",\\"token\\":\\"\\"} --FME_SECURITY_USER \\"\\" --FME_SECURITY_ROLE

Hi,I was wondering if it's possible to connect to Azure Stream Analytics and from the output, create a dynamic KML URL and/or a GEOJSON source to connect other applications to. If so, at what cost?Thanks

Hello,I have around 200 rasters (in ascii format, all in the same folder) that need to be converted into polygons based on a certain threshold pixel value (as an example, for one of the rasters the final polygon should include any pixels above 0.4). Unfortunately, the big issue is that the threshold value changes for each raster (0.4 in my example, but could be 0.5, 0.6, etc for other rasters). I have an excel table with the raster name and associated threshold value but I can't figure out how to make a workflow where the raster name is then used to lookup the matching value in the excel table and then use that value in the RasterExpressionEvaluator and subsequent RastertoPolygonCoercer transformer.Thank you for any help!

Hi everyone,  I was wondering whether anyone had strategies for automating the georeferencing process. I have a raster displaying parking lots and am trying to create a dataset that shows the painted parking space lines. In the past, I've manually drawn the parking space lines, but was wondering whether anyone had any suggestions on how to automate this process.Basically, I've been thinking about how to draw a rectangle over the entire area of the parking lot and then somehow divide the parking lot into a specific number of spaces. However, since each parking lot has a different number of spaces, I'm stuck on how I'd automate this process.Any ideas?Thanks

how tow convert dxf to gbxml

Hi, I just jumped into FME world and get stuck with it. I have a data file of location based network and need to do analyzing with it. The file looks like thisUserID VenueID VnueCat VenueName Lat Long Offsetminmute UTC Time470 49bbd 4bfds Arts & Crafts Store 40.719810 -74.0025 -240 Tue Apr 03 18:00:09 +0000......1. I need to convert the UTC into local time zone2. How can I create a new dataset with specific UserID3. How can I find any 2 different UserID which have same Lat, Long and LocalTime attributes and create a list of them come along with same attributes.I have attached a small sample of the datafile below. Please let me know if you need full data file

Hello,I have a complex xml file and have created a xfMap to translate it. However the reader terminated the whole process when it failed to translate one feature due to it doesn't have the required geometry info (Line0008 as in the code below).I'm wondering if there's a way in xfMap to handle errors by using something like try...catch or if..else. Or should I validate and fix the invalid features using something like xmlvalidator and updator before translating it using xfMap? thank you.<PlanFeature name="Line0007"><CoordGeom><Line oID="Line0007_0001"><Start pntRef="TPS0021">5813350.321246 317541.885870 2.430529</Start><End pntRef="TPS0022">5813350.289701 317542.164240 2.460172</End></Line><Line oID="Line0007_0002"><Start pntRef="TPS0022">5813350.289701 317542.164240 2.460172</Start><End pntRef="TPS0023">5813349.458068 317542.315624 2.497628</End></Line></CoordGeom></PlanFeature><PlanFeatu

Hi all, I have an oracle SDO geometry table containing multiline features. These features should be contiguous collections of point-pairs. i.e. all endpoints should touch another point-pair from the same feature. the features can form a string of point pairs ('~'), but also a 'Y' type of topology, or something more complex. However, the feature should not consist of sub-parts that are not connected to each other (e.g. '~ ~' ).How can I test for this requirement to be met ?I think I should somehow be able to count what Oracle calls the parts of the multiline object, but it is not clear to me if I can call these oracle constructs from FME, or what FME equivalent to use. Can you point me to some example or helpful bit of information for this type of tests in FME ?Regards, Ronald

Hello,I am trying to insert vertices at the end of lines, using the vertexcreator and 'insert point at index'.To do this I am using -1 for the index, but this adding the vertex at the point one before last (see image). How can I get the extra vertex to be at the end?Thanks, Owen

Hi, I'm executing the following queryselect 'PT' as TEST, sdo_geometry (2001, 9999999, sdo_point_type(1673919.702, 513986.296, NULL), NULL,NULL) as geom from dual;which returns (in sql developper) a geom value of MDSYS.SDO_GEOMETRY(2001, 9999999, MDSYS.SDO_POINT_TYPE(1673919.702, 513986.296, NULL), NULL, NULL)How can I add such query in sql executor so that the field geom will be considered as the geometry of the feature?  Rigth now there is no 'geometry' in the inspector   Thanks

I have two line datasets. Dataset A was created by using the snipper on dataset B (attributes BeginMeasure and EndMeasure), resulting in 15 segments in dataset A. They are both saved in SDE. Now I want to use the LineOnLineOverlayer to segment dataset B (only 1 segment before segmentation). I would expect that there will be 15 segments with _overlap = 2, and attributes from dataset A at each segment. Except that is not what is happening. There are only 10 segments with _overlap = 2, the rest are 1, which indicates that the two datasets do not overlap completely which is weird since A was created by B. I'm attaching the ffs for each dataset as well as the result ffs. What is going on and how do I fix?

Hello,I am starting using FME Workbench and it's amazing!A quick question as I can't manage to achieve what I would like.Basically I am starting with 2 features, Airports and Runaways. I have a OneToMany relations between those 2 features.What I would like to do is in that my final GEOJson looks like bellow, meaning that the list of my runaways with their properties + geometry if needed are nested into the Airport feature.I managed well using InlineQuerier to have the data I need and execute the join I need the thing I don't know is what is the flow to build properly the GEOJson as I want. { "type" : "FeatureCollection", "name" : "Airports", "features" : [ { "type" : "Feature", "geometry" : null, "properties" : { "someAirportProperty" : "someAirportValue", "runaways": [ { "someRunawayProperty": "someRunawayValue" } ] } }, ]}

I have a workspace that can generate a table with permutations of rows = 1 to x and rows = 1 to x to possibly create table variations from 1x1 up to at most 10x10 (see pictures). I'm looking for suggestions on how I can create images out of the table created. I'd like to see the format similar to the picture I attached. My 3rd sample is a 12x12. I'm using this pictures for a underground conduit inspection form. Sequence as well as matching picture matter to the users. Attached is my workspace to generate each table. I'd love to be able to create all 100 pictures using one workspace.