Name: BMP_Join_Table_to_Points

Display Field: Structures

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

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:

XMin: 747448.554336078
YMin: 74029.0616616588
XMax: 1224884.78220449
YMax: 900529.748030284
Spatial Reference: 102710 (3437)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"12dd0c39dcdf2bc976130299f1c98728","imageData":"iVBORw0KGgoAAAANSUhEUgAAABcAAAAUCAYAAABmvqYOAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABSUlEQVQ4jbXTP0+DQBzG8e/Qge02CR3oxniJOX0JJA7tOyBxO19Ak65l5h3gZsI7aDfdHA3LvQMZNDrJ5uiAtJRylhJ8Egb+5HOX3z1M+MdMzvxeA1vgbWxcAylwD9yNiU8BLRMwK/TvAvlY+NoNUX4EXwaKjBS4GgNXgA6W1Y1M4PMR9f2B4sTu++CxH4GQ+wfBEsyKDdW4BuMLIZnXu67jR/Ca4ZVmN/9B+HoWgeMev5AJPN/s2nM2roWsDrErQlZXaUixVNOGKyBuj6Od6wd4urRX04ZrP8Jzw79xx63mb6tmF64cFz2zjKMdmUCRoeC4ml14fBEeVq/PAl3VbONaSOYy6Q+DvZpNfErjTzw3wRJebolt+FxI1KlDtMWtRumVhhiIm7gCUiGhyIbh9QKlYQ1sgLzGc2BbZFAMt5t5h8OxLMZx9/kB5NJUHuWcywkAAAAASUVORK5CYII=","contentType":"image/png","width":17,"height":15,"angle":0,"xoffset":0,"yoffset":0}},"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:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• Structures (type: esriFieldTypeString, alias: Structures, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Proposed: Proposed], [Construction: Construction])
• Comment (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Inv_Date (type: esriFieldTypeDate, alias: Inv_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Inv_Crew (type: esriFieldTypeString, alias: Inv_Crew, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Asset_Id (type: esriFieldTypeString, alias: Asset_Id, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• In_Service (type: esriFieldTypeDate, alias: In_Service, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Contract (type: esriFieldTypeString, alias: Contract, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Inspection_Date (type: esriFieldTypeDate, alias: Inspection_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BMPType (type: esriFieldTypeString, alias: BMPType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Buffer: Buffer], [Constructed Wetland: Constructed Wetland], [Dry Detention: Dry Detention], ... 7 more ...)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [District 1: District 1], [District 2: District 2], [District 3: District 3], ... 4 more ...)
• GlobalID (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• InspectionComplete (type: esriFieldTypeString, alias: InspectionComplete, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• AssetID (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InspectionDate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Inspector (type: esriFieldTypeString, alias: Inspector(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Mark Hemmerlein: Mark Hemmerlein], [Bill Arcieri: Bill Arcieri], [other: Other])
• Inspector_other (type: esriFieldTypeString, alias: Specify other., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InspectionType (type: esriFieldTypeString, alias: Inspection Type:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Routine: Routine Annual], [PostStorm: Post Storm-Related], [Other: Other])
• InspectionOther (type: esriFieldTypeString, alias: If Other, Describe, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TodayWeather (type: esriFieldTypeString, alias: Today's Weather:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [S: Sunny], [Other: Overcast], [C: Cloudy], ... 2 more ...)
• Sediment (type: esriFieldTypeString, alias: Sediment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good (No Sediment)], [Fair: Fair (Some sediment within the structure but not affecting operation)], [Poor: Poor (Sediment is affecting the effectiveness of the structure)], ... 1 more ...)
• SedimentComment (type: esriFieldTypeString, alias: Sediment Comment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Trash (type: esriFieldTypeString, alias: Trash Condition:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good (No Trash Present)], [Fair: Fair (Some, but Some, but not affecting the effectiveness)], [Poor: Poor (Affecting the effectiveness of the structure)], ... 1 more ...)
• TrashComment (type: esriFieldTypeString, alias: Trash Comment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Erosion (type: esriFieldTypeString, alias: Erosion Condition:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good (No Erosion)], [Fair: Fair (Some erosion within the structure but not affecting operation)], [Poor: Poor (Erosion is affecting the effectiveness of the structure)], ... 1 more ...)
• ErosionComment (type: esriFieldTypeString, alias: Erosion Comment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Structures_1697655318963 (type: esriFieldTypeString, alias: Structural Condition:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good (Some wear with little or no deterioration)], [Fair: Fair (Some deterioration but could be easily maintained)], [Poor: Poor (Structural damage that renders the structure inoperable)], ... 1 more ...)
• StructuresComment (type: esriFieldTypeString, alias: Structures Comment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Flow (type: esriFieldTypeString, alias: Flow Condition:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good (No Obstructions)], [Fair: Fair (Low Flow Obstructed)], [Poor: Poor (The Spillway is being utilized)], ... 1 more ...)
• FlowComment (type: esriFieldTypeString, alias: Flow Comment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Vegetation (type: esriFieldTypeString, alias: Vegetation Condition:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good (No Woody vegetation present )], [Fair: Fair (Some woody vegetation within the structure but not affecting operation)], [Poor: Poor (Heavy Woody vegetation is affecting the effectiveness of the structure)], ... 1 more ...)
• VegetationComment (type: esriFieldTypeString, alias: Vegetation Comment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Recommendations (type: esriFieldTypeString, alias: Other Comments/Recommendations:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate_1697655318963 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1697655318963 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1697655318963 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1697655318963 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• GlobalID_1697655318963 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate_1 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator_1 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor_1 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Name: BMP Locations
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Structures:
• Comment:
• Inv_Crew:
• Asset_Id:
• Owner:
• Contract:
• BMPType:
• District:
• InspectionComplete:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/7/2025 4:29:02 PM

Schema Last Edit Date: 10/18/2023 6:54:09 PM

Data Last Edit Date: 10/18/2023 6:53:39 PM

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