View In:   ArcGIS Online Map Viewer

Parent Layer: Sanitary Sewer Maintenance

Name: ss Manhole Inspections

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: d116d13c1268453489aad59fa6e334c5

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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: 5653943.443481475
YMin: 3623356.0841064453
XMax: 5690260.316284195
YMax: 3675098.246093765
Spatial Reference: 102675  (3417)

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 )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 50, defaultValue: SAN S, modelName: FACILITYID )
• INSDATE ( type: esriFieldTypeDate, alias: Date of Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSSTART )
• DISCOVERED ( type: esriFieldTypeString, alias: Manhole Found, editable: true, nullable: true, length: 30, defaultValue: null, modelName: DISCOVERED , Coded Values: [Above: Above Grade] , [At: At Grade] , [Lower: Lower than Grade (Susceptible to Ponding)] , ...3 more... )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LOCATION , Coded Values: [Roadway: Roadway] , [Gutter: Gutter] , [Parkway: Parkway] , ...3 more... )
• MHTYPE ( type: esriFieldTypeString, alias: Manhole Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MHTYPE , Coded Values: [Access: Access] , [Inside Drop: Inside Drop] , [PTO: PTO] , ...6 more... )
• ACCESSIBILITY ( type: esriFieldTypeString, alias: Access Difficulty, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ACCESSIBILITY , Coded Values: [None: None] , [Low: Low] , [Moderate: Moderate] , ...1 more... )
• VISUALPIPEFLOW ( type: esriFieldTypeString, alias: Visual Pipe Flow Level, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VISUALPIPEFLOW , Coded Values: [Not Measured: Not Measured] , [0-25%: 0-25%] , [25-50%: 25-50%] , ...2 more... )
• OVERFLOWEVIDENCE ( type: esriFieldTypeString, alias: Evidence of Past Overflow, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OVERFLOWEVIDENCE , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• DEPTHTOFLOW ( type: esriFieldTypeDouble, alias: Depth to Flow (from Rim), editable: true, nullable: true, defaultValue: null, modelName: DEPTHTOFLOW )
• FRAMECOND ( type: esriFieldTypeString, alias: Frame Condition, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FRAMECOND , Coded Values: [Replace: Replace] , [Repair: Repair] , [Other: Other] , ...3 more... )
• FRAMENOTE ( type: esriFieldTypeString, alias: Frame Note, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: FRAMENOTE )
• CFDIAMETER ( type: esriFieldTypeString, alias: Cover/Frame Diameter, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CFDIAMETER , Coded Values: [24: 24 in.] , [Other: Other] , [26: 26 in.] , ...1 more... )
• COVERTYPE ( type: esriFieldTypeString, alias: Cover Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: COVERTYPE , Coded Values: [Other: Other] , [Unknown: Unknown] , [OpenBolt: Open Pickhole - Bolted] , ...5 more... )
• COVERNOTE ( type: esriFieldTypeString, alias: Cover Note, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: COVERNOTE )
• COVERGASKETCOND ( type: esriFieldTypeString, alias: Cover Gasket Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COVERGASKETCOND , Coded Values: [Replace: Replace] , [Repair: Repair] , [Other: Other] , ...3 more... )
• COVERGASKETNOTE ( type: esriFieldTypeString, alias: Cover Gasket Note, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: COVERGASKETNOTE )
• CHIMNEYSEAL ( type: esriFieldTypeString, alias: Chimney Seal Location, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CHIMNEYSEAL , Coded Values: [Internal: Internal] , [External: External] , [None: None (No Chimney Seal)] )
• VFACECHIMSEAL ( type: esriFieldTypeString, alias: Vertical Face for Chimney Seal?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VFACECHIMSEAL , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• CHIMNEYSEALCOND ( type: esriFieldTypeString, alias: Chimney Seal Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CHIMNEYSEALCOND , Coded Values: [Replace: Replace] , [Repair: Repair] , [Other: Other] , ...3 more... )
• CHIMNEYSEALNOTE ( type: esriFieldTypeString, alias: Chimney Seal Note, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: CHIMNEYSEALNOTE )
• ADJRINGYN ( type: esriFieldTypeString, alias: Adjusting Ring(s) Present?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ADJRINGYN , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• ADJRINGCOND ( type: esriFieldTypeString, alias: Adjusting Ring Condition, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ADJRINGCOND , Coded Values: [Replace: Replace] , [Repair: Repair] , [Other: Other] , ...3 more... )
• ADJRINGDIAMETER ( type: esriFieldTypeString, alias: Adjusting Ring Diameter, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ADJRINGDIAMETER , Coded Values: [24: 24 in.] , [Other: Other] , [26: 26 in.] , ...1 more... )
• ADJRINGNOTE ( type: esriFieldTypeString, alias: Adjusting Ring(s) Note, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: ADJRINGNOTE )
• CONDRUNG ( type: esriFieldTypeString, alias: Rung/Step Condition, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CONDRUNG , Coded Values: [Replace: Replace] , [Repair: Repair] , [Other: Other] , ...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... )
• CONEDIAMETER ( type: esriFieldTypeString, alias: Cone Diameter, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONEDIAMETER , Coded Values: [24: 24 in.] , [Other: Other] , [26: 26 in.] , ...1 more... )
• CONECOND ( type: esriFieldTypeString, alias: Cone Condition, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CONECOND , Coded Values: [Replace: Replace] , [Repair: Repair] , [Other: Other] , ...3 more... )
• CONENOTE ( type: esriFieldTypeString, alias: Cone Note, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: CONENOTE )
• 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... )
• BARRELCOND ( type: esriFieldTypeString, alias: Barrel Condition, editable: true, nullable: true, length: 15, defaultValue: null, modelName: BARRELCOND , Coded Values: [Replace: Replace] , [Repair: Repair] , [Other: Other] , ...3 more... )
• BARRELLNOTE ( type: esriFieldTypeString, alias: Barrell Note, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: BARRELLNOTE )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector1, editable: true, nullable: true, length: 100, defaultValue: null, modelName: INSPECTOR , Coded Values: [Adam Decker: Adam Decker] , [Anita Gonyier: Anita Gonyier] , [Anna Van Otterloo: Anna Van Otterloo] , ...49 more... )
• INSPECTOR2 ( type: esriFieldTypeString, alias: Inspector2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: INSPECTOR2 , Coded Values: [Adam Decker: Adam Decker] , [Anita Gonyier: Anita Gonyier] , [Anna Van Otterloo: Anna Van Otterloo] , ...49 more... )
• SURCHARGEEVIDENCE ( type: esriFieldTypeString, alias: Evidence of Past Surcharge, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SURCHARGEEVIDENCE , Coded Values: [None: None] , [Minor: Minor] , [Moderate: Moderate] , ...1 more... )
• INFILTRAT ( type: esriFieldTypeString, alias: Infiltration, editable: true, nullable: true, length: 15, defaultValue: null, modelName: INFILTRAT , Coded Values: [None: None] , [Minor: Minor] , [Moderate: Moderate] , ...1 more... )
• INFILTRATLOC ( type: esriFieldTypeString, alias: Infiltration Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INFILTRATLOC , Coded Values: [No Infiltration: No Infiltration] , [Lid/Cover: Lid/Cover] , [Cone: Cone] , ...5 more... )
• ROOTS ( type: esriFieldTypeString, alias: Roots, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ROOTS , Coded Values: [None: None] , [Minor: Minor] , [Moderate: Moderate] , ...1 more... )
• ROOTSLOC ( type: esriFieldTypeString, alias: Roots Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ROOTSLOC , Coded Values: [No Infiltration: No Infiltration] , [Lid/Cover: Lid/Cover] , [Cone: Cone] , ...5 more... )
• CLEAN ( type: esriFieldTypeString, alias: Needs Cleaning?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CLEAN , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: NOTES )
• CONDITION ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONDITION , Coded Values: [Replace: Replace] , [Repair: Repair] , [Other: Other] , ...3 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 15, defaultValue: null, modelName: STATUS , Coded Values: [Abandoned: Abandoned in Place] , [Active: Active] , [Inactive: Inactive] , ...4 more... )
• FOGPresent ( type: esriFieldTypeString, alias: F.O.G. Present?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FOGPresent , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• FOGNote ( type: esriFieldTypeString, alias: F.O.G. Note, editable: true, nullable: true, length: 200, defaultValue: null, modelName: FOGNote )
• IssueResolved ( type: esriFieldTypeString, alias: Issue(s) Resolved, editable: true, nullable: true, length: 10, defaultValue: null, modelName: IssueResolved , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• IssueResolvedDate ( type: esriFieldTypeDate, alias: Issue Resolved Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: IssueResolvedDate )
• IssueResolvedNote ( type: esriFieldTypeString, alias: Issue Resolved Note, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: IssueResolvedNote )
• VideoInspection ( type: esriFieldTypeString, alias: 360 Video Inspection, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VideoInspection , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 more... )
• StrucQR ( type: esriFieldTypeString, alias: Structural Quick Rating, editable: true, nullable: true, length: 10, defaultValue: null, modelName: StrucQR )
• OMQR ( type: esriFieldTypeString, alias: O&M Quick Rating, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OMQR )
• OverallQR ( type: esriFieldTypeString, alias: Overall Quick Rating, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OverallQR )
• StrucIndex ( type: esriFieldTypeDouble, alias: Structural Rating Index, editable: true, nullable: true, defaultValue: null, modelName: StrucIndex )
• OMIndex ( type: esriFieldTypeDouble, alias: O&M Rating Index, editable: true, nullable: true, defaultValue: null, modelName: OMIndex )
• OverallIndex ( type: esriFieldTypeDouble, alias: Overall Rating Index, editable: true, nullable: true, defaultValue: null, modelName: OverallIndex )
• StrucRating ( type: esriFieldTypeDouble, alias: Structural Rating, editable: true, nullable: true, defaultValue: null, modelName: StrucRating )
• OMRating ( type: esriFieldTypeDouble, alias: O&M Rating, editable: true, nullable: true, defaultValue: null, modelName: OMRating )
• OverallRating ( type: esriFieldTypeDouble, alias: Overall Rating, editable: true, nullable: true, defaultValue: null, modelName: OverallRating )
• Hyperlink ( type: esriFieldTypeString, alias: 360 Video Hyperlink, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Hyperlink )
• LofFailure ( type: esriFieldTypeDouble, alias: Likelihood of Failure (LoF), editable: true, nullable: true, defaultValue: null, modelName: LofFailure )
• CofFailure ( type: esriFieldTypeDouble, alias: Consequence of Failure (CoF), editable: true, nullable: true, defaultValue: null, modelName: CofFailure )
• 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 )

Templates:

• Name: ss Manhole Inspections
  Description:
  Prototype:
  Hyperlink: null
  FACILITYID: SAN S
  INSDATE: null
  DISCOVERED: null
  LOCATION: null
  MHTYPE: null
  ACCESSIBILITY: null
  VISUALPIPEFLOW: null
  OVERFLOWEVIDENCE: null
  DEPTHTOFLOW: null
  FRAMECOND: null
  FRAMENOTE: null
  CFDIAMETER: null
  COVERTYPE: null
  COVERNOTE: null
  COVERGASKETCOND: null
  COVERGASKETNOTE: null
  CHIMNEYSEAL: null
  VFACECHIMSEAL: null
  CHIMNEYSEALCOND: null
  CHIMNEYSEALNOTE: null
  ADJRINGYN: null
  ADJRINGCOND: null
  ADJRINGDIAMETER: null
  ADJRINGNOTE: null
  CONDRUNG: null
  CONETYPE: null
  CONEDIAMETER: null
  CONECOND: null
  CONENOTE: null
  BARRELTYPE: null
  BARRELCOND: null
  BARRELLNOTE: null
  INSPECTOR: null
  INSPECTOR2: null
  SURCHARGEEVIDENCE: null
  INFILTRAT: null
  INFILTRATLOC: null
  ROOTS: null
  ROOTSLOC: null
  CLEAN: null
  NOTES: null
  CONDITION: null
  LofFailure: null
  CofFailure: null
  OverallRating: null
  STATUS: null
  FOGPresent: null
  FOGNote: null
  IssueResolved: null
  IssueResolvedDate: null
  IssueResolvedNote: null
  VideoInspection: null
  StrucQR: null
  OMQR: null
  OverallQR: null
  StrucIndex: null
  OMIndex: null
  OverallIndex: null
  StrucRating: null
  OMRating: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• ss Manhole (3) -- Related To: ss Manholes (6)

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: 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