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
geoinf17:stateoftheart
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
geoinf17:stateoftheart [2017/12/13 14:43] oertz |
geoinf17:stateoftheart [2018/10/29 12:46] (current) oertz |
||
|---|---|---|---|
| Line 6: | Line 6: | ||
| * une URL pour consulter le contenu | * une URL pour consulter le contenu | ||
| * une liste de phrases clés, de commentaires, etc | * une liste de phrases clés, de commentaires, etc | ||
| - | |||
| - | ---- | ||
| - | **Réponses de Spatial Query Language :: Part1** | ||
| - | http://mediamaps.ch/doku.php?id=geoinf15:postgis1&rev=1476093132 | ||
| - | <code> | ||
| - | 1) SELECT ST_Area(the_geom) FROM test; | ||
| - | http://postgis.net/docs/manual-2.0/ST_Area.html | ||
| - | |||
| - | 2) SELECT GeometryType(the_geom) FROM test; | ||
| - | http://postgis.net/docs/manual-2.0/GeometryType.html | ||
| - | |||
| - | 3)SELECT ST_Distance((SELECT the_geom FROM test WHERE genre = 'pieton2'), the_geom), genre FROM test; | ||
| - | http://postgis.net/docs/manual-2.0/ST_Distance.html | ||
| - | |||
| - | 4) SELECT ST_Within(the_geom, (SELECT the_geom FROM test WHERE genre = 'batiment2')), genre FROM test; | ||
| - | |||
| - | </code> | ||
| ---- | ---- | ||
geoinf17/stateoftheart.1513172586.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
