Conservation Areas

Broxtowe Borough Council

@ukgov.conservation_areas120

Table List

1 table(9.22 KB)

Table 1

@ukgov.conservation_areas120.table_1

9.22 KB
16 rows
11 columns

objectid OBJECTID	location LOCATION	website WEBSITE	date_des DATE DES	origin Origin	licence Licence	licenceurl LicenceURL	captscale CaptScale	shape_area Shape Area	shape_length Shape Length
1	Attenborough Village	https://www.broxtowe.gov.uk/for-you/planning/conservation-areas/	Fri Nov 18 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	126429.710581265	2653.31462009547
2	Chilwell	https://www.broxtowe.gov.uk/for-you/planning/conservation-areas/	Wed Mar 07 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	116106.441407061	3313.73690159807
3	Bramcote	https://www.broxtowe.gov.uk/for-you/planning/conservation-areas/	Sat Aug 31 1974 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	401967.32400634	5106.33645394484
4	Chilwell Cottage Grove	https://www.broxtowe.gov.uk/for-you/planning/conservation-areas/	Tue Jul 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	121387.474243609	1806.78031652392
5	Brinsley	https://www.broxtowe.gov.uk/for-you/planning/conservation-areas/	Fri Apr 20 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	40611.7068622904	1574.66328871441
6	Eastwood	https://www.broxtowe.gov.uk/for-you/planning/conservation-areas/	Fri Nov 18 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	109244.08981172	2158.93940428993
7	Church Street Stapleford	https://www.broxtowe.gov.uk/for-you/planning/conservation-areas/		BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	22991.760611969	763.293204453051
8	Nottingham Road Stapleford	https://www.broxtowe.gov.uk/for-you/planning/conservation-areas/	Mon May 12 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	20482.4413734701	649.557794416683
9	Kimberley	https://www.broxtowe.gov.uk/for-you/planning/conservation-areas/		BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	119460.065909998	2326.30989865898
10	Barratt Lane Attenborough	https://www.broxtowe.gov.uk/for-you/planning/conservation-areas/	Tue Jul 07 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	62177.7165338792	1769.69124713714


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "location" VARCHAR,
  "website" VARCHAR,
  "date_des" TIMESTAMP,
  "notes" VARCHAR,
  "origin" VARCHAR,
  "licence" VARCHAR,
  "licenceurl" VARCHAR,
  "captscale" BIGINT,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);