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
0 votes
0 answers
19 views

How to create complete schema file for GeoNetwork custom schema

I need to add a new standard for metadata other than preinstalled ones in GeoNetwork 3. The problem is that I don't know how to create complete schema that will be validated and imported into ...
user avatar
  • 25
2 votes
1 answer
90 views

Export table structure from ArcGIS GDB to Excel

I am wanting to do a visual table-structure comparison of feature classes in an enterprise GDB to feature classes in a File GDB. Just want to compare things like field names and types. Is there a way ...
user avatar
  • 29.2k
0 votes
0 answers
77 views

What is the appropriate way to store geospatial data in MongoDB?

I'm in the process of planning my MongoDB schema for a MEAN stack web app that will deal with a lot of geospatial data. Points, polylines, etc. I've been boning up on the GeoJSON spec. One of my ...
user avatar
0 votes
0 answers
60 views

Fiona schema property name length

Is it possible to increase property name length in schema? If I define schema like this: my_schema = { 'geometry': 'Point', 'properties': {'Here is very long property name': 'float:12.3'} And in ...
user avatar
0 votes
0 answers
38 views

How to distribute / communicate a schema for a Shapefile?

I know the concept of schemas from XML and databases, and I hope it has the same meaning in GIS. I have to record some data about street light and hand it over to the municipality as a Shapefile. They ...
user avatar
0 votes
1 answer
35 views

PostGIS in shapefile import/export manager - how to add schema

I want to know if it is possible to add the "schema" in "see connection details" I was looking but couldn't find anything.
user avatar
0 votes
1 answer
37 views

Specify an icon in Schema in kml?

Is it possible to specify in a Schema an icon to be used in all the Placemarks? Below is an example. I have replaced < and > with ~ ~Schema name="SPIIA" id="SPIIA"~ ~...
user avatar
1 vote
0 answers
28 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 ...
user avatar
  • 117
0 votes
0 answers
34 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 ...
user avatar
  • 133
2 votes
1 answer
222 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 ...
user avatar
  • 21
1 vote
2 answers
112 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/...
user avatar
  • 481
1 vote
1 answer
965 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 ...
user avatar
  • 6,698
4 votes
1 answer
966 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-...
user avatar
  • 6,698