Transformers

@Michael257

Hi,I'm creating line with measure on vertex and write it to postgis. When I read the same line from postgis, there is no measure. Is-it possible to write and read measure from Postgis?Thanks

Hello - I have a dataset of polygons (some of which are donut polygons). Some of these polygons contain multiple parts (i.e. more than one polygon per record). When I run this dataset through an AreaOnAreaOverlayer it seems that some of the multiple polygon parts are lost. This is shown in a comparison of 'DataExtent.png' with 'AonA_Output_Extent.png'. I have tried running the polygon dataset through a Deaggregator thinking this would split records with multiple geometries in to multiple records (in case multiple polygons per record was causing an issue for the AreaOnAreaOverlayer). However the output from the Deaggregator is untouched regardless of the settings in the transformer (so perhaps these are not aggregates). Ultimately I need to run these polygons through the AreaOnAreaOverlayer but need all parts to be considered.  The data was initially stored in an Esri file geodatabase and I've also tried as a Mapinfo .TAB but am getting the same results. I have also

I am unable to write features to a feature class, because FME doesn't recognize the coordinate system. This data is a feature class from a FIleGDB, in LL-WGS84. I didn't originally set the coordinate system, and it seem to read and position the features appropriately, but inspecting the features coming out of the reader, coordinate system is defined like this, with extra characters. When I try to write the features to a new feature class, this message comes up. Feature Caching is ONThe workspace may run slower because features are being recorded on all output ports.Coordinate system named _LL-WGS84_0 does not exist.  The workbench appears to run successfully, but the feature class does not open and if I view written data in FME, the map opens up somewhere in Asia. I had added a custom transformer a couple of weeks ago, so I thought that might be causing the issue. I removed it from the documents folder and restarted FME, but it didn't seem to fix the problem. Has anyone

Hi guys, I'm trying to add a named constraint primary key into a large number of SQL Server tables joined in one reader with this code in the 'SQL to Run after Write' part: FME_SQL_DELIMITER ;ALTER TABLE @Value(fme_basename)ADD CONSTRAINT PK_@Value(fme_basename) PRIMARY KEY (id1)But I got this error:Microsoft SQL Server Spatial Writer: Query failed, possibly due to a malformed statement.  Query Text `ALTER TABLE @Value(fme_basename)ADD CONSTRAINT PK_@Value(fme_basename) PRIMARY KEY (Id1)'. Provider error `(-2147217900) Incorrect syntax near '@Value'.' Does anyone know what is the error? Or how can add a Primary Key for a large number of tables joined in one reader? Thanks a lot

I'm totally new to FME and straight away having problems with conversion from DWG. The conversion is successful but when i zoomed in to the layer (in Arcgis Pro) the parcel data appears to be located somewhere in the middle of the ocean. The parcel data is in GDM2000 Malaysia RSO projection. I wanted it to be displayed in UTM WGS84 48N along with other GIS layers. I really couldn't find out what I am doing wrong here. Thanks.https://drive.google.com/file/d/13GyjeDa9lyH3T4sOUnTKcs4j4ayADFkr/view?usp=sharing

Hello,I am struggling with the use of a WMS reader within my workbench. I would like to use the outcome of the WMS reader as a shapefile and use it within a Clipper transfomer. But the outcome of the WMS reader is not (yet) suitable for shapefile purposes, as it is a raster. I tried the transformer RasterToPolygonCoercer, but it results in a lot of polygons instead of only one polygon (matching the national border of the Netherlands). Should I use another transformer? Or is it possible to read the WMS with different settings? For the WMS reader, I use the following URL: https://geodata.nationaalgeoregister.nl/bestuurlijkegrenzen/wms?request=GetCapabilitiesWithin 'Parameters...' I select under 'Layers' the layer 'landsgrens'. This is the layer where I am interested in.  Furthermore, I used the default settings: Hope anyone can help me getting the national border as a shapefile. Thanks,Eva

Hi, I have a database table with a date column containing dates formatted as YYYYMMDD. I need to select all records from the table with a date ranging from the current date to 5 years previous of the current date. Any assistance appreciated.

We have a DWG Template that defines layer names, and a range of attributes like colour, line type, line weight, block names, etc. In the main this template contains no features.I want to use the raw (featureless) attributes in the template to merge with an existing drawing to check if the layer names and associated attributes are matched. Is this possible?I have a table that has been created with the raw attributes and can merge that with the supplied drawing but if the template changes the table also needs to change, so was hoping I could remove the step to create the table and just read the template. 

Hi all After processing we are left with ortho tiles in GEOTIFF format. The GEOTIFFS on the edge of the process area have black borders. When we process to area's next to eachother we have an overlap with the black borders.  Normally we work with jpeg2000 and I use the rasterbandnodatasetter and the rasterinterpretationcoercer to convert the nodata to an alpha band.  But now our client wants the orthophoto tiled with their specifiactions and in ECW. This is my tiling workbench. Pretty easy. The rastermosaicker groups by "naam" and puts out ECW tiles.  The result looks like this:As you can see there are black borders in the area's that overlap. What I understand is that ECW wont work with nodata and wont work with alpha band.  How can I solve this? I could convert the original geotiff files to tiff with the nodata and rasterbandinterpretation method. Once I have them I can tile them with my workbench but use a tiff writer instead of an ECW writer.After I have my tiff t

Hi all, I have been trying to put together some GIS data we have that was in a list format. When i use FME and check with the inspector this looks fine, data is what i am after. The same when i produce this in QGIS, looks fine. When using arcmap, i seem to see some of the shapes are not getting the same symbology and just displays the outline of the shape. Does anyone know why this might be the case and is there a solution to this issue? 

Hello FME users,I have two layers1. Area Polygon2. LineRequirement Polygon (Blue) need to align to the Line (Red) . Tried “AnchoredSnapper" could not work can any one help me out how can this be accomplish? 

Hi list.When setting expressions in XMLTemplater for ROOT and various sub templates, one uses fme functions like "fme:has-attribute" and fme:get-attribute".But is it possible to use string functions as well, e.g. to test the first character in a string retrieved by "fme:get-attribute" ? I can't seem to find any documentation about this with Safe.I've found some string functions documented at Microsoft, e.g. https://docs.microsoft.com/en-us/sql/xquery/functions-on-string-values-substring?view=sql-server-ver15Here a namespace of "fn" is used, but will that work in FME ?And how do I wrap multiple function within each other ?Is it { f1( f2() ) } or is it { f1( { f2() } ) } ?Any insights will be appriciated.Cheers.

Hello, I'm trying to extract a multipolygon from a JSON file with the model of this topic (https://knowledge.safe.com/questions/40791/json-multipolygon.html) but I don't achive to do it ...It's my first time working with JSON The multipolygon in the Json file is defined like this (I replace real value by x1 x2 etc in the exemple) :{ "stages": { "filters.hexbin":{"boundary": "MULTIPOLYGON (((x1 y1,x2 y2,x3 y3,.... )))I've try with : json["stages"]["filters.hexbin"]["boundary"] in JSONExtractor but it doesn't work , an I don't really know what I need to fill in "JSON Document" ... Does anyone have any idea how to do it? Regards

Hi,I am new to FME Desktop and I would like to get help in order to extract all the street side segments which are located within 5 meters from the standpipes. The resulting segments must also contain the attributes of the standpipes that meet the selection criteria and produce an Excel report of all the selected segments.How can I achieve this task using FME?PS. I'm using FME Desktop 2020 Thank you!

I have a shape file and i want join with xls sheet (consists of X and Y), there are no common id between them but xls feature lies inside the shape file polygons and there are multiple polygons how i will join shape file with xls?

I'm using the IterativeSnipper transformer to segment ~1000 polylines to cut each to a maximum of 5 miles however if there is a northbound polyline I want to ensure the southbound polyline is also snipped at the same location. The southbound for example is exactly overlayed across the northbound. Is there a way I can do this where if two segments fall within a 2 meter buffer they will both be snipped at the same location? Alternatively from my research I hear it is possible to do what I desire by snipping one direction, pulling the start and end gps values and then do an anchored snap method? to make sure the opposite direction is snipped at the same location? I dont know exactly how to set this up though.

Hello thereTraying to use FME to convert date formatdate : 1591982226conversion :Friday, June 12, 2020 5:17:06pmthe conversion was done using this tool ( https://www.silisoftware.com/tools/date.php?inputdate=1591982226&inputformat=unix ) is there a way we get the same result with FME transformerThanks 

Hi!I have a task for an aviation project where there are multiple 3D surfaces of runway approaches (from DWG). I need to take the multiple surfaces and create a single composite "blanket" object taking all of the lowest elevation information. This is because the client would like to know how high an obstruction can be before it intersects with any of the approach boundaries. I've seen SurfaceDissolver & SurfaceFootprintReplacer, but I'm not the best at FME so I'm unsure of a good workflow.Any help would be appreciated! Thank you.

Hi community, I'm trying to find a neighbour for some polygons, then I'm dissolving the base with its candidate. Until here, everything works fine, I get the candidate and dissolve them, but I'm facing the issue that those polygons are multiparts and sometimes Neighbour Finder finds as candidate another multipart of the same father and when I dissolve them the multipart stills as it was before because for some cases the transformer finds the neighbour in a shared coordinate and that candidate has the same value in attribute X.  I considered to filter previously all features named as "A" for the example below, but "A" could be a valid candidate for other multiparts with another value different to "A", so I think that is not an option.  Thanks for your support! Alejandro.

Hye Everyone, Im still newbie in e57 format. May i know whether i can convert my 360 image in JPEG to e57 data format? Thanks and Sorry.  

Is there any transformer that would allow me to generalise a linear feature but use an area polygon as a barrier so that the line does not cross the barrier when it's generalised ? For example a linear road network and polygon road network . I want to generalise the road lines but keep them inside the road polygons . ?

I need to create geometry for records which were merged with other data.records with Geometry from SHAPE.STLength - belowrecords with no Geometry from SHAPE.STLength - aboveThis is the process with the transformers at the top is where the geometry records are not showing up after they were merged with supplier data

Hello, I have three records: 1.07, 2.34 and 4.81 and I have 5 different categories:categoryvalueA0.65B2.55C3.85D4.75E7.95 I want to assign a category to each of my three records. The category assigned should be the one with the value closest to the record.For record 1.07 it should be category A, for 2.34 it should be B and for 4.81 it should be D. How can the assignment be done automatically? What transformer to use? thx.

I have points with attributes and a line. I have used the point on line overlayer to break the line at each point. however there is not a point at the beginning. I assume that is why the attribute of the point is attached to the line the point is at the end of. I need to attach that attribute to the next segment of line. in other words the begin point of the broken piece would give it's attribute to the following segment. I can think of a long way around by creating a crc with the points coords, then by getting the begin point of the broken segment and creating a crc with it but if there were any round issues it would not find it's match. Any other more elegant method anyone has used?If i simply add a point to the beginning of the line will that offset them all to the beginning?