This needs to be at the county before the next code update. Checked into GH, but DDL is:
CREATE OR REPLACE FORCE EDITIONABLE VIEW "NPDES"."ETL_BMP_LAND_USE_SPATIAL_VW" ("BMP_ID", "LAND_USE") AS
select a.BMP_ID, d.LU_CODE
from BMPS a, MDP_LULC d
where
sde.st_relation_operators.st_intersects_f(a.SHAPE, d.SHAPE) = 1;
This needs to be at the county before the next code update. Checked into GH, but DDL is:
CREATE OR REPLACE FORCE EDITIONABLE VIEW "NPDES"."ETL_BMP_LAND_USE_SPATIAL_VW" ("BMP_ID", "LAND_USE") AS select a.BMP_ID, d.LU_CODE
from BMPS a, MDP_LULC d where sde.st_relation_operators.st_intersects_f(a.SHAPE, d.SHAPE) = 1;