sql

Assigning Points to Polygons in SQL Server

A common requirement in GIS is to be able to find the number of points in a polygon to answer a question such as “how many towns are in this county.” With the spatial operations in SQL Server this can be calculated dynamically, however for large spatial datasets it can often take several minutes to […]



Summary of Hours by Month (for every day)

I recently read Mark Forster’s time management book Do It Tomorrow. In summary it suggests creating a task list on a daily basis, and not doing anything other than from items in that list. Only real emergencies should be dealt with. If emails arrive that have to be dealt with then add them to tomorrow’s […]