[postgis-users] Please post - Bounding box

[dornakal]

Thank you much for quick reply. upto what precision should we store the data?



Phil James wrote:
> 
> INSERT INTO tablename (col1, col2, the_geom)
> VALUES (value1, value2, geomfromtext('POLYGON((lat lon, lat lon, lat lon,
> lat 
> lon, lat lon))',4326))
> 
> Where col1, col2 are column names and the geometry column is called
> the_geom
> 
> Phil
> 
> 
> 
> ________________________________
> From: jiggi jug <jiggijug at gmail.com>
> To: postgis-users at postgis.refractions.net
> Sent: Wed, 20 July, 2011 14:57:00
> Subject: [postgis-users] Please post - Bounding box
> 
> 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.
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://old.nabble.com/Please-post---Bounding-box-tp32099353p32101350.html
Sent from the PostGIS - User mailing list archive at Nabble.com.