owl-map/README.md

# OWL-MAP

## Setup
* clone the project
* install geoip and postgis from your local package manager
  * `$ sudo pacman -S postgis geoip`
* setup postgres on your machine, see e.g. https://wiki.archlinux.org/title/PostgreSQL
  * `$ sudo su postgres`
  * `$ initdb -D /var/lib/postgres/data`
* start postgres
* create postgres user
  * `$ sudo su postgres`
  * `$ createuser --interactive` -> "owl" role with relevant priviledges
* create postgres database "matcher" with hstore and postgis extensions
  * `$ psql -U postgres`
  * `> CREATE DATABASE matcher;`
  * `> ALTER DATABASE matcher OWNER TO owl;`
  * `> CREATE EXTENSION hstore;`
  * `> CREATE EXTENSION postgis;`
* create the db tables
  * setup database credentials and name in default.py
  * `$ python create_db.py`
* setup a venv
  * enter the venv, e.g. in pycharm
  * `$ pip install -r requirements.txt`
* `$ cp config/example.py config/default.py`
* download id-tagging-schema
  * `$ git clone https://github.com/openstreetmap/id-tagging-schema`
  * adjust paths in default.py
* download geoip databases
  * https://git.io/GeoLite2-City.mmdb
  * `$ pacman -S geoip-database-extra` in ArchLinux or https://dl.miyuru.lk/geoip/maxmind/city/maxmind4.dat.gz
  * adjust default.py
* run the tests
* run 'python web_view.py'