Database issues

Today I have been battling some database issues that seemed to be related to the schema in the sql files. For some reason, unless you specify the schema to be public, the database will not show the tables when using the \d command to list all tables.

The way I fixed this was to again go through and redo all of the sql files and specify the schema as public. This seems to be working for the time being and all of the tables are showing up when executing the \d command.

Jianfei showed me his viewer today and it looks great, hopefully now that we have everything working we will start progressing much faster.

Database Update

Since we have just installed a new version of Postgresql and PostGIS with GEOS support, I decided to reload the tables into the database. I also wanted to add a GisT index to make queries a bit faster.

The first thing I did was drop all of the tables that were currently in the database. Then I took the newest shapefiles from my machine and converted them to sql using the shp2pgsql function. I then uploaded the new files into the nij_database under the schema name "nij". The tables are currently there now and i have not only put the woodward files in, but also the cameron files.

Another thing I did was convert the junction files that I had created with the network datasets and put them in the database as well.

I am hoping that Jianfei will have a viewer ready by next week, this will give me a better idea of how things are working and if I need to make any changes to the tables or their geometries.

New versions installed

Looks like the system admin. installed the newest version of GEOS, and PostGIS to the linux machine where the database is kept.

I haven't had a chance to test anything out yet, since I am working on backing up files on removable media.

Tomorrow morning I should be able to put everything through a good test to make sure it's working normal. Hopefully I will break something...