Primary Frontages

Broxtowe Borough Council

@ukgov.primary_frontages

Table List

1 table(8.98 KB)

Table 1

@ukgov.primary_frontages.table_1

8.98 KB
5 rows
12 columns

objectid OBJECTID	towncentre TownCentre	policy Policy	capturedat CaptureDat	origin Origin	licence Licence	licenceurl LicenceURL	captscale CaptScale	updated Updated	updatedby UpdatedBy	shape_length Shape Length
1	Kimberley	10	Wed Feb 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Feb 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	369.497563676507
2	Stapleford	10	Wed Feb 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Feb 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	253.141923853892
3	Beeston	10	Wed Feb 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Feb 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	1091.16697518993
4	Eastwood	10	Wed Feb 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Feb 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	754.914141434102
5	Kimberley	10	Mon Jul 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Mon Jul 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	84.1104356557348


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "towncentre" VARCHAR,
  "policy" BIGINT,
  "capturedat" TIMESTAMP,
  "pagetype" VARCHAR,
  "origin" VARCHAR,
  "licence" VARCHAR,
  "licenceurl" VARCHAR,
  "captscale" BIGINT,
  "updated" TIMESTAMP,
  "updatedby" VARCHAR,
  "shape_length" DOUBLE
);