GIScience / openpoiservice

:round_pushpin: Openpoiservice is a flask application which hosts a highly customizable points of interest database derived from OpenStreetMap data.
https://openrouteservice.org
Apache License 2.0
172 stars 22 forks source link

Generate response in psql #24

Open TimMcCauley opened 6 years ago

TimMcCauley commented 6 years ago

GeoJSON response is currently built in Python which has an impact on the response time, this should ultimately be added to the work handled by postgres.

TimMcCauley commented 6 years ago

http://www.postgresonline.com/journal/archives/267-Creating-GeoJSON-Feature-Collections-with-JSON-and-PostGIS-functions.html

TimMcCauley commented 5 years ago

@zephylac this is the corresponding issue related to #68 - we can basically handle everything in postgres with customized functions and keep the logic away from python.