Table "mastermap.topographicarea" Column | Type | Modifiers ---------------------+------------------------+----------- toid | character varying(22) | version | numeric | versiondate | date | calculatedareavalue | numeric(16,6) | changehistory | text | descriptivegroup | character varying(250) | descriptiveterm | character varying(250) | featurecode | numeric(6,0) | gml_version | numeric(6,0) | loaddate | date | make | character varying(12) | mi_prinx | numeric(8,2) | mi_style | character varying(250) | osmmstyle_name | character varying(70) | osmmstyle_number | numeric(6,0) | physicallevel | numeric(6,0) | physicalpresence | character varying(12) | poly_broken | character varying(5) | theme | character varying(250) | tile | character varying(4) | tilenumber | integer | geometry | geometry | Indexes: "topoarea_idx1" gist (geometry), tablespace "mastermap" "topoarea_idx2" btree (toid, version), tablespace "mastermap" Check constraints: "enforce_dims_geometry" CHECK (ndims(geometry) = 2) "enforce_geotype_geometry" CHECK (geometrytype(geometry) = 'POLYGON'::text OR geometry IS NULL) "enforce_srid_geometry" CHECK (srid(geometry) = 27700) Tablespace: "mastermap" Table "mastermap.topographicline" Column | Type | Modifiers ----------------------+------------------------+----------- toid | character varying(22) | version | numeric | versiondate | date | accuracyofposition | character varying(7) | changehistory | text | descriptivegroup | character varying(250) | descriptiveterm | character varying(250) | featurecode | numeric(6,0) | gml_version | numeric(6,0) | heightabovedatum | numeric(8,2) | heightabovedatumacc | character varying(7) | heightaboveground | numeric(8,2) | heightabovegroundacc | character varying(7) | loaddate | date | make | character varying(12) | mi_prinx | numeric(8,2) | mi_style | character varying(250) | osmmstyle_name | character varying(70) | osmmstyle_number | numeric(6,0) | physicallevel | numeric(6,0) | physicalpresence | character varying(12) | polyline_broken | character varying(5) | referencetofeature | character varying(250) | theme | character varying(250) | tile | character varying(4) | tilenumber | integer | geometry | geometry | Indexes: "topoline_idx1" gist (geometry), tablespace "mastermap" "topoline_idx2" btree (toid, version), tablespace "mastermap" Check constraints: "enforce_dims_geometry" CHECK (ndims(geometry) = 2) "enforce_geotype_geometry" CHECK (geometrytype(geometry) = 'LINESTRING'::text OR geometry IS NULL) "enforce_srid_geometry" CHECK (srid(geometry) = 27700) Tablespace: "mastermap" Table "mastermap.topographicpoint" Column | Type | Modifiers ----------------------+------------------------+----------- toid | character varying(22) | version | numeric | versiondate | date | accuracyofposition | character varying(7) | changehistory | text | descriptivegroup | character varying(250) | descriptiveterm | character varying(250) | featurecode | numeric(6,0) | gml_version | numeric(6,0) | heightabovedatum | numeric(8,2) | heightabovedatumacc | character varying(7) | heightaboveground | numeric(8,2) | heightabovegroundacc | character varying(7) | loaddate | date | make | character varying(12) | mi_prinx | numeric(8,2) | mi_style | character varying(250) | osmmstyle_name | character varying(70) | osmmstyle_number | numeric(6,0) | physicallevel | numeric(6,0) | physicalpresence | character varying(12) | referencetofeature | character varying(250) | theme | character varying(250) | tile | character varying(4) | tilenumber | integer | geometry | geometry | Indexes: "topopoint_idx1" gist (geometry), tablespace "mastermap" "topopoint_idx2" btree (toid, version), tablespace "mastermap" Check constraints: "enforce_dims_geometry" CHECK (ndims(geometry) = 2) "enforce_geotype_geometry" CHECK (geometrytype(geometry) = 'POINT'::text OR geometry IS NULL) "enforce_srid_geometry" CHECK (srid(geometry) = 27700) Tablespace: "mastermap" Table "mastermap.cartographicsymbol" Column | Type | Modifiers ------------------+------------------------+----------- toid | character varying(22) | version | numeric | versiondate | date | changehistory | text | descriptivegroup | character varying(250) | descriptiveterm | character varying(250) | featurecode | numeric(6,0) | gml_version | numeric(6,0) | loaddate | date | make | character varying(12) | mi_style | character varying(250) | osmmstyle_name | character varying(70) | osmmstyle_number | numeric(6,0) | physicallevel | numeric(6,0) | physicalpresence | character varying(12) | orientation | numeric(6,0) | primary_key | numeric(6,0) | theme | character varying(250) | tile | character varying(4) | tilenumber | integer | geometry | geometry | Indexes: "cartosym_idx1" gist (geometry), tablespace "mastermap" "cartosym_idx2" btree (toid, version), tablespace "mastermap" Check constraints: "enforce_dims_geometry" CHECK (ndims(geometry) = 2) "enforce_geotype_geometry" CHECK (geometrytype(geometry) = 'POINT'::text OR geometry IS NULL) "enforce_srid_geometry" CHECK (srid(geometry) = 27700) Tablespace: "mastermap" Table "mastermap.cartographictext" Column | Type | Modifiers ------------------------------+------------------------+----------- toid | character varying(22) | version | numeric | versiondate | date | changehistory | text | descriptivegroup | character varying(250) | descriptiveterm | character varying(250) | featurecode | numeric(6,0) | gml_version | numeric(6,0) | loaddate | date | make | character varying(12) | mi_prinx | numeric(8,2) | mi_style | character varying(250) | osmmstyle_name | character varying(70) | osmmstyle_number | numeric(6,0) | physicallevel | numeric(6,0) | physicalpresence | character varying(12) | textstring | character varying(250) | textrendering_anchorposition | numeric(6,0) | textrendering_font | numeric(6,0) | textrendering_height | numeric(6,3) | textrendering_orientation | numeric(6,0) | theme | character varying(250) | tile | character varying(4) | tilenumber | integer | geometry | geometry | Indexes: "cartotext_idx1" gist (geometry), tablespace "mastermap" "cartotext_idx2" btree (toid, version), tablespace "mastermap" Check constraints: "enforce_dims_geometry" CHECK (ndims(geometry) = 2) "enforce_geotype_geometry" CHECK (geometrytype(geometry) = 'POINT'::text OR geometry IS NULL) "enforce_srid_geometry" CHECK (srid(geometry) = 27700) Tablespace: "mastermap" Table "mastermap.boundaryline" Column | Type | Modifiers --------------------+------------------------+----------- toid | character varying(22) | version | numeric | versiondate | date | accuracyofposition | character varying(7) | changehistory | text | descriptivegroup | character varying(250) | descriptiveterm | character varying(250) | featurecode | numeric(6,0) | gml_version | numeric(6,0) | loaddate | date | make | character varying(12) | mi_prinx | numeric(8,2) | mi_style | character varying(250) | osmmstyle_name | character varying(70) | osmmstyle_number | numeric(6,0) | physicallevel | numeric(6,0) | physicalpresence | character varying(12) | polyline_broken | character varying(5) | theme | character varying(250) | tile | character varying(4) | tilenumber | integer | geometry | geometry | Indexes: "bndline_idx1" gist (geometry), tablespace "mastermap" "bndline_idx2" btree (toid, version), tablespace "mastermap" Check constraints: "enforce_dims_geometry" CHECK (ndims(geometry) = 2) "enforce_geotype_geometry" CHECK (geometrytype(geometry) = 'LINESTRING'::text OR geometry IS NULL) "enforce_srid_geometry" CHECK (srid(geometry) = 27700) Tablespace: "mastermap"