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

[Stephan Holl]

Hello Radim,

On Fri, 2 Dec 2005 10:13:51 +0100 Stephan Holl <holl at gdf-hannover.de>
wrote:

> Hello Radim, 
> 
> thanks for the quick response.
> 
> 
> On Fri, 2 Dec 2005 09:38:54 +0100 Radim Blazek
> <radim.blazek at gmail.com> wrote:
> 
> > The problem is obviously missing FID. Try 2 things
> > 1) remove topo file and try to run d.vect
> 
> Yes, after removing the topo-file d.vect shows up the vector-lines,
> but v.info complains about the missing topo-file.
> ERROR: Cannot open old vector roads_OCI at user1 on level 2
> 
> Is this a bug or a feature?
> 
> > 2) try to add FID column (unique id) to the table
> 
> Isnt that the job of v.external when "importing/linking"? AFAIK a
> unique colums is in the table:
> v.db.select roads_OCI|head
> ERROR 1: ORA-00904: "FID": invalid identifier
>  in select FID from ROADS_SPEARFISH60_2 where FID > 0
> ERROR 1: ORA-00904: "OGC_FID": invalid identifier
>  in select ogc_fid from ROADS_SPEARFISH60_2 where ogc_fid > 0
> Using ogr_fid column in OGR DB
> OGR_FID|cat|label|column3
> 1|5|unimproved road|0
> 1|5|unimproved road|0
> 1|5|unimproved road|0
> 1|5|unimproved road|0
> 1|5|unimproved road|0
> 1|5|unimproved road|0
> 1|4|light-duty road, improved surface|0
> 1|5|unimproved road|0
> 1|5|unimproved road|0
> GRASS 6.1.cvs (spearfish60):~/spearfish60/user1/vector/roads_OCI > 
> 
> Thanks for looking into this.

I cannot understand the above thing about topology-info. In short,
Linked OCI-based dataset with v.external does not show in the display
unless I remove the topo-file. But then nearly no other vector-modules
are working.

Is this a Bug or a feature?!

Best
	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