Using transformers to modify data.
Recently active
I have a polygon layer that has various geometry issues, mostly self-intersections. I have used the GeometryValidator to clean these up, but it has had the unfortunate consequence of filling in the holes. This is because they are not proper holes, but "fake" ones created by digitising a zero width corridor. So the hole boundary is actually part of the exterior boundary (highlighted in example below). The corridors are detected as self-intersections. Is there anything I can do to output the polygons with proper holes, or at least detect the polygons with fake holes so they can be edited manually? There are too many self-intersections reported by GeometryValidator to use for manually repairing the holes.I've found this similar topic but I'm not quite sure if @offermann82 is looking for the same solution...https://knowledge.safe.com/questions/59610/how-to-split-polygons-with-holes-that-touch-the-bo.htmlI think I want the opposite of what DonutBridgeBuilder does...ht
I have two versions of GeoJSON data for the same floor where I need to identify changes for both geometries and attributes (example original data has 73 rooms and later modified like two rooms merged into single,two more rooms created by partitioning of one room and revised data makes it to 72 rooms). Now I have tried to check these changes using Change detector tool the output result differs for attributes and geometries.I have used latest beta 2019 desktop as the enhanced version of Change detector available.Please suggest me I have attached the workbench snapshots with results.Where for only attributes I get fairly good result for deleted,added areas but not for the updated areas. Where for only geometries I get everything to be updated .Please note the work-space reads original data queried from SQL database and the revised data from GeoJSON reader but both data has been extracted as GeoJSON with parameter precision 7 in the workspace.Please suggest how to get the proper result.
For example if one: I want to merge a feature with an attributevalue that is called "East Dartmoor" to a feature with an AttibuteValue called "East Dart". Would it be possible to add a wildcard to the feature merger?
I have a table A like:123 and a table B like: 111222333 I would like to run a process on each row at a time in table A e.g. join to another table B that matches then run a process on the match, write some features, then proceed to the next record in table A i.e.2 and run the same processes on matches in table B i.e. 2 and so on..I don't know how to do this in FME without writing a cursor or loop in a script. Hope it makes sense.
I work with geometries (routes) whose vertices have 4 dimensions: XYZ and M (measures). How can I round M coordinate values stored in the data to a specified number of decimal places? The coordinate rounder only covers XYZ dimensions.
I have a pressing deadline but I have no PERL skill and need this attribute trimmed - Lot/Plan(separators).an example of an attribute:1/AB842550I am duplicating the column Lot/Plan(separators) into two columns - Lot and PlanAll characters to the left of this symbol "/" are the Lot numbers required in the Lot columnandAll the characters to the right of this symbol "/" are the Plan numbers required in the Plan column. Any and all help would be greatly appreciated.Thanks peter
Has anyone gotten FME Server to work with the Atos DirX Directory 8.4 server using LDAP v3? The LDAP server is on-site (not cloud).We are able to set up a successful connection but as soon as we try to import users and groups into FME Server 2018.1 it crashes with an unhandled exception in the logs:(Active Directory) Searching using filter "gdiReader"...Thread stack trace:getStackTrace(Thread.java:1559) / ensureNotNull(Validator.java:60) /createSubstringFilter(Filter.java:633) /searchUsers(FMEUidActiveDirectoryConnection.java:942) /searchForUsers(LdapSearchServer.java:411) /executeRequest(SecurityRequestsDispatcher.java:928) /handleRequestSecurity(FMEServer.java:384) /handleFMEServerClientRequest(FMEServer.java:285) /handleFMEServerClientRequest(RequestHandler.java:98) /processClientRequest(RequestHandlerBase.java:856) /readClientRequest(RequestHandlerBase.java:589) /handleClientRequest(RequestHandlerBase.java:772) /run(RequestHandlerBase.java:946) / run(Thread.java:748)LDAPSDKUsageExc
Hi!I have a question about how to convert a PNG palette to RGBA.My input features is in palette format (int8) storing all the RGBA values in one band.Now I would like to export it in PNG-format with the RGBA-values stored in four different bands instead. Does anyone know how to do it?
I have a feature class. There is a ID field in this feature class, like below: 101L1101L2101L3101L4101L5101L6101L7101L8101L9101L10...102L57102L58102L59102L60102L61102L62102L63... I plan to add a new field called AZIMUTH. I need to use ID field above to find the "next" feature, for example, if current feature ID is 101L4, I will try use 101L5, and use this "next" feature and current feature to calculate AZIMUTH. Can you tell me how to find 101L5 in this case? Better use transformers. If not possible use python is also OK.
I have a CSV file with Lat/Long for a point features and String for radius of exposure, I wish to create buffer for each well since their radiuses are different, I followed a tutorial but all the buffer went to one single point. Each point has 3 different radius, so I need to do this 3 times. In the attached tool I only used one radius at a time, this is for sensitive radius. The lat log is originally stored in NAD27 DD.
Hello people,I am new to GIS and FME. For my study we are using ArcMap. Ik have an shapefile and now I need to create a 5000 meter buffer around the shapefile. Therefore I must use the Bufferertool from FME. The result wil be written to a file geodatabase. Anytime I run the spatial ETL tool from FME I get an error and see no buffer of 5000m around the points of the shapefile.I have ad some screenshot. Does anybody know what I am doing wrong in my setup?Thanks in advance.Tijs
Hello everyone,I am relatively new to FME and have put together a conversion of 4 tables from a sql server database into a couple of embedded collections with a $lookup link in MongoDB. I've had a couple of issues getting the data directly into Mongo, but with a subset I have tested transforming it into a JSON and then loading the JSON into Mongo and that works fine. My issue is seems to be with memory when i try to run the full dataset through. I have been stripping the translation back into smaller chunks so that my machine isn't trying to run the full process at ones, but now I'm at the stage where I cannot strip anything away. The first bit of translation I am trying to do is taking the 6.7M row table and creating unique MongoID's for each row and then saving it as a JSON, which is pretty straight forward. However, each time I have tried to run this with the full dataset I get to approximately 3.5M rows loaded and then the JSON writer closes due to memory issues. Be
I need to create a point/line geometry out of the following input data:a) route: line geometry stored with measure values, including a route id fieldb) point/line event table without geometry, including a reference on the route id field, a measure value field (point event) / a start and an end measure value field (line event)Is there an existing transformer or a common known routine in FME to solve this problem?
Hello,I have a dng file that In print, the text information (i.e. codes) is in rectangular boxes linked (only visually I think) with arrows that point the corresponding geometry. However, When I imported the dng in FME, the geometry remains at the proper spatial place, but all text is moved to (0,0) therefore even the visual connection is lost.What I am trying to do, is to relate the text as an attribute in the geometry. However, it does not look like there is any sort of linking that could help me do this.I would appreciate any sort of ideas on how to process this, my question is too vague so I do not expect a specific methodology set. How could we relate text information from dng with its corresponding geometry?Thank you for your time.
the xml fragmenter refuses to recognize the xml in this doc (see attached). What am I missing?
I have a scenario where I need to convert the bit depth of a raster from 16 bit to 8 bit, or vice versa, but the type should remain the same. ie Gray16->Gray8, Int16 -> Int8, Red8 -> Red16, etc.Given that the RasterBandInterpretationCoercer does not accept attribute values for the Destination Interpretation Type parameter, is there an alternate method to testFilter for all allowed types, and 14 hardcoded RasterBandInterpretationCoercers?
I have an XML extract using a Soap interface that has a section with lists of user defined attributes. I have a schema for these but I am having trouble extracting the contents. I expect to be able to rename the fields based on the order after extraction. For example in the IDENTIFICATION path there are UserFields{1} to {5} that I want to extract and label like this 1 Manufacturer No Alphanumeric 40 2 Manufacture_Date No Date 11 3 Model_Number No Alphanumeric 40 4 Make No Alphanumeric 40 5 Serial_Number No Alphanumeric 40
Hi,I'm trying to download table data from Statistics Finland PX-Web API (documentation here http://pxnet2.stat.fi/api1.html). URL for example for the cube and the table containing population demographic data is: http://pxnet2.stat.fi/PXWeb/api/v1/fi/StatFin/vrm/vaerak/statfin_vaerak_pxt_001.px . Px-Web API can return table data in various formats, including csv and excel.Using HTTPCaller and GET or/and JSON-reader I've been able to receive nested JSON containing list of all the different variables of the desired table, but the problem is that this request does NOT retrieve the actual data.In my understanding I should send a specified JSON-query using GET/POST-command to API to be able to download the actual data. But I have no clue how to do this in FME. I've tried to go through JSON-readers schema scan using JSON-query, and I looked for the HTTPcaller but don't know if Query String Parameters or Body settings could help me with this. JSON-query should look somewhat like this:{ "query
I want to connect the orange and green points together to form 3d polylines (I'm in effect wanting to create a ray). The orange points represent a point on the ground and the green points represent the point in space where an image was taken of the point on the ground.
How to convert trimble sketchup (.skp)-files to Esri MultiPatch, with first alignment en clipping on a GIS-buildingunit-layer
How can i create a generic fmw file(X format to Y format) that can convert any x format file to y format.Instead of creating new fmw file for every(X format to Y format) conversion.Is that possible.
Hi guys,I am comparing 2 sets of data (6 months apart), in separate file geodatabases. There are approximately 18 feature classes in each database with a roughly 50,000 features in each class.Is there a way I can run a change detector on each feature class without having to add each feature class individually to the workspace?Cheers, Dave.
Hi. Me and my collegues have encountered this problem many times but we still haven't found an adequate solution. Please help! This is actually exactly what the Excel command Transpose does (when pasting copied data).I want this data to be transposed to this dataAnd if there a more ELEMENTS (after Zn) it should dynamically be included... We have looked at all the transpose posts here but we haven't found a good answer. ELEMENT, As, Ba and so on should be turned into attribute names for further use in the script. Any help will be gratefully accepted.Peter et al
Hi FME experts, I'm having difficulties updating below: Left is what I currently have, right is what I'd like to have. Have Want Toi et Moi (Villa) (Villa) Toi et Moi Wilgenerf ('t) Landhuis ('t) Wilgenerf Landhuis Gheestelic Hof (Het) (Het) Gheestelic Hof So if it finds anything in between brackets, take that and put it in front of the string. I've been trying the StringReplacer with the following RegEx: (\\(.*\\)) - but no luck so far.Cheers, Ed
I have a bulk soap extract that has a list of assets with attributes as properties, not elements. I cannot find in the many XML transformers what I need to do to get the assets back into a simple table with each property as an attribute.Here is a snippet of the first two AssetSummary elements.