[mapguide-users] AutoDesk's SQLServer provider - GEOMETRY_SI_1 andGEOMETRY_SI_2 columns

[Orest Halustchak]

Hi Dennis,
 
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.
 
Orest.

  _____  

From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Dennis
Jonio (Aviation)
Sent: Tuesday, May 01, 2007 8:47 AM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] AutoDesk's SQLServer provider - GEOMETRY_SI_1
andGEOMETRY_SI_2 columns



Good morning,

 

I am looking for some specific information on AutoDesk's SQLServer
provider. Specifically the GEOMETRY_SI_1 and GEOMETRY_SI_2 columns. 

My research to this point: 

1) These columns are NOT to appear in the f_metadata tables for a
feature class.

2) If these columns do NOT exist in the feature class table Autodesk's
MAP3d product complains and abends.

3) Mapguide Enterprise 2007 (MGE) builds an index if these coulmns are
NOT present in the table. Thusly rendering and zooming appropriatly.

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.)

 

Finally, can someone inform me of the "in and outs" of populating these
two(2) fields? 

 "encoded quad-tree index keys"?

 

Dennis Jonio

Miami-Dade Aviation Department

Technical Support Division

Miami International Airport 

Concourse E - 3rd Floor, Miami, Florida 33159

Office: 305 876 7760  Fax: 305 876 0249

*************************************   IMPORTANT NOTICE
****************************************

The Miami-Dade County Aviation Department is a public agency subject to
Chapter 119 of the Florida Statutes concerning

 public records E-mail messages are covered under such laws and thus
subject to disclosure. All e-mail sent and received is

 captured by our server and kept as a public record.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070501/506b5f72/attachment-0001.html