You could try : http://postgis.refractions.net/documentation/manual-1.5/ST_Buffer.html
You might need something like : ST_MakePolygon(ST_ExteriorRing(ST_Buffer(tower.point, resultOfDistanceFunction))) cheers Ben On 02/06/2011, at 3:55 AM, vikashvikky wrote: > > Hi, > > I am doing a project for a telecom company. I have to render circles on the > map(assuming the center of the circle as tower and circle as the area > covered by that signal), I am using base layers as Google Maps,Yahoo > maps(Spherical Mercator) So I have used CreateGeodesicPolygon() successfully > to create circles by reading the values from DB. > > Now Since I have to render lot of circles, it made me switch to geoserver. > Since the data is being provided by telecom company , they provide > Lat,Lon,Gt,Gr,Pt,Pr,lambda(I think their meaning is irrelevant here) values. > These values are stored in the database as they are. Now should use a > equation(FRIIS transmission equation) and substitute each row(of a tower) > values to find the distance covered by the tower.Then I have to create > circles with that distance(considered as radius) and lon/lat and render them > on map using geoserver. > > Please suggest me any ideas of how to carry on this task.... I wud be > thankful to your guidance > -- > View this message in context: > http://old.nabble.com/Create-circles-using-a-formula-tp31752667p31752667.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
