Provincia Autonoma di Trento
{SIAT}
Sistema Informativo Ambiente e Territorio
Nome tabella: elementi_cicloviari_v
Nome campi:
| objectid |
integer |
|
| classid |
text |
|
| pista |
character varying(26) |
|
| id |
integer |
|
| tratto |
character varying(80) |
|
| livello |
character varying |
|
| scala |
character varying |
|
| posizione |
character varying |
|
| fonte |
character varying |
|
| sede |
character varying |
|
| gestione |
character varying(100) |
|
| pavimentazione |
character varying |
|
| eurovelo |
boolean |
|
| datafine |
timestamp without time zone |
|
| dataini |
timestamp without time zone |
|
| dataagg |
timestamp without time zone |
|
| shape |
geometry(MultiLineString,25832) |
|
Chiave tabella:
Relazioni:
Nome tabella: cod_classe_v
Nome campi:
| objectid |
integer |
|
| descr |
character varying |
|
| dataagg |
timestamp without time zone |
|
| classid |
text |
|
| datafine |
timestamp without time zone |
|
| dataini |
timestamp without time zone |
|
| value |
integer |
|
Nome tabella: cod_filoarian_v
Nome campi:
| objectid |
integer |
|
| descr |
character varying |
|
| dataagg |
timestamp without time zone |
|
| classid |
text |
|
| datafine |
timestamp without time zone |
|
| dataini |
timestamp without time zone |
|
| value |
integer |
|
Nome tabella: cod_fonte_v
Nome campi:
| objectid |
integer |
|
| descr |
character varying |
|
| dataagg |
timestamp without time zone |
|
| classid |
text |
|
| datafine |
timestamp without time zone |
|
| dataini |
timestamp without time zone |
|
| value |
integer |
|
Nome tabella: cod_livello_v
Nome campi:
| objectid |
integer |
|
| descr |
character varying |
|
| dataagg |
timestamp without time zone |
|
| classid |
text |
|
| datafine |
timestamp without time zone |
|
| dataini |
timestamp without time zone |
|
| value |
integer |
|
Nome tabella: cod_pavim_v
Nome campi:
| objectid |
integer |
|
| descr |
character varying |
|
| dataagg |
timestamp without time zone |
|
| classid |
text |
|
| datafine |
timestamp without time zone |
|
| dataini |
timestamp without time zone |
|
| value |
integer |
|
Nome tabella: cod_posiz_v
Nome campi:
| objectid |
integer |
|
| descr |
character varying |
|
| dataagg |
timestamp without time zone |
|
| classid |
text |
|
| datafine |
timestamp without time zone |
|
| dataini |
timestamp without time zone |
|
| value |
integer |
|
Nome tabella: cod_scala_v
Nome campi:
| objectid |
integer |
|
| descr |
character varying |
|
| dataagg |
timestamp without time zone |
|
| classid |
text |
|
| datafine |
timestamp without time zone |
|
| dataini |
timestamp without time zone |
|
| value |
integer |
|
Nome tabella: cod_sede_v
Nome campi:
| objectid |
integer |
|
| descr |
character varying |
|
| dataagg |
timestamp without time zone |
|
| classid |
text |
|
| datafine |
timestamp without time zone |
|
| dataini |
timestamp without time zone |
|
| value |
integer |
|
Nome tabella: cod_ciclovie_v
Nome campi:
| objectid |
integer |
|
| descr |
character varying |
|
| dataagg |
timestamp without time zone |
|
| classid |
text |
|
| datafine |
timestamp without time zone |
|
| dataini |
timestamp without time zone |
|
| value |
integer |
|
Modello entità relazioni
