Name: Conversion Of Existing BMP

Display Field: STRU_NO

Type: Table

Geometry Type: N/A

Description: This table is used to track the retrofit of existing SWM facilities to restore the watershed, by adding WQv to the existing facility. MDE GDB requires two fields to be populated where CON_PURPOSE – Conversion of Existing BMP. These two fields are: CONVERTED_FROM: If conversion of existing BMP, then prior BMP Type is required; Conditional if CON_PURPOSE = CONV. and PE_PRE_CONV: PE Treated prior to conversion; Conditional on CON_PURPOSE = CONV and PERMIT_ISSUANCE_YR_CREDIT is current permit or later The Conversion of existing BMP table will contain the Original PE and Original BMP Type, and will relate to both records in ESD Structural based on Structure ID. In ESD and Structural BMP, there will be two records when a retrofit project begins. They will both have the same Structure ID (1234-001), but the existing SWM Facility will have an As Built Date and Project Status will be Permit Closed, whereas the proposed retrofit will not have an As Built Date and Project Status will be Design. The existing SWM BMP will have MDE GDB as PG99BMP000001 and the proposed retrofit will have MDE GDB as PG22RST000001. See MDE GDB Guidance for more information on how the unique IDs are concatenated. When the retrofit is completed, the existing SWM BMP will be archived and removed, leaving only the retrofit with Structure ID: 1234-001 and MDE GDB PG22RST000001, new As Built Date and Project Status Permit Closed.

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• STRU_NO ( type: esriFieldTypeString, alias: Structure ID, length: 8 )
• OrigBMP_Type ( type: esriFieldTypeString, alias: Original BMP Type, length: 5 , Coded Values: [AGRE: Green Roof - Extensive] , [AGRI: Green Roof - Intensive] , [APRP: Permeable Pavements] , ...47 more... )
• OriginalWQv ( type: esriFieldTypeDouble, alias: Original WQv )
• AddtionalWQv ( type: esriFieldTypeDouble, alias: Addtional WQv provided by retrofit )
• ORIG_BMP_PE ( type: esriFieldTypeDouble, alias: ORIG_BMP_PE )
• COMMENTS ( type: esriFieldTypeString, alias: General comments, length: 250 )
• created_user ( type: esriFieldTypeString, alias: Created by, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: Date created, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last edited by, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last edited date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• ESDandS_BMP (4) -- Related To: ESD and Structural BMP (1)

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

  Iteminfo   Thumbnail   Metadata