Bring in wells from NLOG

NLOG is the Dutch oil and gas portal, run by TNO, the Geological Survey of the Netherlands. Its data is public. When the person who runs your Ophiolite installation has switched NLOG on, a project administrator can search it and bring wells into a project without downloading anything first: Ophiolite reads NLOG for you and sends NLOG nothing but what you search for.

Terms

You may copy, process and share NLOG information if you name NLOG.NL as the source. Ophiolite adds that to everything you bring in, and to every result made from it. There is no checkbox: choosing Bring in is your confirmation that the terms allow what you are doing.

Search and bring in (project)

In a project, open Sources. NLOG is listed among the connections; choose Browse.

1. Search by well name or code (at least three characters), or by field, on land, offshore or either. HON-GT finds 4 wells. A well you can already see in this project is marked “Already in this project”.
2. What comes in. For each well NLOG holds a position, formation tops, deviation surveys and log files. By default the position, the tops, the surveys and the composite logs come in; all log files only when you ask.
3. Bring in. The report has one line per file: added, already here, needs a decision, or not read with the reason. Wells are created and named by NLOG’s own code; nothing is matched by name.

Only a project administrator can bring data in. If NLOG is not switched on for your installation, ask the person who runs it to allow NLOG.

What you get, and what you do not

Every well, log, tops table and survey ends with the line “Source: NLOG.NL, Dutch subsurface portal (TNO / Geological Survey of the Netherlands)”, the date it was read, and a link to the terms of use. A result computed from them shows the same line. The position is the one NLOG recorded when the well was submitted, never a position converted by NLOG’s map service.

Ophiolite creates wells, not wellbores, from NLOG, so NLOG tops and well paths appear in QGIS only for a well that already has a wellbore.

NLOG survey azimuths are kept with the north reference “not stated” and are not drawn as well paths.

Check for changes

Later, under Sources → Project sources, choose Check NLOG for changes. Ophiolite asks NLOG again for every file you brought in and reports, for each one, whether it is unchanged, whether NLOG changed what the document says (content) or how it is described (meaning), or whether NLOG no longer offers it. This is a report only: the copy in your project is never replaced, and nothing is added.

Map features from another service

Features from another service is listed among the connections when your installation approves at least one features service. Paste the service’s web address; Ophiolite lists its collections with the licence the service states about itself. Each collection you bring in is read whole and kept as one feature set, in the coordinate system the service stores it in unless you choose another one it offers. No well is created from features.

Only addresses your installation approves can be read. A service the person who runs your installation has added, but whose terms are not published in Ophiolite’s own list of services, can be looked at but not brought in.

In Python

Name the people who may read what comes in, by their user id (it is never a project default):

readers = ["…"]  # who may read what comes in

Search NLOG. Nothing is kept:

wells = client.public_repositories.search("nlog", name="HON-GT")
for well in wells:
    print(well["code"], well["field"], "already in this project" if well["in_project"] else "")
codes = [well["code"] for well in wells]

See what would come in, then bring the wells in. The default brings the position, tops, surveys and composite logs; include=["tops"] brings in only the tops:

for item in client.public_repositories.preview("nlog", codes):
    print(item["code"], item["outcome"] or "can be brought in")
report = client.public_repositories.bring_in("nlog", codes, audience=readers)
print(report.text())
report.save("nlog-report.csv")

Ask NLOG again later. Nothing is replaced:

changes = client.public_repositories.check("nlog")
print(changes["sentence"])

client.public_repositories.attribution(result) lists the public sources a result was made from, with the line its page shows.

Features from another service, by its address: collections(address) lists what it offers, and a collection’s preview states its licence as the service’s documents state it. Without crs= a collection comes in the coordinate system the service stores it in:

address = "https://api.pdok.nl/kadaster/brk-bestuurlijke-gebieden/ogc/v1"
preview = client.public_repositories.features_preview(address, "provinciegebied")
print(preview["title"], preview["licence"] or preview["licence_sentence"])
features = client.public_repositories.features_import(address, ["provinciegebied"], crs="OGC:CRS84", audience=readers)  # longitude, latitude
print(features.text())

Technical details

• NLOG is read through its map viewer’s REST interface (www.nlog.nl) and the WFS layers of www.gdngeoservices.nl; no other host is contacted, a redirect is never followed, and no cookie or credential is sent. Requests are at least 0.5 s apart, one at a time, at most 1,000 per hour; one import is at most 200 boreholes.
• The installation’s setting public-repositories (./ophiolite-ops configure public-repositories < FILE) names the services switched on ({"enabled": ["nlog"]}) and any further features service origin with its copy declaration. It is accepted only while the deployment runs one gateway process, because the request budget is kept in that process.
• A features service is an OGC API - Features landing page or a WFS 2.0 endpoint. A collection is read in the coordinate system it is stored in (for PDOK’s provinciegebied, EPSG:28992) unless crs= names another it offers. An answer in another coordinate system, or one that stops before the last page, is refused and nothing is kept.
• NLOG states survey azimuths with northRefCode G; Ophiolite keeps them with the azimuth reference “not stated”.