Hi all,
I have spent the last three hours trying to find a plain-English
description of how you change the projection of a PostGIS layer, and I
am now giving up. I have found quite a few questions about this on the
internet, but not a single answer that allows for a newbie to SQL. Every
answe
Hi again,
As a follow-up to the last question, I would like to know - and please
assume here my utmost stupidity as I have only recently come from the
GUI world of ArcGIS - how do you add a column to a PostGIS layer that
automatically calculates the area of each polygon feature in the layer?
Hi all,
I have a postgis polygon layer representing a site boundary (we will
call the layer "boundary") and another postgis point layer with a larger
extent representing California condor observations (we will call the
layer "condors"). I am using gvSIG which allows SQL restrictions of
layer
Shouldn't localhost be on the Server line? I think instance can be left
blank.
-Marcus
Bob Pawley wrote:
I'm having a problem connecting OpenJump to Postgis.
I've installed OpenJump c/w the Postgis plugin running Postgresql 8.3
and Postgis 1.2.
The connection manager requires-
Name - Datab
Hello all,
I have a SERIOUS problem here because I have to get a map made and I can
not access my data. I upgraded Ubuntu from 7.10 to 8.04. I just
discovered that I apparently can not use my postgis layers in either
qgis (which can see the layers but crashes when I load them) or gvsig
(which
Regarding the message below, I fixed the problems thanks to an error
message in openjump. All of these programs depend on liblwgeom.so.1.2
and ubuntu hardy upgraded that library to liblwgeom.so.1.3. I created a
symlink to the upgraded file and that fixed the problem.
-Marcus
Hello al
Hi all,
Well, moving to PostGIS as a spatial data format has helped a lot with
trying to learn SQL, but I still have problems with the SQL syntax for
spatial operators. Here is what I want to do:
Layers:
(1) basin_grading: polygons representing the impact area of a
proposed basin, plus 100
Hi all,
I figured out how to use Intersection and get a resulting table with
apparently correct results using the example from the PostGIS website:
CREATE TABLE new_fields AS
SELECT
Intersection(f.the_geom, c.the_geom) AS the_geom,
f.attr1,
f.attr2,
c.clu_name
FROM
fields f,
clu c
result from the units of your map
projection into acres
3) ST_intersection and intersection are the same, the new (ST_*) naming
convention was recently added, for reasons that I do not know but assume that
they were good ones.
HTH,
Robert
-Original Message-
From: [EMAIL PROTECTED]
g convention was recently added, for reasons that I do not know
but assume that they were good ones.
HTH,
Robert
-Original Message-
From: [EMAIL PROTECTED] on behalf of
Marcus C. England
Sent: Tue 6/3/2008 2:57 PM
To: PostGIS Users Discussion
Cc:
Subject:[postgis-u
Hello all,
Well, I'm learning fast but I have come across a problem that perplexes
me. I have three polygon tables. "new_vegetation" represents vegetation
on a site. "grading_phases" represents the grading area for a project,
and this is entirely within the limits of "new_vegetation". The thir
Hi Stanley,
I tried that several times and it never worked. Nonetheless, I copied
your text and placed it into my query (replacing the original sum
function) and it still did not work. I get this:
NOTICE: IllegalArgumentException: This method does not support
GeometryCollection arguments
12 matches
Mail list logo