Progress on digitizing Cameron Research Center

While I am still unable to fully convert the dBase files into SQL scripts automatically, I have decided to start expanding on the data I already have.

Since Cameron Research Center is much smaller, less complex, and has fewer rooms I have decided to start digitizing the building elements like I did for Woodward hall. I was able to create feature classer for each floor's rooms (polygons) and still need to digitize hallways and elevators.

I will then take the much simpler table from this building and begin exporting it into a Oracle database. I also need to start looking for ways to automate these processes.

dBase to SQL Issues

In order to export the geodatabase, I must first convert the files to dBase and read them in a third party program. Once I have the registered version I will be able to convert directly to SQL scrips or .CSV files.

The one problem that I am facing now is that the ObjectID field, which is a primary key, does not convert over to dBase format. It's of type "objectid", which, when displayed in DBF Manager only shows up as zeros. I will have to find a way to assign object ID's in a different type so they can be transferred over.

Future Goals, Database Info

Next week I plan on starting the Geocoding aspect of the project. The first thing I will do is consult with Dr. Paul Smith about possible methods. i will then add entries to the MAT in order to put points on the map where I need them. I will most likely have to manually do this. After this is done, I will have to explore more options in implementing the data in 3D.

I also want to export the database so that SQL calls can be made programmatically.

If I can get all of these things done I will have a good week....