Transformers

I have a shape file that doesn't have the elevation coordinates. I have the extracted x and y and with those I am looking for a way to solve for z or the elevation. Can this be done in FME, and if so with what transformer?

Dear FME-Community, I have a question concerning FME. I would like to convert a huge CityGML file into small tiles of e. g. obj-Files. I have seen that cesium is able to produce 3D tiles. Is this also somehow possible with FME? The end product should be 3D meshes for CAD software/ or something like obj-files. Maybe there is a direct way working with FME or maybe there is a work-around with cesium and FME... Thank you so much for your help in advance! with kind regards, Christian Lendl

I have several main polygons and sub polygons in it, but sometime sub polygons have same name as mentioned in attached snap, attached is the only example, I have lot of data, how can I find duplicate polygons within main polygons? In blue color, name is for main polygon and in black color, name is for sub polygons. If anyone can help with workbench then it will be really helpful. Thanks in advance.

Hello everybody, My project need to convert amount dgn files (more than 2000 files) to shapefile and I want the output also are multiple shapefile which equal dgn files. I'm a newbie in FME, so who know the exactly way to convert multiple dgn files let's support me. Thanks for everyone!

I have an FME-workbench which manipulates data originating from either Excel or Access. Since I want to use the same workbench for dozens of different Excel and/or Access-files and every file has multiple Features, I don't want to create a new Reader every time, but just indicate the path to the corresponding file. The data structure is given and supposed to be the same for every input file. However, sometimes that is not the case, i.e. some additional columns are added in one of the Excel Sheets . Now, I am interested in finding additional/missing columns, but that's where I start getting lost... I tried to compare the attributes of my desired Input file and the Example file (with the correct data structure) via Attribute Transposer and ChangeDetector, but it did not work dynamically as the Reader seems to remember and thus keep all the Attributes it has ever seen so far - and not only the attributes actually present in the desired input file. Please let me know if I should give more

Hello! I'm having a near meltdown trying to figure out how to rework a process that I have and hope the community can help a bit. I'm working on a project that is determined a suitability analysis on which curbs are best suited for EV installation charging. By using the SpatialRelator, I am currently processing millions of feature lines (the curbs) and comparing each line to 20-30 different datasets (polygon areas that have been prepped with preconfigured parameters) to see which of them overlap. I then use a ListExploder to explore those relationships, and then a FeatureMerger that merges the different individual "scores" for each of those 20-30 datasets. Then I run it through an Aggregator to basically generate a total "score" from each of the datasets that intersects with a particular line feature, grouped by the line feature. For a smaller dataset, it works fine! However, trying to run 500,000 features using a WHERE clause lasted over (last I checked) 18+ hours, and then I think my

Since FME 2021.1 I get many python errors around None values: Python Exception <TypeError>: Attribute value cannot be None. Use setAttributeNullWithType() to set a null attribute value. Is anyone else having the same issues? It occurs with FME Desktop as well as FME Server

HI there, I have access to an API that returns flow data. The data is structured with a serial id (unique to each logger), ID (sequential, but only to each logger) and the data value (float). The API would run every 12 hours and just would return the last 12 hours of data with overlaps. The API creators have suggested that by fetching the max ID for each serial number in the existing data I should be able to return the data from the api that doesn't already exist. There is no provision in the API to pass these values as a parameter so will be using FME to achieve this. I could output the data from the api into a holding table and use a FeatureJoiner to the existing data so insert the new rows, but the static table will grow exponentially and I can see this becoming a huge problem in time. Is there a way to grab the max ID for each serial number from the static table, fire this against the holding table and grab only the new values which are greater than the max(ID) for each serial no?

i have a road network of 4 areas and it is categorized as external and internal road, The features has an attribute as number of lanes so i want a HTML or Excel file based on the total sum of lengths each lane has. Thanks in Advance

I have a py script. It takes in 3 parameter, Input file gdb FeatureClass name Output file gdb What it does, is to copy the contends of the featureclass to the outputfile gdb and I would like to convert it to FME Can some help me with this conversion? Please remember it may be configured for any filegdb and any featureclass name so a static linking won't work. My initial findings is the use of "Generic" option of FeatureReader

Each .DWG file has to haev the same file name as the source .LAS that it is converted from. what is the best way to set this up so it converts all of them one at a time without too much user input?

Despite the fact that the nad83 and wgs84 datums are supposedly identical, there are several ways to get from one to the other and they result in different placement. ESRI recommends this transformation: WGS_1984_(ITRF00)_To_NAD_1983 FME appears to use this one: nad_1983_to_wgs_1984_1 I am using AttributeReprojector on a dataset with several coordinate systems. Is it possible to indicate a specific geographic transformation for nad83 to wgs84 when using this? Thank you, Randy McGregor

Hello everyone I got a little lost in this problem, I have three columns segment, direction. I would like to obtain another order column which will be incremented in the event that we have a change either on the segments or on the direction, I tried to give you an example which explains the situation, thank you in advance

Folks, we are trying to call an Oracle Stored Procedure using SQLExecutor that send the student information and it return student_id back to FmE to be used in subsequenct translations. any idea how to do it in FME. store procedure name intsertStudent(name,address,class) return student_id. Apprciate your help!

Hello. I would like to know How can I use FME to transform KML to CAD with 3D shape. The first image below is my KML file in Google Earth which I use 3DForcer to generate the height of buildings. I also want to see them in AutoCAD, so I transform this KML file to DWG without any transformers.Only the reader and the writer.I refered this question:https://community.safe.com/s/question/0D54Q000080hgkVSAQ/converting-kml-to-dwg-stretches-the-original-shape But the result seems that there's no height line in CAD I want CAD shows just what I saw in the Google Earth, How can I do that ?

I am reading an Oracle spatial table and writing the content to an ArcGIS Online feature layer (hosted). There are no transformers in between. The shape_area in the ArcGIS Online feature layer is larger than the actual area the object has in Oracle. there is a factor of 2.61 between them. There seems to be a new area calculation taking place in the writer writing to the ArcGIS Online feature layer that does not seem to be right. How can I prevent that? Greetings, Hans

I've got two data sets with some commonality in length data, one coming from KMZ (S1) and one a csv with no spatial data (S2). I would like to merge the datasets. S1 stores lengths as stationing with start and stop (St. 0, End 100) S2 stores lengths as stationing but more granular (St 0, End 25 etc) My first thought is to try and split stationing from S1 to match S2 then merge the geometry to S2 since that has the data I want to keep but I'm wondering if there is a way to do this I haven't come across yet. Any Ideas?

I want to find the biggest possible box inside an area, like the opposite of a bounding box. It should also be oriented.

I am looking for a sumproduct like function in excel that i can use on data i have in FME. What i am really after is a weighted average of certain groups of data. I have the products solved for in separate fields but i can't sum within their groups.

i would like to use OSM Openstreemap , i have downloaded BPF for a city from Geofabrik Download server ,is that the correct extension or which extension should i download ? could someone provide me with an example for OSM Workspace ?and what shoud i do ? i would like to show output geographical map for polygon as Google maps . FME 2018 Thanks in advance

I am trying to split an attribute using a regular expression as there may be differences within the attribute. For Example the attribute may be as AA9A or B7B However some of the attributes are formatted as CC7 or DD6 I therefore do not want to remove the last character from these, all I need to extract is AA9 or B7. Is there a way with a regular expression to search for a character, potential character and then a digit? Or is there a better way to achieve what i am trying to do?? Thanks in advance Andy

The aim is to use the current transformers that FME has to offer. Any help with this is much appreciated. Thanks, Sam

Hi All, I created a SchemaMapper lookup table in PostgreSQL and used it to map schemas in two scenarios. When I used ESRI SDE feature class as a reader and PostgreSQL as a writer the SchemaMapper mapped all and no problem When I used SQLExecutor reading from Microsoft SQL Server database that creates a query from four tables and writing to a Single PostgreSQL table, the SchemaMapper outputs the results as unmapped. I have used AttributeExposer transformer and it still didn't change. please see the screen shot below: Can anyone please help me fix the issue or let me know if I'm missing anything? Thank you in advance

Hello to the community! I'm new to the FME and I'm quite impressed with what it can do and also with the very helpful tips and solutions which I read in this forum! As a newbee, I'm struggling to get the result which I want, but for most of the experts here, it's probably quite simple: I'm working with polygons which represent the chart coverages of Electrionic Navigational Charts. They are categorized into "usages" with usage 6 having the largest scale (inside harbours) and usage 1 having the smallest scale (covering entire oceans). The set of polygons is currently overlapping each other and my goal is to have a non-overlapping set of polygons - perfectly touching each other's boundaries - which give me the best chart usage at any given point. I have already created a workflow where I dissolved usages 2 to 6 and then used the Clipper to clip usage 1 with this. Similarly, I dissolved usage 3 to 6 and clipped usage 2 with it - and so forth. Doing it this way seems to get me there but my

I used the Directory and File Pathnames reader to go through folders and select all shapefiles. Then trying to use GeometryExtractor and GeometryFilter to filter line shapefiles but GeometryExtractor output has no geometry. Then I'm using the GeometryReplacer to replace the geometry but again the output has no geometry and the GeometryFilter cannot filter lines. I'm very new to FME so please go easy! Thanks in advance.