Creating and organizing workspaces. How to use Workbench.
Recently active
Hello!I am new to using FME and I am working on converting an FBX file storing a 3D terrain model into a CityGML format. I have come across with two questions. How to generate a TINrelief from an FBX file in FME? Does a TINrelief have/need a GML/JSON encoding in CityGML/CityJSON for conducting further geospatial analysis? Can it be a TIN file or a Geotiff file?Thanks!
Hi!I have a list, containing between 5 and 50 values (varying). How can I append a value to this list? I can only assume there has to be a non-pythonic way, but I struggle to find one. My approach was to use AttributeCreator, but I can't dynamically specify the position in the list. Had the list size been fixed, then that's a solution - but not in this case.Any ideas?
Hello Forum, I have two polygon datasets, each with just one object in it. The edges of the two polygons abut in places. I’ve created a workspace where I‘m reading in the ‘Above’ polygon dataset and the ‘Below’ polygon dataset. I want to create a line feature of where they share a border. To do this I’ve used an Intersector which gives me a new _overlaps attribute… The exact line I require is where _overlaps = 2… So, I added a TestFilter to filter out where _overlaps = 2… But when I wrote that to a new feature no geometry was created. So, I added a LineBuilder, hoping that that would force the line to be drawn. But the resulting FeatureWriter is still not creating a line dataset - it creates a dataset, but with no geometry. Any ideas? Thanks,Stuart
Hello Forum, Is it possible to artificially create a polygon based on the lower edge of an existing polygon? Imagine I have an existing polygon, I’d then want to create a new polygon that snaps to the lower edge of the existing polygon. The depth of that polygon doesn’t matter, for example it could just be roughly 50 metres away from the shared boundary. What really matters is that is snaps to the lower edge of the existing polygon. An alternative approach could be that the artificially created polygon is a doughnut polygon which wraps around the existing polygon to say, a depth of 50 metres. I could then split it manually where required… I hope this makes sense. Any ideas? Thanks,Stuart
Hello everyone, I have some published user parameters, and the choices will be retrieved from the database. Is there any way to have the user parameters to be updated automatically once the workspace opened? Thank you everyone.
hi !FME name machine parameter does it exist? I see the name of my computer at the beginning of the log but I don’t find where is this parameter.Thanks !
Hi, I have a time format like below (hh:mm:ss) and I want to round seconds as below. What is the best option to achieve this? 00:00:22.464 > 00:00:2200:01:22.825 > 00:01:23Thanks in advance for your feedback.
Hi folks!I am torn as to what workflow to use between FME and python. I am more comfortable with FME so hopefully FME would be the winner here.The workflow I am trying to achieve for the business user is to have a GIS editable feature layer containing field summaries translate into a docx with a table template (ideally with the same attributes as the GIS feature layer).A sample of the table template in the docx is below:Any time a new field summary project gets entered into the GIS editable feature layer, ideally, a net new Word document with a separate table with populated values from the GIS editable feature layer will populate in the corresponding values in the table within the docx. Any updates that are made to existing field work project records within the GIS editable feature layer would have the updated records/values also translate into the associated Word Document with table template values as well.So in the above, the values from the project name, date, crew, permits, divisio
Can you convert a Polygon M shapefile to a Polygon shapefile?
Before I updated to Form 2024.1.2.0, when I added a writer it would automatically name the Feature/Table and assign the geometry type. Also, if there were multiple readers in the workspace the add writer function would prompt to select individual or all feature/table names associated with the readers. Now the writers have to be individually added, named, and assigned a geometry type. This can be very tedious and time prohibitive in many cases (which goes against all things FME). Is there a default setting that I’m missing?
Hi, I am retrieving data through an API using an HTTP caller. The data consists of points and lines. My plan is to pull this data, perform some attribute mapping, and then POST it to a website. However, I'm having trouble extracting geometry after flattening the JSON data. I used a Geometry Replacer, but it fails every time I run it. The error message says:INVALID_PARAMETER_GEOMETRY_SOURCEI would appreciate any assistance with this!
Hi,I have a file of points which correspond to buildings. Each point or building has a number of apartments (total 9000). from this layer, I would like to create zones for every 500 apartments, without intersection. I tried the neighbor finder with sorter assending on the distance then range mapper attributes but the result is not good because I should not have any intersection between the polygons. Help please :) Thanks a lot
Hello Folks,I am working on a use case where I need to retrieve data for retail shops closest to my current location or a given set of geographic coordinates.I am attempting to implement this using an FME Form; however, I am encountering difficulties in obtaining the current location dynamically.If anyone has experience or insights on how to effectively retrieve the current geographic location within FME or through any integrated approach, I would greatly appreciate your guidance. Thank you in advance!
Hello,I am experiencing some odd behaviour with the FeatureReader when trying to read in a schema from a Feature Class in a FGDB. I am using the “path_windows” attribute that contains the location of the gdb. When run like this, I often get a rejected message (see Caption 2). When I add in the hard coded full path into the Dataset field of the FeatureReader, the data gets read correctly. What is strange is that this has been working fine in the previous weeks when I had developed it. It only appears to be an issue since today. It also seems to read successfully when I run the workbench with caching to the Aggregator before the Feature Reader, then running again from the aggregator (no settings have been changed). I have tried using the path_unix field instead, but get the same error. I have also tried other datasets, but get the same issue.Has anyone experienced similar behaviour when using the FeatureReader with a GDB?… and any ideas to help with the stability of the run? The workbenc
Hi everyone,I’m encountering an issue with the migration of Smallworld collection records to MSSQL using FME. I perform a differential migration of Smallworld records daily, and I need a way to identify and log any failed records during this process.In a previous migration project, I handled this situation using a post-validation Magik script, which compared the migrated objects in the external database. This database had a version control mechanism managed by an additional date column, making it easy to track if records were inserted, updated, or deleted.However, in the current case, there is no such versioning column in the MSSQL database, making it challenging to track failed records.I’ve decided to log the failed records directly in FME. After exploring various resources, most suggestions point to using the Logger transformer, custom transformers, or Python scripts to read the FME log file for errors. While these methods help identify general errors, they don’t provide details abou
I have 501 polygons of various shapes and sizes. I want to split it up in clusters of roughly 20 polygons each. But I wan the clusters to be located together. I have tried the spatialsorter, which gives good results. But not quite what I’m looking for. Is this possible? Any help would be greatly appreciated. ThanksB
Morning,I have access to the bucket and can read files. However, when I attempt to download a file I receive the following error:My admin insists I have the correct credentials, and I can download this file using WinSCP. Are there are settings I might be missing on the connector?
Hi all, i've got a strage error. I have about 30 ArcGIS Online readers that i want to read, update and write back to ArcGIS Online. Now, the update part with the Changedetector workes fine. (Dont look at the mess ;). The problem:When i run the workspace, it gets all the 41K features that are in there. The other ones are skipped because it is not found. This works as it should work. After that it tries to search in groups accessible to the user, and then it says "error running translation”. Does anyone know how to fix this? I have attached the log file and the workspace. Thanks in advance!
Hi, I’m trying to calculate the volume of various areas of beach using point cloud data. I want to calculate it above a horizontal plane at a level input as a user parameter and I have individually references mif/mid polygons demarking the areas.I have been using the method at the below link as a starting point, but the problem is the beach is sloping, not flat, meaning using the z.median value gives an incorrect result.https://support.safe.com/hc/en-us/articles/25407483031053-Volume-Measurements-with-the-VolumeCalculatorAny suggestions for a solution would be gratefully recieved!
Hello Forum, I have a polygon dataset of railway land, but it contain holes where items such as buildings, tracks and signal boxes would be. I need to fill in these holes to form a continuous polygon. The image below shows a sample of the data. I’d want to fill in holes like those marked in red. But I do not need to close spaces such as those marked in gold. I’ve seen…. … but I don’t think that’s suitable for the task. I’ve also looked at Dissolver, but I’m not sure if that's the right way to go. Any ideas, please. Thanks,Stuart
Hi, I need to find into a network of GPS lines the location where 2 line overlaps or where a single line overlapThe problem is that of course the lines aren’t exact the same (the lines derived form GPS points so I don’t have a duplicate geometry) and only a portion of this lines overlapssee picture attacherd If you need the sample of shape dataset let me know thx Francesco
Hello Everyone, I have two datasets, which I essentially want to stack on one another. One datasets has data on rivers, streams, and brooks, while the other has information on ponds, lakes, and reservoirs. They all have the same attributes, so I just want to add the pond, lakes, and reservoir data as new rows in the river, streams, and brooks dataset. Can someone please help me figure this out?
I'm trying to use the WHERE Clause in a FeatureReader. I'm reading in an Oracle SDE featureclass and want to only select those records that match an attribute in a csv file I've loaded. I'm assuming that I have everything setup correctly where the attributes from the csv file are FME Feature Attributes. It seems when I add the @Value(col0) to my WHERE Clause, it breaks. How can I check to make sure it is setup correctly?
I tried generating measures on street segments but the measuregenerator is not calculating it right. It starts every segment from 0 instead of calculating from the end log. Any ideas how to resolve or calculate measures on segments with no measures? Thanks in advance!
Hi,I need to use Upsert to either Update or Insert features into an Oracle database.If I use Insert to add values it works a treat, so the connection to the Oracle tables is good.As the Oracle tables are large, when adding the writer I use Import from Dataset… This picks up the format of the date fields and all sorts. It works well for initially inserting the data.However, when dealing with deltas, which might be Inserts or Updates I want to use Upsert. I can test it on a filegeodatabase and it works perfectly. Taking that knowledge into the Oracle process like this: I use the NODE_ID as this is the unique identifier.However, this fails.So I have followed the guidance to implement fme_db_operation, I have created a new attribute field of that name, and used a FeatureReader, FeatureMerger, and then AttributeCreator to define whether the feature is classed as INSERT or UPDATE. All works well in the workspace, and a manual / visual comparison between Workbench and the Oracle table conclud