{ "layers": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 123, "name": "SCADA Site", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "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" }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 4513.988705, "maxScale": 0, "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 }, "defaultVisibility": 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" }, "supportsVCSProjection": true, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "SiteID", "type": "esriFieldTypeString", "alias": "Site ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 100, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "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" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "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": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "SCADA has UPS", "relatedTableId": 128, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{29466830-1FFE-4326-86C0-3BFFA84D6FEA}" }, { "id": 0, "name": "SCADA has cabinets", "relatedTableId": 125, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BF9A3126-158C-4B34-AB6D-48D70283E0D4}" }, { "id": 3, "name": "SCADA has radios", "relatedTableId": 127, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4F40115C-A75D-4B69-B1FC-783B0B719493}" }, { "id": 1, "name": "SCADA has antennae", "relatedTableId": 124, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1FED5CCB-923D-4BD6-94E8-F5DB76CAD4D8}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "774084f7fa364f0eb70fda868a42ffce" } ], "tables": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 124, "name": "SCADAAntennae", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "SCADAID", "type": "esriFieldTypeString", "alias": "SCADA Site ID", "length": 12, "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 100, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "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" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Antennae are at SCADA", "relatedTableId": 123, "role": "esriRelRoleDestination", "keyField": "SCADAID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1FED5CCB-923D-4BD6-94E8-F5DB76CAD4D8}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "774084f7fa364f0eb70fda868a42ffce" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 125, "name": "SCADAPLCCabinets", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "SCADAID", "type": "esriFieldTypeString", "alias": "SCADA Site ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 100, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "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" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "PLC has components", "relatedTableId": 126, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D6CA0C0C-D501-4264-B9E3-23E23CE4C2B3}" }, { "id": 0, "name": "Cabinets are at SCADA", "relatedTableId": 123, "role": "esriRelRoleDestination", "keyField": "SCADAID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BF9A3126-158C-4B34-AB6D-48D70283E0D4}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "774084f7fa364f0eb70fda868a42ffce" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 126, "name": "SCADAPLCComponents", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "length": 12, "domain": null }, { "name": "CompType", "type": "esriFieldTypeString", "alias": "Component Type", "length": 50, "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" } }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 100, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "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" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Components are in cabinets", "relatedTableId": 125, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D6CA0C0C-D501-4264-B9E3-23E23CE4C2B3}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "774084f7fa364f0eb70fda868a42ffce" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 127, "name": "SCADARadios", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "SCADAID", "type": "esriFieldTypeString", "alias": "SCADA Site ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 100, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "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" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "StatRadioAddr", "type": "esriFieldTypeSmallInteger", "alias": "Station Radio Address", "domain": null }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "length": 12, "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" } } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Radios are at SCADA", "relatedTableId": 123, "role": "esriRelRoleDestination", "keyField": "SCADAID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4F40115C-A75D-4B69-B1FC-783B0B719493}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "774084f7fa364f0eb70fda868a42ffce" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 128, "name": "SCADAUPS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 12, "domain": null }, { "name": "SCADAID", "type": "esriFieldTypeString", "alias": "SCADA Site ID", "length": 12, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 100, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 20, "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" } }, { "name": "PurchaseCost", "type": "esriFieldTypeDouble", "alias": "Purchase Cost", "domain": null }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 25, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeSmallInteger", "alias": "Service Life", "domain": null }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": null }, { "name": "POF", "type": "esriFieldTypeSmallInteger", "alias": "POF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeSmallInteger", "alias": "BRE", "domain": null }, { "name": "AssetNotes", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "OtherNotes", "type": "esriFieldTypeString", "alias": "Other Notes", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "BatteryPack", "type": "esriFieldTypeString", "alias": "Battery Pack", "length": 50, "domain": null }, { "name": "BatteryReplaced", "type": "esriFieldTypeDate", "alias": "Battery Replaced", "length": 8, "domain": null }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "length": 50, "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" } } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "UPS is at SCADA", "relatedTableId": 123, "role": "esriRelRoleDestination", "keyField": "SCADAID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{29466830-1FFE-4326-86C0-3BFFA84D6FEA}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "774084f7fa364f0eb70fda868a42ffce" } ] }