Name: Swale_Maintenance

Display Field: MaintDate

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• MaintDate ( type: esriFieldTypeDate, alias: MaintDate, length: 8 )
• MaintOperator ( type: esriFieldTypeString, alias: MaintOperator, length: 20 )
• MaintDistrict ( type: esriFieldTypeInteger, alias: MaintDistrict )
• WaterinStructure ( type: esriFieldTypeInteger, alias: WaterinStructure )
• FacilityType ( type: esriFieldTypeString, alias: FacilityType, length: 20 )
• MaintActivity ( type: esriFieldTypeString, alias: MaintActivity, length: 20 )
• FacilityCondition ( type: esriFieldTypeString, alias: FacilityCondition, length: 20 )
• MaterialRemoved ( type: esriFieldTypeString, alias: MaterialRemoved, length: 15 )
• TimeSpent ( type: esriFieldTypeSingle, alias: TimeSpent )
• Xcoordinate ( type: esriFieldTypeDouble, alias: Xcoordinate )
• Ycoordinate ( type: esriFieldTypeDouble, alias: Ycoordinate )
• MaintReason ( type: esriFieldTypeString, alias: MaintReason, length: 10 )
• Odor ( type: esriFieldTypeSmallInteger, alias: Odor )
• OdorDescription ( type: esriFieldTypeString, alias: OdorDescription, length: 20 )
• FacilityImage ( type: esriFieldTypeBlob, alias: FacilityImage )
• SedimentInStructure ( type: esriFieldTypeInteger, alias: SedimentInStructure )
• MaintenanceNotes ( type: esriFieldTypeString, alias: MaintenanceNotes, length: 200 )
• OilWaterSeparator ( type: esriFieldTypeSmallInteger, alias: OilWaterSeparator )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 30 )
• FacilitySubType ( type: esriFieldTypeString, alias: FacilitySubType, length: 25 )
• Bottom_of_dw ( type: esriFieldTypeInteger, alias: Bottom_of_dw )
• DrywellDepth ( type: esriFieldTypeString, alias: DrywellDepth, length: 10 )
• CorrectLid ( type: esriFieldTypeSmallInteger, alias: CorrectLid )
• Pretreat ( type: esriFieldTypeSmallInteger, alias: Pretreat )
• LidType ( type: esriFieldTypeString, alias: LidType, length: 20 )
• LidShape ( type: esriFieldTypeString, alias: LidShape, length: 20 )
• SwaleMaterial ( type: esriFieldTypeString, alias: SwaleMaterial, length: 10 )
• SwaleInlet ( type: esriFieldTypeString, alias: SwaleInlet, length: 10 )
• SwaleDrywell ( type: esriFieldTypeSmallInteger, alias: SwaleDrywell )
• SwaleCatchBasin ( type: esriFieldTypeSmallInteger, alias: SwaleCatchBasin )
• SwaleInletBlocked ( type: esriFieldTypeSmallInteger, alias: SwaleInletBlocked )
• SwaleCondition ( type: esriFieldTypeString, alias: SwaleCondition, length: 20 )
• FacilityNotFound ( type: esriFieldTypeSmallInteger, alias: FacilityNotFound )
• SwaleDrywellImproperLidHeight ( type: esriFieldTypeSmallInteger, alias: SwaleDrywellImproperLidHeight )
• NeedsVactoring ( type: esriFieldTypeSmallInteger, alias: NeedsVactoring )
• GeneralNotes ( type: esriFieldTypeString, alias: GeneralNotes, length: 200 )
• CB_PipeElevation ( type: esriFieldTypeInteger, alias: CB_PipeElevation )
• BottomDepthBeforeVactor ( type: esriFieldTypeInteger, alias: BottomDepthBeforeVactor )
• CB_PipeObstructed ( type: esriFieldTypeSmallInteger, alias: CB_PipeObstructed )
• FilterraSand_StandingWater ( type: esriFieldTypeSmallInteger, alias: FilterraSand_StandingWater )
• FilterraSand_DamageToBoxStructu ( type: esriFieldTypeSmallInteger, alias: FilterraSand_DamageToBoxStructure )
• FilterraSand_DamageToGrate ( type: esriFieldTypeSmallInteger, alias: FilterraSand_DamageToGrate )
• FilterraSand_InletObstructed ( type: esriFieldTypeSmallInteger, alias: FilterraSand_InletObstructed )
• FilterraSand_SiltClay ( type: esriFieldTypeSmallInteger, alias: FilterraSand_SiltClay )
• FilterraSand_Trash ( type: esriFieldTypeSmallInteger, alias: FilterraSand_Trash )
• FilterraSand_Leaves ( type: esriFieldTypeSmallInteger, alias: FilterraSand_Leaves )
• FilterraSand_BucketsRemoved ( type: esriFieldTypeSingle, alias: FilterraSand_BucketsRemoved )
• Filterra_PruningRequired ( type: esriFieldTypeSmallInteger, alias: Filterra_PruningRequired )
• Filterra_DistanceToTopOfSlab ( type: esriFieldTypeInteger, alias: Filterra_DistanceToTopOfSlab )
• Filterra_MediaAdded ( type: esriFieldTypeInteger, alias: Filterra_MediaAdded )
• Filterra_PlantHeightAboveGrate ( type: esriFieldTypeInteger, alias: Filterra_PlantHeightAboveGrate )
• Filterra_PlantWidth ( type: esriFieldTypeInteger, alias: Filterra_PlantWidth )
• Filterra_PlantHealth ( type: esriFieldTypeString, alias: Filterra_PlantHealth, length: 9 )
• Filterra_PlantDamage ( type: esriFieldTypeSmallInteger, alias: Filterra_PlantDamage )
• Filterra_SiteDistanceObstructio ( type: esriFieldTypeSmallInteger, alias: Filterra_SiteDistanceObstruction )
• SandFilter_SandRemoved ( type: esriFieldTypeInteger, alias: SandFilter_SandRemoved )
• SandFilter_SandAdded ( type: esriFieldTypeInteger, alias: SandFilter_SandAdded )
• SandFilter_Mat ( type: esriFieldTypeString, alias: SandFilter_Mat, length: 8 )
• SandFilter_VerticalPipeObstruct ( type: esriFieldTypeSmallInteger, alias: SandFilter_VerticalPipeObstructed )
• Drywell_BottomType ( type: esriFieldTypeString, alias: Drywell_BottomType, length: 10 )
• Drywell_BottomTypeNotes ( type: esriFieldTypeString, alias: Drywell_BottomTypeNotes, length: 30 )
• FilterFabric ( type: esriFieldTypeSmallInteger, alias: FilterFabric )
• UnableToAccess ( type: esriFieldTypeSmallInteger, alias: UnableToAccess )
• 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 )
• IncorrectStructure ( type: esriFieldTypeString, alias: IncorrectStructure, length: 3 )
• CorrectStructure ( type: esriFieldTypeString, alias: CorrectStructure, length: 25 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 150 )

Relationships:

• STORMWATERSDE.STORMWATER.Swale (1) -- Related To: Swale - Out (35)
• STORMWATERSDE.STORMWATER.Swale (17) -- Related To: Swale (0)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata