Skip to main content

Apache Zeppelin integration with Geonetwork

We've been exploring Apache Zeppelin as a way of providing a powerful and flexible analytical interface for Geonetwork and are pleased to announce beta integration with the Geonetwork login credentials.

Astun use Geonetwork 3.2 as our metadata portal, supplying metadata to local authorities and government bodies, for both INSPIRE and Enterprise use. A question our customers often ask is which metadata records are the most popular? Our Enterprise customers also have more detailed requirements, such as discovering which metadata records have been started but not finished, how many have been published and so on.

Geonetwork itself provides search and content statistics, but only to users with Administrative rights, and it's not always straightforward to extend these to include new search options.

Enter Apache Zeppelin!

From the blurb:
Apache Zeppelin is a web-based notebook that enables data-driven, interactive data analytics and collaborative documents with SQL, Scala and more.

It's possible to connect Zeppelin to PostgreSQL, which is the database we use behind the scenes to store not only the Geonetwork metadata, but also user information, metadata status, and so on. Therefore, we can use Zeppelin to interrogate the Geonetwork catalog using SQL, and do more analysis than is exposed by Geonetwork itself.



Zeppelin provides a safe, read-only front-end to the database, avoiding any concerns about data integrity. Query results can be displayed in a number of ways, so the end-user can choose the most appropriate chart type for their data. Users can embed their results in reports, or send links to colleagues, and can schedule query updates to ensure the reports are always up to date.

Integration with Geonetwork


The holy grail of this work is to seemlessly integrate Geonetwork and Zeppelin so that users don't have to log in to both packages, and maintain two sets of passwords. Eventually we also want to style Zeppelin so that it fits with the new, clean Geonetwork style, and link to it from the Geonetwork home page.

The first part of this wish-list is now complete! We commissioned GeoCat, as core Geonetwork developers, to build the necessary components, and a beta-version of this code is now available on GitHub. This can be configured to connect to a Geonetwork PostgreSQL database and will allow you to log in with your Geonetwork Administrative credentials.

Watch this space for further enhancements!

Comments

Popular posts from this blog

G-Cloud 11 Update

Astun Technology have been a Crown Commercial Service (CCS) Approved Supplier for a number of years now, with our solutions and services available via their Digital Marketplace.

Our customers have acquired our solutions via both the G-Cloud and Local Authority Software Applications (LASA) frameworks.

G-Cloud 10 was replaced by G-Cloud 11 on 2 July 2019 and I am delighted to say that all of our solutions and services are now available for purchase under this new framework. This framework makes buying cloud solutions and services faster and cheaper than entering into individual procurement contracts, so switching to Cloud based GIS has just got easier.

Our solutions are available under the Cloud Software and Cloud Support lots as follows:

Cloud Software
iShare In the CloudQGIS in the CloudAstun Data ServicesGet INSPIREdGet INSPIREd and Enterprise Metadata for iShareGet INSPIREd Enterprise
Cloud Support Geospatial Cloud Consultancy ServicesGeospatial Open Source Support PackagesGeospatial O…

Making home working work!

I was chatting to a personal acquaintance recently about work and we got on to the subject of home working. The organisation she worked for was going through a period of change and they were planning on moving some of their office staff to home working on a permanent basis. She was after my views on how we manage to make that work effectively at Astun. This blog, which is very much a manager's perspective, is what I told her!

Before we get on to to the two key themes of this blog - the Technical and Cultural - a quick bit about Astun first! 1. Astun's circumstances We employ around 21 people, of which 6 or so work from an office in Epsom, and the rest work from home on a permanent basis. From my home in Bristol, I line manage 13 of those people, 3 of which are office based, the rest primarily work in the UK, as far north as Tyneside & Lancaster and as far south as Southampton. I have one member of the team who is based in Seville in Spain.
2. Technical Use of technology is k…

Reflections on FOSS4G UK Edinburgh 2019

Six members of the Astun team recently headed en mass to the Free and Open Source Software for Geo (FOSS4G) UK conference in Edinburgh - and we came back with a 7th!

FOSS4G is a great forum to find out all the latest on what is going on in the OSGeo community and to spread the word via talks and workshops about some of the exciting work we’ve been involved in. Check out the post to find out about our own personal reflections of the event … and find out who our latest recruit is in the final post!

Dan The FOSS4G UK conference just seems to get better and better each year, and this year was no exception. As the baton gets passed annually to a new organising team, the advice and guidance on running a great event goes with it. This year’s team led by co-chairs Tom Armitage and Ross McDonald did an amazing job. The venue was breathtaking, the agenda was packed with outstanding talks and workshops and the atmosphere both during the day and in the evening social just had a great buzz to it. …