O'Reilly logo

Pro Spatial with SQL Server 2012 by Alastair Aitchison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Index

* algorithm

code optimisation and enhancements, 379

data restructure, 367369

heuristics, 365367

MAXRECURSION query, 365

SQLCLR procedure complete code, 373378

SQLCLR stored procedure, 365

testing, 378379

traversing across network

AStarNode class, 370

GetEdgeBetweenNodes procedure, 372373

GetNodesAccessibleFromNode stored procedure, 370371

node classification, 371372

open list and closed list, 369

A

Aggregation and combination

geometry appending, 276277

geometry subtracting

British Meteorological Office, 279281

STDifference() method, 278

intersection, geometries, 283285

spatial data, column aggregation

CollectionAggregate() function, 288289

ConvexHullAggregate() function, 289

EnvelopeAggregate() function, 288

GROUP BY clause, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required