[pycsw-devel] About "GetRecords-filter-bbox Request"

[Junichi Nagai]

Dear Tom Kralidis,

I'm Junichi Nagai from Japan.
(I'm sorry I can't speak English very well.)

I have a question about "GetRecords-filter-bbox Request" of pycsw.

I installed pycsw 1.0.0(http://sourceforge.net/projects/pycsw/files/1.0.0/)
to my OS:Windows.

I created the necessary tables and values for the repository by using
"./sbin/setup_db.py".

I imported all *.xml records(pycsw samples) by using
"./sbin/load_records.py".


(1)
I sent "GetRecords-all Request" to my pycsw
server(http://localhost/cgi-bin/pycsw/csw.py) at
"http://localhost/tester/index.html".

I got collect response from my pycsw
server(http://localhost/cgi-bin/pycsw/csw.py) at
"http://localhost/tester/index.html".
(attachment file:GetAll_Request_Response.jpg)

No problem.


(2)
I sent "GetRecords-Element Request" to my pycsw server.

I got collect response.
(attachment file:GetRecords-Element_Request_Response.jpg)

No problem.


(3)
I sent "GetRecords-filter-bbox Request" to my pycsw server.

I couldn't got collect response.
(attachment file:GetRecords-filter-bbox_Request_Response.jpg)

I got below error.
--------------------------------------------------------------
<ows:ExceptionText>Invalid query: (OperationalError) no such function:
query_spatial u"SELECT records.identifier AS records_identifier,
records.typename AS records_typename, records.schema AS records_schema,
records.bbox AS records_bbox, records.xml AS records_xml, records.source AS
records_source, records.insert_date AS records_insert_date \nFROM records
\nWHERE records.typename IN (?) AND query_spatial(bbox,'POLYGON((-5.00
47.00, -5.00 55.00, 20.00 55.00, 20.00 47.00, -5.00 47.00))','bbox','false')
= 'true'" ('csw:Record',)</ows:ExceptionText>
--------------------------------------------------------------

I sent oher "GetRecords-filter-*** Request" to my pycsw server.
I got same error.


Could you tell me what's wrong?

I use below.
  OS:Windows XP
  Python:Version 2.7
  Database:SQLite3
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GetAll_Request_Response.jpg
Type: image/jpeg
Size: 512285 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/pycsw-devel/attachments/20110721/2fe4b7e9/GetAll_Request_Response.jpg
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GetRecords-Element_Request_Response.jpg
Type: image/jpeg
Size: 519552 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/pycsw-devel/attachments/20110721/2fe4b7e9/GetRecords-Element_Request_Response.jpg
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GetRecords-filter-bbox_Request_Response.jpg
Type: image/jpeg
Size: 630193 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/pycsw-devel/attachments/20110721/2fe4b7e9/GetRecords-filter-bbox_Request_Response.jpg