Oopus Blog

Category: GIS

  • 溥仪亲迎体心

    读完陳熙遠《共和國裡的皇室婚禮─宣統大婚與帝制王朝的最後掙扎》，特别在意溥仪这位十七岁少年在遗老翘首期盼和各自的算盘下，在民国众冷嘲热讽下，在民国政府小心运作下，在家族至亲各怀心思下，在仪式感的感染下，在中二少年荷尔蒙的驱动下，到底是怎么是怎么想的。于是决定顺着候仁之《北京历史地图集》宣统大婚迎娶淑妃往返图走了一次。花絮 1：在什刹海附近收到友人的微信“你还活着么？”望了望难得的北京清澈夜空的冬季大三角：“溥仪君，你还是死了之后更开心吧XD”。花絮 2：零下十度骑车的保暖按照零下十到十五度搭配保暖装备准备完全没问题（面罩非常重要），虽然骑起来风大，但是高速运动出汗基本能抵消掉快速散失的热量。不过特别要当心擦鼻涕的纸巾在口袋里被冻成硬质纸板。花絮 3：警车上的警官大人很凶的

    Song 题诗：銀錠橋邊盡酒吧，淑妃邸外憶嬌娃。多情最是王經理，寒夜騎車繞京華;

    Oopus 和诗：只眼橋邊識酒吧，癡人橋上冢中娃。務觀畫外前經理，海角天外笑拈華

  • The only corrected tutorial of connecting points to lines in CartoDB

    https://groups.google.com/forum/#!msg/cartodb/PHKbPWKvMmc/NKe18KSt-pUJ

    Hi Amanda,

    Are you doing the tutorial but with your own data? Did you get the tutorial to work just on its own first? It might help to run through it as is first so you can get a hang of what it does.
    To do it with the table map_1, I would just run this query,
    SELECT 0 as cartodb_id, ST_MakeLine(the_geom_webmercator) the_geom_webmercator FROM map_1
    UNION ALL
    SELECT cartodb_id, the_geom_webmercator FROM map_1
    The first half (before the UNION) makes a line from all your points. The second (after the UNION), just selects the points as is.
    Next, on your map you are probably only going to see points. That is because there is no style set for drawing a line. So I would use the following CSS,
    #map_1 {
     //points
     [mapnik-geometry-type=point] {
        marker-fill: #FF6600;
        marker-opacity: 1;
        marker-width: 12;
        marker-line-color: white;
        marker-line-width: 3;
        marker-line-opacity: 0.9;
        marker-placement: point;
        marker-type: ellipse;marker-allow-overlap: true;
      }
     //lines
     [mapnik-geometry-type=linestring] {
        line-color: #FF6600;
        line-width: 2;
        line-opacity: 0.7;
      }
    }
    hope that helps!
    Andrew