View In:   ArcGIS Online Map Viewer

Name: Sanitary Main

Display Field: enabled

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 73c9094000594fa6a7dc6bbb7054bd8f

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

Extent:

XMin: -8409971.0539
YMin: 4946534.369800001
XMax: -8395755.9515
YMax: 4958691.269500002
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: main_type
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Collector
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 1
• Value: 2
  Label: Interceptor
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [38, 115, 0, 255]
  Width: 2
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: true
Supports Query With LOD Spatial Reference: true
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: main_type

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: Object ID )
• enabled ( modelName: ENABLED, nullable: true, editable: true, defaultValue: 1, alias: Enabled, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• lifecycle_status ( modelName: LifecycleStatus, nullable: true, editable: true, defaultValue: null, alias: Lifecycle Status, type: esriFieldTypeInteger , Coded Values: [1: Active] , [2: Proposed] , [3: Abandoned] )
• install_date ( modelName: INSTALL_DATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Install Date, type: esriFieldTypeDate )
• main_type ( modelName: MAIN_TYPE, nullable: true, editable: true, defaultValue: 1, alias: Main Type, type: esriFieldTypeSmallInteger , Coded Values: [1: Collector] , [2: Interceptor] )
• main_size ( modelName: MAIN_SIZE, nullable: true, editable: true, defaultValue: null, alias: Main Size, type: esriFieldTypeSmallInteger , Coded Values: [4: 4"] , [6: 6"] , [8: 8"] , ...18 more... )
• main_material ( modelName: MainMaterial2, nullable: true, editable: true, defaultValue: null, alias: Main Material, type: esriFieldTypeInteger , Coded Values: [0: N/A] , [1: Cast Iron Pipe] , [2: Ductile Iron Pipe] , ...8 more... )
• ownership ( modelName: OWNERSHIP, nullable: true, editable: true, defaultValue: null, alias: Ownership, type: esriFieldTypeInteger , Coded Values: [1: City of Allentown] , [2: City of Bethlehem] , [3: Coplay-Whitehall] , ...8 more... )
• upstream_mh ( modelName: UPSTREAM_MH, nullable: true, editable: true, defaultValue: null, length: 12, alias: Upstream Manhole, type: esriFieldTypeString )
• downstream_mh ( modelName: DOWNSTREAM_MH, nullable: true, editable: true, defaultValue: null, length: 12, alias: Downstream Manhole, type: esriFieldTypeString )
• upstream_invert ( modelName: UPSTREAM_INVERT, nullable: true, editable: true, defaultValue: null, alias: Upstream Invert, type: esriFieldTypeDouble )
• downstream_invert ( modelName: DOWNSTREAM_INVERT, nullable: true, editable: true, defaultValue: null, alias: Downstream Invert, type: esriFieldTypeDouble )
• slope ( modelName: SLOPE, nullable: true, editable: true, defaultValue: null, alias: Slope, type: esriFieldTypeDouble )
• trunk_section ( modelName: TRUNK_SECTION, nullable: true, editable: true, defaultValue: null, length: 6, alias: Trunk Section, type: esriFieldTypeString )
• lateral_asbuilt ( modelName: LATERAL_ASBUILT, nullable: true, editable: true, defaultValue: null, length: 12, alias: Lateral Asbuilt, type: esriFieldTypeString )
• construction_asbuilt ( modelName: CONSTRUCTION_ASBUILT, nullable: true, editable: true, defaultValue: null, length: 12, alias: Construction Asbuilt, type: esriFieldTypeString )
• digital_image ( modelName: DIGITAL_IMAGE, nullable: true, editable: true, defaultValue: "\\Water1\Software\Digital_Images\San_const\", length: 100, alias: Digital Image, type: esriFieldTypeString )
• in_casing ( modelName: IN_CASING, nullable: true, editable: true, defaultValue: null, alias: In Casing, type: esriFieldTypeSmallInteger , Coded Values: [1: Yes] , [0: No] )
• exterior_coated ( modelName: EXTERIOR_COATED, nullable: true, editable: true, defaultValue: null, alias: Exterior Coated, type: esriFieldTypeSmallInteger , Coded Values: [1: Yes] , [0: No] )
• lining_type ( modelName: LINING_TYPE, nullable: true, editable: true, defaultValue: null, length: 80, alias: Lining Type, type: esriFieldTypeString )
• pipeid ( modelName: PIPEID, nullable: true, editable: true, defaultValue: null, alias: Pipe ID, type: esriFieldTypeInteger )
• lucity_id ( modelName: LucityLinkID, nullable: true, editable: true, defaultValue: null, alias: Lucity Link ID, type: esriFieldTypeInteger )
• digital_video ( modelName: DIGITAL_VIDEO, nullable: true, editable: true, defaultValue: "\\WATER4\E-BUSINESS\PipeTech\Videos, length: 100, alias: Digital Video, type: esriFieldTypeString )
• notes ( modelName: NOTES, nullable: true, editable: true, defaultValue: null, length: 255, alias: Notes, type: esriFieldTypeString )
• createdby ( modelName: CREATEDBY, nullable: true, editable: true, defaultValue: null, length: 30, alias: Created by, type: esriFieldTypeString )
• createdon ( modelName: CREATEDON, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Created On, type: esriFieldTypeDate )
• modifiedby ( modelName: MODIFIEDBY, nullable: true, editable: true, defaultValue: null, length: 50, alias: Modified By, type: esriFieldTypeString )
• modifiedon ( modelName: MODIFIEDON, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Modified On, type: esriFieldTypeDate )
• infrastructure_id ( modelName: INFRASTRUCTURE_ID, nullable: true, editable: true, defaultValue: null, length: 5, alias: Infrastructure ID, type: esriFieldTypeString )
• infrastructure_type ( modelName: INFRASTRUCTURE_TYPE, nullable: true, editable: true, defaultValue: null, length: 2, alias: Infrastructure Type, type: esriFieldTypeString , Coded Values: [40: San Main Segment] , [41: San Manhole] , [42: San Fitting] , ...6 more... )
• infrastructure_class ( modelName: INFRASTRUCTURE_CLASS, nullable: true, editable: true, defaultValue: null, length: 1, alias: Infrastructure Class, type: esriFieldTypeString )
• concatenated_id ( modelName: CONCATENATED_ID, nullable: true, editable: true, defaultValue: null, length: 8, alias: Concatenated ID, type: esriFieldTypeString )
• lucity_length ( modelName: Lucity_Length, nullable: true, editable: true, defaultValue: null, alias: Lucity_Length, type: esriFieldTypeDouble )
• i ( modelName: i, nullable: true, editable: true, defaultValue: null, alias: i, type: esriFieldTypeSmallInteger )
• cityworks_id ( modelName: CITYWORKS_ID, nullable: true, editable: true, defaultValue: null, length: 15, alias: CITYWORKS_ID, type: esriFieldTypeString )
• district ( modelName: District, nullable: true, editable: true, defaultValue: null, length: 65, alias: District, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Types:

ID: 1
Name: Collector
Domains:
• main_material:
  Inherited
• exterior_coated:
  Inherited
• ownership:
  Inherited
• in_casing:
  Inherited
• lifecycle_status:
  Inherited
• infrastructure_type:
  Inherited
• enabled:
  Inherited
• main_size:
  Inherited
Templates:
• Name: Collector
  Description:
  Prototype:
  main_material: null
  notes: null
  main_type: 1
  infrastructure_type: null
  infrastructure_class: null
  enabled: 1
  main_size: 8
  digital_image: "\\Water1\Software\Digital_Images\San_const\"
  exterior_coated: 1
  downstream_invert: null
  pipeid: null
  createdby: null
  upstream_invert: null
  lifecycle_status: null
  downstream_mh: null
  install_date: null
  lucity_id: null
  cityworks_id: null
  digital_video: "\\WATER4\E-BUSINESS\PipeTech\Videos
  construction_asbuilt: null
  lucity_length: null
  upstream_mh: null
  i: null
  concatenated_id: null
  infrastructure_id: null
  slope: null
  createdon: null
  trunk_section: null
  modifiedon: null
  ownership: null
  district: null
  lining_type: null
  in_casing: 1
  lateral_asbuilt: null
  modifiedby: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Interceptor
Domains:
• main_material:
  Inherited
• exterior_coated:
  Inherited
• ownership:
  Inherited
• in_casing:
  Inherited
• lifecycle_status:
  Inherited
• infrastructure_type:
  Inherited
• enabled:
  Inherited
• main_size:
  Inherited
Templates:
• Name: Interceptor
  Description:
  Prototype:
  main_material: null
  notes: null
  main_type: 2
  infrastructure_type: null
  infrastructure_class: null
  enabled: 1
  main_size: 8
  digital_image: "\\Water1\Software\Digital_Images\San_const\"
  exterior_coated: 1
  downstream_invert: null
  pipeid: null
  createdby: null
  upstream_invert: null
  lifecycle_status: null
  downstream_mh: null
  install_date: null
  lucity_id: null
  cityworks_id: null
  digital_video: "\\WATER4\E-BUSINESS\PipeTech\Videos
  construction_asbuilt: null
  lucity_length: null
  upstream_mh: null
  i: null
  concatenated_id: null
  infrastructure_id: null
  slope: null
  createdon: null
  trunk_section: null
  modifiedon: null
  ownership: null
  district: null
  lining_type: null
  in_casing: 1
  lateral_asbuilt: null
  modifiedby: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata