vendredi 27 février 2015

How to organize database with objects having GPS coordinates (in radians)


I have a huge database of different objects organized in tables. For instance photos in one table and metadata of each photo in other. Most of them have their GPS coordinates in radians stored as a metadata.. this is a requirement. My question is whether it is better to add postgis extension to database and duplicate the coordinates to geotables, or leave it as it is now, without postgis, write some GPS->GoeJSON convertor in PHP and serve GeoJSON objects to OL3. What is the best practice? At this stage I will need to be able to display data over some basemap and display information about them on click, highlight some LineStrings (roads) etc.


Technologies I use: OL3, PHP, PostgreSQL, Mapserver Im newbie to postgis, mapservers and OL3.


THanks for any help!





Aucun commentaire:

Enregistrer un commentaire