Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Adding population to the summary tables #57

Open
timlinux opened this issue Feb 4, 2020 · 3 comments · Fixed by #72
Open

Adding population to the summary tables #57

timlinux opened this issue Feb 4, 2020 · 3 comments · Fixed by #72
Assignees

Comments

@timlinux
Copy link
Contributor

timlinux commented Feb 4, 2020

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
Copy link
Contributor

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

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

@lucernae
Copy link
Contributor

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
Copy link
Contributor

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants