March 08, 2007
We can now successfully query a database and return the data to the map viewer page without refreshing the page! The current prototype, found here, requires you to be logged on as Jen so you can run the XAMPP webserver and query the database. If you click the “Submit Query” button the form will submit a request to a php script called shapelister.php which will then process the bounding box, query the database, and then return the resulting database rows. The prototype is currently checking against a copy of the historic_point shape file. So, click the button, and all the historic points that exist within the bounds of the viewer will be returned with their name and longitude, latitude coordinates.
The next step is to load the data from our shape files into a new table listing all of our geometries and their respective shape file. Once GeoServer is running we could also return the data as layers to display in the viewer and provide links to download the datasets as KMLs.
Posted by shawse at March 8, 2007 12:06 PM