Using transformers to modify data.
Recently active
I have the following issue. When trying to assign % symbol to attribute, the output is empty field. How can it be solved?
I have run into the strangest problem using the Intersector. Source A is a dataset of overlaying polylines containing attributes I want transferred to the polylines in source C. B is a polygon I use to reduce the amount of data whilst building the workspace, B is to be deleted in the final version. As long as the data passes the clipper the output is as expected, ie features are cut and attributes are merged. But when I bypass the clipper (and turn it off) the data gets cut but attributes are not merged.What on earth is going on here? I can't make sense of this.
Hello,Is there a way to create sampling hexagon using fme (and python caller) that would cover a study area?Basically, the idea is to create a mesh of sample hexagons and ensure that that all regions within the study area are represented by the sampling results as you can see in this post?Thanks
I know this has been asked many times, but i cannot get it to work. My data is: ObjectCategoryNumApple8091Apple 81122Apple8100Banana80913Banana81014Banana81155 And i want to turn it into Object809810811Apple1022Banana131455 I've tried to do the method i've read on the forums using attributecreator, however, its not creating multiple columns based on the column names. ie, in AttributeCreator:NewAttribute: @Value(Category)AttributeValue: @Value(Num)doesnt do anything. I am using FME 2019.
Hi,Have a file with lines of 10 meters each, each with its own rotation.Want to move every line.The midpoint must be moved to the end point.The length, rotation and Z must not changeHow do you do that?
The USGS have deprecated their earthquake feed in GeoRSS and replaced it with a GeoJSON. No problem I thought, in fact better - but wait. The timestamp of the earthquake is now provided as a long integer in milliseconds from the Epoch. Milliseconds? I can see the intent, but the usual standard is whole seconds, and only whole seconds are supported in the DateFormatter. The trouble is that I cannot divide the time by 1000 for the DateFormatter because it is a 64 bit long and it seems that 32bit FME cannot handle it. I have tried to treat it as a string, but that does not work either. Maybe a PythonCaller, but can I pass it across? Here is the feed URI http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/2.5_month.geojson
Hi everyone,I have a very basic (I guess) issue that I can't deal with nor find an appropriate tutorial or answer on the web... I have a 1 band Geotiff that comes from a substraction between two Digital Elevation Models (bathymetric survey). I manage to give a value to nodata (RasterBandNodataSetter) and remove the nodata identifier (RasterBandNodataRemover). So the Geotiff I'm working with as no nodata.I want to associate color (chosen or by default) to different ranges of value, just for visualization of the result. I can do it with any GIS software (like ArcGIS) but couldn't manage to do it with FME. I tried to connect a RasterPaletteGenerator to the Geotiff Reader but I get a translation terminated with the rejection code 'INVALID_RASTER_BAND'. As I have no idea of the problem and where to start to manipulate palette and raster band, any help or links to tutorial or web pages would be greatly appreciated.Please find attached the Geotiff I'm talking about.Tha
I have a set of polygons with OwnerID and a set of polygons without OwnerID. On another layer, I have connection lines. I am trying to give OwnerID attribute to linked polygons using the endpoint of lines to link them together.LineOnAreaOverlayer is good for 90% of the cases but some polygons are traversed by the lines and sould not be considered.here is sample, green polygons has an OwnerID, white polygons don'tUsually, I have only two (2) polygons to link together, but sometimes there is multiple polygons to chain link together. Any Idea ?Thank you
Hi!I have some 3D faces that have been saved out to a FFS. Now I'm trying to use a Search envelope on a FFS reader to load the model above, I want to clip the model according to the bound. It works but many(all) of the clipped faces have faulty values at Z=0. I would expect to get a nice clean cut on the 3D-faces, with correct z-height at all their indices. See this image: I have attached the soure files for debugging. Is this a known bug? Any workaround available?
I load files into a PostGIS DB. When I get new files that update certain areas, I'd like to do change detection. I've tried a bunch of different ways to try to compare the file to the data already in the DB. Is there a trick to this? Seems everything I try give either all new or updated. I know that there is mostly the same polies with very few updates. Is there a trick if the datasources are DB against file? Any help greatly appreciated.
I am using AttributeExposer (AE) and need to import the values from a table. I do not know how many values there are before I run the workspace, so I need to be able to import the values from a table created by the workspace.I thought I had it all worked out and then realized that the "Import..." option might not be "live." i.e., it worked the one time and has been holding onto the values I entered, rather than repopulating with a newly created table each time.Is this true? Is this "one and done" and you need to manually reload these values if the table you loaded them from changes?I need to do this after I use AttributeCreator, because the attributes that are created are invisible. If there was way to create attributes and have them be visible, that would be wonderful.Thank you,Randy McGregor
I want to summarized the polygons (see picture) to bigger polygons.The polygons should be summarized by their number in the middle to around 1000 (+- 100).At the End there are a lot of polygons with a number around 1000.
I have tried a couple of methodologies using a point cloud (LAS) to generate a TIN however the quality of the TIN is not good when it comes to trees and the TIN gives steep surfaces below the tree canopy (because the underneath of the tree is not observable). Altering the tolerance can flatten out other trees too much where there is an ability to view through to the canopy floor. It would be more ideal to use already generated meshes and be able to apply the raster image from the geotiff over (Drape) the mesh file. Draping is more realistic and preferable to the textured mesh that comes with the product produced by these programs.Mesh files are .PLY, .FBX, .DXF, .OBJ, or 3D .PDFI've looked atDraping polygonal features on a TIN?But had problems getting the right parameter into the GeometryPartExtractor.This was a Geometry XQuery : Geometry IFME polygon.andDraping imagery textures on terrain surfacesand the texture mapping demo Any advice to improve the TIN or utilise the existing
As shown, I want to get the position of the sink what like the label 1 instead of label 2 ! because the 1 not true , water could flow out like 2. who can provide some suggestion calculate the position like1 label ?
Hello,what am I doing wrong? Let's say that I have some attributes whose values I want to compare with tester. Each attribute value comes into tester separately. No matter what I do, I always get "failed" result from tester (even when the values are the same). I used 3 Inspectors and I see that both values which are coming into tester are number (number 5 in this examle) but I can't figure out what's going on inside tester.I'm attaching small example file.Please help.Mario
Hi all,If have an issue creating a unique column for a range of points. The points are separated (based on calculations) in ranges that run from 3 to 2, all the point within this range have 1 values (for example 3,1,1,1,2). I would like to generate a new column containing for each range an unique id. See my example columns down below, showing the preferred result:UUIDRangesPreferred ResultA31A 11A 21A - A 32A 12A 22B33B 13B 13B 23C34C14 Is there a way to calculate this final column?
I am looking for the equivalent of ArcGIS ModelBuilder's "precondition." I am using the AttributeExposer transformer and I need to enter a table that contains all the values I want to use for the attribute names.The names come from a field in the input table, and I don't know how many there will be beforehand, so I need to generate a table which is then read by the AttributeExposer.Is there any way to ensure the AttributeExposer does not try to run before this table has been created?Since the table is created with a writer, there is no output for me to plug into the AttributeExposer - It is a "dead end" on a different branch.Thank you,Randy McGregor
Is there any SQL transformer that doesn't need any initiator but only needs a trigger/input to connect to previous step? I don't need SQL Executor which requires an initiator that involves in the query. I can't use SQL Creator because it doesn't have an input handle that can connect to previous step sequentially. any advice?
I've been trying to figure out how to include an external application in my FME Desktop transform. Recently I discovered that my target application exists in the PYPI repository and I believe that these projects can be run in FME.From what I have read, it looks like I can implement this application in FME using Python Creator/PythonModuleInstaller/ PythonCaller.How do I setup and use a transform based on a PYPI project? My experience with FME is limited.https://pypi.org/project/sutime/ Thanks,Gilbert
I have a SQLite database (version 3, created in FME) that I want to use a Select statement with a regular expression in the SQLCreator transformer. According to the SQLite documentation the regexp() user function is a special one that need to be defined. Does anyone know a easy way to do this in FME? (it have to work in both PC and Mac environment)
Hi all,So, I've got this small data set of 12 locations in the Netherlands. I would like to create a distance matrix that tells me what the distance (as the crow flies) is between each point. I figured that I could use FME for this. I think I managed to get quite far, but now I'm stuck and in need of some assistance :-(.So what did I do so far? I first created a workspace that reads the data set and then uses the FromToBuilder transformer in combination with an AttributeManager transformer to determine distance from one manually selected point to all other points. A csv-writer writes the resulting table to a csv-file. Secondly, I added a new published parameter in combination with the Workspace Runner transformer to run through the 12 points. So that I don't have to run the workspace 12 times and manually assign a point to the to-port of the from-to transformer. This generates a csv-file of 12x12=144 features. I'm no stuck figuring out how to convert the 1x144 tab
I want to put the line connection the Center point of rectangle?I dont know how to do?
Hello I am trying to create a control for foreign key integrity constraint between 2 tables.it is a simple case of referenced table and referencing table. I want to check if the reference value is exiting or not.What is the simpliest way to realize that opération ?thanks
green is rectangle?I want to get the all red line ,Which converter to use?
I am trying to merge two lot of attributes but when using FeatureMerger, it is only picking up the requestor attributes and the Supplier attribute of 'issue' keeps repeating '36'.ThanksBill