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:
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