Using transformers to modify data.
Recently active
I define the parameters of the TUREF_TM36 system, which is the national coordinate system of Turkey, and create an FME file. Then I throw the file I created into the documents/coordinate file. then I define it with tools/patch via workbenc but it doesn't read my file. what do you think i should do
Hello, I'm still juggling with FME. I have this very large raster (30 Go) and I need to clip with over 2000 different shapefile extents. Right now, I have been trying to use a Feature Reader and set up a spatial filter to read only what intersects the selected shapefile. Unfortunately, the whole raster is always completely returned. I have also tried creating a parent workspace only reading the main raster and creating a child workspace that would clip the raster according to the selected shapefile. The problem is that the raster is then read EVERYTIME in the child workspace (which amounts to about 72 hrs of unnecessary processing). I have read somewhere that you can publish extent parameter and use it in a normal reader to apply a search by envelop and than clip. However, I can't seem to understand how to "call" the parameters in the reader as there are no way to input parameter (see picture below). Would anyone have a solution?
What I need to to do is to create one attribut in the table adress that says what polygon they are within. One adress can be witnin many polygons. This should lead to many duplicates but when I try to use pointonarea overlayer the point only gets the attribute from one of the polygons. I've tried to group by the polygons unique values but that did not work. I think this should be easy to solve but how to do it? To be clear the table "adress" should get one attribut that tells every polygon they are within. How to do it? Best regardsJesper
I have Table1 with the attributes "code start" and "code end".Table2 contains a code and geometry. Now I need the geometries conmbined from al codes that are between "code start" and "code end". Examples:Id 1 will get only the gemoetry of code 6371 ABid 3 will get the geometries of code 6371 AP and 6371 AR combinedId 5 will get the geometries combined of all codes between 6371 BA and 6371 BD
I have come across this issue a cuple of times and I want to understand what is happening:I use newid() to insert uniqueidentifier for all new rows. The writer set to import table definition from datasource and thus includes the local_id attribute (defualt to newid()) My features to INSERT already have a local_ids from the source that i need to remove which I do my remove the attribute all together using the featureManager transformer. Despite of this FME produce an insert query with local_id is set to <null>. Do I really need to remove my local_id in the writer for it to be left alone to let the DB produce the id?I have other columns default to timestamp (Now()) and that is triggered as expected by the DB, so I am a bit confused to why the identifyer key is treated differently.
I have a workbench that generates features with about 20 attributes. Not every run will have the same source and so not every run will fill the 20 attributes in the feature writer. I have used the NullAttributeMapper just before the FeatureWriter to map null and empty attributes to missing, but it still outputs all the <missing> attributes. I have tried both Automatic and Dynamic, but same result. What's the best way to only output the attributes that aren't all 'missing'?
I have a following problem: I want to group and build lines from points based on two different groupings. Firstly by category_id that indicates certain categories for the lines (number of categories varies from 1-7). Secondly by "line_number" that indicates consecutive measurements points (see first picture with four point lines). As a result (see second picture first line) or in another words I want lines where category change starts a new line within "line number"-group. Points have order_id so it is can build the lines in particular order. I've tried LineBuilder but can't figure out which aggregations/groupings I should do and in which order.
Hi everyone, I have a question about my thesis.I have a point layer witch including data about the traffic(speed, cars number ect..). And I have a road layer. I don’t know how to connect the the point layer to the line as the closest segment of the line get the datas from the closest pont… Thanks in advance
I have a CSV file containing the four values of a bounding box. I would like to read the file into FME and populate the four search envelope values of an SDE reader in order to clip the data to the search envelope when reading the data. How do I populate those four values from the file?Thanks,Aaron
Hi,I am trying to do transformation using Snakegrid projector to OSGB.I have appropriate Snakegrid license as per FME desktop registration key. However, looks like I am facing issue with python compatibility. I tried some workarounds as below:1. Installation of FME desktop & Snakegrid projector with the help of expertise in the team2. Installing FME desktop version (2021.2.1) with customizing python option3. Setting up python interpreter in Translation (tried using all options given in drop down), But when I try to add Snakegrid projector it used popup with python incompatibility and changed to python 2.7 Error snapshot as below:Please can anyone help me with this issue?
We are producing Cesium 3d Tiles from .dgns, our problem first was that some elements seem to have the wrong surface normals, or so we think and our fix was to use the Orientator transformer, produce a Reversed version of all elements and then Merge these elements back together so we don't have duplicates. What occured afterwards is that some elements have weird shadings that change as you orbit the element, is there any fix to this? Is this still an issue with the surface normals? Or could it be that some inner color bleeds through because of the normals 'fix' we did? Thank you in advance!
Hello, I'm trying to convert .dwg to cesium 3D tiles, but exported 3D tiles seems to have only one-side surface. Any ideas how to export 3d tiles with front and back side? I tried lots of transformers. In FME it seems to have double-sided surface. Many thanks
<ul class="textattributes"> <li><strong><span class="atr-name">code</span>:</strong> <span class="atr-value">01</span></li> <li><strong><span class="atr-name">teh_nm</span>:</strong> <span class="atr-value">Adhartal</span></li> </ul>]]></description><georss:polygon>23.263113894134655 79.9657965013572 23.263116605734016 79.96581753147373 23.263121042554495 79.96583425568379 23.26312856542468 79.96585814323883 23.26313967034197 79.96589970121278 23.26315331921497 79.96597267824511</georss:polygon></item><item>
Hello, I am trying to create a polygon from different point clouds files. After the reader I use the "NumericRasterizer" and then the "RasterExtentsCoercer" but after the rasterization I receive 1 file as an output instead of 8 that was the input. Which means that they have been merged somehow and therefore I have one polygon. How can I keep the individual files and create an outline per file?
I want to convert 3Dsolids (dwg) to a shape. But the shape is to complex I just want the boundary of the multisurface. How can convert these multisurfaces to a boundary? Thanks
Hello FME users, I am looking for a solution that is the equivalent to ArcGIS snap raster. My situation is that I have road netowrk, rivers and lakes (all in vector format) and I need to transform those into raster format. I already have a grid template (coming from a 10m resolution slope raster) and I want all my vector to raster outputs to fit with absolute precision. I have tried to use min/max coordinates but the resultat is not good enough (see images below for transformer parameters and resulting rasters.) I am sure this standard ArcGIS procedure MUST have an equivalent in FME(otherwise, PLEASE make sure to develop one!). Can anyone enlight me? Kind regards,Anne-Marie
I have an array of polygons representing a surface triangulation.Because of the source of the data, some faces are vertical which aren't supported in the TIN I'm trying to create.Any ideas on what would be the best way to overcome this? I'm sure its a common issue, be interested to see how others handle it.Maybe convert to lines, filter overlapping lines with different Z values and offset both a small amount?
I’m struggling with the TopologyBuilder transformer and, since I’m sure my use case is quite common, I hope someone might be able to help me. I want to extract the topological boundary polyline from polygons. In addition to the polyline geometry, I’d like to carry polygon attributes through to left and right-side attributes of each new polyline. For example, if my input polygons were countries of the world, I’d like my output polylines to be borders with each attributed with the country on each side. e.g. Left: France, Right: Germany. I’ve got the polylines geometry coming out of the TopologyBuilder perfectly, but not so lucky on the attributes. I get _left_face and _right_face attributes coming out, but these edge IDs don’t seem to mean anything. They don’t relate to any input attributes, nor are the polygon table row id. I’ve also tried “Generate List From Input Faces”, defined a list name, Selected Attributes, and my attribute field name. Sadly, none of these are populated on the ou
is there a way to convert mxd to cad? including all the symbology?
I have gps points that indicate the speed of a car, I want to sum them around 50 meters averages them. which transformer offers and how it would be worth usingThanks in advance
I am building a vehicle location tracking dataset where I want to keep a history of vehicle locations for future analysis. I am using the ChangeDetector to compare the values in two tables based on a field called [device]. I want to compare the [device] in table 1 with the most recent [device] in table 2 and if there has been a change, 'insert' those values from table 1 into table 2. So where [device] is in table 2 multiple times, I want to compare only the most recent record of the [device] details. When running the ChangeDetector, i have noticed that everything in the Deleted output seems to be the older duplicates. This moves me to my question. Does ChangeDetector just look for the first match for the value and move the others to the Deleted port? Does ChangeDetector use the timestamp field that I have to automatically detect the most recent? Can't seem to find any documentation on this?
Is it possible to add transparency styling to DWG output via FME? There doesn't seem to be an option in the DWG styler. If there is an appropriate field in the autocad format attributes i can overwrite this value but I can't see anything relating to transparency.
Is there a possibility to extract only the walls and the roof out of the dae-file ... I do not need steps and all the small stuff..... thx
Hello, I try to create resource inside my Ckan session with the CkanConnector and it doesn't work ><All is good with the dataset creation but when i try this for the resource creationwith url is an attribute with url like https://entrepot.metropolegrenoble.fr/opendata/200040715-MET/ESPNAT_PAT_ARBORE_TOUS/json/PATRIMOINE_ARBORE_EPSG4326.jsonand for dataset the id of the dataset i've got this :HTTP 400: "Requ\\u00eate incorrecte - Erreur JSON : Error decoding JSON data. Error: JSONDecodeError('Expecting value: line 1 column 1 (char 0)',) JSON data extracted from the request: 'url=https://entrepot.metropolegrenoble.fr/opendata/200040715-MET/ESPNAT_PAT_ARBORE_TOUS/json/PATRIMOINE_ARBORE_EPSG4326.json&package_id=3c510f3f-0da9-4ae6-9450-30803f9e6c9a&name=PATRIMOINE_ARBORE_EPSG4326.json&mimetype=application/json'" Any ideas ? Best regards
I get data via API in a JSON format. The values from "Points" need to be stored in seperate attributes. I managed to do so with JSON Fragmenter (json["points"][*]). With list indexer I can then store each index (0 & 1) to an attribute. But I can not transform then this attribute with DateTimeConverter. In the log I saw, that the list structure still exists in my dataset. I also found this information in the Feature Information (see screenshot). How can I actually transform the list into a proper attribute? JSON Structure: { ... "name" : "xy", "modified" : "2022-02-16T10:16:53.066Z", "points" : [ [ 1642633200000, 123.99 ], String replacer Output vs. Feature Information: