Hi,
I find that Union of 2 polygon shape files is not what is expected from
other FOSS GIS like GRASS etc. I can send two small shape files with a few
polygons and the anticipated result. Pl let me know to whom I should mail it
for help, such that UNION with PostGIS can be used after neces
Wanted to follow-up on this with the SQL that worked in the end.
Firstly...thanks so much Regina! I've no confidence that I ever would have
figured out this sql on my own, and yet looking at it now it makes perfect
sense!
So here it is in case anyone else is interested:
- vmap_countries contains
Snaptogrid might help, since it perturbs the geometries a bit, which can
sometimes sidestep these kinds of errors.
You should also ensure that your input geometries are valid.
Dylan Lorimer wrote:
Hi Regina,
Getting Geos errors...any ideas? I'm using the latest PostGIS build
(1.3.3) and all
Hi Dylan,
What are your two input geometries that are causing the error? If
they're not too big, post the wkb strings here.
-- Kevin
Dylan Lorimer wrote:
Hi Regina,
Getting Geos errors...any ideas? I'm using the latest PostGIS build
(1.3.3) and all very recent Geos and such. Any ideas on ho
I think "server" is the hostname the server is on (ie. localhost or your
computer name). "Instance" refers to the name of the database that
resides on the server.
Bob Pawley wrote:
I'm having a problem connecting OpenJump to Postgis.
I've installed OpenJump c/w the Postgis plugin running Pos
DISREGARD THIS ONE, was something else.
Sorry.
2008/5/5 chris hinkle <[EMAIL PROTECTED]>:
> Hi All,
>
> ST_MakeLine( [set of 3d points] ) returns null.
>
> Is that supposed to happen?
>
> I'm trying to get to a place where I can call st_length3d_spheroid( )
> on a linestring, made of of a bun
Hi All,
ST_MakeLine( [set of 3d points] ) returns null.
Is that supposed to happen?
I'm trying to get to a place where I can call st_length3d_spheroid( )
on a linestring, made of of a bunch of 3d points, which were made with
ST_GeomFromText( ) using values from my GPS NMEA parser.
Am I missing
I'd say that's a fairly strong indicator of major success. Congrats, Paul!
-Abe
On Fri, May 2, 2008 at 1:21 PM, Paul Ramsey <[EMAIL PROTECTED]> wrote:
> Anyone in the Bay Area looking for a PostGIS opportunity might want to
> take a gander at these:
>
> http://docs.google.com/View?docid=ddts6c
Hi Regina,
Getting Geos errors...any ideas? I'm using the latest PostGIS build (1.3.3)
and all very recent Geos and such. Any ideas on how to get around this?
Would I use snaptogrid?
NOTICE: TopologyException: found non-noded intersection between 91.9895
27.8807, 91.9179 27.7568 and 91.9908 27.4
I've had this kind of problem before when I haven't set up the role
correctly. If you're working on a local (e.g. Linux) postgresql /
postgis instance using say PSQL you don't notice any problems, but if
you try to connect from another machine, you get frustration.
Make sure your role requires a
Hi Bob,
I'have just try'd the DataStore connection with postgis and its
working fine, if you want to try this i can show you my parameters.
Good luck
MatÃas
On Mon, May 5, 2008 at 4:23 PM, George R. C. Silva
<[EMAIL PROTECTED]> wrote:
> Try:
> name: nameofyourconnection
> driver: postgis
> se
Try:
name: nameofyourconnection
driver: postgis
server:localhost
instance: (public or the schema youre working on)
user
pass
Att.
George
Bob Pawley escreveu:
I'm having a problem connecting OpenJump to Postgis.
I've installed OpenJump c/w the Postgis plugin running Postgresql 8.3
and Postgis
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 - Database
Driver - postgis
Server - 8.3
Instance - localhost
User - postgres
Password - *
T
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
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 - Database
Driver - postgis
Server - 8.3
Instance - localhost
User - postgres
Password - *
The connection keeps
Stephen,
This is a classic, and I think it must be in some FAQ some where. The
only way I have done it is to re-project using the transform function to
something whose units are in meters, since the 4326 SRID has distance
units in meters. Thus, something like the following:
SELECT st_area(tr
> If two geometries overlap, which one would you take? I assume you would
> leave all out of an overlapping set except for one or would you be taking
> the non-overlapping sections?
>
>
Hi Regina,
Good question. I think I answered my own question. I tool the MemUnion of
all polygons and then comp
Thanks Regina!
Always helpful!
Att.
George Silva
Obe, Regina escreveu:
George,
Unfortunately I don't think so. I think Mike Leahy was working on one,
but I think he is still working out some outstanding issues with it.
Anyrate I am cc'ing plr group so perhaps someone can provide an update.
The problem with St_Contains() first mentioned in thread
http://postgis.refractions.net/pipermail/postgis-users/2008-January/0182
31.html
is still not solved in the latest version of Postgis 1.3.3. Probably
this is due to the fact that the GEOS lib included is still an 'old'
version (3.0.0). Would
Had a typo in my last statement and also to make it so you can remove the
where later - revise to
SELECT ST_Difference(A.the_geom, C.the_sum_geom), A.country_name
FROM A INNER JOIN (SELECT ST_Collect(B.the_geom) As the_sum_geom,
A.country_name
FROM A INNER JOIN B ON ST_Intersects(B.the_geom,
Dylan,
I hope you don't think that LEFT JOIN is the only trick I have in my bag of
tricks although I have to admit it is my favorite. For the below I would
think this query wouldn't work at all
SELECT ST_Difference(A.the_geom, B.the_geom), A.country_name FROM A, B WHERE
A.country_name='China'
21 matches
Mail list logo
