Re: [postgis-users] Postgis & R language

. It's a bit > round-about of course: do you use PostGIS from R, or R from PostGIS? > > Jan > > On 11/17/10 12:46, David Potts wrote: >> Hi List >> >> Has anybody ever tried to read the value of geometry column from a table >> into a R-language app

[postgis-users] Postgis & R language

Hi List Has anybody ever tried to read the value of geometry column from a table into a R-language application using the plr handler, is this a support option? Thanks in advance. Any views expressed in this message are tho

Re: [postgis-users] Nearest Neighbour on a polygon gemeotry to a given point

t; st_line_interpolate_point( > st_exteriorring(polygongeometry), > st_line_locate_point( >st_exteriorring(polygongeometry), >pointgeometry > ) > ) > > David > > On Tue, Sep 7, 2010 at 6:55 AM, David Potts > wrote: > >> >> I have a series o

[postgis-users] Nearest Neighbour on a polygon gemeotry to a given point

I have a series of x/y values that represent towns and a coastline that that is encoded as a Polygon. I want to return the nearest point on the polygon to a town. I have seen the item http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_nearest_neighbor_generic Which seems to be f

[postgis-users] Seeing the value of a geometry string before an error message is issued.

Hi I am using hibernate spatial as a front end to postgis(8.3) database within a java program. As far as I can tell, a valid sql statment is generated, I pass in what I think is a valid geometry string. I am getting a 'invalid geometry' error message. Short off rebuilding the liblwgeom libra

Re: [postgis-users] Making a Polygon from Points

))',srid > ) as the_geom > > First put the points in an array, add the first point at the last > position, and convert the array to a GEOMETRY string. You need a column > to orders the points (nr in this case). > > Jan > > > David Potts wrote: >> Hi >&g

[postgis-users] Making a Polygon from Points

Hi I trying to make a polygon or closed linestring from a list of points. I can say something like insert into lines(the_geom) select ST_MakeLine(foo.the_geom) from(select the_geom from hack where generation=1 and circle=0 ) as foo; This results in a open line that runs through all off the po

[postgis-users] Modeling an ocean

Hi, I have been asked to model an Ocean by a 3rd party in terms of the possible movement patterns fo ships, has anybody got any suggestion on where to start on this issue? I am used to think about cost distance models, friction maps, nearest neighbour etc on land. But an ocean is a different con

[postgis-users] Buffering around 1/2 an object

Hi I known this sound like a strange question, but is it possible to create a buffer around 1/2 of geomtry objectt. If I choose to buffer round a stright line, I get a geomtry that looks like a sausage, if I buffer round a point, I get a geomtry that looks like a circle. What I would like to

RE: [postgis-users] 1.3.3 Pre-Release Notice

The other issue I noticed with the file, and could just be my editor > (which > drove me a bit crazy) is that in some locations, the indentation is off so > I > reindented some sections. Also less of a deal there seems to be a mix of > syntax style -e.g > > if () { > > } > > Vs. > if (..) > { > >

Re: [postgis-users] PostGIS + Hibernate Quick Start

"please correct if I am wrong " I stand FULLY corrected in my mad desire to use this useful software I must have overlooked this link. Thank. Dave. >> wrong > Hi, > > On 27 Mar 2008, at 22:53, Dave Potts wrote: >> Whille its true that the hibernate postgis setup is in SVN I did'nt >> discover a s

[postgis-users] problems postgis, hibernate and java

I have been writing an application that uses the org.postgis.Geometry data type. I have been impressed so far, but I have a slight problem with use of the Geometry when supplied to a query. If I attempt to access a Geometry defined with in the database and one of the postgis defined functions su

[postgis-users] postgis mapserver boolean expressions

Hi Is there a problem with the use of the postgres boolean type in mapserver? I have a data type of type boolean in my database type called castle I have tried to use the following syntax(see below) , I would have assumed that if pt.castle was set to true, then this layer would have been drawn

Re: [postgis-users] PostGIS and Java

t; The problem is that it doesn't compile because theses classes are > missing or don't work. On my classpath I have: > - postgis-1.3.2.jar > - postgresql-8.2-508.jdbc2.jar or postgresql-8.2-508.jdbc3.jar > Which Jar is missing? > > Gérald > > 2008/3/4, David Potts

Re: [postgis-users] PostGIS and Java

whats the nature of the error message ? Do you get messages about not being able to find the class when your building your application or some type of error when you run your application? >From what you have said so far I would suspect a class issue problem, ie the jar file that includes the corr

[postgis-users] postgis schema tool

Can any body suggest any tools for drawing a postgis schema ? David Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of the Pinan Software ___ postgis-users mailing

[postgis-users] Making a line from points

hi List, I am trying to make a linestring from a serries of points, I have tried things like update linetable set the_geom=makeline(select the_geom from points_table); witch did'nt work, having looked at the documentation for making making linestrings (addpoint,makeline, etc) and seen a previou

Re: [postgis-users] How is Centroid(Geometry) calculated?

Hi All, Are there any data analytical tools written for postgis ? I known there are tools such as Pgdijkstra I am intrested in cluster analsis , ie discovering if there is any significante data patterns within a given distance of a single point. D. _