Talk:New York State Route 28/sufficiency database

The columns labelled added to db are using the article milepost table to added cities and towns to the NY sufficiency database. The county names are added from the codes used by the NY Department of Highways.

Brief description of above codes

 * GISRTE refers to the first are the route number then the region then county then county order control segment.
 * RTE Route number
 * LTR letter if necessary
 * REG region
 * CO County
 * COC begins at 1 for the county in which the route begins.
 * BMP beginning mile post
 * EMP end mile post
 * LEN length of segment
 * STAHIG State highway number the contract number under which the section was built or original highway number.
 * CORD mean county road
 * CTYST City street
 * VILST Village Street
 * PKWAY parkway
 * BRIDGE
 * RAMP


 * RESIDE may or may not correspond to county - responsible for maintenance.
 * RD: 1 would be undivided and 2 would be divided
 * NUMOFL Number of lanes going in both directions are changing throughout the length indicated by number given 9 or more represented by 9
 * PAVWID Pavement width in feet in both directions.
 * SHOWID Shoulder width on right side in direction of travel 0 means no shoulder only curb
 * SHOTYP Shoulder type stabilized means ashpahlt or concrete add to limit growth, and unstabilized is natural growth
 * 7 unstablized no mowing
 * 6 unstabilized mowing
 * 5 Stabilized no mowing
 * 4 Stabilized moving
 * 3 Gutter no mowing
 * 2 gutter mowing
 * 1 curbed no mowing nothing growing.

Flush paved area less than 4 feet in width is not considered a median
 * SURSCO Surface score condition current year (2006) yearly surface rating conditions 1 poor and 9 or 10 listed as K is excellent; 7-8 good some distress as outlined is beginning; 6 visible distress; 1-5 sections are targeted, flagged for work; U under construction.
 * MEDWID changes as highway has medians then none.
 * 1 means 0 to 4 feet wide median
 * 2 5-8 feet wide
 * 3 9-12 feet
 * 4 13-16 feet
 * 5 17-20 feet
 * 6 21-24 feet
 * 7 25-28 foot wide median
 * 8 29-32 feet
 * 9 33-36 feet
 * 0 37+ feet wide median


 * MEDTYP
 * blank no median
 * 1 flush median
 * 2 barrier
 * 3 depressed median unprotected
 * 4 none
 * 5 continues center turning lane


 * SURTYP surface type
 * 9 unreinforced concrete
 * 8 brick or block
 * 7 portland cement concrete over 8 inches
 * 6 portland cement concrete less than 8 inches
 * 5 Water bound macadem
 * 4 ashpalt concrete / plant mix over 8 inches thickness
 * 3 Portland cement less than 8"
 * 2 Bituminous macadem
 * 1 unpaved natural or gravel
 * 0 same as base


 * BASTYP base
 * 8 brick or block
 * 7 portland concrete cement more than 8 inches thickness
 * 6 portland concrete cement less than 8 inches thickness
 * 5 gravel stone or slag over 6 inches with bituminous binding
 * 4 gravel stone or slag less than 6 inches with bituminous binding
 * 3 cement stabilized base
 * 2 gravel or stone
 * 1 natural stabilized soil
 * 0 sub base and base are identical


 * SUBBAS sub base
 * 0 natural soil not graded not drained
 * 1 natural soil unimproved
 * 2 natural soil graded and drained
 * 3 selected soils 12 " or less
 * 4 selected soils over 12"
 * 5 less than 12" of gravel/stone
 * 6 gravel or stone over 12
 * 7 bridges or culverts other types of things


 * TERTYP terrain type
 * 1 flat profile 0-3%
 * 2 rolling 4-6%
 * 3 Hilly highway profile 7-9 %


 * ARETYP area type
 * 1 rural
 * 2 unincorporated community
 * 3 village less than 5,000 folks
 * 4 suburban
 * 5 city
 * 6 over 5,000 population village


 * CULTUR culture type
 * 6 agriculture open land
 * 5 business
 * 4 industry
 * 3 resort
 * 2 residential
 * 1 controlled access


 * PERPAR % parking
 * 0 No parking
 * K
 * 1 50% parking
 * 2 100% parking


 * PASSIG passing sight distance in feet recorded
 * TRK % truck
 * TRAFYR traffic count year

rural
 * DHV design hour volume or vehicle traffic volume
 * AADT Average annual daily traffic volume 2 way
 * FUNCLA functional classes
 * 1 principal arterial interstate
 * 2 principal arterial other
 * 6 minor arterial
 * 7 major collector
 * 8 minor collector
 * 9 local

Urban
 * 11 principal arterial interstate
 * 12 principal arterial expressway
 * 14 principal arterial other
 * 16 minor arterial
 * 17 collector
 * 19 local


 * JURISDICTION
 * 1 city
 * 2 village
 * 3 town
 * 4 county
 * 5 NYS DOT
 * 6 NYS DOT Thruway
 * 7 NYS OGS
 * 8 NYS DEC
 * 9 NYS parks, rec, historic
 * 10 NYS other
 * 11 NYW thruway authority
 * 12 other authorities
 * 13 state indian reservation
 * 14 federal indian reservation BIA
 * 15 federal indian reservation local
 * 16 national park service
 * 17 US Forest Service
 * 18 US fish and wildlife
 * 19 US dept defense


 * HCC HIghway control code now called jurisdiction HCC no longer used
 * 0 State Highway
 * 1 parkway state DOT
 * 2 parkway state non DOT
 * 3 parkway non state
 * 4 authority and commission toll
 * 5 authority and commission free
 * 6 city or village street gap
 * 7 Town or County road gap
 * 8 indian reservation or institution roads
 * 9 All duplicate mileage
 * X service road state maintained
 * Y serve road not state maintained


 * YS year scored
 * YLW year las work
 * ACCON access control
 * N no control of access
 * P partial control of access
 * F full control of access


 * ARC Adjusted rating capacity
 * VC volume capacity ratio
 * NATHIG National Highway System NHS principal arterial
 * 9 NYS parks, recreation, preserve
 * 4 Intermodal connector
 * 3 STRAHNET connector
 * 2 STRAHNET
 * 1 general NHS
 * 0 general NHS


 * S81...S96 and S97....S05 yearly surface rating conditions 1 poor and 9 or 10 listed as K is excellent; 7-8 good some distress as outlined is beginning; 6 visible distress; 1-5 sections are targeted, flagged for work; U under construction.
 * REFMAR Reference Marker
 * TANTRU Tandem truck designation
 * 1 qualifying highway
 * 2 access limited restrictions
 * 3 access highway


 * BLK1
 * TRKYR
 * WORKTYP Work type maintenance
 * 1 1-1/2 inches of hot ashpalt overlay
 * 2 Two course overlay 2-3 inches
 * 3 Three course hot mix asphalt overlay 4-6 inches
 * 4 mill and fill - no change in pavement thickness
 * 5 Mill and fill additional overlay thickness
 * 6 reconstruction total replacement
 * 7 other such as deck or small section repair
 * 8 Crack and seal pavement rehabilitation
 * 9 pavement reconstruction by rubbilizing
 * 10 pavement construction and reconstruction
 * 11 crack sealing
 * 12 permanent pavement repairs
 * 13 concrete pavement restoration
 * 14 surface treatment
 * 15 slurry seal
 * 16 microsurfacing
 * 17 paver placed surface treatment
 * 18 white topping
 * 19 other treatments


 * OLAP route overlaps
 * + where in fact the route overlaps


 * BLK2


 * PAVTYP pavement type
 * A flexible Asphalt
 * O overlay is Asphalt put on a highway once concrete
 * P portland cement concrete

SriMesh | talk  02:57, 27 July 2008 (UTC)