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)
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)
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)
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)
49605 87302 3 44 2323 Cesar Chavez St 4 16 1 1     1   Permit Number 50312 6011942.20762 2100900.73993 37.7493460165275 -122.401493976188 (37.7493460165275, -122.401493976188)
118995 97217 3 36 300X Claremont Blvd 4 16 1 10     18     5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
143072 97216 3 36 300X Claremont Blvd 3 16 1 10           5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
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)
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)
95215 116655 3 38 199x Esmeralda Ave 9 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
95360 116668 3 129 100x Esmeralda Ave 4 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
95391 113478 3 38 100x ESMERALDA AVE 5 14 1 2     8     6006917.0 2098966.0 37.7437519821991 -122.418734104398 (37.7437519821991, -122.418734104398)
95944 116681 3 38 100 Esmeralda Ave 20 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
97063 116666 3 3 100x Esmeralda Ave 2 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
101447 116661 3 3 199x Esmeralda Ave 14 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
105354 116656 3 3 199x Esmeralda Ave 10 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
105412 116658 3 3 199x Esmeralda Ave 12 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
110832 116665 3 3 100x Esmeralda Ave 1 14 1 2     25     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
112048 116664 3 42 199x Esmeralda Ave 18 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
112164 116647 3 193 199x Esmeralda Ave 2 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
112606 105901 3 103 11X ELLIOT ST 2 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
113837 116669 3 47 100 Esmeralda Ave 6 14 1 2     20     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
118788 116651 3 193 199x Esmeralda Ave 6 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
122561 105900 3 103 11X ELLIOT ST 1 14 1 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
123372 116663 3 154 199x Esmeralda Ave 16 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
123800 116680 3 132 100 Esmeralda Ave 19 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
126736 116670 3 180 100 Esmeralda Ave 8 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
127057 116678 3 58 100 Esmeralda Ave 17 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
129308 116650 3 193 199x Esmeralda Ave 5 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
138343 105902 3 103 11X ELLIOT ST 3 14 1 2     40     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
138825 116683 3 108 100 Esmeralda Ave 22 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
139190 116659 3 3 199x Esmeralda Ave 12 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
143384 116676 3 338 100 Esmeralda Ave 15 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
144028 113477 3 3 100x Esmeralda Ave 10 14 1 2     24     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
144190 116667 3 129 100x Esmeralda Ave 3 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
145384 116657 3 3 199x Esmeralda Ave 11 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
145521 116649 3 193 199x Esmeralda Ave 4 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
3750 253551 3 41 1000 Cayuga Ave 19 13 1 2   09/22/2017 04:40:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3754 253538 3 37 1000 Cayuga Ave 6 13 1 2   09/22/2017 02:43:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3755 253535 3 77 1000 Cayuga Ave 3 13 1 2   09/22/2017 02:31:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3758 253548 3 41 1000 Cayuga Ave 16 13 1 2   09/22/2017 04:31:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
Powered by Datasette · Query took 60.237ms · Data source: data.sfgov.org