opencaching / opencaching-pl

The source code of Opencaching.PL (and some other domains)
https://opencaching.pl/
GNU General Public License v3.0
22 stars 33 forks source link

Make use of US, CA and MX Nature Protected Areas geographical data (requested by OCNA) #863

Open andrixnet opened 7 years ago

andrixnet commented 7 years ago

OCNA serves North America, that is USA, Canada and Mexico.

Geographical data on US Nature Protected Areas (not sure if this is the actual term used in USA) is apparently stored in table us_parks while npa_areas is empty.

IMHO there are two ways of handling it:

  1. import OCNA specific code into OCPL-current and activate it only for OCNA node
  2. process geographical data and convert it into nuts_codes and nuts_layer compatible data, then use existing code to handle it.
  3. a combination of the above, given that US data may have more usable database fields and offer more features then just nuts data.

I have attached what I believe is the relevant database contents for this geographical data.

us_parks.sql.zip

kojoty commented 5 years ago

I think we can think about this but this not a blocker for ocna migration.