[postgis-users] ST_MakePolygon to represent a square

Aurélien .... kinju59 at gmail.com
Sat Apr 17 04:53:25 PDT 2010


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100417/48f07fae/attachment.html>


More information about the postgis-users mailing list