[ gpsdrive ] Patches

[Jan-Benedict Glaw]

On Sat, 2008-12-20 01:04:48 +0000, Paul Martin <pm at debian.org> wrote:
> On Fri, Dec 19, 2008 at 07:27:55PM +0100, Jan-Benedict Glaw wrote:
> > > the best way would be reading the used projection from the database, but that 
> > > has to be done by someone who knows how to get this information out of the 
> > > postgis database.
> > 
> > gis=> select proj4text from spatial_ref_sys where srid=(select srid from geometry_columns where f_table_name ='planet_osm_point');
> >                                                     proj4text                                                     
> > ------------------------------------------------------------------------------------------------------------------
> >  +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
> > (1 row)
> 
> Problem:
> 
> gis=> select * from spatial_ref_sys;
>  srid | auth_name | auth_srid | srtext | proj4text
> ------+-----------+-----------+--------+-----------
> (0 rows)

Solution: Install the PostGIS extensions correctly and completely. One
of the two SQL files wasn't included. (And for the Google-Projection,
aka SRID:900913), there's a specific file in the osm2pgsql directory
in OSM SVN. Heck, doesn't the function adding a GEOMETRY column
*enforce* the calles SRID to be present in the spatial_ref_sys table?

MfG, JBG

-- 
      Jan-Benedict Glaw      jbglaw at lug-owl.de              +49-172-7608481
 Signature of:                      http://perl.plover.com/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/af81949c/attachment.bin>