{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Form","Narrative Sheet","Funding","ref","ImportToDB","Index Parameters","BridgeTableNew"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[[75,1,75,8],[76,1,76,8],[52,0,67,8],[5,1,5,5],[7,1,7,5],[9,1,9,3],[32,0,32,8],[13,4,13,6],[11,1,11,3],[11,5,11,7],[51,0,51,8],[70,0,70,8],[71,0,71,8],[72,1,72,8],[73,1,73,8],[74,1,74,8],[0,0,0,8],[50,0,50,8],[3,1,3,2],[3,4,3,7],[33,0,48,8],[1,2,1,4],[1,0,1,1]]}
["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,BridgeTableNew!$A$2:$U$243,3,FALSE)","v":"Ulster"},null,null,"Project Priority"]
[]
["BIN","2224530",null,"Feature Carried",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,6,FALSE)","v":"DRUMMOND FALLS RD"}]
["Related PIN",null,null,"Feature Crossed",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$T$243,7,FALSE)","v":"KAATERSKILL CREEK"}]
[null,null,null,"Owner",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,4,FALSE)","v":"40 - Town"},null,"Region",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,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,BridgeTableNew!$A$2:$AA$243,27,FALSE)","v":"09"}]
[]
["Facility Importance",null,null,"Cost & Schedule",null,null,"Risk & Restrictions"]
["AADT",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,8,FALSE)","v":285},null,"Const. Cost",null,null,"Posting",null,{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,16,FALSE)","v":10}]
["% Trucks",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,9,FALSE)","v":4.91},null,"Total Cost",null,null,"Hyd. Vuln. Rating",null,{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,17,FALSE)","v":"4"}]
["Detour (mi)",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,10,FALSE)","v":1},null,"SFY Letting",null,null,"Fracture Critical",null,{"$f":"IF(F25=\"N\",\"No\",\"Yes\")","v":"Yes"}]
[null,null,null,null,null,{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,18,FALSE)","v":"Y"},"Design Type",null,{"$f":"VLOOKUP($F$26,ref!$A$1:$B$45,2,FALSE)","v":"Multi Girder Rolled Beam"}]
["Structure Details",null,null,"Capital Need",null,{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,19,FALSE)","v":"09"},"Material Type",null,{"$f":"VLOOKUP($F$27,ref!A47:B63,2,FALSE)","v":"Steel"}]
["Year Built",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,11,FALSE)","v":1884},null,"Condition Rating",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$AA$243,24,FALSE)","v":4.0220000000000002},{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,20,FALSE)","v":"1"}]
["Deck Area",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,12,FALSE)","v":798},null,"Rating Date",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$AA$243,25,FALSE)","v":"2019-07-16"},{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,14,FALSE)","v":"Y"}]
[null,null,null,"General Rating",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$AS$243,28,FALSE)","v":4}]
[null,null,null,"Structural Deficient '18",{"$f":"IF(F28=\"N\",\"No\",\"Yes\")","v":"Yes"},null,"LBPI '18",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,21,FALSE)","v":0.437}]
[null,null,null,"Model Recmdn. '18",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$U$243,15,FALSE)","v":"majorrehab"},null,"UCLBPI",{"$f":"VLOOKUP($B$16,BridgeTableNew!$A$2:$AS$243,45,FALSE)","v":0.47080952380952379}]
[]
["Project Scope Description"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Project Commentary"]
["Sponsor to describe unique elements and important factors that cannot readily be captured solely by the available data."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Affirmations"]
["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":[[28,0,28,8],[23,0,26,8],[29,0,32,8],[34,0,34,8],[35,0,38,8],[22,0,22,8],[0,0,3,8],[5,0,5,8],[10,0,13,8],[15,0,18,8],[20,0,20,8]]}
["Beyond Preservation Project Review \nNARRATIVE SHEET\n"]
[]
[]
[]
[]
["Section A: Project Description"]
[]
["BIN",{"$f":"Form!B16","v":"2224530"}]
[]
["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 elements will be addressed in the project? "]

{"sheet":"Funding","index":2,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,5],[20,0,20,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[2,0,2,5],[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]]}
["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 2020 $)",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 must equal the total in the Funding Sources section"]

{"sheet":"ref","index":3,"n_rows":80,"n_cols":3,"rows_kept":80,"cut":false,"hidden":true,"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":4,"n_rows":2,"n_cols":17,"rows_kept":2,"cut":false,"hidden":true,"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":"2224530"},{"$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!A34","v":0},{"$f":"Form!A53","v":0},{"$f":"Form!C2","v":0},{"$f":"Form!B12","v":0},{"$f":"Form!F12","v":0}]

{"sheet":"Index Parameters","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,10,2],[0,0,0,3],[2,1,3,1],[4,1,6,1],[8,1,9,1],[4,0,6,0],[2,0,3,0],[8,0,9,0]]}
["Ulster County Local Bridge Priority Index \n(0-75)"]
["Category","Category Points","Individual Parameter","Parameter Points"]
["Capital Need",32.5,"General Recommendation",27.5]
[null,null,"Structural Deficiency",5]
["Facility Importance",27.5,"AADT",7]
[null,null,"% Trucks",7]
[null,null,"Detour Length",13.5]
["Restrictions",5,"Postings",5]
["Risk/Resiliency",10,"Fracture Critical",5]
[null,null,"Hydraulic Vulnerability",5]
["Total",null,null,{"$f":"SUM(D3:D10)","v":75}]

{"sheet":"BridgeTableNew","index":6,"n_rows":243,"n_cols":45,"rows_kept":243,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27.5,null,null,null,5,7,7,13.5,5,5,5,null,null,null,{"$f":"SUM(AD1:AN1)","v":75},"out of 1"]
["BIN","REGION","County Name","PRIMARY_OWNER","PRIMARY_OWNER_ID","CARRIED","CROSSED","AADT","DAILY TRUCK TRAFFIC (%)","DETOUR LENGTH (MI)","YEAR BUILT","DECK AREA (SQ FT)","CONDITION RATING","STRUCTRUALLY DEFICIENT","currentwork","POSTED LOAD (TONS)","HYDRAULIC RATING","FRACTURE CRITICAL","DESIGN TYPE","MATERIAL","LBPI","NBI","NBI BIN","NYSDOT CON RATE","NYSDOT CR DATE","Most recent Con","FC","general rec","gen con","Gen con score","actual cond percentile","Gen percentile","nbi sd","SD score","AADT Score","Truck Score","detour score rev","posted score rev","Fracture score","Hydro vuln Score","detour len comp","posted comp",null,"Total Score","UCLBPI"]
["2019580","8","Ulster","42 - City","42","GREENKILL AVENUE","BROADWAY RTE 28 ",3033,1.26,0,1952,2900,3.4060000000000001,"N","cyclical",98,"","Y","15","1",0.45700000000000002,"9","Good",6.5830000000000002,"2019-09-03",6.5830000000000002,"17",7,7,{"$f":"27.5-(AC3*(27.5/7))","v":0},{"$f":"IF(Z3>0,27.5-(_xlfn.PERCENTRANK.EXC(Z:Z,Z3))/(1/27.5),\"\")","v":1.4849999999999994},{"$f":"IF(AC3>0,(27.5-(_xlfn.PERCENTRANK.INC(AC:AC,AC3))/(1/27.5)),\"\")","v":1.6224999999999987},{"$f":"IF(W3=\"Poor\", \"Y\", \"N\")","v":"N"},{"$f":"_xlfn.IFNA((IF(AG3=\"N\",0,5)),\"\")","v":0},{"$f":"_xlfn.IFNA((_xlfn.PERCENTRANK.INC(H:H,H3))/(1/7),\"\")","v":6.5730000000000004},{"$f":"(_xlfn.PERCENTRANK.INC(I:I,I3))/(1/7)","v":0.434},{"$f":"IF(J3=99,13.5,(_xlfn.PERCENTRANK.INC(AO:AO,AO3))/(1/12.5))","v":0},{"$f":"IF(OR(P3=0,P3>97),0,(5-(_xlfn.PERCENTRANK.EXC(AP:AP,AP3))/(1/5)))","v":0},{"$f":"IF(R3=\"Y\",5,0)","v":5},{"$f":"IFERROR((Q3-1),0)","v":0},{"$f":"IF(J3=99,\"\",J3)","v":0},{"$f":"IF(OR(P3=0,P3>97),\"\",P3)","v":""},null,{"$f":"SUM(AN3,AM3,AL3,AK3,AJ3,AI3,AH3,AD3)","v":12.007000000000001},{"$f":"AR3/75","v":0.16009333333333337}]
["2224200","8","Ulster","40 - Town","40","BALACE ROAD     ","RONDOUT CREEK   ",16,4.91,99,2006,1206,6.7229999999999999,"N","cyclical",0,"5","N","03","E",0.13700000000000001,"7","Good",6.4290000000000003,"2018-10-24",6.4290000000000003,"09",6,6,3.9285714285714306,{"$f":"IF(Z4>0,27.5-(_xlfn.PERCENTRANK.EXC(Z:Z,Z4))/(1/27.5),\"\")","v":2.7499999999999964},6.1049999999999969,"N",0,0.45500000000000002,1.9809999999999999,13.5,0,0,4,"","",null,23.864571428571431,{"$f":"AR4/75","v":0.31819428571428576}]
["2224210","8","Ulster","40 - Town","40","CLOVE ROAD      ","COXING KILL     ",228,4.91,6,1930,691,3.4910000000000001,"Y","replace",12,"2","N","21","1",0.56000000000000005,"3","Poor",3.6669999999999998,"2019-04-11",3.6669999999999998,"09",3,3,15.714285714285715,24.1175,27.06,"Y",5,3.367,1.9809999999999999,8.85,3.5300000000000002,0,1,6,12,null,39.442285714285717,0.52589714285714284]
["2224220","8","Ulster","40 - Town","40","CLOVE ROAD","COXING KILL     ",228,4.91,6,1988,690,4.5430000000000001,"N","majorrehab",0,"4","N","27","B",0.25800000000000001,"6","Fair",4.3849999999999998,"2018-04-20",4.3849999999999998,"09",5,5,7.8571428571428577,17.9575,17.16,"N",0,3.367,1.9809999999999999,8.85,0,0,3,6,"",null,25.055142857142858,0.33406857142857144]
["2224230","8","Ulster","40 - Town","40","BARNHART RD     ","BEAVER KILL     ",52,3.85,99,1895,1170,5.3609999999999998,"N","cyclical",0,"4","Y","09","1",0.11799999999999999,"5","Fair",5,"2018-11-01",5,"09",5,5,7.8571428571428577,12.182499999999997,17.16,"N",0,1.274,0.90300000000000002,13.5,0,5,3,"","",null,31.534142857142857,0.4204552380952381]
["2224240","8","Ulster","40 - Town","40","MILL BROOK ROAD ","MILL BROOK      ",42,10.53,2,1933,750,4.1230000000000002,"Y","majorrehab",0,"3","N","09","2",0.36099999999999999,"4","Poor",3.9470000000000001,"2019-04-01",3.9470000000000001,"09",3,3,15.714285714285715,21.477499999999999,27.06,"Y",5,1.0780000000000001,6.8530000000000006,4.8125,0,0,2,2,"",null,35.45778571428572,0.47277047619047624]
["2224250","8","Ulster","40 - Town","40","MILL BROOK ROAD","BELLE AYR BROOK ",42,10.53,25,1926,405,3.0979999999999999,"Y","replace",0,"4","N","12","1",0.53300000000000003,"3","Poor",7,"2019-10-11",7,"09",7,7,0,0.35749999999999815,1.6224999999999987,"N",0,1.0780000000000001,6.8530000000000006,11.7125,0,0,3,25,"",null,22.6435,0.30191333333333331]
["2224260","8","Ulster","40 - Town","40","MILL BROOK ROAD ","MILL BROOK",42,10.53,15,2000,444,5.6669999999999998,"N","cyclical",0,"5","N","40","B",5.2999999999999999E-2,"6","Fair",5,"2018-10-11",5,"09",5,5,7.8571428571428577,12.182499999999997,17.16,{"$f":"IF(W10=\"Poor\", \"Y\", \"N\")","v":"N"},0,1.0780000000000001,6.8530000000000006,11.1875,0,0,4,15,"",null,30.975642857142859,0.41300857142857145]
["2224300","8","Ulster","40 - Town","40","OLD ROUTE 209   ","KRIPPLEBUSH CREEK",null,1,1,1927,900,3.5710000000000002,"Y","majorrehab",0,"4","N","01","B",0.41799999999999998,"4","Poor",3.1429999999999998,"2019-06-14",3.1429999999999998,"09",4,4,11.785714285714286,26.1525,24.75,"Y",5,"",0.25900000000000001,0.77500000000000002,0,0,3,1,"",null,20.819714285714284,0.27759619047619044]
["2224430","8","Ulster","40 - Town","40","MILL HOOK ROAD  ","MILL STREAM",69,4.91,1,1948,500,4.1929999999999996,"Y","majorrehab",14,"3","N","09","1",0.40400000000000003,"4","Poor",3.6920000000000002,"2019-11-07",3.6920000000000002,"09",3,3,15.714285714285715,23.759999999999998,27.06,"Y",5,1.6310000000000002,1.9809999999999999,0.77500000000000002,3.24,0,2,1,14,null,30.341285714285718,0.40455047619047624]
["2224440","8","Ulster","40 - Town","40","STONY KILL ROAD ","STONY KILL      ",301,4.91,1,1988,1196,5.2629999999999999,"N","deckrepl",0,"5","N","09","1",0.02,"5","Fair",5.7309999999999999,"2019-03-28",5.7309999999999999,"09",5,5,7.8571428571428577,6.379999999999999,17.16,"N",0,3.8570000000000007,1.9809999999999999,0.77500000000000002,0,0,4,1,"",null,18.470142857142861,0.24626857142857148]
["2224450","8","Ulster","40 - Town","40","BRIDGE ROAD     ","STONY KILL      ",36,3.92,1,1955,664,3.577,"Y","majorrehab",20,"2","N","09","1",0.502,"4","Poor",3.577,"2019-04-24",3.577,"19",3,3,15.714285714285715,24.6675,27.06,"Y",5,0.88200000000000001,0.95900000000000007,0.77500000000000002,1.3250000000000002,0,1,1,20,null,25.655285714285714,0.3420704761904762]
["2224460","8","Ulster","40 - Town","40","BOICE MILL ROAD ","FALLS MILL BROOK",149,4.91,1,1988,1000,2.9649999999999999,"Y","majorrehab",13,"4","N","09","1",0.54400000000000004,"4","Poor",2.93,"2019-04-25",2.93,"09",3,3,15.714285714285715,26.482500000000002,27.06,"Y",{"$f":"_xlfn.IFNA((IF(AG15=\"N\",0,5)),\"\")","v":5},2.6110000000000002,1.9809999999999999,0.77500000000000002,3.3849999999999998,0,3,1,13,null,32.466285714285718,0.43288380952380956]
["2224470","8","Ulster","40 - Town","40","WATER FALLS ROAD","MOMBACCUS CREEK ",54,7.41,2,1955,725,4.0350000000000001,"N","majorrehab",0,"4","N","09","1",0.30399999999999999,"4","Poor",3.6840000000000002,"2019-04-09",3.6840000000000002,"09",4,4,11.785714285714286,23.87,24.75,"Y",5,1.302,6.3840000000000003,4.8125,0,0,3,2,"",null,32.284214285714285,0.43045619047619044]
["2224480","8","Ulster","40 - Town","40","SUNDOWN ROAD    ","WYNCOOP CREEK",202,4.91,2,1962,518,4.5439999999999996,"N","majorrehab",0,"2","N","09","1",0.27300000000000002,"4","Poor",4.0529999999999999,"2019-08-20",4.0529999999999999,"09",4,4,11.785714285714286,20.7075,24.75,"Y",5,3.1010000000000004,1.9809999999999999,4.8125,0,0,1,2,"",null,27.680214285714285,0.36906952380952379]
["2224510","8","Ulster","40 - Town","40","ROCK HILL ROAD  ","PETERS KILL     ",41,4.91,3,2011,807,5.2809999999999997,"N","vertdown",0,"4","N","09","1",2.1999999999999999E-2,"7","Good",4.9820000000000002,"2019-10-01",4.9820000000000002,"09",5,5,7.8571428571428577,12.292499999999999,17.16,"N",0,1.0429999999999999,1.9809999999999999,6.4375,0,0,3,3,"",null,20.318642857142855,0.27091523809523804]
["2224520","8","Ulster","40 - Town","40","PROJECT 32 ROAD ","STONY KILL      ",64,4.91,2,1955,853,3.9620000000000002,"Y","majorrehab",19,"4","Y","09","1",0.41299999999999998,"5","Fair",3.86,"2019-04-24",3.86,"09",4,4,11.785714285714286,22.7425,24.75,"N",0,1.47,1.9809999999999999,4.8125,1.4750000000000005,5,3,2,19,null,29.524214285714287,0.39365619047619049]
["2224530","8","Ulster","40 - Town","40","DRUMMOND FALLS RD","KAATERSKILL CREEK",285,4.91,1,1884,798,4.149,"Y","majorrehab",10,"4","Y","09","1",0.437,"4","Poor",4.0220000000000002,"2019-07-16",4.0220000000000002,"09",4,4,11.785714285714286,20.817499999999999,24.75,"Y",5,3.7940000000000005,1.9809999999999999,0.77500000000000002,3.9750000000000001,5,3,1,10,null,35.310714285714283,0.47080952380952379]
["2224540","8","Ulster","40 - Town","40","CHARLES SMITH RD","KAATERSKILL CREEK",235,4.91,3,1985,2616,5.476,"N","cyclical",0,"5","N","13","1",2.4E-2,"7","Good",5.7140000000000004,"2019-05-30",5.7140000000000004,"09",5,5,7.8571428571428577,6.5999999999999979,17.16,"N",0,3.5,1.9809999999999999,6.4375,0,0,4,3,"",null,23.775642857142856,0.31700857142857142]
["2224560","8","Ulster","40 - Town","40","SILVER HOLLOW RD","STONY CLOVE CREEK",183,4.91,1,1985,2140,5.42,"N","cyclical",0,"5","N","03","E",0.09,"6","Fair",5.5709999999999997,"2019-04-22",5.5709999999999997,"09",6,6,3.9285714285714306,7.5075000000000003,6.1049999999999969,"N",0,2.8420000000000005,1.9809999999999999,0.77500000000000002,0,0,4,1,"",null,13.526571428571431,0.18035428571428574]
["2224570","8","Ulster","40 - Town","40","BROAD ST HLW ROAD","BROAD ST HOLLW BK",187,4.91,99,1987,1375,5.6070000000000002,"N","cyclical",0,"4","N","09","1",7.0000000000000007E-2,"5","Fair",5.75,"2019-04-01",5.75,"09",5,5,7.8571428571428577,6.1599999999999966,17.16,"N",0,2.94,1.9809999999999999,13.5,0,0,3,"","",null,29.278142857142861,0.39037523809523816]
["2224600","8","Ulster","40 - Town","40","FAWN HILL ROAD","WOODLAND CREEK",32,4.91,99,1988,1520,3.5259999999999998,"Y","majorrehab",15,"4","N","09","1",0.52100000000000002,"4","Poor",3.86,"2019-08-20",3.86,"09",4,4,11.785714285714286,22.7425,24.75,"Y",5,0.81200000000000006,1.9809999999999999,13.5,2.9450000000000003,0,3,"",15,null,39.023714285714291,0.5203161904761906]
["2224620","8","Ulster","40 - Town","40","EAGLE MOUNTAIN RD","ESOPUS CREEK    ",2,4.91,99,1903,992,5.9809999999999999,"N","cyclical",20,"4","N","09","1",0.11700000000000001,"5","Fair",5.577,"2018-08-27",5.577,"09",5,5,7.8571428571428577,7.3975000000000009,17.16,"N",0,0.126,1.9809999999999999,13.5,1.3250000000000002,0,3,"",20,null,27.789142857142856,0.37052190476190477]
["2224650","8","Ulster","40 - Town","40","CHURCH ROAD     ","TRIB ESOPUS CREEK",8,4.91,10,1998,676,3.6669999999999998,"Y","majorrehab",0,"4","N","09","1",0.39200000000000002,"3","Poor",3.4289999999999998,"2019-06-06",3.4289999999999998,"09",3,3,15.714285714285715,25.135000000000002,27.06,"Y",5,0.25900000000000001,1.9809999999999999,10.5375,0,0,3,10,"",null,36.491785714285712,0.4865571428571428]
["2224670","8","Ulster","40 - Town","40","MOUNTAIN ROAD   ","BEAVER BROOK    ",192,4.91,2,1995,800,6.6669999999999998,"N","cyclical",0,"4","N","27","B",3.6999999999999998E-2,"7","Good",5.6360000000000001,"2018-04-02",5.6360000000000001,"09",5,5,7.8571428571428577,6.9574999999999996,17.16,"N",0,3.0380000000000003,1.9809999999999999,4.8125,0,0,3,2,"",null,20.68864285714286,0.27584857142857144]
["2224680","8","Ulster","40 - Town","40","RED MILLS ROAD  ","DWAAR KILL      ",1565,4.91,2,1963,800,4.4710000000000001,"N","minorrehab",0,"4","N","09","1",0.1,"5","Fair",4.2389999999999999,"2018-04-09",4.2389999999999999,"09",5,5,7.8571428571428577,19.112499999999997,17.16,"N",0,5.915,1.9809999999999999,4.8125,0,0,3,2,"",null,23.565642857142858,0.31420857142857145]
["2224690","8","Ulster","40 - Town","40","JOHNS ESTATE ROAD","VERKEERDER KILL ",579,4.91,1,2004,1140,5.8150000000000004,"N","cyclical",0,"4","N","27","B",3.6999999999999998E-2,"6","Fair",5.5449999999999999,"2018-04-04",5.5449999999999999,"09",5,5,7.8571428571428577,7.8649999999999984,17.16,"N",0,4.97,1.9809999999999999,0.77500000000000002,0,0,3,1,"",null,18.583142857142857,0.24777523809523808]
["2224700","8","Ulster","40 - Town","40","ULSTERVILLE ROAD","VERKEERDER KILL ",1419,4.91,2,1989,1144,4.9820000000000002,"N","cyclical",0,"2","N","36","1",6.7000000000000004E-2,"6","Fair",4.9119999999999999,"2018-05-18",4.9119999999999999,"09",5,5,7.8571428571428577,12.732499999999998,17.16,"N",0,5.7190000000000003,1.9809999999999999,4.8125,0,0,1,2,"",null,21.369642857142857,0.28492857142857142]
["2224720","8","Ulster","40 - Town","40","JANSEN ROAD","BEAVER BROOK    ",653,4.91,1,1988,995,4.7190000000000003,"N","majorrehab",0,"4","N","09","1",0.21,"5","Fair",4.5380000000000003,"2018-04-09",4.5380000000000003,"09",5,5,7.8571428571428577,16.61,17.16,"N",0,5.0330000000000004,1.9809999999999999,0.77500000000000002,0,0,3,1,"",null,18.646142857142859,0.24861523809523811]
["2224730","8","Ulster","40 - Town","40","BATES LANE      ","DWAAR KILL      ",215,4.91,3,1992,1254,5.6559999999999997,"N","cyclical",0,"3","N","36","1",4.9000000000000002E-2,"6","Fair",5.1429999999999998,"2018-04-12",5.1429999999999998,"09",5,5,7.8571428571428577,10.697499999999998,17.16,"N",0,3.1710000000000003,1.9809999999999999,6.4375,0,0,2,3,"",null,21.446642857142859,0.2859552380952381]
["2224760","8","Ulster","40 - Town","40","OLD ROUTE 209   ","SANDBURG CREEK  ",500,4.91,1,1988,2144,5.05,"N","cyclical",0,"5","N","09","1",2.1999999999999999E-2,"6","Fair",5.55,"2019-04-23",5.55,"09",5,5,7.8571428571428577,7.7274999999999991,17.16,"N",0,4.7040000000000006,1.9809999999999999,0.77500000000000002,0,0,4,1,"",null,19.317142857142859,0.25756190476190477]
["2224790","8","Ulster","40 - Town","40","PORT BEN ROAD   ","RONDOUT CREEK   ",318,3.92,2,1915,3700,3.78,"Y","replace",4,"4","Y","18","1",0.52500000000000002,"4","Poor",3.6669999999999998,"2019-09-06",3.6669999999999998,"19",3,3,15.714285714285715,24.1175,27.06,"Y",5,3.9200000000000004,0.95900000000000007,4.8125,4.5600000000000005,5,3,2,4,null,42.965785714285715,0.57287714285714286]
["2224800","8","Ulster","40 - Town","40","COLD BROOK ROAD ","LITTLE BEAVER KL",379,4.91,7,1930,860,4.3680000000000003,"N","minorrehab",0,"4","N","09","1",0.11899999999999999,"5","Fair",4.4809999999999999,"2018-09-27",4.4809999999999999,"09",5,5,{"$f":"27.5-(AC35*(27.5/7))","v":7.8571428571428577},17.049999999999997,17.16,"N",0,4.1159999999999997,1.9809999999999999,9.2999999999999989,0,0,3,7,"",null,26.254142857142856,0.35005523809523809]
["2224830","8","Ulster","40 - Town","40","CHESTNUT HILL RD","SAW KILL        ",253,4.91,1,1979,1053,6.3970000000000002,"N","cyclical",0,"4","N","09","1",0.02,"6","Fair",6.5,"2019-03-12",6.5,"09",6,6,3.9285714285714306,2.0624999999999964,6.1049999999999969,"N",0,3.528,1.9809999999999999,0.77500000000000002,0,0,3,1,"",null,13.212571428571431,0.17616761904761907]
["2224840","8","Ulster","40 - Town","40","YERRY HILL ROAD ","SAW KILL        ",385,4.91,3,1996,2444,5.6890000000000001,"N","cyclical",0,"4","Y","19","2",0.104,"6","Fair",5.0359999999999996,"2018-06-21",5.0359999999999996,"09",6,6,3.9285714285714306,11.605,6.1049999999999969,"N",0,4.2490000000000006,1.9809999999999999,6.4375,0,5,3,3,"",null,24.596071428571435,0.32794761904761915]
["2224860","8","Ulster","40 - Town","40","MCDANIEL ROAD   ","SAW KILL        ",205,4.91,7,2016,1080,3.98,"Y","majorrehab",null,"4","N","09","1",0.372,"7","Good",6.5250000000000004,"2019-05-28",6.5250000000000004,"09",6,6,3.9285714285714306,1.952499999999997,6.1049999999999969,"N",0,3.1360000000000001,1.9809999999999999,9.2999999999999989,0,0,3,7,"",null,21.345571428571429,0.28460761904761905]
["2224870","8","Ulster","40 - Town","40","EIGHMEY ROAD    ","SILVER HOLLOW   ",172,4.91,1,1934,690,5.766,"N","majorrehab",0,"5","N","01","E",0.189,"6","Fair",5.7140000000000004,"2018-10-11",5.7140000000000004,"09",6,6,3.9285714285714306,6.5999999999999979,6.1049999999999969,"N",0,2.7790000000000004,1.9809999999999999,0.77500000000000002,0,0,4,1,"",null,13.463571428571431,0.17951428571428574]
["2224880","8","Ulster","40 - Town","40","MINK HOLLOW ROAD","BEAVER KILL     ",232,4.91,99,1920,885,4.2750000000000004,"Y","majorrehab",15,"3","N","09","1",0.44500000000000001,"4","Poor",3.9609999999999999,"2019-04-03",3.9609999999999999,"09",3,3,15.714285714285715,21.3675,27.06,"Y",5,3.4650000000000003,1.9809999999999999,13.5,2.9450000000000003,0,2,"",15,null,44.605285714285714,0.59473714285714285]
["2262930","8","Ulster","40 - Town","40","MILLIE EDWARDS RD","ALDER CREEK     ",8,4.91,99,1994,432,6,"N","cyclical",0,"4","N","27","B",8.2000000000000003E-2,"5","Fair",6,"2018-08-24",6,"09",5,5,7.8571428571428577,4.8949999999999996,17.16,"N",0,0.25900000000000001,1.9809999999999999,13.5,0,0,3,"","",null,26.59714285714286,0.35462857142857146]
["2262960","8","Ulster","40 - Town","40","VAN HOAGLAND ROAD","MINK HOLLOW CREEK",10,4.91,99,2012,500,6.9349999999999996,"N","cyclical",0,"4","Y","21","1",0.152,"8","Good",6.93,"2018-06-12",6.93,"09",6,6,3.9285714285714306,0.46749999999999758,6.1049999999999969,"N",0,0.35699999999999998,1.9809999999999999,13.5,0,5,3,"","",null,27.766571428571432,0.37022095238095243]
["2262970","8","Ulster","41 - Village","41","HICKORY STREET  ","BEER KILL       ",430,3.92,1,1970,2315,6.3040000000000003,"N","cyclical",null,"4","N","13","1",2.1000000000000001E-2,"6","Fair",6.218,"2018-09-12",6.218,"19",6,6,3.9285714285714306,3.5474999999999994,6.1049999999999969,"N",0,4.4800000000000004,0.95900000000000007,0.77500000000000002,0,0,3,1,"",null,13.142571428571431,0.17523428571428576]
["2262980","8","Ulster","41 - Village","41","CLINTON AVENUE","NORTH GULLY     ",1090,3.92,1,1966,1300,3.8250000000000002,"Y","majorrehab",0,"3","N","09","1",0.42699999999999999,"4","Poor",3.81,"2018-04-17",3.81,"19",4,4,11.785714285714286,22.852499999999999,24.75,"Y",5,5.6210000000000004,0.95900000000000007,0.77500000000000002,0,0,2,1,"",null,26.140714285714289,0.34854285714285721]
["2264100","8","Ulster","40 - Town","40","BLACK CREEK ROAD","BLACK CREEK     ",148,4.91,1,1925,1600,3.0419999999999998,"N","replace",0,"3","N","25","B",0.45800000000000002,"5","Fair",3.5790000000000002,"2018-08-14",3.5790000000000002,"09",4,4,11.785714285714286,24.557500000000001,24.75,"N",0,2.5830000000000002,1.9809999999999999,0.77500000000000002,0,0,2,1,"",null,19.124714285714287,0.25499619047619049]
["2264110","8","Ulster","30 - County","30","CONNELLY ROAD   ","PLANTASIA CREEK ",1519,3.92,1,1983,625,5.3639999999999999,"N","cyclical",0,"5","N","01","B",0.03,"5","Fair",5.4550000000000001,"2018-10-01",5.4550000000000001,"19",5,5,7.8571428571428577,9.2124999999999986,17.16,"N",0,5.8170000000000002,0.95900000000000007,0.77500000000000002,0,0,4,1,"",null,19.408142857142856,0.25877523809523806]
["2264130","8","Ulster","40 - Town","40","AUMICK ROAD     ","PALMAGHATT KILL ",174,4.91,1,1987,853,5.07,"N","maintproject",0,"5","N","09","1",0.02,"5","Fair",4.6840000000000002,"2018-05-16",4.6840000000000002,"09",4,4,11.785714285714286,14.904999999999999,24.75,"N",0,2.8070000000000004,1.9809999999999999,0.77500000000000002,0,0,4,1,"",null,21.348714285714287,0.28464952380952385]
["2264170","8","Ulster","40 - Town","40","STONEY CLOVE ROAD","STONY CLOVE CREEK",64,4.91,99,1965,700,3.6669999999999998,"N","replace",0,"4","N","41","1",0.42599999999999999,{"$error":"#N/A"},{"$error":"#N/A"},3,"2018-06-06",3,"09",4,4,11.785714285714286,26.372499999999999,24.75,null,5,1.47,1.9809999999999999,13.5,0,0,3,"","",null,36.736714285714285,0.48982285714285712]
["2264230","8","Ulster","40 - Town","40","RIVER ROAD","TWAALFSKILL CREEK",221,3.92,1,2006,700,6.0739999999999998,"N","cyclical",0,"4","N","27","B",3.5000000000000003E-2,"7","Good",6.2729999999999997,"2018-12-05",6.2729999999999997,"19",6,6,3.9285714285714306,3.0799999999999983,6.1049999999999969,{"$f":"IF(W49=\"Poor\", \"Y\", \"N\")","v":"N"},0,3.3319999999999999,0.95900000000000007,0.77500000000000002,0,0,3,1,"",null,11.99457142857143,0.15992761904761907]
["2264250","8","Ulster","40 - Town","40","BLACK CREEK ROAD","SWARTE KILL     ",null,1,3,2002,700,6.8520000000000003,"N","cyclical",0,"5","N","42","7",7.0999999999999994E-2,"9","Good",7,"2019-08-30",7,"09",7,7,0,0.35749999999999815,1.6224999999999987,"N",0,"",0.25900000000000001,6.4375,0,0,4,3,"",null,10.6965,0.14262]
["2264260","8","Ulster","40 - Town","40","HARDENBURG ROAD ","SWARTE KILL     ",324,4.91,2,1935,736,5.6109999999999998,"N","cyclical",0,"4","N","27","B",3.6999999999999998E-2,"7","Good",5.3929999999999998,"2019-10-25",5.3929999999999998,"19",6,6,3.9285714285714306,9.68,6.1049999999999969,"N",0,3.9899999999999998,1.9809999999999999,4.8125,0,0,3,2,"",null,17.712071428571431,0.23616095238095242]
["2264270","8","Ulster","40 - Town","40","LAUREN TICE ROAD","SAWYER KILL     ",318,4.91,4,1948,2300,5.9130000000000003,"N","cyclical",0,"4","N","43","B",4.5999999999999999E-2,"5","Fair",6.444,"2018-06-21",6.444,"09",4,4,11.785714285714286,2.2824999999999989,24.75,"N",0,3.9200000000000004,1.9809999999999999,7.4749999999999996,0,0,3,4,"",null,28.161714285714289,0.37548952380952388]
["2264280","8","Ulster","40 - Town","40","ROSE MOUNTAIN RD.","ROSE MOUNTAIN ST",70,4.91,1,1958,600,5.8129999999999997,"N","cyclical",0,"5","N","40","B",2.3E-2,"6","Fair",3.9089999999999998,"2018-08-06",3.9089999999999998,"09",5,5,7.8571428571428577,21.835000000000001,17.16,"N",0,1.6659999999999999,1.9809999999999999,0.77500000000000002,0,0,4,1,"",null,16.279142857142858,0.21705523809523811]
["2264390","8","Ulster","40 - Town","40","BIRCH CREEK ROAD","BIRCH CREEK     ",94,4.91,1,1991,500,2.3330000000000002,"N","replace",0,"4","N","26","7",0.51900000000000002,"4","Poor",1.667,"2019-04-22",1.667,"09",3,3,15.714285714285715,26.592500000000001,27.06,"Y",5,2.1910000000000003,1.9809999999999999,0.77500000000000002,0,0,3,1,"",null,28.661285714285718,0.38215047619047626]
["2264400","8","Ulster","40 - Town","40","HERDMAN ROAD    ","FOX HOLLOW BROOK",25,4.91,99,2005,480,6.6669999999999998,"N","cyclical",null,"4","N","02","E",0.187,"7","Good",6.66,"2018-06-21",6.66,"09",6,6,3.9285714285714306,1.1550000000000011,6.1049999999999969,"N",0,0.51800000000000002,1.9809999999999999,13.5,0,0,3,"","",null,22.927571428571433,0.30570095238095246]
["2264410","8","Ulster","40 - Town","40","ERICSON ROAD    ","DRY BROOK       ",8,0,99,1890,600,5.8849999999999998,"N","cyclical",0,"5","N","09","2",6.2E-2,"6","Fair",6.0750000000000002,"2018-10-11",6.0750000000000002,"09",5,5,7.8571428571428577,3.9875000000000007,17.16,"N",0,0.25900000000000001,0,13.5,0,0,4,"","",null,25.616142857142858,0.34154857142857142]
["2264430","8","Ulster","40 - Town","40","VALLI ROAD      ","BLACK CREEK     ",32,4.91,99,1954,500,4.2939999999999996,"Y","majorrehab",8,"3","N","09","1",0.46200000000000002,"4","Poor",4.2160000000000002,"2019-06-13",4.2160000000000002,"09",3,3,15.714285714285715,19.552500000000002,27.06,"Y",5,0.81200000000000006,1.9809999999999999,13.5,4.415,0,2,"",8,null,43.422285714285721,0.57896380952380966]
["2264440","8","Ulster","40 - Town","40","GEIGER ROAD     ","BEER KILL       ",288,4.91,3,1979,1100,5.8280000000000003,"N","cyclical",0,"5","N","09","1",2.4E-2,"6","Fair",5.3869999999999996,"2019-04-19",5.3869999999999996,"09",5,5,7.8571428571428577,9.7899999999999991,17.16,"N",0,3.8220000000000005,1.9809999999999999,6.4375,0,0,4,3,"",null,24.097642857142858,0.32130190476190479]
["2264450","8","Ulster","40 - Town","40","BARBARA ROAD    ","W BR BEER KILL  ",null,10,99,1965,1200,3.8130000000000002,"Y","majorrehab",0,"4","N","10","1",0.46500000000000002,"5","Fair",3.8639999999999999,"2019-11-01",3.8639999999999999,"19",4,4,11.785714285714286,22.522500000000001,24.75,"N",0,"",6.6150000000000002,13.5,0,0,3,"","",null,34.900714285714287,0.46534285714285717]
["2264460","8","Ulster","40 - Town","40","FOORDEMOOR ROAD ","TRIB ROUNDOUT CRK",2528,4.8499999999999996,1,1976,1000,6.0170000000000003,"N","cyclical",0,"5","N","09","1",2.8000000000000001E-2,"6","Fair",5.7549999999999999,"2018-08-29",5.7549999999999999,"09",5,5,7.8571428571428577,6.0499999999999972,17.16,"N",0,6.3770000000000007,1.806,0.77500000000000002,0,0,4,1,"",null,20.81514285714286,0.27753523809523811]
["2264490","8","Ulster","40 - Town","40","ABAND MILL BK RD","MILL BROOK      ",1,10,0,1898,1000,0,"","N/A",99,"","","18","8",null,{"$error":"#N/A"},{"$error":"#N/A"},0,"1985-05-13",0,{"$error":"#N/A"},1,1,23.571428571428573,"",{"$f":"IF(AC61>0,(27.5-(_xlfn.PERCENTRANK.INC(AC:AC,AC61))/(1/27.5)),\"\")","v":27.17},{"$error":"#N/A"},"",0,6.6150000000000002,0,0,0,0,0,"",null,30.186428571428571,0.40248571428571428]
["2264500","8","Ulster","40 - Town","40","OLO FOORDMORE RD","TRIB TO RNDOUT CK",2528,4.8499999999999996,0,1929,400,0,"","N/A",99,"","","12","1",null,{"$error":"#N/A"},{"$error":"#N/A"},0,"1979-07-17",0,"09",3,3,15.714285714285715,"",27.06,{"$error":"#N/A"},"",6.3770000000000007,1.806,0,0,0,0,0,"",null,23.897285714285715,0.31863047619047619]
["2264510","8","Ulster","40 - Town","40","LAWRENCE ROAD   ","STONY KILL      ",29,4.91,1,1929,500,3.2930000000000001,"Y","majorrehab",3,"4","N","12","1",0.503,"4","Poor",3.609,"2019-05-29",3.609,"09",3,3,15.714285714285715,24.337499999999999,27.06,"Y",5,0.78400000000000003,1.9809999999999999,0.77500000000000002,4.8550000000000004,0,3,1,3,{"$f":"1/5","v":0.2},32.109285714285718,0.42812380952380957]
["2264520","8","Ulster","40 - Town","40","OLD ROUTE 52    ","GULLY SANBURG CK",1,10,0,1915,730,0,"","N/A",99,"6","","12","1",null,{"$error":"#N/A"},{"$error":"#N/A"},0,"2000-05-30",0,{"$error":"#N/A"},4,4,11.785714285714286,"",24.75,{"$error":"#N/A"},"",0,6.6150000000000002,0,0,0,5,0,"",null,23.400714285714287,0.31200952380952385]
["2264530","8","Ulster","40 - Town","40","ABAND CHRYTOWN RD","MOMBACCUS CREEK ",1,10,0,1900,500,0,"","N/A",99,"","","19","1",null,{"$error":"#N/A"},{"$error":"#N/A"},0,"1985-05-20",0,{"$error":"#N/A"},4,4,11.785714285714286,"",24.75,{"$error":"#N/A"},"",0,6.6150000000000002,0,0,0,0,0,"",null,18.400714285714287,0.24534285714285717]
["2264550","8","Ulster","41 - Village","41","BECKLEY DRIVE   ","FANTINE KILL    ",257,3.92,99,1960,702,6.6520000000000001,"N","cyclical",null,"5","N","27","B",8.5000000000000006E-2,"7","Good",6.556,"2018-10-04",6.556,"19",6,6,3.9285714285714306,1.8424999999999976,6.1049999999999969,"N",0,3.5630000000000002,0.95900000000000007,13.5,0,0,4,"","",null,25.950571428571429,0.34600761904761906]
["2267650","8","Ulster","40 - Town","40","MAIN STREET     ","CATHEDRAL GLEN  ",219,4.91,1,1988,1200,4.6589999999999998,"N","maintproject",0,"4","N","44","8",9.1999999999999998E-2,"6","Fair",4.5119999999999996,"2018-05-07",4.5119999999999996,"09",5,5,{"$f":"27.5-(AC67*(27.5/7))","v":7.8571428571428577},16.829999999999998,{"$f":"IF(AC67>0,(27.5-(_xlfn.PERCENTRANK.INC(AC:AC,AC67))/(1/27.5)),\"\")","v":17.16},"N",{"$f":"_xlfn.IFNA((IF(AG67=\"N\",0,5)),\"\")","v":0},{"$f":"_xlfn.IFNA((_xlfn.PERCENTRANK.INC(H:H,H67))/(1/7),\"\")","v":3.2690000000000006},{"$f":"(_xlfn.PERCENTRANK.INC(I:I,I67))/(1/7)","v":1.9809999999999999},{"$f":"IF(J67=99,13.5,(_xlfn.PERCENTRANK.INC(AO:AO,AO67))/(1/12.5))","v":0.77500000000000002},{"$f":"IF(OR(P67=0,P67>97),0,(5-(_xlfn.PERCENTRANK.EXC(AP:AP,AP67))/(1/5)))","v":0},{"$f":"IF(R67=\"Y\",5,0)","v":0},{"$f":"IFERROR((Q67-1),0)","v":3},{"$f":"IF(J67=99,\"\",J67)","v":1},{"$f":"IF(OR(P67=0,P67>97),\"\",P67)","v":""},null,{"$f":"SUM(AN67,AM67,AL67,AK67,AJ67,AI67,AH67,AD67)","v":16.88214285714286},0.22509523809523813]
["2268750","8","Ulster","40 - Town","40","ROSSNER BRIDGE RD","BUSHNELLSVILLE CK",4,4.91,99,1996,454,5.2809999999999997,"N","cyclical",0,"4","N","09","2",6.2E-2,"6","Fair",4.4349999999999996,"2018-06-12",4.4349999999999996,"09",5,5,7.8571428571428577,{"$f":"IF(Z68>0,27.5-(_xlfn.PERCENTRANK.EXC(Z:Z,Z68))/(1/27.5),\"\")","v":17.407499999999999},17.16,"N",0,0.161,1.9809999999999999,13.5,0,0,3,"","",null,26.499142857142861,{"$f":"AR68/75","v":0.35332190476190478}]
["2268940","8","Ulster","40 - Town","40","MILL BROOK ROAD ","MILL BROOK      ",42,10.53,0,1991,1262,5.7370000000000001,"N","majorrehab",0,"4","N","09","1",0.16900000000000001,"5","Fair",5.0960000000000001,"2019-05-23",5.0960000000000001,"09",5,5,7.8571428571428577,10.9175,17.16,"N",0,1.0780000000000001,6.8530000000000006,0,0,0,3,0,"",null,18.788142857142859,0.25050857142857147]
["2269010","8","Ulster","40 - Town","40","MAIN STREET     ","BIRCH CREEK     ",219,4.91,1,1990,1184,5,"N","maintproject",0,"2","N","01","8",0.03,"5","Fair",4.9359999999999999,"2018-04-24",4.9359999999999999,"09",5,5,7.8571428571428577,12.512499999999998,17.16,"N",0,3.2690000000000006,1.9809999999999999,0.77500000000000002,0,0,1,1,"",null,14.882142857142858,0.19842857142857143]
["2269920","8","Ulster","42 - City","42","KINGSTON PT BRDGE","KINGSTN PT LAGOON",null,0,0,1999,460,null,"N","N/A",0,"","N","19","2",null,{"$error":"#N/A"},{"$error":"#N/A"},0,"00:00:00",0,{"$error":"#N/A"},"",null,null,"",{"$f":"IF(AC71>0,(27.5-(_xlfn.PERCENTRANK.INC(AC:AC,AC71))/(1/27.5)),\"\")","v":""},{"$error":"#N/A"},"","",0,0,0,0,0,0,"",null,0,0]
["2270000","8","Ulster","40 - Town","40","PECK HOLLOW ROAD","PECK HOLLOW STRM",null,0,99,1996,660,3.3140000000000001,"Y","majorrehab",20,"4","N","09","1",0.54900000000000004,"4","Poor",3.1739999999999999,"2019-06-25",3.1739999999999999,"09",3,3,{"$f":"27.5-(AC72*(27.5/7))","v":15.714285714285715},26.0425,{"$f":"(27.5-(_xlfn.PERCENTRANK.INC(AC:AC,AC72))/(1/27.5))","v":27.06},"Y",5,"",0,13.5,1.3250000000000002,0,3,"",20,null,38.539285714285711,0.51385714285714279]
["2270010","8","Ulster","40 - Town","40","PECK HOLLOW ROAD","PECK HOLLOW STRM",null,0,0,1950,1800,6.633,"N","cyclical",0,"4","Y","21","1",0.10199999999999999,"8","Good",6.6429999999999998,"2019-12-16",6.6429999999999998,"09",7,7,0,1.2650000000000006,1.6224999999999987,"N",0,"",0,0,0,5,3,0,"",null,8,0.10666666666666667]
["2270020","8","Ulster","40 - Town","40","PECK HOLLOW RD","PECK HOLLOW STRM",null,1,10,1997,530,6,"N","cyclical",20,"4","N","27","B",0.10100000000000001,"5","Fair",5.4809999999999999,"2019-08-30",5.4809999999999999,"09",5,5,7.8571428571428577,8.7724999999999973,17.16,"N",0,"",0.25900000000000001,10.5375,1.3250000000000002,0,3,10,20,null,22.978642857142859,0.3063819047619048]
["2270070","8","Ulster","40 - Town","40","DEER LANE","ESOPUS CREEK OVFL",null,1,99,2009,708,5.3330000000000002,"N","cyclical",0,"3","N","09","1",9.1999999999999998E-2,"5","Fair",4.915,"2019-08-20",4.915,"09",5,5,7.8571428571428577,12.622499999999999,17.16,"N",0,"",0.25900000000000001,13.5,0,0,2,"","",null,23.616142857142858,0.31488190476190475]
["2270080","8","Ulster","40 - Town","40","FOX HOLLOW ROAD","FOX HOLLOW CREEK",83,4.91,99,1995,498,4.569,"N","majorrehab",0,"4","N","09","1",0.27800000000000002,"5","Fair",4.2169999999999996,"2019-10-02",4.2169999999999996,"09",4,4,11.785714285714286,19.442500000000003,24.75,"N",0,1.8970000000000002,1.9809999999999999,13.5,0,0,3,"","",null,32.163714285714285,0.42884952380952379]
["2270130","8","Ulster","40 - Town","40","MOON HAW ROAD","WITTENBERG BROOK",null,0,1,2006,403,4.5,"N","majorrehab",10,"2","N","09","1",0.28599999999999998,"6","Fair",3.7829999999999999,"2019-08-19",3.7829999999999999,"09",5,5,7.8571428571428577,23.32,17.16,"N",0,"",0,0.77500000000000002,3.9750000000000001,0,1,1,10,null,13.607142857142858,0.18142857142857144]
["2270140","8","Ulster","40 - Town","40","Berme Road","Criminal Creek",null,0,1,1992,764,5.125,"N","cyclical",0,"4","N","43","B",3.6999999999999998E-2,"7","Good",4.6360000000000001,"2018-06-22",4.6360000000000001,"19",6,6,3.9285714285714306,15.344999999999999,6.1049999999999969,"N",0,"",0,0.77500000000000002,0,0,3,1,"",null,7.703571428571431,0.10271428571428574]
["2270260","8","Ulster","40 - Town","40","HINKLEY RD","MILL BROOK",null,0,99,2014,512,6.8970000000000002,"N","cyclical",0,"4","N","01","B",7.1999999999999995E-2,"8","Good",6.1820000000000004,"2018-10-10",6.1820000000000004,"09",7,7,0,3.8774999999999977,1.6224999999999987,"N",0,"",0,13.5,0,0,3,"","",null,16.5,0.22]
["2270520","8","Ulster","40 - Town","40","Hudson Valley Rai","Vine Yard Ave",3210,2.94,null,2010,1536,null,"N","N/A",null,"","Y","19","3",null,{"$error":"#N/A"},{"$error":"#N/A"},0,"00:00:00",0,{"$error":"#N/A"},"",0,null,"",27.5,{"$error":"#N/A"},"",6.601,0.58100000000000007,0,0,5,0,0,"",null,12.182,0.16242666666666666]
["2270530","8","Ulster","40 - Town","40","MILE HILL ROAD","Hudson Valley Rail Trail",420,4.55,0,2010,677,6.8520000000000003,"N","cyclical",null,"","N","27","B",3.5000000000000003E-2,"8","Good",6.556,"2018-08-17",6.556,"19",7,7,{"$f":"27.5-(AC81*(27.5/7))","v":0},1.8424999999999976,1.6224999999999987,{"$f":"IF(W81=\"Poor\", \"Y\", \"N\")","v":"N"},0,4.4450000000000003,1.512,0,0,0,0,0,"",null,5.9570000000000007,7.9426666666666673E-2]
["2270700","8","Ulster","40 - Town","40","LOWER BIRCH CRK","BIRCH CREEK",14,4.91,99,2011,1708,6.4489999999999998,"N","cyclical",null,"4","Y","21","1",0.152,"9","Good",6.625,"2019-10-16",6.625,"09",7,7,0,1.375,1.6224999999999987,"N",0,0.42,1.9809999999999999,13.5,0,5,3,"","",null,23.901000000000003,0.31868000000000002]
["2270820","8","Ulster","40 - Town","40","BRADKIN ROAD","Traver Hollow Creek",null,4.91,0,2012,1041,6.3330000000000002,"N","cyclical",null,"5","N","26","7",9.1999999999999998E-2,"8","Good",6,"2018-06-06",6,"09",6,6,3.9285714285714306,4.8949999999999996,6.1049999999999969,"N",0,"",1.9809999999999999,0,0,0,4,0,"",null,9.9095714285714305,0.13212761904761908]
["2270830","8","Ulster","40 - Town","40","KATE YAEGER ROAD","Plattekill Creek",null,4.91,2,2012,473,6.6280000000000001,"N","cyclical",null,"5","Y","03","B",0.124,"8","Good",6.5679999999999996,"2018-08-31",6.5679999999999996,"09",7,7,0,1.5949999999999989,1.6224999999999987,"N",0,"",1.9809999999999999,4.8125,0,5,4,2,"",null,15.7935,0.21057999999999999]
["2346960","8","Ulster","40 - Town","40","ELM ROAD          ","BIRCH CREEK     ",118,4.91,1,1958,2900,3.9129999999999998,"N","majorrehab",0,"4","N","43","B",0.41799999999999998,"6","Fair",4,"2018-07-20",4,"09",5,5,7.8571428571428577,21.2575,17.16,"N",0,2.254,1.9809999999999999,0.77500000000000002,0,0,3,1,"",null,15.867142857142857,0.21156190476190476]
["3025090","8","Ulster","30 - County","30","COUNTY ROAD 47","HATCHERY HOLLOW ",404,6.04,25,1986,1066,5.2460000000000004,"N","majorrehab",0,"4","N","09","1",0.23400000000000001,"4","Poor",4.5609999999999999,"2019-07-17",4.5609999999999999,"08",4,4,11.785714285714286,16.032499999999999,24.75,"Y",5,4.2839999999999998,5.628000000000001,11.7125,0,0,3,25,"",null,41.410214285714289,0.55213619047619056]
["3025100","8","Ulster","30 - County","30","COUNTY ROAD 47  ","LTL MABEN HOLLOW",404,6.04,25,1970,1032,3.8769999999999998,"Y","majorrehab",0,"4","N","09","2",0.434,"7","Good",6.4390000000000001,"2019-06-27",6.4390000000000001,"08",6,6,3.9285714285714306,2.3924999999999983,6.1049999999999969,"N",0,4.2839999999999998,5.628000000000001,11.7125,0,0,3,25,"",null,28.553071428571432,0.38070761904761907]
["3025110","8","Ulster","30 - County","30","COUNTY ROAD 47  ","BISCUIT CREEK   ",146,6.04,25,1972,2100,5.5170000000000003,"Y","majorrehab",0,"2","N","09","1",0.32,"4","Poor",4.66,"2018-06-05",4.66,"08",5,5,7.8571428571428577,15.014999999999999,17.16,"Y",5,2.4849999999999999,5.628000000000001,11.7125,0,0,1,25,"",null,33.682642857142859,0.44910190476190481]
["3025130","8","Ulster","30 - County","30","COUNTY ROAD 47  ","HIGH FALLS BROOK",146,6.04,25,2006,1204,6.6920000000000002,"N","cyclical",0,"4","N","09","1",8.2000000000000003E-2,"6","Fair",6.1920000000000002,"2018-09-04",6.1920000000000002,"08",6,6,3.9285714285714306,3.7674999999999983,6.1049999999999969,"N",0,2.4849999999999999,5.628000000000001,11.7125,0,0,3,25,"",null,26.754071428571432,0.35672095238095242]
["3025140","8","Ulster","30 - County","30","COUNTY ROAD 47  ","FALL BROOK      ",146,6.04,25,1993,1033,4.8150000000000004,"N","cyclical",0,"4","N","27","B",0.122,"5","Fair",5.8890000000000002,"2019-11-21",5.8890000000000002,"08",5,5,7.8571428571428577,5.3624999999999972,17.16,"N",0,2.4849999999999999,5.628000000000001,11.7125,0,0,3,25,"",null,30.682642857142859,0.40910190476190478]
["3041140","8","Ulster","30 - County","30","213 213 86011008","TONGORE BROOK   ",2096,8.3800000000000008,4,1929,2158,4.5670000000000002,"N","cyclical",15,"5","N","25","B",0.20200000000000001,"6","Fair",3.5329999999999999,"2019-08-20",3.5329999999999999,"07",5,5,7.8571428571428577,24.7775,17.16,"N",0,6.1460000000000008,6.5310000000000006,7.4749999999999996,2.9450000000000003,0,4,4,15,null,34.954142857142855,0.46605523809523808]
["3045230","8","Ulster","30 - County","30","299 299 86011060","WALLKILL RIVER  ",12366,2.68,15,2016,5250,5.73,"N","cyclical",null,"4","Y","19","2",0.14000000000000001,"6","Fair",5.569,"2018-11-29",5.569,"02",6,6,3.9285714285714306,7.6174999999999997,6.1049999999999969,"N",0,7,0.52500000000000002,11.1875,0,5,3,15,"",null,30.641071428571429,0.40854761904761905]
["3224180","8","Ulster","30 - County","30","NEW HILL ROAD   ","EAST BRANCH NEVERSINK RIVER",null,4.91,3,1973,1610,5.1689999999999996,"N","vertdown",null,"3","N","09","1",4.5999999999999999E-2,"6","Fair",4.5609999999999999,"2019-10-03",4.5609999999999999,"09",5,5,7.8571428571428577,16.032499999999999,17.16,"N",0,"",1.9809999999999999,6.4375,0,0,2,3,"",null,18.275642857142856,0.24367523809523808]
["3224270","8","Ulster","30 - County","30","NEW PALTZ ROAD CR","HUD VLY RL TRAIL",3370,3.02,2,2011,2952,6.6470000000000002,"N","cyclical",0,"","N","26","7",0.13200000000000001,"8","Good",6.4349999999999996,"2019-07-18",6.4349999999999996,"17",7,7,0,2.639999999999997,1.6224999999999987,"N",0,6.6360000000000001,0.60899999999999999,4.8125,0,0,0,2,"",null,12.057500000000001,0.16076666666666667]
["3224280","8","Ulster","30 - County","30","NEW PALTZ ROAD CR","HUD VALLY RL TRAI",3469,4.79,1,2011,3200,6.4290000000000003,"N","cyclical",0,"","N","26","7",0.13100000000000001,"8","Good",6.4349999999999996,"2019-07-11",6.4349999999999996,"17",7,7,0,2.639999999999997,1.6224999999999987,"N",0,6.6710000000000003,1.7150000000000001,0.77500000000000002,0,0,0,1,"",null,9.1610000000000014,0.12214666666666668]
["3224810","8","Ulster","30 - County","30","JOHN JOY ROAD","SAW KILL        ",1052,4.91,1,1975,2700,5.194,"N","cyclical",0,"4","N","09","1",2.4E-2,"6","Fair",5.07,"2018-08-15",5.07,"19",5,5,7.8571428571428577,11.385000000000002,17.16,"N",0,5.5230000000000006,1.9809999999999999,0.77500000000000002,0,0,3,1,"",null,19.136142857142858,0.25514857142857145]
["3346360","8","Ulster","30 - County","30","COUNTY ROAD 46","DEAN BROOK",337,4.91,10,2001,781,4.93,"N","majorrehab",0,"4","N","09","2",0.19400000000000001,"5","Fair",4.6150000000000002,"2019-08-28",4.6150000000000002,"09",4,4,11.785714285714286,15.592499999999999,24.75,"N",0,4.0529999999999999,1.9809999999999999,10.5375,0,0,3,10,"",null,31.357214285714285,0.41809619047619045]
["3346370","8","Ulster","30 - County","30","CR 42","BUSHKILL CREEK  ",712,6.04,27,1993,6150,6.3230000000000004,"N","cyclical",0,"4","N","13","2",0.08,"5","Fair",6.0469999999999997,"2018-10-05",6.0469999999999997,"08",6,6,3.9285714285714306,4.0975000000000001,6.1049999999999969,"N",0,5.0960000000000001,5.628000000000001,12.1625,0,0,3,27,"",null,29.815071428571432,0.39753428571428578]
["3346380","8","Ulster","30 - County","30","HANG GLIDER ROAD","SANDBURG CREEK  ",74,4.91,99,1929,1515,4.5609999999999999,"Y","majorrehab",0,"3","N","09","1",0.35399999999999998,"2","Poor",4.9039999999999999,"2019-04-09",4.9039999999999999,"09",4,4,11.785714285714286,12.979999999999999,24.75,"Y",5,1.7290000000000001,1.9809999999999999,13.5,0,0,2,"","",null,35.995714285714286,0.47994285714285712]
["3346390","8","Ulster","30 - County","30","HURLEY MOUNTAIN ROAD","STONY CREEK     ",1004,4.8499999999999996,14,1988,733,5,"N","cyclical",0,"4","N","43","B",8.4000000000000005E-2,"6","Fair",5,"2018-03-21",5,"08",5,5,7.8571428571428577,12.182499999999997,17.16,"N",0,5.4600000000000009,1.806,11.0625,0,0,3,14,"",null,29.185642857142859,0.3891419047619048]
["3346400","8","Ulster","30 - County","30","OREGON TRAIL    ","VERKEERDER KILL ",506,4.91,4,2001,928,4.9470000000000001,"N","cyclical",0,"3","N","09","2",5.5E-2,"4","Poor",4.4039999999999999,"2019-10-16",4.4039999999999999,"09",4,4,11.785714285714286,17.737500000000001,24.75,"Y",5,4.7390000000000008,1.9809999999999999,7.4749999999999996,0,0,2,4,"",null,32.980714285714285,0.43974285714285716]
["3346410","8","Ulster","30 - County","30","BOODLE HOLE ROAD","ROCHESTER CREEK ",218,4.91,4,1997,1665,5.2809999999999997,"N","majorrehab",0,"4","Y","10","2",0.25600000000000001,"5","Fair",4.5380000000000003,"2018-04-24",4.5380000000000003,"09",4,4,11.785714285714286,16.61,24.75,"N",0,3.1990000000000003,1.9809999999999999,7.4749999999999996,0,5,3,4,"",null,32.440714285714286,0.43254285714285712]
["3346420","8","Ulster","30 - County","30","WOODLAND VLY ROAD","WOODLAND CREEK  ",563,4.91,99,1999,4396,5.5709999999999997,"N","cyclical",0,"5","N","13","2",6.7000000000000004E-2,"8","Good",5.7869999999999999,"2019-05-15",5.7869999999999999,"09",5,5,7.8571428571428577,5.8024999999999984,17.16,"N",0,4.8719999999999999,1.9809999999999999,13.5,0,0,4,"","",null,32.210142857142856,0.42946857142857142]
["3346430","8","Ulster","30 - County","30","SPORTSMANS ROAD","RONDOUT CREEK   ",149,4.91,3,1931,1900,5.1769999999999996,"Y","majorrehab",3,"4","Y","19","1",0.378,"3","Poor",3.7890000000000001,"2019-06-25",3.7890000000000001,"09",3,3,15.714285714285715,23.182500000000001,27.06,"Y",5,2.6110000000000002,1.9809999999999999,6.4375,4.8550000000000004,5,3,3,3,null,44.598785714285711,0.59465047619047617]
["3346450","8","Ulster","30 - County","30","QUEENS HIGHWAY  ","FALLS MILL BROOK",2072,4.9800000000000004,2,1994,1474,5.4809999999999999,"N","cyclical",0,"4","N","09","2",2.4E-2,"5","Fair",5.4809999999999999,"2018-09-19",5.4809999999999999,"09",5,5,7.8571428571428577,8.7724999999999973,17.16,"N",0,6.0830000000000002,5.3620000000000001,4.8125,0,0,3,2,"",null,27.114642857142858,0.36152857142857142]
["3346460","8","Ulster","30 - County","30","SHEELY ROAD     ","SUNDOWN CREEK   ",40,10,1,1995,918,5.8250000000000002,"N","cyclical",0,"4","N","09","2",1.4E-2,"6","Fair",6.0380000000000003,"2019-08-28",6.0380000000000003,"09",6,6,3.9285714285714306,4.2074999999999996,6.1049999999999969,"N",0,0.98000000000000009,6.6150000000000002,0.77500000000000002,0,0,3,1,"",null,15.298571428571432,0.20398095238095243]
["3346470","8","Ulster","30 - County","30","DOUG RD","ROCHESTER CREEK ",65,4.91,3,1996,1248,4.702,"N","deckrepl",0,"5","N","09","2",5.8000000000000003E-2,"5","Fair",5.077,"2019-04-11",5.077,"09",4,4,11.785714285714286,11.274999999999999,24.75,"N",0,1.5680000000000001,1.9809999999999999,6.4375,0,0,4,3,"",null,25.772214285714284,0.34362952380952377]
["3346480","8","Ulster","30 - County","30","INSTITUTION ROAD","RONDOUT CREEK   ",1850,3.92,5,1934,4209,5.5410000000000004,"N","majorrehab",0,"5","Y","15","2",0.26300000000000001,"6","Fair",4.6959999999999997,"2018-09-26",4.6959999999999997,"19",5,5,7.8571428571428577,14.547499999999999,17.16,"N",0,6.0129999999999999,0.95900000000000007,8.1374999999999993,0,5,4,5,"",null,31.966642857142855,0.42622190476190475]
["3346490","8","Ulster","30 - County","30","PEEKAMOOSE ROAD"," RONDOUT CREEK  ",91,6.04,27,2006,1526,5.8419999999999996,"N","cyclical",0,"4","N","09","1",8.2000000000000003E-2,"7","Good",5.8460000000000001,"2018-06-01",5.8460000000000001,"08",6,6,3.9285714285714306,5.582499999999996,6.1049999999999969,"N",0,2.0579999999999998,5.628000000000001,12.1625,0,0,3,27,"",null,26.777071428571432,0.35702761904761909]
["3346500","8","Ulster","30 - County","30","PEEKAMOOSE ROAD","BUTTERMILK FALLS BROOK",91,6.04,27,1929,844,5.93,"N","majorrehab",null,"2","N","09","2",0.315,"5","Fair",6.2119999999999997,"2019-11-15",6.2119999999999997,"08",5,5,7.8571428571428577,3.6574999999999989,17.16,"N",0,2.0579999999999998,5.628000000000001,12.1625,0,0,1,27,"",null,28.705642857142859,0.38274190476190478]
["3346510","8","Ulster","30 - County","30","COUNTY ROAD 30  ","SAW KILL        ",2338,3.49,8,1931,1300,4.2460000000000004,"N","majorrehab",0,"4","N","09","2",0.30499999999999999,"4","Poor",3.351,"2019-07-29",3.351,"08",3,3,15.714285714285715,25.822500000000002,27.06,"Y",5,6.2790000000000008,0.63700000000000001,9.6999999999999993,0,0,3,8,"",null,40.330285714285715,0.53773714285714291]
["3346530","8","Ulster","30 - County","30","COUNTY ROAD 77","RONDOUT CREEK   ",2528,4.8499999999999996,1,2011,7119,5.4409999999999998,"N","cyclical",0,"4","N","03","E",9.8000000000000004E-2,"6","Fair",5.4779999999999998,"2019-05-14",5.4779999999999998,"09",6,6,3.9285714285714306,8.9924999999999962,6.1049999999999969,"N",0,6.3770000000000007,1.806,0.77500000000000002,0,0,3,1,"",null,15.886571428571431,0.21182095238095242]
["3346540","8","Ulster","30 - County","30","DRY BROOK ROAD","HAYNES HOLLOW STREAM",27,4.76,99,1929,929,5.1150000000000002,"N","minorrehab",0,"4","N","09","2",6.2E-2,"6","Fair",4.1920000000000002,"2018-06-07",4.1920000000000002,"09",5,5,{"$f":"27.5-(AC113*(27.5/7))","v":7.8571428571428577},20.02,17.16,{"$f":"IF(W113=\"Poor\", \"Y\", \"N\")","v":"N"},0,0.58800000000000008,1.54,13.5,0,0,3,"","",null,26.485142857142858,0.35313523809523811]
["3346550","8","Ulster","30 - County","30","LAKE ROAD       ","PALMAGHATT KILL ",218,4.91,1,2005,1084,5.3860000000000001,"N","deckrepl",0,"5","N","09","2",1.4999999999999999E-2,"5","Fair",4.7720000000000002,"2019-09-17",4.7720000000000002,"09",5,5,7.8571428571428577,13.75,17.16,"N",0,3.1990000000000003,1.9809999999999999,0.77500000000000002,0,0,4,1,"",null,17.812142857142859,0.23749523809523812]
["3346560","8","Ulster","30 - County","30","COUNTY ROAD 7","KLYNE KILL      ",2342,6.25,5,2006,1680,5.7370000000000001,"N","cyclical",0,"4","N","09","1",0.05,"6","Fair",5.9809999999999999,"2018-11-14",5.9809999999999999,"08",6,6,3.9285714285714306,5.004999999999999,6.1049999999999969,"N",0,6.3070000000000004,6.2370000000000001,8.1374999999999993,0,0,3,5,"",null,27.61007142857143,0.36813428571428575]
["3346570","8","Ulster","30 - County","30","COUNTY ROAD 31","PLATTEKILL CREEK",5959,5.62,5,1931,3874,5.7370000000000001,"N","maintproject",null,"4","Y","21","1",0.156,"6","Fair",5.3860000000000001,"2019-06-27",5.3860000000000001,"17",5,5,7.8571428571428577,9.8999999999999986,17.16,"N",0,6.9300000000000006,5.4810000000000008,8.1374999999999993,0,5,3,5,"",null,36.405642857142858,0.48540857142857147]
["3346580","8","Ulster","30 - County","30","SUNDALE ROAD","METTACHONTS CREEK",null,10,4,1929,1627,4.351,"N","deckrepl",null,"4","N","09","1",0.112,"5","Fair",4.0190000000000001,"2018-08-07",4.0190000000000001,"09",5,5,7.8571428571428577,20.927500000000002,17.16,"N",0,"",6.6150000000000002,7.4749999999999996,0,0,3,4,"",null,24.947142857142858,0.33262857142857144]
["3346590","8","Ulster","30 - County","30","PEEKAMOOSE ROAD","RONDOUT CREEK   ",91,6.04,27,2003,1596,3.9220000000000002,"Y","deckrepl",0,"5","N","09","2",0.27500000000000002,"4","Poor",3.423,"2018-09-27",3.423,"08",4,4,11.785714285714286,25.245000000000001,24.75,"Y",5,2.0579999999999998,5.628000000000001,12.1625,0,0,4,27,"",null,40.634214285714286,0.54178952380952383]
["3346600","8","Ulster","30 - County","30","KINGS HIGHWAY   ","KRIPPLEBUSH CREEK",487,4.91,1,1990,1508,5.07,"N","minorrehab",0,"3","N","09","1",2.1999999999999999E-2,"5","Fair",5.1349999999999998,"2018-09-11",5.1349999999999998,"09",5,5,7.8571428571428577,10.807500000000001,17.16,"N",0,4.6760000000000002,1.9809999999999999,0.77500000000000002,0,0,2,1,"",null,17.289142857142856,0.23052190476190476]
["3346610","8","Ulster","30 - County","30","Cutler Road","VERNOOY KILL",null,3.92,1,1955,1452,5.9420000000000002,"N","maintproject",0,"4","N","09","1",1.7000000000000001E-2,"6","Fair",6.25,"2018-11-02",6.25,"19",6,6,3.9285714285714306,3.1899999999999977,6.1049999999999969,"N",0,"",0.95900000000000007,0.77500000000000002,0,0,3,1,"",null,8.6625714285714306,0.11550095238095241]
["3346640","8","Ulster","30 - County","30","ALBANY POST ROAD","SHAWANGUNK KILL ",2503,5.85,1,1992,5832,5.7809999999999997,"N","vertdown",0,"5","N","13","2",3.6999999999999998E-2,"7","Good",5.484,"2019-10-15",5.484,"08",6,6,3.9285714285714306,8.4149999999999991,6.1049999999999969,"N",0,6.3420000000000005,5.6000000000000005,0.77500000000000002,0,0,4,1,"",null,20.645571428571429,0.27527428571428575]
["3346650","8","Ulster","30 - County","30","COUNTY ROAD 27","STONY KILL      ",480,4.79,9,1955,1200,4.4390000000000001,"N","majorrehab",0,"4","N","09","1",0.26600000000000001,"5","Fair",4.5380000000000003,"2018-08-27",4.5380000000000003,"19",5,5,7.8571428571428577,16.61,17.16,"N",0,4.6060000000000008,1.7150000000000001,9.9500000000000011,0,0,3,9,"",null,27.128142857142858,0.36170857142857143]
["3346660","8","Ulster","30 - County","30","DENNING ROAD    ","E BR NEVERSINK RIVER",265,4.91,99,1929,900,3.5110000000000001,"Y","majorrehab",8,"3","N","12","1",0.55000000000000004,"2","Poor",7,"2018-08-31",7,"09",7,7,0,0.35749999999999815,1.6224999999999987,"N",0,3.6260000000000003,1.9809999999999999,13.5,4.415,0,2,"",8,null,25.522000000000002,0.34029333333333334]
["3346670","8","Ulster","30 - County","30","FOX HOLLOW ROAD ","FOX HOLLOW CREEK",83,4.91,99,1996,995,3.7370000000000001,"Y","majorrehab",0,"4","N","09","2",0.438,"4","Poor",3.5,"2018-07-24",3.5,"09",4,4,11.785714285714286,24.887499999999999,24.75,{"$f":"IF(W124=\"Poor\", \"Y\", \"N\")","v":"Y"},5,1.8970000000000002,1.9809999999999999,13.5,0,0,3,"","",null,37.163714285714285,0.49551619047619044]
["3346680","8","Ulster","30 - County","30","PEEKAMOOSE ROAD","BEAR HOLE BROOK ",91,6.04,27,1947,917,5.2809999999999997,"N","maintproject",0,"4","N","09","1",8.2000000000000003E-2,"4","Poor",5.4619999999999997,"2018-12-03",5.4619999999999997,"08",4,4,11.785714285714286,9.1024999999999991,24.75,"Y",5,2.0579999999999998,5.628000000000001,12.1625,0,0,3,27,"",null,39.634214285714286,0.52845619047619052]
["3346690","8","Ulster","30 - County","30","SOUTH HOLLOW ROAD","BUSH KILL       ",4,4.91,99,1983,968,4.6669999999999998,"N","minorrehab",0,"5","N","09","1",0.113,"4","Poor",4.1920000000000002,"2019-05-22",4.1920000000000002,"09",4,4,11.785714285714286,20.02,24.75,"Y",5,0.161,1.9809999999999999,13.5,0,0,4,"","",null,36.427714285714288,0.48570285714285716]
["3346700","8","Ulster","30 - County","30","WALKER VALLEY RD","PLATTE  KILL    ",1077,6.63,3,1986,1235,5.1230000000000002,"N","cyclical",0,"4","N","09","1",2.8000000000000001E-2,"6","Fair",5.1580000000000004,"2019-04-03",5.1580000000000004,"09",5,5,7.8571428571428577,10.477499999999999,17.16,"N",0,5.5930000000000009,6.2650000000000006,6.4375,0,0,3,3,"",null,29.152642857142858,0.38870190476190475]
["3346710","8","Ulster","30 - County","30","BROAD ST HOLLW RD","BROAD ST HOLLOW ",187,4.91,1,1998,1084,5.3860000000000001,"N","minorrehab",0,"4","N","09","2",1.4999999999999999E-2,"4","Poor",4.4489999999999998,"2019-04-03",4.4489999999999998,"09",4,4,11.785714285714286,17.16,24.75,"Y",5,2.94,1.9809999999999999,0.77500000000000002,0,0,3,1,"",null,25.481714285714286,0.33975619047619049]
["3346720","8","Ulster","30 - County","30","CR 46           ","RONDOUT CREEK   ",337,4.91,10,1946,3000,3.4689999999999999,"Y","majorrehab",15,"3","Y","19","1",0.63100000000000001,"4","Poor",3,"2019-06-26",3,"09",3,3,15.714285714285715,26.372499999999999,27.06,"Y",5,4.0529999999999999,1.9809999999999999,10.5375,2.9450000000000003,5,2,10,15,null,47.230785714285716,0.62974380952380959]
["3346730","8","Ulster","30 - County","30","COUNTY ROAD 49A","RIDER HOLLOW STREAM",189,8.74,11,2007,1605,6.649,"N","cyclical",0,"4","N","09","1",4.1000000000000002E-2,"7","Good",6.7539999999999996,"2018-05-17",6.7539999999999996,"09",5,5,7.8571428571428577,0.6875,17.16,"N",0,3.0030000000000001,6.5590000000000011,10.862499999999999,0,0,3,11,"",null,31.28164285714286,0.41708857142857148]
["3346740","8","Ulster","30 - County","30","COUNTY ROAD 35  ","PLATTEKILL CREEK",3678,3.5,2,1994,1352,4.9119999999999999,"Y","majorrehab",0,"4","N","09","2",0.253,"4","Poor",4.3849999999999998,"2018-06-21",4.3849999999999998,"08",4,4,11.785714285714286,17.9575,24.75,"Y",{"$f":"_xlfn.IFNA((IF(AG131=\"N\",0,5)),\"\")","v":5},{"$f":"_xlfn.IFNA((_xlfn.PERCENTRANK.INC(H:H,H131))/(1/7),\"\")","v":6.734},{"$f":"(_xlfn.PERCENTRANK.INC(I:I,I131))/(1/7)","v":0.70000000000000007},{"$f":"IF(J131=99,13.5,(_xlfn.PERCENTRANK.INC(AO:AO,AO131))/(1/12.5))","v":4.8125},{"$f":"IF(OR(P131=0,P131>97),0,(5-(_xlfn.PERCENTRANK.EXC(AP:AP,AP131))/(1/5)))","v":0},{"$f":"IF(R131=\"Y\",5,0)","v":0},{"$f":"IFERROR((Q131-1),0)","v":3},{"$f":"IF(J131=99,\"\",J131)","v":2},{"$f":"IF(OR(P131=0,P131>97),\"\",P131)","v":""},null,{"$f":"SUM(AN131,AM131,AL131,AK131,AJ131,AI131,AH131,AD131)","v":32.032214285714282},0.42709619047619041]
["3346750","8","Ulster","30 - County","30","COUNTY ROAD 33","PLATTEKILL CREEK",2539,6.04,8,1995,2003,4.5250000000000004,"Y","majorrehab",0,"5","N","09","2",0.254,"4","Poor",4.2300000000000004,"2018-11-12",4.2300000000000004,"09",4,4,11.785714285714286,{"$f":"IF(Z132>0,27.5-(_xlfn.PERCENTRANK.EXC(Z:Z,Z132))/(1/27.5),\"\")","v":19.3325},{"$f":"(27.5-(_xlfn.PERCENTRANK.INC(AC:AC,AC132))/(1/27.5))","v":24.75},"Y",5,6.503000000000001,5.628000000000001,9.6999999999999993,0,0,4,8,"",null,42.616714285714288,{"$f":"AR132/75","v":0.56822285714285714}]
["3346760","8","Ulster","30 - County","30","BONNIEVIEW RD   ","CATHEDRAL GLEN  ",6,4.91,99,1930,861,3.9470000000000001,"Y","majorrehab",14,"4","N","09","2",0.45700000000000002,"4","Poor",3.6539999999999999,"2019-10-29",3.6539999999999999,"09",3,3,15.714285714285715,24.227499999999999,27.06,"Y",5,0.224,1.9809999999999999,13.5,3.24,0,3,"",14,null,42.659285714285716,0.56879047619047618]
["3346770","8","Ulster","30 - County","30","SCHOOL HILL ROAD","COXING KILL     ",124,4.91,1,1986,1840,5.52,"N","cyclical",0,"5","N","03","E",8.8999999999999996E-2,"6","Fair",5.4779999999999998,"2019-08-13",5.4779999999999998,"09",5,5,7.8571428571428577,8.9924999999999962,17.16,"N",0,2.2890000000000001,1.9809999999999999,0.77500000000000002,0,0,4,1,"",null,16.902142857142856,0.22536190476190474]
["3346780","8","Ulster","30 - County","30","COUNTY ROAD 1   ","KRIPPLEBUSH CREEK",2837,5.03,6,1964,1800,5.3,"N","cyclical",0,"5","N","09","1",7.8E-2,"4","Poor",4.3,"2019-06-11",4.3,"07",4,4,11.785714285714286,18.645,24.75,"Y",5,6.5380000000000011,5.3900000000000006,8.85,0,0,4,6,"",null,41.56371428571429,0.5541828571428572]
["3346790","8","Ulster","30 - County","30","CANYON LAKE RD  ","NORTH PETERS KILL",null,1,2,1929,860,4.702,"Y","cyclical",0,"4","N","09","1",0.11,"4","Poor",4.3460000000000001,"2019-06-14",4.3460000000000001,"09",4,4,11.785714285714286,18.314999999999998,24.75,"Y",5,"",0.25900000000000001,4.8125,0,0,3,2,"",null,24.857214285714285,0.33142952380952378]
["3346800","8","Ulster","30 - County","30","UPPER SAHLR ML RD","ROCHESTER CREEK ",62,4,2,2008,784,6.7889999999999997,"N","cyclical",0,"5","N","09","1",0.02,"6","Fair",6.75,"2018-12-10",6.75,"09",6,6,3.9285714285714306,0.79749999999999943,6.1049999999999969,"N",0,1.4000000000000001,1.3650000000000002,4.8125,0,0,4,2,"",null,15.506071428571431,0.20674761904761907]
["3346810","8","Ulster","30 - County","30","BLUE MOUNTAIN RD","PLATTEKILL CREEK",793,5.78,5,1995,1392,4.0330000000000004,"Y","majorrehab",15,"4","N","09","2",0.40899999999999997,"5","Fair",5.5960000000000001,"2019-08-16",5.5960000000000001,"09",6,6,3.9285714285714306,7.1774999999999984,6.1049999999999969,"N",0,5.2290000000000001,5.5370000000000008,8.1374999999999993,2.9450000000000003,0,3,5,15,null,28.777071428571432,0.38369428571428577]
["3346820","8","Ulster","30 - County","30","BLUE MOUNTAIN RD","LUCAS KILL      ",793,5.78,6,1996,1508,4.07,"N","majorrehab",0,"4","N","09","2",0.30599999999999999,"4","Poor",4.3650000000000002,"2019-05-30",4.3650000000000002,"09",4,4,11.785714285714286,18.204999999999998,24.75,"Y",5,5.2290000000000001,5.5370000000000008,8.85,0,0,3,6,"",null,39.401714285714284,0.52535619047619042]
["3346830","8","Ulster","30 - County","30","County Road 18","DWAAR KILL      ",4009,6.83,4,1989,1508,4.649,"N","deckrepl",0,"4","N","09","1",8.6999999999999994E-2,"5","Fair",4.3079999999999998,"2018-08-02",4.3079999999999998,"09",5,5,7.8571428571428577,18.534999999999997,17.16,"N",0,6.8319999999999999,6.3000000000000007,7.4749999999999996,0,0,3,4,"",null,31.464142857142857,0.41952190476190476]
["3346840","8","Ulster","30 - County","30","DRY BROOK ROAD","DRY BROOK       ",27,4.76,99,1956,1098,4.5789999999999997,"N","minorrehab",0,"4","N","09","1",0.125,"5","Fair",3.7309999999999999,"2019-05-15",3.7309999999999999,"09",4,4,11.785714285714286,23.54,24.75,"N",0,0.58800000000000008,1.54,13.5,0,0,3,"","",null,30.413714285714285,0.40551619047619047]
["3346850","8","Ulster","30 - County","30","GLASCO TURNPIKE ","ESOPUS CREEK    ",3927,3.66,7,1962,7038,5.923,"N","cyclical",0,"5","N","13","1",6.9000000000000006E-2,"5","Fair",5.5309999999999997,"2018-11-05",5.5309999999999997,"17",5,5,7.8571428571428577,7.9750000000000014,17.16,"N",0,6.7690000000000001,0.81200000000000006,9.2999999999999989,0,0,4,7,"",null,28.738142857142858,0.38317523809523812]
["3346870","8","Ulster","30 - County","30","ULSTER HEIGHTS RD","BOTSFORD BROOK  ",184,6.04,23,1953,2000,4.2,"Y","replace",10,"4","N","09","1",0.439,"4","Poor",4.0670000000000002,"2019-08-28",4.0670000000000002,"08",4,4,11.785714285714286,20.57,24.75,"Y",5,2.9049999999999998,5.628000000000001,11.5875,3.9750000000000001,0,3,23,10,null,43.881214285714286,0.58508285714285713]
["3346880","8","Ulster","30 - County","30","COUNTY ROAD 29A ","ESOPUS CREEK    ",1963,4.08,4,2014,4166,6.22,"N","cyclical",0,"4","Y","19","1",0.105,"6","Fair",{"$error":"#N/A"},{"$error":"#N/A"},6.22,"08",null,0,null,3.41,27.5,"N",0,6.048,1.4000000000000001,7.4749999999999996,0,5,3,4,"",null,22.923000000000002,0.30564000000000002]
["3346910","8","Ulster","30 - County","30","SNYDER ROAD     ","PLATTEKILL CREEK",1607,3.92,5,1955,3000,4.0739999999999998,"Y","majorrehab",0,"4","N","09","2",0.35499999999999998,"4","Poor",3.9260000000000002,"2019-04-18",3.9260000000000002,"19",4,4,{"$f":"27.5-(AC145*(27.5/7))","v":11.785714285714286},21.615000000000002,24.75,"Y",5,5.95,0.95900000000000007,8.1374999999999993,0,0,3,5,"",null,34.832214285714286,0.46442952380952379]
["3346920","8","Ulster","30 - County","30","GRANITE ROAD","STONY KILL      ",480,4.79,9,1990,1150,4.93,"N","vertdown",0,"4","N","09","1",4.9000000000000002E-2,"6","Fair",4.8460000000000001,"2018-11-29",4.8460000000000001,"19",5,5,7.8571428571428577,13.309999999999999,17.16,"N",0,4.6060000000000008,1.7150000000000001,9.9500000000000011,0,0,3,9,"",null,27.128142857142858,0.36170857142857143]
["3346930","8","Ulster","30 - County","30","GRAU ROAD       ","PLATTE  KILL    ",327,6.09,2,1985,936,4.6840000000000002,"N","cyclical",0,"4","N","09","1",6.6000000000000003E-2,"5","Fair",4.7309999999999999,"2018-12-12",4.7309999999999999,"09",5,5,7.8571428571428577,14.327500000000001,17.16,"N",0,4.0179999999999998,6.2090000000000005,4.8125,0,0,3,2,"",null,25.896642857142858,0.34528857142857144]
["3346940","8","Ulster","30 - County","30","CLOVE VALLEY ROAD","COXING KILL     ",228,4.91,6,2000,959,4.7889999999999997,"N","minorrehab",0,"5","N","09","2",5.3999999999999999E-2,"4","Poor",3.8849999999999998,"2019-08-13",3.8849999999999998,"09",4,4,11.785714285714286,22.274999999999999,24.75,"Y",5,3.367,1.9809999999999999,8.85,0,0,4,6,"",null,34.983714285714285,0.46644952380952381]
["3346970","8","Ulster","30 - County","30","DRY BROOK ROAD  ","DRY BROOK       ",27,4.76,99,1933,1071,3.8769999999999998,"Y","majorrehab",18,"4","N","09","2",0.46700000000000003,"5","Fair",5.5190000000000001,"2019-07-17",5.5190000000000001,"09",6,6,3.9285714285714306,8.3049999999999997,6.1049999999999969,"N",0,0.58800000000000008,1.54,13.5,1.62,0,3,"",18,null,24.176571428571432,0.32235428571428576]
["3347000","8","Ulster","30 - County","30","BIG POND ROAD   ","BEAVER KILL     ",88,3.49,7,1960,2576,4.4749999999999996,"Y","maintproject",0,"4","N","09","2",0.16,"4","Poor",4.5709999999999997,"2018-11-01",4.5709999999999997,"08",4,4,11.785714285714286,15.8125,24.75,"Y",5,2.0230000000000001,0.63700000000000001,9.2999999999999989,0,0,3,7,"",null,31.745714285714286,0.42327619047619047]
["3347010","8","Ulster","30 - County","30","MILL BROOK RD","MILL BROOK",42,10.53,2,2001,1292,5.4039999999999999,"N","cyclical",0,"3","N","09","2",1.6E-2,"6","Fair",6.0190000000000001,"2018-09-26",6.0190000000000001,"09",5,5,7.8571428571428577,4.4549999999999983,17.16,"N",0,1.0780000000000001,6.8530000000000006,4.8125,0,0,2,2,"",null,22.600642857142859,0.30134190476190476]
["3347020","8","Ulster","30 - County","30","GOSSOO ROAD     ","BUSHNELLSVILLE CK",17,4.91,99,1988,860,5.2460000000000004,"N","cyclical",0,"4","N","09","1",6.7000000000000004E-2,"6","Fair",4.8070000000000004,"2019-08-19",4.8070000000000004,"09",5,5,7.8571428571428577,13.419999999999998,17.16,"N",0,0.49000000000000005,1.9809999999999999,13.5,0,0,3,"","",null,26.828142857142858,0.35770857142857143]
["3347030","8","Ulster","30 - County","30","MALDEN TURNPIKE","SAWYER KILL     ",2094,7.93,5,1933,1020,6.0529999999999999,"N","cyclical",0,"3","N","09","3",8.2000000000000003E-2,"5","Fair",5.7309999999999999,"2019-10-16",5.7309999999999999,"17",6,6,3.9285714285714306,6.379999999999999,6.1049999999999969,"N",0,6.1110000000000007,6.4750000000000005,8.1374999999999993,0,0,2,5,"",null,26.652071428571432,0.35536095238095244]
["3347040","8","Ulster","30 - County","30","MOSSY BROOK RD  ","COXING KILL     ",912,4.91,1,1966,2376,5.1719999999999997,"Y","cyclical",0,"4","N","09","1",7.2999999999999995E-2,"5","Fair",4.7409999999999997,"2019-10-01",4.7409999999999997,"09",4,4,11.785714285714286,13.997499999999999,24.75,"N",0,5.3620000000000001,1.9809999999999999,0.77500000000000002,0,0,3,1,"",null,22.903714285714287,0.30538285714285718]
["3347050","8","Ulster","30 - County","30","MARCUS ROAD     ","BEER KILL       ",133,4.91,4,2001,1502,4.7889999999999997,"N","cyclical",0,"5","N","09","2",4.9000000000000002E-2,"5","Fair",4.1920000000000002,"2019-04-23",4.1920000000000002,"09",5,5,7.8571428571428577,20.02,17.16,"N",0,2.415,1.9809999999999999,7.4749999999999996,0,0,4,4,"",null,23.728142857142856,0.3163752380952381]
["3347060","8","Ulster","30 - County","30","SILVER HOLLOW RD","WARNER CREEK    ",183,4.91,99,1987,1326,4.3860000000000001,"N","majorrehab",0,"5","N","09","1",0.30399999999999999,"5","Fair",4.1749999999999998,"2019-08-19",4.1749999999999998,"09",4,4,11.785714285714286,20.239999999999998,24.75,{"$f":"IF(W156=\"Poor\", \"Y\", \"N\")","v":"N"},0,2.8420000000000005,1.9809999999999999,13.5,0,0,4,"","",null,34.108714285714285,0.45478285714285716]
["3347070","8","Ulster","30 - County","30","MT PLESANT      ","ESPOUS CREEK    ",null,4.91,1,1934,6100,null,"N","N/A",99,"","Y","18","1",null,{"$error":"#N/A"},{"$error":"#N/A"},0,"00:00:00",0,"09","",0,null,"",27.5,{"$error":"#N/A"},"","",1.9809999999999999,0.77500000000000002,0,5,0,1,"",null,7.7560000000000002,0.10341333333333334]
["3347080","8","Ulster","30 - County","30","PANTHER KILL ROAD","PANTHER KILL    ",62,4.91,99,1969,675,4.8070000000000004,"Y","majorrehab",0,"2","N","09","1",0.33200000000000002,"5","Fair",4.4039999999999999,"2019-11-13",4.4039999999999999,"09",5,5,{"$f":"27.5-(AC158*(27.5/7))","v":7.8571428571428577},17.737500000000001,17.16,"N",0,1.4000000000000001,1.9809999999999999,13.5,0,0,1,"","",null,25.738142857142858,0.34317523809523809]
["3347090","8","Ulster","30 - County","30","Denning Rd","EB Neversink River",265,4.91,16,1936,4295,7,"N","cyclical",null,"4","N","03","E",0.17100000000000001,"8","Good",6.702,"2018-12-03",6.702,"09",7,7,0,1.0449999999999982,1.6224999999999987,"N",0,3.6260000000000003,1.9809999999999999,11.324999999999999,0,0,3,16,"",null,19.931999999999999,0.26576]
["3347100","8","Ulster","30 - County","30","MABEN HOLLOW ROAD","ESOPUS CREEK    ",1,4.91,99,2013,846,6.6139999999999999,"N","cyclical",0,"4","N","09","1",6.7000000000000004E-2,"7","Good",6.702,"2019-05-28",6.702,"09",6,6,3.9285714285714306,1.0449999999999982,6.1049999999999969,"N",0,0,1.9809999999999999,13.5,0,0,3,"","",null,22.409571428571432,0.29879428571428579]
["3347110","8","Ulster","30 - County","30","WOODLAND VALLEY RD","PANTHER KILL    ",563,4.91,99,1999,1703,4.7889999999999997,"N","maintproject",0,"4","N","09","2",9.6000000000000002E-2,"5","Fair",4.383,"2019-04-22",4.383,"09",5,5,7.8571428571428577,18.094999999999999,17.16,"N",0,4.8719999999999999,1.9809999999999999,13.5,0,0,3,"","",null,31.210142857142859,0.41613523809523811]
["3347120","8","Ulster","30 - County","30","FOX HOLLOW ROAD ","ESOPUS CREEK    ",83,4.91,1,1953,2575,5.0330000000000004,"Y","maintproject",0,"4","N","09","2",6.4000000000000001E-2,"4","Poor",4.7380000000000004,"2019-10-02",4.7380000000000004,"09",4,4,11.785714285714286,14.1075,24.75,"Y",5,1.8970000000000002,1.9809999999999999,0.77500000000000002,0,0,3,1,"",null,24.438714285714287,0.32584952380952381]
["3347130","8","Ulster","30 - County","30","MCKINLEY HOLLW RD","ESOPUS CREEK    ",78,4.91,99,1964,2018,7,"N","cyclical",null,"4","N","09","1",6.9000000000000006E-2,"8","Good",6.4909999999999997,"2019-08-21",6.4909999999999997,"09",7,7,0,2.1724999999999959,1.6224999999999987,"N",0,1.7990000000000002,1.9809999999999999,13.5,0,0,3,"","",null,20.28,0.27040000000000003]
["3347140","8","Ulster","30 - County","30","BURNHAM HOLLOW RD","ESOPUS CREEK    ",39,4.91,99,1964,1302,5.8250000000000002,"N","cyclical",0,"4","N","09","1",6.8000000000000005E-2,"5","Fair",5.3849999999999998,"2018-06-14",5.3849999999999998,"09",5,5,7.8571428571428577,10.009999999999998,17.16,"N",0,0.94500000000000006,1.9809999999999999,13.5,0,0,3,"","",null,27.28314285714286,0.36377523809523815]
["3347160","8","Ulster","30 - County","30","COUNTY ROAD 54  ","BEAVER KILL     ",125,4.91,99,1939,1998,3.9350000000000001,"N","majorrehab",20,"4","Y","15","1",0.52300000000000002,"5","Fair",3.871,"2019-08-14",3.871,"09",4,4,11.785714285714286,22.412500000000001,24.75,"N",0,2.3170000000000002,1.9809999999999999,13.5,1.3250000000000002,5,3,"",20,null,38.908714285714282,0.5187828571428571]
["3347170","8","Ulster","30 - County","30","WOODLND VALLEY RD","DOUGHERTY BROOK ",563,4.91,99,1970,1026,4.2279999999999998,"N","majorrehab",0,"3","N","09","1",0.35299999999999998,"4","Poor",3.8849999999999998,"2018-07-24",3.8849999999999998,"09",4,4,11.785714285714286,22.274999999999999,24.75,"Y",5,4.8719999999999999,1.9809999999999999,13.5,0,0,2,"","",null,39.138714285714286,0.52184952380952376]
["3347180","8","Ulster","30 - County","30","GREENVILLE ROAD ","PIGEON HOLE BROOK",67,4.91,9,1990,918,5.1479999999999997,"N","cyclical",0,"4","N","27","B",0.05,"6","Fair",4.4809999999999999,"2019-08-28",4.4809999999999999,"09",5,5,7.8571428571428577,17.049999999999997,17.16,"N",0,1.5960000000000001,1.9809999999999999,9.9500000000000011,0,0,3,9,"",null,24.384142857142859,0.32512190476190478]
["3347190","8","Ulster","30 - County","30","PALENTOWN RD    ","METTACAHONTS CREE",383,4.91,1,2000,952,4.1399999999999997,"N","majorrehab",null,"5","N","09","2",0.28299999999999997,"6","Fair",6.327,"2019-08-01",6.327,"09",6,6,3.9285714285714306,2.9699999999999989,6.1049999999999969,"N",0,4.1509999999999998,1.9809999999999999,0.77500000000000002,0,0,4,1,"",null,14.835571428571431,0.19780761904761907]
["3347210","8","Ulster","30 - County","30","COUNTY ROAD 9   ","DWAAR KILL      ",3994,6.04,5,2015,2717,6.8620000000000001,"N","cyclical",null,"4","N","03","E",0.124,"8","Good",5.4,"2019-08-30",5.4,"08",7,7,0,9.5699999999999967,1.6224999999999987,"N",0,6.7970000000000006,5.628000000000001,8.1374999999999993,0,0,3,5,"",null,23.5625,0.31416666666666665]
["3347220","8","Ulster","30 - County","30","LASHER ROAD     ","BIRCH CREEK     ",40,4.91,1,2007,1314,6.2279999999999998,"N","cyclical",0,"4","N","09","1",1.7999999999999999E-2,"5","Fair",6.0179999999999998,"2019-10-18",6.0179999999999998,"09",6,6,3.9285714285714306,4.5650000000000013,6.1049999999999969,"N",0,0.98000000000000009,1.9809999999999999,0.77500000000000002,0,0,3,1,"",null,10.664571428571431,0.14219428571428575]
["3347230","8","Ulster","30 - County","30","FOORDMORE RD","RONDOUT CREEK   ",2528,4.8499999999999996,2,1896,3750,5.1449999999999996,"N","cyclical",0,"4","N","09","2",2.5000000000000001E-2,"5","Fair",5.1559999999999997,"2018-09-11",5.1559999999999997,"09",4,4,11.785714285714286,10.587499999999999,24.75,"N",0,6.3770000000000007,1.806,4.8125,0,0,3,2,"",null,27.781214285714288,0.37041619047619051]
["3347240","8","Ulster","30 - County","30","CR 49 Dry BrookRD","DRY BROOK       ",27,4.76,99,1989,1200,5.298,"Y","cyclical",0,"4","N","09","1",6.7000000000000004E-2,"4","Poor",5.0880000000000001,"2019-10-09",5.0880000000000001,"09",4,4,11.785714285714286,11.0275,24.75,"Y",5,0.58800000000000008,1.54,13.5,0,0,3,"","",null,35.413714285714285,0.47218285714285713]
["3347250","8","Ulster","30 - County","30","STONY CLOVE LANE","STONEY CLOVE CRK",64,4.91,99,1955,1140,4.7889999999999997,"N","deckrepl",0,"4","N","09","1",9.7000000000000003E-2,"5","Fair",4.2809999999999997,"2019-04-02",4.2809999999999997,"09",5,5,7.8571428571428577,18.754999999999999,17.16,"N",0,1.47,1.9809999999999999,13.5,0,0,3,"","",null,27.808142857142858,0.3707752380952381]
["3347260","8","Ulster","30 - County","30","HURLEY MT ROAD  ","ESOPUS CREEK    ",1004,4.8499999999999996,16,1958,8900,3.847,"Y","replace",0,"4","N","13","1",0.41299999999999998,"4","Poor",3.4630000000000001,"2018-08-14",3.4630000000000001,"08",4,4,11.785714285714286,25.024999999999999,24.75,"Y",5,5.4600000000000009,1.806,11.324999999999999,0,0,3,16,"",null,38.376714285714286,0.51168952380952382]
["3347270","8","Ulster","30 - County","30","MILLARD BURNETT ROAD","PLATTEKILL CREEK",94,4.91,99,2001,1080,5.7690000000000001,"N","cyclical",0,"4","N","09","2",6.4000000000000001E-2,"6","Fair",5.7690000000000001,"2018-09-20",5.7690000000000001,"09",5,5,7.8571428571428577,5.9124999999999979,17.16,"N",0,2.1910000000000003,1.9809999999999999,13.5,0,0,3,"","",null,28.529142857142858,0.38038857142857146]
["3347280","8","Ulster","30 - County","30","BECKER ROAD     ","PLATTEKILL CREEK",61,4.91,99,1996,1024,6.8150000000000004,"N","cyclical",0,"5","N","25","7",0.108,"6","Fair",5.3330000000000002,"2019-04-22",5.3330000000000002,"09",6,6,3.9285714285714306,10.119999999999997,6.1049999999999969,"N",0,1.3720000000000001,1.9809999999999999,13.5,0,0,4,"","",null,24.781571428571432,0.33042095238095243]
["3347290","8","Ulster","30 - County","30","TANNERY BROOK RD","TANNERY BROOK   ",1442,1.84,1,1940,1004,4.3680000000000003,"N","deckrepl",0,"4","N","09","2",9.4E-2,"4","Poor",6.2309999999999999,"2019-10-04",6.2309999999999999,"17",6,6,3.9285714285714306,3.2999999999999972,6.1049999999999969,"Y",5,5.7539999999999996,0.46200000000000002,0.77500000000000002,0,0,3,1,"",null,18.91957142857143,0.25226095238095242]
["3347300","8","Ulster","30 - County","30","BONE HOLLOW ROAD","NORTH PETERS KILL",311,0.93,1,1938,936,3.3159999999999998,"Y","replace",0,"4","N","09","1",0.45100000000000001,"4","Poor",3.3460000000000001,"2018-04-11",3.3460000000000001,"09",4,4,11.785714285714286,25.932500000000001,24.75,"Y",5,3.8920000000000003,0.23100000000000001,0.77500000000000002,0,0,3,1,"",null,24.683714285714288,0.32911619047619051]
["3347310","8","Ulster","30 - County","30","LOST CLOVE ROAD","ESOPUS CREEK    ",77,4.91,5,1966,2006,5.8849999999999998,"N","cyclical",null,"5","N","09","1",2.7E-2,"6","Fair",5.8849999999999998,"2018-10-24",5.8849999999999998,"09",5,5,7.8571428571428577,5.4724999999999966,17.16,"N",0,1.764,1.9809999999999999,8.1374999999999993,0,0,4,5,"",null,23.739642857142854,0.31652857142857138]
["3347320","8","Ulster","30 - County","30","COUNTY ROAD 18  ","WALLKILL RIVER  ",4009,6.83,9,1915,9000,3.1760000000000002,"Y","replace",20,"4","N","25","B",0.58399999999999996,"4","Poor",4,"2019-05-06",4,"08",5,5,7.8571428571428577,21.2575,17.16,"Y",5,6.8319999999999999,6.3000000000000007,9.9500000000000011,1.3250000000000002,0,3,9,20,null,40.264142857142858,0.53685523809523805]
["3347330","8","Ulster","30 - County","30","MELLERT ROAD    ","SAW KILL        ",82,4.91,99,1981,958,5.1280000000000001,"N","maintproject",0,"5","N","02","E",0.13900000000000001,"5","Fair",4.4039999999999999,"2018-08-06",4.4039999999999999,"09",5,5,7.8571428571428577,17.737500000000001,17.16,"N",0,1.8270000000000002,1.9809999999999999,13.5,0,0,4,"","",null,29.165142857142861,0.38886857142857151]
["3347340","8","Ulster","30 - County","30","COUNTY ROAD 7   ","VERKEERDER KILL ",2104,3.8,2,1938,1482,5.0199999999999996,"N","minorrehab",0,"4","N","09","1",4.1000000000000002E-2,"5","Fair",4.8769999999999998,"2019-04-03",4.8769999999999998,"08",4,4,11.785714285714286,13.2,24.75,"N",0,6.181,0.84,4.8125,0,0,3,2,"",null,26.619214285714285,0.35492285714285715]
["3347360","8","Ulster","30 - County","30","DE WITT ROAD    ","METTACAHONTS CRK",59,4.91,3,1958,1267,5.5,"N","cyclical",0,"5","N","09","1",2.1999999999999999E-2,"6","Fair",5.1920000000000002,"2018-11-29",5.1920000000000002,"09",5,5,7.8571428571428577,10.3675,17.16,"N",0,1.3370000000000002,1.9809999999999999,6.4375,0,0,4,3,"",null,21.612642857142859,0.28816857142857144]
["3347370","8","Ulster","30 - County","30","WOODLAND VLY ROAD","ESOPUS CREEK    ",619,4.91,2,1998,5520,3.87,"Y","majorrehab",8,"4","Y","19","2",0.498,"6","Fair",5.65,"2018-09-20",5.65,"09",6,6,3.9285714285714306,6.82,6.1049999999999969,"N",0,4.9980000000000002,1.9809999999999999,4.8125,4.415,5,3,2,8,null,28.135071428571433,0.37513428571428575]
["3347380","8","Ulster","30 - County","30","SOUTH MOUNTAIN RD","KLYNE KILL      ",171,4.91,1,1930,989,4.7190000000000003,"N","vertdown",0,"4","N","09","1",5.7000000000000002E-2,"6","Fair",4.7690000000000001,"2019-04-30",4.7690000000000001,"09",5,5,7.8571428571428577,13.887499999999999,17.16,"N",0,2.7440000000000002,1.9809999999999999,0.77500000000000002,0,0,3,1,"",null,16.357142857142858,0.21809523809523809]
["3347400","8","Ulster","30 - County","30","COUNTY ROAD 6   ","RONDOUT CREEK   ",1658,5.61,20,1965,9000,5.319,"N","minorrehab",20,"4","N","13","1",0.11700000000000001,"5","Fair",4.4379999999999997,"2019-06-24",4.4379999999999997,"09",5,5,7.8571428571428577,17.297499999999999,17.16,"N",0,5.9850000000000003,5.4530000000000003,11.450000000000001,1.3250000000000002,0,3,20,20,null,35.070142857142855,0.46760190476190472]
["3347410","8","Ulster","30 - County","30","CO RD 6A","COXING KILL     ",966,6.04,3,1941,1660,5.2809999999999997,"N","cyclical",0,"4","N","09","1",4.1000000000000002E-2,"6","Fair",5,"2018-05-23",5,"08",5,5,7.8571428571428577,12.182499999999997,17.16,"N",0,5.3970000000000002,5.628000000000001,6.4375,0,0,3,3,"",null,28.319642857142856,0.37759523809523809]
["3347420","8","Ulster","30 - County","30","DENNING ROAD    ","E BR NEVERSINK RV",265,4.91,3,1970,2548,4.226,"Y","deckrepl",0,"4","N","09","1",0.18,"3","Poor",4.5810000000000004,"2019-10-03",4.5810000000000004,"09",4,4,11.785714285714286,15.702499999999999,24.75,{"$f":"IF(W188=\"Poor\", \"Y\", \"N\")","v":"Y"},5,3.6260000000000003,1.9809999999999999,6.4375,0,0,3,3,"",null,31.830214285714284,0.42440285714285714]
["3347430","8","Ulster","30 - County","30","COUNTY ROAD 19  ","WALLKILL RIVER  ",547,5.52,9,1940,9242,4.7539999999999996,"N","majorrehab",0,"4","Y","18","1",0.34799999999999998,"4","Poor",4.1449999999999996,"2019-07-22",4.1449999999999996,"09",4,4,11.785714285714286,20.350000000000001,24.75,"Y",5,4.8369999999999997,5.4250000000000007,9.9500000000000011,0,5,3,9,"",null,44.997714285714288,0.59996952380952384]
["3347440","8","Ulster","30 - County","30","CAPE AVENUE     ","BEER KILL       ",null,1,21,1940,2100,4.8330000000000002,"N","minorrehab",0,"5","N","09","1",0.108,"5","Fair",4.8,"2018-11-01",4.8,"17",5,5,{"$f":"27.5-(AC190*(27.5/7))","v":7.8571428571428577},13.53,17.16,"N",0,"",0.25900000000000001,11.512500000000001,0,0,4,21,"",null,23.628642857142857,0.31504857142857146]
["3347450","8","Ulster","30 - County","30","COUNTY ROAD 7A  ","SHAWANGUNK KILL ",264,4.91,3,1941,3479,4.0819999999999999,"Y","majorrehab",0,"4","Y","19","1",0.435,"4","Poor",3.3959999999999999,"2019-08-01",3.3959999999999999,"09",3,3,15.714285714285715,25.574999999999999,27.06,"Y",5,3.5980000000000003,1.9809999999999999,6.4375,0,5,3,3,"",null,40.730785714285716,0.54307714285714292]
["3347460","8","Ulster","30 - County","30","COUNTY ROUTE 007","RONDOUT CREEK   ",1555,3.6,1,1957,6594,4.4859999999999998,"Y","minorrehab",0,"4","N","01","B",0.17699999999999999,"4","Poor",3.4180000000000001,"2018-11-07",3.4180000000000001,"17",4,4,11.785714285714286,25.465,24.75,"Y",5,5.8520000000000003,0.72799999999999998,0.77500000000000002,0,0,3,1,"",null,27.140714285714289,0.36187619047619052]
["3347460","8","Ulster","30 - County","30","COUNTY ROUTE 007","RONDOUT CREEK   ",1555,3.6,1,1957,6594,4.4859999999999998,"Y","minorrehab",0,"4","N","13","1",0.17699999999999999,"4","Poor",3.4180000000000001,"2018-11-07",3.4180000000000001,"17",4,4,11.785714285714286,25.465,24.75,"Y",5,5.8520000000000003,0.72799999999999998,0.77500000000000002,0,0,3,1,"",null,27.140714285714289,0.36187619047619052]
["3347470","8","Ulster","30 - County","30","DENNING ROAD    ","E BR NEVERSINK RIVER",265,4.91,10,1965,4100,3.6429999999999998,"Y","majorrehab",0,"2","N","09","1",0.46400000000000002,"4","Poor",3.6,"2019-10-01",3.6,"09",3,3,15.714285714285715,24.447499999999998,27.06,"Y",5,3.6260000000000003,1.9809999999999999,10.5375,0,0,1,10,"",null,37.858785714285716,0.50478380952380952]
["3347480","8","Ulster","30 - County","30","PIROG ROAD      ","VERKEERDER KILL ",411,4.91,1,1957,1217,4.351,"N","maintproject",0,"3","N","09","1",0.13500000000000001,"6","Fair",4.0890000000000004,"2018-06-20",4.0890000000000004,"09",5,5,7.8571428571428577,20.46,17.16,"N",{"$f":"_xlfn.IFNA((IF(AG195=\"N\",0,5)),\"\")","v":0},{"$f":"_xlfn.IFNA((_xlfn.PERCENTRANK.INC(H:H,H195))/(1/7),\"\")","v":4.41},{"$f":"(_xlfn.PERCENTRANK.INC(I:I,I195))/(1/7)","v":1.9809999999999999},{"$f":"IF(J195=99,13.5,(_xlfn.PERCENTRANK.INC(AO:AO,AO195))/(1/12.5))","v":0.77500000000000002},{"$f":"IF(OR(P195=0,P195>97),0,(5-(_xlfn.PERCENTRANK.EXC(AP:AP,AP195))/(1/5)))","v":0},{"$f":"IF(R195=\"Y\",5,0)","v":0},{"$f":"IFERROR((Q195-1),0)","v":2},{"$f":"IF(J195=99,\"\",J195)","v":1},{"$f":"IF(OR(P195=0,P195>97),\"\",P195)","v":""},null,{"$f":"SUM(AN195,AM195,AL195,AK195,AJ195,AI195,AH195,AD195)","v":17.023142857142858},0.22697523809523812]
["3347490","8","Ulster","30 - County","30","BRIDGE ROAD     ","STONY KILL      ",36,3.92,1,1955,584,4.577,"Y","maintproject",0,"3","N","09","1",0.151,"3","Poor",4.7309999999999999,"2019-06-14",4.7309999999999999,"19",4,4,11.785714285714286,{"$f":"IF(Z196>0,27.5-(_xlfn.PERCENTRANK.EXC(Z:Z,Z196))/(1/27.5),\"\")","v":14.327500000000001},{"$f":"(27.5-(_xlfn.PERCENTRANK.INC(AC:AC,AC196))/(1/27.5))","v":24.75},"Y",5,0.88200000000000001,0.95900000000000007,0.77500000000000002,0,0,2,1,"",null,21.401714285714284,{"$f":"AR196/75","v":0.28535619047619049}]
["3347500","8","Ulster","30 - County","30","COUNTY ROAD 30","SAW KILL        ",3596,4.47,14,1958,3325,3.9,"N","minorrehab",0,"4","N","09","1",0.19700000000000001,"5","Fair",3.7810000000000001,"2019-09-11",3.7810000000000001,"17",5,5,7.8571428571428577,23.43,17.16,"N",0,6.6989999999999998,1.484,11.0625,0,0,3,14,"",null,30.102642857142857,0.40136857142857141]
["3347510","8","Ulster","30 - County","30","COUNTY ROAD 18","SHAWANGUNK KILL ",976,7.53,7,1960,6000,3.7229999999999999,"N","majorrehab",16,"4","N","09","1",0.38300000000000001,"4","Poor",3.8980000000000001,"2019-09-04",3.8980000000000001,"09",3,3,15.714285714285715,22.055,27.06,"Y",5,5.4250000000000007,6.4120000000000008,9.2999999999999989,1.7650000000000001,0,3,7,16,null,46.616285714285716,0.62155047619047621]
["3347520","8","Ulster","30 - County","30","BOICE MILL RD   ","FALLS MILL BROOK",149,4.91,2,1962,723,5.4560000000000004,"N","minorrehab",0,"4","N","09","2",1.6E-2,"5","Fair",4.2690000000000001,"2018-08-07",4.2690000000000001,"09",5,5,7.8571428571428577,19.002499999999998,17.16,"N",0,2.6110000000000002,1.9809999999999999,4.8125,0,0,3,2,"",null,20.26164285714286,0.27015523809523811]
["3347530","8","Ulster","30 - County","30","LEGGS MILL ROAD ","ESOPUS CREEK    ",7406,4.1500000000000004,7,1972,12800,5.1529999999999996,"N","majorrehab",30,"4","N","09","1",0.27600000000000002,"5","Fair",3.806,"2018-11-26",3.806,"17",5,5,7.8571428571428577,23.072499999999998,17.16,"N",0,6.9650000000000007,1.456,9.2999999999999989,0.15000000000000036,0,3,7,30,null,28.728142857142856,0.38304190476190475]
["3347540","8","Ulster","30 - County","30","COUNTY ROAD 27","RONDOUT CREEK   ",786,4.91,9,1950,3800,3.9830000000000001,"Y","majorrehab",0,"4","N","09","1",0.38,"5","Fair",4.2359999999999998,"2018-11-06",4.2359999999999998,"09",4,4,11.785714285714286,19.2225,24.75,"N",0,5.194,1.9809999999999999,9.9500000000000011,0,0,3,9,"",null,31.910714285714285,0.42547619047619045]
["3347550","8","Ulster","30 - County","30","AWOSTING ROAD   ","BEAVER BROOK    ",534,7.95,8,1948,900,6.2119999999999997,"N","cyclical",0,"4","N","01","B",4.2000000000000003E-2,"6","Fair",4.6360000000000001,"2018-09-12",4.6360000000000001,"09",5,5,7.8571428571428577,15.344999999999999,17.16,"N",0,4.7740000000000009,6.503000000000001,9.6999999999999993,0,0,3,8,"",null,31.834142857142858,0.42445523809523811]
["3347560","8","Ulster","30 - County","30","COUNTY ROAD 42  ","MALTBY HOLLOW BRK",712,6.04,27,1957,2066,4.931,"Y","minorrehab",0,"4","N","09","1",0.14399999999999999,"3","Poor",4.6550000000000002,"2018-06-01",4.6550000000000002,"08",4,4,11.785714285714286,15.124999999999998,24.75,"Y",5,5.0960000000000001,5.628000000000001,12.1625,0,0,3,27,"",null,42.67221428571429,0.56896285714285721]
["3347570","8","Ulster","30 - County","30","BEAVER KILL ROAD","SCUDDER BROOK   ",72,17.95,99,1953,1104,4.2460000000000004,"N","minorrehab",0,"4","N","09","2",0.16800000000000001,"4","Poor",3.923,"2019-06-05",3.923,"09",4,4,11.785714285714286,21.725000000000001,24.75,"Y",5,1.694,7,13.5,0,0,3,"","",null,41.979714285714287,0.55972952380952379]
["3347580","8","Ulster","30 - County","30","COUNTY ROAD 47","ESOPUS CREEK    ",404,6.04,1,1953,3900,4.5759999999999996,"N","majorrehab",null,"4","Y","15","1",0.35,"5","Fair",4.6950000000000003,"2019-04-25",4.6950000000000003,"08",5,5,7.8571428571428577,14.684999999999999,17.16,"N",0,4.2839999999999998,5.628000000000001,0.77500000000000002,0,5,3,1,"",null,26.544142857142859,0.35392190476190477]
["3347590","8","Ulster","30 - County","30","HERDMAN ROAD    ","WOODLAND CREEK  ",25,4.91,99,2002,2262,5.5960000000000001,"Y","cyclical",0,"5","N","09","2",0.112,"4","Poor",5.6150000000000002,"2018-08-31",5.6150000000000002,"09",5,5,7.8571428571428577,7.067499999999999,17.16,"Y",5,0.51800000000000002,1.9809999999999999,13.5,0,0,4,"","",null,32.856142857142856,0.43808190476190473]
["3347600","8","Ulster","30 - County","30","COUNTY ROAD 3   ","MOMBACCUS CREEK ",773,8.99,1,1955,1300,4.1230000000000002,"N","majorrehab",0,"4","N","09","2",0.30199999999999999,"4","Poor",3.8069999999999999,"2019-05-29",3.8069999999999999,"08",4,4,11.785714285714286,22.962499999999999,24.75,"Y",5,5.1660000000000004,6.5869999999999997,0.77500000000000002,0,0,3,1,"",null,32.313714285714283,0.43084952380952379]
["3347610","8","Ulster","30 - County","30","TOW PATH ROAD   ","SANDERS KILL    ",433,4.91,5,1955,800,4.8940000000000001,"N","cyclical",0,"4","N","09","1",4.4999999999999998E-2,"5","Fair",5.952,"2018-08-07",5.952,"09",5,5,7.8571428571428577,5.115000000000002,17.16,"N",0,4.508,1.9809999999999999,8.1374999999999993,0,0,3,5,"",null,25.483642857142858,0.33978190476190478]
["3347620","8","Ulster","30 - County","30","TOW PATH ROAD   ","PETERS KILL     ",433,4.91,1,1962,1718,5.1749999999999998,"N","maintproject",0,"5","N","09","2",1.7000000000000001E-2,"5","Fair",5.4809999999999999,"2018-08-22",5.4809999999999999,"09",5,5,7.8571428571428577,8.7724999999999973,17.16,"N",0,4.508,1.9809999999999999,0.77500000000000002,0,0,4,1,"",null,19.121142857142857,0.25494857142857141]
["3347630","8","Ulster","30 - County","30","COUNTY ROAD 31","SAW KILL        ",4517,3.61,5,2016,6235,7,"N","cyclical",null,"5","N","13","1",6.6000000000000003E-2,"8","Good",6.7690000000000001,"2018-10-01",6.7690000000000001,"17",7,7,0,0.57750000000000057,1.6224999999999987,"N",0,6.8950000000000005,0.78400000000000003,8.1374999999999993,0,0,4,5,"",null,19.816500000000001,0.26422000000000001]
["3347640","8","Ulster","30 - County","30","TOW PATH ROAD","STONY KILL      ",433,4.91,5,1959,800,4.3680000000000003,"Y","majorrehab",24,"2","N","09","1",0.36699999999999999,"3","Poor",5.8419999999999996,"2019-06-11",5.8419999999999996,"09",6,6,3.9285714285714306,5.692499999999999,6.1049999999999969,"Y",5,4.508,1.9809999999999999,8.1374999999999993,0.29500000000000082,0,1,5,24,null,24.850071428571432,0.33133428571428575]
["3347650","8","Ulster","30 - County","30","COUNTY ROAD 7   ","DWAAR KILL      ",1066,5.76,6,2006,1574,5.93,"N","cyclical",0,"4","N","09","1",4.7E-2,"6","Fair",5.577,"2018-08-29",5.577,"08",6,6,3.9285714285714306,7.3975000000000009,6.1049999999999969,"N",0,5.5580000000000007,5.5090000000000003,8.85,0,0,3,6,"",null,26.845571428571432,0.35794095238095242]
["3347660","8","Ulster","30 - County","30","DRY BROOK ROAD  ","RIDER HOLLOW STRM",27,4.76,12,1961,1548,5.1580000000000004,"N","cyclical",0,"4","N","09","2",3.5000000000000003E-2,"6","Fair",4.1920000000000002,"2018-06-05",4.1920000000000002,"09",5,5,7.8571428571428577,20.02,17.16,"N",0,0.58800000000000008,1.54,11,0,0,3,12,"",null,23.985142857142858,0.31980190476190479]
["3347680","8","Ulster","30 - County","30","DRY BROOK ROAD  ","DRY BROOK       ",27,4.76,2,1990,1716,6.0350000000000001,"N","cyclical",0,"4","N","09","1",1.9E-2,"7","Good",5.423,"2018-06-15",5.423,"09",5,5,7.8571428571428577,9.4324999999999974,17.16,"N",0,0.58800000000000008,1.54,4.8125,0,0,3,2,"",null,17.797642857142858,0.23730190476190477]
["3347690","8","Ulster","30 - County","30","COUNTY ROAD 32  ","PLATTEKILL CREEK",1376,4.1100000000000003,8,1969,2700,4.8280000000000003,"N","minorrehab",0,"5","N","09","1",0.09,"5","Fair",4.6840000000000002,"2018-09-27",4.6840000000000002,"17",5,5,7.8571428571428577,14.904999999999999,17.16,"N",0,5.6909999999999998,1.4279999999999999,9.6999999999999993,0,0,4,8,"",null,28.676142857142857,0.38234857142857143]
["3347700","8","Ulster","30 - County","30","SAMSONVILLE ROAD","METTACAHONTS CRK",null,6.04,23,2000,1586,4.4740000000000002,"Y","majorrehab",0,"5","N","09","2",0.34300000000000003,"4","Poor",4.327,"2018-07-03",4.327,"08",4,4,11.785714285714286,18.424999999999997,24.75,"Y",5,"",5.628000000000001,11.5875,0,0,4,23,"",null,38.00121428571429,0.50668285714285721]
["3347710","8","Ulster","30 - County","30","TANNERY BROOK RD","SAW KILL        ",1442,1.84,11,1961,1560,4.4740000000000002,"N","deckrepl",0,"5","N","09","2",0.1,"5","Fair",5.077,"2019-07-02",5.077,"17",4,4,11.785714285714286,11.274999999999999,24.75,"N",0,5.7539999999999996,0.46200000000000002,10.862499999999999,0,0,4,11,"",null,32.864214285714283,0.43818952380952375]
["3347730","8","Ulster","41 - Village","41","HUGUENOT STREET ","TRIBUTARY 13    ",200,3.92,1,1983,616,4.7619999999999996,"N","cyclical",0,"5","N","41","5",9.8000000000000004E-2,"6","Fair",3.706,"2019-04-30",3.706,"19",5,5,7.8571428571428577,23.65,17.16,"N",0,3.0730000000000004,0.95900000000000007,0.77500000000000002,0,0,4,1,"",null,16.664142857142856,0.22218857142857143]
["3347740","8","Ulster","30 - County","30","UPPR CHERRYTWN RD","MOMBACCUS CREEK ",383,4.91,3,1963,2700,5.6550000000000002,"Y","deckrepl",0,"5","N","09","1",7.3999999999999996E-2,"5","Fair",5.431,"2018-11-20",5.431,"09",5,5,7.8571428571428577,9.322499999999998,17.16,"N",0,4.1509999999999998,1.9809999999999999,6.4375,0,0,4,3,"",null,24.426642857142856,0.32568857142857138]
["3347750","8","Ulster","30 - County","30","FISH CREEK ROAD ","PLATTEKILL CREEK",879,6.04,9,1965,2700,4.8,"N","vertdown",0,"4","N","09","1",8.2000000000000003E-2,"5","Fair",4.2729999999999997,"2018-08-06",4.2729999999999997,"08",5,5,7.8571428571428577,18.865000000000002,17.16,{"$f":"IF(W220=\"Poor\", \"Y\", \"N\")","v":"N"},0,5.327,5.628000000000001,9.9500000000000011,0,0,3,9,"",null,31.762142857142859,0.42349523809523809]
["3347770","8","Ulster","30 - County","30","BURLINGHAM ROAD","PLATTE KILL     ",2104,3.8,2,1965,1300,6.1669999999999998,"N","cyclical",0,"4","N","09","1",4.1000000000000002E-2,"6","Fair",6.0339999999999998,"2018-03-14",6.0339999999999998,"08",5,5,7.8571428571428577,4.3449999999999989,17.16,"N",0,6.181,0.84,4.8125,0,0,3,2,"",null,22.690642857142858,0.30254190476190479]
["3347780","8","Ulster","30 - County","30","METTACAHONTS ROAD","ROCHESTER CREEK ",657,4.91,4,1965,1500,5.0860000000000003,"Y","maintproject",15,"5","N","09","1",0.128,"4","Poor",5.069,"2019-09-17",5.069,"09",4,4,{"$f":"27.5-(AC222*(27.5/7))","v":11.785714285714286},11.495000000000001,24.75,"Y",5,5.0680000000000005,1.9809999999999999,7.4749999999999996,2.9450000000000003,0,4,4,15,null,38.254714285714286,0.51006285714285715]
["3347790","8","Ulster","30 - County","30","CLRK VANVLERDN RD","PLATTEKILL CREEK",null,10,1,1966,1600,5.1150000000000002,"N","cyclical",15,"3","N","09","1",9.1999999999999998E-2,"5","Fair",5.25,"2019-06-05",5.25,"09",5,5,7.8571428571428577,10.23,17.16,"N",0,"",6.6150000000000002,0.77500000000000002,2.9450000000000003,0,2,1,15,null,20.192142857142859,0.26922857142857143]
["3347800","8","Ulster","30 - County","30","BRIDGE STREET   ","ESOPUS CREEK    ",1213,4.91,1,1976,8800,4.3330000000000002,"N","majorrehab",0,"3","N","09","2",0.28699999999999998,"4","Poor",3.9060000000000001,"2018-06-19",3.9060000000000001,"09",4,4,11.785714285714286,21.945,24.75,"Y",5,5.6560000000000006,1.9809999999999999,0.77500000000000002,0,0,2,1,"",null,27.197714285714287,0.3626361904761905]
["3347810","8","Ulster","30 - County","30","BEECH HILL ROAD ","BEAVER KILL     ",86,7.14,2,1969,2400,4.8789999999999996,"N","deckrepl",15,"4","N","09","1",8.7999999999999995E-2,"5","Fair",4.7069999999999999,"2019-08-14",4.7069999999999999,"09",5,5,7.8571428571428577,14.4375,17.16,"N",0,1.9949999999999999,6.3560000000000008,4.8125,2.9450000000000003,0,3,2,15,null,26.965642857142861,0.35954190476190478]
["3347820","8","Ulster","30 - County","30","ZENA HIGHWOODS RD","SAW KILL        ",null,10,1,1968,2800,5.6550000000000002,"N","cyclical",0,"5","N","09","1",1.7000000000000001E-2,"5","Fair",5.5279999999999996,"2018-07-26",5.5279999999999996,"09",4,4,11.785714285714286,8.0850000000000009,24.75,"N",0,"",6.6150000000000002,0.77500000000000002,0,0,4,1,"",null,23.175714285714285,0.30900952380952379]
["3347830","8","Ulster","30 - County","30","PALENTOWN ROAD  ","METTACAHONTS CRK",383,4.91,1,2000,942,4.93,"N","minorrehab",0,"4","N","09","2",4.3999999999999997E-2,"5","Fair",4.9619999999999997,"2018-07-03",4.9619999999999997,"09",4,4,11.785714285714286,12.402499999999998,24.75,"N",0,4.1509999999999998,1.9809999999999999,0.77500000000000002,0,0,3,1,"",null,21.692714285714288,0.28923619047619054]
["3347840","8","Ulster","30 - County","30","FLOYD ACKERT ROAD","BLACK CREEK     ",null,4.91,2,1967,1074,5.1580000000000004,"N","cyclical",0,"5","N","09","2",1.4E-2,"4","Poor",3.3929999999999998,"2019-05-22",3.3929999999999998,"09",4,4,11.785714285714286,25.684999999999999,24.75,"Y",5,"",1.9809999999999999,4.8125,0,0,4,2,"",null,27.579214285714286,0.36772285714285713]
["3347850","8","Ulster","30 - County","30","COUNTY ROAD 47  ","BUSHNELLSVILLE CK",156,4.91,1,1995,1693,4.1150000000000002,"N","deckrepl",0,"4","N","09","2",0.13600000000000001,"4","Poor",4.1790000000000003,"2018-08-30",4.1790000000000003,"09",4,4,11.785714285714286,20.13,24.75,"Y",5,2.7090000000000001,1.9809999999999999,0.77500000000000002,0,0,3,1,"",null,25.250714285714288,0.33667619047619052]
["3347860","8","Ulster","30 - County","30","POWDERMILL ROAD ","SAW KILL        ",136,3.92,99,1970,2600,4.9829999999999997,"N","maintproject",0,"5","N","09","1",7.0999999999999994E-2,"5","Fair",4.9059999999999997,"2018-08-09",4.9059999999999997,"19",4,4,11.785714285714286,12.842499999999999,24.75,"N",0,2.4500000000000002,0.95900000000000007,13.5,0,0,4,"","",null,32.694714285714284,0.43592952380952377]
["3347870","8","Ulster","30 - County","30","ARROWHEAD ROAD  ","SANDBURG CREEK  ",537,3.92,1,1970,2100,4.7759999999999998,"N","majorrehab",0,"3","N","09","1",0.22800000000000001,"5","Fair",4.774,"2018-09-26",4.774,"19",5,5,7.8571428571428577,13.639999999999999,17.16,"N",0,4.8020000000000005,0.95900000000000007,0.77500000000000002,0,0,2,1,"",null,16.393142857142859,0.21857523809523813]
["3364960","8","Ulster","40 - Town","40","SHEELEY ROAD","SUNDOWN CREEK   ",13,4.91,99,1956,559,5.1749999999999998,"N","cyclical",0,"4","N","09","1",6.7000000000000004E-2,"6","Fair",4.8819999999999997,"2019-08-28",4.8819999999999997,"09",5,5,7.8571428571428577,13.089999999999998,17.16,"N",0,0.39200000000000002,1.9809999999999999,13.5,0,0,3,"","",null,26.730142857142859,0.35640190476190481]
["3365180","8","Ulster","30 - County","30","CROSS MOUNTAIN RD","ALDER CREEK     ",125,4.91,9,1994,559,6.1849999999999996,"N","cyclical",0,"5","N","27","B",5.0999999999999997E-2,"5","Fair",6,"2018-09-26",6,"09",6,6,3.9285714285714306,4.8949999999999996,6.1049999999999969,"N",0,2.3170000000000002,1.9809999999999999,9.9500000000000011,0,0,4,9,"",null,22.176571428571432,0.29568761904761909]
["3365190","8","Ulster","30 - County","30","OLD GREENFIELD RD","W BRNCH BEER KILL",82,3.85,1,1924,1800,4.49,"N","maintproject",0,"5","N","09","1",8.7999999999999995E-2,"5","Fair",4.532,"2019-06-11",4.532,"19",4,4,11.785714285714286,16.72,24.75,"N",0,1.8270000000000002,0.90300000000000002,0.77500000000000002,0,0,4,1,"",null,19.290714285714287,0.25720952380952383]
["3365200","8","Ulster","30 - County","30","CR 40           ","BEAVER KILL     ",801,2.76,1,1991,1970,5.4039999999999999,"N","majorrehab",0,"4","Y","19","1",0.25800000000000001,"6","Fair",5.5259999999999998,"2019-07-09",5.5259999999999998,"09",5,5,7.8571428571428577,8.1950000000000003,17.16,"N",0,5.2990000000000004,0.55300000000000005,0.77500000000000002,0,5,3,1,"",null,22.48414285714286,0.29978857142857146]
["3365210","8","Ulster","30 - County","30","COUNTY ROAD 6","COXING KILL     ",null,4.91,1,2006,1529,6.298,"N","cyclical",0,"4","N","09","1",1.7000000000000001E-2,"7","Good",4.6150000000000002,"2018-11-08",4.6150000000000002,"09",6,6,3.9285714285714306,15.592499999999999,6.1049999999999969,"N",0,"",1.9809999999999999,0.77500000000000002,0,0,3,1,"",null,9.6845714285714308,0.12912761904761907]
["3365220","8","Ulster","30 - County","30","PANCAKE HOLLOW RD","BLACK CREEK     ",2238,7.87,4,1963,800,4.5650000000000004,"N","majorrehab",0,"4","N","01","B",0.251,"5","Fair",5.6959999999999997,"2018-08-14",5.6959999999999997,"19",5,5,7.8571428571428577,6.7099999999999973,17.16,"N",0,6.2440000000000007,6.44,7.4749999999999996,0,0,3,4,"",null,31.016142857142857,0.41354857142857143]
["3365230","8","Ulster","30 - County","30","CROSS MOUNTAIN RD","ALDER CREEK     ",125,4.91,9,1994,864,5.9630000000000001,"N","cyclical",0,"4","N","27","B",5.0999999999999997E-2,"6","Fair",4.5449999999999999,"2018-10-10",4.5449999999999999,"09",5,5,7.8571428571428577,16.252499999999998,17.16,"N",0,2.3170000000000002,1.9809999999999999,9.9500000000000011,0,0,3,9,"",null,25.105142857142859,0.33473523809523814]
["3370210","8","Ulster","30 - County","30","PEEKAMOOSE ROAD","PEEKAMOOSE LAKE INLET",42,6.04,6,1992,774,4.7779999999999996,"N","cyclical",null,"4","N","27","B",8.6999999999999994E-2,"5","Fair",4.5449999999999999,"2019-07-10",4.5449999999999999,"08",4,4,11.785714285714286,16.252499999999998,24.75,"N",0,1.0780000000000001,5.628000000000001,8.85,0,0,3,6,"",null,30.341714285714289,0.40455619047619051]
["3370570","8","Ulster","30 - County","30","NEW HILL ROAD","TRIB E BR NEVERSINK RIVER",null,4.91,0,2001,915,4.6669999999999998,"N","cyclical",null,"4","N","42","7",0.113,"6","Fair",5,"2018-08-03",5,"09",5,5,7.8571428571428577,12.182499999999997,17.16,"N",0,"",1.9809999999999999,0,0,0,3,0,"",null,12.838142857142858,0.1711752380952381]
["3370580","8","Ulster","30 - County","30","DENNING  ROAD","Flat Brook",265,4.91,99,1970,410,5,"N","cyclical",0,"5","N","26","7",0.14499999999999999,"5","Fair",4,"2018-07-23",4,"09",5,5,7.8571428571428577,21.2575,17.16,"N",0,3.6260000000000003,1.9809999999999999,13.5,0,0,4,"","",null,30.964142857142861,0.41285523809523816]
["3370870","8","Ulster","30 - County","30","CR 47","Giant Ledge Strea",404,6.04,25,2012,1653,6.0179999999999998,"N","cyclical",null,"4","Y","11","1",0.11899999999999999,"7","Good",5.9470000000000001,"2018-05-17",5.9470000000000001,"08",6,6,3.9285714285714306,5.2524999999999977,6.1049999999999969,"N",0,4.2839999999999998,5.628000000000001,11.7125,0,5,3,25,"",null,33.553071428571428,0.44737428571428572]
["3371380","8","Ulster","30 - County","30","County Road 82","Trib. Black Creek",null,0,3,2009,630,null,"N","N/A",null,"","N","09","3",null,{"$error":"#N/A"},{"$error":"#N/A"},6.423,"2019-04-24",6.423,{"$error":"#N/A"},5,5,7.8571428571428577,2.8599999999999994,17.16,{"$error":"#N/A"},"","",0,6.4375,0,0,0,3,"",null,14.294642857142858,0.1905952380952381]