{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["FL 2018 DIRT ADL Template","Data Sources"],"not_rendered":{"defined_names":16},"read":"whole","date_system":"1904"}

{"sheet":"FL 2018 DIRT ADL Template","index":0,"n_rows":1,"n_cols":38,"rows_kept":1}
["SPEC_VERSION","ORIG_EVENT_SOURCE","EVENT_TYPE","DATE_OF_EVENT","COUNTRY","STATE_PROV","COUNTY","CITY","ADDRESS","INTERSECTION","LATITUDE","LONGITUDE","RIGHTOFWAY_TYPE","FAC_DAMAGED","WAS_CROSSBORE","FAC_DEPTH_IN","FAC_AFFECTED","JOINT_TRENCH","ONECALL_MEMBER","ONECALL_EXEMPT","EXCAVATOR_TYPE","EXCAVATION_TYPE","WORK_PERFORMED","WAS_ONECALL_NOTIF","ONECALL_TICKET_NUM","LOCATE_ORG","WHITE_LINED","EXCAV_EXEMPT","EXCAVATOR_DOWN","EXCAVATOR_DOWN_TIME","EXCAVATOR_DOWN_COST","SERVICE_INTERRUPTED","OUTAGE_HOURS","CUSTOMERS_AFFECTED","REPAIR_RESTORAL_COST","DAMAGE_CAUSE","DAMAGE_OTHER_DESC","ADDITIONAL_COMMENTS"]

{"sheet":"Data Sources","index":1,"n_rows":68,"n_cols":13,"rows_kept":68}
["ORIG_EVENT_SOURCE_DESCRIPTION","EVENT_TYPE_ID","COUNTY","RIGHTOFWAY_TYPE_DESCRIPTION","FAC_DAMAGED_DESCRIPTION","FAC_AFFECTED_DESCRIPTION","WORK_PERFORMED_DESCRIPTION","LOCATE_ORG_DESCRIPTION","DAMAGE_CAUSE_DESCRIPTION","Description","Description","WORK_TYPE","TRUE-FALSE"]
["Electric","Underground Damage","Alachua","Public - City Street","Cable TV","Distribution","Agriculture","Utility Owner","          N/A-One Call Notification Issue (choose one):","Contractor","Auger","Agriculture",true]
["Engineer/Design","Underground Near Miss","Baker","Public - State Highway","Electric","Gathering","Cable TV","Contract Locator","One Call Notification Issue (choose one):","County","Backhoe/Trackhoe","Cable TV","False "]
["Equipment Manufacturer","Above Ground/Surface","Bay","Public - County Road","Natural Gas","Service/Drop","Curb/Sidewalk","Unknown/Other","No notification made to One-Call Center / 811","Developer","Boring","Curb/Sidewalk"]
["Excavator","Aerial","Bradford","Public - Interstate Highway","Liquid Pipeline","Transmission","Bldg. Construction",null,"Excavator dug outside area described on ticket","Farmer","Bulldozer","Bldg. Construction"]
["Liquid Pipeline","Natural Cause","Brevard","Public - Other","Sewer","Unknown/Other","Bldg. Demolition",null,"Excavator dug prior to valid start date/time","Municipality","Drilling","Bldg. Demolition"]
["Locator","Submarine","Broward","Private - Land Owner","Steam",null,"Drainage",null,"Excavator dug after valid ticket expired","Occupant","Directional Drilling","Drainage"]
["Natural Gas",null,"Calhoun","Private - Business","Telecommunications",null,"Driveway",null,"Excavator provided incorrect notification information","Railroad","Explosives","Driveway"]
["Private Water",null,"Charlotte","Private Easement","Water",null,"Electric",null,"          N/A-Facility not marked due to: (choose one):","State","Farm Equipment","Electric"]
["Public Works",null,"Citrus","Pipeline","Unknown/Other",null,"Engineering/Surveying",null,"No response from operator/contract locator","Utility","Grader/Scraper","Engineering/Surveying"]
["Railroad",null,"Clay","Power/Transmission Line",null,null,"Fencing",null,"Not marked due to Abandoned facility","Unknown/Other","Hand Tools","Fencing"]
["Road Builders",null,"Collier","Railroad",null,null,"Grading",null,"Not marked due to Incorrect facility records/maps",null,"Milling Equipment","Grading"]
["Federal/State Regulator",null,"Columbia","Dedicated Public Utility Easement",null,null,"Irrigation",null,"Not marked due to Locator error",null,"Probing Device","Irrigation"]
["Telecommunications",null,"Dade","Federal Land",null,null,"Landscaping",null,"Not marked due to Tracer wire issue",null,"Trencher","Landscaping"]
["Unknown/Other",null,"DeSoto","Unknown/Other",null,null,"Liquid Pipeline",null,"Site marked but incomplete at damage location",null,"Vacuum Equipment","Liquid Pipeline"]
[null,null,"Dixie",{"$nulls":3},"Milling",null,"Unlocatable facility",null,"Unknown/Other","Milling"]
[null,null,"Duval",{"$nulls":3},"Natural Gas",null,"         N/A-Facility marked inaccurately due to: (choose one):",null,null,"Natural Gas"]
[null,null,"Escambia",{"$nulls":3},"Pole",null,"Marked inaccurately due to Abandoned Facility",null,null,"Pole"]
[null,null,"Flagler",{"$nulls":3},"Public Transit Authority",null,"Marked inaccurately due to Incorrect facility record/maps",null,null,"Public Transit Authority"]
[null,null,"Franklin",{"$nulls":3},"Railroad Maintenance",null,"Marked inaccurately due to Locator error",null,null,"Railroad Maintenance"]
[null,null,"Gadsden",{"$nulls":3},"Road Work",null,"Marked inaccurately due to Tracer wire issue",null,null,"Road Work"]
[null,null,"Gilchrist",{"$nulls":3},"Sewer (Sanitary/Storm)",null,"         N/A-Excavation Issue (choose one):",null,null,"Sewer (Sanitary/Storm)"]
[null,null,"Glades",{"$nulls":3},"Site Development",null,"Excavator dug prior to verifying marks by test-hole (pot-hole)",null,null,"Site Development"]
[null,null,"Gulf",{"$nulls":3},"Steam",null,"Excavator failed to maintain clearance after verifying marks",null,null,"Steam"]
[null,null,"Hamilton",{"$nulls":3},"Storm Drain/Culvert",null,"Marks faded, lost or not maintained",null,null,"Storm Drain/Culvert"]
[null,null,"Hardee",{"$nulls":3},"Street Light",null,"Excavator failed to shore excavation/support facilities",null,null,"Street Light"]
[null,null,"Hendry",{"$nulls":3},"Telecommunications",null,"Improper backfilling",null,null,"Telecommunications"]
[null,null,"Hernando",{"$nulls":3},"Traffic Signal",null,"Improper excavation practice not listed above",null,null,"Traffic Signal"]
[null,null,"Highlands",{"$nulls":3},"Traffic Sign",null,"         N/A-Miscellaneous Root Causes (choose one):",null,null,"Traffic Sign"]
[null,null,"Hillsborough",{"$nulls":3},"Water",null,"One-Call Center error",null,null,"Water"]
[null,null,"Holmes",{"$nulls":3},"Waterway Improvement",null,"Deteriorated facility",null,null,"Waterway Improvement"]
[null,null,"Indian River",{"$nulls":3},"Unknown/Other",null,"Previous damage",null,null,"Unknown/Other"]
[null,null,"Jackson",{"$nulls":5},"Root Cause not listed above (comment required)"]
[null,null,"Jefferson"]
[null,null,"Lafayette"]
[null,null,"Lake"]
[null,null,"Lee"]
[null,null,"Leon"]
[null,null,"Levy"]
[null,null,"Liberty"]
[null,null,"Madison"]
[null,null,"Manatee"]
[null,null,"Marion"]
[null,null,"Martin"]
[null,null,"Monroe"]
[null,null,"Nassau"]
[null,null,"Okaloosa"]
[null,null,"Okeechobee"]
[null,null,"Orange"]
[null,null,"Osceola"]
[null,null,"Palm Beach"]
[null,null,"Pasco"]
[null,null,"Pinellas"]
[null,null,"Polk"]
[null,null,"Putnam"]
[null,null,"Santa Rosa"]
[null,null,"Sarasota"]
[null,null,"Seminole"]
[null,null,"St. Johns"]
[null,null,"St. Lucie"]
[null,null,"Sumter"]
[null,null,"Suwannee"]
[null,null,"Taylor"]
[null,null,"Union"]
[null,null,"Volusia"]
[null,null,"Wakulla"]
[null,null,"Walton"]
[null,null,"Washington"]