CODEWITHSUNDEEP
postgresqlgpspolygonpostgispoint
user2588220
user2588220

Reputation: 21

Find GPS point within a set of polygons

I'm trying to figure out how to determine in which polygon (each polygon is the boundary of a watershed, in my case) a set of GPS coordinates lies.

I am using PostGIS and am very new to it so any help would be greatly appreciated.

Upvotes: 1

Views: 367

Answers (1)

Mike T
Mike T

Reputation: 43622

Something like this should get you started:

select gps.*, watershed.*
from gps
left join watershed on ST_Within(gps.geom, watershed.geom)

See more info on ST_Within. Also check out http://gis.stackexchange.com for related questions/answers.

Upvotes: 2

Related Questions