Transformers

I'm sure this is likely to be a bug, I've spent a long time trying to figure out why this doesn't work. I have a workspace that reads CAD blocks (doors) from a .dwg file into FME, exploding these on input (as I want to use the original shape in GIS). It then aggregates these shapes (lines/arcs), and merges the insert point coordinates/attributes of the exploded block to the attributes of the aggregated shape. I then use the VertexCreator with these coordinates stored on the aggregated shape to turn it back to a point. This workflow is needed so I can hopefully have a smooth transfer of data from CAD to GIS and back again. The problem is when these blocks are recreated using the CAD writer, they do not represent the original blocks that are read in, even though all the attributes are identical. It is inconsistent with how the blocks use the x/y scale; if a negative x/y scale is used the block will be created as if this is positive so the block is mirrored. If you then reset all the x/y

I will be receiving a spreadsheet with a list of streetlights that have been removed from the field. I need to select these lights in my streetlight feature class and delete them. I can read the spreadsheet and the feature class but how do in select or filter the streetlights and delete them?

Hello I am using the left-right transformer in order to see the location of the point compared to the road, but it's not giving the expected value, all output is in right but visually are not I reproject both inputs to the same CS but still the same result Any idea?

Hello FME gurus I want to reproject some GDA data to MGA and then reproject back to GDA and extract some coordinates but am getting weird values for the GDA coordinates. I’m confident the problem is with the CoordinateExtractor tool when used in combination with the Reprojector tool. To test it, I have set up this workbench where I started with a SHP file in GDA94 projection then: Exported the coordinates Reprojected to GDA94 MGA56 Exported the coordinates Reprojected to GDA94 Exported the coordinates Reprojected to GDA94 MGA56 Exported the coordinates Workbench looks like this: Below is the results. Yellow is the exported data in GDA94 and blue is the exported data in GDA94 MGA56. The blues match, but the yellows don’t, although they should. Any ideas why the coordinate extractor is giving me the wrong coordinates? Thanks Kym

I have an old unconventional excel worksheets which need to be restructured. See below: The first column are field names and every subsequent column is a route number. Ideally, I'd like to transform it to the following: Any recommendations on how to pivot every n rows per column??

I am transforming a dataset using the RubberSheeter, but it is having no effect on the Observed data. The control dataset is 11,600 polylines, in a shapefile, and are an average of 1,150,000 feet long. I have successfully used this transformer before, but the control geometries have been much shorter in length. Distance Exponent: 2.0 Max Distance: 0 Max Number of Influencing Vectors: 0 No constraints. The Control and Observed are the same coordinate systems. The features exiting from the Corrected port are exactly the same as the original source and I cannot figure out what the issue is. Any help appreciated.

What I am doing: I am creating a QC process on our dataset. On a regular basis (daily or weekly) the job will run and I want to email the last person who edited that record to tell them the error that was introduced so that they can go back and rectify the error. SCENARIO 1: I am using the HTMLReportGenerator to create a report that can get emailed. It is a simple report. The HTMLReportGenerator settings are: - Page Contents - one Table - Table Content Settings - Two ColumnsThis output goes into a EMAILER and sends me a test email. Everything I need is in the email but the columns are a bad width causing the information to get squished. My Question: How do I control the width of the two columns? SCENARIO 2: I turned the Page Contents into a Custom HTML. The problem here is I don't know how to write HTML. So, I found the HTML output from Scenario 1 and added in two lines of HTML that adjust the columns width, but I don't know how to get FME to read in more than just the first record of

Hi everyone, I have a matrix stored in a spreadsheet and I would like to copy the corresponding value into a vector file by comparing two fields to the matrix. To give more detail. I am unioning two habitat maps together, one from 2011 and one from 2017. I have a spreadsheet with habitat classes on row 1 and column A. The matrix then assigns each pair a change value e.g. no change, some change, extreme change etc. Is it possible compare the 2011 field with row 1 of the spreadsheet and the 2017 field with column A and populate a new field with the result? Many thanks, Matthew

Hello. I am very new to python and need some help. I am trying to snap a polygon file to Polyline. I have two Feature class which I want to use in Python caller. And there in the transformer, I want to copy a python script which is exported from the model builder in ArcGIS. Can I use one transformer Python caller for both feature class? And also can I copy the script as it is in the python script window of Python caller.

Can anyone help me with a fairly simple workflow with transformers I need to use? Below is a simple graphic example. I have several overlapping polygon layers and would like to extract a non-overlapping polygon layer that uses an attribute value as the hierarchy (priority) for determining how to clip the output polygon. Polygon Input: Desired output: Additionally, I'd like for the output to have the polygon source name along with output. So in the above example, the attribute table would look like:ColorValueBlue4.0Green3.0Yellow1.5Red2.5Not too worried about this addition because I figure a generate list will accomplish that part. Any help for the above would be greatly appreciated!! Thanks

Hi, I have one postgres table with DWG features recorded, the features are from many files, the files name is in filename column. Look that the kind column, there are 3 different kind...I, II and III. In others words one specifical filename can be of the 3 kinds in the same time. Because the same DWG file was recorded in Postgres considering the 3 differents models of the drawing. Note: all features belonging to same file have the same file_date. In short I need to extract all features group by filename but considering the most recent file_date Maybe I was clear? Thank´s

Hi, After the last windows update (windows 10 pro 1803) data inspector will not launch from workbench. This normally occur when data inspector is running in the background. But not this time. Its also possible to open data inspector from start menu. Anyone else having the same experience?

Hi guys. I have set of polylines and i have to create a midpoint on midsegment of polyline. If the polyline has even number of segments it has to go on mid point of one of a two mid segments. Need help, because i cant find solution on my own!

Hi Guys, in which attributes are this information stored (Radius) ? where my cursor is placed ThxFranco

In my LAS reader I have selected fme_basename to be outputted as an attribute with the feature. In the data inspector I can see it has correctly populated this attributed with the filename of my LAS. The dropdown under DEMRaster in the ReasterDemGenerator shows that fme_basename is an attribute. However when I look in the data inspector it doesn't contain my LAS filename but instead 'RasterDEMGenerator' Is this correct? I was going to read multiple LAS files and output a DEM for each file, using the fme_basename as the filename for the DEM. Seeing it's not being carried through though I've had to create a user parameter and process one file at a time now. Thanks in advance.

Hi All, I am a relatively new FME user. For my job I need to take around 500 MrSID tiles and mosaic and convert them to ECW format. I am able to perform that by "reading" in the MrSID tiles using the "RasterMosaikcer" transformer and then "writing" it as an ECW. However my output mosaic has black edges. Is there a way to make these edges transparent?

What is the simplest path to translate a MDB to SHP. Data is topographic contours for use in AutoCad.

Bonjour a tous je cherche a comprendre comment utiliser les fonctions python dans python caller je joins un petit code test qui ne fonctionne pas avec python caller alors que c'est bon avec mon interpreteur en ligne de commande import fme import fmeobjects import numpy as np # Template Function interface: # When using this function, make sure its name is set as the value of # the 'Class or Function to Process Features' transformer parameter def processFeature(feature): pass # Template Class Interface: # When using this class, make sure its name is set as the value of # the 'Class or Function to Process Features' transformer parameter class FeatureProcessor(object): def __init__(self): pass def fonction_sinus(x): y=np.sin(x) return y def input(self,feature): new_feature = feature.clone() x_new = [0,1,2,3,4,5,6] y_new = [0,1,0,-1,0,1,0] x_interpol = np.linspace(float(x_new[0]), float(max(x_new)), 200) y_interpol = fonction_sinus(x_interpol) for i in range(len(x_interpol)): chart_value_a

The goal of this workspace is to go through multiple shapefiles and update a field for each polygon in a shapefile. The field will be compiled of the sum of an attribute from another shapefile that intersects with a single polygon in the shapefile. Ex. I have a 15 minute drive time polygon from a single point (a single polygon in a shapefile of many polygons). I want to see how many block groups intersect/are within the drive time. I then want to sum or average a field within the block groups and then add this new number as a field to the drive time shapefile. Then it will move onto the next polygon, maybe a 30 minute drive time, and do the same. I have been attempting to use the Spatial Filter but I am unsure if this creates intersections for each polygon or if it is assessing if the candidate needs to intersect with all polygons read from the shapefile. I am open to using arcpy as well to help solve this problem. Overall I think I am asking if looping through each polygon in a shapef

The issue I'm having is I have several CAD "Markers" in my dataset im converting to GIS. These markers are all different and include Sand Marker, Orchard Marker, Rice Paddy Marker, etc. I need to extract a point from the center of these markers/ somewhere near the center of these markers. Is there a transformer/ easy process that does this or will it need to be on a case by case bases. Some markers have touching lines, some do not, some are a bunch of circles. Below are some examples of what these look like. Rice Paddy Marker Field Marker Sand Marker Marsh Marker For the first two I know I can extract the line with the longest length and place a center point. But for the others the "length" parameter wont work. Also, there are no attributes that can be used for extraction of a point across all of the data sheets. Each sheet has different attributes for the lines I would like to use. So an attribute would work on a sheet level basis but that attribute changes as the sheet changes.

The S-57 (ENC) Hydrographic Data Reader claims to support S-57 edition 3.1. However, the reader does not include the supplements to the ENC 3.1 edition. For example, IHO released supplement 3 (https://www.iho.int/iho_pubs/standard/S-57Ed3.1/S-57_e3.1_Supp3_Jun14_EN.pdf) which includes attributes that are not present in the FME reader. Am I missing something or does the FME reader only support the initial release of the ENC edition and not the supplements?

Backgroud: I created a workspace that uses ArcMap's "strip map" tool for data driven pages--the tool creates fixed-sized polygons along a line feature to be used as an index layer to produce multiple output pages [PDF]. I found the tool to be extremely helpful for creating the polygon, but had its flaws when attributing fields. METHOD UsE BEFORE FME PROCESSING: 1) in arcmap, select by attribute for targeted section on line feature. 1.2) run strip map index feature and save output to GDB. 2) both line feature and strip map output are moved to FME workspace to further attribute, but also to push pythonscript, .mxd documents, and output folder to share drive. QUESTION: Is there a transformer(s) that could sort features by its physical location and relative location to other features? Each polygon can be thought as a window to print individual pdf documents. Each feature has four attribute fields for PDF's match-line (top,bottom,left,right) used to inform client which sheet 'goes where'. I

I have an attribute that contains the following string format: [url='thisurl', version='1', timestamp='2019-01-15T08:27:30.382Z', status=[operation='operational', mode='local', state='out', generalError='no', generalWarning='yes', errorList=[], warningList=[warning='inactive', state='unknown']]] I want to convert this string to attributes => values: url => thisurlversion => 1timestamp =>2019-01-15T08:27:30.382Zstatus => [operation='operational', mode='local', state='out', generalError='no', generalWarning='yes', errorList=[], warningList=[warning='inactive', state='unknown']] Can I do this with some kind of regex Transformer and what should it look like?

Hello, I am trying to use the change detection transformer to detect any changes that may have occurred from a previous iteration. The original source is being pulled from a SQL spatial DB, and the revised is a GDB file that I converted to geojson files. I've noticed the vertices are slightly different. I have NOT touched the files, I've just imported the geojson files to the SQL DB and then took the same geojson files and tested it against those coming from the SQL DB. Any suggestions?

I'm working on converting a 12dxml file to a GIS format with an attribute table like an Esri FGDB feature class. Eventually the workflow will be used to write new data to an editable hosted feature service via a FME Server tool. Using the xml reader and feature paths I'm able at access and process the xml elements I require and create the output I need. Rearranging the key:value nature of the xml data is a little fiddly, but I've achieved that using Aggregators, AttributeCreators, AttributeSplitting and lastly an AttributeExposer. Using the AttributeExposer means that I've had to hardcode in the attribute names into the workflow and I'm wondering what the options are for managing these if additional attributes are added to future xml files? Perhaps using a published parameter or a txt file that stores a list of attribute names that can be dynamically read into the AttributeExposer? Exposing the attributes may not even be necessary if I make use of the dynamic options when writing the d