I'm trying to figure out how to use the WHERE function to display only polygons (NYC properties, I'm using the PLUTO land use database) where the height (numfloors) of the tallest building on the block (there's a block column with a unique identifier for each block) is six stories or higher. I assume this is achieved using some nested combination of max, joins, etc., but I can't quite figure it out.
SELECT * FROM qnmappluto WHERE ...???
I'm using MapPLUTO, not straight PLUTO. My problem isn't getting the polygons to display.
I'm not trying to display all buildings where NumFloors >= 6. Rather, I'm trying to display all buildings where the tallest building on the same block is six stories or greater – as in, where the max NumFloors value of all buildings that share the same entry in the Block column is greater than or equal to six.