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

Site Tools


geoinf14:cartodb1

CartoDB :: Part1

Il s'agit simplement de faire avec CartoDB le premier tutoriel PostGIS avec les batiments, piétons etc.

  • Créer une Empty table
  • Renommer la table (Edit Metadata) test1
  • Renommer la colonne name en genre
  • Supprimer la colonne description
  • Exécuter dans le panneau SQL les insertions ci-dessous
INSERT INTO "test1" ("cartodb_id","genre",the_geom) VALUES ('1','batiment1','SRID=4326;MULTIPOLYGON(((6.63376300526706 46.7674702915723,6.63340930755104 46.7669736376389,6.63261348768999 46.7669615240711,6.63250737837519 46.767191681393,6.63376300526706 46.7674702915723)))');
INSERT INTO "test1" ("cartodb_id","genre",the_geom) VALUES ('2','batiment2','SRID=4326;MULTIPOLYGON(((6.63349773198005 46.7690329045661,6.63413438786889 46.7690207914614,6.63386911458187 46.7679790542682,6.63332088312204 46.7681728673645,6.63291413074861 46.7678942608192,6.63234821440298 46.7681244141558,6.63257811791839 46.7685241518241,6.63349773198005 46.7690329045661)))');
INSERT INTO "test1" ("cartodb_id","genre",the_geom) VALUES ('3','batiment3','SRID=4326;MULTIPOLYGON(((6.63178229805734 46.7706318104716,6.63185303760055 46.7706318104716,6.63185303760055 46.7706318104716,6.63236589928878 46.7706318104716,6.63238358417458 46.7695174265195,6.63181766782894 46.7695295395125,6.63178229805734 46.7706318104716)))');
INSERT INTO "test1" ("cartodb_id","genre",the_geom) VALUES ('5','bordureRoute1','SRID=4326;MULTILINESTRING((6.63514242635955 46.7692024877456,6.63130480614071 46.7692024877456))');
INSERT INTO "test1" ("cartodb_id","genre",the_geom) VALUES ('4','bordureRoute2','SRID=4326;MULTILINESTRING((6.63130480614071 46.7693236182612,6.63512474147375 46.7693357312978))');
INSERT INTO "test1" ("cartodb_id","genre",the_geom) VALUES ('9','pieton4','SRID=4326;POINT(6.63353310175165 46.7684999253832)');
INSERT INTO "test1" ("cartodb_id","genre",the_geom) VALUES ('8','pieton3','SRID=4326;POINT(6.63351541686585 46.7687785287958)');
INSERT INTO "test1" ("cartodb_id","genre",the_geom) VALUES ('7','pieton2','SRID=4326;POINT(6.63339162266524 46.7678458073599)');
INSERT INTO "test1" ("cartodb_id","genre",the_geom) VALUES ('6','pieton1','SRID=4326;POINT(6.63194146202955 46.7686452838652)');
  • Remarque : CartoDB a besoin de coordonnées dans un véritable SRS. Ces objets sont tous localisés au Sud d'Yverdon-les-Bains.

TODO

  1. Adapter la CartoCSS pour distinguer les piétons, les routes et les batiments
  2. Répondre aux questions du premier tutoriel PostGIS
geoinf14/cartodb1.txt · Last modified: 2018/05/16 10:05 (external edit)