I have approximately 600,000 points that must be joined to ~12 million polygons. This process happens weekly, with the potential to happen daily. The polygon data never changes, and is stored in a remote PostGIS database. The points are currently pushed from R to the remote PostGIS server and ST_DWithin is performed to join polygon attributes to the points. Is there way to keep my points local (i.e. within my R environment) and query the remote polygons?
The goal is to not let highly confidential information (the points) needlessly be copied to a remote server as a temporary table, if I can help it.