Hello everybody,
I'm new on Postgis and I need help to create / fill a table.
I have to make a column which represent a square (min_lati, min_longi,
max_lati, max_longi). I've done this :
CREATE TABLE geo_countries (
id bigint PRIMARY KEY,
box geography(POLYGON,4326));
INSERT INTO geo_countries (id, box)
SELECT id, ST_MakePolygon(??) FROM countries;
Is the POLYGON type is correct to make this ?
The "countries" table have the fields min/max lati/longi, but I don't know
how to make a polygon with SQL command...
Can you help me ?
Thank you very much,
Aurélien
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
