Employment Sites And Commitments

Broxtowe Borough Council

@ukgov.employment_sites_and_commitments3

Table List

1 table(11.98 KB)

Table 1

@ukgov.employment_sites_and_commitments3.table_1

11.98 KB
37 rows
14 columns

objectid OBJECTID	sitename SiteName	policy Policy	capturedat CaptureDat	source Source	site_status SITE STATUS	origin Origin	licence Licence	licenceurl LicenceURL	captscale CaptScale	updated Updated	updatedby UpdatedBy	shape_area SHAPE Area	shape_length SHAPE Length
1	Simplex Knitting Co	9	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Site	Site	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	5030.8421400217	297.204373334959
2	Chetwynd Business Park	9	Mon Jun 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Site	Site	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Mon Jun 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	31123.6214469513	707.474092380081
3	Palmer Drive (including Bessell Lane, north of A52	9	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Site	Site	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	48395.6468831416	1241.39838942945
4	Former Dye Works, West End Street	9	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Site	Site	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	3919.45434495568	353.356172007489
5	Pasture Road (including Silicone Altimes)	9	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Site	Site	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	10631.6833067794	765.063643373276
6	Stapleford Road Trowell	9	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Site	Site	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	33519.4714962899	816.724240879017
7	Balloon Woods Industrial Estate	9	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Site	Site	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	17650.7727204366	538.802826909197
8	Eagle Mill, Ilkeston Road, Trowell	9	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Site	Site	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	6345.54119720901	453.168738145461
9	Main Road Watnall	9	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Site	Site	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	228764.374960521	2879.94151252892
10	Giltbrook Industrial Park	9	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Site	Site	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Apr 05 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	27069.0791987984	1013.64532726049


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "sitename" VARCHAR,
  "policy" BIGINT,
  "capturedat" TIMESTAMP,
  "source" VARCHAR,
  "site_status" VARCHAR,
  "origin" VARCHAR,
  "licence" VARCHAR,
  "licenceurl" VARCHAR,
  "captscale" BIGINT,
  "updated" TIMESTAMP,
  "updatedby" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);