I have had a postgresql / postgis database with over 120 million rows of
point data in a single table and I have been amazed about how well
postgresql performs. As long as you get your indexes and queries right
then I would recommend that option for point data.
Cheers,
Simon
Frank Warmerdam
Have you tried
DATA 'the_geom from (select oid,gid, the_geom,
Area,Perimeter,PixelValue FROM global_Land_poly WHERE
PixelValue=1 )
AS FOO using SRID=4326'
The other options is to change the table name and column names to be lower
case or case insensitive. Mixed case table and column
.
I guess you get the badge for that one.
Thanks for your help.
Peter
Simon Haddon wrote:
Have you tried
DATA 'the_geom from (select oid,gid, the_geom,
Area,Perimeter,PixelValue FROM global_Land_poly WHERE
PixelValue=1 )
AS FOO using SRID=4326'
The other options
Hi,
I use a combination of server code and Javascript.
I convert the lat long values to a javascript array which is loaded into a
2 dimensional array. This data is then loaded with the map which is quick
if your polygons are not too complicated.
I then have a mouse over ont he map which