[postgis-users] Handling new coordinates and checking intersections

[Nikola]

Hi all,


we have case where we get large number of WGS84 coordinates in database
real fast.

We would like to put geofence (polygons) that we are monitoring and if
coordinate enters polygon system should generate some kinda of alarm.

Idea was to have algo in realtime as much as possible:

1. Trigger on INSERT
2. If coordinate ST_Intersect with polygons in DB create alarm in another
table.


Is this strategy good or checking intersection will kill db.


What is strategy in general for checking if some coordinates are in
specific polygons in realtime?


Thanks for help.

N.


-- 
God is Real, unless declared Integer.
J. Allan Toogood, FORTRAN programmer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140131/6bd2ba00/attachment.html>