Mixedbredie's Ghosts
  • Home
  • Contact
Subscribe
Tagged

open source

A collection of 4 posts

ogr2ogr: Oracle to PostGIS
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

  • Ross McDonald
Ross McDonald Nov 3, 2015 • 2 min read
ogr2ogr: PostGIS to PostGIS
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

  • Ross McDonald
Ross McDonald Nov 3, 2015 • 1 min read
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

  • Ross McDonald
Ross McDonald Oct 28, 2015 • 3 min read
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

  • Ross McDonald
Ross McDonald Oct 26, 2015 • 1 min read
Mixedbredie's Ghosts © 2023
Powered by Ghost