Name: Using Native SQL Geometry for Cloud-Ready, Lightning-Fast Overlays
Start: 2026-05-21T09:00:00-0700
End: 2026-05-21T09:30:00-0700

Using Native SQL Geometry for Cloud-Ready, Lightning-Fast Overlays

Thursday May 21, 2026 9:00am - 9:30am PDT

407-408

Serving high volume, complex reports that require querying dozens of GIS layers for a single parcel is a major performance hurdle. Our Districts and Development Conditions Report simultaneously queries nearly 60 layers, which has the potential to severely impact application performance. This session details the architectural overhaul we implemented to overcome this challenge without changing the core query structure. Our key improvements were optimizing the underlying data storage by moving to the native SQL Server geometry type and using spatial SQL queries.

Speakers

Fred Lott

GIS Developer, King County

Fred is with the Geo Engineering team of the King County GIS Center and focuses on application development and data analysis.

Harkeerat Kang

GIS Engineer, King County

Harkeerat Kang is a GIS professional with over 25+ years of experience working in public sector. Her focus mostly has been on designing, implementing, integration of systems, application development and solution architecting.

Thursday May 21, 2026 9:00am - 9:30am PDT
407-408

Technology, SQL

Success you have shared X tickets.

2026 WA GIS Conference

Fred Lott

Harkeerat Kang

Get help with the event

Success you have shared X tickets.

2026 WA GIS Conference

Fred Lott

Harkeerat Kang

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Get help with the event