<!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.16625"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT color=#0000ff
size=2 face=Arial>Venkat,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT color=#0000ff
size=2 face=Arial>We have 2.0 binaries available for windows. Keep in mind
that PostGIS 2.0 is still in alpha and has not been released yet.
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT color=#0000ff
size=2 face=Arial>You can download the windows binaries from here (for
PostgreSQL 9.0 and 8.4) . We try to update them once every 2 weeks or when
anything exciting happens.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.org/download/windows/experimental.php">http://www.postgis.org/download/windows/experimental.php</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT size=2
face=Arial>We'll probably put up new versions later this week around the time we
put up the PostGIS 1.5.2 binaries.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT size=2
face=Arial>Leo and Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT size=2
face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=116064117-20092010><FONT color=#0000ff
size=2 face=Arial></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>venkat<BR><B>Sent:</B> Monday, September 20, 2010 9:27 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> Re: [postgis-users]
postgis-users Digest, Vol 101, Issue 15<BR></FONT><BR></DIV>
<DIV></DIV><FONT color=#3366ff>Dear All,</FONT>
<DIV><FONT color=#3366ff><BR></FONT></DIV>
<DIV><FONT color=#3366ff> When PostGIS2.0 will be out for
windows.</FONT></DIV>
<DIV><FONT color=#3366ff><BR></FONT></DIV>
<DIV><FONT color=#3366ff>Thanks and Regards,</FONT></DIV>
<DIV><FONT color=#3366ff><BR></FONT></DIV>
<DIV><FONT color=#3366ff>Venkat<BR></FONT><BR>
<DIV class=gmail_quote>On Thu, Sep 16, 2010 at 12:30 AM, <SPAN dir=ltr><<A
href="mailto:postgis-users-request@postgis.refractions.net">postgis-users-request@postgis.refractions.net</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>Send postgis-users mailing list submissions to<BR>
<A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><BR>To
subscribe or unsubscribe via the World Wide Web, visit<BR>
<A href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>or,
via email, send a message with subject or body 'help' to<BR>
<A
href="mailto:postgis-users-request@postgis.refractions.net">postgis-users-request@postgis.refractions.net</A><BR><BR>You
can reach the person managing the list at<BR> <A
href="mailto:postgis-users-owner@postgis.refractions.net">postgis-users-owner@postgis.refractions.net</A><BR><BR>When
replying, please edit your Subject line so it is more specific<BR>than "Re:
Contents of postgis-users digest..."<BR><BR><BR>Today's Topics:<BR><BR>
1. Inserting Geometries into PostGres database - ??? (CS)<BR> 2. Re:
Inserting Geometries into PostGres database - ???<BR>
(Stephen Woodbridge)<BR> 3. Re: unioning a buffer - bug? (Kevin
Neufeld)<BR> 4. Re: Inserting Geometries into PostGres database -
???<BR> (Kevin Neufeld)<BR> 5. ST_Split function is
not working in PostGIS 1.5 (venkat)<BR> 6. Re: ST_Split function is not
working in PostGIS 1.5<BR> (Paragon
Corporation)<BR><BR><BR>----------------------------------------------------------------------<BR><BR>Message:
1<BR>Date: Tue, 14 Sep 2010 16:12:23 -0500<BR>From: CS <<A
href="mailto:cspam1234@gmail.com">cspam1234@gmail.com</A>><BR>Subject:
[postgis-users] Inserting Geometries into PostGres database -<BR>
???<BR>To: <A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>Message-ID:
<<A
href="mailto:C05C04F7-4F38-42D5-8C94-91D910C2E336@gmail.com">C05C04F7-4F38-42D5-8C94-91D910C2E336@gmail.com</A>><BR>Content-Type:
text/plain; charset="us-ascii"<BR><BR>Hi all. I am having problems inserting a
geometry type into a database. I am using postgres 8.4 and whatever the latest
postgis there is(i forgot now). Linux with glassfish is the server
environment.<BR><BR>I have seen multiple hardcoded examples about how to
insert something in the VALUES clause but what if i have an array of polygons
that cannot be hardcoded that is already determined? That is the coordinates
and type of the shape is already decided. This lends to the question as to
whether you can use a preparedStatement and setString to insert a geometry.
This is what i need some help on.<BR><BR><BR>an example of a WKT for a certain
cell that i have is:<BR><BR>POLYGON ((-90.406 31.07360133086052, -90.406
31.34423828125, -90.09073538749632 31.34423828125, -90.09073538749632
31.07360133086052, -90.406 31.07360133086052))<BR><BR>i want to be able to
take this(as a string, if possible) and insert into the database using a
prepared statement.<BR><BR><BR>PreparedStatement.setString(1,
cells[cellIndex].getShape().getWkt());, where getWKT returns the string
representation. Of course this doesnt work because the type of the column is a
postgis geometry. So, again, how do you use a prepared statement to insert a
WKT string representation?<BR><BR><BR>I have tried this:<BR><BR>String
tempString = cells[cellIndex].getShape().getWkt();<BR>String parameterInsert =
"insert into Cell(result, report, modified, cellid, missionid, shape) values
(?, ?, ?, ?, ?, GeomFromText(tempString,4326))";<BR><BR>where tempString would
be the POLYGON above and i get the error: org.postgresql.util.PSQLException:
ERROR: Invalid OGC WKT (does not<BR>start with P,L,M or G), which doesnt
really make much sense to me.<BR><BR>I try to put single quotes around each
one like:<BR><BR>String tempString = "'" +
cells[cellIndex].getShape().getWkt() + "'";<BR><BR>and i get the error that
tempString as a column does not exist.<BR><BR><BR>There also seems to be
some confusion on the postgis message boards whether a single quote is even
needed. I was never able to come to a definite conclusion.<BR><BR><BR>I would
appreciate help to all who could help. ive tried everything that i know at
this point. Thanks a bunch in advance!<BR><BR>CS<BR>-------------- next part
--------------<BR>An HTML attachment was scrubbed...<BR>URL: <<A
href="http://postgis.refractions.net/pipermail/postgis-users/attachments/20100914/ee037f18/attachment-0001.html"
target=_blank>http://postgis.refractions.net/pipermail/postgis-users/attachments/20100914/ee037f18/attachment-0001.html</A>><BR><BR>------------------------------<BR><BR>Message:
2<BR>Date: Tue, 14 Sep 2010 17:38:56 -0400<BR>From: Stephen Woodbridge <<A
href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</A>><BR>Subject:
Re: [postgis-users] Inserting Geometries into PostGres<BR>
database - ???<BR>To: <A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>Message-ID:
<<A
href="mailto:4C8FEB70.3040808@swoodbridge.com">4C8FEB70.3040808@swoodbridge.com</A>><BR>Content-Type:
text/plain; charset=ISO-8859-1; format=flowed<BR><BR>On 9/14/2010 5:12 PM, CS
wrote:<BR>> Hi all. I am having problems inserting a geometry type into a
database.<BR>> I am using postgres 8.4 and whatever the latest postgis
there is(i<BR>> forgot now). Linux with glassfish is the server
environment.<BR>><BR>> I have seen multiple hardcoded examples about how
to insert something in<BR>> the VALUES clause but what if i have an array
of polygons that cannot be<BR>> hardcoded that is already determined? That
is the coordinates and type<BR>> of the shape is already decided. This
lends to the question as to<BR>> whether you can use a preparedStatement
and setString to insert a<BR>> geometry. This is what i need some help
on.<BR>><BR>><BR>> an example of a WKT for a certain cell that i have
is:<BR>><BR>> POLYGON ((-90.406 31.07360133086052, -90.406
31.34423828125,<BR>> -90.09073538749632 31.34423828125, -90.09073538749632
31.07360133086052,<BR>> -90.406 31.07360133086052))<BR>><BR>> i want
to be able to take this(as a string, if possible) and insert into<BR>> the
database using a prepared statement.<BR>><BR>><BR>>
PreparedStatement.setString(1, cells[cellIndex].getShape().getWkt());,<BR>>
where getWKT returns the string representation. Of course this doesnt<BR>>
work because the type of the column is a postgis geometry. So, again,<BR>>
how do you use a prepared statement to insert a WKT string
representation?<BR>><BR>><BR>> I have tried this:<BR>><BR>>
String tempString = cells[cellIndex].getShape().getWkt();<BR>> String
parameterInsert = "insert into Cell(result, report, modified,<BR>> cellid,
missionid, shape) values (?, ?, ?, ?, ?,<BR>>
GeomFromText(tempString,4326))";<BR><BR>You might try something
like:<BR><BR>String parameterInsert = "insert into Cell(result, report,
modified,<BR>cellid, missionid, shape) values (?, ?, ?, ?,
?,<BR> GeomFromText(" + tempString + ",4326))";<BR><BR>And see if that
works.<BR><BR>-Steve W<BR><BR>> where tempString would be the POLYGON above
and i get the error:<BR>> org.postgresql.util.PSQLException: ERROR: Invalid
OGC WKT (does not<BR>><BR>> start with P,L,M or G), which doesnt really
make much sense to me.<BR>><BR>><BR>> I try to put single quotes
around each one like:<BR>><BR>> String tempString = "'" +
cells[cellIndex].getShape().getWkt() + "'";<BR>><BR>> and i get the
error that tempString as a column does not exist.<BR>><BR>> There also
seems to be some confusion on the postgis message boards<BR>> whether a
single quote is even needed. I was never able to come to a<BR>> definite
conclusion.<BR>><BR>><BR>> I would appreciate help to all who could
help. ive tried everything that<BR>> i know at this point. Thanks a bunch
in advance!<BR>><BR>> CS<BR>><BR>><BR>><BR>>
_______________________________________________<BR>> postgis-users mailing
list<BR>> <A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>>
<A href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR><BR><BR>------------------------------<BR><BR>Message:
3<BR>Date: Tue, 14 Sep 2010 19:49:25 -0700<BR>From: Kevin Neufeld <<A
href="mailto:kneufeld@refractions.net">kneufeld@refractions.net</A>><BR>Subject:
Re: [postgis-users] unioning a buffer - bug?<BR>To: PostGIS Users Discussion
<<A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>><BR>Message-ID:
<<A
href="mailto:4C903435.8030802@refractions.net">4C903435.8030802@refractions.net</A>><BR>Content-Type:
text/plain; charset="iso-8859-1"; Format="flowed"<BR><BR>Interesting.
Something sure sounds amiss. Are the results null?
Is<BR>there anything usual occurring at the TopologyException location?
Is<BR>your dataset large? Can you winnow it down to the few
polygons that<BR>might be causing the problem (this may be just the polygons
around the<BR>TopologyException location)? If so, you could paste the
representation<BR>of the geometries in PasteBin or something so we can help
you isolate<BR>the problem.<BR><BR>Also, what version of GEOS do you have
installed?<BR>SELECT PostGIS_Full_Version();<BR><BR>Cheers,<BR>Kevin<BR><BR>On
9/14/2010 6:03 AM, Lee wrote:<BR>> Hi Kevin,<BR>><BR>> I assumed I
have no results because when I load one of the working<BR>> queries as a
view (eg. select st_buffer(the_geom,0.1)) in QGIS, or in<BR>> ArcGIS, I see
all my results as I would expect, but when I modify the<BR>> query to
st_union(st_buffer()), all my parcels disappear and I have a<BR>> blank
canvas.<BR>><BR>> Also, with
st_isvalid(st_union(st_buffer(the_geom,0.1))) returning<BR>> null (neither
t nor f) I guess I just assumed. Anyways, results for<BR>> your
suggestions are inline, below.<BR>><BR>> Thanks for your help. Any
further ideas?<BR>><BR>> Lee.<BR>>
------------------------------------------------------------------------<BR>>
*From:* Kevin Neufeld <<A
href="mailto:kneufeld@refractions.net">kneufeld@refractions.net</A>><BR>>
*To:* <A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>>
*Sent:* Tue, September 14, 2010 12:12:46 AM<BR>> *Subject:* Re:
[postgis-users] unioning a buffer - bug?<BR>><BR>> How are you
determining you have no results?<BR>><BR>> Try:<BR>> CREATE TABLE
results AS<BR>> SELECT st_union(st_buffer(the_geom,0.1)) as
the_geom<BR>> FROM base.current_assessment_parcel;<BR>><BR>> NOTICE:
TopologyException: found non-noded intersection between<BR>> 586714
4.95189e+006, 586714 4.95189e+006 and 586714 4.95189e+006,<BR>> 586739
4.9519e+006 586714 4.95189e+006<BR>> Query returned successfully with no
result in 1078 ms.<BR>><BR>><BR>><BR>> SELECT count(*) FROM
results;<BR>><BR>> 1<BR>><BR>> SELECT ST_Summary(the_geom) FROM
results;<BR>><BR>> This returns blank.<BR>><BR>><BR>>
(snip)<BR>><BR>> -- Kevin<BR>><BR>> On 9/13/2010 7:07 AM, Lee
wrote:<BR>>> So after some googling I see similar problems, but no
solutions posted.<BR>>><BR>>> I am trying to union a buffer, but
the query is returning no<BR>>> results. Here is ultimately what I
would like to achieve:<BR>>><BR>>> select
st_union(st_buffer(the_geom,0.1)) as the_geom from<BR>>>
base.current_assessment_parcel<BR>>><BR>>> Here are some
troubleshooting steps I have taken to try narrow it
down:<BR>>><BR>>> select st_isvalid(the_geom) a from
base.current_assessment_parcel<BR>>> group by a<BR>>>
TRUE<BR>>><BR>>> select st_isvalid(st_buffer(the_geom,0.1)) a
from<BR>>> base.current_assessment_parcel group by a<BR>>>
TRUE<BR>>><BR>>> select st_isvalid(st_union(the_geom)) from
base.current_assessment_parcel<BR>>> TRUE<BR>>><BR>>> select
st_isvalid(st_union(st_buffer(the_geom,0.1))) from<BR>>>
base.current_assessment_parcel<BR>>> NOTICE: TopologyException:
found non-noded intersection between<BR>>> 586714 4.95189e+006, 586714
4.95189e+006 and 586714 4.95189e+006,<BR>>> 586739 4.9519e+006 586714
4.95189e+006<BR>>> Total query runtime: 859 ms.<BR>>> 1 row
retrieved.<BR>>> (returns blank record)<BR>>><BR>>>
And just for fun<BR>>> select
st_isvalid(st_buffer(st_union(the_geom),0.1)) a from<BR>>>
base.current_assessment_parcel<BR>>> TRUE<BR>>><BR>>> I
guess my next step would be to try the snap to grid functions, but<BR>>>
the first query above should work, shouldn't it?<BR>>><BR>>> Any
help appreciated. Thanks.<BR>>> Lee<BR>>><BR>>><BR>>>
_______________________________________________<BR>>> postgis-users
mailing list<BR>>> <A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>>>
<A href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>>><BR>><BR>><BR>>
_______________________________________________<BR>> postgis-users mailing
list<BR>> <A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>>
<A href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>><BR>--------------
next part --------------<BR>An HTML attachment was scrubbed...<BR>URL: <<A
href="http://postgis.refractions.net/pipermail/postgis-users/attachments/20100914/5410d8cd/attachment-0001.html"
target=_blank>http://postgis.refractions.net/pipermail/postgis-users/attachments/20100914/5410d8cd/attachment-0001.html</A>><BR><BR>------------------------------<BR><BR>Message:
4<BR>Date: Tue, 14 Sep 2010 20:20:36 -0700<BR>From: Kevin Neufeld <<A
href="mailto:kneufeld@refractions.net">kneufeld@refractions.net</A>><BR>Subject:
Re: [postgis-users] Inserting Geometries into PostGres<BR>
database - ???<BR>To: PostGIS Users Discussion <<A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>><BR>Message-ID:
<<A
href="mailto:4C903B84.4060903@refractions.net">4C903B84.4060903@refractions.net</A>><BR>Content-Type:
text/plain; charset=ISO-8859-1; format=flowed<BR><BR>Here's some sample code
that illustrates how to programmatically read<BR>and write JTS Geometries from
a PostGIS database in Java. The writing<BR>is done through a
PreparedStatement to set the bounds of a SELECT<BR>query. It's the same
concept if your PreparedStatement represents an<BR>INSERT statement
instead.<BR>BTW, I would not recommend you use WKT. WKT will result in
coordinate<BR>drifts due to loss of precision. If you're doing
things<BR>programmatically, use WKB. However, if you're not concerned
with<BR>precision loss, you can easily enough use
pstmt.setString(1,<BR>myJTSPolygon.toString()) instead (and of course use
ST_GeomFromText(?,<BR><srid>) in the query). Stephen's inline
solution should also work.<BR><BR><BR><BR>// PostGIS and
JTS<BR>Class.forName("org.postgresql.Driver");<BR>Connection conn =<BR>
DriverManager.getConnection("jdbc:postgresql://...");<BR><BR>WKBReader
wkbReader = new WKBReader();<BR>WKBWriter wkbWriter = new
WKBWriter();<BR><BR>String query =<BR> "SELECT the_geom FROM
my_spatial_table<BR> WHERE the_geom && ST_GeomFromWKB(?,
3005)");<BR>PreparedStatement pstmt =
conn.prepareStatement(query);<BR>pstmt.setBytes(1,
wkbWriter.write(myJTSPolygon);<BR><BR>ResultSet rs =
pstmt.executeQuery();<BR>while(rs.next) {<BR> Geometry g =
wkbReader.read(WKBReader.hexToBytes(<BR>
rs.getString(1)));<BR>
...<BR> // Do stuff with Geometry<BR>}<BR><BR><BR>Hope this
helps,<BR>Kevin<BR><BR>On 9/14/2010 2:38 PM, Stephen Woodbridge wrote:<BR>>
On 9/14/2010 5:12 PM, CS wrote:<BR>>> Hi all. I am having problems
inserting a geometry type into a database.<BR>>> I am using postgres 8.4
and whatever the latest postgis there is(i<BR>>> forgot now). Linux with
glassfish is the server environment.<BR>>><BR>>> I have seen
multiple hardcoded examples about how to insert something in<BR>>> the
VALUES clause but what if i have an array of polygons that cannot
be<BR>>> hardcoded that is already determined? That is the coordinates
and type<BR>>> of the shape is already decided. This lends to the
question as to<BR>>> whether you can use a preparedStatement and
setString to insert a<BR>>> geometry. This is what i need some help
on.<BR>>><BR>>><BR>>> an example of a WKT for a certain cell
that i have is:<BR>>><BR>>> POLYGON ((-90.406 31.07360133086052,
-90.406 31.34423828125,<BR>>> -90.09073538749632 31.34423828125,
-90.09073538749632 31.07360133086052,<BR>>> -90.406
31.07360133086052))<BR>>><BR>>> i want to be able to take this(as
a string, if possible) and insert into<BR>>> the database using a
prepared statement.<BR>>><BR>>><BR>>>
PreparedStatement.setString(1,
cells[cellIndex].getShape().getWkt());,<BR>>> where getWKT returns the
string representation. Of course this doesnt<BR>>> work because the type
of the column is a postgis geometry. So, again,<BR>>> how do you use a
prepared statement to insert a WKT string<BR>>>
representation?<BR>>><BR>>><BR>>> I have tried
this:<BR>>><BR>>> String tempString =
cells[cellIndex].getShape().getWkt();<BR>>> String parameterInsert =
"insert into Cell(result, report, modified,<BR>>> cellid, missionid,
shape) values (?, ?, ?, ?, ?,<BR>>>
GeomFromText(tempString,4326))";<BR>><BR>> You might try something
like:<BR>><BR>> String parameterInsert = "insert into Cell(result,
report, modified,<BR>> cellid, missionid, shape) values (?, ?, ?, ?,
?,<BR>> GeomFromText(" + tempString + ",4326))";<BR>><BR>> And
see if that works.<BR>><BR>> -Steve W<BR>><BR>>> where
tempString would be the POLYGON above and i get the error:<BR>>>
org.postgresql.util.PSQLException: ERROR: Invalid OGC WKT (does
not<BR>>><BR>>> start with P,L,M or G), which doesnt really make
much sense to me.<BR>>><BR>>><BR>>> I try to put single
quotes around each one like:<BR>>><BR>>> String tempString = "'" +
cells[cellIndex].getShape().getWkt() + "'";<BR>>><BR>>> and i get
the error that tempString as a column does not exist.<BR>>><BR>>>
There also seems to be some confusion on the postgis message
boards<BR>>> whether a single quote is even needed. I was never able to
come to a<BR>>> definite conclusion.<BR>>><BR>>><BR>>>
I would appreciate help to all who could help. ive tried everything
that<BR>>> i know at this point. Thanks a bunch in
advance!<BR>>><BR>>>
CS<BR>>><BR>>><BR>>><BR>>>
_______________________________________________<BR>>> postgis-users
mailing list<BR>>> <A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>>>
<A href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>><BR>>
_______________________________________________<BR>> postgis-users mailing
list<BR>> <A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>>
<A href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR><BR>------------------------------<BR><BR>Message:
5<BR>Date: Wed, 15 Sep 2010 10:45:14 +0530<BR>From: venkat <<A
href="mailto:ven.tammineni@gmail.com">ven.tammineni@gmail.com</A>><BR>Subject:
[postgis-users] ST_Split function is not working in PostGIS<BR>
1.5<BR>To: <A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>Message-ID:<BR>
<<A
href="mailto:AANLkTik7Ke8JCvTzxypgxA%2Bggx0ujcgPrKkf6K8TQuiT@mail.gmail.com">AANLkTik7Ke8JCvTzxypgxA+ggx0ujcgPrKkf6K8TQuiT@mail.gmail.com</A>><BR>Content-Type:
text/plain; charset="iso-8859-1"<BR><BR>Dear All,<BR><BR> I am trying use
ST_split function.when i use that function is saying that<BR>ST_Split
function does not exit and error is below...<BR><BR> ERROR:
function st_split(geometry, geometry) does not exist<BR>LINE 1: SELECT
ST_Split(circle, line)<BR>HINT: No function matches the given name and
argument types. You might need<BR>to add explicit type
casts.<BR><BR><BR> Please can you anyone guide me.. I am waiting fro your
great response.<BR><BR>Thanks and Regards,<BR><BR>Ven<BR>-------------- next
part --------------<BR>An HTML attachment was scrubbed...<BR>URL: <<A
href="http://postgis.refractions.net/pipermail/postgis-users/attachments/20100915/30d37439/attachment-0001.html"
target=_blank>http://postgis.refractions.net/pipermail/postgis-users/attachments/20100915/30d37439/attachment-0001.html</A>><BR><BR>------------------------------<BR><BR>Message:
6<BR>Date: Wed, 15 Sep 2010 02:23:38 -0400<BR>From: "Paragon Corporation"
<<A href="mailto:lr@pcorp.us">lr@pcorp.us</A>><BR>Subject: Re:
[postgis-users] ST_Split function is not working in<BR>
PostGIS 1.5<BR>To: "'PostGIS Users Discussion'"<BR>
<<A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>><BR>Message-ID:
<ECD1AA3E450746AE8896BDACB5580076@J><BR>Content-Type: text/plain;
charset="us-ascii"<BR><BR>Ven,<BR><BR>Sorry ST_Split function does not exist
in 1.5. ST_Split is a new function<BR>in PostGIS 2.0<BR><A
href="http://www.postgis.org/documentation/manual-svn/ST_Split.html"
target=_blank>http://www.postgis.org/documentation/manual-svn/ST_Split.html</A><BR>See
the Availability: 2.0.0 note?<BR><BR><BR>this is the list of new or
changed functions in 2.0<BR><A
href="http://www.postgis.org/documentation/manual-svn/ch08.html#NewFunctions_2_0"
target=_blank>http://www.postgis.org/documentation/manual-svn/ch08.html#NewFunctions_2_0</A><BR><BR>Sorry,<BR>Regina<BR><A
href="http://www.postgis.us"
target=_blank>http://www.postgis.us</A><BR><BR><BR><BR> _____<BR><BR>From:
<A
href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</A><BR>[mailto:<A
href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</A>]
On Behalf Of venkat<BR>Sent: Wednesday, September 15, 2010 1:15 AM<BR>To: <A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>Subject:
[postgis-users] ST_Split function is not working in PostGIS
1.5<BR><BR><BR>Dear All,<BR><BR><BR> I am trying use ST_split
function.when i use that function is saying that<BR>ST_Split function
does not exit and error is below...<BR><BR><BR> ERROR: function
st_split(geometry, geometry) does not exist<BR>LINE 1: SELECT ST_Split(circle,
line)<BR>HINT: No function matches the given name and argument types.
You might need<BR>to add explicit type casts.<BR><BR><BR> Please can you
anyone guide me.. I am waiting fro your great response.<BR><BR>Thanks and
Regards,<BR><BR>Ven<BR>-------------- next part --------------<BR>An HTML
attachment was scrubbed...<BR>URL: <<A
href="http://postgis.refractions.net/pipermail/postgis-users/attachments/20100915/e3302bc1/attachment-0001.html"
target=_blank>http://postgis.refractions.net/pipermail/postgis-users/attachments/20100915/e3302bc1/attachment-0001.html</A>><BR><BR>------------------------------<BR><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR><BR>End
of postgis-users Digest, Vol 101, Issue
15<BR>**********************************************<BR></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>