View In:   ArcGIS.com Map

Name: Sanitary Manhole Inspections

Display Field: INSPECTDATE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Each point represents the location of a sanitary sewer manhole and records visual assessment data about that particular manhole.</SPAN></P></DIV></DIV></DIV>

Copyright Text: New Haven Engineering NHGIS

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 503575.80829199404
YMin: 2116292.1387869865
XMax: 511514.9991064966
YMax: 2124288.879355155
Spatial Reference: 2244  (2965)

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

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 )
• INSPECTDATE ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSPECTDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCDESC )
• AREADESC ( type: esriFieldTypeString, alias: Area Description, editable: true, nullable: true, length: 30, defaultValue: null, modelName: AREADESC , Coded Values: [Alley: Alley] , [Athletic Court: Athletic Court] , [Athletic Field: Athletic Field] , ...16 more... )
• SURFACEMAT ( type: esriFieldTypeString, alias: Surface Material, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SURFACEMAT , Coded Values: [Grass: Grass] , [Mulch: Mulch] , [Gravel: Gravel] , ...12 more... )
• MHTYPE ( type: esriFieldTypeString, alias: Manhole Type, editable: true, nullable: true, length: 30, defaultValue: Standard, modelName: MHTYPE , Coded Values: [Diversion: Diversion] , [Drop: Drop] , [Sedimentation: Sedimentation] , ...4 more... )
• MHSIZE ( type: esriFieldTypeSmallInteger, alias: Manhole Size, editable: true, nullable: true, defaultValue: 48, modelName: MHSIZE , Coded Values: [48: 48"] , [60: 60"] , [72: 72"] , ...5 more... )
• RIMELEV ( type: esriFieldTypeDouble, alias: Rim Elevation (North Edge, Ft), editable: true, nullable: true, defaultValue: null, modelName: RIMELEV , Range: [400, 1000] )
• MHDEPTH ( type: esriFieldTypeDouble, alias: Manhole Depth (Ft), editable: true, nullable: true, defaultValue: null, modelName: MHDEPTH , Range: [0, 200] )
• PIPECOUNT ( type: esriFieldTypeSmallInteger, alias: Pipe Count, editable: true, nullable: true, defaultValue: null, modelName: PIPECOUNT , Range: [1, 20] )
• FRAMEDEG ( type: esriFieldTypeSmallInteger, alias: Frame Degradation, editable: true, nullable: true, defaultValue: null, modelName: FRAMEDEG , Coded Values: [1: None] , [2: Minor] , [3: Moderate] , ...3 more... )
• ADJRINGDEG ( type: esriFieldTypeSmallInteger, alias: Adjusting Ring Degradation, editable: true, nullable: true, defaultValue: null, modelName: ADJRINGDEG , Coded Values: [1: None] , [2: Minor] , [3: Moderate] , ...3 more... )
• RUNGDEG ( type: esriFieldTypeSmallInteger, alias: Rung Degradation, editable: true, nullable: true, defaultValue: null, modelName: RUNGDEG , Coded Values: [1: None] , [2: Minor] , [3: Moderate] , ...3 more... )
• CONETYPE ( type: esriFieldTypeString, alias: Cone Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CONETYPE , Coded Values: [Brick: Brick] , [Concrete: Concrete] , [Lined: Lined] , ...3 more... )
• CONEDEG ( type: esriFieldTypeSmallInteger, alias: Cone Degradation, editable: true, nullable: true, defaultValue: null, modelName: CONEDEG , Coded Values: [1: None] , [2: Minor] , [3: Moderate] , ...3 more... )
• BARRELTYPE ( type: esriFieldTypeString, alias: Barrel Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: BARRELTYPE , Coded Values: [Brick: Brick] , [Concrete: Concrete] , [Lined: Lined] , ...3 more... )
• BARRELDEG ( type: esriFieldTypeSmallInteger, alias: Barrel Degradation, editable: true, nullable: true, defaultValue: null, modelName: BARRELDEG , Coded Values: [1: None] , [2: Minor] , [3: Moderate] , ...3 more... )
• ROOTS ( type: esriFieldTypeSmallInteger, alias: Roots, editable: true, nullable: true, defaultValue: null, modelName: ROOTS , Coded Values: [1: None] , [2: Minor] , [3: Moderate] , ...3 more... )
• SURCHARGE ( type: esriFieldTypeSmallInteger, alias: Surcharge, editable: true, nullable: true, defaultValue: null, modelName: SURCHARGE , Coded Values: [1: None] , [2: Minor] , [3: Moderate] , ...3 more... )
• INFILTRATE ( type: esriFieldTypeSmallInteger, alias: Infiltration, editable: true, nullable: true, defaultValue: null, modelName: INFILTRATE , Coded Values: [1: None] , [2: Minor] , [3: Moderate] , ...3 more... )
• MHCOND ( type: esriFieldTypeSmallInteger, alias: Manhole Condition, editable: true, nullable: true, defaultValue: null, modelName: MHCOND , Coded Values: [1: Excellent] , [2: Very Good] , [3: Good] , ...5 more... )
• MAINTREQ ( type: esriFieldTypeString, alias: Maintenance Required, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAINTREQ )
• DISCOVERED ( type: esriFieldTypeSmallInteger, alias: Newly Discovered, editable: true, nullable: true, defaultValue: 0, modelName: DISCOVERED , Coded Values: [0: False] , [1: True] )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• REPORTBY ( type: esriFieldTypeString, alias: Report By, editable: true, nullable: true, length: 30, defaultValue: null, modelName: REPORTBY , Coded Values: [Dave Jones: Dave Jones] , [Jeff Jacquay: Jeff Jacquay] , [Fritz Sirk: Fritz Sirk] , ...17 more... )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• MHGUID ( type: esriFieldTypeGUID, alias: Manhole GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: MHGUID )

Templates:

• Name: Sanitary Manhole Inspections
  Description:
  Prototype:
  MHGUID: null
  REPORTBY: null
  INSPECTDATE: null
  LOCDESC: null
  AREADESC: null
  SURFACEMAT: null
  MHTYPE: Standard
  MHSIZE: 48
  RIMELEV: null
  MHDEPTH: null
  PIPECOUNT: null
  FRAMEDEG: null
  ADJRINGDEG: null
  RUNGDEG: null
  CONETYPE: null
  CONEDEG: null
  BARRELTYPE: null
  BARRELDEG: null
  ROOTS: null
  SURCHARGE: null
  INFILTRATE: null
  MHCOND: null
  MAINTREQ: null
  DISCOVERED: 0
  COMMENTS: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

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

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

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