[postgis-users] Please post - Bounding box

[jiggi jug]

Hi,

I have just started using postGIS. I have to populate some satellite data
into a table. I receive foot print in xml. I am getting
footprint_lat[1] = 1.98146079413183642E+01
footprint_lon[1] =-1.55761586451820648E+02
footprint_lat[0] =1.97588878664455372E+01
footprint_lon[0] =-1.55439677185788781E+02
 footprint_lat[2] =1.92503820033957886E+01
footprint_lon[2] =-1.55513901957042549E+02
footprint_lat[3] =1.93098870612302420E+01
footprint_lon[3] =-1.55855972208092851E+02


I have to create a table with column to store the above foot print data as
polygon and insert this data into that column.Can anyone please help me with
these create and insert statements.

Also upto  what precision should the floating point must be stored ususally.

Appreciate your help.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101020/622f4f5d/attachment.html>