Bienvenue sur PostGIS.fr

Bienvenue sur PostGIS.fr , le site de la communauté des utilisateurs francophones de PostGIS.

PostGIS ajoute le support d'objets géographique à la base de données PostgreSQL. En effet, PostGIS "spatialise" le serverur PostgreSQL, ce qui permet de l'utiliser comme une base de données SIG.

Maintenu à jour, en fonction de nos disponibilités et des diverses sorties des outils que nous testons, nous vous proposons l'ensemble de nos travaux publiés en langue française.

source: trunk/workshop-foss4g/postgis-functions.rst @ 36

Revision 1, 2.4 KB checked in by djay, 13 years ago (diff)

Initial import of the svn tree

Appendix A: PostGIS Functions

Constructors

:command:`ST_MakePoint(Longitude, Latitude)`

System Message: ERROR/3 (<string>, line 10); backlink

Unknown interpreted text role "command".

Returns a new point. Note the order of the coordinates (longitude then latitude).

:command:`ST_GeomFromText(WellKnownText, srid)`

System Message: ERROR/3 (<string>, line 13); backlink

Unknown interpreted text role "command".

Returns a new geometry from a standard WKT string and srid.

:command:`ST_SetSRID(geometry, srid)`

System Message: ERROR/3 (<string>, line 16); backlink

Unknown interpreted text role "command".

Updates the srid on a geometry. Returns the same geometry. This does not alter the coordinates of the geometry, it just updates the srid. This function is useful for conditioning geometries created without an srid.

:command:`ST_Expand(geometry, Radius)`

System Message: ERROR/3 (<string>, line 19); backlink

Unknown interpreted text role "command".

Returns a new geometry that is an expanded bounding box of the input geometry. This function is useful for creating envelopes for use in indexed searches.

Outputs

:command:`ST_AsText(geometry)`

System Message: ERROR/3 (<string>, line 25); backlink

Unknown interpreted text role "command".

Returns a geometry in a human-readable text format.

:command:`ST_AsGML(geometry)`

System Message: ERROR/3 (<string>, line 28); backlink

Unknown interpreted text role "command".

Returns a geometry in standard OGC :term:`GML` format.

System Message: ERROR/3 (<string>, line 28); backlink

Unknown interpreted text role "term".
:command:`ST_AsGeoJSON(geometry)`

System Message: ERROR/3 (<string>, line 31); backlink

Unknown interpreted text role "command".

Returns a geometry to a standard GeoJSON format.

Measurements

:command:`ST_Area(geometry)`

System Message: ERROR/3 (<string>, line 37); backlink

Unknown interpreted text role "command".

Returns the area of the geometry in the units of the spatial reference system.

:command:`ST_Length(geometry)`

System Message: ERROR/3 (<string>, line 40); backlink

Unknown interpreted text role "command".

Returns the length of the geometry in the units of the spatial reference system.

:command:`ST_Perimeter(geometry)`

System Message: ERROR/3 (<string>, line 43); backlink

Unknown interpreted text role "command".

Returns the perimeter of the geometry in the units of the spatial reference system.

:command:`ST_NumPoints(linestring)`

System Message: ERROR/3 (<string>, line 46); backlink

Unknown interpreted text role "command".

Returns the number of vertices in a linestring.

:command:`ST_NumRings(polygon)`

System Message: ERROR/3 (<string>, line 49); backlink

Unknown interpreted text role "command".

Returns the number of rings in a polygon.

:command:`ST_NumGeometries(geometry)`

System Message: ERROR/3 (<string>, line 52); backlink

Unknown interpreted text role "command".

Returns the number of geometries in a geometry collection.

Relationships

:command:`ST_Distance(geometry, geometry)`

System Message: ERROR/3 (<string>, line 58); backlink

Unknown interpreted text role "command".

Returns the distance between two geometries in the units of the spatial reference system.

:command:`ST_DWithin(geometry, geometry, radius)`

System Message: ERROR/3 (<string>, line 61); backlink

Unknown interpreted text role "command".

Returns true if the geometries are within the radius distance of one another, otherwise false.

:command:`ST_Intersects(geometry, geometry)`

System Message: ERROR/3 (<string>, line 64); backlink

Unknown interpreted text role "command".

Returns true if the geometries are not disjoint, otherwise false.

:command:`ST_Contains(geometry, geometry)`

System Message: ERROR/3 (<string>, line 67); backlink

Unknown interpreted text role "command".

Returns true if the first geometry fully contains the second geometry, otherwise false.

:command:`ST_Crosses(geometry, geometry)`

System Message: ERROR/3 (<string>, line 69); backlink

Unknown interpreted text role "command".

Returns true if a line or polygon boundary crosses another line or polygon boundary, otherwise false.

Note: See TracBrowser for help on using the repository browser.