[ckan-dev] temporal search plugin

[Renato Guevara]

Adria,

Thank you for your help.  This clarifies a few things for sure!

Renato Guevara

On Wed, Oct 22, 2014 at 5:37 AM, Adrià Mercader <adria.mercader at okfn.org>
wrote:

> Hi Renato,
>
> As described on the plugins README, CKAN supports date searches out of
> the box, eg
>
>
> http://demo.ckan.org/dataset?q=metadata_modified%3A[2013-08-01T00%3A00%3A00Z+TO+2014-08-31T00%3A00%3A00Z]
>
> http://demo.ckan.org/api/action/package_search?q=metadata_modified%3A[2013-08-01T00%3A00%3A00Z+TO+2014-08-31T00%3A00%3A00Z]
>
> The field you choose to search on will be up to you.
> "metadata_modified" isn't stored anywhere on the database, is
> generated based on the revisions on the dataset. "temporal" is not a
> field in the core schema, so I guess it was harvested or entered
> manually via the ui. One thing to notice is that if you want to
> perform a date search you either 1) need to use a field ending with
> "_date", as this will be indexed in Solr as date or 2) Use a custom
> Solr schema where you index your custom field as a date.
>
>  Of course if you need to search a date range you will need a field
> for the start and one for the end date. You can have a look at this
> instance for an example of how this can be done. Notice the date
> slider on the left column.
>
> http://data.satapps.org/dataset
>
> The fields on this case are called "begin-collection_date" and
> "end-collection_date", but this can be replaced by any "_date" field
> that you need. Probably the most relevant code is here:
>
>
> https://github.com/okfn/ckanext-tsbsatellites/blob/master/ckanext/tsbsatellites/plugin.py#L73
>
>
> Hope these pointers help
>
> Adrià
>
> On 21 October 2014 20:27, Renato Guevara <guevara.renato at gmail.com> wrote:
> > I researched online for a plugin that can give me temporal search
> > capabilities.  It seems that there were two plugins out there, namely:
> >
> > https://github.com/seanh/ckanext-datesearch
> >
> > and
> >
> > https://github.com/B2FIND/ckanext-datesearch
> >
> > I ended up using the second one because it actually ran a search (as the
> > first one didn't do anything but maybe I wasn't configuring it
> correctly),
> > however I modified it so that I could search based on Zulu dates.  I also
> > made the change in the plugin.py so that it'd search on the "temporal"
> field
> > instead of the "metadata_modified" field.  This is where I'm tripping up
> a
> > bit.  According to DCAT, the temporal field is formatted as follows:
> > start_date/end_date.  However, when I run a temporal search it only
> seems to
> > be search based on my start_date.  I tried to go into the psql database
> to
> > see where temporal would be stored, but I couldn't find it.  I suspect it
> > should be located in the package_extra table but I couldn't find this
> > information.  I have two datasets in my ckan instance.  One of which was
> > imported using a harvester, and another one was entered manually through
> the
> > web UI.  Both have a field called "temporal".  Do I have to do anything
> > special to have this field in the database?
> >
> > Any help would be much appreciated!
> >
> > Thanks!
> >
> > Renato Guevara
> >
> > _______________________________________________
> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20141027/9681341d/attachment-0003.html>