View In:   ArcGIS Online Map Viewer

Name: GISDATA.DBO.wt_WaterValves

Display Field: ASSET_STATUS

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 10000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 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: 619302.7558000004
YMin: 4894044.1852
XMax: 633366.4780000001
YMax: 4909654.7248
Spatial Reference: 26917  (26917)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 197, 255, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

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: esriFieldTypeString, alias: ENABLED, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ENABLED )
• CREATE_DATE ( type: esriFieldTypeDate, alias: CREATE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATE_DATE )
• CREATE_BY ( type: esriFieldTypeString, alias: CREATE_BY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATE_BY )
• LAST_EDIT_DATE ( type: esriFieldTypeDate, alias: LAST_EDIT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDIT_DATE )
• LAST_EDIT_BY ( type: esriFieldTypeString, alias: LAST_EDIT_BY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LAST_EDIT_BY )
• DATACAPTURE_METHOD ( type: esriFieldTypeString, alias: DATACAPTURE_METHOD, editable: true, nullable: true, length: 22, defaultValue: null, modelName: DATACAPTURE_METHOD )
• SYSTEM_NAME ( type: esriFieldTypeString, alias: SYSTEM_NAME, editable: true, nullable: true, length: 42, defaultValue: null, modelName: SYSTEM_NAME )
• GPS_ACCURACY ( type: esriFieldTypeString, alias: GPS_ACCURACY, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GPS_ACCURACY )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: INSTALL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
• ASSUMPTION_DATE ( type: esriFieldTypeDate, alias: ASSUMPTION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASSUMPTION_DATE )
• COMMISSION_DATE ( type: esriFieldTypeDate, alias: COMMISSION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: COMMISSION_DATE )
• LOCATION_DESCRIPTION ( type: esriFieldTypeString, alias: LOCATION_DESCRIPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCATION_DESCRIPTION )
• ROTATION ( type: esriFieldTypeDouble, alias: ROTATION, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• ASSET_STATUS ( type: esriFieldTypeString, alias: ASSET_STATUS, editable: true, nullable: true, length: 18, defaultValue: null, modelName: ASSET_STATUS )
• FUNCTION_ ( type: esriFieldTypeString, alias: FUNCTION_, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FUNCTION_ )
• ASSET_ID ( type: esriFieldTypeString, alias: ASSET_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSET_ID )
• CONDITION_RATING ( type: esriFieldTypeString, alias: CONDITION_RATING, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CONDITION_RATING )
• SCADA_COMM ( type: esriFieldTypeString, alias: SCADA_COMM, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SCADA_COMM )
• PROJECT_NUMBER ( type: esriFieldTypeString, alias: PROJECT_NUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECT_NUMBER )
• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• MH_ASSET_ID ( type: esriFieldTypeString, alias: MH_ASSET_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MH_ASSET_ID )
• DIAMETER ( type: esriFieldTypeString, alias: DIAMETER, editable: true, nullable: true, length: 4, defaultValue: null, modelName: DIAMETER )
• PERCENTOPEN ( type: esriFieldTypeString, alias: PERCENTOPEN, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PERCENTOPEN )
• REGULATIONTYPE ( type: esriFieldTypeString, alias: REGULATIONTYPE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REGULATIONTYPE )
• TURNSTOCLOSE ( type: esriFieldTypeDouble, alias: TURNSTOCLOSE, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• JOINTTYPE ( type: esriFieldTypeString, alias: JOINTTYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: JOINTTYPE )
• MAKE ( type: esriFieldTypeString, alias: MAKE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MAKE )
• BOX_TYPE ( type: esriFieldTypeString, alias: BOX_TYPE, editable: true, nullable: true, length: 40, defaultValue: null, modelName: BOX_TYPE )
• BOX_OR_CHAMBER ( type: esriFieldTypeString, alias: BOX_OR_CHAMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BOX_OR_CHAMBER )
• BYPASS_VALVE ( type: esriFieldTypeString, alias: BYPASS_VALVE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: BYPASS_VALVE )
• CLOSE_DIRECTION ( type: esriFieldTypeString, alias: CLOSE_DIRECTION, editable: true, nullable: true, length: 17, defaultValue: null, modelName: CLOSE_DIRECTION )
• MOTORIZED ( type: esriFieldTypeString, alias: MOTORIZED, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MOTORIZED )
• NORMALLY_OPEN ( type: esriFieldTypeString, alias: NORMALLY_OPEN, editable: true, nullable: true, length: 3, defaultValue: null, modelName: NORMALLY_OPEN )
• FLOW_CONTROL ( type: esriFieldTypeString, alias: FLOW_CONTROL, editable: true, nullable: true, length: 3, defaultValue: null, modelName: FLOW_CONTROL )
• VALVE_TYPE ( type: esriFieldTypeString, alias: VALVE_TYPE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: VALVE_TYPE )
• VALVE_DESIGNATION ( type: esriFieldTypeString, alias: VALVE_DESIGNATION, editable: true, nullable: true, length: 15, defaultValue: null, modelName: VALVE_DESIGNATION )
• FACILITY_NAME ( type: esriFieldTypeString, alias: FACILITY_NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FACILITY_NAME )
• VALVECLASSIFICATION ( type: esriFieldTypeString, alias: VALVECLASSIFICATION, editable: true, nullable: true, length: 14, defaultValue: null, modelName: VALVECLASSIFICATION )
• AGE ( type: esriFieldTypeDouble, alias: AGE, editable: true, nullable: true, defaultValue: null, modelName: AGE )
• PRESSUREDISTRICT ( type: esriFieldTypeString, alias: PRESSUREDISTRICT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRESSUREDISTRICT )
• REMARKS ( type: esriFieldTypeString, alias: REMARKS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: REMARKS )
• MODVLVTYPE ( type: esriFieldTypeString, alias: MODVLVTYPE, editable: true, nullable: true, length: 31, defaultValue: null, modelName: MODVLVTYPE )
• VLVSETTING ( type: esriFieldTypeString, alias: VLVSETTING, editable: true, nullable: true, length: 60, defaultValue: null, modelName: VLVSETTING )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, editable: true, nullable: true, length: 51, defaultValue: null, modelName: OWNERSHIP )
• VALVE_TYP2 ( type: esriFieldTypeString, alias: VALVE_TYP2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_TYP2 )
• VALVE_TYP3 ( type: esriFieldTypeString, alias: VALVE_TYP3, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_TYP3 )
• VALVE_TYP4 ( type: esriFieldTypeString, alias: VALVE_TYP4, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_TYP4 )
• VALVE_TYP5 ( type: esriFieldTypeString, alias: VALVE_TYP5, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_TYP5 )
• VALVE_TYP6 ( type: esriFieldTypeString, alias: VALVE_TYP6, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_TYP6 )
• VALVE_TYP7 ( type: esriFieldTypeString, alias: VALVE_TYP7, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_TYP7 )
• VALVE_LOCA ( type: esriFieldTypeString, alias: VALVE_LOCA, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_LOCA )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STREET_NAME )
• CROSS_STRE ( type: esriFieldTypeString, alias: CROSS_STRE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CROSS_STRE )
• CROSS_STR2 ( type: esriFieldTypeString, alias: CROSS_STR2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CROSS_STR2 )
• WORK_AREA ( type: esriFieldTypeString, alias: WORK_AREA, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WORK_AREA )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• OBJECTID_2 ( type: esriFieldTypeString, alias: OBJECTID_2, editable: true, nullable: true, length: 200, defaultValue: null, modelName: OBJECTID_2 )
• Feature_ID ( type: esriFieldTypeString, alias: Feature_ID, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Feature_ID )
• ACISys_ID ( type: esriFieldTypeInteger, alias: ACISys_ID, editable: true, nullable: true, defaultValue: null, modelName: ACISys_ID )

Templates:

• Name: GISDATA.DBO.wt_WaterValves
  Description:
  Prototype:
  Feature_ID: null
  ACISys_ID: null
  ANCILLARYROLE: null
  ENABLED: null
  CREATE_DATE: null
  CREATE_BY: null
  LAST_EDIT_DATE: null
  LAST_EDIT_BY: null
  DATACAPTURE_METHOD: null
  SYSTEM_NAME: null
  GPS_ACCURACY: null
  INSTALL_DATE: null
  ASSUMPTION_DATE: null
  COMMISSION_DATE: null
  LOCATION_DESCRIPTION: null
  ROTATION: null
  ASSET_STATUS: null
  FUNCTION_: null
  ASSET_ID: null
  CONDITION_RATING: null
  SCADA_COMM: null
  PROJECT_NUMBER: null
  ELEVATION: null
  MH_ASSET_ID: null
  DIAMETER: null
  PERCENTOPEN: null
  REGULATIONTYPE: null
  TURNSTOCLOSE: null
  JOINTTYPE: null
  MAKE: null
  BOX_TYPE: null
  BOX_OR_CHAMBER: null
  BYPASS_VALVE: null
  CLOSE_DIRECTION: null
  MOTORIZED: null
  NORMALLY_OPEN: null
  FLOW_CONTROL: null
  VALVE_TYPE: null
  VALVE_DESIGNATION: null
  FACILITY_NAME: null
  VALVECLASSIFICATION: null
  AGE: null
  PRESSUREDISTRICT: null
  REMARKS: null
  MODVLVTYPE: null
  VLVSETTING: null
  OWNERSHIP: null
  VALVE_TYP2: null
  VALVE_TYP3: null
  VALVE_TYP4: null
  VALVE_TYP5: null
  VALVE_TYP6: null
  VALVE_TYP7: null
  VALVE_LOCA: null
  STREET_NAME: null
  CROSS_STRE: null
  CROSS_STR2: null
  WORK_AREA: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  OBJECTID_2: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata