In PostGIS I have two tables:
Table that contains polygons:
table a.provinces
gid | geom | name |
------------------------------
1 | 010604 ... | Champagne |
Table that contains points:
table a.stations
gid | geom | province_short |
---------------------------------
1 | 0132 ... | ch |
They are not connected with foreign key!
I would like to get:
- Only points that are inside of the polygon
- Only points that are outside of the polygon
SRID: 3857
Can it be done just like this or I have to modify database?
No comments:
Post a Comment