Using transformers to modify data.
Recently active
I'm trying to build an archive off a feature service hosted in ArcGIS Online by getting the changes and writing them to a second hosted feature service. I can get the changes in JSON, but I'm struggling to turn them back into usable features. The format looks like this: "edits" : [ { "id" : 0, "features" : { "adds" : [ { "geometry" : { "x" : -119.58448584499996, "y" : 32.10688862600006 }, "attributes" : { "OBJECTID" : 93, "GlobalID" : "1DF7CAF6-D3CC-4E8D-8FB3-C6714C06890A", "IncidentName" : "Testing", "Label" : "DIV X", "Label2" : null, "LabelType" : "Division", "Other" : null, "CreateName" : "test_nifc", "CreateDate" : 1621322205148, "EditName" : "test_n
I have this Oracle database that has a trigger that automatically creates a bounding box around any feature, in this case they are parking lots. The index database stores the northernmost and southernmost latitude as well as the corresponding eastern and wester most longitude of the minimum bounding rectangle. I'm trying to crate this bounding box using FME and I'm not seeing the best way to accomplish this. My thought process:Create 4 points for the four corners of each box and then create the areas for them.Create the top left and bottom right corners of each box and then have FME figure out the polygonFind a transformer that just knows what to do with these 4 fields and then get a cup of coffeeOf course the 3rd one is what I'd love to see but I'm not sure that exists. I'd rather not create a ton of points just to create a polygon but I might need to do this. Any thoughts?
When using HTTPCALLER I cannot figure out how to use the Query String Parameters. The URL ends with /1729/1774.mvt these two number are in two columns in a CSV file (attached). The whole URL is the one below and if I use that as a Request URL it works (its password protected).https://maps-ver.lantmateriet.se/vt/fastighetsindelning/v1/wmts/1.0.0/fastighetsindelning/default/3006/10/1729/1774.mvt
please guide to convert the xml file to excel to get all the fields information
Hi, I know the ExcelStyler is in beta but here goes the question anyway. Is it possible to style individual cells based on the attribute value? I have tried different approaches that all color the entire row or entire colum as you see below. Result if I filter through a tester and chose to style attribute "c". Result if any of the attributes fail the tester, the entire row is colored. This is what I need, to style individual cells based on their value Thanks! /Jacob
Your input would be much appreciated. I don't know how to proceed and would like to avoid manipulating the source data manually to get it to do what I want. I've received data which is formatted in the following manner. I'm posting the first item and closing it off just as it ends in the file with </markers>:<markers> <marker name="Tilburg" straat="Vloeiveldweg 6a" postcode="5048 TD" plaats="Tilburg" site="" lat="51.600739" lng="5.064299" linkurl="tilburg" status="0" dot="red.png" ></markers> I used an XMLFragmenter and it's configured as:Elements to Match: markers/markerFlatten Options: EnabledFeature Information shows:How do I go about extracting marker.name etc. into their own attributes with values? I've tried various combinations in Elements as XML Fragments but no dice.
Listing the available layers works with the authentication and using a HTTP caller to the getcapabilites with the authentication works. It's just when the reader is running.It would be great if there was a way to capture the HTTP(S) request and responses.
Hi.I've now run into this issue several times now.If I create a custom transformer in my workspace, and create some parameters in it to be given values in the main part, some of those parameters doesn't accept variables, only text editor and workspace parameters.What is triggering this odd behaviour ?Attaching a screen dump from 2021.0
I have a road network represented by a centerline (brown) and 2 edges (pink). I am looking to create an area from it.The network is rather complicated so linecloser->areauilder doesn't work. I then tried buffering the centerline, polygoncutter and spatialFilter, which doesn't really work for round-about and junctions. At the moment I am trying to create cross-sections (blue) at a given sample dsitance, using neighbourfinder, which seems to work very well. However, I can't figure out a way to create a hull-like area from the cross-sections. I am considering trying to write the vertices into a list and then to a polygon, but it feels overly complicated.Does anybody have any leads. I can provide sample data tomorrow.
Hello everyone, I'm currently trying to make a path from a GEOJSON "link" which was return from a HTTPCaller. Is there any way to transform the link below into a line feature? Thank you in advance. {"code":"Ok","waypoints":[{"hint":"xPMEgEswB4AKAAAAAAAAAFcAAAAAAAAAJ0k3QQAAAADB2cBCAAAAAAoAAAAAAAAAVwAAAAAAAADaAAAAC07F-1foygJzT8X7X-bKAggAnw0GXKGa","location":[-70.955509,46.852183],"name":"Rue du Moulin"},{"hint":"4nEJgIjqCYAMAAAABQAAAH0AAAAaAAAAUXXHQaFyEkF2A31DScJOQgwAAAAFAAAAfQAAABoAAADaAAAAAVjF-47pygK1V8X7u-nKAgUA3w0GXKGa","location":[-70.952959,46.852494],"name":"Route du Fleuve"}],"routes":[{"legs":[{"steps":[{"intersections":[{"out":0,"entry":[true],"location":[-70.955509,46.852183],"bearings":[37]}],"driving_side":"right","geometry":
my example i have folder that contains lots of files that contain tiff extension and tfw extension .i would like to import all images to fme workbench and build one image with the correct cordinates then i could merge with polygon border coordinates ,to check which image suitable to which polygon bordereach image has different min and max extents as pic down,i would like to rearrange them together .How could i achieve it ?Thanks in advance
In the first step Im doing a PointOnAreaOverlay which connects the features with a point inside the features. The next step I want to replace the z-value of the feature with the z-value of the point. I have tried with both CoordinateReplacer and GeometryReplacer. So how to replace z-value of the feature with the z-value of the point?
I have hundreds of image files that require renaming. I have an Excel sheet with the oringinal file names in one column and in another colomn the prefered file name. I would like to replace the image file (.jpg) name with the new name the column in the spreadsheet. I found an article on how to do this, but I can't seem to get the script to work. I am new to FME. I have provided the workbench file and the spread sheet and a image file.Can some one please help guide me with where I am going wrong?
Hi all. I'm struggling to get the LineOnLineOverlayer transformer to work. I'm working with MI tab files. I want to create a node at the crossing locations of an linear infrastructure data set 'A' with three other liner datasets 'B', 'C' and 'D'. The results I'm looking for is nodes at the crossing of A and B, A and C, A and D. The problem I have is not all intersections are being generated. The attached image shows an example of this. On the eastern side the blue dot represents an intersection between A and B. However, further to the west I would expect to see another two intersections but nothing has been generated. The green polygon is one of may regions that is used to clip the poly line datasets to a manageable size before processing. The parent datasets are nationwide in geographic extent. What have I missed? Do I need to deaggregate lines somewhere? (I've tried a few locations) Thanks,Michael
I have got a LandXML schema and I am wondering how can I export a LandXML file based on that from a DWG/DXF reader.Can you please give me some samples/tutorial or guide me how can I map the DXF data to LandXML file? Thank you & Regards,FB
HiHopping this is the correct forumI'm trying to work out how to extract place names from OpenStreetMap(.osm) files from geofabrik.deFor testing I picked WalesUltimately I will push into PostgreSQL / PostGIS database hopefullywithout corrupting non English names In the attached Workbench I used AttributeExposer to show everything thiswas done using the cache My first question how do I make that dynamic?There will be some distinct attributes like name, osm_id, is_in, wikidata etc and some dynamic ones especially non English names My Second question is how do I group similar attributes together and merge into a JSON stringfor instance alt_name:en, alt_name:fr, alt_name:* grouped into alt_namejson this with then be held as a jsonb database type Similarly name: en, name:fr, name:* grouped into official_names json I couldn't see how to do this using AttributeFilter or Tester All other attributes not yet accounted for grouped into all_tags json string I've done something simila
how to avoid black fill color in dgn file output , i would like to change the background of map to yellow instead of black by default in dgn file .what should i do in fme workbench to modify the background .i have used dgnstyler but it is useless in output ,i see only the changes in inspector in fme but no effects at output dgn filei am using dgn writer at the end of FME workbench FME 2018 Thanks in advance
Hi all,I have a workspace, where I am detecting the hange between my original data in an SDE and revised data coming from a public source. I'm using the fme_db_operation to push Inserts, Updates and Deletes to my SDE. However it apparantly just keeps adding the data as duplicates. I have 6 exactly same polygons for each feature, with the only difference being a Version ID... Any thoughts?
Hi,I would like to modify a comment section in my table. The comment section is intended when there's a change between two roads. For example, when Road 6 is changing for Road 6-A, the comment section writes : Road 6 is becoming Road 6-A. Now, I got a lot of these examples but the comment section is almost blank (with some examples as above). I want to describe those Roads change when the comment section is blank. I got 4 000+ roads changes, so a formula would be appreciated. Thanks.
Hello everyone, I'm currently trying to make a path from a GEOJSON "link" which was return from a HTTPCaller. Is there any way to transform the link below into a line feature? Thank you in advance. This, below, is the GeoJSON file in question.https://docs.google.com/document/d/1-H6F53Z3Mpu9qmOLQwvifWVPuG7xgjtk4aekHyG1nUU/edit?usp=sharing
Hello, I'm working with Ordnance Survey data, in particular their OS MasterMap Highways Network RoadLink and RoadNode datasets. This is a topologically correct link and node dataset. I'm looking for a way to segment the RoadLink polyline dataset at 25m intervals up to 100m starting from RoadNode points marked as roundabouts, as shown in the example image below.My intention is to merge all lines with the same road name and road number using the LineCombiner transformer and then use the Chopper transformer to segment the lines at the required intervals. However for this to work, I need to be able to orientate the direction of digitisation of the lines away from the roundabouts nodes, as the chopper will do it's chopping in the same direction as digitisation. I can then chop them starting from the roundabout point and up the line away from this point. My main question is, is there a way to use a point that lies on the end of a line and identify if the line is digitised toward
how to change coordinate min extent and max extent to new coordinates ?i would like to move polygon from his coordinate to new coordinates .i have used attribute creator to change x min and x max and y min and y max ,but i found it changes the coordinate as attribute but i want to move the polygon from his main coordinate to new coordinates.could someone help me ,how i do that ? FME 2018
Hi FME,I am working on a Microstation V8 DGN file with DGNV8 reader. Some of the polygons are recognized differently in Workbench and Data Inspector as attached in the images. Is this a known issue? For example, the green polygon in the Workbench (see the attached image) is losing some of the boundary edges when compared to the same polygon drawn in the Data Inspector that is showing the correct shape. I changed Workspace Parameters > Advanced > Preserve curves "Yes -> No" and then "No -> Yes". But neither was successful. Since the feature shape is wrong at the reader level, adding transformers after the reader won't fix the issue. Do you have any ideas on this? My FME Desktop Version is FME(R) 2020.2.3.0 (20210129 - Build 20820 - linux-x64) and running on Ubuntu 20.04 LTS.
I am hoping someone may have suggestion as to why a FeatureJoiner fails to join on 1 attribute only.Left input: table of records, including CouncilRegion attributeRight input: polygon feature class with Region's NameThe transformer successfully joins all records from the left input table, to the feature class..., apart from the table records in "Hawke's Bay"The join is successful for all other records. I have trimmed any potential white space at the end of the attributes.Anyone can think of where the problem may lie, what test I could do to ensure Hawke's Bay records do join?Many thanks