[R-sig-Geo] How to read .gpkg (Geopackage) files in R

[Manuel Spínola]

Thank you very much Michael.

Manuel

2016-08-25 16:40 GMT-06:00 Michael Sumner <mdsumner at gmail.com>:

>
>
> On Fri, 26 Aug 2016 at 07:18 Manuel Spínola <mspinola10 at gmail.com> wrote:
>
>> Dear list members,
>>
>> How can I read a .gpkg (Geopackage) file in R?
>>
>>
> You're in luck because it's extremely easy.
>
> library(rgdal)
> layers <- ogrListLayers("parcelas.gpkg")
>
> ## you may have more than one layer
> x <- readOGR("parcelas.gpkg", layers[1])
>
> ## some kind of *DataFrame
> print(class(x))
> plot(x)
>
> Cheers, Mike.
>
> Read on only  if you're interested in more details about GeoPackage.
>
> Geopackage is also extremely extensible since it's built right on top of
> SQLite.  If you are keen, you can investigate the contents with
> dplyr/RSQLite - though there's no need if sp/rgdal does what you want:
>
> library(dplyr)
> library(RSQLite)
> db <- src_sql("parcelas.gpkg")
>
> print(db)  ## what tabes are in there?
>
> tbl_df(db, "some_table_name")
>
> The geometry is in one of the tables in WKB form, so it's not "tables all
> the way down" but still pretty useful.
>
>
>
>> The name of my file is: parcelas.gpkg
>>
>> Best,
>>
>> --
>> *Manuel Spínola, Ph.D.*
>> Instituto Internacional en Conservación y Manejo de Vida Silvestre
>> Universidad Nacional
>> Apartado 1350-3000
>> Heredia
>> COSTA RICA
>> mspinola at una.cr <mspinola at una.ac.cr>
>> mspinola10 at gmail.com
>> Teléfono: (506) 8706 - 4662
>> Personal website: Lobito de río <https://sites.google.com/
>> site/lobitoderio/>
>> Institutional website: ICOMVIS <http://www.icomvis.una.ac.cr/>
>>
>>         [[alternative HTML version deleted]]
>>
>> _______________________________________________
>> R-sig-Geo mailing list
>> R-sig-Geo at r-project.org
>> https://stat.ethz.ch/mailman/listinfo/r-sig-geo
>
> --
> Dr. Michael Sumner
> Software and Database Engineer
> Australian Antarctic Division
> 203 Channel Highway
> Kingston Tasmania 7050 Australia
>
>


-- 
*Manuel Spínola, Ph.D.*
Instituto Internacional en Conservación y Manejo de Vida Silvestre
Universidad Nacional
Apartado 1350-3000
Heredia
COSTA RICA
mspinola at una.cr <mspinola at una.ac.cr>
mspinola10 at gmail.com
Teléfono: (506) 8706 - 4662
Personal website: Lobito de río <https://sites.google.com/site/lobitoderio/>
Institutional website: ICOMVIS <http://www.icomvis.una.ac.cr/>

	[[alternative HTML version deleted]]