Database Reference
In-Depth Information
This is all that needs to be done with the PRISM rasters for now.
Now,let's import anSRTMraster.The SRTMraster isfromthe
Shuttle Radar To-
pography Mission
(
SRTM
)thatwasconductedbyNASAJetPropulsionLaboratory
in February, 2000. This raster and others like it are available at
Change the current directory to the SRTM directory.
> cd C:\postgis_cookbook\data\chap05\SRTM
Makesureyouspot-checktheSRTMrasterwith
gdalinfo
toensurethatitisvalid
andhasavaluefor
Coordinate System
.Oncechecked,importtheSRTMraster
into the
chap5.srtm
table.
> raster2pgsql -s 4326 -t 100x100 -F -I -C -Y
C:\postgis_cookbook\data\chap5\SRTM\N37W123.hgt
chap5.srtm | psql -d postgis_cookbook
Weusethesame
raster2pgsql
flagsfortheSRTMrasterasthoseforthePRISM
rasters.
We also need to import a
shapefile
of San Francisco provided by the City and
County of San Francisco; it is available at:
We will use SanFrancisco's boundaries for many of the follow-up recipes.
> cd C:\postgis_cookbook\data\chap05\SFPoly
> shp2pgsql -s 3310 -I
C:\postgis_cookbook\data\chap5\SFPoly\sfpoly.shp
chap5.sfpoly | psql -d postgis_cookbook