{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 23, "name": "wwStructure", "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": "STRUCTURE_TYPE", "type": "esriFieldTypeString", "alias": "Structure_Type", "length": 20, "domain": { "type": "codedValue", "name": "wwLiftStationStructure", "description": "Different types of structures of lift stations for Wastewater", "codedValues": [ { "name": "Pump House", "code": "Pump House" }, { "name": "Overflow", "code": "Overflow" }, { "name": "Wet Well", "code": "Wet Well" }, { "name": "Dry Well", "code": "Dry Well" }, { "name": "Vault", "code": "Vault" } ], "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": "YEAR_REPAIRED", "type": "esriFieldTypeDate", "alias": "Year_Repaired", "length": 8, "domain": null }, { "name": "PUMPS", "type": "esriFieldTypeString", "alias": "Pumps", "length": 10, "domain": { "type": "codedValue", "name": "YN", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BYPASS_SIZE", "type": "esriFieldTypeSmallInteger", "alias": "Bypass_Size", "domain": null }, { "name": "YEAR_LINED", "type": "esriFieldTypeDate", "alias": "Year_Lined", "length": 8, "domain": null }, { "name": "TELEMETRY", "type": "esriFieldTypeString", "alias": "Telemetry", "length": 10, "domain": { "type": "codedValue", "name": "YN", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LINING_TYPE", "type": "esriFieldTypeString", "alias": "Lining_Type", "length": 30, "domain": { "type": "codedValue", "name": "wwStructureLiningType", "description": "Different types of structure linings in lift stations for Wastewater", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Epoxy Cement", "code": "Epoxy Cement" }, { "name": "HDPE", "code": "HDPE" }, { "name": "FRP", "code": "FRP " }, { "name": "Other Polymer See Notes", "code": "Other Polymer See Notes" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ELECTRICAL_EQUIP", "type": "esriFieldTypeString", "alias": "Electrical_Equip", "length": 10, "domain": { "type": "codedValue", "name": "YN", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONTROLS", "type": "esriFieldTypeString", "alias": "Controls", "length": 10, "domain": { "type": "codedValue", "name": "YN", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GENSET", "type": "esriFieldTypeString", "alias": "Genset", "length": 10, "domain": { "type": "codedValue", "name": "YN", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BLOWER", "type": "esriFieldTypeString", "alias": "Blower", "length": 10, "domain": { "type": "codedValue", "name": "YN", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FLOW_METER", "type": "esriFieldTypeString", "alias": "Flow_Meter", "length": 10, "domain": { "type": "codedValue", "name": "YN", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VALVE1", "type": "esriFieldTypeString", "alias": "Valve1", "length": 20, "domain": null }, { "name": "VALVE2", "type": "esriFieldTypeString", "alias": "Valve2", "length": 20, "domain": null }, { "name": "VALVE3", "type": "esriFieldTypeString", "alias": "Valve3", "length": 20, "domain": null }, { "name": "VALVE4", "type": "esriFieldTypeString", "alias": "Valve4", "length": 20, "domain": null }, { "name": "WORKING_VOL", "type": "esriFieldTypeSmallInteger", "alias": "Working_vol", "domain": null }, { "name": "SURCHARGE_VOL", "type": "esriFieldTypeSmallInteger", "alias": "Surcharge_vol", "domain": null }, { "name": "LID_ELEV", "type": "esriFieldTypeSingle", "alias": "Lid_Elev", "domain": null }, { "name": "FLOOR_ELEV", "type": "esriFieldTypeSingle", "alias": "Floor_Elev", "domain": null }, { "name": "INFLUENT1_ELEV", "type": "esriFieldTypeSingle", "alias": "Influent1_Elev", "domain": null }, { "name": "INFLUENT2_ELEV", "type": "esriFieldTypeSingle", "alias": "Influent2_Elev", "domain": null }, { "name": "INFLUENT3_ELEV", "type": "esriFieldTypeSingle", "alias": "Influent3_Elev", "domain": null }, { "name": "EFFLUENT_ELEV", "type": "esriFieldTypeSingle", "alias": "Effluent_Elev", "domain": null }, { "name": "ACCESS_TYPE", "type": "esriFieldTypeString", "alias": "Access_Type", "length": 20, "domain": { "type": "codedValue", "name": "wwAccessType", "description": "Different types of Lift Station Structure asset types for Wastewater", "codedValues": [ { "name": "MH Lid", "code": "MH Lid" }, { "name": "Hinged Double Leaf", "code": "Hinged Single Leaf" }, { "name": "Hinged Double Leaf", "code": "Hinged Double Leaf" }, { "name": "Hinged Triple Leaf", "code": "Hinged Triple Leaf" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LID_HATCH_MATERIAL", "type": "esriFieldTypeString", "alias": "Lid_Hatch_Material", "length": 20, "domain": { "type": "codedValue", "name": "wwLidMaterial", "description": "Different types of lid material for a structure of a lift station for Wastewater", "codedValues": [ { "name": "Iron", "code": "Iron" }, { "name": "Steel", "code": "Steel" }, { "name": "Aluminum", "code": "Aluminum" }, { "name": "Stainless", "code": "Stainless " }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "CONTRACT_NUMBERS", "type": "esriFieldTypeString", "alias": "Contract_Numbers", "length": 30, "domain": null }, { "name": "AS_BUILT", "type": "esriFieldTypeString", "alias": "As_Built", "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": "R6444_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_127442_LIFT_", "fields": "LIFT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "DBO.wwLift_Station", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "LIFT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{ADD07EC5-555C-48DA-9668-D980996A40A5}" } ], "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" }