{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 34, "name": "SCC_ASSET_RE_INSP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user", "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 16, "name": "ASSET_RE", "relatedTableId": 14, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "inspRelGlobalID", "composite": false, "catalogID": "{EB60DB94-0A79-430F-BD09-30D4DF43B4E7}" } ], "isDataVersioned": false, "isDataArchived": true, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1699100008000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "created_date", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "inspAssetNo", "type": "esriFieldTypeInteger", "alias": "Asset ID", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "inspAssetNo" }, { "name": "inspTargetDate", "type": "esriFieldTypeDate", "alias": "Target date of inspection", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "inspTargetDate" }, { "name": "inspId", "type": "esriFieldTypeInteger", "alias": "Legacy Inspection ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "inspId" }, { "name": "externalID", "type": "esriFieldTypeString", "alias": "External ID", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "externalID" }, { "name": "inspAssetType", "type": "esriFieldTypeString", "alias": "Asset type", "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" }, "editable": false, "nullable": true, "length": 20, "defaultValue": null, "modelName": "inspAssetType" }, { "name": "crewArcReason", "type": "esriFieldTypeString", "alias": "Crew archive reason", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "Local Authority", "modelName": "crewArcReason" }, { "name": "inspAccessible", "type": "esriFieldTypeString", "alias": "Access condition", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": "OK", "modelName": "inspAccessible" }, { "name": "inspTm", "type": "esriFieldTypeString", "alias": "What TM was used", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": "Standard Chapter 8", "modelName": "inspTm" }, { "name": "inspWorkType", "type": "esriFieldTypeString", "alias": "Inspection type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "inspWorkType" }, { "name": "inspshift", "type": "esriFieldTypeString", "alias": "Day or night shift", "domain": { "type": "codedValue", "name": "shift", "description": "Shift", "codedValues": [ { "name": "Day shift", "code": "Day shift" }, { "name": "Night shift", "code": "Night shift" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 12, "defaultValue": null, "modelName": "inspshift" }, { "name": "inspOpArrive", "type": "esriFieldTypeString", "alias": "Operational on arrival", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "inspOpArrive" }, { "name": "inspGenCon", "type": "esriFieldTypeString", "alias": "Condition of structure", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "inspGenCon" }, { "name": "inspCoverCon", "type": "esriFieldTypeString", "alias": "Condition of cover", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "inspCoverCon" }, { "name": "inspSiltDefect", "type": "esriFieldTypeString", "alias": "Specify if defective", "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" }, "editable": true, "nullable": true, "length": 40, "defaultValue": "None", "modelName": "inspSiltDefect" }, { "name": "inspSiltArrive", "type": "esriFieldTypeSmallInteger", "alias": "Silt Level", "domain": { "type": "codedValue", "name": "lvSiltInspection", "description": "lvSilt for inspections", "codedValues": [ { "name": "0%", "code": 0 }, { "name": "25%", "code": 25 }, { "name": "50%", "code": 50 }, { "name": "75%", "code": 75 }, { "name": "100%", "code": 100 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "inspSiltArrive" }, { "name": "inspSiltDepart", "type": "esriFieldTypeSmallInteger", "alias": "Depth to Base after Clean (%)", "domain": { "type": "codedValue", "name": "lvSiltInspection", "description": "lvSilt for inspections", "codedValues": [ { "name": "0%", "code": 0 }, { "name": "25%", "code": 25 }, { "name": "50%", "code": 50 }, { "name": "75%", "code": 75 }, { "name": "100%", "code": 100 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "inspSiltDepart" }, { "name": "inspCleaned", "type": "esriFieldTypeString", "alias": "Drainage cleaned", "domain": { "type": "codedValue", "name": "yesnoInspection", "description": "yesno for inspections", "codedValues": [ { "name": "no", "code": "no" }, { "name": "yes", "code": "yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "inspCleaned" }, { "name": "inspComments", "type": "esriFieldTypeString", "alias": "Inspection related comments", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "inspComments" }, { "name": "inspCommentsOther", "type": "esriFieldTypeString", "alias": "Other inspection related comments", "domain": null, "editable": true, "nullable": true, "length": 680, "defaultValue": null, "modelName": "inspCommentsOther" }, { "name": "inspJetCompleted", "type": "esriFieldTypeString", "alias": "Jetted", "domain": { "type": "codedValue", "name": "yesnoInspection", "description": "yesno for inspections", "codedValues": [ { "name": "no", "code": "no" }, { "name": "yes", "code": "yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "inspJetCompleted" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "inspJettingTime" }, { "name": "inspJettingComments", "type": "esriFieldTypeString", "alias": "Jetting related comments", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "inspJettingComments" }, { "name": "inspJettingCommentsOther", "type": "esriFieldTypeString", "alias": "Other jetting related comments", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "inspJettingCommentsOther" }, { "name": "inspAP2", "type": "esriFieldTypeString", "alias": "AP2 Required", "domain": { "type": "codedValue", "name": "yesnoInspection", "description": "yesno for inspections", "codedValues": [ { "name": "no", "code": "no" }, { "name": "yes", "code": "yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "inspAP2" }, { "name": "inspWeep", "type": "esriFieldTypeString", "alias": "Weep Holes Cleaned", "domain": { "type": "codedValue", "name": "weep", "description": "Weep hole status", "codedValues": [ { "name": "Clear", "code": "Clear" }, { "name": "Blocked", "code": "Blocked" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "inspWeep" }, { "name": "inspOpLeave", "type": "esriFieldTypeString", "alias": "Was drainage operational on departure", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "inspOpLeave" }, { "name": "inspPhotoComments", "type": "esriFieldTypeString", "alias": "Photo related comments", "domain": null, "editable": true, "nullable": true, "length": 700, "defaultValue": null, "modelName": "inspPhotoComments" }, { "name": "inspAuditDate", "type": "esriFieldTypeDate", "alias": "Inspection audit date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "inspAuditDate" }, { "name": "auditState", "type": "esriFieldTypeString", "alias": "Result of audit", "domain": { "type": "codedValue", "name": "aResult", "description": "Audit result", "codedValues": [ { "name": "Fail", "code": "Fail" }, { "name": "Pass", "code": "Pass" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "auditState" }, { "name": "POINT_X", "type": "esriFieldTypeDouble", "alias": "Easting", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "POINT_X" }, { "name": "POINT_Y", "type": "esriFieldTypeDouble", "alias": "Northing", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "POINT_Y" }, { "name": "inspRelGlobalID", "type": "esriFieldTypeGUID", "alias": "Asset GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "inspRelGlobalID" }, { "name": "sourceGlobalID", "type": "esriFieldTypeGUID", "alias": "sourceGlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "sourceGlobalID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "inspTmReq", "type": "esriFieldTypeString", "alias": "TM is required", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "inspTmReq" }, { "name": "duplicate", "type": "esriFieldTypeString", "alias": "duplicate", "domain": { "type": "codedValue", "name": "yesnoInspection", "description": "yesno for inspections", "codedValues": [ { "name": "no", "code": "no" }, { "name": "yes", "code": "yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": "no", "modelName": "duplicate" } ], "indexes": [ { "name": "UUID_102", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_567_inspRelG", "fields": "inspRelGlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_102", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "GMT Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SCC_ASSET_RE_INSP", "description": "", "prototype": { "attributes": { "inspTmReq": null, "inspAuditDate": null, "auditState": null, "sourceGlobalID": null, "inspId": null, "externalID": null, "inspRelGlobalID": null, "crewArcReason": "Local Authority", "inspAccessible": "OK", "inspTm": "Standard Chapter 8", "inspWorkType": null, "duplicate": "no", "inspOpArrive": null, "inspGenCon": null, "inspCoverCon": null, "inspSiltDefect": "None", "inspSiltArrive": null, "inspSiltDepart": null, "inspCleaned": null, "inspComments": null, "inspCommentsOther": null, "inspJetCompleted": null, "inspJettingTime": null, "inspJettingComments": null, "inspJettingCommentsOther": null, "inspAP2": null, "inspWeep": null, "inspOpLeave": null, "inspPhotoComments": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 200000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Uploads,Editing,Extract,ChangeTracking", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 200000, "maxRecordCountFactor": 1, "serviceItemId": "341471e9de4144e399c8134b0faa2e8e" }