[ckan-dev] ckanext-spatial search modification

Fri Nov 13 14:31:00 UTC 2015

Perhaps try gcontains [1]?

..Tom

[1] https://github.com/geoalchemy/geoalchemy/blob/master/geoalchemy/functions.py#L358

On Fri, Nov 13, 2015 at 8:45 AM, Dominik Kapišinský
<dkapisinsky at gmail.com> wrote:
> 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
>
>
>
> _______________________________________________
> 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
>