question

ina avatar image
ina asked

what exactly means:implementation of spatial relational operators in databases?

what exactly means:implementation of spatial relational operators in databases?

import-dataspatial
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Matt Whitfield avatar image
Matt Whitfield answered

Spatial databases are those that contain data about physical space - so that can either be geometric data which is in flat planes, or geographic data which is in curved planes, like the earth's surface.

The operators for those types of data are defined here for geography and here for gerometry. Because the two types of spatial data are implemented as CLR types in SQL Server, the operations on them are performed by the CLR type operators, both static (i.e. call them with typename::methodname) and instanced (i.e. call them with columnname.functionname).

3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Holy cow. I've never seen it summarized quite so well. Nice job.
0 Likes 0 ·
Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
@Grant - thank you kindly sir!
0 Likes 0 ·
ina avatar image ina commented ·
Thank you, Matt,for your help.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.