Allotment Locations

Greater London Authority

@ukgov.allotment_locations1

Table List

1 table(66.35 KB)

Gla-allotment-locations

@ukgov.allotment_locations1.gla_allotment_locations

66.35 KB
741 rows
15 columns

gla_id GLA ID	name Name	location Location	suppliedpostcode SuppliedPostcode	nearestpostcode NearestPostcode	borough Borough	easting Easting	northing Northing	latitude Latitude	longitude Longitude
126	Abbots Way	Alongside railway line	BR3 3	CR0 7TX	Bromley	535943	167854	51.393386	-0.047422
127	Adams Road	Alongside railway line at junction with Upper Elmers End Road	BR3	BR3 4AX	Bromley	536250	167898	51.393712	-0.042996
128	Aylesford Avenue	To north of Greenview Avenue	BR3 3	CR0 7QW	Croydon	536252	167397	51.389209	-0.043162
129	Barnmead Road	Between Railway tracks north of Thayers Farm Road	BR3 1	BR3 4LY	Bromley	536292	169784	51.410653	-0.041668
130	Beck Lane	North of Beck Lane and Central Terrace	BR3 4	BR3 4RF	Bromley	535658	169029	51.404014	-0.051065
131	Beckenham Lane	South West of Beckenham Lane, on north side of Playing Field	BR2 0	BR2 0DG	Bromley	539730	169401	51.406374	0.007591
132	Belmont Lane	South of Belmont Lane	BR7	BR7 6BL	Bromley	544100	171400	51.423243	0.071183
133	Biggin Hill	West of Old Tye Avenue	TN16 3	TN16 3LY	Bromley	542178	159230	51.314368	0.038694
134	Bourne Vale	East of Kingsdown Way / north of Farleigh Avenue	BR2 7	BR2 7NY	Bromley	540159	167044	51.38509	0.012812
135	Bull Lane	Between Bull Lane and Paddock Way, north of Graham Chiesman House	BR7	BR7 6PD	Bromley	544718	170124	51.411618	0.079546


CREATE TABLE gla_allotment_locations (
  "gla_id" BIGINT,
  "borough_ref" DOUBLE,
  "name" VARCHAR,
  "location" VARCHAR,
  "suppliedpostcode" VARCHAR,
  "nearestpostcode" VARCHAR,
  "borough" VARCHAR,
  "organisation" VARCHAR,
  "facilities" VARCHAR,
  "grade" VARCHAR,
  "comments" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);