[postgis-users] [Fwd: [Re: About Hard Upgrade]]

[Anne Quesnel]

with a smaller picture.jpg



---------------------------- Message original ----------------------------
Objet:   [Re: [postgis-users] About Hard Upgrade]
De:      "Anne Quesnel" <aquesnel at univ-lille2.fr>
Date:    Jeu 3 octobre 2013 17:55
À:       postgis-users at lists.osgeo.org
--------------------------------------------------------------------------



Hi,
as you can see, it's appear LIKE missing value on the tables : see
attached file of queens.jpg

but from your "sql commands" there is zero missing value in table!?

SELECT count(*) from public.nyc_census_blocks; 36592
SELECT count(*) from public.nyc_census_blocks WHERE the_geom IS NULL; 0

SELECT count(*) from public.queens WHERE the_geom IS NULL; 30  SELECT
count(*) from public.queens WHERE the_geom IS NULL;0




>Are you missing values or full records ?
>
> SELECT count(*) from public.nyc_census_blocks;
> SELECT count(*) from public.nyc_census_blocks WHERE the_geom IS NULL;

>--strk;

-- 
Quesnel Anne - Dr en Géographie quantitative; Géomatique en Santé.
http://quesnela.free.fr/
Mobile: 06 58 06 68 08
Télécharger ma thèse de doctorat
http://tel.ccsd.cnrs.fr/documents/archives0/00/00/96/22/index_fr.html
--

-------------- next part --------------
A non-text attachment was scrubbed...
Name: missing_values_queens1.jpg
Type: image/jpeg
Size: 21795 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131004/19576dea/attachment.jpg>