Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

PostGIS 1.5.1 Manual 290 / 315 Function geometry geography 3D (2.5D) Curves SQL

PostGIS 1.5.1 Manual 290 / 315 Function geometry geography 3D (2.5D) Curves SQL MM ST_Point ST_PointFromText ST_PointFromWKB ST_PointN ST_PointOnSurface ST_Point_Inside_Circle ST_Polygon ST_PolygonFromText ST_Polygonize ST_Relate ST_RemovePoint ST_Reverse ST_Rotate ST_RotateX ST_RotateY ST_RotateZ ST_SRID ST_Scale ST_Segmentize ST_SetPoint ST_SetSRID ST_Shift_Longitude ST_ShortestLine ST_Simplify ST_SimplifyPreserveTopology ST_SnapToGrid ST_StartPoint ST_Summary ST_SymDifference ST_Touches ST_TransScale ST_Transform ST_Translate ST_Union PostGIS 1.5.1 Manual 291 / 315 Function geometry geography 3D (2.5D) Curves SQL MM ST_WKBToSQL ST_WKTToSQL ST_Within ST_X ST_XMax ST_XMin ST_Y ST_YMax ST_YMin ST_Z ST_ZMax ST_ZMin ST_Zmﬂag 8.9 New PostGIS Functions 8.9.1 PostGIS Functions new, behavior changed, or enhanced in 1.5 The functions given below are PostGIS functions that were introduced or enhanced in this major release. • PostGIS_LibXML_Version - Availability: 1.5 Returns the version number of the libxml2 library. • ST_AddMeasure - Availability: 1.5.0 Return a derived geometry with measure elements linearly interpolated between the start and end points. If the geometry has no measure dimension, one is added. If the geometry has a measure dimension, it is over-written with new values. Only LINESTRINGS and MULTILINESTRINGS are supported. • ST_AsBinary - Availability: 1.5.0 geography support was introduced. Return the Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data. • ST_AsGeoJSON - Availability: 1.5.0 geography support was introduced. Return the geometry as a GeoJSON element. • ST_AsText - Availability: 1.5 - support for geography was introduced. Return the Well-Known Text (WKT) representation of the geometry/geography without SRID metadata. • ST_Buffer - Availability: 1.5 - ST_Buffer was enhanced to support different endcaps and join types. These are useful for example to convert road linestrings into polygon roads with ﬂat or square edges instead of rounded edges. Thin wrapper for ge- ography was added. - requires GEOS >= 3.2 to take advantage of advanced geometry functionality. (T) For geometry: Returns a geometry that represents all points whose distance from this Geometry is less than or equal to distance. Calculations are in the Spatial Reference System of this Geometry. For geography: Uses a planar transform wrapper. Introduced in 1.5 support for dif- ferent end cap and mitre settings to control shape. buffer_style options: quad_segs=#,endcap=round|ﬂat|square,join=round|mitre|bevel, • ST_ClosestPoint - Availability: 1.5.0 Returns the 2-dimensional point on g1 that is closest to g2. This is the ﬁrst point of the shortest line. • ST_CollectionExtract - Availability: 1.5.0 Given a GEOMETRYCOLLECTION, returns a MULTI* geometry consisting only of the speciﬁed type. Sub-geometries that are not the speciﬁed type are ignored. If there are no sub-geometries of the right type, an EMPTY collection will be returned. Only points, lines and polygons are supported. Type numbers are 1 == POINT, 2 == LINESTRING, 3 == POLYGON. uploads/Litterature/ haskell-guide.pdf