Tools of the Trade

Avkat Informatics

We will be using a variety of software for this summer which will build upon previous work for the Avkat Archaeological Project. Prior work has been dominated by the creation of an SQL database coded in MySQL. A front-end was created for this database using PHP for query optimization. This database has stored all tabular and image data for the project, however spatial information has been lacking.

ArcSDE is used to store spatial information. Recently the MySQL database was translated to PostgreSQL which employs pgAdminIII. This allows for better communication between the SQL database and the ArcSDE geodatabase.

Currently, we are working on building data queries which result in tables and views which can then be queried by end users. It is important to note here the difference between the two – tables and views. Tables result in a more static image of the data within the SQL…

View original post 472 more words

Advertisements

Author: johnwallx

NC State University PhD Student in Earth Science with a masters in Geographic Information Systems.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s