Skip to main content

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
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 ...
Connor Garrett's user avatar
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....
Andžej Miloš's user avatar
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 ...
Paul DiGirolamo's user avatar
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'...
Paul DiGirolamo's user avatar
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,...
Louie_the_unsolver's user avatar
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 ...
Leehan's user avatar
  • 1,234
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 ...
MrBlakeT's user avatar
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" # ...
Xanderxombie 's user avatar
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 ...
Psoralea's user avatar
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 ...
Neil's user avatar
  • 107
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 ...
Midavalo's user avatar
  • 29.9k
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 ...
NYCaver's user avatar
  • 11
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 ...
DerianFox's user avatar
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 ...
Mads Skjern's user avatar
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.
Mariano Ramirez's user avatar
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"~ ~...
Al Lelopath's user avatar
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 ...
pateksan's user avatar
  • 117
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 ...
cymed's user avatar
  • 155
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 ...
Jake's user avatar
  • 21
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/...
Mario's user avatar
  • 571
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 ...
swiss_knight's user avatar
  • 10.9k
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-...
swiss_knight's user avatar
  • 10.9k