<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Arial",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Hi Wolfgang, <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">We’ve implemented pygeoapi on
<a href="https://ogcapi.bgs.ac.uk/">https://ogcapi.bgs.ac.uk/</a> as a production system. This is running on Kubernetes using our self-hosted cloud infrastructure. Our BGS skin is
<a href="https://github.com/BritishGeologicalSurvey/pygeoapi-bgs-skin">https://github.com/BritishGeologicalSurvey/pygeoapi-bgs-skin</a> if you’d like an example.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">The service isn’t “launched”, but will be early next year once we have some more documentation / examples of how to interact with the API. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">At BGS we use Oracle Spatial as our corporate store, to serve data using pygeoapi we have a postgres instance which has a schema of tables we want to serve using the foreign data wrapper extension
(<a href="https://github.com/laurenz/oracle_fdw">https://github.com/laurenz/oracle_fdw</a>) to connect to oracle query layers. We then have another schema in postgres which holds materialised views of the FDW tables, these are what our pygeoapi instance connects
to. The postgres FDW, Mat Views and scheduled updates are managed using Flyway (<a href="https://flywaydb.org/">https://flywaydb.org/</a>).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">We’d ideally like to drop the postgres intermediate step (although postgres is awesome for generating vector tiles – handy for dynamic datasets). I’m told (not a developer!) making a oracle provider
wouldn’t be a huge job as you’d amend the postgres provider which uses SQLAlchemy (<a href="https://www.sqlalchemy.org/">https://www.sqlalchemy.org/</a>). SQLAlchemy already supports Oracle. There might have been a sticking point with geoalchemy not supporting
oracle… <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">There’s a larger discussion about use of Mapserver, Geoserver, pygeoapi, ESRI server for different users/datasets (BGS currently uses all 4!), but at the moment pygeoapi is the only one which
implements OGCAPI-Features + CQL functionality which we require and meets our dev best practice, infrastructure as code, use k8s etc.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Regards, <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Edd<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="color:#002D3D;mso-fareast-language:EN-GB">Edward Lewis
</span></b><span style="color:#1A171C;mso-fareast-language:EN-GB">PGradCert (Geostats), MGeol, MAusIMM</span><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-top:.1pt;text-autospace:none"><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1A171C">Data Standards Lead | Senior Geologist<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-top:.4pt;text-autospace:none"><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#AC9B6E">p
</span></b><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif">+44 (0)115 936 3385<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-top:.5pt;text-autospace:none"><b><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#AC9B6E">m
</span></b><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif">+44 (0)7487559371<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-top:.5pt;text-autospace:none"><b><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#AC9B6E">e
</span></b><span style="mso-fareast-language:EN-GB"><a href="mailto:edlew@bgs.ac.uk"><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:blue;mso-fareast-language:EN-US">edlew@bgs.ac.uk</span></a></span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1A171C">
<span lang="EN-US"><o:p></o:p></span></span></p>
<p class="MsoNormal" style="margin-top:.5pt;text-autospace:none"><b><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#AC9B6E">t
</span></b><span style="mso-fareast-language:EN-GB"><a href="https://twitter.com/Geologist_Edd?lang=en"><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:blue;mso-fareast-language:EN-US">@GeologistEdd</span></a></span><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1A171C"><br>
</span><b><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#AC9B6E">w
</span></b><span style="mso-fareast-language:EN-GB"><a href="http://www.koalageo.rocks/"><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:blue;mso-fareast-language:EN-US">www.koalageo.rocks</span></a></span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#AC9B6E">
</span><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1A171C"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-top:.4pt;text-autospace:none"><b><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#AC9B6E">w
</span></b><span style="mso-fareast-language:EN-GB"><a href="http://www.bgs.ac.uk/"><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:blue;mso-fareast-language:EN-US">www.bgs.ac.uk</span></a></span><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-top:.4pt;text-autospace:none"><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-top:.05pt;text-autospace:none"><span lang="EN-US" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1A171C">British Geological Survey | Nicker Hill | Keyworth | Nottingham NG12 5GG | UK<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-top:.05pt;text-autospace:none"><span lang="EN-US" style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-top:.45pt;text-autospace:none"><span lang="EN-US" style="font-family:"Arial",sans-serif"><img border="0" width="165" height="69" style="width:1.7187in;height:.7187in" id="Picture_x0020_4" src="cid:image001.png@01D9031D.5C16BFF0"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<br>
This email and any attachments are intended solely for the use of the named recipients. If you are not the intended recipient you must not use, disclose, copy or distribute this email or any of its attachments and should notify the sender immediately and delete
this email from your system. UK Research and Innovation (UKRI) has taken every reasonable precaution to minimise risk of this email or any attachments containing viruses or malware but the recipient should carry out its own virus and malware checks before
opening the attachments. UKRI does not accept any liability for any losses or damages which the recipient may sustain due to presence of any viruses.<br>
<br>
</body>
</html>