I have point table and polygon table in PostgreSQL / PostGIS
The polygon table is a series of concentric polygons getting ever smaller / nearest the point See Picture
Each point could be in 1 or many polygons
Within this table is a level column
How do I perform a spatial query returning the join between the polygon contains the point where MAX(level) ?
The result I’m expecting is 1 polygon per point (A polygon can contain 1 or more points)