Questions tagged [schema-architecture]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
0answers
13 views

Data Modeling for Telecom utilities

I'm looking for standard data modeling for Telecom utilities (fiber, copper, wireless) to implement on our project.
0
votes
0answers
21 views

Combining zip code polygons with numerical dataset in web-stack?

I need help with the overall architecture/stack of my project. I have many spreadsheets of data with zip codes, categories, and numerical values (and a ton of other columns that will eventually be ...
1
vote
0answers
45 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
0answers
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
1answer
50 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 ...
4
votes
2answers
355 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
2answers
221 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
vote
0answers
82 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 ...
1
vote
1answer
349 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 ...
3
votes
1answer
336 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, ...
2
votes
1answer
153 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
1answer
491 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 ...
1
vote
0answers
3k 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 ...
0
votes
1answer
66 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 ...
1
vote
1answer
274 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 ...
1
vote
1answer
160 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 ...
4
votes
1answer
384 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
2answers
1k 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....
4
votes
1answer
502 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 ...
2
votes
1answer
211 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 ...
9
votes
3answers
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 ...
1
vote
1answer
927 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 ...
13
votes
3answers
4k 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 ...
22
votes
3answers
5k 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 ...
6
votes
4answers
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 ...
4
votes
0answers
100 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.
1
vote
1answer
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 ...
18
votes
10answers
39k 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 ...
0
votes
1answer
256 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 ...
3
votes
1answer
388 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 ...
3
votes
1answer
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 ...
1
vote
1answer
2k 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 ...
19
votes
4answers
2k 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 ...