sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
115333 30525 2 82 96 McAllister St 2 1 1 1 1 11/19/2005 12:00:00 AM 10 3x3   6008672.39963745 2112539.12321188 37.7811193385199 -122.41362414398701 (37.7811193385199, -122.413624143987)
135080 69741 2 82 93 Delta St 1 1 1 1 1 08/03/2002 12:00:00 AM 5     6010157.175969999 2089735.57492 37.7185890892048 -122.40687987112601 (37.7185890892048, -122.406879871126)
47463 70412 2 82 1817 Silliman St 2 1 1 1 1 05/21/1994 12:00:00 AM 4     6005464.04095 2092680.05814 37.7264102753879 -122.423311341054 (37.7264102753879, -122.423311341054)
184861 70592 2 82 312 Athens St 1 1 1 1 1 08/06/1994 12:00:00 AM 4     6004234.1327 2091472.6068400003 37.7230253908821 -122.42747709790001 (37.7230253908821, -122.4274770979)
59413 70593 2 82 314 Athens St 2 1 1 1 1 08/06/1994 12:00:00 AM 10     6004216.40489 2091443.51048 37.722944495983 -122.427536307463 (37.722944495983, -122.427536307463)
88949 70620 2 82 1644 Washington St 2 1 1 1   08/13/1994 12:00:00 AM 12 3x3   6006824.13924708 2117065.21920464 37.793442925898105 -122.42033955937599 (37.7934429258981, -122.420339559376)
157725 70621 2 82 713 Excelsior Ave 1 1 1 1 1 08/06/1994 12:00:00 AM 6     6004140.669919999 2091658.5029099998 37.7235305337986 -122.427813419165 (37.7235305337986, -122.427813419165)
39309 70680 2 82 330 Utah St 2 1 1 1 1 09/17/1994 12:00:00 AM 10     6010584.43859 2106698.38492 37.7651892021367 -122.406597696229 (37.7651892021367, -122.406597696229)
186437 71320 2 82 326 Munich St 1 1 1 1 1 08/26/1995 12:00:00 AM 11     6004289.26563 2090538.0021799998 37.720462289783896 -122.42721997362601 (37.7204622897839, -122.427219973626)
172651 71391 2 82 1531 Kirkwood Ave 2 1 1 1 1 05/21/1988 12:00:00 AM 4     6015562.7322 2096452.7948 37.737334227876396 -122.388663558077 (37.7373342278764, -122.388663558077)
48741 71411 2 82 1556 Quesada Ave 1 1 1 1 1 01/22/1983 12:00:00 AM 5     6015495.2506 2094478.7004 37.7319100238031 -122.388759104128 (37.7319100238031, -122.388759104128)
179770 71586 2 82 121 Goethe St 1 1 1 1 1 09/30/1995 12:00:00 AM 9     5994945.16185 2086428.98532 37.7086470380903 -122.459221923276 (37.7086470380903, -122.459221923276)
136079 72127 2 82 2110 23rd St 2 1 1 1 1 08/25/1984 12:00:00 AM 10     6012120.035209999 2102839.43148 37.7546791626274 -122.401015240957 (37.7546791626274, -122.401015240957)
158757 72128 2 82 2012 23rd St 2 1 1 1 1 08/25/1984 12:00:00 AM 11     6012399.20292 2102851.6444 37.7547282656006 -122.400050655116 (37.7547282656006, -122.400050655116)
47148 72144 2 82 58 Meda Ave 1 1 1 1 1 07/27/1985 12:00:00 AM 5     6000049.527000001 2091859.62504 37.723850484693706 -122.441970156497 (37.7238504846937, -122.441970156497)
180005 72279 2 82 767 41st Ave 1 1 1 1 1 01/20/1996 12:00:00 AM 6     5983194.45467 2110583.80622 37.7742869998631 -122.501619002427 (37.7742869998631, -122.501619002427)
65322 73401 2 82 1733 Polk St 1 1 1 1 1 05/07/1994 12:00:00 AM 6     6006559.8799 2116866.9427 37.7928836135597 -122.421239831973 (37.7928836135597, -122.421239831973)
28339 73442 2 82 314 Athens St 1 1 1 1 1 08/06/1994 12:00:00 AM 8     6004223.020830001 2091452.87155 37.72297057362721 -122.42751410409402 (37.7229705736272, -122.427514104094)
92485 73448 2 82 1644 Washington St 1 1 1 1   08/13/1994 12:00:00 AM 12 3x3   6006824.13924708 2117065.21920464 37.793442925898105 -122.42033955937599 (37.7934429258981, -122.420339559376)
70530 73459 2 82 330 Utah St 1 1 1 1 1 09/17/1994 12:00:00 AM 15     6010582.5171300005 2106716.25151 37.765238152235206 -122.40660560128299 (37.7652381522352, -122.406605601283)
169270 73714 2 82 2110 23rd St 1 1 1 1 1 08/25/1984 12:00:00 AM 9     6012133.53509 2102840.64813 37.75468325634171 -122.400968639917 (37.7546832563417, -122.400968639917)
77012 73715 2 82 2012 23rd St 1 1 1 1 1 08/25/1984 12:00:00 AM 9     6012416.66148 2102853.00124 37.7547329645749 -122.399990373555 (37.7547329645749, -122.399990373555)
32871 74007 2 82 2030 23rd St 2 1 1 1 1 08/25/1984 12:00:00 AM 8     6012344.40813 2102849.33443 37.754718867688105 -122.40023998938999 (37.7547188676881, -122.40023998939)
65822 74096 2 82 1133 Athens St 1 1 1 1 1 01/29/1994 12:00:00 AM 10     6001902.78384 2087667.7277099998 37.712445903022704 -122.435264062185 (37.7124459030227, -122.435264062185)
168725 74150 2 82 740 Buchanan St 1 1 1 1 1 03/18/1995 12:00:00 AM 8     6004499.396000001 2111088.6935 37.776901605564206 -122.427957272174 (37.7769016055642, -122.427957272174)
186653 75060 2 82 390x Utah St 1 1 1 1 1 09/17/1994 12:00:00 AM 7     6010594.46043 2106517.2504 37.76469240853879 -122.406550267789 (37.7646924085388, -122.406550267789)
60538 75145 2 82 376 Utah St 4 1 1 1 1 09/17/1994 12:00:00 AM 1     6010592.19708 2106537.02068 37.76474656661821 -122.406559489431 (37.7647465666182, -122.406559489431)
25838 75303 2 82 376 Utah St 2 1 1 1 1 09/17/1994 12:00:00 AM 1     6010591.15079 2106579.14528 37.7648621726769 -122.40656607695699 (37.7648621726769, -122.406566076957)
39170 75389 2 82 376 Utah St 1 1 1 1 1 09/17/1994 12:00:00 AM 1     6010589.86723 2106590.9300700002 37.7648944592258 -122.40657134700199 (37.7648944592258, -122.406571347002)
53492 75980 2 82 6555 Geary Blvd 2 1 1 1 1 06/03/1989 12:00:00 AM 3     5986643.29892 2112486.62546 37.7797135654944 -122.48982895296699 (37.7797135654944, -122.489828952967)
181073 78383 2 82 1490 Quesada Ave 1 1 1 1 1 02/14/2004 12:00:00 AM 5     6015869.5519 2094203.8416 37.7311760546893 -122.387445886397 (37.7311760546893, -122.387445886397)
1366 81793 2 82 435 Hayes St 2 1 1 1 1 04/17/2004 12:00:00 AM 5 3x3   6005759.2342 2111006.7416 37.7767477786156 -122.42359327476801 (37.7767477786156, -122.423593274768)
64108 83143 2 82 101X Whitney Young Cir 2 1 1 1 1 03/17/2006 12:00:00 AM 1     6016637.512159999 2095504.68596 37.7347904181313 -122.384881478104 (37.7347904181313, -122.384881478104)
8721 94275 2 82 850 Broderick St 3 1 1 1     6     6001000.8133 2111684.213 37.778338202659995 -122.440102619662 (37.77833820266, -122.440102619662)
8801 94278 2 82 850@Golden Gate Broderick St 2 1 1 1     6     6001005.8896 2111653.4167 37.7782539328231 -122.440082850024 (37.7782539328231, -122.440082850024)
103743 96097 2 82 1999 Bryant St 1 1 1 1   03/26/2011 12:00:00 AM   3x3 Permit Number 767752 6009553.0 2105475.0 37.7617723065941 -122.41007883348301 (37.7617723065941, -122.410078833483)
108509 96100 2 82 2780X 18th St 2 1 1 1   03/26/2011 12:00:00 AM   3x3 Permit Number 767752 6009596.8 2105493.6 37.7618258328219 -122.40992865921999 (37.7618258328219, -122.40992865922)
79651 96102 2 82 2780X 18th St 5 1 1 1   03/26/2011 12:00:00 AM   3x3 Permit Number 767752 6009596.8 2105493.6 37.7618258328219 -122.40992865921999 (37.7618258328219, -122.40992865922)
142916 96107 2 82 2780X 18th St 1 1 1 1   03/26/2011 12:00:00 AM   3x3 Permit Number 767752 6009596.8 2105493.6 37.7618258328219 -122.40992865921999 (37.7618258328219, -122.40992865922)
113290 98121 2 82 900 York St 3 1 1 1     6 3x3 Permit Number 774687 6009897.0 2103882.5 37.7574189360449 -122.40877671518999 (37.7574189360449, -122.40877671519)
28416 99761 2 82 4212 25th St 2 1 1 1       3x3 4212-4216 25th St (4214 is visible address) 6002485.0 2101232.0 37.749723353108294 -122.434220849449 (37.7497233531083, -122.434220849449)
40781 101046 2 82 1050 Sansome St 1 1 1 1     1 3x3 Permit Number 774347 6012049.4869099995 2119300.00717 37.799872179210894 -122.40241656909201 (37.7998721792109, -122.402416569092)
114129 101280 2 82 2201 Irving St 1 1 1 1       3x3   5988947.0 2106461.0 37.7633031017087 -122.48141813594201 (37.7633031017087, -122.481418135942)
15797 101777 2 82 1700 Yosemite Ave 3 1 1 1     8 3x3   6014038.07825 2093123.5904299999 37.72810829704029 -122.39370208181101 (37.7281082970403, -122.393702081811)
99067 102143 2 82 442 Sanchez St 1 1 1 1     10 3x3   6003585.0 2105673.0 37.761979658220206 -122.43073388246799 (37.7619796582202, -122.430733882468)
114315 102144 2 82 0X Ford St 1 1 1 1     12 3x3   6003601.0 2105679.0 37.7619970392507 -122.430678972901 (37.7619970392507, -122.430678972901)
87818 102145 2 82 0X Ford St 2 1 1 1     10 3x3   6003601.0 2105679.0 37.7619970392507 -122.430678972901 (37.7619970392507, -122.430678972901)
103400 102146 2 82 0X Ford St 3 1 1 1     12 3x3   6003601.0 2105679.0 37.7619970392507 -122.430678972901 (37.7619970392507, -122.430678972901)
78871 102179 2 82 4354 20th St 1 1 1 1     14 3x3   6002056.0 2104132.0 37.7576617009806 -122.435911822312 (37.7576617009806, -122.435911822312)
91102 102673 2 82 616 Shrader St 2 1 1 1       3x3   5997561.0 2108438.0 37.7692285123205 -122.451767914676 (37.7692285123205, -122.451767914676)
5178 104043 2 82 1405 Greenwich St 1 1 1 1     3 3x3   6006090.81059 2119657.4034599997 37.800519058872396 -122.42306126657199 (37.8005190588724, -122.423061266572)
5575 105537 2 82 2192 Green St 2 1 1 1     6 3x3   6002561.80287 2118173.8704 37.796245890587 -122.435166876954 (37.796245890587, -122.435166876954)
66275 106724 2 82 421 Cambridge St 1 1 1 1     8     6006940.66037 2092543.6305799999 37.7261189013498 -122.418197053944 (37.7261189013498, -122.418197053944)
164092 106806 2 82 167 Commonwealth Ave 1 1 1 1     4     5996526.1156 2113255.0824 37.7823956347772 -122.455695748043 (37.7823956347772, -122.455695748043)
131718 106807 2 82 167 Commonwealth Ave 2 1 1 1     2     5996526.1156 2113238.8382 37.78235103251139 -122.45569457348499 (37.7823510325114, -122.455694573485)
10316 110495 2 82 230 Madrid St 1 1 1 1     6 3x3   6003598.79471 2092490.0157299999 37.7257830144685 -122.429745863482 (37.7257830144685, -122.429745863482)
11111 110496 2 82 234 Madrid St 1 1 1 1     6 3x3   6003585.89382 2092469.97138 37.7257272466074 -122.429789031845 (37.7257272466074, -122.429789031845)
47113 111740 2 82 498x 11th Ave 3 1 1 1     1 3x3   5992531.49665 2112146.31797 37.779121219504106 -122.46943451634199 (37.7791212195041, -122.469434516342)
88077 111906 2 82 1699x WASHINGTON ST 1 1 1 1       3x3   6006657.0 2116952.0 37.7931226344993 -122.42090983270799 (37.7931226344993, -122.420909832708)
139854 111907 2 82 1699x WASHINGTON ST 2 1 1 1       3x3   6006657.0 2116952.0 37.7931226344993 -122.42090983270799 (37.7931226344993, -122.420909832708)
107640 111908 2 82 1699x WASHINGTON ST 3 1 1 1       3x3   6006657.0 2116952.0 37.7931226344993 -122.42090983270799 (37.7931226344993, -122.420909832708)
145239 111909 2 82 1699x WASHINGTON ST 4 1 1 1       3x3   6006657.0 2116952.0 37.7931226344993 -122.42090983270799 (37.7931226344993, -122.420909832708)
111716 111910 2 82 1699x WASHINGTON ST 5 1 1 1       3x3   6006657.0 2116952.0 37.7931226344993 -122.42090983270799 (37.7931226344993, -122.420909832708)
141691 112080 2 82 1901x SANTIAGO ST 2 1 1 1     3 3x3   5986971.0 2099566.0 37.744256215511896 -122.487745790198 (37.7442562155119, -122.487745790198)
144808 112082 2 82 1901x SANTIAGO ST 4 1 1 1     3 3x3   5986971.0 2099566.0 37.744256215511896 -122.487745790198 (37.7442562155119, -122.487745790198)
114782 112164 2 82 701 MISSION ST 1 1 1 1       3x3   6011822.0 2114512.0 37.7867127527861 -122.4028668317 (37.7867127527861, -122.4028668317)
100658 112504 2 82 601 WILLOW ST 1 1 1 2   01/14/2016 10:27:00 AM 3 2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
93327 112843 2 82 1415 EVANS AVE 1 7 1 1           6016481.0 2097724.0 37.7408755487739 -122.385577218432 (37.7408755487739, -122.385577218432)
107775 112864 2 82 750 VICENTE ST 1 1 1 1     8 3x3   5990595.0 2097751.0 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927)
114300 112865 2 82 750 VICENTE ST 2 1 1 1       3x3   5990595.0 2097751.0 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927)
20863 112866 2 82 750 VICENTE ST 3 1 1 1       3x3   5990595.0 2097751.0 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927)
109062 112867 2 82 750 VICENTE ST 4 1 1 1       3x3   5990595.0 2097751.0 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927)
99727 112868 2 82 750 VICENTE ST 5 1 1 1       3x3   5990595.0 2097751.0 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927)
109983 112869 2 82 750 VICENTE ST 6 1 1 1       3x3   5990595.0 2097751.0 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927)
147868 113164 2 82 3902 Clay St 1 1 1 1     10 3x3   5996104.12061 2115248.7957599997 37.7878456121944 -122.457299932451 (37.7878456121944, -122.457299932451)
187865 113165 2 82 3902 Clay St 2 1 1 1     8 3x3   5996094.44333 2115248.19615 37.787843410013 -122.457333370439 (37.787843410013, -122.457333370439)
163550 113166 2 82 3902 Clay St 3 1 1 1     10 3x3   5996084.69058 2115243.98919 37.7878312986742 -122.457366808459 (37.7878312986742, -122.457366808459)
93319 113204 2 82 3225 26TH ST 7 1 1 1       3x3   6008227.0 2100905.0 37.7491497143695 -122.41434158844801 (37.7491497143695, -122.414341588448)
19725 114507 2 82 10 LOMBARD ST 2 16 1 9       4x4   6011932.0 2120995.0 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468)
101671 114903 2 82 3261 23rd St 3 1 1 1     10 3x3   6007278.07200017 2102623.89370267 37.7538160547365 -122.41774482262699 (37.7538160547365, -122.417744822627)
8596 115210 2 82 115 Spruce St 2 1 1 1     8 3x3   5997031.37665 2115893.5791 37.789669227607604 -122.45413840466298 (37.7896692276076, -122.454138404663)
94294 115222 2 82 2252 15TH ST 3 1 1 1       3x3   6002543.0 2107122.0 37.76589916997111 -122.434441354631 (37.7658991699711, -122.434441354631)
117317 115488 2 82 1393 YORK ST 1 1 1 1     10 3x3   6010176.0 2101093.0 37.7497752121793 -122.407615143394 (37.7497752121793, -122.407615143394)
58943 116918 2 82 1390x TENNESSEE ST 1 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015390.0 2102613.0 37.754239296938295 -122.389690908339 (37.7542392969383, -122.389690908339)
109779 116919 2 82 1390x TENNESSEE ST 2 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015390.0 2102613.0 37.754239296938295 -122.389690908339 (37.7542392969383, -122.389690908339)
108702 116920 2 82 1390x TENNESSEE ST 3 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015390.0 2102613.0 37.754239296938295 -122.389690908339 (37.7542392969383, -122.389690908339)
121953 116921 2 82 1390x TENNESSEE ST 4 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015390.0 2102613.0 37.754239296938295 -122.389690908339 (37.7542392969383, -122.389690908339)
110363 116922 2 82 900x 24TH ST 1 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015390.0 2102613.0 37.754239296938295 -122.389690908339 (37.7542392969383, -122.389690908339)
57643 117045 2 82 2205x Sutter St 1 1 1 1     3 3x3   6002006.1518 2114301.3544 37.7855813923399 -122.436812184863 (37.7855813923399, -122.436812184863)
46947 117046 2 82 2205x Sutter St 2 1 1 1     9 3x3   6002022.6426 2114300.8047 37.785580820217206 -122.436755092227 (37.7855808202172, -122.436755092227)
48328 117078 2 82 1506 FILLMORE ST 1 1 1 2     0 5x5   6003016.0 2114040.0 37.7849211205465 -122.433299725252 (37.7849211205465, -122.433299725252)
98800 117418 2 82 171 COLERIDGE ST 1 1 1 1     6 3x3   6006547.0 2098715.0 37.743041953466296 -122.41999567036801 (37.7430419534663, -122.419995670368)
45516 117917 2 82 767 41st Ave 2 9 1 1     6 Width 4ft   5983194.46177 2110567.54263 37.7742423451733 -122.501617774429 (37.7742423451733, -122.501617774429)
169324 118185 2 82 435 33rd Ave 2 1 1 1     4 Width 2ft   5985597.25903 2112945.4232900003 37.7809121598048 -122.493481422073 (37.7809121598048, -122.493481422073)
77757 118287 2 82 240 IVY ST 1 1 1 1       3x2.5   6006177.0 2111293.0 37.777557347021606 -122.42216843833201 (37.7775573470216, -122.422168438332)
116732 118288 2 82 240 IVY ST 3 1 1 1       3x2.5   6006177.0 2111293.0 37.777557347021606 -122.42216843833201 (37.7775573470216, -122.422168438332)
126891 120181 2 82 142 26th Ave 1 1 1 1     8 Width 3ft   5987742.587230001 2115005.98358 37.7866951312776 -122.486211085191 (37.7866951312776, -122.486211085191)
50738 120183 2 82 160 26th Ave 1 1 1 1     8 Width 3ft   5987744.35264 2114901.48572 37.7864083129421 -122.486197303246 (37.7864083129421, -122.486197303246)
49709 120248 2 82 164 24th Ave 3 2 1 1     9 Width 6ft   5988365.09621 2114861.46484 37.786334585774604 -122.484046777757 (37.7863345857746, -122.484046777757)
77045 120249 2 82 164 24th Ave 2 2 1 1     10 Width 6ft   5988365.91336 2114852.64965 37.786310429345704 -122.48404330399599 (37.7863104293457, -122.484043303996)
63345 120250 2 82 164 24th Ave 1 2 1 1     9 Width 6ft   5988365.5517 2114845.05893 37.7862895663335 -122.484043998391 (37.7862895663335, -122.484043998391)
Powered by Datasette · Query took 120.751ms · Data source: data.sfgov.org