Land use sections revisions and manufacturing/industry section

[polly64]

Hi @mdsimpson42 and @matkoniecz , @MKIM1008 and I are working on a revised land use section and a GB Manufacturing and SME map. Mike we're wanting to replace the NLUD categories with SIC (Standard Industrial Classifications) from ONS as our next job but let's chat tues.

• We need to group these in order to i) create a readable map including all sections as now , b) in a way that reduces number of categories to roughly number we have already for land use, and c) create a demo a map, with assistance from Cambridge Institute for Manufacturing (IfM) to visualise data useful to manufacturing to present at the University's Cambridge Science Festival mid March .https://www.ifm.eng.cam.ac.uk/aboutifm/outreach/ (@taimaz22 adding you also so you can track this thread/comment)

This will involve integrating the SIC database and transferring existing data across- @MKIM1008 and I can work on latter.

NLUD to SIC classification. These top tier divisions the same as for the United nations ISIC system https://unstats.un.org/unsd/publication/seriesm/seriesm_4rev4e.pdf

Current top tier CCRP land use classifications based on NLUD Mixed Use Single use: Residential (unverified) Residential (verified) Retail Industry & Business Community Services Recreation & Leisure Transport Utilities & Infrastructure Defence Agriculture Minerals Vacant & Derelict Unclassified, presumed non-residential

UK SIC top tier divisions https://www.ons.gov.uk/file?uri=/methodology/classificationsandstandards/ukstandardindustrialclassificationofeconomicactivities/uksic2007/uksic2007indexeswithaddendumdecember2022.xlsx - this has over 16,000 codes. A. Agriculture, forestry and fishing B. Mining and quarrying C. Manufacturing D. Electricity, gas, steam and air conditioning supply E. Water supply; sewerage, waste management and remediation activities F. Construction - of infrastructure /buildings G. Wholesale and retail trade; repair of motor vehicles and motorcycles
H. Transportation and storage I. Accommodation and food service activities J. Information and communication K. Financial and insurance activities L. Real estate activities M. Professional, scientific and technical activities N. Administrative and support service activities (agencies dealing with rentals, security, employment, travel) O. Public administration and defence; P. Education Q. Human health and social work activities (Health and care) R. Arts, entertainment and recreation* S. Other service activities (hairdressing, funerals, memberships, washing and dry cleaning _ T. Activities of households as employers; undifferentiated goods- and services-producing activities of households for own use U. Activities of extraterritorial organizations and bodies

**Proposed CCRP top tier divisions for all countries based on ISIC/UK SIC top tier divisions and linking to all SIC codes

1. Mixed Use Single use:
2. Residential (unverified)
3. Residential
4. Retail and wholesale trade
5. Offices, labs, studios, legal chambers
6. Manufacturing
7. Education
8. Health and care
9. Arts, entertainment and recreation
10. Bars ,restaurants and accommodation
11. Public administration and defence
12. Transportation
13. Utilities & communications
14. Agriculture, forestry and fishing
15. Mining and quarrying
16. Other
17. Vacant & Derelict
18. Unclassified, presumed non-residential

Changes required:

1. Residential (SIC code n/a). Stays the same
2. Retail and wholesale trade (SIC codes G). Change name only from 'Retail'
3. Spilt 'Industry and Business' into NEW Offices, labs, studios, legal chambers (SIC codes K (financial and insurance activities), L (Real estate activities) , M (professional scientific and technical activities, N (admin and support services) NEW Manufacturing on/off site' (SIC codes C= manufacturing plus F=,'Construction')
4. REMOVE 'Community Services' and split out education, health and gov admin buildings ADD NEW Education (SIC codes P) ADD NEW Health and care (SIC codes Q)
5. Arts, entertainment and recreation (SIC codes R)_change name only from 'Recreation & Leisure'
6. NEW Bars ,restaurants and accommodation (SIC codes I) (add OSM data for London for these)
7. MERGE 'Defence' with government buildings from Community services and rename Public administration and defence (SIC codes O)
8. Transportion - _change name only from 'Transport' (SIC codes H)
9. Utilities & communications (SIC codes D utilities and J communication ). Change name only from 'Utilities and infrastructure'
10. 'Agriculture' change name only to Agriculture, forestry and fishing (SIC codes A)
11. 'Minerals' change name only to Mining and quarrying (SIC codes B)
12. ADD NEW Other (SIC codes S,T,U)
13. 'Vacant & Derelict' (SIC codes n/a)
14. 'Unclassified, presumed non-residential' (SIC codes n/a)

[polly64]

@MKIM1008 when you have time could you download all the ISIC codes and compare them against the UK SIC codes so we can look at all the ones that differ many thanks

[MKIM1008]

https://github.com/colouring-cities/colouring-britain/issues/61#issuecomment-1853012332

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

---

ISIC code

Source: International Standard Industrial Classification of All Economic Activities (ISIC) Rev. 4

[MKIM1008]

SIC code VS ISIC code (the same), I will compare with the sub-categories further. <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">

  | Standard Industrial Classification (SIC) code | International Standard Industrial Classification (ISIC) code -- | -- | -- Section | Description | Description A | Agriculture, Forestry and Fishing | Agriculture, forestry and fishing B | Mining and Quarrying | Mining and quarrying C | Manufacturing | Manufacturing D | Electricity, gas, steam and air conditioning supply | Electricity, gas, steam and air conditioning supply E | Water supply, sewerage, waste management and remediation activities | Water supply, sewerage, waste management remediation activities F | Construction | Construction G | Wholesale and retail trade; repair of motor vehicles and motorcycles | Wholesale and retail trade; repair of motor and motorcycles H | Transportation and storage | Transportation and storage I | Accommodation and food service activities | Accommodation and food service activities J | Information and communication | Information and communication K | Financial and insurance activities | and insurance activities L | Real estate activities | Section L Real estate activities M | Professional, scientific and technical activities | Professional, scientific and technical activities N | Administrative and support service activities | Administrative and support service activities O | Public administration and defence; compulsory social security | Public administration and defence; social security P | Education | Education Q | Human health and social work activities | Human health and social work activities R | Arts, entertainment and recreation | Arts, entertainment and recreation S | Other service activities | Other service activities T | Activities of households as employers; undifferentiated goods- and services-producing activities of households for own use | Activities of households as employers; undifferentiated goods- and services-producing activities of households for own use U | Activities of extraterritorial organisations and bodies | Activities of extraterritorial organisations and bodies

[MKIM1008]

High growth business in SME https://www.gov.uk/government/publications/women-led-high-growth-enterprise-taskforce-meeting-minutes/oecd-defined-high-growth-enterprises-in-the-uk#:~:text=All%20enterprises%20with%20average%20annualised,of%20employees%20or%20by%20turnover.

[MKIM1008]

<html xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">

NAICS code | North American Industry Classification System | NAICS code | Proposed Colouring Cities main categories | NAICS code | Test -- | -- | -- | -- | -- | -- 11 | Agriculture, Forestry, Fishing and Hunting | 11 | Agriculture, forestry and fishing | 11 | Agriculture, forestry and fishing 21 | Mining, Quarrying, and Oil and Gas Extraction | 21 | Mining and quarrying | 21 | Mining and quarrying 22 | Utilities | 22-23 | Utilities & Infrastructure | 22-23 | Utilities & Infrastructure 23 | Construction |   |   |   |   31-33 | Manufacturing | 31-33 | Manufacturing | 31-33 | Manufacturing 42 | Wholesale Trade | 42, 44-45 | Retail and Wholesale | 42, 44-45 | Retail and Wholesale 44-45 | Retail Trade |   |   |   |   48-49 | Transportation and Warehousing | 48-49 | Transportation and storage | 48-49 | Transportation and storage 51 | Information |   |   | 51 | Information & Communication 52 | Finance and Insurance | 52, 53 | Financial, Insurance & Real estate services | 52, 53 | Financial, Insurance & Real estate services 53 | Real Estate and Rental and Leasing |   |   |   |   54 | Professional, Scientific, and Technical Services | 54 | Professional and other services | 54 | Professional, Scientific, and Technical Activities 55 | Management of Companies and Enterprises |   |   |   |   56 | Administrative and Support and Waste Management and Remediation Services |   |   |   |   61 | Educational Services | 61 | Education | 61 | Education 62 | Health Care and Social Assistance | 62 | Health & Wellbeing | 62 | Health & Wellbeing 71 | Arts, Entertainment, and Recreation | 71 | Arts, entertainment and recreation | 71 | Arts, entertainment and recreation 72 | Accommodation and Food Services | 72 | Eating, drinking and leisure accommodation | 72 | Eating, drinking and leisure accommodation 81 | Other Services (except Public Administration) |   |   |   |   92 | Public Administration | 92 | Other Community Services  / Defence | 92 | Other Public Services  / Defence   |   | - | Online and hybrid business services | - | Online and hybrid business services   |   |   |   | - | Other services provided in bespoke premises (e.g. hair dressers, motor repairs, funeral parlour, renting equipments, selling travel services, etc.)   |   |   |   | - | Company offices not-categorised   |   | - | Mixed use | - | Mixed use   |   | - | Other (household based activities) | - | Other

[MKIM1008]

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">

NAICS code | North American Industry Classification System -- | -- 11 | Agriculture, Forestry, Fishing and Hunting 21 | Mining, Quarrying, and Oil and Gas Extraction 22 | Utilities 23 | Construction 31-33 | Manufacturing 42 | Wholesale Trade 44-45 | Retail Trade 48-49 | Transportation and Warehousing 51 | Information 52 | Finance and Insurance 53 | Real Estate and Rental and Leasing 54 | Professional, Scientific, and Technical Services 55 | Management of Companies and Enterprises 56 | Administrative and Support and Waste Management and Remediation Services 61 | Educational Services 62 | Health Care and Social Assistance 71 | Arts, Entertainment, and Recreation 72 | Accommodation and Food Services 81 | Other Services (except Public Administration) 92 | Public Administration

[MKIM1008]

@polly64,

Can we add a high-growth business code? https://www.gov.uk/government/publications/women-led-high-growth-enterprise-taskforce-meeting-minutes/oecd-defined-high-growth-enterprises-in-the-uk#:~:text=All%20enterprises%20with%20average%20annualised,of%20employees%20or%20by%20turnover.

[polly64]

Sure. Have u looked at one land use data? Someone just said this was a source