<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18904"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=328051920-18042010>Aurélien,</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=328051920-18042010></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=328051920-18042010><FONT color=#0000ff
size=2 face=Arial>Probably easier to use ST_MakeEnvelope to make a 4 sided
polygon. Also remember x is long and y is lat</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=328051920-18042010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=328051920-18042010><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.org/documentation/manual-1.5/ST_MakeEnvelope.html">http://www.postgis.org/documentation/manual-1.5/ST_MakeEnvelope.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=328051920-18042010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=328051920-18042010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=328051920-18042010>INSERT INTO geo_countries
(id, box)<BR> SELECT id, geography(ST_MakeEnvelope(min_longi,
min_lati, max_longi, max_lati,4326))</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=328051920-18042010> FROM
countries;</SPAN></DIV>
<DIV><FONT color=#0000ff size=2 face=Arial></FONT> </DIV>
<DIV><FONT color=#0000ff size=2 face=Arial></FONT> </DIV>
<DIV><SPAN class=328051920-18042010><FONT color=#0000ff size=2 face=Arial>Leo
and Regina,</FONT></SPAN></DIV>
<DIV><SPAN class=328051920-18042010><FONT color=#0000ff size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV><SPAN class=328051920-18042010><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><FONT color=#0000ff size=2 face=Arial></FONT><BR> </DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Aurélien ....<BR><B>Sent:</B> Saturday, April 17, 2010 7:53 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
ST_MakePolygon to represent a square<BR></FONT><BR></DIV>
<DIV></DIV>Hello everybody,<BR><BR>I'm new on Postgis and I need help to create
/ fill a table.<BR><BR>I have to make a column which represent a square
(min_lati, min_longi, max_lati, max_longi). I've done this :<BR><BR>CREATE TABLE
geo_countries (<BR> id bigint PRIMARY
KEY,<BR> box
geography(POLYGON,4326));<BR><BR>INSERT INTO geo_countries (id,
box)<BR> SELECT id, ST_MakePolygon(??) FROM
countries;<BR><BR>Is the POLYGON type is correct to make this ?<BR><BR>The
"countries" table have the fields min/max lati/longi, but I don't know how to
make a polygon with SQL command...<BR><BR>Can you help me ?<BR><BR>Thank you
very much,<BR><BR>Aurélien<BR><BR></BODY></HTML>