Return to Answer

Try something like this

SELECT DISTINCT ON (boundary.id) boundary.*
FROM boundary, location
WHERE ST_Intersects (boundary.geom, location.geom)

[paul ramsey made an improvement, but forgot the I in ID]

Try something like this

SELECT DISTINCT ON (boundary.id) boundary.*
FROM boundary, location
WHERE ST_Intersects (boundary.geom, location.geom)

Try something like this

SELECT DISTINCT ON (boundary.id) boundary.*
FROM boundary, location
WHERE ST_Intersects (boundary.geom, location.geom)

[paul ramsey made an improvement, but forgot the I in ID]

Try something like this

SELECT DISTINCT ON (boundary.id) boundary.*
FROM boundary, location
WHERE ST_Intersects (boundary.geom, location.geom)

[paul ramsey made an improvement, but forgot the I in ID]

Try something like this

SELECT DISTINCT ON (boundary.d) boundary.*
FROM boundary, location
WHERE ST_Intersects (boundary.geom, location.geom)

Try something like this

SELECT DISTINCT ON (boundary.id) boundary.*
FROM boundary, location
WHERE ST_Intersects (boundary.geom, location.geom)

[paul ramsey made an improvement, but forgot the I in ID]