sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
19459 15076 3 75 1 Minerva St 2 11 1 2     6 11   5995952.59829 2089005.6317099999 37.7157797770894 -122.455926258705 (37.7157797770894, -122.455926258705)
21404 15067 3 75 1 Minerva St 9 11 1 2     3 11   5996019.74584 2089003.9616 37.7157790450506 -122.455694046564 (37.7157790450506, -122.455694046564)
111961 1 3 3 10 10th Ave 1 11 1 2     3 16   5992719.40718 2114869.71245 37.7866097734767 -122.46898271049601 (37.7866097734767, -122.468982710496)
17205 26909 3 39 10 Caine Ave 5 11 1 2     18 10   5997629.54091 2089680.9775599998 37.71773022584279 -122.45017865014299 (37.7177302258428, -122.450178650143)
17237 26912 3 39 10 Caine Ave 8 11 1 2     50 10   5997598.31865 2089637.50605 37.7176090763688 -122.450283439137 (37.7176090763688, -122.450283439137)
19068 26911 3 103 10 Caine Ave 7 11 1 2     18 10   5997609.86555 2089654.4499099997 37.7176562610968 -122.450244747607 (37.7176562610968, -122.450244747607)
19083 26913 3 39 10 Caine Ave 9 11 1 2     24 10   5997584.35365 2089616.43233 37.717550413599795 -122.45033019131 (37.7175504135998, -122.45033019131)
19195 26910 3 39 10 Caine Ave 6 11 1 2     12 10   5997620.43146 2089669.0920400003 37.7176970696553 -122.45020928103399 (37.7176970696553, -122.450209281034)
19203 26914 3 224 10 Caine Ave 10 11 1 2     12 10   5997577.15723 2089606.82913 37.7175236335794 -122.45035437405599 (37.7175236335794, -122.450354374056)
19342 26905 3 39 10 Caine Ave 1 11 1 2     12 10   5997683.40035 2089758.8108400002 37.7179470200262 -122.449998089654 (37.7179470200262, -122.449998089654)
19833 26915 3 180 10 Caine Ave 11 11 1 2   01/26/1999 12:00:00 AM 3 10   5997570.4467 2089598.1443599998 37.7174994031582 -122.450376943463 (37.7174994031582, -122.450376943463)
20603 26906 3 39 10 Caine Ave 2 11 1 2     24 10   5997668.873459999 2089736.17467 37.717884035095295 -122.450046671911 (37.7178840350953, -122.450046671911)
21305 26908 3 39 10 Caine Ave 4 11 1 2     18 10   5997639.65043 2089696.09364 37.7177723096208 -122.45014479517 (37.7177723096208, -122.45014479517)
21645 26907 3 39 10 Caine Ave 3 11 1 2     18 10   5997653.71656 2089718.57825 37.717834852078205 -122.45009779478701 (37.7178348520782, -122.450097794787)
17252 24963 3 100 100 Dolores St 4 11 1 2     90 20   6004800.736959999 2107633.50365 37.7674315357679 -122.42666873508999 (37.7674315357679, -122.42666873509)
19333 24968 3 100 100 Dolores St 9 11 1 2     90 20   6004810.58196 2107534.1310400004 37.767159239034704 -122.426627605497 (37.7671592390347, -122.426627605497)
19334 24962 3 100 100 Dolores St 3 11 1 2   04/21/2005 12:00:00 AM 30 20   6004805.8872 2107667.07109 37.76752399506629 -122.42665331171999 (37.7675239950663, -122.42665331172)
19826 24965 3 100 100 Dolores St 6 11 1 2     90 20   6004804.04595 2107595.6918 37.767327900586 -122.42665459683799 (37.767327900586, -122.426654596838)
20452 24966 3 100 100 Dolores St 7 11 1 2     90 20   6004812.73188 2107584.41194 37.76729741985871 -122.426623750096 (37.7672974198587, -122.426623750096)
22009 24961 3 100 100 Dolores St 1 11 1 2   04/21/2005 12:00:00 AM 90 20   6004800.95891 2107734.51921 37.76770891277079 -122.42667516163999 (37.7677089127708, -122.42667516164)
84722 8291 3 3 100 Garcia Ave 1 11 1 2     6 8   5995006.6013281 2099280.197711 37.743936899881 -122.45993989851101 (37.743936899881, -122.459939898511)
87594 8293 3 3 100 Garcia Ave 3 11 1 2     24 8   5995006.6013281 2099280.197711 37.743936899881 -122.45993989851101 (37.743936899881, -122.459939898511)
95088 8292 3 3 100 Garcia Ave 2 11 1 2     18 8   5995006.6013281 2099280.197711 37.743936899881 -122.45993989851101 (37.743936899881, -122.459939898511)
117295 8294 3 3 100 Garcia Ave 4 11 1 2     24 8   5995006.6013281 2099280.197711 37.743936899881 -122.45993989851101 (37.743936899881, -122.459939898511)
128632 8295 3 3 100 Garcia Ave 5 11 1 2     24 8   5995006.6013281 2099280.197711 37.743936899881 -122.45993989851101 (37.743936899881, -122.459939898511)
9933 11201 3 241 100 Idora Ave 4 11 1 2     3 8   5995318.65927 2099418.1217 37.7443335470614 -122.458870864793 (37.7443335470614, -122.458870864793)
18799 11188 3 35 100 Idora Ave 1 11 1 2     24 8   5995291.088769999 2099424.10153 37.7443483813689 -122.45896663000299 (37.7443483813689, -122.458966630003)
18983 11186 3 35 100 Idora Ave 2 11 1 2     18 8   5995298.39303 2099423.25523 37.7443464775133 -122.458941312315 (37.7443464775133, -122.458941312315)
20854 11187 3 5 100 Idora Ave 3 11 1 2     12 8   5995309.2253 2099420.08132 37.7443383854121 -122.458903627104 (37.7443383854121, -122.458903627104)
21814 11202 3 306 100 Idora Ave 5 11 1 2     3 8   5995328.17404 2099416.28223 37.744329043248 -122.458837831796 (37.744329043248, -122.458837831796)
9748 173655 3 78 100 Lawton St 1 11 1 10                    
81526 103927 3 100 100 The Embarcadero 13 11 1 2   02/05/2001 12:00:00 AM   4x4   6014859.0 2117030.0 37.793795709183996 -122.392535650186 (37.793795709184, -122.392535650186)
129305 3752 3 158 1000 Carolina St 1 11 1 2     12 18   6012438.0377853 2103297.9664682 37.755955933673 -122.399947693157 (37.755955933673, -122.399947693157)
17834 16381 3 3 1000 Moraga St 3 11 1 2     24 12   5991038.119519999 2103837.44782 37.7562208847883 -122.47399428791799 (37.7562208847883, -122.473994287918)
23251 16380 3 331 1000 Moraga St 2 11 1 2     8 12   5991061.65482 2103836.24058 37.7562189332688 -122.47391280754499 (37.7562189332688, -122.473912807545)
1529 251578 3 62 1000X Columbus Ave 6 11 1 2                    
1851 4718 3 62 1000X Columbus Ave 5 11 1 2     80 3   6008205.1504 2120957.4944 37.804207866952204 -122.415836885075 (37.8042078669522, -122.415836885075)
5299 4716 3 62 1000X Columbus Ave 3 11 1 2     70 3   6008306.8566 2120868.0824 37.803968081269204 -122.415478587922 (37.8039680812692, -122.415478587922)
6099 4714 3 62 1000X Columbus Ave 1 11 1 2     80 3   6008373.9156 2120808.2881 37.8038076701269 -122.415242289828 (37.8038076701269, -122.415242289828)
6383 4717 3 62 1000X Columbus Ave 4 11 1 2   08/19/2006 12:00:00 AM 6 3   6008242.0329 2120925.0825 37.804120945419 -122.415706953629 (37.804120945419, -122.415706953629)
8454 4715 3 62 1000X Columbus Ave 2 11 1 2   08/19/2006 12:00:00 AM 6 3   6008330.3273 2120843.4941 37.803901887177204 -122.415395624015 (37.8039018871772, -122.415395624015)
124851 4719 3 62 1000X Columbus Ave 6 11 1 2     70 3   6008486.129587 2120728.7244 37.803595514004 -122.41484833114401 (37.803595514004, -122.414848331144)
17056 25058 3 100 1000X Dolores St 1 11 1 2     90 20   6005092.48697 2102458.1018 37.753237594341996 -122.425291287561 (37.753237594342, -122.425291287561)
17162 25069 3 75 1000X Dolores St 12 11 1 2     90 20   6005114.64614 2102050.12648 37.752118640770995 -122.42518562892599 (37.752118640771, -122.425185628926)
17262 25065 3 75 1000X Dolores St 8 11 1 2     40 20   6005108.04672 2102186.2977 37.7524921625065 -122.42521813940901 (37.7524921625065, -122.425218139409)
17722 25061 3 100 1000X Dolores St 4 11 1 2     90 20   6005097.79962 2102345.06954 37.7529275341834 -122.425264872687 (37.7529275341834, -122.425264872687)
17966 25063 3 75 1000X Dolores St 6 11 1 2     90 20   6005101.20924 2102268.05958 37.7527162753581 -122.42524760211501 (37.7527162753581, -122.425247602115)
18277 25059 3 75 1000X Dolores St 2 11 1 2     40 20   6005094.91106 2102418.8508099997 37.7531299572042 -122.425280111693 (37.7531299572042, -122.425280111693)
18812 25066 3 75 1000X Dolores St 9 11 1 2     90 20   6005105.419480001 2102158.55982 37.7524158523077 -122.425225251269 (37.7524158523077, -122.425225251269)
20631 25060 3 75 1000X Dolores St 3 11 1 2     40 20   6005096.113419999 2102391.61943 37.7530552540956 -122.425274016077 (37.7530552540956, -122.425274016077)
21757 25064 3 100 1000X Dolores St 7 11 1 2     40 20   6005102.4225699995 2102227.07793 37.7526038178156 -122.425240490271 (37.7526038178156, -122.425240490271)
22227 25067 3 100 1000X Dolores St 10 11 1 2     40 20   6005110.57075 2102123.34784 37.7523194593995 -122.425204931964 (37.7523194593995, -122.425204931964)
18919 110775 3 109 1000X GUERRERO ST 4 11 1 2   05/26/2015 02:57:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
80233 110778 3 109 1000X GUERRERO ST 7 11 1 2   05/26/2015 02:43:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
80584 110774 3 109 1000X GUERRERO ST 3 11 1 2   05/26/2015 03:02:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
82047 110777 3 109 1000X GUERRERO ST 6 11 1 2   05/26/2015 02:47:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
93547 110779 3 109 1000X GUERRERO ST 8 11 1 2   05/26/2015 02:35:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
97980 110776 3 109 1000X GUERRERO ST 5 11 1 2   05/26/2015 02:53:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
102576 110781 3 109 1000X GUERRERO ST 10 11 1 2   05/26/2015 02:26:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
114885 110772 3 109 1000X GUERRERO ST 1 11 1 2   05/26/2015 03:10:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
121580 110782 3 109 1000X GUERRERO ST 11 11 1 2   05/26/2015 02:21:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
124792 110780 3 109 1000X GUERRERO ST 9 11 1 2   05/26/2015 02:30:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
139744 110783 3 109 1000X GUERRERO ST 12 11 1 2   05/26/2015 02:16:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
141015 110784 3 109 1000X GUERRERO ST 13 11 1 2   05/26/2015 02:11:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
144929 110773 3 109 1000X GUERRERO ST 2 11 1 2   05/26/2015 03:06:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
113490 114590 3 3 1000X MORAGA ST 2 11 1 2     30 12   5991075.0 2103884.0 37.7563508410106 -122.47387013998001 (37.7563508410106, -122.47387013998)
17715 16378 3 60 1000X Moraga St 1 11 1 2     18 12   5991088.16435 2103840.65792 37.756232597572605 -122.473821451692 (37.7562325975726, -122.473821451692)
80270 29312 3 11 1000X Portola Dr 15 11 1 2   10/27/2016 01:16:00 PM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
81096 29303 3 11 1000X Portola Dr 6 11 1 2   08/23/2014 12:00:00 AM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
87052 29305 3 11 1000X Portola Dr 8 11 1 2   10/14/2005 12:00:00 AM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
91761 29302 3 11 1000X Portola Dr 5 11 1 2   10/14/2005 12:00:00 AM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
95836 29310 3 11 1000X Portola Dr 13 11 1 2   10/14/2005 12:00:00 AM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
100870 29309 3 11 1000X Portola Dr 12 11 1 2   02/25/2014 12:00:00 AM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
108929 29308 3 11 1000X Portola Dr 11 11 1 2   10/14/2005 12:00:00 AM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
110045 29301 3 11 1000X Portola Dr 4 11 1 2   10/14/2005 12:00:00 AM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
112838 29307 3 11 1000X Portola Dr 10 11 1 2   10/14/2005 12:00:00 AM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
117140 29298 3 11 1000X Portola Dr 1 11 1 2   10/27/2016 01:33:00 PM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
119457 29300 3 11 1000X Portola Dr 3 11 1 2   10/14/2005 12:00:00 AM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
139242 29304 3 11 1000X Portola Dr 7 11 1 2   08/23/2014 12:00:00 AM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
139984 29306 3 11 1000X Portola Dr 9 11 1 2   10/27/2016 01:19:00 PM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
140081 29311 3 11 1000X Portola Dr 14 11 1 2   09/03/2014 12:00:00 AM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
146106 29299 3 11 1000X Portola Dr 2 11 1 2   10/27/2016 01:24:00 PM 3 3X3   5995989.04111 2098439.8270093002 37.74168590277029 -122.456482111076 (37.7416859027703, -122.456482111076)
83861 19426 3 267 1000X Sloat Blvd 3 11 1 2     6 20   5988569.2838063 2095968.4634055 37.7344714144349 -122.481955851921 (37.7344714144349, -122.481955851921)
104159 19424 3 267 1000X Sloat Blvd 1 11 1 2     24 20   5988569.2838063 2095968.4634055 37.7344714144349 -122.481955851921 (37.7344714144349, -122.481955851921)
122200 19427 3 267 1000X Sloat Blvd 4 11 1 2     6 20   5988569.2838063 2095968.4634055 37.7344714144349 -122.481955851921 (37.7344714144349, -122.481955851921)
122760 19425 3 267 1000X Sloat Blvd 2 11 1 2     6 20   5988569.2838063 2095968.4634055 37.7344714144349 -122.481955851921 (37.7344714144349, -122.481955851921)
115847 23311 3 11 1000X Van Ness Ave 2 11 1 1   11/18/2010 12:00:00 AM 6 3X3   6006537.8278087005 2113902.4302931 37.7847425526754 -122.421105541385 (37.7847425526754, -122.421105541385)
127717 23312 3 11 1000X Van Ness Ave 3 11 1 2   11/18/2010 12:00:00 AM 6 3X3   6006537.8278087005 2113902.4302931 37.7847425526754 -122.421105541385 (37.7847425526754, -122.421105541385)
53388 137760 3 6 1000x DIVISADERO ST 6 11 1 2     3 Width 0ft   6001423.7559 2112018.8276 37.7792810387103 -122.438663489904 (37.7792810387103, -122.438663489904)
63089 137761 3 6 1000x DIVISADERO ST 1 11 1 2     3 Width 0ft   6001442.3691 2111886.1663 37.7789178432038 -122.43858959128299 (37.7789178432038, -122.438589591283)
67396 137764 3 6 1000x DIVISADERO ST 4 11 1 2     3 Width 0ft   6001436.616 2111937.2679 37.7790578279952 -122.438613156035 (37.7790578279952, -122.438613156035)
138085 137763 3 6 1000x DIVISADERO ST 3 11 1 2     3 Width 0ft   6001437.9696 2111922.039 37.77901609029121 -122.438607381917 (37.7790160902912, -122.438607381917)
154554 137759 3 6 1000x DIVISADERO ST 5 11 1 2     3 Width 0ft   6001427.817000001 2112000.5528 37.7792310917629 -122.438648131089 (37.7792310917629, -122.438648131089)
165225 137749 3 6 1000x DIVISADERO ST 8 11 1 2     3 Width 0ft   6001417.6643 2112072.2982 37.7794275088949 -122.438688395719 (37.7794275088949, -122.438688395719)
172170 137762 3 6 1000x DIVISADERO ST 2 11 1 2     3 Width 0ft   6001439.6617 2111903.7642 37.7789660085719 -122.438600218498 (37.7789660085719, -122.438600218498)
179995 137750 3 6 1000x DIVISADERO ST 7 11 1 2     3 Width 0ft   6001422.0638 2112046.2398 37.779356209408995 -122.43867130831 (37.779356209409, -122.43867130831)
34286 221545 3 109 1000x Guerrero St 1 11 1 2     2 Width 3ft   6005721.87722 2103062.7074700003 37.754933239094704 -122.423157698184 (37.7549332390947, -122.423157698184)
67326 221557 3 109 1000x Guerrero St 15 11 1 2     3 Width 3ft   6005743.02813 2102638.73526 37.7537703032837 -122.42305441913099 (37.7537703032837, -122.423054419131)
68227 221553 3 109 1000x Guerrero St 11 11 1 2     3 Width 3ft   6005734.111409999 2102791.4847 37.7541892146839 -122.42309611170799 (37.7541892146839, -122.423096111708)
76663 221554 3 109 1000x Guerrero St 12 11 1 2     4 Width 3ft   6005736.5559 2102753.56312 37.754085228758505 -122.423084962814 (37.7540852287585, -122.423084962814)
76927 221546 3 109 1000x Guerrero St 2 11 1 2     3 Width 3ft   6005723.96055 2103030.09242 37.7548438033068 -122.423148175257 (37.7548438033068, -122.423148175257)
Powered by Datasette · Query took 69.895ms · Data source: data.sfgov.org