Opened 7 years ago

Closed 7 years ago

#3333 closed defect (duplicate)

v.import/v.in.ogr - GUI regression in import from a SQLITE/SPATIALITE db

Reported by: hellik Owned by: grass-dev@…
Priority: normal Milestone: 7.2.1
Component: Vector Version: 7.2.0
Keywords: import, sqlite Cc:
CPU: All Platform: All

Description

taken from the dev ML ​[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?

Change History (1)

comment:1 by marisn, 7 years ago

Resolution: → duplicate
Status: new → closed

Already reported as #3308

Note: See TracTickets for help on using tickets.