CartoDB :: Part1

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

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)');

TODO

  1. Adapter la CartoCSS pour distinguer les piétons, les routes et les batiments
  2. Répondre aux questions du premier tutoriel PostGIS