Transformers

I have one reader with buildings (areas), and one with parcels (also areas, having 2 attributes: parcel_no, parcel_id). I would like to output an Excel file of every building, with the parcel or parcels where it is located, separated with a "/". For example:Building_no Parcel_no Parcel_id 1 1051/1052 P0356684/P0356685 2 1053/1054 P0264568/P0258934 3 1102 P0256425 4 1173 P0546742 Parcel_no and parcel_id have to be in the same order.What should I use (SpatialRelator or AreaOnAreaOverlayer)? What options should I select?And then, how can I aggregate the fields in one field (ListRangeExtractor, Aggregator, other...)?Additionnal question: can I list only the parcels where the building occupies more than 5 square meters (to avoid parcels that are juste a little bit on the edge)?

I am making a spatial relationship where there are several blocks for the same property, each lot of the same property has a unique value for the block column. If there is a spatial relationship of another file with one or more blocks, all blocks with the same block should appear as if there is a relationship. How to do this?

I want to execute a .sql file through FME. Is there any method to call a sql file before running FME translation? I think it is not possible through sql creator or executor. Is there any other way?

Hello!As you see on the picture, I have lines connected to object (topological). They have differents orientations.I would like to extract the orientation of the line that intersect the blue object and force it to have the first vertex (start) intersecting this object.Then I would like to force the orientation of all the lines connected and all the ramifications to be like this firt line, like a waterway network.I tried differents transformer like NetworkFlowOrientor, PathBuilder/PointOnLineOverlayer but without success. Do you have any idea? Maybe I need a loop or something like that?Thank you in advance!

My client is asking for a report of the mapping schema I used to import data into my database from his Salesforce. For example, he has fields a, b, c, in his salesforce and they relate to my fields. x, r, e, in my database. I use the attribute manager to do the mappings. He basically wants to see that I: mapped a to r, b to e, and c to x. Is it possible to do this?  If that doesn't make sense then see below. I am trying to explain to my client what field on the left ended up being map to which field on the right.

I have not found this case in forum.I have spatial point dataset from which I want make lines depends on some break attribute. I aggregated points based on this break value, and I received for example 3 set of points. From each of this set I want get Line.When I use LineBuilder, I get wrong result - each point connect which each point. I want situation when second point connect first, third connect second etc. ...For example by order of incoming points (remembering about break attribute).

I created the oracle connection inside named connection window. and tested, its good. But when i use the same connection for sql executor i am getting the following error Connecting to ORACLE database `EGIS_T' with user name of `EGIS' and password of `***'Error connecting to Oracle database: message was `ORA-12154: TNS:could not resolve the connect identifier specified'. (serverType=`ORACLE8i', serverName=`EGIS_T', userName=`EGIS', password=`***', dbname=`')ORACLE Reader: Using Oracle Reader to read tables from database `', server type `ORACLE8i', server name `EGIS_T', user name `EGIS', password `***'ORACLE Reader:fme is not mapping the connection name to connection object.where is the problem ? 

Hi.I have been assigned the task of importing 4000+ images from a remote service into a local Postgres database. An obvious FME task.Fetching the images with ImageFetcher runs smoothly, but here starts my problems:- I need to store the MIME type, but although ImageFetcher is set to auto-detect this, it never reveals it in the output. And no file extension is available, and no other transformer offers that service, so an improvement to ImageFetcher is warranted, I think.- I need to store the image in a text column in base64 format, but a combination of GeometryExtractor (FME Binary) + TextEncoder (Base64) doesn't really seems to work.The output should look like this: data:image/jpeg;base64,/9j/........Is there a better way to accomplish my task ?Cheers

What is the best way to count corn plants in a field? I have drone imagery, mostly infrared but some rgb.

I'm not sure what words to use, again, to find my answer so I'm just going to ask.  I'm new to Regular Expressions, and not an FME wizard by any means  I need to, inside a loop,  take text that looks like this: (i'd like to avoid using blocking transformers if possible at this stage in my workbench)OKC1D,790 [55559]|OKC1D, 791 [272]|OKC1D, 792|OKC1D, 796|XD, 4-6 [DEAD]And make it look like this:OKC1D,790 [5559]|OKC1D, 791 [272]|OKC1D, 792 [272]|OKC1D, 796 [272]|XD, 4-6 [DEAD] With string replacers and searches I can get this:OKC1D,790 [5559]|OKC1D, 791 [272]|OKC1D, 792|OKC1D, 796|I'm able to select what's in the brackets with: (?<=\[).*?(?=\]) but I get 5559 and 272,  I need a way to select the last matched group, 272, there are cases where it may be more than 2 match groups but I think that If I can just select the last one it should work  https://rubular.com/r/r2TsFBPPy19hFO   Any regex wizards out there that may be able to help me, OR suggest a better way in FME to do what I want

Established a workflow to convert address points .txt file to .dbf in order to add x,y point in ArcMap. Was able to do an expression fanout that would classify my address points by province (individual folders), but the output is not readable in ArcMap. Any clues? did I miss a step somewhere? Also, if I choose the reader as an .txt, (my file extension is .txt), the reader fails to read my file, I have to choose .csv instead.... also another thing I don't understand...

Hello,Just wondering if anyone could help, i've run into a slight problem with overlapping polygons and I can't seem to find a solution with AreaonAreaOverlayer or SpatialRelator...My problem is that I would like to find when a polygon (Yellow - C in the pictures below) overlaps 2 other polygons. This can be when the full extent of that polygon is completely within the other 2 (example on the left) or it is contained within the others and overlaps their individual boundaries (example on the right).Hopefully that is understandable, sorry if i've missed out anything it's my first time posting a question on here!Thanks in advance,Jack

Hi,I work with WFS reader with polygons and multipart polygons. So, FME ingore the multipart polygones. There is no any error message, but it imports only simply polygons. I don't understand why. Is there any parameter of the WFS reader to change?  Thanks

Hello.I'm using a mapnik rasterizer to overlay a couple of vector datasets on a set of rasters. I have three input, one raster and two vector. When I run it it produced one output including the three input rasters on top of eachother. How can I set it up to run separately for each input raster?

Hello to all forum members, I am looking for lines that have a close relationship between each other ~10 [cm]. The result is a blue line. pictures: a), b), c) it's results from the workflow: pictures: d), e) found a similar solution only the lines have a real relationship, they intersect. Transformer: LineOnLineOverlayer and finall LengthCalculator so it's easy to detect. I tested: NeighborFinder, LineDevider, Snipper, SpatialRelatorThank you for your help.

I am trying to parse an XML file to generate a chart. I am not exactly sure how do do this and could use some help. These should be data series line graph of temperature, salinity, and sound velocity by water depth.Here is an xml example file!

Hello, I wished to summarize the length each route type based on the Map_NO. For example, in Map_No 000, it will give me the length of the total of Program #1, Program #2 and Islands & Turning Lanes. My reader is a line feature class, and I also have separate Map Index class. Ideally, I would like to have attributes about distance of each route type for the associated Map No. I have tried the Sampler, StatiscticsCalculator, Aggregator etc and they didn't give the result I wanted. Maybe there is anything setting or other transformers I could try? Thank you.

I have annotation features in one FileGeoDatabase and I translate them to another FileGeoDatabase using FME. However, it does not maintain the font size. I think it has to do with the relationship of text size and symbol ID in the FileGeoDatabase. But I cannot maintain the font size of the annotation whatever FME format attributes I use in the writer.

Hello, I want to extract individual tiles/images with a fixed dimension (pixels x pixels) from an orthomosaic file (.ecw format), containing a single building in the centre of each tile/image. I do have a shapefile containing all building footprints but a can figure out how to approach this.Can someone help me or give me some tips? Thank you! Best regards,Bram

Hello FME community, I am looking for ideas/ logic to use in FME to divide an irregular polygon geometry into user defined number of polygons of equal or approximately equal area. Example: Assume an irregular polygon with total area of 180 Sq Km.The user would like to divide this irregular polygon into 6 smaller polygons of equal area. That is 30 Sq Km each.But for the spatial input for the irregular polygon to be divided and the number of smaller polygons of equal or approximately equal area desired, there will be no other inputs from the user.Looking for ideas/ logic to use in FME.ThanksSRG

Hi, Could anyone please help with the following issue?I've got 2008.0 version (32 bit) FME installed on server (Windows Server 2008 R2 64bits) with python 2.65 (32 bit) installed. The FME workbench works well on my desktop. But when I moved it across to the aforementioned server, it could not render some of the transformation shapes, hence delete them.I then updated the FME desktop on the server to 2018.1 (latest release 32 bit). But the issue persisted.In every run, the workbench stopped with the following error message: "FME API version of module 'Python_func' matches current internal version (3.8 20180604)In a future release, FME will have reduced support for Python 2.7. Please review http://fme.ly/py27 for further informationPython Exception <ImportError>: No module named _fileioFailed to import `fmesite'Python Exception <ImportError>: cannot import name OrderedDictError executing string `import StatisticsCalculator'@Python failed to execute com

Hi all I hope you can help. I'm fairly new to FME Server, but am having an issue with IMAPS picking up email.We've recently migrated our email from on-premise Exchange to a cloud-hosted solution (Exchange365).We have some contractors out in the field that email geotagged photos from their iPhones to a specific email address.For the past few years, we've been relying on an SMTP "notification publication" on FME server to pick up these emails and process them accordingly.From what I can see, the publication picks up the email, saves any attached photos to a specific folder and adds the location of that folder to a text file. The text file also contains a bunch of meta data contained in the email (sender, date, that sort of thing).An FME workbench is then called that uploads that photograph to a map and tags it with the metadata. Here's an example of the text file that is generated: {"fns_type": "email_publisher","email_publisher_to"

OK S00224 11-18_1-19.csvI have a list that I need to parse. I am not very well versed in Regex. I can manually build my attribute names (and in fact will have to change some of these as they are. I need to know how to1. handle the different number of dashes between the attribute name and the attr value.2. retrieve multiple attributes from one line.3. remove the brackets and write the value to the attribute with varying length strings4. handle LF5. manage dashes inside of brackets (keep)Here is some of the data structure of the list...RKORT 1712 OKOCS 11/01/18 11:33:07 18110111301739 UPDATETICKET NUMBER--[18110111301739]OLD TICKET NUM-[18102215173653]MESSAGE TYPE--[UPDATE] LEAD TIME--[48]PREPARED------[11/01/18] AT [11:30] BY [IMTHEBESTMAN@TRUCKERCONST.COM]CONTRACTOR--[MTRUCKER CONSTRUCTION] CALLER--[JARVIS BESTMAN]ADDRESS-----[707 S CREEK COUNTRY ROAD]COUNTY-[PINE] PLACE--[CUTHING]ADDRESS-----[] STREET--[E][DEEROCK][RD][]NEARBY MAJOR INTERSECTION-[N LITTLE AVE AND E DEEROCK RD]LATITUDE

Hi,reading a geojson file from an online ressource delivers the following error:The file contains german special characters called "Umlaute", such as ä,ö, ü or ß. Manually replacing these characters by other characters, e.g. "ae" instead of ä "solved" the problem. Within FME I can't find any place where one could set the character Encoding.Any smarter ideas out there?

Hello,I have global data read in from PostGIS which I want to clip out to any one of the 5000+ coordinate reference systems (the end user might request anything) and then export to FileGDB, Shapefile or Landmark Z-Map Grid. The data is in WGS84, clipped in WSG84, and then reprojected. Some data reprojects fine (maybe based on the CRS) but others don't and I can't see why. The example image below shows some data that is projected into Minna.NigeriaMid projection. In the original data, the entire earth is covered by data, but no polygons overlap. Clearly, after reprojection they do. I believe most overlaps are caused by the data being 180 degrees away from the central meridian of the Minna.NigeriaMid projection, but cannot think of a way to easily get around this. If there was a way to find the central meridian of the projection the user requests and cut the clipper 180 degrees from that, it might solve the issue? I have cut my clipper area so it doesn't go beyond -179.99, -8