Question
I would like to speed up the rendering of layers in MapThat, how do I create a Spatial Index in SQL Server?
Answer
Creating a Spatial Index is a must for your spatial datasets, as it will help any client application render your data more quickly and perform spatial analysis easier. In order to create a Spatial Index first you must know the bounding box coordinates of your dataset. To do this you can use this simple SQL statement:
* where ogr_geometry is the geometry column in YOURTABLE
This will return a result where the Easting and Northing of the bottom left and top right of your data is shown:
Using these coordinates you can then use the following SQL statement to create a Spatial Index for the table.
* ensure you replace the E & N values for the Bounding Box with those you identified in the first query.
If you now view the list of Indexes for YOURTABLE you can now see that a Spatial Index has been created and will be used to more efficiently render and query your spatial dataset.
For my help with SQL Spatial data try this FAQ: https://www.cadlinecommunity.co.uk/hc/en-us/articles/115002814585-MapThat-Admin-Geometry-Make-Valid-Error-Message