{ "layers": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 123, "name": "SCADA Site", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 4513.988705, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "SCADA has UPS", "relatedTableId": 128, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{29466830-1FFE-4326-86C0-3BFFA84D6FEA}" }, { "id": 0, "name": "SCADA has cabinets", "relatedTableId": 125, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{BF9A3126-158C-4B34-AB6D-48D70283E0D4}" }, { "id": 3, "name": "SCADA has radios", "relatedTableId": 127, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{4F40115C-A75D-4B69-B1FC-783B0B719493}" }, { "id": 1, "name": "SCADA has antennae", "relatedTableId": 124, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{1FED5CCB-923D-4BD6-94E8-F5DB76CAD4D8}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": 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, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 1248536.6950998902, "ymin": 115140.99425323308, "xmax": 1349251.4369114786, "ymax": 164143.29355813563, "spatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3.792674222403606E7, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "sourceSpatialReference": { "wkid": 2926, "latestWkid": 2926, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117104300, "falseY": -99539600, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "ceae556df4719c34862de1f462784530", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABcAAAAWCAYAAAArdgcFAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABw0lEQVQ4je2Vv0sCYRjHv3KGRkJgQV2DgxSBSGYn9GvIyy0OJBr8D+7AKRyj4Q0HF0ttCGyKxKUQB0HEnIOGokERTogIyqXLKSKoiPcoQ7sss4ag7/Z8h8/7fN/neXn1+EXp/+GdXkscwBCAKwDST8JFk6lLXF93Q5IOaL0N4Pgn4BwAsro6BVEcQypVQT5/nnlJ0TGcWK297PIyPQOIRNxwOHbZh4cn8SXBt+EcAGFjww2DgVENm60Pfv84NjdPSKdw4vFY4PUON5pkGslkmVWUu3ir4baCiwyjE6JRXi0qlRoKhQv4fKMwm40IBmfh9xfEVsP9CD5E4TS+3d6vGoKQhizXcHh4iURiQR3u1tYpisVr2r2rHbhgNhs5QmbqxuBgjwpnWZNaM4wOsRgPj2efzoXT6l4LztEHQ2PT+K/K5ZZQLitwOgfq3vy8BYuLI0inK5qrqQUn9CokydFgdnfrMTHxBn5VODyHbPaMvb9/fLeaeq3Vi0Z5NfZXZLX2IhBwIRQ6in8GJzQmXb92tLIyiZ2dIqrV24bum+Hbsnwj8Pwe2pVOpyZtGGozPFMqKWuAwrZNB6qfwanIN8Ca+rvf3DOeG37lsKyVaAAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 17, "height": 16, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "SiteID", "type": "esriFieldTypeString", "alias": "Site ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "SiteID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Name" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Description" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "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" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R15_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_141_AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_141_SiteID", "fields": "SiteID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_15", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_15", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S5_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SCADASites", "description": "", "prototype": { "attributes": { "LifecycleStatus": null, "AssetID": null, "SiteID": null, "Name": null, "Description": null, "Location": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "a039adc9598042a0ad8bcd1eb92eb883" } ], "tables": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 124, "name": "SCADAAntennae", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "Antennae are at SCADA", "relatedTableId": 123, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "SCADAID", "composite": false, "catalogID": "{1FED5CCB-923D-4BD6-94E8-F5DB76CAD4D8}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": 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, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "SCADAID", "type": "esriFieldTypeString", "alias": "SCADA Site ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "SCADAID" }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Latitude" }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Longitude" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Name" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Description" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "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" } ], "indexes": [ { "name": "R94_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_220_SCADAID", "fields": "SCADAID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_94", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_94", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SCADAAntennae", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "SCADAID": null, "Latitude": null, "Longitude": null, "Name": null, "Description": null, "Location": null, "Address": null, "PurchaseDate": null, "Manufacturer": null, "Model": null, "SerialNumber": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "a039adc9598042a0ad8bcd1eb92eb883" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 125, "name": "SCADAPLCCabinets", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 4, "name": "PLC has components", "relatedTableId": 126, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "AssetID", "composite": false, "catalogID": "{D6CA0C0C-D501-4264-B9E3-23E23CE4C2B3}" }, { "id": 0, "name": "Cabinets are at SCADA", "relatedTableId": 123, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "SCADAID", "composite": false, "catalogID": "{BF9A3126-158C-4B34-AB6D-48D70283E0D4}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": 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, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "SCADAID", "type": "esriFieldTypeString", "alias": "SCADA Site ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "SCADAID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Name" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Description" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "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" } ], "indexes": [ { "name": "R95_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_221_SCADAID", "fields": "SCADAID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_221_AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_95", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_95", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SCADAPLCCabinets", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "SCADAID": null, "Name": null, "Description": null, "Location": null, "Address": null, "Manufacturer": null, "Model": null, "SerialNumber": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "a039adc9598042a0ad8bcd1eb92eb883" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 126, "name": "SCADAPLCComponents", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 4, "name": "Components are in cabinets", "relatedTableId": 125, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false, "catalogID": "{D6CA0C0C-D501-4264-B9E3-23E23CE4C2B3}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": 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, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ParentID" }, { "name": "CompType", "type": "esriFieldTypeString", "alias": "Component Type", "domain": { "type": "codedValue", "name": "SCADAPLCCompType", "description": "", "codedValues": [ { "name": "Input Module - Digital", "code": "Input Module - Digital" }, { "name": "Input Module - Analog", "code": "Input Module - Analog" }, { "name": "Output Module - Digital", "code": "Output Module - Digital" }, { "name": "Output Module - Analog", "code": "Output Module - Analog" }, { "name": "CPU", "code": "CPU" }, { "name": "Power Supply", "code": "Power Supply" }, { "name": "Communication Module", "code": "Communication Module" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CompType" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Name" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "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" } ], "indexes": [ { "name": "R98_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_224_ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_98", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_98", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SCADAPLCComponents", "description": "", "prototype": { "attributes": { "OtherNotes": null, "AssetID": null, "ParentID": null, "CompType": null, "Name": null, "Location": null, "Address": null, "Manufacturer": null, "Model": null, "SerialNumber": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "AssetNotes": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "a039adc9598042a0ad8bcd1eb92eb883" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 127, "name": "SCADARadios", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 3, "name": "Radios are at SCADA", "relatedTableId": 123, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "SCADAID", "composite": false, "catalogID": "{4F40115C-A75D-4B69-B1FC-783B0B719493}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": 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, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "SCADAID", "type": "esriFieldTypeString", "alias": "SCADA Site ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "SCADAID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Name" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Description" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "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": "StatRadioAddr", "type": "esriFieldTypeSmallInteger", "alias": "Station Radio Address", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "StatRadioAddr" }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "domain": { "type": "codedValue", "name": "SCADADepartment", "description": "", "codedValues": [ { "name": "SCADA", "code": "SCADA" }, { "name": "Water", "code": "Water" }, { "name": "Sewer", "code": "Sewer" }, { "name": "Storm", "code": "Storm" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Department" } ], "indexes": [ { "name": "R93_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_219_SCADAID", "fields": "SCADAID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_93", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_93", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SCADARadios", "description": "", "prototype": { "attributes": { "StatRadioAddr": null, "AssetID": null, "SCADAID": null, "Name": null, "Description": null, "Location": null, "Address": null, "Manufacturer": null, "Model": null, "SerialNumber": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "AssetNotes": null, "OtherNotes": null, "Department": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "a039adc9598042a0ad8bcd1eb92eb883" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 128, "name": "SCADAUPS", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "UPS is at SCADA", "relatedTableId": 123, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "SCADAID", "composite": false, "catalogID": "{29466830-1FFE-4326-86C0-3BFFA84D6FEA}" } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": 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, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "AssetID" }, { "name": "SCADAID", "type": "esriFieldTypeString", "alias": "SCADA Site ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "SCADAID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Name" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Description" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Location" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Model" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "domain": { "type": "codedValue", "name": "cwLifecycleStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Retired", "code": "Retired" }, { "name": "Out of Service", "code": "Out of Service" }, { "name": "Pending", "code": "Pending" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PurchaseCost" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CostCenter" }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceLife" }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COF" }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POF" }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BRE" }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssetNotes" }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherNotes" }, { "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": "BatteryPack", "type": "esriFieldTypeString", "alias": "Battery Pack", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BatteryPack" }, { "name": "BatteryReplaced", "type": "esriFieldTypeDate", "alias": "Battery Replaced", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "BatteryReplaced" }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "domain": { "type": "codedValue", "name": "SCADADepartment", "description": "", "codedValues": [ { "name": "SCADA", "code": "SCADA" }, { "name": "Water", "code": "Water" }, { "name": "Sewer", "code": "Sewer" }, { "name": "Storm", "code": "Storm" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Department" } ], "indexes": [ { "name": "R97_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_223_SCADAID", "fields": "SCADAID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_97", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_97", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SCADAUPS", "description": "", "prototype": { "attributes": { "BatteryReplaced": null, "AssetID": null, "SCADAID": null, "Name": null, "Description": null, "Location": null, "Address": null, "Manufacturer": null, "Model": null, "SerialNumber": null, "PurchaseDate": null, "InstallDate": null, "WarrantyDate": null, "LifecycleStatus": null, "PurchaseCost": null, "CostCenter": null, "Condition": null, "ConditionDate": null, "ServiceLife": null, "COF": null, "POF": null, "BRE": null, "AssetNotes": null, "OtherNotes": null, "Department": null, "BatteryPack": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "a039adc9598042a0ad8bcd1eb92eb883" } ] }