<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3395" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi Luigi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> i was reading about WPS with
postgis, and only found python based solutions. I prefer a java based one, but
52 north web page is not as clear as i' would need. Iīll install the
framework and look at examples included... But i donīt need to post my
processing services, just make queries with some of them to been used with open
layers (routing, buffers, or more complicated postgis queries). So a usual java
code will be a simpler approach..</FONT></DIV>
<DIV><FONT face=Arial size=2> The problems with views are
dynamic parameters of functions like StBuffer(the_geom,distance).... You can
change the_geom dynamically with a view... On second thougths, maybe de distance
could be read from another table.... Then i have to serve the view as a WMS
or WFS and it will be updated with distace_table automatically... So when
you change the_geom_table or distance_table the wms posted view will
automatically updated, donīt you?</FONT></DIV>
<DIV><FONT face=Arial size=2> Performance? No idea... I have
to do some experiments first! :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Gus</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=luigi.cardeles@gmail.com href="mailto:luigi.cardeles@gmail.com">Luigi
Castro Cardeles</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">PostGIS Users
Discussion</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, August 27, 2008 4:08
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [postgis-users] Postgis and
open layers</DIV>
<DIV><BR></DIV>
<DIV dir=ltr>Hi,<BR><BR>hum, maybe what you want with st_buffer is a WPS? this
service let you do dynamic stuff with your data. But integrate this with
openlayers... i don't do that... yet :D.<BR><BR>if your data are in postgis,
you could put a WFS or WMS, with many tables. You can create a temp table, or
a view from a select (passing the variables via a form) and them you put that
view at mapserver (add an entry in geometry_columns for that view). <BR>If you
don't want to edit your data (change the vectors) you could make many WMS and
put a view(created from a buffer) in a another WMS, so when the user want to
do a buffer stuff, he do that only at that table or some features from that
table. <BR><BR>Making a dynamic buffer can turn in a performance nightmare...
i think. <BR><BR>Maybe you could cache some buffer to gain speed. just some
ideas.<BR><BR>[]'s<BR><BR>
<DIV class=gmail_quote>2008/8/27 Gustavo Ces <SPAN dir=ltr><<A
href="mailto:g.ces@pettra.es">g.ces@pettra.es</A>></SPAN><BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV bgcolor="#ffffff">
<DIV><FONT face=Arial size=2>Hi Luigi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> but
with WFS iīll have to create the table for each query
and serve that table, wonīt i? I donīt know very well WFS, but if a i
want to make a buffer table with ST_buffer ( for example) i have to
create a table and then serve it as WFS ( automatically, coding it in my
application). If a i need to change the distance in St_Buffer funcion, then
i have to recreate that table and serve it as WFS... or maybe there is a
something in WFS specification to make these types of querys? ( not queries
over the result table!)</FONT></DIV>
<DIV><FONT face=Arial size=2>What i want to do is postgis analysis capacity
viewed in open layers. Maybe there is a better solution...</FONT></DIV>
<DIV><FONT face=Arial size=2>Thanks for answering,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Gus</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(0,0,0) 2px solid; MARGIN-RIGHT: 0px">
<DIV>
<DIV></DIV>
<DIV class=Wj3C7c>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal">-----
Original Message ----- </DIV>
<DIV
style="BACKGROUND: rgb(228,228,228); FONT: 10pt arial; font-size-adjust: none; font-stretch: normal; moz-background-clip: -moz-initial; moz-background-origin: -moz-initial; moz-background-inline-policy: -moz-initial"><B>From:</B>
<A title=luigi.cardeles@gmail.com href="mailto:luigi.cardeles@gmail.com"
target=_blank>Luigi Castro Cardeles</A> </DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><B>To:</B>
<A title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net" target=_blank>PostGIS
Users Discussion</A> </DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><B>Sent:</B>
Tuesday, August 26, 2008 5:17 PM</DIV>
<DIV
style="FONT: 10pt arial; font-size-adjust: none; font-stretch: normal"><B>Subject:</B>
Re: [postgis-users] Postgis and open layers</DIV>
<DIV><BR></DIV>
<DIV dir=ltr>Hi,<BR><BR>try to create wms and wfs. They are supported by
openlayers.<BR>[]'s<BR><BR>
<DIV class=gmail_quote>2008/8/26 Gustavo Ces <SPAN dir=ltr><<A
href="mailto:g.ces@pettra.es"
target=_blank>g.ces@pettra.es</A>></SPAN><BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV bgcolor="#ffffff">
<DIV><FONT face=Arial size=2>Hi all,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> i was searching info
about viewing postgis data in openlayers. Which would be the better
approach to draw dynamic queries in postgis? Views not valid to me
because needed queries with variables. </FONT></DIV>
<DIV><FONT face=Arial size=2> One solution could be
making with dynamic web language the query to create an
asGML/KML/... file and then render it in open layers... Any other
idea?</FONT></DIV>
<DIV><FONT face=Arial size=2> Thanks in
advance,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2>Gus</FONT></DIV></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A href="mailto:postgis-users@postgis.refractions.net"
target=_blank>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></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR>Luigi Castro Cardeles<BR></DIV></DIV></DIV>
<P></P>
<HR>
<DIV class=Ih2E3d>
<P></P>_______________________________________________<BR>postgis-users
mailing list<BR><A href="mailto:postgis-users@postgis.refractions.net"
target=_blank>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></DIV></BLOCKQUOTE></DIV><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></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR>Luigi Castro Cardeles<BR></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>postgis-users
mailing
list<BR>postgis-users@postgis.refractions.net<BR>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR></BLOCKQUOTE></BODY></HTML>