I'm experimenting around with my postgis2.0 database. I want to create a basic table to store all my point data and in the process,I realized that the coordinates are in different CRSs. So naturally I'm wondering now if the
the_geom column can contain a variety of CRSs - or Im confined to a single CRS per table.
To visualize it a bit, Is the following possible?
point_id | the_geom | 1 | (geom_string1) <- CRS EPSG:4326 2 | (geom_string2) <- CRS EPSG:2100