Hi all,<br>I am trying to join 2 points on earth (SRID 4326) by a line but somehow I m not able to see that in QGIS.<br><br>I have taken some latitudes and longitudes and created points. When I create POINT column and load these points, I can see them on QGIS at exact same locations. (Boston, MA will be at same position where it is now wrt MA state shapefile)<br>
<br>Now when i try to join two points (E.g. Boston and Some other place in MA), it does not appear on QGIS.<br><br>I tried following queries for linestring construction -<br>1) insert into sridline (the_geom) values (ST_setSRID(ST_MakeLine(ST_MakePoint(42.5667212, -70.987212),ST_MakePoint(44.5667212, -70.987212)),4326));<br>
Other thing I tried is :<br>2) insert into sridline (the_geom) values (GeomFromText('Linestring(42.342305 -71.04858,42.278325 -70.874176)',4326));<br><br>For generating POINT :<br>UPDATE sridpoint<br> SET the_geom = ST_SetSRID(ST_Point( longitude,latitude),4326);<br>
<br>I can draw linestring when SRID = -1 but with SRID, I am facing problems.<br>Please let me know if someone is aware of how to generate linestring when SRID is specified. <br><br>Thanks<br>Siddhesh<br><br>