Creating Spatial Data
SQL provides methods to create data in several formats:
- Well-Known Text (WKT)
- Well-known Binary (WKB)
- Geography Markup Language (GML)
- Programatically
SqlGeometryBuilder class
SqlGeographyBuilder class
Well-Known Text
Advantages:
- Simple format
- Human readable
Disadvantage:
loss of precision due to rounding of text-based representation of floating point coordinate values
SQL must parse All WKT into it's own internal binary format. Parsing takes additional time making this method slower than binary creation methods.
Methods of instantiating Spatial data from WKT:
Geometry |
Static Method |
Point |
STPointFromText() |
STLineFromText() |
|
Polygon |
STPolyFromText() |
STMPointFromText() |
|
STMLineFromText() |
|
STMPolyFromText() |
|
STGeomCollFromText() |
|
Any supported geometry |
STGeomFromText() / Parse() |