Skip to main content
edited tags
Link
Encomium
  • 3.2k
  • 2
  • 15
  • 42
Source Link
jpinilla
  • 3.2k
  • 1
  • 15
  • 27

Select polygons that are within other polygons and have a certain area in PostGIS

I'm using PostgreSQL 14.1 with PostGIS 3.1 and I've got two tables malla_p and pen_bal. I want to select those polygons of table malla_p smaller than 10,000 ha that are within the polygons of table pen_bal. I've built the following query:

select 
    m.utmcode , cast(st_area(m.geom)/10000 as integer) ha
    from malla_p m join pen_bal c
    on st_within(m.geom, c.geom) 
    group by m.utmcode
    having ha < 10000
    order by ha desc
;

but it returns an error saying that column "ha" doesn´t exist. What's wrong?