All, I have a table of about 30 million point observations. The geometries are stored in lon/lat., with a gist index on the column. For display and analysis I want to use an albers projection....mostly I'm aggregating the points to a grid. Currently I just do the transform(geom) in my queries. Would it be better for me to perhaps create a view with the tranformation instead of in my query....or should I instead create another geometry column in the original table, with the tranformation and do another gist index on the new column? What's the best approach?
Thanks, Steve Stephen Crawford Center for Environmental Informatics The Pennsylvania State University _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
