Using transformers to modify data.
Recently active
Looking at migrating one of my clunky ArcGIS scripts over to FME but is betraying my lack of experience with Raster Transformers!It's somewhat straightforward I think, I just am looking for what the key Transformers are for the 2 following Steps:Subtract from a DEM Raster's Cell values the values in overlaying PolygonsBuild "Filled" Contours (ie. Polygons that contain Cell elevation values within certain range intervals)Use case is water pressure contour generation. Hydraulically this is the imaginary Hydraulic Grade Line which at most times of the day is almost a flat surface (Hence the 2D polygons with an HGL attribute value) and subtracting the local Elevation from that (from the DEM) derives the local Water Supply Pressure.My ArcGIS process migrating from builds a second Raster out of the Polygons, and uses that in a Raster Subtract ArcGIS Geoprocessing Tool to create a 3rd raster with the Delta Cell values, and then create Filled Contours from that, but I suspect
FME(R) 2020.1.0.0 (20200305 - Build 20510 - WIN64) When using the BulkAttributeRenamer with a variable prefix. The prefix doesn't get added on the attribute but shows in the inspector. Any thoughts?
Ny mappe.zip
Dear community, is there a way how I can set a data type (integer, char, float, ...) in a transformer? Usually I create the data type in the Feature Type Properties menu of the Writer. On some occassion, it would be helpfull if I could set the types manuelly in a transformer, so that the writer recognizes the formats automatically. I do not want to tell every writer which format it has to be. We can of course tell a single writer all the data types and then copy the attributes from one Writer to another. This one should work. But can I set the data type to a specific type in a transformer before I write the data out? Thank you very much for your help. Kind regards, ThomasK
A workspace that stars with a SQL-creator works flawlessly when executed from workbench or server-app. It executes in a matter of seconds. Especially the server-app is highly efficient.We are now testing to have it run via webhook in a stored procedure in the SQL-database.Below is the log with timestamps. Row 91 seems to halt the execution for ~100 seconds. Can I optimize the transformer/call or is it more likely to arise in a conflict between committing and selecting in the SQL database. 902020-5-26 13:31:08 | Microsoft SQL Server Non-Spatial Reader: Trying to connect using Microsoft OLE DB Driver for SQL Server...912020-5-26 13:31:08 | MSSQL_ADO reader: Building features into bulk mode features922020-5-26 13:32:47 | Microsoft SQL Server Non-Spatial Reader: Database read complete. Retrieved 6 feature(s)932020-5-26 13:32:47 | Logger: ------------ LOGGER --------------------
Good Morning,I am rather new to FME (RATHER). I have schemas and data coming for the next months, almost every day, in excel. EVERY TIME SCHEMAS WILL BE DIFFERENT (INCLUDING THE NUMBER OF FIELDS). My goal is to open a CSV file, explode the attributes (I think is the way to call it) and go from there validating each one. I need to test the length, not nulls, ASCII content (0-9, A-Z, a-z).For many I know is a walk in the park. For my is going ascending to the everest.Thanks a lot i advance.
We have noticed that when we do negative buffering on various polygons the results are sometimes missing parts (red: original, yellow: buffer):In the above example we expect a slightly smaller yellow polygon inside the the area marked with black.The workbench (attached, including input data) used to create the above example looks like this (the validator is set to all):We are still using FME 2016 in production due to various reasons and the above is indeed made using FME 2016. In the above example the bufferer rejects the input geometry (INVALID_GEOMETRY_TYPE), though the yellow part is still the result from the rejected port and apparently looks fine except from the missing area.We have tried the same workbench in FME 2018 and though it doesn't reject the geometry the same part is still missing:
I have a SQL stored procedure to get asset details with input of two List Values (Exec get asset details 'L1,L2'.where L1 and L2 contains concatenated values like L1=100,101,... and L2 = 1001,1002...) When I use SQL creator I am getting the correct results as similar to MS SQL Server Management studio.(But I used hard coded List Values ) and outputs asset details along with L1,L2 values but I am not able to pass the List values in the same workspace for SQL creator as list values derived from the another system using Http Caller.However these same List values used in SQL Executor in the same workspace runs outputs asset details along with only L1 values but not with L2 values. Please suggest me.
I would like to extract text between *** CProtOC*** as a separate attribute from text file * E * *** CProtOC *** FCLID [5318] - FCL [Fuse] - FOID [2634] - KEY_ID node NOT FOUND text_line
I am an SVG file from FME 2015.1. I have some minor issues. The <!ATTLIST array causes chome and other programs I have that read SVG to have fits. I have to manually delete that. Any way around this? Also it would be nice to be alble to set the stroke color and width from FME. Any suggestions: See below: <?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11-flat.dtd" [ <!ATTLIST g xmlns:fme CDATA #FIXED "http://www.safe.com/fme" > <!ATTLIST path fme:access CDATA #IMPLIED fme:visible CDATA #IMPLIED fme:type CDATA #IMPLIED fme:nd{}.ref CDATA #IMPLIED fme:tag{}.v CDATA #IMPLIED fme:timestamp CDATA #IMPLIED fme:user CDATA #IMPLIED fme:id CDATA #IMPLIED fme:version CDATA #IMPLIED fme:tag{}.k CDATA #IMPLIED fme:created_by CDATA #IMPLIED fme:lane_boundary_type CDATA #IMPLIED fme:changeset CDATA #IMPLIED fme:area CDATA #IMPLIED fme:layer CDATA #IMPLIED fme:uid CDATA #IMPLIED
I have a transformer that aggregates areas and writes to FGDB polygons. GeometryFilter or GeometryCoercer show that they are areas in FME. The result in FME show as closed polygons. When I view the results in ArcPro (or Catalog) some of the polygons are unfilled? I'm not sure what the issue is or how to fix it?
@takashiHi!I would like to split the value of an attribute with respect to its number of characters. For example in element 1 from screen shot :1727*hH.1729*hH.1731*hH.1733*hH.1735*hH.1737*hH.1739*hH.1741*hH.1743*hH.1745*hH.1747*hH.1749*hH.1751*hH.1753*hH.1755*hH.1757*hH.1759*hH.1761*hH.1763*hH.1765*hH.1767/hH.1769I want to have something like:1727*hH.1729*hH.1731*hH.1733*hH.1735*hH.1737*hH.1739*hH.1741*hH.1743*hH.1745*hH.1747*hH.1749*hH.1751*hH.1753*hH.1755*hH.1757*hH.1759*hH.1761*hH.1763*hH.1765*hH.1767/hH.1769with a limited characters per line = 69 and each new line must start with a * Thanks in advance for your help !
Hi, I think i have a simple question. I have a csv where the xy is in one attribute. See example (geo_xy) but i have to do an poinonarea but because i have no x and y seperate he doesn't do it. FME doesn't recognise the geometry. I have already tried to extract the x and y by using multiple tranformers. Even used stringextractors but the number of numbers of x and y is various so it's not flawless. I am sure there is an easy way to do it but I cannot find it.Can somebody help me? ThxNathalie
Hello,I am using SystemCaller to delete temporary files during translation. Now I store them in a created folder "Temp" that I'd like the SystemCaller to delete with all its contents.The typed text in SystemCaller is:Del $(Output)\\Tempwhere the $(Output) is a public parameter.At the end of the translation it prompts to delete the full directory with*, Are you sure (Y/N)?Is there a way to type the Yes choice in the SystemCaller? Otherwise translation will get stucked here.For single files the Del command works fine in SystemCaller.Thanks.
Hi,I wounder if it's possible to set custom name of sketchup groups in the Outliner, using i.e. GeometryPropertySetter and "Traits from attribute"? Basically the same as setting the sketchup_layer_name as trait. I have mananged to group objects using aggregator.I tried to solve it by the suggested solution on this tread: https://knowledge.safe.com/questions/2300/writing-multipatch-features-to-sketchup-groups.htmlbut couldn't get it to work. Any suggestions are appreciated. Thanks!
I have tried to use the polygon path segmenter to get the number of line segments in a set of polygons. I can see that it is creating a segment attribute when I go into the attribute properties on the inspector however I can't seem to get these attributes to come through into my routine. I have tried exposing them in different ways but to no avail. Is anyone able to help please? I'm sure it must be something simple I am missing!Thanks
In a directory I have some textfiles and their names contain a date (xy... 2017-12-13.txt). Each month there's a new file. I want to read only the newest file, but I don't want to change the name in the reader each month. So my idea is to read them all (or at least one record to get the fme_basename), compare the dates and then read only the newest file.So I tried various approaches (first extracting the date out of the filename, then use Aggregator, Sorter, VariableSetter...) but I don't manage to compare the dates of the features as I can't see a way to set the initial value...Any ideas?
Hello All, I am trying to loop through a feature class with 30+ fields, each field having terrible quality data filled with duplicate white space. I am trying to find a way to loop through the feature class, checking each field and then replacing the duplicate white space with single white space. I can do this manually, one at a time, with 30+ StringSearchers->StringReplacers. However, I am wondering if anyone has found a way to build a custom function to loop through each field and replace values? I would prefer to call a custom transformer and loop through all fields than build 30+ groups of two transformers. Currently in the string replacer I only see the option to do one string at a time.
Hello all,I have a series of point features that I need to convert to line features, but running perpendicular within a layer that contains parallel polyline features.I want to convert the green dots in the first image below, into the green lines in the second image. There is no data relationship between the existing point and polyline features apart from their spatial proximity.Can anybody recommend a sensible way of doing this?Thanks and stay safe (and sane),Robin
Hi I'm trying to convert our DTM tiffs to a more weboptimized format.I'm thinking of jpg, png, ecw, jpeg2000. When I try to convert them to gray8 I loose the numbers behind the comma, because the rasterinterpretationcoercer converts from float to integer.That's just not an option. I also tried this: The numericrasterizer gives an error:NumericRasterizer (VectorToRasterFactory): No values were specified for either both WIDTH and HEIGHT or both X_CELL_SIZE and Y_CELL_SIZE. When any of WIDTH, HEIGHT, X_CELL_SIZE, Y_CELL_SIZE, INTERPRETATION_TYPE, BACKGROUND_COLOR, BACKGROUND_ALPHA, BACKGROUND_VALUE, or GROUND_EXTENTS is specified, values for either both WIDTH and HEIGHT or both X_CELL_SIZE and Y_CELL_SIZE must be provided.Also tried the propertyextractor in serie with the rastercellcoercer and kept the attributes. Then I get all rejected in the numericrasterizer.Also this takes way to long. I have a lot of DTM tiles. Can somebody point me into the right direction?I've fou
Hi, I'd like to know how to correctly write geometry called MultiLineString and MultiPolygon using GML writer with known Application Schema and validate Output File set to Yes. I keep getting FAILED message 'Surface' is not allowed for content model '(MultiPolygon)'and'LineString' is not allowed for content model '(MultiLineString)' PS. Prefer Polygons over Surfaces is also set to Yes.
I am trying to build a workbench based on Dimitri's rooftop building smart recognition workbench.My first step is to use a decent resolution raster file from my GIS software I use. Problem is, it is not georeferenced, but does have a text file with the extension RCT or raster coordinate text. It does not have column names, but I was able to use, with and expert's help, a CSV reader, since it is always space delimited as X left, Y bottom, X right, Y top. But I am getting an error that the @GeoreferenceRaster is failingon the first attribute coordinate, X Upper Left. I have attached a copy of the workbench, PNG file, and RCT coordinate text file. Please note that the raster has an extension of JPG, but is really a PNG.
I have an Address: "198 whitten farm Apt 3". I would like to count the number of blank spaces in the address. if it has more than 3 blank spaces I want to eliminate whatever is there after the 3 blank spaces.
When there are duplicates present in the Update Detection Key Attributes, FME sometimes detects that there are two updated records, when in fact there are no changes. So it will report that 1 change as originalValue = apples, revisedValue = pears and a second change as originvalValue = pears, revisedValue = appleswhere all other fields are identical, i.e. if you put them through a matcher you would get no unmatched recordsIn these scenarios how is the comparison controlled? Does it relate to feature order? In an ideal world, a key value would be unique, but the world is less than ideal.
