Hot answers tagged etl
9
I do it all the time for my clients.
Dump your data to FileGDB or Shapefiles then execute the following command:
For ESRI Shapefiles:
ogr2ogr -f "PostgreSQL" PG:"dbname=mydbname user=postgres" myshapefile.shp
For FileGDB:
ogr2ogr -f "PostgreSQL" PG:"dbname=mydbname user=postgres" myFileGDB.gdb
For FileGDB, you need to make sure that the FileGDB ...
4
It seems to me that the main problem for you is to introduce some order to your tons of DWG/DXF files with information (in several layers).
Regardless of choosing software/tool I can recommend you to describe your data. Here is some thoughts:
You should develop some kind of unique codes for all types of your features. It can be one attribute or several or ...
3
autocad map 3d will easily geo-reference your dwg/dxf files and allow conversion to 12 gis formats.
Unless you add FME desktop also (FME extsion for ArcGIS).
Then with FME extended to arcmap and autocad you have all ~275 formats.
But doing it through map3d you have access to some particularly useful tools.
(i.e. select by layer, color, linetype, or even ...
2
It sounds like you have some major batch processing and therefore, I would be inclided to script this. Doing this all by hand might be feasible but a pain. At least with a script, if you muck something up you can just correct the script and re-run. Also, you have a chance to unify a lot of the non-standard naming etc by using regular expressions and ...
2
Arcgis Data Interoperability Extension (ADIE) "is" FME.
That is to say. Esri has implemented the FME engine into their extension.
FME Desktop for ArcGIS is a product sold by Safe software which adds more functionality to ADIE and can be "extended" to ArcGIS.
Extended is a term that Safe Software uses to describe hooking or linking the software together.
...
1
You can use the Feature Class to Feature Class (Conversion), Feature Class to Shapefile (Conversion), or Copy Features (Data Management) tools to convert to shapefile.
You can use the Export to CAD (Conversion) tool to convert to DGN. This does not require the Data Interoperability Extension.
However DGN is not a simple format relative to shapefiles, so if ...
1
To convert your CAD files to GIS, you'll need to add georeference information to your cad files. If your CAD files are in some recognizable coordinate system, you can assign those to your files, otherwise you'll have to 'manually' georeference the CAD file to translate the local coordinates to a projected coordinate system.
I found this nice guide [PDF] at ...
1
The esri file geodatabase API only works with file geodatabases created using 10.x - the older versions will not work with GDAL, QGIS or anything else that depends on the open file geodatabase API. The old Personal Geodatabases depend on MS Access and there are readers and code available.
If you have a 10.x file geodatabase you can do this with a single ...
1
Open the .mdb file in MS Access and reorder the fields using drag and drop in 'Design View'
Though ESRI discourages editing a database in Access
ESRI link
Only top voted, non community-wiki answers of a minimum length are eligible
