Kumar,<br>
<br>
<div><span class="gmail_quote">On 9/20/05, <b class="gmail_sendername">Kumar</b> <<a href="mailto:kumar@newfields.com">kumar@newfields.com</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;">
<div>
<p><font color="blue" face="Garamond" size="3"><span style="font-size: 12pt; font-family: Garamond; color: blue;">Hi all,</span></font></p>
<p><font color="blue" face="Garamond" size="3"><span style="font-size: 12pt; font-family: Garamond; color: blue;">I am trying to get the
centroid of the parcels using postgis to get the centroid of each parcel. I have
pasted the layer definition below.</span></font></p><p><font color="#333333" face="Garamond" size="3"><span style="font-size: 12pt; font-family: Garamond; color: rgb(51, 51, 51);">
DATA "the_geom FROM (select centroid(the_geom) AS the_geom,* from
cal_parcel) AS foo USING UNIQUE gid USING SRID=26929"</span></font> <br>
</p></div></blockquote><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><p>
Postgresql reports the error as 'ERROR: column reference "the_geom"
is ambiguous '<br>
</p></div></blockquote></div><br>
Your subquery is returning two columns with the name "the_geom".
There's really not much need to include all the columns in the DATA
string so you might try to remove the ,* and see if that works.<br>
<br>-- <br>Matt Perry<br><a href="mailto:perrygeo@gmail.com">perrygeo@gmail.com</a><br><a href="http://www.perrygeo.net">http://www.perrygeo.net</a>