Location Data for the Public Sector: PSGA Members

## **Introduction**

UK public sector organisations can access 12 open and premium location Ordnance Survey (OS) datasets on this one marketplace listing - this means Public Sector Geospatial Agreement (PSGA) members can click one button to request access to all of the Ordnance Survey (OS) data that is on Snowflake Marketplace currently.

**What data is available?**

Premium

1. [Addresses - UK: OS GB Address and OS Islands Address](https://app.snowflake.com/marketplace/listing/GZ1MOZ2HCBPI0/ordnance-survey-addresses-uk-os-gb-address-and-os-islands-address?search=ordnance%2520survey&sortBy=title&originTab=provider&providerName=Ordnance%2520Survey&profileGlobalName=GZ1MOZBWYT0)
2. [Buildings - Great Britain: OS Buildings Features](https://app.snowflake.com/marketplace/listing/GZ1MOZ2HCBPIO/ordnance-survey-buildings-great-britain-os-buildings-features?search=ordnance%2520survey&sortBy=title&originTab=provider&providerName=Ordnance%2520Survey&profileGlobalName=GZ1MOZBWYT0)
3. [Land Cover - Great Britain: OS Land Features](https://app.snowflake.com/marketplace/listing/GZ1MOZ2HCBPHV/ordnance-survey-land-cover-great-britain-os-land-features?search=ordnance%2520survey&sortBy=title&originTab=provider&providerName=Ordnance%2520Survey&profileGlobalName=GZ1MOZBWYT0)
4. [Sites - Great Britain: OS Land Use Features](https://app.snowflake.com/marketplace/listing/GZ1MOZ2HCBPHR/ordnance-survey-sites-great-britain-os-land-use-features?search=ordnance%2520survey&sortBy=title&originTab=provider&providerName=Ordnance%2520Survey&profileGlobalName=GZ1MOZBWYT0)

Open

1. [Administrative boundaries - Great Britain: Boundary Line - Open](https://app.snowflake.com/marketplace/listing/GZ1MOZBWYYT/ordnance-survey-administrative-boundaries-great-britain-boundary-line-open?search=ordnance%2520survey&sortBy=title&originTab=provider&providerName=Ordnance%2520Survey&profileGlobalName=GZ1MOZBWYT0)
2. [Parks, Sports Facilities, Allotments - Great Britain: Open Greenspace](https://app.snowflake.com/marketplace/listing/GZ1MOZBX00E/ordnance-survey-parks-sports-facilities-allotments-great-britain-open-greenspace?search=ordnance%2520survey&sortBy=title&originTab=provider&providerName=Ordnance%2520Survey&profileGlobalName=GZ1MOZBWYT0)
3. [Postcode units - Great Britain: Code-Point Open](https://app.snowflake.com/marketplace/listing/GZ1MOZ2HCBPHF/ordnance-survey-postcode-units-great-britain-code-point-open?search=ordnance%2520survey&sortBy=title&originTab=provider&providerName=Ordnance%2520Survey&profileGlobalName=GZ1MOZBWYT0)
4. [Postcodes, Place Names and Road Numbers - Great Britain: Open Names](https://app.snowflake.com/marketplace/listing/GZ1MOZBWYYX/ordnance-survey-postcodes-place-names-and-road-numbers-great-britain-open-names?search=ordnance%2520survey&sortBy=title&originTab=provider&providerName=Ordnance%2520Survey&profileGlobalName=GZ1MOZBWYT0)
5. [Road network - Great Britain: Open Roads](https://app.snowflake.com/marketplace/listing/GZ1MOZBX00A/ordnance-survey-road-network-great-britain-open-roads?search=ordnance%2520survey&sortBy=title&originTab=provider&providerName=Ordnance%2520Survey&profileGlobalName=GZ1MOZBWYT0)
6. [Unique Property Reference Numbers - Great Britain: Open UPRN](https://app.snowflake.com/marketplace/listing/GZ1MOZBWYYH/ordnance-survey-unique-property-reference-numbers-great-britain-open-uprn?search=ordnance%2520survey&sortBy=title&originTab=provider&providerName=Ordnance%2520Survey&profileGlobalName=GZ1MOZBWYT0)
7. [Urban Extents for Cities, Towns and Villages - Great Britain: Open Built Up Areas](https://app.snowflake.com/marketplace/listing/GZ1MOZBX00Q/ordnance-survey-urban-extents-for-cities-towns-and-villages-great-britain-open-built-up-areas?search=ordnance%2520survey&sortBy=title&originTab=provider&providerName=Ordnance%2520Survey&profileGlobalName=GZ1MOZBWYT0)
8. [Watercourses, Water Bodies, Rivers - Great Britain: Open Rivers](https://app.snowflake.com/marketplace/listing/GZ1MOZBX006/ordnance-survey-watercourses-water-bodies-rivers-great-britain-open-rivers?search=ordnance%2520survey&sortBy=title&originTab=provider&providerName=Ordnance%2520Survey&profileGlobalName=GZ1MOZBWYT0)

We plan to add more over the coming months, so if there is a dataset missing that you need, [reach out to us](mailto:[e-mail]).

**What is the PSGA?**

The PSGA sets out how OS provides world-leading location data and expertise to the public sector across Britain. It supports the delivery of critical infrastructure and services, as well as working to help protect our environment.

**Who uses the PSGA and OS data?**

Over 5,000 public sector organisations across Great Britain use OS data for the public benefit. From Central to Local Government, NHS and Emergency Services, access to OS data has helped deliver policy, environmental resilience, national security and local services.

**What are the benefits of the PSGA?**

Membership of the PSGA gives you access to our location data and technical support.

**Not sure if your organisation is a PSGA member?**

Use our [PSGA member finder tool](https://www.ordnancesurvey.co.uk/customers/public-sector/psga-member-finder "psga-member-finder") to check if your organisation is already a member of the PSGA. If it isn’t, you can [register](https://www.ordnancesurvey.co.uk/customers/public-sector/public-sector-geospatial-agreement/psga-registration) today to start the process.

**What’s the value of OS data?**

By combining OS's buildings and address data with additional intelligence from sites and land data, you can optimise asset management, understand differences between urban, rural and moorland areas to inform policy and infrastructure planning, assess environmental impacts of proposed developments, and model terrain-related perils to support effective flood risk assessment and resilience planning.

## Case studies

**Central government and emergency services**

[Environment Agency:](https://www.ordnancesurvey.co.uk/customers/case-studies/richer-data-protecting-people-from-flooding) Find out how The EA worked with OS to update and improve their existing property dataset.

[London Ambulance Service:](https://www.ordnancesurvey.co.uk/customers/case-studies/london-ambulance-os-places-api) OS Places API helps London Ambulance Service NHS Trust use flexible search methods for call handlers.

**Local government**

[Northumberland City Council:](https://www.ordnancesurvey.co.uk/customers/case-studies/northumberland-county-council-garden-waste-collection-service-savings) Discover how OS helped optimise Northumberland Country Council's waste collection routes.

[Slough Borough Council:](https://www.ordnancesurvey.co.uk/customers/case-studies/modelling-electric-vehicle-charging-for-a-more-sustainable-slough-borough-council) Read about modelling electric vehicle charging with OS data.

**Town, parish and community councils**

[Ash Parish Council:](https://www.ordnancesurvey.co.uk/customers/case-studies/ash-digital-mapping) Learn about how Ash Parish Council’s local mapping needs were solved using OS data.

[Dauntsey Parish Council:](https://www.ordnancesurvey.co.uk/customers/case-studies/dauntsey-flooding) use local knowledge and OS digital maps to undertake an analysis of local flood impacts.

原始信息汇总

Location Data for the Public Sector: PSGA Members 数据集概述

数据集基本信息

• 数据集名称: Location Data for the Public Sector: PSGA Members
• 提供商: Ordnance Survey
• 访问模式: 免费试用 (Trial: 90 day trial)
• 目标用户: 英国公共部门机构，特别是公共部门地理空间协议 (PSGA) 的成员

数据集内容与范围

该数据集为PSGA成员提供12个开放和高级的地理位置数据集，涵盖英国（大不列颠及岛屿）范围。

高级数据集 (Premium)

1. 地址: OS GB Address and OS Islands Address
2. 建筑物: OS Buildings Features
3. 土地覆盖: OS Land Features
4. 场地: OS Land Use Features

开放数据集 (Open)

1. 行政边界: Boundary Line - Open
2. 公园、体育设施、分配地: Open Greenspace
3. 邮政编码单元: Code-Point Open
4. 邮政编码、地名和道路编号: Open Names
5. 道路网络: Open Roads
6. 唯一财产参考编号: Open UPRN
7. 城市、城镇和村庄的城区范围: Open Built Up Areas
8. 水道、水体、河流: Open Rivers

主要应用场景 (Business Needs)

• 地理位置数据丰富化: 利用OS建筑物数据的丰富属性（如建筑年龄、建筑类型、连通性、高度、用途、地址数量、屋顶属性等）进行分析，并结合准确的位置和几何信息。利用土地覆盖数据进行土地面积估算和统计分析。
• 建成环境规划: 评估房产的可持续性和运营绩效，分析绿色屋顶、太阳能电池板、地下室（用于洪水风险评估）等信息，并与第三方房产能源证书数据集关联。评估新开发项目的环境影响，检查是否符合监管标准。
• 环境规划: 分析和理解感兴趣区域的自然景观，用于监测生物多样性净增益、自然恢复和环境影响评估。
• 风险分析: 了解地表性质，为洪水、野火等自然灾害的风险规划提供信息。识别自然洪水管理方案并为防洪和风险保险决策提供依据。
• 地理位置地理编码: 使用OS的建筑物和地址数据中的准确位置数据，精确定位地址和建筑物的位置。通过分析建筑物的用途、年龄、建筑材料和建造状态来创建特定区域的详细图景。
• 空间分析: 利用为每个建筑物或地址提供的准确屋顶坐标进行空间分析和聚合。理解不同建筑分类、屋顶类型、建筑高度、建筑年龄、建筑材料等的空间分布。

数据字典与预览

数据包含多个视图对象，例如：

• PRS_BUILDING_SAMPLE_VW
• PRS_DISTRICT_BOROUGH_UNITARY_WARD_VW
• PRS_GB_BUILTADDRESS_SAMPLE_VW
• PRS_NAMED_PLACE_VW
• PRS_ROAD_LINK_VW
• 以及其他62个对象

数据列示例 (部分)

数据预览显示了示例数据行和众多数据列中的一部分，包括：

• OSID (Varchar): 对象唯一标识符
• VERSIONDATE (Date): 版本日期
• GEOMETRY (Object): 几何对象
• GEOGRAPHY (Object): 地理对象
• THEME (Varchar): 主题（如"Buildings"）
• DESCRIPTION (Varchar): 描述（如"Mid-Terrace House"）
• BUILDINGUSE (Varchar): 建筑用途（如"Residential Accommodation"）
• CONSTRUCTIONMATERIAL (Varchar): 建筑材料
• BUILDINGAGE_PERIOD (Varchar): 建筑年代区间

数据价值与案例

• 价值: 通过结合OS的建筑物和地址数据以及来自场地和土地数据的额外情报，可以优化资产管理，理解城乡差异以指导政策和基础设施规划，评估拟议开发项目的环境影响，并模拟地形相关风险以支持有效的洪水风险评估和恢复力规划。
• 用户: 超过5,000个英国公共部门组织，从中英政府到地方政府、NHS和紧急服务部门。
• 案例研究:
  • 中央政府和紧急服务: 环境署（更新和改进其财产数据集）、伦敦救护车服务（使用OS Places API进行灵活搜索）。
  • 地方政府: 诺森伯兰郡议会（优化垃圾收集路线）、斯劳自治市议会（模拟电动汽车充电）。
  • 城镇、教区和社区议会: 阿什教区议会（解决本地测绘需求）、当特西教区议会（分析当地洪水影响）。