Gresham地图 PostGIS SQL格式
基于 OpenStreetMap 数据构建的地图，可供下载
自定义地图
在构建器中打开该地点的区域并按需调整
在构建器中打开 →地图档案
关于 PostGIS SQL
Gresham 的地图，PostGIS SQL 格式 — 所选区域真实 OpenStreetMap 数据的导出。
PostGIS SQL is a geodata dump as an SQL script for PostgreSQL/PostGIS. CREATE TABLE + INSERT with geometry for direct database import.
文件中包含哪些图层
所选区域的该文件包含：
- 道路
- 建筑物
- 水域
- 绿地
- 兴趣点
坐标系
WGS 84 (EPSG:4326)，可在向导中选择
兼容性
单位
米（在所选坐标系中投影）
| 类别 | GIS |
| 文件扩展名 | .sql |
| 级别 | Open Beta |
What's in the PostGIS SQL map of Gresham
32,890 buildings (7,813 residential, 39 commercial, 15 industrial, 8 religious), 976.2 km of roads, 304 points of interest, 12 landmarks.
The area covers 61 km², with about 537 buildings per km².
Mostly service roads 425.6 km, residential streets 355.5 km, tertiary roads 73.9 km.
19% of the area is green space.
The map marks 5 parks and 9 water bodies.
Key amenities: kindergartens — 6, pharmacies — 11, convenience stores — 24.
Public transport: 342 bus stops, 18 tram stops, 9 rail stations.
Main streets: Southeast Stark Street, West Powell Boulevard, Northeast Glisan Street, Southeast 242nd Avenue, East Burnside Street
Landmarks: City Park Church, Rockwood Christan Church, Springwater Church of the Nazarene, Cornerstone Church, Mountainview Christian Church
如何为 Gresham 使用 PostGIS SQL
- 在主页选择 Gresham 的地图区域
- 选择 PostGIS SQL 格式并配置导出设置
- 点击「导出」并等待处理完成
- 下载生成的文件并在所需程序中使用
