[ gpsdrive ] Patches

[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)

Problem:

gis=> select * from spatial_ref_sys;
 srid | auth_name | auth_srid | srtext | proj4text
------+-----------+-----------+--------+-----------
(0 rows)


-- 
Paul Martin <pm at debian.org>
-------------- 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/5920bd80/attachment.bin>