Martin, After the OGC meeting two weeks ago, I went on vacation - hence my delay in responding.
During the OGC CRS working group meeting I raised some comments I have heard about the need for open source to move to CRS2. I believe Apache SIS has moved to CRS2 sometime ago, so that is less an issue for this Apache geospatial group. A part of my comments were about using SQLite to distribute the ESPG database. The topic was not adequately discussed in the CRS WG and possibly I did not express the comment correctly. Apparently some open source projects use SQLite internally to manage definition dictionaries. In any case if EPSG chose to distribute its database in SQLite, it seems that elements of GeoPackage would be a quick way to get that done. Should the OGC Testbeds include a requirement "test interoperability of CRS2 implementations”? We are currently planning Testbed 14 that will begin later this year, so now is the time to frame this as a good requirement and seek sponsors. Interested in your discussions. George > On Jun 30, 2017, at 6:45 AM, Martin Desruisseaux > <[email protected]> wrote: > > Hello all > > Yesterday during the Open Geospatial Consortium (OGC) meeting, during > the session about Coordinate Reference System (CRS), they were a talk > about EPSG database on SQLite. Because I attended only by telephone, it > was difficult for me to understand well what was being told. Maybe > George Percivall could tell more if he was in the room? > > If I understood correctly, one reason for the interest for EPSG on > SQLite is that SQLite is the database engine behind the Geopackage > standard. However I'm not sure if the discussion was about providing > EPSG database in WKT format in a single table, or providing the full > EPSG database with all its tables (the later approach avoid redundancies > thanks to relational database, and enable better coordinate operations > thanks to "late binding" approach). > > In the Apache Spatial Information System (SIS) project, Sisindaa is > doing a Google Summer of Code (GSoC) project which consist in porting > Apache SIS to the Android platform. One aspect of this work implies > porting the EPSG database to SQLite, since it is the database engine > embedded on Android. I have also seen some messages on the Proj.4 > mailing list about EPSG on SQLite. > > If there is common interest for this topic, what would be the most > appropriate community/mailing list for such discussion? (this list, > Geopackage, etc). > > Martin > >
