similar to: PostGIS 2.1 rasters available to Rails code: breadcrumbs

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 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

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:

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

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''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 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

We'd like to announce the initial CRAN release of 'rpostgis' (v1.0.0), which facilitates transfer between PostGIS "Geometry" objects (stored in PostgreSQL databases) and R spatial objects. The package also contains a variety of convenience functions which are supplemental to the excellent 'RPostgreSQL' package for interfacing with a PostgreSQL/PostGIS database. To

We'd like to announce the initial CRAN release of 'rpostgis' (v1.0.0), which facilitates transfer between PostGIS "Geometry" objects (stored in PostgreSQL databases) and R spatial objects. The package also contains a variety of convenience functions which are supplemental to the excellent 'RPostgreSQL' package for interfacing with a PostgreSQL/PostGIS database. To

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

The MabLab at the University of Florida is recruiting a Data Manager to fill an immediate opening for the position of Biological Scientist in the lab. We are looking for an enthusiastic, highly motivated and responsible individual to join an exciting research team focused on spatial ecology. The Data Manager will be responsible for the group's database system, and will assist with multiple

Before I start down this road, has anyone done a breadcrumbs implementation they''d be happy to share? Thanks Chris T

I manage a web hosting server that we've recently upgraded, in part so we could accommodate a domain that will enable community mapping. In a recent exchange of mails one developer said: "I could build the package directly on the server machine you have, provided that the potential security risk posed by having compilers installed is not an issue." and another said:

[Sorry for cross-posting] Hi everybody, I am part of the Spatial Information Systems Group in University College Dublin. We are conducting a survey on Open-Source technologies with particular focus on Geo-Spatial projects. Our goal is to collect first-hand knowledge about a number of Open- Source projects active on the Internet. With this work we hope to identify strong and weak points of each

[Apologies for cross-posting] Hi everybody, I am part of the Spatial Information Systems Group in University College Dublin. Our goal is to collect first-hand knowledge about a number of Open- Source projects active on the Internet. With this work we hope to identify strong and weak points of each project in order to give some guidelines for future directions to the Open-Source community and

Hi, is there an environment variable that enables plain Unix filenames in Wine applications? I need to cross compile PostgreSQL and some third party modules on my Fedora 15 system to 64-bit Windows. PostgreSQL uses its "pg_config" for 3rd party code to tell the include dir, compile flags, etc: [zozo at localhost postgis-1.5.3]$ /usr/x86_64-w64-mingw32/sys-root/mingw/bin/pg_config.exe

Hi, I''m running rails 3.0.9 with activerecord 3.0.9 and have three database connections in my rails application - LDAP connection, Oracle and Postgres with PostGIS. I have installed gems GeoRuby v 1.3.4, spatial_adapter v 1.3.1, activerecord-oracle_enhanced-adapter v 1.4.0, ruby-ldap v 0.9.12 , pg v 0.14.0. With both gems the spatial_adapter seem to work well which also is the case