Timeline for How do I explode a MultiLineString using ST_Dump() in PostGIS?
Current License: CC BY-SA 3.0
17 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 4, 2016 at 1:45 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 4, 2016 at 17:55 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 29, 2016 at 5:12 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 27, 2016 at 8:48 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 26, 2016 at 16:05 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 25, 2016 at 21:56 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 31, 2015 at 12:59 | history | edited | Travis Feast | CC BY-SA 3.0 |
deleted 258 characters in body
|
| Jul 14, 2015 at 10:07 | comment | added | iriberri |
CartoDB generates any line as a MultiLineString. This is probably that comes from postgres but I don't know the details. In step 3 you're making an incorrect assumption. You can set the SRID for your query this way: INSERT INTO complex (name, the_geom) VALUES ( 'Bob', ST_SetSRID(ST_GeomFromEWKT('MULTILINESTRING((498376.89 651569.6,498372.28 651571.89),(498372.28 651571.89,498371.77 651576.05))'), 4326) ), but a line with 3 points is not a MultiLineString in the sense that the geometry is formed by 3 lines, it's just a single line with 3 vertices.
|
|
| Jun 28, 2015 at 19:51 | comment | added | Travis Feast |
In step 5, I can get the_geom_webmercator as an output by adding (to the top SELECT query): ST_Transform((simple.geom_dump).geom,3857) as the_geom_webmercator, ... But, am I using the wrong geometry? ST_Transform((simple.simple_geom).geom,3857) produces an error: "column notation .geom applied to type geometry, which is not a composite type". Not sure what is happening here...
|
|
| Jun 9, 2015 at 14:15 | history | edited | Travis Feast | CC BY-SA 3.0 |
Added that I'm working with a Postgresql table
|
| Jun 9, 2015 at 14:13 | comment | added | Travis Feast |
Thanks for your help John and simplexio. I've updated my post with step-by-step details to show the trouble I'm having with running the ST_Dump function in CartoDB. Once I figure this part out, perhaps then I'll deal with how to offset overlapping line segments in another question/post.
|
|
| Jun 9, 2015 at 14:07 | history | edited | Travis Feast | CC BY-SA 3.0 |
Added step-by-step details, SQL & tables
|
| Jun 9, 2015 at 12:32 | history | edited | Travis Feast | CC BY-SA 3.0 |
added 18 characters in body
|
| Jun 8, 2015 at 13:03 | comment | added | John Powell | The coalesce part simply creates a new id by combining the initial id with a path id (which will be unique for each linestring form the dumped multipolygon). The query above has one extra subquery, which doesn't aid understanding, but should still work correctly. What issue are you actually seeing in CartoDB. | |
| Jun 8, 2015 at 7:02 | answer | added | simpleuser001 | timeline score: 4 | |
| Jun 8, 2015 at 5:56 | review | First posts | |||
| Jun 8, 2015 at 6:13 | |||||
| Jun 8, 2015 at 5:54 | history | asked | Travis Feast | CC BY-SA 3.0 |