[Gvsig_english] Updating EPSG database

Benjamin Ducke benjamin.ducke at oxfordarch.co.uk
Wed Apr 21 16:57:27 CEST 2010


Hi all,

I have noticed that the EPSG database snapshot that ships
with the current extCRS (gvSIG 1.9) is a little old. 
It contains some deprecated definitions and is lacking some 
useful new ones (e.g. 3857 for GoogleEarth like CRS).

So I would like to update the EPSG data. I have downloaded
the current EPSG database (PostgreSQL code) from www.epsg.org.

Looking at extJCRS/config/db_epsg.script, I have the following
questions:

1) When and by what Java class is this script run to create
the HSQLDB with the EPSG data?
2) Where is the HSQLDB database stored once gvSIG is runnning?
In memory? In a file somewhere in the gvSIG installation folder?
3) All identifiers (table names) etc. in db_epsg.script are
UPPERCASE, whereas in the SQL statements from epsg.org they
are all lowercase. I have read that HSQLDB implicitly converts
all identifiers to uppercase. So can I just use the epsg.org SQL
code for PostgreSQL or do I have to convert things to uppercase
manuall?
4) Do I understand right that I have to merge the three
SQL files *Tables*,*FKeys* and *Data* in that order to get
db_epsg.script?

Thanks for any help,

Ben


------
Files attached to this email may be in ISO 26300 format (OASIS Open Document Format). If you have difficulty opening them, please visit http://iso26300.info for more information.



More information about the Gvsig_internacional mailing list