Might not be implemented yet? Or a version issue. Are you using the
fdopostgis driver? Or the OGR driver? Or the ODBC driver?
On 8-Jun-07, at 10:18 AM, Scott, Brian wrote:
Hello friends -
We have an Enterprise MapGuide installation up and running on top
of a Postgres database.
Take that, Oracle :)
On 8-Jun-07, at 9:01 PM, Rob Agar wrote:
ValiSystem wrote:
So for a small database (few hundreds of objects), desktop/
development use i would say that any hardware would fit
very true - my dev server is a 400MHz celeron with 64M RAM.
Indexing is slow but operations
getting some additional inside into this. I for one
would like to see a multi-byte UTF8 sequence with \r embedded in it.
-Steve
Paul Ramsey wrote:
Danger, will Robinson. All values are fair game in bytes 2,3,4 of
the UTF encodings, so yes, it's possible you'll wreck multi-byte
characters
http://www.foss4g2007.org/
June 29 is the close of the Call for Presentations for FOSS4G (Free
and Open Source Software for Geospatial). If you plan on giving a 25
minute presentation at FOSS4G, make sure you get your abstract in
before the deadline!
of the world ?
b) workarounds ?
Thanks for any info ... tried trolling the website and didn't find any
caveats, but the mail list archive isn't really searchable so I am
hoping this is not a FAQ (if it is, point me at it!).
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL
to do SRID lookups to figure out if you are
geodetic or not, you can have completely different index types without
any sort of magic switches hiding in the backend, etc. Really cleans up
a lot of things.
P
Paul Ramsey wrote:
There are definitely issues with dateline and poles when working
FYI, this commit:
mleslie * r2634 /trunk/lwgeom/ (6 files):
Added a 1D rtree for polygon segment indexing, and tied the index
into the point
in polygon short-circuit of the contains, within, intersects and
disjoint
methods. Added an index cache to the comparitor methods to save index
build
Coming to FOSS4G 2007? Help us build the FOSS4G 2007 program!
http://www.foss4g2007.org/presentations/review/
We want the attendees at the Free and Open Source Software for
Geospatial (FOSS4G) conference to help us build the program, by
providing rankings of the abstract submissions.
Go
@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL PROTECTED]
Phone: 250-383-3022
Cell: 250-885-0632
___
postgis-users mailing list
postgis
@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL PROTECTED]
Phone: 250-383-3022
Cell: 250-885-0632
___
postgis-users mailing list
/postgis-users
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL PROTECTED]
Phone: 250-383-3022
Cell: 250-885-0632
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman
@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL PROTECTED]
Phone: 250-383-3022
Cell: 250-885-0632
___
postgis-users mailing list
postgis
No, I'm not suggesting that, but I am suggesting that on the non-
indexed side it is possible to break up the test feature into
multiple bounding boxes that can access the indexed side more
efficiently.
P
On 9-Jul-07, at 6:06 PM, Carl Anderson wrote:
Paul Ramsey wrote:
Perhaps you
) b.east_north
AND a.stop_reference b.stop_reference
AND c.service_id d.service_id
ORDER BY distance;
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL PROTECTED]
Phone: 250-383-3022
Cell: 250-885-0632
___
postgis-users mailing list
What is the format of your bytea? If it's the ESRI shape file
record, untranslated, you're out of luck. If it's a WKB byte array,
then use GeomFromWKB.
P
On 20-Jul-07, at 8:17 AM, Murali Maddali wrote:
Hello All,
Can any one tell what I am doing wrong with the following select.
select
?
Kind regards,
Mark.
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL PROTECTED]
Phone: 250-383-3022
Cell: 250-885-0632
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net
.
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL PROTECTED]
Phone: 250-383-3022
Cell: 250-885-0632
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis
users to
customize and print these maps.
http://geofred.stlouisfed.org/
http://geofred.stlouisfed.org/help.php
Federal Reserve Bank of St. Louis
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL PROTECTED]
Phone: 250-383-3022
Cell: 250-885-0632
Only as source right now:
http://svn.osgeo.org/fdo/trunk/Providers/PostGIS/
Intengu Technologies wrote:
Saw this post on an interview with Paul Ramsey Tyler Mitchell
http://www.directionsmag.com/article.php?article_id=2517trv=1
http://www.directionsmag.com/article.php?article_id=2517trv=1
)
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL PROTECTED]
Phone: 250-383-3022
Cell: 250-885-0632
uDig: http://udig.refractions.net
QGIS: http://www.qgis.org
gvSIG: http://www.gvsig.gva.es/
On 11-Aug-07, at 2:28 AM, Thorsten Kraus wrote:
Hi all,
what software tools do you use to view geometric data stored in
PostGIS? I search a tool which directly connects to the PostGIS
database and
certainly ease administration :).
On 8/11/07, Paul Ramsey [EMAIL PROTECTED] wrote:
In what respect do you find that postgis doesn't support multiple
schemas? We generally install postgis in 'public.' and create lots
http://postgis.refractions.net/pipermail/postgis-users/2006-January/
010602.html
new databases (likely) or also help spatial queries
from other databases (not likely, but if so, how is this
inter-database querying happening)?
jzs
On 8/13/07, Paul Ramsey [EMAIL PROTECTED] wrote:
Correct, that's how most do it. dblink is an option, but I have no
experience to share on that. Just
Thanks, fixed
On 17-Aug-07, at 8:44 AM, Mateusz Loskot wrote:
Hi,
I suppose name of the archived directory in the package
with latest sources has wrong name:
[EMAIL PROTECTED]:~/src$ tar -zxf postgis-1.3.1.tar.gz
[EMAIL PROTECTED]:~/src$ ls
postgis-1.3.1.tar.gz postgis-cvs
Cheers
--
Mateusz
2007 Free and Open Source Software for Geospatial (FOSS4G) Conference
September 24-27, Victoria, British Columbia
Register and make your travel plans now! On August 23rd, our hotel
room blocks will be released, and we will no longer have discounted
rooms available to delegates. Remember,
Figure out which geometry is the problem one so (a) you can work
around it and (b) you can attach it to a bug report and (c) we can
eventually fix it.
Worst case scenario, binary search by repeatedly cutting your input
data set in half.
P
On 28-Aug-07, at 5:16 AM, Andreas Laggner wrote:
Indeed:
SELECT *
FROM mytable
WHERE
ST_DWithin(mytable.the_geom, ST_SetSRID(MakePoint($x, $y), $srid),
$distance);
P.
On 9-Sep-07, at 11:25 AM, Shane Spencer wrote:
I don't understand how the Distance() and Intersects() and Contains
() function wouldn't work for this?
Are X and Y
/interactive/functions-admin.html.
ATB,
Mark.
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL PROTECTED]
Phone: 250-383-3022
Cell: 250-885-0632
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http
in advance!
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL PROTECTED]
Phone: 250-383-3022
Cell: 250-885-0632
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net
SELECT m.name from transport m, rivers r where ST_Intersects
(m.the_geom, r.the_geom);
On 15-Sep-07, at 8:03 AM, Dave Potts wrote:
I am trying to discover all the data points when a river system
crosses a road system, my data is expressed as two different
shapefiles, I had assumed that
that casts from Box* to GEOMETRY.
PostgreSQL does automatic casting, so
Extent(GEOMETRY) return BOX*
Centroid(GEOMETRY) returns GEOMETRY
PostgreSQL will rewrite Centroid(Extent()) to Centroid(Box2Geom(Extent())
P.
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL
Calculating the bbox for points on the fly has zero cost, so that's
what we do instead of wasting space duplicating the ordinates a
second time.
P.
On 20-Sep-07, at 6:43 AM, Stephen Crawford wrote:
I have a db with a few million points. I noticed that hasbbox
(the_geom) =
false for
PostGIS/PostGres allow for such spatial indexing of images?
Images from Source - Disk Archive - Insert metadata record into
PostGIS - use TILEINDEX in Mapserver to reference particular images -
web map etc.
Paul
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL
the pros and cons? or all cons ;)
On Oct 2, 2007, at 1:45 PM, Paul Ramsey wrote:
Those of you still breathless at the opportunity to store your images
in the database entirely (fools!) feel free to review Xing Lin's work
in this branch. It's good work, though obviously I have religious
You probably want to do it within a tolerance, using ST_DWithin...
select points.*,lines.id from points, lines where ST_DWithin
(points.the_geom, lines.the_geom, 0.01);
P
On 6-Oct-07, at 5:11 PM, temiz wrote:
hello
I have point geometry table and a line geometry table.
how can I query
/lwgeom/liblwgeom.so.1.3: libgeos_c.so.1: cannot
open shared object file: No such file or directory
--
Paul Ramsey
Refractions Research
http://www.refractions.net
[EMAIL PROTECTED]
Phone: 250-383-3022
Cell: 250-885-0632
___
postgis-users
Yes and no... simplify() shouldn't crash on it, it should notify on
it at worst... can you submit it?
On 16-Oct-07, at 7:18 AM, ivan minčík wrote:
I isolated wrong geometry and I have fount that it is not valid
polygon. So that should be the problem.
Paul Ramsey wrote:
Where I used
Clustering rears its ugly head again...
http://en.wikipedia.org/wiki/Cluster_analysis
On 16-Oct-07, at 2:48 PM, Stephen Woodbridge wrote:
Michael Welter wrote:
Is there an algorithm to divide a group of points into n
distinct groups?
A locus is a set of points satisfying a certain
ST_Overlaps has a very particular meaning (partly in, partly out). Do
you mean ST_Intersects (which is equivalent to NOT ST_Disjoint()) ?
P
On 17-Oct-07, at 7:01 AM, Jørn Vegard Røsnes wrote:
Hi,
I have just upgraded my database with the following
PostgreSQL 8.1.1 on i686-pc-linux-gnu,
ST_Distance_Sphere and ST_Distance_Spheroid return in meters, not
kilometers, so they think the distance is about 495km. What makes
you so sure that's wrong? I checked in a transformed projection and
got a similar result also.
On 18-Oct-07, at 7:19 AM, [EMAIL PROTECTED] wrote:
id |
select p.*
from pandatestdata p, world2_12nm w
where not st_contains(w.the_geom, p.the_geom);
On 24-Oct-07, at 11:45 AM, Richard Heimann [C] wrote:
Thanks for your response W. I should have posted the sql query
earlier.
Anyway...its below.
My goal is to drop all features (points) that fall
of features by eight
times. Any
thoughts?
Vr
Rich
-Original Message-
From: Paul Ramsey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 24, 2007 4:07 PM
To: [EMAIL PROTECTED]; PostGIS Users Discussion
Subject: Re: [postgis-users] ST_Difference
select p.*
from pandatestdata p, world2_12nm w
On the flip side, if the number of bad points of ships-on-land is
small, the stripping operation is probably faster than the positive
containment test on all the ships-in-water points.
P
On 24-Oct-07, at 2:01 PM, Paul Ramsey wrote:
Oh, yeah, oops, I know. It's the join logic, its finding
pandatestdata p LEFT JOIN world2_12nm w On st_contains
(w.the_geom, p.the_geom)
WHERE w.id IS NULL
Here I am assuing w.id is the id of world2_12nm
From: [EMAIL PROTECTED] on behalf of
Paul Ramsey
Sent: Wed 10/24/2007 5:01 PM
To: [EMAIL PROTECTED]
Cc: 'PostGIS Users Discussion'
Subject: Re
potentially a slow one, in the worst case scenario.
P
On 24-Oct-07, at 4:22 PM, Paul Ramsey wrote:
OK, ugly query in a different way:
select pd.* from pandatestdata pd,
where pd.id not in (select p.id
from pandatestdata p, world2_12nm w
where st_contains(w.the_geom, p.the_geom));
I like
Yes, that is all the magic there is to the distance is faster
assertion. Obviously it's only faster for cases where there are lots
of fully contained candidates that return immediately on the first
point test.
P
On 25-Oct-07, at 4:24 AM, Obe, Regina wrote:
Am I safe in saying that
Well, I've spent several fruitless hours trying to upgrade us to a
more recent spam-resistant version of phpbt, and I hereby declare
failure. The new version may well be more spam resistant, but it's
also entirely PostgreSQL resistant -- it seems quite dependent on a
MySQL group by syntax
Well, you have to build the cartesian product of every city
combination and then measure every distance in that virtual table, so
it's not going to scale well at all as the input table gets bigger.
However, if you know the maximum minimum distance (?mmd?) you can
add a spatial constraint
? And is mmd a thing which has to do with PostGis ?
On 11/4/07, Paul Ramsey [EMAIL PROTECTED] wrote:
Well, you have to build the cartesian product of every city
combination and then measure every distance in that virtual table, so
it's not going to scale well at all as the input table gets bigger
Lee, what are you going to do with this beast once you have created it?
P
On 6-Nov-07, at 10:41 AM, Lee Keel wrote:
Hello list.
I am trying to get a multipolygon from a union of buffered
linestrings. See attached (bad_drawing.jpg) to see what I am
trying to achieve. I have some
-
[EMAIL PROTECTED] On Behalf Of Paul Ramsey
Sent: Tuesday, November 06, 2007 4:55 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] GEOS union() error
Lee, what are you going to do with this beast once you have
created it?
P
On 6-Nov-07, at 10:41 AM, Lee Keel wrote:
Paul,
My
You're not testing the speed of the data sources, you're testing the
speed of the geometry processing (that Intersection() and Intersects
() ).
There should not be significant differences between the JUMP/Kosmo
geometry processing and PostGIS, since they are the same algorithmic
base.
as well.
3) BTW, how many users a single postgres database instance (say on a
2GHz Pentium 2GB memory system) can handle?
This depends entirely on what they are doing, so an answer is not
possible with this much information.
P.
--
Paul Ramsey
Refractions Research
http://www.refractions.net
. For now we use PostGIS and SQL Server 2005 next
to each other in our organization.Spatial support looks promising
but I don't know if it's worth to take the SQL 2008-spatial support in
account.
(read: if the price tag will justify SQL server above PostGIS).
Cheers
Steven
--
Paul Ramsey
1.3.2 is on the streets.
http://postgis.refractions.net/news/20071201/
Kudos to Mark for seeing this one through!
P
On 2-Dec-07, at 12:40 PM, Mark Cave-Ayland wrote:
On Fri, 2007-11-30 at 10:20 -0800, Paul Ramsey wrote:
Say the word and I'll pull the pin.
P
Righto, have just committed
At this point I would be more interested in changing the behavior of
SIS than changing the behavior of PostGIS. OIDs are deprecated so we
should not be moving to *improve* our support of them at this late
date. SIS can follow the lead of Mapserver, and uDig and look for a
defined primary
Done
On 6-Dec-07, at 12:43 PM, Devrim GÜNDÜZ wrote:
Hi,
On Thu, 2007-12-06 at 15:33 -0500, Normand Savard wrote:
The tarball of Postgis 1.3.2 found on
http://postgis.refractions.net/download/ when extracted has is root
directory named postgis-cvs instead of postgis-1.3.2. Other tarballs
There appears to be a mismatch between the .sql file you are using
and the .so file it's linking to. Check their dates. All else fails,
just delete the coveredby definition from the .sql file if you're in
a hurry.
P
On 10-Dec-07, at 9:40 AM, Alex Turner wrote:
I am installing PostGIS
Richard,
Move the data directory to a new device, and then in
postgresql.conf, alter the location of the default data space to that
location.
P
On 13-Dec-07, at 7:37 AM, Richard Heimann [C] wrote:
This question is more to do with PostgreSQL then PostGIS but I’ve
always gotten good
Try without the constraints... just a guess, but it might be the
combination of the index and the unique constraint on geometry.
On 13-Dec-07, at 8:14 AM, Kyle Wilcox wrote:
I am having trouble creating a GiST index on a MULTIPOLYGON column.
When the table is empty, the indexes will be
pggis 1.3+
select t.*
from region_polygons r, geom_table t
where
st_contains(r.rpg_geom,t.geom_fld)
and
rpg_name = 'GVRD_OLD'
pgis 1.3
select t.*
from region_polygons r, geom_table t
where
r.rpg_geom t.geom_fld
and
contains(r.rpg_geom,t.geom_fld)
and
rpg_name = 'GVRD_OLD'
On
Darrell,
Pare down the script to just the three entries that create the _in
and _out functions and the type and send the output from that...
Seems very odd to me.
P
On 2-Jan-08, at 9:49 PM, Darrell Sher wrote:
Issue:
When I run the lwpostgis.sql script it fails when creating the
What happens when you reverse the order in the SQL script and do the
spheroid ones first?
On 3-Jan-08, at 11:23 AM, Darrell Sher wrote:
test.zip
___
postgis-users mailing list
postgis-users@postgis.refractions.net
Permission problems and encoding problems are quite separate, so let's
examine the first problem first. Your first error is the permission
problem. What happens when you log in as yourself with psql and try to
insert a column into geometry_columns? Hopefully it should fail, since
that's
ST_Area(ST_Intersection(g1,g2)) ?
On Jan 10, 2008, at 8:23 AM, [EMAIL PROTECTED] wrote:
Yes, but how do you calculate the area of the intersection ?
Olivier.
Selon Guido Lemoine [EMAIL PROTECTED]:
Your multipolygon is simply two rings of 3 by 3. Defining them
as multipolygon does do
))'))) -- 4 (QED)
SELECT ST_Area(ST_Union(GeomFromText('Polygon((0 0,0 3,3 3,3 0,0
0))'),
GeomFromText('Polygon((1 1,1 4,4 4,4 1,1 1))'))) -- 14
Paul Ramsey wrote:
ST_Area(ST_Intersection(g1,g2)) ?
On Jan 10, 2008, at 8:23 AM, [EMAIL PROTECTED] wrote:
Yes, but how do you calculate the area
I just confirmed this behavior. true/true on geos 2.2 true/false on
geos 3.0.
Please file this at http://trac.osgeo.org/geos, it's real, and it's
not right.
P
On Jan 17, 2008, at 7:35 PM, KXK wrote:
SELECT
ST_Contains(
GeomFromText('POLYGON((0 0,0 10,10 10,10 0,0 0))', -1),
.
Paul
On Jan 18, 2008, at 11:17 AM, Clay, Bruce wrote:
Paul:
Can you briefly explain how Centos differs from Fedora when it comes
to using PostgreSql and PostGis?
Bruce
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Paul
Ramsey
Sent: Friday, January
Your original data is probably not 4326. Do you have any clue what
projection it is in? Where did you get it from?
P
On Jan 20, 2008, at 7:02 PM, Sam Boggess wrote:
Hello,
I'm new to PostGIS and this has to be a cakewalk for
you experienced users, but your help would be greatly
Geographic Coordinates, Longitude / Latitude, Unprojected ?
P.
On Jan 20, 2008, at 8:07 PM, Sam Boggess wrote:
Thank you so much! I'll try transforming it at the shp2pgsql stage.
In ArcMap does 4326 have a name? I can't find it?
Paul Ramsey wrote:
Mercator EPSG:4326
4326
On Jan 23, 2008, at 3:39 AM, Peter Hopfgartner wrote:
we were looking at the tables generated by shp2pgsql. As it seems,
numeric(m, 0) is mapped, if possible to integers, and numeric(m,n)
is mapped to numeric.
Do you mean, mapped to float?
We would like to optionally maintain the numeric
The index-caching trick appears to be on both ST_Within and
ST_Contains. It was added to the code at 1.3.0.
P
On 23-Jan-08, at 2:26 PM, Martin Davis wrote:
Some thoughts:
- ST_Distance is likely to be slow, since it does not do any
optimizations
- ST_Within was recently optimized to
Or the more succinct and modern
SELECT the_geom, zone
FROM r_zones
WHERE
ST_Contains(the_geom,GeomFromText('POINT(7644373.465626
687692.342075)', 2838));
On 25-Jan-08, at 8:14 PM, Stephen Woodbridge wrote:
Try:
SELECT the_geom, zone
FROM r_zones
WHERE
I'd love to see some people here with large data volumes who do
contains/intersects/within tests do some testing of the new postgis/
geos prepared geometry code...
To test the new functions
- install the svn snapshot of GEOS
- install the svn snapshot of PostGIS
- use the
I don't know, try and tell us! :)
P
On Jan 25, 2008, at 7:58 PM, Bruce Rindahl wrote:
Does the SVN of GEOS compile under MingW??
Bruce
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Paul
Ramsey
Sent: Friday, January 25, 2008 11:46 AM
To: PostGIS
On Jan 28, 2008, at 4:56 AM, Olivier Tournaire wrote:
1. As far as I know, PostGIS is ale to store 3D data. Am I right ?
It can store z-variants of point, line, polygon, multipoint,
multiline, multipolygon.
2. If I create a spatial index on a table which contains 3D
geometries, is it a
On Jan 28, 2008, at 9:35 AM, Olivier Tournaire wrote:
Thanks Paul and Ben for your answers.
Z-values are ignored in tests, and occasionally used in building
resultants for things like intersections.
Is it possible to know which things ?
Intersection. I intersect two lines that have Z
but
I am getting compile errors on the SVN snapshot given in the link
below.
Can I test the performance upgrades using the 3.0.0 version or do I
need to
get the SVN version working?
Bruce
-Original Message-
From: Paul Ramsey [mailto:[EMAIL PROTECTED]
Sent: Monday, January 28, 2008 11:37
PROTECTED] On Behalf Of
Paul
Ramsey
Sent: Wednesday, January 30, 2008 9:59 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Problems while
loadinglwpostgis.sql...Pleaseprovide your inputs / help
This is certainly an environment problem, not a software problem...
You have confirmed
In true ESRI form, they re-named something generic because it was
GIS, so it needed a different name.
Tasks == Web services
What ESRI has done that has not been done in the OSS world is
standardize the bindings for their web services so their clients can
discover and consume them on the
The magic upgrade path...
1 - Compile and install PgSQL 8.3 and latest PostGIS.
2 - Inspect your old PgSQL / PostGIS installation. Find out what
versions of liblwgeom you have. In your new installation, create
symlinks so that the old files appear to exist in the new installation.
3 - Dump
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
Indeed, it looks like there was a form of low-level time support that
must have been built in the academic research days... it only
survived into the 6.X series:
http://www.postgresql.org/docs/6.3/static/c0503.htm
As the page notes, you can do historical information storage with
triggers
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
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 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
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
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
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
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
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
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:
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
1 - 100 of 782 matches
Mail list logo