Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE sites(gid serial PRIMARY KEY,the_geog geography(POLYGON,4326) )
- INSERT INTO sites (gid,the_geog) VALUES (1,ST_Buffer(geography(ST_GeomFromText(POINT(78.2529 23.6897))), 20000))
- SELECT ST_AsText(ST_Difference(linestring,
- (SELECT ST_Union(sites.the_geog::geometry)
- FROM new_towers WHERE
- ST_Intersects( roads ,sites.the_geog::geography ))))
- FROM ST_GeometryFromText('SRID=4326;LINESTRING(linestring)') as roads
Add Comment
Please, Sign In to add comment