sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
116973 108643 2 17 315X PACIFIC AVE 1 1 1 1 15     3x3   6012408.6 2118423.0 37.7974841688946 -122.40111223755501 (37.7974841688946, -122.401112237555)
62495 118286 2 12 199X JULES AVE 2 1 1 1 12     3x3   5994418.0 2091201.0 37.7217195365393 -122.461389557582 (37.7217195365393, -122.461389557582)
80969 108934 1 49 361 Elsie St 1 1 1 1 12 01/12/2015 12:00:00 AM 3 3x3 Permit Number 774685 6006490.6 2097118.7 37.7386556931549 -122.42007742591001 (37.7386556931549, -122.42007742591)
112534 108521 1 120 1969 17th Ave 1 1 1 1 12 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773668 5990944.21476 2102008.8699 37.751194650539205 -122.47418561882401 (37.7511946505392, -122.474185618824)
112977 118285 2 12 199X JULES AVE 1 1 1 1 12     3x3   5994418.0 2091201.0 37.7217195365393 -122.461389557582 (37.7217195365393, -122.461389557582)
117298 108904 1 13 565 Banks St 1 1 1 1 12 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772986 6008567.7 2096169.9 37.7361673058735 -122.41282871497101 (37.7361673058735, -122.412828714971)
50491 107717 2 17 2400X 25th Ave 3 1 2 1 11 10/16/2014 12:00:00 AM 3 3x3 Permit Number 773973 5985789.0 2098909.0 37.7423832554664 -122.49178447783899 (37.7423832554664, -122.491784477839)
80890 108255 2 19 1798X Washington St 2 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
92163 108259 2 19 1798X Washington St 6 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
97433 107716 2 17 2400X 25th Ave 2 1 2 1 11 10/16/2014 12:00:00 AM 3 3x3 Permit Number 773973 5985789.0 2098909.0 37.7423832554664 -122.49178447783899 (37.7423832554664, -122.491784477839)
98097 108256 2 19 1798X Washington St 3 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
105668 108258 2 19 1798X Washington St 5 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
112717 108257 2 19 1798X Washington St 4 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
120202 108107 2 43 1990X Laguna St 2 1 1 1 11         6004838.0 2115780.0 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027)
121707 108254 2 19 1798X Washington St 1 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
136121 106963 2 44 2728 Union St 2 1 1 1 11   14     5999920.02374 2118149.14648 37.7960276377095 -122.444306168018 (37.7960276377095, -122.444306168018)
143269 108106 2 43 1990X Laguna St 1 1 1 1 11         6004838.0 2115780.0 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027)
44757 104618 2 21 800 Folsom St 1 1 1 1 10   8 4x4 Permit Number 770959 6012200.3 2112763.2826 37.7819322989016 -122.401435053146 (37.7819322989016, -122.401435053146)
90733 104623 2 21 250 04th St 1 1 1 1 10     3x3 Permit Number 770961 6012050.5 2112960.1 37.7824643544146 -122.40196713530099 (37.7824643544146, -122.401967135301)
95314 104621 2 21 266-286X 04th St 1 1 1 1 10     4x4 Permit Number 770959 6012142.0 2112916.0 37.7823483723512 -122.401647482717 (37.7823483723512, -122.401647482717)
113498 104624 2 21 250 04th St 2 1 1 1 10     3x3 Permit Number 770961 6012050.5 2112960.1 37.7824643544146 -122.40196713530099 (37.7824643544146, -122.401967135301)
140020 104622 2 21 266-286X 04th St 2 1 1 1 10     4x4 Permit Number 770959 6012142.0 2112916.0 37.7823483723512 -122.401647482717 (37.7823483723512, -122.401647482717)
145040 104625 2 21 250 04th St 3 1 1 1 10     3x3 Permit Number 770961 6012050.5 2112960.1 37.7824643544146 -122.40196713530099 (37.7824643544146, -122.401967135301)
151790 104620 2 21 800 Folsom St 3 1 1 1 10   10 4x4 Permit Number 770959 6012183.3573 2112747.2558 37.7818873476901 -122.401492540712 (37.7818873476901, -122.401492540712)
164897 104619 2 21 800 Folsom St 2 1 1 1 10   7 4x4 Permit Number 770959 6012190.226 2112753.6665 37.781905333235294 -122.401469228728 (37.7819053332353, -122.401469228728)
27975 107435 2 340 418 19th Ave 2 1 1 1 9   32 3x3   5990007.15475 2112492.97382 37.779926833827794 -122.478192501966 (37.7799268338278, -122.478192501966)
100855 114731 7 103 934 BRANNAN ST   13 1 1 9     10x10   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
4715 103364 2 15 1171X Sacramento St 3 1 1 1 7   3 3x3   6009173.30525 2116699.27717 37.79257023366971 -122.412185363057 (37.7925702336697, -122.412185363057)
5817 103362 2 15 1171X Sacramento St 1 1 1 1 7   12 3x3   6009111.87446 2116690.2667799997 37.7925420462198 -122.41239727931601 (37.7925420462198, -122.412397279316)
6038 103363 2 15 1171X Sacramento St 2 1 1 1 7   12 3x3   6009142.2805 2116694.47646 37.79255531122121 -122.412292370693 (37.7925553112212, -122.412292370693)
6622 103365 2 15 1171X Sacramento St 4 1 1 1 7   12 3x3   6009208.54849 2116702.7837799997 37.7925818394263 -122.412063667702 (37.7925818394263, -122.412063667702)
79827 103361 2 15 1000X Taylor St 10 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
83849 103357 2 15 1000X Taylor St 6 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
88405 103359 2 15 1000X Taylor St 8 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
89814 103355 2 15 1000X Taylor St 4 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
91178 103360 2 15 1000X Taylor St 9 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
120938 103358 2 15 1000X Taylor St 7 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
139014 103352 2 15 1000X Taylor St 1 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
140230 103354 2 15 1000X Taylor St 3 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
140679 103356 2 15 1000X Taylor St 5 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
145238 103353 2 15 1000X Taylor St 2 1 1 1 7   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821)
172264 116139 2 15 1171X Sacramento St 5 1 1 1 7   11     6009237.30915 2116708.0838099997 37.7925980056535 -122.411964529145 (37.7925980056535, -122.411964529145)
891 251304 2 1 1 Cashmere St 3 13 1 1 5     3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
521 5204 3 15 777 Divisadero St 1 1 1 1 4 04/21/2016 12:00:00 AM 3 4X4   6001528.9942 2111019.6475 37.7765435284866 -122.438227828795 (37.7765435284866, -122.438227828795)
621 251339 1 51 2230 Ocean Ave 3 1 1 1 4 05/28/2012 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
657 5214 3 9 835 Divisadero St 1 1 1 1 4 12/09/2001 12:00:00 AM 3 3X3   6001489.0793 2111327.2763 37.7773859294292 -122.438387950593 (37.7773859294292, -122.438387950593)
985 97601 3 9 855 Divisadero St 1 1 1 1 4   3 3x3   6001476.9066 2111398.2834 37.7775802046297 -122.43843514847099 (37.7775802046297, -122.438435148471)
1065 24631 3 44 601 Divisadero St 1 1 1 1 4 04/03/2013 12:00:00 AM 3 3X3   6001596.3507 2110541.037 37.775233214934104 -122.43796053363701 (37.7752332149341, -122.437960533637)
1685 251478 1 15 2x Virginia Ave 2 1 1 1 4 02/21/2004 12:00:00 AM   3x3   6006146.0 2098692.0 37.7429562000135 -122.42138058886101 (37.7429562000135, -122.421380588861)
1968 251132 1 26 354 05th St 2 1 1 1 4 02/11/2006 12:00:00 AM   3x3 Permit Number 779305 6011875.0 2111882.0 37.779494345884295 -122.402498458881 (37.7794943458843, -122.402498458881)
2484 5197 3 9 631 Divisadero St 1 1 1 1 4 05/10/1993 12:00:00 AM 3 3X3   6001585.1623 2110622.5519999997 37.7754563984119 -122.438005076955 (37.7754563984119, -122.438005076955)
2929 28092 3 9 528 Divisadero St 1 1 1 1 4 05/12/2001 12:00:00 AM 3 3X3   6001704.4418 2110256.1887 37.774457239071104 -122.43756621922199 (37.7744572390711, -122.437566219222)
3158 253097 6 3 1290 Portola Dr 1 9 1 1 4 08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
3798 5199 3 9 643 Divisadero St 1 1 1 1 4 06/29/2007 12:00:00 AM 3 3X3   6001573.1748 2110709.1284 37.7756934337528 -122.43805274745701 (37.7756934337528, -122.438052747457)
4425 97577 3 9 628 Divisadero St 1 1 1 1 4   3 3x3   6001652.1221 2110620.3263 37.775454094869296 -122.43777328811301 (37.7754540948693, -122.437773288113)
4475 253631 2 49 39 Mason St 1 1 1 1 4         6009957.290080001 2113442.89538 37.783672949399204 -122.409242840109 (37.7836729493992, -122.409242840109)
4588 200921 1 79 4040 03rd St 1 1 1 1 4 01/18/2008 12:00:00 AM 5 Width 0ft   6015547.5959 2097647.2059 37.7406129979736 -122.388799250904 (37.7406129979736, -122.388799250904)
5125 97583 3 9 748 Divisadero St 1 1 1 1 4   3 3x3   6001590.7259 2111040.5 37.776604295001 -122.438015775508 (37.776604295001, -122.438015775508)
5209 169218 1 29 824 Ellis St 1 1 1 1 4   0 3x3   6006905.3054599995 2113639.6299099997 37.7840416758297 -122.419815533287 (37.7840416758297, -122.419815533287)
5210 83637 1 17 840 Ellis St 1 1 1 1 4 11/19/2005 12:00:00 AM   3x3   6006834.966315799 2113631.30048912 37.784014842491395 -122.420058290383 (37.7840148424914, -122.420058290383)
5211 253829 1 54 869 Ellis St 1 1 1 1 4     3x3   6006713.1749 2113568.2957099997 37.7838349840749 -122.420475171434 (37.7838349840749, -122.420475171434)
5216 253831 1 54 651X Polk St 5 1 1 1 4     3x3            
5217 169168 1 29 701 Polk St 2 1 1 1 4   0 3x3   6007051.56678 2113380.55802 37.7833385660552 -122.41929113679599 (37.7833385660552, -122.419291136796)
5218 169214 1 29 724 Ellis St 1 1 1 1 4   0 Width 4ft   6007369.544319999 2113705.88387 37.7842497348906 -122.41821413029301 (37.7842497348906, -122.418214130293)
5222 253825 1 54 725 Ellis St 1 1 1 1 4     3x3   6007393.727109999 2113660.9435900003 37.784127700976896 -122.418127279043 (37.7841277009769, -122.418127279043)
5223 74484 1 17 749 Polk St 4 1 1 1 4 06/29/2016 12:00:00 AM 3 3x3 Permit Number 778449 6007035.08305 2113498.23336 37.783660745502296 -122.41935651480301 (37.7836607455023, -122.419356514803)
5224 253827 1 54 825 Polk St 1 1 1 1 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5226 253832 1 54 665 Eddy St 1 1 1 1 4     3x3   6007254.7956 2113297.42725 37.783121752773 -122.41858214693501 (37.783121752773, -122.418582146935)
5227 169217 1 29 800 Ellis St 1 1 1 1 4   0 3x3   6006932.37231 2113646.73425 37.7840627073778 -122.41972239586501 (37.7840627073778, -122.419722395865)
5228 253828 1 54 825 Polk St 2 1 1 1 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5229 253834 1 54 747 Eddy St 1 1 1 1 4     3x3   6006860.78535 2113242.76542 37.7829494746502 -122.419941385136 (37.7829494746502, -122.419941385136)
5230 253826 1 54 701 Ellis St 1 1 1 1 4     3x3            
5234 169170 1 29 750 Eddy St 1 1 1 1 4   0 3x3   6006877.9642199995 2113290.02776 37.7830802133315 -122.419885308057 (37.7830802133315, -122.419885308057)
5236 253833 1 54 607 Eddy St 2 1 1 1 4     3x3            
5238 169219 1 29 840 Polk St 1 1 1 1 4   0 3x3   6006827.36035 2113629.7400599997 37.7840101293977 -122.42008449353001 (37.7840101293977, -122.42008449353)
5239 253830 1 54 651X Polk St 3 1 1 1 4     3x3            
5728 97579 3 9 628 Divisadero St 3 1 1 1 4   3 3x3   6001646.5608 2110651.222 37.7755386104847 -122.437794739235 (37.7755386104847, -122.437794739235)
5735 28095 3 9 650 Divisadero St 2 1 1 1 4 12/06/2006 12:00:00 AM 3 3x3   6001636.0563 2110732.7869 37.775761969914896 -122.437836920035 (37.7757619699149, -122.437836920035)
5871 97602 3 9 833 Divisadero St 1 1 1 1 4   3 3xe   6001492.376 2111306.2278 37.777328323069796 -122.438375037891 (37.7773283230698, -122.438375037891)
5874 97590 3 9 559 Divisadero St 1 1 1 1 4   3 3x3   6001615.3648 2110410.2466 37.774875178544995 -122.437885389718 (37.774875178545, -122.437885389718)
5886 5187 3 9 505 Divisadero St 1 1 1 1 4   3 3X3   6001641.6836 2110218.0701 37.7743490065847 -122.43778058071699 (37.7743490065847, -122.437780580717)
6000 28097 3 9 661 Divisadero St 1 1 1 1 4   3 3X3   6001567.17 2110752.9686 37.7758134664372 -122.438076660597 (37.7758134664372, -122.438076660597)
6072 24616 3 9 830 Divisadero St 1 1 1 1 4 03/27/1990 12:00:00 AM 3 3X3   6001554.3804 2111297.3519 37.777307478654706 -122.438159908991 (37.7773074786547, -122.438159908991)
6760 24628 3 9 536 Divisadero St 1 1 1 1 4 03/27/1990 12:00:00 AM 3 3X3   6001694.2572 2110311.9357 37.774609727324204 -122.437605442785 (37.7746097273242, -122.437605442785)
7406 97595 3 9 793 Divisadero St 3 1 1 1 4   3 4x4   6001524.4178 2111055.242 37.7766410017417 -122.438246210395 (37.7766410017417, -122.438246210395)
7506 14836 1 21 1300 McAllister St 1 1 1 1 4 10/22/2008 12:00:00 AM 9 3X3   6002892.8097 2111692.1261 37.7784674596438 -122.43355807318501 (37.7784674596438, -122.433558073185)
7792 97581 3 9 736 Divisadero St 1 1 1 1 4   3 3x3   6001597.3606 2110988.4698 37.776461810461704 -122.43798909643101 (37.7764618104617, -122.437989096431)
7872 97569 3 9 542 Divisadero St 1 1 1 1 4   3     6001690.505 2110331.7687 37.7746639704386 -122.437619843013 (37.7746639704386, -122.437619843013)
8085 5202 3 9 740 Divisadero St 1 1 1 1 4 02/15/2005 12:00:00 AM 3 3X4   6001595.2588 2111007.3853 37.7765136281427 -122.437997722367 (37.7765136281427, -122.437997722367)
8303 97591 3 9 501 Divisadero St 1 1 1 1 4   3 4x3   6001649.1323 2110166.4258 37.7742076278049 -122.43775111477899 (37.7742076278049, -122.437751114779)
8311 5206 3 9 793 Divisadero St 1 1 1 1 4 05/10/1993 12:00:00 AM 3 4X4   6001519.3329 2111090.328 37.7767370498578 -122.438266314655 (37.7767370498578, -122.438266314655)
8394 97584 3 9 818 Divisadero St 1 1 1 1 4   3 3x3   6001564.5243 2111243.3358 37.777159740959895 -122.43812094768101 (37.7771597409599, -122.438120947681)
8431 97593 3 9 661 Divisadero St 2 1 1 1 4   3     6001569.9782 2110730.4395 37.7757517668907 -122.438065332169 (37.7757517668907, -122.438065332169)
17572 5174 3 9 350 Divisadero St 1 1 1 1 4 11/28/2006 12:00:00 AM 3 3x4   6001785.2321 2109677.0482 37.7728716568906 -122.437245274575 (37.7728716568906, -122.437245274575)
17669 5170 3 223 318 Divisadero St 1 1 1 1 4 02/15/2005 12:00:00 AM 3 3X3   6001801.5136 2109559.6859 37.7725503347821 -122.43718055043101 (37.7725503347821, -122.437180550431)
18219 5158 3 9 275 Divisadero St 1 1 1 1 4 03/27/1990 12:00:00 AM 3 3X3   6001773.6501 2109268.6052 37.771749515715605 -122.437256087151 (37.7717495157156, -122.437256087151)
18577 5154 3 9 259 Divisadero St 1 1 1 1 4   3 3X3   6001780.9624 2109220.4101 37.771617599631604 -122.43722734206499 (37.7716175996316, -122.437227342065)
20046 5155 3 9 265 Divisadero St 1 1 1 1 4 12/17/2001 12:00:00 AM 3 3X3   6001777.3063 2109242.3472 37.7716776256193 -122.43724155970399 (37.7716776256193, -122.437241559704)
22018 24636 3 223 443 Divisadero St 3 1 1 1 4 06/17/2014 12:00:00 AM 3 3X4   6001673.68932 2109984.60324 37.773709784823296 -122.437653143592 (37.7737097848233, -122.437653143592)
22149 16024 1 11 130 Monterey Blvd 1 1 1 1 4 12/29/2015 12:00:00 AM 3 3X3 Permit Number 776129 6001188.36813 2094689.80455 37.731686341545206 -122.43823603107799 (37.7316863415452, -122.438236031078)
44053 97599 3 223 857 Divisadero St 1 1 1 1 4   3 3x3   6001483.0 2111323.0 37.7773738419974 -122.43840867438801 (37.7773738419974, -122.438408674388)
Powered by Datasette · Query took 117.518ms · Data source: data.sfgov.org