[GRASS-dev] How to import from a spatialite/sqlite db by v.in.ogr?

[Helmut Kudrnovsky]

database can be downloaded here:

http://www.eea.europa.eu/data-and-maps/data/biogeographical-regions-europe-3

----
ogrinfo -al -so BiogeoRegions2016.sqlite
INFO: Open of `BiogeoRegions2016.sqlite'
      using driver `SQLite' successful.

Layer name: biogeoregions2016
Geometry: Multi Polygon
Feature Count: 12
Extent: (943611.000000, 600000.000000) - (8500000.000000, 7800000.000000)
Layer SRS WKT:
PROJCS["ETRS89 / LAEA Europe",
    GEOGCS["ETRS89",
        DATUM["European_Terrestrial_Reference_System_1989",
            SPHEROID["GRS 1980",6378137,298.257222101,
                AUTHORITY["EPSG","7019"]],
            TOWGS84[0,0,0,0,0,0,0],
            AUTHORITY["EPSG","6258"]],
        PRIMEM["Greenwich",0,
            AUTHORITY["EPSG","8901"]],
        UNIT["degree",0.0174532925199433,
            AUTHORITY["EPSG","9122"]],
        AUTHORITY["EPSG","4258"]],
    PROJECTION["Lambert_Azimuthal_Equal_Area"],
    PARAMETER["latitude_of_center",52],
    PARAMETER["longitude_of_center",10],
    PARAMETER["false_easting",4321000],
    PARAMETER["false_northing",3210000],
    UNIT["metre",1,
        AUTHORITY["EPSG","9001"]],
    AUTHORITY["EPSG","3035"]]
FID Column = PK_UID
Geometry Column = geometry
short_name: String (0.0)
pre_2012: String (0.0)
code: String (0.0)
name: String (0.0)
----

test which layer are in the db:

----
v.in.ogr -l input=BiogeoRegions2016.sqlite
biogeoregions2016
Data source <BiogeoRegions2016.sqlite> (format 'SQLite') contains 1 layers:
----

a layer can be seen by v.in.ogr (see the messed output)

then try to import:

----
v.in.ogr input=BiogeoRegions2016.sqlite layer=biogeoregions2016|geometry
output=test where=short_name = 'alpine'
ERROR: Layer <biogeoregions2016^^^|geometry> not available
----

it seems the geometry column of the can't be found by v.in.ogr.

but trying:

----
ogr2ogr -where "short_name = 'alpine'" test.shp BiogeoRegions2016.sqlite
----

works without any problems.

tested with

System Info                                                                     
GRASS version: 7.3.svn                                                          
GRASS SVN revision: r70874M                                                     
Build date: 2017-04-15                                                          
Build platform: x86_64-w64-mingw32                                              
GDAL: 2.1.3                                                                     
PROJ.4: 4.9.3                                                                   
GEOS: 3.5.0                                                                     
SQLite: 3.17.0                                                                  
Python: 2.7.5                                                                   
wxPython: 2.8.12.1                                                              
Platform: Windows-8-6.2.9200 (OSGeo4W) 

any ideas?



-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-import-from-a-spatialite-sqlite-db-by-v-in-ogr-tp5317435.html
Sent from the Grass - Dev mailing list archive at Nabble.com.