Name: Pothole_Defects
Display Field: DEFECT_RID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 16995894.993513
YMin: -3176156.20183439
XMax: 17054690.5958045
YMax: -3099563.39832375
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"uniqueValue","valueExpression":"var other_types = ['AI.RDS.EDGEDAMAGE', 'AI.RDS.POTHOLE', 'RAD009', 'RAD010', 'RAD025', 'RAD045', '', 'RD_DAMAGE', 'WR.EDGEBREAK', 'WR.POTHOLES']\nif ($feature.DEFECT_CODE == 'RD_DAMAG') {\n if ($feature.DEFECT_STAGE == 'R') {\n if (DateDiff(Date($feature.RequiredBy), Now(), 'days') > 7) {\n //'RD_DAMAG, R, Required by date is more than 7 days away'\n return 'CSR Recorded'\n }\n else{\n if (DateDiff(Date($feature.RequiredBy), Now(), 'days') >= 0){\n //'RD_DAMAG, R, Required by date is within 7 days'\n return 'CSR Nearing due date'\n }\n else{\n //'RD_DAMAG, R, Required by date has passed'\n return 'CSR Overdue'\n }\n }\n }\n else if ($feature.DEFECT_STAGE == 'P') {\n //'RD_DAMAG, P'\n return 'CSR In progress'\n }\n else if ($feature.DEFECT_STAGE == 'W') {\n //'RD_DAMAG, W'\n return 'CSR Completed'\n }\n}\nelse {\n if ($feature.DEFECT_STAGE == 'R') {\n if (Includes(other_types, $feature.DEFECT_CODE)) {\n //'R'\n return 'Recorded'\n }\n }\n else if ($feature.DEFECT_STAGE == 'A' || $feature.DEFECT_STAGE == 'P') {\n if (Includes(other_types, $feature.DEFECT_CODE)) {\n //'A and P'\n return 'In progress'\n }\n }\n else if ($feature.DEFECT_STAGE == 'W') {\n if (Includes(other_types, $feature.DEFECT_CODE)) {\n //'W'\n return 'Completed'\n }\n }\n}","valueExpressionTitle":"Coded","uniqueValueGroups":[{"heading":"Coded","classes":[{"label":"Recorded","description":"Recorded","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[115,178,255,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"values":[["Recorded"]]},{"label":"In progress","description":"In progress","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"values":[["In progress"]]},{"label":"Completed","description":"Completed","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[85,255,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"values":[["Completed"]]},{"label":"CSR Recorded","description":"CSR Recorded","symbol":{"type":"esriPMS","url":"9cd7dfafa349ea99cc36c8588c83371b","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAiCAYAAABfqvm9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABvklEQVRIid2Wv0rDQBzHP0NewEns6AMIGt9ABYe66SZ0MnUvFJysk1DobuMkdKubDoL1DSxCHqCbQqe+gnzDXTnzP20nv3CkTS7ffH93n7vEY8Py/o3h0BzbmzAMTJOmQLiOYUNmu+zFf2ZEvXUNm4B/TocttrnhdAfomVbb0NfY+ZygJinpjOgWeDHl1zKMUyidVZcnrtm3187qGPoq95jLOJWVyta5CaN4KLJSennpdLObzkrnJowsSodVDIVI005EUjp3QYcxA9/0DYsMl5iotDzpYVPeMzHy8jApk/r0aaUw8pKYKJ3FpEjq42AUAj9Jw/gpV/SpKgejocXIK8KkTFkYeckO68ozRwH6OmbQPDBjU0UzIstkaCF3E2qv+36kyz1vlQyfGdifS3RcQ81SOCMK9OSylOJQDSdd0tCmDPq0eOCrSropcFe29NoL5kONTd5q0TVV4fJXZKhOwSNdP8tQRk66sOpuo9I/NUFJ0D8YsWBOstQywxgjAXvkwJ7ARLt2rR07hVEWJnUM/2CkMrMwqfvWW2JklmUKk1Ve9DFGZiJSmKxiGJqdpFH2kqfGt03pN01dw8rauOEvmSiUNyrCrp8AAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":25,"angle":0,"xoffset":0,"yoffset":0},"values":[["CSR Recorded"]]},{"label":"CSR In progress","description":"CSR In progress","symbol":{"type":"esriPMS","url":"c78cbb7d67306f4c9d01bf9be448a170","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAiCAYAAABfqvm9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABl0lEQVRIid2W0bGDIBRE94MmYhukDE0ZWEZIGdqGKSOUEdPGm0VwCKKI5uvtTMaM4rL3chQFfizxbww7d2x/YajcjzIA+jOGFc2kdG4G+qxhDUBqDVwuwPWKC2BN9RFDyd41DVDX7oS0Ke8ABld+kaFNceftTsMAVNV8rSkxlCxXqSmVF8vmub6fWpFKKdbSMQl7t7igraFH6brHkIjULJWJYvEcTbW2CVW86mINE5a2Jk7GfqYwEmuY5MQxTbPESMSYMJ3HZEscE2DUAxhjQztL55/aHQow6jxGYguTnFIYiXCAm+2UhDsS0KfWqH1v9siYmcneQx4m5Lvu3bbA67XP8PGY/87ohIZcpd4YKM6cS/l8TouCIF1s6FOq2w14v7cNHauGQXOPXjuO6NibtaeF11hFyN+WIQeptoVMGdLI9S65HQikxdJfXKAYdKYbp0xfpeYMLUYENoQ9wmRakoI39gKjFCYlhl8YfT5pTEp3vRkj97JdYHJko7cYuYVYYHLEkCZcliq3yaPg2yb7TVNquFs/N/wD3/GT44oVYwAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":25,"angle":0,"xoffset":0,"yoffset":0},"values":[["CSR In progress"]]},{"label":"CSR Nearing due date","description":"CSR Nearing due date","symbol":{"type":"esriPMS","url":"1c0d95bfe7cace19bc2723f01da78f71","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAiCAYAAABfqvm9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABrUlEQVRIid2WsXHCMBiFX6EFKHHJCmKElCYdK9gjkA6nCyNYK1BCmRHwCnSQkhVyT5YcIcvIMlR5dxw+Wff8/l+fJQu8WOLfGNbmv3yFYWF+VANAPWOY0UwujNsZ1bOGOQBZrYH5DFh+YA5o02qKoWTvVhLIpRlY6JRbAAdTfpKhTrFd/w0cNkBWdvdWKYaS5RZvbSorls0x9d22IpRSDKXLZgB717ux1oYWpeUYQyKSs1Qm8sUxmlZ7nbDwV10MYcLShsSHHZowRmIIk5g4Z7XrYyR8TJjOYvJInONgpABcfUP9lNq+ZCPkYFRbjMQjTGIKYSTcCUTlWQnzT0CP1R657c0YNeeOSWUhdxOyG5dSAaevcYaf++6yQ8c15Cqp5oyCT46lPDYti3DS+YY2ZfG+Ay52jx5Q1aZrGDT26pXXG2r2Zuht4T1W4fL3yJCTilJBhgxpZHoXPA4EwmLpJy6QDzrTXW/68q7UmKHGiMC6sHuYcNdO2rF7GIUwSTG8w+jnFsYk9dTrMDKbbQ+TKQe9xsgsRA+TKYbK7CRZ7JBHwrdN9Jsm1XC0Xm74C6u1lCN3gcDwAAAAAElFTkSuQmCC","contentType":"image/png","width":15,"height":25,"angle":0,"xoffset":0,"yoffset":0},"values":[["CSR Nearing due date"]]},{"label":"CSR Overdue","description":"CSR Overdue","symbol":{"type":"esriPMS","url":"b8bc111574816c42b3ecd6f66caec99f","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAiCAYAAABfqvm9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABjUlEQVRIid2WzWnDMBiGn4N2CM0QgeKuEOjB3aCQmzNAwdem10IGsG8Fb9AeClkhoeAdWvAW5XOk2FYtW7Jz6gvCf+L1+0mPJSuuLPVvDDN93F7DMNFNdALyOYZLMVvpixJ2cw1jIHoCFsA93HA23U0xjGTs1oA0kSQt4Rl41+UHGdYpJJ3RG3DbPHsIMYyk3EedykjKlnuFHoq+lMqVbmGlM5J7RYPSnY+hIBKbibBlXrQ/J0zsWVcuTKQ0l8Tw4MBIuTAZk/TZ9GCkbExWLUyGtO5ilAM/tmH9llf81cIoMxipIUzG1IeRsjvMldJHAfRjD7EZGx+VDZO5gbydUNa67xT49DTcN6cXdNqGMkt5CUnpkfKgG610tqFJmWyAL790J+Bl7NPbVpAVA1+LPJMq2vwNGUqnJIWoz7Dspst9Vxsp/Zj2gC7pqvNpp9QxwxqjwoLdwkRW7aAV+w9GfZiEGHYwqhyYhO56F4wWDkymbPQ1RpUDkymGuV5JlmObPAH/NqP/NKGG3rq64S8PvWaw6l8ytgAAAABJRU5ErkJggg==","contentType":"image/png","width":15,"height":25,"angle":0,"xoffset":0,"yoffset":0},"values":[["CSR Overdue"]]},{"label":"CSR Completed","description":"CSR Completed","symbol":{"type":"esriPMS","url":"952000263bfd6efb8ecf272055e6314e","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAiCAYAAABfqvm9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABr0lEQVRIid2WoXbCMBiFr4jY5CSVk5sscnKy7DHax1h5DPoaRU5ujkiQOEBWMrlzm6QnpGnTAGr3HE6hDTf3T74kFbizxL8xXOlrcQ/DXH8oCaC6xTCh2VOqfjQS5a2GGYD0tQQeZsDXHDOgNS2vMUw5dskCmNEWAJM2Ep8Aal1+lGGb4oV/13qrgTrpni1iDFOW+5yrVEYsm/f2lRoKX0oxlO4xATh2rnhvX3UozacYEpGMpTKRK96j6bZsE+burIshTFjakNjZsfZjJIYwCYltvhd9jISLCdMZTMbENhZGFYCja9j2kppVO0EWRiuDkRjDJCQfRsJuQFRuldBXArrelsjM2ExRIzsmKwO5nZB73UEWwPtmmuFu2X3t0LENOUtVI5Gz51DK01qxCCuda2hS5j8fQHYYN9wq8iSAZWjpFecjVhybodXCZ6zC5m/MkI1yWSD1GdJIj533OBDwi6VvOEEu6Ex3VpkuSg0ZthgRWBt2BxM1JRE7dg8jHyYxhhcY/Z78mMSeeh1GerPtYXLNQd9ipCeih8k1hjThtCShQx4R7zbBd5pYw8m6u+EfSIuUWoQ94DoAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":25,"angle":0,"xoffset":0,"yoffset":0},"values":[["CSR Completed"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[115,178,255,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"value":"Recorded","label":"Recorded"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"value":"In progress","label":"In progress"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[85,255,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"value":"Completed","label":"Completed"},{"symbol":{"type":"esriPMS","url":"9cd7dfafa349ea99cc36c8588c83371b","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAiCAYAAABfqvm9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABvklEQVRIid2Wv0rDQBzHP0NewEns6AMIGt9ABYe66SZ0MnUvFJysk1DobuMkdKubDoL1DSxCHqCbQqe+gnzDXTnzP20nv3CkTS7ffH93n7vEY8Py/o3h0BzbmzAMTJOmQLiOYUNmu+zFf2ZEvXUNm4B/TocttrnhdAfomVbb0NfY+ZygJinpjOgWeDHl1zKMUyidVZcnrtm3187qGPoq95jLOJWVyta5CaN4KLJSennpdLObzkrnJowsSodVDIVI005EUjp3QYcxA9/0DYsMl5iotDzpYVPeMzHy8jApk/r0aaUw8pKYKJ3FpEjq42AUAj9Jw/gpV/SpKgejocXIK8KkTFkYeckO68ozRwH6OmbQPDBjU0UzIstkaCF3E2qv+36kyz1vlQyfGdifS3RcQ81SOCMK9OSylOJQDSdd0tCmDPq0eOCrSropcFe29NoL5kONTd5q0TVV4fJXZKhOwSNdP8tQRk66sOpuo9I/NUFJ0D8YsWBOstQywxgjAXvkwJ7ARLt2rR07hVEWJnUM/2CkMrMwqfvWW2JklmUKk1Ve9DFGZiJSmKxiGJqdpFH2kqfGt03pN01dw8rauOEvmSiUNyrCrp8AAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":25,"angle":0,"xoffset":0,"yoffset":0},"value":"CSR Recorded","label":"CSR Recorded"},{"symbol":{"type":"esriPMS","url":"c78cbb7d67306f4c9d01bf9be448a170","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAiCAYAAABfqvm9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABl0lEQVRIid2W0bGDIBRE94MmYhukDE0ZWEZIGdqGKSOUEdPGm0VwCKKI5uvtTMaM4rL3chQFfizxbww7d2x/YajcjzIA+jOGFc2kdG4G+qxhDUBqDVwuwPWKC2BN9RFDyd41DVDX7oS0Ke8ABld+kaFNceftTsMAVNV8rSkxlCxXqSmVF8vmub6fWpFKKdbSMQl7t7igraFH6brHkIjULJWJYvEcTbW2CVW86mINE5a2Jk7GfqYwEmuY5MQxTbPESMSYMJ3HZEscE2DUAxhjQztL55/aHQow6jxGYguTnFIYiXCAm+2UhDsS0KfWqH1v9siYmcneQx4m5Lvu3bbA67XP8PGY/87ohIZcpd4YKM6cS/l8TouCIF1s6FOq2w14v7cNHauGQXOPXjuO6NibtaeF11hFyN+WIQeptoVMGdLI9S65HQikxdJfXKAYdKYbp0xfpeYMLUYENoQ9wmRakoI39gKjFCYlhl8YfT5pTEp3vRkj97JdYHJko7cYuYVYYHLEkCZcliq3yaPg2yb7TVNquFs/N/wD3/GT44oVYwAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":25,"angle":0,"xoffset":0,"yoffset":0},"value":"CSR In progress","label":"CSR In progress"},{"symbol":{"type":"esriPMS","url":"1c0d95bfe7cace19bc2723f01da78f71","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAiCAYAAABfqvm9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABrUlEQVRIid2WsXHCMBiFX6EFKHHJCmKElCYdK9gjkA6nCyNYK1BCmRHwCnSQkhVyT5YcIcvIMlR5dxw+Wff8/l+fJQu8WOLfGNbmv3yFYWF+VANAPWOY0UwujNsZ1bOGOQBZrYH5DFh+YA5o02qKoWTvVhLIpRlY6JRbAAdTfpKhTrFd/w0cNkBWdvdWKYaS5RZvbSorls0x9d22IpRSDKXLZgB717ux1oYWpeUYQyKSs1Qm8sUxmlZ7nbDwV10MYcLShsSHHZowRmIIk5g4Z7XrYyR8TJjOYvJInONgpABcfUP9lNq+ZCPkYFRbjMQjTGIKYSTcCUTlWQnzT0CP1R657c0YNeeOSWUhdxOyG5dSAaevcYaf++6yQ8c15Cqp5oyCT46lPDYti3DS+YY2ZfG+Ay52jx5Q1aZrGDT26pXXG2r2Zuht4T1W4fL3yJCTilJBhgxpZHoXPA4EwmLpJy6QDzrTXW/68q7UmKHGiMC6sHuYcNdO2rF7GIUwSTG8w+jnFsYk9dTrMDKbbQ+TKQe9xsgsRA+TKYbK7CRZ7JBHwrdN9Jsm1XC0Xm74C6u1lCN3gcDwAAAAAElFTkSuQmCC","contentType":"image/png","width":15,"height":25,"angle":0,"xoffset":0,"yoffset":0},"value":"CSR Nearing due date","label":"CSR Nearing due date"},{"symbol":{"type":"esriPMS","url":"b8bc111574816c42b3ecd6f66caec99f","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAiCAYAAABfqvm9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABjUlEQVRIid2WzWnDMBiGn4N2CM0QgeKuEOjB3aCQmzNAwdem10IGsG8Fb9AeClkhoeAdWvAW5XOk2FYtW7Jz6gvCf+L1+0mPJSuuLPVvDDN93F7DMNFNdALyOYZLMVvpixJ2cw1jIHoCFsA93HA23U0xjGTs1oA0kSQt4Rl41+UHGdYpJJ3RG3DbPHsIMYyk3EedykjKlnuFHoq+lMqVbmGlM5J7RYPSnY+hIBKbibBlXrQ/J0zsWVcuTKQ0l8Tw4MBIuTAZk/TZ9GCkbExWLUyGtO5ilAM/tmH9llf81cIoMxipIUzG1IeRsjvMldJHAfRjD7EZGx+VDZO5gbydUNa67xT49DTcN6cXdNqGMkt5CUnpkfKgG610tqFJmWyAL790J+Bl7NPbVpAVA1+LPJMq2vwNGUqnJIWoz7Dspst9Vxsp/Zj2gC7pqvNpp9QxwxqjwoLdwkRW7aAV+w9GfZiEGHYwqhyYhO56F4wWDkymbPQ1RpUDkymGuV5JlmObPAH/NqP/NKGG3rq64S8PvWaw6l8ytgAAAABJRU5ErkJggg==","contentType":"image/png","width":15,"height":25,"angle":0,"xoffset":0,"yoffset":0},"value":"CSR Overdue","label":"CSR Overdue"},{"symbol":{"type":"esriPMS","url":"952000263bfd6efb8ecf272055e6314e","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAiCAYAAABfqvm9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAABr0lEQVRIid2WoXbCMBiFr4jY5CSVk5sscnKy7DHax1h5DPoaRU5ujkiQOEBWMrlzm6QnpGnTAGr3HE6hDTf3T74kFbizxL8xXOlrcQ/DXH8oCaC6xTCh2VOqfjQS5a2GGYD0tQQeZsDXHDOgNS2vMUw5dskCmNEWAJM2Ep8Aal1+lGGb4oV/13qrgTrpni1iDFOW+5yrVEYsm/f2lRoKX0oxlO4xATh2rnhvX3UozacYEpGMpTKRK96j6bZsE+burIshTFjakNjZsfZjJIYwCYltvhd9jISLCdMZTMbENhZGFYCja9j2kppVO0EWRiuDkRjDJCQfRsJuQFRuldBXArrelsjM2ExRIzsmKwO5nZB73UEWwPtmmuFu2X3t0LENOUtVI5Gz51DK01qxCCuda2hS5j8fQHYYN9wq8iSAZWjpFecjVhybodXCZ6zC5m/MkI1yWSD1GdJIj533OBDwi6VvOEEu6Ex3VpkuSg0ZthgRWBt2BxM1JRE7dg8jHyYxhhcY/Z78mMSeeh1GerPtYXLNQd9ipCeih8k1hjThtCShQx4R7zbBd5pYw8m6u+EfSIuUWoQ94DoAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":25,"angle":0,"xoffset":0,"yoffset":0},"value":"CSR Completed","label":"CSR Completed"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[249,252,192,255],"toColor":[249,252,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,179,252,255],"toColor":[210,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,189,187,255],"toColor":[252,189,187,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,239,252,255],"toColor":[179,239,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,189,255],"toColor":[182,252,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,246,255],"toColor":[252,212,246,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,205,252,255],"toColor":[182,205,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,227,197,255],"toColor":[252,227,197,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,252,223,255],"toColor":[215,252,223,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,189,244,255],"toColor":[252,189,244,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,233,255],"toColor":[179,252,233,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,234,252,255],"toColor":[215,234,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[216,252,179,255],"toColor":[216,252,179,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- DEFECT_CATEGORY (type: esriFieldTypeString, alias: DEFECT_CATEGORY, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
- DEFECT_CODE (type: esriFieldTypeString, alias: DEFECT_CODE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- DEFECT_STAGE (type: esriFieldTypeString, alias: DEFECT_STAGE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- REG_NAME (type: esriFieldTypeString, alias: REG_NAME, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- ASSNBRI (type: esriFieldTypeString, alias: ASSNBRI, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- DEFECT_RID (type: esriFieldTypeInteger, alias: DEFECT_RID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ASSET_RID (type: esriFieldTypeInteger, alias: ASSET_RID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RES_WORK_SYS_NAME (type: esriFieldTypeString, alias: RES_WORK_SYS_NAME, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- RES_TASK_NBRI (type: esriFieldTypeString, alias: RES_TASK_NBRI, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- RespArea (type: esriFieldTypeString, alias: RespArea, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- RespTeam (type: esriFieldTypeString, alias: RespTeam, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- Severity (type: esriFieldTypeString, alias: Severity, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- DefectDescription (type: esriFieldTypeString, alias: DefectDescription, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- DetailsOfWork (type: esriFieldTypeString, alias: DetailsOfWork, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- DefectRiskScore (type: esriFieldTypeDouble, alias: DefectRiskScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SeverityDescription (type: esriFieldTypeString, alias: SeverityDescription, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- RequiredBy (type: esriFieldTypeDate, alias: RequiredBy, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- SEARCH_PATH (type: esriFieldTypeString, alias: SEARCH_PATH, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- URL (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- DEFECT_UNIQUE_ID (type: esriFieldTypeString, alias: DEFECT_UNIQUE_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- LastInspected (type: esriFieldTypeDate, alias: LastInspected, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Templates:
Name: Pothole_Defects
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 4/30/2025 4:18:52 AM
Schema Last Edit Date: 4/30/2025 4:12:22 AM
Data Last Edit Date: 4/30/2025 4:18:52 AM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat