Transformers

This is more of a workflow question, but using FME to do so.  New to FME, but basically I have a Microsoft SQL Spacial Table that has geometries/polygons in it that I want to display on a Google Map. These polygons represent land ownership, which is basically what Google Maps shows when you fully zoom in. (See the attached image below. i.e. For Crafton Tull you can see the 3d building and then the polygon around it that is the property boundary.) What I want to do is automate the transfer of the Microsoft SQL Spacial Table geometries & associated data into a format that Google Maps can use. The simplest option seems to be to pull it into a Google Fusion Table, but I didn't know if others had recommendations. I found this old FME blog post that talks about using Google Cloud SQL but that seems more complex. (Fusion tables are very easy to use... But the future support for them is unclear.)https://blog.safe.com/2015/01/6-google-maps-engine-alternatives/Any other / better s

I want to map values from the following feature:Myfeature:- x = 100- y = 100- z = 150Based on the following rulesnewattribute = a if z > 0 and z < 50 newattribute = b if z > 50 and z < 100 newattribute = c if z > 100 and z < 120  newattribute = d if z > 120 and z < 175 So this feature will get the attribute:newattribute = dI can not seem to find an example with the schemamapper (or any other solution which is NOT Python-coding).The issue is that I have alot of changing interval-rules, in a database - so they can not be hardcoded in the workspace - but have to be read from a csv / Excel-file so the Schemamapper would be great if it could handle larger than and smaller than etc.

I have data stored across multiple DBF files.DBF1 contains data stored as follows (sample):ID ---------DEMAND-------PATTERN1123-----------5---------------0.34553456-----------3---------------0.32122322-----------2---------------0.2112DBF2 contains data stored as follows (sample):ID----------------ZONE1123------------ZONE13456------------ZONE22322------------ZONE1TOTAL_DEMAND for a particular zone is calculated as the sum of products of the demand and pattern for all the ID that lie within that ZONE.Ex. for ZONE1(which contains 1123 and 2322), TOTAL_DEMAND= 5*0.3455+2*0.2112I need to create the final results tabulated as follows:ZONE-------------TOTAL_DEMANDZONE1-----------(calculated as above)ZONE2-----------(calculated as above)The task is easier with VLOOKUP in excel, but I am not able to find suitable transformers to do the same in FME. Please suggest a suitable method.Suggestions regading use of a programming language(such as python) to achieve the same are also welcome.PS- Hiphens

I regularely see the following line in my log-windowprocessing [#####] elements with mode CLASSICSometimes I stop and wonder about this, so now I thought it time to ask 'the world':What does this mode CLASSIC mean, and are there any other modes?Kind regards,Martin

Folks,I have a challenge and I'm not sure if FME has this capacity. I have some Mapinfo co-located points that need to be written as attributed blocks. This I know FME can do and I have done this successfully. Now the challenge has been set to come up with "placement rules" that "move" each block insertion such that it DOES NOT overlap its co-located partners.As far as the logic is concerned what I would want to do is test each input object(point) to see if there are co-located points. Then based on the number of co-located objects loop through the objects placing them at some fixed incrementing\\decrementing Y(North South axis) coordinate.eg var NumPoints = 5for i = 2 to Numpointsfetch rec(i)insert block X,Y+(i*-10)next Is there any sort of construct that would support this?I'm also aware I'd need a way to ensure I didn't test an already tested point and inserted\\offset block.Any advice appreciated.

I have a set of data that contains on each row a highway, start_mp. I want to find, for each highway, the min(start_mp) and the max_start_mp and combine them into a single row of data ordered like: HWY, MIN(START_MP), MAX(START_MP), other attributes.

Hi all,I've got a question about integrating ArcPy in FME. It would appear that FME won't let me to read in multiple features and process them using ArcPy functions through PythonCaller. This can be easily done outside FME with one line of code such as:arcpy.LocateFeaturesAlongRoutes_lr(feats, rts, rid, tol, tbl, props)What I would hope to achieve with PythonCaller is that it can be used just like one of the transformers like clipper and buffer. Not sure anybody else has experienced the same issue?Thanks!

Could really use this function extensively, but almost all our data is Date variable - eg Groundwater and chemistry. Is there any news about fixing this bug? Eg FME 2018.Gecko On. Gecko Up.

I'm trying to create (FME-)features from a JSON-ouput (source: JSONFragmenter).I am not able to subtract/expose "geometry" and can't figure out why.My JSONFragmenter parameters are:JSON Query: json["features"][*]Attributes to expose: id geometryCan someone help me out ?Example of JSON-output:{    "type": "FeatureCollection",    "totalFeatures": 1681523,    "features": [        {            "type": "Feature",            "id": "GBG.23662",            "geometry": {                "type": "Polygon",                "coordinates": [                    [                        [                            134465.638337,                            192310.473928                        ],                        [                            134465.881025,                            192308.624072                        ],                        [                            134470.076353,                            192309.29684                        ],                        [                     

I'm using the HTMLReportGenerator to build a simple HTML page with a map (and charts, tables, etc.). I'm trying to use the Mapbox leaflet option, but encountering some issues. Given I'm new to MapBox, I don't know if I'm just going about this the wrong way.I can specify which MapBox style to use by entering mapid value, but this seems to work only for the default style - if I enter 'mapbox.light' as the map-id value then the MapBox Light map is returned - great. If I enter 'mapbox.mystyle-test' then I was expecting that my custom built style 'MyStyle-Test' from MapBox would be returned, but I get nothing returned. Have I missed something? My second issue is styling data that I add to the map by passing the features into the HTMLReportGenerator. I've added a MapBoxStyler transformer before the HTMLReportGenerator to style my data (for example set points to a red circle). But when I build the map using the MapBox leaflet option and using th

I recently noticed that the beloved Logger transformer – number 49 on the popularity list, as of this writing – also has a very interesting alias.Behold,.. the Lumberjack transformer!Next time you are debugging your workflow, why don't you try throwing some Lumberjacks at the problem?Which has me wondering... Are there any other aliases out there which are equally amusing? Or what transformer do you insist referring by its alias rather than its "proper" name? What alias do you want to see!?

I have a little challenge that i am not sure how to tackle. Hoping for some hints. I have a large obj model. I can import this and it describes a surface of a land area.  What I think I want to do is take a seperate set of polygons (3D) I have for building footprints (all flat but in 3D) I then wish to use these polygons to "slice" the bottom of the buildings to generate building shapes which I want to assign an attribute (its identifier) from the polygons which do the slicing.   I am thinking clipper and buffer but not sure whether it preserves Z values for the surface bottom.  My data also has an arbitary 0,0 so will have to move the origin and stuff doesn't 100% line up. That's something new for me also.

   I am new to FME and need to perform an intersect with a specific cluster tolerance. In ArcGIS Pro you can set the cluster tolerance during an intersect (http://pro.arcgis.com/en/pro-app/tool-reference/analysis/intersect.htm) but I don't know how I can reproduce this in FME? The clipper does not have this option and there is no "cluster tolerance" transformer. Any suggestions?

When using the FME Quick Translator to convert CAD from Autodesk AutoCAD Map 3D Object Data to Esri Geodatabase (File Geodb ArcObjects) as raw relational static schema conversion, tables with "_od_table" are created. When using FME Workbench using the exact same settings, the "_od_table" are not created. How can I replicate the production of these tables using FME Workbench?

Hello, I am using FME(R) 2017.1.0.0. I have prepared a workflow consisting of several calculations and selecting attributes from SHP format. I want to output the results into a CSV format. More specifically, I want to transpose results into a custom format which automatically populate a spreadsheet. I am having trouble figuring out the right transformer/writers to transpose and design the spreadsheet the way I need to. I would appreciate this board's feedback.Thanks in advance.

I have asked this on GIS SE but seem to have had little interest. I imagine it would be more suitable to post here.How can i prevent sloped buildings when I extrude building footprints over sloped terrain? I am using FME to drape 2D features over terrain (SurfaceDraper), then using the Extruder transformer to create 3D buildings from OS Building Heights. Unfortunately the height value seems to apply itself to each vertex, which creates sloped building tops (roof geom is not relevant here) - example below: Is there an extrusion method that uses a single vertex, or is there another method entirely?

Text attributes can have a character encoding in FME, as we all know. The encoding that is used is shown in the Data Inspector, for instance: I would like to fetch that "iso-8895-1", "utf-8" or "windows-1252" value. My guess is that the answer is no but the question is: is it possible to extract the encoding somehow? I know that the FME Objects Python API allows me to detect if the attribute is an encoded string (FMEFeature.getAttributeType() ==> FME_ATTR_ENCODED_STRING), but it doesn't tell me what the encoding is. It seems to be stored as a (hidden) attribute property though, otherwise the Data Inspector could not show it.Depending on the answer(s) I will get here, I'm thinking of posting an idea for an EncodingExtractor transformer.

Hello... What transformers would I need to extract the Well-known text (WKT) from the following oData entry? Thanks!{ "id":"97051464","GeoInstance":{ "Geography":{ "CoordinateSystemId":4326,"WellKnownText":"POLYGON ((-111.854 54.5259, -111.738 54.0571, -111.738 54.0571, -111.086 54.219, -111.086 54.219, -111.145 54.4751, -111.145 54.4751, -111.854 54.5259))","WellKnownBinary":null } }

I have a question about integrating FME with ArcGIS Online (which I will be using to create an Open Data site). I am exploring using FME as the method for pushing data updates to our feature services. I have tested this successfully with small datasets, but ran into issues (understandably) with our large parcel dataset (~400,000 parcels). This is very slow to run with the Update Detector method as well as a Truncate and re-populate method. Has anyone ran into this issue and do you have any suggestions for how to do this with larger datasets like this? Any tips or tricks I'm missing? I am thinking that for large datasets we may have to manually publish from ArcMap or Pro (since it takes less than 5 mins), but it would be ideal for us to use an FME workspace for each dataset to keep it clean and consistend. However, if processing time is 2+ hours then that is definitely not the best solution. Here is a screenshot of my (currently running) workspace. I have limited the revised source

Hi all, I have a roads shapefile that is a polygon. When I convert it to a DWG using FME it comes in as a series of blocks. I have a few things that I need to do. Explode the blocks so that they aren’t polygons any more. I’ve tried: geometry coercer and deaggregator but neither of these explode the blocks.I need to be able to style the file as follows: BlueWeight 0.5mmA particular dash line type. I have created a polyline in a dwg with the style I want and used DWGStyler to select it but I can’t seem to get it to work, does the layer in the template and the layer that is to be written have to be the same name? Thanks

Hi !I have a set of feature, for each feature, multiple attributes (A,B,C), all having numbers. I have to extract, for each feature, the maximum value value among the attributes A,B and C.Since the StatisticCalculator limit to compute the max/min/... value of an attribute among all feature, how can archive my goal ?thanks in advance !

Hello, I have measured some points on some piles of dirt that I need to calculate the volumes of. I have got some points by the foot of the piles and some on top of them to define their geometries. Now is the question how to use this data to get the volumes? I have managed to get a TIN surface from the TIN Generator but I cannot calculate the volume unless it is a solid, right? Any ideas..?

If somebody from Safe's support could take a look at this.As mentioned in this thread the SchemaMapper is showing some odd behaviour. I'm doing a simple attribute map and specify that the old attributes should be removed. However, they remain and the new ones aren't automatically exposed.Sample template attached: