[ckan-dev] ckanext-spatial search modification

[Dominik Kapišinský]

Hi Tom,

thank you for your quick answer.
When I try to change intersects to contains, I get the following error:

ProgrammingError: (ProgrammingError) operator is not unique: unknown ||
geometry LINE 4: ...= package.id AND package_extent.the_geom LIKE '%' ||
ST_Geom... ^ HINT: Could not choose a best candidate operator. You might
need to add explicit type casts. "SELECT count(*) AS count_1 \nFROM (SELECT
ST_AsBinary(package_extent.the_geom) AS package_extent_the_geom,
package_extent.package_id AS package_extent_package_id \nFROM
package_extent, package \nWHERE package_extent.package_id = package.id AND
package_extent.the_geom LIKE '%%' || ST_GeomFromText(%(ST_GeomFromText_1)s,
%(ST_GeomFromText_2)s) || '%%' AND package.state = %(state_1)s) AS anon_1"
{'ST_GeomFromText_1': 'POLYGON ((18.45703125 48.3562490295, 18.45703125
49.5537255135, 22.587890625 49.5537255135, 22.587890625 48.3562490295,
18.45703125 48.3562490295))', 'state_1': u'active', 'ST_GeomFromText_2':
4326}

You can see full log here: http://pastebin.com/iWzreE1U

Am I missing something?

Dominik

2015-11-13 14:16 GMT+01:00 Tom Kralidis <tomkralidis at gmail.com>:

> On Fri, Nov 13, 2015 at 7:01 AM, Dominik Kapišinský
> <dkapisinsky at gmail.com> wrote:
> > Hello,
> >
> > I would like to modify my ckanext-spatial fork to search for something
> like
> > contains (if package extent is contained by search box) instead of
> > intersection between them. Is it doable?
> > I think that I need to change the line in ckanext/spatial/lib/init.py :
> >
> > extents = Session.query(PackageExtent) \
> > .filter(PackageExtent.package_id==Package.id) \
> > .filter(PackageExtent.the_geom.intersects(input_geometry)) \
> > .filter(Package.state==u'active')
> >
> > Could you help me please?
> >
>
> You can update
> https://github.com/ckan/ckanext-spatial/blob/master/ckanext/spatial/lib/__init__.py#L153
> (changing .intersects to .contains).
>
> Having said this, it would be great to expose the spatial predicates
> to the UI, so a user can (optionally) select what kind of spatial
> query they would like (assuming default=intersects).
>
> ..Tom
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20151113/d42fcddf/attachment-0003.html>