[openstreetmap/openstreetmap-website] Performance: Optimizing database for map structure query, perhaps using PostGIS? (#2048)
notifications at github.com
Tue Nov 6 22:36:08 UTC 2018
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?
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:
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the rails-dev