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
ogo12:postgis
Differences
This shows you the differences between two versions of the page.
|
ogo12:postgis [2012/10/12 15:31] oertz |
ogo12:postgis [2018/05/15 17:18] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Geographic Query Language avec PostGIS ====== | ||
| - | PostGIS, le cartouche géospatial de PostgreSQL, ajoute un nouveau type de données, //geometry//, ainsi que plus de 700 opérateurs permettant de le manipuler par des requêtes SQL. Nous allons voir dans la suite un échantillon de ces possibilités. | ||
| - | Pour se familiariser, travaillons ces deux suites d'exercices : **[[ogo11:gql:exo1]] [[ogo11:gql:exo2]]** | ||
| - | |||
| - | Ne pas oublier l'indispensable [[http://postgis.refractions.net/documentation/manual-1.5/|documentation]] avec son chapitre [[http://postgis.refractions.net/documentation/manual-1.5/reference.html|PostGIS Reference]] | ||
| - | |||
| - | |||
| - | ---- | ||
| - | |||
| - | Quelques snippets de code QGL : | ||
| - | * Transformation de projection pour un point (longitude X, latitude Y) | ||
| - | <code> | ||
| - | SELECT AsText(ST_Transform(GeometryFromText('POINT(833838 295935)', 21781 ), 4326)); | ||
| - | </code> | ||
| - | |||
| - | |||
| - | |||
ogo12/postgis.txt · Last modified: 2018/05/15 17:18 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
