[postgis-users] NOTICE: no non-null/empty features, unable to compute statistics

[Rémi Cura]

I also have this message on some of my database.
I don't know where it comes from.

Cheers,
Rémi-C

2014-09-23 1:43 GMT+02:00 Paul Ramsey <pramsey at cleverelephant.ca>:

> If you can share data, I'm happy to try and reproduce it here.
>
> P
>
> On Mon, Sep 22, 2014 at 2:01 PM, Jason Mathis
> <jmathis at redzonesoftware.com> wrote:
> > I am stumped on it. I think i remember seeing something like this before,
> > but can’t quite recall.
> >
> > Queries both return zero.
> >
> > 'POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6
> > March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.6"
> > LIBJSON="UNKNOWN" RASTER'
> >
> > i even tried putting a bogus null row in there but I still got the
> message.
> >
> > thanks!
> >
> >
> > On September 22, 2014 at 2:52:00 PM, Paul Ramsey (
> pramsey at cleverelephant.ca)
> > wrote:
> >
> > It means it sampled 30000 rows and didn't find any geometries that
> > were non-null or non-empty. I suppose it could mean a bug, though that
> > code's been around for a while.
> >
> > select count(*) from yourtable where geom is null;
> > select count(*) from yourtable where st_isempty(geom);
> > select postgis_full_version();
> >
> > P.
> >
> > On Mon, Sep 22, 2014 at 12:11 PM, Jason Mathis
> > <jmathis at redzonesoftware.com> wrote:
> >> Does anyone know what this “notice” means? I loaded some new data into a
> >> table from a shape file.Visually it looks good and loaded without
> error. I
> >> have a nightly analyze job that runs and since loading the data it spits
> >> out
> >> this “notice” I don’t know what it means. If I drop the geom column I do
> >> not
> >> get this message. I have tried drop/create the index, and reloading the
> >> data without success.
> >>
> >> Thanks!
> >>
> >>
> >>
> >> $ /usr/bin/vacuumdb -v -Z -d redzone -t 'demo.homes'
> >> INFO: analyzing "demo.homes"
> >> INFO: "homes": scanned 2237 of 2237 pages, containing 101937 live rows
> and
> >> 0 dead rows; 30000 rows in sample, 101937 estimated total rows
> >> NOTICE: no non-null/empty features, unable to compute statistics
> >> NOTICE: no non-null/empty features, unable to compute statistics
> >>
> >> CREATE TABLE demo.homes
> >> (
> >> gid integer NOT NULL DEFAULT nextval('demo.homes_gid_seq'::regclass),
> >> geolat numeric,
> >> geolong numeric,
> >> geolevel text,
> >> geonumber integer,
> >> geostreet text,
> >> geocity text,
> >> geocounty text,
> >> geostate text,
> >> zip text,
> >> firstname text,
> >> lastname text,
> >> tiv integer,
> >> geom geometry(PointZM,4326),
> >> CONSTRAINT homes_pkey PRIMARY KEY (gid)
> >> )
> >>
> >>
> >>
> >>
> >>
> >>
> >> This transmission contains confidential and privileged information
> >> intended
> >> solely for the party identified above. If you receive this message in
> >> error,
> >> you must not use it or convey it to others. Please destroy it
> immediately
> >> and contact the sender at (303) 386-3955 or by return e-mail to the
> >> sender.
> >>
> >>
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at lists.osgeo.org
> >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> >
> >
> > This transmission contains confidential and privileged information
> intended
> > solely for the party identified above. If you receive this message in
> error,
> > you must not use it or convey it to others. Please destroy it immediately
> > and contact the sender at (303) 386-3955 or by return e-mail to the
> sender.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140923/429c7c54/attachment.html>