similar to: PostGIS and MySql Spatial Extensions in Rails

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:

After writing some code (stupidly without checking to see if there was code to do this already) to generate PostGIS SQL insert statements for simple geometry (wkt), I didn't check see if there is already something available to convert WKT strings into some R package geometry (sp?). Does anyone have any advice, hints, code (?) for converting the following OpenGIS strings into something

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

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

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

Hi everyone. I''m having a bit of a problem with an application I''m currently developing with Rails 1.2.3 and PostgreSQL, attempting to use test-first development. Here''s the scenario: * I have the usual three databases, with migrations. Testing has been working beautifully. * I need to store geographic data, so I add PostGIS to all three databases (along with

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

I need to make a simple read-only web query page that allows the user to enter in a longitude and latitude and get a list of areas within which those coordinates occur. I have a postgis (postgresql) databases that contain shape files for county, township, range and section. I can query these databases in the following way from within postgresql in the database county county=# SELECT name_lc

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 announcing a Rails Engine for presenting maps based on your own data, either rendered by Mapserver, or pulled directly out of geometric database tables stored by PostGIS. There''s a demo here: http://ivygis.mgxkernel.com:3000/canada which shows a tiled, draggable version of a Mapserver demo map, with mouse-sensitive park polygons and railroads (SVG in Firefox 1.5+,

Hi! Your plugin is really great! Thanks. One more little question. Is it possible to add event listeners to the maps via your plugin? greetings /till -------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/ym4r-user/attachments/20061106/6b1c6f4f/attachment.html

OK. This may help, but it will also make your head hurt. The basic problem that you''re running into is that you want a "for all" operator and sql doesn''t have one. Instead, you have to think of the query in terms of the logically equivalent "not exists not". Effectively, a proposition is true for all x if you can''t find a counter-example in

I''ve got a Cuisine and a Restaurant model, with a habtm. One thing I want to do is find all the cuisines that have at least one restaurant associated with them. Right now I''m using the following SQL query: SELECT DISTINCT(cuisines.*) FROM cuisines, restaurants, cuisines_restaurants WHERE cuisines.id = cuisines_restaurants.cuisine_id AND restaurants.id =

Is it my environment? Is something wrong, cause I thought this should just work? I have a simple table and I created a model and a controller: ruby script/generate controller Restaurant ruby script/generate model Restaurant I edited the controller to this: class RestaurantController < ApplicationController scaffold :Restaurant end I run it and: http://0.0.0.0:3000/Restaurant works

On Sun, 19 Jul 2015 at 19:21:16 +0200, Guilhem Moulin wrote: > The "subtree" mailbox filter has the same problem, but the > non-parameterized ones ("inboxes", "personal" and "subscribed") work > fine. Actually there are further problem with the INBOX namespace, to which I'm subscribed: $ /usr/lib/dovecot/imap S1: * PREAUTH [CAPABILITY

Here is an example with APPEND $ /usr/lib/dovecot/imap S1: * PREAUTH [CAPABILITY IMAP4rev1 ? MOVE NOTIFY SPECIAL-USE] Logged in as guilhem C1: a1 NOTIFY SET (INBOXES (MessageNew MessageExpunge FlagChange)) S1: a1 OK NOTIFY completed (0.000 secs) $ /usr/lib/dovecot/imap S2: * PREAUTH [CAPABILITY IMAP4rev1 ? MOVE NOTIFY SPECIAL-USE] Logged in as guilhem C2: a2 APPEND

Hi list, The NOTIFY extension (RFC 5465) works fine for mailboxes in the "virtual/" namespace, but it crashes the IMAP client when used with a mailbox in the empty "" namespace: ~$ /usr/lib/dovecot/imap * PREAUTH [CAPABILITY IMAP4rev1 ? NOTIFY SPECIAL-USE] Logged in as guilhem a NAMESPACE * NAMESPACE (("" "/")("virtual/"

Hi, dat1<- read.table(text=" Restaurant owner purchase_date ??????????? 23 Chuck 3/4/2011 ??????????? 23 Chuck 3/4/2011 ??????????? 23 Chuck 3/4/2011 ??????????? 23 Chuck 3/4/2011 ??????????? 23 Bob??????? 1/1/2013 ??????????? 23 Bob??????? 1/1/2013 ??????????? 23 Bob???????? 1/1/2013 ??????????? 15 Hazel 4/11/2010 ??????????? 15 Hazel 4/11/2010 ??????????? 15 Hazel 4/11/2010 ???????????

So, I''m coding my school project in Rails. There are two models, User and Restaurants. I noticed that in Restaurants, when you use the belongs_to method, you could specify the condition of the associated table. There are a few types of users, in the user_type column of the users table - owners is type 1, users are type 2. So in my haste to hand in enough code, in the Restaurant model,