Transformers

I have a county road network from which I want to create a state route road network. I feel like this should be easy and that I am missing something, so I'm posting it here for advice. Say I have the following data:recordidcountyRtIdstateRtIdlrsBeginlrsEndx1y1x2y2*order*A1ASR1SR10100110A2ASR1SR11211221A3ASR1SR12333443A4ASR1SR13455665B1BSR1SR10222332B2BSR1SR12444554B3BSR1SR14666776B4BSR1SR16877887The table above, I want to calculate the order column. The x1,y1, x2,y2 values represent the begin and end coordinates of the linestrings to which each record is associated. The stateRtId is a known state identifier, and the countyRtId is our identifier for the county. In this example, ASR1 travels out of the county and then back in, demonstrating that the collection of linestrings by county is not always continuous. However, for purposes of this example, once can assume that all routes within the state route network are continuous. Essentially, since I can already group all the lines

This parameter is not documented.

question 1)I have attributes in a format that I would like to remove using the BulkAttributeRemover.e.g attribute names are in the format of :A_B_C_DA_C_D_D_EWhat is the regex code to remove any attribute name where the count of underscores "_" is greater than 2 ?the example of _{2,} only works if the searched character is next to each other. question 2)If i have a csv list (so manually using attribute keeper / remover is tedious) of attributes that need to be kept e.g.Att_ToKeep:1) Name2 Age3) Colorhow would i join it to a populated table to keep only the required attributes (as described above?

It seems the JSON Templater will render null in the following example:{ "Test": { }  } _result' has value `{ "Test" : null }'Is it possible to get it to render the empty braces as-is?Thanks.

I have an RGB TIFF Image which in ArcGIS is rendered OK. In FME the Red Band is however interpreted as GRAY16 and therefore does not render the image properly when transformed. Why does this happen, and how can I resolve it?

I think the error reported in this question is caused by a defect in the NeighborFinder.NeighborFinder: Try to get elevation but get this error: IFMELine was given an index beyond its current range This workspace reproduces the same situation. Could you please check this? (FME 2017.1.2)

I need to change a definition of a foot from Survey feet to International feet in the NAD83 Hawaii SPC 3Feet (HI83-3F) coordinate system in FME. I used the description in https://knowledge.safe.com/questions/41372/how-do-i-create-a-custom-coordinate-system.html and the tool at http://fme.ly/coordsys.I am using FME 2016.1.0.1 (20160516 - Build 16494)When I use either Reprojector or CsmapReprojector to convert from UTM with NAD83 datum, Zone 4, Meter to my new coordinate system I am getting the same coordinate as I get when I convert to HI83-3F.I need to verify that the new coordinate system is using 0.3048 as the meters to feet conversion value.

I'm trying to merge photos together (similar to raster mosaicking) but they have no overlapping features. Their file name shares a common value which I would like to use to merge the photos, but I can't seem to find a transformer/group of transformers to do this?Thanks

Hi, I would like to assign a unique count as a new attribute, based on the value of an existing attribute. I cannot find a solution: Counter, UniqueValueLogger and StatisticsCaltulator seem not be suitable for this. It is a large database. How do I manage this? I am not interested in the number of Pete's, Daisy's.Example:Old attributeDesired attributePete1Pete1Jacob2Daisy3Daisy3Daisy3  Sieger

I have an aggregate of 4 3D lines which are the outline of a vertical polygon. I want to replace it by a face and can't seem to do that. (In fact it is a wall of a building)I need LineCombiner to create a polygon which is prerequisite for the FaceReplacer.As it seems to me LineCombiner cannot handle vertical polygons and so I cannot create vertical faces.Please proof me wrong or let me know how to solve this.

Hi,Is there a way of finding the min x, max x, min y and max y cords of a DWG file without reading the whole file and then using 'BoundingBoxAccumulator'?The file is very large so I don't want to have to read it all first.I am using FME 2017.0 64 Bit Desktop.Thanks!!

Hello, I was initially running a python script outside FME to prompt a user for a said city to download data for. I would like to integrate that script as a "Python Startup Script", in FME 2017.1. I am stuck right at the beginning where I want the user to mention the city but the input caller stops the progress of the translation and the console log is waiting for something I am not sure how to enter. It would be even cooler if I could present him a dropdown list to chose from.county_name = input('City Name: ').title()The log window shows the following:FME_BEGIN_PYTHON: evaluating python script from string...Enter the City Name:...aaand I cannot do anything here. Or I am not aware of the input place.Any advice on how to overcome this?

Hello people I need help! how to generate RGB from a Geotiff.

Hello everyone,It's been a while since I posted the Flavour of the Month winner, so today we have two winners: one for November and one for December.NovemberThe top 10 list for November was:david_r: 1792takashi: 1541erik_jan:1140jdh: 735redgeographics: 422danilo_fme: 330mark_1spatial: 225gio: 1701spatialmary: 165larry: 153Remember, the winner is one who is in the top-10, with 100+ points, and hasn't won this award before. This makes the November Flavour of the Month: @mark_1spatial Congratulations! And a big thank you on behalf of everyone for the efforts you put into the group.DecemberThe top 10 list for December was:takashi: 1421david_r: 1348erik_jan: 700redgeographics: 652sigtill: 515egomm: 4651spatialmary: 4501spatialdave: 425, jdh: 425danilo_fme: 339With revesz close behind with 315 and runneals with 271.So congratulations to @sigtill. Having also won the FME holiday hackathon, it was a great month for him! Maybe the Hackathon votes helped propel him to the top of the list

When trying to reproject the data downloaded from this site / canada - New Brunswick (shape files): http://www.snb.ca/geonb1/e/DC/catalogue-E.aspI get2018-01-08 13:48:24| 0.5| 0.0|ERROR |CS-Map Reprojector: Unable to load grid file for 'NAD83_to_CSRS'I also downloaded the the FME Reprojection Grid Add-on at http://www.safe.com/support/support-resources/fme-downloads/beta/ but it didn't help.

I have a few hundreds of points and I'm trying to:1) 'Cluster' them spatially (max distance 25cm) and based on one common attribute while the number of neighbors can vary from 0 to 52) Calculate average position for each 'cluster' of points and replace their geometry so that all aggregated points have the same position (of course keeping the original attributes).I would be grateful for a hint, I've been trying different transformers and I can't find a solution.

I have 1 area Featureclass with 700.000 square of 5mX5m and 1 featureclass with 70.000 lines. I want to know for each square how many times it is touched bij a line. I have tryed [SpatialRelator] but after 14 hours FME was stil comparing, amd i tryed [LineOnAreaOverlayer] but FME gives a memory error. Is there maybe another way? Someone suggested [InLineQuerier] but i see no options to check if square is touched by a line.Thanks for your time.

Hi guys,  I've got an issue with the JSONFragmenter in FME Server 2017.1 (Build 17539 - win64). Well, I think I have... maybe I'm missing something!   Any non-JSON input seems to cause the workspace to finish with an error rather than carry on : "A fatal error has occurred. Check the logfile above for details". But there's no further clues in the log :Loaded module 'JSONQueryFactory' from file 'C:\Program Files\FMEServer\Server\fme\plugins/JSONQueryFactory.dll'FME API version of module 'JSONQueryFactory' matches current internal version (3.8 20170315).Emptying factory pipeline.A fatal error has occurred. Check the logfile above for details The same workspace runs fine in FME Desktop where any non-JSON inputs come out of the "Rejected" port and the workspace happily carries on (I've got "Rejected Feature Handling" set to "Continue Translation" in FME Desktop). I've added in a Tester before the JSONFragmenter in my workspace for now, but I'm curious as to why this is behaving differently

Trying to write from SQL server to MongoDB.It has a below structure:Geometry Type  Coords  [  [  [  [long, late], (pt 1)  [long, late], (pt 2)  ]  ]  ]  Can we store all the polygon data like the following:  Geometry:  Cords:  [  [long, late], (pt 1)  [long, late], (pt 2)  ]

Hi all,I'm new to FME and am trying to deal with a datset that has duplicates in. However each duplicate contains some information that I need to preserve into new columns. A simplified version is something like this: PropertyIDAddressContact nameContact details00011 High StreetMr Smith0121232800000011 High StreetMr Jones0121232800100022 Low StreetMr Birmingham0121232800200022 Low StreetMr Warwick01212328003 And what I need to end up with is more like this:  PropertyIDAddressContact nameContact detailsContact name 2Contact details 200011 High StreetMr Smith01212328000Mr Jones0121232800100022 Low StreetMr Birmingham01212328002Mr Warwick01212328003 It's been suggested to me to use FeatureMerger after multiple DuplicateFilters, but I can't figure out how to bring each set of filtered duplicates back in to a single dataset whilst preserving the data out of the duplicate entries.Any help, pointers or example workspaces would be greatly appreciated.Cheers, Mark

Hi,I want feature count in a variable, I am using statistic calculator for this purpose but it ask me for attribute to analyze but i want count for all features.I guess the below links are explaining my requirement.https://knowledge.safe.com/idea/45903/add-a-count-attribute-to-the-featureholder.htmlhttps://knowledge.safe.com/idea/48591/save-feature-count.htmlRegards,Dheeraj

Hi guys,i am trying to import some surveying data into a file geodatabase which requireds to have some standardised schema and unique identifiers.Because there are about 200 feature classes to read and 30 feature classes to write it's not very realistic to set up tester for each of them.. I have created a lookup table which include the feature classes names for the both source (from surveyed data) and final dataset. as well as the required field name and value for unique identifierBecause there are other fields required in the final dataset, i have created a fie geodatabase with all reuqired schema so hopefully there is a way i can just import the source data into it.Thanks in advance and a late happy new year to everyone :)