rhemanthk93 opened a new issue, #1583:
URL: https://github.com/apache/sedona/issues/1583
## Expected behavior
In PostGIS, when running ST_Clip on the same dataset, it seems to ignore
problematic rows / data that may have "empty" intersections. So RS_Clip should
not throw an exception for 1 or 2 problematic rows but instead just chose to
ignore them as null, since i am relying on RS_Intersects to provide me the
intersections between raster and geometry
## Actual behavior
RS_Clip throws EmptyIntersectionException("Crop envelope does not intersect
in model space") when interceptions identified by RS_Intersects happened to be
"insignificant to clip", causing the whole spark job to fail.
## Steps to reproduce the problem
compute_query = """
SELECT
project_id,
SUM(RS_CountValue(RS_BandAsArray(RS_Clip(rast, 1, geometry, 0), 1),
1)) as 1_total_count
FROM
valid_interceptions_table
GROUP BY
project_id
"""
## Settings
Sedona version = 1.6.1
Apache Spark version = 3.5.0-amzn-1
Apache Flink version = Not Sure
API type = Python
Scala version = NA
JRE version = NA
Python version = 3.9.16
Environment = Jupyter Notebook on EMR Studio (EMR serverless)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
