Questions tagged [schema-architecture]
The schema-architecture tag has no usage guidance.
33 questions
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 ...
- 3
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 ...
- 117
1
vote
0
answers
363
views
Storing a large amount of vector layers on PostGIS
I'm developing a web application where PostGIS will be used as a vector tile server backend to serve mvt tiles. For each user of the application at least one vector layer will be created. So, ...
0
votes
0
answers
34
views
Standalone Web Application Development putting GIS cordinates over layers and Visualising it [duplicate]
I am trying to understand what architecture I can use for my GIS Application. I am from a programming background, however quite inexperienced with GIS and Web development, yet the task is to create a ...
2
votes
1
answer
410
views
Cross-schema function call with PostGIS dependencies
I have an issue where I am unable to make a cross-schema function call because of that function's use of PostGIS. I have both PostGIS and my function in the public schema, but I'm trying to call the ...
- 115
4
votes
2
answers
3k
views
Healthy number of tables in PostgreSQL schema?
I manage a PostgreSQL + PostGIS database with two schemas of 200 and 120 tables.
I wonder if this is correct or I should organize the tables in more and smaller schemas.
So far, we hadn't had any ...
2
votes
2
answers
608
views
Hiding PostGIS Schema in QGIS?
This is my situation:
I have a table A in schema A which includes personal data. I want to give specific persons the permission to see some data from that table in QGIS, excluding that personal data. ...
- 1,230
1
vote
0
answers
174
views
Use enterprise architect to export models with metadata
I am using Enterprise Architect to build a data model, and I need to know if there is a way to write somewhere in EA "in notes or glossary....." the description of each feature and class that I have ...
- 83
1
vote
1
answer
831
views
Publish multiple tables from different PostgreSQL's schemas on GeoServer
I have many tables (about 1000) in a postgis which are seperated in four different schemas. I know that every PostGIS store must be connected with just one schema. Thus, what is the most efficient ...
- 607
3
votes
1
answer
2k
views
Geoserver Error while publishing a shapefile from a custom PostGIS schema
I have organized my shapefiles in seperate PostGIS's schemas. Also I have added the schemas into the search_path with the following command:
ALTER USER postgres SET search_path = custom_schema, ...
- 607
2
votes
1
answer
222
views
Create Replica using arcpy
I am creating a Replica from an ArcSDE database using python/arcpy
(CreateReplica_management (in_data, in_type, out_geodatabase, out_name, {access_type}, {initial_data_sender}, {...
0
votes
1
answer
1k
views
Creating Data Dictionary File (.ddf) from a Geodatabase
At my workplace we use Trimble GeoXT GPS devices or similar with CartoPac installed for GPS feature data collection. We have not used Trimble Pathfinder for several years.
For a few projects, we ...
2
votes
0
answers
4k
views
Loading GML schema file on QGIS
I am Very New to GML format.
first of all, I have came to the assumption that a schema file will display gml in a particular style as defined by the schema, similar to the way i load a .qml on a ...
- 21
0
votes
1
answer
116
views
About the storage of GIS attributes
I'm quite new to the GIS world and I currently have some technical questions for which I have no answers yet.
I'd like to know the good way to store the attributes for a feature using the PostgreSQL ...
- 117
1
vote
1
answer
370
views
FME: How to retain Field names in reader?
I am having problems with field names in my writer using fme 2014. When I "generate" a workspace and pre-define the reader and writer before I add transformers, the readers field names are ...
- 10.3k
1
vote
1
answer
204
views
Controlling Python Version from ArcGIS?
I am writing a VB.net console application that calls ArcGIS Desktop 10.1 ArcToolbox geoprocessing tools from my code. Some of these tools use Python syntax and I am encountering a problem that I ...
- 692
4
votes
1
answer
469
views
Adding GUID field with ArcObjects
I'm trying to add a GUID field programmatically to an existing FeatureClass using ArcObjects.
Here is my code:
ISchemaLock schemaLock = (ISchemaLock)ipFC;
try
{
// A try block is necessary, as ...
5
votes
2
answers
2k
views
Efficient way to use a CSV to Define a Feature Class
I was provided an Excel Spreadsheet which had the definitions of fields for a feature class. There were several worksheets in the file, each containing field definitions for different feature classes....
- 22k
5
votes
1
answer
986
views
Homogeneous vs Heterogeneous schema in Postgis
Introduction
I'm working on creating a spatial database in Postgis, to be viewed and edited trough QGIS to help managing some farmland areas.
One of my goals is the have a centralized place where ...
- 14.4k
2
votes
1
answer
473
views
How do you get a schema report from SHP, PostGIS, or other file type?
All,
We're loading City and County data into our database, but looking to remove several fields we don't use.
Those fields we do use I'd like our users to simply highlight on a printout I give them ...
- 18.9k
9
votes
3
answers
5k
views
How to design a bus station query database schema?
We have bus station data, and we want to build an application which will provide the line/multiple line for a given start station and the end station.
For example user try to get a bus line ...
- 803
1
vote
1
answer
1k
views
How to Change the schema of SDE dataset in Connected environment
We continuously use to receive changes in Schema ( field +/-, domain changes etc ) for our Utility dataset..
Since we have swicthed to a multiuser Geodatabase ( ArcSDE on Oracle ) , we would like to ...
- 774
13
votes
3
answers
6k
views
How to compare schemas from two File geodatabases?
We have template geodatabase, which we send out to our regional Data creators. They update these geodatabases and digitize all the data from their region in the predefined featureclasses.
Now that we ...
- 41.6k
23
votes
3
answers
8k
views
Geometry column naming convention - 'geom' or 'the_geom'?
I'm starting my first PostGIS project, and in various books and tutorials I've seen the geometry column labelled either 'geom' or 'the_geom'. Is one more conventional than the other?
Furthermore, is ...
- 363
7
votes
4
answers
1k
views
How to build PostGIS database schema for flexibility and normalization?
I'm creating a database that will be used by researchers in population genetics with different goals and sampling strategies. The database needs to accommodate locations as points, lines, or polygons ...
- 1,671
4
votes
0
answers
104
views
Importing existing data model into geodatabase [closed]
How can I integrate an existing ArcGIS datamodel like Arc Marine into my geodatabase? I don't have schematics in my ArcGIS 9.3.1.
- 91
1
vote
1
answer
1k
views
How to create Feature Class based on DBF schema?
I have an attribute table schema (about 30 fields) stored in an Excel document, which I exported as a dbf. I can easily make a geodatabase table from this, using the Excel sheet as a template. How can ...
- 4,055
20
votes
14
answers
47k
views
Reordering fields (permanently) in file geodatabase using ArcGIS Desktop?
Using ArcGIS 10.0, is it possible to reorder the fields in a file geodatabase, and have the order persisted to the database?
We considered exporting to XML, and writing a parser to change the field ...
- 21.2k
0
votes
1
answer
268
views
Are these 9.2 CASE tools instructions still valid using ArcGIS 10.1?
The Using CASE tools in ArcGIS 10 document links to some older documentation at Building geodatabases with case tools, which specifically mentions ArcGIS 9.2 throughout.
Are these instructions still ...
- 21.2k
3
votes
1
answer
405
views
How to manipulate OpenStreetMap schema to be useful in ArcGIS applications?
I have a shapefile of OSM data. I plan to use the data for an ArcGIS Engine application, and I was wondering if there are any existing solutions to getting the data's schema into your typical GIS ...
- 7,403
3
votes
1
answer
1k
views
Schema locking logistics on ArcSDE for SQL Server?
I have a set of feature classes that I want to be able to edit schema or what ever I want to do in the heat of the battle and I don't want to be stiffled by schema locks.
I have a interpretable ...
- 3,398
1
vote
1
answer
3k
views
Converting Microsoft Visio 2007 .vsd file to xml workspace document (without the macro)
I was just editing my geodatabase schema in Microsoft Visio and noticed that it is the new 2007 version, rather than 2003 which had a handy export tool, therefore I downloaded the ESRIExportToXML ...
- 63
19
votes
4
answers
3k
views
How to generate schemas of GIS hardware / software / workflows?
Quite often I find myself in a situation where I need to explain hardware or software GIS infrastructure to people with no or limited knowledge of GIS. Or give an overview of geoprocessing tasks ...
user173