I usually create hexbins using the MMQGIS tools in QGIS. I would create a hex layer and intersect it with a shapefile. I've tried to create a hex shapefile and importing it into a PostGIS and tried to do an
ST_Intersects but the result usually come up empty.
Is there a way to create hex bin from PostGIS over a shapefile (truncation of hexes are ok).