Hi! We are currently discussing a project where a customer wants to add a geosearch to Koha (store lat/lng in biblio, use Elastic geo queries [0] together with a leaflet.js map to find biblios in a certain area). I assume that might be of interest to Koha in general? I also assume that this will only be possible via some changes to Koha core code (i.e. adding a new search field to ES and Koha, define mappings), while some things might be doable as a plugin (the "frontend" map etc). Before we start hacking I'd like to get some feedback from you: * Would something like this be considered to be added to future Koha versions? * Do you think it's feasable / possible to add to Koha? * Has anybody maybe done a geosearch before? (I couldn't find anything..) Greetings, domm 0: https://www.elastic.co/guide/en/elasticsearch/reference/6.8/geo-queries.html -- #!/usr/bin/perl https://domm.plix.at eor(ref bless{},just'another'perl'hacker){s-:+-$"-g&&print$_.$/}
So that you get a feeling what Thomas is talking about I want this https://gisgba.geologie.ac.at/geonames/ as open source solution in koha The customer ;-) Kind regards Hofrat Mag. Rainer Stowasser Head of Library and Archives ZAMG ________________________________________ Von: Koha-devel <koha-devel-bounces@lists.koha-community.org> im Auftrag von Thomas Klausner <domm@plix.at> Gesendet: Mittwoch, 29. Juni 2022 12:04:39 An: Koha-devel Betreff: [Koha-devel] ElasticSearch Geoserch Hi! We are currently discussing a project where a customer wants to add a geosearch to Koha (store lat/lng in biblio, use Elastic geo queries [0] together with a leaflet.js map to find biblios in a certain area). I assume that might be of interest to Koha in general? I also assume that this will only be possible via some changes to Koha core code (i.e. adding a new search field to ES and Koha, define mappings), while some things might be doable as a plugin (the "frontend" map etc). Before we start hacking I'd like to get some feedback from you: * Would something like this be considered to be added to future Koha versions? * Do you think it's feasable / possible to add to Koha? * Has anybody maybe done a geosearch before? (I couldn't find anything..) Greetings, domm 0: https://www.elastic.co/guide/en/elasticsearch/reference/6.8/geo-queries.html -- #!/usr/bin/perl https://domm.plix.at eor(ref bless{},just'another'perl'hacker){s-:+-$"-g&&print$_.$/} _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/ EXTERNAL EMAIL: Do not click any links or open any attachments unless you trust the sender and know the content is safe.
I don't think the link is working for me, but it's an interesting idea. Where in the bib record are you storing the coordinate data? Have you looked at https://www.loc.gov/marc/bibliographic/bd034.html? It looks like that field was redescribed in 2021 to perfectly suit your use case. In terms of feasibility, I think the main change would be to add suitable indexes for 034 MARC21 data. Beyond that, I think a plugin would make the most sense for a frontend, as the geosearch would probably be fairly specific to your library's needs. But if you could think of a geosearch that is useful for other libraries as well, then I imagine it could make it into Koha. I don't know if any of my libraries would use it, but it's interesting. It might be one of those things that people don't know that they want until after they see it in action? Anyway, sounds cool! David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 0899 Online: 02 8005 0595 -----Original Message----- From: Koha-devel <koha-devel-bounces@lists.koha-community.org> On Behalf Of Stowasser Rainer Sent: Wednesday, 29 June 2022 8:17 PM To: Thomas Klausner <domm@plix.at>; Koha-devel <koha-devel@lists.koha-community.org> Subject: Re: [Koha-devel] ElasticSearch Geoserch So that you get a feeling what Thomas is talking about I want this https://gisgba.geologie.ac.at/geonames/ as open source solution in koha The customer ;-) Kind regards Hofrat Mag. Rainer Stowasser Head of Library and Archives ZAMG ________________________________________ Von: Koha-devel <koha-devel-bounces@lists.koha-community.org> im Auftrag von Thomas Klausner <domm@plix.at> Gesendet: Mittwoch, 29. Juni 2022 12:04:39 An: Koha-devel Betreff: [Koha-devel] ElasticSearch Geoserch Hi! We are currently discussing a project where a customer wants to add a geosearch to Koha (store lat/lng in biblio, use Elastic geo queries [0] together with a leaflet.js map to find biblios in a certain area). I assume that might be of interest to Koha in general? I also assume that this will only be possible via some changes to Koha core code (i.e. adding a new search field to ES and Koha, define mappings), while some things might be doable as a plugin (the "frontend" map etc). Before we start hacking I'd like to get some feedback from you: * Would something like this be considered to be added to future Koha versions? * Do you think it's feasable / possible to add to Koha? * Has anybody maybe done a geosearch before? (I couldn't find anything..) Greetings, domm 0: https://www.elastic.co/guide/en/elasticsearch/reference/6.8/geo-queries.html -- #!/usr/bin/perl https://domm.plix.at eor(ref bless{},just'another'perl'hacker){s-:+-$"-g&&print$_.$/} _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/ EXTERNAL EMAIL: Do not click any links or open any attachments unless you trust the sender and know the content is safe. _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/
Hi! On Thu, Jun 30, 2022 at 09:35:05AM +1000, dcook@prosentient.com.au wrote:
Where in the bib record are you storing the coordinate data? Have you looked at https://www.loc.gov/marc/bibliographic/bd034.html? It looks like that field was redescribed in 2021 to perfectly suit your use case.
Oh, 034 is new to me, but looks like a perfect match. Currently some geoinfo is stored in https://www.loc.gov/marc/bibliographic/bd751.html and we were considering (ab)using the non-specified subfield $x and $y for longitude and latitude.
In terms of feasibility, I think the main change would be to add suitable indexes for 034 MARC21 data.
Yes, that's what I think too.
Beyond that, I think a plugin would make the most sense for a frontend, as the geosearch would probably be fairly specific to your library's needs.
That's the plan
But if you could think of a geosearch that is useful for other libraries as well, then I imagine it could make it into Koha.
I guess "upgrading" a useful and working plugin to a Koha core feature is easier than trying to implement it in Koha itself. Thanks for the feedback! Greetings, domm -- #!/usr/bin/perl https://domm.plix.at for(ref bless{},just'another'perl'hacker){s-:+-$"-g&&print$_.$/}
Hi there, we already implemented something like this and are using it within Primo. Try it and go to https://primo.bibliothek.kit.edu/primo-explore/search?tab=kit&sortby=date&vid=KIT Then search for "php head first" and take the second hit (german book) On the full title you see the typical google maps "mark a position" icons in read, click on them Best regards, Uwe -------------------------------------------------------------------------- Karlsruhe Institute of Technology (KIT) KIT-Library Dipl.-Inform. Uwe Dierolf Straße am Forum 2 Geb. 30.50, Raum 628.1 76131 Karlsruhe - Germany +49 721 608-46076 uwe.dierolf@kit.edu -------------------------------------------------------------------------- Am Wed, Jun 29, 2022 at 12:04:39PM +0200 schrieb Thomas Klausner:
Hi!
We are currently discussing a project where a customer wants to add a geosearch to Koha (store lat/lng in biblio, use Elastic geo queries [0] together with a leaflet.js map to find biblios in a certain area).
I assume that might be of interest to Koha in general?
I also assume that this will only be possible via some changes to Koha core code (i.e. adding a new search field to ES and Koha, define mappings), while some things might be doable as a plugin (the "frontend" map etc).
Before we start hacking I'd like to get some feedback from you:
* Would something like this be considered to be added to future Koha versions? * Do you think it's feasable / possible to add to Koha? * Has anybody maybe done a geosearch before? (I couldn't find anything..)
Greetings, domm
0: https://www.elastic.co/guide/en/elasticsearch/reference/6.8/geo-queries.html
-- #!/usr/bin/perl https://domm.plix.at eor(ref bless{},just'another'perl'hacker){s-:+-$"-g&&print$_.$/} _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : https://www.koha-community.org/ git : https://git.koha-community.org/ bugs : https://bugs.koha-community.org/
Hi! On Wed, Jun 29, 2022 at 12:22:32PM +0200, Uwe Dierolf wrote:
we already implemented something like this and are using it within Primo.
Try it and go to https://primo.bibliothek.kit.edu/primo-explore/search?tab=kit&sortby=date&vid=KIT Then search for "php head first" and take the second hit (german book) On the full title you see the typical google maps "mark a position" icons in read, click on them
Nice! Though what we're trying to do - as pointed out by Rainer aka "the customer" :-) - is to show what area / location is relevant to the contents of the book, not where the physical copy of the book is located. Here's more context, which should be ok to "leak" as Rainer also posted the URL of the current system: The library in question collects geological books / articles, most of which discuss a very specific area. They want to list all books thematically linked to an area: https://gisgba.geologie.ac.at/geonames/ Enter "Znaim", hit enter, wait a bit. You'll see a map of Znojmo and surrounding areas. Click on one of the red dots, and in the popup on "view more" => A new tab opens showing books about "Znojmo". Greetings, domm -- #!/usr/bin/perl https://domm.plix.at for(ref bless{},just'another'perl'hacker){s-:+-$"-g&&print$_.$/}
participants (4)
-
dcook＠prosentient.com.au -
Stowasser Rainer -
Thomas Klausner -
Uwe Dierolf