3. Tipos de datos espaciales en SQL Server
{"Image DocumentName": "3. Tipos de datos espaciales en SQL Server", "Image ImageDescription": "WKT (Well-Known Text) Lenguaje de marcas de texto. Para representar objetos geom\u00e9tricos vectoriales. WKB (Well-Known Binary) Equivalente en formato binario. Almacenamiento en bases de datos. POINT: A Point is an exact location, and is defined in terms of an X and Y pair of coordinates, as well as optionally by a Z (elevation) and M (measure) coordinate. It does not have a length or any area associated with it. Points are used as the fundamental building blocks of more complex spatial types. Note: Z and M are recognized and maintained by SQL Server 2008 if supplied, but are not used in any calculations). LINESTRING: A line segment is the shortest path between two points. A LineString, then, is defined as the path between a sequence of points (i.e., a series of connected line segments). It is considered simple if it does not cross over itself, and is considered a ring if the starting point is the same as the ending point. A LineString is always considered to be a one dimensional object; it has length, but does not have area (even if it is a ring). POLYGON: A Polygon is a closed two-dimensional shape defined by a ring. It has both length and area. A Polygon may also have holes in its interior (a hole is defined by another Polygon). Area within a hole is considered to be exterior to the Polygon itself. COLLECTIONS: In addition to the single instance types (Point, LineString, and Polygon), there is also a type that can hold a collection of instances. This is similar to a list or an array in most programming languages. The most generic type of collection is the GeomCollection, whose members can be of any type. Deriving from GeomCollection are MultiPolygon, MultiLineString, and MultiPoint. As their names suggest, the members of these collection types must be of the single instance type (i.e., MultiPoint can only contain Points, etc).", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}