Add changes for boundary and population ingester

[lucernae]

Work in Progress

We are attempting to ingests data from GeoCRIS table or features for admin boundaries and population automatically

List of todos:

• [x] Create global admin boundaries mapping table, so we can assign unique id for all countries' admin boundaries. We can then track back from id to the source table.
• [x] Use pg_featureserv. (not available at the moment)
• [x] Prototyping using SQL connection. (will be changed once pg_featureserv is ready).
• [x] Legend for the new Hurricane forecast hazard layer.

[lucernae]

Setup steps to test new changes:

Use hardcoded CDEMA boundaries

In deployment/env fill in option:

DEFAULT_INITIAL_MAP_BOUNDS=[[-6.656216214,-107.546395306],[42.506191841,-46.020831507]]

Generate mapfile

from deployment

make down up mapserver-generate-mapfile

Apply db changes

from deployment

make backend-schema-test backend-populate-test-data

If you need to retrieve GeoCRIS GeoJSON collections

Must be done in order:

From mapserver dir:

make up django-shell
# or if you are in dev mode
make up django-dev-shell

From inside the container, run management command:

./manage.py ingest_boundary_data
./manage.py ingest_building_data
./manage.py ingest_road_data

Each of the management command might take some time to complete, so it's better if you use separate terminal for each. At least boundary needs to be fetched first. Building and road can be in parallel.

Fetch latest hazard

From mapserver dir:

make up django-shell
# or if you are in dev mode
make up django-dev-shell

From inside the container, run management command:

./manage.py ingest_hazard_data

If the hurricane is not in our test area, move the hurricane using QGIS for testing the intersections.

From the db (psql shell), run:

select kartoza_calculate_impact()

to redo the calculations.

[lucernae]

It's done and I'm going to merge it.