<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"><meta http-equiv="Content-Type" content="text/html charset=utf-8"><base href="x-msg://192/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Hi Gery</div><div><br></div><div>Thanks a lot for testing FS.</div><div><br></div><div>I uploaded a new version including the discussed bug fixes (<a href="http://featureserver.org/download.html#r1.15.1">http://featureserver.org/download.html#r1.15.1</a>) and created a new tag on GitHub (<a href="https://github.com/iocast/featureserver/tree/1.15.1">https://github.com/iocast/featureserver/tree/1.15.1</a>).</div><div><br></div><div>Cheers,</div><div>Michel</div><div><br></div><div><br></div><br><div><div>On Dec 10, 2012, at 12:53 PM, Gery . <<a href="mailto:gamejihou@hotmail.com">gamejihou@hotmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div class="hmmessage" style="font-size: 10pt; font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div dir="ltr"><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">Hi Michel,<br><br>now it works, thanks ;). I'll keep testing FS with GeoAlchemy and will contact you again if have more questions,<br><br>Cheers,<br><br>Gery<br id="FontBreak"></font><br><br><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><br>__________________________________________________________________________________________<br>Piensa en el medio ambie<font face="Arial">nte - mantenlo en la pantalla. NO lo imprimas si NO es necesario.</font></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><br></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; ">Think green - keep it on the screen. Do NOT print if it is NOT necessary.</font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><br></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><span id="ecxresult_box" class="ecxshort_text" lang="de"><span class="ecxhps">Denken Sie an</span><span class="Apple-converted-space"> </span><span class="ecxhps">die Umwelt</span></span></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><span id="ecxresult_box" lang="de"><span class="ecxhps"></span> <span class="ecxhps">-</span><span class="Apple-converted-space"> </span><span class="ecxhps">bewahren Sie es</span><span class="Apple-converted-space"> </span><span class="ecxhps">auf dem Bildschirm.</span><span class="Apple-converted-space"> </span><span class="ecxhps">Drucken Sie NICHT</span><span>, wenn</span><span class="Apple-converted-space"> </span><span class="ecxhps">es NICHT notwendig ist</span><span>.</span></span></font><br><br><br><div><div id="SkyDrivePlaceholder"></div><hr id="stopSpelling">From: <a href="mailto:iocast@me.com">iocast@me.com</a><br>Subject: Re: [FeatureServer] GeoAlchemy, what is the trick?<br>Date: Fri, 7 Dec 2012 10:54:27 +0100<br>To: <a href="mailto:gamejihou@hotmail.com">gamejihou@hotmail.com</a><br><br>Hi Gery<div><br></div><div>I have changed some lines and it should now be solved … at least on my mac :)</div><div><br></div><div>Replace the files</div><div><ul class="ecxMailOutline"><li>FeatureServer/Service/Request.py</li><li>FeatureServer/DataSource/GeoAlchemy.py</li></ul><div>with the attached files.</div></div><div><br></div><div></div><br><div></div><br><div></div><div><br></div><div>Please let me know if it works</div><div>Michel</div><div><br></div><div><br></div><div><br><div><div>On Dec 6, 2012, at 11:22 PM, Gery . <<a href="mailto:gamejihou@hotmail.com">gamejihou@hotmail.com</a>> wrote:</div><br class="ecxApple-interchange-newline"><blockquote><div class="ecxhmmessage" style="font-size: 10pt; font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; "><div dir="ltr"><font color="#366092" face="Arial" size="2" style="font-size: 10pt; "><br id="ecxFontBreak"></font><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">cool,<span class="ecxApple-converted-space"> </span><font size="2" style="font-size: 10pt; ">t</font>ha<font size="2" style="font-size: 10pt; ">nks a<span class="ecxApple-converted-space"> </span><font size="2" style="font-size: 10pt; ">lot<span class="ecxApple-converted-space"> </span></font>Michel</font>,<br><br><font size="2" style="font-size: 10pt; ">Gery<br><br></font></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><br>__________________________________________________________________________________________<br>Piensa en el medio ambie<font face="Arial">nte - mantenlo en la pantalla. NO lo imprimas si NO es necesario.</font></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><br></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; ">Think green - keep it on the screen. Do NOT print if it is NOT necessary.</font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><br></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><span id="ecxresult_box" class="ecxshort_text" lang="de"><span class="ecxhps">Denken Sie an</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">die Umwelt</span></span></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><span id="ecxresult_box" lang="de"><span class="ecxhps"></span> <span class="ecxhps">-</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">bewahren Sie es</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">auf dem Bildschirm.</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">Drucken Sie NICHT</span><span>, wenn</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">es NICHT notwendig ist</span><span>.</span></span></font><br><br><br><div><div id="ecxSkyDrivePlaceholder"></div><hr id="ecxstopSpelling">From:<span class="Apple-converted-space"> </span><a href="mailto:iocast@me.com">iocast@me.com</a><br>Subject: Re: [FeatureServer] GeoAlchemy, what is the trick?<br>Date: Thu, 6 Dec 2012 15:28:57 +0100<br>To:<span class="Apple-converted-space"> </span><a href="mailto:gamejihou@hotmail.com">gamejihou@hotmail.com</a><br><br>Okey, I see � then I need to setup a test env to find the bug. It would take some time.<div><br></div><div>I will give you a feedback as soon as i found the solution.</div><div><br></div><div>thanks</div><div>Michel</div><div><br><div><br></div><div><br></div><div><br><div><div>On Dec 6, 2012, at 2:06 PM, Gery . <<a href="mailto:gamejihou@hotmail.com">gamejihou@hotmail.com</a>> wrote:</div><br class="ecxApple-interchange-newline"><blockquote><div class="ecxhmmessage" style="font-size: 10pt; font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; "><div dir="ltr"><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">Hi Michel,<br><br>Thanks for the file, I used it but still I'm getting kind of the same error, this is it:<br><br>-- 1 --<br>/fs/boreholes?format=GeoJSON&queryable=source&source=ODP<br></font><pre>An error occurred: string indices must be integers, not str
File "/var/www/html/mop/fs/web_request/handlers.py", line 230, in cgi
accepts = accepts )
File "/var/www/html/mop/fs/FeatureServer/Server.py", line 245, in dispatchRequest
result = method(action)
File "/var/www/html/mop/fs/FeatureServer/DataSource/GeoAlchemy.py", line 160, in select
for k, v in action.attributes.iteritems()]
{'source': 'ODP', 'queryable': 'source', 'format': 'GeoJSON'}</pre><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">-- 2 --<br>/fs/boreholes?format=GeoJSON&source__ilike=ODP&queryable=source<br></font><pre>An error occurred: 'str' object has no attribute 'query_action_types'
File "/var/www/html/mop/fs/web_request/handlers.py", line 230, in cgi
accepts = accepts )
File "/var/www/html/mop/fs/FeatureServer/Server.py", line 207, in dispatchRequest
request.parse(params, path_info, host, post_data, request_method)
File "/var/www/html/mop/fs/FeatureServer/Service/GeoJSON.py", line 44, in parse
Request.parse(self, params, path_info, host, post_data, request_method, format_obj=g)
File "/var/www/html/mop/fs/FeatureServer/Service/Request.py", line 70, in parse
action = self.get_select_action(path_info, params)
File "/var/www/html/mop/fs/FeatureServer/Service/Request.py", line 149, in get_select_action
type, ",".join(ds.query_action_types) or "None"))
{'source__ilike': 'ODP', 'queryable': 'source', 'format': 'GeoJSON'}
</pre><br><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">in the --1--, I understand that the "</font>string indices must be integers, not str<font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">" means that an array index must be integer (string is an array of characters), like this:<br></font><pre><span class="ecxgp">>>> </span><span class="ecxn">s</span>
<span class="ecxgo">'abcd12345'</span>
<span class="ecxgp">>>> </span><span class="ecxn">s</span><span class="p">[</span><span class="ecxmi">1</span><span class="p">]</span>
<span class="ecxgo">'b'</span>
<span class="ecxgp">>>> </span><span class="ecxn">s</span><span class="p">[</span><span class="s">'1'</span><span class="p">]</span>
<span class="ecxgt">Traceback (most recent call last):</span>
File <span class="ecxnb">"<stdin>"</span>, line <span class="ecxm">1</span>, in <span class="ecxn-Identifier"><module></span>
<span class="ecxnc">TypeError</span>: <span class="ecxn-Identifier">string indices must be integers, not str</span></pre><font color="#366092" face="Arial" size="2" style="font-size: 10pt; "><br>so I'm thinking that this error could be related to the GeoJSON format itself (perhaps the quotes??), this is the first record of my table as GeoJSON:<br></font><pre>{"crs": null, "type": "FeatureCollection", "features": [{"geometry": {"type": "Point", "coordinates": [-7.99, -8.99]}, "type": "Feature", "id": 1, "properties": {"h_f_mwm2": "No information available", "core_rec_m": "No information available", "t_g_ckm1": "8.5", "w_depth_m": -19.0, "longitude": -7.99, "source": "RO", "station": "Delfin 20", "survey": "Delfin 20", "comments": "The borehole was drilled.", "fid": 1, "max_pen_m": "26", "latitude": -8.99, "type": "dust"}}, {"geometry": {"type": "Point", "coordinates": ...</pre><font color="#366092" face="Arial" size="2" style="font-size: 10pt; "><br>in the --2--, I'm not sure what is the error:<span class="ecxApple-converted-space"> </span></font>'str' object has no attribute 'query_action_types'<font color="#366092" face="Arial" size="2" style="font-size: 10pt; "><br id="ecxFontBreak"></font><br><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; ">Cheers,<br><br>Gery<br><br>__________________________________________________________________________________________<br>Piensa en el medio ambie<font face="Arial">nte - mantenlo en la pantalla. NO lo imprimas si NO es necesario.</font></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><br></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; ">Think green - keep it on the screen. Do NOT print if it is NOT necessary.</font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><br></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><span id="ecxresult_box" class="ecxshort_text" lang="de"><span class="ecxhps">Denken Sie an</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">die Umwelt</span></span></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><span id="ecxresult_box" lang="de"><span class="ecxhps"></span> <span class="ecxhps">-</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">bewahren Sie es</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">auf dem Bildschirm.</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">Drucken Sie NICHT</span><span>, wenn</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">es NICHT notwendig ist</span><span>.</span></span></font><br><br><br><div><div id="ecxSkyDrivePlaceholder"></div><hr id="ecxstopSpelling">From:<span class="ecxApple-converted-space"> </span><a href="mailto:iocast@me.com">iocast@me.com</a><br>Subject: Re: [FeatureServer] GeoAlchemy, what is the trick?<br>Date: Thu, 6 Dec 2012 09:24:34 +0100<br>To:<span class="ecxApple-converted-space"> </span><a href="mailto:gamejihou@hotmail.com">gamejihou@hotmail.com</a><br><br><div>Hi Gery</div><div><br></div><div>As I can read in the source, your ilike example should work.</div><div><br></div><div>could you try this fix. Replace the file Request.py in the folder FeatureServer/Service/</div><div></div><br><div></div><div><br></div><div>Hopefully it works</div><div><br></div><div>Thanks for testing</div><div>Michel</div><div><br></div><div><br></div><br><div><div>On Dec 5, 2012, at 12:22 PM, Gery . <<a href="mailto:gamejihou@hotmail.com">gamejihou@hotmail.com</a>> wrote:</div><br class="ecxApple-interchange-newline"><blockquote><div class="ecxhmmessage" style="font-size: 10pt; font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; "><div dir="ltr"><font color="#366092" face="Arial" size="2" style="font-size: 10pt; "><br id="ecxFontBreak"></font><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">Thanks a lot Michel, it worked like a charm. Now I'm getting the whole table as GeoJSON. However I have a doubt about the querying option, for example:<br><br>/fs/boreholes?format=GeoJSON&source__ilike=ODP&queryable=source ---> this source_ilike comes from Ext JS, and should give only the rows in source column with "odp".<br></font><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">/fs/boreholes?format=GeoJSON&queryable=source&source=ODP ---> this should work as above with FeatureServer<span class="ecxApple-converted-space"> </span></font><font color="#366092"><font size="2" style="font-size: 10pt; "><font face="Arial">but it gives this:<br></font></font></font><pre>An error occurred: string indices must be integers, not str
File "/var/www/html/mop/fs/web_request/handlers.py", line 230, in cgi
accepts = accepts )
File "/var/www/html/mop/fs/FeatureServer/Server.py", line 245, in dispatchRequest
result = method(action)
File "/var/www/html/mop/fs/FeatureServer/DataSource/GeoAlchemy.py", line 160, in select
for k, v in action.attributes.iteritems()]
{'source': 'ODP', 'queryable': 'source', 'format': 'GeoJSON'}
</pre><br id="ecxFontBreak"><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">Because I'm using Ext JS to do the search (search button), I'd like this form: /fs/boreholes?format=GeoJSON&source__ilike=ODP&queryable=source, could it be possible to adapt this in FeatureServer?<br><br>Thanks again,<br><br>Gery<br><br>PS: this is the error coming from the Ext JS example above:<br></font><pre>An error occurred: 'str' object has no attribute 'query_action_types'
File "/var/www/html/mop/fs/web_request/handlers.py", line 230, in cgi
accepts = accepts )
File "/var/www/html/mop/fs/FeatureServer/Server.py", line 207, in dispatchRequest
request.parse(params, path_info, host, post_data, request_method)
File "/var/www/html/mop/fs/FeatureServer/Service/GeoJSON.py", line 44, in parse
Request.parse(self, params, path_info, host, post_data, request_method, format_obj=g)
File "/var/www/html/mop/fs/FeatureServer/Service/Request.py", line 70, in parse
action = self.get_select_action(path_info, params)
File "/var/www/html/mop/fs/FeatureServer/Service/Request.py", line 145, in get_select_action
if type in ds.query_action_types:
{'source__ilike': 'ODP', 'queryable': 'source', 'format': 'GeoJSON'}
</pre><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><br>__________________________________________________________________________________________<br>Piensa en el medio ambie<font face="Arial">nte - mantenlo en la pantalla. NO lo imprimas si NO es necesario.</font></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><br></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; ">Think green - keep it on the screen. Do NOT print if it is NOT necessary.</font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><br></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><span id="ecxresult_box" class="ecxshort_text" lang="de"><span class="ecxhps">Denken Sie an</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">die Umwelt</span></span></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><span id="ecxresult_box" lang="de"><span class="ecxhps"></span> <span class="ecxhps">-</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">bewahren Sie es</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">auf dem Bildschirm.</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">Drucken Sie NICHT</span><span>, wenn</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">es NICHT notwendig ist</span><span>.</span></span></font><br><br><br><div><div id="ecxSkyDrivePlaceholder"></div><hr id="ecxstopSpelling">Subject: Re: [FeatureServer] GeoAlchemy, what is the trick?<br>From:<span class="ecxApple-converted-space"> </span><a href="mailto:iocast@me.com">iocast@me.com</a><br>Date: Wed, 5 Dec 2012 08:34:15 +0100<br>CC:<span class="ecxApple-converted-space"> </span><a href="mailto:featureserver@lists.osgeo.org">featureserver@lists.osgeo.org</a><br>To:<span class="ecxApple-converted-space"> </span><a href="mailto:gamejihou@hotmail.com">gamejihou@hotmail.com</a><br><br><div><div>Hi Gery</div><div><br></div><div>In the test files I found an example and tried to adapt it:</div><div><br></div><div>The config entry I changed as follow:</div><div>************************</div><div><div>[boreholes]</div><div>type=GeoAlchemy</div><div>dburi=postgresql://<user>:<password>@localhost:5432/map</div><div>model=model.boreholes_model</div><div>cls=Boreholes</div><div>fid=id</div><div>geometry=geom</div></div><div><div>************************</div><div></div></div><div>where the <b>model</b> is a subdirectory of the featureserver root directory and boreholes_model is a file called boreholes_model.py. I also added a __init__.py file in the model folder to be sure that it is recognised as a Python package.</div><div><b>cls</b> is the class name of your model, so it should be Boreholes.</div><div><br></div><div>You could also look at the 'Road' example in the folder tests</div><div><ul class="ecxMailOutline"><li>DataSource.GeoAlchemy.txt and</li><li>geoalchemy_model.py for the model declaration</li></ul></div><div><br></div><div>Hopefully it would help</div><div>Michel</div></div><div><br></div><div><br></div><div><br></div><br><div><div>On Dec 5, 2012, at 8:00 AM, Iocast <<a href="mailto:iocast@me.com">iocast@me.com</a>> wrote:</div><br class="ecxApple-interchange-newline"><blockquote><div style="word-wrap: break-word; "><div>Hi Gery</div><div><br></div><div>I never tried/changed the GeoAlchemy data source, however I'm going to try your setup and have a look if I get the same error.</div><div><br></div><div>Cheers,</div><div>Michel</div><div><br></div><div><br></div><div><blockquote><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">I get this error recently, I'm not sure why, someone has an idea? thanks<br><br></font><pre style="font-size: 13px; ">An error occurred: 'NoneType' object has no attribute 'items'
File "/var/www/html/mop/fs/web_request/handlers.py", line 236, in cgi
for (key, value) in returned_data[2].items():
{}</pre></blockquote><div><br></div></div><div><br></div><div><br></div><br><div><div>On Dec 4, 2012, at 10:31 AM, Gery . <<a href="mailto:gamejihou@hotmail.com">gamejihou@hotmail.com</a>> wrote:</div><br class="ecxApple-interchange-newline"><blockquote><div class="ecxhmmessage" style="font-size: 10pt; font-family: Tahoma; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; "><div dir="ltr"><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">Hello,<br><br>I'm using GeoAlchemy with FeatureServer, but I'm new using both, so sorry for the very simple questions. This is my model (boreholes.model) for one of my PostGis tables:<br><br>*****************************<br>print "Content-type: text/html\n\n";<br><br>from sqlalchemy import *<br>from sqlalchemy.orm import *<br>from sqlalchemy.dialects.postgresql import *<br>from geoalchemy import *<br>from geoalchemy.postgis import *<br><br>engine = create_engine('<a target="_blank">postgresql://postgres:pass@localhost:5432/map'</a>, echo=False)<br>metadata = MetaData(engine)<br><br>session = sessionmaker(bind=engine)()<br><br>boreholes_table = Table('boreholes_point_wgs84', metadata,<br> Column('id', SMALLINT, primary_key=True),<br> Column('fid', SMALLINT),<br> Column('longitude', DOUBLE_PRECISION),<br> Column('latitude', DOUBLE_PRECISION),<br> Column('w_depth_m', DOUBLE_PRECISION),<br> Column('station', VARCHAR(150)),<br> Column('type', VARCHAR(150)),<br> Column('survey', VARCHAR(150)),<br> Column('source', VARCHAR(150)),<br> Column('max_pen_m', VARCHAR(150)),<br> Column('core_rec_m', VARCHAR(150)),<br> Column('t_g_ckm1', VARCHAR(150)),<br> Column('h_f_mwm2', VARCHAR(150)),<br> Column('comments', TEXT),<br> GeometryExtensionColumn('geom', Geometry(3)))<br><br>class Boreholes(object):<br> def __init__ (self, id, fid, longitude, latitude, w_depth_m, station, type, survey, source, max_pen_m, core_rec_m, t_g_ckm1, h_f_mwm2, comments):<br> self.id = id<br> self.fid = fid<br> self.longitude = longitude<br> self.latitude = latitude<br> self.w_depth_m = w_depth_m<br> self.station = station<br> self.type = type<br> self.survey = survey<br> self.source = source<br> self.max_pen_m = max_pen_m<br> self.core_rec_m = core_rec_m<br> self.t_g_ckm1 = t_g_ckm1<br> self.h_f_mwm2 = h_f_mwm2<br> self.comments = comments<br><br>mapper(Boreholes, boreholes_table,<br> properties={<br> 'geom': GeometryColumn(boreholes_table.c.geom,<br> comparator=PGComparator)<br> })<br><br>GeometryDDL(boreholes_table)<br><br></font><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">*****************************</font><br><font color="#366092" face="Arial" size="2" style="font-size: 10pt; "><br>and this is what I have in my featureserver.cfg:<br><br></font><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">*****************************<br>[boreholes]<br>type=GeoAlchemy<br>dburi=<a target="_blank">postgresql://postgres:pass@localhost:5432/map</a><br>model=../model/boreholes.model<br>cls=boreholes_point_wgs84<br>fid=id<br>geometry=geom<br></font><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">*****************************</font><br><font color="#366092" face="Arial" size="2" style="font-size: 10pt; "><br>so what I want is to query this table and output that in GeoJSON format. I'm doing the query in OpenLayers using GeoExt like this:<br><br></font><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">*****************************</font><br><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">var searchformPanel = new GeoExt.form.FormPanel(<br> {<br> width: 250,<br> bodyStyle: 'padding:5px',<br> labelAlign: 'top',<br> defaults:<br> {<br> anchor: '100%'<br> },<br> protocol: new OpenLayers.Protocol.HTTP(<br> {<br> url: '<a href="http://www.mop.org/fs/boreholes?format=GeoJSON%27" target="_blank">http://www.mop.org/fs/boreholes?format=GeoJSON'</a>,<br> format: new OpenLayers.Format.GeoJSON(<br> {<br> ignoreExtraDims: true,<br> 'internalProjection': new OpenLayers.Projection("EPSG:900913"),<br> 'externalProjection': new OpenLayers.Projection("EPSG:4326")<br> }<br> )<br> }<br> ),<br> items:<br> [<br> {<br> xtype: 'textfield',<br> name: 'station__like',<br> fieldLabel: 'Enter a word',<br> allowBlank: false<br> }<br> ],<br>...<br>...<br></font><font color="#366092" face="Arial" size="2" style="font-size: 10pt; ">*****************************</font><br><font color="#366092" face="Arial" size="2" style="font-size: 10pt; "><br>by the way, this PostGis table is served by MarServer as WMS, but I think this has nothing to do with the query. So, to do this query I'm sure I need something else related to GeoAlchemy and featureserver itself but not sure what it is, I'd be grateful for some support on this, thanks in advance for any help.<br><br>Best regards,<br><br>Gery<br> <br id="ecxFontBreak"></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><br>__________________________________________________________________________________________<br>Piensa en el medio ambie<font face="Arial">nte - mantenlo en la pantalla. NO lo imprimas si NO es necesario.</font></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><br></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; ">Think green - keep it on the screen. Do NOT print if it is NOT necessary.</font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><br></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><span id="ecxresult_box" class="ecxshort_text" lang="de"><span class="ecxhps">Denken Sie an</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">die Umwelt</span></span></font><font color="#1F497D" face="Arial" size="2" style="font-size: 10pt; "><span id="ecxresult_box" lang="de"><span class="ecxhps"></span> <span class="ecxhps">-</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">bewahren Sie es</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">auf dem Bildschirm.</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">Drucken Sie NICHT</span><span>, wenn</span><span class="ecxApple-converted-space"> </span><span class="ecxhps">es NICHT notwendig ist</span><span>.</span></span></font><br></div>_______________________________________________<br>FeatureServer mailing list<br><a href="mailto:FeatureServer@lists.osgeo.org">FeatureServer@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/featureserver" target="_blank">http://lists.osgeo.org/mailman/listinfo/featureserver</a><br></div></blockquote></div><br></div>_______________________________________________<br>FeatureServer mailing list<br><a href="mailto:FeatureServer@lists.osgeo.org">FeatureServer@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/featureserver" target="_blank">http://lists.osgeo.org/mailman/listinfo/featureserver</a></blockquote></div></div></div></div></blockquote></div></div></div></div></blockquote></div></div></div></div></div></div></blockquote></div></div></div></div></div></blockquote></div><br></body></html>