Questions tagged [schema]

Definition of a database structure (blueprint) including table layout, integrity constraints, embedded functions, sequences, triggers, domains, etc.

Filter by
Sorted by
Tagged with
1
vote
0answers
19 views

Is there an xsd schema or UML diagram for GDF and if not then why?

I am a GIS newbie exploring the GDF Geographic Data Files format. The question "GDF — Can anyone suggest some good reading?" was a great starting point (despite dead links that have lots of ...
0
votes
0answers
9 views

Geonetwork 4.0.1-0 Language problem

I'm trying to implement the Swedish language in Geonetwork 4.0.1-0. It went fine until it was time to make the schema-specific translations in the codelist.xml-file (\geonetwork\core-geonetwork\...
0
votes
0answers
23 views

pgAdmin 4: create view without defining schema

I have a database containing the official cadastral surveying of hundreds of counties. For every county I have created a new schema named state_zipcode_countyname. As all my db entries have the same ...
2
votes
1answer
58 views

Is it possible for QGIS to recognise GeoPackage Schema and/or Related Tables extension implementation?

I have set up a basic geo package example with the schema extension, specifically for data constraints and enums. When I bring this into QGIS v3.16, I cannot see my extension work implemented anywhere ...
1
vote
2answers
51 views

Add metadata schema to Geonetwork from Github

I have a local installation of GeoNetwork 3.10.4 where I want to add a metadata schema that is available on Github. The schema can be found here: https://github.com/geoadmin/geocat/tree/geocat_3.4.x/...
0
votes
0answers
103 views

Strange PostGIS errors after having altered its extension by specifying the postgis schema

Context I'm trying to refine a PostgreSQL (v.10.12) trigger in order to actually execute some computations on point features only if the input points do intersect a convex hull stored in an other ...
1
vote
1answer
348 views

Making PostGIS extension persist in the search_path of a PostgreSQL database?

Context I have a script to set up a PostgreSQL database along with the postgis extension which I decided to install in an other schema than public, namely, the postgis schema. In my script, this ...
4
votes
1answer
368 views

Use PostGIS functions from an other schema (than public)

Context I have to set up a postgresql database with several schemas. To separate things, I decided to install postgis elsewhere than the public schema, based on https://postgis.net/2017/11/07/tip-...