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

Jachym_Cepicky1 · March 10, 2006, 2:58pm

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@idrisi type=area dsn="PG:dbname=krtiny" olayer=det format=PostgreSQL

After that, two tables (one table and one sequence) are created:

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@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@node.mendelu.cz
URL: http://mapserver.mendelu.cz
Tel.: +420 545 134 514

Jachym_Cepicky1 · March 10, 2006, 6:21pm

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@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@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@node.mendelu.cz
URL: http://mapserver.mendelu.cz
Tel.: +420 545 134 514

_______________________________________________
grass5 mailing list
grass5@grass.itc.it
http://grass.itc.it/mailman/listinfo/grass5

--
Jachym Cepicky
e-mail: jachym.cepicky@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@node.mendelu.cz
URL: http://mapserver.mendelu.cz
Tel.: +420 545 134 514

Markus_Neteler1 · March 10, 2006, 6:16pm

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@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@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@node.mendelu.cz
> URL: http://mapserver.mendelu.cz
> Tel.: +420 545 134 514
>
> _______________________________________________
> grass5 mailing list
> grass5@grass.itc.it
> http://grass.itc.it/mailman/listinfo/grass5

--
Jachym Cepicky
e-mail: jachym.cepicky@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@node.mendelu.cz
URL: http://mapserver.mendelu.cz
Tel.: +420 545 134 514

_______________________________________________
grass5 mailing list
grass5@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