Diskuse:Cvičná databáze PostGIS: Porovnání verzí
Založena nová stránka: == Poznámky pro administraci == |
|||
| (Nejsou zobrazeny 3 mezilehlé verze od stejného uživatele.) | |||
| Řádek 1: | Řádek 1: | ||
== Poznámky pro administraci == | == Poznámky pro administraci == | ||
=== osm_routing === | |||
./osm2pgrouting -file ~/czech-republic-latest.osm -conf mapconfig.xml -dbname pgis_osm_rouring -user landa -passwd ... | |||
<source lang=sql> | |||
ALTER TABLE classes SET SCHEMA osm_routing; | |||
ALTER TABLE nodes SET SCHEMA osm_routing; | |||
ALTER TABLE relation_ways SET SCHEMA osm_routing; | |||
ALTER TABLE relations SET SCHEMA osm_routing; | |||
ALTER TABLE types SET SCHEMA osm_routing; | |||
ALTER TABLE way_tag SET SCHEMA osm_routing; | |||
ALTER TABLE ways SET SCHEMA osm_routing; | |||
</source> | |||
pg_dump -Fc -b -v -f pgis_osm_routing.dump -n osm_routing pgis_osm_rouring | |||
postgis_restore.pl pgis_osm_routing.dump | psql pgis_student | |||
Aktuální verze z 6. 5. 2013, 16:24
Poznámky pro administraci
osm_routing
./osm2pgrouting -file ~/czech-republic-latest.osm -conf mapconfig.xml -dbname pgis_osm_rouring -user landa -passwd ...
ALTER TABLE classes SET SCHEMA osm_routing;
ALTER TABLE nodes SET SCHEMA osm_routing;
ALTER TABLE relation_ways SET SCHEMA osm_routing;
ALTER TABLE relations SET SCHEMA osm_routing;
ALTER TABLE types SET SCHEMA osm_routing;
ALTER TABLE way_tag SET SCHEMA osm_routing;
ALTER TABLE ways SET SCHEMA osm_routing;
pg_dump -Fc -b -v -f pgis_osm_routing.dump -n osm_routing pgis_osm_rouring postgis_restore.pl pgis_osm_routing.dump | psql pgis_student