sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9684 173630 6 1 2699x OCEAN AVE 2 5 1 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
114895 116578 6 1 2699x OCEAN AVE 1 5 1 6 4   11 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
90552 47255 3 2 1035 Gilman Ave 4 1 1 4 4 05/09/2002 12:00:00 AM 6 3x3 Permit Number 45198 6015368.10493708 2089617.80548286 37.71855592189279 -122.388859444456 (37.7185559218928, -122.388859444456)
98455 97903 2 2 375X Precita Ave 9 1 1 4 4   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
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)
108228 106878 2 3 180X SAN MARCOS AVE 1 11 1 1 4   26     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
87235 117162 2 5 1383X VERMONT ST 2 8 1 1 4         6011571.0 2102081.0 37.752566033842896 -122.40286062573799 (37.7525660338429, -122.402860625738)
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)
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)
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)
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)
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)
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)
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)
109915 109999 2 10 501X Shotwell St 16 1 1 10 4         6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
128369 109998 2 10 501X Shotwell St 15 1 1 10 4         6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
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)
87276 112509 2 11 699x WILLOW ST 1 1 1 20 4     2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
94993 112510 2 11 699x WILLOW ST 2 1 1 20 4     2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
109229 93013 1 11 2395 Lombard St 1 1 1 1 4 01/08/2010 12:00:00 AM 3 4x4 Permit Number 53139; 3-year maintenance agreement through 12/29/12 6000915.0 2119261.0 37.7991372104515 -122.440943166878 (37.7991372104515, -122.440943166878)
113857 97066 3 11 1599X Newcomb Ave 7 1 1 4 4   10 3x3   6015231.1 2095663.5 37.7351486000155 -122.38975506041099 (37.7351486000155, -122.389755060411)
120473 112511 2 11 699x WILLOW ST 3 1 1 20 4 08/08/2015 03:37:00 PM 3 2x2   6004423.0 2113018.0 37.7821946822097 -122.42835909048999 (37.7821946822097, -122.42835909049)
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)
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)
82894 24632 3 15 605 Divisadero St 1 1 1 1 4 10/08/2014 11:30:00 AM 3 3X3   6001606.913089 2110457.4002288003 37.7750041699802 -122.437918004082 (37.7750041699802, -122.437918004082)
110539 14250 1 15 2001 Market St 6 1 1 1 4 05/20/2011 12:00:00 AM 0 3x3 Permit Number 767173 6004759.8459002 2108188.2274393 37.7689523618819 -122.426849682313 (37.7689523618819, -122.426849682313)
140589 14248 1 15 2001 Market St 4 1 1 1 4 05/20/2011 12:00:00 AM 0 3x3 Permit Number 767173 6004759.8459002 2108188.2274393 37.7689523618819 -122.426849682313 (37.7689523618819, -122.426849682313)
85143 115005 5 16 1050 MCALLISTER ST 2 8 1 21 4     3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
97910 100983 3 16 2190 Powell St 4 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
107842 100984 3 16 2190 Powell St 5 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
145388 100987 3 16 2190 Powell St 8 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
1493 103663 2 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
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)
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)
5598 103666 2 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7681 103657 6 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7764 103662 2 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8197 103668 6 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8408 103664 2 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
10665 103665 2 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11212 103658 6 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11415 103667 2 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12113 103660 6 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12885 103661 6 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
15949 103659 6 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
94772 98675 1 17 199X Park St 1 1 1 4 4         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
111283 98658 3 17 2110 Greenwich St 12 1 1 4 4 06/20/2014 12:00:00 AM   6x6 Permit Number 772915 6002683.8 2119245.6 37.799195508176105 -122.434821422435 (37.7991955081761, -122.434821422435)
127181 103126 1 17 1020 Guerrero St 2 1 1 1 4 03/22/2013 12:00:00 AM   3x3 Permit Number 769235 6005624.5 2103007.3 37.7547756072831 -122.423490517587 (37.7547756072831, -122.423490517587)
119959 100985 3 18 2190 Powell St 6 1 1 4 4 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
101889 95411 1 20 2815 Diamond St 1 1 1 1 4   1 3x3 Planted by Glen Park Library; will become DPW maintained. 6002467.0 2095594.0 37.734241695714005 -122.43388015504499 (37.734241695714, -122.433880155045)
111008 116626 2 20 5732X GEARY BLVD 7 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
120383 95412 1 20 2815 Diamond St 3 1 1 1 4   1 3x3 Planted by Glen Park Public Library; will become DPW maintained after it is established. 6002467.0 2095594.0 37.734241695714005 -122.43388015504499 (37.734241695714, -122.433880155045)
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)
85658 96467 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
89325 96464 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
103701 96466 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
115707 96469 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
120725 96465 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
124890 96470 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
144888 96468 1 21 2001 Market St   1 1 1 4 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.42717658242701 (37.7686219813575, -122.427176582427)
47263 100971 3 22 450X Chestnut St 3 1 1 4 4   4   Permit Number 37341 6009642.5454 2120895.3461 37.8041179253888 -122.410858257388 (37.8041179253888, -122.410858257388)
55605 100978 3 22 450X Chestnut St 10 1 1 4 4   5   Permit Number 37341 6009524.0508 2120877.4907 37.8040622540071 -122.41126705605801 (37.8040622540071, -122.411267056058)
57285 100977 3 22 450X Chestnut St 9 1 1 4 4   3   Permit Number 37341 6009542.7178 2120879.1139 37.8040677578058 -122.411202572075 (37.8040677578058, -122.411202572075)
147766 100979 3 22 450X Chestnut St 11 1 1 4 4   6   Permit Number 37341 6009507.0071 2120874.2443 37.8040523843138 -122.411325807727 (37.8040523843138, -122.411325807727)
177834 100976 3 22 450X Chestnut St 8 1 1 4 4   5   Permit Number 37341 6009558.1383 2120880.7372 37.8040730797801 -122.411149322876 (37.8040730797801, -122.411149322876)
463 234072 3 26 1400 San Bruno Ave 2 1 1 4 4   4 Width 3ft   6011140.67766 2101759.7310900004 37.7516598624171 -122.404326151746 (37.7516598624171, -122.404326151746)
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)
3436 100973 3 26 450X Chestnut St 5 1 1 4 4   0   Permit Number 37341 6009614.0 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823)
28296 33101 3 26 450X Chestnut St 1 1 1 4 4 11/01/1997 12:00:00 AM 14   Permit Number 37341 6009682.3141 2120901.0273 37.804135754366996 -122.410721035819 (37.804135754367, -122.410721035819)
40243 100970 3 26 450X Chestnut St 2 1 1 4 4   9   Permit Number 37341 6009657.9659 2120896.9693 37.804123246932896 -122.41080500812201 (37.8041232469329, -122.410805008122)
59125 100975 3 26 450X Chestnut St 7 1 1 4 4   11   Permit Number 37341 6009580.8633 2120886.4184 37.8040899533369 -122.411071082632 (37.8040899533369, -122.411071082632)
64540 100974 3 26 450X Chestnut St 6 1 1 4 4   15   Permit Number 37341 6009596.2838 2120888.8532 37.8040975034287 -122.41101789076099 (37.8040975034287, -122.411017890761)
81591 95239 2 26 1220 Noe St 6 1 1 4 4   12     6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
83876 109990 2 26 501X Shotwell St 7 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
89691 109988 2 26 501X Shotwell St 5 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
92640 109986 2 26 501X Shotwell St 3 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
93134 98908 2 26 501X Shotwell St 2 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
95002 95237 2 26 1220 Noe St 4 1 1 4 4   9 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
95046 109987 2 26 501X Shotwell St 4 1 1 10 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
96184 102636 1 26 2176 Mission St 2 1 1 1 4 02/08/2013 12:00:00 AM 3 5x5 Permit Number 769974 6006850.0 2105688.0 37.7622052831774 -122.41944256138001 (37.7622052831774, -122.41944256138)
107934 95238 2 26 1220 Noe St 5 1 1 4 4     3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514)
Powered by Datasette · Query took 4.816ms · Data source: data.sfgov.org