I have a table with a column that contains MULTILINESTRINGs, where every string contains the longitude and latitude of a starting- and an end point, e.g.:
MULTILINESTRING((97.0253024 4.3685491,8.5618685 47.4524688))
Now I want to add geometry to those lines and make them curved so that I get an "arc" between the starting- and end point when I map them. What I have tried is the following:
UPDATE table_nameSET the_geom = ST_Transform(ST_GeomFromText(column_with_multilinestrings, 4326), 953027)
Shouldn't this change the reference system from 4326 to 953027? It somehow doesn't work for me, I only get the following error:
Geometry SRID (953027) does not match column SRID (4326).
I already checked this post and the links in it. I also had a look at the cartodb tutorial for making curved lines, but everything I have seen so far concentrates on making curved lines/arcs from a centre point to other points (i.e. A -> B, A -> C, A -> D, etc.). The problem I have, is that I don't know how to draw those arcs from A -> B, C -> D, E -> F, etc.
What am I doing wrong? How can I transform these multilines to curved lines (i.e. arcs)? Any help is very much appreciated! Thanks.
أكثر...
MULTILINESTRING((97.0253024 4.3685491,8.5618685 47.4524688))
Now I want to add geometry to those lines and make them curved so that I get an "arc" between the starting- and end point when I map them. What I have tried is the following:
UPDATE table_nameSET the_geom = ST_Transform(ST_GeomFromText(column_with_multilinestrings, 4326), 953027)
Shouldn't this change the reference system from 4326 to 953027? It somehow doesn't work for me, I only get the following error:
Geometry SRID (953027) does not match column SRID (4326).
I already checked this post and the links in it. I also had a look at the cartodb tutorial for making curved lines, but everything I have seen so far concentrates on making curved lines/arcs from a centre point to other points (i.e. A -> B, A -> C, A -> D, etc.). The problem I have, is that I don't know how to draw those arcs from A -> B, C -> D, E -> F, etc.
What am I doing wrong? How can I transform these multilines to curved lines (i.e. arcs)? Any help is very much appreciated! Thanks.
أكثر...