On Thu, Apr 05, 2012 at 11:17:40AM -0700, Paul Ramsey wrote:
> Working here. It's a problem with the st_geographyFromText somehow,
> you can insert values into the table if you feed it text directly.
>
> INSERT INTO myTable (location) VALUES ('SRID=4326;PointZ(85 35 500)');
Yep, that's what I was
On Fri, Apr 06, 2012 at 12:08:53AM -0400, Paragon Corporation wrote:
> ALTER ROLE postgres RESET search_path;
Does anyone know how to get a similar call to have temporary effect
for the sake of "make check" sanity ?
--strk;
,--o-.
| __/ |Delivering high quality PostGIS 2.0 !
|
Hi,
I hv imported a raster in PostGIS in the form of table and done some
queries on it and now i want to display that result in Geoserver.
can i do this?
or some other method to display it in form of image?
Thanks
Jyoti
___
postgis-users mailing list
pos
On 4/6/2012 3:33 AM, Sandro Santilli wrote:
On Fri, Apr 06, 2012 at 12:08:53AM -0400, Paragon Corporation wrote:
ALTER ROLE postgres RESET search_path;
Does anyone know how to get a similar call to have temporary effect
for the sake of "make check" sanity ?
You can use
SET search_path to .
On Fri, Apr 06, 2012 at 09:47:52AM -0400, Stephen Woodbridge wrote:
> On 4/6/2012 3:33 AM, Sandro Santilli wrote:
> >On Fri, Apr 06, 2012 at 12:08:53AM -0400, Paragon Corporation wrote:
> >
> >>ALTER ROLE postgres RESET search_path;
> >
> >Does anyone know how to get a similar call to have temporar
Hi.
I am developing a system to manage ad analyse (wildlife) tracking data.
I need to integrate GPS data with raster time series, let's say MODIS NDVI.
I want to associate each location to the NDVI value on the basis of both
coordinates and timestamp.
The time series includes an image every 2 weeks
Everything imports fine if I do not use the transform. I would also point out
that the srid conversion functionality is missing in the shapefile/dbf
loader GUI in pgadmin as there is no box for convert srid.
As to my path issues, if I do not change my user path addgeometrycolumn
fails.
I used:
I have polygon made up of many different points,it some cases its rather
to accurate for my requirments,i.e. its generating a lot points to
describe a minor change.
I had throught that by saying something like
select ((st_dumppoints(
(st_intersection(ST_Segmentize(st_exteriorRing(jt.the_Geom),7
Hi Dave,
I would have thought ST_Simplify() would met your requirements.
If you use it with a buffer distance of zero, then the full resolution is
retained, but any points on a straight boundary segment which are redundant are
removed. This is the minimum number of vertices required to define t
Pierre et al.
I have been investigating the apparent disappearance of ST_PixelAsPolygons.
I have updated the database to 2.0 and preformed an apparently successful
soft upgrade on the database. Still when, when trying to use the function i
get:
ERROR: function st_pixelaspolygons(raster) does not
Hmm strange works all fine on my window box and my postgres doesn't have
it's own search_paths.
You did set the search path of the database right?
Mine is like this:
ALTER DATABASE mygisdb SET search_path="$user", postgis, public, contrib;
and it works fine for all users. I do have user speci
One other thought. It's possible you have the search_path set for postgres
in your database. I think that features was introduced in postgresql 9.0 or
9.1. Can't recall.
So for example in my database, I have a setting like this:
ALTER ROLE postgres IN DATABASE mygisdb SET search_path="$user",
The following works fine for me:
psql -U postgres
#in psql prompt:
CREATE DATABASE template_postgis20 WITH TEMPLATE = template1 ENCODING =
'UTF8';
\c template_postgis20
CREATE SCHEMA postgis;CREATE EXTENSION postgis WITH SCHEMA postgis; CREATE
EXTENSION postgis_topology;
SET search_path TO postgi
13 matches
Mail list logo
