[R-sig-Geo] Consolidated SRS database/list?

[Alex Mandel]

QGIS makes one
https://github.com/qgis/QGIS/blob/master/resources/srs.db
There's some script in the build that updates it also, not without issue:
https://issues.qgis.org/issues/17993

I suppose you could also dump out how PostGIS does it to Sqlite, or use
the Spatialite metadata table.
https://www.gaia-gis.it/gaia-sins/spatialite-cookbook/html/metadata.html

But the thread mentioned that goes back to the MetaCRS mailing list is
probably the right place in the community to revive the discussion.

Seems like something to encourage, and a good topic for an OSGeo
sponsored sprint.

Thanks,
Alex

On 09/21/2018 12:32 AM, Roger Bivand wrote:
> On Thu, 20 Sep 2018, Vijay Lulla wrote:
> 
>> Ok, thanks!  While the page provided information about the project and
>> its
>> funding status I couldn't find the SQLite database.  Do you happen to
>> know
>> when this will be available?
> 
> No more than is on that page, plus the time needed to re-write plenty of
> sf, lwgeom, rgdal and sp. At that stage, contributions welcome!
> 
> Roger
> 
>>
>> On Thu, Sep 20, 2018 at 1:02 PM Roger Bivand <Roger.Bivand using nhh.no> wrote:
>>
>>> On Thu, 20 Sep 2018, Vijay Lulla wrote:
>>>
>>>> Dear list members,
>>>> A few years ago Roger Bivand posted a discussion (
>>>> https://stat.ethz.ch/pipermail/r-sig-geo/2015-August/023204.html )
>>>> about
>>>> consolidating SRS definitions into a SQLite database and I am wondering
>>> if
>>>> there has been any development along those lines.
>>>
>>> Rather than trying this just within R, we're hoping that the GDAL
>>> barn-raising effort:
>>>
>>> https://gdalbarn.com/
>>>
>>> will take us there and further, and be much better than having a
>>> non-standard implementation.
>>>
>>> When that effort is done, we'll be open for ideas about interfacing it
>>> through PROJ and GDAL, which now ship with CSV files that we copy into
>>> Windows and MacOS binary packages (rgdal, sf, lwgeom).
>>>
>>> For now, if it helps, rgdal::make_EPSG() reads the EPSG CSV file shipped
>>> with PROJ into the R workspace as a data.frame.
>>>
>>> Roger
>>>
>>>> Specifically, is there any consolidated collection of SRS
>>>> definitions in
>>>> R (either a data.frame or tibble or SQLite backed) that are being used
>>>> by geospatial packages that users can use too?  If so, can you please
>>>> point me to it?  If not, would it be worthwhile to have this
>>>> consolidated list/dataframe, maybe as part of data for one of the core
>>>> geospatial packages? Thanks in advance, Vijay
>>>>
>>>>       [[alternative HTML version deleted]]
>>>>
>>>> _______________________________________________
>>>> R-sig-Geo mailing list
>>>> R-sig-Geo using r-project.org
>>>> https://stat.ethz.ch/mailman/listinfo/r-sig-geo
>>>>
>>>
>>> -- 
>>> Roger Bivand
>>> Department of Economics, Norwegian School of Economics,
>>> Helleveien 30, N-5045 Bergen, Norway.
>>> voice: +47 55 95 93 55; e-mail: Roger.Bivand using nhh.no
>>> http://orcid.org/0000-0003-2392-6140
>>> https://scholar.google.no/citations?user=AWeghB0AAAAJ&hl=en
>>>
>>
>>
>>
>