Greenstand / Greenstand/treetracker-query-api

Use `denormalized.trees` table to implement the routers under `/species`

Open
#338 3 comments 0 reactions 0 assignees View on GitHub
good first issue Node.js postgresql
Dominant language
TypeScript
Stars
18
Forks
65
PR merge metrics
No merged PRs in 30d

Description

We are using `public.trees` to query data for `/species` but it is slow, we now created a new table to denormalize the data to get higher performance, so please use the new table to implement this API again.

Some notes:
* Prerequisite: https://github.com/Greenstand/treetracker-denormalization/issues/1
* Please checkout the denormalized branch to work on and to create pull request.
* More details about denormalization is [here](https://docs.greenstand.org/web-map/denormalized-map-data)

---

Some hints:

- Please read our readme for more information/guide/tutorial.
- Here is [an engineering book](https://greenstand.gitbook.io/engineering/) in Greenstand.
- To know more about our organization, visit our [website](https://greenstand.org).
- If you want to join the slack community (some resources need the community member's permission), please leave your email address.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.