Ken,<br><br>The update you ran only set the SRID in the individual features themselves. What you want to do is to run <span class="term">UpdateGeometrySRID([<schema_name>],
<table_name>, <column_name>, <srid>) which will also update the constraints and the geometry_columns table.<br><br>Ideally, there should have been a constraint on your geometry column that should have disallowed you from updating the individual feature SRIDs. You can find the feature SRID by doing a "select srid(the_geom) from yourtable;".
<br><br>David<br></span><br><div><span class="gmail_quote">On 3/27/07, <b class="gmail_sendername">Ken Boss</b> <<a href="mailto:Ken.Boss@dnr.state.mn.us">Ken.Boss@dnr.state.mn.us</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I was trying to get a handle on coincident points in a table:<br><br> select location_geom, count(*) from burn_locations group by location_geom<br><br>but was getting errors back:<br><br> ERROR: Operation on two GEOMETRIES with different SRIDs
<br><br>The geometry_columns table lists the SRID for the burn_locations table as -1. I thought maybe PostGIS was just choking on the unspecified projection, so I specified it:<br><br> update burn_locations set location_geom=setsrid(location_geom, 26915)
<br><br>and then I was able to run my original query successfully. However, when I looked again at the geometry_columns table, it still listed -1 as the SRID for burn_locations. Which leaves me wondering:<br><br>1) Where does the SRID get stored when I run an update as above?
<br>2) Can I query the SRID for and individual feature? How?<br><br>Thanks for any help,<br><br>--Ken Boss<br> Minnesota DNR<br><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></blockquote></div><br><br clear="all">
<br>-- <br>************************************<br>David William Bitner