Topographical Waterbody

Description

 

Waterbodies include dams, streams, and rivers.

Column Name Data TypeData UDT TypeNullableDescriptionInclude
geomgeometrygeometryYESThe spatial component or definition of the geographic feature.x
created_attimestamp without time zonetimestampYESThe created date of the record.x
updated_attimestamp without time zonetimestampYESThe last modification date of the record.x
feature_area_sqmdouble precisionfloat8YESThe surface area of the feature measured in square metres.x
feature_length_mdouble precisionfloat8YESThe perimeter of the feature measured in metres.x
country_idintegerint4NOThe identifier of the national administrative division. x
countrycharacter varyingvarcharYESThe official country name specified in English.x
isonintegerint4YESThe iso country number defined in ISO 3166-1.x
iso3character varyingvarcharYESThe three-letter country code defined in ISO 3166-1.x
iso2character varyingvarcharYESThe two-letter country code defined in ISO 3166-1.x
adminarea_l1_idintegerint4YESThe identifier of the first-level administrative area.x
adminarea_l1_typecharacter varyingvarcharYESThe type of the first-level administrative area.x
adminarea_l1_namecharacter varyingvarcharYESThe name of the first-level administrative area.x
adminarea_l1_shortnamecharacter varyingvarcharYESAn abbreviated or abridged textual name of the first-level administrative area.x
adminarea_l2_idintegerint4YESThe identifier of the second-level administrative area.x
adminarea_l2_typecharacter varyingvarcharYESThe type of the second-level administrative area.x
adminarea_l2_namecharacter varyingvarcharYESThe name of the second-level administrative area.x
adminarea_l2_shortnamecharacter varyingvarcharYESAn abbreviated or abridged textual name of the second-level administrative area.x
adminarea_l2_variantnamecharacter varyingvarcharYESAn alternative and/or former name of the second-level administrative area.x
adminarea_l3_idintegerint4YESThe identifier of the third-level administrative area.x
adminarea_l3_typecharacter varyingvarcharYESThe type of the third-level administrative area.x
adminarea_l3_namecharacter varyingvarcharYESThe name of the third-level administrative area.x
adminarea_l3_shortnamecharacter varyingvarcharYESAn abbreviated or abridged textual name of the third-level administrative area.x
adminarea_l3_variantnamecharacter varyingvarcharYESAn alternative and/or former name of the third-level administrative area.x
locality_idintegerint4YESThe identifier of the locality.x
locality_typecharacter varyingvarcharYESThe type of the locality.x
locality_namecharacter varyingvarcharYESThe name of the locality.x
water_idintegerint4NOThe water body identifier.x
water_namecharacter varyingvarcharYESThe name of the water body.x
water_typecharacter varyingvarcharYESThe type of the water body.x
map_sheetcharacter varyingvarcharYESThe mapseries name.x
map_label1character varyingvarcharYESA proposed expression for map labelling purposes.x
labelgeometrygeometryYESThe spatial component or definition of the recommended label location.x
mbrgeometrygeometryYESThe spatial component or definition of the minimum boundary rectangle.x
vbrgeometrygeometryYESThe spatial component or definition of the viewport boundary rectangle.x