View In:   ArcGIS Online map viewer

Name: engineering.gisadmin.IPS_TEST_WATER_LINE

Display Field: subtype_name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Includes the following subtypes: Flushing Station, Irrigation Service Line, Hydrant Lead, Main, Private Main, Sampling Station, Service Line- Added SUBTYPE_NAME field and populated it to match sub type.

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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: 485432.5106999893
YMin: 5439752.197724979
XMax: 503204.65339998994
YMax: 5451186.213024979
Spatial Reference: 26910  (26910)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: line_subtype
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [128, 0, 153, 255]
Width: 1
Default Label:
UniqueValueInfos:
• Value: 6
  Label: Flushing Station
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [130, 0, 121, 255]
  Width: 1
• Value: 2
  Label: Hydrant Lead
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 143, 168, 255]
  Width: 1
• Value: 5
  Label: Irrigation Service Line
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 89, 128, 255]
  Width: 1
• Value: 0
  Label: Main
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 133, 128, 255]
  Width: 1
• Value: 3
  Label: Private Main
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 61, 158, 255]
  Width: 1
• Value: 4
  Label: Sampling Station
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 93, 133, 255]
  Width: 1
• Value: 1
  Label: Service Line
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [61, 173, 0, 255]
  Width: 1
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: line_subtype

Fields:

• objectid ( type: esriFieldTypeOID, alias: objectid, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• line_subtype ( type: esriFieldTypeInteger, alias: Line_Subtype, editable: true, nullable: true, defaultValue: 0, modelName: Line_Subtype )
• status ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 16, defaultValue: INSERVICE, modelName: STATUS , Coded Values: [ABANDONED: Abandoned] , [FUTURE: Future] , [INSERVICE: In Service] , ...3 more... )
• diameter ( type: esriFieldTypeDouble, alias: DIAMETER, editable: true, nullable: true, defaultValue: 0, modelName: DIAMETER , Coded Values: [0: Unknown] , [20: 20MM] , [25: 25MM] , ...24 more... )
• material ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: false, length: 16, defaultValue: null, modelName: MATERIAL , Coded Values: [AC: (AC) Asbestos Concrete] , [BLUE: (BLUE) Blue Brute] , [CERTI: (CERTI) Certi-Lok PBC Pipe] , ...17 more... )
• install_year ( type: esriFieldTypeDate, alias: INSTALL_YEAR, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_YEAR )
• design_year ( type: esriFieldTypeDate, alias: DESIGN_YEAR, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DESIGN_YEAR )
• expire_date ( type: esriFieldTypeDate, alias: EXPIRE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EXPIRE_DATE )
• drawing ( type: esriFieldTypeString, alias: DRAWING, editable: true, nullable: true, length: 64, defaultValue: null, modelName: DRAWING )
• ownership ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 16, defaultValue: COR_ENG, modelName: Ownership , Coded Values: [CNR: CNR] , [COR_ENG: COR-Engineering] , [FEDERAL: Federal Government] , ...11 more... )
• maint_responsibility ( type: esriFieldTypeString, alias: Maint_Responsibility, editable: true, nullable: true, length: 16, defaultValue: COR_ENG, modelName: Mant_Responcibility , Coded Values: [CNR: CNR] , [COR_ENG: COR-Engineering] , [FEDERAL: Federal Government] , ...11 more... )
• const_type ( type: esriFieldTypeString, alias: Const_Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Const_Type , Coded Values: [CAP: Capital] , [DS: PW Demo Survey] , [MAINT: Maintenance] , ...6 more... )
• subdivision ( type: esriFieldTypeString, alias: SUBDIVISION, editable: true, nullable: true, length: 64, defaultValue: null, modelName: SUBDIVISION )
• asbuilt_yn ( type: esriFieldTypeString, alias: ASBUILT_YN, editable: true, nullable: false, length: 1, defaultValue: N, modelName: ASBUILT_YN , Coded Values: [Y: Yes] , [N: No] )
• datasource ( type: esriFieldTypeString, alias: DATASOURCE, editable: true, nullable: false, length: 20, defaultValue: UNKNOWN, modelName: DATASOURCE , Coded Values: [AIRPHOTO: Airphoto] , [ASSESSMENT: Assessment] , [CREW: Crew Pickup] , ...10 more... )
• quarter_section ( type: esriFieldTypeString, alias: QUARTER_SECTION, editable: true, nullable: true, length: 6, defaultValue: null, modelName: QUARTER_SECTION )
• compkey ( type: esriFieldTypeInteger, alias: COMPKEY, editable: true, nullable: true, defaultValue: null, modelName: COMPKEY )
• comptype ( type: esriFieldTypeInteger, alias: COMPTYPE, editable: true, nullable: false, defaultValue: 41, modelName: COMPTYPE , Coded Values: [12: Hydrant (HY)] , [38: Water Backflow (WBF)] , [41: Water Main (WMN)] , ...10 more... )
• unitid ( type: esriFieldTypeString, alias: UNITID, editable: true, nullable: true, length: 16, defaultValue: null, modelName: UNITID )
• unitid2 ( type: esriFieldTypeString, alias: UNITID2, editable: true, nullable: true, length: 16, defaultValue: null, modelName: UNITID2 )
• maincomp1 ( type: esriFieldTypeInteger, alias: MAINCOMP1, editable: true, nullable: true, defaultValue: 43, modelName: MAINCOMP1 , Coded Values: [12: Hydrant (HY)] , [38: Water Backflow (WBF)] , [41: Water Main (WMN)] , ...10 more... )
• maincomp2 ( type: esriFieldTypeInteger, alias: MAINCOMP2, editable: true, nullable: true, defaultValue: 43, modelName: MAINCOMP2 , Coded Values: [12: Hydrant (HY)] , [38: Water Backflow (WBF)] , [41: Water Main (WMN)] , ...10 more... )
• parlineno ( type: esriFieldTypeString, alias: PARLINENO, editable: true, nullable: true, length: 1, defaultValue: 1, modelName: PARLINENO )
• cre_date ( type: esriFieldTypeDate, alias: CRE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CRE_DATE )
• cre_by ( type: esriFieldTypeString, alias: CRE_BY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CRE_BY )
• mod_date ( type: esriFieldTypeDate, alias: MOD_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MOD_DATE )
• mod_by ( type: esriFieldTypeString, alias: MOD_BY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MOD_BY )
• verified_yn ( type: esriFieldTypeString, alias: Verified_YN, editable: true, nullable: true, length: 1, defaultValue: N, modelName: Verified_YN , Coded Values: [Y: Yes] , [N: No] )
• location_status ( type: esriFieldTypeString, alias: Location_Status, editable: true, nullable: true, length: 10, defaultValue: UNKNOWN, modelName: Location_Status , Coded Values: [CNL: Can Not Locate] , [FOUND: Located] , [PEND: Location Pending] , ...1 more... )
• remarks ( type: esriFieldTypeString, alias: REMARKS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: REMARKS )
• subtype_name ( type: esriFieldTypeString, alias: SUBTYPE_NAME, editable: true, nullable: true, length: 50, defaultValue: MAIN, modelName: SUBTYPE_NAME )
• xcoord ( type: esriFieldTypeDouble, alias: Xcoord, editable: true, nullable: true, defaultValue: null, modelName: XCOORD )
• ycoord ( type: esriFieldTypeDouble, alias: Ycoord, editable: true, nullable: true, defaultValue: null, modelName: YCOORD )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• unittype ( type: esriFieldTypeString, alias: UNITTYPE, editable: true, nullable: true, length: 10, defaultValue: UNKNOWN, modelName: UNITTYPE , Coded Values: [HYDLEA: Hydrant Lead] , [UNKNOW: Unknown] , [WT-PRE: Water Main] , ...1 more... )
• addrkey ( type: esriFieldTypeInteger, alias: ADDRKEY, editable: true, nullable: true, defaultValue: null, modelName: ADDRKEY )
• addr_combo ( type: esriFieldTypeString, alias: ADDR_COMBO, editable: true, nullable: true, length: 88, defaultValue: null, modelName: ADDR_COMBO )
• dirty_status ( type: esriFieldTypeString, alias: DIRTY_STATUS, editable: true, nullable: true, length: 10, defaultValue: C, modelName: DIRTY_STATUS , Coded Values: [D: Dirty] , [C: Clean] )

Types:

ID: 6
Name: Flushing Station
Domains:
• status:
  Inherited
• diameter:
  Inherited
• material:
  Inherited
• ownership:
  Inherited
• maint_responsibility:
  Inherited
• const_type:
  Inherited
• asbuilt_yn:
  Inherited
• datasource:
  Inherited
• comptype:
  Inherited
• maincomp1:
  Inherited
• maincomp2:
  Inherited
• verified_yn:
  Inherited
• location_status:
  Inherited
• unittype:
  Coded Values: [DF: Drinking Fountain] , [FL: Fire Line] , [WFS: Flushing Station] , ...10 more...
• dirty_status:
  Inherited
Templates:
• Name: Flushing Station
  Description:
  Prototype:
  addr_combo: null
  addrkey: null
  line_subtype: 6
  status: INSERVICE
  diameter: 0
  material:
  install_year: null
  design_year: null
  expire_date: null
  drawing: null
  ownership: COR_ENG
  maint_responsibility: COR_ENG
  const_type: null
  subdivision: null
  asbuilt_yn: N
  datasource: UNKNOWN
  quarter_section: null
  compkey: null
  comptype: 45
  unitid: null
  unitid2: null
  maincomp1: 43
  maincomp2: 43
  parlineno: 1
  cre_date: null
  cre_by: null
  mod_date: null
  mod_by: null
  verified_yn: N
  location_status: UNKNOWN
  remarks: null
  subtype_name: FLUSHING STATION
  xcoord: null
  ycoord: null
  dirty_status: C
  unittype: WFS
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Hydrant Lead
Domains:
• status:
  Inherited
• diameter:
  Inherited
• material:
  Inherited
• ownership:
  Inherited
• maint_responsibility:
  Inherited
• const_type:
  Inherited
• asbuilt_yn:
  Inherited
• datasource:
  Inherited
• comptype:
  Inherited
• maincomp1:
  Inherited
• maincomp2:
  Inherited
• verified_yn:
  Inherited
• location_status:
  Inherited
• dirty_status:
  Inherited
Templates:
• Name: Hydrant Lead
  Description:
  Prototype:
  addr_combo: null
  addrkey: null
  line_subtype: 2
  status: INSERVICE
  diameter: 0
  material:
  install_year: null
  design_year: null
  expire_date: null
  drawing: null
  ownership: COR_ENG
  maint_responsibility: COR_ENG
  const_type: null
  subdivision: null
  asbuilt_yn: N
  datasource: UNKNOWN
  quarter_section: null
  compkey: null
  comptype: 41
  unitid: null
  unitid2: null
  maincomp1: 43
  maincomp2: 43
  parlineno: 1
  cre_date: null
  cre_by: null
  mod_date: null
  mod_by: null
  verified_yn: N
  location_status: UNKNOWN
  remarks: null
  subtype_name: HYDRANT LEAD
  xcoord: null
  ycoord: null
  dirty_status: C
  unittype: HYDLEA
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 5
Name: Irrigation Service Line
Domains:
• status:
  Inherited
• diameter:
  Inherited
• material:
  Inherited
• ownership:
  Inherited
• maint_responsibility:
  Inherited
• const_type:
  Inherited
• asbuilt_yn:
  Inherited
• datasource:
  Inherited
• comptype:
  Inherited
• maincomp1:
  Inherited
• maincomp2:
  Inherited
• verified_yn:
  Inherited
• location_status:
  Inherited
• unittype:
  Coded Values: [DF: Drinking Fountain] , [FL: Fire Line] , [WFS: Flushing Station] , ...10 more...
• dirty_status:
  Inherited
Templates:
• Name: Irrigation Service Line
  Description:
  Prototype:
  addr_combo: null
  addrkey: null
  line_subtype: 5
  status: INSERVICE
  diameter: 0
  material:
  install_year: null
  design_year: null
  expire_date: null
  drawing: null
  ownership: COR_ENG
  maint_responsibility: COR_ENG
  const_type: null
  subdivision: null
  asbuilt_yn: N
  datasource: UNKNOWN
  quarter_section: null
  compkey: null
  comptype: 45
  unitid: null
  unitid2: null
  maincomp1: 43
  maincomp2: 43
  parlineno: 1
  cre_date: null
  cre_by: null
  mod_date: null
  mod_by: null
  verified_yn: N
  location_status: UNKNOWN
  remarks: null
  subtype_name: IRRIGATION SERVICE LINE
  xcoord: null
  ycoord: null
  dirty_status: C
  unittype: IL
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 0
Name: Main
Domains:
• status:
  Inherited
• diameter:
  Inherited
• material:
  Inherited
• ownership:
  Inherited
• maint_responsibility:
  Inherited
• const_type:
  Inherited
• asbuilt_yn:
  Inherited
• datasource:
  Inherited
• comptype:
  Inherited
• maincomp1:
  Inherited
• maincomp2:
  Inherited
• verified_yn:
  Inherited
• location_status:
  Inherited
• unittype:
  Inherited
• dirty_status:
  Inherited
Templates:
• Name: Main
  Description:
  Prototype:
  addr_combo: null
  addrkey: null
  line_subtype: 0
  status: INSERVICE
  diameter: 0
  material:
  install_year: null
  design_year: null
  expire_date: null
  drawing: null
  ownership: COR_ENG
  maint_responsibility: COR_ENG
  const_type: null
  subdivision: null
  asbuilt_yn: N
  datasource: UNKNOWN
  quarter_section: null
  compkey: null
  comptype: 41
  unitid: null
  unitid2: null
  maincomp1: 43
  maincomp2: 43
  parlineno: 1
  cre_date: null
  cre_by: null
  mod_date: null
  mod_by: null
  verified_yn: N
  location_status: UNKNOWN
  remarks: null
  subtype_name: MAIN
  xcoord: null
  ycoord: null
  dirty_status: C
  unittype: WT-PRE
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: Private Main
Domains:
• status:
  Inherited
• diameter:
  Inherited
• material:
  Inherited
• ownership:
  Inherited
• maint_responsibility:
  Inherited
• const_type:
  Inherited
• asbuilt_yn:
  Inherited
• datasource:
  Inherited
• comptype:
  Inherited
• maincomp1:
  Inherited
• maincomp2:
  Inherited
• verified_yn:
  Inherited
• location_status:
  Inherited
• unittype:
  Inherited
• dirty_status:
  Inherited
Templates:
• Name: Private Main
  Description:
  Prototype:
  addr_combo: null
  addrkey: null
  line_subtype: 3
  status: INSERVICE
  diameter: 0
  material:
  install_year: null
  design_year: null
  expire_date: null
  drawing: null
  ownership: COR_ENG
  maint_responsibility: COR_ENG
  const_type: null
  subdivision: null
  asbuilt_yn: N
  datasource: UNKNOWN
  quarter_section: null
  compkey: null
  comptype: 41
  unitid: null
  unitid2: null
  maincomp1: 43
  maincomp2: 43
  parlineno: 1
  cre_date: null
  cre_by: null
  mod_date: null
  mod_by: null
  verified_yn: N
  location_status: UNKNOWN
  remarks: null
  subtype_name: PRIVATE MAIN
  xcoord: null
  ycoord: null
  dirty_status: C
  unittype: WT-PRE
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: Sampling Station
Domains:
• status:
  Inherited
• diameter:
  Inherited
• material:
  Inherited
• ownership:
  Inherited
• maint_responsibility:
  Inherited
• const_type:
  Inherited
• asbuilt_yn:
  Inherited
• datasource:
  Inherited
• comptype:
  Inherited
• maincomp1:
  Inherited
• maincomp2:
  Inherited
• verified_yn:
  Inherited
• location_status:
  Inherited
• unittype:
  Coded Values: [DF: Drinking Fountain] , [FL: Fire Line] , [WFS: Flushing Station] , ...10 more...
• dirty_status:
  Inherited
Templates:
• Name: Sampling Station
  Description:
  Prototype:
  addr_combo: null
  addrkey: null
  line_subtype: 4
  status: INSERVICE
  diameter: 0
  material:
  install_year: null
  design_year: null
  expire_date: null
  drawing: null
  ownership: COR_ENG
  maint_responsibility: COR_ENG
  const_type: null
  subdivision: null
  asbuilt_yn: N
  datasource: UNKNOWN
  quarter_section: null
  compkey: null
  comptype: 45
  unitid: null
  unitid2: null
  maincomp1: 43
  maincomp2: 43
  parlineno: 1
  cre_date: null
  cre_by: null
  mod_date: null
  mod_by: null
  verified_yn: N
  location_status: UNKNOWN
  remarks: null
  subtype_name: SAMPLING STATION
  xcoord: null
  ycoord: null
  dirty_status: C
  unittype: WSS
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: Service Line
Domains:
• status:
  Inherited
• diameter:
  Inherited
• material:
  Inherited
• ownership:
  Inherited
• maint_responsibility:
  Inherited
• const_type:
  Inherited
• asbuilt_yn:
  Inherited
• datasource:
  Inherited
• comptype:
  Inherited
• maincomp1:
  Inherited
• maincomp2:
  Inherited
• verified_yn:
  Inherited
• location_status:
  Inherited
• unittype:
  Coded Values: [DF: Drinking Fountain] , [DPSWC: Water CNCTN (ST PMP STN)] , [FL: Fire Line] , ...9 more...
• dirty_status:
  Inherited
Templates:
• Name: Service Line
  Description:
  Prototype:
  addr_combo: null
  addrkey: null
  line_subtype: 1
  status: INSERVICE
  diameter: 0
  material:
  install_year: null
  design_year: null
  expire_date: null
  drawing: null
  ownership: COR_ENG
  maint_responsibility: COR_ENG
  const_type: null
  subdivision: null
  asbuilt_yn: N
  datasource: UNKNOWN
  quarter_section: null
  compkey: null
  comptype: 45
  unitid: null
  unitid2: null
  maincomp1: 43
  maincomp2: 43
  parlineno: 1
  cre_date: null
  cre_by: null
  mod_date: null
  mod_by: null
  verified_yn: N
  location_status: UNKNOWN
  remarks: null
  subtype_name: SERVICE LINE
  xcoord: null
  ycoord: null
  dirty_status: C
  unittype: null
  
  Drawing Tool: esriFeatureEditToolLine

---

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

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   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata