ETL (extract, transform, load)
1
vote
0answers
40 views
Geokettle transformation for FileGDB to SHP
I want to transform FileGDB layer to Shapefile on Geokettle. Firstly i added OGR Input and than i added a Shapefile Output. And i entered parameters shown on the screenshot but i got errors for ...
1
vote
1answer
96 views
tools and ETLs for migrating data benchmarking - from shapefile to SQL SERVER
i need to migrate my shapefiles to my database SQL SERVER, and i don't know what's the best tool or ETLs to choose, i already tried FME Desktop and i succeded to load the shapefiles on my db, but ...
1
vote
1answer
133 views
Experiences with ArcGIS Data Interoperability
In order to import/extract data from tons of DWG files, I'd like to know experiences with ArcGIS Data Interoperability, and its strong points versus FME or GeoKettle.
Thank you very much.
9
votes
2answers
359 views
Migration from ArcSDE (SQL Server) to PostGIS (PostgreSQL)
We've got all the geospatial information of our company within an ArcSDE Database (over SQL Server):
points (locations of the antennas),
lines (elevation, rivers),
polygons (protected areas, ...
3
votes
1answer
406 views
Is Data Interoperability Extension for ArcGIS Server 10 required to extract data in .dgn format?
I am trying to create a Geoprocessing Task in my .mxd to in order to extract data to .SHP and .DGN formats which will be utilized in a data extraction tool for a web application.
Right now, there is ...
5
votes
4answers
2k views
Ways to transform from DWG/DXF to GIS (Experiences are welcome)
I've got tons of DWG/DXF files with information (in several layers) dealing with:
Contour lines and elevation (lines)
positions of antennas (points)
protection areas (polygons)
administrative ...
7
votes
4answers
1k views
Is there any safe fme alternatives?
Just wondering if there is any open source solution which comes close to safe FME?
I would like to integrate it into my workflow, but it´s just another few thousand which my employer has to give out ...
1
vote
2answers
411 views
Using FME to Parse An Attribute Field
I have a table that contains a field with street names. Each street name ends with the street type. Fore example, Washington St, Happy Valley Rd, Redstone Dr. I need to extract the last part of the ...
3
votes
0answers
65 views
Determine the Degree of Data Lossiness when Converting Data
I'm working through some of the ESRI tutorials on Data Interoperability and it briefly mentions the issue of data conversion being a lossy process.
Some questions that come to mind are:
What is ...
19
votes
5answers
4k views
How to migrate GDB data into PostGIS without ESRI apps?
Can you tell me how I can load geodatabase data into PostGIS without having to install ESRI apps? The solution I found online talked about using ArcGIS to convert GDB to SHP and then importing SHP to ...
16
votes
9answers
3k views
Permanently reorder fields in data (shp, gdb)
If I have a shapefile or geodatabase featureclass that has fields that I want to permanently reorder, is there a tool, script, or utility that will help me quickly accomplish this task?
Generally I ...
5
votes
2answers
341 views
Data ETL workflow optimization
I have a legacy workflow that I would like to optimize and automate (at least partially). The current workflow goes like this. I receive a MS Access .mdb file containing a single table. This table ...
4
votes
2answers
438 views
Is it possible to set the output of a spatial etl tool in model builder?
I am using the interoperability extension and building spatial ETL tools, but I can't seem to specify the output location of the ETL tool so it's impossible to use this dynamically.
Has anyone ...
12
votes
3answers
795 views
Centralizing shapefile data into database
I've got hundreds of shapefiles from various different GIS projects that I want to start consolidating into a single database platform, currently attempting this with Postgres / PostGIS.
Hardly any ...
19
votes
2answers
2k views
Spatial ETL comparisons
I am hoping some of you experts out there can list the pro's and con's of various spatial ETL (extract, transform, load) tools. If you have used these items listed here (or add your own), please ...
9
votes
5answers
991 views
What tools are available for uploading gis data to a database?
I would like a nice graphical tool that allows me to take standard gis data such as shp files and kml files and upload them to a database such as PostGIS, MySql or Oracle. Are there any such tools? ...
