[GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT

Helmut Kudrnovsky hellik at web.de
Tue Oct 10 13:56:48 PDT 2017


 
 

Gesendet: Dienstag, 10. Oktober 2017 um 22:52 Uhr
Von: "Veronica Andreo" <veroandreo at gmail.com>
An: "Roger Bivand" <Roger.Bivand at nhh.no>
Cc: "grass-stats at lists.osgeo.org" <grass-stats at lists.osgeo.org>, "Helmut Kudrnovsky" <hellik at web.de>
Betreff: Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT

Hello Roger,
 Sorry I forgot this info. Here, the outputs:
> sessionInfo()
R version 3.4.1 (2017-06-30)
Platform: x86_64-redhat-linux-gnu (64-bit)
Running under: Fedora 26 (Twenty Six)

Matrix products: default
BLAS/LAPACK: /usr/lib64/R/lib/libRblas.so

locale:
 [1] LC_CTYPE=en_US.UTF-8       LC_NUMERIC=C             
 [3] LC_TIME=en_US.UTF-8        LC_COLLATE=en_US.UTF-8   
 [5] LC_MONETARY=en_US.UTF-8    LC_MESSAGES=en_US.UTF-8  
 [7] LC_PAPER=en_US.UTF-8       LC_NAME=C                
 [9] LC_ADDRESS=C               LC_TELEPHONE=C           
[11] LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C      

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base    

loaded via a namespace (and not attached):
[1] compiler_3.4.1

----
> library(rgrass7)
Loading required package: sp
Loading required package: XML
GRASS GIS interface loaded with GRASS version: GRASS 7.3.svn (2017)
and location: nc_spm_08_grass7
> library(rgdal)
rgdal: version: 1.2-13, (SVN revision 686)
 Geospatial Data Abstraction Library extensions to R successfully loaded
 Loaded GDAL runtime: GDAL 2.1.3, released 2017/20/01
 Path to GDAL shared files: /usr/share/gdal
 Loaded PROJ.4 runtime: Rel. 4.9.3, 15 August 2016, [PJ_VERSION: 493]
 Path to PROJ.4 shared files: (autodetected)
 Linking to sp version: 1.2-5
 
> ogrDrivers()
             name                                                   long_name
1      AeronavFAA                                                 Aeronav FAA
2      AmigoCloud                                                  AmigoCloud
3          ARCGEN                                           Arc/Info Generate
4          AVCBin                                    Arc/Info Binary Coverage
5          AVCE00                               Arc/Info E00 (ASCII) Coverage
6             BNA                                                   Atlas BNA
7           Carto                                                       Carto
8        Cloudant                                          Cloudant / CouchDB
9         CouchDB                                          CouchDB / GeoCouch
10            CSV                                Comma Separated Value (.csv)
11            CSW                      OGC CSW (Catalog  Service for the Web)
12            DGN                                            Microstation DGN
13            DXF                                                 AutoCAD DXF
14         EDIGEO                               French EDIGEO exchange format
15  ElasticSearch                                              Elastic Search
16 ESRI Shapefile                                              ESRI Shapefile
17     Geoconcept                                                  Geoconcept
18        GeoJSON                                                     GeoJSON
19       Geomedia                                               Geomedia .mdb
20         GeoRSS                                                      GeoRSS
21            GFT                                        Google Fusion Tables
22            GML                             Geography Markup Language (GML)
23           GPKG                                                  GeoPackage
24       GPSBabel                                                    GPSBabel
25  GPSTrackMaker                                               GPSTrackMaker
26            GPX                                                         GPX
27            HTF                                Hydrographic Transfer Vector
28           HTTP                                       HTTP Fetching Wrapper
29         Idrisi                                        Idrisi Vector (.vct)
30     Interlis 1                                                  Interlis 1
31     Interlis 2                                                  Interlis 2
32            JML                                                OpenJUMP JML
33    JP2OpenJPEG                  JPEG-2000 driver based on OpenJPEG library
34       JPEG2000 JPEG-2000 part 1 (ISO/IEC 15444-1), based on Jasper library
35            KML                               Keyhole Markup Language (KML)
36         LIBKML                            Keyhole Markup Language (LIBKML)
37   MapInfo File                                                MapInfo File
38         Memory                                                      Memory
39   MSSQLSpatial                       Microsoft SQL Server Spatial Database
40          MySQL                                                       MySQL
41            NAS                                                 NAS - ALKIS
42         netCDF                                  Network Common Data Format
43           ODBC                                                        ODBC
44            ODS        Open Document/ LibreOffice / OpenOffice Spreadsheet
45       OGR_DODS                                                    OGR_DODS
46        OGR_GMT                                    GMT ASCII Vectors (.gmt)
47       OGR_OGDI                               OGDI Vectors (VPF, VMAP, DCW)
48        OGR_PDS                                Planetary Data Systems TABLE
49       OGR_SDTS                                                        SDTS
50        OGR_VRT                                    VRT - Virtual Datasource
51        OpenAir                                                     OpenAir
52    OpenFileGDB                                                ESRI FileGDB
53            OSM                                   OpenStreetMap XML and PBF
54         PCIDSK                                        PCIDSK Database File
55            PDF                                              Geospatial PDF
56         PGDUMP                                         PostgreSQL SQL dump
57           PGeo                                   ESRI Personal GeoDatabase
58       PLSCENES                                      Planet Labs Scenes API
59     PostgreSQL                                          PostgreSQL/PostGIS
60            REC                                               EPIInfo .REC
61            S57                                              IHO S-57 (ENC)
62       SEGUKOOA                                        SEG-P1 / UKOOA P1/90
63           SEGY                                                       SEG-Y
64        Selafin                                                     Selafin
65         SQLite                                         SQLite / Spatialite
66            SUA             Tim Newport-Peace's Special Use Airspace Format
67            SVG                                    Scalable Vector Graphics
68            SXF                                 Storage and eXchange Format
69          TIGER                                      U.S. Census TIGER/Line
70        UK .NTF                                                     UK .NTF
71            VDV                         VDV-451/VDV-452/INTREST Data Format
72            VFK                        Czech Cadastral Exchange Data Format
73           Walk                                                        Walk
74           WAsP                                            WAsP .map format
75            WFS                               OGC WFS (Web Feature Service)
76            XLS                                             MS Excel format
77           XLSX                              MS Office Open XML spreadsheet
78         XPlane                        X-Plane/Flightgear aeronautical data
   write  copy isVector
1  FALSE FALSE     TRUE
2   TRUE FALSE     TRUE
3  FALSE FALSE     TRUE
4  FALSE FALSE     TRUE
5  FALSE FALSE     TRUE
6   TRUE FALSE     TRUE
7   TRUE FALSE     TRUE
8   TRUE FALSE     TRUE
9   TRUE FALSE     TRUE
10  TRUE FALSE     TRUE
11 FALSE FALSE     TRUE
12  TRUE FALSE     TRUE
13  TRUE FALSE     TRUE
14 FALSE FALSE     TRUE
15  TRUE FALSE     TRUE
16  TRUE FALSE     TRUE
17  TRUE FALSE     TRUE
18  TRUE FALSE     TRUE
19 FALSE FALSE     TRUE
20  TRUE FALSE     TRUE
21  TRUE FALSE     TRUE
22  TRUE FALSE     TRUE
23  TRUE  TRUE     TRUE
24  TRUE FALSE     TRUE
25  TRUE FALSE     TRUE
26  TRUE FALSE     TRUE
27 FALSE FALSE     TRUE
28 FALSE FALSE     TRUE
29 FALSE FALSE     TRUE
30  TRUE FALSE     TRUE
31  TRUE FALSE     TRUE
32  TRUE FALSE     TRUE
33 FALSE  TRUE     TRUE
34 FALSE  TRUE     TRUE
35  TRUE FALSE     TRUE
36  TRUE FALSE     TRUE
37  TRUE FALSE     TRUE
38  TRUE FALSE     TRUE
39  TRUE FALSE     TRUE
40  TRUE FALSE     TRUE
41 FALSE FALSE     TRUE
42  TRUE  TRUE     TRUE
43  TRUE FALSE     TRUE
44  TRUE FALSE     TRUE
45 FALSE FALSE     TRUE
46  TRUE FALSE     TRUE
47 FALSE FALSE     TRUE
48 FALSE FALSE     TRUE
49 FALSE FALSE     TRUE
50 FALSE FALSE     TRUE
51 FALSE FALSE     TRUE
52 FALSE FALSE     TRUE
53 FALSE FALSE     TRUE
54  TRUE FALSE     TRUE
55  TRUE  TRUE     TRUE
56  TRUE FALSE     TRUE
57 FALSE FALSE     TRUE
58 FALSE FALSE     TRUE
59  TRUE FALSE     TRUE
60 FALSE FALSE     TRUE
61  TRUE FALSE     TRUE
62 FALSE FALSE     TRUE
63 FALSE FALSE     TRUE
64  TRUE FALSE     TRUE
65  TRUE FALSE     TRUE
66 FALSE FALSE     TRUE
67 FALSE FALSE     TRUE
68 FALSE FALSE     TRUE
69  TRUE FALSE     TRUE
70 FALSE FALSE     TRUE
71  TRUE FALSE     TRUE
72 FALSE FALSE     TRUE
73 FALSE FALSE     TRUE
74  TRUE FALSE     TRUE
75 FALSE FALSE     TRUE
76 FALSE FALSE     TRUE
77  TRUE FALSE     TRUE
78 FALSE FALSE     TRUE

----

sorry, ok, and here my results (just forgot to import the library before)

>  library(rgdal)
rgdal: version: 1.2-12, (SVN revision 681)
 Geospatial Data Abstraction Library extensions to R successfully loaded
 Loaded GDAL runtime: GDAL 2.2.0, released 2017/04/28
 Path to GDAL shared files: C:/Program Files/R/R-3.4.0/library/rgdal/gdal
 Loaded PROJ.4 runtime: Rel. 4.9.3, 15 August 2016, [PJ_VERSION: 493]
 Path to PROJ.4 shared files: C:/Program Files/R/R-3.4.0/library/rgdal/proj
 Linking to sp version: 1.2-5
Warning message:
package 'rgdal' was built under R version 3.4.2
> ogrDrivers()
             name                                            long_name write
1          ARCGEN                                    Arc/Info Generate FALSE
2          AVCBin                             Arc/Info Binary Coverage FALSE
3          AVCE00                        Arc/Info E00 (ASCII) Coverage FALSE
4      AeronavFAA                                          Aeronav FAA FALSE
5      AmigoCloud                                           AmigoCloud  TRUE
6             BNA                                            Atlas BNA  TRUE
7             CAD                                       AutoCAD Driver FALSE
8             CSV                         Comma Separated Value (.csv)  TRUE
9             CSW               OGC CSW (Catalog  Service for the Web) FALSE
10          Carto                                                Carto  TRUE
11       Cloudant                                   Cloudant / CouchDB  TRUE
12        CouchDB                                   CouchDB / GeoCouch  TRUE
13            DGN                                     Microstation DGN  TRUE
14            DXF                                          AutoCAD DXF  TRUE
15         EDIGEO                        French EDIGEO exchange format FALSE
16 ESRI Shapefile                                       ESRI Shapefile  TRUE
17  ElasticSearch                                       Elastic Search  TRUE
18            GFT                                 Google Fusion Tables  TRUE
19            GML                      Geography Markup Language (GML)  TRUE <=
20           GPKG                                           GeoPackage  TRUE
21       GPSBabel                                             GPSBabel  TRUE
22  GPSTrackMaker                                        GPSTrackMaker  TRUE
23            GPX                                                  GPX  TRUE
24        GeoJSON                                              GeoJSON  TRUE
25         GeoRSS                                               GeoRSS  TRUE
26     Geoconcept                                           Geoconcept  TRUE
27       Geomedia                                        Geomedia .mdb FALSE
28            HTF                         Hydrographic Transfer Vector FALSE
29           HTTP                                HTTP Fetching Wrapper FALSE
30         Idrisi                                 Idrisi Vector (.vct) FALSE
31            JML                                         OpenJUMP JML  TRUE
32            KML                        Keyhole Markup Language (KML)  TRUE
33   MSSQLSpatial                Microsoft SQL Server Spatial Database  TRUE
34   MapInfo File                                         MapInfo File  TRUE
35         Memory                                               Memory  TRUE
36           ODBC                                                 ODBC  TRUE
37            ODS Open Document/ LibreOffice / OpenOffice Spreadsheet   TRUE
38        OGR_GMT                             GMT ASCII Vectors (.gmt)  TRUE
39        OGR_PDS                         Planetary Data Systems TABLE FALSE
40       OGR_SDTS                                                 SDTS FALSE
41        OGR_VRT                             VRT - Virtual Datasource FALSE
42            OSM                            OpenStreetMap XML and PBF FALSE
43        OpenAir                                              OpenAir FALSE
44    OpenFileGDB                                         ESRI FileGDB FALSE
45         PCIDSK                                 PCIDSK Database File  TRUE
46            PDF                                       Geospatial PDF  TRUE
47         PGDUMP                                  PostgreSQL SQL dump  TRUE
48           PGeo                            ESRI Personal GeoDatabase FALSE
49       PLSCENES                               Planet Labs Scenes API FALSE
50     PostgreSQL                                   PostgreSQL/PostGIS  TRUE
51            REC                                        EPIInfo .REC  FALSE
52            S57                                       IHO S-57 (ENC)  TRUE
53       SEGUKOOA                                 SEG-P1 / UKOOA P1/90 FALSE
54           SEGY                                                SEG-Y FALSE
55         SQLite                                  SQLite / Spatialite  TRUE <=
56            SUA      Tim Newport-Peace's Special Use Airspace Format FALSE
57            SVG                             Scalable Vector Graphics FALSE
58            SXF                          Storage and eXchange Format FALSE
59        Selafin                                              Selafin  TRUE
60          TIGER                               U.S. Census TIGER/Line  TRUE
61        UK .NTF                                              UK .NTF FALSE
62            VDV                  VDV-451/VDV-452/INTREST Data Format  TRUE
63            VFK                 Czech Cadastral Exchange Data Format FALSE
64           WAsP                                     WAsP .map format  TRUE
65            WFS                        OGC WFS (Web Feature Service) FALSE
66           Walk                                                 Walk FALSE
67            XLS                                      MS Excel format FALSE
68           XLSX                       MS Office Open XML spreadsheet  TRUE
69         XPlane                 X-Plane/Flightgear aeronautical data FALSE
70         netCDF                           Network Common Data Format  TRUE
 
GML and SQLite both there.

Helmut


More information about the grass-stats mailing list