{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 20, "name": "wwMeter", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSET_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSET_ID", "type": "esriFieldTypeString", "alias": "ASSET_ID", "length": 20, "domain": null }, { "name": "LIFT_ID", "type": "esriFieldTypeString", "alias": "Lift_ID", "length": 50, "domain": null }, { "name": "LIFT_STATION_NUMBER", "type": "esriFieldTypeSmallInteger", "alias": "Lift_Station_Number", "domain": { "type": "range", "name": "wwLiftStationNumber", "description": "List of Lift Station numbers for Wastewater", "range": [ 1, 103 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": null }, { "name": "LOF", "type": "esriFieldTypeSmallInteger", "alias": "LOF", "domain": { "type": "range", "name": "wwRisk", "description": "Risk Score for Wastewater", "range": [ 1, 5 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COF", "type": "esriFieldTypeSmallInteger", "alias": "COF", "domain": { "type": "range", "name": "wwRisk", "description": "Risk Score for Wastewater", "range": [ 1, 5 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RISK", "type": "esriFieldTypeSmallInteger", "alias": "Risk", "domain": null }, { "name": "MAKE_MODEL", "type": "esriFieldTypeString", "alias": "Make_Model", "length": 30, "domain": null }, { "name": "SIZE_IN", "type": "esriFieldTypeSmallInteger", "alias": "Size_in", "domain": null }, { "name": "LAST_INSPECTED", "type": "esriFieldTypeDate", "alias": "Last_Inspected", "length": 8, "domain": null }, { "name": "DATE_RENEWED", "type": "esriFieldTypeDate", "alias": "Date_Renewed", "length": 8, "domain": null }, { "name": "INSTALL_YEAR", "type": "esriFieldTypeSmallInteger", "alias": "Install_Year", "domain": null }, { "name": "USEFUL_LIFE_YRS", "type": "esriFieldTypeSmallInteger", "alias": "Tot_Useful_Life_yrs", "domain": null }, { "name": "CURRENT_YEAR", "type": "esriFieldTypeSmallInteger", "alias": "Current_Year", "domain": null }, { "name": "REMAINING_LIFE", "type": "esriFieldTypeSmallInteger", "alias": "Remain_Useful_Life_yrs", "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 200, "domain": null }, { "name": "MAINTENANCE_ZONE", "type": "esriFieldTypeString", "alias": "Maintenance_Zone", "length": 10, "domain": null } ], "indexes": [ { "name": "R6454_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_127452_LIFT_", "fields": "LIFT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "DBO.wwLift_Station", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "LIFT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D3D9BC0F-7B5B-4C3D-A90C-8EFE648E5A76}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 4000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "21fc8eee2ca147a8b106abc1d1087557" }