<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><div>INSERT INTO tablename (col1, col2, the_geom)</div><div>VALUES (value1, value2, geomfromtext('POLYGON((lat lon, lat lon, lat lon, lat lon, lat lon))',4326))</div><div><br></div><div>Where col1, col2 are column names and the geometry column is called the_geom</div><div><br></div><div>Phil</div><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><br><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> jiggi jug <jiggijug@gmail.com><br><b><span style="font-weight: bold;">To:</span></b> postgis-users@postgis.refractions.net<br><b><span style="font-weight: bold;">Sent:</span></b> Wed, 20 July, 2011 14:57:00<br><b><span style="font-weight: bold;">Subject:</span></b>
[postgis-users] Please post - Bounding box<br></font><br><meta http-equiv="x-dns-prefetch-control" content="off">Hi,<br>
<br>
I have just started using postGIS. I have to populate some satellite data<br>
into a table. I receive foot print in xml. I am getting<br>
footprint_lat[1] = 1.98146079413183642E+01<br>
footprint_lon[1] =-1.55761586451820648E+02<br>
footprint_lat[0] =1.97588878664455372E+01<br>
footprint_lon[0] =-1.55439677185788781E+02<br>
footprint_lat[2] =1.92503820033957886E+01<br>
footprint_lon[2] =-1.55513901957042549E+02<br>
footprint_lat[3] =1.93098870612302420E+01<br>
footprint_lon[3] =-1.55855972208092851E+02<br>
<br>
<br>
I have to create a table with column to store the above foot print data as<br>
polygon and insert this data into that column.Can anyone please help me with<br>
these create and insert statements.<br>
<br>
Also upto what precision should the floating point must be stored ususally.<br>
<br>
Appreciate your help.<br>
<meta http-equiv="x-dns-prefetch-control" content="on"></div></div><div style="position:fixed"></div>
</div></body></html>