{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "WCElementsInsp", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "WCElements", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GISID_", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "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, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "SERVICETYPE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "RECEIVEDDATE", "type": "esriFieldTypeDate", "alias": "RECEIVEDDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RECEIVEDDATE" }, { "name": "TIMEARRIVED", "type": "esriFieldTypeDate", "alias": "TIMEARRIVED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "TIMEARRIVED" }, { "name": "TIMECOMPLETED", "type": "esriFieldTypeDate", "alias": "TIMECOMPLETED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "TIMECOMPLETED" }, { "name": "SERVICEREQUEST", "type": "esriFieldTypeInteger", "alias": "SERVICEREQUEST", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SERVICEREQUEST" }, { "name": "WORKORDER", "type": "esriFieldTypeDouble", "alias": "WORKORDER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WORKORDER" }, { "name": "WORKORDERTASK", "type": "esriFieldTypeDouble", "alias": "WORKORDERTASK", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WORKORDERTASK" }, { "name": "SERVICETYPE", "type": "esriFieldTypeString", "alias": "SERVICETYPE", "domain": { "type": "codedValue", "name": "WaterCurbInspSERV", "description": "WaterCurbInspSERV", "codedValues": [ { "name": "Pre-Flushing", "code": "Pre-Flushing" }, { "name": "Flushing Program", "code": "Flushing Program" }, { "name": "Pre-Construction", "code": "Pre-Construction" }, { "name": "Emergency", "code": "Emergency" }, { "name": "Maintenance", "code": "Maintenance" }, { "name": "Preventative Maintenance", "code": "Preventative Maintenance" }, { "name": "Post-Construction", "code": "Post-Construction" }, { "name": "Watermain Relining", "code": "Watermain Relining" }, { "name": "Others", "code": "Others" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERVICETYPE" }, { "name": "PIPEMATERIALCITY", "type": "esriFieldTypeString", "alias": "PIPEMATERIALCITY", "domain": { "type": "codedValue", "name": "WaterCFPIPEMATERIALCITY", "description": "WaterCFPIPEMATERIALCITY", "codedValues": [ { "name": "Copper", "code": "Copper" }, { "name": "Lead", "code": "Lead" }, { "name": "Poly B", "code": "Poly B" }, { "name": "Poly E", "code": "Poly E" }, { "name": "Camaloid", "code": "Camaloid" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PIPEMATERIALCITY" }, { "name": "PIPEMATERIALPRIVATE", "type": "esriFieldTypeString", "alias": "PIPEMATERIALPRIVATE", "domain": { "type": "codedValue", "name": "WaterCFPIPEMATERIALCITY", "description": "WaterCFPIPEMATERIALCITY", "codedValues": [ { "name": "Copper", "code": "Copper" }, { "name": "Lead", "code": "Lead" }, { "name": "Poly B", "code": "Poly B" }, { "name": "Poly E", "code": "Poly E" }, { "name": "Camaloid", "code": "Camaloid" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PIPEMATERIALPRIVATE" }, { "name": "CBOCONDITION", "type": "esriFieldTypeString", "alias": "CBOCONDITION", "domain": { "type": "codedValue", "name": "WaterCurbInspBO", "description": "WaterCurbInspBO", "codedValues": [ { "name": "Operable", "code": "Operable" }, { "name": "Cannot Locate", "code": "Cannot Locate" }, { "name": "Stuck Lid", "code": "Stuck Lid" }, { "name": "Full/Debris", "code": "Full/Debris" }, { "name": "Misaligned Box", "code": "Misaligned Box" }, { "name": "Bent Rod", "code": "Bent Rod" }, { "name": "Too High", "code": "Too High" }, { "name": "Too Low", "code": "Too Low" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CBOCONDITION" }, { "name": "CSCONDITION", "type": "esriFieldTypeString", "alias": "CSCONDITION", "domain": { "type": "codedValue", "name": "WaterCurbInspSTOP", "description": "WaterCurbInspSTOP", "codedValues": [ { "name": "Non-Operable", "code": "Non-Operable" }, { "name": "Corroded", "code": "Corroded" }, { "name": "No Check pin", "code": "No Check pin" }, { "name": "Passing", "code": "Passing" }, { "name": "Pass", "code": "Pass" }, { "name": "Drain Hole", "code": "Drain Hole" }, { "name": "Packing Gland", "code": "Packing Gland" }, { "name": "Tee Head off", "code": "Tee Head off" }, { "name": "Frozen", "code": "Frozen" }, { "name": "Leak", "code": "Leak" }, { "name": "Other", "code": "Other" }, { "name": "Operable", "code": "Operable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CSCONDITION" }, { "name": "ACTION", "type": "esriFieldTypeString", "alias": "ACTION", "domain": { "type": "codedValue", "name": "WaterCurbInspACTION", "description": "WaterCurbInspACTION", "codedValues": [ { "name": "Replaced Curb Box and Rod", "code": "Replaced Curb Box and Rod" }, { "name": "Flushed", "code": "Flushed" }, { "name": "Raised", "code": "Raised" }, { "name": "Lower", "code": "Lower" }, { "name": "Steamed", "code": "Steamed" }, { "name": "Thawed", "code": "Thawed" }, { "name": "No Action", "code": "No Action" }, { "name": "Hydrovac Failed", "code": "Hydrovac Failed" }, { "name": "Located and Operated", "code": "Located and Operated" }, { "name": "Pulled Rod", "code": "Pulled Rod" }, { "name": "Hydrovac Successful", "code": "Hydrovac Successful" }, { "name": "Repaired", "code": "Repaired" }, { "name": "Inspected", "code": "Inspected" }, { "name": "Turned on", "code": "Turned on" }, { "name": "Turned off", "code": "Turned off" }, { "name": "Seized", "code": "Seized" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ACTION" }, { "name": "BOXRODQTY", "type": "esriFieldTypeInteger", "alias": "BOXRODQTY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BOXRODQTY" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "SERVICEDBY", "type": "esriFieldTypeString", "alias": "SERVICEDBY", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERVICEDBY" }, { "name": "VEHICLEUNIT", "type": "esriFieldTypeInteger", "alias": "VEHICLEUNIT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VEHICLEUNIT" }, { "name": "DATEREFFERED", "type": "esriFieldTypeDate", "alias": "DATEREFFERED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEREFFERED" }, { "name": "PLANSMADEBY", "type": "esriFieldTypeString", "alias": "PLANSMADEBY", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PLANSMADEBY" }, { "name": "GISID_", "type": "esriFieldTypeInteger", "alias": "GISID_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GISID_" }, { "name": "MAITENANCE", "type": "esriFieldTypeString", "alias": "MAITENANCE", "domain": { "type": "codedValue", "name": "WaterCurbInspMAINTE", "description": "WaterCurbInspMAINTE", "codedValues": [ { "name": "Replaced Curb Box and Rod", "code": "Replaced Curb Box and Rod" }, { "name": "Flushed", "code": "Flushed" }, { "name": "Raised", "code": "Raised" }, { "name": "Lower", "code": "Lower" }, { "name": "Steamed", "code": "Steamed" }, { "name": "Thawed", "code": "Thawed" }, { "name": "No Action", "code": "No Action" }, { "name": "Hydrovacced Failed", "code": "Hydrovacced Failed" }, { "name": "Others", "code": "Others" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MAITENANCE" }, { "name": "POSITIONLEFT", "type": "esriFieldTypeString", "alias": "POSITIONLEFT", "domain": { "type": "codedValue", "name": "WaterCurbInspPOSITIONLEF", "description": "WaterCurbInspPOSITIONLEF", "codedValues": [ { "name": "Open", "code": "Open" }, { "name": "Closed", "code": "Closed" }, { "name": "Partially Open", "code": "Partially Open" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "POSITIONLEFT" } ], "indexes": [ { "name": "GDB_126844_GISID", "fields": "GISID_", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R1244438_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Canada Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "WCElementsInsp", "description": "", "prototype": { "attributes": { "MAITENANCE": null, "POSITIONLEFT": null, "RECEIVEDDATE": null, "TIMEARRIVED": null, "TIMECOMPLETED": null, "SERVICEREQUEST": null, "WORKORDER": null, "WORKORDERTASK": null, "SERVICETYPE": null, "PIPEMATERIALCITY": null, "PIPEMATERIALPRIVATE": null, "CBOCONDITION": null, "CSCONDITION": null, "ACTION": null, "BOXRODQTY": null, "COMMENTS": null, "SERVICEDBY": null, "VEHICLEUNIT": null, "DATEREFFERED": null, "PLANSMADEBY": null, "GISID_": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }