header html

is there a query?

  run a query that selects 5 random cams

  foreach random cam

    can i display?

      do it

      (query the "camsType" db and use that info to display, probably a seperate cam->display_image, cam->display_roundshot, cam->display_grep)

      set display = 1

  did i not display something?

    show an error

did i not display something?

  show links to queries
  
footer html

#
# data
#

the main cams database

1. id
2. type (image, roundshot, grep, etc)
3. url? (every cam has one, type determines what is done with it?)
4. loc_id

other databases

## lets say the camera view doesn't quite match the location...
## i can add a view here

camsView

1. id
2. view

examples
  sub "Mount Whitney" in for "Lone Pine" in title1, put "Lone Pine: " in title2
  sub "El Capitan and Half Dome" in for "Turtleback Dome" in title1, put "Turtleback Dome: " in title2
  sub "Matterhorn" in for "Zermatt" in title1, put "Zermatt: " in title2
  sub "Denali and the Alaska Range" in for "Talkeetna" in title1, put "Talkeetna: " in title2
  sub "Atlantic City" in for "Absecon" in title1, put "Absecon: " in title2

camsTitle

1. id
2. title1 (override the big title, normally locale1 and state/country)
3. title2 (override the first small title, normally a description/altitude, or if override, the locale1?)

camsKeyword

1. id
2. keyword (best, volcano, beach, etc)

camsNps

1. id
2. park (Mount Rainier National Park, Yellowstone National Park, etc)

camsResort

1. id
2. resort (Snowbird, Mount Bachelor, etc)
3. title2?
4. altitude?

camsTypeImage

1. id
2. url
3. positioning data for (wide) images?

camsTypeRoundshot

1. id
2. url
3. positioning data?

camsTypeGrep

1. id
2. url
3. grep
4. skip?

locations

1. loc_id
2. locale
3. state
4. country
5. lat
6. lng
7. tz
8. altitude
9. note