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 <[email protected]>
To: [email protected]
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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
