[Qgis-developer] Re: srs.db epsg's added, shrinking?

[Tim Sutton]

Hi Richard / All

Gary and I originally loaded the srs.db using the postgis srs table.
The idea was to try to synchronise regularly against postgis srs table
(hence the fact that we have a number of different identifiers - srid
(pg), epsg id, srs_id (qgis)). Since you are now the maintainer of the
srs.db I welcome any initiatives you take (including vacuuming the db
as mentioned above) and assure you you wont be treading on anyones
toes :-)

One thing to note, srs_id's >  100000 are reserved for user defined
projections - as specified in qgis/src/core/qgis.h:

131   /** Magick number that determins whether a projection srsid is a
system (srs.db)
132    *  or user (~/.qgis.qgis.db) defined projection. */
133   const int USER_PROJECTION_START_ID=100000;

Regards

Tim


2008/4/13, Marco Hugentobler <marco.hugentobler at karto.baug.ethz.ch>:
> Hi Richard,
>
>  Thanks for providing a new version of srs.db . It is already commited to svn.
>
>  I think the shrinking filesize is because the database reorganises storage
>  after 'database cleanup'.
>
>
>  > There is a plan to use FrankW scripts for generating the
>  > parameters/epsg-list in the same way as is done for proj, postgis etc
>  > (https://trac.osgeo.org/qgis/ticket/1035).
>  > I think it would be fine to line up with those tools, but only if we do
>  > not offend somebody/maintainer who is normally building srs.db (or was
>  > it generated once by hand)?
>
>
> Yes, it would be good to automate the generation. Maybe Gary or Tim know how
>  the db was originally generated?
>
>  cheers,
>  Marco
>
>  Am Samstag 12 April 2008 15:23:37 schrieb Richard Duivenvoorde:
>
> > Hi Marco,
>  > here a new srs.db for commiting/testing:
>  > http://www.duif.net/srs.db
>  >
>  > I added the following EPSG's:
>  > 3328-3335
>  > 3120
>  > 3066
>  > in the db using http://sqliteadmin.orbmu2k.de/
>  > this tool also has the possibility to do a 'database cleanup'. But after
>  > doing that the srs.db shrunk from 3.3 Mb to 526 kb ??? Do people think
>  > that's ok?
>  > It's still working for me, but can other people please test (especially
>  > the new additions?
>  >
>  > There is a plan to use FrankW scripts for generating the
>  > parameters/epsg-list in the same way as is done for proj, postgis etc
>  > (https://trac.osgeo.org/qgis/ticket/1035).
>  > I think it would be fine to line up with those tools, but only if we do
>  > not offend somebody/maintainer who is normally building srs.db (or was
>  > it generated once by hand)?
>  >
>  > Richard Duivenvoorde
>
>
>
>
> --
>  Dr. Marco Hugentobler
>  Institute of Cartography
>  ETH Zurich
>  Technical Advisor QGIS Project Steering Committee
>


-- 
Tim Sutton
QGIS Project Steering Committee Member - Release  Manager
Visit http://qgis.org for a great open source GIS
openModeller Desktop Developer
Visit http://openModeller.sf.net for a great open source ecological
niche modelling tool
Home Page: http://tim.linfiniti.com
Skype: timlinux
Irc: timlinux on #qgis at freenode.net