[ckan-dev] ckanext-spatial search modification

Fri Nov 13 16:03:56 UTC 2015

Try within [1]?

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

On Fri, Nov 13, 2015 at 10:59 AM, Dominik Kapišinský
<dkapisinsky at gmail.com> wrote:
> that works, but I would like the other direction. It returns packages that
> contain whole search box. I want to get packages that are fully contained by
> search box (they are inside the search box).
>
>
> Is there such a function?
>
> Dominik
>
> 2015-11-13 15:31 GMT+01:00 Tom Kralidis <tomkralidis at gmail.com>:
>>
>> 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
>> >
>> _______________________________________________
>> 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
>