Implemented PgPhoneHome Web app

Today I finally worked the bugs out of the Postgresql Windows installation and got it up and running. I also resolved the issue with StackBuilder running for Postgresql Plus and was finally able to implement the PgPhoneHome iphone Web application. I have tested it from my local box as well as Jianfei's iPhone and it seems to be working correctly.

Below are a few screenshots of it running in the iPhone simulator on the Mac in the demo lab:

This screenshot shows the home page of phPhoneHome

This screenshot shows the different tools available in the program

This shows the server information

This shows the windows that allows you to exectute SQL queries on your server

Installation of Postgresql Plus on Windows

Just for a reference I am going to post these links to the installation of Postgresql Plus on Windows:

http://www.enterprisedb.com/learning/getting_started.do

This also includes the documentation for installing the server with Apache/PHP support for web applications.

Project Progress update 1/24/2009

This week I have been able to acquire the CAD data files for the College of Education at UNCC. I have been through the process of "cleaning" up these data files for use in our database and for our automation program. This process allowed me to delete and filter out all polygons and other bits of data that were either erroneous or not useful. After this was finished I was able to take each floor and geo-reference it to the base map in order to put it in the correct coordinate system for this project.

The current building files are now located in our GIS database as spatial data files that have been converted from shapefiles. They are now in the proper format to be read by Jianfei's automated centerline program to make paths inside the building.

Other things that have been done are: setting up and test the new version of Postgresql on my Windows box. This has allowed me to install the pgPhoneHome iPhone web application that will allow us to mainipulate our database from the iPhone. This will hopefully provide a first step in our mobile application.

I have also come across a useful project called FeatureServer. It is basically a implementation of a RESTful Geographic Information feature service. I will be posting more information about this service and all of the details in a later blog post.

Implementation of phPhoneHome for remote iPhone connections

I have come across the phPhoneHome program for Postgresql that will allow me to administer the NIJ database from an iPhone. This should provide a useful starting point for our mobile application and should let us start sending/receiving data between the device and the server.

The program is installed as part of stackbuilder on the Enterprise DB installation, which is located at: http://www.enterprisedb.com/begin-download.do?redirectReason=startDownload . The application isn't really an application in essence, but a way to format the administrative tools for use on the iPhone.

The program was created by Dave Page who has an interesting and useful blog at: http://pgsnake.blogspot.com/ . Dave works for EnterpriseDB and developed the Iphone application that I will be using. His blog is a useful source of information for Postgresql information that I hope to use more of in the future.

Currently I am trying to get the server running on my Windows box since I have to get Scott Wood to do the install on our main DB server. At the moment, things don't seem to be working correctly and my server isn't recieving incoming connection on TCP/IP. Once i have this problem resolved I should be able to load the iPhone interface and try to test sending quieries and updates via SQL to the server.

Below are some screenshots that show how pgPhoneHome looks and works:

This show the main interface with all the tools available for use

This next screenshot show the server information once a connection is established.