<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1515" name=GENERATOR><o:SmartTagType
name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="PlaceName"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="PlaceType"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Garamond;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.EmailStyle18 {
FONT-WEIGHT: normal; COLOR: blue; FONT-STYLE: normal; FONT-FAMILY: Garamond; TEXT-DECORATION: none; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
OL {
MARGIN-BOTTOM: 0in
}
UL {
MARGIN-BOTTOM: 0in
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=blue link=blue>
<DIV><SPAN class=396232621-20092005><FONT face=Arial color=#0000ff size=2>I
think the problem may be your * at the end because that would add in your
regular the_geom so you would end up having 2 the_geom fields. try getting
rid of * and explicitly listing the fields you need.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Kumar
[mailto:kumar@NEWFIELDS.COM] <BR><B>Sent:</B> Tuesday, September 20, 2005 5:20
PM<BR><B>To:</B> MAPSERVER-USERS@LISTS.UMN.EDU<BR><B>Subject:</B>
[UMN_MAPSERVER-USERS] mapserver-postgis centroid function<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Garamond color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Garamond">Hi
all,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Garamond">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="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 1pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; mso-element: para-border-div">
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none"><FONT
face=Garamond color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
LAYER<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
NAME "Calhoun_Parcel_centroid"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
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 face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
STATUS OFF<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
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 face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
TYPE POINT<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
CONNECTIONTYPE POSTGIS<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
CONNECTION "user=parcel password=dbpass dbname=AnnistonDB host=localhost
port=5432"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
UNITS METERS<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
SIZEUNITS PIXELS<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
LABELCACHE ON<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
LABELITEM "PPIN"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
LABELMAXSCALE 6000<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
TOLERANCE 0<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
TOLERANCEUNITS PIXELS<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
TEMPLATE "ttt_query"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
METADATA<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
"layer_title" "Selected Parcel"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
END<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
CLASS<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
NAME "Selected Parcel"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
LABEL<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
TYPE TRUETYPE<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
FONT "fritqat"<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
SIZE 8<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
MINSIZE 4<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
MAXSIZE 256<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
POSITION CC<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
OFFSET 0 0 <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
ANGLE AUTO<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
BUFFER 0<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
MINDISTANCE -1<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
MINFEATURESIZE -1<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
COLOR 0 0 0<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
OUTLINECOLOR 200 200 200<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
ANTIALIAS TRUE<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
PARTIALS TRUE<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
FORCE FALSE<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
END<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
STYLE<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
SYMBOL 3<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
COLOR 200 0 200<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
SIZE 10<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
END<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
END<o:p></o:p></SPAN></FONT></P>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 1pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; mso-element: para-border-div">
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none"><FONT
face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
END<o:p></o:p></SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT face=Garamond color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 1pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; mso-element: para-border-div">
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none"><FONT
face=Garamond color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Garamond">I am getting this
warning if I try to use this layer<o:p></o:p></SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT face=Garamond color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><B><FONT face="Times New Roman" size=3><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 12pt">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="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 1pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; mso-element: para-border-div">
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none"><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT face=Garamond color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Garamond">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="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 1pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; mso-element: para-border-div">
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none"><FONT
face=Garamond color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT face=Garamond color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">AnnistonDB=#
select the_geom from cal_parcel where ppin =
'123';<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"> the_geom<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">--------------------------------------------------------------------------------------------------------------------------SRID=26929;MULTIPOLYGON(((592129.329345788......)))<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">(1
row)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">AnnistonDB=#
select centroid(the_geom) from cal_parcel where ppin =
'123';<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
centroid<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">--------------------------------------------------<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"> SRID=-1;POINT(592030.853820728
1186660.20937603)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">(1
row)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">AnnistonDB=#
select postgis_full_version();<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">
postgis_full_version<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">------------------------------------------------------------------------------------------------------<o:p></o:p></SPAN></FONT></P>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 1pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; mso-element: para-border-div">
<P class=MsoNormal
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none"><FONT
face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"> 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 face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.25in"><FONT face=Garamond
color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond">Thanks<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal
style="MARGIN-LEFT: 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1"><![if !supportLists]><FONT
face=Garamond color=#333333 size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: #333333; FONT-FAMILY: Garamond"><SPAN
style="mso-list: Ignore">-<FONT face="Times New Roman" size=1><SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></FONT></SPAN></SPAN></FONT><![endif]><FONT face=Garamond
color=#333333><SPAN
style="COLOR: #333333; FONT-FAMILY: Garamond"> kumar<o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>