[Gvsig_english] Updating EPSG database

[Juan Lucas Dominguez Rubio]

Hello, Ben.
 
I don't know how to do that, but I suggest to add EPSG:900913 and EPSG:3785 as synonyms of EPSG:3857 (if they were not declared) because I have seen them in some map servers too (you probably knew about this though)
 
Regards,
 
Juan Lucas Domínguez Rubio
---
Prodevelop SL, Valencia (España)
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 
---

________________________________

De: gvsig_internacional-bounces at listserv.gva.es en nombre de Benjamin Ducke
Enviado el: mié 21/04/2010 16:57
Para: Users and Developers mailing list
Asunto: [Gvsig_english] Updating EPSG database



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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100422/fcb0e59e/attachment.htm