sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
999 251422 2 47 480x De Long St   7 1 1       3x3   5992963.0 2086633.0 37.709093057147996 -122.466087289133 (37.709093057148, -122.466087289133)
2126 252903 2 64 215 Capistrano Ave   7 1 1       3x3   6001180.0 2093207.0 37.727614424830705 -122.438158778943 (37.7276144248307, -122.438158778943)
3851 252871 2 5 2557 Sutter St   7 1 1       3x3   5999847.0 2113975.0 37.7845623594454 -122.444258736096 (37.7845623594454, -122.444258736096)
12440 100166 7 218 2340 Twin Peaks Blvd   7 1 1         Permit Number 769026          
16457 93053 1 105     7 1 1   04/28/2010 12:00:00 AM 36   Permit Number 53387          
19350 95161 6 175 2721 Pacific Ave   7 1 1         Permit Number 54078 6001026.7 2116843.3 37.7925052022591 -122.440383162252 (37.7925052022591, -122.440383162252)
19781 96412 6 175 185 Chilton Ave   7 1 1   05/18/2011 12:00:00 AM     Permit Number 767805 6001587.1 2095138.7 37.732941575251004 -122.436889661497 (37.732941575251, -122.436889661497)
47993 105254 2 2 130 GONZALEZ DR   7 1 1     2     5990327.0 2090136.0 37.7185590045312 -122.47545320091999 (37.7185590045312, -122.47545320092)
50166 95953 6 17 499 Buena Vista East Ave   7 1 1   03/18/2011 12:00:00 AM 21   Permit Number 57015 6000177.0 2107098.0 37.7656986843565 -122.442623109531 (37.7656986843565, -122.442623109531)
54776 95300 6 11 701 Golden Gate Ave   7 1 1   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617005 -122.422419858646 (37.780652317617, -122.422419858646)
74398 97290 7 3 55 Hiliritas Ave   7 1 1         Permit Number 778896 6001461.7 2096833.2 37.7375871516219 -122.437444499981 (37.7375871516219, -122.437444499981)
77391 92760 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
77551 116996 2 143 606x FULTON ST   7 1 1   09/29/2016 12:00:00 AM 3     6004628.0 2111737.0 37.7786889706302 -122.42755859051901 (37.7786889706302, -122.427558590519)
77818 108026 6 116 862 Kansas St   7 1 1         Permit Number 774734 6011570.0 2104296.0 37.758647879927395 -122.403019866682 (37.7586478799274, -122.403019866682)
78391 108038 6 3 1 Twin Peaks Blvd   7 1 1           5998985.485719999 2105240.3128 37.760529947122706 -122.446610614338 (37.7605299471227, -122.446610614338)
78407 92764 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
78970 106970 2 17 30 Piedmont St   7 1 1   07/11/2014 12:00:00 AM     Permit Number 772781 5999571.08265 2107127.2788400003 37.76574451836729 -122.444720943629 (37.7657445183673, -122.444720943629)
80420 105844 6 17 355 Buena Vista Ave   7 1 1   03/03/2014 12:00:00 AM     Permit Number 771052 6000886.5 2107736.6 37.767492540377 -122.44021490806801 (37.767492540377, -122.440214908068)
81073 101977 7 129 601 Grand View Ave   7 1 1           6000076.2 2101609.9 37.750623962991796 -122.44257767940901 (37.7506239629918, -122.442577679409)
81598 94690 7 329 749 Congo St   7 1 1   10/28/2010 12:00:00 AM     Permit Number 53820 6000274.0 2096023.0 37.735294937499 -122.441492809367 (37.735294937499, -122.441492809367)
81688 93931 6 105     7 1 1   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.5528400003 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841)
81710 104892 6 62 201 Gonzalez Dr   7 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
82109 105208 6 1 2694 47TH AVE   7 1 1           5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
82826 92763 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
83452 92762 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
84656 92048 3 12 2323 Cesar Chavez St   7 1 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
86127 92761 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
87949 96848 6 75 1486 Innes Ave   7 1 1           6016133.4 2096820.6 37.7383757570157 -122.386716118251 (37.7383757570157, -122.386716118251)
90103 100046 7 17 562 28th St   7 1 1   11/28/2012 12:00:00 AM 17   Permit Number 769057 6002262.0 2099459.0 37.7448424535299 -122.43486521318898 (37.7448424535299, -122.434865213189)
90230 98140 7 47 315 San Marcos Ave   7 1 1           5992920.8 2100212.1 37.746375486546704 -122.467219803339 (37.7463754865467, -122.467219803339)
90772 106612 6 138 1189 TENNESSEE ST   7 1 1     55     6015654.1 2103577.3 37.7569017014681 -122.388844893024 (37.7569017014681, -122.388844893024)
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)
93582 93724 6 62 415 Belvedere St   7 1 1           5998488.0 2106798.0 37.7647785355325 -122.44844336243601 (37.7647785355325, -122.448443362436)
94387 87294 1 104 2087 28th Ave   7 1 1   03/20/2008 12:00:00 AM     Permit Number 50307 5987541.6 2101099.3 37.7484995140672 -122.48588532379298 (37.7484995140672, -122.485885323793)
94853 104637 1 54 217 Montcalm St   7 2 1       16x16   6010036.0 2099691.0 37.7459177905176 -122.40800041337499 (37.7459177905176, -122.408000413375)
96055 107245 6 17 140 CEDRO AVE   7 1 1           5991993.7 2093259.3 37.727231291852604 -122.469919436342 (37.7272312918526, -122.469919436342)
96352 92759 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
98130 95234 6 17 7 Almaden Ct   7 1 1   01/25/2011 12:00:00 AM     Permit Number 767129 5995849.0 2112535.0 37.780379598944705 -122.457986127959 (37.7803795989447, -122.457986127959)
99064 93932 6 105     7 1 1   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.5528400003 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841)
99731 115673 6 183 86 Stanton St   7 1 1           6000281.6 2103909.8 37.7569506357303 -122.442032456595 (37.7569506357303, -122.442032456595)
102075 109040 6 19 654 Precita Ave   7 1 1     30     6009911.5 2100416.7 37.7479034320272 -122.408482100152 (37.7479034320272, -122.408482100152)
102208 110843 7 231 2037 TURK BLVD   7 1 1     15     6000252.0 2111948.0 37.779019836036206 -122.442711981138 (37.7790198360362, -122.442711981138)
102514 107902 1 88 133 Elsie St   7 1 1   11/04/2014 12:00:00 AM 3   Permit Number 773996 6007164.40736 2098513.6513900002 37.742523860763995 -122.417846568545 (37.742523860764, -122.417846568545)
103866 87188 6 17 2119 Bush St   7 1 1   01/29/2008 12:00:00 AM     Permit Number 50204 6002998.0 2114831.0 37.787091984974104 -122.433418544226 (37.7870919849741, -122.433418544226)
105112 95242 6 3 2620 Larkin St   7 1 1     37   Permit Number 56959 6006630.0 2120172.0 37.801962421987 -122.421232011572 (37.801962421987, -122.421232011572)
106619 86895 6 17 321 Haight St   7 1 1   10/26/2007 12:00:00 AM     Permit Number 49844 6004599.9 2109420.1 37.7723257406977 -122.427490696784 (37.7723257406977, -122.427490696784)
106998 92755 1 6 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
107166 98714 3 3 500X Brotherhood Way   7 1 2           5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
107985 92049 3 30 2323 Cesar Chavez St   7 1 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
108286 100045 7 181 556 28th St   7 1 1         Not sure which property tree is located on. 6002301.0 2099461.0 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666)
108424 106038 6 75 230 Lakeview Ave   7 1 1         Permit Number 772456 5997013.1 2089546.6 37.7173259605404 -122.452299707743 (37.7173259605404, -122.452299707743)
109599 98161 6 71 600 Front St   7 1 1   12/21/2011 12:00:00 AM     Permit Number 768589 6012888.4 2118392.6 37.7974274520849 -122.39944985704099 (37.7974274520849, -122.399449857041)
109838 98274 6 82 766 Anderson St   7 1 1   01/23/2012 12:00:00 AM 18   Permit Number 768445 6007723.0 2095324.0 37.7337971999422 -122.41568932106199 (37.7337971999422, -122.415689321062)
110495 95215 6 175 2203 Divisadero St   7 1 1           6000868.0 2115894.0 37.7898896344174 -122.440864138631 (37.7898896344174, -122.440864138631)
111744 104636 1 54 217 Montcalm St   7 2 1       16x16   6010036.0 2099691.0 37.7459177905176 -122.40800041337499 (37.7459177905176, -122.408000413375)
112470 110950 6 3 342 HILL ST   7 1 1     15 3x3 Permit Number 778799 6004048.0 2103384.0 37.755720828524204 -122.42896934322901 (37.7557208285242, -122.428969343229)
113676 95299 6 11 701 Golden Gate Ave   7 1 1   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617005 -122.422419858646 (37.780652317617, -122.422419858646)
113684 92767 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
115263 97894 6 17 2927 Folsom St   7 1 1   02/29/2012 12:00:00 AM 30   Permit Number 768566 6008395.0 2101384.0 37.7504743768844 -122.413794517972 (37.7504743768844, -122.413794517972)
116515 92766 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
116721 105845 6 3 355 Buena Vista Ave   7 1 1           6000886.5 2107736.6 37.767492540377 -122.44021490806801 (37.767492540377, -122.440214908068)
118024 94228 7 175 1097 Church St   7 1 1   06/25/2010 12:00:00 AM     Permit Number 53567 6004455.0 2102510.0 37.753344058808395 -122.427499544702 (37.7533440588084, -122.427499544702)
118218 104635 1 54 217 Montcalm St   7 2 1       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
121702 95777 6 518 30 Onondaga Ave   7 1 1   03/11/2011 12:00:00 AM     Permit Number 767524 6001190.6 2091111.6 37.721861535681704 -122.437972107548 (37.7218615356817, -122.437972107548)
122763 86746 1 3 41 Nevada St   7 1 1         Permit Number 49711 6009063.0 2098235.0 37.7418654099413 -122.411262090685 (37.7418654099413, -122.411262090685)
122921 106507 2 529 50 FANNING WAY   7 1 1           5991716.2 2101233.1 37.749109278682795 -122.471459514348 (37.7491092786828, -122.471459514348)
122936 107159 6 47 1000 ESMERALDA AVE   7 1 1           6009839.0 2098688.0 37.7431527400861 -122.408610872619 (37.7431527400861, -122.408610872619)
123402 98170 6 134 2324 Sacramento St   7 1 1   12/22/2011 12:00:00 AM 3   Permit Number 768454 6003670.2 2115963.1 37.7902385582714 -122.43117371849199 (37.7902385582714, -122.431173718492)
124823 92756 1 6 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
125171 107047 6 17 1933 15TH ST   7 1 1           6004592.7 2107127.1 37.766029309282295 -122.42735222853202 (37.7660293092823, -122.427352228532)
125951 87199 1 12 71 Mansfield St   7 1 1   01/31/2008 12:00:00 AM   3x3 Permit Number 50216 6005338.0 2091826.0 37.7240581044071 -122.423686361989 (37.7240581044071, -122.423686361989)
126422 109061 6 3 36 ARBOR ST   7 1 1         Permit Number 774913 6002094.4 2096943.6 37.7379262346414 -122.435264853151 (37.7379262346414, -122.435264853151)
127034 114142 6 3 99 Divisadero St   7 1 1           6001906.1 2108188.4 37.7687910682296 -122.436720598265 (37.7687910682296, -122.436720598265)
127045 92765 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
139354 106405 6 105 4849X 19th St   7 1 1         Permit Number 772769 5999644.57626 2104777.09851 37.759295701171105 -122.44429784106501 (37.7592957011711, -122.444297841065)
139726 98721 3 3 700X Brotherhood Way   7 1 2           5991178.9 2088065.4 37.7129229890255 -122.47235769727399 (37.7129229890255, -122.472357697274)
140658 92758 1 6 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
141435 104808 6 277 1665 08th Ave   7 1 1     40     5993673.5 2104163.7 37.7572689897716 -122.46490400670099 (37.7572689897716, -122.464904006701)
141601 108981 1 507 10 ARBOR ST   7 1 1   03/02/2015 12:00:00 AM 3   Permit Number 774690 6002183.8 2097008.7 37.7381100606509 -122.434960408352 (37.7381100606509, -122.434960408352)
141674 104634 1 54 217 Montcalm St   7 2 1       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
142961 104761 6 277 1665 18TH AVE   7 1 1     50 9x9   5990543.2 2104073.0 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248)
142992 97797 2 17 400 Sussex St   7 1 1   11/14/2011 12:00:00 AM 17   Permit Number 768175 6000884.7 2096726.7 37.7372619068373 -122.43943182637501 (37.7372619068373, -122.439431826375)
144810 104762 6 277 1665 18TH AVE   7 1 1     50 9x9   5990543.2 2104073.0 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248)
144843 92757 1 6 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
145874 100769 2 47 3701 21st St   7 1 1     55   Street tree w/in RoW 6003717.0 2103606.0 37.7563116466144 -122.43012988292 (37.7563116466144, -122.43012988292)
28352 125438 2 70 250 Euclid Ave 0 7 1 1     15     5998091.24108 2114006.2469099998 37.78454782955 -122.45033529224199 (37.78454782955, -122.450335292242)
175263 226690 2 55 1451 San Bruno Ave 0 7 1 1     0     6011227.792669999 2101285.4147 37.7503623610541 -122.40399151941901 (37.7503623610541, -122.403991519419)
82 241178 1 31 300 Duboce Ave 1 7 1 1   02/20/2001 12:00:00 AM 8 Width 3ft Permit Number 43693 6004795.3896699995 2108410.1055900003 37.769563595403106 -122.42674254153299 (37.7695635954031, -122.426742541533)
240 251249 5 64 161 Lundys Ln 1 7 2 1       3x3   6006716.0 2098685.0 37.7429691002686 -122.41940918518 (37.7429691002686, -122.41940918518)
247 251250 3 63 321X Corbett Ave 1 7 1 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
604 171523 1 17 281 Harvard St 1 7 1 1   04/12/2017 12:00:00 AM 3 3x3 Permit Number 779632 6006304.03409 2092571.58308 37.7261597980302 -122.420399821019 (37.7261597980302, -122.420399821019)
767 251382 2 58 731 Huron Ave 1 7 1 1       2x5   5997668.0 2087467.0 37.7116533538928 -122.449886244657 (37.7116533538928, -122.449886244657)
870 117001 3 54 1X Bernal Heights Blvd 1 7 1 2                    
1159 112361 6 26 561X Folsom St 1 7 1 1   11/16/2015 12:00:00 AM 3 10x30 Permit Number 775828 6013749.7362 2114198.9064599997 37.785960521430205 -122.396175324952 (37.7859605214302, -122.396175324952)
1177 251471 3 137 2423 Market St 1 7 1 2                    
1282 251482 3 3 900 Bosworth St 1 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1310 251480 6 3 51 Peralta Ave 1 7 1 1       3x3   6010641.0 2100362.0 37.747794064611604 -122.40595565659201 (37.7477940646116, -122.405955656592)
1633 251599 2 47 740 Moraga St 1 7 1 1       3x3   5992006.0 2103899.0 37.756445907456396 -122.470651540396 (37.7564459074564, -122.470651540396)
1712 251473 2 110 151 32nd Ave 1 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
1719 251394 6 154 203 Corbett Ave 1 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779803 6000094.0 2105620.0 37.7616357315689 -122.442804047122 (37.7616357315689, -122.442804047122)
1820 251716 6 47 3929 19th St 1 7 1 1           6003450.0 2104734.0 37.75939373993371 -122.431133769968 (37.7593937399337, -122.431133769968)
Powered by Datasette · Query took 24.066ms · Data source: data.sfgov.org