sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
22823 251110 9 100 1700X Quesada Ave 5 3 1 2                    
22824 251112 9 100 1700X Quesada Ave 14 22 1 2                    
22825 251109 9 100 1700X Quesada Ave 3 3 1 2                    
22828 251115 9 100 1700X Quesada Ave 19 3 1 2                    
22831 251116 9 100 1700X Quesada Ave 20 3 1 2                    
22832 251108 9 100 1700X Quesada Ave 2 3 1 2                    
22833 251113 9 100 1700X Quesada Ave 15 3 1 2                    
22838 251111 9 100 1700X Quesada Ave 7 3 1 2                    
22839 251114 9 100 1700X Quesada Ave 16 3 1 2                    
24494 233935 3 100 150x Dolores St 9 3 1 2     30     6004826.52958 2107279.95522 37.766462234780604 -122.426554344032 (37.7664622347806, -122.426554344032)
27134 194292 3 100 1700x Quesada Ave 43 3 1 2     38     6014354.24031 2095291.86255 37.734079495961396 -122.392760714642 (37.7340794959614, -122.392760714642)
27355 234354 3 100 650x Dolores St 1 3 1 2     23     6004979.813630001 2104508.3497200003 37.7588607286626 -122.425826859935 (37.7588607286626, -122.425826859935)
27594 194293 3 100 1700x Quesada Ave 46 3 1 2     28     6014318.796490001 2095319.19207 37.7341525685742 -122.392885167337 (37.7341525685742, -122.392885167337)
30108 210927 2 100 234 Joost Ave 1 9 1 1     35     6000492.41263 2094973.31916 37.732425199355 -122.44066241093701 (37.732425199355, -122.440662410937)
31219 194283 2 100 2 Tulare St 1 7 1 1     44     6016255.79944 2100318.37917 37.747986718206604 -122.386536741486 (37.7479867182066, -122.386536741486)
33156 234362 3 100 1150x Dolores St 4 3 1 2     25     6005144.45634 2101528.47617 37.7506879938715 -122.425045428228 (37.7506879938715, -122.425045428228)
33897 132069 2 100 45 Havens St 3 9 1 1     29     6007646.13343 2119391.20002 37.7998757746973 -122.417660327771 (37.7998757746973, -122.417660327771)
34789 119450 2 100 800 33rd Ave 1 9 1 1     32     5985749.05602 2110390.9661 37.7739072286205 -122.49276808877701 (37.7739072286205, -122.492768088777)
35273 233937 3 100 230x Dolores St 3 3 1 2     32     6004843.94175 2106947.59382 37.7655506342911 -122.42647045077801 (37.7655506342911, -122.426470450778)
35608 194288 9 100 1700x Quesada Ave 37 3 1 2     34     6014411.93404 2095259.01392 37.733992504551296 -122.392558950849 (37.7339925045513, -122.392558950849)
35928 194284 3 100 1700x Quesada Ave 20 3 1 2     31     6014504.15008 2095180.2076400002 37.733781239407 -122.392234619349 (37.733781239407, -122.392234619349)
37148 96681 1 100 375@32nd Ave 32nd Ave 3 5 1 1   06/28/2011 12:00:00 AM 25   Permit Number 768040 5985880.88078 2113443.18167 37.7822954478301 -122.49253691723301 (37.7822954478301, -122.492536917233)
38595 234356 3 100 650x Dolores St 3 3 1 2     22     6004985.9304599995 2104422.99085 37.7586266989802 -122.42579962935301 (37.7586266989802, -122.425799629353)
39519 118599 2 100 249 Point Lobos Ave 4 17 1 1     35     5981986.20635 2112598.8818200002 37.7797487653148 -122.50594791191901 (37.7797487653148, -122.505947911919)
39528 194389 2 100 1031 Key Ave 4 2 1 1     36     6013123.75243 2089902.89375 37.7192140640518 -122.396637279208 (37.7192140640518, -122.396637279208)
39870 194287 9 100 1700x Quesada Ave 32 3 1 2     31     6014435.322380001 2095233.3766599998 37.733923408722795 -122.392476296866 (37.7339234087228, -122.392476296866)
41120 233936 3 100 230x Dolores St 2 3 1 2     34     6004841.8872 2106976.70647 37.7656304545194 -122.42647963012699 (37.7656304545194, -122.426479630127)
42394 201687 2 100 401 08th St 23 7 1 1     23     6010195.30306 2109846.89146 37.7738124981919 -122.408165701983 (37.7738124981919, -122.408165701983)
42834 194390 2 100 1031 Key Ave 5 2 1 1     29     6013152.66051 2089880.8718700001 37.719155205216104 -122.396535811395 (37.7191552052161, -122.396535811395)
44570 27941 1 100 699 The Embarcadero 2 11 1 9   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.801444644335106 -122.399901749617 (37.8014446443351, -122.399901749617)
46040 187495 2 100 100 Walbridge St 1 7 1 1     8     6005184.36761 2086469.76682 37.709342367834395 -122.423836763664 (37.7093423678344, -122.423836763664)
47477 234367 3 100 1650x Dolores St 5 3 1 2     44     6005309.50054 2098532.58451 37.7424712831236 -122.424261641173 (37.7424712831236, -122.424261641173)
47741 194278 2 100 1750 22nd St 7 17 1 1     5     6012817.610719999 2103799.38432 37.7573538722899 -122.398670182286 (37.7573538722899, -122.398670182286)
47801 234359 3 100 1000x Dolores St 13 3 1 2     31     6005116.63925 2102018.48994 37.752031886768705 -122.42517648553302 (37.7520318867687, -122.425176485533)
47964 234371 3 100 1750x Dolores St 5 3 1 2     35     6005338.50183 2098008.71997 37.7410345073494 -122.42412411595 (37.7410345073494, -122.42412411595)
48345 194388 2 100 1031 Key Ave 3 2 1 1     40     6013107.94825 2089911.6587099999 37.7192372512804 -122.39669252276501 (37.7192372512804, -122.396692522765)
48420 187504 2 100 100 Walbridge St 10 7 1 1     9     6005101.69485 2086503.71935 37.7094309267755 -122.424124907354 (37.7094309267755, -122.424124907354)
48507 118600 2 100 249 Point Lobos Ave 2 17 1 1     37     5981958.17368 2112601.6345 37.779754673268705 -122.506045091658 (37.7797546732687, -122.506045091658)
48989 233929 2 100 8 Octavia St 2 2 1 1     31     6005769.81739 2109368.12443 37.77224912933389 -122.42344014465901 (37.7722491293339, -122.423440144659)
49252 233940 3 100 270x Dolores St 2 3 1 2     27     6004851.53435 2106800.76384 37.7651479034782 -122.426433734123 (37.7651479034782, -122.426433734123)
53743 118598 2 100 249 Point Lobos Ave 8 17 1 1     35     5982022.838269999 2112594.06181 37.7797376871414 -122.50582083083799 (37.7797376871414, -122.505820830838)
54301 194281 2 100 2 Tulare St 11 7 1 1     38     6016211.24922 2100302.5214299997 37.7479407097974 -122.38668969007601 (37.7479407097974, -122.386689690076)
54350 194294 3 100 1700x Quesada Ave 49 3 1 2     27     6014297.19865 2095334.47415 37.7341933303645 -122.392960907318 (37.7341933303645, -122.392960907318)
54354 194291 9 100 1700x Quesada Ave 41 3 1 2     38     6014364.32912 2095287.3135099998 37.7340675655682 -122.39272551607701 (37.7340675655682, -122.392725516077)
54411 234398 2 100 3980 22nd St 8 4 1 1     32     6001905.073469999 2102956.38941 37.7544251823875 -122.436349651817 (37.7544251823875, -122.436349651817)
58702 194289 9 100 1700x Quesada Ave 38 3 1 2     48     6014396.14271 2095264.76436 37.734007417094 -122.39261394888901 (37.734007417094, -122.392613948889)
59423 194280 2 100 2 Tulare St 18 7 1 1     3     6016126.44291 2100241.55687 37.747768618243605 -122.38697869801202 (37.7477686182436, -122.386978698012)
59904 187497 2 100 100 Walbridge St 3 7 1 1     6     6005151.09396 2086478.68565 37.7093649785846 -122.42395239669399 (37.7093649785846, -122.423952396694)
61697 28231 3 100 399X King St 14 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
63890 234360 3 100 1150x Dolores St 2 3 1 2     21     6005142.56045 2101579.1271 37.7508269625113 -122.425055587855 (37.7508269625113, -122.425055587855)
68375 234369 3 100 1750x Dolores St 3 3 1 2     18     6005339.90624 2098058.76544 37.7411720001789 -122.42412281821899 (37.7411720001789, -122.424122818219)
68513 210928 2 100 617 Mangels Ave 2 9 1 1     37     5997342.33131 2095240.63361 37.732979290542104 -122.451572201795 (37.7329792905421, -122.451572201795)
69742 210912 2 100 443 Gennessee St 2 9 1 1     33     5997433.76219 2094954.34243 37.732198438902294 -122.451235463255 (37.7321984389023, -122.451235463255)
70141 194290 3 100 1700x Quesada Ave 40 3 1 2     27     6014381.3022300005 2095272.57767 37.7340280466394 -122.39266580380101 (37.7340280466394, -122.392665803801)
71379 234345 3 100 1350x Dolores St 6 3 1 2     34     6005211.50018 2100294.54181 37.7473036813364 -122.424725813644 (37.7473036813364, -122.424725813644)
71756 233939 3 100 270x Dolores St 1 3 1 2     32     6004850.2917 2106826.33652 37.765218049699605 -122.426439853137 (37.7652180496996, -122.426439853137)
72308 233934 3 100 150x Dolores St 7 3 1 2     34     6004824.15396 2107326.99928 37.7665912721916 -122.42656591108101 (37.7665912721916, -122.426565911081)
73360 233933 3 100 150x Dolores St 3 3 1 2     35     6004817.19467 2107404.1110799997 37.76680260927 -122.426595473608 (37.76680260927, -122.426595473608)
73838 28232 3 100 399X King St 15 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
76008 201682 2 100 401 08th St 18 7 1 1     25     6010248.09063 2109749.24504 37.773547339368704 -122.40797621303899 (37.7735473393687, -122.407976213039)
77513 27958 1 100 307X The Embarcadero 2 11 1 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
78635 60467 1 100 152 MAJESTIC AVE 1 1 1 1   11/24/1982 12:00:00 AM     Permit Number 20060 5996883.0 2089135.0 37.716188348676894 -122.45271971026699 (37.7161883486769, -122.452719710267)
79238 28220 3 100 399X King St 3 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
79708 27959 1 100 307X The Embarcadero 3 11 1 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
79855 28229 3 100 399X King St 12 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
80037 86731 1 100 2 Pico Ave   8 1 1         Permit Number 49705 5994102.9 2092171.9 37.724367252780496 -122.462549157922 (37.7243672527805, -122.462549157922)
81194 28236 3 100 399X King St 19 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
81864 28226 3 100 399X King St 9 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
82090 27775 1 100 299X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
83893 110583 6 100 46 COOK ST 5 1 1 1     36     5997534.0 2113434.0 37.782944683725 -122.45222184269899 (37.782944683725, -122.452221842699)
87101 96694 1 100 3132@32nd Ave Clement St 16 5 1 1   06/28/2011 12:00:00 AM     Permit Number 768040 5985890.0 2113240.0 37.7817381026149 -122.49249040156602 (37.7817381026149, -122.492490401566)
87650 27777 1 100 299X The Embarcadero 5 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
89467 28227 3 100 399X King St 10 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
90111 27847 1 100 280 The Embarcadero 8 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
91142 28372 1 100 199X The Embarcadero 1 11 1 9     18     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
92133 27942 1 100 699 The Embarcadero 3 11 1 9   02/01/2001 12:00:00 AM 24     6012787.5534626 2119857.700218 37.801444644335106 -122.399901749617 (37.8014446443351, -122.399901749617)
92364 27782 1 100 399X The Embarcadero 5 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
92652 27780 1 100 399X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
93618 28237 3 100 399X King St 20 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
93856 27960 1 100 307X The Embarcadero 4 11 1 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
94540 106114 3 100 1752X DOLORES ST 1 3 1 2           6005197.0 2098194.1 37.741535528464496 -122.424626562024 (37.7415355284645, -122.424626562024)
96124 27767 1 100 299X The Embarcadero 1 11 1 9   12/10/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
99547 27845 1 100 280 The Embarcadero 6 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
100132 27778 1 100 299X The Embarcadero 6 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
100729 27843 1 100 280 The Embarcadero 4 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
101121 27717 1 100 307X The Embarcadero 1 11 1 9   09/11/2000 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
101242 27788 1 100 199X The Embarcadero 5 11 1 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
103442 96695 1 100 3132@32nd Ave Clement St 17 5 1 1   06/28/2011 12:00:00 AM     Permit Number 768040 5985890.0 2113240.0 37.7817381026149 -122.49249040156602 (37.7817381026149, -122.492490401566)
103796 28225 3 100 399X King St 8 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
105556 27842 1 100 280 The Embarcadero 3 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
105677 27827 1 100 280 The Embarcadero 1 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
106263 96692 1 100 3132@32nd Ave Clement St 14 5 1 1   06/28/2011 12:00:00 AM     Permit Number 768040 5985890.0 2113240.0 37.7817381026149 -122.49249040156602 (37.7817381026149, -122.492490401566)
107261 96693 1 100 3132@32nd Ave Clement St 15 5 1 1   06/28/2011 12:00:00 AM     Permit Number 768040 5985890.0 2113240.0 37.7817381026149 -122.49249040156602 (37.7817381026149, -122.492490401566)
107571 28235 3 100 399X King St 18 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
108524 28230 3 100 399X King St 13 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
110061 27844 1 100 280 The Embarcadero 5 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
111408 28223 3 100 399X King St 6 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
111571 27784 1 100 399X The Embarcadero 7 11 1 9   12/01/2000 12:00:00 AM 20     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
111889 28228 3 100 399X King St 11 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
112720 27781 1 100 399X The Embarcadero 4 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
115023 28238 3 100 399X King St 21 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
Powered by Datasette · Query took 9.921ms · Data source: data.sfgov.org