Skip to main content

Data

Using readers and writers to extract and load data.

  • 6,973 Posts
  • 25,687 Replies
6973 Posts
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
B
bernard
asked in Data
Cannot access tables to Oracle DB with Reader. But can connect with Transformer OracleQuerier

Hello As the title says I cannot access the tables in the oracle Spatial DB (10.2.0.4.0) with the add Reader command. The strange thing is, that with the transformer "OracleQuerier" I have access to the tables in the DB. I suspect it is because with the transformer, i can choose which version of Oracle (9i/10g/11) i have. With the reader I cannot. Do you have any ideas? Do you need more information about my specs? I use FME 2011 SP4 on WIN32 The connection parameters are correct as i can get a connection to the Oracle DB with SQL Manager, ArcMAP (with add sql layer) and AutoCAD MAP. And as I mentioned with the OracleQuerier as well. Excuse my english Regards Bernard

74
B
M
marks
asked in Data
Google Fusion Tables API is changing and this will affect FME Google Fusion readers & writers

Google has announced that the Google Fusion Tables SQL API is being deprecated and replaced by the Google Fusion Tables API v1.0. This will occur on or around 14 January 2013. The main API change is the move to OAuth 2.0 This means that existing FME Google Fusion readers & writers will not be able to access your Google Fusion tables. All new FME 2013 Versions (after build 13261) will support the new OAuth 2.0 authorisation. If you have problems connecting to your Google Fusion tables please contact Safe support

40
fmelizard
Contributor
M
morten
asked in Data
PostGIS writer

Hi there I have looked at the FME workbench help for the postgis writer and in the old FME talk group, but haven't found a clear answer to my issue... How do i define the following using the postgis writer in FME Workbench 2012 SP3: - Database name - Schema name - Table name - Encoding The same question when using fanout by attribute.

210
M
I
irfan
asked in Data
OSM file to ArcGIS File GeoDB

Hi All, I have some problems when I try to convert OSM file to ArcGIS FileGeoDB. These problems are mainly due to invalid or duplicate field name in the OSM file. When I convert the same OSM file to Shape File everything is fine. So my question is when Shape File export can find and remove that kind of errors why FileGeoDB (API /Arc Object) export cannot find and fix that kind of errors in the field name? Can someone explain me a way to automatically find/fix these problems, rather than run the workbench until it fails and then fix them manually? Is there something available in FME like ValidateFieldName in ArcGIS? I am using FME 2012 64bit on Windowx 7 64bit.

140
davideagle
Contributor
rknight
Contributor
rknightContributor
asked in Data
Using XMLUpdater to change waypoint names in .GPX file

Is XMLUpdater the best transformer to edit multiple waypoints in a .GPX file. I need to change hundreds of unique waypoint names in a .GPX file to a few names based on a alpha character in the those original way point names. For example: <name>002C34</name> needs to become <name>C</name> or <name>003B33</name> become <name>B</name>

600
takashi
Influencer
dos_gis
Contributor
dos_gisContributor
asked in Data
points from coords in a text file

Hi, I’m trying to generate points from a text file, using Lat & Long values. StringSearcher seems to be the right transformer but I’m having trouble figuring out the proper expression to use. Any help would be appreciated. The contents of the text file: From: bcticket@telus.net Sent: Wednesday, January 09, 2013 12:58 PM To: GIS Subject: Request 2013021114 01/09/13 12:57:20 BC ONE CALL NOTICE OF INTENT TO EXCAVATE REASON CODE: ROUTINE LOCATE Ticket No: 2013021114 Sending to:SQUISH01 Code:SQUISH01 Sequence:0002 Original Call Date: 01/09/2013 Time: 12:53:02 Op: 442 Transmit Date: 01/09/2013 Time: 12:57:20 Op: 442 Work To Begin Date: 01/14/2013 Time: 12:53:00 Company :HOMEOWNER Contact Name:Test Contact Phone:(111)111-1111 Cell Phone: Pager : Alt. Contact: Alt. Phone: Fax Phone: Email:gmmorgan@shaw.ca Place :SQUAMISH Comments : Address At/From:2114 Address To: Street: RIDGEWAY CRES Nearest Intersecting Street : GARIBALDI WAY Second Intersecting Street : Latitude: 49.74068850 Longitude: -12

80
dos_gis
Contributor
D
dr_ysg
asked in Data
PNG Palette

I have a large NITF image (grey scale, with palette). In the course of a number of transofmrations (reprojection, etc.) it gets converted to an RGBA (the palette is resolved). Now I want to save it as a PNG. I do not need all the RGB bands. I see that PNGRASTER has a grey scale, and also a pallette option. Is there a transform to shrink the RGBA to a Grey Scale plus Alpha PNG image (and pallette might also be nice). The goal is to get the disk size smaller. Just compressing at level 6 is resulting in a 400% explosion from the original NITF.

61
davideagle
Contributor
T
toolward
asked in Data
Can't see my Oracle columns

I want to be able to see my Oracle columns in Workbench. When I connect a shape reader to a transformer, I can see the source columns. But I can't see the Oracle columns the same way. I could use the Attribute Connections window, but I'd like to use the visual tools.

50
C
P
pka
asked in Data
FME Server 2012 with Smallworld 4.2/ 422 translator - dll missing?

We are currently onsite doing a translation. Smallworld 4.2 (with 422 translators) with FME SERVER 2012 The translation uses FME.exe and it works with FME Desktop 2012, we tested the same with FME SERVER 2011. But this doesnt work with FME Server 2012. Is there some special setup? we didnt find any sworldswaf*.dll in FME Server directory. we renamed the Fmf file. This is urgent.

110
P
H
hendrik
asked in Data
Write Microstation DGN Priority

Hi, is there any way to write the DGN Priority using FME? Regards, Hendrik

440
H
J
jpm
asked in Data
Setting output file name for .xyz to las translation

Hello. I have several hundred .xyz files that I want to translate to las/laz files. Using a reader-writer (Point Cloud XYZ- LAS) does the job: Inputs are something like 100903_120345.xyz, 100903_120736.xyz but the output files have names like POINTCLOUDXYZ.las, POINTCLOUDXYZ_1.las and so on What I would like to happen is for the output files to inherit the base name of the input so that the outputs would be named 100903_120345.las, 100903_120736.las etc. I'm very new to FME so apoligies for this simple question. Thanks Justin.

113
J
G
graeme
asked in Data
Creating a .prj file with the Shape writer

Does anyone know the correct way to ensure a shapefile is always created with its accompanying .prj file during the ESRI Shape writer process? For the type of translations I'm doing, I'd ideally like to have FME output the same projection file as the input for shape-to-shape conversion, i.e. create .prj files dynamically based on the input files, not from a hard-coded script parameter. I searched for but couldn't find any documentation about how/if a .prj file is created when writing to Shape. From mapping file translations, sometimes this projection file is created alongside the core shapefile components and sometimes not. Next week I am going to test a hunch that setting the COORDINATE_SYSTEM directive (or equivalent workbench parameter) for the writer allows FME to output a .prj file, while having it not set results in no projection file.

1750
G
C
charlotte_t
asked in Data
Read Autodesk AutoCAD Map 3D Object Data from a dxf file

Hi, I'm having trouble to read data from a dxf file. This file has been built with autocad map 2012. It has one table associated to one layer feature types. It does'nt seem to be simple xdata because I can't read it by just using an "attribute exposer". I also tried to add my source data as "Autodesk AutoCAD Map 3D Object Data" but I stil can't read it. What do I need to do? Thanks for your help. Charlotte

150
C
C
charlotte_t
asked in Data
Add xdata to an existing DWG file

Hi, I have - 16 dwg that are our original workfiles without xdata - a DXF file which is the result of a FME treatment and which contains xdata I created ID for several layers and I need to retreive this IDs so when we will update our workfiles, and I will pass them into my treatment to make a new DXF file, my IDs for existing features won't change. I have to retreive the xdata "ACCESS1_ID" from the DXF to put it, as XDATA in my orginal files (DWG). I have a way to merge correctly the DXF with the original files thanks to a block attribute I have kept as a xdata in the DXF. But I don't manage to obtain a file which would be exactly the same as my workfiles (DWG) with adding xdata in it. Thank you for your help. Charlotte

540
C
J
jac007
asked in Data
Selecting an existing AOI from an ESRI file geodatabase as a source parameter.

How can I publish a feature class in an ESRI file geodatabase as a source parameter rather than just the file geodatabase to use as an AOI? I am using FME to create contours from DTED using an existing AOI as my CLIP. However the exisiting AOI will not always come from the same feature class or even database. So I need the user to be able to select both the source database and/or feature class within it.

80
davideagle
Contributor
fmelizard
Contributor
fmelizardContributor
asked in Data
GeoTIFF for GeoServer

I want to create an inner tiled GeoTiff with internal Overlays for use with GeoServer. I know FME can do the inner tiling, but can it do the internal overlays too and if so, how? Thanks

350
fmelizard
Contributor
mhab
Contributor
mhabContributor
asked in Data
FME-Server/Engine: Output directory

Hello If I run a workspace on FME Server through an FME-Engine, and - if this workspace writes some output, - and the output is specified without a path e.g. write DXF to "test" ... --> then the output is written to the FME-Server Repository directory, which is NOT where I prefer to get the result. Is there a way to specify the working dir for the engine at runtime, like with a parameter ? I found FME_WORKING_DIR in the engine configuration, but it seems to be static. Thanks for any advice Michael

250
sigtill
Supporter
T
timst_rk
asked in Data
Difference in Oracle non-spatial reader and a joiner

Hi, I have problem with the joiner-transformer. When joining tables from an Oracle database all unicode characters are not handled correct. Ex æøåÆØÅ. But if I create another reader-import-type with the same table it handles the unicode characters correct. Is there a setting on the joiner-transformer that i have missed? Or is it a bug? (I'm using fme 2012SP4 right now but the problem was also present the previous version I used. I think it was v2010.) /Tim

80
fmelizard
Contributor
P
pals
asked in Data
FME2010 SP4 and ESRI ArcGIS licensing problem

Hi, I have runned into some strange behaviour with FME Desktop and ArcGIS. My ArcGIS licences are 1 ArcInfo, 15 ArcEditor and 15 ArcView hosted on a license server. Under Citrix I set the variable ESRI_SOFTWARE_CLASS=Viewer as a default environment variable. This works fine, and for example a "double-click" on a MXD icon will launch ArcView. Given this as the default behaviour I provide users with separate startup icons for ArcEditor and ArcInfo (ESRI_SOFTWARE_CLASS=Editor or Professional respectively). But, when I launch FME and start an ETL-workflow which requires an ArcGIS license, then FME try to launch ArcInfo. Seems like ESRI_SOFTWARE_CLASS=Viewer (i.e ArcView) is not honoured by FME. The same seems to be the case for local installs. FME honours license settings from the ArcGIS Administrator and not what i set by ESRI_SOFTWARE_CLASS. Anyone knows a way to force a specific ArcGIS licensetype to be used by FME? best Pål Herman Oslo, Norway

190
fmelizard
Contributor
J
jerrod
asked in Data
'Subtract' one line feature class from another

Thre should be a simple solution for what I am trying to do, but for some reason I can't think of it. I have two polyline feature classes. Feature Class 'A' is made up of segments of the Feature Class 'B'. However, not all segments of a line from 'B' exist in 'A'. Some segments are missing. What I need to do is compare the two to find out what is missing in 'A'. Basically just looking for a "subtract" feature for lines. I know how to do this for polygons, but not for lines. Any ideas would be much appreciated! I feel like it is really simple and I'm just overlooking the easy solution!

929
M
R
rob1980
asked in Data
Specifying SQLNET.ORA file

Hi! Has anyone ever had the need to specify which sqlnet.ora file FME uses? Unfortunately, I need to use 2 different ones to access various Oracle databases and FME does not like the one I use mainly. I have tried hacking about with both version to merge them but then I have FME not working or TOAD not working, or in some cases neither! Any suggestions would be great as I am fed up having to keep swapping over :(

280
R
H
hpras
asked in Data
FME Desktop 32bit and 64bit on the same machine

Can I have 32bit and 64bit versions of FME Desktop on the same machine. I need to use some of the datatypes for some projects, but need >4GB memory space for tothers. Thanks H

250
mhab
Contributor

Helpful Members This Week

Badge Winners

  • Student (Grey)
    srperdomohas earned the badge Student (Grey)
  • I Dig JSON
    takashihas earned the badge I Dig JSON
  • Integrate Data with the FME Platform Training
    mramsayhas earned the badge Integrate Data with the FME Platform Training
  • Teacher (Grey)
    aaannashas earned the badge Teacher (Grey)
  • Welcome Back
    mseagren839has earned the badge Welcome Back
Show all badges

Popular Tags

Community Stats

31,148
Posts
118,080
Replies
38,766
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.