Child Care Provider Map

<style><!-- [et_pb_line_break_holder] --> #map-canvas { width:80%; height:500px; }<!-- [et_pb_line_break_holder] --> .layer-wizard-search-label { font-family: sans-serif; }<!-- [et_pb_line_break_holder] -->.color {<!-- [et_pb_line_break_holder] --> border: 1px solid #ccc;<!-- [et_pb_line_break_holder] --> height: 12px;<!-- [et_pb_line_break_holder] --> width: 12px;<!-- [et_pb_line_break_holder] --> margin-right: 3px;<!-- [et_pb_line_break_holder] --> float: left;<!-- [et_pb_line_break_holder] --> }<!-- [et_pb_line_break_holder] --> .red { background: #C00; }<!-- [et_pb_line_break_holder] --> .yellow { background: #FF3; }<!-- [et_pb_line_break_holder] --> .legend-item { float: left; margin-top: -10px; }<!-- [et_pb_line_break_holder] --></style><!-- [et_pb_line_break_holder] --><div class="ccp_button" style="margin-top: 10px; float: left; width: 20%;"><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->Show providers table<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><label class="layer-wizard-search-label"><!-- [et_pb_line_break_holder] --> <h2>Search for providers</h2> <!-- [et_pb_line_break_holder] --> <p class="ccp_text"> Use the drop box below to search child care providers and TRS locations.</p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> <select class="ccp_dropdown" id="search-string_0" onchange="changeMap_0(this.value);"><!-- [et_pb_line_break_holder] --> <option value="--Select--">Show all providers</option><!-- [et_pb_line_break_holder] --> <option value="79072">79072</option><!-- [et_pb_line_break_holder] --> <option value="79235">79235</option><!-- [et_pb_line_break_holder] --> <option value="79316">79316</option><!-- [et_pb_line_break_holder] --> <option value="79323">79323</option><!-- [et_pb_line_break_holder] --> <option value="79329">79329</option><!-- [et_pb_line_break_holder] --> <option value="79336">79336</option><!-- [et_pb_line_break_holder] --> <option value="79339">79339</option><!-- [et_pb_line_break_holder] --> <option value="79347">79347</option><!-- [et_pb_line_break_holder] --> <option value="79356">79356</option><!-- [et_pb_line_break_holder] --> <option value="79363">79363</option><!-- [et_pb_line_break_holder] --> <option value="79364">79364</option><!-- [et_pb_line_break_holder] --> <option value="79371">79371</option><!-- [et_pb_line_break_holder] --> <option value="79372">79372</option><!-- [et_pb_line_break_holder] --> <option value="79373">79373</option><!-- [et_pb_line_break_holder] --> <option value="79379">79379</option><!-- [et_pb_line_break_holder] --> <option value="79381">79381</option><!-- [et_pb_line_break_holder] --> <option value="79382">79382</option><!-- [et_pb_line_break_holder] --> <option value="79401">79401</option><!-- [et_pb_line_break_holder] --> <option value="79403">79403</option><!-- [et_pb_line_break_holder] --> <option value="79404">79404</option><!-- [et_pb_line_break_holder] --> <option value="79407">79407</option><!-- [et_pb_line_break_holder] --> <option value="79409">79409</option><!-- [et_pb_line_break_holder] --> <option value="79410">79410</option><!-- [et_pb_line_break_holder] --> <option value="79411">79411</option><!-- [et_pb_line_break_holder] --> <option value="79412">79412</option><!-- [et_pb_line_break_holder] --> <option value="79413">79413</option><!-- [et_pb_line_break_holder] --> <option value="79414">79414</option><!-- [et_pb_line_break_holder] --> <option value="79415">79415</option><!-- [et_pb_line_break_holder] --> <option value="79416">79416</option><!-- [et_pb_line_break_holder] --> <option value="79423">79423</option><!-- [et_pb_line_break_holder] --> <option value="79424">79424</option><!-- [et_pb_line_break_holder] --> </select><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> <select class="ccp_dropdown" id="search-string_1" onchange="changeMap_1(this.value);"><!-- [et_pb_line_break_holder] --> <option value="all">Show all locations</option><!-- [et_pb_line_break_holder] --> <option value="trs">Show only TRS locations</option><!-- [et_pb_line_break_holder] --> </select><!-- [et_pb_line_break_holder] --></label><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --><h2>Legend</h2><!-- [et_pb_line_break_holder] --><p><div class="color yellow"></div><span class="legend-item">Location</span></p><!-- [et_pb_line_break_holder] --><p><div class="color red"></div><span class="legend-item">Texas Rising Star</span></p><!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --></div><!-- [et_pb_line_break_holder] --><div id="map-canvas" style="display: none"></div><!-- [et_pb_line_break_holder] --><script type="text/javascript"src="https://maps.google.com/maps/api/js?key=AIzaSyAus8w-OIDcfCMOUs37PZfreHWZ_Uu6Bns"></script><!-- [et_pb_line_break_holder] --><script type="text/javascript"><!-- [et_pb_line_break_holder] --> var map;<!-- [et_pb_line_break_holder] --> var layer_0;<!-- [et_pb_line_break_holder] --> function initialize() {<!-- [et_pb_line_break_holder] --> map = new google.maps.Map(document.getElementById('map-canvas'), {<!-- [et_pb_line_break_holder] --> center: new google.maps.LatLng(33.57054912752844, -101.86981679907227),<!-- [et_pb_line_break_holder] --> zoom: 12,<!-- [et_pb_line_break_holder] --> mapTypeId: google.maps.MapTypeId.ROADMAP<!-- [et_pb_line_break_holder] --> });<!-- [et_pb_line_break_holder] --> layer_0 = new google.maps.FusionTablesLayer({<!-- [et_pb_line_break_holder] --> query: {<!-- [et_pb_line_break_holder] --> select: "col5",<!-- [et_pb_line_break_holder] --> from: "1n2KXss1U31NS6-OB42ZyVeK4nkRRrNvYfpK6PE2z"<!-- [et_pb_line_break_holder] --> },<!-- [et_pb_line_break_holder] --> map: map,<!-- [et_pb_line_break_holder] --> styleId: 2,<!-- [et_pb_line_break_holder] --> templateId: 2<!-- [et_pb_line_break_holder] --> });<!-- [et_pb_line_break_holder] --> }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> var selectedZIP;<!-- [et_pb_line_break_holder] --> var selectedTRS;<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> console.log(selectedZIP);<!-- [et_pb_line_break_holder] --> console.log(selectedTRS);<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> function changeMap_0() {<!-- [et_pb_line_break_holder] --> var whereClause = '';<!-- [et_pb_line_break_holder] --> selectedZIP= document.getElementById('search-string_0').value.replace(/'/g, "\\'");<!-- [et_pb_line_break_holder] --> if (selectedZIP != '--Select--') {<!-- [et_pb_line_break_holder] --> whereClause = "'Zip' = '" + selectedZIP+ "'";<!-- [et_pb_line_break_holder] --> }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> if (selectedTRS && selectedTRS != 'all') {<!-- [et_pb_line_break_holder] --> if (selectedZIP && selectedZIP != '--Select--') {<!-- [et_pb_line_break_holder] --> whereClause += " AND ";<!-- [et_pb_line_break_holder] --> }<!-- [et_pb_line_break_holder] --> whereClause += "'TEXAS RISING STAR' IN ('4-STAR', '4 STAR', '3 STAR', '2 STAR')";<!-- [et_pb_line_break_holder] --> }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> layer_0.setOptions({<!-- [et_pb_line_break_holder] --> query: {<!-- [et_pb_line_break_holder] --> select: "col5",<!-- [et_pb_line_break_holder] --> from: "1n2KXss1U31NS6-OB42ZyVeK4nkRRrNvYfpK6PE2z",<!-- [et_pb_line_break_holder] --> where: whereClause<!-- [et_pb_line_break_holder] --> }<!-- [et_pb_line_break_holder] --> });<!-- [et_pb_line_break_holder] --> }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->function changeMap_1() {<!-- [et_pb_line_break_holder] --> var whereClause = '';<!-- [et_pb_line_break_holder] --> selectedTRS= document.getElementById('search-string_1').value.replace(/'/g, "\\'");<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> if (selectedTRS== 'trs') {<!-- [et_pb_line_break_holder] --> whereClause = "'TEXAS RISING STAR' IN ('4-STAR', '4 STAR', '3 STAR', '2 STAR')";<!-- [et_pb_line_break_holder] --> }<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->if (selectedZIP && selectedZIP != '--Select--') {<!-- [et_pb_line_break_holder] --> if (selectedTRS == 'trs') {<!-- [et_pb_line_break_holder] --> whereClause += " AND ";<!-- [et_pb_line_break_holder] --> }<!-- [et_pb_line_break_holder] --> whereClause += "'Zip' = '" + selectedZIP + "'" ;<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] --> layer_0.setOptions({<!-- [et_pb_line_break_holder] --> query: {<!-- [et_pb_line_break_holder] --> select: "col9",<!-- [et_pb_line_break_holder] --> from: "1n2KXss1U31NS6-OB42ZyVeK4nkRRrNvYfpK6PE2z",<!-- [et_pb_line_break_holder] --> where: whereClause<!-- [et_pb_line_break_holder] --> }<!-- [et_pb_line_break_holder] --> });<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->google.maps.event.addDomListener(window, 'load', initialize);<!-- [et_pb_line_break_holder] --><!-- [et_pb_line_break_holder] -->window.onload = function () {<!-- [et_pb_line_break_holder] --> google.maps.event.addDomListener(window, 'load', initialize);<!-- [et_pb_line_break_holder] --> document.getElementById('map-canvas').style.display = "block";<!-- [et_pb_line_break_holder] -->}<!-- [et_pb_line_break_holder] --></script>