Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

indexing nodes: quadtile vs lat/long #47

Open
anandthakker opened this issue Apr 14, 2015 · 1 comment
Open

indexing nodes: quadtile vs lat/long #47

anandthakker opened this issue Apr 14, 2015 · 1 comment
Labels

Comments

@anandthakker
Copy link
Contributor

We should investigate whether we're benefitting from the current approach to indexing Nodes with a quadtile index. The alternative would be to index both the latitude and longitude columns in the nodes table so that we could do WHERE BETWEEN queries on lat and long.

@kamicut
Copy link
Contributor

kamicut commented Apr 14, 2015

This is where the quadtile query is used in openstreetmap: https://github.com/openstreetmap/openstreetmap-website/blob/master/lib/osm.rb#L544-L551

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants