<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Garamond;
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1777749346;
mso-list-type:hybrid;
mso-list-template-ids:-1651737294 -302598816 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Garamond;
mso-fareast-font-family:"Times New Roman";
mso-bidi-font-family:"Times New Roman";}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'>Hi all,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;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.<o:p></o:p></span></font></p>
<div style='mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt;
padding:0in 0in 1.0pt 0in'>
<p class=MsoNormal style='border:none;padding:0in'><font size=3 color=blue
face=Garamond><span style='font-size:12.0pt;font-family:Garamond;color:blue'><o:p> </o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'> LAYER<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
NAME "Calhoun_Parcel_centroid"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
GROUP "Calhoun <st1:place w:st="on"><st1:PlaceType w:st="on">County</st1:PlaceType>
<st1:PlaceName w:st="on">Data</st1:PlaceName></st1:place>"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
STATUS OFF<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
DATA "the_geom FROM (select centroid(the_geom) AS the_geom,* from
cal_parcel) AS foo USING UNIQUE gid USING SRID=26929"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
TYPE POINT<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
CONNECTIONTYPE POSTGIS<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
CONNECTION "user=parcel password=dbpass dbname=AnnistonDB host=localhost
port=5432"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
UNITS METERS<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
SIZEUNITS PIXELS<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'> LABELCACHE
ON<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
LABELITEM "PPIN"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
LABELMAXSCALE 6000<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
TOLERANCE 0<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
TOLERANCEUNITS PIXELS<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
TEMPLATE "ttt_query"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
METADATA<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
"layer_title" "Selected Parcel"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
END<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
CLASS<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
NAME "Selected Parcel"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
LABEL<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
TYPE TRUETYPE<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
FONT "fritqat"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
SIZE 8<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
MINSIZE 4<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
MAXSIZE 256<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
POSITION CC<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
OFFSET 0 0 <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
ANGLE AUTO<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
BUFFER 0<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'> MINDISTANCE
-1<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
MINFEATURESIZE -1<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
COLOR 0 0 0<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
OUTLINECOLOR 200 200 200<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
ANTIALIAS TRUE<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
PARTIALS TRUE<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
FORCE FALSE<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
END<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
STYLE<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
SYMBOL 3<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
COLOR 200 0 200<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
SIZE 10<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
END<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
END<o:p></o:p></span></font></p>
<div style='mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt;
padding:0in 0in 1.0pt 0in'>
<p class=MsoNormal style='border:none;padding:0in'><font size=3 color="#333333"
face=Garamond><span style='font-size:12.0pt;font-family:Garamond;color:#333333'>
END<o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'><o:p> </o:p></span></font></p>
<div style='mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt;
padding:0in 0in 1.0pt 0in'>
<p class=MsoNormal style='border:none;padding:0in'><font size=3 color=blue
face=Garamond><span style='font-size:12.0pt;font-family:Garamond;color:blue'>I
am getting this warning if I try to use this layer<o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'>Warning</span></font></b>: [MapServer
Error]: msDrawMap(): Failed to draw layer named 'Calhoun_Parcel_centroid'. in <b><span
style='font-weight:bold'>C:\ms4w\Apache\htdocs\Anniston11\Develop2.php</span></b>
on line <b><span style='font-weight:bold'>82</span></b><br>
<br>
<b><span style='font-weight:bold'>Warning</span></b>: [MapServer Error]:
prepare_database(): Error executing POSTGIS DECLARE (the actual query)
statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from (select
centroid(the_geom) AS the_geom,* from cal_parcel) AS foo WHERE the_geom
&& setSRID('BOX3D(626801.874849 1124507.96601,683350.291609
1166919.27858)'::BOX3D, -1 )' <br>
<br>
Postgresql reports the error as 'ERROR: column reference "the_geom"
is ambiguous '<br>
<br>
More Help:<br>
<br>
Error with POSTGIS data variable. You specified '<check your .map file>'.<br>
Standard ways of specifiying are : <br>
(1) 'geometry_column from geometry_table' <br>
(2) 'geometry_column from (<sub query>) as foo using unique <column
name> using SRID=<srid#>' <br>
<br>
Make sure you put in the 'using unique <column name>' and 'using SRID=#'
clauses in.<o:p></o:p></p>
<div style='mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt;
padding:0in 0in 1.0pt 0in'>
<p class=MsoNormal style='border:none;padding:0in'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'>I found that I was
losing the SRID information when I tried to use the centroid function in
postgis. I have pasted my output below. I was wondering if anyone can help me
fix this error. Any input would be appreciated.<o:p></o:p></span></font></p>
<div style='mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt;
padding:0in 0in 1.0pt 0in'>
<p class=MsoNormal style='border:none;padding:0in'><font size=3 color=blue
face=Garamond><span style='font-size:12.0pt;font-family:Garamond;color:blue'><o:p> </o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>AnnistonDB=# select
the_geom from cal_parcel where ppin = '123';<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'> the_geom<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>--------------------------------------------------------------------------------------------------------------------------SRID=26929;MULTIPOLYGON(((592129.329345788……)))<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>(1 row)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>AnnistonDB=# select
centroid(the_geom) from cal_parcel where ppin = '123';<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
centroid<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>--------------------------------------------------<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'> SRID=-1;POINT(592030.853820728
1186660.20937603)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>(1 row)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>AnnistonDB=# select
postgis_full_version();<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>
postgis_full_version<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'>------------------------------------------------------------------------------------------------------<o:p></o:p></span></font></p>
<div style='mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt;
padding:0in 0in 1.0pt 0in'>
<p class=MsoNormal style='border:none;padding:0in'><font size=3 color="#333333"
face=Garamond><span style='font-size:12.0pt;font-family:Garamond;color:#333333'> POSTGIS="0.9.1"
GEOS="2.1.4" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS
DBPROC="0.0.1" RELPROC="0.0.1"<o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color="#333333" face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:#333333'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 color="#333333"
face=Garamond><span style='font-size:12.0pt;font-family:Garamond;color:#333333'>Thanks<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><font
size=3 color="#333333" face=Garamond><span style='font-size:12.0pt;font-family:
Garamond;color:#333333'><span style='mso-list:Ignore'>-<font size=1
face="Times New Roman"><span style='font:7.0pt "Times New Roman"'>
</span></font></span></span></font><![endif]><font color="#333333"
face=Garamond><span style='font-family:Garamond;color:#333333'> kumar<o:p></o:p></span></font></p>
</div>
</body>
</html>