There's probably a simple answer to this, but...
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. Any help?
SELECT * FROM qnmapplutoWHERE ...???Thank you.
أكثر...
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. Any help?
SELECT * FROM qnmapplutoWHERE ...???Thank you.
أكثر...