Difference between revisions of "Eyesis Panorama Database"

From ElphelWiki
Jump to: navigation, search
(Created page with "==MySQL DB Structure== ==PHP Methods==")
 
Line 1: Line 1:
 
==MySQL DB Structure==
 
==MySQL DB Structure==
  
 +
ID
 +
Longitude
 +
Latitude
 +
Timestamp
 +
Altitude
 +
Heading
 +
Tilt
 +
Roll
 +
Panorama URL
 +
name
 +
description
 +
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).
  
 
==PHP Methods==
 
==PHP Methods==

Revision as of 10:43, 7 July 2011

MySQL DB Structure

ID
Longitude
Latitude
Timestamp
Altitude
Heading
Tilt
Roll
Panorama URL
name
description
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).

PHP Methods