Layer: Valve_Survey (ID:0)

View In: Map Viewer

Name: Valve_Survey

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 1358775

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"authoringInfo":{},"type":"uniqueValue","field1":"NeedsWrk","defaultSymbol":{"color":[170,170,170,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"defaultLabel":"Other","uniqueValueInfos":[{"value":"no","symbol":{"color":[60,175,153,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"No"},{"value":"yes","symbol":{"color":[255,0,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Yes"}]},"transparency":0}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Global ID Field: globalid

Type ID Field: NeedsWrk

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
SurveyDate (type: esriFieldTypeDate, alias: Survey Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
InspectName (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PtNumber (type: esriFieldTypeString, alias: Survey Point Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GridLoc (type: esriFieldTypeString, alias: Grid Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SystemType (type: esriFieldTypeString, alias: Valve System Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CHWS: CHW-Supply], [CHWR: CHW-Return], [HHWS: HHW-Supply], ... 5 more ...)
ValveSize (type: esriFieldTypeString, alias: Valve Size (Inches), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Turns (type: esriFieldTypeString, alias: How many turns does it take to open/close valve?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
VFeedType (type: esriFieldTypeString, alias: Valve Feed Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Main: Main], [Fire: Fire], [Other: Other])
FeedTypeOther (type: esriFieldTypeString, alias: If other, what type of feed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
VKeyType (type: esriFieldTypeString, alias: Key Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Square: Square], [Wheel: Wheel], [PVC Quarter Turn: PVC Quarter Turn], ... 1 more ...)
KeyTypeOther (type: esriFieldTypeString, alias: If other, what type of key type?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LeftRight (type: esriFieldTypeString, alias: Left or Right Turn?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Left: Left], [Right: Right])
ValveLoc (type: esriFieldTypeString, alias: Valve Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [VVP: Vault / Valve Pit], [Tunnel: Tunnel], [ValveBx: Valve Box], ... 1 more ...)
ValveLocOther (type: esriFieldTypeString, alias: If other, what type of valve location?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LocDescription (type: esriFieldTypeString, alias: Brief Description of Valve Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
VOpenClosed (type: esriFieldTypeString, alias: Valve is opened or closed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Open: Open], [Closed: Closed])
Vman (type: esriFieldTypeString, alias: Valve Manufacturer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Vmodel (type: esriFieldTypeString, alias: Valve Model, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
VSN (type: esriFieldTypeString, alias: Valve Serial Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Vobstructions (type: esriFieldTypeString, alias: Valve Obstructions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
Pinsulation (type: esriFieldTypeString, alias: Was insulation installed on pipe near valve? (If applicable), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
CondInsulation (type: esriFieldTypeString, alias: Condition of Insulation (If applicable), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Satisfactory: Satisfactory], [Needs Repair: Needs Repair], [Missing: Missing])
ValveBXCond (type: esriFieldTypeString, alias: Valve Box Condition (If applicable), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Satisfactory: Satisfactory], [Needs Repair: Needs Repair])
Voperation (type: esriFieldTypeString, alias: Is valve operable?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
AddComments (type: esriFieldTypeString, alias: Additional Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
NeedsWrk (type: esriFieldTypeString, alias: Needs Additional Attention?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
NormalPosition (type: esriFieldTypeString, alias: Normal Valve Position, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [OPEN: OPEN], [CLOSED: CLOSED], [UNKNOWN: UNKNOWN])
CurrentPosition (type: esriFieldTypeString, alias: Current Valve Position, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [OPEN: OPEN], [CLOSED: CLOSED], [UNKNOWN: UNKNOWN])
RepairMade (type: esriFieldTypeString, alias: Repair Made?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [0: NO], [1: YES])
DateRepaired (type: esriFieldTypeDate, alias: Date Repaired, SQL Type: sqlTypeOther, length: 0, nullable: true, editable: true)
RepairPerson (type: esriFieldTypeString, alias: Repair Person, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Mitch: Mitch], [Grant: Grant], [Layne: Layne], ... 2 more ...)
RepairNotes (type: esriFieldTypeString, alias: Repair Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
RepairType (type: esriFieldTypeString, alias: Repair Type Needed, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true, Coded Values: [REPLACE VALVE: REPLACE VALVE], [ABANDON VALVE: ABANDON VALVE], [BRING VALVE TO GRADE: BRING VALVE TO GRADE], ... 4 more ...)
RepairTypeDone (type: esriFieldTypeString, alias: Repair Type Done, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [VALVE BOX BROUGHT TO GRADE: VALVE BOX BROUGHT TO GRADE], [VALVE REPLACED: VALVE REPLACED], [OTHER REPAIR: OTHER REPAIR], ... 4 more ...)
RepairCategoryPlan (type: esriFieldTypeString, alias: Category of Repair, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [PLANNED OUTAGE: PLANNED OUTAGE], [EMERGENCY REPAIR: EMERGENCY REPAIR], [ABANDONED VALVE: ABANDONED VALVE])

Types:

NeedsWrk: no

NeedsWrk: yes

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/18/2022 3:44:49 PM

Schema Last Edit Date: 2/18/2022 3:44:49 PM

Data Last Edit Date: 2/18/2022 3:44:49 PM

Supported Operations: Query Query Top Features Query Analytic Query Bins Query Attachments Add Features Update Features Delete Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat