{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 16, "name": "wwGenset", "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": "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": "FUEL", "type": "esriFieldTypeString", "alias": "Fuel", "length": 30, "domain": { "type": "codedValue", "name": "wwGensetFuel", "description": "Different types of fuel for Gensets associated with Lift Stations for Wastewater", "codedValues": [ { "name": "Diesel", "code": "Diesel" }, { "name": "Liq Propane", "code": "Liq Propane" }, { "name": "Natural Gas", "code": "Natural Gas" }, { "name": "Gasoline", "code": "Gasoline" }, { "name": "Multi-fuel", "code": "Multi-fuel " } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FUEL_TANK_VOL", "type": "esriFieldTypeSmallInteger", "alias": "Fuel_Tank_vol", "domain": null }, { "name": "POWER_KW", "type": "esriFieldTypeSmallInteger", "alias": "Power_kW", "domain": null }, { "name": "MAKE_MODEL", "type": "esriFieldTypeString", "alias": "Make_Model", "length": 50, "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", "domain": null }, { "name": "SHOP_DRAWINGS", "type": "esriFieldTypeString", "alias": "Shop_Drawings", "length": 50, "domain": null }, { "name": "AS_BUILT", "type": "esriFieldTypeString", "alias": "As_Built", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": { "type": "codedValue", "name": "wwGensetLocation", "description": "Location of Gensets inside Lift Stations for Wastewater", "codedValues": [ { "name": "Dry Well", "code": "Dry Well" }, { "name": "Pump House", "code": "Pump House " }, { "name": "Vault", "code": "Vault" }, { "name": "Skid", "code": "Skid" }, { "name": "Trailer Mount", "code": "Trailer Mount" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 200, "domain": null }, { "name": "MAINTENANCE_ZONE", "type": "esriFieldTypeString", "alias": "Maintenance_Zone", "length": 10, "domain": null } ], "indexes": [ { "name": "R6450_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_127448_LIFT_", "fields": "LIFT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "DBO.wwLift_Station", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "LIFT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E3897C8B-3C75-4002-AB51-D9419C40C700}" } ], "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" }