View In:   ArcGIS Online Map Viewer

Name: GIS.DBO.ssManhole

Display Field: MANHOLE_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: -118767900
YMin: -94525500
XMax: 2841739.3970326334
YMax: 1675362.3918536454
Spatial Reference: 102654  (2232)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• MANHOLE_ID ( type: esriFieldTypeString, alias: Manhole ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• HIGH_ELEVATION ( type: esriFieldTypeDouble, alias: High Pipe Elevation, editable: true, nullable: true, defaultValue: null, modelName: HIGHELEV )
• INVERT ( type: esriFieldTypeDouble, alias: Invert, editable: true, nullable: true, defaultValue: null, modelName: INVERT )
• INVERT_ELEVATION ( type: esriFieldTypeDouble, alias: Invert Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVERTELEV )
• RIM_ELEVATION ( type: esriFieldTypeDouble, alias: Rim Elevation, editable: true, nullable: true, defaultValue: null, modelName: RIMELEV )
• CV_TYPE ( type: esriFieldTypeString, alias: Cover Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CVTYPE , Coded Values: [Standard W/ Lock: Standard W/ Lock] , [Standard W/ Ears: Standard W/ Ears] , [Non-District: Non-District] , ...17 more... )
• WALL_MATERIAL ( type: esriFieldTypeString, alias: Wall Material, editable: true, nullable: true, length: 25, defaultValue: null, modelName: WALLMAT , Coded Values: [PVC: Polyvinyl Chloride] , [RPM: Reinforced Plastic (Truss)] , [SDR35: SDR 35] , ...6 more... )
• MH_TYPE ( type: esriFieldTypeString, alias: Manhole Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MHTYPE , Coded Values: [STD: Standard] , [DRP: Drop] , [SPL: Split] , ...6 more... )
• CONDITION ( type: esriFieldTypeString, alias: Manhole Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• CUT_DEPTH ( type: esriFieldTypeDouble, alias: Pavement Cut Depth, editable: true, nullable: true, defaultValue: null, modelName: CUTDEPTH )
• FLOW_DIRECTION ( type: esriFieldTypeString, alias: Flow Direction, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FLOWDIR , Coded Values: [Upstream: Upstream] , [Downstream: Downstream] )
• LINED ( type: esriFieldTypeString, alias: Lined, editable: true, nullable: true, length: 3, defaultValue: null, modelName: LINED , Coded Values: [Yes: Yes] , [No: No] )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSDATE )
• WATER_TYPE ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WATERTYPE , Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...6 more... )
• LOCATION_DESCRIPTION ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC , Coded Values: [Backlot: Backlot] , [Backyard: Backyard] , [Other: Other] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: null, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVE_FLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: null, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNED_BY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: OWNEDBY , Coded Values: [-1: Private] , [-2: Other] , [1: TOS] )
• MAINTAINED_BY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: null, modelName: MAINTBY , Coded Values: [-1: Private] , [-2: Other] , [1: TOS] )
• SUM_FLOW ( type: esriFieldTypeDouble, alias: Flow Summary, editable: true, nullable: true, defaultValue: null, modelName: SUMFLOW )
• LAST_UPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LAST_EDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• DATA_SOURCE ( type: esriFieldTypeString, alias: Data Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DATASOURCE , Coded Values: [Aerial Imagery: Aerial Imagery] , [As-Builts/Construction Drawings: As-Builts/Construction Drawings] , [CAD: CAD] , ...4 more... )
• GPS_ACCURACY ( type: esriFieldTypeString, alias: GPS Accuracy, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GPSACCURACY )
• FIELD_NOTES ( type: esriFieldTypeString, alias: Field Notes, editable: true, nullable: true, length: 150, defaultValue: null, modelName: FIELDNOTES )
• CREATE_DATE ( type: esriFieldTypeDate, alias: Date Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATEDATE )
• CREATE_USER ( type: esriFieldTypeString, alias: Created By, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CREATEUSER )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ScheduleNumber ( type: esriFieldTypeSmallInteger, alias: ScheduleNumber, editable: true, nullable: true, defaultValue: null, modelName: ScheduleNumber )
• Interceptor ( type: esriFieldTypeString, alias: Interceptor, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Interceptor )
• Surveyor ( type: esriFieldTypeString, alias: Surveyor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Surveyor , Coded Values: [DRC: DRC] , [Snow Bridge: Snow Bridge] , [TOS Operator: TOS Operator] , ...1 more... )
• Urgent ( type: esriFieldTypeString, alias: Urgent, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Urgent , Coded Values: [Yes: Yes] , [No: No] )
• InspectionStatus ( type: esriFieldTypeString, alias: Inspection Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CleanStatus , Coded Values: [Inspected: Inspected] , [Not Inspected: Not Inspected] , [N/A: N/A] )

Templates:

• Name: GIS.DBO.ssManhole
  Description:
  Prototype:
  Urgent: null
  MANHOLE_ID: null
  INSTALL_DATE: null
  HIGH_ELEVATION: null
  INVERT: null
  INVERT_ELEVATION: null
  RIM_ELEVATION: null
  CV_TYPE: null
  WALL_MATERIAL: null
  MH_TYPE: null
  CONDITION: null
  CUT_DEPTH: null
  FLOW_DIRECTION: null
  LINED: null
  GPS_DATE: null
  WATER_TYPE: null
  LOCATION_DESCRIPTION: null
  ENABLED: null
  ACTIVE_FLAG: null
  OWNED_BY: null
  MAINTAINED_BY: null
  SUM_FLOW: null
  LAST_UPDATE: null
  LAST_EDITOR: null
  DATA_SOURCE: null
  GPS_ACCURACY: null
  FIELD_NOTES: null
  CREATE_DATE: null
  CREATE_USER: null
  InspectionStatus: null
  ScheduleNumber: null
  Interceptor: null
  Surveyor: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• ssManholeInspectionTable (0) -- Related To: GIS.DBO.ssManholeInspectionTable (5)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata