Elevation

From ecology
Revision as of 10:51, 28 March 2013 by Judy (talk | contribs) (Usage)
Jump to: navigation, search

ELEVATION

Get the elevation for specific point on Earth. There is a high resolution (srtm3) and low resolution (srtm30) dataset available. The srtm_getvalue will first try the high-resolution dataset for the specific location and the low-resolution if the first did not give a result.


Usage

The function elevation.srtm_getvalue extracts the land surface elevation (m) from a digital elevation model (DEM) stored in the database for a given set of coordinates (longitude and latitude) which is parsed as text in the function. The function can be used in different ways, shown below.

 select elevation.srtm_getvalue(pointfromtext('POINT(<longitude> <latitude>)',4326))

i.e.


 select elevation.srtm_getvalue(pointfromtext('POINT(6.99666 49.504)',4326))
  
 or
  
 select elevation.srtm_getvalue (pointfromtext('POINT(86.93333 27.983333)',4326));


To use only high- or low resolution the following can be used resp.

 select elevation.srtm3_getvalue(pointfromtext('POINT(6.99666 49.504)',4326)) -- high res
 select elevation.srtm30_getvalue(pointfromtext('POINT(6.99666 49.504)',4326)) -- low res


If a user would like to access the elevation data for a series of locations, than the location field can be used, which is a composite, text field including longitude and latitude of each GPS point, do not run this query for very large datasets without testing first on a subset of data.

 SELECT device_info_serial, date_time, latitude, longitude, elevation.srtm_getvalue("location") AS DEM
 FROM gps.uva_tracking_data 
 WHERE device_info_serial = <device_info_serial> 
i.e.


 SELECT device_info_serial, date_time, latitude, longitude, elevation.srtm_getvalue("location") AS DEM
 FROM gps.uva_tracking_data 
 WHERE device_info_serial = 60
  
 

On borders between cells the south and/or east cell is selected, also between tiles!


Notes :


The 27 tiles for srtm30 are placed in one table. The 900 tiles from srtm3 are classified according to the srtm30 classification and distributed to 27 tables.

All tiles have been redistributed into rasters of 60 * 60

Links

Credits

This postgresql adaptation of the SRTM3 v3 is made by F.P. Sluiter. The original 6000*6000 tiles are retiled to 60*60. New tiles containing only no_data values were removed. Dataset is subdivided in 27 tables that cover the globe.

april 2008, University of Amsterdam

Please put the following reference in publications:

"F.P. Sluiter, University of Amsterdam, april 2008, SRTM3 postgresql adaptation ; based on Jarvis A., H.I. Reuter, A. Nelson, E. Guevara, 2006, Hole-filled seamless SRTM data V3, International Centre for Tropical Agriculture (CIAT), available from http://srtm.csi.cgiar.org."

Original documentation: PROCESSED SRTM DATA VERSION 3

The data distributed here are in ARC GRID, ARC ASCII and Geotiff format, in decimal degrees and datum WGS84. They are derived from the USGS/NASA SRTM data. CIAT have processed this data to provide seamless continuous topography surfaces. Areas with regions of no data in the original SRTM data have been filled in using interpolation methods. A full technical report on this method is in preparation.


DISTRIBUTION

Users are prohibited from any commercial, non-free resale, or redistribution without explicit written permission from CIAT. Users should acknowledge CIAT as the source used in the creation of any reports, publications, new data sets, derived products, or services resulting from the use of this data set. CIAT also request reprints of any publications and notification of any redistributing efforts.

NO WARRANTY OR LIABILITY

CIAT provides these data without any warranty of any kind whatsoever, either express or implied, including warranties of merchantability and fitness for a particular purpose. CIAT shall not be liable for incidental, consequential, or special damages arising out of the use of any data.

ACKNOWLEDGMENT AND CITATION

We kindly ask any users to cite this data in any published material produced using this data, and if possible link web pages to the CIAT SRTM website (http://srtm.csi.cgiar.org).

Citations should be made as follows:

Jarvis A., H.I. Reuter, A. Nelson, E. Guevara, 2006, Hole-filled seamless SRTM data V3, International Centre for Tropical Agriculture (CIAT), available from http://srtm.csi.cgiar.org.