- WKT: Well-Known Text
- SRID: a unique identifier for the co-ordinate system to be used defined by EPSG. All Geography types in SQl Server have an associated SRID. Geography instances with different SRIDS cannot be compared without additional transformation.
Note: SRIDS must be the same when performing opertations on multiple geography instances*
SqlGeometry is 2D while SqlGeography is 3D+. It is worth considering deafaulting to SqlGeometry simply unless 3D measuements or localised geography systems are used. Many 3rd parties provide data in 2D and it is easier to transform geometries to difference co-ordinate systems.
Try SharpKml (https://github.com/samcragg/sharpkml) great library for manipulating KML
- Load your KML: