= DATE(NOW()) OR r.project_enddate_datetime='0000-00-00 00:00:00') GROUP BY re.emphasis_area ORDER BY re.emphasis_area asc;"; */ $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $ea = rtrim($row['emphasis_area']); if (!in_array($ea, $arr)) { $arr[] = $ea; } } // now get those with active $actives = array(); $sql = "SELECT DISTINCT re.emphasis_area, r.project_enddate FROM requests_emphasis re INNER JOIN requests r ON r.request_num = re.request_num WHERE ( DATE(r.project_enddate_datetime) >= DATE(NOW()) OR r.project_enddate_datetime='0000-00-00 00:00:00') GROUP BY re.emphasis_area ORDER BY re.emphasis_area asc;"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $actives[] = trim($row['emphasis_area']); } if (!empty($arr)) { print " "; } } ?>

Grant Impact Map

All active grants are shown on the map above with locations where services are provided, which is not necessarily the location of the grantee organization. For example, a grantee that provides programs at 20 schools will show locations for each of those twenty schools. Each grant was also coded by areas of emphasis (column shown at right). To see locations by areas of emphasis, simply click on a topic. Clicking on each pin will provide additional information on the grant, such as the project description and amount of the funding award.

Note: Due to confidentiality reasons, domestic violence shelters do not appear on the map.

Selections