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 <[email protected]> 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 ([email protected]) > 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 > <[email protected]> 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 >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > 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 [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
