with a smaller picture.jpg



---------------------------- Message original ----------------------------
Objet:   [Re: [postgis-users] About Hard Upgrade]
De:      "Anne Quesnel" <[email protected]>
Date:    Jeu 3 octobre 2013 17:55
À:       [email protected]
--------------------------------------------------------------------------



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
--

<<attachment: missing_values_queens1.jpg>>

_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Reply via email to