[ gpsdrive ] Patches

Jan-Benedict Glaw jbglaw at lug-owl.de
Sat Dec 20 03:42:52 AKST 2008


On Sat, 2008-12-20 13:13:06 +0100, Sascha Silbe <sascha-ml-gis-gpsdrive at silbe.org> wrote:
> On Sat, Dec 20, 2008 at 12:46:56PM +0100, Guenther Meyer wrote:
> 
> > right, the spatial_ref_sys table is empty.
> Sounds like the database wasn't properly PostGIS-enabled. The last three 
> steps of the PostGIS installation instructions (to be repeated for each 
> database that should be PostGIS-enabled):
[...]
>  7. For a complete set of EPSG coordinate system definition 
> identifiers, you can also load the spatial_ref_sys.sql
>     definitions file and populate the SPATIAL_REF_SYS table.
> 
>     # psql -d [yourdatabase] -f spatial_ref_sys.sql
> 
> 
> The last step populates the spatial_ref_sys table. The mentioned SQL 
> files are in /usr/share/postgresql-8.3-postgis on my (Debian) system.

Very right. In addition,
http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/900913.sql
should be added, too.

MfG, JBG

-- 
      Jan-Benedict Glaw      jbglaw at lug-owl.de              +49-172-7608481
Signature of:               http://www.eyrie.org/~eagle/faqs/questions.html
the second  :
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.gpsdrivers.org/pipermail/gpsdrive/attachments/20081220/961e9607/attachment.bin>


More information about the GPSdrive mailing list