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

Rework spatial data tables #178

Open
rbroth opened this issue Jul 5, 2021 · 2 comments
Open

Rework spatial data tables #178

rbroth opened this issue Jul 5, 2021 · 2 comments
Assignees

Comments

@rbroth
Copy link
Collaborator

rbroth commented Jul 5, 2021

We want to import administrative regions of different levels for the same country (e.g.: Regions (level 1) and districts (level 2) for Malawi).

At the moment we have several different tables for storing spatial data related to country and admin region location data. We have a country table as well as region and subregion tables, all of which store geographic data that is very similar, but at different scales. We should rework these tables so that thye can deal with multiple levels of administrative boundaries

@rbroth rbroth self-assigned this Jul 5, 2021
@rbroth
Copy link
Collaborator Author

rbroth commented Jul 8, 2021

Semi-related: for importing spatial boundaries, for the MVP, use GADM data imported with ogr2ogr, then replace with "proper" spatial data later in the project

@rbroth
Copy link
Collaborator Author

rbroth commented Jul 9, 2021

todo list for myself

  • subregion table has ben reworked to be hierarchical and accept arbitrary regions
  • need to rename subregions table
  • need to see if "country" table can be removed and subregion/agg_area table be used instead
  • check what other geometries are currently imported and if it's in line with what we want the agg_area table to be

@rbroth rbroth added the Priority::1 User story that we want to focus on label Jan 19, 2022
@rbroth rbroth added Priority::3 and removed Priority::1 User story that we want to focus on labels Feb 2, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant