Eyesis Panorama Database

MySQL DB Structure

Nodes Table:

ID
Name
Description
Longitude
Latitude
Timestamp
Altitude
Heading
Tilt
Roll
Panorama URL
Visibility3d -  list of ranges [from,to] - which nodes are visible from the current one. from, to are both relative to the current node, so merging several segments should not break visibility (not so easy in the map that is not linear path, but we'll think of something  - adding new nodes (importing KML) should not change the relative sequence of indices (kml "name" tag).

Routes Table

ID
Name
Description
Nodes List

PHP Methods

Array GetNodeData (ID)

Returns all database fields of a specific Node ID as array

Array GetRouteData (ID)

Returns all database fields of a specific Route ID as array

AddNode (Array Data)

Save a new node to the DB supplying all database field

AddRoute (Array Data)

Save a new node to the DB supplying all database field

void AddNodeToRoute (int NodeID, int RouteID)

Adds one Node to a Route. Both have to exist already.

Array GetNodesAt (Lat, Long, MaxDistance, Limit)

Find an array of nodes that are not further away from the supplied coordinates (Lat, Long) than the MaxDistance. To prevent huge number of results being return I would add a limit parameter here. If the results reach the limit count it will just stop searching and return the results found so far.

int GetNextNodeinRoute (int NodeID)

Routes are a sequence of nodes, Next means recorded later = higher timestamp

int GetPreviousNodeinRoute (int NodeID)

Routes are a sequence of nodes, Previous means recorded earlier = lower timestamp

void ImportKML (String KMLfile, int RouteID)

Works just like AddNode but can import a high number of nodes with a single function - read from a KML file, if you supply a RouteID all new Nodes will automatically be added to an existing route.

Notes

function distance ($lat1,$long1,$lat2,$long2) {
 $earthRadius=6378100; //meters
 $dlat= $lat2- $lat1;
 $dlong=$long2-$long1;
 $lat=($lat1+$lat2)/2;
 $dlong*= cos(deg2rad($lat));
 return pi()*$earthRadius/180* sqrt($dlat*$dlat+$dlong*$dlong);
}