{"id":46,"date":"2015-06-08T16:36:43","date_gmt":"2015-06-08T20:36:43","guid":{"rendered":"https:\/\/www.oopus.info\/blog\/?p=46"},"modified":"2015-06-08T16:36:43","modified_gmt":"2015-06-08T20:36:43","slug":"the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb","status":"publish","type":"post","link":"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/","title":{"rendered":"The only corrected tutorial of connecting points to lines in CartoDB"},"content":{"rendered":"

https:\/\/groups.google.com\/forum\/#!msg\/cartodb\/PHKbPWKvMmc\/NKe18KSt-pUJ<\/p>\n

Hi Amanda,<\/p>\n

<\/div>\n
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.<\/div>\n
<\/div>\n
To do it with the table map_1, I would just run this query,<\/div>\n
<\/div>\n
\n
SELECT 0 as cartodb_id, ST_MakeLine(the_geom_webmercator) the_geom_webmercator FROM map_1<\/div>\n
UNION ALL<\/div>\n
SELECT cartodb_id, the_geom_webmercator FROM map_1<\/div>\n
<\/div>\n
<\/div>\n
The first half (before the UNION) makes a line from all your points. The second (after the UNION), just selects the points as is.<\/div>\n
<\/div>\n
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,<\/div>\n
<\/div>\n
\n
#map_1 {<\/div>\n
\u00a0\/\/points<\/div>\n
\u00a0[mapnik-geometry-type=point] {<\/div>\n
\u00a0 \u00a0 marker-fill: #FF6600;<\/div>\n
\u00a0 \u00a0 marker-opacity: 1;<\/div>\n
\u00a0 \u00a0 marker-width: 12;<\/div>\n
\u00a0 \u00a0 marker-line-color: white;<\/div>\n
\u00a0 \u00a0 marker-line-width: 3;<\/div>\n
\u00a0 \u00a0 marker-line-opacity: 0.9;<\/div>\n
\u00a0 \u00a0 marker-placement: point;<\/div>\n
\u00a0 \u00a0 marker-type: ellipse;marker-allow-overlap: true;<\/div>\n
\u00a0 }<\/div>\n
\u00a0\/\/lines<\/div>\n
\u00a0[mapnik-geometry-type=linestring] {<\/div>\n
\u00a0 \u00a0 line-color: #FF6600;<\/div>\n
\u00a0 \u00a0 line-width: 2;<\/div>\n
\u00a0 \u00a0 line-opacity: 0.7;<\/div>\n
\u00a0 }<\/div>\n
}<\/div>\n
<\/div>\n
<\/div>\n
hope that helps!<\/div>\n
<\/div>\n
Andrew<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[13],"tags":[],"class_list":["post-46","post","type-post","status-publish","format-standard","hentry","category-gis"],"yoast_head":"\nThe only corrected tutorial of connecting points to lines in CartoDB - Oopus Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The only corrected tutorial of connecting points to lines in CartoDB - Oopus Blog\" \/>\n<meta property=\"og:description\" content=\"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 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/\" \/>\n<meta property=\"og:site_name\" content=\"Oopus Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-06-08T20:36:43+00:00\" \/>\n<meta name=\"author\" content=\"oopus\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"oopus\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/\"},\"author\":{\"name\":\"oopus\",\"@id\":\"https:\/\/www.oopus.info\/blog\/#\/schema\/person\/0491ca0bc5ba1f23b62bb7be621f29c9\"},\"headline\":\"The only corrected tutorial of connecting points to lines in CartoDB\",\"datePublished\":\"2015-06-08T20:36:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/\"},\"wordCount\":186,\"commentCount\":0,\"articleSection\":[\"GIS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/\",\"url\":\"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/\",\"name\":\"The only corrected tutorial of connecting points to lines in CartoDB - Oopus Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.oopus.info\/blog\/#website\"},\"datePublished\":\"2015-06-08T20:36:43+00:00\",\"author\":{\"@id\":\"https:\/\/www.oopus.info\/blog\/#\/schema\/person\/0491ca0bc5ba1f23b62bb7be621f29c9\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.oopus.info\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The only corrected tutorial of connecting points to lines in CartoDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.oopus.info\/blog\/#website\",\"url\":\"https:\/\/www.oopus.info\/blog\/\",\"name\":\"Oopus Blog\",\"description\":\"Oopu's self-recording\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.oopus.info\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.oopus.info\/blog\/#\/schema\/person\/0491ca0bc5ba1f23b62bb7be621f29c9\",\"name\":\"oopus\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/e6169b542ea65ef728fae42c117aa13b4897842f8263161765d1384a2a6e6fd9?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e6169b542ea65ef728fae42c117aa13b4897842f8263161765d1384a2a6e6fd9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e6169b542ea65ef728fae42c117aa13b4897842f8263161765d1384a2a6e6fd9?s=96&d=mm&r=g\",\"caption\":\"oopus\"},\"sameAs\":[\"http:\/\/www.oopus.info\/blog\"],\"url\":\"https:\/\/www.oopus.info\/blog\/author\/oopus\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The only corrected tutorial of connecting points to lines in CartoDB - Oopus Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/","og_locale":"en_US","og_type":"article","og_title":"The only corrected tutorial of connecting points to lines in CartoDB - Oopus Blog","og_description":"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 […]","og_url":"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/","og_site_name":"Oopus Blog","article_published_time":"2015-06-08T20:36:43+00:00","author":"oopus","twitter_card":"summary_large_image","twitter_misc":{"Written by":"oopus","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/#article","isPartOf":{"@id":"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/"},"author":{"name":"oopus","@id":"https:\/\/www.oopus.info\/blog\/#\/schema\/person\/0491ca0bc5ba1f23b62bb7be621f29c9"},"headline":"The only corrected tutorial of connecting points to lines in CartoDB","datePublished":"2015-06-08T20:36:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/"},"wordCount":186,"commentCount":0,"articleSection":["GIS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/","url":"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/","name":"The only corrected tutorial of connecting points to lines in CartoDB - Oopus Blog","isPartOf":{"@id":"https:\/\/www.oopus.info\/blog\/#website"},"datePublished":"2015-06-08T20:36:43+00:00","author":{"@id":"https:\/\/www.oopus.info\/blog\/#\/schema\/person\/0491ca0bc5ba1f23b62bb7be621f29c9"},"breadcrumb":{"@id":"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.oopus.info\/blog\/2015\/06\/08\/the-only-corrected-tutorial-of-connecting-points-to-lines-in-cartodb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.oopus.info\/blog\/"},{"@type":"ListItem","position":2,"name":"The only corrected tutorial of connecting points to lines in CartoDB"}]},{"@type":"WebSite","@id":"https:\/\/www.oopus.info\/blog\/#website","url":"https:\/\/www.oopus.info\/blog\/","name":"Oopus Blog","description":"Oopu's self-recording","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.oopus.info\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.oopus.info\/blog\/#\/schema\/person\/0491ca0bc5ba1f23b62bb7be621f29c9","name":"oopus","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e6169b542ea65ef728fae42c117aa13b4897842f8263161765d1384a2a6e6fd9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e6169b542ea65ef728fae42c117aa13b4897842f8263161765d1384a2a6e6fd9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e6169b542ea65ef728fae42c117aa13b4897842f8263161765d1384a2a6e6fd9?s=96&d=mm&r=g","caption":"oopus"},"sameAs":["http:\/\/www.oopus.info\/blog"],"url":"https:\/\/www.oopus.info\/blog\/author\/oopus\/"}]}},"_links":{"self":[{"href":"https:\/\/www.oopus.info\/blog\/wp-json\/wp\/v2\/posts\/46","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oopus.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oopus.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oopus.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oopus.info\/blog\/wp-json\/wp\/v2\/comments?post=46"}],"version-history":[{"count":0,"href":"https:\/\/www.oopus.info\/blog\/wp-json\/wp\/v2\/posts\/46\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.oopus.info\/blog\/wp-json\/wp\/v2\/media?parent=46"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oopus.info\/blog\/wp-json\/wp\/v2\/categories?post=46"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oopus.info\/blog\/wp-json\/wp\/v2\/tags?post=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}