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:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
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: false
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:

Fields:

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

Templates:

• Name: Conversion Of Existing BMP
  Description:
  Prototype:
  ORIG_BMP_PE: null
  COMMENTS: null
  STRU_NO: null
  OrigBMP_Type: null
  OriginalWQv: null
  AddtionalWQv: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata