• Blog posts

    Bio

    Question: 

    How can I create a Spatial Index for a SQL Geometry Table?

     

    Answer:

    Firstly, you will need to calculate the Bounding Box for the geometry within your SQL table. Use the following SQL statement and change the Your_TableName where required:

    The results of this will identify the co-ordinates of the bounding box around your geometry.

      

    Using the SQL statement below you can now generate the Spatial Index. Simply change the Your_TableName as required and insert the coordinates to specify your tables bounding box (as identified in the last step):

     

    The Spatial Index will now be created and can be seen within the Indexes section of your tables properties.