GIS and Media fusion
"The explosive growth of the GeoWeb and geographic information has made GIS powerful media for the general public to communicate, but perhaps more importantly, GIS have also become media for constructive dialogs and interactions about social issues." - Sui & Goodchild
User Tools
geoinf15:postgis1
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
geoinf15:postgis1 [2015/11/16 11:00] oertz |
geoinf15:postgis1 [2018/05/16 10:05] (current) |
||
|---|---|---|---|
| Line 22: | Line 22: | ||
| ===== Premiers pas ===== | ===== Premiers pas ===== | ||
| (-> cf. documentation [[http://postgis.net/docs/manual-2.0/reference.html|PostGIS Reference]]) | (-> cf. documentation [[http://postgis.net/docs/manual-2.0/reference.html|PostGIS Reference]]) | ||
| - | - Quelles sont les aires des objets ? -> ST_Area2d<code>cf. 2</code> | + | - Quelles sont les aires des objets ? -> ST_Area2d<code>...</code> |
| - | - Quel sont les types géométriques des objets ? -> Geometrytype<code>select genre, ST_Area2d(the_geom) from test where ST_GeometryType(the_geom) = 'ST_Polygon';</code> | + | - Quel sont les types géométriques des objets ? -> Geometrytype<code>...</code> |
| - | - Quel est l'objet géométrique le plus proche du pieton 2 ? -> ST_Distance<code>select genre, ST_Distance((select the_geom from test where genre = 'pieton2'),the_geom) as dist | + | - Quel est l'objet géométrique le plus proche du pieton 2 ? -> ST_Distance<code>...</code> |
| - | from test where genre <> 'pieton2' order by dist limit 1;</code>ou<code>select genre from test where id <> 2 | + | |
| - | and | + | |
| - | ST_Distance( | + | |
| - | the_geom, | + | |
| - | (select the_geom from test where id = 2) | + | |
| - | ) = (select min(ST_Distance( | + | |
| - | the_geom, | + | |
| - | (select the_geom from test where id = 2) | + | |
| - | )) from test where id <> 2);</code> | + | |
| - Qui est dans le bâtiment 2 ? -> ST_Within<code>...</code> | - Qui est dans le bâtiment 2 ? -> ST_Within<code>...</code> | ||
| //(source: [[http://www.davidgis.fr|Jean David Techer]])// | //(source: [[http://www.davidgis.fr|Jean David Techer]])// | ||
geoinf15/postgis1.1447668013.txt.gz · Last modified: 2018/05/16 10:05 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
