<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi all,<br>
<br>
During the day I wear my Denver Public Schools hat, and have been
spreading the good word of SQL Spatial, specifically ST_Distance, to
our analysts here with much relief and excitement. They are database
users, not "GIS" users, so the ability to simply add a distance
query to their existing (and complex) enterprise queries brings huge
power to our analysis, and of course is very intuitive. <br>
<br>
Additionally, I've been spreading the word of the concept of <i>'</i>distance<i>
along the network'</i> (ie. driving distance or <span
class="comment-copy">pgr_kDijkstra algorithms in pgRouting) </span>as
they apply to routing kids to their closest school by program type,
grade, etc... which brings an equal or greater level of excitement
from our analysts...<br>
<br>
Distance along a network as a SQL spatial function has huge
potential in the way we assign kids to a school, as the system of
polygon 'boundaries' is becoming more and more scrutinized as a
solution whose time has almost come to an end.<br>
<br>
My question is - and see the recent posts below on GIS.SE on this
subject - <b>how can the driving distance functions be implemented
in the same way that ST_Distance works</b>... ie, I have a table
of points (student households), and 2nd a list of points (schools),
and want to determine the students closest school (including other
attribute filters such as program type, etc.).<br>
<br>
GIS.SE / recent questions:<br>
<br>
<a class="moz-txt-link-freetext" href="http://gis.stackexchange.com/questions/110716/nearest-facility-with-pgrouting">http://gis.stackexchange.com/questions/110716/nearest-facility-with-pgrouting</a><br>
<br>
<a class="moz-txt-link-freetext" href="http://gis.stackexchange.com/questions/110838/how-to-calculate-the-shortest-distance-for-multiple-source-and-targets-using-pgr">http://gis.stackexchange.com/questions/110838/how-to-calculate-the-shortest-distance-for-multiple-source-and-targets-using-pgr</a><br>
<br>
Many thanks for any insight / thoughts / suggestions!<br>
<br>
-m<br>
<br>
Matthew Baker<br>
Denver Public Schools<br>
Department of Planning and Analysis<br>
<br>
</body>
</html>