How to store geodata of type coordinates - value?

Question

PHP

There is the following type of data
X coordinate, Y coordinate, value, time.
Can be converted to JSON.

What is the best way to store this type of data so that later you can easily build graphs based on this data.
Time - implies that at one geographical point there can be many values ​​\u200b\u200bin different time periods.

Answer 1

if you need spatial queries, then you can store in PostGIS, mongo, mysql, sqlite, etc.
if spatial queries are not needed, then you can store csv, geojson, BD where convenient

Answer 2

I advise you to pay attention to MongoDB MongoDB's 2d geospatial indexes