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

[Vijay Lulla]

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

-- 
Vijay Lulla

Assistant Professor,
Dept. of Geography, IUPUI
425 University Blvd, CA-207C.
Indianapolis, IN-46202
vlulla using iupui.edu
ORCID: https://orcid.org/0000-0002-0823-2522
Webpage: http://vijaylulla.com

	[[alternative HTML version deleted]]