Postgis Spatial Functions
Postgis Spatial Functions
Postgis Spatial Functions
"
Fonctions de gestion
"
Fonction de gestion
-postgis_full_version:Affiche la version courante de
Postgis, GEOS, PROJ4 et PostgreSQL
-UpdateGeometrySRID:Met jour le SRID de toutes les entits
d'une colonne gographique, de la table gemetry_columns, et
de la contrainte sur le SRID de la table
Fonction de gestion
AddGeometryColumn
DropGeometryColumn
DropGeometryTable
PostGIS_Full_Version
PostGIS_GEOS_Version
PostGIS_LibXML_Version
PostGIS_Lib_Build_Date
PostGIS_Lib_Version
PostGIS_PROJ_Version
PostGIS_Scripts_Build_Date
PostGIS_Scripts_Installed
PostGIS_Scripts_Released
PostGIS_Version
Populate_Geometry_Columns
UpdateGeometrySRID
"
Constructeurs de gomtries
"
Constructeurs de gomtries
v ST_GeomFromText
:Construit une gomtrie a partir de
sa reprsentation WKT.
select
st_geomFromText(
'POINT(2.5
43)',
4326);
v ST_GeometryFromText:Alias pour st_geomFromText
v ST_GeomFromWKB:Construit une gomtrie a partir de
sa reprsentation WKB.
v ST_makeBox2D,
ST_makeBox3D:Construit une bbox a partir
de points.
v ST_MakePoint/ST_Point:Construit un point partir de
coordonnes
SELECT ST_MakePoint(1,2);
ST_MPointFromText
ST_MPolyFromText
ST_Point
ST_PointFromText
ST_PointFromWKB
ST_Polygon
ST_PolygonFromText
ST_WKBToSQL
ST_WKTToSQL
"
Accesseurs de gomtries
"
Accesseurs de gomtries
v GeometryType/ST_GeometryType:Retourne le type de la
gomtrie ('POINT', 'POLYGONE'), respectivement
('ST_POINT', 'ST_POLYGONE')
v ST_Boundary:Retourne l'ensemble formant la frontire d'un
object
select
st_boundary(st_point(0,
0));
select
st_boundary(
st_geomFromText('LINESTRING(0
0,
1
1,
2
2)',
-1));
select
astext
(
st_boundary
(
st_polygonFromText
('POLYGON((0
0,
6
0,
6
6,
0
6,
0
0),
(1
1,
5
1,
5
5,
1
5,
1
1))')));
ST_IsValidReason
ST_IsValidDetail
ST_M
ST_NDims
ST_NPoints
ST_NRings
ST_NumGeometries
ST_NumInteriorRings
ST_NumInteriorRing
ST_NumPatches
ST_NumPoints
ST_PatchN
ST_PointN
ST_SRID
ST_StartPoint
ST_Summary
ST_X
ST_XMax
ST_XMin
ST_Y
ST_YMax
ST_YMin
ST_Z
ST_ZMax
ST_Zmflag
ST_ZMin
"
Editeurs de gomtries
"
Editeurs de gomtries
v ST_AddPoint/ST_RemovePoint:Ajoute/supprime un
point une LINESTRING avant le/au point de position
donne (0-based index).
v ST_Affine,
ST_Rotate,
ST_RotateX,
ST_RotateY,
ST_Scale,
ST_Transcale:Effectue des oprations
math. de transformation affine, rotation mise
l'chelle, translation, etc.
v ST_Force2D,
ST_Force3D,
ST_Force3DM:Force la
dimension de la gomtrie
v ST_ForceRHR:Force l'orientation des sommets du
POLYGONE selon la rgle de la main droite (sens
horaire)
"
ST_AsLatLonText
"
ST_Area
v Renvoie la surface en units carres (*) d'une
gomtrie polygonale
v Prototype:
ST_Area(geometry
geom)
SELECT
ST_Area(the_geom)
FROM
ma_table;
v Voir aussi:
v ST_Perimeter
ST_Centroid
v Renvoie la gomtrie du centrode d'une gomtrie
polygonale
v Prototype:
ST_Centroid(geometry
geom)
SELECT
ST_Centroid(the_geom)
FROM
ma_table;
ST_Length
v Renvoie la longueur(*) d'une gomtrie linaire
v Prototype:
ST_Length(geometry
geom)
SELECT
ST_Length(the_geom)
FROM
ma_table;
v Voir aussi:
v ST_Length_Sphere/spheroid (distance en mtres)
v ST_Perimeter
ST_Extent
v Renvoie la BBOX agrge d'un ensemble de
gomtries
v Prototype:
ST_Extent(geometry_set
geom)
SELECT
ST_Extent(the_geom)
FROM
ma_table;
v Voir aussi:
v ST_Box2D et ST_Box3D
v ST_Expand
v ST_Enveloppe
v ST_Estimated_Extent
ST_Crosses
ST_LineCrossingDirection
ST_Disjoint
ST_Distance
ST_HausdorffDistance
ST_MaxDistance
ST_Distance_Sphere
ST_Distance_Spheroid
ST_DFullyWithin
ST_DWithin
ST_Length_Spheroid
ST_Length2D_Spheroid
ST_3DLength_Spheroid
ST_LongestLine
ST_OrderingEquals
ST_Overlaps
ST_Perimeter
ST_Perimeter2D
ST_3DPerimeter
ST_PointOnSurface
ST_Centroid
ST_ClosestPoint
ST_Contains
ST_ContainsProperly
ST_Covers
ST_CoveredBy
ST_Equals
ST_HasArc
ST_Intersects
ST_Length
ST_Length2D
ST_3DLength
ST_Project
ST_Relate
ST_RelateMatch
ST_ShortestLine
ST_Touches
ST_Within
"
ST_Simplify
v Renvoie une gomtrie gnralise (algo: Douglas
Peuker)
v Prototype:
ST_Simplify(geometry
geom,
integer
tolerance)
SELECT
ST_Simplify(the_geom,
100)
FROM
ma_table;
v Voir aussi:
v ST_SnapToGrid
v ST_SimplifyPreserveTopology
ST_Simplify
ST_Intersection
v Renvoie la gomtrie rsultant de l'intersection entre
deux gomtries donnes
v Prototype:
ST_Intersection(geometry
geom_A,
geometry
geom_B)
SELECT
ST_Intersection(
(SELECT
the_geom
FROM
ma_table
WHERE
gid='4'),
(SELECT
the_geom
FROM
ma_table
WHERE
gid='2')
);
v Voir aussi:
v ST_Union
v ST_Difference, ST_sym_difference
ST_Intersection
SELECT
ST_intersection(pays.geometry,
etoiles.geometry)
as
geom
FROM
pays,
etoiles
where
pays.country='France';
ST_Buffer
v Renvoie une gomtrie reprsentant un buffer de X
units(*) autour d'une gomtrie donne. (units des
donnes)
v Prototype:
ST_Buffer(geometry
geom,
double
buffer_distance,
[integer
number_of_segments])
SELECT
ST_Buffer(the_geom,
30)
FROM
ma_table;
v Nota:
vLa valeur du buffer peut tre ngative (buffer inverse)
ST_Buffer
ConvexHull
SELECT
ST_convexHull(geometry)
as
geom
FROM
metro;
ST_MakeValid
pology
ST_MemUnion
ST_Split
ST_MinimumBoundingC ST_SymDifference
ircle
ST_Union
ST_Polygonize
ST_UnaryUnion
ST_Node
ST_OffsetCurve
ST_RemoveRepeatedP
oints
ST_SharedPaths
ST_Shift_Longitude
ST_Simplify
ST_SimplifyPreserveTo