GEOS problems

Seems like we have limited functionality in PostGIS since we haven't yet installed GEOS support. This will add functions that will allow us to extract geometry information from the tables we created.

Currently we are waiting for the system admin. to install this software and set up the other packages that are dependent on it. I have also put in a request to have Quantum GIS installed on the linux box so that we will have a way to view the GIS data we created.

Next week I am hoping we will have a prototype viewer and all of the datasets uploaded with all of the GEOS functionality that we need.

Finalizing woodward database

I have sent the SQL files to Jianfei to upload to the database. These should be the final builds of this data, and hopefully it will work with little to no errors.

I have also been able to test the Quantum GIS tool to view the tables graphically using only the table information. This confirms that the "the_geom" column does contain all the needed information for interpreting geographic information.

The next step will be to keep sending datasets to the database and hopefully develop an entire database of two building as well as a rudimentary viewer to look at these files.

PostGIS information

Today I discovered several good websites for PostGIS information. The first lists all of the functions that are included in PostGIS and how to execute them. That site is http://www.bostongis.org/postgis_quickguide.bqg

The next thing I have found is a viewer that reads directly from PostGIS, this utility is called Quantum GIS, and it is open source and cross platform. The website is www.qgis.org

I am currently working with Jianfei to start construction of our own viewer and also uploading more datasets to the main database.