Back to dataset
Filter drains in DevonFilter drains in Devon CSV
You're previewing the first 4 rows of this file.
Download this file| FILTER_DRAIN_UID | ST_CHAINAGE | END_CHAINAGE | ACTUAL_LENGTH | BINDER_UID | ITEM_UID | ITEM_TYPE_UID | EASTING | NORTHING | ITEM_IDENTITY_CODE | COMMENTS | LOCATION_DESCRIPTION | LAST_INSPECTED_DATE | INSPECT_UID | START_DATE | END_DATE | END_DATED | PARISH_UID | LOCAL_SERVICE_GROUP_UID | AREA_OFFICE_UID | HIMS_REFERENCE | LAST_EDIT_DATE | LAST_EDIT_USER_UID | BLCE | BLCN | TRCE | TRCN | POINTS | PARENT_UID | FAMILY_UID | PREVIOUS_STREET | HIMS_ULR_ID | HIMS_HI_SQ | HIPOSCD_UID | DIGITAL_LENGTH | DIGITAL_AREA | SHAPE_GEOMETRY | SHAPE_GEOGRAPHY | MAINTENANCE_POLICY_EXCEPTION | MAINTENANCE_RESPONSIBILITY_UID | OWNER_OF_INVENTORY_ITEM_UID | CW_MAINTENANCE_HIERARCHY_NAME | SALTED_ROUTE_NAME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2035554 | 193 | 240 | 0 | 2 | 2035554 | 38 | 284560 | 77092 | 2035554 | Not set | ? | 19/01/1994 00:00:00 | 0 | 19/01/1994 00:00:00 | 01/01/9999 00:00:00 | False | 1841425 | 5 | 3 | U/3370/8010 | 01/01/9999 00:00:00 | 0 | 284560 | 77037 | 284593 | 77092 | 284560 77092 284580 77066 284580 77066 284593 77037 | 0 | 2035554 | 0 | 77099 | 80 | 9 | 64.58 | 64.58 | LINESTRING (284560 77092, 284580 77066, 284593 77037) | LINESTRING (-3.6319038572677664 50.582123856437377, -3.6316134073222357 50.581894093577546, -3.6314208569934103 50.581635977560005) | False | 0 | 0 | 17 - Private | ? |
| 2035555 | 197 | 236 | 0 | 2 | 2035555 | 38 | 284569 | 77091 | 2035555 | Not set | ? | 19/01/1994 00:00:00 | 0 | 19/01/1994 00:00:00 | 01/01/9999 00:00:00 | False | 1841425 | 5 | 3 | U/3370/8010 | 01/01/9999 00:00:00 | 0 | 284569 | 77045 | 284596 | 77091 | 284569 77091 284585 77069 284596 77045 | 0 | 2035555 | 0 | 77099 | 82 | 4 | 53.6 | 53.6 | LINESTRING (284569 77091, 284585 77069, 284596 77045) | LINESTRING (-3.6317764796181931 50.582116648042593, -3.631543747098585 50.581922050474454, -3.6313809872710827 50.581708484895323) | False | 0 | 0 | 17 - Private | ? |
| 2035230 | 0 | 230 | 0 | 2 | 2035230 | 38 | 321442 | 99974 | 2035230 | Not set | ? | 12/12/1991 00:00:00 | 0 | 12/12/1991 00:00:00 | 01/01/9999 00:00:00 | False | 3812354 | 12 | 1 | A/35/40240 | 01/01/9999 00:00:00 | 0 | 321442 | 99974 | 321663 | 100002 | 321442 99974 321456 99979 321456 99979 321480 99985 321480 99985 321541 99994 321541 99995 321593 100001 321594 100002 321625 100002 321625 100002 321656 99997 321656 99997 321663 99995 | 0 | 2035230 | 0 | 67177 | 8 | 9 | 225.71 | 225.71 | LINESTRING (321442 99974, 321456 99979, 321480 99985, 321541 99994, 321541 99995, 321593 100001, 321594 100002, 321625 100002, 321656 99997, 321663 99995) | LINESTRING (-3.1159595498940815 50.793990585254811, -3.1157620258047718 50.794037439727113, -3.1154228616939932 50.794094641579036, -3.1145594789010138 50.794183832376817, -3.1145596928024291 50.794192823228876, -3.1138233341063026 50.794253815813036, -3.113809362436271 50.794262942149892, -3.1133696140286951 50.794267141256682, -3.1129287975704494 50.794226384421407, -3.1128290724604941 50.79420935028709) | False | 0 | 0 | 2 - Primary National (T) | ? |
| 2034243 | 0 | 18 | 8.9 | 2 | 2034243 | 38 | 296608 | 91558 | 2034243 | Not set | ? | 20/04/1995 00:00:00 | 0 | 20/04/1995 00:00:00 | 01/01/9999 00:00:00 | False | 1841583 | 3 | 1 | C/579/20050 | 01/01/9999 00:00:00 | 0 | 296605 | 91540 | 296608 | 91558 | 296608 91558 296605 91550 296606 91540 | 0 | 2034243 | 0 | 22322 | 5 | 2 | 18.59 | 18.59 | LINESTRING (296608 91558, 296605 91550, 296606 91540) | LINESTRING (-3.46583519598724 50.714430783290879, -3.4658754300818919 50.714358331173727, -3.4658584658020217 50.714268611931253) | False | 0 | 0 | 3 National Primary Route (C) | Primary Salted |