I’ve been working on a side project using pgRouting to determine the least-cost path across a street network from a given building to the nearest bus stop within Bellingham, WA. It’s one thing to execute pgRouting’s built-in functions for a single vertex (building) to another vertex (bus stop)… but another to have the function iterate [...]
With the routing database configured and populated, and with geoserver rendering the WMS, now the focus can shift on designing the actual display and functionality.
The conceptual plan is as follows:
Extract the geometry of a user’s click on the map.
Pass the extracted geometry to a PHP script, via an HTTP GET request.
Use the PHP script to [...]
Since compiling Orkney’s pgRouting extension to PostgreSQL/PostGIS, I’ve decided to try my hand at creating a simple web interface to poke into the database. The current setup is as follows:
Display: OpenLayers
Renderer: Geoserver (via non-cached WMS)
Spatial Backend: PostGIS/pgRouting enabled PostgreSQL
Data: Public GIS data from the city of Bellingham, Washington’s GIS department.
For the sake of brevity, (but [...]
While working through Regina Obe and Leo Hsu’s PostGIS In Action I thought that I’d jump into the world of routing. My plan was to develop a sample application that could be used to plan bicycle routes throughout the city of Seattle. A quick google search proved that someone has already done it, and done [...]
With such a small footprint (a single file) SpatialLite appears to a novice like myself to be a fantastic niche storage solution for spatial data. In an environment where installing larger FOSS databases such as MySQL or PostGIS/PostgreSQL can be prohibitive, Spatial Lite appears to provide a great solution. Using the provided GUI interface, it’s [...]