Here's my dataset: https://aaron-bauman.carto.com/dataset/curbs_1
I want to calculate the area covered by the purple only.
ST_Area
seems to be yielding all the area within the purple as well because when I sum it up the value is greater than the entire area of Philadelphia.
How do I get the area of just the purple?
The dataset bunch of polygons outlining street surfaces. The polygons cover huge areas. Here's a small snippet of one polygon for example:
Here's the query i'm running:
select sum(shape__area) from public.curbs_1;