Adds database tables and procedures to build a mapping between sites and climate zones (stored as native mysql geometry type) since it takes too long to query on demand. Triggers should keep everything up to date with a new zone or site. Right now, there are no permission checks on zones and no way to add new ones through the API.
For the api adds the /sites/in/<zone>, /climatezones, /climatezones/<zone>, and /climatezones/search endpoints
wholmgren
commented
4 years ago
closes #253
Adds database tables and procedures to build a mapping between sites and climate zones (stored as native mysql geometry type) since it takes too long to query on demand. Triggers should keep everything up to date with a new zone or site. Right now, there are no permission checks on zones and no way to add new ones through the API.
For the api adds the
/sites/in/<zone>, /climatezones,/climatezones/<zone>, and /climatezones/search endpoints