Questions tagged [schema]
Definition of a database structure (blueprint) including table layout, integrity constraints, embedded functions, sequences, triggers, domains, etc.
17
questions
0
votes
0
answers
35
views
Time to list all schemas of PostgreSQL with QGIS 3
QGIS 3.18 PostgreSQL 14.
We use QGIS to access data from a PostGIS server. The data are stored in 33 schemas.
one contains all the data in 17 tables;
the others schemas contain views and materialized ...
- 1,164
0
votes
1
answer
41
views
ArcGIS: Splitting Street Full Street Name into Street Name and Street Name Post Type [closed]
Our team is starting to implement NG 9-1-1 and as NENA Standards for GIS Data Model have the fields laid out (referencing pages 24-25 & 30-31). The St_Name (Street Name) and St_PosType (Street ...
- 3
0
votes
0
answers
21
views
Cannot use Near() due to schema lock
I have recently been able to add 2 layers to the Table of Contents is ArcGIS Pro using ArcPy. It uses code like this:
ResultPath1 = r"*DirectFilePath*.gdb\GeocodedDonationLocations"
# ...
1
vote
0
answers
22
views
ModelBuilder with iterate raster - Tools won't overwrite temporary rasters from the previous iteration due to schema lock
I have a model based on an iterate raster. One of the steps is to create a 'temporary' Viewshed, which after the subsequent process is intended to be overwritten by the next iteration.
However when ...
- 11
0
votes
1
answer
71
views
Create a new feature class of a different geometry type using the same schema from an existing feature class
I have the data schema for a point feature class that I would like to apply to a new line feature class. That is, I'd like to have all the same fields with the same set domains in the feature class ...
- 107
2
votes
1
answer
903
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 ...
- 29.5k
0
votes
0
answers
495
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 ...
- 1
0
votes
0
answers
221
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 ...
0
votes
0
answers
144
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 ...
- 721
0
votes
1
answer
94
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.
0
votes
1
answer
110
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"~
~...
- 393
1
vote
0
answers
43
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 ...
- 117
0
votes
0
answers
294
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 ...
- 155
2
votes
1
answer
492
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 ...
- 21
1
vote
2
answers
184
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/...
- 531
1
vote
1
answer
2k
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 ...
- 9,373
4
votes
1
answer
2k
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-...
- 9,373