Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| fid | serial | 10 | √ | nextval('ap.gadm_410_fid_seq'::regclass) |
|
|
||||
| uid | int8 | 19 | √ | null |
|
|
||||
| gid_0 | varchar | 10 | √ | null |
|
|
||||
| name_0 | varchar | 32 | √ | null |
|
|
||||
| varname_0 | varchar | 29 | √ | null |
|
|
||||
| gid_1 | varchar | 10 | √ | null |
|
|
||||
| name_1 | varchar | 34 | √ | null |
|
|
||||
| varname_1 | varchar | 82 | √ | null |
|
|
||||
| nl_name_1 | varchar | 87 | √ | null |
|
|
||||
| iso_1 | varchar | 10 | √ | null |
|
|
||||
| hasc_1 | varchar | 10 | √ | null |
|
|
||||
| cc_1 | varchar | 10 | √ | null |
|
|
||||
| type_1 | varchar | 32 | √ | null |
|
|
||||
| engtype_1 | varchar | 32 | √ | null |
|
|
||||
| validfr_1 | varchar | 15 | √ | null |
|
|
||||
| gid_2 | varchar | 12 | √ | null |
|
|
||||
| name_2 | varchar | 34 | √ | null |
|
|
||||
| varname_2 | varchar | 39 | √ | null |
|
|
||||
| nl_name_2 | varchar | 75 | √ | null |
|
|
||||
| hasc_2 | varchar | 15 | √ | null |
|
|
||||
| cc_2 | varchar | 12 | √ | null |
|
|
||||
| type_2 | varchar | 34 | √ | null |
|
|
||||
| engtype_2 | varchar | 32 | √ | null |
|
|
||||
| validfr_2 | varchar | 15 | √ | null |
|
|
||||
| gid_3 | varchar | 15 | √ | null |
|
|
||||
| name_3 | varchar | 38 | √ | null |
|
|
||||
| varname_3 | varchar | 44 | √ | null |
|
|
||||
| nl_name_3 | varchar | 56 | √ | null |
|
|
||||
| hasc_3 | varchar | 27 | √ | null |
|
|
||||
| cc_3 | varchar | 10 | √ | null |
|
|
||||
| type_3 | varchar | 32 | √ | null |
|
|
||||
| engtype_3 | varchar | 32 | √ | null |
|
|
||||
| validfr_3 | varchar | 10 | √ | null |
|
|
||||
| gid_4 | varchar | 18 | √ | null |
|
|
||||
| name_4 | varchar | 34 | √ | null |
|
|
||||
| varname_4 | varchar | 35 | √ | null |
|
|
||||
| cc_4 | varchar | 12 | √ | null |
|
|
||||
| type_4 | varchar | 29 | √ | null |
|
|
||||
| engtype_4 | varchar | 29 | √ | null |
|
|
||||
| validfr_4 | varchar | 10 | √ | null |
|
|
||||
| gid_5 | varchar | 19 | √ | null |
|
|
||||
| name_5 | varchar | 34 | √ | null |
|
|
||||
| cc_5 | varchar | 10 | √ | null |
|
|
||||
| type_5 | varchar | 22 | √ | null |
|
|
||||
| engtype_5 | varchar | 10 | √ | null |
|
|
||||
| governedby | varchar | 17 | √ | null |
|
|
||||
| sovereign | varchar | 32 | √ | null |
|
|
||||
| disputedby | varchar | 32 | √ | null |
|
|
||||
| region | varchar | 32 | √ | null |
|
|
||||
| varregion | varchar | 48 | √ | null |
|
|
||||
| country | varchar | 32 | √ | null |
|
|
||||
| continent | varchar | 13 | √ | null |
|
|
||||
| subcont | varchar | 10 | √ | null |
|
|
||||
| compoundname | text | 2147483647 | √ | null |
|
|
||||
| ts_compoundname | tsvector | 2147483647 | √ | null |
|
|
||||
| geom | geometry | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| gadm_410_pkey | Primary key | Asc | fid |
| gadm_geom_gix | Performance | Asc | geom |