Name: Manhole

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

MaxRecordCount: 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: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: CITY OF MOBILE
  Label: City of Mobile
  Description: N/A
  Symbol:
  
• Value: CITY OF PRICHARD
  Label: Other
  Description: N/A
  Symbol:
  
• Value: FEDERAL
  Label: Other
  Description: N/A
  Symbol:
  
• Value: MAWSS
  Label: Other
  Description: N/A
  Symbol:
  
• Value: MOBILE COUNTY
  Label: Other
  Description: N/A
  Symbol:
  
• Value: PRIVATE
  Label: Other
  Description: N/A
  Symbol:
  
• Value: STATE
  Label: Other
  Description: N/A
  Symbol:
  
• Value: UNKNOWN
  Label: Other
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

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: false
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 Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

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

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

  Iteminfo   Thumbnail   Metadata