sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4451 216718 2 48 978 Capitol Ave 2 2 1 1   10/13/2017 11:36:00 AM 3 Width 3ft   5995057.03199 2090421.24862 37.7196152839906 -122.45912417326299 (37.7196152839906, -122.459124173263)
31529 52954 1 48 975 Cayuga Ave 1 1 1 1 1 08/03/2006 12:00:00 AM 5   Permit Number 48941 6000767.51384 2091342.1163299999 37.7224704120511 -122.43945112037399 (37.7224704120511, -122.439451120374)
119242 87861 1 48 96 Caselli Ave 3 1 1 1   06/11/2008 12:00:00 AM   3x3 Permit Number 50803 6000485.4 2104954.1 37.7598296396585 -122.441402573572 (37.7598296396585, -122.441402573572)
47585 176883 2 48 96 Alpha St 4 7 1 1     1     6011048.63475 2088252.8219299999 37.7145675926038 -122.40369417294501 (37.7145675926038, -122.403694172945)
172938 176884 2 48 96 Alpha St 2 7 1 1     1     6011062.55449 2088258.87965 37.7145850034576 -122.40364648639601 (37.7145850034576, -122.403646486396)
20660 88463 1 48 955X Newhall St 1 1 1 1 1 07/11/2008 12:00:00 AM 6 3x3 Permit Number 51410 6015306.946426 2096847.395831 37.7384035424873 -122.389575486471 (37.7384035424873, -122.389575486471)
94653 88465 1 48 955X Newhall St 3 1 1 1 1 07/11/2008 12:00:00 AM 6 3x3 Permit Number 51410 6015306.946426 2096847.395831 37.7384035424873 -122.389575486471 (37.7384035424873, -122.389575486471)
42969 95722 1 48 950 Avalon Ave 7 1 1 1 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047)
79989 95720 1 48 950 Avalon Ave 5 1 1 1 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047)
97343 95721 1 48 950 Avalon Ave 6 1 1 1 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047)
124038 95719 1 48 950 Avalon Ave 4 1 1 1 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047)
125716 95718 1 48 950 Avalon Ave 3 1 1 1 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047)
63496 227556 2 48 95 Seward St 2 9 1 1     7 Width 3ft   6000674.34081 2104608.13246 37.7588904593411 -122.440724304978 (37.7588904593411, -122.440724304978)
4096 181028 2 48 95 Rolph St 2 2 1 1   10/05/2017 04:38:00 PM 3 Width 4ft   6000533.08885 2088674.4676599998 37.715132307492794 -122.44007027934201 (37.7151323074928, -122.440070279342)
4113 181027 2 48 95 Rolph St 1 2 1 1   10/05/2017 04:23:00 PM 3 Width 4ft   6000546.58685 2088667.2481099998 37.7151132526545 -122.440023107188 (37.7151132526545, -122.440023107188)
70838 69919 1 48 95 Mercedes Way 2 1 1 1 1 12/29/2015 12:00:00 AM     Permit Number 776113 5991810.08250882 2093768.29366569 37.728618246103295 -122.470591251084 (37.7286182461033, -122.470591251084)
83196 71841 1 48 95 Mercedes Way 1 1 1 1 1 12/29/2015 12:00:00 AM     Permit Number 776113 5991810.08250882 2093768.29366569 37.728618246103295 -122.470591251084 (37.7286182461033, -122.470591251084)
50407 52070 1 48 939 Jackson St 1 1 1 1   10/04/2005 12:00:00 AM 7   Permit Number 48265 6009656.25559 2117750.5131099997 37.7954837583147 -122.410588599703 (37.7954837583147, -122.410588599703)
147945 52071 1 48 939 Jackson St 2 1 1 1   10/04/2005 12:00:00 AM 7   Permit Number 48265 6009677.58908 2117754.14875 37.7954949369081 -122.41051503874701 (37.7954949369081, -122.410515038747)
38399 129386 2 48 929 Pine St 2 1 1 1     5 Width 3ft   6009490.7484 2116033.66261 37.7907604245028 -122.411039958651 (37.7907604245028, -122.411039958651)
74310 129384 2 48 91 McAllister St 3 1 1 1     7 Width 4ft   6008749.2926 2112454.6236099997 37.7808916402666 -122.41335215429399 (37.7808916402666, -122.413352154294)
172851 129382 2 48 91 McAllister St 1 1 1 1     4 Width 4ft   6008704.563080001 2112447.63135 37.7808699297471 -122.41350640150401 (37.7808699297471, -122.413506401504)
183197 129383 2 48 91 McAllister St 2 1 1 1     4 Width 4ft   6008721.10925 2112450.3341200002 37.7808782799549 -122.413449351208 (37.7808782799549, -122.413449351208)
179963 227566 2 48 91 Clover Ln 2 1 1 1     5 Width 5ft   6000468.027480001 2104951.63177 37.7598218728073 -122.44146247932301 (37.7598218728073, -122.441462479323)
153028 129390 2 48 902 Vallejo St 1 10 1 1     4 Width 4ft   6009192.86484 2118752.75452 37.798209676283 -122.41226288822399 (37.798209676283, -122.412262888224)
49701 191228 2 48 901 Newhall St 1 4 1 1     8 Width 3ft   6015254.00871 2096807.9147599998 37.7382922001146 -122.38975576401 (37.7382922001146, -122.38975576401)
137533 191229 2 48 901 Newhall St 3 4 1 1     6 Width 3ft   6015272.35005 2096832.51763 37.7383607716336 -122.389694066038 (37.7383607716336, -122.389694066038)
12688 27048 1 48 896 Silver Ave 1 1 1 1   01/29/2009 12:00:00 AM 3 3X3   6007189.55023 2093517.44233 37.7288067843062 -122.417405636178 (37.7288067843062, -122.417405636178)
11119 27314 1 48 884 Silver Ave 1 1 1 1   12/05/2007 12:00:00 AM 3 3X3   6007123.27309 2093533.58449 37.728847377904394 -122.41763590486799 (37.7288473779044, -122.417635904868)
36351 119164 2 48 883 47th Ave 1 1 1 1     1 Width 3ft   5981372.52859 2109725.62562 37.7718235084184 -122.507857566702 (37.7718235084184, -122.507857566702)
4276 180842 2 48 87 Laura St 3 1 1 1   10/10/2017 03:54:00 PM 3 Width 2ft   5997291.8877 2087045.22216 37.710473721248 -122.45115578601299 (37.710473721248, -122.451155786013)
113043 115237 1 48 867 42nd Ave 1 1 1 1   01/20/2016 12:00:00 AM     Permit Number 775536 5982900.6 2109891.1 37.772367765473795 -122.502584200594 (37.7723677654738, -122.502584200594)
175819 117934 2 48 867 42nd Ave 1 1 1 1     1 Width 3ft   5982916.92515 2109877.9656700003 37.7723326617078 -122.502526759002 (37.7723326617078, -122.502526759002)
47498 119083 2 48 863 45th Ave 1 1 1 1     1 Width 3ft   5981985.30992 2109867.54201 37.7722492542332 -122.505748473333 (37.7722492542332, -122.505748473333)
113001 115239 1 48 863 45th Ave 1 1 1 1   01/20/2016 12:00:00 AM     Permit Number 775147 5981970.6 2109880.3 37.7722834181785 -122.505800301349 (37.7722834181785, -122.505800301349)
176002 95742 1 48 86 Ina Ct 1 1 1 1 1 09/07/2011 12:00:00 AM 5 3x3 Permit Number 767488 6004830.443109999 2091416.58174 37.7229052675357 -122.42541178684799 (37.7229052675357, -122.425411786848)
37420 207024 2 48 85 Williar Ave 3 1 1 1     5 Width 3ft   5997067.34432 2090557.5942799998 37.7201050223995 -122.452185117661 (37.7201050223995, -122.452185117661)
38084 207023 2 48 85 Williar Ave 2 1 1 1     4 Width 3ft   5997061.0236599995 2090546.31892 37.7200737008175 -122.452206152789 (37.7200737008175, -122.452206152789)
60679 207022 2 48 85 Williar Ave 1 1 1 1     5 Width 3ft   5997053.5846 2090532.92812 37.720036506659206 -122.452230901246 (37.7200365066592, -122.452230901246)
161119 207025 2 48 85 Williar Ave 4 1 1 1     3 Width 3ft   5997075.91635 2090573.81293 37.72015004606371 -122.45215665681299 (37.7201500460637, -122.452156656813)
61434 227118 2 48 85 29th St 2 1 1 1     4 Width 3ft   6005870.45988 2099040.93392 37.743898754514106 -122.42235811905701 (37.7438987545141, -122.422358119057)
57528 227572 2 48 841 Church St 10 1 1 1     6 Width 3ft   6004362.062530001 2104151.54801 37.7578461063327 -122.42793790601499 (37.7578461063327, -122.427937906015)
98150 43741 1 48 840 Mount Vernon Ave 3 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.45213982606899 (37.7199634590291, -122.452139826069)
103046 43742 1 48 840 Mount Vernon Ave 4 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.45213982606899 (37.7199634590291, -122.452139826069)
112382 43739 1 48 840 Mount Vernon Ave 1 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.45213982606899 (37.7199634590291, -122.452139826069)
114348 43740 1 48 840 Mount Vernon Ave 2 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.45213982606899 (37.7199634590291, -122.452139826069)
44951 227560 2 48 84 Seward St 6 9 1 1     8 Width 3ft   6000737.03493 2104555.7602 37.758750228049294 -122.44050372379101 (37.7587502280493, -122.440503723791)
55628 227559 2 48 84 Seward St 4 9 1 1     4 Width 3ft   6000741.2761699995 2104538.3206 37.758702584674204 -122.44048780488001 (37.7587025846742, -122.44048780488)
133941 227561 2 48 84 Seward St 7 9 1 1     9 Width 3ft   6000738.66154 2104570.78605 37.7587915779822 -122.44049917592 (37.7587915779822, -122.44049917592)
13068 109689 1 48 836 Russia Ave 1 1 1 1 1 02/27/2015 12:00:00 AM 3 3x3 Permit Number 774161 6003406.50306 2089728.7354700002 37.7181902596385 -122.430213694415 (37.7181902596385, -122.430213694415)
137158 207029 2 48 835 Sargent St 1 4 1 1     7 Width 3ft   5991723.94975 2089189.17612 37.7160401362134 -122.47055564102301 (37.7160401362134, -122.470555641023)
178180 207030 2 48 835 Sargent St 2 4 1 1     7 Width 3ft   5991738.49074 2089190.01168 37.716043271265704 -122.470505441771 (37.7160432712657, -122.470505441771)
144924 114895 5 48 820 30th Ave 1 1 1 1   12/21/2015 12:00:00 AM     Permit Number 775427 5986664.4 2110325.3 37.7737804103986 -122.489596975753 (37.7737804103986, -122.489596975753)
41920 227112 2 48 82 Mirabel Ave 1 1 1 1     1 Width 2ft   6007863.71848 2099963.32211 37.7465436642568 -122.41553116305 (37.7465436642568, -122.41553116305)
164734 120000 2 48 818 30th Ave 1 9 1 1     1 Width 3ft   5986676.70436 2110336.5469299997 37.7738120096448 -122.489555240793 (37.7738120096448, -122.489555240793)
153496 227150 2 48 808 Crescent Ave 1 1 1 1     4 Width 3ft   6008185.203290001 2095640.9266099997 37.7346933830922 -122.41411375505301 (37.7346933830922, -122.414113755053)
110202 84332 1 48 804 29th Ave 2 1 1 1   10/08/2008 12:00:00 AM   3x3 Permit Number 51851 5986981.94009984 2110441.32651783 37.7741175201244 -122.488507097746 (37.7741175201244, -122.488507097746)
130069 84554 2 48 804 29th Ave 1 1 1 1 1 09/16/2006 12:00:00 AM 4     5986976.65331 2110412.96099 37.7740393278808 -122.488523300237 (37.7740393278808, -122.488523300237)
143316 102935 2 48 801X Church St 5 1 1 1     4 3x3   6004394.3 2104124.7 37.757774211767796 -122.427824502367 (37.7577742117678, -122.427824502367)
11575 27064 3 48 801 Silver Ave 6 1 1 2   01/30/2009 12:00:00 AM 1 4   6007054.44286 2093598.3683099998 37.7290213868102 -122.41787844665899 (37.7290213868102, -122.417878446659)
28351 248531 2 48 800 Shrader St 1 1 1 1     5 Width 0ft   5997658.267999999 2107761.8815 37.767377634072794 -122.451382700243 (37.7673776340728, -122.451382700243)
78971 51607 1 48 800 Shrader St 1 1 1 1 1 08/20/2005 12:00:00 AM 5 3x3 Permit Number 47904 5997656.30420255 2107807.08178851 37.7675016300781 -122.45139275313 (37.7675016300781, -122.45139275313)
121418 27081 1 48 799X Silver Ave 3 1 1 1   12/21/2007 12:00:00 AM 3 2X3   6006577.59669 2093640.7294700001 37.7291108536609 -122.419529947915 (37.7291108536609, -122.419529947915)
126643 27080 1 48 799X Silver Ave 2 1 1 1   01/29/2009 12:00:00 AM 6 2X3   6006577.59669 2093640.7294700001 37.7291108536609 -122.419529947915 (37.7291108536609, -122.419529947915)
74077 227120 2 48 799 Duncan St 6 9 1 1     3 Width 4ft   6001486.2339699995 2099669.55813 37.7453765205103 -122.43756273743 (37.7453765205103, -122.43756273743)
173018 227119 2 48 799 Duncan St 4 9 1 1     11 Width 4ft   6001473.16561 2099668.76787 37.7453736076231 -122.437607869022 (37.7453736076231, -122.437607869022)
88126 92664 1 48 791 San Bruno Ave 2 5 1 1   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.759644317200106 -122.404916188138 (37.7596443172001, -122.404916188138)
108202 92665 1 48 791 San Bruno Ave 3 5 1 1   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.759644317200106 -122.404916188138 (37.7596443172001, -122.404916188138)
125423 92663 1 48 791 San Bruno Ave 1 5 1 1   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.759644317200106 -122.404916188138 (37.7596443172001, -122.404916188138)
70932 119542 2 48 791 30th Ave 1 1 1 1     1 Width 3ft   5986618.95807 2110548.82595 37.7743914964818 -122.48977060648899 (37.7743914964818, -122.489770606489)
167057 227121 2 48 791 27th St 1 1 1 1     6 Width 4ft   6001433.87774 2099966.59062 37.746189124520896 -122.437765046244 (37.7461891245209, -122.437765046244)
13061 27046 1 48 790 Silver Ave 1 1 1 1   01/29/2009 12:00:00 AM 6 3X3   6006496.082169999 2093583.10222 37.728948030017904 -122.419807663316 (37.7289480300179, -122.419807663316)
24713 71549 2 48 780 Post St 2 1 1 1 1 08/18/2015 12:00:00 AM 3 3x3 Permit Number 772812 6008431.05429 2114892.38013 37.7875672592553 -122.41462566084101 (37.7875672592553, -122.414625660841)
41903 73594 1 48 780 Post St 1 1 1 1 1 07/12/2014 12:00:00 AM 3   Permit Number 772812 6008453.79298 2114896.74793 37.787580529660794 -122.41454729843399 (37.7875805296608, -122.414547298434)
118027 79726 1 48 780 Post St 1 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50955 6008416.19534554 2114892.53002417 37.7875668360064 -122.414677080613 (37.7875668360064, -122.414677080613)
74626 227547 2 48 780 Elizabeth St 1 1 1 1     6 Width 4ft   6001390.11593 2102052.79607 37.7519148588942 -122.43806578220502 (37.7519148588942, -122.438065782205)
11808 27083 3 48 773 Silver Ave 1 1 1 2   12/21/2007 12:00:00 AM 3 2X3   6006444.73415 2093622.02758 37.729052017734794 -122.419987938702 (37.7290520177348, -122.419987938702)
136694 227083 2 48 770 Treat Ave 1 1 1 1     3 Width 5ft   6008514.3452699995 2104071.33726 37.75785989922729 -122.41357185686 (37.7578598992273, -122.41357185686)
162634 95938 1 48 770 29th Ave 1 1 1 1 1 07/29/2011 12:00:00 AM 2 3x3 Permit Number 767634 5986967.37973 2110670.26469 37.774745270265605 -122.48857429400101 (37.7747452702656, -122.488574294001)
137003 227579 2 48 77 Landers St 1 1 1 1     8 Width 3ft   6004499.29505 2107353.29779 37.7666451110058 -122.427691415339 (37.7666451110058, -122.427691415339)
157288 227587 2 48 77 Brady St 1 1 1 1     20 Width 3ft   6006751.41341 2109490.52204 37.7726405574578 -122.42005339854201 (37.7726405574578, -122.420053398542)
33440 176906 2 48 769 Silver Ave 2 1 1 1     7 Width 3ft   6006512.6379 2093630.87617 37.7290801395131 -122.419753817278 (37.7290801395131, -122.419753817278)
169335 176907 2 48 769 Silver Ave 3 1 1 1     4 Width 3ft   6006492.037819999 2093629.408 37.7290749477448 -122.419824929392 (37.7290749477448, -122.419824929392)
95419 117055 1 48 762 34th Ave   1 1 1   05/18/2016 12:00:00 AM 3   Permit Number 778404 5985439.6 2110687.7 37.7747038750392 -122.49386040463101 (37.7747038750392, -122.493860404631)
177664 118188 2 48 762 34th Ave 1 1 1 1     1 Width 3ft   5985415.78787 2110692.34221 37.7747152280145 -122.49394311659901 (37.7747152280145, -122.493943116599)
159581 52456 1 48 757 11th Ave 1 1 1 1 1 11/26/2013 12:00:00 AM 1   Permit Number 770898 5992550.20906 2110320.92766 37.774110273254706 -122.46923688790599 (37.7741102732547, -122.469236887906)
179813 137671 2 48 756 LYON ST 1 1 1 1     1 Width 0ft   6000049.6788 2111547.4906 37.7779086039439 -122.443383113797 (37.7779086039439, -122.443383113797)
129668 207044 2 48 755 Foerster St 1 9 1 1     4 Width 3ft   5998014.32968 2095894.50831 37.7348131350024 -122.44929603208 (37.7348131350024, -122.44929603208)
11394 27044 1 48 750 Silver Ave 1 1 1 1   05/26/1999 12:00:00 AM 3 3X3   6006334.59281 2093563.7909400002 37.7288859066417 -122.42036457476001 (37.7288859066417, -122.42036457476)
180870 227099 2 48 75 Montcalm St 2 1 1 1     1 Width 3ft   6010635.77556 2100089.10311 37.7470444571367 -122.40595450111401 (37.7470444571367, -122.405954501114)
139293 38921 1 48 749 Lakeview Ave 1 1 1 1 1 11/02/1998 12:00:00 AM     Permit Number 40731 5994544.80644489 2089901.89590816 37.718159804985795 -122.460857119734 (37.7181598049858, -122.460857119734)
59456 106431 2 48 747 Natoma St 1 1 1 1     2 3x3   6008848.75367 2110684.34026 37.7760364460542 -122.412882870049 (37.7760364460542, -122.412882870049)
74076 120009 2 48 746 29th Ave 1 1 1 1     2 Width 3ft   5986962.570590001 2110820.51914 37.775157546008 -122.48860197556101 (37.775157546008, -122.488601975561)
134834 84816 1 48 736 Leavenworth St 1 1 1 1   11/13/2009 12:00:00 AM 4 3x3 Permit Number 53031 6008319.9304599995 2115035.61847 37.7879543130824 -122.415020270782 (37.7879543130824, -122.415020270782)
56440 117883 2 48 734 43rd Ave 3 1 1 1     5 Width 3ft   5982620.39521 2110769.29715 37.7747625699566 -122.503618485147 (37.7747625699566, -122.503618485147)
56847 71337 2 48 734 43rd Ave 2 1 1 1 1 01/20/1996 12:00:00 AM 4     5982620.59121 2110750.54443 37.7747110919712 -122.503616418137 (37.7747110919712, -122.503616418137)
10740 27042 1 48 730 Silver Ave 1 1 1 1   12/10/2007 12:00:00 AM 6 3X3   6006159.1890199995 2093550.7367900002 37.7288401770086 -122.420970032554 (37.7288401770086, -122.420970032554)
158616 129380 2 48 730 Leavenworth St 1 1 1 1     4 Width 4ft   6008321.927730001 2115014.63424 37.7878968077251 -122.415011874722 (37.7878968077251, -122.415011874722)
11861 117431 1 48 730 Excelsior Ave 1 1 1 1   06/14/2016 12:00:00 AM 3   Permit Number 776696 6004211.115780001 2091567.32576 37.7232841663055 -122.42756340763901 (37.7232841663055, -122.427563407639)
109287 50035 1 48 73 University St 2 1 1 1 1 07/28/2003 12:00:00 AM     Permit Number 46766 6007848.45417861 2093691.5625558 37.7293219318135 -122.41514007459801 (37.7293219318135, -122.415140074598)
153522 50036 1 48 73 University St 1 1 1 1 1 07/28/2003 12:00:00 AM 9   Permit Number 46766 6007832.621069999 2093714.43935 37.729383856755796 -122.41519642998199 (37.7293838567558, -122.415196429982)
Powered by Datasette · Query took 6.426ms · Data source: data.sfgov.org