[postgis-users] How to add circle to Postgis database?

Gustavo Henrique Sberze Ribas gribas at cpqd.com.br
Wed Mar 7 07:55:01 PST 2007


> hi i get this data and don't know hove add this to postgis 
> database what type of geometry it is (MULTILINESTRING,POLYGON)?
> 
> center-X: -87.69581735217052,
> center-Y: 43.75183840008278
> Radius: 0.007124880185134723


  You can use the 'buffer' function to create a polygon that resembles a
circle. 
Ex:
  select buffer('POINT(-87.69581735217052
43.75183840008278)',0.007124880185134723);

--
Gustavo



More information about the postgis-users mailing list