[GRASSLIST:6270] v.in.ogr error

GRASS GRASS user
1

What is implied by the error:

GRASS 6.0.0 (arrowhead_utm):~ > v.in.ogr -o dsn=/Users/kirkw/projects/wrf/grids/ layer=forties output=forties
Over-riding projection check.
Proceeding with import...
Layer: forties
DBMI-DBF driver error:
Column 'PLS_FORTYP' already exists (duplicate name)
Cannot create table.
Error in db_execute_immediate()

ERROR: Cannot create table: create table forties_grid (cat integer, AREA
        double precision, PERIMETER double precision, PLS_FORTYP integer,
        PLS_FORTYP integer, COUN integer, TOWN integer, RDIR integer, RANG
        integer, SECT integer, FORT integer, GLOT integer, PARC integer,
        FORT_DESC varchar ( 40 ), GLOTMATCH integer, GEOPARC integer,
        GEOGLOT integer, GEOFORT integer, GEOSECT integer, GEORANG integer,
        HECTARES double precision)

I am trying to import some shape files into utm location in grass6.0. The shape files have the naming scheme:
forties.dbf
forties.sbn
forties.sbx
forties.shp
forties.shx

Thanks,

Kirk

2

On Mon, March 28, 2005 19:23, Kirk R. Wythers said:

What is implied by the error:

GRASS 6.0.0 (arrowhead_utm):~ > v.in.ogr -o
dsn=/Users/kirkw/projects/wrf/grids/ layer=forties output=forties
Over-riding projection check.
Proceeding with import...
Layer: forties
DBMI-DBF driver error:
Column 'PLS_FORTYP' already exists (duplicate name)
Cannot create table.
Error in db_execute_immediate()

ERROR: Cannot create table: create table forties_grid (cat integer, AREA
        double precision, PERIMETER double precision, PLS_FORTYP integer,
        PLS_FORTYP integer, COUN integer, TOWN integer, RDIR integer,
RANG
        integer, SECT integer, FORT integer, GLOT integer, PARC integer,
        FORT_DESC varchar ( 40 ), GLOTMATCH integer, GEOPARC integer,
        GEOGLOT integer, GEOFORT integer, GEOSECT integer, GEORANG
integer,
        HECTARES double precision)

The problem is that your dbf file contains two columns with exactly the same
name (PLS_FORTYP) which is unacceptable for the database driver. Change one of
the column names in the table before using v.in.ogr or use the cnames option
of v.in.ogr.

Moritz

I am trying to import some shape files into utm location in grass6.0.
The shape files have the naming scheme:
forties.dbf
forties.sbn
forties.sbx
forties.shp
forties.shx

Thanks,

Kirk

3

Thank you Moritz. I just stumbled to the fact that the help documents on the web (http://grass.itc.it/grass60/manuals/html60_user/v.in.ogr.html) are more detailed (including additional information concerning v.in.ogr options) than those that are generated from the build and install process. I will look on the web in the future.

Kirk

On Mar 28, 2005, at 12:14 PM, Moritz Lennert wrote:

On Mon, March 28, 2005 19:23, Kirk R. Wythers said:

What is implied by the error:

GRASS 6.0.0 (arrowhead_utm):~ > v.in.ogr -o
dsn=/Users/kirkw/projects/wrf/grids/ layer=forties output=forties
Over-riding projection check.
Proceeding with import...
Layer: forties
DBMI-DBF driver error:
Column 'PLS_FORTYP' already exists (duplicate name)
Cannot create table.
Error in db_execute_immediate()

ERROR: Cannot create table: create table forties_grid (cat integer, AREA
        double precision, PERIMETER double precision, PLS_FORTYP integer,
        PLS_FORTYP integer, COUN integer, TOWN integer, RDIR integer,
RANG
        integer, SECT integer, FORT integer, GLOT integer, PARC integer,
        FORT_DESC varchar ( 40 ), GLOTMATCH integer, GEOPARC integer,
        GEOGLOT integer, GEOFORT integer, GEOSECT integer, GEORANG
integer,
        HECTARES double precision)

The problem is that your dbf file contains two columns with exactly the same
name (PLS_FORTYP) which is unacceptable for the database driver. Change one of
the column names in the table before using v.in.ogr or use the cnames option
of v.in.ogr.

Moritz

I am trying to import some shape files into utm location in grass6.0.
The shape files have the naming scheme:
forties.dbf
forties.sbn
forties.sbx
forties.shp
forties.shx

Thanks,

Kirk

4

On Mon, March 28, 2005 20:55, Kirk R. Wythers said:

Thank you Moritz. I just stumbled to the fact that the help documents
on the web
(http://grass.itc.it/grass60/manuals/html60_user/v.in.ogr.html) are
more detailed (including additional information concerning v.in.ogr
options) than those that are generated from the build and install
process. I will look on the web in the future.

This is weird. I have exactly the same manual page locally as the one on the
web. Maybe there was some error building the docs on your machine ?

Moritz

Kirk

On Mar 28, 2005, at 12:14 PM, Moritz Lennert wrote:

On Mon, March 28, 2005 19:23, Kirk R. Wythers said:

What is implied by the error:

GRASS 6.0.0 (arrowhead_utm):~ > v.in.ogr -o
dsn=/Users/kirkw/projects/wrf/grids/ layer=forties output=forties
Over-riding projection check.
Proceeding with import...
Layer: forties
DBMI-DBF driver error:
Column 'PLS_FORTYP' already exists (duplicate name)
Cannot create table.
Error in db_execute_immediate()

ERROR: Cannot create table: create table forties_grid (cat integer,
AREA
        double precision, PERIMETER double precision, PLS_FORTYP
integer,
        PLS_FORTYP integer, COUN integer, TOWN integer, RDIR integer,
RANG
        integer, SECT integer, FORT integer, GLOT integer, PARC
integer,
        FORT_DESC varchar ( 40 ), GLOTMATCH integer, GEOPARC integer,
        GEOGLOT integer, GEOFORT integer, GEOSECT integer, GEORANG
integer,
        HECTARES double precision)

The problem is that your dbf file contains two columns with exactly
the same
name (PLS_FORTYP) which is unacceptable for the database driver.
Change one of
the column names in the table before using v.in.ogr or use the cnames
option
of v.in.ogr.

Moritz

I am trying to import some shape files into utm location in grass6.0.
The shape files have the naming scheme:
forties.dbf
forties.sbn
forties.sbx
forties.shp
forties.shx

Thanks,

Kirk

5

On Mar 28, 2005, at 1:05 PM, Moritz Lennert wrote:

On Mon, March 28, 2005 20:55, Kirk R. Wythers said:

Thank you Moritz. I just stumbled to the fact that the help documents
on the web
(http://grass.itc.it/grass60/manuals/html60_user/v.in.ogr.html) are
more detailed (including additional information concerning v.in.ogr
options) than those that are generated from the build and install
process. I will look on the web in the future.

This is weird. I have exactly the same manual page locally as the one on the
web. Maybe there was some error building the docs on your machine ?

If there was, there is nothing in the error.log

Moritz

Kirk

On Mar 28, 2005, at 12:14 PM, Moritz Lennert wrote:

On Mon, March 28, 2005 19:23, Kirk R. Wythers said:

What is implied by the error:

GRASS 6.0.0 (arrowhead_utm):~ > v.in.ogr -o
dsn=/Users/kirkw/projects/wrf/grids/ layer=forties output=forties
Over-riding projection check.
Proceeding with import...
Layer: forties
DBMI-DBF driver error:
Column 'PLS_FORTYP' already exists (duplicate name)
Cannot create table.
Error in db_execute_immediate()

ERROR: Cannot create table: create table forties_grid (cat integer,
AREA
        double precision, PERIMETER double precision, PLS_FORTYP
integer,
        PLS_FORTYP integer, COUN integer, TOWN integer, RDIR integer,
RANG
        integer, SECT integer, FORT integer, GLOT integer, PARC
integer,
        FORT_DESC varchar ( 40 ), GLOTMATCH integer, GEOPARC integer,
        GEOGLOT integer, GEOFORT integer, GEOSECT integer, GEORANG
integer,
        HECTARES double precision)

The problem is that your dbf file contains two columns with exactly
the same
name (PLS_FORTYP) which is unacceptable for the database driver.
Change one of
the column names in the table before using v.in.ogr or use the cnames
option
of v.in.ogr.

Moritz

I am trying to import some shape files into utm location in grass6.0.
The shape files have the naming scheme:
forties.dbf
forties.sbn
forties.sbx
forties.shp
forties.shx

Thanks,

Kirk

6

>> Thank you Moritz. I just stumbled to the fact that the help
>> documents on the web
>> (http://grass.itc.it/grass60/manuals/html60_user/v.in.ogr.html) are
>> more detailed (including additional information concerning v.in.ogr
>> options) than those that are generated from the build and install
>> process. I will look on the web in the future.
>
> This is weird. I have exactly the same manual page locally as the
> one on the web. Maybe there was some error building the docs on your
> machine ?

If there was, there is nothing in the error.log

Look for "modules without description.html" towards the end of the build
process, not in error.log. Or cd vector/v.in.ogr/ and type "make" to
rerun the man page building for that module. e.g. it has been
demonstrated recently that running 'make -j 3' on a multi-processor
computer causes some of the help pages to not build properly.

The website version of a help page will in many cases be more up to date
than the release versions, as the website version is updated from the
latest CVS at least once a week. Looking at the v.in.ogr help page
though, there have been no changes since 6.0.0 was released:

http://freegis.org/cgi-bin/viewcvs.cgi/grass6/vector/v.in.ogr/description.html

Hamish