Postcode units - Great Britain: Code-Point Open
收藏Snowflake2025-07-17 更新2025-07-18 收录
下载链接:
https://app.snowflake.com/marketplace/listing/GZ1MOZ2HCBPHF
下载链接
链接失效反馈官方服务:
资源简介:
## Introduction
Code-Point® Open locates 1.7 million postcode units in Great Britain. Postcode units are unique references and identify an average of 15 addresses. In some cases, where an address receives a substantial amount of mail, a postcode will apply to only one address and is defined as a large-user postcode. The maximum number of addresses in a postcode is 100. The data contains locations for postcode units, NHS authority codes and administrative county, district and ward codes.
Category: Areas and zones
Coverage: Great Britain
Update Cycle: Quarterly in February, May, August, November
Documentation: [Code-Point Open | OS Download Products' Documentation](https://docs.os.uk/os-downloads/addressing-and-location/code-point-open)
<p><br/></p>
**What's in this product?**
Code-Point Open: An open dataset of all the current postcode units in Great Britain. For each postcode, Code-Point Open provides a positional quality indicator (PQI), country code, NHS area code along with local government county, district, and ward codes.
What is its value?
Code-Point Open creates value for customers in a variety of ways including:
1. Locate your analysis: Link any dataset that includes postcode data to the postcode location in a GIS and build up a spatial picture of your data.
2. Link statistical and numeric datasets to your postcode data: Using ONS administrative unit codes and NHS health authority code attributes in each postcode.
3. Additional attributes: To give you extra analytical power, Code-Point Open includes NHS authority and administrative unit codes.
4. Authoritative data: Code-Point Open provides accurate coverage of the 1.7 million postcodes in Great Britain. The product is updated quarterly.
Case Studies
OS data helps keep hospital open in Somerset https://www.ordnancesurvey.co.uk/customers/case-studies/stroke-nhs
提供机构:
Ordnance Survey
创建时间:
2025-06-30
原始信息汇总
Postcode units - Great Britain: Code-Point Open
概述
- 提供者: Ordnance Survey
- 价格: 免费
- 访问权限: 无限制
- 最后更新: 2025年5月
- 更新周期: 每季度(2月、5月、8月、11月)
- 覆盖范围: 大不列颠(英格兰、苏格兰、威尔士)
- 格式: 矢量 - 点
- 比例尺: 1:1 250 至 1:10 000
数据集内容
- 数据量: 170万个邮政编码单位
- 内容描述:
- 每个邮政编码单位的位置
- 位置质量指标(PQI)
- 国家代码
- NHS区域代码
- 地方政府县、区和选区代码
- 最大地址数: 每个邮政编码最多100个地址
- 特殊类型: 大型用户邮政编码(单个地址的邮政编码)
数据字典
表名: PRS_CODE_POINT_OPEN_VW
| 列名 | 数据类型 | 描述 |
|---|---|---|
| POSTCODE | Varchar | 邮政编码 |
| POSITIONAL_QUALITY_INDICATOR | Number | 位置质量指标 |
| COUNTRY_CODE | Varchar | 国家代码 |
| NHS_REGIONAL_HA_CODE | Varchar | NHS区域卫生局代码 |
| NHS_HA_CODE | Varchar | NHS卫生局代码 |
| ADMIN_COUNTY_CODE | Varchar | 行政县代码 |
| ADMIN_DISTRICT_CODE | Varchar | 行政区代码 |
| ADMIN_WARD_CODE | Varchar | 行政选区代码 |
| GEOMETRY | Object | 英国国家网格坐标 |
| GEOGRAPHY | Object | 经纬度坐标 |
使用案例
-
生成特定NHS卫生局的邮政编码列表 sql SELECT POSTCODE, GEOMETRY, GEOGRAPHY FROM PRS_CODE_POINT_OPEN_SCH.PRS_CODE_POINT_OPEN_VW WHERE NHS_HA_CODE = E18000007;
-
查找威尔士的邮政编码位置 sql SELECT POSTCODE, GEOGRAPHY, GEOMETRY FROM PRS_CODE_POINT_OPEN_SCH.PRS_CODE_POINT_OPEN_VW WHERE COUNTRY_CODE = W92000004;
商业需求
- 地理编码: 显示和分析邮政编码级别的数据
- 应用场景:
- 站点定位
- 网络搜索支持
- 市场分析和画像
- 健康和流行病学
- 资源分配
- 端到端旅程路线规划
- 社会经济画像
- 销售目标定位
已知问题
相关数据集
-
Road network - Great Britain: Open Roads
- 覆盖范围: 包括高速公路、A级公路、B级公路、乡村道路
- 价格: 免费
-
Unique Property Reference Numbers - Great Britain: Open UPRN
- 覆盖范围: 约4000万个物业位置
- 价格: 免费
-
Urban Extents for Cities, Towns and Villages - Great Britain: Open Built Up Areas
- 用途: 支持统计分析和政策制定
- 价格: 免费
-
Watercourses, Water Bodies, Rivers - Great Britain: Open Rivers
- 覆盖范围: 144,000公里的水体、水道、淡水河流、潮汐河口和运河
- 价格: 免费
-
Sample: Buildings - GB: OS National Geographic Database
- 覆盖范围: 超过4000万栋建筑
- 价格: 免费试用
-
Parks, Sports Facilities, Allotments - Great Britain: Open Greenspace
- 覆盖范围: 公共公园、体育设施、游乐区、分配地
- 价格: 免费
联系方式
- 销售: os.snowflake.support@os.uk
- 支持: os.snowflake.support@os.uk
法律条款
- 条款类型: 标准
搜集汇总
数据集介绍

背景与挑战
背景概述
该数据集为英国邮政编码定位数据,覆盖170万个邮政编码单位,提供每个邮政编码的地理位置、NHS代码以及行政区域代码。数据每季度更新,可用于空间分析、统计链接和权威地理覆盖,支持多种应用场景。
以上内容由遇见数据集搜集并总结生成



