[openstreetmap/openstreetmap-website] Performance: Optimizing database for map structure query, perhaps using PostGIS? (#2048)

[Jason Sun]

Are there any plans to use the support of PostGIS in PostgreSQL? So that we may optimize querying times for answering questions like 
● How many features lie within 100m?
● What is the total length of a given road?
● What is the total area of water in my city?
https://wiki.postgresql.org/images/c/c5/PostGISPGUK.pdf

It may be a major effort but would pay off at larger scales. We're storing map data in our own custom format, as defined in https://github.com/openstreetmap/openstreetmap-website/blob/master/db/structure.sql. 


-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/2048
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20181106/b56ed4a2/attachment.html>