Do you want the function to work with projected or geographic data?If no one has one, I have such functions for Oracle and SQL Server.http://www.spatialdbadvisor.com/sql_server_blog/186/cogo-create-point-from-bearing-and-distancePorting those to PostGIS is easy.SOn Tue, 31 May 2011 15:17:03 +1000,
I need a function that gets a point a distance and bearing from a known
point on the WGS84 datumn. If postgis has such a function I think I will
start using it! I checked the reference manual but my limited knowledge of
postgis at this point is not doing me well.
Thank you!
___
Hi Ben
Try instead of "public.CLEANEDCAMDENGPS" --> public."CLEANEDCAMDENGPS"
notice the "".
I strongly suggest to lowercase all your table and column names.
Hope this helped.
Ricardo
2011/5/30 Ben Madin
> James,
>
> The error message has two possibilities:
>
> ERROR: relation "public.
James,
The error message has two possibilities:
ERROR: relation "public.CLEANEDCAMDENGPS" does not exist
either their is no table called 'CLEANEDCAMDENGPS' (and I think you've probably
got the idea about the issues with case), but it is also possible that the
schema is not 'public', depending
Hmm. Blush. Now that I have posted and annoyed you all, I believe I see my
problem - I'm getting an outer product effect from my st_difference as it
visits each polygon.
So I need to go away and think about the join condition on those queries.
Sorry...
On Mon, May 30, 2011 at 5:06 PM, Chris He
Ladies and gentlemen;
Nice to be back.
I am wrestling with st_difference() and it is getting the better of me. I
am hoping someone who has seen this before can help.
I have two tables that are buffer polygons, built by PostGIS, around some
linear features (trails and traplines).
I am seeking t
Hi,
2011/5/30 Stephen Woodbridge wrote:
> As you know there are many ways to skin a cat. Without more information on
> your specific use case, I would implement this using OpenLayers and not the
> Google API (in part because it open javascript api for mapping and feature
> manipulation and I know
If you have a table named "CLEANEDCAMDENGPS" (in public), and you want
a column "GPS_POINTS":
SELECT AddGeometryColumn('CLEANEDCAMDENGPS', 'GPS_POINTS', 4326, 'POINT', 2);
works fine. There is some confusion in your first message with another
table "CAMDENGPS" and another geometry column "geom".
On 5/30/2011 1:51 PM, Ahmad Aburizaiza wrote:
Hello all,
I am fairly new to PostGIS and I have to work on a project for my PhD. I
hope you can help me. I want to build a web map where the user can
select a building or more than one from a layer on top of Google Maps
API and the code should creat
In addition, rather than using WFS, you could hit the database directly
using something like a PHP script.
On Mon, May 30, 2011 at 2:33 PM, Dave wrote:
> On 30/05/2011 18:51, Ahmad Aburizaiza wrote:
>
> Perhaps you need to look at something like mapserver or geoserver
>
> Both of these applicat
Dear Brent,
Thank you for your reply and simple explanation, it's much appreciated.
Unfortunately, it doesn't seem to work. When I try to create the Geom
column, I get this error:
-
ERROR: function st_creategeometrycolumn(unknown, unknown, unknown, integer,
unknown, integer) does not exist
SQ
On 30/05/2011 18:51, Ahmad Aburizaiza wrote:
Perhaps you need to look at something like mapserver or geoserver
Both of these application are used as part of a web server either tomcat
or apache. The will connect to postgis and provide access to your table
as wms/wfs server.
You can use some
Hello all,
I am fairly new to PostGIS and I have to work on a project for my PhD. I
hope you can help me. I want to build a web map where the user can select a
building or more than one from a layer on top of Google Maps API and the
code should create an automatic convex hull from the set of point
Right, This is happening in a stored procedure that is doing some
additional work, but my point was, that the in the 200-400ms case you
are measuring the the disk hit performance as a page is getting located
on disk and paged into cache and at the faster 20-40ms you are getting
just the index s
GEOS 3.3.0 is out:
http://download.osgeo.org/geos/geos-3.3.0.tar.bz2
This release introduces a fair amount of new C-API interfaces
and a brand new PHP binding. Full details in the NEWS file:
http://trac.osgeo.org/geos/browser/tags/3.3.0/NEWS
As with any release since 3.0.0 there is complete binar
http://www.gordongatherer.com/find11.html
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
16 matches
Mail list logo