Questions tagged [schema]
Definition of a database structure (blueprint) including table layout, integrity constraints, embedded functions, sequences, triggers, domains, etc.
22 questions
0
votes
1
answer
81
views
Migrating an existing geodatabase to an existing empty database in PostgreSQL using PostGIS extension. (Schema and Procedure error)
I am attempting to migrate/export an existing geodatabase into an existing database that I created in pgAdmin. When I attempt to transfer tables inside my existing geodatabase into my PostgreSQL ...
1
vote
1
answer
112
views
How to get WFS feature type schema in Python
I need to get all attribute names and all their restrictions of the WFS feature type. The get_schema method of the owslib.wfs WebFeatureService is not working and throwing an error.
Code:
from owslib....
0
votes
1
answer
66
views
How to generate sequential numbers for list of input table fields written to a text file (ArcMap script tool)?
In order for a script tool I'm writing in ArcMap to read fields in a source CSV correctly as text, I need to automate the writing of a shema.ini file in the source directory. In order to do that I ...
0
votes
1
answer
109
views
Schema.ini file not being honored by ArcMap, string fields still being converted to numbers when importing CSV to GDB
I am trying to import a CSV to GDB using an ArcMap script tool and preserve some string fields that look like numbers as strings. I added some code to create and populate a schema.ini file in the CSV'...
2
votes
1
answer
110
views
Why doesn't `gdalinfo` with `json` flag report searched but not found attributes?
Motivation
I have satellite .tiff data files. I want to understand what information exists in these files. When I run gdalinfo on them, with the -json flag, I don't get any null values from the output,...
0
votes
0
answers
60
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 ...
0
votes
1
answer
179
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 ...
0
votes
0
answers
49
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
59
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 ...
0
votes
1
answer
207
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 ...
2
votes
1
answer
2k
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 ...
1
vote
0
answers
818
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 ...
0
votes
0
answers
336
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
266
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 ...
0
votes
1
answer
181
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
296
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"~
~...
1
vote
0
answers
72
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
0
answers
552
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
1
answer
783
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
2
answers
288
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/...
1
vote
1
answer
3k
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 ...
5
votes
1
answer
3k
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-...