View In:   ArcGIS Online Map Viewer

Name: CorpGIS.SDE.Sewer_Manholes

Display Field: Corridor_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 249205c74d144fd0aadcc448029bfdd3

Copyright Text:

Default Visibility: true

MaxRecordCount: 9000

Supported Query Formats: JSON, geoJSON, PBF

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: 638724.8912000004
YMin: 4754096.0789
XMax: 648140.7947000004
YMax: 4765686.548699999
Spatial Reference: 26917  (26917)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [78, 0, 156, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• Condition_index ( type: esriFieldTypeSingle, alias: Condition_index, editable: true, nullable: true, defaultValue: null, modelName: Condition_index )
• Replacement_cost ( type: esriFieldTypeDouble, alias: Replacement_cost, editable: true, nullable: true, defaultValue: null, modelName: Replacement_cost )
• Residual_life ( type: esriFieldTypeSingle, alias: Residual_life, editable: true, nullable: true, defaultValue: null, modelName: Residual_life )
• Useful_life ( type: esriFieldTypeSingle, alias: Useful_life, editable: true, nullable: true, defaultValue: null, modelName: Useful_life )
• Station ( type: esriFieldTypeSingle, alias: Station, editable: true, nullable: true, defaultValue: null, modelName: Station )
• Quantity ( type: esriFieldTypeDouble, alias: Quantity, editable: true, nullable: true, defaultValue: null, modelName: Quantity )
• Weir_elevation ( type: esriFieldTypeSingle, alias: Weir_elevation, editable: true, nullable: true, defaultValue: null, modelName: Weir_elevation )
• Sub_surface_depth ( type: esriFieldTypeSingle, alias: Sub_surface_depth, editable: true, nullable: true, defaultValue: null, modelName: Sub_surface_depth )
• Surface_elevation ( type: esriFieldTypeSingle, alias: Surface_elevation, editable: true, nullable: true, defaultValue: null, modelName: Surface_elevation )
• Assembly_id ( type: esriFieldTypeInteger, alias: Assembly_id, editable: true, nullable: true, defaultValue: null, modelName: Assembly_id )
• Asset_description ( type: esriFieldTypeString, alias: Asset_description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Asset_description )
• Asset_historical_id ( type: esriFieldTypeString, alias: Asset_historical_id, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Asset_historical_id )
• Asset_id ( type: esriFieldTypeOID, alias: Asset_id, editable: false, nullable: false, defaultValue: null, modelName: Asset_id )
• Asset_parent_id ( type: esriFieldTypeString, alias: Asset_parent_id, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Asset_parent_id )
• Asset_symbol ( type: esriFieldTypeString, alias: Asset_symbol, editable: true, nullable: true, length: 2, defaultValue: MH, modelName: Asset_symbol )
• Asset_user_id ( type: esriFieldTypeString, alias: Asset_user_id, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Asset_user_id )
• Component ( type: esriFieldTypeString, alias: Component, editable: true, nullable: true, length: 30, defaultValue: Manhole, modelName: Component , Coded Values: [Catchbasin_mh_single_inlet: Catchbasin_mh_single_inlet] , [Catchbasin_mh_twin_inlet: Catchbasin_mh_twin_inlet] , [Chamber: Chamber] , ...6 more... )
• Sub_component ( type: esriFieldTypeString, alias: Sub_component, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Sub_component )
• Facility ( type: esriFieldTypeString, alias: Facility, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Facility , Coded Values: [Conduit: Conduit] , [Main_junction: Main_junction] , [Service_junction: Service_junction] , ...1 more... )
• Service ( type: esriFieldTypeString, alias: Service, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Service , Coded Values: [Sewerage: Sewerage] , [Urban_drainage: Urban_drainage] )
• Sub_system ( type: esriFieldTypeString, alias: Sub_system, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Sub_system , Coded Values: [Collection: Collection] , [Trunk: Trunk] )
• System ( type: esriFieldTypeString, alias: System, editable: true, nullable: true, length: 25, defaultValue: null, modelName: System , Coded Values: [Sanitary_system: Sanitary_system] , [Storm_system: Storm_system] , [Combined_system: Combined_system] , ...1 more... )
• Ownership ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Ownership , Coded Values: [CoW: City of Welland] , [RMN: Niagara Region] , [MTO: MTO] , ...6 more... )
• Service_area ( type: esriFieldTypeString, alias: Service_area, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Service_area )
• Condition_grade ( type: esriFieldTypeString, alias: Condition_grade, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Condition_grade )
• Criticality_category ( type: esriFieldTypeSmallInteger, alias: Criticality_category, editable: true, nullable: true, defaultValue: null, modelName: Criticality_category )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Material )
• Physical_shape ( type: esriFieldTypeString, alias: Physical_shape, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Physical_shape )
• Acquisition_method ( type: esriFieldTypeString, alias: Acquisition_method, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Acquisition_method )
• Cost_basis ( type: esriFieldTypeString, alias: Cost_basis, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Cost_basis )
• Cost_multiplier ( type: esriFieldTypeSmallInteger, alias: Cost_multiplier, editable: true, nullable: true, defaultValue: null, modelName: Cost_multiplier )
• Date_assumption ( type: esriFieldTypeDate, alias: Date_assumption, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_assumption )
• Date_commissioned ( type: esriFieldTypeDate, alias: Date_commissioned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_commissioned )
• Date_condition_grade ( type: esriFieldTypeDate, alias: Date_condition_grade, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_condition_grade )
• Date_cost_estimate ( type: esriFieldTypeDate, alias: Date_cost_estimate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_cost_estimate )
• Date_decommissioned ( type: esriFieldTypeDate, alias: Date_decommissioned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_decommissioned )
• Date_effective ( type: esriFieldTypeDate, alias: Date_effective, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_effective )
• Date_scheduled ( type: esriFieldTypeDate, alias: Date_scheduled, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_scheduled )
• Program_description ( type: esriFieldTypeString, alias: Program_description, editable: true, nullable: true, length: 64, defaultValue: null, modelName: Program_description )
• Program_priority ( type: esriFieldTypeSmallInteger, alias: Program_priority, editable: true, nullable: true, defaultValue: null, modelName: Program_priority )
• Program_timing ( type: esriFieldTypeString, alias: Program_timing, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Program_timing )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Status , Coded Values: [I: In Service] , [R: Removed] , [N: Not in Service] , ...9 more... )
• Corridor_name ( type: esriFieldTypeString, alias: Corridor_name, editable: true, nullable: true, length: 64, defaultValue: null, modelName: Corridor_name )
• Segment_id ( type: esriFieldTypeInteger, alias: Segment_id, editable: true, nullable: true, defaultValue: null, modelName: Segment_id )
• Station_description ( type: esriFieldTypeString, alias: Station_description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Station_description )
• Circa ( type: esriFieldTypeString, alias: Circa, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Circa )
• Comment ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 64, defaultValue: null, modelName: Comment )
• Data_confidence ( type: esriFieldTypeSmallInteger, alias: Data_confidence, editable: true, nullable: true, defaultValue: null, modelName: Data_confidence )
• Metrics_confidence ( type: esriFieldTypeSmallInteger, alias: Metrics_confidence, editable: true, nullable: true, defaultValue: null, modelName: Metrics_confidence )
• Old_record_id ( type: esriFieldTypeInteger, alias: Old_record_id, editable: true, nullable: true, defaultValue: null, modelName: Old_record_id )
• Unit_measure ( type: esriFieldTypeString, alias: Unit_measure, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Unit_measure , Coded Values: [metre: Metre] , [each: Each] , [sq-metres: Square metres] )
• Service_level ( type: esriFieldTypeInteger, alias: Service_level, editable: true, nullable: true, defaultValue: null, modelName: Service_level )
• Nominal_span ( type: esriFieldTypeSmallInteger, alias: Nominal_span, editable: true, nullable: true, defaultValue: null, modelName: Nominal_span )
• Nominal_width ( type: esriFieldTypeSmallInteger, alias: Nominal_width, editable: true, nullable: true, defaultValue: null, modelName: Nominal_width )
• Anti_tamper_device ( type: esriFieldTypeString, alias: Anti_tamper_device, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Anti_tamper_device )
• Weir ( type: esriFieldTypeString, alias: Weir, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Weir )
• Filll_method ( type: esriFieldTypeString, alias: Filll_method, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Filll_method )
• Surface_elevation_source ( type: esriFieldTypeString, alias: Surface_elevation_source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Surface_elevation_source )
• No_main_connections ( type: esriFieldTypeInteger, alias: No_main_connections, editable: true, nullable: true, defaultValue: null, modelName: No_main_connections )
• Map_id ( type: esriFieldTypeString, alias: Map_id, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Map_id )
• Checked ( type: esriFieldTypeInteger, alias: Checked, editable: true, nullable: true, defaultValue: null, modelName: Checked )
• Invert_backfall ( type: esriFieldTypeString, alias: Invert_backfall, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Invert_backfall )
• 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 )

Templates:

• Name: CorpGIS.SDE.Sewer_Manholes
  Description:
  Prototype:
  last_edited_user: null
  Condition_index: null
  Replacement_cost: null
  Residual_life: null
  Useful_life: null
  Station: null
  Quantity: null
  Weir_elevation: null
  Sub_surface_depth: null
  Surface_elevation: null
  Assembly_id: null
  Asset_description: null
  Asset_historical_id: null
  last_edited_date: null
  Asset_parent_id: null
  Asset_symbol: MH
  Asset_user_id: null
  Component: Manhole
  Sub_component: null
  Facility: null
  Service: null
  Sub_system: null
  System: null
  Ownership: null
  Service_area: null
  Condition_grade: null
  Criticality_category: null
  Material: null
  Physical_shape: null
  Acquisition_method: null
  Cost_basis: null
  Cost_multiplier: null
  Date_assumption: null
  Date_commissioned: null
  Date_condition_grade: null
  Date_cost_estimate: null
  Date_decommissioned: null
  Date_effective: null
  Date_scheduled: null
  Program_description: null
  Program_priority: null
  Program_timing: null
  Status: null
  Corridor_name: null
  Segment_id: null
  Station_description: null
  Circa: null
  Comment: null
  Data_confidence: null
  Metrics_confidence: null
  Old_record_id: null
  Unit_measure: null
  Service_level: null
  Nominal_span: null
  Nominal_width: null
  Anti_tamper_device: null
  Weir: null
  Filll_method: null
  Surface_elevation_source: null
  No_main_connections: null
  Map_id: null
  Checked: null
  Invert_backfall: null
  created_user: null
  created_date: 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   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata