Skip to main content

Data

Using readers and writers to extract and load data.

  • 6,970 Posts
  • 25,684 Replies
6970 Posts
J
jesuspisto
asked in Data
Polygon can't be written to file geodatabase

I'm reading polygons from SDE and selecting them with the spatial filter transformer. I add and calculate a few attributes and then output to file geodatabase but I get an error message saying that non poly feature can't be written to poly feature class in file gdb. Why the error? Data is coming from SDE so geometry is fine, and I'm not altering it in my script. This always seem to occur with the same polygon. Any ideas or suggestions? thanks

880
J
C
chesney
asked in Data
Multipatch 3D shapefiles to DGN

Hi I'm looking to translate some building multipatch 3D shapefile data into CAD format. We are using ArcGIS 10.1 and FME 2012. Could anyone help please? Thank you.

170
fmelizard
Contributor
P
petejnr
asked in Data
Output data to local drive

I have a job which has been added to FME Server. I would like a user to log into FME Server and run the workspace but allow them to process a textfile on their local drive and output a shapefile to their local drive also. The workspace connects to Oracle Spatial to retrieve some data also. Is this possible? Thanks

221
sigtill
Supporter
D
dominic
asked in Data
DGN to DGN

Hi, I have build a model that read a .dgn file, add MsLink and then write the result in a new .dgn file. I have a problem with the cells. When i run the model, I receive this message : DESIGN WRITER: The cells read from the cell file V8.cel' are as follows: META RESURG TOUR MINE RAPIDE GOUFFR BATIME PONT BRULEU COTTER COINFE PYLONE HUMIDE FLECHE CHUTE SILO PHARE HYDROB MARINA ROCHE SKI TOURT CAMPIN NUMOV ETANGE RESERV MAIMOB ENLEV LEGMAJ SCAN20 MODIF SEGABS REPRE AJOU SCANB SEGNCO SEGTRO SEGIMP NOTE_B DESIGN WRITER: Error - An attempt was made to write a cell but could not find the value of 'igds_cell_name' on the feature

291
srg
A
asn
asked in Data
How to make 3d pdf?

hi, anyone know how to make 3d pdf? I can't understand it just only saw it from the webinar videos I'm so pleased if anyone here can share me the manual. thanks, asn

320
davideagle
Contributor
frantsch
Contributor
frantschContributor
asked in Data
PostGIS: Non geometry tables no longer writeable with Allowed Geometries other than 'postgis_none'

Untill FME 2012 the PostGIS writer wrote to PostGIS tables without geometry column even though the Allowed Geometries field within the Feature Type Properties was set to other than 'postgis_none'. Since FME 2013 this is no longer implemented, the Allowed Geometries field will strictly have to be set to 'postgis_none' in order to write to geometry-less tables. Strictly speaking, the new behaviour is correct, of course. It however gives me a big headache changing all the dozends and hundreds of Feature Type Proberties in all my dozends of workbenches in order to make them running properly again...

690
mark2atsafe
Safer
fme4fsj
Participant
fme4fsjParticipant
asked in Data
How is DBF file size calculated in Shape Reader?

I am aware of the 2g file size limitation for DBFs but the DBF on my shape file is only slightly more than 1g and I'm still getting the f"file limitation" error on the Shapefile Reader when it is reading the source file. Another shape file with a slightly larger dbf file runs fine. Am I missing something? Does any one know how the file size is calculated?

100
fme4fsj
Participant
P
pietro
asked in Data
Equivalent of the ArcGIS "Eliminate"

Many thanks for the answer to my previous questions. Another question: does FME have an equivalent of the ArcGIS "Eliminate" tool? (http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Eliminate/00170000005p000000/) (Default) The ArcGIS Eliminate tool replaces the selected polygons with the neighbour with longest boundary. (Using optional "ex_where_clause"), the Eliminate tool replaces polygons with the neighbour with longest boundary that doe not have a specified type. The FME "SliverRemover" does the same as the (Default) Eliminate, but does not have this "ex_where_cause" option. Application: I want to eliminate small holes and replace them with the neighbour with longest boundary except it this neighbour is a road, then it should choose the second longest shared boundary. How should I do this withFME? Thanks for your reply.

480
O
G
geospatiallover
asked in Data
Autodesk SDF

Does Safe has plans to support Autodesk SDF in the future?

150
G
S
sandman
asked in Data
Writing CityGML with custom ADE... I just cannot get it to work.. :(

So.. someone in my team wrote this custom ADE (see all the way below). I also have an example CityGML of how my output should look like. It shouldn't be so hard now to write a proper CityGML, right? Well, I'm getting quite desperate here... An example: for each building it should add this XML code to the feature: <bldg:Building gml:id="building_39"> <pan:project name="Test Project"> <pan:scenario name="Scenario 1"> <pan:doubleAttribute name="TestAttribute1"> <gen:value>43.5</gen:value> </pan:doubleAttribute> <pan:intAttribute name="TestAttribute2"> <gen:value>5</gen:value> </pan:intAttribute> </pan:scenario> </pan:project> ... etc. (geometry stuff) So, a feature can take part in 1~n projects and each project can consist of 1~n scenarios (bold). Each scenario contains 0~n generic attributes (double, string, integer), as shown in italics. If I add a writer to my workbench for the example CityGML that I have and I specify the custom ADE, I end up with the following attributes: citygml_pro

210
S
R
rickyt
asked in Data
ASCII Grid to multiple XYZ attribute CSV file

Hi, I'm trying to convert mulitple ASCII grids to a single CSV file in the following format: X, Y, Z, Z, Z, Z....etc.... where the Z is rainfall data over time. I can capture the XYZ info, but I don't know how to write out multiple Z value attributes while keeping the XY as a constant into a single CSV file. Any ideas on how to solve this are welcome. Thanks Ricky (newbie!)

330
davideagle
Contributor
J
jlinehan
asked in Data
DWG to ESRI 10.1 File Geodatabase

I am doing a simple convert from an AutoCAD 2011 dwg file to an ESRI 10.1 File Geodatabase. I have an FME 2013 Workspace with the input data (DWG) linked to the output dataset (fGdb). The Reader for CAD uses all defaults for Parameters and is generating a single merged feature type. The Writer uses the File Geodatabase API and is set to produce Dynamic Schema. Projections are set to source (Nad27UTM15N) The transformation completes without errors. I then open ArcCatalog 10.1 to view the created Geodatabase and see all features are there. Clicking on a feature to preview it is where the problems start. Any attempt to Identify the feature will come back with nothing found. Any attempt to zoom in causes the graphics to disappear. The features do not display in ArcMAp either. Teir Attribute table contains the Shape and ObjectID fields only. Can anyone point me in the right direction to resolve this problem?? [OS: details Win 7 x64, ArcGIS Desktop Advanced (ArcInfo) 10.1 build 3035 and FME

140
J
A
amit
asked in Data
Writing to a dwg block hyperlink attribute

Hi, I want to create a .dwg with clickable hyperlinks from a .shp file, however I can't see an attribute I can expose on the .dwg writer that can take the hyperlink attribute from the shp file. Does anyone know is this is possible? Also, bit of a secondary question (that may make the first one invalid!) , but could I write this straight to an interactive PDF? (I know I can create it via (Acrobat / AutoCAD). I'm not very familair with FME's PDF capability. Thanks.

340
A
A
angela
asked in Data
Writer - an Access database with special characters in field names causing issues

My workspace's goal is to import the contents ot two old Access databases into a new, differently structured Access database. The new database has four fields that have forward slashes in the field names. These are being interpreted as underscores by FME. When I run the workspace, I get an error indicating that my new database doesn't have the field `Esmt_ppty_lease Date' (the first field it runs across with an underscore I guess) -which of course it doesn't. What's the simplest solution here? I'd rather not have to rename the four fields in the new Access database as that has other implications.

170
C
P
pietro
asked in Data
Equivalent of the ArcGIS "Update"

Hi, Does anyone know what is the FME quivalent of the "Update" tool? Thanks. Pietro

40
davideagle
Contributor
Y
yakker
asked in Data
SDE to SHP - Loop through txt file and re-projecting

Hi All, Just wondering if anyone can help me out. I'm looking at pulling a single SDE layer and re-projecting it through FME workbench. I will be fanning the output dataset by province (BC,AB,SK) and each province will have 2 or 3 projections (LL27,LL83,UTM, etc...) . I am trying to figure out the best way to approach this. The SDE layer is large so I know the processing time may suffer a bit. I was thinking about creating a batch process and looping through a .txt file containing a list of provinces & projections to run the workbench. The batch process looks like this: BATCH FOR /F "tokens=1,2,3 delims=," %%A IN (reproject.txt) DO fme <workspacename>.fmw --<fme_projection> <projection> --<provincename> <province> MY BASIC FME WORKBENCH FLOW: SDE > ATTRIBUTE FILTER >SOME OTHER TRANSFORMATIONS> STRING CONCATINATOR (create file name)>OUTPUT (shp) Any suggestions and/or feedback would be greatly appreciated! Thanks

61
sigtill
Supporter
R
richo
asked in Data
One step dwg symbolising for pdf (or other output)

Howdy, Is it possible to grab points from a miscellaneous database, associate them with a dwg block (ie symbol, by way of a template file) and then effectively expand those blocks into entities prior to rendering out to a pdf, or even as a raster. It's an easy enough exercise to do it in two steps using an intermediate dwg file but I can't see a way to do it in one. Any assistance would be appreciated.

101
sigtill
Supporter
sigtill
Supporter
sigtillSupporter
asked in Data
Feature request: Restart FMEServer-service from admin-interface

It would be very handy to have a restart fmeserver-services including attached databases as a button in the admin-interface of FMEServer. Instead of logging in to the server and doing it "manually" from there - as this computer might be "locked away" between firewalls and computers. Similar to the "Restart router" that most internet-routers have in their admin-userface.

51
fmelizard
Contributor
M
msmgis
asked in Data
MapInfo polygon order

Hi, I have created a workbench to translate British OS Mastermap from gml to .tab which works fine and I have multiple MapInfo. Tab outputs. I also have a combined topography. tab which has all the features present but some building features are above land features and vice versa I have tried sorting prior to and after testing and styling but I have not been able to place all building feature above land features, fairly new to FME so any suggestions would be greatly received. Thanks in advance M

156
M
A
alang
asked in Data
geodatabase feature class alias

I'm reading a file geodatabase and need to grab the feature class alias. I don't see any way of doing this?

191
fmelizard
Contributor
geolassi
Contributor
geolassiContributor
asked in Data
Ignore Failed Readers when reading a Zip file with FME 2013 b13261

Hi! I'm trying to set up a workspace with three Readers: TAB, MIF/MID and Shape. I've published a parameter, which contains the path to a zip file. The zip file could contain either TAB, MIF/MID or Shape files. If the zip file has only Shape files, the TAB Reader fails and gives an error. I would like FME to ignore failing readers. Setting up the parameter Ignore Failed Readers to Yes doesn't seem to have an effect. BR, Lassi

90
sigtill
Supporter
S
seshu
asked in Data
Performance Issue is SDE geodatabase

Hi, I am using ARCSDE geodatabase as inputs to the workbench, from the input tables I need to extract the coordinates(x,y) values for point features and for linear linear feature i need to extract every vertex id's of the element(line segment) along with x, y coordinates of each vertex and "from junction element id" & "to junction element id" of the element. To extract the geometry information FME takes lot of time. Time consumption is the major hurdle in this project. It is the chalenging issue to succed in our project. Please help us that how to increase performance. Thanks in Advance, Seshu

135
S
Z
z77
asked in Data
Why do file geodatabase and SDE readers produce different fme_geometry types?

I have one very simple workbench that I am running against both SDE (9.3) and FGDB (10.0) sources. I noticed two different fme_geometry values for same type of objects. For the first one, i.e SDE 9.3, I have fme_geometry=fme_donut , but for the same features in FGDB 10.0 I have fme_geometry=fme_aggregate . Is this a "problem" of converting ESRI data from 9.3 to 10.0 or how FME interprets geometry? Because in case of fme_aggregate, FME is doing "additional" job of constructing donuts again: Calculating inside points Determining uppermost containment Constructing donuts from xxx points (Visible in log window)

240
Z
R
rvgeneug
asked in Data
PostGIS writer multipolygon issue

Hi, I have an existing multipolygon PostGIS table. The entry in the geometry_columns is multipolygon and there are constraints on the table (2d, multipolygon and SRS). 1. When trying to write some features from a shapefile reader, only the single part polygons are written to the table. The multipart polygons get following warning: Geometry might not be representable in requested form The allowed geometries parameter in the writer is set to "postgis_multipolygon". 2. In QGIS I can open the table and view the single part polygons that are written to the table, but the geometry column of the features is empty. Found some similar topics in the FME talk but these are not really solving my problem. Any ideas? Thx, Rob

280
R
C
charlie
asked in Data
Change Detector with Personal Geodatabase

I am using the Change Detector to compare changes between a feature class in SDE and a feature class in a personal geodatabase. I am running into a problem with the output from the Change Detector transformer when using the personal geodatabase feature class. I have tried to run this transformer comparing an SDE feature class with a shapefile and the output is what I would have expected. With the personal geodatabase feature class however I receive incorrect results. I am only comparing geometry changes and ignoring changes to attributes at the moment. If anyone could provide any guidance on this matter, then I would really appreciate it. Thank you!

100
C

Helpful Members This Week

Badge Winners

Show all badges

Popular Tags

Community Stats

31,140
Posts
118,062
Replies
38,759
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.