sp920_region_polygon

This table holds all the polygon definitions used in ServicePlanner; this table is introduced due to the migration of "Pitney Bows Maps" to "HERE maps".

Table Definition

Field	Type	Default	Nullable
polygon_seq	number(10)
region_no	number(9)
release_id	varchar2(10)
label	varchar2(255)
region_ref	varchar2(255)
polygon	clob
geopolygon	sdo_geometry

Keys

primary key (polygon_seq)

foreign key (region_no) References sp057_regions (region_no)

Column Descriptions

Field	Description
polygon_seq	polygon_seq is used as the primary key and increments by 1 each insertion.
region_no	region_no is a foreign key that makes reference to sp057_regions
release_id	A combination of COUNTRY & YEAR (for example "UK_2018"). In order to differentiate future versions of polygons layer.
label	The sector postcode.
region_ref	The region reference which is used to retrieve the polygon for one specific region.
polygon	A collection of latitude and longitude which is the perimeter of the polygon.
geopolygon	A Geometry type column in which an index Polygon_IDX is generated