—Kevin Watt, Tom Brown
View the slides [PDF]
Listen and view the presentation [FLASH]
Applications can interact with the geodatabase through SQL. Writing efficient SQL with spatial attributes requires an understanding of the data types architecture and operators. This session will introduce the audience to the ST_Geometry model, spatial index, and relational and geometry operators. It will also focus on proper SQL syntax to ensure optimal execution and utilization of the spatial index.
Prerequisites: SQL and a basic understanding of geodatabase versioning