Geocortex Essentials Sites Directory Sign In Sign Out ( Guest )

Table: Catch Basin Inspection (ID: 151)

Display Name:   Catch Basin Inspection

Description:   

Type:   TableLayer

Display Field:   last_edited_date

Primary Key Field:   OBJECTID

Searchable:   False

Queryable:   True

Has Attachments:   True

Feature Label:   {last_edited_date}

Feature Description:   N/A

Feature Long Description:   N/A

Icon:   N/A

Data Provider:   Default

Fields:
  • OBJECTID (Type: Int32, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • CMMS_ID [Catchbasin ID] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Weather [Weather at time of inspection] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Condition [Condition of catchbasin] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • DepthToSump [Depth to sump (bottom of basin)] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • BasinFullPercent [Percent basin full] (Type: Int16, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • BasinFullOver50 [Is basin over 50 full?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • CleanedOut [Was catchbasin cleaned out?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • MaintenanceNeeded [Is maintenance needed?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • BrokenGrate [Broken grate] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • WallsFailing [Walls failing] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • CorbelFailing [Corbel failing] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • PipeBlocked [Pipe blocked] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • NoBottom [No bottom] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • NoOutletPipe [No outlet pipe] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • VactorCleaning [Requires vactor cleaning] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • CannotRemoveGrate [Cannot remove grate] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • AsphaltConcrete [Asphalt or Concrete in structure] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • PavementFailing [Pavement failing near grate] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • ExcessiveSediment [Excessive sediment] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • OtherMaintenance [Other maintenance needs] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • AdditionalObservations [Are there additional observations?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Foam [Is foam present?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SanitaryOdor [Is there sanitary odor?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Oil [Is oil present?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Bacteria [Is bacteria present?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Trash [Is trash present?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • ExcessiveCigaretteButts [Are excessive cigarette butts present?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • PetWaste [Is pet waste present?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • OtherObservations [Other observations] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Notes (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • created_user [Collected By] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • created_date [Collection Date] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • last_edited_user [Edited By] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • last_edited_date [Date record was last edited] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • FlowPresent [Is flow present?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • FlowDescription [Description of flow] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • FlowDepth [Flow depth (inches)] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • FlowWidth [Flow width (ft/in)] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • TravelTime [Time of travel (seconds)] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Volume [Volume (liters)] (Type: Double, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Precipitation [Previous 48 hours precipitation >0.1 inches] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • IllicitDischarge [Do indicators suggest illicit discharge?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • TypeOfDischarge [Type of illicit discharge] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • DischargeRemoved [Was illicit discharge removed?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • DateOfRemoval [Date illicit discharge was removed] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • InvestigationClosed [Is investigation closed?] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • DateClosed [Date investigation was closed?] (Type: DateTime, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Non_IllicitConcerns [Describe any non-illicit discharge concerns] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • GlobalID (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Damage [Catchbasin damage] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Deposits [Deposits or stains] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • PipeAlgae [Pipe algae or growth] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Color [Color present] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • Turbidity [Turbidity present] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • TurbiditySeverity [Severity of turbidity] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • GlobalID_1 (Type: Guid, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • SedimentRemoved [Sediment Removed (cf)] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • DepthtoSediment [Depth to Sediment (in)] (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)
  • CatchbasinDamage (Type: String, Visible: True, Searchable: True, Can Symbolize Unique Value: True, Can Symbolize Class Breaks: True, Addressable: True)

Layer Hyperlinks:
N/A

    Show Feature Hyperlinks:   Show

    Feature Hyperlinks:
    N/A

      Queries:

        Relationships:
        • dCatchbasin





        Supported Interfaces:  REST