| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('edp_core_tdta_gis_id_seq'::regclass) |
|
|
Id used for manage geometries |
|||||||||
| geom | geometry | 2147483647 | √ | null |
|
|
The geometry in PostGis (binary) format: the coordinates of polygons |
|||||||||
| conformity_degree | varchar | 255 | √ | null |
|
|
||||||||||
| conformity_pub_date | timestamptz | 35,6 | √ | null |
|
|
||||||||||
| conformity_title | varchar | 255 | √ | null |
|
|
||||||||||
| level | varchar | 10 | √ | null |
|
|
Nomenclature level (1,2,3,4, eg.) |
|||||||||
| nomenclature_id | int4 | 10 | √ | null |
|
|
Relation to nomenclature type (NUTS, LAU, eg.) |
|||||||||
| tunit_code | varchar | 255 | √ | null |
|
|
Id of each geometric object |
|||||||||
| tunit_name | varchar | 255 | √ | null |
|
|
Official geometric name in english |
|||||||||
| version | int4 | 10 | √ | null |
|
|
Nomenclature version (year) |
Showing 1 to 10 of 10 entries
Table contained 271 639 rows
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edp_core_tdta_gis_pkey | Primary key | Asc | id |
| edp_core_tdta_gis_geom_gist | Performance | Asc | geom |
| edp_core_tdta_gis_level_nomenclature_id_ve_d5b339e1_uniq | Must be unique | Asc/Asc/Asc/Asc | level + nomenclature_id + version + tunit_code |
| edp_core_tdta_gis_nomenclature_id_b5dfb69a | Performance | Asc | nomenclature_id |
Showing 1 to 4 of 4 entries

