Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT
In the readVECT function, internally v.in.ogr is used to list the supported vector format and it is compared the format available using rgdal (or sf). However, using v.external instead of v.in.ogr fix this single problem because of the way the output is different (in form). For example, if you use v.in.ogr you will have to compare SQLite_/_Spatialite (GRASS) to SQLite (R) and they are not the same. I tried to send a PR, let me know if it works https://github.com/rsbivand/rgrass7/pull/1 Best, On Tue, Oct 10, 2017 at 9:29 PM, Helmut Kudrnovskywrote: > >Gesendet: Dienstag, 10. Oktober 2017 um 23:24 Uhr > >Von: "Ahmadou Dicko" > >An: "Helmut Kudrnovsky" > >Cc: "Roger Bivand" , "grass-stats@lists.osgeo.org" < > grass-stats@lists.osgeo.org> > >Betreff: Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working > for readVECT > > > >Hi everyone, > > > >I think that using v.external -f (instead of v.in.ogr -f) can fix this > issue (didn't try yet) > > > > > >execGRASS("v.external", flags = "f", intern = TRUE) > > [1] "ARCGEN" "AVCBin" "AVCE00" > > [4] "AeronavFAA" "AmigoCloud" "BNA" > > [7] "CAD""CSV""CSW" > >[10] "Carto" "Cloudant" "CouchDB" > >[13] "DGN""DXF""EDIGEO" > >[16] "ESRI_Shapefile" "ElasticSearch" "GFT" > >[19] "GML""GPKG" "GPSBabel" > >[22] "GPSTrackMaker" "GPX""GeoJSON" > >[25] "GeoRSS" "Geoconcept" "Geomedia" > >[28] "HTF""HTTP" "Idrisi" > >[31] "JML""JPEG2000" "KML" > >[34] "MSSQLSpatial" "MapInfo_File" "Memory" > >[37] "MySQL" "ODBC" "ODS" > >[40] "OGR_GMT""OGR_GRASS" "OGR_PDS" > >[43] "OGR_SDTS" "OGR_VRT""OSM" > >[46] "OpenAir""OpenFileGDB""PCIDSK" > >[49] "PDF""PGDUMP" "PGeo" > >[52] "PLSCENES" "PostgreSQL" "REC" > > in a quick check, there is no difference in available formats. > > > -- Ahmadou H. DICKO, PhD Data Lab Manager Humanitarian Data Exchange (HDX) - humdata.org OCHA ROWCA regional office VDN Sacre Coeur III, Villa 9364 BP 16 922 Fann Dakar, Senegal Phone: (+221) 33 869 85 36 Mobile: (+221) 77 123 81 69 Email: dic...@un.org Skype: dicko.ahmadou.h Twitter : @dickoah Gitlab: gitlab/dickoa Github: github/dickoa ___ grass-stats mailing list grass-stats@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-stats
Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT
>Gesendet: Dienstag, 10. Oktober 2017 um 23:24 Uhr >Von: "Ahmadou Dicko">An: "Helmut Kudrnovsky" >Cc: "Roger Bivand" , "grass-stats@lists.osgeo.org" > >Betreff: Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for >readVECT > >Hi everyone, > >I think that using v.external -f (instead of v.in.ogr -f) can fix this issue >(didn't try yet) > > >execGRASS("v.external", flags = "f", intern = TRUE) > [1] "ARCGEN" "AVCBin" "AVCE00" > [4] "AeronavFAA" "AmigoCloud" "BNA" > [7] "CAD" "CSV" "CSW" >[10] "Carto" "Cloudant" "CouchDB" >[13] "DGN" "DXF" "EDIGEO" >[16] "ESRI_Shapefile" "ElasticSearch" "GFT" >[19] "GML" "GPKG" "GPSBabel" >[22] "GPSTrackMaker" "GPX" "GeoJSON" >[25] "GeoRSS" "Geoconcept" "Geomedia" >[28] "HTF" "HTTP" "Idrisi" >[31] "JML" "JPEG2000" "KML" >[34] "MSSQLSpatial" "MapInfo_File" "Memory" >[37] "MySQL" "ODBC" "ODS" >[40] "OGR_GMT" "OGR_GRASS" "OGR_PDS" >[43] "OGR_SDTS" "OGR_VRT" "OSM" >[46] "OpenAir" "OpenFileGDB" "PCIDSK" >[49] "PDF" "PGDUMP" "PGeo" >[52] "PLSCENES" "PostgreSQL" "REC" in a quick check, there is no difference in available formats. ___ grass-stats mailing list grass-stats@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-stats
Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT
Hi everyone, I think that using v.external -f (instead of v.in.ogr -f) can fix this issue (didn't try yet) execGRASS("v.external", flags = "f", intern = TRUE) [1] "ARCGEN" "AVCBin" "AVCE00" [4] "AeronavFAA" "AmigoCloud" "BNA" [7] "CAD""CSV""CSW" [10] "Carto" "Cloudant" "CouchDB" [13] "DGN""DXF""EDIGEO" [16] "ESRI_Shapefile" "ElasticSearch" "GFT" [19] "GML""GPKG" "GPSBabel" [22] "GPSTrackMaker" "GPX""GeoJSON" [25] "GeoRSS" "Geoconcept" "Geomedia" [28] "HTF""HTTP" "Idrisi" [31] "JML""JPEG2000" "KML" [34] "MSSQLSpatial" "MapInfo_File" "Memory" [37] "MySQL" "ODBC" "ODS" [40] "OGR_GMT""OGR_GRASS" "OGR_PDS" [43] "OGR_SDTS" "OGR_VRT""OSM" [46] "OpenAir""OpenFileGDB""PCIDSK" [49] "PDF""PGDUMP" "PGeo" [52] "PLSCENES" "PostgreSQL" "REC" Best, On Tue, Oct 10, 2017 at 9:22 PM, Helmut Kudrnovskywrote: > >Von: "Roger Bivand" > >And output of v.in.ogr -f? > > v.in.ogr -f > JP2ECW (ro): ERDAS JPEG2000 (SDK 5.3) > FileGDB (rw+): ESRI FileGDB > PCIDSK (rw+): PCIDSK Database File > netCDF (rw+): Network Common Data Format > JP2OpenJPEG (rw): JPEG-2000 driver based on OpenJPEG library > PDF (rw+): Geospatial PDF > DB2ODBC (rw+): IBM DB2 Spatial Database > ESRI Shapefile (rw+): ESRI Shapefile > MapInfo File (rw+): MapInfo File > UK .NTF (ro): UK .NTF > OGR_SDTS (ro): SDTS > S57 (rw+): IHO S-57 (ENC) > DGN (rw+): Microstation DGN > OGR_VRT (ro): VRT - Virtual Datasource > REC (ro): EPIInfo .REC > Memory (rw+): Memory > BNA (rw+): Atlas BNA > CSV (rw+): Comma Separated Value (.csv) > NAS (ro): NAS - ALKIS > GML (rw+): Geography Markup Language (GML) <= > GPX (rw+): GPX > LIBKML (rw+): Keyhole Markup Language (LIBKML) > KML (rw+): Keyhole Markup Language (KML) > GeoJSON (rw+): GeoJSON > Interlis 1 (rw+): Interlis 1 > Interlis 2 (rw+): Interlis 2 > OGR_GMT (rw+): GMT ASCII Vectors (.gmt) > GPKG (rw+): GeoPackage > SQLite (rw+): SQLite / Spatialite <= > ODBC (rw+): ODBC > WAsP (rw+): WAsP .map format > PGeo (ro): ESRI Personal GeoDatabase > MSSQLSpatial (rw+): Microsoft SQL Server Spatial Database > OGR_OGDI (ro): OGDI Vectors (VPF, VMAP, DCW) > PostgreSQL (rw+): PostgreSQL/PostGIS > MySQL (rw+): MySQL > OpenFileGDB (ro): ESRI FileGDB > XPlane (ro): X-Plane/Flightgear aeronautical data > DXF (rw+): AutoCAD DXF > CAD (ro): AutoCAD Driver > Geoconcept (rw+): Geoconcept > GeoRSS (rw+): GeoRSS > GPSTrackMaker (rw+): GPSTrackMaker > VFK (ro): Czech Cadastral Exchange Data Format > PGDUMP (rw+): PostgreSQL SQL dump > OSM (ro): OpenStreetMap XML and PBF > GPSBabel (rw+): GPSBabel > SUA (ro): Tim Newport-Peace's Special Use Airspace Format > OpenAir (ro): OpenAir > OGR_PDS (ro): Planetary Data Systems TABLE > WFS (ro): OGC WFS (Web Feature Service) > HTF (ro): Hydrographic Transfer Vector > AeronavFAA (ro): Aeronav FAA > Geomedia (ro): Geomedia .mdb > EDIGEO (ro): French EDIGEO exchange format > GFT (rw+): Google Fusion Tables > SVG (ro): Scalable Vector Graphics > CouchDB (rw+): CouchDB / GeoCouch > Cloudant (rw+): Cloudant / CouchDB > Idrisi (ro): Idrisi Vector (.vct) > ARCGEN (ro): Arc/Info Generate > SEGUKOOA (ro): SEG-P1 / UKOOA P1/90 > SEGY (ro): SEG-Y > XLS (ro): MS Excel format > ODS (rw+): Open Document/ LibreOffice / OpenOffice Spreadsheet > XLSX (rw+): MS Office Open XML spreadsheet > ElasticSearch (rw+): Elastic Search > Walk (ro): Walk > Carto (rw+): Carto > AmigoCloud (rw+): AmigoCloud > SXF (ro): Storage and eXchange Format > Selafin (rw+): Selafin > JML (rw+): OpenJUMP JML > PLSCENES (ro): Planet Labs Scenes API > CSW (ro): OGC CSW (Catalog Service for the Web) > VDV (rw+): VDV-451/VDV-452/INTREST Data Format > GMLAS (rw): Geography Markup Language (GML) driven by application schemas > TIGER (rw+): U.S. Census TIGER/Line > AVCBin (ro): Arc/Info Binary Coverage > AVCE00 (ro): Arc/Info E00 (ASCII) Coverage > HTTP (ro): HTTP Fetching Wrapper > Supported formats: > > --- > > both GML and SQLite there. > > thanks for checking. > > Helmut > ___ > grass-stats mailing list > grass-stats@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/grass-stats > -- Ahmadou H. DICKO, PhD Data Lab Manager Humanitarian Data Exchange (HDX) - humdata.org OCHA ROWCA regional office VDN Sacre Coeur III, Villa 9364 BP 16 922 Fann Dakar, Senegal Phone: (+221) 33 869 85 36 Mobile: (+221) 77 123 81 69 Email: dic...@un.org Skype: dicko.ahmadou.h Twitter : @dickoah Gitlab: gitlab/dickoa Github: github/dickoa ___ grass-stats mailing list grass-stats@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-stats
Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT
>Von: "Roger Bivand" >And output of v.in.ogr -f? v.in.ogr -f JP2ECW (ro): ERDAS JPEG2000 (SDK 5.3) FileGDB (rw+): ESRI FileGDB PCIDSK (rw+): PCIDSK Database File netCDF (rw+): Network Common Data Format JP2OpenJPEG (rw): JPEG-2000 driver based on OpenJPEG library PDF (rw+): Geospatial PDF DB2ODBC (rw+): IBM DB2 Spatial Database ESRI Shapefile (rw+): ESRI Shapefile MapInfo File (rw+): MapInfo File UK .NTF (ro): UK .NTF OGR_SDTS (ro): SDTS S57 (rw+): IHO S-57 (ENC) DGN (rw+): Microstation DGN OGR_VRT (ro): VRT - Virtual Datasource REC (ro): EPIInfo .REC Memory (rw+): Memory BNA (rw+): Atlas BNA CSV (rw+): Comma Separated Value (.csv) NAS (ro): NAS - ALKIS GML (rw+): Geography Markup Language (GML) <= GPX (rw+): GPX LIBKML (rw+): Keyhole Markup Language (LIBKML) KML (rw+): Keyhole Markup Language (KML) GeoJSON (rw+): GeoJSON Interlis 1 (rw+): Interlis 1 Interlis 2 (rw+): Interlis 2 OGR_GMT (rw+): GMT ASCII Vectors (.gmt) GPKG (rw+): GeoPackage SQLite (rw+): SQLite / Spatialite <= ODBC (rw+): ODBC WAsP (rw+): WAsP .map format PGeo (ro): ESRI Personal GeoDatabase MSSQLSpatial (rw+): Microsoft SQL Server Spatial Database OGR_OGDI (ro): OGDI Vectors (VPF, VMAP, DCW) PostgreSQL (rw+): PostgreSQL/PostGIS MySQL (rw+): MySQL OpenFileGDB (ro): ESRI FileGDB XPlane (ro): X-Plane/Flightgear aeronautical data DXF (rw+): AutoCAD DXF CAD (ro): AutoCAD Driver Geoconcept (rw+): Geoconcept GeoRSS (rw+): GeoRSS GPSTrackMaker (rw+): GPSTrackMaker VFK (ro): Czech Cadastral Exchange Data Format PGDUMP (rw+): PostgreSQL SQL dump OSM (ro): OpenStreetMap XML and PBF GPSBabel (rw+): GPSBabel SUA (ro): Tim Newport-Peace's Special Use Airspace Format OpenAir (ro): OpenAir OGR_PDS (ro): Planetary Data Systems TABLE WFS (ro): OGC WFS (Web Feature Service) HTF (ro): Hydrographic Transfer Vector AeronavFAA (ro): Aeronav FAA Geomedia (ro): Geomedia .mdb EDIGEO (ro): French EDIGEO exchange format GFT (rw+): Google Fusion Tables SVG (ro): Scalable Vector Graphics CouchDB (rw+): CouchDB / GeoCouch Cloudant (rw+): Cloudant / CouchDB Idrisi (ro): Idrisi Vector (.vct) ARCGEN (ro): Arc/Info Generate SEGUKOOA (ro): SEG-P1 / UKOOA P1/90 SEGY (ro): SEG-Y XLS (ro): MS Excel format ODS (rw+): Open Document/ LibreOffice / OpenOffice Spreadsheet XLSX (rw+): MS Office Open XML spreadsheet ElasticSearch (rw+): Elastic Search Walk (ro): Walk Carto (rw+): Carto AmigoCloud (rw+): AmigoCloud SXF (ro): Storage and eXchange Format Selafin (rw+): Selafin JML (rw+): OpenJUMP JML PLSCENES (ro): Planet Labs Scenes API CSW (ro): OGC CSW (Catalog Service for the Web) VDV (rw+): VDV-451/VDV-452/INTREST Data Format GMLAS (rw): Geography Markup Language (GML) driven by application schemas TIGER (rw+): U.S. Census TIGER/Line AVCBin (ro): Arc/Info Binary Coverage AVCE00 (ro): Arc/Info E00 (ASCII) Coverage HTTP (ro): HTTP Fetching Wrapper Supported formats: --- both GML and SQLite there. thanks for checking. Helmut ___ grass-stats mailing list grass-stats@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-stats
Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT
And output of v.in.ogr -f? Nothing has changed in rgrass7, I'll check in the morning. Roger Roger Bivand Norwegian School of Economics Bergen, Norway Fra: Helmut Kudrnovsky Sendt: tirsdag 10. oktober, 22.56 Emne: Aw: Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT Til: Veronica Andreo Kopi: Roger Bivand, grass-stats@lists.osgeo.org Gesendet: Dienstag, 10. Oktober 2017 um 22:52 Uhr Von: "Veronica Andreo" An: "Roger Bivand" Cc: "grass-stats@lists.osgeo.org" , "Helmut Kudrnovsky" 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 AVCBinArc/Info Binary Coverage 5 AVCE00 Arc/Info E00 (ASCII) Coverage 6 BNA Atlas BNA 7 Carto Carto 8Cloudant Cloudant / CouchDB 9 CouchDB CouchDB / GeoCouch 10CSVComma Separated Value (.csv) 11CSW OGC CSW (Catalog Service for the Web) 12DGNMicrostation DGN 13DXF AutoCAD DXF 14 EDIGEO French EDIGEO exchange format 15 ElasticSearch Elastic Search 16 ESRI Shapefile ESRI Shapefile 17 Geoconcept Geoconcept 18GeoJSON GeoJSON 19 Geomedia Geomedia .mdb 20 GeoRSS GeoRSS 21GFTGoogle Fusion Tables 22GML Geography Markup Language (GML) 23 GPKG GeoPackage 24 GPSBabel GPSBabel 25 GPSTrackMaker GPSTrackMaker 26GPX GPX 27HTFHydrographic Transfer Vector 28 HTTP HTTP Fetching Wrapper 29 Idrisi Idrisi Vector (.vct) 30 Interlis 1 Interlis 1 31 Interlis 2 Interlis 2 32JML OpenJUMP JML 33JP2OpenJPEG JPEG-2000 driver based on OpenJPEG library 34 JPEG2000 JPEG-2000 part 1 (ISO/IEC 15444-1), based on Jasper library 35KML Keyhole Markup Language (KML) 36 LIBKMLKeyhole Markup Language (LIBKML) 37 MapInfo File MapInfo File 38 Memory
Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT
Gesendet: Dienstag, 10. Oktober 2017 um 22:52 Uhr Von: "Veronica Andreo"An: "Roger Bivand" Cc: "grass-stats@lists.osgeo.org" , "Helmut Kudrnovsky" 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
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-8LC_COLLATE=en_US.UTF-8 [5] LC_MONETARY=en_US.UTF-8LC_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 AVCBinArc/Info Binary Coverage 5 AVCE00 Arc/Info E00 (ASCII) Coverage 6 BNA Atlas BNA 7 Carto Carto 8Cloudant Cloudant / CouchDB 9 CouchDB CouchDB / GeoCouch 10CSVComma Separated Value (.csv) 11CSW OGC CSW (Catalog Service for the Web) 12DGNMicrostation DGN 13DXF AutoCAD DXF 14 EDIGEO French EDIGEO exchange format 15 ElasticSearch Elastic Search 16 ESRI Shapefile ESRI Shapefile 17 Geoconcept Geoconcept 18GeoJSON GeoJSON 19 Geomedia Geomedia .mdb 20 GeoRSS GeoRSS 21GFTGoogle Fusion Tables 22GML Geography Markup Language (GML) 23 GPKG GeoPackage 24 GPSBabel GPSBabel 25 GPSTrackMaker GPSTrackMaker 26GPX GPX 27HTFHydrographic Transfer Vector 28 HTTP HTTP Fetching Wrapper 29 IdrisiIdrisi Vector (.vct) 30 Interlis 1 Interlis 1 31 Interlis 2 Interlis 2 32JMLOpenJUMP JML 33JP2OpenJPEG JPEG-2000 driver based on OpenJPEG library 34 JPEG2000 JPEG-2000 part 1 (ISO/IEC 15444-1), based on Jasper library 35KML Keyhole Markup Language (KML) 36 LIBKMLKeyhole Markup Language (LIBKML) 37 MapInfo FileMapInfo File 38 Memory Memory 39 MSSQLSpatial Microsoft SQL Server Spatial Database 40 MySQL MySQL 41NAS NAS - ALKIS 42 netCDF Network Common Data Format 43 ODBC ODBC 44ODSOpen Document/ LibreOffice / OpenOffice Spreadsheet 45 OGR_DODS OGR_DODS 46OGR_GMTGMT ASCII Vectors (.gmt) 47 OGR_OGDI OGDI Vectors (VPF, VMAP, DCW) 48OGR_PDSPlanetary Data Systems TABLE 49 OGR_SDTS SDTS 50OGR_VRTVRT - Virtual Datasource 51OpenAir OpenAir 52OpenFileGDBESRI FileGDB 53OSM OpenStreetMap XML and PBF 54 PCIDSKPCIDSK Database File 55PDF Geospatial PDF 56 PGDUMP PostgreSQL SQL dump 57 PGeo ESRI Personal GeoDatabase 58
Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT
>Von: "Roger Bivand">Please report sessionInfo() in R, and check the ogrDrivers() list. sessionInfo() already posted in the mail before, here again: > sessionInfo() R version 3.4.0 (2017-04-21) Platform: x86_64-w64-mingw32/x64 (64-bit) Running under: Windows 10 x64 (build 15063) Matrix products: default locale: [1] C attached base packages: [1] stats graphics grDevices utils datasets methods base loaded via a namespace (and not attached): [1] compiler_3.4.0 and > ogrDrivers() Error in ogrDrivers() : could not find function "ogrDrivers" ___ grass-stats mailing list grass-stats@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-stats
Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT
Please report sessionInfo() in R, and check the ogrDrivers() list. Roger Bivand Norwegian School of Economics Bergen, Norway On Tue, Oct 10, 2017 at 10:03 PM +0200, "Helmut Kudrnovsky"> wrote: >Are SQLite and GML drivers disabled/broken in readVECT? some earlier discussions I remembered: https://lists.osgeo.org/pipermail/grass-stats/2015-July/001561.html https://lists.osgeo.org/pipermail/grass-stats/2015-July/001562.html [...] https://lists.osgeo.org/pipermail/grass-stats/2015-June/date.html - best regards Helmut -- Sent from: http://osgeo-org.1560.x6.nabble.com/Grass-Stats-f4049448.html ___ grass-stats mailing list grass-stats@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-stats ___ grass-stats mailing list grass-stats@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-stats
Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT
>Are SQLite and GML drivers disabled/broken in readVECT? some earlier discussions I remembered: https://lists.osgeo.org/pipermail/grass-stats/2015-July/001561.html https://lists.osgeo.org/pipermail/grass-stats/2015-July/001562.html [...] https://lists.osgeo.org/pipermail/grass-stats/2015-June/date.html - best regards Helmut -- Sent from: http://osgeo-org.1560.x6.nabble.com/Grass-Stats-f4049448.html ___ grass-stats mailing list grass-stats@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-stats
Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT
>> bla2<-readVECT("census_wake2000") >Exporting 105 areas (may take some time)... >Warning 1: Value 120426752 of field AREA of feature 23 not successfully written. Possibly due to too larger >number with respect to field width testing by: v.out.ogr input=census_wake2000@PERMANENT output=D:\wd\test\slkdf\census_wake2000.sqlite format=SQLite D:\wd\test\slkdf>ogrinfo census_wake2000.sqlite INFO: Open of `census_wake2000.sqlite' using driver `SQLite' successful. 1: census_wake2000 (Polygon) D:\wd\test\slkdf>ogr2ogr test.shp census_wake2000.sqlite Warning 1: Value 120426752 of field area of feature 23 not successfully written. Possibly due to too larger number with respect to field width Warning 1: Value 108540592 of field area of feature 24 not successfully written. Possibly due to too larger number with respect to field width the same warning as in readVect. OTOH loading the test.shp in QGIS, it seems that the area value is successfully written into the shapefile dbf attribute table. maybe worth to ask in the GDAL ML for clarification for these warnings. - best regards Helmut -- Sent from: http://osgeo-org.1560.x6.nabble.com/Grass-Stats-f4049448.html ___ grass-stats mailing list grass-stats@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-stats
Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT
Hi Helli, 2017-10-10 21:24 GMT+02:00 Helmut Kudrnovsky: > >For some vectors, I get the following warnings (loss of data apparently): > > > >> bla2<-readVECT("census_wake2000") > >Exporting 105 areas (may take some time)... > >Warning 1: Value 120426752 of field AREA of feature 23 not successfully > written. Possibly due to too larger >number with respect to field width > >Warning 1: Value 108540592 of field AREA of feature 24 not successfully > written. Possibly due to too larger >number with respect to field width > > it seems to be a shapefile/(ogr) issue, see: > > v.out.ogr input=census_wake2000@PERMANENT > output=D:\wd\test\slkdf\census_wake2000.shp format=ESRI_Shapefile > Exporting 105 areas (may take some time)... > Warning 1: Value 120426752 of field AREA of feature 23 not > successfully written. Possibly due to too larger number with > respect to field width > Warning 1: Value 108540592 of field AREA of feature 24 not > successfully written. Possibly due to too larger number with > respect to field width > Warning 1: Value 136831232 of field AREA of feature 26 not > successfully written. Possibly due to too larger number with > respect to field width > Warning 1: Value 133581472 of field AREA of feature 37 not > successfully written. Possibly due to too larger number with > respect to field width > Warning 1: Value 186611808 of field AREA of feature 42 not > successfully written. Possibly due to too larger number with > respect to field width > Warning 1: Value 645046656 of field AREA of feature 43 not > successfully written. Possibly due to too larger number with > respect to field width > Warning 1: Value 550580288 of field AREA of feature 44 not > successfully written. Possibly due to too larger number with > respect to field width > thanks for testing :) and yes, precisely because shapefile has that limitation, I would rather to use SQLite (which was working some months ago, say June, but in some months things might change) Vero ___ grass-stats mailing list grass-stats@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-stats
Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT
>For some vectors, I get the following warnings (loss of data apparently): > >> bla2<-readVECT("census_wake2000") >Exporting 105 areas (may take some time)... >Warning 1: Value 120426752 of field AREA of feature 23 not successfully written. Possibly due to too larger >number with respect to field width >Warning 1: Value 108540592 of field AREA of feature 24 not successfully written. Possibly due to too larger >number with respect to field width it seems to be a shapefile/(ogr) issue, see: v.out.ogr input=census_wake2000@PERMANENT output=D:\wd\test\slkdf\census_wake2000.shp format=ESRI_Shapefile Exporting 105 areas (may take some time)... Warning 1: Value 120426752 of field AREA of feature 23 not successfully written. Possibly due to too larger number with respect to field width Warning 1: Value 108540592 of field AREA of feature 24 not successfully written. Possibly due to too larger number with respect to field width Warning 1: Value 136831232 of field AREA of feature 26 not successfully written. Possibly due to too larger number with respect to field width Warning 1: Value 133581472 of field AREA of feature 37 not successfully written. Possibly due to too larger number with respect to field width Warning 1: Value 186611808 of field AREA of feature 42 not successfully written. Possibly due to too larger number with respect to field width Warning 1: Value 645046656 of field AREA of feature 43 not successfully written. Possibly due to too larger number with respect to field width Warning 1: Value 550580288 of field AREA of feature 44 not successfully written. Possibly due to too larger number with respect to field width - best regards Helmut -- Sent from: http://osgeo-org.1560.x6.nabble.com/Grass-Stats-f4049448.html ___ grass-stats mailing list grass-stats@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-stats
Re: [GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT
>Are SQLite and GML drivers disabled/broken in readVECT? I only get driver="ESRI Shapefile" to work, confirmed by: --- > sessionInfo() R version 3.4.0 (2017-04-21) Platform: x86_64-w64-mingw32/x64 (64-bit) Running under: Windows 10 x64 (build 15063) Matrix products: default locale: [1] C attached base packages: [1] stats graphics grDevices utils datasets methods base other attached packages: [1] rgrass7_0.1-9 XML_3.98-1.9 sp_1.2-5 loaded via a namespace (and not attached): [1] compiler_3.4.0 rgdal_1.2-12grid_3.4.0 lattice_0.20-35 --- only driver="ESRI Shapefile" works here. trying SQLite: > bla5 <- readVECT("firestations", driver="SQLite") Supported formats: Error: driver %in% candDrivers is not TRUE - best regards Helmut -- Sent from: http://osgeo-org.1560.x6.nabble.com/Grass-Stats-f4049448.html ___ grass-stats mailing list grass-stats@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-stats
[GRASS-stats] rgrass7 - SQLite and GML drivers not working for readVECT
Hello all, Are SQLite and GML drivers disabled/broken in readVECT? I only get driver="ESRI Shapefile" to work, but in some cases with a lot of warnings. Here an example with NC location: grass73svn grassdata/nc_spm_08_grass7/PERMANENT/ --text ... GRASS 7.3.svn (nc_spm_08_grass7):~ > R ... >library(rgrass7) ... > bla <- readVECT("firestations", driver="SQLite") Error: driver %in% candDrivers is not TRUE > bla <- readVECT("firestations", driver="GML") Error: driver %in% candDrivers is not TRUE > bla <- readVECT("firestations", driver="ESRI Shapefile") Exporting 71 features... 100% v.out.ogr complete. 71 features (Point type) written to (ESRI_Shapefile format). OGR data source with driver: ESRI Shapefile Source: "/home/veroandreo/grassdata/nc_spm_08_grass7/PERMANENT/.tmp/ ipv6.dynamic.ziggo.nl", layer: "firestat" with 71 features It has 22 fields For some vectors, I get the following warnings (loss of data apparently): > bla2<-readVECT("census_wake2000") Exporting 105 areas (may take some time)... Warning 1: Value 120426752 of field AREA of feature 23 not successfully written. Possibly due to too larger number with respect to field width Warning 1: Value 108540592 of field AREA of feature 24 not successfully written. Possibly due to too larger number with respect to field width [...] Warning 1: Value 439922656 of field AREA of feature 102 not successfully written. Possibly due to too larger number with respect to field width Warning 1: Value 678758336 of field AREA of feature 103 not successfully written. Possibly due to too larger number with respect to field width 100% Warning 1: Value 439045472 of field AREA of feature 104 not successfully written. Possibly due to too larger number with respect to field width v.out.ogr complete. 105 features (Polygon type) written to (ESRI_Shapefile format). OGR data source with driver: ESRI Shapefile Source: "/home/veroandreo/grassdata/nc_spm_08_grass7/PERMANENT/.tmp/ ipv6.dynamic.ziggo.nl", layer: "census_w" with 105 features It has 13 fields Thanks a lot in advance for any hint best, Vero ___ grass-stats mailing list grass-stats@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-stats