View In:   ArcGIS Online Map Viewer

Name: sw Manhole Inspections

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 1b6ba19ea1b94a45b229b49b90e519de

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: 5654337.551889628
YMin: 3643775.0805736035
XMax: 5687611.274810135
YMax: 3673820.825826511
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:

• INSSTART ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSSTART )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACILITYID )
• 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... )
• 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... )
• 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... )
• CONDRUNG ( type: esriFieldTypeString, alias: Rung Condition, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CONDRUNG , Coded Values: [Replace: Replace] , [Repair: Repair] , [Other: Other] , ...3 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... )
• 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... )
• 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... )
• 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... )
• DISCOVERED ( type: esriFieldTypeString, alias: Manhole Found, editable: true, nullable: true, length: 30, defaultValue: null, modelName: DISCOVERED , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] , ...1 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... )
• 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... )
• SURCHARGE ( type: esriFieldTypeString, alias: Surcharge, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SURCHARGE , 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... )
• CONDITION ( type: esriFieldTypeString, alias: Overall Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONDITION , Coded Values: [Replace: Replace] , [Repair: Repair] , [Other: Other] , ...3 more... )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NOTES )
• INSEND ( type: esriFieldTypeDate, alias: End DateTime, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSEND )
• WORKKEY ( type: esriFieldTypeString, alias: Workorder ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WORKKEY )
• INSPECTID ( type: esriFieldTypeString, alias: Inspection ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTID )
• 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... )
• INSSTATUS ( type: esriFieldTypeString, alias: Inspection Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSSTATUS , Coded Values: [Unassigned: Unassigned] , [Assigned: Assigned] , [In Progress: In Progress] , ...1 more... )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• DEPTH ( type: esriFieldTypeDouble, alias: Depth (from Rim), editable: true, nullable: true, defaultValue: null, modelName: DEPTH )
• ACCESSIBILITY ( type: esriFieldTypeString, alias: Access Difficulty, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ACCESSIBILITY , Coded Values: [None: None] , [Low: Low] , [Moderate: Moderate] , ...1 more... )
• FRAMENOTE ( type: esriFieldTypeString, alias: Frame Note, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FRAMENOTE )
• ADJRINGNOTE ( type: esriFieldTypeString, alias: Adjusting Ring Note, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ADJRINGNOTE )
• CONENOTE ( type: esriFieldTypeString, alias: Cone Note, editable: true, nullable: true, length: 250, defaultValue: null, modelName: CONENOTE )
• COVERNOTE ( type: esriFieldTypeString, alias: Cover Note, editable: true, nullable: true, length: 250, defaultValue: null, modelName: COVERNOTE )
• BARRELLNOTE ( type: esriFieldTypeString, alias: Barrell Note, editable: true, nullable: true, length: 250, defaultValue: null, modelName: BARRELLNOTE )
• CFDIAMETER ( type: esriFieldTypeString, alias: Cover/Frame Diameter, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CFDIAMETER , Coded Values: [24: 24 in.] , [Other: Other] , [26: 26 in.] , ...1 more... )
• ADJRINGDIAMTER ( type: esriFieldTypeString, alias: Adjusting Ring Diameter, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADJRINGDIAMTER , Coded Values: [24: 24 in.] , [Other: Other] , [26: 26 in.] , ...1 more... )
• CONEDIAMETER ( type: esriFieldTypeString, alias: Cone Diameter, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONEDIAMETER , Coded Values: [24: 24 in.] , [Other: Other] , [26: 26 in.] , ...1 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 )
• INSPECTOR2 ( type: esriFieldTypeString, alias: Inspector 2, 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... )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• 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: 250, 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 )

Templates:

• Name: sw Manhole Inspections
  Description:
  Prototype:
  LofFailure: null
  INSSTART: null
  FACILITYID: null
  MHTYPE: null
  FRAMECOND: null
  ADJRINGCOND: null
  CONDRUNG: null
  COVERTYPE: null
  CONETYPE: null
  CONECOND: null
  BARRELTYPE: null
  BARRELCOND: null
  DISCOVERED: null
  LOCATION: null
  ROOTS: null
  SURCHARGE: null
  INFILTRAT: null
  CONDITION: null
  NOTES: null
  INSEND: null
  WORKKEY: null
  INSPECTID: null
  INSPECTOR: null
  INSSTATUS: null
  ROTATION: null
  LASTUPDATE: null
  LASTEDITOR: null
  CofFailure: null
  DEPTH: null
  ACCESSIBILITY: null
  FRAMENOTE: null
  ADJRINGNOTE: null
  CONENOTE: null
  COVERNOTE: null
  BARRELLNOTE: null
  CFDIAMETER: null
  ADJRINGDIAMTER: null
  CONEDIAMETER: null
  Hyperlink: null
  OverallRating: null
  OMRating: null
  StrucRating: null
  INSPECTOR2: null
  IssueResolved: null
  IssueResolvedDate: null
  IssueResolvedNote: null
  VideoInspection: null
  StrucQR: null
  OMQR: null
  OverallQR: null
  StrucIndex: null
  OMIndex: null
  OverallIndex: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• swManhole (19) -- Related To: sw Manholes (18)

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