Town Centres

Broxtowe Borough Council

@ukgov.town_centres8

Table List

1 table(7.75 KB)

Table 1

@ukgov.town_centres8.table_1

7.75 KB
4 rows
10 columns

objectid OBJECTID	towncentre TownCentre	origin Origin	licence Licence	licenceurl LicenceURL	captscale CaptScale	updated Updated	updatedby UpdatedBy	shape_area SHAPE Area	shape_length SHAPE Length
1	Beeston	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Oct 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	145409.053606017	2773.24584529142
2	Stapleford	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Oct 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	67096.3881572074	2268.24292094261
3	Eastwood	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Oct 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	52299.8409201455	1602.48961268211
4	Kimberley	BBC	OGL	http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/	1250	Wed Oct 16 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	JC	43212.0403502493	1384.06192387827


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