Council Land And Building Assets

Leeds City Council

@ukgov.council_land_and_building_assets

Table List

5 tables(997.82 KB)

22/11/2017

@ukgov.council_land_and_building_assets.n_22_11_2017

Council land and building assets

173.84 KB
2778 rows
19 columns

organisationlabel OrganisationLabel	organisationuri OrganisationURI	effectivedate EffectiveDate	servicetypeuri ServiceTypeURI	servicetypelabel ServiceTypeLabel	unnamed_5 Unnamed: 5	assetcode AssetCode	propertyname PropertyName	siteaddress SiteAddress	coordinatereferencesystem CoordinateReferenceSystem	easting Easting	northing Northing	geopointlicensinguri GeoPointLicensingURI	tenuretype TenureType	tenuredetail TenureDetail	holdingtype HoldingType	heldby Heldby	service Service	ward Ward
Leeds City Council	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Wed Nov 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/1662	Corporate - assets	72575822	ASSET/8542/BLDGC	Beckett Park Primary School (Former) Site	Land for Site of Nursery	OSGB36	426866	436346	http://www.ordnancesurvey.co.uk/business-and-government/help-and-support/public-sector/guidance/derived-data-exemptions.html	Freehold	Ground Lease	Nursery (North Leeds Comm Nursery)	Corporate Landlord	CD: AM Miscellaneous	Kirkstall
Leeds City Council	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Wed Nov 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/1662	Corporate - assets	72674313	ASSET/4154/LAND	Bedford Gardens Com Centre, Cookridge	Reserve Forces And Cadets Assocation ATC Centre Grove Farm Crescent Cookridge Leeds LS16 6BZ	OSGB36	425337	439386	http://www.ordnancesurvey.co.uk/business-and-government/help-and-support/public-sector/guidance/derived-data-exemptions.html	Leasehold	Lease Out	Land	Corporate Landlord	CD: AM Miscellaneous	Weetwood
Leeds City Council	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Wed Nov 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/1662	Corporate - assets	72647191	ASSET/009822/LAND	Beeston, Footpath South of Cockburn High School	Footpath South Of Cockburn High School Gipsy Lane Beeston Leeds	OSGB36	429135	429378	http://www.ordnancesurvey.co.uk/business-and-government/help-and-support/public-sector/guidance/derived-data-exemptions.html	Freehold	Council Occupied	Land	Corporate Landlord	CD: AM Miscellaneous	Beeston & Holbeck
Leeds City Council	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Wed Nov 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/1662	Corporate - assets	72359213	ASSET/009587/LAND	Beryl Burton Gardens and associated land	Beryl Burton Gardens Land Adjacent And Rear 80 To 86 Queen Street Morley Leeds	OSGB36	426399	427676	http://www.ordnancesurvey.co.uk/business-and-government/help-and-support/public-sector/guidance/derived-data-exemptions.html	Freehold	Council Occupied	Land	Corporate Landlord	CD: AM Miscellaneous	Morley South
Leeds City Council	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Wed Nov 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/1662	Corporate - assets	72644859	ASSET/009592/LAND	Biddenden Road, (land to south) LS15	Land To South Of Biddenden Road Manston Leeds LS15 8XD	OSGB36	437575	434942	http://www.ordnancesurvey.co.uk/business-and-government/help-and-support/public-sector/guidance/derived-data-exemptions.html	Freehold	Council Occupied	Land	Corporate Landlord	CD: AM Miscellaneous	Crossgates & Whinmoor
Leeds City Council	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Wed Nov 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/1662	Corporate - assets	72338097	ASSET/009569/LAND	Birdcage Walk Allotments (former)	Birdcage Walk Allotments - West Birdcage Walk Otley Leeds LS21	OSGB36	420328	444916	http://www.ordnancesurvey.co.uk/business-and-government/help-and-support/public-sector/guidance/derived-data-exemptions.html	Freehold	Lease Out	Land	Corporate Landlord	CD: AM Miscellaneous	Otley & Yeadon
Leeds City Council	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Wed Nov 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/1662	Corporate - assets	72122682	ASSET/009830/LAND	Blenheim Walk (Land to SW of Blenheim Primary School)	Blenheim Walk - Land At To SW Of Blenheim Primary School Woodhouse Leeds LS2	OSGB36	429894	434617	http://www.ordnancesurvey.co.uk/business-and-government/help-and-support/public-sector/guidance/derived-data-exemptions.html	Freehold	Council Occupied	Land	Corporate Landlord	CD: AM Miscellaneous	Hyde Park & Woodhouse
Leeds City Council	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Wed Nov 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/1662	Corporate - assets	72338589	ASSET/5160/STRUCT	Bradford Road (No 212) Otley	Wall Adjacent To 212 Bradford Road Otley LS21 3LT	OSGB36	418879	444765	http://www.ordnancesurvey.co.uk/business-and-government/help-and-support/public-sector/guidance/derived-data-exemptions.html	Freehold	Council Occupied	Wall adjacent	Corporate Landlord	CD: AM Miscellaneous	Otley & Yeadon
Leeds City Council	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Wed Nov 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/1662	Corporate - assets		ASSET/009577/LAND	Brigg Hill Pit, off Whitehall Road	Brigg Hill Pit (former Landfill Area) Off Whitehall Road Pudsey	OSGB36			http://www.ordnancesurvey.co.uk/business-and-government/help-and-support/public-sector/guidance/derived-data-exemptions.html	Freehold	Lease Out	Land	Corporate Landlord	CD: AM Miscellaneous	Pudsey
Leeds City Council	http://opendatacommunities.org/id/metropolitan-district-council/leeds	Wed Nov 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	http://id.esd.org.uk/service/1662	Corporate - assets	72563985	ASSET/5173/LAND	Cross Lane (Butterbowl Grove), Farnley	24th South West Leeds Scout Group Butterbowl Grove Farnley Leeds LS12 5BN	OSGB36	425179	432411	http://www.ordnancesurvey.co.uk/business-and-government/help-and-support/public-sector/guidance/derived-data-exemptions.html	Freehold	Lease Out	Land	Corporate Landlord	CD: AM Miscellaneous	Farnley & Wortley


CREATE TABLE n_22_11_2017 (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "unnamed_5" DOUBLE,
  "assetcode" VARCHAR,
  "propertyname" VARCHAR,
  "siteaddress" VARCHAR,
  "coordinatereferencesystem" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "geopointlicensinguri" VARCHAR,
  "tenuretype" VARCHAR,
  "tenuredetail" VARCHAR,
  "holdingtype" VARCHAR,
  "heldby" VARCHAR,
  "service" VARCHAR,
  "ward" VARCHAR
);