Changes between Version 14 and Version 15 of RenderingOsmData

Timestamp:

Jun 28, 2010, 6:30:12 AM (14 years ago)

Author:

tbonfort

Comment:

--

RenderingOsmData

@@ -34 +34 @@
 ==== Preparing the postgis database ====
 
-We'll assume that the data will be imported into a database named {{{osm}}}. We will also add the 900913 crs, and grant access to a {{{www-data}}} user.
+We'll assume that the data will be imported into a database named {{{osm}}}. We will also grant access to a {{{www-data}}} user.
 On a debian-ish system, this goes like:
 
@@ -51 +51 @@
 }}}
 
-And run these two commands:
-
-{{{
-INSERT INTO spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text)
-VALUES (900913, 'spatialreference.org', 900913,
-  'PROJCS["unnamed",GEOGCS["unnamed ellipse",DATUM["unknown",
-   SPHEROID["unnamed",6378137,0]],PRIMEM["Greenwich",0],
-   UNIT["degree",0.0174532925199433]],PROJECTION["Mercator_2SP"],
-   PARAMETER["standard_parallel_1",0],PARAMETER["central_meridian",0],
-   PARAMETER["false_easting",0],PARAMETER["false_northing",0],
-   UNIT["Meter",1],
-   EXTENSION["PROJ4","+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 +wktext  +no_defs"]]',
-   '+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 +wktext  +no_defs');
-
+And run create the www-data user:
+
+{{{
 create user "www-data" with password 'www-data';
 }}}
 
-now add the 900913 projection to your epsg database (usually in /usr/share/proj/epsg):
+eventually add the 900913 projection to your epsg database if it isn't already present (usually in /usr/share/proj/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
@@ -81 +68 @@
 
 {{{
-# osm2pgsql -d osm -p osm -s  -C 1024 /path/to/australia.osm.bz2
+# osm2pgsql -l -d osm -p osm -s  -C 1024 /path/to/australia.osm.bz2
 }}}