<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16588"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=510453721-05082010><FONT color=#0000ff
size=2 face=Arial>Are you sure you are suing PostGIS? PostGIS geometry
type is just geometry.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=510453721-05082010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=510453721-05082010><FONT color=#0000ff
size=2 face=Arial>I believe ESRI PostgreSQL SDE calls their datatype
sde.st_geometry which seems closer to what you are trying to do
there.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=510453721-05082010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=510453721-05082010><FONT color=#0000ff
size=2 face=Arial>So your query for PostGIS should be just</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=510453721-05082010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=510453721-05082010>CREATE TABLE polygon_test
(p1 geometry);</SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=510453721-05082010></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=510453721-05082010><FONT color=#0000ff
size=2 face=Arial>We use PostGIS in PHP and we don't use any additional dlls
aside from the postgresql one.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=510453721-05082010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=510453721-05082010><FONT color=#0000ff
size=2 face=Arial>Leo and Regina,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=510453721-05082010><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV><BR>
<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>Jim
Smith<BR><B>Sent:</B> Thursday, August 05, 2010 12:36 PM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] PostGIS
PHP setup on Windows 7<BR></FONT><BR></DIV>
<DIV></DIV>I'm not configuring PHP to work with PostGIS. So, when I try in PHP:
<DIV><BR></DIV>
<DIV>require_once 'postgresqlConnect.php'; //make a connection to the
database</DIV>
<DIV>pg_query("CREATE TABLE polygon_test (p1 st_geometry)");</DIV>
<DIV><BR></DIV>
<DIV>I get:</DIV>
<DIV><BR></DIV>
<DIV><SPAN style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: medium"
class=Apple-style-span><B>Warning</B></SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: medium"
class=Apple-style-span>: pg_query() [</SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: medium"
class=Apple-style-span><A
href="http://localhost/processDatabase/function.pg-query">function.pg-query</A></SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: medium"
class=Apple-style-span>]: Query failed: ERROR: type "st_geometry" does not exist
LINE 1: CREATE TABLE polygon_test (p1 st_geometry) ^ in</SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: medium"
class=Apple-style-span><B>C:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\processDatabase\fillPostgresTable.php</B></SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: medium"
class=Apple-style-span> </SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: medium"
class=Apple-style-span>on line</SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: medium"
class=Apple-style-span> </SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: medium"
class=Apple-style-span><B>51</B></SPAN></DIV>
<DIV><FONT class=Apple-style-span face="'Times New Roman'"><SPAN
style="FONT-SIZE: medium" class=Apple-style-span><B><BR></B></SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="'Times New Roman'"><SPAN
style="FONT-SIZE: medium" class=Apple-style-span><B><SPAN
style="FONT-FAMILY: arial; FONT-SIZE: small; FONT-WEIGHT: normal"
class=Apple-style-span>I can use PgAdminIII and use st_geometry. With PHP I've
added the PostgreSQL bits so I can access the
database.</SPAN></B></SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="'Times New Roman'"><SPAN
style="FONT-SIZE: medium" class=Apple-style-span><B><SPAN
style="FONT-FAMILY: arial; FONT-SIZE: small; FONT-WEIGHT: normal"
class=Apple-style-span><BR></SPAN></B></SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="'Times New Roman'"><SPAN
style="FONT-SIZE: medium" class=Apple-style-span><B><SPAN
style="FONT-FAMILY: arial; FONT-SIZE: small; FONT-WEIGHT: normal"
class=Apple-style-span>What I'm missing is the bits I've got to add to
php.ini extensions. There are probably some PostGIS dlls that I'm missing as
well to make PHP happy.</SPAN></B></SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="'Times New Roman'"><SPAN
style="FONT-SIZE: medium" class=Apple-style-span><B><SPAN
style="FONT-FAMILY: arial; FONT-SIZE: small; FONT-WEIGHT: normal"
class=Apple-style-span><BR></SPAN></B></SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span face="'Times New Roman'"><SPAN
style="FONT-SIZE: medium" class=Apple-style-span><B><SPAN
style="FONT-FAMILY: arial; FONT-SIZE: small; FONT-WEIGHT: normal"
class=Apple-style-span>If someone could point me in the right direction for
getting PHP to work with PostGIS, I'd appreciate
it.</SPAN></B></SPAN></FONT></DIV>
<DIV><BR></DIV></BODY></HTML>