happens.
P.
On Wed, Jan 28, 2009 at 4:40 PM, Mark Cave-Ayland
mark.cave-ayl...@siriusit.co.uk wrote:
Paul Ramsey wrote:
I would like to add a function that takes an anonymous
GEOMETRYCOLLECTION and returns something more structured:
- a GEOMETRYCOLLECTION where the first element
select st_area(the_geom) from onb;
You *cannot* use the visibility/non-visibility of fields in PgAdmin as
any indicator of the presence/absence of geometry data in the record,
because PgAdmin tosses things that are too long to display and *many*
geometries fall into that category.
On Mon, Jan
On Mon, Jan 26, 2009 at 3:54 PM, Paragon Corporation l...@pcorp.us wrote:
Though if you want to maintain borders I guess you would probably want to
1) convert your polygons to linestrings using ST_Boundary,
2) dump out into edges and grouping by the gid
3) Simplify and then repolygonize.
It
Setting an environment variable should do the trick, but a commandline
option would be an improvement
Sent from my iPod
On 25-Jan-09, at 10:33 AM, Stephen Woodbridge
wood...@swoodbridge.com wrote:
Hi all,
I tend to keep all my databases in UTF8, and I just had an occasion
where I
Upgrade to 1.3.5, it looks like you are doing point-in-polygon
intersects, and there were some massive leaks there that I fixed in
later revisions.
P.
On Wed, Jan 21, 2009 at 3:15 PM, Reid Priedhorsky r...@umn.edu wrote:
Dear all,
I have a fairly simple (or so I thought) PostGIS query which
st_is_registered_spatial_column() is an ESRI function, best ask at an
ESRI forum.
P
On Wed, Jan 14, 2009 at 1:03 AM, P Adji yo...@hotmail.com wrote:
dear all,
ive been messing around with Arcsde + postgre 8.3.0 and postgis 1.3.2. After
i ran a command select
SELECT o.name, o.id, s.name
FROM offenders o, schools s
WHERE ST_DWithing(o.the_geom, s.the_geom, 500)
AND o.status = 'TRUE';
On Tue, Jan 13, 2009 at 7:56 AM, chris brisendine cbriz...@gmail.com wrote:
I am trying to do a query where I have two point tables one is
offenders and the other is
Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Paul Ramsey
OpenGeo - http://opengeo.org
Community members,
Reminder, there is a Code Sprint event occurring this spring that
members of the C tribe of open source GIS projects might be
interested in attending.
http://wiki.osgeo.org/wiki/Toronto_Code_Sprint_2009
We have space for only about five more attendees, and a couple more
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Paul Ramsey
pram...@cleverelephant.ca
+1 250 885 0632
___
postgis-users
I just tried to load up the geometry portion of the problem only, and
I am *not* seeing the same effect. Does the geometry-only part of the
query also exhibit the long query time for you?
select count(*) from gdors_geography g1, gdors_geography g2 where
st_intersects(g1.the_geom, g2.the_geom)
old SQL*Net clients.
P.
On Jan 8, 2009, at 10:30 AM, Stephen Carville wrote:
On Wednesday 07 January 2009 15:34, Paul Ramsey wrote:
Fastest way to migrate: drop a couple thousand bucks on an FME
license
and run it once. :) If you understand Oracle Spatial, you understand
PostGIS, conceptually
/listinfo/postgis-users
--
Paul Ramsey
OpenGeo - http://opengeo.org
The secret sauce is called... PostGIS.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Another option is ogr2ogr http://www.gdal.org/ogr/ which should
allow you to do flat table transfers.
P.
On Jan 8, 2009, at 10:30 AM, Stephen Carville wrote:
On Wednesday 07 January 2009 15:34, Paul Ramsey wrote:
Fastest way to migrate: drop a couple thousand bucks on an FME
license
Fastest way to migrate: drop a couple thousand bucks on an FME license
and run it once. :) If you understand Oracle Spatial, you understand
PostGIS, conceptually. Just a few function names different. The
drudgery of a migration though, that's something FME can cure.
P.
On Wed, Jan 7, 2009 at
Indeed. If I test the distance of your derived point from the original
line, it is:
5.82594422389951e-15
We only have 64 bits of precision to work with (less, really, since
the exponent and sign take up space) in a double, so the derived point
will not be on the original line, in a mathematical
I don't have facts on the ground, just surmise: large objects likely
refers to BLOBs, which PostGIS objects are *not* (though PostGIS
objects are large, they are large in a confusing, different way than
BLOBs). Slony should work for PostGIS.
P.
On Mon, Dec 22, 2008 at 7:14 AM, Peter N.
Totally up to you... depends on how it fits your application. It's not
a bad design pattern, by any means, and it does provide guaranteed
performance, assuming your data doesn't change too much.
What are you doing this distance calculation set in aid of?
P
On Mon, Dec 22, 2008 at 8:52 AM,
Yeah, north polar stereographic, not an optimal choice for Brazil :)
P
On Wed, Dec 17, 2008 at 12:53 PM, David William Bitner
david.bit...@gmail.com wrote:
How did you chose to use 32661? You should use an SRID that uses a
projection that works well for the area that you are working in.
On
:\tmp\AbaloneClosures2.sql
Based on the error message, the table hm_vect.abaloneclosures2 seemed
created. However, it is not.
Your input on the problem would be much appreciated!
Thanks
John
Date: Sat, 13 Dec 2008 16:36:00 -0800
From: Paul Ramsey pram...@cleverelephant.ca
Subject: Re
:36:00 -0800
From: Paul Ramsey pram...@cleverelephant.ca
Subject: Re: [postgis-users] Problem loading shape data
To: PostGIS Users Discussion postgis-users@postgis.refractions.net
Message-ID:
30fe546d0812131636v212853d8wa3422f29f4e14...@mail.gmail.com
Content-Type: text/plain; charset
The 1.3.5 release of PostGIS is available. I am cross-posting to
Mapserver because of the particular interest for that community in
this release.
This release fixes a minor change in 1.3.4 that caused and Mapserver
LINE layer to start crashing PostGIS. If you are using Mapserver and
PostGIS, do
Yes, Peter, I think it should call for a quick 1.3.5. Mapserver users
are a huge contingent of PostGIS users, and anyone with a LINE layer
now has a crasher. 1.3.5 should come off the line ASAP. There's always
more version numbers, IMO.
Can we have a quick vote on 1.3.5 release-from-branch,
Stop thinking lines and start thinking endpoints. If you convert your
lines into a set of start/end points then group on x/y you'll end up
an aggregation which defines your sets of road intersections.
If you want until Monday, I bet Kevin or Regina will drop full SQL
into your lap. I'm too lazy
You have to scroll up in the window until you can see what the
*actual* error is... increase your command terminal scroll buffers to
5000 then re-run and scroll up to the first error message.
On Fri, Dec 12, 2008 at 3:17 PM, John Zhang johnzhan...@gmail.com wrote:
Hi there,
I used shp2pgsql
Sorry Greg, it's manual, so variation is seeping in. Another reason to
bring the scripted packaging system back up to snuff.
P
On Wed, Dec 10, 2008 at 3:34 PM, Greg Troxel [EMAIL PROTECTED] wrote:
I am updating postgis to 1.3.4 (from 1.3.3) in pkgsrc. It seems the
names of installed docs have
add
wkb_geometry SetSRID('BOX3D(-162 55,-161 56)'::box3d,4326)
to your where clause to engage the index.
P
On Fri, Dec 5, 2008 at 10:26 AM, William Kyngesburye
[EMAIL PROTECTED] wrote:
On Dec 5, 2008, at 11:22 AM, Martin Davis wrote:
Good news! I thought about this some more overnight,
It's very much a client side issue, not a PostGIS issue. Ask the
QGIS/gvSIG/uDig folks how they support your use case.
P.
On Fri, Nov 28, 2008 at 8:12 AM, ju [EMAIL PROTECTED] wrote:
thanks but my table contains data for 1500 geographical place we are going
to digitize
some will be point,
Try including one non-spatial field in the table you dump.
P
On Thu, Nov 27, 2008 at 11:33 AM, Travis Kirstine
[EMAIL PROTECTED] wrote:
I'm having some problems with shapefiles dumped out of postgis using
the pgsql2shp utility. I am creating a geometry union using the
upgis_cascadeunion
Tell the QGIS developers to expand their notion of an int to 11
digits. The whole problem is the mismatch between formal typing in
C/C++ (integer, float, double) and the typing used in DBF headers
(number(n,m)). QGIS interprets anything over 10 digits as float so
that it doesn't accidentally bust
Probably your multipolygons are merging into a proper polygon.
INSERT INTO county (polygon_nm, the_geom) VALUES ('X',
st_multi(st_union((select the_geom from county where polygon_nm='LAKE'), (select
the_geom from county where polygon_nm='COOK'
Yes, st_union can operate as an aggregate.
I have fixed the regression failure on pre-8.2 pgsql, which was
unrelated to PostGIS, just the use of SELECT FROM VALUES that I used
in the regress_ogc_prep.sql file, and was not supported in earlier
versions.
P.
On Mon, Nov 24, 2008 at 3:23 AM, Mark Cave-Ayland
[EMAIL PROTECTED] wrote:
Peter
Excellent timing, I just pushed to release.
An issue for 1.3.5 :)
P
On Mon, Nov 24, 2008 at 9:09 PM, Stephen Davies [EMAIL PROTECTED] wrote:
I have just built 1.3.4rc3 and run the regression tests.
Test 17 failed with:
PostgreSQL 8.3.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.1
to GeoJSON format within the database. (Olivier Courtin)
- Add forthcoming PostgreSQL 8.4 support
(Paul Ramsey, Mark Cave-Ayland)
- Improved CSS for PostGIS documentation (Dane Springmeyer)
- Inclusion of new postgis_comments.sql file to enable detailed
function comments to be installed
Tim, what did the diff file look like?
tmp/pgis_reg_15519/test_38_diff
P
On Fri, Nov 21, 2008 at 5:50 AM, Tim Bowden [EMAIL PROTECTED] wrote:
On Fri, 2008-11-21 at 12:25 +, Mark Cave-Ayland wrote:
Tim Bowden wrote:
On Fri, 2008-11-21 at 00:42 +0900, Tim Bowden wrote:
Debian etch,
If you re-run ./autogen yourself, do things get better?
P
On Thu, Nov 13, 2008 at 9:33 AM, Kevin Neufeld [EMAIL PROTECTED] wrote:
I'm trying to compile it with PostgreSQL 8.2.4 with no luck.
I did this (configure and make had no errors):
./configure --with-pgsql=/opt/pgsql-test/bin/pg_config
Important information for PostGIS users! If you are on the PostgreSQL
8.3 series, upgrade to 8.3.5 as soon as possible, as earlier releases
contain a GiST index bug which may cause data to occasionally not show
up in spatially indexed searches.
This bug will only affect tables that have had
Did you upgrade an existing database? Create a fresh one and load
postgis and then see if it works. The SQL signatures in old databases
don't get updated when you update the dll/so underneath.
P
On Fri, Oct 31, 2008 at 9:54 AM, lisek lichu [EMAIL PROTECTED] wrote:
Hello,
For last week i
uDig doesn't checkin/checkout, it works directly on the records one at time.
P.
On Fri, Oct 31, 2008 at 9:58 AM, Sufficool, Stanley
[EMAIL PROTECTED] wrote:
So far all the tools I have worked with (OpenJUMP, uDIG) use a check out,
check in process on PostGIS to update geometries. This is
Either you are working on an old database with the new library
underneath, or you accidentally loaded the old lwpostgis.sql file into
a new database. Go back and review your install procedure, you'll find
the problem there.
P.
On Fri, Oct 31, 2008 at 12:08 PM, lisek lichu [EMAIL PROTECTED]
We continue to inch closer to a 1.3.4 release. Please compile and test
1.3.4rc2, available from
http://postgis.refractions.net/download/postgis-1.3.4rc2.tar.gz
Thanks!
Paul
___
postgis-users mailing list
postgis-users@postgis.refractions.net
Wouldn't the ratio of area to perimeter be a similar metric? Also,
wouldn't it be easier to just stop letting politicians draw their own
boundaries? :)
I wonder what the algorithm for minimum enclosing circle is...
(Short answer, no, because we don't have a min-circle routine.)
P.
On Fri, Oct
It's an inscribed circle? I thought it was a containing one.
P.
On Fri, Oct 24, 2008 at 12:50 PM, Lee Meilleur [EMAIL PROTECTED] wrote:
The area of the convex hull is actually larger than the area of the polygon,
so the ratio ends up being greater than 1. With the Roeck test, the ratio
This should be fixed when 1.3.4 comes out. An rc2 will be out tomorrow
you can try.
P.
On Tue, Oct 21, 2008 at 3:28 PM, John Zhang [EMAIL PROTECTED] wrote:
Hello list,
I am writing to seek your input on how to handle such an issue:
I have a large table containing over 3 million polygons and
There's a contains bug in GEOS 3.0.0
We need to cut 3.0.1
P
On Wed, Oct 15, 2008 at 9:23 AM, Fred Lehodey [EMAIL PROTECTED] wrote:
Hi,
I have the same results as David: (false)
postgis_full_version():
POSTGIS=1.3.3 GEOS=3.0.0-CAPI-1.4.1 PROJ=Rel. 4.6.0, 21 Dec 2007
USE_STATS
Fred.
On
I'm pleased to report, GEOS 3.0.1 is available:
http://download.osgeo.org/geos/geos-3.0.1.tar.bz2
This removes a contains bug that has been reported here a couple time recently.
P.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
Got it, sorry, fell into gaps. Applied now.
(BTW, unified diff (-u) is preferred, if possible in future.)
On Tue, Oct 14, 2008 at 1:45 AM, Mark Cave-Ayland
[EMAIL PROTECTED] wrote:
Paul Ramsey wrote:
1.3.4 is very close to release, but we can release it faster, with
less intestinal distress
If you're in a planar projection, then
select * from footable where st_dwithin(the_geom, 'POINT(foo bar)', DISTANCE)
will return based on an indexed search for arbitrary foo and bar. You
need to be in a planar projection so the spatial index works in the
same cartesian domain as the distance
:
CREATE INDEX mygeoidx ON mytable USING GIST (mygeocolumn);
Paul
On Tue, Oct 14, 2008 at 6:43 PM, Stephen Baillie
[EMAIL PROTECTED] wrote:
Paul Ramsey wrote:
If you're in a planar projection, then
select * from footable where st_dwithin(the_geom, 'POINT(foo bar)',
DISTANCE)
will return based
1.3.4 is very close to release, but we can release it faster, with
less intestinal distress, if we get some solid pre-release testing
from folks. You can download the current SVN version directly from the
downloads page, no SVN client required:
Try removing the table from qgis and re-adding it. And don't forget to
change the SRID value in GEOMETRY_COLUMNS before you do. I think
you're altering the coordinates underneath QGIS's understanding of
that they are (it things it has a 4326 table, and boom, you turn it
into something else).
P.
I'm not seeing this problem on your polygon. What does
select postgis_full_version()
say?
On Thu, Oct 9, 2008 at 7:56 PM, [EMAIL PROTECTED] wrote:
Hi All,
In debugging the problem below, I found that TRANSFORM would fail with some
of my city multipolygons.
I would think that the
It ran without any error. But some of the resulted values in the_geom
column became null or empty.
How did you check this?
select gid from thetable where the_geom is null?
select gid from thetabel where npoints(the_geom) =
P
___
postgis-users
,
the_geom was not NULL.
The sql below returns nothing:
select gid, the_geom from city where the_geom is null;
The sql below returns npoints = 218:
select gid, npoints(the_geom) from city where polygon_id=35665106;
Thanks,
CYW
- Original Message - From: Paul Ramsey [EMAIL
Are you suggesting doing something like
PostGIS = WFS Server = Conterra WFS Editor = ArcMap?
Wouldn't using the new SDE-on-PostGIS functionality from ESRI be a
little more direct?
Paul
On Wed, Oct 8, 2008 at 12:59 PM, [EMAIL PROTECTED] wrote:
Is anyone using the Conterra.de wfsEditor with
PostGIS 3D more powerful (e.g. uDig for 3D
or OpenJump for 3D or OpenLayers for 3D?)
Thanks,
Regina
From: [EMAIL PROTECTED] on behalf of Paul Ramsey
Sent: Tue 10/7/2008 12:30 PM
To: PostGIS Development Discussion
Subject: Re: [postgis-devel] Dropped DM
I think we all buy that. File it.
P
On Mon, Sep 29, 2008 at 4:48 PM, Charlie Savage [EMAIL PROTECTED] wrote:
So - do we have agreement that NULL's should be ignored in functions that
act on aggregates?
To recap:
* NULL values cause functions such as ST_UNION to return NULL
* This is
Use 26910.
The reference you chose is for the southern hemisphere (hence the S).
P
On Mon, Sep 29, 2008 at 7:55 PM, Oliver Monson [EMAIL PROTECTED] wrote:
Hi All,
I'm not sure if I'm seeing some random bug, or just not doing/understanding
something correctly?
I have a list of point
There's sort of a grey area between RDBMS and spatial semantics
if A = B does st_equals(A,B) ?
same thing with null and GEOMETRY EMPTY, there is similarity but the
ideas are not identical
I would expect A = B to return false if SRIDs are not the same, but
ST_Equals(A,B) to error out if
That's deeply odd, and worth investigating. Can you try 8.3+1.3.3, so
we can eliminate the PostGIS version as a variable first? Then I'll
see if I can duplicate the result on my system.
P.
On Sat, Sep 27, 2008 at 12:59 PM, David Vaz [EMAIL PROTECTED] wrote:
Hi,
I am a debian user, several
tried again, given that debian testing
already had postgis packages, but the speed was the same.
Paul Ramsey wrote:
That's deeply odd, and worth investigating. Can you try 8.3+1.3.3, so
we can eliminate the PostGIS version as a variable first? Then I'll
see if I can duplicate the result on my
You don't need iconv, you can use the -W flag in shp2pgsql:
shp2pgsql -W LATIN1 -s 4366 -D foo.shp foo
If you're in a western country, your encoding is likely either LATIN1
or WIN1252 (they are almost identical, the WIN one has some Windows
special characters in it).
Here's the list of
PostGIS supports neither the creation nor the storage of TINs.
The latter (storage) is easier than the former, and there is a patch
extant which supplied and X3D mesh type, but it just creates one big
serialized mesh object, and I have a hard time reconciling that to the
real use-case needs of
To what end? You can certainly insert the whole kit'n'kaboodle as a
bytea, if you like.
On Thu, Sep 18, 2008 at 3:54 PM, Nandorov [EMAIL PROTECTED] wrote:
Hi,
I wonder if is posible to save a dwg file into a PostGIS database. not
converting the dwg data in a lot of registers but saving the
SELECT gid FROM the_table WHERE NOT ST_IsValid(the_geom);
On Tue, Sep 16, 2008 at 10:55 AM, Reid Priedhorsky [EMAIL PROTECTED] wrote:
Dear all,
PostGIS is failing on one of my tables with the following in the logs:
2008-09-16 01:27:31 CDT NOTICE: TopologyException: side location conflict
They pre-date the transformation functionality, and were never
upgraded when it was added. Realistically, they could/should look at
the SRID. Or, they could just have hardcoded sphere/spheroids, since
everyone uses WGS84 anyways.
P.
On Tue, Sep 9, 2008 at 5:55 AM, Willy-Bas Loos [EMAIL
Your syntax looks right, all that's missing is whether the def'n for
102010 you are using matching your input coordinates, which we can't
tell, since we don't know what you're using for 102010.
P
On Fri, Sep 5, 2008 at 11:55 AM, Angel Menendez [EMAIL PROTECTED] wrote:
Hi:
doing that
int_xx
They in inverses.
ST_Contains(A,B) = ST_Within(B,A)
P.
On Thu, Sep 4, 2008 at 3:49 PM, [EMAIL PROTECTED] wrote:
What are the difeerences between these two functions?
Thanks.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
Possibly, you never know until you try :) Mateusz fixed at least a
couple, and in places where they might be exercised by st_within().
P.
On Tue, Sep 2, 2008 at 3:02 PM, Mark Cave-Ayland
[EMAIL PROTECTED] wrote:
Thanks for the information from the log file. It's definitely a memory leak
Martin did address this last year:
http://lin-ear-th-inking.blogspot.com/2007/06/history-of-jts-and-geos.html
On Fri, Aug 22, 2008 at 10:18 AM, Michael Michaud
[EMAIL PROTECTED] wrote:
Hi,
Interesting article.
I am surprised not to see JTS even mentioned in this brief history, as it is
a
More news from the south:
2008 Free and Open Source Software for Geospatial (FOSS4G) Conference
incorporating GISSA 2008, September 29 - October 3, Cape Town, South
Africa We are pleased to announce that the Workshop programme has been
finalised. FOSS4G is renowned for its hands-on workshops, so
Theoretically, with a CURVEPOLYGON. Practically, by stroking that arc
so it's a standard POLYGON.
ST_Union(
ST_Transform(ST_Buffer(ST_Transform(ST_GeomFromText('POINT(-115.7922
49.955)', 4269),26910),50*1609),4269),
ST_GeomFromText('POLYGON((-123.25 56, -119 53.4, -116.-847
50.3263,
PS : The whole song-and-dance with the ST_Transform is so I can create
a proper circular buffer using a metric distance (meters = 1609 *
miles) around a geographic point (degrees).
On Wed, Aug 13, 2008 at 1:14 PM, Paul Ramsey [EMAIL PROTECTED] wrote:
Theoretically, with a CURVEPOLYGON
OK, that's interesting, as Buffer is usually pretty tolerant of
invalidity... but not completely tolerant. Perhaps you can extract
just one case for us, since if it's happening on all your cases it's
probably the same issue every time.
P.
On Mon, Aug 11, 2008 at 1:46 PM, Bresnahan, Mike
[EMAIL
try
select b.poli1 as fips, b.name, a.poli1 as contained_by_fips, a.name
from poli_bounds as a , poli_bounds as b
where a.poli1 b.poli1
and st_contains(a.the_geom, st_pointonsurface(b.the_geom))
and a.projectid = 1
and b.projectid = 1;
that should rid you of the boundary conditions plaguing
At core, this is not an indexing problem (of the usual sort). When we
can fix the memory leaks on the preparedgeometry code, and get it out
to users, it will make this case go much much faster, but until then,
it's going to be slow.
P.
On Tue, Aug 5, 2008 at 11:47 AM, [EMAIL PROTECTED] wrote:
Well, that's the opposite of the usual point-in-polygon use case
(given an existing set of polygons and a point input, tell me what
polygons it falls within), but it's equally tractable.
You need an input interface, and that will be the hardest part of your
task. You can do something in Google
Correct, clustering locks up the table while in process, so it's a
pain for changing data, also the new data doesn't end up clustered,
just tacked onto the end.
BTW, your shared buffers of 100MB for a 16GB box is stingy. Give it
2-4GB, be generous.
Not sure why you're having performance issues
Jim,
We've got that contribution already,
http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2975494
Thanks though!
Paul
On Wed, Jul 30, 2008 at 3:49 PM, Jim [EMAIL PROTECTED] wrote:
I wrote some code to output a geometry as json.
Its based on lwgeom_kml.c. I wrote it a few
an ST_AsGeoJson or an AsGeoJson
function.
Paul Ramsey wrote:
Jim,
We've got that contribution already,
http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2975494
Thanks though!
Paul
___
postgis-users mailing list
postgis
Judging from the gook you're getting in your second example (two
characters for every hibit character) the database probably has the
data encoded as UTF-8.
- If your database encoding is UTF8 (use psql -l for a listing of
databases) then the problem is Manifolds fault... for some reason it's
-
Or the SQL way
ALTER DATABASE somedatabase SET client_encoding=latin1;
Hope that helps,
Regina
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul
Ramsey
Sent: Monday, July 28, 2008 1:08 PM
To: PostGIS Users Discussion
Subject
I'm not that any of the databases use the hipparchus mesh.
IBM Informix Geodetic might, but I think someone told me they
*didn't*, as it wasn't all that.
IBM Informix Spatial has an R-Tree
IBM DB2 Spatial I think uses a quadtree
IBM DB2 Geodetic I think *does* use the hipparchus mesh
PostGIS uses
- If you step back a bit and don't even bother splitting up the
rasters into tiles, you can use an existing raster access library like
GDAL to work with serialized data.
Users have the choice of splitting their raster or not. Splitting (which
is synonym of indexing in my head) have the
Nope. All ops are 2D only.
P
On Fri, Jun 27, 2008 at 10:44 AM, Sufficool, Stanley
[EMAIL PROTECTED] wrote:
If I buffer a 3d:
point do I get a sphere?
Line string -- plane?
Box2d -- cube?
Polygon -- Extrusion ???
Obvious questions, but there would be practical
This is in no way a PostGIS problem, certainly nothing we can ever
fix, just something that the particular combination of PgAdmin, the
geometry we are feeding it, and the way the Windows rendering system
are interacting.
My experience has been that these days the thing that causes a modern
No, not common at all.
On Tue, Jun 24, 2008 at 10:11 AM, Bob Pawley [EMAIL PROTECTED] wrote:
Hi
I just downloaded and installed a shapefile into Postgresql.
When I opened the table to view it in PGAdmin my Windows crashed.
According to Microsoft it was an Intel graphics driver error. After
Have you run as ST_IsValid test on it?
On Sun, Jun 22, 2008 at 7:47 PM, Sean Fulton [EMAIL PROTECTED] wrote:
I have Census congressional district data loaded in a Postgis db. I want to
do a negative buffer on all of the districts. The data is in US National
Atlas (EPSG:2163).
Whenever I try
ST_Shift_Longitude?
On Fri, Jun 20, 2008 at 5:52 AM, [EMAIL PROTECTED] wrote:
Hi,
I believe such a function is feasible, but my programming skills are pretty
minimal, so any advice appreciated.
I have data in a custom mercator projection, crossing 180 degrees. I can use
ST_transform to
This is a well-chewed issue, and we have come down repeatedly in
favour of allowing invalid geometry to be loaded. Which, I suppose,
means we should loosen the parser to allow even non-closed rings.
What *does* need to be done (issue for me, it's not that hard) is a
few additional hooks to the
and knowledge required :)
P.
Mark, is there any chance of you posting your datasets for experimentation
purposes?
Paul Ramsey wrote:
Asked and answered? 15 minutes = 900 seconds / 12700 intersections =
70ms per intersection calculation. If your 10 rainfalls are fairly
complex (what's
What GEOS are you using, Bill? Your PostGIS is mismatched to the GEOS.
Or, at least, *something* is mismatched. Do you have old GEOS libs
hanging around? Old postgis libs? Try really reaming out the system
and ensure that the only things around are your new fresh builds.
P
On Thu, Jun 19, 2008
Please file in the issue tracker.
Even better, submit a patch: this isn't something that takes anything
other than a text editor and the will to be great.
P.
On Fri, Jun 20, 2008 at 5:59 PM, Sufficool, Stanley
[EMAIL PROTECTED] wrote:
Issue 1: Can we just name the arguments to the functions
Paul,
Does this mean also that we definition committers can come up with more
meaningful comments that a lay user has a chance of understanding - instead
of
ST_ConvexHull -- Return the convex hull of the ST_Geometry value.
Sorry for nit-picking. I know REAL GIS users already know what a
The numeric cast is a cute hack, but it won't work when shp2pgsql is
in -D dump mode, since dump expects you to give it the right forms
directly.
Have you filed this issue in the bug tracker?
P
On Tue, Jun 17, 2008 at 8:04 AM, hustvedt [EMAIL PROTECTED] wrote:
Hello,
There is what appears to
If you have control of both the pgsql and the sde, you could use
ogr2ogr and a windows scheduler or cron job to fire it off and
directly translate from pgsql to sde.
P
On Wed, Jun 18, 2008 at 8:07 AM, Paragon Corporation [EMAIL PROTECTED] wrote:
I use a PostgreSQL pgagent job to do nightly
Asked and answered? 15 minutes = 900 seconds / 12700 intersections =
70ms per intersection calculation. If your 10 rainfalls are fairly
complex (what's the vertex count?) I don't think that's all that
terrible. Removing the intersects() test will make things modestly
faster, but not
ST_Buffer(ST_MakePoint(x,y),r)
On Fri, Jun 13, 2008 at 3:35 PM, Bob Pawley [EMAIL PROTECTED] wrote:
What is the best way of creating a circle?
Mu PostgreSQL Developes Handbook susy it should be - point and radius.
Postgis doesn't seem to have this function.
Bob
Try it and see :)
It constructs a circular-shaped polygon around the point.
P
On Fri, Jun 13, 2008 at 4:23 PM, Bob Pawley [EMAIL PROTECTED] wrote:
I'm interested in what the buffer actually does.
Bob
- Original Message - From: Paul Ramsey [EMAIL PROTECTED]
To: PostGIS Users
Is that the only function of the buffer - to create a circle?
Can the buffer modify other functions. If so - what is the criteria?
Bob
- Original Message -
From: Paul Ramsey [EMAIL PROTECTED]
To: PostGIS Users Discussion postgis-users@postgis.refractions.net
Sent: Friday, June 13, 2008 4:33 PM
501 - 600 of 782 matches
Mail list logo