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
geoinf14:cartodb0
Differences
This shows you the differences between two versions of the page.
|
geoinf14:cartodb0 [2014/12/05 18:15] oertz [Première CartoTable] |
geoinf14:cartodb0 [2018/05/16 10:05] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Spatial database :: CartoDB ====== | ||
| - | * Créer un compte chez www.cartodb.com et s'y loguer | ||
| - | |||
| - | ===== Première "CartoTable" ===== | ||
| - | * Créer une //Empty table// | ||
| - | * Renommer la table (Edit Metadata) //my4capitals// | ||
| - | * Exécuter dans le panneau SQL les insertions ci-dessous | ||
| - | <code> | ||
| - | INSERT INTO my4capitals (cartodb_id, name, the_geom) VALUES ( 0, 'Paris', ST_GeometryFromText( 'POINT(2.333 48.867)', 4326)); | ||
| - | INSERT INTO my4capitals (cartodb_id, name, the_geom) VALUES ( 1, 'Bern', ST_GeometryFromText( 'POINT(7.433 46.95)', 4326)); | ||
| - | INSERT INTO my4capitals (cartodb_id, name, the_geom) VALUES ( 2, 'Rome', ST_GeometryFromText( 'POINT(12.5 41.883)', 4326)); | ||
| - | INSERT INTO my4capitals (cartodb_id, name, the_geom) VALUES ( 3, 'Madrid', ST_GeometryFromText( 'POINT(-3.71 40.41)', 4326)); | ||
| - | </code> | ||
| - | * Executer dans le panneau SQL la sélection ci-dessous et comparer la colonne //the_geom// avec //the_geom_webmercator// | ||
| - | <code> | ||
| - | SELECT * from my4capitals | ||
| - | </code> | ||
| - | * Basculer en mode MAP VIEW | ||
| - | * Editer la CartoCSS à votre goût (onglet CSS) | ||
| - | |||
| - | ==== Utilisation de la SQL API de CartoDB ==== | ||
| - | La classe Connection du GeoManager précédent est maintenant remplacée par une API Web. On peut y lancer des requêtes GQL. Par exemple : | ||
| - | <code> | ||
| - | <?php | ||
| - | $ch = curl_init(); | ||
| - | curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); | ||
| - | |||
| - | $api_key = "2e957be5f1e9c0793ca1725aab08274a795f2c3f"; | ||
| - | $q = "select name, ST_AsGeoJSON(the_geom) as geom from my4capitals"; | ||
| - | |||
| - | $url = "http://oertz.cartodb.com/api/v2/sql?api_key=" . $api_key. "&q=" . urlencode($q); | ||
| - | curl_setopt($ch, CURLOPT_URL, $url); | ||
| - | |||
| - | $result = curl_exec($ch); | ||
| - | |||
| - | header("Content-type: application/json"); | ||
| - | echo $result; | ||
| - | ?> | ||
| - | </code> | ||
| - | __TODO__ | ||
| - | - Adapter le géoservice Get4Capitals.php en utilisant l'API SQL de CartoDB pour afficher les 4 villes dans votre application OpenLayers (la classe FeatureCollection du GeoManager peut être utile). | ||
geoinf14/cartodb0.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
