[postgis-users] Multipoint thresold
Hi everyone, I am using multipoints and while filling them I noticed that there appears to be a thresold between 1,100 and 1,200 points per multipoint (no error, everything loads fine, just the multipoint geometry columns are empty). I haven't found any documentation on this. So, I am wondering whether this is a general size restriction or if it depends on the computer you're on as well. Thanks, B. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Multipoint thresold
Hi, thanks for your reply. Actually, I do use sql in order to query my data. It tells me that there is nothing in my multipoint geometry. B. Zitat von Nicolas Ribot nicolas.ri...@gmail.com: Hi everyone, I am using multipoints and while filling them I noticed that there appears to be a thresold between 1,100 and 1,200 points per multipoint (no error, everything loads fine, just the multipoint geometry columns are empty). I haven't found any documentation on this. So, I am wondering whether this is a general size restriction or if it depends on the computer you're on as well. Hi No size restriction. Is it possible you look at your data using pgAdmin ? If it is the case, pgAdmin is limiting the number of characters when displaying tables. try a select st_numGeometries(geom) to check all the points are added to the multi object. Or use psql to see the data. Nicolas ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Multipoint thresold
What tells you there is nothing in your multipoint geometry? Client software can be buggy with large unexpected numbers, so the error may be with whatever tool you are using. Can you verify the number of points using SQL? -Mike On 2 July 2010 08:49, Biddy newska...@riomhphost.net wrote: Hi, thanks for your reply. Actually, I do use sql in order to query my data. It tells me that there is nothing in my multipoint geometry. B. Zitat von Nicolas Ribot nicolas.ri...@gmail.com: Hi everyone, I am using multipoints and while filling them I noticed that there appears to be a thresold between 1,100 and 1,200 points per multipoint (no error, everything loads fine, just the multipoint geometry columns are empty). I haven't found any documentation on this. So, I am wondering whether this is a general size restriction or if it depends on the computer you're on as well. Hi No size restriction. Is it possible you look at your data using pgAdmin ? If it is the case, pgAdmin is limiting the number of characters when displaying tables. try a select st_numGeometries(geom) to check all the points are added to the multi object. Or use psql to see the data. Nicolas ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users