-
Notifications
You must be signed in to change notification settings - Fork 64
Datasets
April 23rd, 2019
Import OSM data from Berlin in pgRouting format into PostgreSQL/PostGIS
wget -N --progress=dot:mega "https://download.geofabrik.de/europe/germany/berlin-latest.osm.bz2"
bunzip2 berlin-latest.osm.bz2
osm2pgrouting -f berlin-latest.osm -d database -U user -W password
Export shapefiles from PostgreSQL/PostGIS
...
Import shapefiles to Secondo
...
Match vehicles and routes
...
Output network moving points
...
Thiago
March 12, 14th, 2019
Compatibility: OpenStreetMap, PostgreSQL/PostGIS, pgRouting, MobilityDB
Steps:
- Unzip the file (e.g. in the home directory):
tar -xjvf brussels.tar.bz2
- Connect to the DBMS:
psql
- Create a proper database or skip to step 4.
create database mydb;
\c mydb
create extension postgis;
create extension pgrouting;
create extension mobilitydb;
- Create a schema:
create schema brussels;
- Import data:
\i ~/brussels_configuration.sql
\i ~/brussels_pointsofinterest.sql
\i ~/brussels_ways_vertices_pgr.sql
\i ~/brussels_ways.sql
The tables are brussels.configuration, brussels.pointsofinterest, brussels.ways_vertices_pgr and brussels.ways.
Warning: some MobilityDB functions are working only when tables are in the schema public (e.g. geometry_in_network, in_space). Move the tables to that schema and thereafter thus drop the schema brussels. Then:
alter table brussels.configuration set schema public;
alter table brussels.pointsofinterest set schema public;
alter table brussels.ways_vertices_pgr set schema public;
alter table brussels.ways set schema public;
drop schema brussels;
Thiago
March 11th, 2019
Requirements: regions
Prerequisites: PostgreSQL, PostGIS, shp2pgsql
Download:
http://biogeo.ucdavis.edu/data/diva/adm/BEL_adm.zip
Unzip and execute the commands below.
Thiago
March 8th, 2019
Requirements: diverse geometry types and around 1GB of data
Prerequisites: PostgreSQL, PostGIS, shp2pgsql
Download:
wget -N --progress=dot:mega "http://download.geofabrik.de/asia/china-latest-free.shp.zip
Unzip:
bunzip2 china-latest-free.shp.zip
Import (creates and inserts into the table roads):
shp2pgsql -s 4326 -S gis_osm_roads_free_1 roads | psql -d berlinshp
Query!
Thiago