postgis ogr2ogr: Oracle to PostGIS Traditionally^ exporting from Oracle to PostGIS involved an intermediate step Oracle to Shapefile and then Shapefile to PostGIS. But this means that field names longer than 10 characters in Oracle get truncated in the conversion to Shapefile. And using the QGIS or PgAdminIII shp2pgsql gui has no easy way to
postgis ogr2ogr: PostGIS to PostGIS I recently^ had to update a live database with updated tables from a staging database and then continue to update on a daily basis. As it is a regular update and the source and destination tables won’t change I generated a text file with a list of layers to
gis Geeking out on a GIS A couple of months ago Paul Wilson asked a question on KnowledgeHub about the best way to organise data in a GIS. Well, that got the GIS folk out of their data loading torpor and provided some interesting discussion. It highlighted the many different approaches but all seemed to agree
gis QGIS 2.12 Lyon QGIS 2.12 Lyon has just been released with a ton of new features. I particularly like the new rule based labeling options giving fine grained control. The change log has a very comprehensive list of all the other new features. Download the latest version for your Windows, Mac or
