search

colouring-cities / colouring-britain

Developed out of the Colouring London prototype. Collecting data on Britain's buildings and testing new core features
https://colouringbritain.org/
GNU General Public License v3.0
10 stars 2 forks source link

Data: Land use - Colouring Loughborough #61

Closed MKIM1008 closed 6 months ago

MKIM1008 commented 11 months ago

Main 1) Charnwood Borough Council: My Property data, https://webmap.charnwood.gov.uk/Charnwoodwm/, The GIS officer (Wayne) sent us this in shp.

image image image image image

Secondary data 1) Energy Performance Certificate (EPC): domestic building, https://epc.opendatacommunities.org/docs 2) Domestic Energy Certificate (DEC): non-domestic building, https://epc.opendatacommunities.org/docs

3) Ordnance Survey (OS): Points of interest, UPRN, PSGA ID, https://www.ordnancesurvey.co.uk/products/points-of-interest#get

4) Old maps: retail location expectation, https://github.com/colouring-cities/colouring-london/issues/59

5) Open Street Map (OSM): https://download.geofabrik.de/europe/united-kingdom/england/leicestershire.html

Useful resources: VOA’s Non-domestic rating database, SCat codes UK planning portal (MHCLG, 2020a) London Building Stock Model National LaDOS’s Addressbase National Land Use Database (NLUD) UK National Asset Register (NAR)

OSM (OpenStreetMap Wiki, 2021b) OS OpenMap – Local Cabinet Office Church of England Geomni UK The first Land Utilisation Survey of Britain - map in the 1930s (EDINA, 2021b)

Colouring London:

https://github.com/colouring-cities/manual/wiki/X01.-London-prototype:-References https://github.com/colouring-cities/manual/wiki/X03.-London-prototype:-Open-data-assessment-for-London-UK-2021

MKIM1008 commented 11 months ago

This post serves as a basis for our upcoming discussion regarding Land Use and its related categories.

@Polly64 @matkoniecz @mdsimpson42 @fallipalaiologou @MKIM1008 @taimaz22

polly64 commented 11 months ago

@MKIM1008 this is the land use classification system we use. see page 30 for order and group. See how many you can match to both an order and a group, and then I can check and do any that are tricky-

Could you create a shared excel sheet if helpful

polly64 commented 11 months ago

do you know what classification system Myproperty is using?

Can you try and add as many of the available open datasets using the OSMM data for loughborough on your computer- i.e. under the university licence. I'd just like to look at how we are doing for coverage first? so all the ones you found below but colour by different source?:

MKIM1008 commented 11 months ago

this is the land use classification system we use. see page 30 for order and group. See how many you can match to both an order and a group, and then I can check and do any that are tricky-

Could you create a shared excel sheet if helpful

Capture

@polly64 I sort out My Property land use from Charnwood Borough Council into this form first.

MKIM1008 commented 11 months ago

@polly64 I put the data with O mark in GIS. I will share this during the meeting today.

do you know what classification system Myproperty is using? Can you try and add as many of the available open datasets using the OSMM data for loughborough on your computer- i.e. under the university licence. I'd just like to look at how we are doing for coverage first? so all the ones you found below but colour by different source?:

  • my property O
  • Open Street Map (OSM) O
  • Energy Performance Certificate (EPC): domestic building O
  • Domestic Energy Certificate (DEC) O
  • Ordnance Survey (OS): Points of interest O
  • Old maps: retail location expectation, Colouring Loughborough material - old maps #59
polly64 commented 10 months ago

SIC codes = A SIC code stands for Standard Industrial Classification code and classifies your business activity at Companies House. SIC code for a company can be changed at any time and be amended when you file your next Confirmation Statement. https://resources.companieshouse.gov.uk/sic/

Section A | Agriculture, Forestry and Fishing

Section B | Mining and Quarrying

Section C | Manufacturing

Section D Electricity, gas, steam and air conditioning supply

Section E Water supply, sewerage, waste management and remediation activities

Section F | Construction

Section G Wholesale and retail trade; repair of motor vehicles and motorcycles

Section H | Transportation and storage

Section I | Accommodation and food service activities

Section J | Information and communication

Section K Financial and insurance activities

Section L Real estate activities

Section M | Professional, scientific and technical activities

Section N | Administrative and support service activities

Section O Public administration and defence; compulsory social security

Section P | Education

Section Q | Human health and social work activities

Section R | Arts, entertainment and recreation

Section S Other service activities

Section T Activities of households as employers; undifferentiated goods- and services-producing activities of households for own use

Section U Activities of extraterritorial organisations and bodies

MKIM1008 commented 10 months ago

@polly64 For mapping the manufacturing, technology sector buildings, etc.

1) SMEs (with SIC codes) - the addresses are not matched with OSMM. (around 1000 cases) 2) High growth business - should be listed - now only statistics.

@matkoniecz The X and Y coordinates from the addresses are not matched with OSMM. Should I add the addresses on the Open Street Map? (It would be around 1000 cases). If you know other solutions please let me know.

MKIM1008 commented 10 months ago

@polly64 @taimaz22

Land Use - from Charnwood Borough Council - completion % in progress

Sorted byNational Land Use Database, colour legend from Colouring London image image

In progress: 1) I plan to incorporate additional land use data from OSM and other open sources. Is it permissible to use OS Points of Interest? (Note: This refers to point data, not polygon data.)

2) Is it possible for me to categorise Mixed-Use properties from the EPC (non-domestic) data?

3) Residential buildings will be compared using data from EPC (domestic).

4) I am looking at the dates to consider data updates.

MKIM1008 commented 10 months ago

@polly64 @taimaz22 @matkoniecz

Test: Charnwood Brough Council Land use in OSMM - Flat/Apartment layer

Step 1) Charnwood Brough Council Land Use + OS UPRN -> since CBC's using different UPRN and polygon Step 2) 1) + OSMM (OS UPRN/XY coordinates centred) Step 3) Visualisation centred Land Use informatiom from 1)

image image

White box: OSMM Purple box: Charnwood Brough Council Land use Pink box: Charnwood Brough Council Land use in OSMM

Error: To address the lack of UPRNs in OSMM, I tried a location-centered spatial join, but it unintentionally colored buildings near the Charnwood Brough Council land use area.

image

polly64 commented 10 months ago

@MKIM1008 and @taimaz22 i have started to add garages manually. is there anyone you know who can write an algorithm to begin to geolocate these automatically as we have some training data?

matkoniecz commented 10 months ago

the simplest check could be finding buildings at some specified size

polly64 commented 10 months ago

@matkoniecz can we look for rectangles with max and min width and length?

matkoniecz commented 10 months ago

that should be also possible, though maybe it would be easier and sufficient to consider bounding box size/dimensions?

polly64 commented 10 months ago

@MKIM1008 could you measure the width of the garages- which I have started colouring green in the loughborough land use section? there should probably be only 2 widths, for single and double garages, single being half the width of double. The lengths will vary as people will have extended some from averse car length so best to put a max and minimum on it. The minimum you can see from the most car sized rectangles which are the most common. @matkoniecz the algorithm would allow us too colour garages in the whole of the UK

MKIM1008 commented 10 months ago

@polly64 @matkoniecz

Sure, I will set the measuring standards for determining the width / type of the garages.

MKIM1008 commented 10 months ago

@polly64

Charnwood Borough Council - information from Land Use data image

polly64 commented 10 months ago

@MKIM1008 great is this all open?- if so can send you @matkoniecz the dataset for Loughborough, or upload onto site if MK shows you how

MKIM1008 commented 10 months ago

@polly64

I will ask the council if we can open the data in their Land Use file when I send over other enquires.

polly64 commented 10 months ago

@MKIM1008 what you want to ask is what the license terms are for using it.

polly64 commented 10 months ago

@MKIM1008 let's alsi talk about garden buildings- think we need to have a separate session chatting re the classification issue

MKIM1008 commented 9 months ago

@matkoniecz @polly64

The black boundary is Loughborough's (Built-Up Area) Should we include the land use surrounding the boundary which is from the council? (red circle) - I will add the question in the council email list. - I am working with the surrounding Land Use, too to remove at a later stage, if needed. Did Matkoniecz mean this issue, too related to the boundary issue?

image

polly64 commented 9 months ago

@MKIM1008 think we have to ask Council. for now I think we need to include polygons the top red circle as I imagine these will be included in the next time the government revises town boundaries , and just leaver these polygons outside the above loughborough boundary - as this is obviously new town buildings bursting out of current boundary but clearly connected-Whereas red circle at bottom contains polygons that don't actually look like buildings from the shape - could you check what they are?- think we should probably ignore

MKIM1008 commented 9 months ago

@polly64

Is it required to create a land use map using the OS OpenMap Local?

Commercial Ancillary Building OS Master Map image

OS OpenMap Local image

polly64 commented 9 months ago

@MKIM1008 It's interesting to just play around but might be worth waiting until Mateusz has done the INSPIRE/OML merge

matkoniecz commented 7 months ago

How we done this by any chance?

MKIM1008 commented 7 months ago

How we done this by any chance?

I've combined the land use from OS OML with OS MM. I am not sure we will include OS OML polygons in the live platform.

polly64 commented 7 months ago

@MKIM1008 this is helpful to see, yes the OML are used combined with INSPIRE on live platform

MKIM1008 commented 6 months ago

  1. Land Use Specific Systems: Land-Based Classification Standards (LBCS) North American Land Use Classification System (NALUCS) Anderson Land Use Classification Canadian Land Use Monitoring Program (CLUMP) Australian Land Use and Management (ALUM) Classification System Japan's Land Use Classification System South Africa's Land Use Classification System FAO Land Cover Classification System (LCCS) Indian Remote Sensing Satellite (IRS) Land Use and Land Cover Classification System Chinese Land Use Classification System

  2. Urban and Regional Analysis Tools: European Space Agency's Urban Atlas CORINE Land Cover (CLC) United States National Land Cover Database (NLCD) Land Use and Coverage Area frame Survey (LUCAS) UK Land Use Database (UKLUD) The Multi-Resolution Land Characteristics Consortium (MRLC)

  3. Property Valuation and Taxation: VOA SCAT Codes (Valuation Office Agency Site Code and Address Type)

  4. Indirectly Related to Land Use through Economic Expenditure: Classification of Individual Consumption According to Purpose (COICOP)