Name: STORM_WATER_STRUCTURES

Display Field: STR_TYPE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This database is a conflation of the older database and the more current data collected by the Department of Engineering. Many fields have been combined and some removed to make the database more readable and easier to edit. The purpose of including non-County maintained structures serves to understand the complete drainage system connectivity, and also, to easily add or remove existing features into the MS4 should a mistake be discovered or annexation/de-annexations occur.

Copyright Text: Chatham County, Georgia

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 899152.697739173
YMin: 696673.40123561
XMax: 1060436.88235167
YMax: 788598.587136157
Spatial Reference: 102666 (2239)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"CNTY_MAINT1","uniqueValueInfos":[{"value":"0","symbol":{"color":[20,158,206,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Yes"},{"value":"1","symbol":{"color":[237,81,81,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"No"}]},"transparency":0}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: CNTY_MAINT1

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• STR_TYPE (type: esriFieldTypeString, alias: Structure Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CURB_INLET: CURB_INLET], [JUNCTION_BOX: JUNCTION_BOX], [DROP_INLET: DROP_INLET], ... 16 more ...)
• COLL_STATU (type: esriFieldTypeString, alias: Collection Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [INLET_POINT: INLET_POINT], [OUTLET_POINT: OUTLET_POINT], [JUNCTION_POINT: JUNCTION_POINT])
• STR_MAT (type: esriFieldTypeString, alias: STR_MAT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [PRE-CAST CONCRETE: PRE-CAST CONCRETE], [METAL: METAL], [CAST IN PLACE: CAST IN PLACE], ... 8 more ...)
• STR_DAMAGE (type: esriFieldTypeString, alias: STR_DAMAGE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [MINOR: MINOR], [MODERATE: MODERATE], [SEVERE: SEVERE], ... 2 more ...)
• STR_SED (type: esriFieldTypeString, alias: STR_SED, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [0%-25% OF PIPE DIAMATER: 0%-25% OF PIPE DIAMATER], [26%-50% OF PIPE DIAMATER: 26%-50% OF PIPE DIAMATER], [51%-75% OF PIPE DIAMATER: 51%-75% OF PIPE DIAMATER], ... 1 more ...)
• STR_DEBRIS (type: esriFieldTypeString, alias: STR_DEBRIS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [MINOR: MINOR], [MODERATE: MODERATE], [SIGNIFICANT: SIGNIFICANT], ... 1 more ...)
• WATER (type: esriFieldTypeString, alias: WATER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [STANDING: STANDING], [FLOWING: FLOWING], [NONE: NONE])
• SCOUR (type: esriFieldTypeString, alias: SCOUR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [MINOR: MINOR], [MODERATE: MODERATE], [SEVERE: SEVERE], ... 2 more ...)
• MAINT_NEED (type: esriFieldTypeString, alias: MAINT_NEED, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ROUTINE: ROUTINE], [REMEDIAL: REMEDIAL], [PRIORITY: PRIORITY], ... 3 more ...)
• CNTY_MAINT1 (type: esriFieldTypeSmallInteger, alias: CNTY_MAINT1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: )
• INSP_DATE (type: esriFieldTypeDate, alias: INSP_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FIELD_NOTE (type: esriFieldTypeString, alias: FIELD_NOTE, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• BASIN (type: esriFieldTypeString, alias: BASIN, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NO_PIPES (type: esriFieldTypeInteger, alias: NO_PIPES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INVERT_ELV (type: esriFieldTypeDouble, alias: INVERT_ELV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• THROAT_ELEV (type: esriFieldTypeDouble, alias: THROAT_ELEV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WEIR_ELV (type: esriFieldTypeDouble, alias: WEIR_ELV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BOTTOM_ELEV (type: esriFieldTypeDouble, alias: BOTTOM_ELEV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOP_ELEV (type: esriFieldTypeDouble, alias: TOP_ELEV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ELV_U_D (type: esriFieldTypeString, alias: ELV_U_D, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• PHOTO (type: esriFieldTypeString, alias: PHOTO, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• PHOTO_PATH (type: esriFieldTypeString, alias: PHOTO_PATH, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CARTEID (type: esriFieldTypeString, alias: CARTEID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• STO_MRK_D (type: esriFieldTypeString, alias: STO_MRK_D, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [NO: NO], [YES: YES], [UNKNOWN: UNKNOWN])
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PLAT_REF (type: esriFieldTypeString, alias: PLAT_REF, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MAINTENANCE (type: esriFieldTypeString, alias: MAINTENANCE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LAST_MAINT (type: esriFieldTypeDate, alias: LAST_MAINT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MAINT_COUNT (type: esriFieldTypeSmallInteger, alias: MAINT_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Types:

ID: 0
Name: 0
Domains:

Templates:

Name: Yes
Description: County Maintained
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• CNTY_MAINT1: 0

---

ID: 1
Name: 1
Domains:

Templates:

Name: No
Description: Not County Maintained
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• CNTY_MAINT1: 1

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/28/2017 3:05:10 PM

Schema Last Edit Date: 6/28/2017 3:05:10 PM

Data Last Edit Date: 6/28/2017 3:05:10 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat