similar to: Simple Query of Postgis Posgresql database?

Hello list, I'm just getting started with using R - I have been trying over the past day or so to work out a method for generating voronoi polygons for PostGIS using SQL. I was able to put together a procedure which works relatively well, but is somewhat inefficient. Someone on the PostGIS list pointed me to the deldir() function in R, for which I can export a text file with x/y coordinates

Hi I know this is not directly centos related but if anyone has used postgres before then that would be a help!! Normally i'm an oracle or mysql guy. I have to install a qa postgres box that uses postgis. All seems well but when the devs import the schema this happens... ERROR: could not access file "$libdir/libpostgis.so.0.9": No such file or directory and indeed that

Hello, This post is to announce a new release of the Spatial Adapter for Rails, which is a plugin that adds support for columns of geometric types (point, linestring, polygon,etc...) to ActiveRecord. Currently the only supported databases are MySql and PostGIS. With this release, geometric columns should behave like columns of any other basic types in all areas: migration, data access, dumping

For those of you looking to add some spatial functionality to your Ruby or Ruby on Rails app, there''s a new project called GeoRuby. It''s pretty new (at v0.0.1), but the basic functionality works and it''s available under the fab MIT license. There was some interest in this on the postgis-users list, so I figured the Rails list might like to know too. Check out:

Hi all, I'm looking for a fix in postgis, which seems to be fixed already in postgis-2.0.7-2.el7. However that package seems to be 'stuck' in the epel7-testing repository: https://koji.fedoraproject.org/koji/buildinfo?buildID=750618 https://bodhi.fedoraproject.org/updates/FEDORA-EPEL-2016-b6c229157e Is there a reason that the package is not pushed to stable yet? Or can it be

Just wanted to post this in case someone else was faced with the same problem. It''s database-specific code, worse, it''s specific to a particular * version* of a particular *extension* to a particular database, wires in SQL, and uses eval on a string of data from the database! So, you know, I''m getting coal in my stocking from DHH this year. I can deal. (After the

The MabLab at the University of Florida's Fort Lauderdale Research and Education Center (Davie, FL) is looking to fill an immediate opening for the position of a Biological Scientist. We are looking for an enthusiastic, highly motivated and responsible individual to join an exciting research team focused on spatial ecology, from fine-scale movement and habitat selection to range dynamics.

Hello, I've been trying every now and then to find a cross operating system solution that would let me access PostgreSQL (and PostGIS) from R, or to access R from PostgreSQL. I know of pl/r, which accomplishes the latter, but has yet to be successfully ported to Windows. Similarly, I've tried to use Rdbi and DBI, but I haven't had luck with those on Windows either for connecting to

Hi. I''m a happy shorewall user. I found something that looks like a possible bug. I''m using shorewall on a single computer at home. I''m using the privoxy proxy server and dansguardian content filter. I configured shorewall based on the "one interface" example from the shorewall.net website. I set the firewall up so that users cannot directly connect to