Transformers

Hello,  I want to use Point on area overlay transformer but it does not work and I don't know why. As You can see here some points are overlaying the buffer I created but output is collapsing.

(I asked this question in here, https://knowledge.safe.com/questions/1935/distance-between-points.html?childToView=64766#answer-64766but I figured I probably needed to make a separate new post, since it involves a different set of issues.)I need to calculate the distance from each point feature in a point dataset to each polygon feature in another dataset. I've used the neighbourfinder with the maximum distance set in such a way that it will include all the features involved. I also set the number of neighbours to the amount of polygon features I have.I set the list name.After that I used a list exploder to get a list of all the distances from each point to each polygon. That seems to do the job. However, how do I now transpose the list?I get a table with the amount of records equal to the number of point features multiplied by the numer of polygon features. I want a table with the same amount of records as the point featurues, and added to it the distance to each polygon feature

Hey!I have a problem with my PostGIS database. Trying to get it much more efficient. It contains information from several counties, which means I read a lot of unnecessary information that I do not need and the computer is giving up. Something similar "Fastkart.ak = '2085' and all information within 2085 from Fastkart.by" is what I need to do. But can’t figure out how. I’ve tried many hours to write clause under feature type and also by using sqlexecutor. Figure 1 shows all tables in the database. Often when I am going to read information from my municipality, it must read all the municipalities' buildings eg which makes it very big amounts. Of course, you can drive a clipper directly after the base but would be better if I could get the data base to read no information other than it by 2085. Anyone know if it’s possible to write "Where clause" directly in the database when you do not have matching information I attribute table?(That would be the best op

Hi, I am running a workbench which uses system caller to run a bat file ad that bat file in turn runs a exe file. When I run the workbench from any location other than the same folder as the bat and exe files it fails to execute. What I want to know is how can I pass through a published parameter value to the command prompt temp variable %%1 so I can set a folder for it to be run from?Thanks,Clare

I am trying to use SpatialFilter to get polygons that overlap but it also includes polygons that touch the edges since I am using the "Filter Intersects Candidate" option. Has anyone found a workaround for this issue since there isn't an option to only test for overlaps?Thanks

Hello,  I have a source file with Points of intrests and thier x/y coordinations. I would like to compare them with the database extract with also having this information. The problem is that they might not be on the same exact spot and also the names can vary a little. I was having an idea of using neighbour finder and then check the naming by using fuzzy string comparer but I struggle with doing it properly. Maybe there is better way?  Thanks,

I have a dataset consisting of polygons. The polygons represents roads. Along these roads I need to find certain points and the distances between them.  I've fed the dataset through a chopper and coordinate extractor with a point replacer to get the vertices.  Now i need to measure every single distance between all points in the dataset to find the maximum ditance between any two points in the dataset. I've tried every possible combination of transformers, but no luck.  No one else seems to have the same problem either, because after about four hours of googling and testing, I've been able to measure a whole lot of things, but not what I really want to measure.  Using the length calculator has proven to be the best shot so far, but the problem I'm facing is that the length calculator takes the vertex with the highest node number and measures the distance from that point to every other point.  Basically I would like to do the same for every point in the dataset. Any sugg

Hello FME community !I've a treatment with MDB destination and I would like to ZIP this MDB at the end of the WorkBench but with a size specification.For the moment, I used this article and the result is a unique ZIP file so fat.What I want is (like 7-zip) to divide this file in different volumes with a userdefined size.In the better world, I would like before this operation to send an e-mail with this ZIP file.Can you help me ?Thank you.

Hi everybody.I try to recept the result of a cmd code used in a SystemCaller transformer :In fact my SystemCaller works with my result (in this case : 3)But in facts, the result is not saved :What can I do for resolve this ?Thank you for your help.

Hycan you explain how can use fuzzy to detect names present in list A but missing in list Band viceversa ?  thx Francesco

I am using an existing polygon buffered dataset along with another line dataset to produce a new line dataset, where the source lines either contain or intersect the source polygon. The problem I am facing is that there are considerate gaps between the lines of the new dataset as the sources are either not fully contained in the polygon or don't intersect at a specific point.Using GIS software I can trace to join the lines, how can I automate this in FME?

I'm slowly getting this PDF to work and have made some progress, now getting stuck in another spot. Right now the process is I clip a raster and a points shapefile by the same polygon > rotate both > and export out to a PDF. I've figured out how to rotate and align the points all neatly, but I want the raster image to fill the extent I want. Examples:The extent I want (made from ArcMap) on top and the extent that FME outputs:

I want to group polylines together depending on x, y and z. Neighborhood Aggregator only seems to take into account XY. The 2D perspective snip shows the lines in 2D. Neighborhood groups polylines together regardless in they are far apart in 3D (as the second snip shows).

I need to extract a variable amount of characters from a string and would like some help.I have an attribute in the following format:id-Structure-1.1.13.1.6.1I need to extract the first 4 numbers (1.1.13.1)Where it's get tricky, is that each number can have a value that may varies between 1 and 6000so it's possible to see "id-Structure-1.5474.768.322.22.12" where I'd like to extract (1.5474.768.322)Any help would be much appreciatethanks

Tried all the "solutions" in the provided link, and changing my port. It was working 1 days prior to the errors

I simply want to create a subset of my pointcloud containing points between 2 heights. What syntax enables me to write the expression in one line?

Here is the basic outline of what I'm trying to figure out1. clip raster to polygon (a rectangle shape)2. clip points to same polygon shape 3. rotate both (points and raster) the same degree, i.e 30.54. output is PDFWhere I'm getting stuck is everything is working fine until I try to rotate the raster- the imagery rotates correctly but it rotated in the wrong location?: I have examples to help explain-When I add the boundary of the clipped imagery is shows that the rotated points and rotated imagery are not lined up:This is what it looks like before I rotate the data: everything is nicely lined up:Any help in rotating this raster will be great!

Hi everyone, I have two data setsOne contains many catchment areas and their sizes (calculated)The second has the total area of all catchments (Calculated)I need to join these two so that I can then use an ExpressionEvaluator on them to determine percentages. How do I do this if they do not have a common attribute to join on? I tried a FeatureMerger assigning them both a value of 1 as I thought I read somewhere that that would work... but can not find that article again :-(Thanks!Iris

Hi all,I have the next question : is it possible to make a LineOnAreaOverlay and calculate new measures (based on the origin measures) of the output lines that intersect the polygons? The origin lines are roadsections and have a start and end measure (hectopoints).See also the attached png:

Hi,I am trying to find the position of the interruption in a polyline. I have already filtered the broken line, now I need the coordinates of the interruption point.

Hi all,I have a question about performing calculations on individual grid points.I have a regular, 6*6 grid, which contains information about depth values (height above ground surface). I also have a constant ground surface elevation. I called these attributes [z.point] and [z.ground].What I want to do, is to calculate the depth difference between the ground surface and those grid points, so basically I want to calculate [z.point]-[z.ground]. [z-ground] is a constant attribute, but z.point is a variable attribute that I already defined correctly per point via a spatial join. Later on, I would like to use more formula's and add more attributes with formula output to the individual grid points, but I think that could be done once I know how to solve this problem.Any suggestions would be great!Thanks in advance,Martin-------------------------------------------------------------------------------------------------------------------------------------------Further model information, if n

Hi, when I apply the sliver remover after an areaonarea-overlay I noticed that arcs get dissolved. I would like to remove slivers but keep arcs as arcs. Repair method is set to "longest boundary". It seems even arcs get dissolved (turned into line segments) for areas/arcs where there is no sliver.FME 2017.1 Is that behaviour as designed? Did not find anything about in documentation. Thank you, Rob

I created a workbench translating data from Smallworld to json. It was just a plain Smallworld reader and then a connector that connects to write to a json writer. After the translation is done, the FME Data Inspector tells me there is no geometry in my json file. Do I need some sort of transformer in between to create the geometry in json? Thanks!

Hi,I have some JSON GET requests working AWS API Gateway and an FME backend thanks to @GerhardAtSafe and @stewartharper for the youtube videos and github repo. The next step is to offer up zip files. The workbench streams a small zip file and I am now trying to get this working through the AWS API Gateway. I have added application/zip for the content type and got the gateway to support application/zip binary. When I try to make the call though I only get an empty zip file - although the FME job does run successfully and a file is created. I suspect it is because the body mapping is incorrect. There is some information for images here:https://aws.amazon.com/blogs/compute/binary-support-for-api-integrations-with-amazon-api-gateway/Does anyone know what I should put in the body mapping template for the integration response?Many Thanks,Oliver

Good afternoon all!I am having a problem with developing a QA/QC process for some CAD data. The ultimate objective is to compare the layers within the CAD files against base layer names located in a spreadsheet (i.e Elevation Contours, Houses, Lights, etc). I think the best way to do this is using Python. I have tried transformers but they only look at the data that is being run. I'm new to FME Python and I'm kinda lost so far. Any assistance would be great!Thanks! David