Transformers

I have an ArcSDE database on SQL Server 2016 and I want to delete features from a condition.Each night I want to delete thousands of points older than 30 days from now.My points layer has a datetime2 field (created_date).I thought using the SQLExecutor to do this and run this script.DELETE FROM GPSDataWHERE [created_date] < DATEADD(DAY, -30, GETDATE())Unfortunatly it doesn't work and I don't understand why. The log doesn't say much :Microsoft SQL Server Spatial Reader: Query failed, possibly due to a malformed statement. Â Query Text `DELETE FROM GPSDataWHERE [created_date] < DATEADD(DAY, -30, GETDATE())'. Provider error `(-2147217871) Query timeout expired'If I replace DELETE by SELECT *, it works though.Is there any SQL beast here who would know if it's my query or FME the problem? I don't have access to this SQL Server, so I can't test my query over there.For sure I could create a procedure straightly in SQL Server, but my FME script is doing a FGDB backup of those points bef

HelloI'm looking for the rasters that are in the same polygon to assemble them and then cut the mosaic according to the polygon.In this treatment I try to remove the black edges of the images to make the mosaic but I still have black pixels.Thanks D045_3P_79_4_0001.zip

I am using the QGIS plugin "QGIS2WEB" for publishing spatial data into webmaps, written in javascript. The plugin converts all the data showing into .js files, stored in a data registry. Now I want to replace/add spatial data manually, without using the plugin. Is there a way to convert and export spatial data, e.g. json as .js with FME? Thank you.

I have 3D polygons where I need to calculate the aspect for each polygon and add it as attribute. Is there a way to do this? I found a transformer to calculate the aspect for raster but not for vector ,is there a way to go around? Thanks !

Hi,I have the building data captured through stereo plotting process. My task is to create citygml using this data, when I try to extrude the feature using "Extruder" transformer(ref attached screenshot Extrude.png) the building is not extrude properly (ref attached screenshot Issue.png).Same building I tried in Arcscene using the extrusion option, it rendered properly (ref attached screenshot arcscene.png)  Kindly help me to resolve this issue. Regards,K.Jayakumar   

From this Q&A: Replace attribute values for all attributesMy first idea was to use a StringReplacer to replace every attribute with '0' if it matched the regex '^0*$' (0 or more '0'), '1' otherwise.I thought it should work theoretically, but the StringReplacer replaced '0' with '1' in fact.If you set a character (e.g. 'x') other than '0' to the Replacement Text parameter, it worked fine.I'm afraid that there could be a bug here. See also the attached workspace. (FME 2018.1.0.3)Original:Unexpected Result: Every <empty> was replace with '0', but '0' was replaced with '1'.Comparison: Every '0' and <empty> was replaced with 'x'.

hi guys,I have an NW line FC, I need to locate the overlapping in this NW as a point in a new FC any suggest?

Hi, this is my problem :I have a lot of overlapped polygons and I would like to dissolve the intersected part with the bigger polygonI would to dissolve only the intersect part. Thank you to help me because I'm on a dead now! Jonathan

Hello,how is it possible to have nodata in white?ThanksMarion

Is it possible and how would I do that?

I have a workspace that has a published parameter of type Filename (Multiple) and I have multiple files in a folder with spaces. At the top of my fmw file is says that this should be the command-line to run the workspace "C:\\Program Files\\FME\\fme.exe" "ImporteerTrimble.fmw" --DB_Service "ODSDEV" --DB_User "GVR" --DB_Password "********" --Project_ID "22"--SchemaName "INWINNING" --Bronbestand """D:\\Path with space\\file1.dxf" "D:\\Path with space\\file2.dxf"""But when I run this command line it complains that there are uneven number of command line arguments.I just can't get this to work from the command line, running within FME Workbench does work. When I remove some quotes it accepts the arguments but then the reader fails AutoCAD Reader: Unrecognized extension for source file 'D:\\Path'.

I am trying to convert some DEM in .tif image to polygon geometries representing 3 dimensional triangles that is Well-known text (WKT) - 3D (x, y, z) . What is the work flow for doing this?

Is there any transformers to generate intersection points between 3d line and 3d polygon?Thx

 I have a problem and it looks fine until I add the scaler. I can´t get the result good with the scaler. I scaled the orginal model to the size of one meter, so the scale factor is right, e.g. a tree with the height 8 meters should have scale factor 8. Why inspector showing strange geometries when I add scale or z in the scale parameters?

Hello: I have a workspace that I attempted to write a JSON file with the JSON writer. The problem is, the structure of the JSON has a SUB associated with it and the SUB features are not produced with the write. I'm currently using the text file writer where it simply writes the text_line_data from my JSONFormatter. The problem with this approach is that the output are strings and I have some fields that must be numeric. I saw on another thread to dynamically convert the strings to int/double using the xs:int(attribute) or xs:double(attribute) function. This approach is fine BUT there are some number values that have NULL and in order to use the xs function, I've discovered these attributes can't be NULL. Can't I take care of this using the JSON writer by setting the datatype of the output? But again I can't seem to get the JSON writer to generate my SUB features.

Hi,I have a problem and I was wondering if you could help me.I have a road intersection table like this: OdonymeIDIDRueIDINTNameCountIndex730350012611Robert, Rue20730350013121Roxanne, Rue21730350013132Roxanne, Rue20730350015142Thérèse, Rue21730350012092Rue Raymond32730350012653Robert, Rue20730350012963Rosaire, Rue21730350012974Rosaire, Rue20730350015184Thérèse, Rue21  I need to create a table of intersection combinations (IDINT). In other words, for each intersection id I want to know the possible intersection 2 streets at a time.Ex:IDINTIDRue (1)IDRue(2)112121234243249294239293 Someone would have any idea?thanks  

Hello,I am reading a folder containing various Excel files of the same schema. The difference between the files is the date and the content, the structure is always the same. My goal is to create a line diagram in a new Excel file. I want to use the "ChartGenerator". My Problem now is to prepare the data to be used within the ChartGenerator:I will have a bunch of records as illustrated in the "Start" section of the above pic. For every additional date I will have an additional record. I need to convert the data as illustrated in the "End" section. For every additional date I will need an additional column. The various existing Posts regarding transposing data do not seem to tackle my issue.Any ideas?

I've got some continuous rectangles(polygons), each of them represents an atrribute value from 1 to 5. So after symbolization they just look like a raster. Some of the rectangles have abnormal values such as 1 rectangle has value 1 surrounded by 8 rectangles have value 5. I'd like to change 1 into 5 in order to clean the data. Due to the polygons are rectangles not squares, I can't convert them into raster to perform a Majority Filter operation in ArcGIS. Is there a way to perform same operation on vectors? I'm thinking about creating a list to store surrounded rectangles' value, then use ListHistogrammer to get most frequence value if they appear equal or more than half, then change centre value in it. I've tried to put data through SpatialRelator's requestor and candidate port to create the list, but I can't ignore the centre rectangle which creates 9 listelements.I'm struck here, if you have any suggestions or a better/more efficient method, pleas

Hello: I have an oracle query that I need to generate as a json file. The query contains all of the feature necessary for the output however, there can be multiple addresses for a given project name. For projects that have multiple addresses, I need to repeat the following attributes: street, cagisID, addressID I had this structure in a JSONTemplater but when a project contains multiple rows (with the differing address), it generates all of the elements below multiple times. I tried to configure the "SUB" feature of the transformer but I must need to only send a project query to the ROOT and all of the possible address variations for a project to the SUB. But then I could figure out how to link the two for this to work. {  "totalInvestment": fme:get-attribute("totalInvestment"),  "squareFootageRetail": fme:get-attribute("squareFootageRetail"),  "squareFootageOffice": fme:get-attribute("squareFootageOffice"

Hi everyone,I looked up at some forum posts, I saw people excluding the content within squarebrackets with square brackets itself or deleting some funny characters, but I couldn't really find something which suit my situation or I just didn't understand the forum posts quite well.The case is, I have got a column with strings such as "[]" or "[Park5, Park4]" and ideally I would like to remove the square brackets. I tried it with the stringreplacer with the regualr expression, however that didn't work, it has to be said that I am not that familiar with regular expression, so the way how I formulated it, might be wrong. In my case, I want to keep the content within the square brackets, while only deleting the square brackets itself. Thank very much in advance!

Hi FMErs,I have a question related to the use of the ListElementFilter transformer by @takashi that is a continuation of this question. I'm open to any recommendations for alternate transformers that may be able to match the conditions, but I cannot find any to date.Attributes for line length, line name, line date have been successfully extracted from an initial text string.Attributes for line geometry such as total length, start x,y, end x,y and azimuth have been successfully extracted from the autocad polyline.Now trying to match the text to the correct polyline using a combination of1) Proximity (neighbour finder within 5m, line as base, text as candidate generating list of potential matches shown Figure 1), and2) Length (by matching geometry length to text sourced length)Referring to Figure 1 - A previous attempt using the first match only, and testing line length with a 1m tolerance yields about 50% success.In attempt 2, using a list of all potential matches within 5m, I get

Hello, I would like to read all attributes for some specific fields and then compute some satistics.  I know that it is possible with multiple statistics calculators and feature mergers.How can I do this inside a python caller?Thanks

I have a non-spatial data, want to compare every 2 rows: if they has A, B columns same then compare Column C Start, Column D End has the overlap, if it overlap with another row, write that row id to this row column. See attached image, any suggestion for the task? Thank you very much.

I have got the following structure: Three Attributes and a feature with three different values Attr1 Attr2 Attr3X Y Z The result should be:Attr1 NewAttrX YX Z  In my initial table (Excel) I have more features of course, but this is the way I have to deal with each feature. Any ideas?

I want to move all different sorts of geometry (points,lines,areas, 3D, surface, faces +++) to a local origo. I can find the correct x,y,z and I can use the 3DAffiner to move most of the data to the correct spot. However it seems that the complex 3D-geometries that has a Transformation Matrix does not get updated (https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!FME_Geometry/Transformation_Matrix.htm) .Is there any easy way to also 3DAffine these Matrixes or do I need to "unwrap" all these geometries and then re-wrap them again. Using deaggregating on all the complex geometires, and then aggregating them again afterwards?