{ "currentVersion": 10.61, "id": 99, "name": "TB_WRF_Valve", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 91, "name": "TB_WRF_PositionPoint", "relatedTableId": 104, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ParentID", "composite": false } ], "isDataVersioned": true, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "AssetID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 30 }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 130 }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location Details", "domain": null, "editable": true, "nullable": true, "length": 256 }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "domain": { "type": "codedValue", "name": "gStatus", "description": "Lifecycle Status", "codedValues": [ { "name": "Permitted", "code": "Permitted" }, { "name": "In Service", "code": "In Service" }, { "name": "Not In Service", "code": "Not In Service" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20 }, { "name": "ProcessArea", "type": "esriFieldTypeString", "alias": "Process Area", "domain": { "type": "codedValue", "name": "gProcessArea_3", "description": "Process Area", "codedValues": [ { "name": "M00", "code": "M00" }, { "name": "M01", "code": "M01" }, { "name": "M02", "code": "M02" }, { "name": "M03", "code": "M03" }, { "name": "M04", "code": "M04" }, { "name": "M05", "code": "M05" }, { "name": "M06", "code": "M06" }, { "name": "M07", "code": "M07" }, { "name": "M08", "code": "M08" }, { "name": "M09", "code": "M09" }, { "name": "M10", "code": "M10" }, { "name": "M11", "code": "M11" }, { "name": "M12", "code": "M12" }, { "name": "M13", "code": "M13" }, { "name": "M14", "code": "M14" }, { "name": "M16", "code": "M16" }, { "name": "M17", "code": "M17" }, { "name": "M18", "code": "M18" }, { "name": "M19", "code": "M19" }, { "name": "M21", "code": "M21" }, { "name": "M22", "code": "M22" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3 }, { "name": "Process", "type": "esriFieldTypeString", "alias": "Process", "domain": { "type": "codedValue", "name": "gProcess_3", "description": "Process", "codedValues": [ { "name": "M00 Preaeration Basins Odor Control", "code": "M00 Preaeration Basins Odor Control" }, { "name": "M01 Equalization Basins", "code": "M01 Equalization Basins" }, { "name": "M01 Fuel Unloading", "code": "M01 Fuel Unloading" }, { "name": "M01 Pretreatment", "code": "M01 Pretreatment" }, { "name": "M02 Primary Pump Station Primary Clarifiers 1 through 5", "code": "M02 Primary Pump Station Primary Clarifiers 1 through 5" }, { "name": "M03 Blower Building Aeration Basins", "code": "M03 Blower Building Aeration Basins" }, { "name": "M04 Secondary Clarifiers 1 through 9 Return Activated Sludge Pumping Stations 1 and 2", "code": "M04 Secondary Clarifiers 1 through 9 Return Activated Sludge Pumping Stations 1 and 2" }, { "name": "M05 Denitrification Filters 1 through 24", "code": "M05 Denitrification Filters 1 through 24" }, { "name": "M06 Administration Building Old", "code": "M06 Administration Building Old" }, { "name": "M07 Generator and Electrical Distribution", "code": "M07 Generator and Electrical Distribution" }, { "name": "M08 Lime Handling Lime Tower", "code": "M08 Lime Handling Lime Tower" }, { "name": "M09 Control and Process Building", "code": "M09 Control and Process Building" }, { "name": "M10 Plant Wastewater Pump Station", "code": "M10 Plant Wastewater Pump Station" }, { "name": "M11 Grubbs Admin and Lab", "code": "M11 Grubbs Admin and Lab" }, { "name": "M12 Thickeners 1 and 2 Thickened Sludge Pump Station 1", "code": "M12 Thickeners 1 and 2 Thickened Sludge Pump Station 1" }, { "name": "M12 Thickeners 3 and 4 Thickened Sludge Pump Station 2", "code": "M12 Thickeners 3 and 4 Thickened Sludge Pump Station 2" }, { "name": "M13 Outside of Process Areas", "code": "M13 Outside of Process Areas" }, { "name": "M14 Operations Support Facility Maintenance", "code": "M14 Operations Support Facility Maintenance" }, { "name": "M16 Incinerator", "code": "M16 Incinerator" }, { "name": "M17 Dewatering Equipment Solids Building", "code": "M17 Dewatering Equipment Solids Building" }, { "name": "M18 Sludge Holding Tanks 1 and 4", "code": "M18 Sludge Holding Tanks 1 and 4" }, { "name": "M19 Ash Settling Basins Ash Cover", "code": "M19 Ash Settling Basins Ash Cover" }, { "name": "M21 Methanol Building", "code": "M21 Methanol Building" }, { "name": "M22 Ultraviolet Disinfection Process Water Pumps Final Flow Meter Effluent Cascade", "code": "M22 Ultraviolet Disinfection Process Water Pumps Final Flow Meter Effluent Cascade" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 100 }, { "name": "ProjectNum", "type": "esriFieldTypeString", "alias": "Project Number", "domain": null, "editable": true, "nullable": true, "length": 30 }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 256 }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "Parent ID", "domain": null, "editable": true, "nullable": true, "length": 25 }, { "name": "AssetCost", "type": "esriFieldTypeDouble", "alias": "Asset Cost", "domain": null, "editable": true, "nullable": true }, { "name": "ReplaceCost", "type": "esriFieldTypeDouble", "alias": "Replacement Cost", "domain": null, "editable": true, "nullable": true }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null, "editable": true, "nullable": true }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "RehabDate", "type": "esriFieldTypeDate", "alias": "Last Rehab Date", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "LifeExpectancy", "type": "esriFieldTypeSmallInteger", "alias": "Life Expectancy in Yrs", "domain": null, "editable": true, "nullable": true }, { "name": "RemUseLife", "type": "esriFieldTypeSmallInteger", "alias": "Remaining Useful Life in Yrs", "domain": null, "editable": true, "nullable": true }, { "name": "COF", "type": "esriFieldTypeDouble", "alias": "Consequence of Failure", "domain": null, "editable": true, "nullable": true }, { "name": "POF", "type": "esriFieldTypeDouble", "alias": "Probability of Failure", "domain": null, "editable": true, "nullable": true }, { "name": "BRE", "type": "esriFieldTypeDouble", "alias": "Business Risk Exposure", "domain": null, "editable": true, "nullable": true }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "domain": null, "editable": true, "nullable": true, "length": 25 }, { "name": "ModelYear", "type": "esriFieldTypeSmallInteger", "alias": "Model Year", "domain": null, "editable": true, "nullable": true }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 25 }, { "name": "ValveType", "type": "esriFieldTypeString", "alias": "Valve Type", "domain": { "type": "codedValue", "name": "gValveType_3", "description": "Valve Type", "codedValues": [ { "name": "3-Way", "code": "3-Way" }, { "name": "Air Relief", "code": "Air Relief" }, { "name": "Altitude", "code": "Altitude" }, { "name": "Ball", "code": "Ball" }, { "name": "Butterfly", "code": "Butterfly" }, { "name": "Check", "code": "Check" }, { "name": "Cone", "code": "Cone" }, { "name": "Corporation Stop", "code": "Corporation Stop" }, { "name": "Diverter", "code": "Diverter" }, { "name": "Double Check", "code": "Double Check" }, { "name": "Draw-Off", "code": "Draw-Off" }, { "name": "Eccentric Plug", "code": "Eccentric Plug" }, { "name": "Flange", "code": "Flange" }, { "name": "Float", "code": "Float" }, { "name": "Gate", "code": "Gate" }, { "name": "Globe", "code": "Globe" }, { "name": "Knife", "code": "Knife" }, { "name": "Mud", "code": "Mud" }, { "name": "Pinch", "code": "Pinch" }, { "name": "Plug", "code": "Plug" }, { "name": "Post Indicator", "code": "Post Indicator" }, { "name": "Pressure Reducing", "code": "Pressure Reducing" }, { "name": "Pressure Regulating", "code": "Pressure Regulating" }, { "name": "Rotary Air Lock", "code": "Rotary Air Lock" }, { "name": "Surge Relief", "code": "Surge Relief" }, { "name": "Yard Hydrant", "code": "Yard Hydrant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 22 }, { "name": "ValveFunction", "type": "esriFieldTypeString", "alias": "Valve Function", "domain": { "type": "codedValue", "name": "gValveFunc_2", "description": "Valve Function", "codedValues": [ { "name": "Blow-Off", "code": "Blow-Off" }, { "name": "By-Pass", "code": "By-Pass" }, { "name": "Back Wash", "code": "Back Wash" }, { "name": "Drain", "code": "Drain" }, { "name": "Flow Control", "code": "Flow Control" }, { "name": "Filter to Waste", "code": "Filter to Waste" }, { "name": "Isolation", "code": "Isolation" }, { "name": "Level Control", "code": "Level Control" }, { "name": "Pressure Zone", "code": "Pressure Zone" }, { "name": "Relief", "code": "Relief" }, { "name": "Hydrant", "code": "Hydrant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 18 }, { "name": "Diameter", "type": "esriFieldTypeDouble", "alias": "Diameter in IN", "domain": null, "editable": true, "nullable": true }, { "name": "OpenDirec", "type": "esriFieldTypeString", "alias": "Operational Direction", "domain": { "type": "codedValue", "name": "gValveOpDir", "description": "Valve Operational Direction", "codedValues": [ { "name": "Open Left", "code": "Open Left" }, { "name": "Open Right", "code": "Open Right" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 14 }, { "name": "TurnsReq", "type": "esriFieldTypeDouble", "alias": "Turns Required", "domain": null, "editable": true, "nullable": true }, { "name": "OperStatus", "type": "esriFieldTypeString", "alias": "Operational Status", "domain": { "type": "codedValue", "name": "gValveOpStatus", "description": "Valve Normal Operational Status", "codedValues": [ { "name": "Normally Closed", "code": "Normally Closed" }, { "name": "Modulated", "code": "Modulated" }, { "name": "Normally Open", "code": "Normally Open" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 18 }, { "name": "Actuated", "type": "esriFieldTypeString", "alias": "Actuated?", "domain": { "type": "codedValue", "name": "gYesNo", "description": "Yes/No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3 }, { "name": "CutInPress", "type": "esriFieldTypeSmallInteger", "alias": "Cut In Pressure in PSI", "domain": null, "editable": true, "nullable": true }, { "name": "CutOutPress", "type": "esriFieldTypeSmallInteger", "alias": "Cut Out Pressure in PSI", "domain": null, "editable": true, "nullable": true }, { "name": "AssetName", "type": "esriFieldTypeString", "alias": "Asset Name (Equipment No.)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "Image", "type": "esriFieldTypeString", "alias": "Image Name", "domain": null, "editable": true, "nullable": true, "length": 100 }, { "name": "ActAssetID", "type": "esriFieldTypeString", "alias": "Actuator Asset ID", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "ActLegacyID", "type": "esriFieldTypeString", "alias": "Actuator Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 30 }, { "name": "ActInstallDate", "type": "esriFieldTypeDate", "alias": "Actuator Install Date", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "ActWarrantyDate", "type": "esriFieldTypeDate", "alias": "Actuator Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "ActStatus", "type": "esriFieldTypeString", "alias": "Actuator Lifecycle Status", "domain": null, "editable": true, "nullable": true, "length": 20 }, { "name": "ActProjectNum", "type": "esriFieldTypeString", "alias": "Actuator Project Number", "domain": null, "editable": true, "nullable": true, "length": 30 }, { "name": "ActNotes", "type": "esriFieldTypeString", "alias": "Actuator Notes", "domain": null, "editable": true, "nullable": true, "length": 256 }, { "name": "ActAssetCost", "type": "esriFieldTypeDouble", "alias": "Actuator Asset Cost", "domain": null, "editable": true, "nullable": true }, { "name": "ActReplaceCost", "type": "esriFieldTypeDouble", "alias": "Actuator Replacement Cost", "domain": null, "editable": true, "nullable": true }, { "name": "ActCondition", "type": "esriFieldTypeSmallInteger", "alias": "Actuator Condition", "domain": null, "editable": true, "nullable": true }, { "name": "ActConditionDate", "type": "esriFieldTypeDate", "alias": "Actuator Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "ActRehabDate", "type": "esriFieldTypeDate", "alias": "Actuator Last Rehab Date", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "ActLifeExpectancy", "type": "esriFieldTypeSmallInteger", "alias": "Actuator Life Expectancy in Yrs", "domain": null, "editable": true, "nullable": true }, { "name": "ActRemUseLife", "type": "esriFieldTypeSmallInteger", "alias": "Actuator Remaining Useful Life in Yrs", "domain": null, "editable": true, "nullable": true }, { "name": "ActCOF", "type": "esriFieldTypeDouble", "alias": "Actuator Consequence of Failure", "domain": null, "editable": true, "nullable": true }, { "name": "ActPOF", "type": "esriFieldTypeDouble", "alias": "Actuator Probability of Failure", "domain": null, "editable": true, "nullable": true }, { "name": "ActBRE", "type": "esriFieldTypeDouble", "alias": "Actuator Business Risk Exposure", "domain": null, "editable": true, "nullable": true }, { "name": "ActManufacturer", "type": "esriFieldTypeString", "alias": "Actuator Manufacturer", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "ActModel", "type": "esriFieldTypeString", "alias": "Actuator Model", "domain": null, "editable": true, "nullable": true, "length": 25 }, { "name": "ActModelYear", "type": "esriFieldTypeSmallInteger", "alias": "Actuator Model Year", "domain": null, "editable": true, "nullable": true }, { "name": "ActSerialNumber", "type": "esriFieldTypeString", "alias": "Actuator Serial Number", "domain": null, "editable": true, "nullable": true, "length": 25 }, { "name": "ActuatorType", "type": "esriFieldTypeString", "alias": "Actuator Actuator Type", "domain": null, "editable": true, "nullable": true, "length": 18 }, { "name": "MotorSpeed", "type": "esriFieldTypeSmallInteger", "alias": "Actuator Motor Speed in RPM", "domain": null, "editable": true, "nullable": true }, { "name": "OpSpeed", "type": "esriFieldTypeSmallInteger", "alias": "Actuator Operating Speed in Seconds", "domain": null, "editable": true, "nullable": true }, { "name": "Volts", "type": "esriFieldTypeInteger", "alias": "Actuator Voltage", "domain": null, "editable": true, "nullable": true }, { "name": "Amps", "type": "esriFieldTypeDouble", "alias": "Actuator Amperage", "domain": null, "editable": true, "nullable": true }, { "name": "Weight", "type": "esriFieldTypeSmallInteger", "alias": "Actuator Weight in LB", "domain": null, "editable": true, "nullable": true }, { "name": "ShaftDiam", "type": "esriFieldTypeSmallInteger", "alias": "Actuator Shaft Diameter", "domain": null, "editable": true, "nullable": true }, { "name": "FrameNum", "type": "esriFieldTypeString", "alias": "Actuator Frame Number", "domain": null, "editable": true, "nullable": true, "length": 10 }, { "name": "Torque", "type": "esriFieldTypeSmallInteger", "alias": "Actuator Torque in FT - LBS", "domain": null, "editable": true, "nullable": true }, { "name": "ActAssetName", "type": "esriFieldTypeString", "alias": "Actuator Asset Name (Equipment No.)", "domain": null, "editable": true, "nullable": true, "length": 50 }, { "name": "ActImage", "type": "esriFieldTypeString", "alias": "Actuator Image Name", "domain": null, "editable": true, "nullable": true, "length": 100 }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38 }, { "name": "CREATED_BY", "type": "esriFieldTypeString", "alias": "CREATED_BY", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "LAST_EDITED_BY", "type": "esriFieldTypeString", "alias": "LAST_EDITED_BY", "domain": null, "editable": true, "nullable": true, "length": 255 }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "domain": null, "editable": true, "nullable": true, "length": 8 } ], "indexes": [ { "name": "R551_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_551", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1161ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_551", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "TB_WRF_Valve", "description": "", "prototype": { "attributes": { "LAST_EDITED_BY": null, "LAST_EDITED_DATE": null, "AssetID": null, "LegacyID": null, "Address": null, "Location": null, "InstallDate": null, "WarrantyDate": null, "Status": "In Service", "ProcessArea": null, "Process": null, "ProjectNum": null, "Notes": null, "ParentID": null, "AssetCost": null, "ReplaceCost": null, "Condition": null, "ConditionDate": null, "RehabDate": null, "LifeExpectancy": null, "RemUseLife": null, "COF": null, "POF": null, "BRE": null, "Manufacturer": null, "Model": null, "ModelYear": null, "SerialNumber": null, "ValveType": null, "ValveFunction": null, "Diameter": null, "OpenDirec": null, "TurnsReq": null, "OperStatus": null, "Actuated": null, "CutInPress": null, "CutOutPress": null, "AssetName": null, "Image": null, "ActAssetID": null, "ActLegacyID": null, "ActInstallDate": null, "ActWarrantyDate": null, "ActStatus": "In Service", "ActProjectNum": null, "ActNotes": null, "ActAssetCost": null, "ActReplaceCost": null, "ActCondition": null, "ActConditionDate": null, "ActRehabDate": null, "ActLifeExpectancy": null, "ActRemUseLife": null, "ActCOF": null, "ActPOF": null, "ActBRE": null, "ActManufacturer": null, "ActModel": null, "ActModelYear": null, "ActSerialNumber": null, "ActuatorType": null, "MotorSpeed": null, "OpSpeed": null, "Volts": null, "Amps": null, "Weight": null, "ShaftDiam": null, "FrameNum": null, "Torque": null, "ActAssetName": null, "ActImage": null, "CREATED_DATE": null, "CREATED_BY": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, AMF, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 1000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }