Name: Sanitary Maintenance

Display Field: ATLASID

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

N/A

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: Sanitary Maintenance
  Description:
  Prototype:
  JettedBy: null
  ProgramYear: null
  ATLASID: null
  DATE_: null
  INSPCTBY: null
  CLEANFLUSH: null
  INSPECTION: null
  REPAIRS: null
  MHFROM: null
  MHTO: null
  INSPCTID1: null
  INSPCTID2: null
  INSPCTID3: null
  INSPCTID4: null
  INSPCTID5: null
  INSPCTID6: null
  REPAIRID1: null
  REPAIRID2: null
  REPAIRID3: null
  REPAIRID4: null
  REPAIRID5: null
  REPAIRID6: null
  SNSWRNDEID: null
  SNSWRPIPID: null
  DEGREASED: null
  ROOTFOAMED: null
  JettingDate: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• VOL Sanitary Mainlines (0) -- Related To: Lisle Sanitary Mainlines (0)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

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