Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| identifier | text | 2147483647 | √ | null |
|
|
||
| dataset_name | varchar | 100 | √ | null |
|
|
||
| typename | text | 2147483647 | √ | null |
|
|
||
| schema | text | 2147483647 | √ | null |
|
|
||
| mdsource | text | 2147483647 | √ | null |
|
|
||
| insert_date | timestamp | 29,6 | √ | null |
|
|
||
| xml | text | 2147483647 | √ | null |
|
|
||
| metadata | text | 2147483647 | √ | null |
|
|
||
| metadata_type | text | 2147483647 | √ | null |
|
|
||
| anytext | text | 2147483647 | √ | null |
|
|
||
| language | text | 2147483647 | √ | null |
|
|
||
| title | text | 2147483647 | √ | null |
|
|
||
| abstract | text | 2147483647 | √ | null |
|
|
||
| keywords | text | 2147483647 | √ | null |
|
|
||
| keywordstype | text | 2147483647 | √ | null |
|
|
||
| format | text | 2147483647 | √ | null |
|
|
||
| source | text | 2147483647 | √ | null |
|
|
||
| version | text | 2147483647 | √ | null |
|
|
||
| date_modified | timestamp | 29,6 | √ | null |
|
|
||
| type | text | 2147483647 | √ | null |
|
|
||
| wkt_geometry | text | 2147483647 | √ | null |
|
|
||
| wkb_geometry | geometry | 2147483647 | √ | null |
|
|
||
| title_alternate | varchar | 100 | √ | null |
|
|
||
| doi | text | 2147483647 | √ | null |
|
|
||
| date_revision | text | 2147483647 | √ | null |
|
|
||
| date_creation | timestamp | 29,6 | √ | null |
|
|
||
| date_publication | text | 2147483647 | √ | null |
|
|
||
| organisation | text | 2147483647 | √ | null |
|
|
||
| securityconstraints | text | 2147483647 | √ | null |
|
|
||
| parentidentifier | text | 2147483647 | √ | null |
|
|
||
| topiccategory | json | 2147483647 | √ | null |
|
|
||
| resourcelanguage | text | 2147483647 | √ | null |
|
|
||
| geodescode | text | 2147483647 | √ | null |
|
|
||
| denominator | text | 2147483647 | √ | null |
|
|
||
| distancevalue | text | 2147483647 | √ | null |
|
|
||
| distanceuom | text | 2147483647 | √ | null |
|
|
||
| date | json | 2147483647 | √ | null |
|
|
||
| time_begin | json | 2147483647 | √ | null |
|
|
||
| time_end | json | 2147483647 | √ | null |
|
|
||
| reference_date_type | json | 2147483647 | √ | null |
|
|
||
| servicetype | text | 2147483647 | √ | null |
|
|
||
| servicetypeversion | text | 2147483647 | √ | null |
|
|
||
| operation | text | 2147483647 | √ | null |
|
|
||
| couplingtype | text | 2147483647 | √ | null |
|
|
||
| operateson | text | 2147483647 | √ | null |
|
|
||
| operatesonidentifier | text | 2147483647 | √ | null |
|
|
||
| operatesonname | text | 2147483647 | √ | null |
|
|
||
| degree | text | 2147483647 | √ | null |
|
|
||
| accessconstraints | text | 2147483647 | √ | null |
|
|
||
| otherconstraints | text | 2147483647 | √ | null |
|
|
||
| classification | text | 2147483647 | √ | null |
|
|
||
| conditionapplyingtoaccessanduse | text | 2147483647 | √ | null |
|
|
||
| edition | text | 2147483647 | √ | null |
|
|
||
| lineage_statement | text | 2147483647 | √ | null |
|
|
||
| dataset_lineage | text | 2147483647 | √ | null |
|
|
||
| responsiblepartyrole | text | 2147483647 | √ | null |
|
|
||
| specificationtitle | text | 2147483647 | √ | null |
|
|
||
| specificationdate | text | 2147483647 | √ | null |
|
|
||
| specificationdatetype | text | 2147483647 | √ | null |
|
|
||
| creator | text | 2147483647 | √ | null |
|
|
||
| publisher | text | 2147483647 | √ | null |
|
|
||
| contributor | text | 2147483647 | √ | null |
|
|
||
| relation | text | 2147483647 | √ | null |
|
|
||
| platform | text | 2147483647 | √ | null |
|
|
||
| instrument | text | 2147483647 | √ | null |
|
|
||
| sensortype | text | 2147483647 | √ | null |
|
|
||
| cloudcover | text | 2147483647 | √ | null |
|
|
||
| bands | text | 2147483647 | √ | null |
|
|
||
| links | text | 2147483647 | √ | null |
|
|
||
| bounding_geojson | json | 2147483647 | √ | null |
|
|
||
| crs | json | 2147483647 | √ | null |
|
|
||
| equivalent_scale | json | 2147483647 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
