<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3020" name=GENERATOR>
<STYLE>@font-face {
font-family: Comic Sans MS;
}
@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: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=323405312-01052007><FONT face=Arial
color=#0000ff size=2>Hi Dennis,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=323405312-01052007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=323405312-01052007><FONT face=Arial
color=#0000ff size=2>These columns are used for spatial indexing. The provider
computes the quad-tree keys based on the feature's geometry when you add or
update a feature through the provider.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=323405312-01052007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=323405312-01052007><FONT face=Arial
color=#0000ff size=2>Orest.</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Dennis Jonio
(Aviation)<BR><B>Sent:</B> Tuesday, May 01, 2007 8:47 AM<BR><B>To:</B>
mapguide-users@lists.osgeo.org<BR><B>Subject:</B> [mapguide-users] AutoDesk's
SQLServer provider - GEOMETRY_SI_1 andGEOMETRY_SI_2 columns<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Good morning,</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I am looking for some specific
information on AutoDesk's SQLServer provider. Specifically the GEOMETRY_SI_1 and
GEOMETRY_SI_2 columns. </SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">My research to this point:
</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">1) These columns are NOT to appear
in the f_metadata tables for a feature class.</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">2) If these columns do NOT exist in
the feature class table Autodesk's MAP3d product complains and
abends.</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">3) Mapguide Enterprise 2007 (MGE)
builds an index if these coulmns are NOT present in the table. Thusly rendering
and zooming appropriatly.</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">4) Mapguide Enterprise 2007 (MGE)
"uses" these columns if they are present in the table and they must be populated
with the "appropriate" values.(To this point my feature classes are < 5000
records so performance is not an issue.)</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Finally, can someone inform me of
the "in and outs" of populating these two(2) fields? </SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> "encoded quad-tree index
keys"?</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><EM><I><FONT face="Comic Sans MS" color=navy size=4><SPAN
style="FONT-SIZE: 13.5pt; COLOR: navy; FONT-FAMILY: 'Comic Sans MS'">Dennis
Jonio</SPAN></FONT></I></EM></P>
<P class=MsoNormal><EM><I><FONT face="Comic Sans MS" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">Miami-Dade Aviation
Department</SPAN></FONT></I></EM></P>
<P class=MsoNormal><EM><I><FONT face="Comic Sans MS" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">Technical Support
Division</SPAN></FONT></I></EM></P>
<P class=MsoNormal><U1:PLACE><U1:PLACENAME><EM><I><FONT face="Comic Sans MS"
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">Miami</SPAN></FONT></I></EM></U1:PLACENAME><EM><I><FONT
face="Comic Sans MS" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">
</SPAN></FONT></I></EM><EM><I><FONT face="Comic Sans MS" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'"><U1:PLACENAME>International</SPAN></FONT></I></EM></U1:PLACENAME><EM><I><FONT
face="Comic Sans MS" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">
</SPAN></FONT></I></EM><EM><I><FONT face="Comic Sans MS" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'"><U1:PLACETYPE>Airport</SPAN></FONT></I></EM></U1:PLACETYPE></U1:PLACE><EM><I><FONT
face="Comic Sans MS" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">
</SPAN></FONT></I></EM></P>
<P class=MsoNormal><EM><I><FONT face="Comic Sans MS" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">Concourse E - 3rd Floor,
</SPAN></FONT></I></EM><U1:PLACE><U1:CITY><EM><I><FONT face="Comic Sans MS"
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">Miami</SPAN></FONT></I></EM></U1:CITY><EM><I><FONT
face="Comic Sans MS" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">,
</SPAN></FONT></I></EM><U1:STATE><EM><I><FONT face="Comic Sans MS" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">Florida</SPAN></FONT></I></EM></U1:STATE><EM><I><FONT
face="Comic Sans MS" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">
</SPAN></FONT></I></EM><EM><I><FONT face="Comic Sans MS" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'"><U1:POSTALCODE>33159</SPAN></FONT></I></EM></U1:POSTALCODE></U1:PLACE></P>
<P class=MsoNormal><EM><I><FONT face="Comic Sans MS" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">Office: 305 876
7760 Fax: 305 876 0249</SPAN></FONT></I></EM></P>
<P class=MsoNormal><FONT face="Times New Roman" color=navy size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy">*************************************
<B><I><SPAN style="FONT-WEIGHT: bold; FONT-STYLE: italic">IMPORTANT
NOTICE</SPAN></I></B> ****************************************</SPAN></FONT></P>
<P class=MsoNormal><I><FONT face="Times New Roman" color=navy size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-STYLE: italic">The Miami-Dade County
Aviation Department is a public agency subject to Chapter 119 of the
</SPAN></FONT></I><I><FONT color=navy size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-STYLE: italic">Florida</SPAN></FONT></I><I><FONT
color=navy size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-STYLE: italic"> Statutes
concerning</SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face="Times New Roman" color=navy size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-STYLE: italic"> public records
E-mail messages are covered under such laws and thus subject to disclosure. All
e-mail sent and received is</SPAN></FONT></I></P>
<P class=MsoNormal><I><FONT face="Times New Roman" color=navy size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-STYLE: italic"> captured by our
server and kept as a public record.</SPAN></FONT></I></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV></BODY></HTML>