{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 48, "name": "Valve Maintenance", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user", "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "DBO.wSystemValve", "relatedTableId": 29, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "ValveGLOBAL", "composite": false, "catalogID": "{E1C3DDD7-3BBC-4BD4-B313-1196E40EE1EF}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Facility_Identifier", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Facility_Identifier", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Facility_Identifier" }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Inspection_Date" }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Inspected_By" }, { "name": "Inspected_Turns", "type": "esriFieldTypeString", "alias": "Inspected Turns", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Inspected_Turns" }, { "name": "Unable_to_Turn", "type": "esriFieldTypeString", "alias": "Unable to Turn", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Unable_to_Turn" }, { "name": "Inspected_Size", "type": "esriFieldTypeString", "alias": "Inspected Size", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Inspected_Size" }, { "name": "Location_of_Valve", "type": "esriFieldTypeString", "alias": "Location of Valve", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Location_of_Valve" }, { "name": "Valve_Access", "type": "esriFieldTypeString", "alias": "Valve Access", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Valve_Access" }, { "name": "Valve_Keyable", "type": "esriFieldTypeString", "alias": "Valve Keyable", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Valve_Keyable" }, { "name": "Harrware_Condition", "type": "esriFieldTypeString", "alias": "Harrware Condition", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Harrware_Condition" }, { "name": "Dead_end", "type": "esriFieldTypeString", "alias": "Dead end", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Dead_end" }, { "name": "Inspection_notes", "type": "esriFieldTypeString", "alias": "Inspection notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Inspection_notes" }, { "name": "Surface_Type", "type": "esriFieldTypeString", "alias": "Surface Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Surface_Type" }, { "name": "Pump_Down", "type": "esriFieldTypeString", "alias": "Pump Down", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Pump_Down" }, { "name": "Could_Not_Locate", "type": "esriFieldTypeString", "alias": "Could Not Locate", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Could_Not_Locate" }, { "name": "Unable_To_Turn_Reason", "type": "esriFieldTypeString", "alias": "Unable To Turn Reason", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Unable_To_Turn_Reason" }, { "name": "Do_Not_Open", "type": "esriFieldTypeString", "alias": "Do Not Open", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Do_Not_Open" }, { "name": "Issue", "type": "esriFieldTypeString", "alias": "Issue", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Issue" }, { "name": "ValveGLOBAL", "type": "esriFieldTypeGUID", "alias": "Valve GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "ValveGLOBAL" }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CONDITION" }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER" }, { "name": "GISNOTES", "type": "esriFieldTypeString", "alias": "GIS Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GISNOTES" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION" }, { "name": "MACHINETURN", "type": "esriFieldTypeString", "alias": "Machine Turn", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "MACHINETURN" }, { "name": "NUMTURNS", "type": "esriFieldTypeDouble", "alias": "Num Turns", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NUMTURNS" }, { "name": "POSITION", "type": "esriFieldTypeString", "alias": "Position", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "POSITION" }, { "name": "ROTATION", "type": "esriFieldTypeString", "alias": "Rotation", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "ROTATION" }, { "name": "TIMESEXERCISED", "type": "esriFieldTypeSmallInteger", "alias": "Time Exercised", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TIMESEXERCISED" }, { "name": "VALVETYPE", "type": "esriFieldTypeString", "alias": "Valve Type", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "VALVETYPE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R3222_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "G7242ValveGLOBAL", "isAscending": true, "isUnique": false, "description": "", "fields": "ValveGLOBAL" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "Etc/GMT+6", "respectsDaylightSaving": false }, "preferredTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "Etc/GMT+6", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Valve Maintenance", "description": "", "prototype": { "attributes": { "VALVETYPE": null, "TIMESEXERCISED": null, "Facility_Identifier": null, "Inspection_Date": null, "Inspected_By": null, "Inspected_Turns": null, "Unable_to_Turn": null, "Inspected_Size": null, "Location_of_Valve": null, "Valve_Access": null, "Valve_Keyable": null, "Harrware_Condition": null, "Dead_end": null, "Inspection_notes": null, "Surface_Type": null, "Pump_Down": null, "Could_Not_Locate": null, "Unable_To_Turn_Reason": null, "Do_Not_Open": null, "Issue": null, "ValveGLOBAL": null, "CONDITION": null, "DIAMETER": null, "GISNOTES": null, "LOCATION": null, "MACHINETURN": null, "NUMTURNS": null, "POSITION": null, "ROTATION": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "ad70ab8f51fc4da6a4d39fac96323779" }