Administration¶

i.e.

pycsw-admin.py setup-repository --config default.yml

ogrinfo /path/to/records.db
INFO: Open of 'records.db'
using driver 'SQLite' successful.
1: records (Polygon)
ogrinfo -al /path/to/records.db
# lots of output

pycsw-admin.py load-records --config default.yml --path /path/to/records

pycsw-admin.py export-records --config default.yml --path /path/to/output_dir

pycsw-admin.py optimize-db --config default.yml
pycsw-admin.py rebuild-db-indexes --config default.yml

pycsw-admin.py delete-records --config default.yml

repository:
    ...
    mappings: path/to/mappings.py

repository:
    ...
    mappings: path.to.pycsw_mappings

[
  {
    "concepts": [
      {
        "id": "atmosphericComposition"
      },
      {
        "id": "pollution"
      },
      {
        "id": "observationPlatform"
      },
      {
        "id": "rocketSounding"
      }
    ],
    "scheme": "https://wis.wmo.int/2012/codelists/WMOCodeLists.xml#WMO_CategoryCode"
  }
]

[
  {
    "name": "contact",
    "individual": "Lastname, Firstname",
    "positionName": "Position Title",
    "contactInfo": {
      "phone": {
        "office": "+xx-xxx-xxx-xxxx"
      },
      "email": {
        "office": "you@example.org"
      },
      "address": {
        "office": {
          "deliveryPoint": "Mailing Address",
          "city": "City",
          "administrativeArea": "Administrative Area",
          "postalCode": "Zip or Postal Code",
          "country": "COuntry"
        },
        "onlineResource": {
          "href": "Contact URL"
        }
      },
      "hoursOfService": "Hours of Service",
      "contactInstructions": "During hours of service.  Off on weekends",
      "url": {
        "rel": "canonical",
        "type": "text/html",
        "href": "https://example.org"
      }
    },
    "roles": [
      {
        "name": "pointOfContact"
      }
    ]
  }
]

 [
   {
     "name": "foo",
     "description": "bar",
     "protocol": "OGC:WMS",
     "url": "https://example.org/wms"
   }
]

 [
   {
     "name": "B1",
     "units": "nm",
     "min": 0.1,
     "max": 0.333
   }
]

CREATE MATERIALIZED VIEW IF NOT EXISTS my_pycsw_view AS
    WITH cte_extras AS (
        SELECT
               p.id,
               p.title,
               g.title AS org_name,
               json_object_agg(pe.key, pe.value) AS extras,
               array_agg(DISTINCT t.name) AS tags
               -- remaining columns omitted for brevity
        FROM package AS p
            JOIN package_extra AS pe ON p.id = pe.package_id
            JOIN "group" AS g ON p.owner_org = g.id
            JOIN package_tag AS pt ON p.id = pt.package_id
            JOIN tag AS t on pt.tag_id = t.id
        WHERE p.state = 'active'
         AND p.private = false
        GROUP BY p.id, g.title
    )
    SELECT
           c.id AS identifier,
           c.title AS title,
           c.org_name AS organization,
           ST_GeomFromGeoJSON(c.extras->>'spatial')::geometry(Polygon, 4326) AS geom,
           c.extras->>'reference_date' AS date,
           concat_ws(', ', VARIADIC c.tags) AS keywords
           -- remaining columns omitted for brevity
    FROM cte_extras AS c
WITH DATA;

# contents of my_custom_pycsw_mappings.py
from sqlalchemy.schema import PrimaryKeyConstraint

MD_CORE_MODEL = {
    "column_constraints": (PrimaryKeyConstraint("identifier"),),
    "typename": "pycsw:CoreMetadata",
    "outputschema": "http://pycsw.org/metadata",
    "mappings": {
        "pycsw:Identifier": "identifier",
        # remaining mappings omitted for brevity

# file: pycsw.yml

repository:
    database: postgresql://${DB_USERNAME}:${DB_PASSWORD}@${DB_HOST}/${DB_NAME}
    mappings: /path/to/my_custom_pycsw_mappings.py
    table: my_pycsw_view

Administration¶

Metadata Repository Setup¶

Supported Information Models¶

Setting up the Database¶

Loading Records¶

Exporting the Repository¶

Optimizing the Database¶

Deleting Records from the Repository¶

Database Specific Notes¶

PostgreSQL¶

PostGIS¶

Mapping to an Existing Repository¶

Existing Repository Requirements¶

Using a SQL View as the repository table¶