Manage spatial data with Microsoft SQL Server

Apply boolean operations in SQL Server to filter spatial data by greater than, less than, and equal to, using and, or, and not on parcels and land use.

Learn date and time operations in SQL Server to convert strings to dates, compute differences, extract day, month, year, and use date from parts and date name for transaction analysis.

Master spatial functions in SQL Server using geometry data types, including buffering, containment, and intersects. Work with parcels, parks, flood maps, and critical areas to compute intersections.

Master the select statement to retrieve data from tables with star or specific columns, using where clauses and conditions, and join tables on account id, total value, and land use.

Explore spatial type functions in SQL Server, including geometry operations like buffer, contains, intersects, distance, and adjacency, applied to parcel and state data for geospatial analysis.

Explore spatial analysis with SQL Server by applying distance functions to geographic data, build a nearest neighbor index, and compute average nearest neighbor distances between cities.

The Huff model for retail gravitation estimates a customer’s probability of visiting a store by combining store attractiveness with inverse distance weighting, enabling SQL-based market cannibalization and sales projections.

Explore a variogram of the last spring frost date across 76 cities to quantify spatial autocorrelation as distance grows, using 50‑mile bands and semi-variance.