you would be better off pre-transforming them with ogr2ogr.. dump them to a shapefile, write a q
On 9/25/07, Stephen Crawford <[EMAIL PROTECTED]> wrote: > > 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 >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
