DBT Test: Data Release Package Geometry Within Bbox Indonesia Wood Pulp V3 2 0 Spatial Entities Simplified Geometry 7 142 12 94
DBT test name: data_release_package_geometry_within_bbox_indonesia_wood_pulp_v3_2_0_spatial_entities_simplified_geometry__7__142___12__94
DBT details
-
Kind:
generic(data_release_package_geometry_within_bbox) -
Test file: trase/data_pipeline/models/indonesia/wood_pulp/data_packages/indonesia_wood_pulp_v3_2_0/_schema.yml
-
Tags:
indonesia,indonesia_wood_pulp_v3_2_0_data_package,mock_model,wood_pulp
Description
No description
Details
{{ test_data_release_package_geometry_within_bbox(**_dbt_generic_test_kwargs) }}{{ config(tags=['mock_model', 'indonesia', 'wood_pulp', 'indonesia_wood_pulp_v3_2_0_data_package'],alias="data_release_package_geometry__32ee58ede380179cc7927397ffa957bb") }}
select *
from "memory"."main"."indonesia_wood_pulp_v3_2_0_spatial_entities"
where simplified_geometry is not null
and (
ST_XMin(simplified_geometry) < 94
or ST_XMax(simplified_geometry) > 142
or ST_YMin(simplified_geometry) < -12
or ST_YMax(simplified_geometry) > 7
)