Show projects needed to be located

While I was sending an email about the progress, I thought of building a page to show the projects that did not have Latitude/Longitude. This means they have not been located. It could also mean that the data from one file has not been pushed to another. Makes a nice report

Also made the department sort by community name and show the sequence number.

Show communities for not located and they show the index key.

Listing projects in each department

Updated the department file to find the projects in each department. It creates a table of all the projects listed by community.

http://www.lagerquist.com/joel/mano/bolivia-map.php

Department map

Yesterday I found a map of Bolivia that I could create hot spots on for each department/state. This morning I created the hot spots (using a great tool GeoHTML by Alexander Samsomov), wrote a little code, and now can pick stuff based on department.

I plan to show project info specific to each department.

Runways

I created a table for the runway projects. I have all the types of projects in a separate file. It would be possible to have them interspersed in the same file, but I think this is easier. Each project table has identical structure so the code to show them is the same.

Rewrote the main page so it can work with any of the projects. Now don't need a specific one for each project.

Got the blurb about the 79th clinic in Piusilla. I created a new entry for it, deleted an old one, then recalled Tony had told me coordinates for it. This is why having a backup is important. I can get the coordinates from the email I have saved at home.

Figured out KML file generation

I wanted to generate a KML file for locating the project in Google Earth. I got some code from them but when I tried it it did not work. I figured out that I didn't need to have the standard HTML header in the PHP file that generates the KML file.

I have a hyperlink on the satellite image now that works. I need to reopen the database in the file that generates the KML file so I can get more information to put in the positioning information. Right now I just have the name, project type, and number. I would like to have province/department, country, dedication, locate source. This would fit what I had done by hand.

I should also place a link bank to the web page that got me into Google Earth.

Need better layout

At some point here I will need to get a better layout. I need to look around the web and find something to copy. Then I need to learn to program HTML or PHP to paint it. I could find a fancy page editor but they generate terrible code.

Marcus at Mano a Mano Bolivia has created a nice site for Mano a Mano Bolivia. It is well laid out and simple. It even works in both English and Spanish. Good job Marcus.

Images on clinic page

Once I figured out the naming convention I could add code to show the images. I have a picture of the Chapisirca clinic so I started there (as I have been with all features). I got pictures of the map of the area, a satellite image, and my picture. I resized them and uploaded them. I updated the web page to show the images and added hyperlinks to map sites. I created a new page that would show the picture in a larger format.

Naming convention

I had been thinking about how to name the files for the images. I was worrying about name collisions and having people name them consistently. I came up with the idea of fixed name files for the type and having a directory with the sequence number. Now I don't have to have a name, they are all fixed.

I have a directory named image. Under that I have one named project. That is because there might be images of stuff other than the projects. Under there I have two directories, clinic and school. Those are the two project types I am focusing on right now. Under those I have a directory for each project. It is named the sequence number of the project. In that directory I have the specific files. map for a map, sat for a satellite image, proj for a picture of the project from the outside, broch for a scanned image of the brochure that is printed when the project is dedicated. I will add tags on the end when I need larger or smaller images.

Creating a database

Next I thought of creating a database of the clinics. This way I could make pages for each clinic. I made three tables; one for clinics, one for schools, and one for villages. The villages will have location and population. The clinics and schools will have their location, dedication date, and names of files for images and such.

I got that created and filled in a bit. I also created a page to show a list of the clinics and then something about the clinic when you click on it. I had to learn how to do a join to get some info from the village table. The bulk of the code I reused from our player piano roll project.

Found neat map site

Each day I try to look at Wikipedia for interesting bits of knowledge. One day there was something about a town in Bolivia. I went to the page for it. They had a link to a map site I had not seen. It allows looking at each department (states) and the municipalities(counties)

http://www.aguabolivia.org/situacionaguaX/Riego/mapas/indexrh.htm

Web clinic project

I like Google Earth. It allows you to see things on the earth. I found a couple of the Mano a Mano clinic locations there. Chapisirca has a really good picture. I also saw that pictures from Panoramio show up on Google Earth. I uploaded a few of mine of the area.

I then thought: "Why can't we mark all the clinics here?".

I got a list of the clinics from Nate and entered them into my Google Earth. I uploaded the KMZ file to a website I created. I then tried to find the villages. That was not going very well.

I used www.geody.com, www.fallinggrain.com to locate villages. I have since found that maps.live.com also does a good job.