[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