GrailTwo DataSpec file v1.0

// Note: The following text is generated manually.

<Milepost Log>
{
  Desc: Milepost Log descriptions

  Data Type: STRING

  For Dates: 4/28/1976 thru 12/31/2002
  {
    Reader: VKFR
    Filename: mpdesc.kng
  }
}

<Final Index>
{
  Desc: Final Index drawn from SUMRY

  Data Type: NUMBER

  For Dates: 1/1/2002 thru 12/31/2002
  {
    Reader: DKFR
    Data Width: 4
    Filename: findex.kng
  }
}

<ADT_Pave Deficient>
{
  Desc: ADT/Pavement Deficiency

  Data Type: NUMBER

  For Dates: 1/1/2002 thru 12/31/2002
  {
    Reader: VKFR
    Data Width: 1
    Filename: adt_pave_def.kng
  }
}

<Pavement Age>
{
   Desc: Year of most recent pavement surfacing

   Data Type: NUMBER
   For Dates: all
   {
      Reader: VKFR
      Data Width: 4
      Filename: pvage.kng
      UseZeroAsMissing
   }
}

// Note: The following text is generated by hdq2dataspec.pl.

<Access Control>
{
   Desc: Access Control drawn from the database

   Data Type: ENUM
   Values:
   {
      "Partial Control Type A"
      "Partial Control Type B"
      "Partial Control Type C"
      "Partial Control Type D"
      "Partial Control Type E"
      "Partial Control Type F"
      "Partial Control Type I"
      "Partial Control Type II"
      "Partial Control Type III"
      "Partial Control Type IV"
      "Full Control"
      "Standard Approach"
   }
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: access
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "ACCESS CONTROL", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "1"
         "2"
         "3"
         "4"
         "5"
         "6"
         "7"
         "8"
         "9"
         "10"
         "11"
         "12"
      } // Item count must be what's in 'Values:' above.
      DecimalPointInMP
   }
}

<Crashes>
{
   Desc: Crashes drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: accidents
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "ACCIDENT AVERAGES", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Average Annual Daily Traffic Count>
{
   Desc: Average Annual Daily Traffic Count drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: adt
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "ADT", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Bridge Sufficiency Rating>
{
   Desc: Bridge Sufficiency Rating drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: bridges
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "ASCENDING SUFFICIENCY", "DESCENDING SUFFICIENCY", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Cracking Index>
{
   Desc: Cracking Index drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: cracking
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "ASCENDING CRACKING INDEX", "DESCENDING CRACKING INDEX", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Functional Classification>
{
   Desc: Functional Classification drawn from the database

   Data Type: ENUM
   Values:
   {
      "Rural Princip Art-Interstate"
      "Rural Princip Art-Other"
      "Rural Minor Arterial"
      "Rural Major Collector"
      "Rural Minor Collector"
      "Rural Local"
      "Urban Princip Art-Interstate"
      "Urban Princip Art-Other"
      "Urban Minor Arterial"
      "Urban Collector"
      "Urban Local"
   }
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: funclass
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "FUNCTIONAL CLASS", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "1"
         "2"
         "6"
         "7"
         "8"
         "9"
         "11"
         "14"
         "16"
         "17"
         "19"
      } // Item count must be what's in 'Values:' above.
      DecimalPointInMP
   }
}

<Functional Class Date>
{
   Desc: Functional Class Date drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: funclass
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "FUNCTIONAL CLASS DATE", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}


<Programmed Project Key Number>
{
   Desc: Programmed Project Key Number drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: hwyprogwork
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "KEY NUMBER", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Programmed Project>
{
   Desc: Programmed Project drawn from the database

   Data Type: ENUM
   Values:
   {
      "New Route"
      "Relocation"
      "Bridge Replacement"
      "Bridge Rehabilitation"
      "Added Lanes Separate Roadway"
      "Major Widening"
      "Reconstruction/Realignment"
      "Interchange"
      "Interchange Modification"
      "Grade Separation"
      "Pavement Rehabilitation"
      "Base/Sub-base Work & Resurfacing"
      "Spalled/Manufacturing Joint Replacement"
      "Pavement Grooving & Grinding"
      "Minor Widening"
      "Minor Widening & Resurfacing"
      "Resurfacing"
      "Reseal Joints"
      "Seal Coat"
      "Intersection Improvement"
      "Slow-Moving Vehicle Turnouts"
      "Alignment/Grade Spot Improvement"
      "Miscellaneous Improvement"
      "Short Span Replacement"
   }
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: hwyprogwork
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "WORK CODE", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "1"
         "2"
         "3"
         "4"
         "5"
         "6"
         "7"
         "8"
         "9"
         "10"
         "13"
         "14"
         "15"
         "16"
         "17"
         "18"
         "19"
         "20"
         "21"
         "22"
         "28"
         "29"
         "46"
         "48"
      } // Item count must be what's in 'Values:' above.
      DecimalPointInMP
   }
}

<Programmed Project Year>
{
   Desc: Programmed Project Year drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: hwyprogwork
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "PROJECT YEAR", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<International Roughness Index>
{
   Desc: International Roughness Index Average drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: iri
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "ASCENDING IRI", "DESCENDING IRI", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Lane Width>
{
   Desc: Lane Width drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: lanewidth
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "LANE WIDTH", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Median Type>
{
   Desc: Median Type drawn from the database

   Data Type: ENUM
   Values:
   {
      "Curbed"
      "Positive Barrier"
      "Unprotected"
      "None"
   }
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: mediantype
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "MEDIAN TYPE", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "1"
         "2"
         "3"
         "4"
      } // Item count must be what's in 'Values:' above.
      DecimalPointInMP
   }
}

<Median Width>
{
   Desc: Median Width drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: medianwidth
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "MEDIAN WIDTH", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Hwyneeds Deficiency #01>
{
   Desc: Deficiency as reported by the HPMS-AP model

   Data Type: ENUM
   Values:
   {
      "VOLUME/CAPACITY" 
      "NUMBER OF LANES" 
      "HORIZ ALIGNMENT" 
      "LANE WIDTH     " 
      "SHLD WDTH-RIGHT" 
      "SURFACE TYPE   " 
      "SHOULDER TYPE  " 
      "PSR < RESRF-PSR" 
      "VERT ALIGNMENT " 
      "PSR < RECON-PSR" 
   }
   For Dates: all
   {
      Reader: DBSR
      Server: lripoll2
      Port: 14980
      Database: kangview
      Table: needsdef
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "DEFICIENCY CODE 01", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "6"
         "9"
         "13"
         "18"
         "19"
         "25"
         "26"
         "27"
         "39"
         "40"
      } // Item count must be what's in 'Values:' above.
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Hwyneeds Deficiency #02>
{
   Desc: Deficiency as reported by the HPMS-AP model

   Data Type: ENUM
   Values:
   {
      "VOLUME/CAPACITY" 
      "NUMBER OF LANES" 
      "HORIZ ALIGNMENT" 
      "LANE WIDTH     " 
      "SHLD WDTH-RIGHT" 
      "SURFACE TYPE   " 
      "SHOULDER TYPE  " 
      "PSR < RESRF-PSR" 
      "VERT ALIGNMENT " 
      "PSR < RECON-PSR" 
   }
   For Dates: all
   {
      Reader: DBSR
      Server: lripoll2
      Port: 14980
      Database: kangview
      Table: needsdef
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "DEFICIENCY CODE 02", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "6"
         "9"
         "13"
         "18"
         "19"
         "25"
         "26"
         "27"
         "39"
         "40"
      } // Item count must be what's in 'Values:' above.
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Hwyneeds Deficiency #03>
{
   Desc: Deficiency as reported by the HPMS-AP model

   Data Type: ENUM
   Values:
   {
      "VOLUME/CAPACITY" 
      "NUMBER OF LANES" 
      "HORIZ ALIGNMENT" 
      "LANE WIDTH     " 
      "SHLD WDTH-RIGHT" 
      "SURFACE TYPE   " 
      "SHOULDER TYPE  " 
      "PSR < RESRF-PSR" 
      "VERT ALIGNMENT " 
      "PSR < RECON-PSR" 
   }
   For Dates: all
   {
      Reader: DBSR
      Server: lripoll2
      Port: 14980
      Database: kangview
      Table: needsdef
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "DEFICIENCY CODE 03", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "6"
         "9"
         "13"
         "18"
         "19"
         "25"
         "26"
         "27"
         "39"
         "40"
      } // Item count must be what's in 'Values:' above.
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Hwyneeds Deficiency #04>
{
   Desc: Deficiency as reported by the HPMS-AP model

   Data Type: ENUM
   Values:
   {
      "VOLUME/CAPACITY" 
      "NUMBER OF LANES" 
      "HORIZ ALIGNMENT" 
      "LANE WIDTH     " 
      "SHLD WDTH-RIGHT" 
      "SURFACE TYPE   " 
      "SHOULDER TYPE  " 
      "PSR < RESRF-PSR" 
      "VERT ALIGNMENT " 
      "PSR < RECON-PSR" 
   }
   For Dates: all
   {
      Reader: DBSR
      Server: lripoll2
      Port: 14980
      Database: kangview
      Table: needsdef
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "DEFICIENCY CODE 04", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "6"
         "9"
         "13"
         "18"
         "19"
         "25"
         "26"
         "27"
         "39"
         "40"
      } // Item count must be what's in 'Values:' above.
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<TOI>
{
   Desc: The Improvments as recommended by the HPMS-AP model

   Data Type: ENUM
   Values:
   {
      "RECONST-FREEWAY" 
      "RECONST-ADDLANE" 
      "RECONST WIDER" 
      "PAVEMNT-RECONST" 
      "PAVE-RECNST-ALN" 
      "MAJOR-WIDENING" 
      "MINOR-WIDENING" 
      "RESURF/IMP SHLD" 
      "RESURFACING" 
      "RESURFACE/SHLD/ALN" 
      "RECONSTRUCTION" 
   }
   For Dates: all
   {
      Reader: DBSR
      Server: lripoll2
      Port: 14980
      Database: kangview
      Table: needsimp
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "RECOMMENDED IMPROVEMENT CODE", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "1"
         "2"
         "3"
         "4"
         "5"
         "6"
         "7"
         "8"
         "9"
         "10"
         "11"
      } // Item count must be what's in 'Values:' above.
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<YOI>
{
   Desc: The Year of Improvment recommended by the HPMS-AP model

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: lripoll2
      Port: 14980
      Database: kangview
      Table: needsimp
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "RECOMMENDED IMPROVEMENT YEAR", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Number of Lanes>
{
   Desc: Number of Lanes drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: numlane
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "NUMBER OF LANES", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Parking Width>
{
   Desc: Parking Width drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: parkwidth
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "PARKING WIDTH", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Passing Lane Width>
{
   Desc: Passing Lane Width drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: passlane
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "ASCENDING PASSING LANE WIDTH", "DESCENDING PASSING LANE WIDTH", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Pavement Type>
{
   Desc: Pavement Type drawn from the database

   Data Type: ENUM
   Values:
   {
      "Unpaved (Unimproved)"
      "Unpaved (Graded and Drained)"
      "Unpaved (Soil Gravel or Stone)"
      "Low (Bituminous Surface-Treated)"
      "Intermediate (Mixed Bituminous)"
      "Intermediate (Bituminous Penetration)"
      "High Flexible"
      "High Flexible (Flexible over Rigid)"
      "High Rigid (Plain Jointed)"
      "High Rigid (Reinforced Jointed)"
      "High Rigid (Continuously Reinforced)"
      "High Rigid (Rigid over Rigid-Bonded or Partially Bonded)"
      "High Rigid (Rigid over Rigid-Unbonded)"
      "High Rigid (Rigid over Flexible)"
      "High Flexible (Brick Block or Other Combination)"
   }
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: pavetype
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "ASCENDING PAVEMENT TYPE", "DESCENDING PAVEMENT TYPE", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "20"
         "30"
         "40"
         "51"
         "52"
         "53"
         "61"
         "62"
         "71"
         "72"
         "73"
         "74"
         "75"
         "76"
         "80"
      } // Item count must be what's in 'Values:' above.
      DecimalPointInMP
   }
}

<Peak Parking Type>
{
   Desc: Peak Parking Type drawn from the database

   Data Type: ENUM
   Values:
   {
      "N/A"
      "One Side"
      "Both Sides"
      "None"
   }
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: peakpark
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "PEAK PARKING", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "0"
         "1"
         "2"
         "3"
      } // Item count must be what's in 'Values:' above.
      DecimalPointInMP
   }
}

<Roughness Index Average>
{
   Desc: Roughness Index Average drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: roughness
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "ASCENDING RI", "DESCENDING RI", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Route>
{
   Desc: Route drawn from the database

   Data Type: STRING
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: hpmsap
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "ROUTE", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Right-Of-Way Width>
{
   Desc: Right-Of-Way Width drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: rowwidth
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "RIGHT OF WAY WIDTH", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Rut Depth>
{
   Desc: Rut Depth drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: rutting
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "ASCENDING RUTTING", "DESCENDING RUTTING", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Scenic Byway>
{
   Desc: Scenic Byway drawn from the database

   Data Type: ENUM
   Values:
   {
      "Bear Lake-Caribou Scenic"
      "City of Rocks Back Country"
      "Gold Rush Historic Byway"
      "Hells Canyon Scenic"
      "Lake Coeur d'Alene Scenic"
      "Lewis and Clark Back Country"
      "Mesa Falls Scenic"
      "Northwest Passage Scenic"
      "Panhandle Historic Rivers Passage"
      "Payette River Scenic"
      "Pend Oreille Scenic"
      "Pioneer Historic"
      "Ponderosa Pine Scenic"
      "Salmon River Scenic"
      "Sawtooth Scenic"
      "Teton Scenic"
      "Thousand Springs Scenic"
      "White Pine Scenic"
   }
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: scenicbwy
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "BYWAY", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "1"
         "2"
         "3"
         "4"
         "5"
         "6"
         "7"
         "8"
         "10"
         "11"
         "12"
         "13"
         "14"
         "15"
         "16"
         "17"
         "18"
         "19"
      } // Item count must be what's in 'Values:' above.
      DecimalPointInMP
   }
}

<Shoulder Type>
{
   Desc: Shoulder Type drawn from the database

   Data Type: ENUM
   Values:
   {
      "None"
      "Bituminous"
      "PCC"
      "Tied PCC"
      "Stabilized"
      "Combination"
      "Earth"
      "Curbed"
   }
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: shldrtype
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "SHOULDER TYPE", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "1"
         "2"
         "3"
         "4"
         "5"
         "6"
         "7"
         "8"
      } // Item count must be what's in 'Values:' above.
      DecimalPointInMP
   }
}

<Right Paved Shoulder Width>
{
   Desc: Right Paved Shoulder Width drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: shldrwidth
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "RIGHT PAVED SHOULDER WIDTH", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Right Unpaved Shoulder Width>
{
   Desc: Right Unpaved Shoulder Width drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: shldrwidth
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "RIGHT UNPAVED SHOULDER WIDTH", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Left Paved Shoulder Width>
{
   Desc: Left Paved Shoulder Width drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: shldrwidth
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "LEFT PAVED SHOULDER WIDTH", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Left Unpaved Shoulder Width>
{
   Desc: Left Unpaved Shoulder Width drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: shldrwidth
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "LEFT UNPAVED SHOULDER WIDTH", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Skid Number>
{
   Desc: Skid Number drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: skidave
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "ASCENDING SKID", "DESCENDING SKID", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Speed Limit>
{
   Desc: Speed Limit drawn from the database

   Data Type: NUMBER
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: speed
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "SPEED LIMIT", "EFFECTIVE DATE", "EXPIRATION DATE"
      UseZeroAsMissing
      DecimalPointInMP
   }
}

<Subsurface Drainage>
{
   Desc: Subsurface Drainage drawn from the database

   Data Type: ENUM
   Values:
   {
      "N/A"
      "Dense w/0 Subdrainage"
      "Dense w/ Subdrainage"
      "Drainable w/o Subdrainage"
      "Drainable w/ Subdrainage"
      "N/A Due To Raised Roadway"
   }
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: subdrain
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "SUBDRAINAGE", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "1"
         "2"
         "3"
         "4"
         "5"
         "6"
      } // Item count must be what's in 'Values:' above.
      DecimalPointInMP
   }
}

<Terrain Type>
{
   Desc: Terrain Type drawn from the database

   Data Type: ENUM
   Values:
   {
      "Flat"
      "Rolling"
      "Mountainous"
   }
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: terrtype
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "TYPE OF TERRAIN", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "1"
         "2"
         "3"
      } // Item count must be what's in 'Values:' above.
      DecimalPointInMP
   }
}

<Widening Feasibility>
{
   Desc: Widening Feasibility drawn from the database

   Data Type: ENUM
   Values:
   {
      "None"
      "Partial Lane"
      "1 Lane"
      "2 Lanes"
      "3+ Lanes"
   }
   For Dates: all
   {
      Reader: DBSR
      Server: www3.state.id.us
      Port: 14980
      Database: kangview
      Table: widenfease
      Fields: "SEGMENT CODE", "BEGINNING MILEPOST", "ENDING MILEPOST", "WIDENING FEASIBILITY", "EFFECTIVE DATE", "EXPIRATION DATE"
      String Values:
      {
         "1"
         "2"
         "3"
         "4"
         "5"
      } // Item count must be what's in 'Values:' above.
      DecimalPointInMP
   }
}