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

Add PostGIS extension to Postgres to add geospatial indexes #513

Open
eapen opened this issue Aug 18, 2018 · 1 comment
Open

Add PostGIS extension to Postgres to add geospatial indexes #513

eapen opened this issue Aug 18, 2018 · 1 comment
Labels
enhancement New feature or request help wanted Extra attention is needed medium watch

Comments

@eapen
Copy link

eapen commented Aug 18, 2018

Subject of the issue

Add the PostGIS extension to Postgres which will allow you to create geospatial indexes which will speed up lat/lng + radius queries

Your environment

https://devcenter.heroku.com/articles/heroku-postgres-extensions-postgis-full-text-search#postgis

Steps to reproduce

This will likely have to be done via CLI and can be verified on a spare instance first

Expected behaviour

Will speed up queries and enable better location-based searches
I believe the current plan is to use text-based indexes which will be much less efficient

@tomahawk-pilot tomahawk-pilot added enhancement New feature or request help wanted Extra attention is needed medium watch labels Aug 18, 2018
@shasts
Copy link

shasts commented Aug 18, 2018

@eapen
Just in case if you haven't noticed, the coordinates are captured as text and I went through the data set, so it contains google maps URLs and even handwritten text.

The first step would be to clean up that data and run migration to convert to (lat,lon) coordinates.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request help wanted Extra attention is needed medium watch
Projects
None yet
Development

No branches or pull requests

3 participants