Guest User

Untitled

a guest
Jun 30th, 2016
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. CREATE TABLE sites(gid serial PRIMARY KEY,the_geog geography(POLYGON,4326) )
  2. INSERT INTO sites (gid,the_geog) VALUES (1,ST_Buffer(geography(ST_GeomFromText(POINT(78.2529 23.6897))), 20000))
  3.  
  4. SELECT ST_AsText(ST_Difference(linestring,
  5. (SELECT ST_Union(sites.the_geog::geometry)
  6. FROM new_towers WHERE
  7. ST_Intersects( roads ,sites.the_geog::geography ))))
  8. FROM ST_GeometryFromText('SRID=4326;LINESTRING(linestring)') as roads
Add Comment
Please, Sign In to add comment