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

We need a way to assign population to each polygon #105

Open
timlinux opened this issue Dec 13, 2021 · 1 comment
Open

We need a way to assign population to each polygon #105

timlinux opened this issue Dec 13, 2021 · 1 comment

Comments

@timlinux
Copy link
Contributor

Maybe we can use pgraster to load w.g. worldpop and then do zonal stats to get the pop count for each polygon that is not yet populated. We could even do this db side to have a trigger that updates population whenever a poly is inserted.

@timlinux
Copy link
Contributor Author

Or we can just use the raster stats library

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

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

No branches or pull requests

1 participant