How to implement a database with geopoints?

P

phmphx2014-08-02 01:43:19

PHP

phmphx, 2014-08-02 01:43:19

There was an idea to collect a number of points (for example, museums) into one database on the site, and store the coordinates of the location of these museums on the map there.
How to implement? What structure should sql have and which cards are better to use?
Please advise.
Thank you)

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

Y

yttrium, 2014-08-02
@yttrium

There are specialized DBs that support spatial data storage - PostGIS (PostgreSQL extension)
As far as I know mysql, sqlite also support spatial data types
In mongodb it is possible to create 2D indexes
I'm behind OSM