Name: Sanitary Maintenance

Display Field: ATLASID

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• ATLASID ( type: esriFieldTypeString , alias: Atlas ID , length: 5 )
• DATE_ ( type: esriFieldTypeInteger , alias: Date )
• INSPCTBY ( type: esriFieldTypeString , alias: Inspected By , length: 30 )
• CLEANFLUSH ( type: esriFieldTypeString , alias: Clean Flush , length: 2 , Coded Values: [Y: Yes] , [N: No] )
• INSPECTION ( type: esriFieldTypeString , alias: Inspection , length: 2 , Coded Values: [Y: Yes] , [N: No] )
• REPAIRS ( type: esriFieldTypeString , alias: Repairs , length: 2 , Coded Values: [Y: Yes] , [N: No] )
• MHFROM ( type: esriFieldTypeString , alias: Manhole From , length: 5 )
• MHTO ( type: esriFieldTypeString , alias: Manhole To , length: 5 )
• INSPCTID1 ( type: esriFieldTypeSmallInteger , alias: Inspection 1 , Coded Values: [1: NO PROBLEMS] , [2: ROOTS] , [3: CRACKS] , ...17 more... )
• INSPCTID2 ( type: esriFieldTypeSmallInteger , alias: Inspection 2 , Coded Values: [1: NO PROBLEMS] , [2: ROOTS] , [3: CRACKS] , ...17 more... )
• INSPCTID3 ( type: esriFieldTypeSmallInteger , alias: Inspection 3 , Coded Values: [1: NO PROBLEMS] , [2: ROOTS] , [3: CRACKS] , ...17 more... )
• INSPCTID4 ( type: esriFieldTypeSmallInteger , alias: Inspection 4 , Coded Values: [1: NO PROBLEMS] , [2: ROOTS] , [3: CRACKS] , ...17 more... )
• INSPCTID5 ( type: esriFieldTypeSmallInteger , alias: Inspection 5 , Coded Values: [1: NO PROBLEMS] , [2: ROOTS] , [3: CRACKS] , ...17 more... )
• INSPCTID6 ( type: esriFieldTypeSmallInteger , alias: Inspection 6 , Coded Values: [1: NO PROBLEMS] , [2: ROOTS] , [3: CRACKS] , ...17 more... )
• REPAIRID1 ( type: esriFieldTypeSmallInteger , alias: Repair 1 , Coded Values: [1: REPLACE STEPS] , [2: REPLACE FRAME] , [3: REPLACE LID] , ...20 more... )
• REPAIRID2 ( type: esriFieldTypeSmallInteger , alias: Repair 2 , Coded Values: [1: REPLACE STEPS] , [2: REPLACE FRAME] , [3: REPLACE LID] , ...20 more... )
• REPAIRID3 ( type: esriFieldTypeSmallInteger , alias: Repair 3 , Coded Values: [1: REPLACE STEPS] , [2: REPLACE FRAME] , [3: REPLACE LID] , ...20 more... )
• REPAIRID4 ( type: esriFieldTypeSmallInteger , alias: Repair 4 , Coded Values: [1: REPLACE STEPS] , [2: REPLACE FRAME] , [3: REPLACE LID] , ...20 more... )
• REPAIRID5 ( type: esriFieldTypeSmallInteger , alias: Repair 5 , Coded Values: [1: REPLACE STEPS] , [2: REPLACE FRAME] , [3: REPLACE LID] , ...20 more... )
• REPAIRID6 ( type: esriFieldTypeSmallInteger , alias: Repair 6 , Coded Values: [1: REPLACE STEPS] , [2: REPLACE FRAME] , [3: REPLACE LID] , ...20 more... )
• SNSWRNDEID ( type: esriFieldTypeDouble , alias: Manhole ID )
• SNSWRPIPID ( type: esriFieldTypeDouble , alias: Mainline ID )
• DEGREASED ( type: esriFieldTypeString , alias: Degreased , length: 2 , Coded Values: [Y: Yes] , [N: No] )
• ROOTFOAMED ( type: esriFieldTypeString , alias: Rootfoamed , length: 2 , Coded Values: [Y: Yes] , [N: No] )
• Jetting_Date ( type: esriFieldTypeDate , alias: Jetting Date , length: 8 )
• created_user ( type: esriFieldTypeString , alias: created_user , length: 255 )
• created_date ( type: esriFieldTypeDate , alias: created_date , length: 8 )
• last_edited_user ( type: esriFieldTypeString , alias: last_edited_user , length: 255 )
• last_edited_date ( type: esriFieldTypeDate , alias: last_edited_date , length: 8 )
• JettedBy ( type: esriFieldTypeString , alias: Jetted By , length: 50 , Coded Values: [Lisle: Lisle] , [Contractor: Contractor] , [Other: Other] )
• ProgramYear ( type: esriFieldTypeDouble , alias: ProgramYear )

Relationships:

• VOL San Structures (0) -- Related To: Lisle Sanitary Manholes (5)
• VOL Sanitary Mainlines (4) -- Related To: Lisle Sanitary Mainlines (9)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata