Transformers

I have a road network where I have to find intersections with more than 2 streets. I used Intersector to find nodes and filtered nodes with more than 2 overlaps, eventually finding intersections with more than 2 streets. But this approach has resulted in finding undesirable intersections marked as cross in attached image.To avoid those intersections I decided to find angle between lines. I cannot use AzimuthCalculator as I don't have a previous WB referencing this transformer. I used PolylineAnalyzer but it outputs angle between segments and not lines. Is there any way I can filter out these undesirable intersections?

Hi  i'm trying to pivot (transpose) some data, but all the examples i can find on here turn rows into columns, and i want to turn columns into rows.  DATA   RegionUnder 1616-1718-1920-2425-3435-4445 and overDurham572025263520Darlington351827284425Gateshead8152535262835 what i want it to look like RegionAge BandValueDurhamUnder 165Durham 16-177Durham18-1920Durham 20-2425Durham 25-3426Durham 35-4435Durham 45 and over20DarlingtonUnder 163Darlington16-175Darlington18-1918Darlington20-2427Darlington25-3428Darlington35-4444Darlington45 and over25 etc. Any help in much appreciated.  ThanksMark 

The gist of the problem was defined in this question. https://knowledge.safe.com/questions/46298/how-can-i-easily-expose-attributes-from-xmlflatten.html In my case the JSON has the schema (name, alias and field type of a feature). Shown below.Sample attached.I got the schema array in rows.I have feautes JSON fragmented with json["features"][*]["attributes"] with the following output.Instead of exposing each attribute one at a time or importing a temporary csv file created by aggregation, i'd like to use the schema from the fields array for the features output.Hope to get some ideas to use using derived schema in my workflow.Thanks!

Hey,I have polygons with a height information (in meter) in the attributes. (Those are buildings) How can I use this z value (height) and create a 3D model from my polygons?  For some Objects i dont have the height information, could I set some default height for all of the Objects which do not have any hight information? - if yes, how?  Kind Regards!

I am trying to find a string with regex and put it in an attribute. I have used the stringReplacer, but this means I would have to search for what I don't want to capture and replace it with nothing so that what is left is the string I want to capture.It seems as though capture-groups do not capture strings for subsequent use in fme.     

Hi,For my current task I have a road network (purple lines) and 2 datasets with points.Dataset 1: green pointsDataset 2: red pointsWhat I want to do now is to select points from dataset 2 which intersect or are close to dataset 1. See the attached figure for examples.However, I want to limit my search for the test 'are close to' within a single line. The FME method/tool should not look at points which are postioned at parallel running lines. In the figure below I do not want to select the red point indicated as 'not intersecting'. There are green points closeby. However, they aren't postioned at the same line which should be the case to be considered as a closeby points.I tried something with the NeighborFinder. This works fine. Only situtations like the one below I did not solve yet. Any suggestions? 

I have started testing of translating our data from GDA94 to GDA2020 in preparation for Australia's new datum change. I have tried a simple translation however have a 'Warning' in the FME translation process saying "MapInfo does not support datum/ellipsoid GDA2020 -- assuming default of WGS84", why?? How do I correct this?

I am new with FME and I have been testing several GIS software to add elevation data to a GeoPackage. No luck so far and I was wondering if FME had the capabilities to do it. Thank you

I am trying to pass a list of API and Date values from a StatisticsCalculator to a SQLExecutor to execute a joint query from a SQL Server database, and it does not work for me. The following is my query inside SQLExecutor, and I cannot get any results. Please help. Thanks in advance.SELECT a.PROPNUM,LEFT(a.API,10) as API100, a.WELL_NAME,a.AREA AS [MGY_AREA],a.RSV_CAT,a.STATE,a.COUNTY,a.OPERATOR,b.[D_DATE],b.[GAS],b.[OIL],b.[WATER],b.[FTP],b.[CSG],b.[CHK]FROM [dbo].[MAGNOLIA_AC_PROPERTY] a, [dbo].[AC_DAILY] bWHERE a.PROPNUM = b.PROPNUM and a.API = 'value@(API10)'

I know i am missing something obvious here, but i need to select all of the polygons containing points. I have tried the point on area overlapper which works fine for those polygons containing only one point, but if it contains more than one point it will only select the polygon once.How can i export the same polygon with the merged data for each point the is selected?I.e. 3 points = 3 polygons albeit the same geometry but different attributes.Thanks for your help?Andy

I am reading from a postgresql database. Attribute [publication_time] has a primary key and type timestamp. In the postgresql database this attribute has values, but FME 2018.1 inspector shows no (blank) values.Can timestamp as primarykey be the cause? Kind regards Kees 

I'm new with FME. I have one attribute with this value "Zonne-energie in woonplaats vermogen 0,2394 MW, beschikte productie per jaar 227,43 MWh, looptijd 15 jaar. Het project is nog niet gerealiseerd (peildatum januari 2020)."I want 4 values out of this values and put them into 4 attributes.- 0,2394 MW into VERMOGEN- 227,43 into PRODUCTIE- 15 into LOOPTIJD- januari 2020 into PEILDATUMI want to use StringSearcher but i don't what Regular Expression to use. CWho can help me?

I have IFC data that originally used a local cartesian coordinate system. It originated in Navisworks and I used Intergraph Smart Interop Publisher to convert it to IFC format so I could use it in FME. I want to use the data in GIS software (ArcGIS Pro/Online) so will likely convert to multipatch/revit.What is the best approach for georeferencing this data/working out control points, etc.? Some of the IFC files are quite large (500MB+). Any suggestions appreciated!

I have an orthophoto in ESRI GRID format stored in a file geodatabase. It works really well in ArcGIS and ArcGIS Pro; however, I need to convert this image into a GeoTIFF for a contractor that does not have an ESRI based GIS. I have tried to do this in ArcGIS Pro but I keep running into resolution and grainy output problems, and the documented fixes and remedies are not helping.  As I have FME Desktop, and I have seen that FME is capable of converting raster imagery from one format to another, I thought I would give that a try...but now my output is even worse than before.  Not being one to give up I thought I would come here to see how I should approach this using FME. Is there a trick to converting raster images? I thought it would be something quite straight forward (e.g. Geodatabase raster reader --> TIFF writer), but obviously the process will be a little more complex than that, at least this is my current thinking.What is the best way to convert an image from one format to

Is it possible to read in multiple files from a parameter with FeatureReader? For example:C:/some_path/fileA.shpC:/some_path/fileB.shpSourceDataset parameter value would be: C:/some_path/fileA.shp,C:/some_path/fileB.shpBut this approach doesn't work, it gives an error.

Hello,I am interested in how to get a given point distnce with FME.I have points arranged by counter (pontID is ascending) and I want to get the next point's distance. I tried NeighborFinder, but the problem is that sometimes an other point is closer,so it gives a wrong distance.Thanks!

Now, ever since discovering Bulk Mode transformers like FeatureJoiner, AttributeFilter, AttributeManager etc. my WorkBench designs look radically different to my "old" ways of doing things in FME. Gone are almost all of my Testers, FeatureMergers etc.One of the things I had been meaning to test though is "Does FME automatically activate Bulk Mode where possible or do you maybe have to "Force" it? "It appears that in many workflows they do not automatically switch the Transformer into Bulk Mode!!!Example 1 - AttributeFilters (Bulk Mode capable) fed from a Tester (Not Bulk Mode capable)Takes 55 seconds to complete.Example 2 - AttributeFilters (Bulk Mode capable) fed from a Dummy FeatureJoiner (Manually forces Workflow back into Bulk Mode)Takes 23 seconds to complete despite having a extra FeatureJoiner! Here I just match on any random fields with FeatureJoiner. I'm not actually trying to Join anything, but rather "force" the workflow back

I'm trying to map levels names from one MicroSation DGN file into different level names in another DGN file. Most of the levels are being mapped correctly but some features are not being mapped at all. Not sure why that is happening. Has anyone else had this problem?

Currently the MapnikRasterizer will not render lines/polygons if the output raster dataset exceeds ~32,800 columns - text and points will render normally regardless of the size. For example, if I try to process a dataset that spans 40000 x 45000 pixels, the output will be missing the rasterized lines past column 32,768.

Hi, I'm working on a workbench to report on changes made to a data set. I have a database table with a column of unique IDs. I store a previous copy of the IDs so I can compare current against previous.Using a FeatureJoiner I can establish NEW/DELETED IDs - brilliant......The issue is that I may not have Unjoined Left/Right every time so at the moment my workbench doesn't proceed.I need to get to the point where the workbench can continue/report even if either/or both are null. Is FeatureJoiner the best transformer?Any ideas? Thanks 

How to make LoD3.0 or LoD2.3 buildings in 3D shape. I have roof constructions and the floor in 3D. Is anyone doing it? The data set is in dwg format.

Hello,Can you please help me with HTML parsing. Which settings I should using (css selector and etc) into HTMLExtractor that I can get only value of data-title attribute ?Regards, Pavel.

I've got a *.dwg with a surface and an image attached on the right coordinates.I would like to drape the image over the surface, the image will drape but I coudn't get it on the right coordinates, who could help me please? The files and workbench are attached. Thanks!!

Picture 1: Picture 2: I want to do a Raster Mosaik so i need to make sure that the Rasterbands of the two Pictures are the same.why has the picture nr 2 behind the channels "#"? Never saw a Raster with the Band behind the Channel.

Hi all,I am using 2DGridAccumulator, which works perfectly fine. I would like to write also the bbox coordinates of each grid to my final output. I can see those values in the inspector but I don't know how I can extract those attributes so that i can write it. Any idea how i can do it? thanks in advance.