I have chosen Visual Studio as the environment in which we will create the new Avkat Web App. This app will collaborate with the work Daniel has done on ArcGIS online. I have embedded the map within my website, which was a fairly straightforward process. I have created a interface that allows for querying our tabular data on the database Avkat_mySql. Users will be able to chose content types of features, survey units, and ceramics. Users can specify a date range or Era which corresponds to each content type. When Users click the button “Execute Query” a table will be generated that includes all the needed attributes of their chosen content. The first two cells of each row contain an info and photo button. The info button will bring the user to a new tab that has a detailed listing of all attributes. The photo button will bring the user to a new tab that will display all photos of the chosen content.
We are currently creating the functionality behind the photo and info button. I am collaborating with Daniel to make this happen. The design of the current website is also under construction. We are focusing on the functionality of the web app first and foremost. Here is a quick look at what we have so far, with some queried results.
Recently I have setup a map in Arcgisonline for eventual use embedded in the avkat website.
- The layers of this map are taken from the Mapserver definition file currently running on earth.cofc.edu:10080/avkat.html.
- I took the MapServer file that is being hosted on earth and split it into seven seperate MapServer files that are each running independently on earth.
- Then I imported them into a new map in Arcgisonline with their own observation pop-ups.
With the help of Norm, I imported the photolog to our Avkat geodatabase as an SDE geodatabase table. To begin working on bringing the photos into the map as part of each feature’s popup along with its other information.
- I then imported this table to the Survey Units MapServer file
- and the Features MapServer File.
- This photolog has a field FUSUID that shows either the FUID or the SUID where each picture was taken of the over 15,000 pictures.
- I then related the features layer to photolog on FUID and FUSUID.
- I then related the survey units layer to photolog on SUID and FUSUID.
- these relates will allow us to know exactly which photos go with every single fuid and suid.
The next step is to setup the photos on our server so that they can be accessed by our map.
- Originally we thought that we could create a Raster Catalog that would point to the directory where the photos are and that we would not need to actually move the photos.
- After we began the geoprocess we realized that creating a raster catalog and loading the photos would actually copy and paste the 40 gigabytes of photos. This was no good.
- We then realized that all we had to do was to create a simple website with a list of hyperlinks to each photo using our Inetpub/wwwroot directory.
- This gave me a lot more trouble that expected. I discovered that the standard way to create a html page has all links within the same directory as the html page in the wwwroot folder. I had something different, my pictures were on a network drive on an entirely seperate machine.
- I attempted to create a virtual directory using IIS 6.0 so that the hyperlink would assume that on my website, https://earth.cofc.edu/avkat_photos.default.htm there would be a way to go to https://earth.cofc.edu/avkat_photos/images/imagename to view a specific photo called imagename. This “subdirectory” images would not be located physically within the avkat_photos directory.
- I am still researching how to correctly execute this virtual directory to allow my hyperlinks to work correctly.
I am copying the spatial SQL database, named Avkat, and the tabular SQL database, named avkat_mysql, from the geodata server where they are live, to the beta server, gis.cofc.edu. Once they are both copied to gis, we will attempt to run our live beta version of the web viewer through these two beta databases. I will begin to merge the spatial and tabular databases into a single database for our beta production, in order to simplify the querying done by our system.
I discovered how to copy the tabular database from geodata to gisdata. That was easily done within sql server management studio. The spatial data requires extra steps. I attempted a plain copy using sql server but this will not work. The spatial database is a geodatabase that has certain schema properties set from arcgis server. I am not able to do this at the moment because our arcgis server version 10.1 is not running at the moment. I have found that all I have to do is use the Enable Enterprise Geodatabase tool in arccatalog to change the schema of a basic sql server database into an arc sde. This requires something called an authorization file.
“Provide the path and file name of the keycodes file that was created when you authorized ArcGIS for Server Enterprise. This file is in the \\Program Files\ESRI\License<release#>\sysgen folder on Windows and /arcgis/server/framework/runtime/.wine/drive_c/Program Files/ESRI/License<release#>/sysgen directory on Linux. If you have not already done so, authorize ArcGIS for Server to create this file.”
This authorization file is not there on our machine because we have been having trouble updating the version of arcgis server from 10.0 to 10.1. Once we can finish the install on our arcgis server, we will be able to create a new SDE geodatabase.
As an aside, Dr. Newhard asked me to post the following so we would not forget. We also discovered a change in how connecting to SDE databases works in arcgis 10.1. When connecting to Avkat as an SDE in ArcGIS, after creating the connection shortcut, you must right click on the database connection, then go to geodatabase connection properties and change the transactional version from DEFAULT to Published. This will allow it to show all of the changes made to it by us.
Today we have successfully moved the user interface from Earth to GIS. The new URL is http://gis.cofc.edu:10080/avkat.html. We will now move our 2 databases(avkat, avkat_mysql) over to server GIS to make a full migration of Avkat Informatics, without any ties to server Earth, or Geodata. We are currently digging through the code to find all of the data retrieval endpoints, which we will now direct to GIS. I have identified the main endpoint to be the file OpenDB.php. The endpoint has now been updated to gis.COUGARS.INT without any visible problems. We must continue to make sure all of the data pointers are consistent. The next step will be to connect the UI to our tabular data on avkat_mysql. Doing so will add functionality to the left panel of our current UI. Multiple breakthroughs were achieved today, progress should move much faster from this point.
This course is a directed study course with Dr. Jim Newhard, Dr. Norm Levine, and Dr. Paul Anderson at the College of Charleston that brings together the Classics, Geology, and Computer Science departments. Using advanced GIS techniques in combination with SQL server we will attempt to improve the current viewing solution to Avkat Informatics. I will be working alongside another student, Matt Mazzarell, to display the GIS data in the Web View on our server, earth.cofc.edu.
On Tuesday, September 11, 2012 Norm gave Matt and I a quick lesson on the mapping of network drives that will be used to ensure consistency across the project. This is the same mapping that is used by all involved in the GIS work at the College of Charleston. He also walked through some basic server setup and maintenance to allow us to have access to remote login to the server, earth. All involved in the Avkat project have been granted access to the server at this point and can proceed to work.
It should be noted that this is our first WMA, designed to handle basic query searches and data extraction. We will design WMAs relevant to the needs of the project.