Загрузка данных в PostGIS¶

CREATE DATABASE osm  WITH ENCODING='UTF-8';
alter database osm owner to osm;
\c osm
CREATE EXTENSION postgis;
CREATE EXTENSION hstore; 
CREATE EXTENSION postgis_topology;
CREATE EXTENSION fuzzystrmatch;
-- https://dev.to/cincybc/create-your-own-geocoder-with-postgistiger-3anc
CREATE EXTENSION postgis_tiger_geocoder;
--this one is optional if you want to use the rules based standardizer (pagc_normalize_address)
CREATE EXTENSION address_standardizer;

download http://download.geofabrik.de/

wget http://download.geofabrik.de/russia/central-fed-district-latest.osm.bz2
#osm2pgsql -U osm -H db -d osm -l central-fed-district-latest.osm.bz2
osm2pgsql -k -s -U osm -H localhost -d osm -l russia-latest.osm.bz2

Qgis¶

https://qgis.org/

cd /usr/ports/graphics/qgis
make install clean