worldbank / HNP

World Bank's Geospatial Team (GOST) support to the Global Practice for Health, Nutrition, and Population.
MIT License
6 stars 3 forks source link

Geohash for fishnet locations #1

Open KPGeo opened 4 years ago

KPGeo commented 4 years ago

Need to select a geohash solution to apply to the fishnets to simplify and speed the mobility data processing and to enable a uniqueID for each cell in a common table.

geohacker commented 4 years ago

Per chat with @KPGeo, the use cases for geohash in this context are:

I think it's better if use a quadkey approach. Each of the fishnet tile can get a unique quadkey that it falls in and this makes it easier to fetch within a bbox as well as aggregate higher levels. There also several client-side tools like tilebelt so we don't have to implement a custom geohash algorithm.

For implementation, we can either directly store the quadkey as a column in the table during import time or write a postgis function that fetches the quadkey id.

cc @guidorice @bitner @pieschker

guidorice commented 4 years ago

There also several client-side tools like tilebelt so we don't have to implement a custom geohash algorithm.

Also https://github.com/mapbox/tile-cover