<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi list,<br>
<br>
Here at the work we are trying to make some spatial operations on our
GIS database, but when we try to generate functions like:<br>
<br>
<font face="Arial" size="2"><font color="#3f7f5f" size="2"><font
color="#0000ff"></font></font></font>
<p><font face="Arial" size="2"><font color="#3f7f5f" size="2"><font
color="#0000ff">"SELECT desc,address,picture,asText(geometry) AS
geometry FROM tab1"</font></font></font></p>
<p><font face="Arial" size="2"><font color="#3f7f5f" size="2"><font
color="#000000">This function works but this one:<br>
<br>
</font></font></font></p>
<font face="Arial" size="2"><font color="#3f7f5f" size="2"><font
color="#0000ff" size="2">
<p>SELECT PointOnSurface(geometry) FROM tab1<br>
</p>
<p> </p>
<p><font color="#000000">the PostGIS returns:</font></p>
</font></font></font>
<dl>
<dd><small><font color="#ff0000">org.postgresql.util.PSQLException:
ERROR: pointonsurface:: operation not implemented - compile PostGIS
with JTS or GEOS supportat </font></small></dd>
<dd><small><font color="#ff0000">org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)</font></small></dd>
<dd><small><font color="#ff0000">at
org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)</font></small></dd>
<dd><small><font color="#ff0000">at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)</font></small></dd>
<dd><small><font color="#ff0000">at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)</font></small></dd>
<dd><small><font color="#ff0000">at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)</font></small></dd>
<dd><small><font color="#ff0000">at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)</font></small></dd>
<dd><small><font color="#ff0000">at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)</font></small></dd>
<dd><small><font color="#ff0000">at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:221)</font></small></dd>
<dd><small><font color="#ff0000">at
dados.JavaGIS.main(JavaGIS.java:112)</font></small></dd>
</dl>
I hope someone could help me on this problem.<br>
<br>
Sincerely...<br>
<pre class="moz-signature" cols="72">--
Ezequias Rodrigues da Rocha
<a class="moz-txt-link-freetext" href="http://ezequiasrocha.blogspot.com">http://ezequiasrocha.blogspot.com</a>
<a class="moz-txt-link-abbreviated" href="mailto:msn:ezequias@hotmail.com">msn:ezequias@hotmail.com</a>
"the worst of democracies is still better than the best of dictatorship"
</pre>
</body>
</html>