List of Examples

• 1-1 SQL Script for Customers and Stores Scenario
• 1-2 Inserting Customer and Store Records
• 1-3 Updating the Spatial Metadata
• 1-4 Creating the Spatial Indexes
• 1-5 Finding Closest Customers to a Store
• 1-6 Finding Closest Customers, Ordered by Distance from Store
• 1-7 Finding Customers Within 100 Miles of a Store
• 1-8 SQL Statement to Insert a Polygon
• 1-9 SQL Statement to Insert a Rectangle
• 1-10 SQL Statement to Insert a Polygon with a Hole
• 1-11 SQL Statement to Insert a Line String
• 1-12 SQL Statement to Insert a Compound Line String
• 1-13 SQL Statement to Insert a Compound Polygon
• 1-14 SQL Statements to Insert Various Geometries