{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 35, "name": "SCC_ASSET_SA_INSP", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "created_date", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "inspAssetNo", "type": "esriFieldTypeInteger", "alias": "Asset ID", "domain": null }, { "name": "inspTargetDate", "type": "esriFieldTypeDate", "alias": "Target date of inspection", "length": 8, "domain": null }, { "name": "inspId", "type": "esriFieldTypeInteger", "alias": "Legacy Inspection ID", "domain": null }, { "name": "externalID", "type": "esriFieldTypeString", "alias": "External ID", "length": 40, "domain": null }, { "name": "inspAssetType", "type": "esriFieldTypeString", "alias": "Asset type", "length": 20, "domain": { "type": "codedValue", "name": "assetType", "description": "Description", "codedValues": [ { "name": "AcoDrain", "code": "AcoDrain" }, { "name": "BeanieBlocks", "code": "BeanieBlocks" }, { "name": "Catchpit", "code": "Catchpit" }, { "name": "Connector", "code": "Connector" }, { "name": "Cover", "code": "Cover" }, { "name": "Culvert", "code": "Culvert" }, { "name": "DishChannel", "code": "DishChannel" }, { "name": "Ditch", "code": "Ditch" }, { "name": "Filter", "code": "Filter" }, { "name": "GhostNode", "code": "GhostNode" }, { "name": "Grip", "code": "Grip" }, { "name": "Gully", "code": "Gully" }, { "name": "Headwall", "code": "Headwall" }, { "name": "HydroBrake", "code": "HydroBrake" }, { "name": "Inlet", "code": "Inlet" }, { "name": "Interceptor", "code": "Interceptor" }, { "name": "KerbDrain", "code": "KerbDrain" }, { "name": "Manhole", "code": "Manhole" }, { "name": "Other", "code": "Other" }, { "name": "Outfall", "code": "Outfall" }, { "name": "Outlet", "code": "Outlet" }, { "name": "Pipe", "code": "Pipe" }, { "name": "PumpingStation", "code": "PumpingStation" }, { "name": "RoddingEye", "code": "RoddingEye" }, { "name": "Slot", "code": "Slot" }, { "name": "Soakaway", "code": "Soakaway" }, { "name": "TrashScreen", "code": "TrashScreen" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "crewArcReason", "type": "esriFieldTypeString", "alias": "Crew archive reason", "length": 20, "domain": { "type": "codedValue", "name": "archiveReasonInspection", "description": "archiveReason for inspections", "codedValues": [ { "name": "Yes, Found", "code": "Local Authority" }, { "name": "Not Found", "code": "Not Found" }, { "name": "Duplicate", "code": "Duplicate" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspAccessible", "type": "esriFieldTypeString", "alias": "Access condition", "length": 20, "domain": { "type": "codedValue", "name": "accessInspection", "description": "access for inspections", "codedValues": [ { "name": "Excavation Required", "code": "Excavation Required" }, { "name": "Inaccessible", "code": "Inaccessible" }, { "name": "OK", "code": "OK" }, { "name": "Private Land", "code": "Private Land" }, { "name": "TM Required", "code": "TM" }, { "name": "ToDo OOH", "code": "ToDo OOH" }, { "name": "Vehicle Over", "code": "Vehicle Over" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspTm", "type": "esriFieldTypeString", "alias": "What TM was used", "length": 30, "domain": { "type": "codedValue", "name": "tmInspection", "description": "tm for inspections", "codedValues": [ { "name": "15 Min Delay Boards", "code": "15 Min Delay Boards" }, { "name": "2-Way Lights", "code": "2-Way Lights" }, { "name": "Lane Closure", "code": "Lane Closure" }, { "name": "Multi-Phase Lights", "code": "Multi-Phase Lights" }, { "name": "No Parking Cone", "code": "No Parking Cone" }, { "name": "Out Of Hours", "code": "Out Of Hours" }, { "name": "Parking Bay Suspension", "code": "Parking Bay Suspension" }, { "name": "Priority Signs", "code": "Priority Signs" }, { "name": "Road Closure", "code": "Road Closure" }, { "name": "Standard Chapter 8", "code": "Standard Chapter 8" }, { "name": "Stop & Go", "code": "Stop & Go" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspWorkType", "type": "esriFieldTypeString", "alias": "Inspection type", "length": 20, "domain": { "type": "codedValue", "name": "workType", "description": "Work type", "codedValues": [ { "name": "Cyclical", "code": "Cyclical" }, { "name": "Cyclical - Remote", "code": "CycRemote" }, { "name": "Day Works", "code": "Day Works" }, { "name": "Emergency", "code": "Emergency" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspshift", "type": "esriFieldTypeString", "alias": "Day or night shift", "length": 12, "domain": { "type": "codedValue", "name": "shift", "description": "Shift", "codedValues": [ { "name": "Day shift", "code": "Day shift" }, { "name": "Night shift", "code": "Night shift" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspOpArrive", "type": "esriFieldTypeString", "alias": "Operational on arrival", "length": 30, "domain": { "type": "codedValue", "name": "opArriveLeaveInspection", "description": "opArriveLeave for inspections", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Slow Runner", "code": "Slow Runner" }, { "name": "Yes - Junction Flowing", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspGenCon", "type": "esriFieldTypeString", "alias": "Condition of structure", "length": 30, "domain": { "type": "codedValue", "name": "genCon", "description": "General condition", "codedValues": [ { "name": "Average", "code": "Average" }, { "name": "Good", "code": "Good" }, { "name": "Needs Attention / Repair", "code": "Needs Attention / Repair" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspCoverCon", "type": "esriFieldTypeString", "alias": "Condition of cover", "length": 20, "domain": { "type": "codedValue", "name": "covCon", "description": "Cover condition", "codedValues": [ { "name": "Broken Lid", "code": "Broken Lid" }, { "name": "Buried on Arrival", "code": "Buried on Arrival" }, { "name": "Missing", "code": "Missing" }, { "name": "OK", "code": "OK" }, { "name": "Unable to Lift", "code": "Unable to Lift" }, { "name": "Unable to Lift Frozen", "code": "Frozen Shut" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspSiltDefect", "type": "esriFieldTypeString", "alias": "Specify if defective", "length": 40, "domain": { "type": "codedValue", "name": "siltDefectInspection", "description": "siltDefect for inspections", "codedValues": [ { "name": "Ditch Maintenance Required", "code": "Ditch Maintenance Required" }, { "name": "Domestic Refuse", "code": "Domestic Refuse" }, { "name": "Excessive Debris", "code": "Excessive Debris" }, { "name": "Further Investigation", "code": "Further Investigation" }, { "name": "Leaves", "code": "Leaves" }, { "name": "Litter", "code": "Litter" }, { "name": "Needles", "code": "Needles" }, { "name": "None", "code": "None" }, { "name": "Offset Pot", "code": "Offset Pot" }, { "name": "Oil and Fat", "code": "Oil and Fat" }, { "name": "Required Dig Out", "code": "Required Dig Out" }, { "name": "Roots", "code": "Roots" }, { "name": "Suspected Broken Pipe", "code": "Suspected Broken Pipe" }, { "name": "Swan Neck (no access to outlet)", "code": "Swan Neck (no access to outlet)" }, { "name": "Tarmac / Stone", "code": "Tarmac / Stone" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspDepBaseArrive", "type": "esriFieldTypeSmallInteger", "alias": "Depth to Base before Clean (mm)", "domain": null }, { "name": "inspDepBaseDepart", "type": "esriFieldTypeSmallInteger", "alias": "Depth to Base after Clean (mm)", "domain": null }, { "name": "inspCleaned", "type": "esriFieldTypeString", "alias": "Drainage cleaned", "length": 7, "domain": { "type": "codedValue", "name": "yesnoInspection", "description": "yesno for inspections", "codedValues": [ { "name": "no", "code": "no" }, { "name": "yes", "code": "yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspComments", "type": "esriFieldTypeString", "alias": "Inspection related comments", "length": 50, "domain": { "type": "codedValue", "name": "inspDrop", "description": "Inspection comments drop down", "codedValues": [ { "name": "3rd Party site blocking access", "code": "3rd Party site blocking access" }, { "name": "Can't reach with gully boom", "code": "Can't reach with gully boom" }, { "name": "Filled with concrete", "code": "Filled with concrete" }, { "name": "Filled with tarmac", "code": "Filled with tarmac" }, { "name": "Road access too narrow", "code": "Road access too narrow" }, { "name": "Skip over Gully", "code": "Skip over Gully" }, { "name": "Too close to parked vehicle", "code": "Too close to parked vehicle" }, { "name": "Vegetation blocking access", "code": "Vegetation blocking access" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspCommentsOther", "type": "esriFieldTypeString", "alias": "Other inspection related comments", "length": 680, "domain": null }, { "name": "inspJetCompleted", "type": "esriFieldTypeString", "alias": "Jetted", "length": 7, "domain": { "type": "codedValue", "name": "yesnoInspection", "description": "yesno for inspections", "codedValues": [ { "name": "no", "code": "no" }, { "name": "yes", "code": "yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspJettingTime", "type": "esriFieldTypeSmallInteger", "alias": "Jetting time", "domain": { "type": "codedValue", "name": "jeTime", "description": "Time spent jetting", "codedValues": [ { "name": "15 Mins", "code": 15 }, { "name": "30 Mins", "code": 30 }, { "name": "45 Mins", "code": 45 }, { "name": "60 Mins", "code": 60 }, { "name": "75 Mins", "code": 75 }, { "name": "90 Mins", "code": 90 }, { "name": "105 Mins", "code": 105 }, { "name": "120 Mins", "code": 120 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspJettingComments", "type": "esriFieldTypeString", "alias": "Jetting related comments", "length": 50, "domain": { "type": "codedValue", "name": "jetDrop", "description": "Jetting comments drop down", "codedValues": [ { "name": "No access to jet", "code": "No access to jet" }, { "name": "Suspected collapsed pipe", "code": "Suspected collapsed pipe" }, { "name": "Jetted 1m to blockage", "code": "Jetted 1m to blockage" }, { "name": "Jetted 2m to blockage", "code": "Jetted 2m to blockage" }, { "name": "Jetted 3m to blockage", "code": "Jetted 3m to blockage" }, { "name": "Jetted 4m to blockage", "code": "Jetted 4m to blockage" }, { "name": "Jetted 5m to blockage", "code": "Jetted 5m to blockage" }, { "name": "Jetted 6m to blockage", "code": "Jetted 6m to blockage" }, { "name": "Jetted 7m to blockage", "code": "Jetted 7m to blockage" }, { "name": "Jetted 8m to blockage", "code": "Jetted 8m to blockage" }, { "name": "Jetted 9m to blockage", "code": "Jetted 9m to blockage" }, { "name": "Jetted 10m to blockage", "code": "Jetted 10m to blockage" }, { "name": "Jetted 11m to blockage", "code": "Jetted 11m to blockage" }, { "name": "Jetted 12m to blockage", "code": "Jetted 12m to blockage" }, { "name": "Jetted 13m to blockage", "code": "Jetted 13m to blockage" }, { "name": "Jetted 14m to blockage", "code": "Jetted 14m to blockage" }, { "name": "Jetted 15m to blockage", "code": "Jetted 15m to blockage" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspJettingCommentsOther", "type": "esriFieldTypeString", "alias": "Other jetting related comments", "length": 1000, "domain": null }, { "name": "inspAP2", "type": "esriFieldTypeString", "alias": "AP2 Required", "length": 7, "domain": { "type": "codedValue", "name": "yesnoInspection", "description": "yesno for inspections", "codedValues": [ { "name": "no", "code": "no" }, { "name": "yes", "code": "yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspWeep", "type": "esriFieldTypeString", "alias": "Weep Holes Cleaned", "length": 10, "domain": { "type": "codedValue", "name": "weep", "description": "Weep hole status", "codedValues": [ { "name": "Clear", "code": "Clear" }, { "name": "Blocked", "code": "Blocked" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspOpLeave", "type": "esriFieldTypeString", "alias": "Was drainage operational on departure", "length": 30, "domain": { "type": "codedValue", "name": "opArriveLeaveInspection", "description": "opArriveLeave for inspections", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Slow Runner", "code": "Slow Runner" }, { "name": "Yes - Junction Flowing", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspPhotoComments", "type": "esriFieldTypeString", "alias": "Photo related comments", "length": 700, "domain": null }, { "name": "inspAuditDate", "type": "esriFieldTypeDate", "alias": "Inspection audit date", "length": 8, "domain": null }, { "name": "auditState", "type": "esriFieldTypeString", "alias": "Result of audit", "length": 7, "domain": { "type": "codedValue", "name": "aResult", "description": "Audit result", "codedValues": [ { "name": "Fail", "code": "Fail" }, { "name": "Pass", "code": "Pass" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "POINT_X", "type": "esriFieldTypeDouble", "alias": "Easting", "domain": null }, { "name": "POINT_Y", "type": "esriFieldTypeDouble", "alias": "Northing", "domain": null }, { "name": "inspRelGlobalID", "type": "esriFieldTypeGUID", "alias": "Asset GlobalID", "length": 38, "domain": null }, { "name": "sourceGlobalID", "type": "esriFieldTypeGUID", "alias": "sourceGlobalID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "inspAP2Used", "type": "esriFieldTypeString", "alias": "AP2 Used", "length": 7, "domain": { "type": "codedValue", "name": "yesnoInspection", "description": "yesno for inspections", "codedValues": [ { "name": "no", "code": "no" }, { "name": "yes", "code": "yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "inspTmReq", "type": "esriFieldTypeString", "alias": "TM is required", "length": 30, "domain": { "type": "codedValue", "name": "tmInspection", "description": "tm for inspections", "codedValues": [ { "name": "15 Min Delay Boards", "code": "15 Min Delay Boards" }, { "name": "2-Way Lights", "code": "2-Way Lights" }, { "name": "Lane Closure", "code": "Lane Closure" }, { "name": "Multi-Phase Lights", "code": "Multi-Phase Lights" }, { "name": "No Parking Cone", "code": "No Parking Cone" }, { "name": "Out Of Hours", "code": "Out Of Hours" }, { "name": "Parking Bay Suspension", "code": "Parking Bay Suspension" }, { "name": "Priority Signs", "code": "Priority Signs" }, { "name": "Road Closure", "code": "Road Closure" }, { "name": "Standard Chapter 8", "code": "Standard Chapter 8" }, { "name": "Stop & Go", "code": "Stop & Go" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "duplicate", "type": "esriFieldTypeString", "alias": "duplicate", "length": 5, "domain": { "type": "codedValue", "name": "yesnoInspection", "description": "yesno for inspections", "codedValues": [ { "name": "no", "code": "no" }, { "name": "yes", "code": "yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "UUID_103", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_568_inspRelG", "fields": "inspRelGlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_103", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 18, "name": "ASSET_SA", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "inspRelGlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D6B7220D-62A1-4B57-8CE3-8E5E5898780B}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 200000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "GMT Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1699100049000 }, "serviceItemId": "3efec8729f794e7a86718ff7f5769e14" }