{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 42, "name": "Sewer Valve Info", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NAME_NUMBER", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "NAME_NUMBER", "type": "esriFieldTypeString", "alias": "NAME NUMBER", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "NAME_NUMBER" }, { "name": "FFID", "type": "esriFieldTypeInteger", "alias": "FFID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FFID" }, { "name": "Maintenance_Strategy", "type": "esriFieldTypeString", "alias": "Maintenance Strategy", "domain": { "type": "codedValue", "name": "BUO_Maintenance_Strategy", "description": "Maintenance strategies defined by the Bureau of Utility Operations", "codedValues": [ { "name": "Run To Failure", "code": "Run To Failure" }, { "name": "Preventative Maintenance", "code": "Preventative Maintenance" }, { "name": "Predictive Maintenance", "code": "Predictive Maintenance" }, { "name": "Risk", "code": "Risk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Maintenance_Strategy" }, { "name": "Install_Year", "type": "esriFieldTypeSmallInteger", "alias": "Install Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Install_Year" }, { "name": "WarrantyStartDate", "type": "esriFieldTypeDate", "alias": "Warranty Start Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyStartDate" }, { "name": "WarrantyEndDate", "type": "esriFieldTypeDate", "alias": "Warranty End Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyEndDate" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": { "type": "codedValue", "name": "BUO_MFG_Valve", "description": "Valve manufacturers as specified by the Bureau of Utility Operations", "codedValues": [ { "name": "A.R.I. USA Inc.", "code": "A.R.I USA Inc." }, { "name": "ABZ Manufacturing", "code": "ABZ Manufacturing" }, { "name": "Acrison, Inc.", "code": "Acrison, Inc." }, { "name": "American", "code": "American" }, { "name": "Ames", "code": "Ames" }, { "name": "Anniston", "code": "Anniston" }, { "name": "APCO Valves", "code": "APCO Valves" }, { "name": "Apollo Valves", "code": "Apollo Valves" }, { "name": "Avk Valves", "code": "Avk Valves" }, { "name": "Beeco", "code": "Beeco" }, { "name": "Bermad Valve", "code": "Bermad Valve" }, { "name": "BIF", "code": "BIF" }, { "name": "Bray Control And Valves", "code": "Bray Controls And Valves" }, { "name": "Cameron", "code": "Cameron" }, { "name": "Centerline", "code": "Centerline" }, { "name": "Cla-Val", "code": "Cla-Val" }, { "name": "CLB Valve", "code": "CLB Valve" }, { "name": "Clow Valve Company", "code": "Clow Valve Company" }, { "name": "Crane Valves", "code": "Crane Valves" }, { "name": "Crispin Valve Manufacturing", "code": "Crispin Valve Manufacturing" }, { "name": "Danfoss Valves", "code": "Danfoss Valves" }, { "name": "Davis Valve", "code": "Davis Valve" }, { "name": "Dezurik Valve Company", "code": "Dezurik Valve Company" }, { "name": "DK TMI Co. , Ltd Valves", "code": "DK TMI Co. , Ltd Valves" }, { "name": "Dresser Rand Group Inc.", "code": "Dresser Rand Group Inc." }, { "name": "E.I.M. Controls", "code": "E.I.M. Controls" }, { "name": "Eddy Iowa", "code": "Eddy Iowa" }, { "name": "Febco", "code": "Febco" }, { "name": "Flowline, Inc", "code": "Flowline, Inc" }, { "name": "Flowserve", "code": "Flowserve" }, { "name": "FNW Piping Products", "code": "FNW Piping Products" }, { "name": "G.A. Industries", "code": "G.A. Industries" }, { "name": "Hayward Gordon", "code": "Hayward Gordon" }, { "name": "Hayward Plastics", "code": "Hayward Plastics" }, { "name": "Henry Pratt Valve Co.", "code": "Henry Pratt Valve Co." }, { "name": "Homestead Valves Co", "code": "Homestead Valve Co" }, { "name": "Hydro Gate Valves", "code": "Hydro Gate Valves" }, { "name": "Indelac Controls", "code": "Indelac Controls" }, { "name": "Kennedy Fire Hydrants And Valves", "code": "Kennedy Fire Hydrants And Valves" }, { "name": "Keystone Valve", "code": "Keystone Valve" }, { "name": "Kinetrol Usa Inc", "code": "Kinetrol Usa Inc" }, { "name": "Limitorque", "code": "Limitorque" }, { "name": "M and H Valve", "code": "M and H Valve" }, { "name": "Meyer Products", "code": "Meyer Products" }, { "name": "Milliken Valve Company", "code": "Milliken Valve Company" }, { "name": "Mueller Co.", "code": "Mueller Co." }, { "name": "Nibco", "code": "Nibco" }, { "name": "Orbinox Valve Solutions", "code": "Orbinox Valve Solutions" }, { "name": "Pepco Valves", "code": "Pepco Valves" }, { "name": "Plasti-fab, Inc.", "code": "Plasti-fab, Inc." }, { "name": "Powell", "code": "Powell" }, { "name": "Red Valve Company", "code": "Red Valve Company" }, { "name": "Rodney Hunt - Fontaine Inc.", "code": "Rodney Hunt - Fontaine Inc." }, { "name": "Ross Valve", "code": "Ross Valve" }, { "name": "Rotork Actuators And Valves", "code": "Rotork Actuators And Valves" }, { "name": "RW Gate Company", "code": "RW Gate Company" }, { "name": "Saehan Valve Ind. Co , Ltd.", "code": "Saehan Valve Ind. Co , Ltd." }, { "name": "Shick Tube-yeyor Corporation", "code": "Shick Tube-yeyor Corporation" }, { "name": "Singer Heaters", "code": "Singer Heaters" }, { "name": "Smith And Loveless", "code": "Smith And Loveless" }, { "name": "SST Enviro Corp", "code": "SST Enviro Corp" }, { "name": "Techno Check Valves - Cameron Valve", "code": "Techno Check Valves - Cameron Valve" }, { "name": "Terminal City Iron Works Valves", "code": "Terminal City Iron Works Valves" }, { "name": "Tideflex Technologies", "code": "Tideflex Technologies" }, { "name": "Titan Flow Control, Inc.", "code": "Titan Flow Control, Inc." }, { "name": "U.S. Manufacturing Inc.", "code": "U.S. Manufacturing Inc." }, { "name": "Valmatic Valves", "code": "Valmatic Valves" }, { "name": "Vortex Valves", "code": "Vortex Valves" }, { "name": "Waterman Industries", "code": "Waterman Industries" }, { "name": "Watts", "code": "Watts" }, { "name": "Whipps", "code": "Whipps" }, { "name": "Wilkins", "code": "Wilkins" }, { "name": "Zurn Wilkins Engineered Water Solutions", "code": "Zurn Wilkins Engineered Water Solutions" }, { "name": "H-TEC", "code": "H-TEC" }, { "name": "Wood Matthew Fire Hydrant", "code": "Wood Matthew Fire Hydrant" }, { "name": "Woods Matthews/Kennedy FH with Lead jnts", "code": "Woods Matthews/Kennedy FH with Lead jnts" }, { "name": "Gaysco Valves", "code": "Gaysco Valves" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "Model_No", "type": "esriFieldTypeString", "alias": "Model No", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Model" }, { "name": "Serial_No", "type": "esriFieldTypeString", "alias": "Serial No", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Serial" }, { "name": "Bury_Condition", "type": "esriFieldTypeString", "alias": "Bury_Condition", "domain": { "type": "codedValue", "name": "BUO_Bury_Condition", "description": "Bury Condition", "codedValues": [ { "name": "Vault", "code": "Vault" }, { "name": "Direct Bury", "code": "Direct Bury" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Bury_Condition" }, { "name": "Operator_Type", "type": "esriFieldTypeString", "alias": "Operator Type", "domain": { "type": "codedValue", "name": "BUO_Operator_Type", "description": "Valve operation type", "codedValues": [ { "name": "Wheel", "code": "Wheel" }, { "name": "Key", "code": "Key" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Operator_Type" }, { "name": "ARV_Odor_Control_System", "type": "esriFieldTypeString", "alias": "ARV Odor Control System", "domain": { "type": "codedValue", "name": "Yes/No", "description": "Three character Yes/No values", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ARV_Odor_Control_System" }, { "name": "Open_Direction", "type": "esriFieldTypeString", "alias": "Open Direction", "domain": { "type": "codedValue", "name": "BUO_Rotation", "description": "Rotation values specified by the Bureau of Utility Operations", "codedValues": [ { "name": "CW", "code": "CW" }, { "name": "CCW", "code": "CCW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Open_Direction" }, { "name": "Turns_To_Close", "type": "esriFieldTypeSmallInteger", "alias": "Turns To Close", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Turns_To_Close" }, { "name": "Current_Position", "type": "esriFieldTypeString", "alias": "Current Position", "domain": { "type": "codedValue", "name": "BUO_Current_Position", "description": "State of Valve", "codedValues": [ { "name": "Open", "code": "Open" }, { "name": "Closed", "code": "Closed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "Current_Position" }, { "name": "Current_Position_Date", "type": "esriFieldTypeDate", "alias": "Current Position Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Current_Position_Date" }, { "name": "ARV_Priority", "type": "esriFieldTypeSmallInteger", "alias": "ARV Priority", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ARV_Priority" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Notes" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "BUO_Status", "description": "Asset status as defined by the Bureau of Utilitity Operations", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Status" }, { "name": "Valve_ID", "type": "esriFieldTypeString", "alias": "Valve ID", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Valve_ID" }, { "name": "Vault_Material", "type": "esriFieldTypeString", "alias": "Vault Material", "domain": { "type": "codedValue", "name": "BUO_Wall_Type", "description": "Wall types defined by the Bureau of Utility Operations", "codedValues": [ { "name": "Brick", "code": "Brick" }, { "name": "Block", "code": "Block" }, { "name": "Precast", "code": "Precast" }, { "name": "Poured", "code": "Poured" }, { "name": "Plastic", "code": "Plastic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Vault_Material" }, { "name": "Vault_Shape", "type": "esriFieldTypeString", "alias": "Vault Shape", "domain": { "type": "codedValue", "name": "BUOVaultShape", "description": "Sewer Vault Shape", "codedValues": [ { "name": "Circular", "code": "Circular" }, { "name": "Rectangular", "code": "Rectangular" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Vault_Shape" }, { "name": "Valve_Type", "type": "esriFieldTypeString", "alias": "Valve Type", "domain": { "type": "codedValue", "name": "BUO_ARVType", "description": "Type of Sewer Air Release Valve", "codedValues": [ { "name": "Air Release", "code": "Air Release" }, { "name": "Combination", "code": "Combination" }, { "name": "Vacuum", "code": "Vacuum" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "ARV_Type" }, { "name": "Tap_Type", "type": "esriFieldTypeString", "alias": "Tap Type", "domain": { "type": "codedValue", "name": "BUOTapType", "description": "Type of Sewer Valve Tap", "codedValues": [ { "name": "Flange", "code": "Flange" }, { "name": "Saddle", "code": "Saddle" }, { "name": "Tap", "code": "Tap" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Tap_Type" }, { "name": "Valve_Position", "type": "esriFieldTypeString", "alias": "Valve Position", "domain": { "type": "codedValue", "name": "BUO_Current_Position", "description": "State of Valve", "codedValues": [ { "name": "Open", "code": "Open" }, { "name": "Closed", "code": "Closed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "ARV_Position" }, { "name": "Valve_Location", "type": "esriFieldTypeString", "alias": "Valve Location", "domain": { "type": "codedValue", "name": "BUO_ARVLocation", "description": "Location of ARV in Vault", "codedValues": [ { "name": "Top", "code": "Top" }, { "name": "Side", "code": "Side" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ARV_Location" }, { "name": "Nipple_Material", "type": "esriFieldTypeString", "alias": "Nipple Material", "domain": { "type": "codedValue", "name": "BUO_ARVPipeMaterial", "description": "ARV Pipe Material", "codedValues": [ { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Galvanized", "code": "Galvanized" }, { "name": "Stainless", "code": "Stainless" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "ARV_Pipe_Material" }, { "name": "Max_Pressure", "type": "esriFieldTypeDouble", "alias": "Max Pressure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Max_Pressure" }, { "name": "Min_Pressure", "type": "esriFieldTypeDouble", "alias": "Min Pressure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Min_Pressure" }, { "name": "Valve_Size", "type": "esriFieldTypeDouble", "alias": "Valve Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ARV_Size" }, { "name": "Tap_Size", "type": "esriFieldTypeDouble", "alias": "Tap Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Tap_Size" }, { "name": "Vault_Length", "type": "esriFieldTypeDouble", "alias": "Vault Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Vault_Length" }, { "name": "Vault_Width", "type": "esriFieldTypeDouble", "alias": "Vault Width", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Vault_Width" }, { "name": "Vault_Floor_to_Ceiling", "type": "esriFieldTypeDouble", "alias": "Vault Floor to Ceiling", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Vault_Floor_to_Ceiling" }, { "name": "Side_Wall_to_Valve", "type": "esriFieldTypeDouble", "alias": "Side Wall to Valve", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Side_Wall_to_Valve" }, { "name": "Front_Wall_to_Valve", "type": "esriFieldTypeDouble", "alias": "Front Wall to Valve", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Front_Wall_to_Valve" }, { "name": "Main_to_Ceiling", "type": "esriFieldTypeDouble", "alias": "Main to Ceiling", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Main_to_Ceiling" }, { "name": "PS_Area", "type": "esriFieldTypeString", "alias": "PS Area", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "PS_Area" } ], "indexes": [ { "name": "R72_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Sewer Valve Info", "description": "", "prototype": { "attributes": { "Main_to_Ceiling": null, "PS_Area": null, "NAME_NUMBER": null, "FFID": null, "Maintenance_Strategy": null, "Install_Year": null, "WarrantyStartDate": null, "WarrantyEndDate": null, "Manufacturer": null, "Model_No": null, "Serial_No": null, "Bury_Condition": null, "Operator_Type": null, "ARV_Odor_Control_System": null, "Open_Direction": null, "Turns_To_Close": null, "Current_Position": null, "Current_Position_Date": null, "ARV_Priority": null, "Notes": null, "Status": null, "Valve_ID": null, "Vault_Material": null, "Vault_Shape": null, "Valve_Type": null, "Tap_Type": null, "Valve_Position": null, "Valve_Location": null, "Nipple_Material": null, "Max_Pressure": null, "Min_Pressure": null, "Valve_Size": null, "Tap_Size": null, "Vault_Length": null, "Vault_Width": null, "Vault_Floor_to_Ceiling": null, "Side_Wall_to_Valve": null, "Front_Wall_to_Valve": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }