[GRASS5] v.external, OGR/OCI and v.in.ogr

[Stephan Holl]

Hello Radim, 

On Mon, 12 Dec 2005 09:11:21 +0100 Radim Blazek
<radim.blazek at gmail.com> wrote:

> On 12/9/05, Stephan Holl <holl at gdf-hannover.de> wrote:
> > Hello Radim, Frank,
> >
> > On Fri, 9 Dec 2005 11:49:10 +0100 Radim Blazek
> > <radim.blazek at gmail.com> wrote:
> >
> > > It seems to be a bug in Oracle driver for OGR.
> > > FID is assigned to features by OGR and it is different for
> > > each driver. It has nothing to do with GRASS.
> >
> > I see. You already have CCed this to Frank.
> >
> > But why does ogr2ogr work from shapefile to Oracle correctly?
> 
> How the tables differ?  ogr2ogr probably adds a column
> which is then used as FID. But that is not something v.out.ogr
> should do, in my opinion!

gdf at linux:~> ogrinfo -ro "OCI:holl/pw at ORACLESP" ROADS_SPEARFISH60
-summary 
INFO: Open of `OCI:holl/pw at ORACLESP'
using driver `OCI' successful.

Layer name: ROADS_SPEARFISH60
Geometry: Unknown (any)
Feature Count: 825
Extent: (589434.856469, 4914006.337837) - (609527.210215,
4928063.398015) Layer SRS WKT:
PROJCS["UTM Zone 13, Northern Hemisphere",
    GEOGCS["clark66",
        DATUM["North_American_Datum_1927",
            SPHEROID["clark66",6378206.4,294.9786982]],
        PRIMEM["Greenwich",0],
        UNIT["Decimal Degree",0.0174532925199433]],
    PROJECTION["Transverse_Mercator"],
    PARAMETER["latitude_of_origin",0],
    PARAMETER["central_meridian",-105],
    PARAMETER["scale_factor",0.9996],
    PARAMETER["false_easting",500000],
    PARAMETER["false_northing",0],
    UNIT["meter",1]]
cat: Integer (0.0)
label: String (2047.0)
column3: Integer (0.0)
gdf at linux:~> ogrinfo -ro "OCI:holl/pw at ORACLESP"
ROADS_SPEARFISH_SHP -summary 
INFO: Open of `OCI:holl/pw at ORACLESP' using driver `OCI' successful.

Layer name: ROADS_SPEARFISH_SHP
Geometry: Unknown (any)
Feature Count: 825
Extent: (589434.856469, 4914006.337837) - (609527.210215,
4928063.398015) Layer SRS WKT:
PROJCS["UTM Zone 13, Northern Hemisphere",
    GEOGCS["clark66",
        DATUM["North_American_Datum_1927",
            SPHEROID["clark66",6378206.4,294.9786982]],
        PRIMEM["Greenwich",0],
        UNIT["Decimal Degree",0.0174532925199433]],
    PROJECTION["Transverse_Mercator"],
    PARAMETER["latitude_of_origin",0],
    PARAMETER["central_meridian",-105],
    PARAMETER["scale_factor",0.9996],
    PARAMETER["false_easting",500000],
    PARAMETER["false_northing",0],
    UNIT["meter",1]]
cat: Integer (11.0)
label: String (80.0)
column3: Integer (11.0)
gdf at linux:~>  

When I log into Oracle, both datasets habe the same FID-colum
(OGR_FID), but the one GRASS created is always 1 and does not increment.

I am stuck.

Where should I start searching for the errors?

Thanks

	Stephan

-- 
GDF Hannover - Solutions for spatial data analysis and remote sensing
Hannover Office      -     Mengendamm 16d      -     D-30177 Hannover
Internet: www.gdf-hannover.de      -      Email: holl at gdf-hannover.de
Phone : ++49-(0)511.39088507       -        Fax: ++49-(0)511.39088508