sf-trees

Data source: data.sfgov.org

Custom SQL query returning 19 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
163945 206035 3 99 700x Monterey Blvd 18 11 1 2     6 Width 4ft   5996866.22235 2094722.0274099999 37.7315280455795 -122.453180800271 (37.7315280455795, -122.453180800271)
19998 30014 3 99 738X San Jose Ave 6 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005753.20487 2098967.8779700003 37.7436915444264 -122.422758369527 (37.7436915444264, -122.422758369527)
21577 30015 3 99 738X San Jose Ave 7 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005757.33905 2098980.75435 37.7437271333024 -122.422744989392 (37.7437271333024, -122.422744989392)
45931 190000 2 99 770 De Haro St 1 9 1 1     3 Width 3ft   6012104.84568 2104756.14819 37.7599411975544 -122.401202450128 (37.7599411975544, -122.401202450128)
52213 190002 2 99 790 De Haro St 2 9 1 1     16     6012104.02513 2104748.44893 37.759920011313206 -122.401204746997 (37.7599200113132, -122.401204746997)
171539 190001 2 99 790 De Haro St 1 9 1 1     9     6012095.84153 2104748.83564 37.759920616576 -122.401233077439 (37.759920616576, -122.401233077439)
17649 30005 3 99 795X San Jose Ave 1 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005615.08127 2098546.14287 37.7425257613504 -122.423205996259 (37.7425257613504, -122.423205996259)
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)
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)
54105 206046 2 99 82 Ventura Ave 3 2 1 1     5 Width 3ft   5994334.26497 2101814.09479 37.750855650885605 -122.462448420067 (37.7508556508856, -122.462448420067)
149483 225211 2 99 83 Tiffany Ave 1 1 1 1     17 Width 4ft   6006284.028469999 2099592.34977 37.74543613838021 -122.42096723475402 (37.7454361383802, -122.420967234754)
25803 225170 2 99 84 Putnam St 1 1 1 1     13 Width 3ft   6009137.3737 2096981.67824 37.7384282324737 -122.410916429557 (37.7384282324737, -122.410916429557)
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)
37075 225178 2 99 858 Shotwell St 2 1 1 1     7 Width 3ft   6007945.63288 2102930.5151400003 37.754695511392605 -122.41545794294301 (37.7546955113926, -122.415457942943)
170506 225177 2 99 858 Shotwell St 1 1 1 1     8 Width 3ft   6007943.221609999 2102943.9382 37.754732232531794 -122.41546723204901 (37.7547322325318, -122.415467232049)
40599 190014 2 99 888 07th St 9 1 1 1     29 Width 8ft   6012452.605140001 2108628.1137900003 37.770592145536 -122.400271663513 (37.770592145536, -122.400271663513)
177844 190013 2 99 888 07th St 1 1 1 1     27 Width 8ft   6012319.46536 2108768.17498 37.7709692969125 -122.40074203953002 (37.7709692969125, -122.40074203953)
31524 175845 2 99 98 Newton St 2 9 1 1     23 Width 10ft   6000912.9484 2087984.8955700002 37.7132605143345 -122.43870794134399 (37.7132605143345, -122.438707941344)
49570 225173 2 99 98 Santa Marina St 2 1 1 1     9 Width 3ft   6006194.79816 2097580.2396 37.7399063069243 -122.42113293303998 (37.7399063069243, -122.42113293304)
Powered by Datasette · Query took 3.963ms · Data source: data.sfgov.org