The tag has no wiki summary.

learn more… | top users | synonyms

4
votes
1answer
79 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 ...
1
vote
1answer
72 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 ...
7
votes
3answers
492 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
128 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 ...
12
votes
3answers
728 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 ...
12
votes
3answers
642 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 ...
4
votes
4answers
231 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
66 views

Importing existing data model into geodatabase [closed]

How can I integrate an existing ArcGIS datamodel like Arc Marine into my geodatabase? I dont have schematics in my ArcGIS 9.3.1.
5
votes
1answer
860 views

ARCMAP ERROR 000464: Cannot get exclusive schema lock

I am trying to run the "Near" tool in Arcmap. Both my layers involved are on a SDE database. When I run the tool I get the following error... ERROR 000464: Cannot get exclusive schema lock. ...
1
vote
1answer
270 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 ...
9
votes
4answers
3k views

How to reorder fields (permanently) in a file geodatabase

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
174 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 ...
2
votes
1answer
232 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 ArcEngine application, and I was wondering if there are any existing solutions to getting the data's schema into your typical GIS format. ...
4
votes
1answer
383 views

SDE analysis - file locking logistics - ArcSDE 10 on MSSQL

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
1k 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
800 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 ...