Community Services

Leeds City Council

@ukgov.community_services2

Table List

1 table(123.93 KB)

April 2020

@ukgov.community_services2.april_2020

123.93 KB
1452 rows
19 columns

uprn UPRN	organisation ORGANISATION	secondary_name Secondary Name	primary_name Primary Name	primary_number Primary Number	street_name Street Name	locality Locality	town Town	postal_town Postal Town	latitude Latitude	longitude Longitude	x_coord X COORD	y_coord Y COORD	lon_wgs84 LON WGS84	lat_wgs84 LAT WGS84	blpu_class BLPU CLASS	blpu_class_desc BLPU CLASS DESC	lpi_level LPI LEVEL
72670282	Yorkshire Ambulance Service NHS Trust	Ambulance Service Building Rear Of		15	Morris Lane	Kirkstall	Leeds	Leeds	53.81716	-1.59969	426453	435728	-1.59969413	53.81716537	CX03	Commercial, Emergency and Rescue Service, Ambulance Station	Ground
72137688			St Stephens C Of E Primary School		Morris Lane	Kirkstall	Leeds	Leeds	53.81909	-1.60084	426376	435942	-1.60084534	53.8190918	CE03	Commercial, Education, Primary, Junior, Infants or Middle School	NA
72137622	Kirkstall Health Centre			15	Morris Lane	Kirkstall	Leeds	Leeds	53.81716	-1.59969	426453	435728	-1.59969413	53.81716537	CM02	Commercial, Medical, GP Surgeries and Clinics	NA
72138490	Cookridge Village Association		Community Centre		Moseley Wood Lane	Cookridge	Leeds	Leeds	53.85956	-1.61843	425194	440439	-1.61843181	53.85956573	CC04	Commercial, Community Services, Public and Village Halls	Ground
72138792			Bright Beginnings Childcare Centre		Mount Preston Street	Woodhouse	Leeds	Leeds	53.80563	-1.55977	429089	434461	-1.55977714	53.80563736	CE02	Commercial, Education, Nursery/Creche
72137541	Dr Re Pearson And Partners		Foundry Lane Surgery	95	Moresdale Lane	Seacroft	Leeds	Leeds	53.81057	-1.47156	434894	435050	-1.47156787	53.81057358	CM02	Commercial, Medical, GP Surgeries and Clinics	Ground First
72137534			Seacroft Grange Primary School		Moresdale Lane	Seacroft	Leeds	Leeds	53.8112	-1.47279	434813	435120	-1.47279	53.81121063	CE03	Commercial, Education, Primary, Junior, Infants or Middle School	NA
72136749	Integrated Dental Holdings Ltd			1	Moor View	Hyde Park	Leeds	Leeds	53.81431	-1.56187	428945	435426	-1.5618732	53.8143158	CM01	Commercial, Medical, Dentist	Ground First
72092734			Ebor Gardens Community Centre	79	Haslewood Drive	Burmantofts	Leeds	Leeds	53.79915	-1.52289	431523	433755	-1.52289116	53.79914856	CC04	Commercial, Community Services, Public and Village Halls	Ground First
72565969			Corn Mill Lodge Hotel And Restaurant		Pudsey Road	Bramley	Leeds	Leeds	53.79647	-1.62251	424963	433418	-1.62251127	53.79647446	CH03	Commercial, Hotels, Boarding and Guest Houses, Hotel	NA


CREATE TABLE april_2020 (
  "uprn" BIGINT,
  "organisation" VARCHAR,
  "secondary_name" VARCHAR,
  "secondary_number" VARCHAR,
  "primary_name" VARCHAR,
  "primary_number" VARCHAR,
  "street_name" VARCHAR,
  "locality" VARCHAR,
  "town" VARCHAR,
  "postal_town" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "x_coord" DOUBLE,
  "y_coord" DOUBLE,
  "lon_wgs84" DOUBLE,
  "lat_wgs84" DOUBLE,
  "blpu_class" VARCHAR,
  "blpu_class_desc" VARCHAR,
  "lpi_level" VARCHAR
);