sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
94067 91239 3 109 842x Guerrero St 1 28 1 2   11/20/1989 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
108835 113062 3 47 2X Cranleigh Dr 3 23 1 2   08/18/2016 09:59:00 AM 3     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664)
119367 113063 3 47 2X Cranleigh Dr 4 23 1 2   08/18/2016 09:56:00 AM 3     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664)
21240 95973 3 26 6100 Geary Blvd 2 22 1 2   03/12/2011 12:00:00 AM 1     5988036.984 2112655.97284 37.780259822750295 -122.48502007741101 (37.7802598227503, -122.485020077411)
22824 251112 9 100 1700X Quesada Ave 14 22 1 2                    
74201 103698 3 161 1306 Montgomery St 1 22 1 2     24     6011461.604719999 2119835.9957 37.8013110378213 -122.404488622371 (37.8013110378213, -122.404488622371)
78258 95981 3 26 6800 Geary Blvd 2 22 1 2   03/12/2011 12:00:00 AM 1     5985845.243869999 2112512.8777799997 37.7797390169842 -122.492591667736 (37.7797390169842, -122.492591667736)
79525 95976 3 26 6300 Geary Blvd 8 22 1 2   03/12/2011 12:00:00 AM 1     5987433.277530001 2112645.56538 37.7801960637602 -122.487107784765 (37.7801960637602, -122.487107784765)
80640 95966 3 26 5500 Geary Blvd 1 22 1 2   03/12/2011 12:00:00 AM 2     5989915.47138 2112737.13311 37.780591904899104 -122.478527531838 (37.7805919048991, -122.478527531838)
85995 95969 3 60 5600 Geary Blvd 4 22 1 2   03/12/2011 12:00:00 AM 2     5989606.68558 2112715.06065 37.7805133679778 -122.479594141591 (37.7805133679778, -122.479594141591)
87711 91236 3 109 804 Guerrero St 1 22 1 2   11/20/2009 12:00:00 AM 3 3x100   6005614.0 2104300.0 37.758324467407704 -122.423618732861 (37.7583244674077, -122.423618732861)
90310 95970 3 26 5700 Geary Blvd 2 22 1 2   03/12/2011 12:00:00 AM 1     5989285.66195 2112703.31658 37.780462469008896 -122.480703841334 (37.7804624690089, -122.480703841334)
92602 95971 3 60 5900 Geary Blvd 5 22 1 2   03/12/2011 12:00:00 AM 2     5988665.62185 2112680.2165599996 37.7803629858967 -122.482847132605 (37.7803629858967, -122.482847132605)
98676 95965 3 60 5400 Geary Blvd 1 22 1 2   03/12/2011 12:00:00 AM 2     5990210.87302 2112736.64328 37.7806077057511 -122.47750557201701 (37.7806077057511, -122.477505572017)
99563 95974 3 26 6100 Geary Blvd 13 22 1 2   03/12/2011 12:00:00 AM 1     5988036.984 2112655.97284 37.780259822750295 -122.48502007741101 (37.7802598227503, -122.485020077411)
100250 95977 3 26 6400 Geary Blvd 2 22 1 2   03/12/2011 12:00:00 AM 1     5987191.92688 2112582.17224 37.780007928322 -122.487938057094 (37.780007928322, -122.487938057094)
104582 95964 3 60 5200 Geary Blvd 6 22 1 2   03/12/2011 12:00:00 AM       5990756.89162 2112756.21837 37.780693122390204 -122.47561808245399 (37.7806931223902, -122.475618082454)
111342 95979 3 26 6500 Geary Blvd 6 22 1 2   03/12/2011 12:00:00 AM 1     5986883.76294 2112568.0929 37.779951289394205 -122.489003085019 (37.7799512893942, -122.489003085019)
114989 95975 3 26 6300 Geary Blvd 1 22 1 2   03/12/2011 12:00:00 AM 1     5987433.277530001 2112645.56538 37.7801960637602 -122.487107784765 (37.7801960637602, -122.487107784765)
119612 96804 3 35 1200X Revere Ave 1 22 1 2           6017205.4 2092876.1 37.7276042330013 -122.38273521775801 (37.7276042330013, -122.382735217758)
122416 95968 3 60 5600 Geary Blvd 2 22 1 2   03/12/2011 12:00:00 AM 2     5989606.68558 2112715.06065 37.7805133679778 -122.479594141591 (37.7805133679778, -122.479594141591)
117984 91210 3 91 333 Haight St 1 21 1 2   02/15/2008 12:00:00 AM 3     6004540.59043 2109422.99046 37.7723303224715 -122.427696060061 (37.7723303224715, -122.427696060061)
49960 105135 3 26 175X ESMERALDA AVE 1 19 1 2     26     6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
85853 114950 7 3 1X WOODACRE DR 2 19 1 2       30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
98700 105140 3 3 125X ESMERALDA AVE 1 19 1 2     12     6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
109114 105137 3 3 175X ESMERALDA AVE 3 19 1 2     18     6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
111345 114949 7 3 1X WOODACRE DR 1 19 1 2     30 30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502)
117494 107817 3 3 501X BROTHERHOOD WAY   19 1 2           5991892.0 2087849.0 37.712370053151204 -122.469877266524 (37.7123700531512, -122.469877266524)
128729 105136 3 38 175X ESMERALDA AVE 2 19 1 2           6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
139638 105139 3 3 175X ESMERALDA AVE 4 19 1 2     25     6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
143716 105138 3 3 175X ESMERALDA AVE 4 19 1 2     25     6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
3390 253422 3 143 2X Miraloma Dr 1 18 1 2       10x10   5994995.0 2097925.0 37.740215196600396 -122.459881864698 (37.7402151966004, -122.459881864698)
1320 251503 3 143 800X Bosworth St 15 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1324 251501 3 143 800X Bosworth St 13 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1326 251502 3 143 800X Bosworth St 14 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1335 251499 3 143 800X Bosworth St 11 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1341 251498 3 143 800X Bosworth St 10 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1348 251500 3 143 800X Bosworth St 12 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1875 251783 3 47 610 Clipper St 5 17 1 2       Width 2ft   6001275.75039 2100902.7174 37.7487505133321 -122.438378885672 (37.7487505133321, -122.438378885672)
1918 251819 3 159 298X Corbett Ave 1 17 1 2       3x3 Permit Number 778898 5999572.0 2105342.0 37.7608426398345 -122.444589445505 (37.7608426398345, -122.444589445505)
3586 253468 3 213 801X Alemany Blvd 1 17 1 2                    
9916 173733 3 47 14 Richland Ave 1 17 1 2       3x3   6004601.0 2096122.0 37.7358123337564 -122.426539816145 (37.7358123337564, -122.426539816145)
80765 121082 3 143 24X KEMPTON AVE 6 17 1 2       30x30   5992274.0 2087683.0 37.7119363308651 -122.46854490041599 (37.7119363308651, -122.468544900416)
88629 117549 3 40 24X KEMPTON AVE 3 17 1 2       30x30   5992274.0 2087683.0 37.7119363308651 -122.46854490041599 (37.7119363308651, -122.468544900416)
100045 120550 3 159 298x Corbett Ave 1 17 1 2     10   Permit Number 778898 5999572.0 2105342.0 37.7608426398345 -122.444589445505 (37.7608426398345, -122.444589445505)
112585 117548 3 40 24X KEMPTON AVE 2 17 1 2       30x30   5992274.0 2087683.0 37.7119363308651 -122.46854490041599 (37.7119363308651, -122.468544900416)
114561 114882 3 182 801x Alemany Blvd 1 17 1 2           6004188.833980001 2094500.26728 37.731336111506295 -122.42784931643499 (37.7313361115063, -122.427849316435)
120316 121151 3 3 1X Payson St 1 17 1 2     25 3x3   5992041.0 2087761.0 37.7121370380572 -122.469355880776 (37.7121370380572, -122.469355880776)
121639 117546 3 40 24X KEMPTON AVE 1 17 1 2       30x30   5992274.0 2087683.0 37.7119363308651 -122.46854490041599 (37.7119363308651, -122.468544900416)
126638 117550 3 40 24X KEMPTON AVE 4 17 1 2       30x30   5992274.0 2087683.0 37.7119363308651 -122.46854490041599 (37.7119363308651, -122.468544900416)
146070 121081 3 40 24X KEMPTON AVE 5 17 1 2       30x30   5992274.0 2087683.0 37.7119363308651 -122.46854490041599 (37.7119363308651, -122.468544900416)
1547 251582 3 3 691x Ulloa St 1 16 1 2       3x3   5994175.0 2098101.0 37.7406512558576 -122.462729837498 (37.7406512558576, -122.462729837498)
85764 115641 7 3 81x ELSIE ST 7 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
86412 115638 7 3 81x ELSIE ST 4 16 1 2     7 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
90360 115646 7 3 81x ELSIE ST 12 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
95069 115635 7 3 81x ELSIE ST 1 16 1 2     20 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
96699 115645 7 3 81x ELSIE ST 11 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
97160 115639 7 3 81x ELSIE ST 5 16 1 2     6 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
99755 115644 7 3 81x ELSIE ST 10 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
102527 115648 7 3 81x ELSIE ST 14 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
102675 115649 7 3 81x ELSIE ST 15 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
108009 115652 7 3 81x ELSIE ST 18 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
111875 115636 7 3 81x ELSIE ST 2 16 1 2     16 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
113407 115650 7 3 81x ELSIE ST 16 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
118558 115640 7 3 81x ELSIE ST 6 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
122253 115643 7 3 81x ELSIE ST 9 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
124724 115642 7 3 81x ELSIE ST 8 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
125004 115653 7 3 81x ELSIE ST 19 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
127152 115647 7 3 81x ELSIE ST 13 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
139401 115654 7 3 81x ELSIE ST 20 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
139921 115637 7 3 81x ELSIE ST 3 16 1 2     14 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
142076 115655 7 3 81x ELSIE ST 21 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
144101 115651 7 3 81x ELSIE ST 17 16 1 2       3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013)
3497 247942 4 58 29 Joy St 5 14 1 2     3   Permit Number 775404 6010292.72224 2098904.67919 37.7437730949632 -122.40705728398399 (37.7437730949632, -122.407057283984)
3501 247943 4 22 29 Joy St 6 14 1 2     2   Permit Number 775404 6010304.2598 2098903.51059 37.7437705318851 -122.407017307297 (37.7437705318851, -122.407017307297)
3506 247939 4 180 29 Joy St 2 14 1 2     12   Permit Number 775404 6010258.299769999 2098917.5156900003 37.7438064148349 -122.40717721395 (37.7438064148349, -122.40717721395)
3510 247941 4 58 29 Joy St 4 14 1 2     5   Permit Number 775404 6010287.82636 2098909.7574 37.743786764646 -122.40707457072901 (37.743786764646, -122.407074570729)
3511 247940 4 58 29 Joy St 3 14 1 2     5   Permit Number 775404 6010280.31746 2098909.2881400003 37.7437850559498 -122.407100501782 (37.7437850559498, -122.407100501782)
3513 247938 4 16 29 Joy St 1 14 1 2     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056)
4716 253674 3 225 600 x Sanchez St 2 14 1 2       3x3   6003598.0 2104743.0 37.75942683738779 -122.43062255590701 (37.7594268373878, -122.430622555907)
4727 253673 3 26 600 x Sanchez St 1 14 1 2       3x3   6003598.0 2104743.0 37.75942683738779 -122.43062255590701 (37.7594268373878, -122.430622555907)
5081 253792 2 1 1698X 08th Ave 2 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5085 253795 2 1 1698X 08th Ave 5 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5092 253791 2 1 1698X 08th Ave 1 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5097 253793 2 1 1698X 08th Ave 3 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5099 253794 2 1 1698X 08th Ave 4 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
19241 116677 3 58 100 Esmeralda Ave 16 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
42966 112248 3 158 1799X TAYLOR ST 1 14 1 2     15     6008739.0 2118839.0 37.79842100686071 -122.413839504702 (37.7984210068607, -122.413839504702)
69268 116648 3 193 199x Esmeralda Ave 3 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
77674 116662 3 3 199x Esmeralda Ave 15 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
78555 116671 3 28 100 Esmeralda Ave 7 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
79334 116646 3 193 199x Esmeralda Ave 1 14 1 2     2     6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
82247 116682 3 108 100 Esmeralda Ave 21 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
82496 116652 3 193 199x Esmeralda Ave 7 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
86166 116675 3 180 100 Esmeralda Ave 14 14 1 2     14     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
89602 116672 3 3 100 Esmeralda Ave 9 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
92156 116653 3 26 199x Esmeralda Ave 8 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
92622 116679 3 211 100 Esmeralda Ave 18 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
93306 116660 3 116 199x Esmeralda Ave 13 14 1 2     8     6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
94398 116654 3 38 199x Esmeralda Ave 9 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
94793 106979 3 506 801X Clipper St 1 14 1 2     24     5999765.50041 2100345.59515 37.7471347718267 -122.443561289165 (37.7471347718267, -122.443561289165)
Powered by Datasette · Query took 60.384ms · Data source: data.sfgov.org