search for: postgi

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

...his year. I can deal. (After the whole Jolt Award thing years back, though, he totally owes me, I wanted to keep that thing so bad...) Anyway, problem is this: I wanted to do some calculations on some geospatial raster data, which are to be stored in a GIS-enabled database. I''d chosen PostGIS long ago for various reasons. But even the fabulous RGeo gem doesn''t know from rasters, or at least not yet AFAIK. So there''s no way to get pixels out of the raster except one-by-one with an ST_Value query; for a 297x582 array, a nonstarter. Enter PostGIS 2.1 and its lovely l...

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 library does not exist anywhere on the box. I have looked at the rpm downloaded from postgis.refractions.net and...

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 from a PostGIS table, and write an SQL script with insert stat...

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+, VML in IE). The data for the mouse-sensitive objects is being pulled live out of PostG...

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 FROM counties WHERE distance(the_geom,''POINT(-89.85139 42.73806)'')...

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 in ruby schema mode... For example, here is how you would define a "restaurants" table in a migration, along with a spatial index on the geometric col...

...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: http://rubyforge.org/projects/georuby/ and http://thepochisuperstarmegashow.com/projects/ -- Barry Sears http://www.gix.ca/

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 PostgreSQL from R. Can anyone sugges...

...tem of the Lab (database, GIS and documents), and will assist research and extension projects within the Lab's themes. The primary missions of the Biological Scientist will be: 1. Manage the Lab data system: the Lab relies on a data server using Linux (Debian). Most notably, the server runs a PostGIS database system, which hosts data from research projects of the Lab (notably wood stork, sea turtle and raccoon telemetry data and associated GIS layers), as well as Rstudio Server, Shiny, and GitLab, among others. The candidate will entirely manage the server (keep the data base and the associate...

...lem 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 SpatialAdapter -- thanks, Guilhem!). Development and production databases are happy. * However, testing no longer works. Why? Because the test database is always dropped and recreated -- so that all the PostGIS goodness goes bye-bye before each round of tests....

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 useful in R: POIN...

Hi all! I am quite new to rails, and I would like to know if there is a tutorial, or if someone can tell me how to use rails with stored procedures and views. Any help would be appreciated. Thanks to all -- ------------------------------------------- Gioachino Bartolotta

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

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

I've been given the job of extracting some data from the United States 2000 census (files at http://www2.census.gov/census_2000/datasets/Summary_File_2/Maryland/all_ Maryland.zip 52M). I'm only interested in Census Block Groups (CBGs) located within Baltimore City, Maryland. Additionally, I just have to extract certain data fields. I think I'll be using Summary File 2. This is my first

...base system, and will assist with multiple projects investigating for instance animal fine-scale movement in urban areas, or migration and range dynamics in the context of climate change. The primary mission of the Data Manager will be to manage the group's database system: we run a PostgreSQL/PostGIS database system on a Linux server, which hosts telemetry data on wood storks, sea turtles, raccoons, and associated GIS layers. In the near future, we will be adding advanced data from albatrosses, including accelerometers and infrasound. The Data Manager will manage the database server (database...

It seemed to me that rails extract the special database field type (Array .. In PostgreSQL) as a string.. {'One','Two'} wouldn't it be great if it got converted to a Ruby array directly? _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org http://lists.rubyonrails.org/mailman/listinfo/rails

...ine you have, provided that the potential security risk posed by having compilers installed is not an issue." and another said: "What sort of security risk is there in having compilers installed on a working server? "Obviously we can remove the compilers, however when Mapserver or postgis get updated, we will need to build new packages somewhere. One option: create a second VM for mapchat. We'll put the build environment on it, and only turn it on to make new packages." I don't have enough experience to assess the security issues. Does anyone have an opinion on this...

Hello, I am trying to install RPostgreSQL, but without success at the moment, getting an errormessage - see below. My OS is Fedora 17, R version 2.15.2, PostgreSQL 9.2.1 with Postgis 2.0.1 spatial extension. Thank You for any help, advice or hint in advance. Regards Tomas > install.packages("RPostgreSQL", dependencies=TRUE) trying URL 'http://cran.fyxm.net/src/contrib/RPostgreSQL_0.3-3.tar.gz' Content type 'application/x-gzip' length 474570 b...