sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
14162 85622 3 82 1360 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016552.9396 2093696.0654 37.729819627930105 -122.385047906896 (37.7298196279301, -122.385047906896)
13407 16508 3 82 325 Newhall St 10 1 1 2     12 3x3   6016639.93914 2098306.03692 37.7424824967653 -122.385068203435 (37.7424824967653, -122.385068203435)
173068 197158 2 82 106 Whitney Young Cir 6 1 1 1     2 Width 3ft   6016583.16711 2095682.22839 37.7352749081106 -122.385081735533 (37.7352749081106, -122.385081735533)
15196 85648 3 82 1357 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016534.0204 2093632.0271 37.7296427448929 -122.38510885322701 (37.7296427448929, -122.385108853227)
45950 197160 2 82 11 Mabrey Ct 2 1 1 1     3 Width 3ft   6016488.26571 2095902.24457 37.7358737783612 -122.385425174944 (37.7358737783612, -122.385425174944)
129195 16492 1 82 305X Newhall St 3 1 1 1   12/03/1992 12:00:00 AM 3 3X3   6016524.668196499 2098330.497802 37.7425432844059 -122.385468484111 (37.7425432844059, -122.385468484111)
13543 13319 1 82 14 Mabrey Ct 1 1 1 1   09/09/1992 12:00:00 AM 7 3X3   6016463.59576 2095940.9292900001 37.7359786339072 -122.385513164614 (37.7359786339072, -122.385513164614)
41586 197159 2 82 122 Whitney Young Cir 5 1 1 1     1 Width 3ft   6016446.71962 2095806.9526900002 37.7356098273254 -122.385562178561 (37.7356098273254, -122.385562178561)
93327 112843 2 82 1415 EVANS AVE 1 7 1 1           6016481.0 2097724.0 37.7408755487739 -122.385577218432 (37.7408755487739, -122.385577218432)
54847 197162 2 82 123 Whitney Young Cir 6 1 1 1     2 Width 3ft   6016438.8167 2095743.2053 37.735434352517 -122.385585060917 (37.735434352517, -122.385585060917)
97965 24186 3 82 55X Whitney Young Cir 2 1 1 2   03/11/2006 12:00:00 AM 3 4x3   6016412.1769872 2096105.6107163997 37.736427970914 -122.38570241578998 (37.736427970914, -122.38570241579)
98467 24177 3 82 95X Whitney Young Cir 10 1 1 2   03/11/2006 12:00:00 AM 4 3X3   6016412.1769872 2096105.6107163997 37.736427970914 -122.38570241578998 (37.736427970914, -122.38570241579)
105931 24194 3 82 55X Whitney Young Cir 10 1 1 2   01/01/2008 12:00:00 AM 3 3x3   6016412.1769872 2096105.6107163997 37.736427970914 -122.38570241578998 (37.736427970914, -122.38570241579)
106905 24171 3 82 95X Whitney Young Cir 4 1 1 2   03/11/2006 12:00:00 AM 3 3x3   6016412.1769872 2096105.6107163997 37.736427970914 -122.38570241578998 (37.736427970914, -122.38570241579)
9255 24072 1 82 161X Whitney Young Cir 2 1 1 1   03/11/2006 12:00:00 AM 3 3X3   6016395.7853594 2095946.5828375 37.735990405317004 -122.385748008424 (37.735990405317, -122.385748008424)
9055 24107 1 82 105X Whitney Young Cir 14 1 1 1   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.0813580002 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885)
9206 24109 1 82 105X Whitney Young Cir 16 1 1 1   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.0813580002 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885)
103685 24094 3 82 105X Whitney Young Cir 1 1 1 2   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.0813580002 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885)
109191 24106 3 82 105X Whitney Young Cir 13 1 1 2   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.0813580002 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885)
139566 24098 3 82 105X Whitney Young Cir 5 1 1 2   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.0813580002 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885)
15931 85649 3 82 1399 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016350.3286 2093764.5437 37.7299964462298 -122.385753133703 (37.7299964462298, -122.385753133703)
9107 24086 1 82 141X Whitney Young Cir 8 1 1 1   03/11/2006 12:00:00 AM 3 3X3   6016393.5495733 2095983.6738742 37.7360921261264 -122.38575832291299 (37.7360921261264, -122.385758322913)
137452 197161 2 82 130 Whitney Young Cir 2 1 1 1     2 Width 3ft   6016392.6723 2096037.13258 37.7362388644345 -122.38576508091299 (37.7362388644345, -122.385765080913)
93857 8232 3 82 1500X Galvez Ave 11 1 1 2   11/13/1992 12:00:00 AM 6 3x3   6016396.247314 2097296.3974116 37.739696749128896 -122.385840466933 (37.7396967491289, -122.385840466933)
80405 16518 3 82 330 Newhall St 9 1 1 2   03/30/2006 12:00:00 AM 3 3X3   6016409.970087901 2098376.06541 37.742662057146795 -122.385868255606 (37.7426620571468, -122.385868255606)
9197 24149 1 82 100X Whitney Young Cir 9 1 1 1   03/11/2006 12:00:00 AM 3 3x3   6016357.373923 2096088.8828188 37.736379006835996 -122.385890729183 (37.736379006836, -122.385890729183)
9227 24151 1 82 100X Whitney Young Cir 11 1 1 1   03/11/2006 12:00:00 AM 3 3x3   6016357.373923 2096088.8828188 37.736379006835996 -122.385890729183 (37.736379006836, -122.385890729183)
9464 24167 1 82 110X Whitney Young Cir 18 1 1 1   01/01/2011 12:00:00 AM 2 3x3   6016346.0952597 2096044.1423308998 37.736255534298 -122.38592660691401 (37.736255534298, -122.385926606914)
9104 24127 1 82 140X Whitney Young Cir 6 1 1 1   03/11/2006 12:00:00 AM 3 3X3   6016343.6401634 2095980.6654178002 37.736081103602096 -122.38593067194799 (37.7360811036021, -122.385930671948)
14888 24090 1 82 125X Whitney Young Cir 2 1 1 1   05/07/1997 12:00:00 AM 6 3x3   6016342.364159999 2095991.2568 37.736110114791 -122.3859358217 (37.736110114791, -122.3859358217)
15934 85623 3 82 1404 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016275.7207 2093898.407 37.7303598794973 -122.38602039250401 (37.7303598794973, -122.386020392504)
14222 16526 1 82 375 Newhall St 6 1 1 1   12/03/1992 12:00:00 AM 3 3X3   6016351.58796 2098272.95822 37.7423757148758 -122.386062939968 (37.7423757148758, -122.386062939968)
15360 85624 3 82 1422 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016199.7661 2093954.969 37.7305109836044 -122.38628692243 (37.7305109836044, -122.38628692243)
14774 85650 3 82 1419 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016182.7975 2093891.6734 37.730336247224706 -122.386341174586 (37.7303362472247, -122.386341174586)
125432 8257 3 82 1525 GALVEZ AVE 4 1 1 2   11/13/1992 12:00:00 AM 6 3x3   6016246.0 2097351.0 37.739838361172204 -122.38636376878901 (37.7398383611722, -122.386363768789)
83796 85625 3 82 1430 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016164.799973001 2093969.832807 37.730549861172705 -122.38640884249901 (37.7305498611727, -122.386408842499)
162145 60407 1 82 1430 Quesada Ave 1 1 1 1 1 01/22/1983 12:00:00 AM 6   Permit Number 19988 6016156.6712 2093985.1354 37.7305914290757 -122.38643801167801 (37.7305914290757, -122.386438011678)
32020 197170 2 82 1440 Galvez Ave 1 1 1 1     4 Width 3ft   6016200.17093 2097456.77974 37.740126273917 -122.386529601766 (37.740126273917, -122.386529601766)
130064 52155 1 82 1431 Quesada Ave 1 1 1 1 1 10/31/2005 12:00:00 AM 8   Permit Number 48347 6016125.1581 2093936.3843 37.7304558237734 -122.386543560163 (37.7304558237734, -122.386543560163)
30146 44337 1 82 1386 Palou Ave 1 1 1 1   03/06/2001 12:00:00 AM 10   Permit Number 43722 6016111.020719999 2094370.93672 37.7316482354559 -122.386622725671 (37.7316482354559, -122.386622725671)
130726 60409 1 82 1448 Quesada Ave 1 1 1 1   07/09/2009 12:00:00 AM 5 3x3 Permit Number 52503 6016089.8742 2094040.62 37.73074008090121 -122.38667280863399 (37.7307400809012, -122.386672808634)
16109 85626 3 82 1454 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016038.1604 2094077.7893 37.7308392772335 -122.38685418415001 (37.7308392772335, -122.38685418415)
15644 16542 1 82 400X Newhall St 3 1 1 1     6 3x3   6016097.47551 2098025.0219 37.741680865376 -122.386924304309 (37.741680865376, -122.386924304309)
66105 98309 6 82 401X Newhall St 1 25 1 1     6 3x3   6016081.14502 2097910.9401599998 37.741366715992896 -122.386972815546 (37.7413667159929, -122.386972815546)
16831 16544 3 82 400X Newhall St 5 1 1 2     12 3x3   6016074.6462900005 2097992.47705 37.7415902397879 -122.38700097152399 (37.7415902397879, -122.387000971524)
87673 6645 3 82 495X Newhall St 1 1 1 2   12/16/1992 12:00:00 AM 6 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472)
14960 85627 3 82 1466 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015977.8277 2094121.4228 37.730955745426606 -122.387065808076 (37.7309557454266, -122.387065808076)
13396 85628 3 82 1470 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015957.8963 2094137.5833 37.730999015226104 -122.387135841638 (37.7309990152261, -122.387135841638)
15649 85651 3 82 1467 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015942.8131 2094070.7863 37.730814768733396 -122.387183329829 (37.7308147687334, -122.387183329829)
78120 16551 1 82 500X Newhall St 2 1 1 1   03/12/1998 12:00:00 AM 3 3x3   6016006.287148001 2097894.9109735 37.74131855784729 -122.387230532448 (37.7413185578473, -122.387230532448)
85261 16550 3 82 500X Newhall St 1 1 1 2   03/12/1998 12:00:00 AM 3 3x3   6016006.287148001 2097894.9109735 37.74131855784729 -122.387230532448 (37.7413185578473, -122.387230532448)
89430 16558 3 82 500X Newhall St 9 1 1 2   12/27/1997 12:00:00 AM 3 3x3   6016006.287148001 2097894.9109735 37.74131855784729 -122.387230532448 (37.7413185578473, -122.387230532448)
99184 16557 1 82 500X Newhall St 8 1 1 1   12/23/1997 12:00:00 AM 3 3x3   6016006.287148001 2097894.9109735 37.74131855784729 -122.387230532448 (37.7413185578473, -122.387230532448)
14570 16549 1 82 400X Newhall St 10 1 1 1     6 3x3   6015994.10911 2097882.11034 37.7412827355083 -122.38727174751001 (37.7412827355083, -122.38727174751)
165428 197129 2 82 400 Newhall St 11 4 1 1     5 Width 3ft   6015974.4503 2097856.83037 37.741212233148495 -122.387337958305 (37.7412122331485, -122.387337958305)
16542 6847 1 82 595X Newhall St 4 1 1 1   12/11/2002 12:00:00 AM 3 3x3   6015962.97666 2097752.7883599997 37.7409259196071 -122.38737037433701 (37.7409259196071, -122.387370374337)
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)
14424 6845 1 82 595X Newhall St 2 1 1 1   12/16/1992 12:00:00 AM 6 3x3   6015936.9719 2097716.00593 37.7408234823092 -122.38745772460899 (37.7408234823092, -122.387457724609)
111278 85629 3 82 1490 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015857.0244309995 2094199.26405 37.7311627918046 -122.38748887723801 (37.7311627918046, -122.387488877238)
140091 88478 1 82 1514 McKinnon Ave   1 1 1   07/18/2008 12:00:00 AM   3x3 Permit Number 51430 6015856.3 2095628.5 37.7350871465747 -122.387591057509 (37.7350871465747, -122.387591057509)
73028 197130 2 82 400 Newhall St 16 4 1 1     5 Width 3ft   6015893.1870800005 2097747.64492 37.7409079313583 -122.38761132431299 (37.7409079313583, -122.387611324313)
56408 197131 2 82 400 Newhall St 17 4 1 1     5 Width 3ft   6015885.54456 2097735.3383299997 37.740873716654 -122.38763689115 (37.740873716654, -122.38763689115)
14632 85652 3 82 1519 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015655.7374 2094284.1377 37.7313846871586 -122.388190689138 (37.7313846871586, -122.388190689138)
15814 85630 3 82 1518 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015608.4708 2094395.709 37.7316884205401 -122.388361884277 (37.7316884205401, -122.388361884277)
74292 54817 1 82 1414 Underwood Ave 1 1 1 1   12/06/2007 12:00:00 AM 5 3x3 Permit Number 49953 6015568.3491 2093032.3958 37.7279428116622 -122.388405474303 (37.7279428116622, -122.388405474303)
14120 85653 3 82 1541 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015555.708 2094360.5338 37.731588912651404 -122.388541843069 (37.7315889126514, -122.388541843069)
14937 16560 3 82 702X Newhall St 2 1 1 2   12/03/1992 12:00:00 AM 12 3X3   6015615.61867 2097370.07413 37.7398558207833 -122.38854471268299 (37.7398558207833, -122.388544712683)
15981 16561 1 82 702X Newhall St 3 1 1 1   03/11/2006 12:00:00 AM 3 3X3   6015590.528940001 2097333.28077 37.739753403296206 -122.388628895503 (37.7397534032962, -122.388628895503)
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)
49629 88476 1 82 1531 Kirkwood Ave 1 1 1 1   07/18/2008 12:00:00 AM   3x3 Permit Number 51429 6015551.7 2096433.9 37.7372817351758 -122.38870038321801 (37.7372817351758, -122.388700383218)
39723 73566 1 82 1531 Kirkwood Ave 1 1 1 1   06/24/2008 12:00:00 AM 4 3x3 Permit Number 51073 6015551.1974 2096459.91912 37.737353150531504 -122.388703936761 (37.7373531505315, -122.388703936761)
145935 85631 3 82 1556 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015497.489333999 2094466.5036189999 37.7318766579731 -122.38875051314301 (37.7318766579731, -122.388750513143)
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)
3820 193326 2 82 1398 Tennessee St 3 1 1 1     1 Width 5ft   6015584.3745800005 2102621.5534900003 37.754273559383 -122.389019303814 (37.754273559383, -122.389019303814)
3810 193325 2 82 1398 Tennessee St 2 1 1 1     1 Width 5ft   6015584.15702 2102639.39931 37.754322548171395 -122.389021302106 (37.7543225481714, -122.389021302106)
3814 193324 2 82 1398 Tennessee St 1 1 1 1     1 Width 5ft   6015583.67362 2102658.4010900003 37.7543746962452 -122.38902430045499 (37.7543746962452, -122.389024300455)
3825 253557 2 82 1398 Tennessee St 5 1 1 1       Width 5ft   6015583.67362 2102658.4010900003 37.7543746962452 -122.38902430045499 (37.7543746962452, -122.389024300455)
14505 85632 3 82 1582 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015365.5421 2094575.4322 37.7321684400373 -122.38921428964 (37.7321684400373, -122.38921428964)
27916 197079 2 82 690 18th St 1 1 1 1     6 Width 4ft   6015561.72583 2105828.91514 37.763079033783605 -122.389321587544 (37.7630790337836, -122.389321587544)
122012 197080 2 82 690 18th St 2 1 1 1     5 Width 4ft   6015550.01358 2105828.2198099997 37.7630764752211 -122.389362048039 (37.7630764752211, -122.389362048039)
16244 85633 3 82 1590 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015320.4739 2094608.4089 37.732256488847106 -122.38937240380899 (37.7322564888471, -122.389372403809)
68096 200038 2 82 1598 Lane St 1 1 1 1     5 Width 0ft   6015316.6267 2094740.3159 37.7326184655785 -122.38939491276501 (37.7326184655785, -122.389394912765)
29178 197081 2 82 690 18th St 3 1 1 1     5 Width 4ft   6015537.3565 2105827.07749 37.7630726369229 -122.389405745189 (37.7630726369229, -122.389405745189)
84861 53148 1 82 1499@ LANE Thomas Ave 2 1 1 1   11/02/2006 12:00:00 AM     Permit Number 49076 6015286.17606683 2093519.24782482 37.7292639697355 -122.389414946979 (37.7292639697355, -122.389414946979)
126794 53150 1 82 1499@ LANE Thomas Ave 1 1 1 1   11/02/2006 12:00:00 AM     Permit Number 49076 6015286.17606683 2093519.24782482 37.7292639697355 -122.389414946979 (37.7292639697355, -122.389414946979)
169613 200039 2 82 1598 Lane St 2 1 1 1     1 Width 0ft   6015308.9321 2094726.0259999998 37.7325788017835 -122.38942051753 (37.7325788017835, -122.38942051753)
71612 197082 2 82 690 18th St 4 1 1 1     5 Width 4ft   6015524.49345 2105827.33722 37.7630726369153 -122.38945025263901 (37.7630726369153, -122.389450252639)
178628 200040 2 82 1598 Lane St 3 1 1 1     1 Width 0ft   6015299.5887 2094715.0337 37.732548101110794 -122.389452052823 (37.7325481011108, -122.389452052823)
119496 199666 2 82 1901 Keith St 2 1 1 1     5 Width 0ft   6015268.2608 2093490.7724 37.72918478862329 -122.389474894337 (37.7291847886233, -122.389474894337)
153566 200041 2 82 1598 Lane St 4 1 1 1     1 Width 0ft   6015290.2453 2094700.1942 37.73250683679421 -122.389483319509 (37.7325068367942, -122.389483319509)
157622 200042 2 82 1598 Lane St 5 1 1 1     4 Width 0ft   6015283.1003 2094689.2019 37.7324762579969 -122.389507254289 (37.7324762579969, -122.389507254289)
150852 197141 2 82 502 Beale St 2 1 1 1     8 Width 6ft   6015667.2078 2114177.54158 37.786008361852396 -122.38953984758801 (37.7860083618524, -122.389539847588)
175783 200043 2 82 1598 Lane St 6 1 1 1     2 Width 0ft   6015271.0088 2094675.4616 37.732437859472796 -122.38954809856399 (37.7324378594728, -122.389548098564)
71297 199665 2 82 1901 Keith St 1 1 1 1     5 Width 0ft   6015244.0778 2093456.6965 37.729089882168395 -122.389556118834 (37.7290898821684, -122.389556118834)
98703 88464 1 82 955X Newhall St 2 1 1 1   07/11/2008 12:00:00 AM 4 3x3 Permit Number 51410 6015306.946426 2096847.395831 37.7384035424873 -122.389575486471 (37.7384035424873, -122.389575486471)
116084 88466 1 82 955X Newhall St 4 1 1 1 1 07/11/2008 12:00:00 AM 4 3x3 Permit Number 51410 6015306.946426 2096847.395831 37.7384035424873 -122.389575486471 (37.7384035424873, -122.389575486471)
84924 88489 1 82 1600 Quesada Ave 3 1 1 1   07/18/2008 12:00:00 AM   3x3 Permit Number 51434 6015245.7 2094684.2 37.732460450023495 -122.38963620788401 (37.7324604500235, -122.389636207884)
87921 88492 1 82 1600 Quesada Ave 6 1 1 1   07/18/2008 12:00:00 AM   3x3 Permit Number 51434 6015245.7 2094684.2 37.732460450023495 -122.38963620788401 (37.7324604500235, -122.389636207884)
90200 88490 1 82 1600 Quesada Ave 4 1 1 1   07/18/2008 12:00:00 AM   3x3 Permit Number 51434 6015245.7 2094684.2 37.732460450023495 -122.38963620788401 (37.7324604500235, -122.389636207884)
111056 88488 1 82 1600 Quesada Ave 2 1 1 1   07/18/2008 12:00:00 AM   3x3 Permit Number 51434 6015245.7 2094684.2 37.732460450023495 -122.38963620788401 (37.7324604500235, -122.389636207884)
117423 88487 1 82 1600 Quesada Ave 1 1 1 1   07/18/2008 12:00:00 AM   3x3 Permit Number 51434 6015245.7 2094684.2 37.732460450023495 -122.38963620788401 (37.7324604500235, -122.389636207884)
Powered by Datasette · Query took 24.663ms · Data source: data.sfgov.org