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
geoinf16:sqlcartodb
Differences
This shows you the differences between two versions of the page.
|
geoinf16:sqlcartodb [2016/11/25 08:00] oertz [Partie 2] |
geoinf16:sqlcartodb [2018/05/16 10:05] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== SQL Spatial with Carto.com & PostGIS ====== | ||
| - | Carto.com offre un frontale très convivial pour piloter une base de données spatiale utilisant PostGIS (http://postgis.net, https://carto.com/docs/faqs/postgresql-and-postgis). Rapide découverte en deux parties. | ||
| - | |||
| - | Avant de commencer, il faut se connecter sur http://carto.com avec le utilisateur **geoinf16**. | ||
| - | |||
| - | ===== Partie 1 ===== | ||
| - | On utilise la géotable **earthquakes** (source : http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/all_month.csv) | ||
| - | <code> | ||
| - | SELECT ST_AsText(the_geom), * FROM earthquake | ||
| - | </code> | ||
| - | |||
| - | * Le frontale offre une preview cartographique et permet de créer une carte sur la base de ce jeu de géodonnées | ||
| - | * Créer votre séisme quelque-part en Suisse (!) | ||
| - | <code> | ||
| - | SELECT ST_AsText(ST_Transform(ST_GeometryFromText('POINT(558000 137000)', 21781), 4326)) | ||
| - | </code> | ||
| - | * A vous de jouer en donnant de bonnes infos | ||
| - | <code> | ||
| - | INSERT INTO earthquakes (place, mag, the_geom) VALUES ('SOMEWHERE, Switzerland', MMM, ST_Transform(ST_GeometryFromText('POINT(XXX YYY)', 21781), 4326)); | ||
| - | </code> | ||
| - | |||
| - | * Exemple ST_Distance et le type geography : http://postgis.net/docs/manual-2.3/ST_Distance.html | ||
| - | <code> | ||
| - | SELECT ST_Distance( | ||
| - | ST_GeomFromText('POINT(-72.1235 42.3521)',4326), | ||
| - | ST_GeomFromText('LINESTRING(-72.1260 42.45, -72.123 42.1546)', 4326) | ||
| - | ) | ||
| - | </code> | ||
| - | * Exercice ST_Distance (1) : quelle distance sépare chaque séisme de Fukushima - POINT(141.0357 37.4217) ? | ||
| - | <code> | ||
| - | ... | ||
| - | </code> | ||
| - | * Adapter le style (plus on s'éloigne de Fukushima, plus la couleur du point représenté s'éclaircie) | ||
| - | * Exercice ST_Distance (2) : quel est le séisme de magnitude > 6 le plus proche de Fukushima ? | ||
| - | |||
| - | ===== Partie 2 ===== | ||
| - | On utilise les deux géotables **highway61** et **musicians** (sources : https://carto.com/academy/d/highway_61.geojson, https://carto.com/academy/d/mississippi_blues_musicians.geojson). | ||
| - | |||
| - | |||
| - | |||
| - | |||
geoinf16/sqlcartodb.txt · 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
