Layer: Storm Water Point Features (ID:1)

View In: Map Viewer

Name: Storm Water Point Features

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.

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"feature_type","uniqueValueGroups":[{"heading":"Feature Type","classes":[{"label":"CleanOut","description":"CleanOut","symbol":{"type":"esriPMS","url":"f93e4671aeb2a0addab5fb6ddbf38be1","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABc0lEQVQ4jWNhoBCw4JETkRTgjv7668/vT99+TiPVAA0JAZ7OHHdTTxBn8s7T7i8+fElmYGB4Q4wBAWbK0lN6Y92kbdTlwAJ2mgp+MVPWX3j45kMOAwPDBlwGaAjzcOQ7ailFNIc7CmhIicAlQAbtqIyWzpm/bcmxW082ff/1OwrdABt5Ef6qNGcjl6oAO1asfpISYdhTHcfdsfFI5NRdp1WevPtUxMDAcARkgIi1muyUjigXfZiT8YEKfxuGAFMNU9fWxX1P3n0yAxnw5srjV+9FeLkYSAF//v17DvfCx+8/d9549sYB2d/4wKHrD36/+PDlONwABgaGDUsPXy4PMNEQIMaA7RfvvIfFBgtU7Mbuy3cvEOOKG8/eMFx7/OYyiIlsAAOx3gAZ8P7bd7DzUQxgINIbSw9f/vD607el2AwAe+PIzUcOuGLkzedvDOcePH8Icz66ASBvTAydsPoTPhf8+vMXbjuGASBvvPjwBSWtEwIAeZChUR3crnsAAAAASUVORK5CYII=","contentType":"image/png","width":12,"height":12,"angle":0,"xoffset":0,"yoffset":0},"values":[["CleanOut"]]},{"label":"Inlet","description":"Inlet","symbol":{"type":"esriPMS","url":"594f1aa88cd8b86b6aaaacdee3f090aa","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAC/UlEQVQ4ja2UXUiTYRTH/++2Nr+2uQ+HbaxRanMqIVtlsySK8EojiLqp27ywC6GITEiIboKgC+smvRGiTKgrK7wMRIpskpslNvzYtM1E92mb+3zjPPkuRU2Lzs3zcZ7n955znvP+JfjPJlm/4Hm+BYAegG2X930AujmOc2wC8jw/AKCJ5vG4f0dSfv5eYdrC8/wrjuOac8C1yJqCQQfGx+/A5yP2zqZS2dDQMEDwJmJwHNctREhpwud7DZ3uJEpKTkAkkjJHJhNnc44TI5tNQizOZ3vCODl5H7W1DyCUSQDaKM1UKsyAdNjtfgSlsgZG40V4vX0IBByoqupAJDKB2dknMJuvIS9Ph2QyjPVBbXiUdHoF6XQMc3MvYTReYOuJiXtsLpWq4PU+R0HBPlRUXEU2u4qlpXfQao+zmgs13QCk1KLRr8hkfoDns5DJdEgklpBIfIdSeQjh8GdEIl9gMJxDLDaH1dUF5pfLzTnGJqBGcwRabT3Gxm6gsHA/rNYuuN1d8Hj6UF7eCrFYhtHRNpjN16HTnQbPpzc81KaUKY3l5feoqbmLWMyD4eHzKCu7Ao3mGGZmeqFQHERdXS8WF99iYWEQJtPl7YESSRFrBUolEPgAtfooSkvPQCpVszqp1TZIpRr2UYXCwgIQrXXDlsBfloXJdAlOZwdSqRB0ulMIBj/B43mK6upOiER74HLdZmf0+ibEYt+2B1KfhUIuTE09htX6kAGdzluwWNphtz/DyEgL5PIK1Nf3Y3q6Bw5HKyvNtkAKn5paJtPA738DiaQQlZXtiEbd8PsHYbHcZK/vcnXCbG6DSnWYNfyWQOojipDnMygurkUqFWUNrlBUQibTsn0aqc5FRQcQjy+wxl9Zmd4SSKqBUGgM4+NT4DgRkskAuzw//4JFRe1Br08fJaM/hvYkEjkMhrM5hgDsJtWw2/sxNNQMEondi0OPsGSXGJD0jCSIVKOx8SPz/qWEkXxRUL9rSHq2JmOkGvp1h/9klKZDgG0ArkFzjn+1nymgReNk/A3gAAAAAElFTkSuQmCC","contentType":"image/png","width":15,"height":15,"angle":0,"xoffset":0.25113636363636355,"yoffset":-0.12556818181818177},"values":[["Inlet"]]},{"label":"Manhole","description":"Manhole","symbol":{"type":"esriPMS","url":"16cdd796e0f0dc568638908ca2b94b05","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABt0lEQVQ4ja2TwU7CQBCGZ41EJBqjMSbUGx494tGrN8tj6GMojwGPQX0EjvToUW628QIxGsUQWPONnU0txGjin5Ru2Zl//vl3dlP+CZvlD+99JCLtX+RlIpI757IVIu99LCKDEHn3IbNsETL32zV9KoU7zrkkEBVKlGSazuW++ypZMlsr5ay3J824LtvNDT4H3vtjlJmitpGMrp/1HcV1Ob3ZkYf+mwYctGu6Zn+7+yrx45GUcgORAiWQgOhy61srrauGvOdL3X/PFjLsTOV8sB/2A9G4/6btkEB1KlviLF9qkfvbFzm93dX/iOVtxQIRSeDkqqGbfJPYKhGzpt0fiawl84RvEs96e6GQeYhCMCGm2lqVkGCUGDilcTqX+tdprSAQWQAKkItn+DJJ50rI2lpjxobxZD0R3lgyCeZJzmDmS13jGcogAozICpFNLibycDpUH3amqpY1JBSweEakSqR35jw5kCR6Cl6ZX0BPqlACiR2C5RpRzg8VL0aHqsKUSQHaLpMUx655gYi7wgXk7hDA+JOI0WXgSakdSK6dc2lZEWQJF9DuHebajKyBtmMk34hMmQX9FZ/mUQXsLrnPMwAAAABJRU5ErkJggg==","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"values":[["Manhole"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"f93e4671aeb2a0addab5fb6ddbf38be1","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABc0lEQVQ4jWNhoBCw4JETkRTgjv7668/vT99+TiPVAA0JAZ7OHHdTTxBn8s7T7i8+fElmYGB4Q4wBAWbK0lN6Y92kbdTlwAJ2mgp+MVPWX3j45kMOAwPDBlwGaAjzcOQ7ailFNIc7CmhIicAlQAbtqIyWzpm/bcmxW082ff/1OwrdABt5Ef6qNGcjl6oAO1asfpISYdhTHcfdsfFI5NRdp1WevPtUxMDAcARkgIi1muyUjigXfZiT8YEKfxuGAFMNU9fWxX1P3n0yAxnw5srjV+9FeLkYSAF//v17DvfCx+8/d9549sYB2d/4wKHrD36/+PDlONwABgaGDUsPXy4PMNEQIMaA7RfvvIfFBgtU7Mbuy3cvEOOKG8/eMFx7/OYyiIlsAAOx3gAZ8P7bd7DzUQxgINIbSw9f/vD607el2AwAe+PIzUcOuGLkzedvDOcePH8Icz66ASBvTAydsPoTPhf8+vMXbjuGASBvvPjwBSWtEwIAeZChUR3crnsAAAAASUVORK5CYII=","contentType":"image/png","width":12,"height":12,"angle":0,"xoffset":0,"yoffset":0},"value":"CleanOut","label":"CleanOut"},{"symbol":{"type":"esriPMS","url":"594f1aa88cd8b86b6aaaacdee3f090aa","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAC/UlEQVQ4ja2UXUiTYRTH/++2Nr+2uQ+HbaxRanMqIVtlsySK8EojiLqp27ywC6GITEiIboKgC+smvRGiTKgrK7wMRIpskpslNvzYtM1E92mb+3zjPPkuRU2Lzs3zcZ7n955znvP+JfjPJlm/4Hm+BYAegG2X930AujmOc2wC8jw/AKCJ5vG4f0dSfv5eYdrC8/wrjuOac8C1yJqCQQfGx+/A5yP2zqZS2dDQMEDwJmJwHNctREhpwud7DZ3uJEpKTkAkkjJHJhNnc44TI5tNQizOZ3vCODl5H7W1DyCUSQDaKM1UKsyAdNjtfgSlsgZG40V4vX0IBByoqupAJDKB2dknMJuvIS9Ph2QyjPVBbXiUdHoF6XQMc3MvYTReYOuJiXtsLpWq4PU+R0HBPlRUXEU2u4qlpXfQao+zmgs13QCk1KLRr8hkfoDns5DJdEgklpBIfIdSeQjh8GdEIl9gMJxDLDaH1dUF5pfLzTnGJqBGcwRabT3Gxm6gsHA/rNYuuN1d8Hj6UF7eCrFYhtHRNpjN16HTnQbPpzc81KaUKY3l5feoqbmLWMyD4eHzKCu7Ao3mGGZmeqFQHERdXS8WF99iYWEQJtPl7YESSRFrBUolEPgAtfooSkvPQCpVszqp1TZIpRr2UYXCwgIQrXXDlsBfloXJdAlOZwdSqRB0ulMIBj/B43mK6upOiER74HLdZmf0+ibEYt+2B1KfhUIuTE09htX6kAGdzluwWNphtz/DyEgL5PIK1Nf3Y3q6Bw5HKyvNtkAKn5paJtPA738DiaQQlZXtiEbd8PsHYbHcZK/vcnXCbG6DSnWYNfyWQOojipDnMygurkUqFWUNrlBUQibTsn0aqc5FRQcQjy+wxl9Zmd4SSKqBUGgM4+NT4DgRkskAuzw//4JFRe1Br08fJaM/hvYkEjkMhrM5hgDsJtWw2/sxNNQMEondi0OPsGSXGJD0jCSIVKOx8SPz/qWEkXxRUL9rSHq2JmOkGvp1h/9klKZDgG0ArkFzjn+1nymgReNk/A3gAAAAAElFTkSuQmCC","contentType":"image/png","width":15,"height":15,"angle":0,"xoffset":0.25113636363636355,"yoffset":-0.12556818181818177},"value":"Inlet","label":"Inlet"},{"symbol":{"type":"esriPMS","url":"16cdd796e0f0dc568638908ca2b94b05","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABt0lEQVQ4ja2TwU7CQBCGZ41EJBqjMSbUGx494tGrN8tj6GMojwGPQX0EjvToUW628QIxGsUQWPONnU0txGjin5Ru2Zl//vl3dlP+CZvlD+99JCLtX+RlIpI757IVIu99LCKDEHn3IbNsETL32zV9KoU7zrkkEBVKlGSazuW++ypZMlsr5ay3J824LtvNDT4H3vtjlJmitpGMrp/1HcV1Ob3ZkYf+mwYctGu6Zn+7+yrx45GUcgORAiWQgOhy61srrauGvOdL3X/PFjLsTOV8sB/2A9G4/6btkEB1KlviLF9qkfvbFzm93dX/iOVtxQIRSeDkqqGbfJPYKhGzpt0fiawl84RvEs96e6GQeYhCMCGm2lqVkGCUGDilcTqX+tdprSAQWQAKkItn+DJJ50rI2lpjxobxZD0R3lgyCeZJzmDmS13jGcogAozICpFNLibycDpUH3amqpY1JBSweEakSqR35jw5kCR6Cl6ZX0BPqlACiR2C5RpRzg8VL0aHqsKUSQHaLpMUx655gYi7wgXk7hDA+JOI0WXgSakdSK6dc2lZEWQJF9DuHebajKyBtmMk34hMmQX9FZ/mUQXsLrnPMwAAAABJRU5ErkJggg==","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0},"value":"Manhole","label":"Manhole"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[231,252,199,255],"toColor":[231,252,199,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[243,184,252,255],"toColor":[243,184,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,226,252,255],"toColor":[189,226,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,185,182,255],"toColor":[252,185,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,235,255],"toColor":[182,252,235,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,190,252,255],"toColor":[179,190,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,210,237,255],"toColor":[252,210,237,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,228,212,255],"toColor":[252,228,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,195,255],"toColor":[179,252,195,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[225,207,252,255],"toColor":[225,207,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,242,194,255],"toColor":[252,242,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,245,252,255],"toColor":[179,245,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,205,179,255],"toColor":[252,205,179,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: globalid

Type ID Field: feature_type

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
featureid (type: esriFieldTypeInteger, alias: FeatureID, SQL Type: sqlTypeOther, nullable: true, editable: true)
feature_type (type: esriFieldTypeString, alias: Feature_Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Inlet: Inlet], [Manhole: Manhole], [CleanOut: CleanOut])
feature_subtype (type: esriFieldTypeString, alias: Feature_SubType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Inlet: Inlet], [Grate: Grate], [S-Type: S-Type], ... 11 more ...)
locationdescription (type: esriFieldTypeString, alias: LocationDescription, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
maintainedby (type: esriFieldTypeString, alias: MaintainedBy, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CITY OF MOBILE: CITY OF MOBILE], [CITY OF PRICHARD: CITY OF PRICHARD], [MAWSS: MAWSS], ... 4 more ...)
wallmaterial (type: esriFieldTypeString, alias: WallMaterial, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [BRICK: Brick], [CONC: Concrete], [CMU: CMU], ... 3 more ...)
survey_date (type: esriFieldTypeDate, alias: Survey_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
survey_gps_status (type: esriFieldTypeString, alias: Survey_GPS_Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [GPS Complete: GPS Complete], [Issues - Unable to GPS: Issues - Unable to GPS], [Not GPS: Not GPS])
survey_gps_source (type: esriFieldTypeString, alias: Survey_GPS_Source, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [DGPS-RTK: DGPS-RTK], [DIFFERENTIAL LEVELING: DIFFERENTIAL LEVELING], [CONVENTIONAL SURVEYING: CONVENTIONAL SURVEYING])
survey_measurement_status (type: esriFieldTypeString, alias: Survey_Measurement_Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Complete: Complete], [Complete - Atypical: Complete - Atypical], [Complete - Atypical - Unintentional: Complete - Atypical - Unintentional], ... 2 more ...)
survey_depth (type: esriFieldTypeDouble, alias: Survey_Depth, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 25])
survey_elevation (type: esriFieldTypeDouble, alias: Survey_Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [-9 - 275])
survey_invertelevation (type: esriFieldTypeDouble, alias: Survey_InvertElevation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [-9 - 275])
watershed (type: esriFieldTypeString, alias: Watershed, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
creat_date (type: esriFieldTypeDate, alias: Creat_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
rev_date (type: esriFieldTypeDate, alias: Rev_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
accessible (type: esriFieldTypeString, alias: ACCESSIBLE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [N: N], [Y: Y])
lid_material (type: esriFieldTypeString, alias: Lid_Material, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Metal: Metal], [Concrete: Concrete])
gps_horiz_accuracy (type: esriFieldTypeDouble, alias: GPS_Horiz_Accuracy, SQL Type: sqlTypeOther, nullable: true, editable: true)
gps_vert_accuracy (type: esriFieldTypeDouble, alias: GPS_Vert_Accuracy, SQL Type: sqlTypeOther, nullable: true, editable: true)
asset_name (type: esriFieldTypeString, alias: ASSET_NAME, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)

Types:

Field Name: feature_type
Inherited
Field Name: feature_subtype
Inherited
Field Name: maintainedby
Inherited
Field Name: wallmaterial
Inherited
Field Name: survey_gps_status
Inherited
Field Name: survey_gps_source
Inherited
Field Name: survey_measurement_status
Inherited
Field Name: survey_depth
Inherited
Field Name: survey_elevation
Inherited
Field Name: survey_invertelevation
Inherited
Field Name: accessible
Inherited
Field Name: lid_material
Inherited

feature_type: CleanOut

Field Name: feature_type
Inherited
Field Name: feature_subtype
Inherited
Field Name: maintainedby
Inherited
Field Name: wallmaterial
Inherited
Field Name: survey_gps_status
Inherited
Field Name: survey_gps_source
Inherited
Field Name: survey_measurement_status
Inherited
Field Name: survey_depth
Inherited
Field Name: survey_elevation
Inherited
Field Name: survey_invertelevation
Inherited
Field Name: accessible
Inherited
Field Name: lid_material
Inherited

feature_type: Inlet

Field Name: feature_type
Inherited
Field Name: feature_subtype
Inherited
Field Name: maintainedby
Inherited
Field Name: wallmaterial
Inherited
Field Name: survey_gps_status
Inherited
Field Name: survey_gps_source
Inherited
Field Name: survey_measurement_status
Inherited
Field Name: survey_depth
Inherited
Field Name: survey_elevation
Inherited
Field Name: survey_invertelevation
Inherited
Field Name: accessible
Inherited
Field Name: lid_material
Inherited

feature_type: Manhole

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/31/2025 6:18:43 PM

Schema Last Edit Date: 12/31/2025 6:18:43 PM

Data Last Edit Date: 12/31/2025 6:18:43 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat