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

Paul Ramsey pramsey at cleverelephant.ca
Tue Sep 23 15:54:00 PDT 2014


I guess in theory I could reproduce it with some random xyz data...

P

On Tue, Sep 23, 2014 at 1:47 PM, Jason Mathis
<jmathis at redzonesoftware.com> wrote:
> So unfortunately I did not get the go ahead to share the data, but I solved
> the problem. It was a dataset that was merged from several different
> datasets which is why I got the “PointZM” from shp2pgsql. I was given a
> shape file to load into the database. Although the data just needed to be
> two dimensional. I also had the original coordinates, so I drop the column
> and re-added with just “POINT” and updated the geometry from the lat/longs
> and viola no “notice” message.
>
> Is it only an issue with three or four dimensional data?
>
> Thanks,
> jason
>
> On September 22, 2014 at 5:43:43 PM, Paul Ramsey (pramsey at cleverelephant.ca)
> wrote:
>
> 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.
>
>
> 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.


More information about the postgis-users mailing list