[GRASS-dev] DBF SQL extract error w/ external vector map

Hamish hamish_nospam at yahoo.com
Wed Mar 7 20:21:13 EST 2007


Hi,

6.3cvs (1-2 days old), OGR linked shapefile (v.external),


G63> v.extract in=admin98 out=antarctica98 \
         where="ADMIN_NAME = 'Antarctica'"

Load cats from the database (table = admin98, db =
/home/hamish/grassdata/world_ll/PERMANENT/external).
1 cats loaded from the database
Building topology ...
276 primitives registered      
Building areas:  100%
138 areas built      
138 isles built
Attaching islands:  100%
Attaching centroids:  100%
Topology was built.
Number of nodes     :   276
Number of primitives:   276
Number of points    :   0
Number of lines     :   0
Number of boundaries:   138
Number of centroids :   138
Number of areas     :   138
Number of isles     :   138
Writing attributes ...
Layer 1
ERROR 1: SQL: Failed to identify field:0
DBMI-OGR driver error:
Cannot select: 
select * from admin98 where 0 = 1

WARNING: Cannot open select cursor: 'select * from admin98 where 0 = 1'
WARNING: Cannot copy table
Done.



The vector map is extracted ok, but the attr table isn't copied.
 |   Number of dblinks:      0  


?,
Hamish

ps - general IPY interest of what happens in a "corner" case:
pic of output v.proj'd into EPSG#3033 attached (LCC). blue crosses
indicate +lat_1 and +lat_2 for the projection, centered on the Lambert
Glacier (no relation) and Amery Ice Shelf. d.grid -g goes a bit nuts
once you zoom out so far from the projection's region of purpose; v.proj
held up pretty well except for directly across from +lon_0=70 (middle
bottom). 180 lon break is there but easily cleaned with v.clean tool=rmsa
PROJ4 values for EPSG Polar Stereographic epsg codes don't exist.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Amery.png
Type: image/png
Size: 15341 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/grass-dev/attachments/20070308/4352ad1e/Amery.png


More information about the grass-dev mailing list