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

[Alex Mandel]

Though it requires Internet what about hitting the epsg.io API described
on https://github.com/klokantech/epsg.io

Thanks,
Alex

On 09/22/2018 05:23 AM, Vijay Lulla wrote:
> Alex,
> Thanks for QGIS's srs.db!  I wasn't aware of it.
> 
> I currently use the spatial_ref_sys from PostGIS to create a SRS data frame
> but plan to use rgdal::make_EPSG more often.  The reason I brought this up
> is because on the lab computers (cannot install stuff on it) where I teach
> there is no PostGIS and I didn't know how to lookup EPSG codes for various
> SRS definitions from within R.  I hadn't thought of Spatialite metadata as
> a viable alternative.  So, thanks for that.  I will look into it and most
> likely use it in conjunction with make_EPSG!
> 
> Finally, I am really looking forward to the consolidated SRS database from
> the gdal barn-raising effort!  This consolidated database will be
> invaluable, and of great aid/service, to the geospatial community, IMO.
> Thanks,
> Vijay.
> 
> On Sat, Sep 22, 2018 at 1:22 AM Alex Mandel <tech_dev using wildintellect.com>
> wrote:
> 
>> 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
>>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>