[Gvsig_english] Updating EPSG database

[Benjamin Ducke]

OK, Thanks Fran, I will try to figure it out based on the
information you gave me.

Cheers,

Ben

----- Original Message -----
From: "Francisco José Peñarrubia" <fpenarru at gmail.com>
To: "Users and Developers mailing list" <gvsig_internacional at listserv.gva.es>
Sent: Thursday, April 22, 2010 11:08:46 AM GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna
Subject: Re: [Gvsig_english] Updating EPSG database

Hi Ben.

I don't know too much about this issue, but maybe I can give some tips.
I think EPSG database is created by Geotools. You can have a look to 
this class:

org.geotools.referencing.factory.epsg.DefaultFactory

Anyway, there is some code inside extJCRS in order to modify this 
database with some projections. (Initialize method).
You can search also in method getDataAndUpdate from 
extJCRS\src\org\gvsig\crs\gui\panels\wizard\MainPanel.java.
And about where is the database, I found some info in libJCRS, look to 
this class:

libJCRS\src\es\idr\teledeteccion\connection\EpsgConnection.java

Hope it helps....

Cheers.

Fran Peñarrubia
www.scolab.es

Benjamin Ducke escribió:
> 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.
>
> _______________________________________________
> Gvsig_internacional mailing list
> Gvsig_internacional at listserv.gva.es
> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>   

_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at listserv.gva.es
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional



------
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.