Spreadsheet

Follow this link to the spreadsheet that is used to draw the map of the Alapaha River Water Trail.

This spreadsheet has three main purposes:

  1. WWALS uses it for draft maps of the Alapaha River Water Trail.
  2. Data for use by local governments, county, city, and other interested parties such as chambers of commerce, tourism councils, etc.
  3. For GA-EPD to use to produce an interactive google map.
  4. For drawing detail maps by SRWMD and others.
  5. For WWALS to keep track of ART data for its own uses, such as brochures, guides, kiosks, cards, etc.

WWALS-ART Committee members are finding and filling in data for each of these categories.

Current categories include: Acess/Landing, Outfitter, Camping/Lodging, Bridge, Waterfall, Spring, Rapid/Shoal, Hiking Trail (Trail Head), Tributary, River Gauge, Water Discharge, Obstacle, Point of Interest. GRN River Trail coordinator Gwyneth Moody says she will check with GA-EPD about adding a category for Lakes. WWALS has already added in the WWALS working spreadsheet categories for:

  • Lake
  • Sinkhole
  • Landing (for a constructed boat ramp or canoe launch)
  • Access (for unimproved access)
  • Railbridge (separate from Bridge, which we use for road bridge)
  • ARWT Sponsor
  • Logo contest sponsor

These additional categories get translated back to GRN’s categories before updating the GRN spreadsheet.

For more detail, see the Interactive Water Trail Map Data Submission Protocol, which actually asks for a Sections Spreadsheet and a Sites Spreadsheet.

For each item the sites spreadsheet needs:

  • CATEGORY
  • NAME
  • LATITUDE
  • LONGITUDE
  • ADDRESS (physical)
  • WEBSITE (URL)/ INFORMATION SOURCE/ REFERENCE
  • DESCRIPTION
  • PHOTO (Make sure to save photo as jpg and upload to dropbox folder)
  • PHOTO SOURCE
  • PHONE NUMBER
  • OWNERSHIP (Public or Private)
  • WATER BODY
  • CANOE/KAYAK RENTAL (Yes or No)
  • ACCESS (to river)
  • CAMPING (No or RV Campsites, and/or Primitive Campsites)
  • FOOD (No or Snack Machine, Restaurant, Convenient Store etc.)
  • WATER (Yes or No)
  • RESTROOMS (No or Portalet, Flush Toilet, or Vault Toilet)
  • HISTORIC ATTRACTION
  • TYPE OF BOAT RAMP/ LAUNCH/ STAIRS
    • Ramp: Dirt, Gravel or Concrete;
    • Launch: Native/Soil Rock, Floating, Pipe, Pile, or Cantilever [Boat Lift];
    • Stairs: Dirt, Metal, Timber, Stone, or Concrete
  • DOCK (Yes or No),
  • PARKING/ DAY USE FEE (No or Parking Fee $X or Day Use Fee $X),
  • SHELTER (Yes or No),
  • PICNIC AREA (Yes or No),
  • FISH BAIT (Yes or No),
  • GASOLINE (Yes or No),
  • Handicapped Accessible,
  • OTHER,

Plus some additional fields added by WWALS:

  • MILE
    upstream from the confluence
  • LAYER determines which google map layer:
    • Brochure
    • * means a layer with the same name as the Category for the row
    • any other name can also be use for a layer
    • a row with no name goes into a layer called Other
  • FOOTNOTE,
  • SMALL PHOTO,
  • Lowest boatable,
  • Highest safe,
  • TODO,
  • State,
  • County,
  • Parcel,
  • Owner,
  • Parcel link,
  • Comprehensive Plan,
  • Plan quotes

The example Ocmulgee River Water Trail spreadsheet GRN sent only has 141 items, so it wasn’t too hard to construct a spreadsheet for the Alapaha River Water Trail, currently at 75 items (2014-03-05) 126 items (2014-04-24).

A public copy of the current working draft spreadsheet for the Alapaha River Water Trail, in its native Google Sheets format and below in web-friendly format.

[gdoc key=”https://docs.google.com/spreadsheets/d/1-cTKmn_0YK6lW9vl1rBdhSD-og2n–S52l3oZmdjv2c/edit#gid=1460442333″ style=”width:600px”]

We are also making the spreadsheet information available in the online location requested by GRN. Since we keep quite a bit more information in our spreadsheet, such as mile markers, boatable low and safe high water levels, and tax assessor parcel numbers, we remove and remap a number of fields with a program before inserting into the GRN spreadsheet. This GRN version is not as current as the WWALS ARWT spreadsheet.

Leave a Reply

Your email address will not be published. Required fields are marked *