Name: Sewer.DBO.TV_Surveys

Display Field: Street_Name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• San_Pipe_ID ( type: esriFieldTypeInteger, alias: Sanitary Sewer Line Object ID )
• SMVCONTDTG_OID ( type: esriFieldTypeInteger, alias: Storm Conduit Object ID )
• Sewer_Type ( type: esriFieldTypeString, alias: Sewer_Type, length: 10 , Coded Values: [Storm: Storm] , [Sanitary: Sanitary] )
• DVD_Number ( type: esriFieldTypeString, alias: DVD_Number, length: 10 )
• Survey_Number ( type: esriFieldTypeString, alias: Survey_Number, length: 6 )
• House ( type: esriFieldTypeString, alias: House, length: 10 )
• Street_Name ( type: esriFieldTypeString, alias: Street_Name, length: 30 )
• Street_Type ( type: esriFieldTypeString, alias: Street_Type, length: 10 )
• Quad ( type: esriFieldTypeString, alias: Quad, length: 5 )
• USMAN ( type: esriFieldTypeString, alias: USMAN, length: 20 )
• DSMAN ( type: esriFieldTypeString, alias: DSMAN, length: 20 )
• Survey_Date ( type: esriFieldTypeDate, alias: Survey_Date, length: 8 )
• DVD_Unit ( type: esriFieldTypeString, alias: DVD_Unit, length: 5 )
• Operator ( type: esriFieldTypeString, alias: Operator, length: 30 )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 250 )
• Roots ( type: esriFieldTypeString, alias: Roots, length: 10 , Coded Values: [Trace: Trace] , [Light: Light] , [Medium: Medium] , ...2 more... )
• Root_Location ( type: esriFieldTypeString, alias: Root_Location, length: 20 , Coded Values: [Joints: Joints] , [Services: Services] , [Joints and Services: Joints and Services] , ...3 more... )
• Affected_Svcs ( type: esriFieldTypeString, alias: Affected_Svcs, length: 5 )
• Debris ( type: esriFieldTypeString, alias: Debris, length: 10 , Coded Values: [Trace: Trace] , [Light: Light] , [Medium: Medium] , ...2 more... )
• Grease ( type: esriFieldTypeString, alias: Grease, length: 10 , Coded Values: [Trace: Trace] , [Light: Light] , [Medium: Medium] , ...2 more... )
• Minerals ( type: esriFieldTypeString, alias: Minerals, length: 10 , Coded Values: [Trace: Trace] , [Light: Light] , [Medium: Medium] , ...2 more... )
• Needs_Slip_Lined ( type: esriFieldTypeSmallInteger, alias: Needs_Slip_Lined , Coded Values: [0: False] , [1: True] )
• Damage_or_Defect ( type: esriFieldTypeSmallInteger, alias: Damage_or_Defect , Coded Values: [0: False] , [1: True] )
• Hyperlink ( type: esriFieldTypeString, alias: Hyperlink, length: 100 )
• Offset ( type: esriFieldTypeString, alias: Offset, length: 10 , Coded Values: [Minor: Minor] , [Moderate: Moderate] , [Major: Major] , ...1 more... )
• Crack ( type: esriFieldTypeString, alias: Crack, length: 10 , Coded Values: [Minor: Minor] , [Moderate: Moderate] , [Major: Major] , ...1 more... )
• Break_ ( type: esriFieldTypeSmallInteger, alias: Break , Coded Values: [0: False] , [1: True] )
• I_I ( type: esriFieldTypeString, alias: I_I, length: 10 , Coded Values: [Trace: Trace] , [Light: Light] , [Medium: Medium] , ...2 more... )
• I_I_Location ( type: esriFieldTypeString, alias: I_I_Location, length: 20 , Coded Values: [Joints: Joints] , [Services: Services] , [Joints and Services: Joints and Services] , ...3 more... )
• Hole ( type: esriFieldTypeString, alias: Hole, length: 10 , Coded Values: [Minor: Minor] , [Moderate: Moderate] , [Major: Major] , ...1 more... )
• Hole_Location ( type: esriFieldTypeString, alias: Hole_Location, length: 10 , Coded Values: [Crown: Crown] , [Side(s): Side(s)] , [Trough: Trough] , ...2 more... )
• Sag ( type: esriFieldTypeString, alias: Sag, length: 5 , Coded Values: [<1/4: <1/4] , [1/4: 1/4] , [1/2: 1/2] , ...3 more... )
• Repair_Status ( type: esriFieldTypeString, alias: Repair_Status, length: 20 , Coded Values: [Needs Repair: Needs Repair] , [Repair in Progress: Repair in Progress] , [Repair Complete: Repair Complete] , ...1 more... )
• Repair_Comments ( type: esriFieldTypeString, alias: Repair_Comments, length: 250 )
• TV_Survey_ID ( type: esriFieldTypeInteger, alias: TV_Survey_ID )
• weblink ( type: esriFieldTypeString, alias: weblink, length: 500 )
• OldTVID ( type: esriFieldTypeInteger, alias: OldTVID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• 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 )
• Project_Number ( type: esriFieldTypeString, alias: Project_Number, length: 30 )
• Survey_Completed ( type: esriFieldTypeSmallInteger, alias: Survey_Completed , Coded Values: [0: False] , [1: True] )
• Flow_Direction ( type: esriFieldTypeString, alias: Flow_Direction, length: 15 , Coded Values: [With: With] , [Against: Against] )
• Low_or_Obstructed_Flow ( type: esriFieldTypeSmallInteger, alias: Low_or_Obstructed_Flow , Coded Values: [0: False] , [1: True] )
• GISTemp ( type: esriFieldTypeString, alias: GISTemp, length: 25 )
• Root_Letter_Created ( type: esriFieldTypeSmallInteger, alias: Root_Letter_Created , Coded Values: [0: No] , [1: Yes] )
• AssetID ( type: esriFieldTypeString, alias: AssetID, length: 10 )

Relationships:

• Sewer.DBO.Storm_Pipes (0) -- Related To: Storm Pipes (2)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata