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

[Paul Ramsey]

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.