View In:   ArcGIS Online Map Viewer

Name: GISDATA.DBO.wt_WaterMains

Display Field: OWNERSHIP

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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: 619301.6201999998
YMin: 4894042.410599999
XMax: 633455.3391000004
YMax: 4909672.2859000005
Spatial Reference: 26917  (26917)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 197, 255, 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 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 200, defaultValue: null, modelName: COMMENTS )
• 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 )
• 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 )
• ASSET_STATUS ( type: esriFieldTypeString, alias: ASSET_STATUS, editable: true, nullable: true, length: 18, defaultValue: null, modelName: ASSET_STATUS )
• FLOW_MEASUREMENT_ID ( type: esriFieldTypeString, alias: FLOW_MEASUREMENT_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FLOW_MEASUREMENT_ID )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: true, length: 33, defaultValue: null, modelName: MATERIAL )
• ASSET_ID ( type: esriFieldTypeString, alias: ASSET_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSET_ID )
• RECORDED_LENGTH ( type: esriFieldTypeDouble, alias: RECORDED_LENGTH, editable: true, nullable: true, defaultValue: null, modelName: RECORDED_LENGTH )
• PROJECT_NUMBER ( type: esriFieldTypeString, alias: PROJECT_NUMBER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROJECT_NUMBER )
• REFERENCE_FILES ( type: esriFieldTypeString, alias: REFERENCE_FILES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REFERENCE_FILES )
• FROM_STATION ( type: esriFieldTypeDouble, alias: FROM_STATION, editable: true, nullable: true, defaultValue: null, modelName: FROM_STATION )
• TO_STATION ( type: esriFieldTypeDouble, alias: TO_STATION, editable: true, nullable: true, defaultValue: null, modelName: TO_STATION )
• SOIL_TYPE ( type: esriFieldTypeString, alias: SOIL_TYPE, editable: true, nullable: true, length: 16, defaultValue: null, modelName: SOIL_TYPE )
• SURF_TYPE ( type: esriFieldTypeString, alias: SURF_TYPE, editable: true, nullable: true, length: 14, defaultValue: null, modelName: SURF_TYPE )
• IN_MODEL ( type: esriFieldTypeString, alias: IN_MODEL, editable: true, nullable: true, length: 3, defaultValue: null, modelName: IN_MODEL )
• CONDITION_RATING ( type: esriFieldTypeString, alias: CONDITION_RATING, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION_RATING )
• LINING_TYPE ( type: esriFieldTypeString, alias: LINING_TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LINING_TYPE )
• PIPE_CLASS ( type: esriFieldTypeString, alias: PIPE_CLASS, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PIPE_CLASS )
• ROUGHNESS_CO ( type: esriFieldTypeDouble, alias: ROUGHNESS_CO, editable: true, nullable: true, defaultValue: null, modelName: ROUGHNESS_CO )
• PIPE_SHAPE ( type: esriFieldTypeString, alias: PIPE_SHAPE, editable: true, nullable: true, length: 13, defaultValue: null, modelName: PIPE_SHAPE )
• INITIAL_VALUE ( type: esriFieldTypeDouble, alias: INITIAL_VALUE, editable: true, nullable: true, defaultValue: null, modelName: INITIAL_VALUE )
• EXPECTED_LIFE ( type: esriFieldTypeDouble, alias: EXPECTED_LIFE, editable: true, nullable: true, defaultValue: null, modelName: EXPECTED_LIFE )
• MIN_DEPTH ( type: esriFieldTypeInteger, alias: MIN_DEPTH, editable: true, nullable: true, defaultValue: null, modelName: MIN_DEPTH )
• MAX_DEPTH ( type: esriFieldTypeInteger, alias: MAX_DEPTH, editable: true, nullable: true, defaultValue: null, modelName: MAX_DEPTH )
• PRESSURE_DISTRICT ( type: esriFieldTypeString, alias: PRESSURE_DISTRICT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PRESSURE_DISTRICT )
• MAIN_TYPE ( type: esriFieldTypeString, alias: MAIN_TYPE, editable: true, nullable: true, length: 16, defaultValue: null, modelName: MAIN_TYPE )
• BACKFILL_TYPE ( type: esriFieldTypeString, alias: BACKFILL_TYPE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: BACKFILL_TYPE )
• BEDDING_TYPE ( type: esriFieldTypeString, alias: BEDDING_TYPE, editable: true, nullable: true, length: 21, defaultValue: null, modelName: BEDDING_TYPE )
• INSULATION ( type: esriFieldTypeString, alias: INSULATION, editable: true, nullable: true, length: 3, defaultValue: null, modelName: INSULATION )
• TRACE_WIRE ( type: esriFieldTypeString, alias: TRACE_WIRE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: TRACE_WIRE )
• CHECK_VALVE ( type: esriFieldTypeString, alias: CHECK_VALVE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CHECK_VALVE )
• CEMENT_LINED ( type: esriFieldTypeString, alias: CEMENT_LINED, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CEMENT_LINED )
• CEMENT_LINED_DATE ( type: esriFieldTypeDate, alias: CEMENT_LINED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CEMENT_LINED_DATE )
• JOINT_TYPE_1 ( type: esriFieldTypeString, alias: JOINT_TYPE_1, editable: true, nullable: true, length: 10, defaultValue: null, modelName: JOINT_TYPE_1 )
• JOINT_TYPE_2 ( type: esriFieldTypeString, alias: JOINT_TYPE_2, editable: true, nullable: true, length: 10, defaultValue: null, modelName: JOINT_TYPE_2 )
• STRUCTURE_TYPE ( type: esriFieldTypeString, alias: STRUCTURE_TYPE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: STRUCTURE_TYPE )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DESCRIPTION )
• MAIN_DIAMETER ( type: esriFieldTypeInteger, alias: MAIN_DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: MAIN_DIAMETER )
• SYSTEM_NAME ( type: esriFieldTypeString, alias: SYSTEM_NAME, editable: true, nullable: true, length: 42, defaultValue: null, modelName: SYSTEM_NAME )
• FACILITY_NAME ( type: esriFieldTypeString, alias: FACILITY_NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FACILITY_NAME )
• IGNORE_FLIP ( type: esriFieldTypeSmallInteger, alias: IGNORE_FLIP, editable: true, nullable: true, defaultValue: null, modelName: IGNORE_FLIP )
• AGE ( type: esriFieldTypeDouble, alias: AGE, editable: true, nullable: true, defaultValue: null, modelName: AGE )
• LINING_DATE ( type: esriFieldTypeDate, alias: LINING_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LINING_DATE )
• PRE_SPLIT_EID ( type: esriFieldTypeString, alias: PRE_SPLIT_EID, editable: true, nullable: true, length: 40, defaultValue: null, modelName: PRE_SPLIT_EID )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, editable: true, nullable: true, length: 51, defaultValue: null, modelName: OWNERSHIP )
• PIPE_TYPE ( type: esriFieldTypeString, alias: PIPE_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PIPE_TYPE )
• DEPTHCOVER ( type: esriFieldTypeDouble, alias: DEPTHCOVER, editable: true, nullable: true, defaultValue: null, modelName: DEPTHCOVER )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET_NAME )
• AS_B_DWG_R ( type: esriFieldTypeString, alias: AS_B_DWG_R, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AS_B_DWG_R )
• US_PIPE_IN ( type: esriFieldTypeDouble, alias: US_PIPE_IN, editable: true, nullable: true, defaultValue: null, modelName: US_PIPE_IN )
• DS_PIPE_IN ( type: esriFieldTypeDouble, alias: DS_PIPE_IN, editable: true, nullable: true, defaultValue: null, modelName: DS_PIPE_IN )
• 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 )
• WM_GIS_ID ( type: esriFieldTypeInteger, alias: WM_GIS_ID, editable: true, nullable: true, defaultValue: null, modelName: WM_GIS_ID )
• MAIN_LENGTH ( type: esriFieldTypeDouble, alias: MAIN_LENGTH, editable: true, nullable: true, defaultValue: null, modelName: MAIN_LENGTH )

Templates:

• Name: GISDATA.DBO.wt_WaterMains
  Description:
  Prototype:
  WM_GIS_ID: null
  MAIN_LENGTH: null
  COMMENTS: null
  ENABLED: null
  CREATE_DATE: null
  CREATE_BY: null
  LAST_EDIT_DATE: null
  LAST_EDIT_BY: null
  DATACAPTURE_METHOD: null
  INSTALL_DATE: null
  ASSUMPTION_DATE: null
  COMMISSION_DATE: null
  ASSET_STATUS: null
  FLOW_MEASUREMENT_ID: null
  MATERIAL: null
  ASSET_ID: null
  RECORDED_LENGTH: null
  PROJECT_NUMBER: null
  REFERENCE_FILES: null
  FROM_STATION: null
  TO_STATION: null
  SOIL_TYPE: null
  SURF_TYPE: null
  IN_MODEL: null
  CONDITION_RATING: null
  LINING_TYPE: null
  PIPE_CLASS: null
  ROUGHNESS_CO: null
  PIPE_SHAPE: null
  INITIAL_VALUE: null
  EXPECTED_LIFE: null
  MIN_DEPTH: null
  MAX_DEPTH: null
  PRESSURE_DISTRICT: null
  MAIN_TYPE: null
  BACKFILL_TYPE: null
  BEDDING_TYPE: null
  INSULATION: null
  TRACE_WIRE: null
  CHECK_VALVE: null
  CEMENT_LINED: null
  CEMENT_LINED_DATE: null
  JOINT_TYPE_1: null
  JOINT_TYPE_2: null
  STRUCTURE_TYPE: null
  DESCRIPTION: null
  MAIN_DIAMETER: null
  SYSTEM_NAME: null
  FACILITY_NAME: null
  IGNORE_FLIP: null
  AGE: null
  LINING_DATE: null
  PRE_SPLIT_EID: null
  OWNERSHIP: null
  PIPE_TYPE: null
  DEPTHCOVER: null
  STREET_NAME: null
  AS_B_DWG_R: null
  US_PIPE_IN: null
  DS_PIPE_IN: null
  WORK_AREA: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  
  Drawing Tool: esriFeatureEditToolLine

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