Database For Storing Polyline Coordinates

bogeyman2007 · 07-06-2015, 07:20 PM

Hi,

I need to store some polylines coordinates data into a table. What is the best database that suitable for doing that? And what is the data type? I also need that coordinates can be queried using some radius from one position (latitude, longitude).

For example from coordinates -6.118687601752689 and 106.90720740688471, what are the closest polylines in 500 meter radius?

Thanks before.

dugan · 07-06-2015, 08:01 PM

Hard for me to say, personally.

If traversing the lines is something you'd like to do, then look into neo4j.

sundialsvcs · 07-06-2015, 08:37 PM

Also, if the coordinates are spatial data ("latitude and longitude"), then you might find that various databases have specific support for this use-case.

Start by looking, for example, at pages like this one: http://dev.mysql.com/doc/refman/5.6/...xtensions.html

I would particularly call your attention to the opening two paragraphs of that page, which for your convenience I have included below:

Quote:

The Open Geospatial Consortium (OGC) is is an international consortium of more than 250 companies, agencies, and universities participating in the development of publicly available conceptual solutions that can be useful with all kinds of applications that manage spatial data.

The Open Geospatial Consortium publishes the OpenGIS® Implementation Standard for Geographic information - Simple feature access - Part 2: SQL option, a document that proposes several conceptual ways for extending an SQL RDBMS to support spatial data. This specification is available from the OGC Web site at http://www.opengeospatial.org/standards/sfs.

Any application which references or uses geo-spatial data should, I think, be "put to the drawing board" only after a very careful review of such "prior art." Even before you commit to the idea of thinking of whatever-it-is as being (say ...) "a polyline" ... which is a purely 2D-graphics concept ... I would canvass, with a very open mind, everything that I might encounter at a site such as "opengeospatial.org."