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