gis

Now that PostGIS 2.0.0 is finally out, the number one question people have (or should have) is how to upgrade your PostGIS install to the latest 2.0. We've seen a few casualities on the PostGIS users list of people who did it wrong partly because how you do it has changed a bit. Some ground rules, if you are running 1.x, you MUST do a hard-upgrade and if you go the quick and dirty hard-upgrade path, you MUST run the postgis_upgrade_20_minor.sql and rtpostgis_upgrade_20_minor.sql (if you installed raster support from an early 2.0 build or wktraster). If you are running an alpha of PostGIS 2.0, you can possibly get by with a soft-upgrade with caveats. Now for the long story.

• Figure out what you are running by doing a: SELECT postgis_full_version();
• If you are running PostGIS 2.0.0 beta2 (technically you could do a micro upgrade if you have alpha1 or above but there were some operator changes with geography that require a dump/restore to take advantage of) or above follow the micro upgrade route otherwise Please follow one of the hard upgrade routes. There are a few upgrade routes in fact, so choose which ever seems less scary.

One of the new features I'm pretty excited about is the new postgis gui batch features that allows not only for multiple import of shape files, but also multiple export of shapefiles. It will work fine with your postgis 1.5 databases as well. We have windows standalone gui binaries at http://www.postgis.org/download/windows.

Is this cool or what? Here are some screen shots with it loaded as a pgAdmin plugin.

Import Tab

Export Tab

Add Table Hold the ctrl key to select multiple tables/views

Supports multiple geometry columns If your table has multiple geometry columns have option of changing to different one

Export Export the shapefiles to a folder w option of creating new subfolder