#3333: v.import/v.in.ogr - GUI regression in import from a SQLITE/SPATIALITE db
----------------------------+-------------------------
Reporter: hellik | Owner: grass-dev@…
Type: defect | Status: new
Priority: normal | Milestone: 7.2.1
Component: Vector | Version: 7.2.0
Keywords: import, sqlite | CPU: All
Platform: All |
----------------------------+-------------------------
taken from the dev ML [https://lists.osgeo.org/pipermail/grass-
dev/2017-April/084764.html [GRASS-dev] How to import from a
spatialite/sqlite db by v.in.ogr?]
{{{
Martin Landa wrote
> Hi,
>
> 2017-04-16 22:40 GMT+02:00 Helmut Kudrnovsky <
> hellik@
> >:
>> v.in.ogr -l input=BiogeoRegions2016.sqlite
>> biogeoregions2016
>
> [...]
>
>> Data source
> <BiogeoRegions2016.sqlite>
> (format 'SQLite') contains 1 layers:
>> v.in.ogr input=BiogeoRegions2016.sqlite
layer=biogeoregions2016|geometry
>> output=test where=short_name = 'alpine'
>> ERROR: Layer <biogeoregions2016^^^|geometry> not available
>
> why not
>
> layer=biogeoregions2016
yes, the bioregions2016|geometry is autogenerated by the v.in.ogr-GUI!
tested the cmd on the command line without "|geometry"
C:\>v.in.ogr input=BiogeoRegions2016.sqlite layer=biogeoregions2016
output=testoncmdline where="short_name = 'alpine'"
Check if OGR layer <biogeoregions2016> contains polygons...
100%
WARNING: Width for column short_name set to 255 (was not specified by
OGR),
some strings may be truncated!
WARNING: Width for column pre_2012 set to 255 (was not specified by OGR),
some strings may be truncated!
WARNING: Width for column code set to 255 (was not specified by OGR), some
strings may be truncated!
WARNING: Width for column name set to 255 (was not specified by OGR), some
strings may be truncated!
Importing 1 features (OGR layer <biogeoregions2016>)...
100%
-----------------------------------------------------
Registering primitives...
27 primitives registered
48947 vertices registered
Number of nodes: 27
Number of primitives: 27
Number of points: 0
Number of lines: 0
Number of boundaries: 27
Number of centroids: 0
Number of areas: -
Number of isles: -
-----------------------------------------------------
Cleaning polygons
-----------------------------------------------------
Breaking polygons...
Breaking polygons (pass 1: select break points)...
100%
Breaking polygons (pass 2: break at selected points)...
100%
-----------------------------------------------------
Removing duplicates...
100%
-----------------------------------------------------
Breaking boundaries...
100%
-----------------------------------------------------
Removing duplicates...
100%
-----------------------------------------------------
Cleaning boundaries at nodes...
100%
-----------------------------------------------------
Merging boundaries...
100%
-----------------------------------------------------
Removing dangles...
100%
-----------------------------------------------------
Building areas...
100%
27 areas built
27 isles built
Number of nodes: 27
Number of primitives: 27
Number of points: 0
Number of lines: 0
Number of boundaries: 27
Number of centroids: 0
Number of areas: 27
Number of isles: 27
-----------------------------------------------------
Removing bridges...
100%
-----------------------------------------------------
Registering primitives...
27 primitives registered
48947 vertices registered
Building areas...
100%
27 areas built
27 isles built
Attaching islands...
100%
Number of nodes: 27
Number of primitives: 27
Number of points: 0
Number of lines: 0
Number of boundaries: 27
Number of centroids: 0
Number of areas: 27
Number of isles: 27
-----------------------------------------------------
Finding centroids for OGR layer <biogeoregions2016>...
100%
-----------------------------------------------------
Writing centroids...
100%
-----------------------------------------------------
27 input polygons
Total area: 9.48235E+011 (27 areas)
-----------------------------------------------------
Copying features...
100%
Building topology for vector map <testoncmdline at vecdata>...
Registering primitives...
54 primitives registered
48974 vertices registered
Building areas...
100%
27 areas built
27 isles built
Attaching islands...
100%
Attaching centroids...
100%
Number of nodes: 27
Number of primitives: 54
Number of points: 0
Number of lines: 0
Number of boundaries: 27
Number of centroids: 27
Number of areas: 27
Number of isles: 27
it's imported correctly.
it's a GUI regression.
should I open a ticket?
}}}
--
Ticket URL: <https://trac.osgeo.org/grass/ticket/3333>
GRASS GIS <https://grass.osgeo.org>