Changes between Version 35 and Version 36 of UserGuidelines/GIS/Data


Ignore:
Timestamp:
08/31/10 11:09:27 (11 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/GIS/Data

    v35 v36  
    9797
    9898== PostgreSQL management ==
    99  * Create a new spatially-enabled database:
    100 {{{
    101 createdb my_spatial_db
    102 createlang plpgsql my_spatial_db
    103 psql -d my_spatial_db -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql
    104 psql -d my_spatial_db -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql
    105 }}}
    10699 * Connect to Database (or use pgAdmin III GUI's PSQL Console on plugins menu)
    107100{{{
     
    112105{{{
    113106psql -d my_spatial_db -U username
    114 }}}
    115 * Add Spherical Mercator projection (check http://www.cadmaps.com/gisblog/?p=81):
    116 {{{
    117 INSERT into spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text) values (900913 ,'EPSG',900913,'GEOGCS["WGS 84", DATUM["World Geodetic System 1984", SPHEROID["WGS 84", 6378137.0, 298.257223563,AUTHORITY["EPSG","7030"]], AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]], NIT["degree",0.017453292519943295], AXIS["Longitude", EAST], AXIS["Latitude", NORTH],AUTHORITY["EPSG","4326"]], PROJECTION["Mercator_1SP"],PARAMETER["semi_minor", 6378137.0], PARAMETER["latitude_of_origin",0.0], PARAMETER["central_meridian", 0.0], PARAMETER["scale_factor",1.0], PARAMETER["false_easting", 0.0], PARAMETER["false_northing", 0.0],UNIT["m", 1.0], AXIS["x", EAST], AXIS["y", NORTH],AUTHORITY["EPSG","900913"]] |','+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs');
    118107}}}
    119108 * List Databases