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 <[email protected]> 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 ([email protected]) > 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 > <[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. > > > 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
