<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; ">As I tell my students the precision is purely spurious. Geometry is stored as double precision values as far as I know but after the first few decimal places you soon get beyond what is measurable by modern survey instruments so I wouldn't worry about it.</div><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; "><br></div><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; ">If you take a UTM zone measurement in metres at 4240000.5555555, the values after the decimal point are</div><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; ">decimetre, centimetre, millimetre, micrometre, nanonmetre, picometre.</div><div style="font-family: arial, helvetica, sans-serif;
font-size: 12pt; "><br></div><div style="font-family: arial, helvetica, sans-serif; "><font class="Apple-style-span" size="3">A picometre is </font><span class="Apple-style-span" style="font-family: sans-serif; font-size: 13px; line-height: 19px; ">1×10<sup style="line-height: 1em; ">−12</sup> m - </span><span class="Apple-style-span" style="font-family: sans-serif; line-height: 19px; ">you need about 100 or more to measure an atom. Obviously with Lat/Lon you are using an angular measurement but the same concept applies.</span></div><div><font class="Apple-style-span" face="sans-serif"><span class="Apple-style-span" style="line-height: 19px;"><br></span></font></div><div><font class="Apple-style-span" face="sans-serif"><span class="Apple-style-span" style="line-height: 19px;">Hope this helps</span></font></div><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; "><br></div><div style="font-family: arial, helvetica,
sans-serif; font-size: 12pt; ">Phil<br><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> dornakal <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 18:32:25<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] Please post - Bounding box<br></font><br><br>Thank you much for quick reply. upto what precision should we store the data?<br><br><br><br>Phil James wrote:<br>> <br>> INSERT INTO tablename (col1, col2, the_geom)<br>> VALUES (value1, value2, geomfromtext('POLYGON((lat lon, lat lon, lat lon,<br>> lat <br>> lon, lat lon))',4326))<br>> <br>> Where col1, col2 are column names and the geometry column is called<br>> the_geom<br>> <br>>
Phil<br>> <br>> <br>> <br>> ________________________________<br>> From: jiggi jug <<a ymailto="mailto:jiggijug@gmail.com" href="mailto:jiggijug@gmail.com">jiggijug@gmail.com</a>><br>> To: <a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> Sent: Wed, 20 July, 2011 14:57:00<br>> Subject: [postgis-users] Please post - Bounding box<br>> <br>> 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<br>> with<br>> these create and insert statements.<br>> <br>> Also upto what precision should the floating point must be stored<br>> ususally.<br>> <br>> Appreciate your help.<br>> <br>> _______________________________________________<br>> postgis-users mailing list<br>> <a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>> <br>> <br><br>-- <br>View this message in context: <a
href="http://old.nabble.com/Please-post---Bounding-box-tp32099353p32101350.html" target="_blank">http://old.nabble.com/Please-post---Bounding-box-tp32099353p32101350.html</a><br>Sent from the PostGIS - User mailing list archive at Nabble.com.<br><br>_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></div></div><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; position: fixed; "></div>
</div></body></html>