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.

Sign up for GitHub

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

Jump to bottom

Given a service request with lat/lon data, show nearby service requests on its permalink page #75

Open
2 of 4 tasks
bensheldon opened this issue Aug 16, 2018 · 0 comments
Open
2 of 4 tasks

Given a service request with lat/lon data, show nearby service requests on its permalink page #75

bensheldon opened this issue Aug 16, 2018 · 0 comments
Assignees
@hampelm

Comments

@bensheldon
Copy link
Owner

bensheldon commented Aug 16, 2018 •
edited
Loading

  • Extract lat/lon attributes from ServiceRequest#raw_data (is an optional field in Open311)
  • Add column(s) to the service_requests table that stores and indexes ___location data
  • On ServiceRequest permalink page (controllers/cities/service_requests#show), if the current service request has ___location data, show a list of 5 nearby service requests. Can be the simplest list of links possible.
    • Nice to have: show the distance (in feet/miles/etc) between the current service request and the nearby ones.
hampelm added a commit to hampelm/open311status that referenced this issue Aug 19, 2018
@hampelm
Store lat-lngs from service requests for bensheldon#75
f54f2ab
@hampelm hampelm mentioned this issue Aug 19, 2018
Merged
bensheldon pushed a commit that referenced this issue Aug 20, 2018
@hampelm @bensheldon
Store points from service requests (#79)
345723e 
* Ignore byebug logs

* Store lat-lngs from service requests for #75

* Move instructions for adding real data

* Rely on the raw_data setter to set geometry

* Match raw request

* Update README.md

* Use CircleCI postgis image

* Ensure postgis extension is enabled in migration

* Replace postgres with postgis in production db connection string
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hampelm hampelm

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@bensheldon @hampelm