Raster tools - hackoregon/disaster-resilience GitHub Wiki

Loading raster data into Postgres/Postgis Requires:

• gdalinfo
• raster2pgsql
• psql

According to this site: https://duncanjg.wordpress.com/2012/11/20/the-basics-of-postgis-raster/ Use gdalinfo to get the projection & other info here's the command: gdalinfo CSZ_M9p0_pgv_site.tif > CSZ_M9p0_pgv_site.info

On that file, the SRID is 4152 GCS_North_American_1983_HARN According to this site: http://resources.esri.com/help/9.3/arcgisserver/apis/rest/gcs.html

(You could probably also use postgis to figure out the SRID, but I haven't looked at that yet)

Here's something about showing raster tables in QGIS but it's not helpful https://gis.stackexchange.com/questions/131923/visualising-a-raster-postgresql-table-in-qgis