Skip to main content
  • EN

Best Answers

10387 Posts
J
jitkam
asked in Data
How to convert Shapefile to CSV and extract Postal Code as well as coordinates

How can I convert .shp to .csv and include Postal code as well as lat/long? I am able to make the conversion, but only Postal code is exposed in the .csvThe original shape file has x and y axis and is using EPSG 102015, the .csv would preferably convert to EPSG 4326 and include lat/long

272
J
bubblebeb
Contributor
bubblebebContributor
asked in Data
Does FME write to MongoDB?

Does anyone know if FME can write / read / interact with MongoDB?   

173
B
J
johannesbloemen
asked in Transformers
Snap line to line

I would like to snap the blue line to the red line. End goal is to merge attributes. I tried using AnchoredSnapper, the problem is that as you can see in some cases especially where the line bends lines can be closer to the 'wrong' red line. Any advice would be greatly appreciated.

3983
gio
Contributor
A
andyew
asked in Transformers
Multiple Attributefilters on one source going to one destination

Folks,Still on that learning curve.I have a table where there are two filtering criteria based on two different columns in the source.Initially I thought to use two Attributefilters one for each criteria and then re-combine the result like a UNION for the output.However it's possible the criteria will allow the same record through twice. Once for each criteria.What is the best way to filter out data based on multiple criteria?I was thinking if I stuck with multiple parrallel Attributefilters I'd need some kind of Merger to eliminate the duplicate records.Advice apprciated.

152
A
arthy
Contributor
arthyContributor
asked in Data
how to dynamically create a json

Hello,I implemented a changed detection on oracle table.Now I would like to be able to create a json for each change per object. For instance, for an object where changes were detected on 5 attributs, below will be the json that I would like to obtain:{ "ATTRIBUT1": { "OLD_VALUE": "OLD1", "NEW_VALUE": "NEW1" }, "ATTRIBUT2": { "OLD_VALUE": "OLD2", "NEW_VALUE": "NEW2" }, "ATTRIBUT3": { "OLD_VALUE": "OLD3", "NEW_VALUE": "NEW3" }, "ATTRIBUT4": { "OLD_VALUE": "OLD4", "NEW_VALUE": "NEW4" }, "ATTRIBUT5": { "OLD_VALUE": "OLD5", "NEW_VALUE": "NEW5" }}How can I proceed to obtain this in fme?I was tinking of the agregator to group all the changes from the same object (based on an objectid) and then build the json but I don't know how to proceed.Please keep in mind that the number  and names of attributes will change from one object to another one.Thanks,

1305
arthy
Contributor
B
bakkermans
asked in Transformers
Read csv in SchemaMapper via published parameter

I want to read the csv file for my SchemaMapper via a published parameter. This however does not seems to be an option. I can not select a parameter and when I try to type $(published_parameter), I get in parameters the notification "No dataset found in $(published_parameter)". How can I solve this issue?PS: using FME 2016.1 build 16492

123
verdoodtdries
Supporter
F
flocad
asked in Transformers
How to create an advanced BoundingBox ?

Hi everyone ! I'm trying to create an advanced boundbox from multiple input (.dgn) using a group by closis on fme_basename and I would like that my boundbox be oriented !I tried the BoundingBoxAccumulator and Replacer but with the Accumulator there is no OrientedBoundBox and with the Replacer there is no group by ...Does someone has an answer ?Thx =)

294
F
E
e_blair
asked in Transformers
point elevation from contour lines

Is there a transformer that will assign an elevation value interpolated from a set of contour lines?

642
E
ireen
Contributor
ireenContributor
asked in Data
Direction of a closed curve (line)?

I have to determine the direction of a closed curve (a line where start and endpoint are the same) because I want to derive a gpx in the right direction (clockwise) from the polyline. Is there a way to do this? So I want to test if the polyline has a clockwise direction and, if not, reverse the direction. I tried the Polylineanalyzer and the azimuthcalculator, but both don't give me a solution.

394
ireen
Contributor
ngstoke
Contributor
ngstokeContributor
asked in Transformers
Identify duplicate attributes and only keep attribute with the most recent date.

Hello,I don't know the best way to go about this, I've been trying to set some conditional statements in my AttributeManager but I'm unable to get the results I'm after. I'd like to identify the duplicate serial numbers (API NUMBER 10) in my data and then only keep the duplicate that has the most recent date (WELL STATUS DATE).Thanks in advance for your help.

2433
takashi
Celebrity
parashari
parashari
asked in General
Extract Polygons as per Grid

I am sing FME 2016 and have polygons dataset that are spread in an irregular fashion. I want to create a fishnet(grid) wherein the geometry is as per the density of the polygons. So, first of all, I have to convert the polygons to points, so that the original polygon file is not occupied by 2 different grids and then create the tiles thing and save the output in multiple polygon gdbs (outputs as per the tile). it would be really amazing if the number of polygons in one grid could be controlled.Thanks.

13416
takashi
Celebrity
A
andyew
asked in Transformers
AttributeManager somewhat unexpected functionality

Folks,This is part observation and part confirmation of the general functionality of Transformers.I have an AttributeManager. Amongst it's operations there is a conditional evaluation of a value.If owner = XCOM then id = 0. This modified the id value. This was working. Then "all of a sudden" it stopped working.During my manipulations I applied another modification to the owner field in the same AttributeManager.If owner = XCOM then owner = Xcom. This modified the owner field. A case modification for the purposes of output.What I didn't anticipate was that my earlier condition would stop working because the case of the owner had changed based on another condition. I presumed that all operations in an AttributeManager operated on the original input file values.Is this expected functionality?

44
gio
Contributor
nath
Contributor
nathContributor
asked in Transformers
Move a point

Hi,I want to move a point by using the coordinatereplacer but i'm doing something wrong because the point doesn't move. What's the value i have to enter by Replace? Thx!

1264
gio
Contributor
aron
Supporter
aronSupporter
asked in Authoring
Dynamic writer is not exporting all attributes

I suspect that I am missing some simple setting here. But simple as it might be, I cant find a solution. I have set up a workspace that imports a bunch of shape files and runs various transformers on them. Among these are Attribute Managers for some of the files, where I add a couple of new attributes. But for some reason these new attributes do not get written to the exported shape files. When I Inspect the last step with the same data that is feed the Dynamic Writer everything looks fine. Is there some setting I have missed or do I need an additional step, with a extra transformer, to write the new schema?

732
itay
Supporter
R
rydentobbe
asked in Transformers
Convert extremely big raster to polygons

Hi, I'm trying to convert a raster that is some 7 gigapixel to polygons without resampling.The raster is global land cover data, and it is one band 129 600 by 55 800 pixels (7,2 Gpx...). Trying to use the rastertopolygoncoercer obviously crashes. I don't want to resample because of the resolution and my following work. Instead what I want to do is to dissolve polygons based on 23 possible values represented in the raster. Land cover is fairly coherent I believe.But... I am at a loss trying to figure out how I should solve this. Maybe some kind of loop reading 10-100-1000? rows at a time, dissolving these and writing to an appending fileset.I believe that the final dataset would, should... could be in a manageable size. Maybe I'm wrong and the only option is to resample.

1123
jdh
Contributor
M
mikeymess
asked in Data
KML Styler Custom Icon

I'm trying to add a custom icon using the KMLStyler. The icon is saved on google drive. I used Attribute Manager to add a new attrubute called "Symbol_Icon" thats value is the google drive url link, then I used the KMLStyler to set the icon name to the newly created attribute. I'm getting the "red x" once I open the kml in google earth. Screenshots below, any suggestions?

1744
itay
Supporter
oscard
Influencer
oscardInfluencer
asked in General
Use SDE Writer in FME Server

Hi.I have a workspace that uses the ArcSDE Writer. It works perfectly in my FME Desktop, because I have ArcGIS installed in the same machine.But now I have to upload it to a FME Server. In that machine, there is not any ArcGIS installation and I've been told that there is no plan of installing one. So... my workspace won't work.I'm aware of the ArcGIS Legacy writer, but it's an option that they don't want to use due to its lack of maintenance.So... is there any other solution? I've been searching in this forum and I haven't found anything else.Thanks for any help provided!

1596
david_r
Celebrity
G
gam
asked in Transformers
Copy some attributes from a second source

Apologies, This is a newbie question which shouldn't be this darn awkward to do.I have two files A & B . Each have 3 attributes: NAME, ID, LABEL I want to copy A's NAME into B's LABEL based on the same ID.I have been trying with Feature Merger. Join On for Requestor and Supplier are both pointing to the ID. A is the supplier. But the merged LABEL is not being overwritten.any positive suggestions?thanks kindly

112
G
D
davewp
asked in Transformers
Problem using Dissolver with large shape files - corrupt KML files created

HiI have a file of UK postcode areas which I am attempting to merge to create a themed overlay on a Google Map. However, it appears that in merging the polygons from the shp file, some of the polygon boundary line-string point ordering gets messed up so that there are "figures of eight" in the resulting KML file.I suspect the problem may be linked to the order of shapes in the original shp file, so is there a transformer I can use to improve the dissolver functionality.Note that the inspector view of the output is correct, it is just when "kml_360" polygon is viewed, it has "steaks" across the area.I have attached the source files used to create this sample. The image is OK when viewed by the inspector.Thoughts on how to resolve this issue welcome or additional transformers which can be used in the data processing pipeline to mitigate the problem

164
fmelizard
Safer
U
uba_kp
asked in Transformers
How to write feature class attributes without „null-values“?

Dear FME-users,  I’m creating polygons from input raster data. Therefore I use the transformer “RasterToPolygonCoercer”. The values of 7 input data are written in 1 output feature class.  These attributes includes a lot of “null-values”. (<NULL>)  Do you’ve any ideas which transformer can solve it?  Thank you very much and best regards.  Konrad

1014
U
J
john_leo
asked in Data
Bug in FeatureReader?

This is somewhat related to another question of mine. I am using FME 2013 and connecting to Smallworld 4.3 via SpatialBiz' SBS plugin.I have had trouble getting the syntax straight to extract all elements from gt_pipe_segment that match a certain 'where'-clause (using FeatureReader). At some point then I decided to look at the results without any clause in place, and got the following results:FME returned me about 28.000 entries, while gt_pipe_segment.size is about 92.000.This problem seems to get bigger the bigger a table is. But already for a table of size roughly 1500 I had a deviation of six.Again, there was no clause in place, neither spatial nor on the attribute.Is this a known bug? Can someone confirm this? Could this be fixed in a newer version of FME/SpatialBiz? I have found another bug report on FeatureReader.  

154
erik_jan
Contributor
J
jedimule
asked in Authoring
Group lines based on similar heading and of the same attribute type

I have a collection of lines and I need to first select those within X distance of each other, and then merge into one feature if the headings are the same (within a specified threshold) and they are of the same type (specified attribute).The result will be one line representing a grouping of features that are of the same type and heading in roughly the same direction.Does anyone have any ideas on how to approach this?So in the image below, step one would be to find the groupings of lines within x distance and heading in the same direction.After this selection I want to group them into one feature based on a specific attribute. in the image below, these lines are grouped according to a specified attribute.The end result would be this, one line representing all of the merged lines heading in the same direction and grouped by a specific attribute.

578
ebygomm
Influencer
clemensb
Contributor
clemensbContributor
asked in Transformers
Update of database deletes values of other fields

Hi,i have a workspace which reads a featureclass from ArcSDE with MSSQL Server 2012 with many fields, where one field is named “Post_Processing_Status”. I validate and check the data, do some calculations and create a csv from the data. Is the data from the feature class not valid I update the field “Post_Processing_Status” with the value “mangelhaft” or when it’s OK with “MNA” (originally “erfasst” is in Post_Processing_Status) and write it to the featureclass in the SQL Server. However when I check the data, the value for Post_Processing_Status is written, but in some rows other field values are now missing, they are filled with blanks. In the original all fields were filled with values. My procedure is I delete with an AttributeManager all other Attributes, except the OBJECTID and the Post_Processing_Status assign the value “mangelhaft” or “MNA” and link it to an Esri Geodatabase (ArcSDE Geodb) writer with the configuration “UPDATE”, the Transaction Type is set to “Transactions”.I c

78
fmelizard
Safer
tim_wood
Contributor
tim_woodContributor
asked in Authoring
Parallel processing with PointOnAreaOverlayer fails to add polygon attributes to point data

FME 2017.0 (17271) on Windows Server 2008 R2 Standard.I'm using PointOnAreaOverlayer to add 3 attributes from a polygon layer (non-overlapping polygons) to a point layer. The polygons are coming from ArcSDE (SQL Server) and the point data comes from SQL Server with geometry in the Geometry data type. The 3 attribute columns already exist in the point layer and I'm using fme_db_operation to UPDATE them in the Writer. Between the PointOnAreaOverlayer and Writer I'm using AttributeManager to assign the polygon attribute values to the appropriate SQL Server table attributes.If I don't use any parallel processing in the PointOnAreaOverlayer, the translation works and takes about an hour per million points. However, if I group by one of the point layer fields (4 distinct values) and use Aggressive parallel processing, it cuts that time to 40 minutes per million points, but the polygon attributes do not get added to the point data. When I inspect the output from AttributeM

246
tim_wood
Contributor
danpaoly
Contributor
danpaolyContributor
asked in Authoring
Look Up Tables

I would like to have the attribute values in my source data compared to values in an external look up table and changed based on the values in the look up table and then have the new values populated in a different database.  For example.  Read the Type Column find the value UNKNOWN look at the look up table and change UNKNOWN to UNK and send to destination database.

1816
J

Badge Winners

  • Welcome Back
    lizsanderson21has earned the badge Welcome Back
  • Integrate Spatial Data
    jbrontehas earned the badge Integrate Spatial Data
  • English Speaker
    strangbyhas earned the badge English Speaker
  • Swedish Speaker
    strangbyhas earned the badge Swedish Speaker
  • Welcome Back
    strangbyhas earned the badge Welcome Back
Show all badges

Community Stats

31,811
Posts
120,827
Replies
39,442
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.