作者
digoal
日期
2021-09-08
标签
PostgreSQL , gis , pgrouting , osm , openstreetmap
https://gis.cybertec-postgresql.com/
https://www.cybertec-postgresql.com/en/openstreetmap-service-by-cybertec/
OPENSTREETMAP SERVICE BY CYBERTEC
cybertec 提供的地图和路网数据, 数据源来自openstreetmap, 为什么要提供这个服务? 直接去openstreetmap下载不好吗?
1、openstreetmap下载需要提供经纬度范围, 不适合小白.
2、openstreetmap下载的数据导入比较慢.
cybertec 每天刷新一次osm数据, 同时导入到数据库并以pg_dump格式导出, 以国家为单位提供dump文件的下载, 同时将数据拆分为路网数据和地图数据两部分, 便于用户选择使用.
Dataset frequency
How often will our datasets be generated? Native extracts (pbfs) are generated daily, dumps are produced 1 to 2 times per month. Currently, we’re trying to optimize the whole process to provide current dumps more frequently for our customers.
The general instructions are as follows:
Firstly, start by heading to https://gis.cybertec-postgresql.com/ and choose your region of interest. Figure 2 shows available datasets for Austria at present time. As we want to setup a tiling service, our dataset flavor of choice is “Analysis, Tiling”. Let’s download the latest dump for this region from https://gis.cybertec-postgresql.com/osmtile/europe/austria/osmtile_europe_austria_latest_compressed.dump
Secondly, we must import our dump. How can this be accomplished?
Instructions are published beneath each published dump as readme.txt. For Austria, instructions can be accessed at https://gis.cybertec-postgresql.com/osmtile/europe/austria/readme.txt.
Let’s quickly look at the instructions to better understand how we must proceed. As requirement, a database must be prepared, with extensions PostGIS and hstore enabled.
postgres=# create database tilingdb;
CREATE DATABASE
postgres=# \c tilingdb
psql (13.3 (Ubuntu 13.3-1.pgdg20.04+1), server 13.4 (Ubuntu 13.4-1.pgdg20.04+1))
You are now connected to database "tilingdb" as user "postgres".
tilingdb=# create extension postgis;
CREATE EXTENSION
tilingdb=# create extension hstore;
CREATE EXTENSION
Finally, the dump can be restored by executing
pg_restore -j 4 --no-owner -d tilingdb
osmtile_europe_austria_latest_compressed.dump
This results in a new database schema osmtile_europe_austria.
tilingdb=# \dn
List of schemas
Name | Owner
------------------------+----------
osmtile_europe_austria | postgres
public | postgres
(2 rows)
The upcoming listing shows generated tables within our schema.
tilingdb=# \dt+ osmtile_europe_austria.
List of relations
Schema | Name | Type | Owner | Persistence | Size | Description
------------------------+--------------------+-------+----------+-------------+---------+-------------
osmtile_europe_austria | planet_osm_line | table | postgres | permanent | 1195 MB |
osmtile_europe_austria | planet_osm_nodes | table | postgres | permanent | 3088 MB |
osmtile_europe_austria | planet_osm_point | table | postgres | permanent | 323 MB |
osmtile_europe_austria | planet_osm_polygon | table | postgres | permanent | 1865 MB |
osmtile_europe_austria | planet_osm_rels | table | postgres | permanent | 102 MB |
osmtile_europe_austria | planet_osm_roads | table | postgres | permanent | 130 MB |
osmtile_europe_austria | planet_osm_ways | table | postgres | permanent | 1996 MB |
(7 rows)
PostgreSQL 许愿链接
您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.
9.9元购买3个月阿里云RDS PostgreSQL实例
PostgreSQL 解决方案集合
德哥 / digoal's github - 公益是一辈子的事.
