{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Form","Narrative Sheet","Funding","BridgeTable","ref","ImportToDB"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Form","index":0,"n_rows":75,"n_cols":9,"rows_kept":75,"cut":false,"hidden":false,"merged":[[0,0,0,8],[48,0,48,8],[3,1,3,2],[3,4,3,7],[31,0,46,8],[1,2,1,4],[1,0,1,1],[73,1,73,8],[74,1,74,8],[50,0,65,8],[5,1,5,5],[7,1,7,5],[9,1,9,3],[30,0,30,8],[13,4,13,6],[11,1,11,3],[11,5,11,7],[49,0,49,8],[68,0,68,8],[69,0,69,8],[70,1,70,8],[71,1,71,8],[72,1,72,8]]}
["UCTC STP-OFF SYSTEM BRIDGE BLOCK PROGRAM DATA FORM"]
["Project Sponsor"]
[]
["First Name",null,null,"Last Name"]
[]
["Address 1"]
[]
["Address 2"]
[]
["City",null,null,null,"State:  NY",null,"Zip Code"]
[]
["email",null,null,null,"phone"]
[]
["County",{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,3,FALSE)","v":"Ulster"},null,null,"Project Priority"]
[]
["BIN","2224560",null,"Feature Carried",{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,6,FALSE)","v":"SILVER HOLLOW RD"}]
["Related PIN",null,null,"Feature Crossed",{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,7,FALSE)","v":"STONY CLOVE CREEK"}]
[null,null,null,"Owner",{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,4,FALSE)","v":"Town"},null,"Region",{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,2,FALSE)","v":8}]
["STP Off",{"$f":"IF(VLOOKUP(Form!$E$19,ref!A67:C80,3,FALSE) = \"On\", \"Ineligible\", \"Eligible\")","v":"Eligible"},null,"Functional Class",{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$V$218,22,FALSE)","v":"09"}]
[]
["Facility Importance",null,null,"Cost & Schedule",null,null,"Risk & Restrictions"]
["AADT",{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,8,FALSE)","v":180},null,"Const. Cost",null,null,"Posting",null,{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,16,FALSE)","v":0}]
["% Trucks",{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,9,FALSE)","v":6.98},null,"Total Cost",null,null,"Hyd. Vuln. Rating",null,{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,17,FALSE)","v":"5"}]
["Detour (mi)",{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,10,FALSE)","v":1},null,"SFY Letting",null,null,"Fracture Critical",null,{"$f":"IF(F25=\"N\",\"No\",\"Yes\")","v":"No"}]
[null,null,null,null,null,{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,18,FALSE)","v":"N"},"Design Type",null,{"$f":"VLOOKUP($F$26,ref!$A$1:$B$45,2,FALSE)","v":"Box, Adjacent"}]
["Structure Details",null,null,"Capital Need",null,{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,19,FALSE)","v":"03"},"Material Type",null,{"$f":"VLOOKUP($F$27,ref!A47:B63,2,FALSE)","v":"Prestr Conc Pre-Tensioned"}]
["Year Built",{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,11,FALSE)","v":1985},null,"Condition Rating",{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,13,FALSE)","v":5.42},{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,20,FALSE)","v":"E"}]
["Deck Area",{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,12,FALSE)","v":2140},null,"Structural Deficiency",{"$f":"IF(F28=\"N\",\"No\",\"Yes\")","v":"No"},{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,14,FALSE)","v":"N"}]
[null,null,null,"Model Recmdn.",{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,15,FALSE)","v":"cyclical"},null,"LBPI",{"$f":"VLOOKUP($B$16,BridgeTable!$A$1:$U$218,21,FALSE)","v":8.3000000000000004E-2}]
[]
["Project Scope Description"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Project Commentary"]
["Sponsor to describe unique elements and important factors that cannot readily be captured soley by the available data."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Affrimations"]
["Place an “X” in the boxes to indicate that you have read and understand the following:"]
[null,"The sponsor has provided a signed cover letter from the chief elected official or equivalent along with this Project Justification Package."]
[null,"The sponsoring municipality or agency agrees to provide the minimum required local match (20% of the total project cost). NOTE: The 20% local match may be reduced depending on the project type, the federal fund source and the availability of matching state funds."]
[null,"The sponsoring municipality or agency acknowledges that funds for locally administered federal aid projects will be provided on a reimbursement basis. The sponsor will be responsible for 100% of the upfront costs and will be reimbursed following completion of the project."]
[null,"The sponsoring municipality or agency acknowledges that the cost estimate provided by the sponsor may be adjusted by UCTC staff based on federal unit costs or other information related to federal aid projects."]
[null,"The sponsoring municipality or agency acknowledges that if preliminary engineering funds are not obligated in the federal fiscal year in which they are programmed, the entire project will be removed from the TIP and federal funds will be reprogrammed for other purposes. The project would then have no status. The UCTC Technical Committee can take action to approve exceptions to this rule at its discretion."]

{"sheet":"Narrative Sheet","index":1,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[[22,0,22,8],[0,0,3,8],[5,0,5,8],[10,0,13,8],[15,0,18,8],[20,0,20,8],[28,0,28,8],[23,0,26,8],[29,0,32,8],[34,0,34,8],[35,0,38,8]]}
["Beyond Preservation Project Review \nNARRATIVE SHEET\n"]
[]
[]
[]
[]
["Section A: Project Description"]
[]
["BIN",{"$f":"Form!B16","v":"2224560"}]
[]
["Project Scope"]
[]
[]
[]
[]
["Project Objective"]
[]
[]
[]
[]
[]
["Section B: Project Context"]
[]
["1.)  Describe how the proposed project provides critical links to the area the project serves (examples are multi-modal connections, large residential areas, emergency routes, freight routes, employment centers etc).  Discuss type and magnitude of link."]
[]
[]
[]
[]
[]
["2.) How was the need for the project identified? Was the project derived from a local bridge work program, a planning/engineering study, part of an overall plan, or part of an existing capital plan? Other source? Provide a copy or web link to the related planning/engineering studies or other planning work as part of this application"]
[]
[]
[]
[]
[]
["3.) What specific elemnts will be addressed in the project? For examples of pavement work by category, see page 14 of the NYSDOT TIP/STIP Policy Guidance Document (Part 1) for the 2016 TIP Update on UCTC’s website at: http://ulstercountyny.gov/planning/transportation-improvement-plan "]

{"sheet":"Funding","index":2,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[31,0,31,3],[19,0,19,5],[26,0,26,5],[27,0,27,3],[29,0,29,3],[28,0,28,3],[30,0,30,3],[0,0,0,5],[20,0,20,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[2,0,2,5]]}
["UCTC STP-OFF SYSTEM BRIDGE BLOCK PROGRAM FUNDING WORKSHEET"]
[]
["Element Cost Estimates"]
["Element","Unit","Unit Price","Quantity","Total Cost","Estimate source"]
["eg 5' wide sidewalk ","LF",74,20,{"$f":"C5*D5","v":1480},"NYSDOT Item Numbers: 608.0101 - CONCRETE SIDEWALKS AND DRIVEWAYS203.02 - UNCLASSIFIED EXCAVATION AND DISPOSAL 304.12 - SUBBASE COURSE TYPE 2"]
[null,null,null,null,{"$f":"C6*D6","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[]
["Estimated Total Project Costs"]
["Construction Costs (in 2017 $)",null,null,null,{"$f":"SUM(E6:E18)","v":0}]
["Inspection Cost/Contingency (10% of construction cost)"]
["All Design Phases:"]
["Total Project Cost:",null,null,null,{"$f":"SUM(E21:E23)","v":0}]
[]
[]
["Funding Sources"]
["Federal Funds Requested + Required 20% Local Match*"]
["Additional Local Funds Beyond the Required Match**"]
["Funds for Other Sources Beyond the Required Match **"]
["List the source of the other funding:"]
["Total Project Cost***:",null,null,null,{"$f":"SUM(E28:E31)","v":0}]
[]
[]
[]
["* Match percentage may vary based upon federal fund source requirements."]
["** These funds would be in addition to the required local match"]
["*** The total in the Total Project Cost section mus equal the total in the Funding Sources section"]

{"sheet":"BridgeTable","index":3,"n_rows":218,"n_cols":22,"rows_kept":218,"cut":false,"hidden":false,"merged":[]}
["BIN","Region","County Name","Owner","PRIMARY OWNER","CARRIED","CROSSED","AADT","DAILY TRUCK TRAFFIC (%)","DETOUR LENGTH (MI)","YEAR BUILT","DECK AREA (SQ FT)","CONDITION RATING","STRUCTURALLY DEFICIENT","currentwork","POSTED LOAD (TONS)","HYDRAULIC RATING","FRACTURE CRITICAL","Design Type","Material","LBPI","FC"]
["3025090",8,"Ulster","County","30","COUNTY ROAD 47","HATCHERY HOLLOW ",400,7.41,25,1986,1066,5.3330000000000002,"N","paint",0,"4","N","09","1",0.154,"08"]
["3025100",8,"Ulster","County","30","COUNTY ROAD 47  ","LTL MABEN HOLLOW",400,7.41,25,1970,1032,3.8769999999999998,"N","majorrehab",0,"4","N","09","2",0.504,"08"]
["3025110",8,"Ulster","County","30","COUNTY ROAD 47  ","BISCUIT CREEK   ",146,7.41,25,1972,2100,5,"N","maintproject",0,"4","N","09","1",0.14799999999999999,"08"]
["3025130",8,"Ulster","County","30","COUNTY ROAD 47  ","HIGH FALLS BROOK",146,7.41,25,2006,1204,6.2880000000000003,"N","paint",0,"5","N","09","1",0.14799999999999999,"08"]
["3025140",8,"Ulster","County","30","COUNTY ROAD 47  ","FALL BROOK      ",146,7.41,25,1993,1033,4.8150000000000004,"N","cyclical",0,"4","N","27","B",0.188,"08"]
["3346370",8,"Ulster","County","30","CR 42","BUSHKILL CREEK  ",711,7.41,27,1993,6150,5.8730000000000002,"N","cyclical",0,"4","N","13","2",0.154,"08"]
["3346390",8,"Ulster","County","30","HURLEY MOUNTAIN ROAD","STONY CREEK     ",1007,5.62,14,1988,733,4,"N","minorrehab",0,"5","N","43","B",0.11799999999999999,"08"]
["3346490",8,"Ulster","County","30","PEEKAMOOSE ROAD"," RONDOUT CREEK  ",93,7.41,27,2006,1584,6.0170000000000003,"N","paint",0,"4","N","09","1",0.14799999999999999,"08"]
["3346500",8,"Ulster","County","30","PEEKAMOOSE ROAD","BUTTERMILK FALLS BROOK",93,7.41,27,1929,844,5.93,"Y","majorrehab",null,"2","N","09","2",0.38100000000000001,"08"]
["3346510",8,"Ulster","County","30","COUNTY ROAD 30  ","SAW KILL        ",2338,3.8,8,1931,1300,4.2460000000000004,"N","majorrehab",0,"4","N","09","2",0.32600000000000001,"08"]
["3346560",8,"Ulster","County","30","COUNTY ROAD 7","KLYNE KILL      ",2340,6.74,5,2006,1736,6.1189999999999998,"N","paint",0,"5","N","09","1",0.06,"08"]
["3346590",8,"Ulster","County","30","PEEKAMOOSE ROAD","RONDOUT CREEK   ",93,7.41,27,2003,1596,4.1399999999999997,"Y","deckrepl",0,"5","N","09","2",0.311,"08"]
["3346640",8,"Ulster","County","30","ALBANY POST ROAD","SHAWANGUNK KILL ",2504,6.12,1,1992,5832,5.7809999999999997,"N","vertdown",0,"5","N","13","2",3.3000000000000002E-2,"08"]
["3346680",8,"Ulster","County","30","PEEKAMOOSE ROAD","BEAR HOLE BROOK ",93,7.41,27,1947,882,5.4390000000000001,"N","vertdown",0,"4","N","09","1",0.14799999999999999,"08"]
["3346740",8,"Ulster","County","30","COUNTY ROAD 35  ","PLATTEKILL CREEK",3654,7.41,2,1994,1352,4.5439999999999996,"Y","deckrepl",0,"4","N","09","2",0.16200000000000001,"08"]
["3346870",8,"Ulster","County","30","ULSTER HEIGHTS RD","BOTSFORD BROOK  ",261,7.41,23,1953,2000,3.9830000000000001,"Y","deckrepl",10,"4","N","09","1",0.38,"08"]
["3347000",8,"Ulster","County","30","BIG POND ROAD   ","BEAVER KILL     ",88,7.45,7,1960,2576,4.6559999999999997,"N","maintproject",0,"4","N","09","2",8.5999999999999993E-2,"08"]
["3347210",8,"Ulster","County","30","COUNTY ROAD 9   ","DWAAR KILL      ",3997,7.41,5,2015,2717,6.8620000000000001,"Y","cyclical",null,"4","N","03","E",0.14399999999999999,"08"]
["3347260",8,"Ulster","County","30","HURLEY MT ROAD  ","ESOPUS CREEK    ",1007,5.62,16,1958,8900,3.903,"Y","replace",0,"4","N","13","1",0.46,"08"]
["3347320",8,"Ulster","County","30","COUNTY ROAD 18  ","WALLKILL RIVER  ",4006,7.06,9,1915,9000,3.7629999999999999,"Y","replace",20,"4","N","25","B",0.53600000000000003,"08"]
["3347340",8,"Ulster","County","30","COUNTY ROAD 7   ","VERKEERDER KILL ",2107,4.3,2,1938,1482,5.0199999999999996,"N","minorrehab",0,"4","N","09","1",3.7999999999999999E-2,"08"]
["3347410",8,"Ulster","County","30","CO RD 6A","COXING KILL     ",966,7.41,3,1941,1660,5.1929999999999996,"N","paint",0,"5","N","09","1",3.5000000000000003E-2,"08"]
["3347560",8,"Ulster","County","30","COUNTY ROAD 42  ","MALTBY HOLLOW BRK",711,7.41,27,1957,2100,3.9670000000000001,"Y","deckrepl",0,"4","N","09","1",0.35099999999999998,"08"]
["3347580",8,"Ulster","County","30","COUNTY ROAD 47","ESOPUS CREEK    ",400,7.41,1,1953,3900,3.7810000000000001,"N","majorrehab",10,"5","Y","15","1",0.46800000000000003,"08"]
["3347600",8,"Ulster","County","30","COUNTY ROAD 3   ","MOMBACCUS CREEK ",774,10.17,1,1955,1300,4.1230000000000002,"N","majorrehab",0,"4","N","09","2",0.28899999999999998,"08"]
["3347650",8,"Ulster","County","30","COUNTY ROAD 7   ","DWAAR KILL      ",1064,7,6,2006,1574,5.9320000000000004,"N","paint",0,"4","N","09","1",5.1999999999999998E-2,"08"]
["3347700",8,"Ulster","County","30","SAMSONVILLE ROAD","METTACAHONTS CRK",null,7.41,23,2000,1586,4.5090000000000003,"Y","deckrepl",0,"5","N","09","2",0.24399999999999999,"08"]
["3347750",8,"Ulster","County","30","FISH CREEK ROAD ","PLATTEKILL CREEK",879,7.41,9,1965,2700,4.3499999999999996,"N","majorrehab",0,"4","N","09","1",0.31,"08"]
["3347770",8,"Ulster","County","30","BURLINGHAM ROAD","PLATTE KILL     ",2107,4.3,2,1965,1300,5.4109999999999996,"N","deckrepl",0,"4","N","09","1",3.7999999999999999E-2,"08"]
["3370210",8,"Ulster","County","30","PEEKAMOOSE ROAD","PEEKAMOOSE LAKE INLET",283,7.41,6,1992,774,4.5860000000000003,"N","cyclical",null,"4","N","27","B",0.11600000000000001,"08"]
["3370870",8,"Ulster","County","30","CR 47","Giant Ledge Strea",400,7.41,null,2012,1653,6.1050000000000004,"N","cyclical",null,"4","Y","11","1",0.10100000000000001,"08"]
["2224200",8,"Ulster","Town","40","BALACE ROAD     ","RONDOUT CREEK   ",18,6.98,99,2006,1206,5.6669999999999998,"N","cyclical",0,"5","N","03","E",0.21199999999999999,"09"]
["2224210",8,"Ulster","Town","40","CLOVE ROAD      ","COXING KILL     ",228,6.98,6,1930,691,2.1890000000000001,"Y","replace",12,"2","N","21","1",0.51100000000000001,"09"]
["2224220",8,"Ulster","Town","40","CLOVE ROAD","COXING KILL     ",228,6.98,6,1988,690,5.4859999999999998,"N","cyclical",0,"5","N","27","B",5.6000000000000001E-2,"09"]
["2224230",8,"Ulster","Town","40","BARNHART RD     ","BEAVER KILL     ",54,8.6199999999999992,99,1895,1170,4.6559999999999997,"N","maintproject",0,"4","Y","09","1",0.245,"09"]
["2224240",8,"Ulster","Town","40","MILL BROOK ROAD ","MILL BROOK      ",43,17.39,2,1933,750,3.1760000000000002,"Y","replace",0,"3","N","09","2",0.308,"09"]
["2224250",8,"Ulster","Town","40","MILL BROOK ROAD","BELLE AYR BROOK ",43,17.39,25,1926,405,3.1040000000000001,"Y","replace",0,"4","N","12","1",0.60899999999999999,"09"]
["2224260",8,"Ulster","Town","40","MILL BROOK ROAD ","MILL BROOK",43,17.39,15,2000,444,4.9260000000000002,"N","cyclical",0,"5","N","40","B",0.105,"09"]
["2224300",8,"Ulster","Town","40","OLD ROUTE 209   ","KRIPPLEBUSH CREEK",null,1,1,1927,900,3.5590000000000002,"Y","majorrehab",0,"4","N","01","B",0.40799999999999997,"09"]
["2224430",8,"Ulster","Town","40","MILL HOOK ROAD  ","MILL STREAM",70,6.98,1,1948,500,4.5960000000000001,"Y","majorrehab",14,"3","N","09","1",0.34200000000000003,"09"]
["2224440",8,"Ulster","Town","40","STONY KILL ROAD ","STONY KILL      ",301,6.98,1,1988,1196,5.2629999999999999,"N","deckrepl",0,"5","N","09","1",1.6E-2,"09"]
["2224460",8,"Ulster","Town","40","BOICE MILL ROAD ","FALLS MILL BROOK",149,6.98,1,1988,1000,4.1230000000000002,"N","majorrehab",13,"4","N","09","1",0.38,"09"]
["2224470",8,"Ulster","Town","40","WATER FALLS ROAD","MOMBACCUS CREEK ",56,11.86,2,1955,725,4.0350000000000001,"N","majorrehab",0,"4","N","09","1",0.29899999999999999,"09"]
["2224480",8,"Ulster","Town","40","SUNDOWN ROAD    ","WYNCOOP CREEK",200,6.98,2,1962,518,4.5439999999999996,"N","majorrehab",0,"2","N","09","1",0.27,"09"]
["2224510",8,"Ulster","Town","40","ROCK HILL ROAD  ","PETERS KILL     ",39,6.98,3,2011,807,5.2809999999999997,"N","vertdown",0,"4","N","09","1",1.9E-2,"09"]
["2224520",8,"Ulster","Town","40","PROJECT 32 ROAD ","STONY KILL      ",66,6.98,2,1955,853,4.4210000000000003,"N","deckrepl",19,"4","Y","09","1",0.19500000000000001,"09"]
["2224530",8,"Ulster","Town","40","DRUMMOND FALLS RD","KAATERSKILL CREEK",283,6.98,1,1884,842,4.7249999999999996,"N","deckrepl",10,"4","Y","09","1",0.154,"09"]
["2224540",8,"Ulster","Town","40","CHARLES SMITH RD","KAATERSKILL CREEK",234,6.98,3,1985,2616,5.476,"N","paint",0,"5","N","13","1",2.4E-2,"09"]
["2224560",8,"Ulster","Town","40","SILVER HOLLOW RD","STONY CLOVE CREEK",180,6.98,1,1985,2140,5.42,"N","cyclical",0,"5","N","03","E",8.3000000000000004E-2,"09"]
["2224570",8,"Ulster","Town","40","BROAD ST HLW ROAD","BROAD ST HOLLW BK",182,6.98,99,1987,1375,5.6070000000000002,"N","paint",0,"4","N","09","1",0.151,"09"]
["2224600",8,"Ulster","Town","40","FAWN HILL ROAD","WOODLAND CREEK",31,6.98,99,1988,1520,4.8250000000000002,"N","deckrepl",15,"4","N","09","1",0.219,"09"]
["2224620",8,"Ulster","Town","40","EAGLE MOUNTAIN RD","ESOPUS CREEK    ",4,6.98,99,1903,992,5.2629999999999999,"N","cyclical",20,"4","N","09","1",0.192,"09"]
["2224650",8,"Ulster","Town","40","CHURCH ROAD     ","TRIB ESOPUS CREEK",12,6.98,10,1998,676,4.4740000000000002,"N","majorrehab",0,"4","N","09","1",0.27900000000000003,"09"]
["2224670",8,"Ulster","Town","40","MOUNTAIN ROAD   ","BEAVER BROOK    ",193,6.98,2,1995,800,6.6669999999999998,"N","cyclical",0,"4","N","27","B",3.4000000000000002E-2,"09"]
["2224680",8,"Ulster","Town","40","RED MILLS ROAD  ","DWAAR KILL      ",1567,6.98,2,1963,800,3.8090000000000002,"N","replace",0,"4","N","09","1",0.23699999999999999,"09"]
["2224690",8,"Ulster","Town","40","JOHNS ESTATE ROAD","VERKEERDER KILL ",567,6.98,1,2004,1140,6.5650000000000004,"N","cyclical",0,"5","N","27","B",3.4000000000000002E-2,"09"]
["2224700",8,"Ulster","Town","40","ULSTERVILLE ROAD","VERKEERDER KILL ",1414,6.98,2,1989,1144,4.8470000000000004,"N","paint",0,"4","N","36","1",5.6000000000000001E-2,"09"]
["2224720",8,"Ulster","Town","40","JANSEN ROAD","BEAVER BROOK    ",644,6.98,1,1988,995,3.9249999999999998,"N","majorrehab",0,"5","N","09","1",0.16900000000000001,"09"]
["2224730",8,"Ulster","Town","40","BATES LANE      ","DWAAR KILL      ",212,6.98,3,1992,1254,5.1859999999999999,"N","vertdown",0,"4","N","36","1",2.4E-2,"09"]
["2224760",8,"Ulster","Town","40","OLD ROUTE 209   ","SANDBURG CREEK  ",495,6.98,1,1988,2144,5.05,"N","paint",0,"5","N","09","1",1.9E-2,"09"]
["2224800",8,"Ulster","Town","40","COLD BROOK ROAD ","LITTLE BEAVER KL",378,6.98,7,1930,860,4.702,"N","vertdown",0,"4","N","09","1",0.09,"09"]
["2224830",8,"Ulster","Town","40","CHESTNUT HILL RD","SAW KILL        ",250,6.98,1,1979,1053,6.3970000000000002,"Y","cyclical",0,"4","N","09","1",1.2999999999999999E-2,"09"]
["2224840",8,"Ulster","Town","40","YERRY HILL ROAD ","SAW KILL        ",375,6.98,3,1996,2444,4.5739999999999998,"Y","majorrehab",10,"4","Y","19","2",0.41599999999999998,"09"]
["2224860",8,"Ulster","Town","40","MCDANIEL ROAD   ","SAW KILL        ",204,6.98,7,1928,816,4.2629999999999999,"N","majorrehab",5,"4","N","09","1",0.39700000000000002,"09"]
["2224870",8,"Ulster","Town","40","EIGHMEY ROAD    ","SILVER HOLLOW   ",170,6.98,1,1934,690,5.7949999999999999,"N","vertdown",0,"5","N","01","E",0.03,"09"]
["2224880",8,"Ulster","Town","40","MINK HOLLOW ROAD","BEAVER KILL     ",238,6.98,99,1920,885,4.431,"N","vertdown",15,"3","N","09","1",0.30399999999999999,"09"]
["2262930",8,"Ulster","Town","40","MILLIE EDWARDS RD","ALDER CREEK     ",11,6.98,99,1994,432,5.1479999999999997,"N","cyclical",0,"4","N","27","B",0.158,"09"]
["2262960",8,"Ulster","Town","40","VAN HOAGLAND ROAD","MINK HOLLOW CREEK",11,6.98,99,2012,500,6.931,"N","cyclical",0,"4","Y","21","1",0.22800000000000001,"09"]
["2264100",8,"Ulster","Town","40","BLACK CREEK ROAD","BLACK CREEK     ",147,6.98,1,1925,1600,4.556,"N","replace",0,"4","N","25","B",0.24199999999999999,"09"]
["2264130",8,"Ulster","Town","40","AUMICK ROAD     ","PALMAGHATT KILL ",174,6.98,1,1987,853,4.0570000000000004,"N","majorrehab",0,"5","N","09","1",0.186,"09"]
["2264170",8,"Ulster","Town","40","STONEY CLOVE ROAD","STONY CLOVE CREEK",65,6.98,99,1965,700,4.6840000000000002,"N","majorrehab",0,"5","N","41","1",0.36599999999999999,"09"]
["2264250",8,"Ulster","Town","40","BLACK CREEK ROAD","SWARTE KILL     ",null,1,3,2002,700,6.8520000000000003,"N","cyclical",0,"5","N","42","7",6.6000000000000003E-2,"09"]
["2264270",8,"Ulster","Town","40","LAUREN TICE ROAD","SAWYER KILL     ",319,6.98,4,1948,2300,4.3899999999999997,"N","majorrehab",0,"5","N","43","B",0.28599999999999998,"09"]
["2264280",8,"Ulster","Town","40","ROSE MOUNTAIN RD.","ROSE MOUNTAIN ST",69,6.98,1,1958,600,5.1109999999999998,"N","cyclical",0,"5","N","40","B",1.6E-2,"09"]
["2264390",8,"Ulster","Town","40","BIRCH CREEK ROAD","BIRCH CREEK     ",null,6.98,1,1991,500,4.2629999999999999,"N","cyclical",0,"5","N","26","7",0.18099999999999999,"09"]
["2264400",8,"Ulster","Town","40","HERDMAN ROAD    ","FOX HOLLOW BROOK",26,6.98,99,1956,561,4.3529999999999998,"Y","majorrehab",12,"4","N","09","1",0.48199999999999998,"09"]
["2264410",8,"Ulster","Town","40","ERICSON ROAD    ","DRY BROOK       ",12,0,99,1890,600,5.6920000000000002,"N","cyclical",0,"5","N","09","2",0.13800000000000001,"09"]
["2264430",8,"Ulster","Town","40","VALLI ROAD      ","BLACK CREEK     ",32,6.98,99,1954,500,4.0380000000000003,"Y","majorrehab",8,"4","N","09","1",0.52700000000000002,"09"]
["2264440",8,"Ulster","Town","40","GEIGER ROAD     ","BEER KILL       ",285,6.98,3,1979,1100,5.8280000000000003,"N","cyclical",0,"5","N","09","1",2.7E-2,"09"]
["2264460",8,"Ulster","Town","40","FOORDEMOOR ROAD ","TRIB ROUNDOUT CRK",2529,4.99,1,1976,1000,5.5629999999999997,"N","paint",0,"5","N","09","1",3.7999999999999999E-2,"09"]
["2264500",8,"Ulster","Town","40","OLO FOORDMORE RD","TRIB TO RNDOUT CK",2529,4.99,0,1929,400,null,"","N/A",99,"","","12","1",0.36299999999999999,"09"]
["2264510",8,"Ulster","Town","40","LAWRENCE ROAD   ","STONY KILL      ",30,6.98,1,1929,500,3.875,"N","majorrehab",3,"4","N","12","1",0.41299999999999998,"09"]
["2267650",8,"Ulster","Town","40","MAIN STREET     ","CATHEDRAL GLEN  ",218,6.98,1,1988,1200,4.6829999999999998,"N","cyclical",0,"4","N","44","8",8.2000000000000003E-2,"09"]
["2268750",8,"Ulster","Town","40","ROSSNER BRIDGE RD","BUSHNELLSVILLE CK",5,6.98,99,1996,454,5.9429999999999996,"N","cyclical",0,"4","N","09","2",0.13800000000000001,"09"]
["2268940",8,"Ulster","Town","40","MILL BROOK ROAD ","MILL BROOK      ",43,17.39,0,1991,1262,5.2809999999999997,"N","majorrehab",0,"4","N","09","1",0.16,"09"]
["2269010",8,"Ulster","Town","40","MAIN STREET     ","BIRCH CREEK     ",218,6.98,1,1990,1184,4.2329999999999997,"N","majorrehab",0,"4","N","01","8",0.17299999999999999,"09"]
["2270000",8,"Ulster","Town","40","PECK HOLLOW ROAD","PECK HOLLOW STRM",null,0,99,1996,660,4.0350000000000001,"N","majorrehab",20,"4","N","09","1",0.52600000000000002,"09"]
["2270010",8,"Ulster","Town","40","PECK HOLLOW ROAD","PECK HOLLOW STRM",null,null,0,1950,1800,7,"N","cyclical",0,"4","Y","21","1",0.09,"09"]
["2270020",8,"Ulster","Town","40","PECK HOLLOW RD","PECK HOLLOW STRM",null,1,10,1997,530,4.867,"N","cyclical",20,"4","N","27","B",0.14000000000000001,"09"]
["2270070",8,"Ulster","Town","40","DEER LANE","ESOPUS CREEK OVFL",null,1,99,2009,708,5.3330000000000002,"N","paint",0,"3","N","09","1",0.16800000000000001,"09"]
["2270080",8,"Ulster","Town","40","FOX HOLLOW ROAD","FOX HOLLOW CREEK",249,6.98,99,1995,498,5.867,"N","majorrehab",0,"4","N","09","1",0.36,"09"]
["2270130",8,"Ulster","Town","40","MOON HAW ROAD","WITTENBERG BROOK",null,0,1,2006,403,5.0960000000000001,"N","majorrehab",10,"4","N","09","1",0.20499999999999999,"09"]
["2270260",8,"Ulster","Town","40","HINKLEY RD","MILL BROOK",null,0,99,2014,512,7,"N","cyclical",0,"4","N","01","B",0.14799999999999999,"09"]
["2270700",8,"Ulster","Town","40","LOWER BIRCH CRK","BIRCH CREEK",19,6.98,99,2011,1708,6.4489999999999998,"N","cyclical",null,"4","Y","21","1",0.22800000000000001,"09"]
["2270820",8,"Ulster","Town","40","BRADKIN ROAD","Traver Hollow Cre",null,6.98,null,2012,1041,6.4740000000000002,"N","cyclical",null,"5","N","40","7",0.03,"09"]
["2270830",8,"Ulster","Town","40","KATE YAEGER ROAD","Plattekill Creek",null,6.98,null,2012,473,6.7080000000000002,"N","cyclical",null,"5","Y","01","B",0.06,"09"]
["2346960",8,"Ulster","Town","40","ELM RD          ","BIRCH CREEK     ",116,6.98,1,1958,2900,4.6589999999999998,"N","cyclical",0,"5","N","43","B",7.8E-2,"09"]
["3224180",8,"Ulster","County","30","NEW HILL ROAD   ","EAST BRANCH NEVERSINK RIVER",null,6.98,3,1973,1610,5.1689999999999996,"N","vertdown",null,"3","N","09","1",4.1000000000000002E-2,"09"]
["3346360",8,"Ulster","County","30","COUNTY ROAD 46","DEAN BROOK",333,6.98,10,2001,781,4.93,"N","majorrehab",0,"4","N","09","2",0.223,"09"]
["3346380",8,"Ulster","County","30","HANG GLIDER ROAD","SANDBURG CREEK  ",74,6.98,99,1929,1515,5.0350000000000001,"Y","majorrehab",0,"3","N","09","1",0.373,"09"]
["3346400",8,"Ulster","County","30","OREGON TRAIL    ","VERKEERDER KILL ",498,6.98,4,2001,928,4.9470000000000001,"N","cyclical",0,"3","N","09","2",6.2E-2,"09"]
["3346410",8,"Ulster","County","30","BOODLE HOLE ROAD","ROCHESTER CREEK ",217,6.98,4,1997,1665,5.2629999999999999,"N","minorrehab",0,"5","Y","10","2",0.11,"09"]
["3346420",8,"Ulster","County","30","WOODLAND VLY ROAD","WOODLAND CREEK  ",567,6.98,99,1999,4396,5.5709999999999997,"N","cyclical",0,"5","N","13","2",0.151,"09"]
["3346430",8,"Ulster","County","30","SPORTSMANS ROAD","RONDOUT CREEK   ",146,6.98,3,1931,1900,4.6769999999999996,"Y","majorrehab",12,"4","Y","19","1",0.40200000000000002,"09"]
["3346450",8,"Ulster","County","30","QUEENS HIGHWAY  ","FALLS MILL BROOK",2072,5.49,2,1994,1474,5.4909999999999997,"N","cyclical",0,"4","N","09","2",3.3000000000000002E-2,"09"]
["3346460",8,"Ulster","County","30","SHEELY ROAD     ","SUNDOWN CREEK   ",40,10,1,1995,918,5.8250000000000002,"N","cyclical",0,"4","N","09","2",6.0000000000000001E-3,"09"]
["3346470",8,"Ulster","County","30","DOUG RD","ROCHESTER CREEK ",65,6.98,3,1996,1248,4.702,"N","deckrepl",0,"5","N","09","2",5.8000000000000003E-2,"09"]
["3346530",8,"Ulster","County","30","COUNTY ROAD 77","RONDOUT CREEK   ",2529,4.99,1,2011,7119,5.4409999999999998,"N","cyclical",0,"4","N","03","E",0.108,"09"]
["3346540",8,"Ulster","County","30","DRY BROOK ROAD","HAYNES HOLLOW STM",29,10,99,2004,929,5.86,"N","cyclical",0,"4","N","09","2",0.14000000000000001,"09"]
["3346550",8,"Ulster","County","30","LAKE ROAD       ","PALMAGHATT KILL ",218,6.98,1,2005,1084,5.3860000000000001,"N","deckrepl",0,"5","N","09","2",8.0000000000000002E-3,"09"]
["3346580",8,"Ulster","County","30","SUNDALE ROAD","METTACHONTS CREEK",null,10,4,2003,1627,4.7539999999999996,"N","deckrepl",null,"5","N","09","1",5.6000000000000001E-2,"09"]
["3346600",8,"Ulster","County","30","KINGS HIGHWAY   ","KRIPPLEBUSH CREEK",483,6.98,1,1990,1601,4.649,"N","deckrepl",0,"4","N","09","1",6.7000000000000004E-2,"09"]
["3346660",8,"Ulster","County","30","DENNING ROAD    ","E B NEVERSINK RVR",262,6.98,99,1929,900,3.9180000000000001,"Y","majorrehab",8,"3","N","12","1",0.57499999999999996,"09"]
["3346670",8,"Ulster","County","30","FOX HOLLOW ROAD ","FOX HOLLOW CREEK",249,6.98,99,1996,995,4.5090000000000003,"Y","deckrepl",0,"4","N","09","2",0.26300000000000001,"09"]
["3346690",8,"Ulster","County","30","SOUTH HOLLOW ROAD","BUSH KILL       ",5,6.98,99,1983,968,4.6669999999999998,"N","minorrehab",0,"5","N","09","1",0.188,"09"]
["3346700",8,"Ulster","County","30","WALKER VALLEY RD","PLATTE  KILL    ",1080,7.2,3,1986,1235,5.1230000000000002,"N","cyclical",0,"4","N","09","1",3.5000000000000003E-2,"09"]
["3346710",8,"Ulster","County","30","BROAD ST HOLLW RD","BROAD ST HOLLOW ",182,6.98,1,1998,1084,5.3860000000000001,"N","minorrehab",0,"4","N","09","2",8.0000000000000002E-3,"09"]
["3346720",8,"Ulster","County","30","CR 46           ","RONDOUT CREEK   ",333,6.98,10,1946,3000,3.6720000000000002,"Y","majorrehab",15,"3","Y","19","1",0.61099999999999999,"09"]
["3346730",8,"Ulster","County","30","COUNTY ROAD 49A","RIDER HOLLOW STRM",189,11.86,11,2007,1605,6.2110000000000003,"N","cyclical",0,"5","N","09","1",7.3999999999999996E-2,"09"]
["3346750",8,"Ulster","County","30","COUNTY ROAD 33","PLATTEKILL CREEK",2539,7.41,8,1995,1939,4.7210000000000001,"N","deckrepl",0,"5","N","09","2",0.115,"09"]
["3346760",8,"Ulster","County","30","BONNIEVIEW RD   ","CATHEDRAL GLEN  ",11,6.98,99,1930,861,4.1230000000000002,"Y","majorrehab",14,"4","N","09","2",0.50800000000000001,"09"]
["3346770",8,"Ulster","County","30","SCHOOL HILL ROAD","COXING KILL     ",123,6.98,1,1986,1840,5.52,"N","cyclical",0,"5","N","03","E",0.08,"09"]
["3346790",8,"Ulster","County","30","CANYON LAKE RD  ","NORTH PETERS KILL",null,1,2,1929,860,4.7720000000000002,"N","maintproject",0,"4","N","09","1",4.2000000000000003E-2,"09"]
["3346800",8,"Ulster","County","30","UPPER SAHLR ML RD","ROCHESTER CREEK ",60,11.29,2,2008,784,6.1189999999999998,"N","cyclical",0,"5","N","09","1",1.6E-2,"09"]
["3346810",8,"Ulster","County","30","BLUE MOUNTAIN RD","PLATTEKILL CREEK",791,7.56,5,1995,1392,4.0330000000000004,"Y","majorrehab",15,"4","N","09","2",0.42399999999999999,"09"]
["3346820",8,"Ulster","County","30","BLUE MOUNTAIN RD","LUCAS KILL      ",791,7.56,6,1996,1508,4.07,"N","majorrehab",0,"4","N","09","2",0.32500000000000001,"09"]
["3346830",8,"Ulster","County","30","County Road 18","DWAAR KILL      ",4006,7.06,4,1989,1508,5.0529999999999999,"Y","deckrepl",0,"4","N","09","1",0.11600000000000001,"09"]
["3346840",8,"Ulster","County","30","DRY BROOK ROAD","DRY BROOK       ",29,10,99,1956,1100,4.5090000000000003,"N","deckrepl",0,"4","N","09","1",0.21199999999999999,"09"]
["3346930",8,"Ulster","County","30","GRAU ROAD       ","PLATTE  KILL    ",333,8.2200000000000006,2,1985,936,4.8419999999999996,"N","deckrepl",0,"4","N","09","1",4.3999999999999997E-2,"09"]
["3346940",8,"Ulster","County","30","CLOVE VALLEY ROAD","COXING KILL     ",228,6.98,6,2000,959,4.7889999999999997,"N","minorrehab",0,"5","N","09","2",6.5000000000000002E-2,"09"]
["3346970",8,"Ulster","County","30","DRY BROOK ROAD  ","DRY BROOK       ",29,10,99,1933,1071,4.2789999999999999,"Y","majorrehab",18,"4","N","09","2",0.48899999999999999,"09"]
["3347010",8,"Ulster","County","30","MILL BROOK RD","MILL BROOK",43,17.39,2,2001,1290,5.3330000000000002,"N","cyclical",0,"5","N","09","2",1.0999999999999999E-2,"09"]
["3347020",8,"Ulster","County","30","GOSSOO ROAD     ","BUSHNELLSVILLE CK",18,6.98,99,1988,860,5.2460000000000004,"N","paint",0,"4","N","09","1",0.14199999999999999,"09"]
["3347040",8,"Ulster","County","30","MOSSY BROOK RD  ","COXING KILL     ",909,6.98,1,1966,2400,4.6500000000000004,"N","deckrepl",0,"4","N","09","1",7.1999999999999995E-2,"09"]
["3347050",8,"Ulster","County","30","MARCUS ROAD     ","BEER KILL       ",132,6.98,4,2001,1502,4.7889999999999997,"N","cyclical",0,"5","N","09","2",5.0999999999999997E-2,"09"]
["3347060",8,"Ulster","County","30","SILVER HOLLOW RD","WARNER CREEK    ",180,6.98,99,1987,1326,4.5439999999999996,"N","majorrehab",0,"5","N","09","1",0.36399999999999999,"09"]
["3347070",8,"Ulster","County","30","MT PLESANT      ","ESPOUS CREEK    ",null,6.98,1,1934,6100,null,"","N/A",99,"","","18","1",null,"09"]
["3347080",8,"Ulster","County","30","PANTHER KILL ROAD","PANTHER KILL    ",62,6.98,99,1969,675,4.8070000000000004,"Y","majorrehab",0,"2","N","09","1",0.41199999999999998,"09"]
["3347090",8,"Ulster","County","30","Denning Rd","EB Neversink Rive",262,6.98,16,1936,1998,3.0630000000000002,"Y","replace",99,"4","Y","18","1",0.7,"09"]
["3347100",8,"Ulster","County","30","MABEN HOLLOW ROAD","ESOPUS CREEK    ",4,6.98,99,2013,846,6.6139999999999999,"N","cyclical",0,"4","N","09","1",0.14199999999999999,"09"]
["3347110",8,"Ulster","County","30","WOODLAND VLLY RD","PANTHER KILL    ",567,6.98,99,1999,1650,5.0880000000000001,"N","vertdown",0,"4","N","09","2",0.151,"09"]
["3347120",8,"Ulster","County","30","FOX HOLLOW ROAD ","ESOPUS CREEK    ",249,6.98,1,1953,2575,5.1310000000000002,"Y","maintproject",0,"4","N","09","2",8.0000000000000002E-3,"09"]
["3347130",8,"Ulster","County","30","MCKINLEY HOLLW RD","ESOPUS CREEK    ",82,6.98,99,1964,2018,7,"N","cyclical",null,"4","N","09","1",0.14799999999999999,"09"]
["3347140",8,"Ulster","County","30","BURNHAM HOLLOW RD","ESOPUS CREEK    ",41,6.98,0,1964,1302,5.5960000000000001,"N","paint",0,"4","N","09","1",8.0000000000000002E-3,"09"]
["3347160",8,"Ulster","County","30","COUNTY ROAD 54  ","BEAVER KILL     ",125,6.98,99,1939,1998,4.29,"N","deckrepl",20,"4","Y","15","1",0.38100000000000001,"09"]
["3347170",8,"Ulster","County","30","WOODLND VALLEY RD","DOUGHERTY BROOK ",567,6.98,99,1970,1026,5,"N","cyclical",0,"4","N","09","1",0.156,"09"]
["3347180",8,"Ulster","County","30","GREENVILLE ROAD ","PIGEON HOLE BROOK",null,6.98,9,1990,918,6.4550000000000001,"N","cyclical",0,"4","N","27","B",6.7000000000000004E-2,"09"]
["3347190",8,"Ulster","County","30","PALENTOWN RD    ","METTACAHONTS CREE",379,6.98,1,2000,952,4.1399999999999997,"N","majorrehab",null,"5","N","09","2",0.27900000000000003,"09"]
["3347220",8,"Ulster","County","30","LASHER ROAD     ","BIRCH CREEK     ",41,6.98,1,2007,1314,6.2279999999999998,"N","paint",0,"4","N","09","1",8.0000000000000002E-3,"09"]
["3347230",8,"Ulster","County","30","FOORDMORE RD","RONDOUT CREEK   ",2529,4.99,2,1896,3750,4.6669999999999998,"N","minorrehab",0,"4","N","09","2",8.4000000000000005E-2,"09"]
["3347240",8,"Ulster","County","30","CR 49 Dry BrookRD","DRY BROOK       ",29,10,99,1989,1200,5.1230000000000002,"Y","paint",0,"4","N","09","1",0.14499999999999999,"09"]
["3347250",8,"Ulster","County","30","STONY CLOVE LANE","STONEY CLOVE CRK",65,6.98,99,1955,1140,4.7889999999999997,"N","deckrepl",0,"4","N","09","1",0.17699999999999999,"09"]
["3347270",8,"Ulster","County","30","MILLARD BURNETT R","PLATTEKILL CREEK",94,6.98,99,2001,1068,5.5090000000000003,"N","cyclical",0,"4","N","09","2",0.14299999999999999,"09"]
["3347280",8,"Ulster","County","30","BECKER ROAD     ","PLATTEKILL CREEK",62,6.98,99,1996,1024,6.8150000000000004,"N","cyclical",0,"5","N","25","7",0.188,"09"]
["3347300",8,"Ulster","County","30","BONE HOLLOW ROAD","NORTH PETERS KILL",311,2.7,1,1938,936,2.4340000000000002,"N","replace",0,"4","N","09","1",0.255,"09"]
["3347310",8,"Ulster","County","30","LOST CLOVE ROAD","ESOPUS CREEK    ",74,6.98,5,2006,2006,5.4560000000000004,"N","paint",null,"5","N","09","1",3.2000000000000001E-2,"09"]
["3347330",8,"Ulster","County","30","MELLERT ROAD    ","SAW KILL        ",82,6.98,99,1981,958,5,"N","vertdown",0,"5","N","02","E",0.218,"09"]
["3347360",8,"Ulster","County","30","DE WITT ROAD    ","METTACAHONTS CRK",59,6.98,3,2006,1272,5.492,"N","paint",0,"5","N","09","1",2.1999999999999999E-2,"09"]
["3347370",8,"Ulster","County","30","WOODLAND VLY ROAD","ESOPUS CREEK    ",615,6.98,2,1998,5520,4.6959999999999997,"N","deckrepl",0,"4","Y","19","2",0.14599999999999999,"09"]
["3347380",8,"Ulster","County","30","SOUTH MOUNTAIN RD","KLYNE KILL      ",171,6.98,1,1930,989,4.7190000000000003,"N","vertdown",0,"4","N","09","1",4.8000000000000001E-2,"09"]
["3347400",8,"Ulster","County","30","COUNTY ROAD 6   ","RONDOUT CREEK   ",1662,6.25,20,1965,9000,4.2030000000000003,"N","deckrepl",20,"4","N","13","1",0.30199999999999999,"09"]
["3347420",8,"Ulster","County","30","DENNING ROAD    ","E BR NEVERSINK RV",262,6.98,3,1970,2500,4.25,"Y","deckrepl",0,"4","N","09","1",0.17699999999999999,"09"]
["3347430",8,"Ulster","County","30","COUNTY ROAD 19  ","WALLKILL RIVER  ",548,7.09,9,1940,9242,4.2460000000000004,"N","majorrehab",0,"4","Y","18","1",0.40400000000000003,"09"]
["3347450",8,"Ulster","County","30","COUNTY ROAD 7A  ","SHAWANGUNK KILL ",266,6.98,3,1941,3479,4.508,"Y","deckrepl",0,"4","Y","19","1",0.22700000000000001,"09"]
["3347470",8,"Ulster","County","30","DENNING ROAD    ","E B NEVERSINK RVR",262,6.98,10,1965,4100,3.9169999999999998,"Y","replace",0,"2","N","09","1",0.45200000000000001,"09"]
["3347480",8,"Ulster","County","30","PIROG ROAD      ","VERKEERDER KILL ",403,6.98,1,1957,1217,5.0880000000000001,"N","vertdown",0,"4","N","09","1",1.6E-2,"09"]
["3347510",8,"Ulster","County","30","COUNTY ROAD 18","SHAWANGUNK KILL ",975,8.67,7,1960,6000,4.3559999999999999,"N","majorrehab",0,"4","N","09","1",0.29899999999999999,"09"]
["3347520",8,"Ulster","County","30","BOICE MILL RD   ","FALLS MILL BROOK",149,6.98,2,1962,723,5.4740000000000002,"N","minorrehab",0,"4","N","09","2",1.0999999999999999E-2,"09"]
["3347540",8,"Ulster","County","30","COUNTY ROAD 27","RONDOUT CREEK   ",781,6.98,9,1950,3800,4.2329999999999997,"Y","deckrepl",0,"4","N","09","1",0.22700000000000001,"09"]
["3347550",8,"Ulster","County","30","AWOSTING ROAD   ","BEAVER BROOK    ",548,6.98,8,1948,900,5.85,"N","cyclical",0,"4","N","01","B",6.5000000000000002E-2,"09"]
["3347570",8,"Ulster","County","30","BEAVER KILL ROAD","SCUDDER BROOK   ",75,22.5,99,1953,1104,4.2460000000000004,"Y","minorrehab",0,"4","N","09","2",0.247,"09"]
["3347590",8,"Ulster","County","30","HERDMAN ROAD    ","WOODLAND CREEK  ",26,6.98,99,2002,2263,5.5609999999999999,"N","cyclical",0,"5","N","09","2",null,"09"]
["3347610",8,"Ulster","County","30","TOW PATH ROAD   ","SANDERS KILL    ",427,6.98,5,1955,800,5.0330000000000004,"N","paint",0,"4","N","09","1",4.1000000000000002E-2,"09"]
["3347620",8,"Ulster","County","30","TOW PATH ROAD   ","PETERS KILL     ",427,6.98,1,1962,1718,5.0330000000000004,"N","deckrepl",0,"5","N","09","2",1.4E-2,"09"]
["3347640",8,"Ulster","County","30","TOW PATH ROAD","STONY KILL      ",427,6.98,5,1959,800,4.5609999999999999,"Y","minorrehab",24,"5","N","09","1",0.20100000000000001,"09"]
["3347660",8,"Ulster","County","30","DRY BROOK ROAD  ","RIDER HOLLOW STRM",29,10,12,1961,1700,4.7889999999999997,"N","cyclical",0,"4","N","09","2",9.5000000000000001E-2,"09"]
["3347680",8,"Ulster","County","30","DRY BROOK ROAD  ","DRY BROOK       ",29,10,2,1990,1716,5.5789999999999997,"N","paint",0,"4","N","09","1",1.2999999999999999E-2,"09"]
["3347740",8,"Ulster","County","30","UPPR CHERRYTWN RD","MOMBACCUS CREEK ",379,6.98,3,1963,2700,5.383,"Y","minorrehab",0,"5","N","09","1",7.6999999999999999E-2,"09"]
["3347780",8,"Ulster","County","30","METTACAHONTS ROAD","ROCHESTER CREEK ",952,6.98,4,1965,1500,4.9829999999999997,"N","maintproject",15,"5","N","09","1",9.2999999999999999E-2,"09"]
["3347790",8,"Ulster","County","30","CLRK VANVLERDN RD","PLATTEKILL CREEK",null,10,1,1966,1600,4.75,"N","paint",15,"4","N","09","1",8.8999999999999996E-2,"09"]
["3347800",8,"Ulster","County","30","BRIDGE STREET   ","ESOPUS CREEK    ",1219,6.98,1,1976,8800,4.6340000000000003,"N","majorrehab",0,"5","N","09","2",0.22500000000000001,"09"]
["3347810",8,"Ulster","County","30","BEECH HILL ROAD ","BEAVER KILL     ",86,10.87,2,1969,2400,4.7809999999999997,"N","deckrepl",15,"4","N","09","1",9.6000000000000002E-2,"09"]
["3347820",8,"Ulster","County","30","ZENA HIGHWOODS RD","SAW KILL        ",null,10,1,1968,2800,4.5,"N","minorrehab",0,"5","N","09","1",7.3999999999999996E-2,"09"]
["3347830",8,"Ulster","County","30","PALENTOWN ROAD  ","METTACAHONTS CRK",379,6.98,1,2000,942,5.1580000000000004,"N","cyclical",0,"4","N","09","2",1.0999999999999999E-2,"09"]
["3347840",8,"Ulster","County","30","FLOYD ACKERT ROAD","BLACK CREEK     ",null,6.98,2,1967,1074,5.1580000000000004,"N","cyclical",0,"5","N","09","2",6.0000000000000001E-3,"09"]
["3347850",8,"Ulster","County","30","COUNTY ROAD 47  ","BUSHNELLSVILLE CK",156,6.98,1,1995,1693,4.8029999999999999,"N","deckrepl",0,"4","N","09","2",3.2000000000000001E-2,"09"]
["3364960",8,"Ulster","Town","40","SHEELEY ROAD","SUNDOWN CREEK   ",15,6.98,99,1956,559,5.1749999999999998,"N","paint",0,"4","N","09","1",0.14199999999999999,"09"]
["3365180",8,"Ulster","County","30","CROSS MOUNTAIN RD","ALDER CREEK     ",125,6.98,9,1994,559,5.2759999999999998,"N","cyclical",0,"5","N","27","B",7.1999999999999995E-2,"09"]
["3365200",8,"Ulster","County","30","CR 40           ","BEAVER KILL     ",794,6.98,1,1991,1970,5.4039999999999999,"N","majorrehab",0,"4","Y","19","1",0.25900000000000001,"09"]
["3365210",8,"Ulster","County","30","COUNTY ROAD 6","COXING KILL     ",null,6.98,1,2006,1529,6.5590000000000002,"N","cyclical",0,"4","N","09","1",5.0000000000000001E-3,"09"]
["3365230",8,"Ulster","County","30","CROSS MOUNTAIN RD","ALDER CREEK     ",125,6.98,9,1994,920,5.2069999999999999,"N","cyclical",0,"4","N","27","B",7.1999999999999995E-2,"09"]
["3370570",8,"Ulster","County","30","NEW HILL ROAD","Trib - EB Neversi",null,6.98,null,2001,1008,4.6840000000000002,"N","cyclical",null,"4","N","42","7",9.8000000000000004E-2,"09"]
["3370580",8,"Ulster","County","30","DENNING  ROAD","Flat Brook",262,6.98,null,1970,410,5.5259999999999998,"N","cyclical",0,"5","N","26","7",8.7999999999999995E-2,"09"]
["334709T",8,"Ulster","County","30","DENNING ROAD","E B NEVERSINK RVR",262,6.98,99,2005,2016,5.3860000000000001,"N","maintproject",0,"4","N","09","1",0.151,"09"]
["2224450",8,"Ulster","Town","40","BRIDGE ROAD     ","STONY KILL      ",36,4.99,1,1955,664,4.07,"Y","majorrehab",20,"2","N","09","1",0.42399999999999999,"19"]
["2224790",8,"Ulster","Town","40","PORT BEN ROAD   ","RONDOUT CREEK   ",315,4.99,2,1915,3700,4.016,"N","majorrehab",4,"4","Y","18","1",0.439,"19"]
["2262970",8,"Ulster","Village","41","HICKORY STREET  ","BEER KILL       ",422,4.99,1,2014,2313,6.3330000000000002,"N","cyclical",null,"4","N","13","1",1.6E-2,"19"]
["2262980",8,"Ulster","Village","41","CLINTON AVENUE","NORTH GULLY     ",1085,4.99,1,1966,1300,3.7029999999999998,"Y","majorrehab",0,"4","N","09","1",0.40200000000000002,"19"]
["2264110",8,"Ulster","County","30","CONNELLY ROAD   ","PLANTASIA CREEK ",1520,4.99,1,1983,643,5.6669999999999998,"N","cyclical",0,"5","N","01","B",3.2000000000000001E-2,"19"]
["2264230",8,"Ulster","Town","40","RIVER ROAD","TWAALFSKILL CREEK",221,4.99,1,2006,700,5.8520000000000003,"N","cyclical",0,"5","N","27","B",2.8000000000000001E-2,"19"]
["2264260",8,"Ulster","Town","40","HARDENBURG ROAD ","SWARTE KILL     ",323,6.98,2,1935,736,5.6109999999999998,"N","cyclical",0,"4","N","27","B",3.5999999999999997E-2,"19"]
["2264450",8,"Ulster","Town","40","BARBARA ROAD    ","W BR BEER KILL  ",null,10,99,1965,1200,4.5910000000000002,"N","vertdown",0,"4","N","10","1",null,"19"]
["2264550",8,"Ulster","Village","41","BECKLEY DRIVE   ","FANTINE KILL    ",250,4.99,99,2010,702,6.3449999999999998,"N","cyclical",null,"5","N","27","B",0.16600000000000001,"19"]
["2270140",8,"Ulster","Town","40","Berme Road","Criminal Creek",null,null,null,1992,764,5.976,"N","cyclical",0,"5","N","43","B",2.5000000000000001E-2,"19"]
["2270530",8,"Ulster","Town","40","MILE HILL RD.","Hudson Valley Rai",421,6.08,null,2010,677,6.7709999999999999,"N","cyclical",null,"","N","27","B",3.1E-2,"19"]
["3224810",8,"Ulster","County","30","JOHN JOY ROAD","SAW KILL        ",1056,6.98,1,1975,2700,5.0940000000000003,"N","paint",0,"4","N","09","1",2.4E-2,"19"]
["3346480",8,"Ulster","County","30","INSTITUTION ROAD","RONDOUT CREEK   ",1246,4.99,5,1934,4209,4.9189999999999996,"N","cyclical",0,"5","Y","15","2",0.14000000000000001,"19"]
["3346610",8,"Ulster","County","30","Cutler Road","VERNOOY KILL",null,4.99,null,2009,1502,6.2709999999999999,"N","cyclical",0,"4","N","09","1",5.0000000000000001E-3,"19"]
["3346650",8,"Ulster","County","30","COUNTY ROAD 27","STONY KILL      ",483,5.51,9,1955,1200,4.7370000000000001,"N","majorrehab",0,"4","N","09","1",0.252,"19"]
["3346910",8,"Ulster","County","30","SNYDER ROAD     ","PLATTEKILL CREEK",1611,4.99,5,1955,3000,3.81,"N","majorrehab",0,"4","N","09","2",0.218,"19"]
["3346920",8,"Ulster","County","30","GRANITE ROAD","STONY KILL      ",483,5.51,9,1990,1150,4.9820000000000002,"N","vertdown",0,"4","N","09","1",6.8000000000000005E-2,"19"]
["3347490",8,"Ulster","County","30","BRIDGE ROAD     ","STONY KILL      ",36,4.99,1,1955,584,5.2110000000000003,"Y","paint",0,"3","N","09","1",8.3000000000000004E-2,"19"]
["3347730",8,"Ulster","Village","41","HUGUENOT STREET ","TRIBUTARY 13    ",200,4.99,1,1983,616,4.7619999999999996,"N","cyclical",0,"5","N","41","5",9.0999999999999998E-2,"19"]
["3347860",8,"Ulster","County","30","POWDERMILL ROAD ","SAW KILL        ",132,4.99,99,1970,2600,4.3280000000000003,"N","majorrehab",0,"5","N","09","1",0.39,"19"]
["3347870",8,"Ulster","County","30","ARROWHEAD ROAD  ","SANDBURG CREEK  ",534,4.99,1,1970,2100,5.1669999999999998,"N","deckrepl",0,"4","N","09","1",1.9E-2,"19"]
["3365190",8,"Ulster","County","30","OLD GREENFIELD RD","W BRNCH BEER KILL",84,8.99,1,1924,1800,4.49,"N","maintproject",0,"5","N","09","1",0.08,"19"]
["3365220",8,"Ulster","County","30","PANCAKE HOLLOW RD","BLACK CREEK     ",2230,4.99,4,1963,800,4.8330000000000002,"N","cyclical",0,"5","N","01","B",0.08,"19"]

{"sheet":"ref","index":4,"n_rows":80,"n_cols":3,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
["Design Types"]
["01","Slab"]
["02","Slab, Voided"]
["03","Box, Adjacent"]
["04","Box, Spread"]
["05","Tee Beam"]
["06","Prestressed Conc I-Beam"]
["07","Prestr Conc Box Channel"]
["08","Segmental Box"]
["09","Multi Girder Rolled Beam"]
["10","Deck w/Floorbeam"]
["11","Thru w/Floorbeam"]
["12","Jack Arch Rolled Beam"]
["13","Multi Girder Plate Girder"]
["14","Deck w/Floorbeam"]
["15","Thru w/Floorbeam"]
["16","Jack Arch Plate Girder"]
["17","Deck Truss"]
["18","Thru Truss w/Ovh Bracing"]
["19","Thru Truss no Ovh Bracing"]
["20","Combination Truss"]
["21","Kit Bridge Truss"]
["22","Thru Arch"]
["23","Tied Thru Arch"]
["24","Deck Arch Open Spandrel"]
["25","Deck Arch Clsed Spandrel"]
["26","Metal Pipe Arch"]
["27","Frame"]
["28","Frame w/Floorbeam"]
["29","Movable, Bascule"]
["30","Movable, Lift"]
["31","Movable, Swing"]
["32","Orthotropic"]
["35","Inverset, Plate Girder"]
["36","Inverset, Rolled Beam"]
["37","Suspension"]
["38","Single Box"]
["39","Tunnel"]
["40","Single Box Culvert"]
["41","Multiple Pipe Culvert"]
["42","Pipe Culvert"]
["43","Multiple Box Culvert"]
["44","Timber Beam"]
["XX","Other"]
["YY","Unknown"]
[]
["Material Types"]
["1","Steel"]
["2","Weathering Steel"]
["3","Special Steel"]
["4","Hybrid Steel Section"]
["5","Corrugated Steel"]
["6","Wrought or Cast Iron"]
["7","Aluminum"]
["8","Timber"]
["9","Masonry"]
["A","Concrete, Unreinforced"]
["B","Concrete, Reinforced"]
["C","Concrete, Unknown"]
["D","Prestr Conc Post-Tension"]
["E","Prestr Conc Pre-Tensioned"]
["F","Prestressed Conc Unkn"]
["X","Other"]
[]
[]
["Functional Class Codes",null,"STP"]
["01","Interstate","On"]
["02","Principal Arterial","On"]
["04","Principal Arterial","On"]
["06","Minor Arterial","On"]
["07","Major Collector","On"]
["08","Minor Collector","Off"]
["09","Local","Off"]
["11","Interstate","On"]
["12","Principal Arterial","On"]
["14","Principal Arterial","On"]
["16","Minor Arterial","On"]
["17","Major Collector","On"]
["18","Minor Collector","On"]
["19","Local","Off"]

{"sheet":"ImportToDB","index":5,"n_rows":2,"n_cols":17,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["BIN","PIN","Const Cost","Total Cost","SFY Letting","First Name","Last Name","Address 1","Address 2","City","Zip Code","Project Priority","Project Scope Description","Project Commentary","Project Sponsor","email","phone"]
[{"$f":"Form!B16","v":"2224560"},{"$f":"Form!B17","v":0},{"$f":"Form!E22","v":0},{"$f":"Form!E23","v":0},{"$f":"Form!E24","v":0},{"$f":"Form!B4","v":0},{"$f":"Form!E4","v":0},{"$f":"Form!B6","v":0},{"$f":"Form!B8","v":0},{"$f":"Form!B10","v":0},{"$f":"Form!H10","v":0},{"$f":"Form!H14","v":0},{"$f":"Form!A32","v":0},{"$f":"Form!A51","v":0},{"$f":"Form!C2","v":0},{"$f":"Form!B12","v":0},{"$f":"Form!F12","v":0}]