Reading the solution to PostGIS > Intersect two circles. Each Circle must be built from Long/Lat degrees plus radius got me thinking. How can I graphically display a SQL query? It doesn't need to be cartographic quality. A sketch for debugging purposes would be sufficient.
For example, this SQL is in the accepted solution:
SELECT ST_Touches(temp.point1, temp.point2) as geom_touches, ST_Intersects(temp.point1, temp.point2) as geom_intersectFROM (SELECT * FROM ST_Buffer(ST_Transform(ST_GeomFromText('POINT(-105.05083 39.74823)', 4326), 2877), 1500) as point1, ST_Buffer(ST_Transform(ST_GeomFromText('POINT(-105.04428 39.74779)', 4326), 2877), 1500) as point2 )as tempHow could I draw ST_Touches() and ST_Intersects() - the geometry, not the boolean?
أكثر...
For example, this SQL is in the accepted solution:
SELECT ST_Touches(temp.point1, temp.point2) as geom_touches, ST_Intersects(temp.point1, temp.point2) as geom_intersectFROM (SELECT * FROM ST_Buffer(ST_Transform(ST_GeomFromText('POINT(-105.05083 39.74823)', 4326), 2877), 1500) as point1, ST_Buffer(ST_Transform(ST_GeomFromText('POINT(-105.04428 39.74779)', 4326), 2877), 1500) as point2 )as tempHow could I draw ST_Touches() and ST_Intersects() - the geometry, not the boolean?
أكثر...