Hi,
I have a database stored in WGS84 EPSG:4326
I would like ti find objects within a distance from a lat/lon point.
1) If i use 1 degree as the distance, will I then get an eliptic search area?
2) Will i find objects on the other side of the Datum shift border if I enter a
point like lat=60°,
On Mon, May 10, 2010 at 11:32:32AM -0400, Charles Galpin wrote:
ST_PointN doesn't work for multipoints,
ST_GeometryN does.
--strk;
() Free GIS Flash consultant/developer
/\ http://strk.keybit.net/services.html
___
postgis-users mailing
I've read the 1.5 reference docs but can't figure out what is wrong with
below. ST_CoveredBy(geography, geography) should work right?
select count(*) from t_swath_metadata where ST_CoveredBy(
ST_GeogFromText('SRID=4326;POLYGON((123.1773295292851 -16.07501950971949,
On 11 May 2010 07:34, Malm Paul paul.m...@saabgroup.com wrote:
Hi,
I have a database stored in WGS84 EPSG:4326
I would like ti find objects within a distance from a lat/lon point.
1) If i use 1 degree as the distance, will I then get an eliptic search
area?
2) Will i find objects on the
Even better, thanks!
On May 11, 2010, at 3:15 AM, strk wrote:
On Mon, May 10, 2010 at 11:32:32AM -0400, Charles Galpin wrote:
ST_PointN doesn't work for multipoints,
ST_GeometryN does.
--strk;
() Free GIS Flash consultant/developer
/\ http://strk.keybit.net/services.html
Bad sentence construction in the error, perhaps? The restriction only
polygon and point means that one argument must be a polygon and one
must be a point. Both your arguments are polygons.
P.
On Tue, May 11, 2010 at 4:51 AM, Nicholas Bower n...@petangent.net wrote:
I've read the 1.5 reference
Would something like this be inefficient? I store data in a geometry
type, as I don't really care about the spheroid accuracy, as my
location queries are mostly less than 30 km apart. So...
SELECT ST_AsGeoJSON(location), title, description
FROM event
WHERE ST_DWithin(location::geography,
Hello,
I am getting the following error during database queries:
WARNING:OGC WKT expected, EWKT provided - use GeomFromEWKT() for this
I found some references to this using Google, so it appears to be a
known item.
I have tried wrapping all of my text geometries in 'GeomFromEWKT()'
to no
On 11 May 2010 12:04, Peter Willis pwil...@aslenv.com wrote:
How many dimensions is postgis WKT now expecting for 'POLYGON'?
OGC WKT has only 2 dimensions while EWKT has up to 4.
Ps.
I thought to search your mailing list archives but they don't appear
to be search-able. Is there any way to
Mike Toews wrote:
On 11 May 2010 12:04, Peter Willis pwil...@aslenv.com wrote:
How many dimensions is postgis WKT now expecting for 'POLYGON'?
OGC WKT has only 2 dimensions while EWKT has up to 4.
Ps.
I thought to search your mailing list archives but they don't appear
to be search-able. Is
Thanks but not according to the doc I think?
1) Abstract superclass is mentioned in API, not point,
2) the SQL example uses circles
3) the blog link specifically uses polygons in it's discussion of OGC
coverage behaviour.
Nick,
Hmm, I guess we didn't provide a geography example and also didn't put in
the restrictions for geography. We'll update the docs.
For geometry -- ST_CoveredBy covers Polygon/polygon and various other
permutations.
The geography version is much more limited and as Paul mentioned only
On 12 May 2010 08:14, Paul Ramsey pram...@opengeo.org wrote:
The doc example appears to not mention the limitation in the geography
implementation, which can be fixed. The example is correct, insofar
as it is against geometries, but again, doesn't illustrate the
limitation in the geography
On Tue, May 11, 2010 at 4:30 PM, Nicholas Bower n...@petangent.net wrote:
On 12 May 2010 08:14, Paul Ramsey pram...@opengeo.org wrote:
The doc example appears to not mention the limitation in the geography
implementation, which can be fixed. The example is correct, insofar
as it is against
Thanks for the clarification. True intersects (ST_Intersects) or bounding
box intersects ()?
I'll ask around and see if there is interest in funding something.
Personally however I've been working with no secured funding on this for 3
years (not my day job) so can't fund myself sorry;
Bounding box intersects () on geography will return
sane-on-the-spheroid results, which then can be reprojected for use in
geometry land.
On Tue, May 11, 2010 at 5:47 PM, Nicholas Bower n...@petangent.net wrote:
Thanks for the clarification. True intersects (ST_Intersects) or bounding
box
Hi,
Postgis 1.5.1 compiles ok on Postgres 9.0 beta1, but when I run make install
it fails:
...
PostGIS was built successfully. Ready to install.
make -C postgis install
make[1]: Entering directory `/home/japearson/postgis/postgis-1.5.1/postgis'
Makefile.pgxs:17: warning: overriding commands for
Joel,
Which OS are you building under? We tried under Windows and had other
issues, but assumed it was just a windows mingW issue.
Last we tried compiling at the 8.5lahpa something or other, we were able to
compile and install as I recall. That was a while ago though.
Thanks,
Leo and Regina
Hi,
I am building under Centos 5.4
I was building with geos 3.2.2 and proj 4.7.0
Cheers,
-Joel
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
No, seems to compile and install perfectly fine under OS/X.
Two regression failures (*sigh*) due to a slight change in output from
SQL (select queries that don't return rows now return 'SELECT number
of rows' instead of just 'SELECT')
P.
On Tue, May 11, 2010 at 6:13 PM, Joel Pearson
Hmm weird.
As a sanity check, I compiled postgis 1.3.6 against 8.4 and it
compiled fine. I then tried compile postgis 1.5.1 and it failed with
this error:
/bin/sh /usr/lib/pgsql/pgxs/src/makefiles/../../config/install-sh -c
pgsql2shp /var/tmp/postgis-1.5.1-2-root-japearson/usr/bin
/bin/sh
We've got a successful build now for 1.5 SVN against PostgreSQL 9.0 beta 1
for Windows (well 32-bit anyway). We'll try to release an experimental
package for windows sometime this week that includes 9.0 beta1.
As far as putting on stack builder, we are going to wait till PostGIS 1.5.2
is
22 matches
Mail list logo