[GRASS-user] Error using v.in.ogr to load a shapefile: any clue?

Corrado ct529 at york.ac.uk
Mon Mar 10 11:52:28 EDT 2008


Dear friends,

I get this error when trying to read the Scotland.shp shape file using 
v.in.ogr. Please, not that I have the proper permissions on the databse.

GRASS 6.2.3 (Scotland_from_shapefile):~ > v.in.ogr 
dsn=/home/ct529/Documents/Projects/UKBryophytes/Datasets/SSSI_vectors/SCOTLAND.shp 
output=Scotland_SSSI layer=SCOTLAND min_area=0.0001 snap=-1 
location=SCOTLAND_SSSI
A datum name osgb36 (OSGB_1936) was specified without transformation 
parameters.

Now select Datum Transformation Parameters
Please think carefully about the area covered by your data
and the accuracy you require before making your selection.

Enter 'list' to see the list of available Parameter sets
Enter the corresponding number, or <RETURN> to cancel request
>2
Layer: SCOTLAND
WARNING: Default driver / database set to:
         driver: dbf
         database: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
DBMI-DBF driver error:
SQL parser error in statement:
create table Scotland_SSSI (cat integer, AREA double precision, PERIMETER 
double precision, SSSI_ double precision, SSSI_ID double precision, 
CARTO_CODE varchar ( 8 ), OVERLAP_CO varchar ( 8 ), SITE_NAME varchar ( 
100 ), SITE_HA double precision, NOTIFIED date, COUNCIL varchar ( 100 ), TYPE 
varchar ( 10 ), MIDAS_NUM double precision, UPDATE varchar ( 30 ))
Error in db_execute_immediate()

ERROR: Cannot create table: create table Scotland_SSSI (cat integer, AREA
       double precision, PERIMETER double precision, SSSI_ double
       precision, SSSI_ID double precision, CARTO_CODE varchar ( 8 ),
       OVERLAP_CO varchar ( 8 ), SITE_NAME varchar ( 100 ), SITE_HA double
       precision, NOTIFIED date, COUNCIL varchar ( 100 ), TYPE varchar ( 10
       ), MIDAS_NUM double precision, UPDATE varchar ( 30 ))
GRASS 6.2.3 (Scotland_from_shapefile):~ >



Best regards
-- 
Corrado Topi

Global Climate Change & Biodiversity Indicators
Area 18,Department of Biology
University of York, York, YO10 5YW, UK
Phone: + 44 (0) 1904 328645, E-mail: ct529 at york.ac.uk


More information about the grass-user mailing list