{ "layers": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 0, "name": "Wells", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102645, "latestWkid": 2229, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117608900, "falseY": -91881400, "xyUnits": 3048.0060960121928, "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": "esriPMS", "url": "601d28e850a1fe0b456285264e5a4b1a", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA0ElEQVQokWNhIBGwUKqBi8G8rphBzMSegYmZleHDjTMMp9t7GL69eY5NAyuDy9yVDDpJPgghLzsGEUM7hgMZAQxvbz1F1WBamc+gk4ikGApkHU0Y9PKqGfbnZKFqkDC2ZGBgxO5wQXVrTCf9Z8ShmgEkyYSp4d3NIwx/fgQysHBgqv945ximhmNVfQw8Eh4MapGuCE3/GRjurLvKcH9/GaYGENiV5Mbw+0sdA5+yMwMjEwvDx7tnGX7cLWe4t/o7dg0gsD+viYGBAYSxApJjGgBFBTbE/a1xNQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 9, "height": 9, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 6435718.428639635, "ymin": 1739112.0489557236, "xmax": 6561613.699158311, "ymax": 1833119.4747856408, "spatialReference": { "wkid": 102645, "latestWkid": 2229, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117608900, "falseY": -91881400, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Common_Well_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID_1", "domain": null }, { "name": "WRDID", "type": "esriFieldTypeInteger", "alias": "WRDID", "domain": null }, { "name": "X", "type": "esriFieldTypeDouble", "alias": "X", "domain": null }, { "name": "Y", "type": "esriFieldTypeDouble", "alias": "Y", "domain": null }, { "name": "Agency_Short", "type": "esriFieldTypeString", "alias": "Agency_Short", "length": 25, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CMMS_Well", "type": "esriFieldTypeString", "alias": "CMMS_Well", "length": 1073741822, "domain": null }, { "name": "Well_Zone", "type": "esriFieldTypeString", "alias": "Well_Zone", "length": 1073741822, "domain": null }, { "name": "Common_Well_Name", "type": "esriFieldTypeString", "alias": "Common Well Name", "length": 1073741822, "domain": null }, { "name": "F4_digit", "type": "esriFieldTypeString", "alias": "4_digit", "length": 1073741822, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_Shape", "fields": "Shape", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Hydro_Sites", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "F4_digit", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{623A943E-3731-4608-99FB-3655B97B2CFB}" } ], "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, "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": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "f20935208b69487095821931ea7a0360" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 1, "name": "Sites", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102645, "latestWkid": 2229, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117608900, "falseY": -91881400, "xyUnits": 3048.0060960121928, "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": [ 115, 178, 115, 255 ], "outline": null } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 6435668.428639663, "ymin": 1739062.0488557187, "xmax": 6561663.699158313, "ymax": 1833169.4746856391, "spatialReference": { "wkid": 102645, "latestWkid": 2229, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117608900, "falseY": -91881400, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "HydroCMMS_Wells_CMMS_Well", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID_1", "domain": null }, { "name": "HydroCMMS_Wells_CMMS_Well", "type": "esriFieldTypeString", "alias": "CMMS_Well", "length": 1073741822, "domain": null }, { "name": "HydroCMMS_Wells_F4_digit", "type": "esriFieldTypeString", "alias": "4-Digit SCADA Code", "length": 1073741822, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape_Area", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape_Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null }, { "name": "StreetName", "type": "esriFieldTypeString", "alias": "StreetName", "length": 100, "domain": null }, { "name": "City_State", "type": "esriFieldTypeString", "alias": "City_State", "length": 50, "domain": null }, { "name": "Zip", "type": "esriFieldTypeString", "alias": "Zip", "length": 20, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_Shape", "fields": "Shape", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Hydro_Wells", "relatedTableId": 0, "role": "esriRelRoleOrigin", "keyField": "HydroCMMS_Wells_F4_digit", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{623A943E-3731-4608-99FB-3655B97B2CFB}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": 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, "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": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape_Area", "shapeLengthFieldName": "Shape_Length", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "f20935208b69487095821931ea7a0360" } ], "tables": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 2, "name": "HYDRO_AUTOMATED_SAMPLER", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 3, "name": "HYDRO_COM_CABLE", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G17Site", "fields": "Site", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G17ParentAssetID", "fields": "ParentAssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "gis_hydro_cmms_dev.DBO.WELL", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "ParentAssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{ED093475-1909-49D7-951C-DB27F76224F3}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 4, "name": "HYDRO_COMPRESSOR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 5, "name": "HYDRO_FLOW_CELL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G13Site", "fields": "Site", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G13ParentAssetID", "fields": "ParentAssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "gis_hydro_cmms_dev.DBO.WELL", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "ParentAssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{ECEB35C9-3B9B-40F7-98FF-EE7A69074ED9}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 6, "name": "HYDRO_FORKLIFT", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "f20935208b69487095821931ea7a0360" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 7, "name": "HYDRO_FORKLIFT_CHARGER", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "f20935208b69487095821931ea7a0360" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 8, "name": "HYDRO_GENERATOR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 9, "name": "HYDRO_PORTABLE_REEL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G14Site", "fields": "Site", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G14ParentAssetID", "fields": "ParentAssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "gis_hydro_cmms_dev.DBO.WELL", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "ParentAssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A341558A-E892-4083-BAB7-D11716517A0B}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 10, "name": "HYDRO_PUMP", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 11, "name": "HYDRO_PUMP_CONTROLLER", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 12, "name": "HYDRO_PUMPING_SKID", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G18Site", "fields": "Site", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G18ParentAssetID", "fields": "ParentAssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "gis_hydro_cmms_dev.DBO.WELL", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "ParentAssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{ECFD0602-3236-47EC-8042-15202BE2932F}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 13, "name": "HYDRO_SONDE", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 14, "name": "HYDRO_TELEMETRY", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G12Site", "fields": "Site", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G12ParentAssetID", "fields": "ParentAssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "gis_hydro_cmms_dev.DBO.WELL", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "ParentAssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E6D5FC0E-CFAA-444D-8F73-CE6274D1549B}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "f20935208b69487095821931ea7a0360" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 15, "name": "HYDRO_TOTAL_DEPTH_TAGGER", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G8Site", "fields": "Site", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G8ParentAssetID", "fields": "ParentAssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "gis_hydro_cmms_dev.DBO.WELL", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "ParentAssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{DE3A8611-70AC-45BA-83BB-FCA3C7F6C326}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 16, "name": "HYDRO_TRANSDUCER", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G16ParentAssetID", "fields": "ParentAssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "gis_hydro_cmms_dev.DBO.WELL", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "ParentAssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{FF1C09F7-A805-4A14-B92D-4B5580E6F132}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 17, "name": "HYDRO_TROLL_COM", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G19ParentAssetID", "fields": "ParentAssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "gis_hydro_cmms_dev.DBO.WELL", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "ParentAssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F0FD4737-DD54-4D11-8AF9-D087F66A35B4}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "f20935208b69487095821931ea7a0360" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 18, "name": "HYDRO_TROLL_REPLACEABLE_BATTERY_PACK", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G15ParentAssetID", "fields": "ParentAssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "gis_hydro_cmms_dev.DBO.WELL", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "ParentAssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{93A6AD83-A13A-4E6D-A8CA-46F0143E3DF9}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 19, "name": "HYDRO_VW_LOGGER", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G11ParentAssetID", "fields": "ParentAssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "gis_hydro_cmms_dev.DBO.WELL", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "ParentAssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A21113FF-0788-4483-A21B-E495963F9DB2}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 20, "name": "HYDRO_WATER_LEVEL_METER", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G20ParentAssetID", "fields": "ParentAssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "gis_hydro_cmms_dev.DBO.WELL", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "ParentAssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{657A92AA-8DD9-4F7C-BB61-171EA5501EDF}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 21, "name": "HYDRO_WELL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G9Location", "fields": "Location", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G9Site", "fields": "Site", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G9AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "gis_hydro_cmms_dev.DBO.WIRELESS_TROLL_COM", "relatedTableId": 23, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{CAEB3429-01D0-4667-B3BF-A7E2972328A6}" }, { "id": 7, "name": "gis_hydro_cmms_dev.DBO.TRANSDUCER", "relatedTableId": 16, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{FF1C09F7-A805-4A14-B92D-4B5580E6F132}" }, { "id": 9, "name": "gis_hydro_cmms_dev.DBO.TROLL_REPLACEABLE_BATTERY_PACK", "relatedTableId": 18, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{93A6AD83-A13A-4E6D-A8CA-46F0143E3DF9}" }, { "id": 4, "name": "gis_hydro_cmms_dev.DBO.PUMPING_SKID", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{ECFD0602-3236-47EC-8042-15202BE2932F}" }, { "id": 5, "name": "gis_hydro_cmms_dev.DBO.TELEMETRY", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E6D5FC0E-CFAA-444D-8F73-CE6274D1549B}" }, { "id": 6, "name": "gis_hydro_cmms_dev.DBO.TOTAL_DEPTH_TAGGER", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{DE3A8611-70AC-45BA-83BB-FCA3C7F6C326}" }, { "id": 10, "name": "gis_hydro_cmms_dev.DBO.VW_LOGGER", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A21113FF-0788-4483-A21B-E495963F9DB2}" }, { "id": 8, "name": "gis_hydro_cmms_dev.DBO.TROLL_COM", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F0FD4737-DD54-4D11-8AF9-D087F66A35B4}" }, { "id": 1, "name": "gis_hydro_cmms_dev.DBO.COM_CABLE", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{ED093475-1909-49D7-951C-DB27F76224F3}" }, { "id": 11, "name": "gis_hydro_cmms_dev.DBO.WATER_LEVEL_METER", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{657A92AA-8DD9-4F7C-BB61-171EA5501EDF}" }, { "id": 3, "name": "gis_hydro_cmms_dev.DBO.PORTABLE_REEL", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A341558A-E892-4083-BAB7-D11716517A0B}" }, { "id": 2, "name": "gis_hydro_cmms_dev.DBO.FLOW_CELL", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{ECEB35C9-3B9B-40F7-98FF-EE7A69074ED9}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 22, "name": "HYDRO_WELL_VAULT", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G40Site", "fields": "Site", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 23, "name": "HYDRO_WIRELESS_TROLL_COM", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AssetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SMARTTag", "type": "esriFieldTypeString", "alias": "SMARTTag", "length": 50, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "AssetName", "length": 125, "domain": null }, { "name": "AssetDescription", "type": "esriFieldTypeString", "alias": "AssetDescription", "length": 125, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 100, "domain": null }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "ModelNumber", "length": 200, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 200, "domain": null }, { "name": "AssetSubType", "type": "esriFieldTypeString", "alias": "AssetSubType", "length": 125, "domain": null }, { "name": "AssociatedEquip", "type": "esriFieldTypeString", "alias": "AssociatedEquip", "length": 200, "domain": null }, { "name": "Quantity", "type": "esriFieldTypeDouble", "alias": "Quantity", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "Size1", "type": "esriFieldTypeString", "alias": "Size1", "length": 25, "domain": null }, { "name": "Unit1", "type": "esriFieldTypeString", "alias": "Unit1", "length": 25, "domain": null }, { "name": "Size2", "type": "esriFieldTypeString", "alias": "Size2", "length": 25, "domain": null }, { "name": "Unit2", "type": "esriFieldTypeString", "alias": "Unit2", "length": 25, "domain": null }, { "name": "Size3", "type": "esriFieldTypeString", "alias": "Size3", "length": 25, "domain": null }, { "name": "Unit3", "type": "esriFieldTypeString", "alias": "Unit3", "length": 25, "domain": null }, { "name": "Size4", "type": "esriFieldTypeString", "alias": "Size4", "length": 25, "domain": null }, { "name": "Unit4", "type": "esriFieldTypeString", "alias": "Unit4", "length": 25, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 50, "domain": null }, { "name": "SiteAlias", "type": "esriFieldTypeString", "alias": "SiteAlias", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "LocationType", "type": "esriFieldTypeString", "alias": "LocationType", "length": 100, "domain": null }, { "name": "UsefulLIfe_am", "type": "esriFieldTypeDouble", "alias": "UsefulLIfe_am", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionComment", "type": "esriFieldTypeString", "alias": "ConditionComment", "length": 255, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "POF", "domain": null }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "COF", "domain": null }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "BRE", "domain": null }, { "name": "ReplacementCost", "type": "esriFieldTypeDouble", "alias": "ReplacementCost", "domain": null }, { "name": "ReplacementCostVar", "type": "esriFieldTypeDouble", "alias": "ReplacementCostVar", "domain": null }, { "name": "LastRehabYear", "type": "esriFieldTypeDouble", "alias": "LastRehabYear", "domain": null }, { "name": "RehabFrequency1", "type": "esriFieldTypeDouble", "alias": "RehabFrequency1", "domain": null }, { "name": "RehabCost1", "type": "esriFieldTypeDouble", "alias": "RehabCost1", "domain": null }, { "name": "RehabFrequency2", "type": "esriFieldTypeDouble", "alias": "RehabFrequency2", "domain": null }, { "name": "RehabCost2", "type": "esriFieldTypeDouble", "alias": "RehabCost2", "domain": null }, { "name": "PercentConsumed", "type": "esriFieldTypeDouble", "alias": "PercentConsumed", "domain": null }, { "name": "AnnualDepreciation", "type": "esriFieldTypeDouble", "alias": "AnnualDepreciation", "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": null }, { "name": "LastUpdated", "type": "esriFieldTypeDate", "alias": "LastUpdated", "length": 8, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "Image_Path", "type": "esriFieldTypeString", "alias": "Image_Path", "length": 255, "domain": null }, { "name": "ParentAssetID", "type": "esriFieldTypeString", "alias": "ParentAssetID", "length": 50, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G10ParentAssetID", "fields": "ParentAssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "gis_hydro_cmms_dev.DBO.WELL", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "ParentAssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{CAEB3429-01D0-4667-B3BF-A7E2972328A6}" } ], "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": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "f20935208b69487095821931ea7a0360" } ] }