[postgis-users] more effective way?
chris brisendine
ki4gyw at gmail.com
Sun Jun 3 07:02:32 PDT 2012
I have a postgis table that contains radar. My problem is every 3
minutes I update the radar table and sometimes the end user has no
radar showing due to the new data loading
is there a more effective way than doing it like I am with the following code,
shp2pgsql -D -a -s 4269 last.shp base05 > base05.sql
psql -c "TRUNCATE TABLE base05" -d wxserver
psql -d wxserver -f base05.sql
I was dropping the table but that would cause my wms server to freakout.
More information about the postgis-users
mailing list