gvSIG feature requests #2306

Update the EPSG database

Added by Antonio Falciano about 10 years ago. Updated almost 10 years ago.

Status:Closed% Done:

100%

Priority:NormalSpent time:-
Assignee:Joaquín del Cerro Murciano
Category:CRS
Target version:2.1.0-2239-testing
gvSIG version:2.1.0 Add-on resolve version:
Keywords:epsg, crs Add-on resolve build:
Has patch:No Proyecto:
Add-on name:Unknown Hito:
Add-on version:

Description

A quite regular update of the EPSG database is strongly needed, because there are many unsupported CRSs in gvSIG.
For instance, there are new EPSG codes for Italy in the latest versions of EPSG Geodetic Parameter Dataset (http://www.epsg-registry.org/):
  • "Monte Mario / TM Emilia-Romagna" (EPSG:5659);
  • "RDN2008" (EPSG:6706)
  • "RDN2008 / TM32" (EPSG:6707);
  • "RDN2008 / TM33" (EPSG:6708);
  • "RDN2008 / TM34" (EPSG:6709).

And consequently there are other transformation parameters to keep in count.

For instance, this is how gvSIG CE team is solving this issue:
http://gvsigce.sourceforge.net/wiki/index.php/How_to_update_the_EPSG_database

EPSG_v8_4_hsql.zip - EPSG.sql for hsql v.8.4 (951 KB) Antonio Falciano, 06/26/2014 02:00 PM

EPSG_v8_4_hsql_fixed.zip - EPSG.sql v.8.4 for hsqldb (fixed version) (951 KB) Antonio Falciano, 06/27/2014 07:01 AM

EPSG_diff.zip - diff between the new and the old EPSG.sql file (1.24 MB) Antonio Falciano, 06/27/2014 07:02 AM

EPSG_v8_4_hsql_final.zip - EPSG.sql v.8.4 for hsqldb (final version) ...It works! (948 KB) Antonio Falciano, 06/28/2014 01:13 PM

EPSG_v8.5.zip - EPSG.sql v.8.5 for hsqldb (954 KB) Antonio Falciano, 07/02/2014 04:27 AM

Related issues

Related to Application: gvSIG desktop - gvSIG feature requests #1371: Support for CRS EPSG:3857, EPSG:3785, EPSG:900913 Closed 11/09/2012
Related to Application: gvSIG desktop - gvSIG feature requests #2455: Agregar EPSG de Argentina Closed 03/20/2014
Related to Application: gvSIG desktop - gvSIG bugs #2596: Problema con la proyección EPSG:21781 Closed 06/26/2014
Related to Application: gvSIG desktop - gvSIG bugs #2389: No transformation is offered from 4326 to 3035 Closed 02/26/2014
Related to Application: gvSIG desktop - gvSIG feature requests #2728: Crear un tipo de complemento que permita instalar nuevas ... Closed 07/27/2014

History

#1 Updated by Alexander Holsteinson about 10 years ago

Esto debe ser parte de la monitoreo en linea automatico de nuevos versiones de addons cada vez que se cargue gvSIG. Por ejemplo no veo el datum o CRS IGS08 ni el vigente IGb08 asi como el NGA WGS84 G1674 vigentes actualmente.

#2 Updated by Álvaro Anguix about 10 years ago

  • Priority changed from High to Normal

#3 Updated by Antonio Falciano almost 10 years ago

I've just converted the latest version of EPSG Registry (8.4, May 2014) for HSQL (in attachment), trying to replicate the same structure of the EPSG.sql file available in gvSIG 2.1. In order to test it, follow these steps:
  1. make a backup copy of gvSIG\plugins\org.gvsig.projection.app.jcrs\db\EPSG.sql file (in order to eventually restore it after the test);
  2. overwrite it with the copy contained in the zip file;
  3. start gvSIG... and test it!

#4 Updated by Antonio Falciano almost 10 years ago

I've fixed the new EPSG.sql in order to ensure the full compatibility between the two versions. I attach both the fixed version and the diff between the new and the old EPSG.sql.
After some quick test, I see that there's some misalignment in the jcrs extension, e.g. it seems that gvSIG doesn't recognize the datum correctly... To be tested!

#5 Updated by Antonio Falciano almost 10 years ago

  • % Done changed from 0 to 100
  • Target version set to 2.1.0-2259-rc3
  • Status changed from New to Awaiting response
  • File EPSG_v8_4_hsql_final.zip added

I attach a final version of EPSG.sql (v. 8.4) which works like a charm! Tested with BN 2230.
Finally we can search and set the new Italian CRSs correctly, even if some transformations (e.g. RDN2008 to WGS84) are not always recognized (it may depend by the registry), but it's not a big problem because all parameters are zeros (manual transformation).
Note that EPSG:3785 and EPSG:3857 (Web Mercator) are searchable, but a warning message says "CRS not supported ======".

#6 Updated by Álvaro Anguix almost 10 years ago

#7 Updated by Álvaro Anguix almost 10 years ago

  • Assignee set to Joaquín del Cerro Murciano
  • Status changed from Awaiting response to Fixed
  • Category set to CRS

Antonio, thank you very much for the contribution. We're going to test it and if everything works good we're going to include it in the next builds.

#8 Updated by Álvaro Anguix almost 10 years ago

#9 Updated by Álvaro Anguix almost 10 years ago

  • Related to gvSIG bugs #2389: No transformation is offered from 4326 to 3035 added

#10 Updated by Antonio Falciano almost 10 years ago

Hi Alvaro,
don't mention it! It's a pleasure to contribute in order to solve these kind of issues.
The version 8.5 of EPSG Registry was released in the meanwhile, so I attach a new EPSG.sql script. I've tested it a bit and I have some suggestions in order to recognize new projection aliases introduced recently (#2596 and #2624) and to manage Web Mercator (#1371).

#11 Updated by Joaquín del Cerro Murciano almost 10 years ago

#12 Updated by Joaquín del Cerro Murciano almost 10 years ago

  • Target version changed from 2.1.0-2259-rc3 to 2.1.0-2239-testing

#13 Updated by Álvaro Anguix almost 10 years ago

  • Status changed from Fixed to Closed

Also available in: Atom PDF