[GRASS5] v.out.ogr and v.external does not work

[Markus Neteler]

Jachym,

I have already implemented an auto-detector of
the FID column, but it doesn't work yet.
Asap I hope to have it in CVS.

Then these problems should disappear.

ciao

 Markus

On Fri, Mar 10, 2006 at 07:21:39PM +0100, Jachym Cepicky wrote:
> I upgraded to postgis-1.1.1 and seems to work
> 
> only error, i get is
> 
> ERROR 1: ERROR:  column "fid" does not exist
> 
> 
> but it is running so I'll let it be
> 
> jachym
> 
> On Fri, Mar 10, 2006 at 03:58:58PM +0100, Jachym Cepicky wrote:
> > Hallo,
> > I try to "v.out.ogr" some polygon map from GRASS to PosgreSQL (postgis),
> > which I do trough
> > 
> > GRASS: ~> v.out.ogr input=det at idrisi type=area  dsn="PG:dbname=krtiny"  olayer=det format=PostgreSQL
> > 
> > After that, two tables (one table and one sequence) are created:
> > 
> > psql=> \d det
> >    Column     |        Type       |                       Modifikátory                       
> > --------------+-------------------+----------------------------------------------------------
> >  ogc_fid      | integer           | not null default nextval('public.det_ogc_fid_seq'::text)
> >  wkb_geometry | geometry          | 
> >  cat          | integer           | 
> >  cislo        | integer           | 
> >  plocha       | double precision  | 
> >  vymera       | double precision  | 
> >  kvalita      | integer           | 
> >  katastr      | character varying | 
> >  ku_kod       | integer           | 
> >  sk_parc      | character varying | 
> >  oddeleni     | integer           | 
> > ...
> > 
> > psql=> Sequence "public.det_ogc_fid_seq"
> > krtiny=> Sequence "public.det_ogc_fid_seq"
> >     Sloupec    |   Typ     |   Typ    | Vlastník 
> > ---------------+-----------+----------+----------
> >  sequence_name | name      | tabulka  | jachym
> >  last_value    | bigintseq | sequence | jachym
> >  increment_by  | bigintmns | tabulka  | jachym
> >  max_value     | bigint    | tabulka  | jachym
> >  min_value     | bigint    | sequence | jachym
> >  cache_value   | bigintys  | tabulka  | jachym
> >  log_cnt       | bigint    | tabulka  | jachym
> >  is_cycled     | boolean   | sequence | jachym
> > ...
> > 
> > 
> > when I try to "v.extrude" this table, I get following error:
> > 
> > GRASS: ~> v.external dsn="PG: dbname=krtiny" out=det  layer=det
> > ERROR 1: ERROR:  column "fid" does not exist
> > 
> > ERROR 1: ERROR:  column "ogr_fid" does not exist
> > 
> > Vytvá?ím topologii ...
> > Feature:    0
> > Topologie byla vytvo?ena.
> > Po?et uzl?          :   0
> > Po?et primitiv      :   0
> > Po?et bod?          :   0
> > Po?et linií         :   0
> > Po?et hranic        :   0
> > Po?et centroid?     :   0
> > Po?et ploch         :   0
> > Po?et ostrov?       :   0
> > 
> > GRASS: ~> d.vect det
> > WARNING: 'vector/det/head' was found in more mapsets (also found in
> >          stromy).
> > ERROR 1: ERROR:  column "fid" does not exist
> > 
> > ERROR 1: ERROR:  column "ogr_fid" does not exist
> > 
> > The bounding box of the map outside current region, nothing displayed.
> > 
> > What to do?
> > 
> > Thanks
> > 
> > Jachym
> > 
> > 
> > -- 
> > Jachym Cepicky                                  
> > e-mail: jachym.cepicky at centrum.cz           
> > URL: http://les-ejk.cz                      
> > GPG: http://les-ejk.cz/gnupg_public_key/    
> > -----------------------------------------   
> > OFFICE:                                     
> > Department of Geoinformation Technologies   
> > LDF MZLU v Brn?                             
> > Zem?d?lská 3                                
> > 613 00 Brno                                 
> > e-mail: xcepicky at node.mendelu.cz            
> > URL:    http://mapserver.mendelu.cz
> > Tel.:   +420 545 134 514
> > 
> > _______________________________________________
> > grass5 mailing list
> > grass5 at grass.itc.it
> > http://grass.itc.it/mailman/listinfo/grass5
> 
> -- 
> Jachym Cepicky                                  
> e-mail: jachym.cepicky at centrum.cz           
> URL: http://les-ejk.cz                      
> GPG: http://les-ejk.cz/gnupg_public_key/    
> -----------------------------------------   
> OFFICE:                                     
> Department of Geoinformation Technologies   
> LDF MZLU v Brn?                             
> Zem?d?lská 3                                
> 613 00 Brno                                 
> e-mail: xcepicky at node.mendelu.cz            
> URL:    http://mapserver.mendelu.cz
> Tel.:   +420 545 134 514
> 
> _______________________________________________
> grass5 mailing list
> grass5 at grass.itc.it
> http://grass.itc.it/mailman/listinfo/grass5

-- 
Markus Neteler     <neteler itc it>       http://mpa.itc.it
ITC-irst -  Centro per la Ricerca Scientifica e Tecnologica
MPBA - Predictive Models for Biol. & Environ. Data Analysis
Via Sommarive, 18        -       38050 Povo (Trento), Italy