====== 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__ - Adapter la CartoCSS pour distinguer les piétons, les routes et les batiments - Répondre aux [[geoinf14:postgis1|questions du premier tutoriel]] PostGIS