The attached stored procedure populates the Elements grid within the Managed Area record (i.e. the element_managed_area table) based on data within the Managed Area grid within the EO record (i.e. eo_managed_area table). The Managed Area grid in the EO will be automatically populated, assuming the Managed_Area spatial attribute is defined for the Element Occurrence, within Spatial Calculation Attributes, as indicated within the Core Spatial Attributes help topic. A functionality request for this process to be automated is awaiting development (BX-3342: Automate managing the ELEMENT_MANAGED_AREA table based on MA/EO spatial intersections )
- Install the stored procedure by running the attached SQL script as biotics_dlink
- Run the procedure by typing:
SQL>SET SERVEROUT ON
SQL>EXEC EOR_MA_TO_EST_MA