I am performing analysis using line of sight's and followed a very useful blog post at http://davidrowley.blogspot.co.uk/2013/08/calculating-line-of-sight-with-postgis.html which detailed how to load in hgt raster files from http://www.viewfinderpanoramas.org/Coverage map viewfinderpanoramas_org3.htm into PostGIS.
Eseentially I ran raster2pgsql.exe on the hgt files in a directory to generate a sql file to import into my PostGIS database. The speed is great
I would now like to do the same as this but instead within the UK I would like to use the freely available OS Terrain 50 product available from https://www.ordnancesurvey.co.uk/opendatadownload/products.html. It appears to be available in 3 formats: [ESRI ® Shape (Contours): 1.1 Gb], [GML (Contours): 1.1 Gb], [ASCII Grid and GML (Grid): 162 Mb].
Could anyone explain the best (and hopefully free) tools/process I could use to take the OS terrain 50 dataset and generate a table in postGIS of rasters? Or at least provide a start as to which of the three formats to use and where to go from there?
We also have the issue of converting the dataset to lat long values rather than grid, although I do also have a simple (large) table of lat, long and z's already created that I could start with if that would be easier?
أكثر...
Eseentially I ran raster2pgsql.exe on the hgt files in a directory to generate a sql file to import into my PostGIS database. The speed is great
I would now like to do the same as this but instead within the UK I would like to use the freely available OS Terrain 50 product available from https://www.ordnancesurvey.co.uk/opendatadownload/products.html. It appears to be available in 3 formats: [ESRI ® Shape (Contours): 1.1 Gb], [GML (Contours): 1.1 Gb], [ASCII Grid and GML (Grid): 162 Mb].
Could anyone explain the best (and hopefully free) tools/process I could use to take the OS terrain 50 dataset and generate a table in postGIS of rasters? Or at least provide a start as to which of the three formats to use and where to go from there?
We also have the issue of converting the dataset to lat long values rather than grid, although I do also have a simple (large) table of lat, long and z's already created that I could start with if that would be easier?
أكثر...