search

inasafe / inasafe-fba

Next generation of InaSAFE that includes support for forecast based action
MIT License
1 stars 8 forks source link

Adding population to the summary tables #57

Open timlinux opened 4 years ago

timlinux commented 4 years ago

New field names for pop to be added to all summary tables:

See #55

Screenshot 2020-02-04 at 09 56 53

Podes should use a generic term "census"

census_population census_females census_males census_unemployed census_elderly

Worldpop should use specific prefix 'worldpop_'

worldpop_affected_high_hazard worldpop_affected_low_hazard

@lucernae please provide the Podes data to @NyakudyaA

When importing the podes data, use generic table name like 'census' so that we can use the same model in other countries. For the raster pop we need to use zonal stats technique like described here:

https://www.perrygeo.com/zonal-stats-with-postgis-rasters.html

The stats should be available at event, district, subdistrict, and village level.

lucernae commented 4 years ago

I'll drop off here the data source website for documentations:

https://gis.dukcapil.kemendagri.go.id/peta/

lucernae commented 4 years ago

The local census table part is done. Next is the worldpop table. Can you take over this @NyakudyaA for the worldpop? Do you already know where to get the worldpop source? I want to document it in the repo for now.

NyakudyaA commented 4 years ago

The local census table part is done. Next is the worldpop table. Can you take over this @NyakudyaA for the worldpop? Do you already know where to get the worldpop source? I want to document it in the repo for now.

The data comes from here https://www.worldpop.org/. I think they also have an API (https://www.worldpop.org/sdi/introapi) to access the data but since we will be loading the data once off we can just download it and ingest it.