{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Gastonia", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 234, 201, 252, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -9037436.6376, "ymin": 4199573.685400002, "xmax": -9037339.7579, "ymax": 4199622.515900001, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "OBJECTID", "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": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R136_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S3_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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": false, "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, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriMeters" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "LS Asset Containers", "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": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "ParentAssetId", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 255, "domain": null }, { "name": "ParentAsset", "type": "esriFieldTypeString", "alias": "ParentAsset", "length": 255, "domain": null }, { "name": "ParentAssetType", "type": "esriFieldTypeString", "alias": "ParentAssetType", "length": 255, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeString", "alias": "WarrantyDate", "length": 255, "domain": null }, { "name": "RebuiltDate", "type": "esriFieldTypeString", "alias": "RebuiltDate", "length": 255, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeString", "alias": "ReplacementDate", "length": 255, "domain": null }, { "name": "FloorLevel", "type": "esriFieldTypeString", "alias": "FloorLevel", "length": 255, "domain": null }, { "name": "ConditionAssessment", "type": "esriFieldTypeString", "alias": "ConditionAssessment", "length": 255, "domain": null }, { "name": "O_M_Location", "type": "esriFieldTypeString", "alias": "O_M_Location", "length": 255, "domain": null }, { "name": "BudgetCode", "type": "esriFieldTypeString", "alias": "BudgetCode", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 255, "domain": { "type": "codedValue", "name": "Lifecyle", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "assetimage", "type": "esriFieldTypeString", "alias": "assetimage", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "length": 255, "domain": null } ], "indexes": [ { "name": "R137_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G433AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G433ParentAssetI", "fields": "ParentAssetId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "LS Mixers", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "LS Pumps", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "LS Facilities", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 18, "name": "LS Barscreen", "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": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "ParentAssetId", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 255, "domain": null }, { "name": "ParentAsset", "type": "esriFieldTypeString", "alias": "ParentAsset", "length": 255, "domain": null }, { "name": "ParentAssetType", "type": "esriFieldTypeString", "alias": "ParentAssetType", "length": 255, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET_TYPE", "length": 255, "domain": null }, { "name": "Membrane_Location_ID", "type": "esriFieldTypeString", "alias": "Membrane_Location_ID", "length": 255, "domain": null }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "MFGDate", "type": "esriFieldTypeString", "alias": "MFGDate", "length": 255, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeString", "alias": "WarrantyDate", "length": 255, "domain": null }, { "name": "RebuiltDate", "type": "esriFieldTypeString", "alias": "RebuiltDate", "length": 255, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeString", "alias": "ReplacementDate", "length": 255, "domain": null }, { "name": "FloorLevel", "type": "esriFieldTypeString", "alias": "FloorLevel", "length": 255, "domain": null }, { "name": "ConditionAssessment", "type": "esriFieldTypeString", "alias": "ConditionAssessment", "length": 255, "domain": null }, { "name": "O_M_Location", "type": "esriFieldTypeString", "alias": "O_M_Location", "length": 255, "domain": null }, { "name": "BudgetCode", "type": "esriFieldTypeString", "alias": "BudgetCode", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 255, "domain": { "type": "codedValue", "name": "Lifecyle", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "assetimage", "type": "esriFieldTypeString", "alias": "assetimage", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "length": 255, "domain": null } ], "indexes": [ { "name": "R138_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G434ParentAssetI", "fields": "ParentAssetId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "LS Facilities", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "LS Belts", "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": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "ParentAssetId", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 255, "domain": null }, { "name": "ParentAsset", "type": "esriFieldTypeString", "alias": "ParentAsset", "length": 255, "domain": null }, { "name": "ParentAssetType", "type": "esriFieldTypeString", "alias": "ParentAssetType", "length": 255, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET_TYPE", "length": 255, "domain": null }, { "name": "Membrane_Location_ID", "type": "esriFieldTypeString", "alias": "Membrane_Location_ID", "length": 255, "domain": null }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "MFGDate", "type": "esriFieldTypeString", "alias": "MFGDate", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeString", "alias": "WarrantyDate", "length": 255, "domain": null }, { "name": "RebuiltDate", "type": "esriFieldTypeString", "alias": "RebuiltDate", "length": 255, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeString", "alias": "ReplacementDate", "length": 255, "domain": null }, { "name": "FloorLevel", "type": "esriFieldTypeString", "alias": "FloorLevel", "length": 255, "domain": null }, { "name": "ConditionAssessment", "type": "esriFieldTypeString", "alias": "ConditionAssessment", "length": 255, "domain": null }, { "name": "O_M_Location", "type": "esriFieldTypeString", "alias": "O_M_Location", "length": 255, "domain": null }, { "name": "BudgetCode", "type": "esriFieldTypeString", "alias": "BudgetCode", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 255, "domain": { "type": "codedValue", "name": "Lifecyle", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "assetimage", "type": "esriFieldTypeString", "alias": "assetimage", "length": 255, "domain": null }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "length": 255, "domain": null } ], "indexes": [ { "name": "R139_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G435AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G435ParentAssetI", "fields": "ParentAssetId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "LS Pumps", "relatedTableId": 9, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 20, "name": "LS Fans", "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": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "ParentAssetId", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 255, "domain": null }, { "name": "ParentAsset", "type": "esriFieldTypeString", "alias": "ParentAsset", "length": 255, "domain": null }, { "name": "ParentAssetType", "type": "esriFieldTypeString", "alias": "ParentAssetType", "length": 255, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET_TYPE", "length": 255, "domain": null }, { "name": "Membrane_Location_ID", "type": "esriFieldTypeString", "alias": "Membrane_Location_ID", "length": 255, "domain": null }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "MFGDate", "type": "esriFieldTypeString", "alias": "MFGDate", "length": 255, "domain": null }, { "name": "HP", "type": "esriFieldTypeDouble", "alias": "HP", "domain": null }, { "name": "Volts_Amps", "type": "esriFieldTypeString", "alias": "Volts_Amps", "length": 255, "domain": null }, { "name": "Frame", "type": "esriFieldTypeString", "alias": "Frame", "length": 255, "domain": null }, { "name": "RPM", "type": "esriFieldTypeInteger", "alias": "RPM", "domain": null }, { "name": "Impeller_Dia", "type": "esriFieldTypeString", "alias": "Impeller_Dia", "length": 255, "domain": null }, { "name": "GPM", "type": "esriFieldTypeString", "alias": "GPM", "length": 255, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeString", "alias": "WarrantyDate", "length": 255, "domain": null }, { "name": "RebuiltDate", "type": "esriFieldTypeString", "alias": "RebuiltDate", "length": 255, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeString", "alias": "ReplacementDate", "length": 255, "domain": null }, { "name": "FloorLevel", "type": "esriFieldTypeString", "alias": "FloorLevel", "length": 255, "domain": null }, { "name": "ConditionAssessment", "type": "esriFieldTypeString", "alias": "ConditionAssessment", "length": 255, "domain": null }, { "name": "O_M_Location", "type": "esriFieldTypeString", "alias": "O_M_Location", "length": 255, "domain": null }, { "name": "BudgetCode", "type": "esriFieldTypeString", "alias": "BudgetCode", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 255, "domain": { "type": "codedValue", "name": "Lifecyle", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "assetimage", "type": "esriFieldTypeString", "alias": "assetimage", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "length": 255, "domain": null } ], "indexes": [ { "name": "R141_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G437ParentAssetI", "fields": "ParentAssetId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "LS Facilities", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 19, "name": "LS Facilities", "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": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "ParentAssetId", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 255, "domain": null }, { "name": "ParentAsset", "type": "esriFieldTypeString", "alias": "ParentAsset", "length": 255, "domain": null }, { "name": "ParentAssetType", "type": "esriFieldTypeString", "alias": "ParentAssetType", "length": 255, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET_TYPE", "length": 255, "domain": null }, { "name": "RebuiltDate", "type": "esriFieldTypeString", "alias": "RebuiltDate", "length": 255, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeString", "alias": "ReplacementDate", "length": 255, "domain": null }, { "name": "FloorLevel", "type": "esriFieldTypeString", "alias": "FloorLevel", "length": 255, "domain": null }, { "name": "ConditionAssessment", "type": "esriFieldTypeString", "alias": "ConditionAssessment", "length": 255, "domain": null }, { "name": "O_M_Location", "type": "esriFieldTypeString", "alias": "O_M_Location", "length": 255, "domain": null }, { "name": "BudgetCode", "type": "esriFieldTypeString", "alias": "BudgetCode", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 255, "domain": { "type": "codedValue", "name": "Lifecyle", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "assetimage", "type": "esriFieldTypeString", "alias": "assetimage", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Lat", "type": "esriFieldTypeDouble", "alias": "Lat", "domain": null }, { "name": "Long", "type": "esriFieldTypeDouble", "alias": "Long", "domain": null } ], "indexes": [ { "name": "R140_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G436AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "LS Motors", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "LS Asset Containers", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 8, "name": "LS Instrumentation", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "LS Filters and Membranes", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 7, "name": "LS Generators", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 6, "name": "LS VFDs", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 10, "name": "LS Rakes and Augers", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "LS Fans", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "LS Barscreen", "relatedTableId": 18, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 11, "name": "LS Pumps", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "LS Filters and Membranes", "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": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "ParentAssetId", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 255, "domain": null }, { "name": "ParentAsset", "type": "esriFieldTypeString", "alias": "ParentAsset", "length": 255, "domain": null }, { "name": "ParentAssetType", "type": "esriFieldTypeString", "alias": "ParentAssetType", "length": 255, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET_TYPE", "length": 255, "domain": null }, { "name": "CHECK_TYPE", "type": "esriFieldTypeString", "alias": "CHECK_TYPE", "length": 255, "domain": null }, { "name": "Membrane_Location_ID", "type": "esriFieldTypeString", "alias": "Membrane_Location_ID", "length": 255, "domain": null }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "MFGDate", "type": "esriFieldTypeString", "alias": "MFGDate", "length": 255, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeString", "alias": "WarrantyDate", "length": 255, "domain": null }, { "name": "RebuiltDate", "type": "esriFieldTypeString", "alias": "RebuiltDate", "length": 255, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeString", "alias": "ReplacementDate", "length": 255, "domain": null }, { "name": "FloorLevel", "type": "esriFieldTypeString", "alias": "FloorLevel", "length": 255, "domain": null }, { "name": "ConditionAssessment", "type": "esriFieldTypeString", "alias": "ConditionAssessment", "length": 255, "domain": null }, { "name": "O_M_Location", "type": "esriFieldTypeString", "alias": "O_M_Location", "length": 255, "domain": null }, { "name": "BudgetCode", "type": "esriFieldTypeString", "alias": "BudgetCode", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 255, "domain": { "type": "codedValue", "name": "Lifecyle", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "assetimage", "type": "esriFieldTypeString", "alias": "assetimage", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "length": 255, "domain": null } ], "indexes": [ { "name": "R142_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G438AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G438ParentAssetI", "fields": "ParentAssetId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "LS Facilities", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "LS Generators", "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": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "ParentAssetId", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 255, "domain": null }, { "name": "ParentAsset", "type": "esriFieldTypeString", "alias": "ParentAsset", "length": 255, "domain": null }, { "name": "ParentAssetType", "type": "esriFieldTypeString", "alias": "ParentAssetType", "length": 255, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET_TYPE", "length": 255, "domain": null }, { "name": "Membrane_Location_ID", "type": "esriFieldTypeString", "alias": "Membrane_Location_ID", "length": 255, "domain": null }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "MFGDate", "type": "esriFieldTypeString", "alias": "MFGDate", "length": 255, "domain": null }, { "name": "Volts_Amps", "type": "esriFieldTypeString", "alias": "Volts_Amps", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeString", "alias": "WarrantyDate", "length": 255, "domain": null }, { "name": "RebuiltDate", "type": "esriFieldTypeString", "alias": "RebuiltDate", "length": 255, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeString", "alias": "ReplacementDate", "length": 255, "domain": null }, { "name": "FloorLevel", "type": "esriFieldTypeString", "alias": "FloorLevel", "length": 255, "domain": null }, { "name": "ConditionAssessment", "type": "esriFieldTypeString", "alias": "ConditionAssessment", "length": 255, "domain": null }, { "name": "O_M_Location", "type": "esriFieldTypeString", "alias": "O_M_Location", "length": 255, "domain": null }, { "name": "BudgetCode", "type": "esriFieldTypeString", "alias": "BudgetCode", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 255, "domain": { "type": "codedValue", "name": "Lifecyle", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "assetimage", "type": "esriFieldTypeString", "alias": "assetimage", "length": 255, "domain": null }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "length": 255, "domain": null } ], "indexes": [ { "name": "R143_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G439AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G439ParentAssetI", "fields": "ParentAssetId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "LS Facilities", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 5, "name": "LS Instrumentation", "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": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "ParentAssetId", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 255, "domain": null }, { "name": "ParentAsset", "type": "esriFieldTypeString", "alias": "ParentAsset", "length": 255, "domain": null }, { "name": "ParentAssetType", "type": "esriFieldTypeString", "alias": "ParentAssetType", "length": 255, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET_TYPE", "length": 255, "domain": null }, { "name": "Membrane_Location_ID", "type": "esriFieldTypeString", "alias": "Membrane_Location_ID", "length": 255, "domain": null }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "MFGDate", "type": "esriFieldTypeString", "alias": "MFGDate", "length": 255, "domain": null }, { "name": "HP", "type": "esriFieldTypeDouble", "alias": "HP", "domain": null }, { "name": "Volts_Amps", "type": "esriFieldTypeString", "alias": "Volts_Amps", "length": 255, "domain": null }, { "name": "Frame", "type": "esriFieldTypeString", "alias": "Frame", "length": 255, "domain": null }, { "name": "RPM", "type": "esriFieldTypeInteger", "alias": "RPM", "domain": null }, { "name": "Impeller_Dia", "type": "esriFieldTypeString", "alias": "Impeller_Dia", "length": 255, "domain": null }, { "name": "GPM", "type": "esriFieldTypeString", "alias": "GPM", "length": 255, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeString", "alias": "WarrantyDate", "length": 255, "domain": null }, { "name": "RebuiltDate", "type": "esriFieldTypeString", "alias": "RebuiltDate", "length": 255, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeString", "alias": "ReplacementDate", "length": 255, "domain": null }, { "name": "FloorLevel", "type": "esriFieldTypeString", "alias": "FloorLevel", "length": 255, "domain": null }, { "name": "ConditionAssessment", "type": "esriFieldTypeString", "alias": "ConditionAssessment", "length": 255, "domain": null }, { "name": "O_M_Location", "type": "esriFieldTypeString", "alias": "O_M_Location", "length": 255, "domain": null }, { "name": "BudgetCode", "type": "esriFieldTypeString", "alias": "BudgetCode", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 255, "domain": { "type": "codedValue", "name": "Lifecyle", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "assetimage", "type": "esriFieldTypeString", "alias": "assetimage", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "length": 255, "domain": null } ], "indexes": [ { "name": "R144_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G440AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G440ParentAssetI", "fields": "ParentAssetId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "LS Facilities", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 7, "name": "LS Mixers", "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": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "ParentAssetId", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 255, "domain": null }, { "name": "ParentAsset", "type": "esriFieldTypeString", "alias": "ParentAsset", "length": 255, "domain": null }, { "name": "ParentAssetType", "type": "esriFieldTypeString", "alias": "ParentAssetType", "length": 255, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET_TYPE", "length": 255, "domain": null }, { "name": "Membrane_Location_ID", "type": "esriFieldTypeString", "alias": "Membrane_Location_ID", "length": 255, "domain": null }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "MFGDate", "type": "esriFieldTypeString", "alias": "MFGDate", "length": 255, "domain": null }, { "name": "HP", "type": "esriFieldTypeDouble", "alias": "HP", "domain": null }, { "name": "Volts_Amps", "type": "esriFieldTypeString", "alias": "Volts_Amps", "length": 255, "domain": null }, { "name": "Frame", "type": "esriFieldTypeString", "alias": "Frame", "length": 255, "domain": null }, { "name": "RPM", "type": "esriFieldTypeInteger", "alias": "RPM", "domain": null }, { "name": "Impeller_Dia", "type": "esriFieldTypeString", "alias": "Impeller_Dia", "length": 255, "domain": null }, { "name": "GPM", "type": "esriFieldTypeString", "alias": "GPM", "length": 255, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeString", "alias": "WarrantyDate", "length": 255, "domain": null }, { "name": "RebuiltDate", "type": "esriFieldTypeString", "alias": "RebuiltDate", "length": 255, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeString", "alias": "ReplacementDate", "length": 255, "domain": null }, { "name": "FloorLevel", "type": "esriFieldTypeString", "alias": "FloorLevel", "length": 255, "domain": null }, { "name": "ConditionAssessment", "type": "esriFieldTypeString", "alias": "ConditionAssessment", "length": 255, "domain": null }, { "name": "O_M_Location", "type": "esriFieldTypeString", "alias": "O_M_Location", "length": 255, "domain": null }, { "name": "BudgetCode", "type": "esriFieldTypeString", "alias": "BudgetCode", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 255, "domain": { "type": "codedValue", "name": "Lifecyle", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "assetimage", "type": "esriFieldTypeString", "alias": "assetimage", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "length": 255, "domain": null } ], "indexes": [ { "name": "R145_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G441AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G441ParentAssetI", "fields": "ParentAssetId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 13, "name": "LS Motors", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 0, "name": "LS Asset Containers", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 8, "name": "LS Motors", "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": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "length": 255, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "ParentAssetId", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 255, "domain": null }, { "name": "ParentAsset", "type": "esriFieldTypeString", "alias": "ParentAsset", "length": 255, "domain": null }, { "name": "ParentAssetType", "type": "esriFieldTypeString", "alias": "ParentAssetType", "length": 255, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET_TYPE", "length": 255, "domain": null }, { "name": "Membrane_Location_ID", "type": "esriFieldTypeString", "alias": "Membrane_Location_ID", "length": 255, "domain": null }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "MFGDate", "type": "esriFieldTypeString", "alias": "MFGDate", "length": 255, "domain": null }, { "name": "HP", "type": "esriFieldTypeDouble", "alias": "HP", "domain": null }, { "name": "Volts_Amps", "type": "esriFieldTypeString", "alias": "Volts_Amps", "length": 255, "domain": null }, { "name": "Frame", "type": "esriFieldTypeString", "alias": "Frame", "length": 255, "domain": null }, { "name": "RPM", "type": "esriFieldTypeInteger", "alias": "RPM", "domain": null }, { "name": "Impeller_Dia", "type": "esriFieldTypeString", "alias": "Impeller_Dia", "length": 255, "domain": null }, { "name": "GPM", "type": "esriFieldTypeString", "alias": "GPM", "length": 255, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeString", "alias": "WarrantyDate", "length": 255, "domain": null }, { "name": "RebuiltDate", "type": "esriFieldTypeString", "alias": "RebuiltDate", "length": 255, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeString", "alias": "ReplacementDate", "length": 255, "domain": null }, { "name": "FloorLevel", "type": "esriFieldTypeString", "alias": "FloorLevel", "length": 255, "domain": null }, { "name": "ConditionAssessment", "type": "esriFieldTypeString", "alias": "ConditionAssessment", "length": 255, "domain": null }, { "name": "O_M_Location", "type": "esriFieldTypeString", "alias": "O_M_Location", "length": 255, "domain": null }, { "name": "BudgetCode", "type": "esriFieldTypeString", "alias": "BudgetCode", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 255, "domain": { "type": "codedValue", "name": "Lifecyle", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "assetimage", "type": "esriFieldTypeString", "alias": "assetimage", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null } ], "indexes": [ { "name": "R146_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G442AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G442ParentAssetI", "fields": "ParentAssetId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "LS Facilities", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "LS Mixers", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 14, "name": "LS Pumps", "relatedTableId": 9, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 9, "name": "LS Pumps", "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": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "ParentAssetId", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 255, "domain": null }, { "name": "ParentAsset", "type": "esriFieldTypeString", "alias": "ParentAsset", "length": 255, "domain": null }, { "name": "ParentAssetType", "type": "esriFieldTypeString", "alias": "ParentAssetType", "length": 255, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET_TYPE", "length": 255, "domain": null }, { "name": "Membrane_Location_ID", "type": "esriFieldTypeString", "alias": "Membrane_Location_ID", "length": 255, "domain": null }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "MFGDate", "type": "esriFieldTypeString", "alias": "MFGDate", "length": 255, "domain": null }, { "name": "HP", "type": "esriFieldTypeDouble", "alias": "HP", "domain": null }, { "name": "Volts_Amps", "type": "esriFieldTypeString", "alias": "Volts_Amps", "length": 255, "domain": null }, { "name": "Frame", "type": "esriFieldTypeString", "alias": "Frame", "length": 255, "domain": null }, { "name": "RPM", "type": "esriFieldTypeInteger", "alias": "RPM", "domain": null }, { "name": "Impeller_Dia", "type": "esriFieldTypeString", "alias": "Impeller_Dia", "length": 255, "domain": null }, { "name": "GPM", "type": "esriFieldTypeString", "alias": "GPM", "length": 255, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeString", "alias": "WarrantyDate", "length": 255, "domain": null }, { "name": "RebuiltDate", "type": "esriFieldTypeString", "alias": "RebuiltDate", "length": 255, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeString", "alias": "ReplacementDate", "length": 255, "domain": null }, { "name": "FloorLevel", "type": "esriFieldTypeString", "alias": "FloorLevel", "length": 255, "domain": null }, { "name": "ConditionAssessment", "type": "esriFieldTypeString", "alias": "ConditionAssessment", "length": 255, "domain": null }, { "name": "O_M_Location", "type": "esriFieldTypeString", "alias": "O_M_Location", "length": 255, "domain": null }, { "name": "BudgetCode", "type": "esriFieldTypeString", "alias": "BudgetCode", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 255, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "assetimage", "type": "esriFieldTypeString", "alias": "assetimage", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "length": 255, "domain": null } ], "indexes": [ { "name": "R147_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G443AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G443ParentAssetI", "fields": "ParentAssetId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 16, "name": "LS Valves", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "LS Belts", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 15, "name": "LS VFDs", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 14, "name": "LS Motors", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "LS Asset Containers", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 11, "name": "LS Facilities", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 10, "name": "LS Rakes and Augers", "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": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "ParentAssetId", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 255, "domain": null }, { "name": "ParentAsset", "type": "esriFieldTypeString", "alias": "ParentAsset", "length": 255, "domain": null }, { "name": "ParentAssetType", "type": "esriFieldTypeString", "alias": "ParentAssetType", "length": 255, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET_TYPE", "length": 255, "domain": null }, { "name": "Membrane_Location_ID", "type": "esriFieldTypeString", "alias": "Membrane_Location_ID", "length": 255, "domain": null }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "MFGDate", "type": "esriFieldTypeString", "alias": "MFGDate", "length": 255, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeString", "alias": "WarrantyDate", "length": 255, "domain": null }, { "name": "RebuiltDate", "type": "esriFieldTypeString", "alias": "RebuiltDate", "length": 255, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeString", "alias": "ReplacementDate", "length": 255, "domain": null }, { "name": "FloorLevel", "type": "esriFieldTypeString", "alias": "FloorLevel", "length": 255, "domain": null }, { "name": "ConditionAssessment", "type": "esriFieldTypeString", "alias": "ConditionAssessment", "length": 255, "domain": null }, { "name": "O_M_Location", "type": "esriFieldTypeString", "alias": "O_M_Location", "length": 255, "domain": null }, { "name": "BudgetCode", "type": "esriFieldTypeString", "alias": "BudgetCode", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 255, "domain": { "type": "codedValue", "name": "Lifecyle", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "assetimage", "type": "esriFieldTypeString", "alias": "assetimage", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "length": 255, "domain": null } ], "indexes": [ { "name": "R148_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G444AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G444ParentAssetI", "fields": "ParentAssetId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "LS Facilities", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 11, "name": "LS Valves", "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": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "length": 255, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "ParentAssetId", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 255, "domain": null }, { "name": "ParentAsset", "type": "esriFieldTypeString", "alias": "ParentAsset", "length": 255, "domain": null }, { "name": "ParentAssetType", "type": "esriFieldTypeString", "alias": "ParentAssetType", "length": 255, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET_TYPE", "length": 255, "domain": null }, { "name": "Membrane_Location_ID", "type": "esriFieldTypeString", "alias": "Membrane_Location_ID", "length": 255, "domain": null }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "MFGDate", "type": "esriFieldTypeString", "alias": "MFGDate", "length": 255, "domain": null }, { "name": "Actuation", "type": "esriFieldTypeString", "alias": "Actuation", "length": 255, "domain": null }, { "name": "OpenDirection", "type": "esriFieldTypeString", "alias": "OpenDirection", "length": 255, "domain": null }, { "name": "Diameter", "type": "esriFieldTypeInteger", "alias": "Diameter", "domain": null }, { "name": "Impeller_Dia", "type": "esriFieldTypeString", "alias": "Impeller_Dia", "length": 255, "domain": null }, { "name": "GPM", "type": "esriFieldTypeString", "alias": "GPM", "length": 255, "domain": null }, { "name": "Turns", "type": "esriFieldTypeInteger", "alias": "Turns", "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeString", "alias": "WarrantyDate", "length": 255, "domain": null }, { "name": "RebuiltDate", "type": "esriFieldTypeString", "alias": "RebuiltDate", "length": 255, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeString", "alias": "ReplacementDate", "length": 255, "domain": null }, { "name": "FloorLevel", "type": "esriFieldTypeString", "alias": "FloorLevel", "length": 255, "domain": null }, { "name": "ConditionAssessment", "type": "esriFieldTypeString", "alias": "ConditionAssessment", "length": 255, "domain": null }, { "name": "O_M_Location", "type": "esriFieldTypeString", "alias": "O_M_Location", "length": 255, "domain": null }, { "name": "BudgetCode", "type": "esriFieldTypeString", "alias": "BudgetCode", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 255, "domain": { "type": "codedValue", "name": "Lifecyle", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "assetimage", "type": "esriFieldTypeString", "alias": "assetimage", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null } ], "indexes": [ { "name": "R149_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G445AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G445ParentAssetI", "fields": "ParentAssetId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 16, "name": "LS Pumps", "relatedTableId": 9, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 12, "name": "LS VFDs", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Volts_Amps", "type": "esriFieldTypeString", "alias": "Volts_Amps", "length": 10, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 255, "domain": null }, { "name": "ParentAssetId", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 255, "domain": null }, { "name": "ParentAsset", "type": "esriFieldTypeString", "alias": "ParentAsset", "length": 255, "domain": null }, { "name": "ParentAssetType", "type": "esriFieldTypeString", "alias": "ParentAssetType", "length": 255, "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeString", "alias": "ASSET_TYPE", "length": 255, "domain": null }, { "name": "Membrane_Location_ID", "type": "esriFieldTypeString", "alias": "Membrane_Location_ID", "length": 255, "domain": null }, { "name": "Manufacture", "type": "esriFieldTypeString", "alias": "Manufacture", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "MFGDate", "type": "esriFieldTypeString", "alias": "MFGDate", "length": 255, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeString", "alias": "WarrantyDate", "length": 255, "domain": null }, { "name": "RebuiltDate", "type": "esriFieldTypeString", "alias": "RebuiltDate", "length": 255, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeString", "alias": "ReplacementDate", "length": 255, "domain": null }, { "name": "FloorLevel", "type": "esriFieldTypeString", "alias": "FloorLevel", "length": 255, "domain": null }, { "name": "ConditionAssessment", "type": "esriFieldTypeString", "alias": "ConditionAssessment", "length": 255, "domain": null }, { "name": "O_M_Location", "type": "esriFieldTypeString", "alias": "O_M_Location", "length": 255, "domain": null }, { "name": "BudgetCode", "type": "esriFieldTypeString", "alias": "BudgetCode", "length": 255, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 255, "domain": { "type": "codedValue", "name": "Lifecyle", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Retired", "code": "Retired" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "assetimage", "type": "esriFieldTypeString", "alias": "assetimage", "length": 255, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Facility", "type": "esriFieldTypeString", "alias": "Facility", "length": 255, "domain": null } ], "indexes": [ { "name": "R150_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G446AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G446ParentAssetI", "fields": "ParentAssetId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "LS Facilities", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "ParentAsset", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 15, "name": "LS Pumps", "relatedTableId": 9, "role": "esriRelRoleDestination", "keyField": "ParentAssetId", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "33ce6997ab274a5a9261c09ce18f31bf" } ] }