New task was created
Add countries to cities/islands
Created on Tuesday 18 May 2021, 02:59
Back to task list-
ID987459
-
ProjectMetabolism of Cities Data Hub
-
StatusCompleted
-
PriorityMedium
-
TypeProgramming work
-
TagsData Hub Priority Plan 2021 General data hub improvements
-
Assigned toPaul Hoekman
-
SubscribersPaul Hoekman
Description
We should have a link between cities/islands and countries. The best way to do this is by taking the gps coordinates and checking the global country file to determine which country this is in. However, we don't want a spatial lookup every time a country is displayed, so we should also save this in the reference space itself.
Discussion and updates
Paul Hoekman
Johannesburg
3 years, 6 months ago
Paul Hoekman
Johannesburg
3 years, 6 months ago
Task was assigned to Paul Hoekman
Paul Hoekman
Johannesburg
3 years, 6 months ago
Status change: Open → In Progress
Paul Hoekman
Johannesburg
3 years, 6 months ago
Okay, this was done. Details:
- The country is based on the boundary of the city. The system checks if the boundary is within country boundaries and sets the country accordingly.
- If not, the system tries to get the country based on the centroid (center coordinates) of the city. This is sometimes needed for cities on the edge of the country where we might have more precise boundaries than those on national level, and a few bits may stick out.
There was a huge pain with some cities where the query to check the country caused a database error. I am not sure what causes it but have manually skipped those (Montreal, Singapore, and Samothraki). I have added comments in case, attached. At some point this should be further debugged. I will make a task for that. In general it all works well tough.
We should also have a feature to quickly add the GPS coordinates for our cities - not the shapefile but just the location - so that the country can be set.
Paul Hoekman
Johannesburg
3 years, 6 months ago
Status change: In Progress → Completed