Transformers

How to calculate lat long of this lines corner vertex points in FME with help of any transformer or any other useful method with any projection of the shapfile.Anybody can help in getting this Lat long or XY co-ordinated for this four corner positions of any randomn area with any projection.Just need to extract XY Co-ordinates. how can we generate or extract it. Please find below snapshot for reference to understand it better.

Hi, I have a postgresql database I am writing to it has the following fields:    changedetect_date timestamp without time zone NOT NULL DEFAULT now(),    changedetect_uuid character varying(36) COLLATE pg_catalog."default" NOT NULL DEFAULT uuid_generate_v4(),    pk_index integer NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ), All these fields do not need to be inserted into by FME but FME is trying to insert NULL's into them even through the fields are not explicitly set in my feature writer (set to automatic and does not have these fields). When it inserts postgres gives an error 'ERROR: null value in column "pk_index" violates not-null constraint DETAIL: Failing row contains (...'POSTGIS writer: A fatal error has occurred. Check the logfile above for detailsSuccessfully closed POSTGIS database writer=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- What can I do to get around this? I tried using ma

Is it possible to resample a raster so the values left are one of the existing band values? If I use the raster re-sampler with the average 16 interpolation type, I get an average of the 16 cells but what I need is the value that occurs the most in these 16 cells.

Hi folks, I started using the Tygron API, which I used to extract building information for a specific location/site. However, when I request the building information, the response body is a JSON Array with JSON Objects of which only approximately 1/3 of the JSON Objects are actually about buildings. To determine if a JSON Object is about a building, I'm checking if it contains a "BAG_ID" attribute. Below is some a sample_json Array that illustrates the data structure I'm working with:[ { "id": 1, "name": null, "attributes": { "type": "Bridge" } }, { "id": 2, "name": "just a shed", "attributes": { "type": "Shed" } }, { "id": 3, "name": "just a house", "attributes": { "type": "Building", "BAG_ID": 1.5010000000035E14 } }]In the real world data, the JSON Array contains a lot more features and data.  Initially I queried out the JSON Objects on buildings using the following steps;JSONFragmenter (create features for individual JSON Objects),JSONExtractor (Extract BAG_ID at

When dealing with JSON data, I sometimes like to use the JSONiq XQuery extension to manipulate JSON data a bit more directly. For example to be able to directly query for only relevant data (see e.g. this question), or directly setting list attributes for portions JSON without the overhead of fragmenting/flattening the entire JSON structure (see e.g. this question). I've been quite happy with the flexibility that the JSONiq XQuery extension seems to bring me, but as I'm using an XMLXQueryExtractor for this, this seems like a bit of a hack, and thus it might be that JSNOiq is not officially/fully supported. For example, I also came across the situation where I wanted to check if a JSON value was equal to null or not. At first I had a look at the JSONiq specification page. There in the Revision History (at the end), I found this line below Revision 1-1;Removed the function jn:is-null() because it is redundant with the "eq" and "instance of" operators which sup

Hello,I am using Aggregator with FME 2018.I restricted my data to only one feature. So literally there no aggregation but the transformer is taking 10 min to proceed.Is this normal? Is there a way to optimise it?

I have created one text attribute using the AttributeCreator transformer and by default, its length is 50, there is no option to change this length in FME. This attribute is created for the feature class to save filename which is over 50 characters.

While converting Ecw the following error will appear ECW writer: The ECWJP2 SDK only has 200.0 MB of memory allocated to it and this is not enough to compress this dataset. Please set the SDK's memory limit above 304.7 MB

My input has a lot of Ring looking objects in it, when viewed from Autodesk everything is smooth but the FeatureReader doesn't see them as rings, but some dumbed down rectangular shape. Reader: How it should look:How it looks: What I've tried was extracting coordinates and rebuilding with Python and Scipy and it seems that for some reason it has ~380 coordinates in it but 12 duplicates of each exactly at the points where the ring seems to 'break'(coordinates only appear there, nowhere else), could this be source of the issue? Or where should I look? I'm trying to write these to a Cesium Tileset but I don't think that should be relevant since the rings show up like that the moment they get read and not just in the output. Thanks in advance!

I want to read all features in the mxd or gdb and write to gdb. How can I do this with only one reader and one writer

Hi guys,just wondering when using AreaOnAreaOverlay on single input, can it add attribute to show which records's overlap which? Currently i only get the overlap count option but ideally I'd like each record to be added as an attribute field and with a return value so i can see. Thanks in advance 🙂 

How would one create a new line that lies right in the middle between two existing lines? Imagine that we have the blue and pink lines below, they are parallel but not identical, and we want to find the centre (doted) line between them.  I was thinking one could AreaBuild the lines and then chop the resulting polygon into shorter segments, use a CentrePointReplacer on the segments and then finally connect the points. But before I dive down that rabbit hole I was wondering if there was a more efficient method to achieve this? 

I want to write some 50000 features to Excel with fanout enabled by some attributes.One of the fanouts contains 23487 features and fails the workspace with the message Error running translation with 8179 features inputted to the writer. If I filter it out the remaining 118 fanout files get written to disk.I tried both normal writer and FeatureWriter. I have attached the workspace.I started with FME 2021.1.3 and updated to 2021.2.0.1

Attached is a testkit with a raster (geotiff 10mx10m), 3 overlayered polygons and workspace. I would expect that if I clip the given raster with the smaller polygon the raster sum would be smaller. Clipping with a larger polygon (which contains the smaller polygon) would yield a larger rastersum. The polygon named T20 in contained within T100 - but the rastersum is larger for T20 than for T100 - if the cellsize is 7 or 10m.The last transformer calculates the ratio on the rastersums between the different clips, and there doesn't seem to be any pattern.   

I have a dataset containing fields representing year and shape length and would like to know how to sum the shape length based on different ranges of years. For example, if I had years 2010- 2020 how would I get the following? 2010 = sum of shape length 2010 2011 = sum of shape length for 2010 and 2011 2012 = sum of shape length for 2010,2011, and 2012and so on up to 2020.  For reference, please see the attached image of my data set.  I've attempted to work this out using test filter using the "IN RANGE" operator but it seems to filter out the values for each consecutive year. Would creating a new field using a combination of math functions and string functions within Text editor in attribute manager be a better method?

Hello everyone, So I have many points and lines in my data set. I would like to extract those points that are not on/touch the lines.  May I ask how I can do that? Thank you and sorry for all the questions. 

Hello there,​So I have a list of data - Floor and units. For the units, it could have more than one categories (with space to seperate different categories). And I have a excel list that shows all the categories.What I can ​to do is to check all the Units are within the excel table categories. Might I ask how to do it? Since there could be several cateogries in one unit, I am not sure how what transformer I should use to solve my problem. Data:Floor UnitsG/F Lobby1/F Office Toliet Excel:TypeLobbyOfficeTolietBathroom Thank you for your help!

Hi, I am new to FME. I have a Mapinfo TAB file from UK Mastermaps which contains the map text ( housenumber, streets etc). I would like to conert it to gdb annotations to be used in arcgis.

Hi, I have a polygon layer that represents the building footprint (attribute: building id). In .csv I have a list of apartments (attributes: building id, Apartman id). One building consists of x apartments. So, I need to x duplicates of the building footprint and each clone needs to have a different apartment id. I used the FeatureMerger to join shp and csv and clon to create duplicates of geometry but all duplicates have the same apartment id.

Hi everyone. I have 2 gml files and want to replace some buildings from one of them in the other one using their gml id. I tried feature joiner, but it doesn't work. Can somebody helps me with that? Many thanks in advance

convert Using XML hierarcy(parent-child id) to relational database(postgresql) tables

Hello,  I use one featureReader to load Oracle spatial data on my workspace. How can i choose my geometry like the oracle spatial reader ? By defaut fme read the first geometry field.  Thank you

As an example, in Excel you would use the filter function and select specific values from the drop down menu across multiple columns. How in FME do you filter rows of data based on attributes held in multiple columns? I've looked at the two SQL translators; SQLCreator and SQLExcuter but both need connecting directly to a database. In my case I need to use the transformer within my workflow. Thanks.

Hi FME Community,I have a column with number. I want to add a dot to the last three numbers.the pictures show what I expect as a result:what I have:Thanks in advance :)

Hi, We have an FME workbench to extract features from PostGIS, run through a GeometryValidator to identify and repair features, then written to an ESRI geodatabase. However when loading features from the Geodatabase in ArcMap, some features are prevented from loading due to geometry errors, such as self intersects. Is there a way to configure FME to match the geometry validation routine performed by ESRI and if possible repair these?