Using transformers to modify data.
Recently active
I have several hundred TIFFs that I want to load in to a File Geodatabase (FGDB) raster mosaic. ArcGIS allows you to load one image, then mosaic additional images into the same raster. I'm trying to do this with FME.So far, I have tried the following:1) RasterMosaicker, but that seems to create the mosaic in memory or temp before writing one huge raster to the FGDB.2) Read several TIFFs (e.g. select 2 TIFFs or specify *.tif in the Reader) and send to the same FGDB raster dataset (i.e. no fanout on the Writer) with Drop Table set to "No" for obvious reasons. This loads the first image then fails on the second with "ERROR |Failed to write raster data tile when writing to raster dataset 'TIFF2'. The error number from ArcObjects is: '-2147467259'".3) Using the Path Reader to get the TIFF names, then sending these 1 at a time to a second Workspace using the WorkspaceRunner (Wait for Job to Complete = Yes). The second Workspace loads the TIFF into
FME People, I'm trying to limit the number of source values I use in the AttributeValueMapper by using the following statement as my Source Value: @Value(LAYERTYPE) Ends With _Wd, In other words I have many different attribute values ending with "_Wd" and I want to reassign all of the those to one new value. The destination attribute ends up being an empty value. I moving data from SDE (oracle) to a file geodatabase.Gary
Can we write Xattributes to dgn elements in Bentley V8i Select Series 3 ?
Hi there,I have a table (lets call it TableA) which contains a field (lets call it Types). I need to compare each value in the Types field with ALL of the values in another field (lets call it OriginalTypes) which is in another table (lets call it TableB). If there is a match a value gets updated, if not nothing happens. Currently I have these 2 tables feeding AttributeManager which has a Condition Statement checking if Types In OriginalTypes but this is not producing my expected results. Any thoughts on what I am doing wrong here or what might be a better approach?Regards
I want to extract XFM data from the attached dgn file. I have tried using the Bentley Map V8XFM reader in both FME 2017 & 2018, but am unable to do so. I have exposed the igds_xfm* attributes as well. Is there a way out ?
I have a SystemCaller that simply deletes a file. I would assume if the deletion is successful, it would give code 0, otherwise 1. However, it always gives 0 whether the deletion is successful or not (for example, I keep the file open before hand to cause the deletion to fail). Any workaround? I could use PythonCaller to do the deletion and generate an exit code, but would be nice just do this simple operation in the SystemCaller.
Just want to convert from string containing fractional numbers (e.g., 4 1/2 2 7/8...to decimal doubles 4.52.875...Anyway to not use multiple transformers for this? ( I know I can separate the fraction from the whole number, then value map the fractional segment to decimal segments, and then patch the number back together via concatenation...). However, I thought I'd check to see if I'm missing something less bulky.Many thanks, Pete
I have a raster dataset stored in a file geodatabase and when I read this into a workbench the nodata bit masks for each band are merged into a single additional alpha band named geodb_nodata as default and stated in the help documentation.When I view the grid in the inspector Band 0 contains data values and a value of 0 or -3.40282e+38 for nodata cells. Band 1 (ALPHA8): geodb_nodata contains a value of 0 for nodata and 255 for cells containing data. My question is how can I set the values in Band 0 as nodata using Band 1 (ALPHA8)? I assume it's a combination of using the RasterSelector with the RasterBandNodataSetter transformers, but no combination has worked for me so far.Specifically, I want to set the values in Band 0 to nodata using Band 1 and then sending the output to a RasterCellCoercer transformer to create points for all raster cells containing a value i.e. excluding nodata cells.Thanks
Hi there,I'm exporting rvz files to a esri file geodatabase. When I want to open the multipatches in ArcGIS pro I have to adjust the elevation to make the features visible. In Revit it is possible to built storey /levels and give them a height or elevation value. How can I transfer Z-values to arcGIS and use them as an attribute field for the elevation source? Thank you. I hope my question makes sense.
I am using FME to convert ESRI Raster Dataset orthophotos to an .ecw file and there are some very ugly black pixels added to the border.
Im simply trying to get fme to use FileCopy (so that I can copy csv files inside a large zip file (about 4 gigs)) to a network folder. I only used a reader with format set to CSV, dataset set to the path of the zip file, and workflow options set to Individual (connected to filecopy writer). Are there any issues with fme and large zip files? Is there a better method to extracting a specific file type from the zip than what I used? Thanks for any help--latest error states: "failed to open file. failed to get any schema from reader". i am able to manually use filezila or 7 zip and perform this
Hi All, I'm working with 3D solids (buildings) and sometimes they are made up of surfaces from which the orientation (order of the vertices) is not the way I would expect them to be. This causes that for some of the surface I'm looking at the 'inner' side in stead of the 'outern' side when visualising them. Is there a good approach to 1) detect these "wrongly oriented" surfaces 2) correct these "wrongly oriented" surfaces ? (The SurfaceReverser can turn all orders of all the vertices for solids, (making inside outside and vice versa) but that is not what I'm looking for) Thanks
Hello all,I have two questions. 1- Is it possible to replace regex with a regex? For example, I want to add a dot after every numeric value before any letter. StringBeforeAfter 1 7 St7. Street21 Av1. Avenue@ReplaceRegEx(@Value(POI_NEW_NAME),^\d\s\w,^\d\.s\w,))Search: ^\d\s\wReplace: ^\d\.\s\w2- I have different variations which I need to manipulate. Is there any possibility to use different expressions in a text editor of an AttributeManager? I tried to use "|" symbol for this purpose but it didn't work.@ReplaceRegEx(@Value(POI_NEW_NAME),^\d\s\w,^\d\.s\w,))|@ReplaceRegEx(@Value(POI_NEW_NAME),\d$,$\d\.))Sorry, if it's a duplicate question but I couldn't find a similar case.Thank you
I want to aggregate or dissolve a set of input polygons based on 3 fields - Authority, Category, Site_Name. So where these values are the same, there should be one output feature. If the polygons are not adjacent, a muti-part feature should be output (File Geodatabase). If they are adjacent, then I expect them to be merged. However this is not happening. I've tried both Aggregator and Dissolver, individually and together. The boundaries may not be shared, but I believe the polygons overlap, so why aren't they being merged?In the attached image, the blue fill is the input, and the hatching is the aggregated/dissolved polygons.Also, there are 2 blue polygons on top of each other in the middle, but in the output there's no polygon visible.
I would like to ask how can I filter data by using Tester consider condition:ATTRIBUTE_ABC - contains - "max. 1" or ATTRIBUTE_ABC - contains - "max. 2" or "max. 3" etc.how can I generalize Tester by substituting number 1, 2 or 3... to don't build x number of testers.
Hi, In the attached workspace I am having issues with the spatial filter and attribute pivoter transformers.With the spatial filter, I am trying to output from the buildings Mapinfo table reader, the buildings that intersect the filter layer, comprised of buffers for different simulations. In the attributepivoter transformer, I am trying to show a count of flood vol, separated into columns for sim (there should be six simulation columns), for each propref (row).There should be numerous proprefs where there are flood vol values for more than one sim, I am struggling to recreate this. Also struggling to bring through all six sims as columns. Any ideas how to restructure this?Thanks
As per Bentley, XML attributes are stored in Xattributes. Does FME support these attributes ? I am using FME 2018.
Firstly, yes I know that there are already answers regarding measuring points along lines, but trust me I've read them on here, and I'm still not getting an answer. So I'm clearly doing something wrong.Ok, so I have a series of 3d points (recording x,y,z) as a shapefile. These all occur along a single line of section. I also have that line of section as a polyline shapefile. All I need to do is measure each point from the start of the line.It "should" be easy, I'm sure of that. But I've tried all the ideas posted by people like @takashi and I still have no joy.My setup so far is -A reader for each shapefile (one point, one polyline), PointOnLineOverlayer, into a MeasuresGenerator then a MeasuresExtractor. But I get no measurements output. You're help would be much appreciated.Steve T
Does anybody know if it's possible to use a dwg template with a block and then set parameters in FME so the block is 3D-rotated in the resulting dwg-file?
Is it possible to do a substring(0,10) with the BulkAttributeRenamer? I want to simulate truncating the columns as writing to shape does. I know I can do this with a SchemaMapper, this is my current workaround.
Hi, I can't find an explanation in the doc about what this error means so that I can avoid it. I'm using a Clipper with Clipper Type 'clippers first' for performance. I'm grouping by row and column tiler output columns which are unique although I do have multipart polygons.
Hi all,I have a check-in text data file with long/lat information, ,example as below:[user] [check-in time] [latitude] [longitude] [location id] 196514 2010-07-24T13:45:06Z 53.3648119 -2.2723465833 145064How can I convert it into point features? I tried several times but unsuccessfulThe data file looks like this:0 2010-10-19T23:55:27Z 30.2359091167 -97.7951395833 22847 0 2010-10-18T22:17:43Z 30.2691029532 -97.7493953705 420315 0 2010-10-17T23:42:03Z 30.2557309927 -97.7633857727 316637 0 2010-10-17T19:26:05Z 30.2634181234 -97.7575966669 16516 0 2010-10-16T18:50:42Z 30.2742918584 -97.7405226231 5535878 0 2010-10-12T23:58:03Z 30.261599404 -97.7585805953 15372 0 2010-10-12T22:02:11Z 30.2679095833 -97.7493124167 21714 0 2010-10-12T19:44:40Z 30.2691029532 -97.7493953705 420315 0 2010-10-12T15:57:20Z 30.2811204101 -97.7452111244 153505 0 2010-10-12T15:19:03Z 30.2691029532 -97.7493953705 420315 0 2010-10-12T00:21:28Z 40.6438845363 -
Is it automatic classification methods in FME transformer?
I am comparing two feature classes in separate GIS sdes. I made a copy of one and put it in the other sde. So they were exactly the same to start. I changed the SYNGERGEN_ID value in one field in one record to test the update detector using . I expected that the one record would be passed through the update port. However, it is going out of the inserted and deleted port instead. Thank you in advance for your responses.
As a proof of concept, I want to use FME to find lines not connected to, touching or near any other lines. The nearness would be user defined e.g. keep lines within 10 metres of another line. I can't find an existing answer so I'm posting my solutions. I was inspired by @redgeographics answer to:https://knowledge.safe.com/questions/42455/lines-connected.htmlThe first solutions has 2 options for pre-processing. Either buffer the input lines by the amount required to take care of undershoots. This will obviously create polygons. Or use the LineExtender to do a similar job. The difference with the LineExtender is the direction of the extensions at each end (see documentation).Then send the pre-processing result to both the Requestor AND Supplier ports of the SpatialRelator. Choose the Intersects and Touches tests (regardless of whether you're using buffered or extended lines). Select ObjectID (or other primary key) as the attribute that must differ. Results with _rel