Local Green Space

Broxtowe Borough Council

@ukgov.local_green_space2

Table List

1 table(9.5 KB)

Table 1

@ukgov.local_green_space2.table_1

9.5 KB
17 rows
12 columns

objectid OBJECTID	feat_name Feat Name	policy Policy	plan_des Plan Des	origin Origin	licence Licence	licenceurl LicenceURL	captscale CaptScale	updated Updated	updatedby UpdatedBy	shape_area SHAPE Area	shape_length SHAPE Length
1	Land to the east of Cornwall Avenue	27.2	Broxtowe Part 2 Local Plan	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Thu Jun 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	6507.16746660983	368.820740505994
2	G1	GI4	Awsworth Neighbourhood Plan	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Tue Feb 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	17183.932729976	613.815303999711
3	G15	GI4	Awsworth Neighbourhood Plan	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Tue Feb 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	6133.95587500099	317.834668829596
4	G16	GI4	Awsworth Neighbourhood Plan	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Tue Feb 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	7274.68169499252	370.316219241591
5	G2A / G2B	GI4	Awsworth Neighbourhood Plan	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Tue Feb 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	31815.8116894955	970.669128328576
6	G5	GI4	Awsworth Neighbourhood Plan	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Tue Feb 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	489.403723492503	261.64293414248
7	G10	GI4	Awsworth Neighbourhood Plan	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Tue Feb 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	23403.1862945798	647.336463972563
8	G6	GI4	Awsworth Neighbourhood Plan	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Tue Feb 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	381.71155011751	447.252153425293
9	G4	GI4	Awsworth Neighbourhood Plan	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Tue Feb 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	436.895750001629	90.5036854895129
10	G3	GI4	Awsworth Neighbourhood Plan	BBC	OGL	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Tue Feb 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	4010.80744005432	667.767279784941


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "feat_name" VARCHAR,
  "policy" VARCHAR,
  "plan_des" VARCHAR,
  "origin" VARCHAR,
  "licence" VARCHAR,
  "licenceurl" VARCHAR,
  "captscale" BIGINT,
  "updated" TIMESTAMP,
  "updatedby" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);