Name: Water Service Tap Record

Display Field: OWNERSHIP

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 8a71d31558cb48f8b8d08ea4ef34c250

Copyright Text: City of Iowa City Water Division

Default Visibility: true

MaxRecordCount: 3000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2500.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2156544.465267971
YMin: 592772.6725094463
XMax: 2196864.2238412527
YMax: 623578.5820749699
Spatial Reference: 102676  (3418)  VCSWkid(105703)  LatestVCSWkid(6360)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: VALVE_DIAM
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: .
  Label: Corps 2" or Less
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 169, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 0
  Label: Corps 2" or Less
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 169, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 0.75
  Label: Corps 2" or Less
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 169, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 1
  Label: Corps 2" or Less
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 169, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 1.5
  Label: Corps 2" or Less
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 169, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 2
  Label: Corps 2" or Less
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 169, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 1.25
  Label: Corps 2" or Less
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 169, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: <Null>
  Label: Corps 2" or Less
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 169, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 4
  Label: Tapping Valve
  Description: N/A
  Symbol:
  
• Value: 6
  Label: Tapping Valve
  Description: N/A
  Symbol:
  
• Value: 8
  Label: Tapping Valve
  Description: N/A
  Symbol:
  
• Value: 10
  Label: Tapping Valve
  Description: N/A
  Symbol:
  
• Value: 12
  Label: Tapping Valve
  Description: N/A
  Symbol:
  
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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CORP_ID ( type: esriFieldTypeInteger, alias: CORP_ID )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, length: 20 , Coded Values: [City: City] , [Other: Other] , [Private: Private] , ...8 more... )
• SERVICE_TYPE ( type: esriFieldTypeString, alias: SERVICE_TYPE, length: 20 , Coded Values: [FIRE: FIRE ONLY] , [DOM: DOMESTIC ONLY] , [IRR: IRRIGATION] , ...5 more... )
• VALVE_DIAM ( type: esriFieldTypeSingle, alias: VALVE_DIAM )
• VALVE_TYPE ( type: esriFieldTypeString, alias: VALVE_TYPE, length: 50 , Coded Values: [AUX: AUXILIARY] , [AR: AIR RELEASE] , [BOV: BLOWOFF] , ...9 more... )
• MEAS_1 ( type: esriFieldTypeString, alias: MEAS_1, length: 50 )
• MEAS_2 ( type: esriFieldTypeString, alias: MEAS_2, length: 50 )
• MEAS_3 ( type: esriFieldTypeString, alias: MEAS_3, length: 50 )
• MEAS_4 ( type: esriFieldTypeString, alias: MEAS_4, length: 50 )
• NOTES ( type: esriFieldTypeString, alias: NOTES, length: 256 )
• HYPERLINK ( type: esriFieldTypeString, alias: HYPERLINK, length: 256 )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, length: 50 , Coded Values: [AMERICAN FLOW: AMERICAN FLOW] , [CLOW: CLOW] , [HYDRO-STOP: HYDRO-STOP] , ...13 more... )
• VALVE_MODEL ( type: esriFieldTypeString, alias: VALVE_MODEL, length: 50 , Coded Values: [USPO-23: USPO-23] , [A-2360: A-2360] , [A-2362: A-2362] , ...16 more... )
• YEAR_MAN ( type: esriFieldTypeSmallInteger, alias: YEAR_MAN )
• BOX_SIZE ( type: esriFieldTypeString, alias: BOX_SIZE, length: 10 , Coded Values: [SMALL: SMALL] , [LARGE: LARGE] , [BUFFALO: BUFFALO] , ...4 more... )
• CONNECT_TYPE ( type: esriFieldTypeString, alias: CONNECT_TYPE, length: 20 , Coded Values: [DIRECT TAP: DIRECT TAP] , [SADDLE: SADDLE] , [TAPPING SLEEVE: TAPPING SLEEVE] , ...1 more... )
• CONNECT_MAN ( type: esriFieldTypeString, alias: CONNECT_MAN, length: 50 , Coded Values: [AYMcDonald: AY McDonald] , [AFC: American Flow Control] , [Kennedy: Kennedy] , ...8 more... )
• DATE_INST ( type: esriFieldTypeDate, alias: DATE_INST, length: 8 )
• EXCAVATOR ( type: esriFieldTypeString, alias: EXCAVATOR, length: 256 , Coded Values: [BOCKENSTEDT EXCAVATING: BOCKENSTEDT EXCAVATING] , [CALACCI CONSTRUCTION: CALACCI CONSTRUCTION] , [CARTER & ASSOCIATES: CARTER & ASSOCIATES] , ...47 more... )
• MAIN_DIAM ( type: esriFieldTypeSmallInteger, alias: MAIN_DIAM )
• PIPE_MAT ( type: esriFieldTypeString, alias: PIPE_MAT, length: 50 , Coded Values: [CAST: CAST] , [CEMENT: CEMENT] , [COPPER: COPPER] , ...11 more... )
• MAIN_DEPTH ( type: esriFieldTypeSingle, alias: MAIN_DEPTH )
• STBX_ID ( type: esriFieldTypeInteger, alias: STBX_ID )
• VALVE_ID ( type: esriFieldTypeString, alias: VALVE_ID, length: 50 )
• MAP_NUM ( type: esriFieldTypeString, alias: MAP_NUM, length: 20 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• ADDRESS ( type: esriFieldTypeString, alias: Address, length: 100 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• ACCNT_NUM ( type: esriFieldTypeDouble, alias: ACCNT_NUM )

Relationships:

• SDE.wServiceAccount (3) -- Related To: Water Service Account and Address (32)
• SDE.wServiceValve (2) -- Related To: Water Service Valve (13)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata