sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
86 119601 6 34 4357x Mission St 3 7 1 1         Permit Number 774415          
272 251264 6 47 3630x 19th Ave 3 9 1 1         Permit Number 779147          
277 251265 6 47 3630x 19th Ave 4 9 1 1         Permit Number 779147          
293 251262 6 47 3630x 19th Ave 1 9 1 1         Permit Number 779147          
300 251263 6 47 3630x 19th Ave 2 9 1 1         Permit Number 779147          
363 119608 6 34 299x Avalon Ave 4 7 1 1                    
595 119606 6 1 299x Avalon Ave 2 7 1 1                    
2196 119600 6 34 4357x Mission St 2 7 1 1         Permit Number 774415          
4747 253677 6 71 199X Kissling St 1 18 1 1       5x10            
7681 103657 6 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7809 119599 6 34 4357x Mission St 1 7 1 1         Permit Number 774415          
7810 119607 6 3 299x Avalon Ave 3 7 1 1                    
7834 119605 6 47 299x Avalon Ave 1 7 1 1                    
8197 103668 6 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
9148 85030 6 17 411 Panama St 1 1 1 1   06/26/2007 12:00:00 AM     Permit Number 49384          
11212 103658 6 17 350X Hickory St 2 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          
16097 104813 6 60 1601X Portola Dr 5 7 1 1                    
22866 251139 6 17 621X Gough St 1 13 1 1   03/10/2017 12:00:00 AM 3   Permit Number 779685          
92048 111996 6 17 501 Point Lobos Ave   7 1 1   07/08/2015 12:00:00 AM 3 3x3 Permit Number 775626 5981249.6 2112592.5 37.779687857228296 -122.508495636007 (37.7796878572283, -122.508495636007)
126841 106972 6 17 464 46TH AVE 3 7 1 1   08/07/2014 12:00:00 AM     Permit Number 773827 5981646.2 2112608.0 37.7797537818913 -122.507124798545 (37.7797537818913, -122.507124798545)
143633 121087 6 1 1443 47th Ave 1 1 1 1       3x3 Permit Number 778784 5981521.320719999 2105258.5458 37.7595669638281 -122.507011468719 (37.7595669638281, -122.507011468719)
114664 102604 6 17 401 45th Ave 1 7 1 1   02/06/2013 12:00:00 AM     Permit Number 769720 5981859.7 2112893.4 37.7805499779863 -122.50640739196301 (37.7805499779863, -122.506407391963)
105512 105130 6 17 4045 MORAGA ST   9 1 1           5981665.2 2103465.9 37.7546533409301 -122.506380933635 (37.7546533409301, -122.506380933635)
90158 108211 6 19 524 45th Ave 2 7 1 1         Permit Number 773704 5981973.192319999 2112153.30127 37.778524566445206 -122.505959887315 (37.7785245664452, -122.505959887315)
143885 108210 6 19 524 45th Ave 1 7 1 1         Permit Number 773704 5981973.192319999 2112153.30127 37.778524566445206 -122.505959887315 (37.7785245664452, -122.505959887315)
82109 105208 6 1 2694 47TH AVE   7 1 1           5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
102950 105540 6 1 2694 47TH AVE 1 7 1 1     12     5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
98766 104736 6 48 1499X 44th Ave 1 7 1 1         Permit Number 770763 5982473.05016 2105245.16297 37.7595862228156 -122.50371897878901 (37.7595862228156, -122.503718978789)
4922 253717 6 105 4101 Balboa St 1 13 1 1           5982822.0 2110967.0 37.7753172554615 -122.50293574331002 (37.7753172554615, -122.50293574331)
120572 113234 6 21 2023 43RD AVE 1 7 1 1     12 3x3   5982877.0 2101339.0 37.748884737458795 -122.50203289923901 (37.7488847374588, -122.502032899239)
79360 112811 6 17 2023 43rd Ave 1 7 1 1           5982877.4 2101339.2 37.748885310102104 -122.502031530859 (37.7488853101021, -122.502031530859)
142384 106198 6 539 2101 42ND AVE 1 7 1 1     18     5983206.1 2100796.8 37.74741533456479 -122.500854798087 (37.7474153345648, -122.500854798087)
3534 253482 6 19 2179 41st Ave 1 7 1 1       3x5   5983532.0 2100331.0 37.74615550514321 -122.49969345420799 (37.7461555051432, -122.499693454208)
80217 92320 6 2 2733 Wawona St 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5984522.0 2096783.0 37.736471699686206 -122.49600850837099 (37.7364716996862, -122.496008508371)
122239 105434 6 49 4355 ANZA ST 1 13 1 1     10     5985110.8 2111730.2 37.7775470387472 -122.495074662501 (37.7775470387472, -122.495074662501)
13271 187638 6 47 875 El Camino Del Mar 2 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13275 187637 6 47 875 El Camino Del Mar 1 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
116206 103477 6 17 875 El Camino Del Mar 1 25 1 1   05/08/2013 12:00:00 AM     Permit Number 770113 5985641.7 2114972.5 37.7864805258078 -122.493477079739 (37.7864805258078, -122.493477079739)
104638 101202 6 17 7070 California St 1 25 1 1   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
110409 98703 6 47 7070@ 32nd Ave California St 4 25 1 1   03/10/2012 12:00:00 AM     Permit Number 767466 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
122098 101203 6 17 7070 California St 2 25 1 1   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
82542 108215 6 3 865 EL CAMINO DEL MAR 1 7 1 1           5985761.0 2114995.0 37.7865492821054 -122.49306599544501 (37.7865492821054, -122.493065995445)
107759 120952 6 17 100X 32nd Ave 1 2 1 1   08/30/2016 12:00:00 AM 3 10x10 Permit Number 778529 5985781.0 2114962.0 37.7864598433405 -122.492994369609 (37.7864598433405, -122.492994369609)
86608 85093 6 17 100 32nd Ave 2 7 1 1   12/18/2009 12:00:00 AM     Permit Number 53112 5985781.7 2114962.8 37.786462080845396 -122.49299200677 (37.7864620808454, -122.49299200677)
144783 92909 6 17 100 32nd Ave 1 7 1 1   12/18/2009 12:00:00 AM 11   Permit Number 53112 5985781.7 2114962.8 37.786462080845396 -122.49299200677 (37.7864620808454, -122.49299200677)
125647 85060 6 47 7070 California St 1 8 1 1   07/03/2007 12:00:00 AM     Permit Number 49405 5985878.0 2113896.0 37.7835385880022 -122.49258024231199 (37.7835385880022, -122.492580242312)
87085 113937 6 3 800 EL CAMINO DEL MAR 1 7 1 1     35     5985966.0 2115003.0 37.7865832348262 -122.49235734524099 (37.7865832348262, -122.492357345241)
98898 117252 6 143 2500x 34TH AVE 2 17 1 4       3x3   5985829.0 2097874.0 37.73954376030179 -122.491570003273 (37.7395437603018, -122.491570003273)
112260 117251 6 143 2500x 34TH AVE 1 17 1 4       3x3   5985829.0 2097874.0 37.73954376030179 -122.491570003273 (37.7395437603018, -122.491570003273)
142324 117253 6 143 2500x 34TH AVE 3 17 1 4       3x3   5985829.0 2097874.0 37.73954376030179 -122.491570003273 (37.7395437603018, -122.491570003273)
12363 92312 6 12 2711 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985822.132 2096946.3119 37.7369961745626 -122.49152548244 (37.7369961745626, -122.49152548244)
96595 106311 6 71 99X Clearfield Dr 5 9 1 1   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.4648400003 37.73289581695511 -122.49149816384899 (37.7328958169551, -122.491498163849)
142007 106310 6 71 99X Clearfield Dr 4 9 1 1   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.4648400003 37.73289581695511 -122.49149816384899 (37.7328958169551, -122.491498163849)
10899 92314 6 35 2783 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985837.7861 2096464.2212 37.7356733962807 -122.491435886509 (37.7356733962807, -122.491435886509)
10597 92315 6 35 2783 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985839.9086 2096474.3035 37.73570120363421 -122.491429290175 (37.7357012036342, -122.491429290175)
13114 92316 6 35 2787 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985840.4393 2096424.4229 37.7355642757438 -122.49142378511002 (37.7355642757438, -122.49142378511)
12690 92317 6 35 2787 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985840.9699 2096433.9745 37.7355905329114 -122.491422653463 (37.7355905329114, -122.491422653463)
12500 92318 6 35 2787 34th Ave 3 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985842.0312 2096446.1793 37.7356241060746 -122.49141988222999 (37.7356241060746, -122.49141988223)
10790 80073 6 35 2788 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3     5985889.2586 2096432.3825 37.735588983385 -122.49125558617901 (37.735588983385, -122.491255586179)
10461 92319 6 35 2788 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985889.2586 2096423.8922 37.7355656712712 -122.491254961509 (37.7355656712712, -122.491254961509)
108780 92311 6 18 2211 33rd Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5986022.3 2100155.2 37.7458186185696 -122.491069496457 (37.7458186185696, -122.491069496457)
97466 102302 6 17 740X 31st Ave 1 7 1 1   01/14/2013 12:00:00 AM     Permit Number 769784 5986476.3 2110809.8 37.7750997269751 -122.490283282468 (37.7750997269751, -122.490283282468)
9683 173631 6 47 99X Everglade Dr 1 5 1 1       3x3   5986361.0 2095495.0 37.733042731061104 -122.48955570953301 (37.7330427310611, -122.489555709533)
99818 105907 6 105 1837 30TH AVE 1 7 1 1     6     5986904.0 2102674.0 37.752786039312795 -122.488205804709 (37.7527860393128, -122.488205804709)
11570 174950 6 2 309 Crestlake Dr 1 1 1 1       3x3   5987294.0 2096147.0 37.7348873783654 -122.486377975564 (37.7348873783654, -122.486377975564)
90926 114099 6 85 201x VIDAL DR 1 1 1 1     14     5987665.0 2090646.0 37.719804665893605 -122.484691919383 (37.7198046658936, -122.484691919383)
94574 114097 6 306 221x VIDAL DR 1 7 1 1     14     5987664.0 2090556.0 37.7195574904968 -122.484688777519 (37.7195574904968, -122.484688777519)
88441 114094 6 55 239x VIDAL DR 1 7 1 1     24     5987668.0 2090475.0 37.7193353179991 -122.484669012602 (37.7193353179991, -122.484669012602)
83993 114406 6 203 500X ARBALLO DR 3 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
93266 114407 6 177 500X ARBALLO DR 4 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
107939 114408 6 203 500X ARBALLO DR 5 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
109893 114409 6 103 500X ARBALLO DR 6 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
112205 114404 6 203 500X ARBALLO DR 1 1 1 1     24 3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
138618 114405 6 203 500X ARBALLO DR 2 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
95902 96835 6 60 6001 Geary Blvd 1 8 1 1           5988352.4 2112527.1 37.779924341439 -122.483919468894 (37.779924341439, -122.483919468894)
9948 114067 6 62 6 Higuera Ave 1 8 1 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
113595 114068 6 62 8 HIGUERA AVE 1 7 1 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
84582 114072 6 21 454 ARBALLO DR 1 2 1 1     4     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
86962 114103 6 62 5 ACEVEDO AVE 2 7 1 1     15     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
103750 114102 6 62 7 ACEVEDO AVE 1 7 1 1     18     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
81453 114249 6 40 499x 24TH AVE 1 5 1 1       3x3   5988415.0 2112957.0 37.78110836988721 -122.483734439284 (37.7811083698872, -122.483734439284)
58967 96572 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
80235 96569 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
81160 96570 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
86907 96483 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
97749 96481 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
99207 96568 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
101102 96484 6 180 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
103034 96485 6 180 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
109217 96482 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
113578 96571 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
124197 96567 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
138508 96480 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
104403 114100 6 146 21x ACEVEDO AVE 1 7 1 1     10     5988027.0 2090598.0 37.7196939458216 -122.48343711113998 (37.7196939458216, -122.48343711114)
118949 114101 6 146 21x ACEVEDO AVE 2 7 1 1     7     5988027.0 2090598.0 37.7196939458216 -122.48343711113998 (37.7196939458216, -122.48343711114)
91565 114074 6 146 18x HIGUERA AVE 2 2 1 1     5     5988029.0 2090212.0 37.718634203797706 -122.483401916227 (37.7186342037977, -122.483401916227)
119334 114073 6 146 18x HIGUERA AVE 1 2 1 1     6     5988029.0 2090212.0 37.718634203797706 -122.483401916227 (37.7186342037977, -122.483401916227)
144120 114104 6 85 400x ARBALLO DR 1 7 1 1     12 3x3   5988116.0 2090625.0 37.7197732605649 -122.48313145165001 (37.7197732605649, -122.48313145165)
Powered by Datasette · Query took 7.496ms · Data source: data.sfgov.org