Transformers

Is it possible to read the coordinate system from the input features and use it as source for the ESRI reprojector? Background is, that I don't want to define a transformer for each UTM zone as the destination coordinate system and the geographic transformation will be identical for all, so it would make sense to read the source coordinate system from the input files. Unfortunately I have no idea how to realize this. I've tried a User parameter, but I have no idea how to dynamically populate this value with the source coordinate system.

Hello All,I have two datasets. The first dataset is excel files that show citizens' residence the second dataset is GTFS. I want to find the number of residents who live within 400 meters from the existing bus stops. I would appreciate the help or advice. Thanks

Hi,I want to cut a raster with shp file, and the result raster will have the extent of the clipper's instead of the clippee's. (consider null or nodata as filled up)

I just want to create a line from below table in screen. To do it may be needs to create list as below but I do not know how it manage. Please help Sample of list below. Facility Name | Request User | X | Y |========================================Line | MEKK | x1 | y1 |Line | MEKK | x2 | y2 |Line | MEKK | x3 | y3 | Line | MEKK | x* | y* |    

I'm trying to calculate a 7-days moving average in FME 2017.Using "DateTimeConverter" and the "Cumulative" option in "StatisticCalculator" I've managed to calculate a moving average on a weekly basis. However, the calcul of the average re-intializes at the start of each week with the value of the first day of the week.Is there a way to implemente a moving average with a known frequency (7 days in this case, 365 in another I'm working on)?Thanks

@takashiHi !Any hints how to align label with the line direction ? I'm using a 2DVectorCalculator, Featuremerger, offsetter and vertex creator. But I'm not always having the right orientation of my labels with the line direction. See below attached images. Thank you in advance.

FME has disabled truncating a Spatialite table, so I need a hack to do it anyway. I want it to exist so that other applications can read it after it is updated.I need to truncate rather than drop_and_create to refresh the table with an insert because I have another transformer right afterwards doing an SQLExecutor that does a selection from a large table in the same sqlite database. It seems that a lock is added that prevents the drop/create.So you might think that I could hack the truncate using SQLExecutor, but no! All database operators are disabled in FME for spatialite so the "DELETE FROM table" is not allowed.Never mind I will use Python. Ah, but now that I am using FME 64 bit I need to use Python3.6 and that is now from Anaconda which does not have sqlite as a standard module for ArcGISPro, so my python hack also fails.Well then, I will just shell out to sqlite.exe. But wait, FME implements it as sqlite_fme.dll, not a EXE.I can truncate the table if I use a filegeodata

I have a workspace that is generating a couple of shape files returned in a zip file through datastreaming. It works as expected in dev, test and production environment but not in education. In education it only returns one of the files unzipped. I have confirmed that it returns several files and I have resubmitted the exact same workspace that works in the other environments. What other parameters can cause this? Some set up on the education fme server?

How can I include null values in the list of acceptable values (Validation Rule = In)?Also, if an attribute is null, how does that impact the Type (Validation Rule = Type)?

I am trying to clip a point cloud using building footprints from CityGML file. Pretty much like in this tutorial. However the Clipper transformation marks the whole cloud as Outside and none of the points as Inside.  Details:I have FME version 2020.1According to FME Data Inspector the building footprints and the point cloud are alignedBoth clipper and clippee have same coordinate system (EPSG:3301)LAS file I'm using can be downloaded from here and CityGML from hereThere is a similar issue from 7 years ago that was no helpThis sequence worked with 2020.0 version What could be causing this? Are there any alternatives to using clipper?

With older MongoDB Reader, there was no problem on using regex for the JSON Filter parameter, such as:{"insee_code": /^06004/}I can't find how to use regex in the Mongo query with the MongoDB3 Reader, and I have this type of error :MONGODB3 reader: SetAttributeFilter(): Got parse error at "/", position 61: "SPECIAL_EXPECTED": could not parse JSON documentI also notice that the Mongo keys always require to be between quotes, while with MongoDB Reader version we could use "un quoted" keys for filter.  Are there any other changes with this new driver? Thanks for the info !  I use FME Desktop 2019.2.1.0 (20191202 - Build 19813 - WIN64)Mongo version is 4.0.13

I have to define 3 custom coordinate system ( HDKS-5, HDKS-6, HTRS96 or epsg codes: 3907, 3908, 3765 ) and parameters for transformations between them. I tried this: https://demos-safe-software.fmecloud.com/fmedatastreaming/Coordsys/Start.fmw? I copy esri wkt from https://epsg.io/3765 and paste to previous link but I get wrong results when I transform from HDKS-5 to HTRS96.Thanks in advance.

Hello all,  As far as I can tell the "Snapping Distance" param for the Snapper and the "Tolerance" param for the Intersector have to be hard coded or a workspace param. ie. They need to be known before the workspace runs. It would be really useful to have these values calculated within the workspace as the snapping distance/tolerance may depend on the data being processed. ie. It would be nice to be able to set the snapping distance from an attribute and the Snapper uses the value from the attribute of the first feature of each group entering the Snapper. Is this, or some variant, currently possible? I am considering splitting the workspace into two workspaces and having the first one calculate the value then calling the second one, however it would be much more convenient to be able to do the calculation of the snapping distance in the same workspace. Any assistance is appreciated. Thanks Michael Pascoecc: @deanhowell​ , @luke.giles​ 

Hi,   I've searched for the ways to calculate quantile for an attribute in FME with no joy. Does anyone know if there's a transformer or a combination (possibly sorting and then extract the value at a certain row?) that's capable of calculating quartile, percentile etc in FME?  Cheers.

I have been having trouble writing geometries into custom linestyles in dgn. I have specified the seed file in the writer parameters and have set the color, style and weights using the "From Seed File" level overrides in the writer. However, when I write out the dgn, the custom linestyles seem to be dropped.I have attached an image with some test lines. The dgn on the right is the dgn that was written out and the dgn on the left is what I am working towards. I created my seed file by deleting all the lines I drew in the dgn on the left. Does anyone have any advice?

Hello, I am trying to install a few python modules to the python 3 installation included with FME workbench 2020.1 on MacOS Catalina 10.15.6. using pip is there a way to do this? furthermore, is it possible to use a virtual environment?

Upload File In Session in FME Server Playground documentation(and also both "Easy Translator" and "Easy Translator FME Server App" presented at FME Server Playground Demos demos),all use GenericReader + GenericWriter to do both format transformations and coordinate transformations. Actually, in order to correctly reproject between different coordinate systems, all these demos should contain also the EsriReprojector in between the GenericReader and the GenericWriter (and enable filling its public parameters from the javascript web app). Example of what happens if EsriReprojector is not used:Converting coordinates between Israel TM grid (EPSG:2039) and wgs84 (EPSG:4326) need to handle many internal parameters, and this is done correctly only by EsriReprojector by using WGS_1984_To_Israel_CoordFrame Transformation. All examples mentioned above fail to do it correctly (they shift the results) because they don't use EsriReprojector in between the Generic-reader an

I'm looking for a tool to assist with the creation of databases diagrams for an enterprise geodatabase. Essentially, I would like to create a table with: field names, data types and length (domains would be nice but not necessary). It looks like Scheme Reader (from table) should allow me to do this but I haven't been able to figure it out. Is anyone able to provide an example? ESRI use to have a tool to do this but it no longer works with 10.5+. Documenting your geodatabase design

I need to mosaic thousands of images, I was wondering if this is possible with FME or FME/cloud. Is there any feature for dealing with big Geodata? and what is the maximum capacity?

Hello all,I'm reading labels from a DWG and trying to determine what line they apply to based on their location relative to the line. As part of this I use the oriented bounding box of the text rather than the anchor point as the text usually has the anchor point below and to the left of the actual text while it is the actual text the user has positioned relative to the line. A BoundingBoxReplacer works well for this. However the bounding box includes the anchor point. See pic: Is it possible to get the bounding box without the anchor point included?ThanksMichael Pascoecc: @deanhowell

I am using a KML file exported from a GPS device and using FME I have have translated the KML to excel. I want to use a transformer to remove the extra text in the cell that I don't need and retain the text that I do need to conduct a match to the image file. Example below shows the italic text is the text to be removed and the bold text is the text to be retainedCell <a href='images/insphere/14325921-964c-4024-b002-8cb1549f232d.jpg'><img src='images/insphere/14325921-964c-4024-b002-8cb1549f232d.jpg' width='250'/></a>Image fiile14325921-964c-4024-b002-8cb1549f232d.jpg

Hello all,I am processing a dataset in the state of Queensland, Australia which lies across three UTM zones.Because my processing involves calculating area and perimeter in metres, and my source data is in LL I want to divide the data according to the three zones, reproject, calculate, and then reproject back.How can I filter each spatial object so that it goes only once into each appropriate zone?SpatialFilter tests the whole candidate, but if an object lies on the boundary I only want it to go into one zone, so really I want to filter by the centroid of the spatial object, not the entire object.Is there a filter for centroids?

I am facing some weird behavior from fme desktop, i have a sql executor and able to connect to oracle (thru named connection) , I tested it , testing good, able run the sql to bring fields to expose, bring the output fields(expose) within sql executor... i can do everything in development stage. But while running it gives TNS name error. how can i fix this? 9:26Connecting to ORACLE database `My_connection' with user name of `' and password of `***' Error connecting to Oracle database: message was `ORA-12154: TNS:could not resolve the connect identifier specified'. (serverType=`ORACLE8i', serverName=`My_connection', userName=`', password=`***', dbname=`')

we have a lot of data on the cloud and locally. does the desktop ESRI license provide the capabilities to connect to remote databases/data?

Hi I have table of with x,y, coordinate_number, and ID associated with each record. I created the vertex, sorted by coordinate_number and trying to use linebuilder by grouping by ID. However the option to group by ID is missing in version 6 of the transformer (2018)Any suggestion how lines could be built efficiently by grouping by field ID? I cannot upgrade FME Desktop for now. I am expecting about 1.5 million lines to be created.