Transformers

Hi, I have two datasets, each with thousands of features, I need to check the spatial relationship between them, but if for example 2 features are the same, I would like that based on a certain field with the value of the year for example, it would always be considered the most recent year.  Can you help me? Thank´s

I downloaded gml file of munich and want to use only few buildings, specifically TUM, from it. However the gml covers large area.  How do I cut out the buildings that I want and remove the other buildings from the gml and then save it?  I tried using "Clipper" transformers but I dont have any other information or files to use other than personally knowing that I only want the specific few buildings.  

Hello, I'm reprojecting tens of millions of complex polygons from LL-WGS84 to Esri's USA_Contiguous_Albers_Equal_Area_Conic_USGS coordinate system. There are many other transformers in the workspace as well. Using the EsriReprojector, the reprojection works as expected but takes a very long time. Using CsmapReprojector, the polygons are 3ft (~1 meter) off from where I'd expect, but it's about 30 times faster (many hours!). I've noticed this difference between the two transformers before with any reprojection that has a datum transformation. Does anyone have any ideas that would allow the performance of CsmapReprojector with the results of the EsriReprojector? Notes:I saw another post where a user believes FME is not correctly performing a datum transformation between WGS84 and NAD83. - Could this be a mistake in CsmapReprojector?I have tried changing the Reprojection Engine from FME to Esri in the workspace parameters.The spatial difference seems to be present in an

I am able to complete the geometry transfer from GIS .shp to DGN v8 however the attributes from the writer are not available once the format has been changed even though the reader and writer seem to recognize them.

Hello,In a model that I am creating, i would to expose attribute in the feature reader automatically . The idea is to use the same model for different dataset. I have seen that is not possible to do it automatically but I would ask you if it's possible to do that using the user parameters. if yes, please, can You explain me how to do?Or if there are some other ways.The input file is not stored locally and it's a zip file. Thanks to all. Max 

I have a COLLARS table with the following columns : hole_number, X, Z, Z; I also have a SURVEY table with hole_number, depth, azimuth, and dip. Currently I use the QGIS "Geoscience" plug-in with those tables, it does a nice job but it's static and I can't really schedule it. Any thoughts?

Hello, I have been sent a SketchUp model that includes roads, cars, trains, buildings, and other features. I do not have a SketchUp license. Viewing with Inspector, all of these features are aggregated as one, so I cannot select individual buildings. What is a potential workflow to extract the individual buildings from this mass SketchUp model? My end goal is to incorporate these buildings as COLLADA (.dae) format to be used in an ArcGIS Pro Scene for land use planning and visualization. I know an appropriate workflow may be difficult to determine without having the attribute information, so even suggested potential transformers to use is appreciated. Thank you.

Hi everyone,This is a very specfic question and is targeted towards the persons who work a lot with dgn files in FME Desktop. I ask this question on behalf of my colleague.  He is reading in a lot of dgn files in FME Desktop made by other persons from other departments and some drawings have a global origin that is not x = 0, y= 0 such as in beneath image. My colleague would like to derive these global orign x, y and z values so we can move the global origin of these dgn files to x en y =0. Does anyone thus know if the global origin x and y values are stored in some kind of parameters? When reading in the dgn files in fme desktop the global orign x, y and z are known (see image below). So it looks to me that these values are stored in some kind of variables. 

 

I don't see the grid in email body when I use table in htmlreportgenerator and emailer

I have an MSSQL database, where new rows will be added on and off. I have setup a workspace that will be run nightly, that checks the database for rows with null in the field "email_sent_with_data" and sends it in a beautifully formatted email and it works wonderfully.  However, I would like to send along a map, either a pdf or a shapefile or similar containing the three geometry columns in the row. Any ideas for solutions to this problem?

Dear Sir / Madam, I have an indoor data set. As shown in the figure below.  Red line represents network path.Blue circle is the POI (Point). Black dot is just the vertex. As I have an indoor data for the entire building. I would like to find network that is unnecessary (not linked with any POI), as shown as Yellow Circle. I am just wondering what transformers I can use to find these path?I cannot just simply break the lines as some vertex are necessary for turning. I would really need some hand. Thank you very much!

I am creating PDF reports from ArcGIS Portal Features w/ attachments. The workbench is set up to write to a word doc to use the template doc functionality (custom header/footer) and then converting to PDFs with a PythonCaller. It seems that when writing more than 2 images (from the feature attachments) to the MS Word document, it corrupts the file. Two images or less works correctly and the documents are able to convert.  I am writing out images from attachments to a local drive using the BinaryDecoder and AttributeFileWriter. Then specifying them for the word doc using the MSWordStyler --> Image Source = From File. I've tried using a PythonCaller after the the AttributeFileWriter to compress the images (jpeg and png) and resize them before being written to the word doc, but that doesn't seem to help. Any help/ideas would be appreciated.

Hi, Is there a way to modify execution order of a sub part of a workflow to obtain a full execution of an arbitrary long chain of transformer on a given feature.alike: transformer1 execute row1 - transfomrer2 execute row1 and output 10 row - transformer3 execute row1 to 10- then -transformer1 execute row2 - transformer2 execute row2 and output 5 row - transfomer3 execute row11 to 15- then -transformer1 execute row3 - transformer2 execute row3 and output 7 row - transfomer3 execute row16 to 22 this even if there is merge or agregate transformer. The issue is: I have is that I have to sequence operation on an external web service that some time "loose itself" when for exemple I create all invoices then further in the workflow I create all invoices_lines for all invoices, I need inside of a more complex workflow to create the invoice then create all line for this invoice then create next invoice and so on... I allready know that I can use a workflow runner to achieve this but it

I have this problem:In the workbench there are many writers. Two of them should be in the same zip folder. This happens when I run the workbench in FME Desktop, but when I run it from FME server I only get 1 of the two files in the zipped folder. I use fanouts:@Value(field1)_ExportacioGIS.zip\\SortidaDXF.dxf@Value(field1)_ExportacioGIS.zip\\SortidaDWG.dwg Where "field1" is the same value for each file. In the desktop I get the expected output:But when it runs from the server I get only the DXF file. I try it using a Job Submitter and a Data Download services. Any idea why it does not work from the server?

How to extract start and end name of road from road network ?

Hello , i am using Esri feature service reader to read map service but it does not work with me .when I click on layer to show them ,it is written that token error ,499 error i have admin user and keyword but it does not work to access .could someone advice me ,how could I read map service from ArcGis server ?

Hi, Im struggling a bit with finding nearby points to another point layer. I want the Neighborhoodfinder to find the two closest points within a distance. The output file only includes the nearest point even though I have set the neighbors to find parameter = 2.  I want the output file to include the two closest points and their distance. Any suggestions?Thanks in advance!

I have a shapefile with numerous columns that I need to calculate a mean for on a row by row basis. Within the data there are a lot of values equal to 0 that are skewing the mean - how can I set up a calculation in the ExpressionEvaluator to remove the 0's from my calculation?

Hello everyone! I struggle with understanding how ArcByCentrepoint (and Circle) are implemented in AIXM 5.1/GML. I ingest exactly the same dataset in FME and QGIS. However, in FME everything looks correct whereas QGIS butchers the geometry. I tried this with class C airspaces around Munich and other airspaces. The system behavior is the same regardless of the airspace. These discrepancies are not just ugly, but they also lead to partially invalid geometries. I have attached example screenshots.In FME In QGISI believe that these discrepancies may occur due to each application utilizing a slightly different projection, e.g. UTM, AZMED, AZMEA, and other local coordinate reference systems are probably just part of a longer list. With each projection, the displayed geometries are slightly differently skewed in terms of distances and angles. So far, I have selected Lambert Azimuthal Equidistant Projection for my calculations/constructions, which originate at the circle’s midpoint. In my unde

Hello,I have a workbench that uses a tester to copy files into a folder and zip them based on the create date. This works fine however after I have the files in the new zip file I can't seem to figure out a good way to then use a FTP caller to upload the files since you can't do anything after you have used the filewriter. Looking for ideas of how to upload this zip file to an FTP in the same workbench?    

I have tried using the combination of this transformers to discard or filter out compoundCurve geometry but the issue still persist I would like to find a way to discard these geometry ("CompoundCurve".) to avoid the WB stops when I am inserting data to postgis table. GeometryFilterGeometryValidatorArcStrokcerGeometryRefiner

I am trying to write a bunch of shape files to a geopackage but am getting a strange error.  'OGCGEOPACKAGE writer: sqlite3_exec(CREATE TABLE "table_name" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL' There seems to be a problem when the writer constructs the primary keys for the database, but I have no idea how to address this. There is no id attribute in the source data, I actually tried adding one and the writer handled this by changing the name of the primary key to id_0. Still got the same error though. I am using fme_feature_type to set the table names and schemas.

Has anyone got a method to rebuild a flattened json file using the dot notation? Essentially it would be the JSONAttributePacker but with a iterative approach?

I have upgrade from FME 2016 to FME 2021.2.When I am running the FME script, if I don't give source dataset in SCHEMA READER then I am facing "No Schema Dataset found" issue. But the same script runs fine on FME 2016. I think FME 2021.2 is not accepting empty string (i.e. no dataset) as input.Is there anything I can do to fix this issue ?