Transformers

Thanks for your help in advance, I am creating composite content, stacking polygons together from different 'surfaces' then clipping. This works as expected but it is almost exponentially creating additional vertices. This is an issue and as a result I need to generalize the output. Unfortunately when I use the generalizer tool the output geometry reports lots of invalid outputs, mainly 2d self intersections. Does anyone have any suggestions to help.Many Thanks

I have an IFC File that was exported by Revit. FME triangulates the surfaces as can be seen in the picture. Is there any transformer or parameter option to solve this problem? @DaveAtSafe

The issue: When using the FME 2017 and 2018 NETCDF writer the coordinate system of the output file is 'unknown' even when set. Writing the same data to geoTIFF has the correct coordinate system set. So far I have tried1. Setting the crs in the reader and then writing out with no specified crs2. Setting the crs in the writer3. Using the CoordinateSystemSetter to set and then writing with no specified crs4. Using the CoordinateSystemSetter to set and then writing with a specified crs (same as what was in the crs setter)5. Setting the crs in the reader and then using a reprojector (GDA94 to WGS84) and then write with no specified crs6. Doing 1 and then writing to geotiff Results: 1,2,3,4, and 5 have a crs of 'unknown'6 has a crs of 'GDA 94'Attaching an inspector to readers with a specified crs shows the crs as 'GDA 94'Attaching an inspector after the coordinate system setter and the reprojector shows the crs as 'GDA 94'

Hi All,  I am building validation rules for 3D buildings. One of the rules I would like to test is to check that all the surfaces (walls, ground surfaces, roofs) are not crossing each other.  When I test this with dummy data, this works fine using the SpatialRelator. (Test to perform: Crosses) [I create dummy data by creating 2D-lines an extrude them (some of them with a constant extrusion height, some of them with and extrusion vector) so I get surface which intersect somewhere in 3D (and the intersection is a line) and the SpatialRelator detects my crossing objects. So this works fine.]  When I test the same with real data (and I know some of the surfaces do cross, the SpatialRelator doesn not detect the crossings.  I have the impression that the difference is the geometry type of my "surfaces". In my dummy data the Geometry is IFMECompositeSurface and contains a IFMEFace and an Appearance. (it is the extruder who changes the geometry-type from line into IFMECompositeSurfac

I am currently working on creating polygons from a gps tracks based on tracks of same attributes using hullaccumulator but my points (tracks) are scatter and producing overlapping polygons so I am looking for how I can set a distance constrain so points closer to each other can form a separate polygon from tracks further apart even though they have same attributes. Please how can I be able to set distance constrain in this scenario?

Hi Everyone,  I have been using FME for some time now and am now getting into little details. My question revolves around parsing out filenames and eliminating portions of them to create a new name. This is probably elementary to many of you.  I have a name like this:   2_038_1558_0001.ecw  In this case, the number after the last underscore "_" is always an incremented value. What I want is to always eliminate the last underscore and following number and extension and have the following result:  2_038_1558  The sequential number portion is not always 4 digits. Sometimes it is 2 or 3 or 5 (2_038_1558_0001.ecw,  2_038_1558_023.ecw, 2_038_1558_00012.ecw)  Any ideas of the which transformer to use and/or the code the place within it?  Thank you for any help .  

Hello,can someone please help me to understand this error:ERROR |Microsoft SQL Server Spatial Reader: Failed to fetch post-ADO SQL Server columns for table I can't replicate it every time I run my workspace. But when I capture that, the process ran and I got expected results.Thanks

I am new, so I appreciate your patience.I have tried to search for my answer, but so far no luck.I am attempting to compare the values from 2 datasets (no geometry at this point) with the same attribute names. I used the changedetector so we could see which attributes were non-matching and which were missing from one of the datasets (updated, inserted, deleted).The features have dozens of attributes, so when something doesn't match it can be a process to determine the exact attribute that it failed on. How can we retain/build the relationhship back to the attribute name and value to pinpoint where the failed match occurred?

Hi I'm applying change updates to OS MasterMap stored in a geodatabase. However, it is not inserting the new featuresI am using two feature mergers, one to find the deleted features and one to find the updated and new features to insert. These then go to attribute creators to create the fme_db_operations field with DELETE, INSERT and UPDATE values.My writer parameters are as follows: TOID is the unique value field. It is deleting and updating existing features but not inserting the new ones.Any help and advice would be greatly appreciated.I have attached my workbench for you to look at if that helps.Thanks,Matt

I have a spatial table (an ESRI feature class) that consists of many points. I want to divide the points into groups based on an attribute "projectCode", then create a center of mass for each group. All the centers form a new feature class. Any hint how to do this?.

I have a test2 shp file representing a 3D door, and then try to convert test2 to the fbx format file, but the fbx file appears translucent area. After query, it is found that the normal line needs to be set perpendicular to the surface. How do I set it? This file contains test2.shp and fwm project files

I've got a dataset with lots of columns and the contents of the ones I need to tackle contain many zeros (0) and lots of ones (1)... there are also lots of 'Yes' and 'No' values. I want 'selected' columns to be checked for the existence of a 0 and it should be replaced with a 'No', 1s need to be 'Yes'.The AttributeValueMapper will do this on 1 attribute, but I don't want 1 AttributeValueMapper per column.An AttributeManager allows me to set conditional values, but I don't want to have to create this conditional rule for every column, even with FME 2018 supporting copy\\paste, that's too much effort.I'm currently using 2 chained NullAttributeMappers, with one of them handling the 0 mapping to No and the other the 1 mapping to Yes.But what would you do? I'm looking for ideally a elegant single transformer solution and really an AttributeValueMapper that could work on more than just 1 column seems to be an 'Idea' I o

I am producing an XML file in a loop. I write one feature formatted as XML at a time. In the next loop execution I wish to write over what is in the file or wipe it out completely and write the current feature. Thanks.

I am trying to reproject this feature in order to view it on bing MAP, but its not working, those features should be located In Dammam City in Saudi Arabia

Hi All,     I've been tasked with optimising a workbench that's quite slow.     Basically I take in a very large DEM raster 2m granularity, and need to clip it against a vector dataset of 50m grid squares. The vector dataset then pulls the underlying raster data (RasterCellCoercer), and calculates statistics (StatisticsCalculator) using a group-by from the clipping.          The clipping part I've got down to about 30minutes.          The problem is the RasterCellCoercer. That part takes 15hrs! It creates about 300,000,000 points (yes, 300 million!) from the raster (there are about 4.5 Billion points in the source raster, so the other 4.2billion are no "noData" or were culled completely). I can't think of a way to get the number lower because that's how many the features require.          Any suggestions for a faster way to get the DEM values in a way that they can be grouped for a statisticsCalculator pass?     Would somehow trying to coerce it into a Poi

Hello,please, Im trying to solve interesting issue in gasoline industry. I have the source file, contains lines features, and I need to compare lines to each other. Issue is following:- none of line end-points cannot be in distance 5-30 centimeters to end-points, vertices or line segment of another linesIs there any possibility to detect this gap between lines please?Thank You so much!Lubo

I have a decelorator in my routine but it is failing with the message below. It looks like it is failing within the transformer. @Tcl2 -- failed to evaluate expression `if { {Limit Features Per Second} == {Per Feature Delay} } { rename Decelerator_delay Decelerator_Waiter; } else { rename Decelerator_maxpersecond Decelerator_Waiter; };' -- can't rename to "Decelerator_Waiter": command already existsAny ideas how I can get it going?Thanks

Hi, I have one table with phone numbers and another with regex for possibles mobile/phone numbers. I'd like to extract which ones of the first ones are mobile and which ones are regular phones. is it possible with feature merger? Many thanks

Hi Im having trouble validating some XML, I keep getting no declaration found for element Features errors.heres the 1st part of the XSD <?xml version="1.0" ?><xs:schema id="Features" targetNamespace="urn:284_SeAr.xsd"  xmlns="urn:284_SeAr.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema"  xmlns:sql="urn:schemas-microsoft-com:mapping-schema" xmlns:dt="urn:schemas-microsoft-com:datatypes"  attributeFormDefault="qualified" elementFormDefault="qualified"> <xs:element name="Sediment_Area">  <xs:complexType>  <xs:sequence>...And heres the start of my XML<?xml version="1.0" encoding="UTF-8"?><Features> <Sediment_Area>it complains no declaration found for element 'Features'But even if I remove the features element it still has similar errors all over the rest of it. After looking at some similar problems I am now suspecting this is something to do with the namespaces but even if I move them into my XML it doesn't seem to parse.Is features actua

Hi,I would like to filter out whether a certain value appears multiple times in either of two fields. An example:ID1ID2Desired action1_22_1keep1_33_1keep2_11_2discardCurrent attempts have either given me the rows which don't ever appear twice across the two fields, or a full list of those that do appear twice across the two fields. Is there a way to filter out duplicates looking at both fields?

I have a table that I'm downloading from an FTP site as an attribute (all data is in a single cell) that I need to inject into another part of my workflow as if it were coming from a csv reader table (data is broken out into their respective cells). I've been able to get the data broken down into it's indexed components but can't figure out how to reassemble them back into a table. I've looked at the transpose demo video but I'm not sure how to handle I've attached a workspace that shows where I'm at as well as an image of what I'm trying to replicate. Any help would be very appreciated! :)

Is there a way of doing the same thing as in ArcGIS Raster zonal statistics ? I have a 1 billion cell raster (whose values are comprised between 1 and 5) on which I want to overlay a 3000 polygon layer. I am looking for the number of 1, of 2, of 3 value cells, etc. in each polygon. Coercing my raster to vector (polygon or points) would produce a too big dataset so I am trying to avoid it. Any ideas ?

I have a dwf file with points and text (as line features). I'm trying to convert the data to a point shapefile and add the line text to the point as an attribute. In the image below the text '7086 PM' is actually just line features that make up the numbers and letters. Is there anyway to convert this to a shapefile and append the text as an attribute? If needed, I can share the dwf to get a clearer picture of what I'm trying to do.

As shown in the attachment, I am looking to replace the <missing> values with the value located above it. For example, I want rows 44 to 48 to contain the value 2nd st.

How can I find solitary pointobjects? I have two datasets with pointobjects. From both datasets I want to filter the objects which have no other near object within a specific distance. And then I want to match those solitary objects from both datasets "if the solitary objects from the seperate datasets are within a specific distance from eachother. How can I do that?