I have two tables both of them has linestring geometry. I try to make a new one which contain the first one and from the second take only the decimal v when the linestring of the first table touch a linestring of the second.
CREATE TABLE Three AS( SELECT st_astext(r.geom),e."v" FROM r , e WHERE ST_Touches(e.geom, ST_Transform(r.geom,4326))); But i am not take an error or a result , the geom of r is in another srid than the 4326 which is the e and i transform it.
أكثر...
CREATE TABLE Three AS( SELECT st_astext(r.geom),e."v" FROM r , e WHERE ST_Touches(e.geom, ST_Transform(r.geom,4326))); But i am not take an error or a result , the geom of r is in another srid than the 4326 which is the e and i transform it.
أكثر...