ah found the other one:
http://trac.osgeo.org/postgis/ticket/2556
_
From: postgis-users-boun...@lists.osgeo.org
[mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Paragon
Corporation
Sent: Friday, January 31, 2014 11:27 PM
To: 'PostGIS Users Discussion'
Cc: 'PostGIS Development
Jerry,
Thanks very much for the report. I had noticed what I think might be the
same issue, but couldn't find such a short and succinct example as yours to
reproduce.
I have added to my original ticket:
http://trac.osgeo.org/postgis/ticket/2422
I think there is another ticket in our bug trac
Hello,
I am using Ubuntu 12.04 with the official PostgreSQL apt repo (via
https://wiki.postgresql.org/wiki/Apt). I am running into an easily
reproducible issue, and was hoping for some help to solve this.
When using ST_Intersects() not all rows that intersect are returned. This
was not the case
Thank you Bborie, it looks to be working successfully now.
On Fri, Jan 31, 2014 at 10:17 AM, Bborie Park wrote:
> Put the following at the top of your file...
>
> CREATE TYPE summarystats AS (
> count bigint,
> sum double precision,
> mean double precision,
> stddev double precision,
> min dou
Put the following at the top of your file...
CREATE TYPE summarystats AS (
count bigint,
sum double precision,
mean double precision,
stddev double precision,
min double precision,
max double precision
);
-bborie
On Fri, Jan 31, 2014 at 9:41 AM, Hailey Eckstrand wrote:
> It was from a post
It was from a post on the PostGIS User Discussion that I made last year
from Pierre Racine:
http://lists.osgeo.org/pipermail/postgis-users/2013-August/037514.html
Is it possible to get this functionality working with PostGIS 2.1?
Thanks,
Hailey
On Fri, Jan 31, 2014 at 9:33 AM, Bborie Park wro
PostGIS 2.1 does not have the data type summarystats. Where did you get
this function?
PostGIS 2.2 (in development now) does have that data type though for a
built in ST_SummaryStatsAgg function.
-bborie
On Jan 31, 2014 9:23 AM, "Hailey Eckstrand"
wrote:
> Hi bborie,
>
> After changing it from
Hi bborie,
After changing it from 'SQL' to 'sql' this is the error:
$psql mydb -f ST_SummaryStatsAgg.sql
psql:ST_SummaryStatsAgg.sql:50: ERROR: type summarystats does not exist
psql:ST_SummaryStatsAgg.sql:56: ERROR: type summarystats does not exist
psql:ST_SummaryStatsAgg.sql:77: ERROR: type
Your usage of ST_SummaryStats() won't work. ST_SummaryStats provides the
average and the standard deviation of the input raster...
SELECT (ST_SummaryStats(rast)).mean, (ST_SummaryStats(rast)).stddev FROM
mytable
-bborie
On Fri, Jan 31, 2014 at 5:59 AM, wrote:
> Dear All,
>
>
>
> I have a ras
Can you change line 56 of that code from ...
$$ LANGUAGE 'SQL';
to
$$ LANGUAGE 'sql';
I believe PostgreSQL 9.3 (maybe 9.2) became case-sensitive with regards to
the language.
-bborie
On Thu, Jan 30, 2014 at 4:41 PM, Hailey Eckstrand wrote:
> Hello,
> I've got a new sandbox (Ubuntu 12.04)
Hi,
QGIS prevent to overwrite the primary key field when it copies/pastes,
this is why it leaves the field empty.
One way would be to add the constraint after the copy/paste if it's for
a single shot.
Otherwise, just add a unique constraint on f1 and add a serial as
primary key.
Cheers,
Den
Dear All,
I have a raster in which the pixel values ranges from 0 - 1. I want to find the
standard deviation of from the average cell value of the raster for which I use
a query as under. The query can be executed but do not see any values in data
output window. I initially thought that it coul
Hi all,
we have case where we get large number of WGS84 coordinates in database
real fast.
We would like to put geofence (polygons) that we are monitoring and if
coordinate enters polygon system should generate some kinda of alarm.
Idea was to have algo in realtime as much as possible:
1. Trig
On Thu, Jan 30, 2014 at 01:05:45PM -0500, Scott Pezanowski wrote:
> Sandro,
> Thank you for your advice and I apologize for the lengthy delay in my reply.
> Based on your advice, I seem to have narrowed the problem to one record the
> restore script hits and its tsvector value (perhaps there are
14 matches
Mail list logo
