Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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? What do other people use to move gis data into a database?

share|improve this question
    
I would suggest making this question Community Wiki, since it's "List of X" with no one right answer. –  JasonBirch Aug 9 '10 at 5:51
    
Good thought. Thanks. –  Jay Askren Sep 5 '10 at 3:57

5 Answers 5

up vote 10 down vote accepted

To import shapefiles into PostGIS, you can use QGIS PostGIS Manager Plugin. It's a GUI for for shp2pgsql command line function. If you want to load KML files, you'd first have to convert those to shapefiles. This is simple: Just open the KML file in QGIS and save it again as shapefile. If you have multiple KML files, you might prefer using OGR Converter plugin to convert whole folders at once.

share|improve this answer
    
+1 nice one (although I prefer using shp2pgsql directly). –  Adam Matan Aug 7 '10 at 19:48

As others have mentioned, there are many tools avaliable to perform these actions, from dedicated x2y style command-line utilities through high-end Spatial ETL tools.

I personally use, and love the power of FME by Safe Software. It has paid for itself many times over in increased productivity. If proprietary/un-free software is an option for you, it's worth checking out.

For open source GUI tools, I also have had good experiences using fdo2fdo by SL-King in a production task-specific scenario, and Jackie Ng's FDO Toolbox for quick translation between formats.

Talend's SpatialDataIntegrator and GeoKettle also both boast some impressive ETL capabilities with GUI designers, but I've never had the patience to get through their learning curves. Probably worth investigating if you need full ETL capabilities.

share|improve this answer

Not for all of these databases. As each before me said, there are many tools available, but each with it's own purpose. That is actually a good idea to further development!

share|improve this answer

QGIS and shp2pgsql (and they are FLOSS) are probably most popular for Postgres/PostGIS database as underdark already said. There are probably some FLOSS tools for MySQL and Oracle but i'm not familiar with those. But if you have access to some commercial tools such as AutoCAD Map (via FDO) or Safe FME, you can import any spatial data to almost any spatial database. Probably Manifold can do it also.

Also there is FDO Toolbox which can copy data and its properties from one source (shp for example) to another (MySQL, PostGIS, MSSQL etc.).

share|improve this answer

I'd give ogr2gui (screenshots) a try, which provides a graphical wrapper around OGR, arguably the most powerful vector conversion library. In the long run, you'd help yourself becoming familiar with a command-line tools in this area, because of the great flexibility in OGR that isn't exposed through a simple GUI wrapper.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.