sf-trees

Data source: data.sfgov.org

Custom SQL query returning 22 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
29299 225151 2 99 14 Montezuma St 1 1 1 1     10 Width 3ft   6007510.1037 2099736.8177900002 37.7459018513879 -122.416737884151 (37.7459018513879, -122.416737884151)
38579 190011 2 99 1599 Newhall St 1 4 1 1     10 Width 4ft   6014210.748430001 2095415.1555299999 37.7344100624646 -122.39326543937 (37.7344100624646, -122.39326543937)
39929 225188 2 99 500 Capp St 2 1 1 1     10 Width 3ft   6007247.90987 2103966.5437 37.757500966319604 -122.417944302192 (37.7575009663196, -122.417944302192)
50903 225174 2 99 1000 Jarboe Ave 1 2 1 1     10 Width 3ft   6009367.84971 2096849.47647 37.738078156068894 -122.410110221514 (37.7380781560689, -122.410110221514)
54322 206026 2 99 804 Faxon Ave 1 2 1 1     10 Width 10ft   5994921.599769999 2093400.11628 37.727786752547296 -122.45980797188601 (37.7277867525473, -122.459807971886)
57244 126010 2 99 85 Toledo Way 2 1 1 1     10 Width 3ft   6001465.00623 2119940.72568 37.801034867711 -122.43908870440599 (37.801034867711, -122.439088704406)
57805 206027 2 99 804 Faxon Ave 2 2 1 1     10 Width 10ft   5994921.23721 2093409.63408 37.7278128652723 -122.459809914392 (37.7278128652723, -122.459809914392)
58330 206036 2 99 280 Brighton Ave 1 1 1 1     10 Width 3ft   5996259.37903 2091732.03952 37.7232834540474 -122.455062785437 (37.7232834540474, -122.455062785437)
70642 206037 2 99 280 Brighton Ave 2 1 1 1     10 Width 3ft   5996260.563569999 2091771.26312 37.72339122070879 -122.45506152367201 (37.7233912207088, -122.455061523672)
72634 225193 2 99 2973 23rd St 1 1 1 1     10 Width 3ft   6009010.89225 2102726.9922700003 37.7541965009837 -122.41175959345 (37.7541965009837, -122.41175959345)
106572 225189 2 99 500 Capp St 3 1 1 1     10 Width 3ft   6007250.88683 2103937.06131 37.757420182006605 -122.41793191673901 (37.7574201820066, -122.417931916739)
134896 120285 2 99 151 24th Ave 1 2 1 1     10     5988326.80885 2115016.043 37.7867567842415 -122.484190580999 (37.7867567842415, -122.484190580999)
146819 225192 2 99 500 Capp St 6 1 1 1     10 Width 3ft   6007260.94104 2103859.736 37.757208430341294 -122.41789166399299 (37.7572084303413, -122.417891663993)
148481 225146 2 99 1706 Dolores St 3 2 1 1     10 Width 6ft   6005275.161069999 2098395.65522 37.7420933673216 -122.424370639893 (37.7420933673216, -122.424370639893)
157715 225155 2 99 104 Franconia St 2 1 1 1     10 Width 2ft   6010008.90641 2099846.42229 37.7463430291237 -122.40810505891199 (37.7463430291237, -122.408105058912)
162917 206039 2 99 280 Brighton Ave 4 1 1 1     10 Width 3ft   5996261.11762 2091797.78089 37.723464064001895 -122.455061523695 (37.7234640640019, -122.455061523695)
165711 225191 2 99 500 Capp St 5 1 1 1     10 Width 3ft   6007257.73573 2103878.07853 37.7572586143179 -122.41790404944099 (37.7572586143179, -122.417904049441)
173741 206038 2 99 280 Brighton Ave 3 1 1 1     10 Width 3ft   5996260.86716 2091785.79325 37.72343113441671 -122.45506152366998 (37.7234311344167, -122.45506152367)
176830 225187 2 99 500 Capp St 1 1 1 1     10 Width 3ft   6007244.27543 2104007.62921 37.7576135731224 -122.417959784028 (37.7576135731224, -122.417959784028)
181288 225164 2 99 2861 16th St 1 1 1 1     10 Width 3ft   6007651.46889 2106744.64503 37.7651516941295 -122.416745437549 (37.7651516941295, -122.416745437549)
182331 225163 2 99 2859 16th St 1 1 1 1     10 Width 3ft   6007679.26286 2106746.83875 37.7651592807999 -122.416649460099 (37.7651592807999, -122.416649460099)
183926 225156 2 99 104 Franconia St 3 1 1 1     10 Width 2ft   6010015.03813 2099834.46528 37.746310541115896 -122.408083012937 (37.7463105411159, -122.408083012937)
Powered by Datasette · Query took 3.548ms · Data source: data.sfgov.org