View In:   ArcGIS Online Map Viewer

Name: Water_GIS.DBO.SystemValves

Display Field: ComputerName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 0.0
YMin: 0.0
XMax: 447477.49289999995
YMax: 4941711.5187
Spatial Reference: 26918  (26918)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 112, 255, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[52, 52, 52, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, editable: true, nullable: true, defaultValue: null, modelName: ANCILLARYROLE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• GRIDNUMBER ( type: esriFieldTypeString, alias: GRIDNUMBER, editable: true, nullable: true, length: 15, defaultValue: null, modelName: GRIDNUMBER )
• ASSETNUMBER ( type: esriFieldTypeString, alias: ASSETNUMBER, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ASSETNUMBER )
• WORKORDERID ( type: esriFieldTypeString, alias: WORKORDERID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WORKORDERID )
• INSTALLYEAR ( type: esriFieldTypeInteger, alias: INSTALLYEAR, editable: true, nullable: true, defaultValue: null, modelName: INSTALLYEAR )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LifeCycleStatus, editable: true, nullable: false, length: 20, defaultValue: Active, modelName: LifeCycleStatus )
• PRESSUREZONE ( type: esriFieldTypeString, alias: PressureZone, editable: true, nullable: false, length: 50, defaultValue: null, modelName: PressureZone )
• SERVICEAREA ( type: esriFieldTypeString, alias: ServiceArea, editable: true, nullable: false, length: 50, defaultValue: null, modelName: ServiceArea )
• ROTATION ( type: esriFieldTypeDouble, alias: ROTATION, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• DIAMETER ( type: esriFieldTypeString, alias: Diameter, editable: true, nullable: false, length: 10, defaultValue: null, modelName: Diameter , Coded Values: [100: 100] , [150: 150] , [200: 200] , ...9 more... )
• GPS_X ( type: esriFieldTypeDouble, alias: GPS_X, editable: true, nullable: true, defaultValue: null, modelName: GPS_X )
• GPS_Y ( type: esriFieldTypeDouble, alias: GPS_Y, editable: true, nullable: true, defaultValue: null, modelName: GPS_Y )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DESCRIPTION )
• SYSTEMVALVETYPE ( type: esriFieldTypeInteger, alias: SystemValveType, editable: true, nullable: true, defaultValue: 10, modelName: SystemValveType )
• SYSTEMVALVEID ( type: esriFieldTypeString, alias: SystemValveID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ValveID )
• NORMALLYOPEN ( type: esriFieldTypeSmallInteger, alias: NormallyOpen, editable: true, nullable: false, defaultValue: 1, modelName: NormallyOpen )
• VALVESTATUS ( type: esriFieldTypeString, alias: ValveStatus, editable: true, nullable: false, length: 10, defaultValue: null, modelName: ValveStatus , Coded Values: [OPEN: Open] , [CLO: Close] )
• OPERATIONAL ( type: esriFieldTypeSmallInteger, alias: Operational, editable: true, nullable: false, defaultValue: 1, modelName: Operational )
• BYPASSVALVE ( type: esriFieldTypeSmallInteger, alias: BypassValve, editable: true, nullable: false, defaultValue: 0, modelName: BypassValve )
• CLOCKWISETOCLOSE ( type: esriFieldTypeSmallInteger, alias: ClockwiseToClose, editable: true, nullable: false, defaultValue: null, modelName: ClockwiseToClose )
• MOTORIZED ( type: esriFieldTypeSmallInteger, alias: Motorized, editable: true, nullable: false, defaultValue: null, modelName: Motorized )
• PERCENTOPEN ( type: esriFieldTypeInteger, alias: PercentOpen, editable: true, nullable: true, defaultValue: 100, modelName: PercentOpen )
• TURNSTOCLOSE ( type: esriFieldTypeInteger, alias: TURNSTOCLOSE, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• REGULATIONTYPE ( type: esriFieldTypeString, alias: RegulationType, editable: true, nullable: false, length: 20, defaultValue: null, modelName: RegulationType )
• ASSOCIATEDFACILITY ( type: esriFieldTypeString, alias: AssociatedFacility, editable: true, nullable: false, length: 50, defaultValue: null, modelName: AssociatedFacility )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: false, length: 20, defaultValue: null, modelName: Manufacturer )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMMENTS )
• SLID ( type: esriFieldTypeSmallInteger, alias: Slid, editable: true, nullable: false, defaultValue: 0, modelName: Slid )
• REMARKS ( type: esriFieldTypeString, alias: REMARKS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: REMARKS )
• HYPERLINK ( type: esriFieldTypeString, alias: HYPERLINK, editable: true, nullable: true, length: 100, defaultValue: null, modelName: HYPERLINK )
• CROSSSTREET ( type: esriFieldTypeString, alias: CROSSSTREET, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CROSSSTREET )
• VALVESTREET ( type: esriFieldTypeString, alias: VALVESTREET, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VALVESTREET )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DISTRICT )
• EXERCISEPERCENT ( type: esriFieldTypeInteger, alias: EXERCISEPERCENT, editable: true, nullable: true, defaultValue: null, modelName: EXERCISEPERCENT )
• MAP ( type: esriFieldTypeInteger, alias: MAP, editable: true, nullable: true, defaultValue: null, modelName: MAP )
• VALVEOPEN ( type: esriFieldTypeString, alias: VALVEOPEN, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VALVEOPEN , Coded Values: [Y: Yes] , [N: No] )
• QUARTER ( type: esriFieldTypeString, alias: QUARTER, editable: true, nullable: true, length: 10, defaultValue: null, modelName: QUARTER )
• SECTIONS ( type: esriFieldTypeString, alias: SECTIONS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SECTIONS )
• SUBDIVISION ( type: esriFieldTypeString, alias: SUBDIVISION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SUBDIVISION )
• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• VALVEADDRESS ( type: esriFieldTypeString, alias: VALVEADDRESS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: VALVEADDRESS )
• VALVEBOX ( type: esriFieldTypeInteger, alias: VALVEBOX, editable: true, nullable: true, defaultValue: null, modelName: VALVEBOX )
• VALVEDRIVE ( type: esriFieldTypeString, alias: VALVEDRIVE, editable: true, nullable: true, length: 20, defaultValue: Main, modelName: VALVEDRIVE )
• VALVEFUNCTION ( type: esriFieldTypeString, alias: VALVE FUNCTION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVEFUNCTION , Coded Values: [DV: Distribution Valve] , [HV: Hydrant Valve] , [DS: Domestic Service] , ...7 more... )
• VALVELATITUDEDIRECTION ( type: esriFieldTypeString, alias: VALVELATITUDEDIRECTION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVELATITUDEDIRECTION )
• VALVELATITUDEDEGREES ( type: esriFieldTypeString, alias: VALVELATITUDEDEGREES, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVELATITUDEDEGREES )
• VALVELATITUDEMINUTES ( type: esriFieldTypeString, alias: VALVELATITUDEMINUTES, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVELATITUDEMINUTES )
• VALVELONGITUDEDIRECTION ( type: esriFieldTypeString, alias: VALVELONGITUDEDIRECTION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVELONGITUDEDIRECTION )
• VALVELONGITUDEDEGRESS ( type: esriFieldTypeString, alias: VALVELONGITUDEDEGRESS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVELONGITUDEDEGRESS )
• VALVELONGITUDEMINUTES ( type: esriFieldTypeString, alias: VALVELONGITUDEMINUTES, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVELONGITUDEMINUTES )
• VALVELOCATION ( type: esriFieldTypeString, alias: VALVELOCATION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVELOCATION )
• VALVETYPE ( type: esriFieldTypeString, alias: VALVETYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVETYPE , Coded Values: [DV: Distribution Valve] , [HV: Hydrant Valve] , [DS: Domestic Service] , ...7 more... )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, editable: true, nullable: true, length: 211, defaultValue: null, modelName: LOCATIONDESCRIPTION )
• SETTING ( type: esriFieldTypeDouble, alias: SETTING, editable: true, nullable: true, defaultValue: null, modelName: SETTING )
• MINORLOSS ( type: esriFieldTypeDouble, alias: MINORLOSS, editable: true, nullable: true, defaultValue: null, modelName: MINORLOSS )
• CURVE ( type: esriFieldTypeString, alias: CURVE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CURVE )
• CONTROLID ( type: esriFieldTypeString, alias: CONTROLID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CONTROLID )
• UPPERLEVEL ( type: esriFieldTypeDouble, alias: UPPERLEVEL, editable: true, nullable: true, defaultValue: null, modelName: UPPERLEVEL )
• LOWERLEVEL ( type: esriFieldTypeDouble, alias: LOWERLEVEL, editable: true, nullable: true, defaultValue: null, modelName: LOWERLEVEL )
• ID ( type: esriFieldTypeString, alias: ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ID )
• MODELINGVALVETYPE ( type: esriFieldTypeString, alias: MODELINGVALVETYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MODELINGVALVETYPE )
• LastActivity ( type: esriFieldTypeString, alias: LastActivity, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LastActivity , Coded Values: [INST: Installation] , [UPDT: Update Info] , [EXE: Exercise Valve] , ...4 more... )
• DateStamp ( type: esriFieldTypeDate, alias: DateStamp, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateStamp )
• OperatedBy ( type: esriFieldTypeString, alias: OperatedBy, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OperatedBy )
• ComputerName ( type: esriFieldTypeString, alias: ComputerName, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ComputerName )
• OperationalStatus ( type: esriFieldTypeString, alias: OperationalStatus, editable: true, nullable: true, length: 4, defaultValue: null, modelName: OperationalStatus , Coded Values: [OK: OK] , [NRPR: Needs Repair] , [INOP: Inoperable] , ...6 more... )
• HighTorque ( type: esriFieldTypeString, alias: HighTorque, editable: true, nullable: true, length: 5, defaultValue: null, modelName: HighTorque )
• ActivityId ( type: esriFieldTypeString, alias: ActivityId, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ActivityId )
• AssemblytType ( type: esriFieldTypeString, alias: AssemblytType, editable: true, nullable: true, length: 25, defaultValue: null, modelName: AssemblytType , Coded Values: [GV: Gate Valve] , [BFV: Butterfly Valve] , [BAL: Ball Valve] , ...8 more... )
• Depth ( type: esriFieldTypeString, alias: Depth, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Depth )
• UpdateGps ( type: esriFieldTypeString, alias: UpdateGps, editable: true, nullable: true, length: 5, defaultValue: null, modelName: UpdateGps , Coded Values: [Y: Yes] , [N: No] )
• LinkedDocuments ( type: esriFieldTypeString, alias: LinkedDocuments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LinkedDocuments )
• OpTime ( type: esriFieldTypeString, alias: OpTime, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OpTime )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Address )
• AddressNumber ( type: esriFieldTypeString, alias: AddressNumber, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AddressNumber )
• CloseDirection ( type: esriFieldTypeString, alias: CloseDirection, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CloseDirection , Coded Values: [CLW: Clockwise] , [CCW: Counter Clockwise] )
• Crew ( type: esriFieldTypeString, alias: Crew, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Crew , Coded Values: [Chris: Chris Hall] , [Clay: Clay Sluytman] , [Jason: Jason McConnell] , ...6 more... )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssetID )
• Abbr ( type: esriFieldTypeString, alias: Abbr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Abbr )
• RIMS ( type: esriFieldTypeDouble, alias: RIMS, editable: true, nullable: true, defaultValue: null, modelName: RIMS )
• InstallDate ( type: esriFieldTypeDouble, alias: InstallDate, editable: true, nullable: true, defaultValue: null, modelName: InstallDate )
• AssetTypeNew ( type: esriFieldTypeString, alias: AssetTypeNew, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssetTypeNew )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: Water_GIS.DBO.SystemValves
  Description:
  Prototype:
  AssetTypeNew: null
  InstallDate: null
  ANCILLARYROLE: null
  ENABLED: 1
  FACILITYID: null
  GRIDNUMBER: null
  ASSETNUMBER: null
  WORKORDERID: null
  INSTALLYEAR: null
  LIFECYCLESTATUS: Active
  PRESSUREZONE:
  SERVICEAREA:
  ROTATION: null
  DIAMETER:
  GPS_X: null
  GPS_Y: null
  DESCRIPTION: null
  SYSTEMVALVETYPE: 10
  SYSTEMVALVEID: null
  NORMALLYOPEN: 1
  VALVESTATUS:
  OPERATIONAL: 1
  BYPASSVALVE: 0
  CLOCKWISETOCLOSE: 0
  MOTORIZED: 0
  PERCENTOPEN: 100
  TURNSTOCLOSE: null
  REGULATIONTYPE:
  ASSOCIATEDFACILITY:
  MANUFACTURER:
  COMMENTS: null
  SLID: 0
  REMARKS: null
  HYPERLINK: null
  CROSSSTREET: null
  VALVESTREET: null
  DISTRICT: null
  EXERCISEPERCENT: null
  MAP: null
  VALVEOPEN: null
  QUARTER: null
  SECTIONS: null
  SUBDIVISION: null
  ELEVATION: null
  VALVEADDRESS: null
  VALVEBOX: null
  VALVEDRIVE: Main
  VALVEFUNCTION: null
  VALVELATITUDEDIRECTION: null
  VALVELATITUDEDEGREES: null
  VALVELATITUDEMINUTES: null
  VALVELONGITUDEDIRECTION: null
  VALVELONGITUDEDEGRESS: null
  VALVELONGITUDEMINUTES: null
  VALVELOCATION: null
  VALVETYPE: null
  LOCATIONDESCRIPTION: null
  SETTING: null
  MINORLOSS: null
  CURVE: null
  CONTROLID: null
  UPPERLEVEL: null
  LOWERLEVEL: null
  ID: null
  MODELINGVALVETYPE: null
  LastActivity: null
  DateStamp: null
  OperatedBy: null
  ComputerName: null
  OperationalStatus: null
  HighTorque: null
  ActivityId: null
  AssemblytType: null
  Depth: null
  UpdateGps: null
  LinkedDocuments: null
  OpTime: null
  Address: null
  AddressNumber: null
  CloseDirection: null
  Crew: null
  AssetID: null
  Abbr: null
  RIMS: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata