http://www.openjump.org
http://udig.refractions.net
http://www.qgis.org
http://gvsig.gva.es
On Thu, Jun 12, 2008 at 7:04 PM, Bob Pawley [EMAIL PROTECTED] wrote:
Does anyone know of a tool the will allow the user to draw a geometric
object and convert it to a shapefile, or WKT/WKB, suitable to
this capability? If so, I would appreciate a
link that explains how to use the system.
Bob
- Original Message - From: Paul Ramsey [EMAIL PROTECTED]
To: PostGIS Users Discussion postgis-users@postgis.refractions.net
Sent: Thursday, June 12, 2008 7:07 PM
Subject: Re: [postgis-users] Shapefile
On Wed, Jun 11, 2008 at 12:21 PM, Abram Gillespie
[EMAIL PROTECTED] wrote:
What's the difference between using st_* and other functions w/o the
st_ prefix. For example, why is there both st_buffer() and buffer()?
The non-st_* functions will be first deprecated and then removed in
future
IMMUTABLE.
I bet when you have the function it's caching the result, and when you
don't, it's re-fetching it. And because the bare result is a toasted
tuple, the re-fetch is a lot more expensive.
P.
On Mon, Jun 9, 2008 at 5:39 AM, Mark Cave-Ayland
[EMAIL PROTECTED] wrote:
Mark Cave-Ayland
Bummer. Well if you need any other cock-eyed theories, let me know :)
P
On Mon, Jun 9, 2008 at 6:34 AM, Mark Cave-Ayland
[EMAIL PROTECTED] wrote:
Paul Ramsey wrote:
IMMUTABLE.
I bet when you have the function it's caching the result, and when you
don't, it's re-fetching it. And because
the plan to AVOID the
spatial index, which is wise, since so many rows are being fetched.
P.
On Fri, Jun 6, 2008 at 12:30 PM, Paul Ramsey [EMAIL PROTECTED] wrote:
I just want to see if I can duplicate the result, having the original
data makes that a faster process, since I can copy your use case
and over (once for each centroid
tested, perhaps?) so the query was being driven by a very expensive
route
P.
On Fri, Jun 6, 2008 at 3:52 PM, Paul Ramsey [EMAIL PROTECTED] wrote:
OK, I'm seeing the same problem here...
I can fix it by re-writing your query:
select count(*) from geography a join
Trust me, Chris, the maintenance of GEOMETRY_COLUMNS has been a
longstanding bug'a'bear and in retrospect we probably would have been
better off without it. In order to get an automagic GEOMETRY_COLUMNS
though, we either required (a) triggers on system tables or (b)
parameterized user-defined
First, basic index concepts: when you are requesting the whole data
set, the index (any index) does *nothing* for your performance. To
use an (obsolete) metaphor, if you are checking out *every* book in
the library, do you first go to the card catalog?
So your test case isn't testing anything
[track_index] being indexed to try
and speed up our queries.
- Brian Peck
- 858-795-1398
- Software Engineer
- Lockheed Martin
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul
Ramsey
Sent: Wednesday, June 04, 2008 4:21 PM
To: PostGIS Users
On Wed, Jun 4, 2008 at 6:35 PM, Stephen Frost
Just an fyi, the parameterized user-defined types was added in 8.3, so
we don't actually need to wait for 8.4. :)
Look at me, asleep at the switch! :)
P
___
postgis-users mailing list
I don't know that it got fully baked. Mark Leslie would have to confirm...
P
On Mon, Jun 2, 2008 at 11:45 PM, mj [EMAIL PROTECTED] wrote:
Hello,
why the function st_curvetoline is not documented in postgis documentation,
it is vital function for displaying compundcurve with mapserver.
The redirect may not work when running it from Run... or exec inside a
program. This sort of argues for a -f option to write out to file
without needing a stdout redirect.
P
On Sat, May 31, 2008 at 2:49 PM, Daniel Blomberg
[EMAIL PROTECTED] wrote:
Hi,
I am trying to run shp2pgsql.exe from
Eric,
Is that a marxan in your pocket, or are you just happy to see us? :)
P
(Sorry, no grid help, just cheesy line...)
On Thu, May 29, 2008 at 7:08 AM, Randall, Eric
[EMAIL PROTECTED] wrote:
Has anyone created a method for generating a hexagonal grid over a polygon
envelope using postgis?
Try this:
http://www.bostongis.com/blog/index.php?/archives/35-Map-Dicing-and-other-stuff.html
P.
On Thu, May 29, 2008 at 12:34 PM, Matias Massigoge
[EMAIL PROTECTED] wrote:
Hi all,
I'm looking for something similar but squared.
This theme have been covered in the past?
Sorry, I'm newby.
Functional indexes do work, but you have to be very careful to match
your SQL invocation to the index you build... it can be fiddly, which
is why I just start by recommending transforming the data :)
P
On Wed, May 28, 2008 at 6:04 AM, Markus Schaber [EMAIL PROTECTED] wrote:
Hi, Paul,
Paul
You have a misconception. If it's a multipolygon in the shape file, it
will be a multipolygon in postgis. When you open up the table view of
your file in ArcView, how many rows are devoted to Hawaii? One, or 27?
P
On Tue, May 27, 2008 at 1:23 PM, Andy Anderson [EMAIL PROTECTED] wrote:
Sorry,
(a) The ST_Transform() function is making your spatial index
un-usable, because your spatial index is against the raw coordinates
of your data.
(b) You are using ST_Buffer() instead of just calculating a distance.
So, first transform your data to your working projection.
Then, use ST_DWithin() to
SDE allows you to use ArcMap as a client. That's the main value proposition.
Secondarily, there's some stuff, most particularly versioning, that
they implement by managing extra metadata in side tables. This is
where your concern regarding 3rd party edits to PostGIS data come to
reality. If you
On Fri, May 23, 2008 at 11:05 AM, Tim Bowden [EMAIL PROTECTED] wrote:
In general, if you restrict yourself ot reading with 3rd party tools
and writing with ESRI tools, or non-ESRI tools working through the SDE
API, you should be safe.
So how much of the API is published? My (very limited)
On Fri, May 23, 2008 at 11:59 AM, Tim Bowden [EMAIL PROTECTED] wrote:
wouldn't it make financial sense for a number of large SDE users to pool
some resources to either make SDE - PostGIS multi-master possible (as
per my previous post which I'm sure is about to get shot down) or
re-implement
On Fri, May 23, 2008 at 12:56 PM, Obe, Regina [EMAIL PROTECTED] wrote:
Okay I need to be educated here. What does ArcMap do exactly that is
special? Most of the time when I see people using it here, its to
export the data they need out of ArcSDE into ESRI Shape so they can use
it in there
, no need for
cursors here - to make with Spatial SQL, with Geodatabase (and ArcSde) you
would need to write an ArcObjects dll and deploy that at any client. This is
even a problematic solutions, because you will have a deployment issue.
Paolo
Paul Ramsey-3 wrote:
SDE allows you to use
You don't want the GROUP BY. It is grouping the union op on distinct
geometry... ie, one per row. Remove it and you'll get what you want,
one output row.
P
On Tue, May 20, 2008 at 8:49 AM, Bob Pawley [EMAIL PROTECTED] wrote:
Hi
I am attemptijng to use the ST_Union function to collapse three
On Tue, May 20, 2008 at 8:40 AM, Kevin Neufeld [EMAIL PROTECTED] wrote:
a1001800 wrote:
Thanks Kevin,
It looks like ~= not invoke the index.
That's why I suggested the operator as well. It does use the index.
Do we have a way to deal with an index with third value?
For example, point
Bah humbug, right you are :)
P
On Tue, May 20, 2008 at 12:31 PM, Kevin Neufeld
[EMAIL PROTECTED] wrote:
Paul Ramsey wrote:
On Tue, May 20, 2008 at 8:40 AM, Kevin Neufeld [EMAIL PROTECTED]
wrote:
a1001800 wrote:
Thanks Kevin,
It looks like ~= not invoke the index.
That's why I
(the_geom)
from tank_lin;
and got the error Unknown geometry type: 0
Bob
- Original Message -
From: Paul Ramsey [EMAIL PROTECTED]
To: PostGIS Users Discussion
postgis-users@postgis.refractions.net
Sent: Tuesday, May 20, 2008 9:51 AM
Subject: Re: [postgis-users] I'm missing
On Tue, May 20, 2008 at 3:06 PM, Karina Guardado [EMAIL PROTECTED] wrote:
1.from the 1.2.0 release of PostGIS there is support for curve /types/,
and initial support for the ISO SQL/MM suite of spatial database functions
Yes, and you'll see some sparse documentation on these. There is not
On Tue, May 20, 2008 at 10:31 PM, Karina Guardado [EMAIL PROTECTED] wrote:
At first reading I thought that Postgis support all of the features types
specified in the OGC geometry model. But now as you explained me there is
not support for all of this then could you please explain me about this
On Sat, May 17, 2008 at 6:45 PM, Paragon Corporation [EMAIL PROTECTED] wrote:
SELECT ST_Transform(ST_Transform(the_geom, srid2), srid1)
It is off a bit from what you started out with. It gets progressively worse
the more transformations you pile on. Perhaps there is no easy solution to
it.
It all falls down into this function:
write_double(double val){
ensure(32);
if (lwgi)
sprintf(out_pos,%.8g,val);
else
sprintf(out_pos,%.15g,val);
to_end();
}
On Fri, May 16, 2008 at 3:23 AM, Paragon Corporation [EMAIL PROTECTED]
On Fri, May 16, 2008 at 7:51 AM, Andy Anderson [EMAIL PROTECTED] wrote:
Being new to PostGIS, I've been looking at other people's code snippets and
trying to figure out what they do. I'm a bit mystified by geomunion(),
though, as it's not in the PostGIS docs, though there are many references
Patch preferred :)
On Fri, May 16, 2008 at 8:56 AM, Andy Anderson [EMAIL PROTECTED] wrote:
Ah, missed this one very clear message amongst the plethora my search
returned.
I see that the request for a documentation fix was made here, also (nine
months ago). Looking at the documentation, I see
Anderson [EMAIL PROTECTED] wrote:
How would I provide that? Source, methods, destination?
Thanks,
-- Andy
On May 16, 2008, at 12:17 PM, Paul Ramsey wrote:
Patch preferred :)
On Fri, May 16, 2008 at 8:56 AM, Andy Anderson [EMAIL PROTECTED]
wrote:
Ah, missed this one very clear message
Department of Environmental Quality
[EMAIL PROTECTED]
804-698-4405
Open Source Modeling Tools:
http://sourceforge.net/projects/npsource/
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul
Ramsey
Sent: Wednesday, May 14, 2008 6:36 PM
To: PostGIS Users
://sourceforge.net/projects/npsource/
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul
Ramsey
Sent: Thursday, May 15, 2008 10:57 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Newbie questions: SRIDs, function return
values
The zillow data is in lat/lon, so use -s 4326.
lat/lon is not a planar projection, so the units returned are pretty
non-sensical: square degrees for area, linear degrees for distance.
Once you have your data correctly flagged with respect to its source
projection, you can transform it.
Add a new
Hi guys, this just in from the 2008 conference committee: the call for
papers deadline approaches!
--
Free and Open Source Geospatial 2008, Cape Town, South Africa.
September 29 - Oct 3 2008.
Reminder: The paper / presentation submission deadline is this coming
Monday 12 May.
Go to
Client applications using the Java libraries are not subject to the
GPL, they are subject to the LGPL, so you can link to the JDBC client
and still use the code in a proprietary application. If you make
change to the JDBC code itself, those changes must be shared, but that
requirement is only for
Niels,
No, it's not in 1.3.3. The performance is indeed quite a bit better,
but it requires an unreleased version of GEOS and also still has a
memory leak in it somewhere... so definately going to be good stuff,
but not ready for release yet.
P
On Sun, May 4, 2008 at 9:15 PM, niels hoffmann
Anyone in the Bay Area looking for a PostGIS opportunity might want to
take a gander at these:
http://docs.google.com/View?docid=ddts6cgv_17qcf7mzcb
I've also noticed that there are actual PostGIS jobs on Dice, Monster
and Craigslist, go figure:
There's a regression issue then, because I needed to *add* those lines
to get it to pass...
On the regression side, could you please change your regression suite
a bit to match the style of the OGC suite? See how each tests also
echos out a test number? It makes it far easier to traverse from the
That's nice, crashed on my platform too (OS/X 10.5, GEOS trunk).
What's your platform?
On Thu, Apr 24, 2008 at 4:02 PM, Stefan Zweig [EMAIL PROTECTED] wrote:
Hi paul,
here we go, there is the new animal for your zoo:
select buffer(st_geomFromText('MULTIPOLYGON(((12.098789
Of course, it's also invalid...
NOTICE: Hole lies outside shell at or near point 12.1087 50.8989
On Thu, Apr 24, 2008 at 4:26 PM, Paul Ramsey [EMAIL PROTECTED] wrote:
That's nice, crashed on my platform too (OS/X 10.5, GEOS trunk).
What's your platform?
On Thu, Apr 24, 2008 at 4:02 PM
Olivier,
I'll try this out on my ferry trip home today and apply it when I get
in if all is looking good. Thanks, that's one item off of my todo
list! :)
P
On Wed, Apr 23, 2008 at 9:56 AM, Courtin Olivier
[EMAIL PROTECTED] wrote:
Hi,
GeoJson is a format we use widely between server and Web
On Wed, Apr 23, 2008 at 7:24 AM, John Abraham [EMAIL PROTECTED] wrote:
We are hiring a programmer and/or sysadmin. Position is in Calgary and the
job level is flexible (envisioning 2-15 years experience but read the job
description.)
We develop spatial economic modelling software used for
I'm going to go out on a limb here, without consulting the source
code, and say that the '=' operator is comparing the representations
of the geomtries, so only geometries that have exactly the same
vertices in exactly the same order starting at exactly the same point
are counted. The equals()
doco patched
On Tue, Apr 22, 2008 at 4:45 AM, Mark Cave-Ayland
[EMAIL PROTECTED] wrote:
Sam Giffney wrote:
On Postgis 1.3.2 (tested on Windows and Debian Lenny)
A LINESTRING which runs parallel to the grid lines (excuse my poor
GIS terminology) returns a LINESTRING instead of a POLYGON
somehow you have odd geometries in your geometry columns...
select gid from quadras_poligono where not st_isvalid(the_geom);
select gid from bairros_poligono where not st_isvalid(the_geom);
P
On Tue, Apr 22, 2008 at 8:18 AM, George R. C. Silva
[EMAIL PROTECTED] wrote:
Hello everyone.
Am i
I've committed the trunk fix into the 3.0.X branch, so the next minor
release of GEOS should contain it.
On Mon, Apr 21, 2008 at 4:18 PM, Paul Ramsey [EMAIL PROTECTED] wrote:
This problem http://www.nabble.com/ST_Contains-doesn't-work--to14946025.html
appears fixed in my local installation
Interesting jumping off point for a discussion of new technology ideas...
- heatmap in the database
- contouring in the database
- kriging in the database (I know, already there w/ R)
P
On Mon, Apr 21, 2008 at 3:55 PM, Reid Priedhorsky [EMAIL PROTECTED] wrote:
Dear list,
I would like to
This?
select id from thetable where st_xmax(the_geom) 180 or
st_xmin(the_geom) -180 or st_ymax 90 or st_ymin -90;
P
On Sun, Apr 20, 2008 at 12:44 AM, Stephen Davies [EMAIL PROTECTED] wrote:
One of my users has been entering garbage lat/long coordinates for geometries
(SRID 4283). eg
Can you re-build GEOS and run make test? The problem seems to be a
symbol that GEOS can't find rather than one lwpostgis can't find.
P
On Fri, Apr 18, 2008 at 3:09 AM, Ronald Woita [EMAIL PROTECTED] wrote:
Hi list,
I have a problem loading the lwpostgis.sql into a database.
(plpgsql is
Use the CIRCULARSTRING type, and the ST_CurveToLine(geometry) function
to convert it to a linestring.
CREATE TABLE test ( GEOM geometry );
INSERT INTO test VALUES ('CIRCULARSTRING(0 0, 1 1, 2 0)');
SELECT ST_AsText(ST_CurveToLine(geom)) FROM test;
P
On Fri, Apr 18, 2008 at 7:53 AM, JohanNL
[EMAIL PROTECTED] wrote:
On Thu, 2008-04-10 at 15:21 -0700, Paul Ramsey wrote:
I (OS/X 10.5, geos trunk) got no failures in regress_ogc under your
patch. We'll see what it was tomorrow I guess.
Okay, it's all sorted now - it was a mismatch between LF and CR/LF files
from SVN. The file
It's on the street:
PostGIS 1.3.3
2008/04/12
- shp2pgsql, pgsql2shp improvements
- regression tests on Windows
- OS/X 10.5 compatibility
- DBF-only loading flag (-n)
- fix to Date DBF output
- ST_SimplifyPreserveTopology(geometry, float8)
Tore, get the -svn tip of postgis and try again. There's a known bug
which is fixed in svn against OS/X 10.5
P
On Thu, Apr 10, 2008 at 11:44 PM, Tore Halset [EMAIL PROTECTED] wrote:
Hello.
I have installed postgresql-8.3.1, geos-3.0.0, proj-4.6.0, postgis-1.3.2
and gdal-1.5.1 on my brand
shp2pgsql
RCSID: $Id: shp2pgsql.c 2760 2008-04-09 19:52:19Z pramsey $ RELEASE: 1.3.3SVN
On Fri, Apr 11, 2008 at 8:11 AM, Obe, Regina [EMAIL PROTECTED] wrote:
(HINT HINT Paul: Would be nice for the dumper/loader files to have a
version option similar to what mapserv has that gives a clue
There is a patch in svn now, download postgis-svn and see if things
are better, they should be.
P
On Thu, Apr 10, 2008 at 5:23 AM, Stefan Schwarzer
[EMAIL PROTECTED] wrote:
Hi,
sorry for coming back to this issue... (and for sending a similar mail just
a couple of minutes ago before I
Just check that the first and last points are the same before
inserting, that's all PostGIS is doing. See below:
On Thu, Apr 10, 2008 at 6:36 AM, Shad Keene [EMAIL PROTECTED] wrote:
I started using postgis recently because of the spatial
capabilities, but I'm stuck now.
I have a
I wonder how client_srid is supposed to handle operations prior to
transport? If I do a buffer() before sending the geometry back, is it
done in the storage srid or the client srid?
I wonder how client_encoding does it... does it sort in UTF and send
back in the client encoding?
On Thu, Apr 10,
My intuition that it worked left-to-right came from Perl... where'd
your reverse intuition come from, Mark? (Languages are so
multifarious...)
On Thu, Apr 10, 2008 at 3:26 PM, Mark Cave-Ayland
[EMAIL PROTECTED] wrote:
Fascinating. Being self-taught in C, it's always interesting to learn
if ( sr_id strcmp(sr_id,-1) ) printf(SRID=%s;, sr_id);
I have a very strong feeling that evaluation order in C is unspecified,
rather
than being from left to right; so for example the compiler could decide to
generate code that evaluates the strcmp() first, in which case it would
On Tue, Apr 8, 2008 at 11:57 PM, David Potts [EMAIL PROTECTED] wrote:
Reindenting the code may be nice and may help people to read the code, but
its not a wise idea.
Particularly not when you're in the midst of a patch cycle. Once your
patch is in and working, we can run 'indent' on the file
by Postgis anyway.
Thanks,
Regina
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul
Ramsey
Sent: Wednesday, April 09, 2008 11:23 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] 1.3.3 Pre-Release Notice
if ( sr_id strcmp
OK, they should be gone now... btw what compiler are you using, I
didn't get those...
On Tue, Apr 8, 2008 at 2:22 PM, Mark Cave-Ayland
[EMAIL PROTECTED] wrote:
On Monday 07 April 2008 22:12:42 Paul Ramsey wrote:
Folks,
1.3.3 is going to be coming out by the end of this week. If you
Folks,
1.3.3 is going to be coming out by the end of this week. If you have
time, please pull the SVN version and give it a try, to ensure we
haven't left any big bugs in the bin.
Thanks!
Paul
___
postgis-users mailing list
st_extent for a minimal bounding box
st_convexhull for a hull
On Sat, Apr 5, 2008 at 1:08 PM, Paul Tomblin [EMAIL PROTECTED] wrote:
I have a table with a point column. Is there a way to find the boundary or
convex hull of some of the entries in that table? For instance, if I want
to find the
Drop the . The indexes are not much help for testing Disjoint, unfortunately.
The other thing you could do is re-cast it as a does-not-intersect
test instead...
SELECT some stuff FROM A, B, C WHERE NOT ( ST_Intersects(A.the_geom,
B.the_geom) OR ST_Intersects(A.the_geom, C.the_geom) );
(The
distance_sphere(GeometryFromText('POINT(10 10)',4326),
GeometryFromText('POINT(11 11)',4326))
On 3/18/08, davidj2k [EMAIL PROTECTED] wrote:
I am trying to find the distance from a point to a polygon object and when I
use the distance(geometry,geometry) function it returns something that is
Mike,
You don't appear to be doing anything wrong, and I can recreate the
same behavior here. I've filed it as a bug. The source of the problem
is unclear.
P
On 3/16/08, Mike Leahy [EMAIL PROTECTED] wrote:
Hello list,
I seem to be having trouble with st_union as an aggregate function.
My test was on OS/X 10.5 on Intel, but come to think of it I have no
idea if that's a 64 bit architecture or not! :) Have you run the test
on 32bit Mark?
P
On 3/17/08, Mark Cave-Ayland [EMAIL PROTECTED] wrote:
On Monday 17 March 2008 15:04:36 Paul Ramsey wrote:
Mike,
You don't appear
On 3/17/08, Mark Cave-Ayland [EMAIL PROTECTED] wrote:
On Monday 17 March 2008 16:23:13 Paul Ramsey wrote:
My test was on OS/X 10.5 on Intel, but come to think of it I have no
idea if that's a 64 bit architecture or not! :) Have you run the test
on 32bit Mark?
P
Nope not yet
Try ST_AsGML and ST_AsKML
P
On 3/17/08, davidj2k [EMAIL PROTECTED] wrote:
I am trying to use the AsGML and AsKML functions in PostGIS 1.3.2 I get this
error when trying to use AsGML
ERROR: XX000: Only GML 2 and GML 3 are supported
The documentations says it is defined like this
NP, the architecture is a red herring, since the reporter saw the
problem in 64-bit land and I have now seen it on two different 32-bit
compilations (OS/X (thanks for the explanation!) and Linux)
P.
On 3/17/08, William Kyngesburye [EMAIL PROTECTED] wrote:
On Mar 17, 2008, at 12:10 PM, Paul
restored from a file, is there
a simple way to update the functions in this database? I can see the
correct function in another database that was created in this version.
Paul Ramsey [EMAIL PROTECTED] wrote:
select postgis_full_version().
I am seeing it work just fine on my installation
Hard. An ERROR() geometry type is almost called for, so that you can
run the whole set and actual inspect post-facto which ones failed.
The most annoying part of the current behavior for me is the
difficulty tracking down the problematic pair of geometries. I think
you're right, the current
On 3/12/08, Martin Davis [EMAIL PROTECTED] wrote:
Orginally the idea was that it was nice to report the actual nature of
the exception, since it contains an indication of where the error
occurred. It would be nice to be able to continue to have access to
this information. One way to do
because of the topology
failures?
P
On 3/12/08, Paul Ramsey [EMAIL PROTECTED] wrote:
On 3/12/08, Martin Davis [EMAIL PROTECTED] wrote:
Orginally the idea was that it was nice to report the actual nature of
the exception, since it contains an indication of where the error
occurred
for ST_Contains(geom,geom,false)
This way, people's queries won't break or wonder why the change in their
outcomes. If they want the null behaviour, they can ask for it.
-- Kevin
On 3/12/08, Paul Ramsey [EMAIL PROTECTED] wrote:
...
This means that the return values
Nope, SQL/MM only specifies circular arcs. At this point, I'll be
happy just to get that support roughed in fully.
P
On 3/9/08, Jeshua Lacock [EMAIL PROTECTED] wrote:
Greetings,
I am wondering if bezier type paths are supported with PostGIS. The
path is comprised of segments with an
http://www.foss4g2008.org
While not open source *un*friendly (I will be talking about Mapserver
there, probably) Geoweb has no specific OSS mandate. FOSS4G, this year
in Cape Town, does.
Paul
On 3/6/08, Guido Lemoine [EMAIL PROTECTED] wrote:
Dear List,
Just saw this announcement:
The magic incantation is as follows.
+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0
+x_0=0.0 +y_0=0 +k=1.0 +units=m [EMAIL PROTECTED]
On 3/5/08, Sean Montague [EMAIL PROTECTED] wrote:
I've been trying to get Google Maps tiles into an SVG map with the viewBox
set in DD. Given that the
OS/X 10.5?
On 2/22/08, Stefan Schwarzer [EMAIL PROTECTED] wrote:
Hi there,
I wonder what is going wrong... I type the shp2pgsql command, but
there is always the help than popping up, nothing is been done:
shp2pgsql -s 4326 countries gis.countries countries.sql
RCSID:
They aren't saying they can't cross the dateline, they are saying you
can't have objects that cover more than half the sphere (any half).
It's a restriction, but not a particularly onerous one.
On 2/26/08, Robert Coup [EMAIL PROTECTED] wrote:
Noticed this today...
Sometimes the pipe operation ain't great on Windows, try doing it in two steps
shp2psql file.sql
psql -f file.sql
On 2/28/08, Intengu Technologies [EMAIL PROTECTED] wrote:
I am running Windows with Postgis 1.3.2 (installed using Appication Stack
Builder) on Postgresql 8.3 on running
Sadly, no. It was just firefighting on the existing server.
On 3/3/08, Mark Cave-Ayland [EMAIL PROTECTED] wrote:
On Monday 03 March 2008 19:50:58 Paul Ramsey wrote:
It's back, FYI, having some fun w/ servers this week.
Does that include rebuilding them so that we can use trac
On 2/21/08, Dane Springmeyer [EMAIL PROTECTED] wrote:
You are right that this addition is not essential. As I found that I
needed these tags within my geometry elements I figured out how to use
Python and the Genshi Templating engine with XPATH to insert them. I
posted a whole page with
Sorry, just need to send a test message and see where it sticks in the pipe...
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
providing a string parameter which can supply the various
options in a human-readable format?
E.g. extrude=1 tesselate=0 altitudeMode=clampToGround
Easy to read, easy to parse, easy to extend...
Paul Ramsey wrote:
I hope others are testing this out...
I have some aesthetic concerns with how you
Right, this:
select 'yes' as foo
from table1 a, table1 b
where a.gid=4
and b.gid=4
and st_intersects(a.the_geom, b.the_geom)
seems likely to a LOT less common than
select 'yes' as foo
from table1 a, table1 b
where a.gid=4
and st_intersects(a.the_geom, b.the_geom)
and the
select astext(transform(makepoint(lon,lat,4326),2922))
P
On Feb 16, 2008, at 8:12 PM, Webb Sprague wrote:
Hi all,
Is there a recipe somewhere on how to get from decimal lat/ long into
a specific SRID? I assume that I need to go from decimal to a
geometry column in the appropriate SRID, and
Shaun,
Your backyard server is building a query plan that uses an index, and
your megabuck server is not.
Now, *why* that would be, is another story. Perhaps your Sun-special
configuration is being over-optimistic about how fast a sequence scan
is? That is probably one part of your
I think your geometries have slightly different topology than your
text representations admit. I cannot reproduce your result, but then I
started from your text representations.
Do this:
update test set geometry = ST_GeomFromText('POLYGON((4506577.35665529
on the terminal, I get the
correct results.
Can this happen if one uses (GeometryFromText, SRID) instead of
(ST_GeomFromText, SRID) in an application with JDBC-Driver?
thanks,
Johannes
Paul Ramsey schrieb:
I think your geometries have slightly different topology than your
text
Hmm...
These layers have entries in geometry_columns ?
The SRIDs these layers reference in geometry_columns are in
spatial_ref_sys?
The SRIDs these layers have in geometry_columns match the SRIDs in the
geometries themselves (select distinct st_srid(geom) from thetable)?
The SRIDs these
OK, it was a bit harder than you interpreted (takes more than a SQL
cut'n'paste) and not as straightforward as I thought it might be (the
simplify function that was already there was a native implementation,
not a GEOS call, so cutting and pasting it would do no good).
Anyhow, I have
I re-named and found things began working... I am hesitant to commit
my patch though, since I know SFA about C at this point. In
particular, what bits to rename in getopt.h were not clear to me, so I
renamed every *getopt function, which may have been overkill.
P
On Dec 30, 2007, at
On 8-Feb-08, at 1:39 AM, dnrg wrote:
ESRI tells me that, at the ArcGIS Desktop release 9.3,
you'll be able to edit PostGIS data as core
functionality. No SDE required. This will open doors
and minds I hope. Paul, any comments on that?
I'll believe it when I see it. Different elements of the
) is both no. You'll always need SDE
in between., if you use SDO_GEOMETRY.
I would love to be proven wrong though in this case :-)
Best regards,
Bart
Paul Ramsey schreef:
On 8-Feb-08, at 1:39 AM, dnrg wrote:
ESRI tells me that, at the ArcGIS Desktop release 9.3,
you'll be able to edit PostGIS data
601 - 700 of 782 matches
Mail list logo
