Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
geo_parcelle | text | 2147483647 | null |
|
|
Identifiant |
||||
annee | text | 2147483647 | null |
|
|
Année |
||||
object_rid | text | 2147483647 | √ | null |
|
|
Numéro d’objet |
|||
idu | text | 2147483647 | √ | null |
|
|
Identifiant |
|||
geo_section | text | 2147483647 | null |
|
|
Section |
||||
geo_subdsect | text | 2147483647 | √ | null |
|
|
||||
supf | numeric | 131089 | √ | null |
|
|
Contenance MAJIC |
|||
geo_indp | text | 2147483647 | √ | null |
|
|
Figuration de la parcelle au plan |
|||
coar | text | 2147483647 | √ | null |
|
|
Code arpentage |
|||
tex | text | 2147483647 | √ | null |
|
|
Numéro parcellaire |
|||
tex2 | text | 2147483647 | √ | null |
|
|
tex2 - non documenté |
|||
codm | text | 2147483647 | √ | null |
|
|
codm - non documenté |
|||
creat_date | date | 13 | √ | null |
|
|
Date de création |
|||
update_dat | date | 13 | √ | null |
|
|
Date de dernière modification |
|||
inspireid | text | 2147483647 | √ | null |
|
|
||||
lot | text | 2147483647 | √ | null |
|
|
||||
ogc_fid | serial | 10 | √ | nextval('cadastre.geo_parcelle_ogc_fid_seq'::regclass) |
|
|
||||
geom | geometry | 2147483647 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
geo_parcelle_pk | Primary key | Asc | ogc_fid |
geo_parcelle_centroide_geom_idx | Performance | ||
geo_parcelle_geo_parcelle | Performance | Asc | geo_parcelle |
geo_parcelle_geo_section_idx | Performance | Asc | geo_section |
geo_parcelle_geom_idx | Performance | Asc | geom |
geo_parcelle_idu_idx | Performance | Asc | idu |