Name: Clean Out

Display Field: ASSET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Date_last_cleaned_inspected and NumberTimes_cleanedInspected last updated on 2/23/2021 using stormWater.dbo.vw_swPoint_Inspection_Table_CleanHistory.

Service Item Id: 0f0d5c8806b2409ea4d73c9cff2ce3f1

Copyright Text:

Default Visibility: true

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 8000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2400.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1725433.3795181625
YMin: 194817.5899529904
XMax: 1806540.6700591631
YMax: 295582.6098792404
Spatial Reference: 102630  (102630)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: maintainedby
Field 2: feature_subtype
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: CITY OF MOBILE,Junction Box
  Label: City of Mobile - Junction Box
  Description: N/A
  Symbol:
  
• Value: CITY OF MOBILE,JunctionBoxWithManhole
  Label: City of Mobile - Junction Box w/Manhole
  Description: N/A
  Symbol:
  
• Value: PRIVATE,Junction Box
  Label: Other - Junction Box
  Description: N/A
  Symbol:
  
• Value: STATE,Junction Box
  Label: Other - Junction Box
  Description: N/A
  Symbol:
  
• Value: PRIVATE,JunctionBoxWithManhole
  Label: Other - Junction Box w/Manhole
  Description: N/A
  Symbol:
  
• Value: STATE,JunctionBoxWithManhole
  Label: Other - Junction Box w/Manhole
  Description: N/A
  Symbol:
  
• Value: MOBILE COUNTY,JunctionBoxWithManhole
  Label: Other - Junction Box w/Manhole
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: true

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:

• objectid ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• enabled ( nullable: true, alias: Enabled, type: esriFieldTypeSmallInteger )
• lifecyclestatus ( nullable: true, length: 20, alias: LifecycleStatus, type: esriFieldTypeString , Coded Values: [Abandoned: Abandoned] , [Active: Active] )
• featureid ( nullable: true, alias: FeatureID, type: esriFieldTypeInteger )
• feature_type ( nullable: true, length: 50, alias: Feature_Type, type: esriFieldTypeString , Coded Values: [Inlet: Inlet] , [Manhole: Manhole] , [CleanOut: CleanOut] )
• feature_subtype ( nullable: true, length: 50, alias: Feature_SubType, type: esriFieldTypeString , Coded Values: [Inlet: Inlet] , [Grate: Grate] , [S-Type: S-Type] , ...11 more... )
• structure_condition ( nullable: true, length: 50, alias: Structure_Condition, type: esriFieldTypeString , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• inlet_filter ( nullable: true, length: 50, alias: Inlet Filter, type: esriFieldTypeString , Coded Values: [Litter Basket: Litter Basket] , [Screen: Screen] )
• ladderrungs ( nullable: true, length: 1, alias: LadderRungs, type: esriFieldTypeString , Coded Values: [N: N] , [Y: Y] )
• plan_depth ( nullable: true, alias: Plan_Depth, type: esriFieldTypeDouble , Range: [0, 25] )
• plan_elevation ( nullable: true, alias: Plan_Elevation, type: esriFieldTypeDouble , Range: [-9, 275] )
• plan_invertelevation ( nullable: true, alias: Plan_InvertElevation, type: esriFieldTypeDouble , Range: [-9, 275] )
• locationdescription ( nullable: true, length: 200, alias: LocationDescription, type: esriFieldTypeString )
• owner ( nullable: true, length: 20, alias: Owner, type: esriFieldTypeString , Coded Values: [CITY OF MOBILE: CITY OF MOBILE] , [CITY OF PRICHARD: CITY OF PRICHARD] , [MAWSS: MAWSS] , ...4 more... )
• maintainedby ( nullable: true, length: 20, alias: MaintainedBy, type: esriFieldTypeString , Coded Values: [CITY OF MOBILE: CITY OF MOBILE] , [CITY OF PRICHARD: CITY OF PRICHARD] , [MAWSS: MAWSS] , ...4 more... )
• source ( nullable: true, length: 20, alias: Source, type: esriFieldTypeString , Coded Values: [ASBUILT: Asbuilt] , [DGPS-SUBMETER: DGPS-SUBMETER] , [ENGLINEN: Linen] , ...5 more... )
• northing ( nullable: true, alias: Northing, type: esriFieldTypeDouble )
• easting ( nullable: true, alias: Easting, type: esriFieldTypeDouble )
• comments ( nullable: true, length: 250, alias: Comments, type: esriFieldTypeString )
• wallmaterial ( nullable: true, length: 20, alias: WallMaterial, type: esriFieldTypeString , Coded Values: [BRICK: Brick] , [CONC: Concrete] , [CMU: CMU] , ...3 more... )
• conflict_type ( nullable: true, length: 50, alias: Conflict_Type, type: esriFieldTypeString , Coded Values: [Sewer: Sewer] , [Water: Water] , [Gas: Gas] , ...2 more... )
• survey_date ( nullable: true, length: 8, alias: Survey_Date, type: esriFieldTypeDate )
• survey_contract ( nullable: true, length: 50, alias: Survey_Contract, type: esriFieldTypeString )
• survey_gps_status ( nullable: true, length: 50, alias: Survey_GPS_Status, type: esriFieldTypeString , Coded Values: [GPS Complete: GPS Complete] , [Issues - Unable to GPS: Issues - Unable to GPS] , [Not GPS: Not GPS] )
• survey_gps_accuracy ( nullable: true, alias: Survey_GPS_Accuracy, type: esriFieldTypeDouble , Range: [0, 20] )
• survey_gps_source ( nullable: true, length: 50, alias: Survey_GPS_Source, type: esriFieldTypeString , Coded Values: [DGPS-RTK: DGPS-RTK] , [DIFFERENTIAL LEVELING: DIFFERENTIAL LEVELING] , [CONVENTIONAL SURVEYING: CONVENTIONAL SURVEYING] )
• survey_measurement_status ( nullable: true, length: 50, alias: Survey_Measurement_Status, type: esriFieldTypeString , Coded Values: [Complete: Complete] , [Complete - Atypical: Complete - Atypical] , [Complete - Atypical - Unintentional: Complete - Atypical - Unintentional] , ...2 more... )
• survey_depth ( nullable: true, alias: Survey_Depth, type: esriFieldTypeDouble , Range: [0, 25] )
• survey_elevation ( nullable: true, alias: Survey_Elevation, type: esriFieldTypeDouble , Range: [-9, 275] )
• survey_invertelevation ( nullable: true, alias: Survey_InvertElevation, type: esriFieldTypeDouble , Range: [-9, 275] )
• watershed ( nullable: true, length: 100, alias: Watershed, type: esriFieldTypeString )
• cleanzone ( nullable: true, length: 5, alias: CleanZone, type: esriFieldTypeString )
• survey_gps_comment ( nullable: true, length: 255, alias: Survey GPS Comment, type: esriFieldTypeString )
• survey_measurement_comment ( nullable: true, length: 255, alias: Structure Measurement Comment, type: esriFieldTypeString )
• survey_gps_issue ( nullable: true, length: 30, alias: Structure GPS Issue, type: esriFieldTypeString , Coded Values: [Not found: Not found] , [Does Not Exist: Does Not Exist] , [Heavy Traffic: Heavy Traffic] , ...3 more... )
• survey_measurement_issue ( nullable: true, length: 25, alias: Structure Measurement Issue, type: esriFieldTypeString , Coded Values: [Collapsed: Collapsed] , [Other: Other] , [Unable to Access: Unable to Access] , ...1 more... )
• creat_user ( nullable: true, length: 255, alias: Creat_User, type: esriFieldTypeString )
• creat_date ( nullable: true, length: 8, alias: Creat_Date, type: esriFieldTypeDate )
• rev_oper ( nullable: true, length: 50, alias: Rev_Oper, type: esriFieldTypeString )
• rev_date ( nullable: true, length: 8, alias: Rev_Date, type: esriFieldTypeDate )
• globalid ( nullable: false, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• accessible ( nullable: true, length: 10, alias: ACCESSIBLE, type: esriFieldTypeString , Coded Values: [N: N] , [Y: Y] )
• lid_material ( nullable: true, length: 25, alias: Lid_Material, type: esriFieldTypeString , Coded Values: [Metal: Metal] , [Concrete: Concrete] )
• date_last_cleaned_inspected ( nullable: true, length: 8, alias: Date_Last_Cleaned_Inspected, type: esriFieldTypeDate )
• numbertimes_cleanedinspected ( nullable: true, alias: NumberTimes_CleanedInspected, type: esriFieldTypeSmallInteger )
• accessible_issue ( nullable: true, length: 50, alias: ACCESSIBLE_ISSUE, type: esriFieldTypeString , Coded Values: [Paved Over: Paved Over] , [Fencing: Fencing] , [Lid Locked: Lid Locked] , ...1 more... )
• gps_horiz_accuracy ( nullable: true, alias: GPS_Horiz_Accuracy, type: esriFieldTypeDouble )
• gps_vert_accuracy ( nullable: true, alias: GPS_Vert_Accuracy, type: esriFieldTypeDouble )
• survey_easement_comment ( nullable: true, length: 256, alias: Survey_Easement_Comment, type: esriFieldTypeString )
• secondary_function ( nullable: true, length: 25, alias: Secondary Function, type: esriFieldTypeString , Coded Values: [Outfall: Outfall] , [Major Outfall: Major Outfall] )
• insp_zone ( nullable: true, alias: Inspection Zone, type: esriFieldTypeInteger )
• ms4_id ( nullable: true, length: 25, alias: MS4_ID, type: esriFieldTypeString )
• asset_name ( nullable: true, length: 150, alias: ASSET_NAME, type: esriFieldTypeString )
• asset_number ( nullable: true, length: 100, alias: ASSET_NUMBER, type: esriFieldTypeString )
• department ( nullable: true, length: 50, alias: DEPARTMENT, type: esriFieldTypeString )
• division ( nullable: true, length: 50, alias: DIVISION, type: esriFieldTypeString )
• parent_class ( nullable: true, length: 50, alias: PARENT_CLASS, type: esriFieldTypeString )
• subclass1 ( nullable: true, length: 100, alias: SUBCLASS1, type: esriFieldTypeString )
• subclass2 ( nullable: true, length: 100, alias: SUBCLASS2, type: esriFieldTypeString )
• subclass3 ( nullable: true, length: 100, alias: SUBCLASS3, type: esriFieldTypeString )
• parent_asset_id ( nullable: true, length: 50, alias: PARENT_ASSET_ID, type: esriFieldTypeString )
• parent_location ( nullable: true, length: 50, alias: PARENT_LOCATION, type: esriFieldTypeString )
• sublocation1 ( nullable: true, length: 100, alias: SUBLOCATION1, type: esriFieldTypeString )
• sublocation2 ( nullable: true, length: 100, alias: SUBLOCATION2, type: esriFieldTypeString )
• sublocation3 ( nullable: true, length: 100, alias: SUBLOCATION3, type: esriFieldTypeString )
• parent_address ( nullable: true, length: 50, alias: PARENT_ADDRESS, type: esriFieldTypeString )
• asset_id_prefix ( nullable: true, length: 50, alias: ASSET_ID_PREFIX, type: esriFieldTypeString )
• asset_id_seq_num ( nullable: true, alias: ASSET_ID_SEQ_NUM, type: esriFieldTypeInteger )
• council_district ( nullable: true, length: 10, alias: COUNCIL_DISTRICT, type: esriFieldTypeString )
• lat ( nullable: true, alias: LAT, type: esriFieldTypeDouble )
• long ( nullable: true, alias: LONG, type: esriFieldTypeDouble )
• status ( nullable: true, length: 25, alias: STATUS, type: esriFieldTypeString )
• assets_description ( nullable: true, length: 100, alias: ASSETS_DESCRIPTION, type: esriFieldTypeString )
• shape ( nullable: true, alias: Shape, type: esriFieldTypeGeometry )

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

  Iteminfo   Thumbnail   Metadata