[ gpsdrive ] Patches

[Guenther Meyer]

Am Samstag 20 Dezember 2008 schrieb Paul Martin:
> 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)
>
that's the solution. thanks!

> Problem:
>
> gis=> select * from spatial_ref_sys;
>  srid | auth_name | auth_srid | srtext | proj4text
> ------+-----------+-----------+--------+-----------
> (0 rows)
right, the spatial_ref_sys table is empty.
but as its content seems to be some kind of "standard" (a list of many 
possible projections), it should be not to hard to get those data.
afair someone on the list recently mentioned a source for this...

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.gpsdrivers.org/pipermail/gpsdrive/attachments/20081220/71b07c79/attachment.bin>