sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
123910 96598 7 458 325 Sanchez St   5 3 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
5154 253212 1 17 15 Liberty St 2 18 3 1   11/08/2017 12:00:00 AM 3 5x5 Permit Number 780777 6006173.0 2104008.0 37.75755424109929 -122.421664722498 (37.7575542410993, -122.421664722498)
4548 253634 3 43 830 Oak St 1 5 3 2           6003018.63904 2109969.70237 37.7737452502421 -122.43299969185101 (37.7737452502421, -122.432999691851)
178249 227519 2 284 375 Alabama St 1 4 2 1     8 Width 3ft   6008967.54586 2106408.18704 37.7643017925286 -122.41216964832199 (37.7643017925286, -122.412169648322)
172552 140265 2 98 2100X Grove St 3 1 2 1     0 Width 0ft   5997671.17 2110272.3417 37.7742714515841 -122.45151917218 (37.7742714515841, -122.45151917218)
152708 117679 2 106 7800 Geary Blvd 2 1 2 1     19 Width 3ft   5982700.570040001 2112440.0728599997 37.7793547453385 -122.50346489390199 (37.7793547453385, -122.503464893902)
145744 109499 1 7 99 Surrey St 1 1 2 1 1 02/19/2015 12:00:00 AM 3 3x3 Permit Number 774984 6002392.9 2096233.9 37.7359945088656 -122.43418207236999 (37.7359945088656, -122.43418207237)
145716 98878 7 17 11 Panorama Dr   13 2 1           5998029.0 2100213.0 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849)
145543 111758 1 54 1235 47th Ave 1 1 2 1   06/23/2015 12:00:00 AM 3 6x6   5981472.7 2106671.7 37.7634442160317 -122.50728446314301 (37.7634442160317, -122.507284463143)
145403 99528 1 17 120 Howard St 2 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
145017 99533 1 17 188 Spear St 1 1 2 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
144925 93163 1 98 201 Upper Ter 1 5 2 1   12/22/2009 12:00:00 AM   1x15   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
143940 106932 2 98 358 SHOTWELL ST 1 1 2 1       8x10   6007793.2 2105846.4 37.7626932925098 -122.416191600332 (37.7626932925098, -122.416191600332)
143915 93160 1 17 201 Upper Ter 1 5 2 1   12/22/2009 12:00:00 AM   1x1   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
143838 89015 1 98 4437 20th St   1 2 1   09/30/2008 12:00:00 AM   3x1 Permit Number 51764 6001659.0 2104076.0 37.757485378077604 -122.43728079846599 (37.7574853780776, -122.437280798466)
143440 117372 1 54 1533 McAllister St 5 5 2 1   06/08/2016 12:00:00 AM 3 1x2.75   6001806.7 2111472.8 37.777803561930206 -122.437299621265 (37.7778035619302, -122.437299621265)
143386 110614 1 134 200 McAllister St 2 1 2 1   12/31/2015 12:00:00 AM 3 21.4x7.8 Permit Number 773269 6008108.0 2112443.0 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338)
143329 93161 1 17 201 Upper Ter 2 5 2 1   12/22/2009 12:00:00 AM   1x1   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
142588 104374 2 17 22 GARDENSIDE DR 1 3 2 1       50x50   5999468.0 2101996.0 37.7516494117124 -122.444708626009 (37.7516494117124, -122.444708626009)
141674 104634 1 54 217 Montcalm St   7 2 1       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
141475 104153 1 54 525X Church St 1 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
140914 114321 1 12 2118 47th Ave 1 8 2 1   01/14/2016 12:00:00 AM   5x16 Permit Number 777356 5981743.9 2100646.6 37.7469169691931 -122.505899765145 (37.7469169691931, -122.505899765145)
140829 105041 1 54 2660 Harrison St 3 5 2 1       2x2   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586)
140567 94962 1 17 3098@Lyon Pacific Ave   5 2 1   10/25/2010 12:00:00 AM       5999362.0 2116697.3 37.7920093994348 -122.44613254842899 (37.7920093994348, -122.446132548429)
140543 109342 1 54 3211 Baker St 1 9 2 1   02/11/2015 12:00:00 AM 3 1x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
139898 109348 5 253 2505 Pacific Ave 1 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
139298 92611 1 98 3856 23rd St   6 2 1   08/31/2009 12:00:00 AM     Permit Number 52924 6004067.0 2102488.0 37.753261698893496 -122.428839761175 (37.7532616988935, -122.428839761175)
138994 99532 1 17 120 Howard St 6 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
138642 99534 1 17 188 Spear St 2 1 2 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
138621 104565 5 64 18 FLOOD AVE 1 7 2 1           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042)
138475 96182 1 17 330 South Van Ness Ave   8 2 1   04/04/2011 12:00:00 AM     Permit Number 767813 6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
129188 105003 2 98 607 CONGO ST   9 2 1           6000094.1 2095817.0 37.73471905904071 -122.44210000591002 (37.7347190590407, -122.44210000591)
129064 99535 1 17 188 Spear St 3 1 2 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
128554 93164 1 98 201 Upper Ter 2 5 2 1   12/22/2009 12:00:00 AM   1x2   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
128427 109369 1 54 2061 Hyde St 1 1 2 1 1 02/11/2015 12:00:00 AM 3 5x6   6007159.6 2119443.7 37.799992536546505 -122.41934764587201 (37.7999925365465, -122.419347645872)
128347 104667 1 18 172 Clipper St 1 1 2 1 1 01/19/2016 12:00:00 AM   6x12 Permit Number 777366 6003998.6 2101043.1 37.749290469922705 -122.42897329466999 (37.7492904699227, -122.42897329467)
128027 82995 1 12 1412 Quesada Ave 1 1 2 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52364 6016260.71862294 2093905.81391215 37.730379387125204 -122.38607277339099 (37.7303793871252, -122.386072773391)
127755 83007 1 457 1058 De Haro St 1 11 2 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52381 6012170.46860809 2103464.70975517 37.7563988530014 -122.40088475581499 (37.7563988530014, -122.400884755815)
127072 99201 1 17 4016 26th St   1 2 2 1 04/12/2012 12:00:00 AM   6x10.5 Permit Number 768835 6003752.7 2100736.7 37.7484352450997 -122.429801769855 (37.7484352450997, -122.429801769855)
126302 109534 1 54 1234 Filbert St 2 5 2 1 1 02/23/2015 12:00:00 AM 3 1.5x2.6   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677)
125946 109370 1 54 2061 Hyde St 2 1 2 1 1 02/11/2015 12:00:00 AM 3 13x6   6007159.6 2119443.7 37.799992536546505 -122.41934764587201 (37.7999925365465, -122.419347645872)
125875 89140 1 17 3170 23rd St   5 2 1   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373001 (37.7541940143569, -122.41572017373)
125761 108576 7 54 2479 Diamond St 1 7 2 1           6002240.0 2097369.0 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338)
125736 109351 5 253 2505 Pacific Ave 4 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
124767 99530 1 17 120 Howard St 4 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
124298 109367 1 54 1205 Filbert St 4 1 2 1 1 02/11/2015 12:00:00 AM 3 4.5x6.5   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
123904 106641 5 64 1323X CLAYTON ST 1 13 2 1           5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866)
123584 109253 1 88 1355 46th Ave 1 1 2 1 1 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773041 5981790.7 2105864.5 37.7612466017789 -122.50612476738199 (37.7612466017789, -122.506124767382)
123231 88829 1 98 4437 20th St   1 2 1   09/30/2008 12:00:00 AM   8x1 Permit Number 51764 6001659.0 2104076.0 37.757485378077604 -122.43728079846599 (37.7574853780776, -122.437280798466)
122806 105040 1 54 2660 Harrison St 2 5 2 1       2x7   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586)
122339 104861 1 54 3458A 18th St   5 2 1           6006508.0 2105569.9 37.7618617394874 -122.42061702780899 (37.7618617394874, -122.420617027809)
122284 109352 5 253 2505 Pacific Ave 5 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
121197 109754 1 54 601 Steiner St 1 5 2 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
120634 116580 6 98 3000x 19TH AVE 3 5 2 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
120372 88656 1 461 94 Danton St   5 2 1   08/05/2008 12:00:00 AM     Permit Number 51634 6002844.0 2094598.0 37.7315282931893 -122.43250562955099 (37.7315282931893, -122.432505629551)
120169 104564 5 64 18 FLOOD AVE 1 7 2 1           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042)
119638 109607 5 98 775 Congo St 1 7 2 1           6000381.8 2095947.7 37.7350943222142 -122.44111470541901 (37.7350943222142, -122.441114705419)
119565 99732 2 98 4150 Ocean Ave 1 5 2 1           5986619.2 2095203.6 37.7322576937009 -122.48864164528798 (37.7322576937009, -122.488641645288)
118241 4313 3 98 727 Chenery St 1 1 2 2   08/17/2013 12:00:00 AM   3X3   6002321.2517800005 2095689.19659 37.7344948117373 -122.434390856497 (37.7344948117373, -122.434390856497)
118218 104635 1 54 217 Montcalm St   7 2 1       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
118010 109755 1 54 601 Steiner St 2 5 2 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
117306 104857 1 54 2555 46th Ave   1 2 1           5982069.8 2097707.6 37.7388664658919 -122.504555139124 (37.7388664658919, -122.504555139124)
117077 89137 1 17 3170 23rd St   1 2 1   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373001 (37.7541940143569, -122.41572017373)
116207 109368 1 54 1205 Filbert St 5 1 2 1 1 02/11/2015 12:00:00 AM 3 3x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
116050 111759 1 54 1235 47th Ave 2 2 2 1   06/23/2015 12:00:00 AM 3 6x4   5981472.7 2106671.7 37.7634442160317 -122.50728446314301 (37.7634442160317, -122.507284463143)
115664 85184 1 49 501 Bartlett St   5 2 1   12/13/2006 12:00:00 AM   3x25 Permit Number 768657 6006822.0 2100867.0 37.748966349809606 -122.419197411761 (37.7489663498096, -122.419197411761)
115357 98501 7 17 232 Glenview Dr   13 2 1           5998998.0 2100740.0 37.748173910048706 -122.446243600021 (37.7481739100487, -122.446243600021)
114892 115259 1 54 2130 Jackson St   1 2 1   01/21/2016 12:00:00 AM   6x12   6003918.8 2117004.0 37.7931106894063 -122.43038787884501 (37.7931106894063, -122.430387878845)
114798 105147 1 18 52 Mirabel Ave   1 2 1   12/26/2013 12:00:00 AM   3X3 Permit Number 771012 6007663.7 2099931.8 37.7464458666696 -122.41622057503099 (37.7464458666696, -122.416220575031)
114741 104860 1 54 283 Randall St   1 2 1           6003774.7 2097827.3 37.7404479510811 -122.429518236565 (37.7404479510811, -122.429518236565)
114314 108701 1 12 478 30th St   1 2 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774626 6003507.49152 2098366.3309400002 37.7419128730633 -122.43048058961 (37.7419128730633, -122.43048058961)
114285 96183 1 17 330 South Van Ness Ave   8 2 1           6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
114228 99531 1 17 120 Howard St 5 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
113603 104154 1 54 525X Church St 2 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
113495 92775 1 17 2701 Pacific Ave   1 2 1   10/15/2009 12:00:00 AM     Permit Number 52996 6001178.5 2116864.5 37.7925720539586 -122.43985945141 (37.7925720539586, -122.43985945141)
113379 109349 5 253 2505 Pacific Ave 2 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
113148 104375 2 17 30 GARDENSIDE DR 1 3 2 1       50x50   5999465.0 2102094.0 37.7519183246276 -122.444726043725 (37.7519183246276, -122.444726043725)
112497 104858 1 54 4205 24th St   5 2 1           6001816.0 2101720.7 37.7510272133613 -122.43656924920201 (37.7510272133613, -122.436569249202)
112218 109536 1 54 1234 Filbert St 4 5 2 1 1 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677)
111918 109831 1 54 146 Staples Ave 1 5 2 1       12x15.3   5999109.5 2093827.3 37.7291996500545 -122.445361075989 (37.7291996500545, -122.445361075989)
111744 104636 1 54 217 Montcalm St   7 2 1       16x16   6010036.0 2099691.0 37.7459177905176 -122.40800041337499 (37.7459177905176, -122.408000413375)
111084 89138 1 17 3170 23rd St   1 2 1   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373001 (37.7541940143569, -122.41572017373)
110920 85195 1 17 333 Eucalyptus Dr   5 2 1           5990168.0 2094689.0 37.731051182582604 -122.47633519175501 (37.7310511825826, -122.476335191755)
110904 109242 7 64 2479 DIAMOND ST   2 2 1           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916)
110838 107348 5 64 260 LANSDALE AVE 1 13 2 1           5995019.0 2096651.7 37.7367204092857 -122.459706678853 (37.7367204092857, -122.459706678853)
110489 109322 2 64 191 24TH AVE 1 1 2 1       3x3   5988309.1 2114757.6 37.7860461422813 -122.484232887865 (37.7860461422813, -122.484232887865)
110212 110320 7 54 9 Imperial Aly   13 2 1           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274)
109480 92778 1 4 2701 Pacific Ave   5 2 1   10/15/2009 12:00:00 AM     Permit Number 52996 6001178.5 2116864.5 37.7925720539586 -122.43985945141 (37.7925720539586, -122.43985945141)
107768 82751 1 147 52 Sheridan St 1 1 2 1   07/07/2009 12:00:00 AM 3 3x3 Permit Number 52446 6009256.89976445 2109417.42292722 37.772580689338 -122.41138145626002 (37.772580689338, -122.41138145626)
107476 82512 1 12 52 Tulane St 1 1 2 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52482 6007264.0 2093867.0 37.7297707824944 -122.41717301728399 (37.7297707824944, -122.417173017284)
107139 82886 1 134 761 Clementina St 1 1 2 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52437 6009240.34446046 2110165.45314704 37.7746336766823 -122.41149158097299 (37.7746336766823, -122.411491580973)
106864 109768 1 54 2502X Bush St 1 5 2 1       1.5x13   6001313.62368 2114572.17699 37.786285618589204 -122.43922754338101 (37.7862856185892, -122.439227543381)
106819 105042 1 54 2660 Harrison St 4 5 2 1       2x10   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586)
105459 96289 1 17 228 30th St   1 2 1         Permit Number 767877 6005120.0 2098458.0 37.7422557889482 -122.42491157296699 (37.7422557889482, -122.424911572967)
105398 117608 1 54 450 Hayes St 1 1 2 1   06/29/2016 12:00:00 AM 3     6005708.4 2111040.6 37.776837876057 -122.423771533631 (37.776837876057, -122.423771533631)
105108 104859 1 54 650 Fillmore St   1 2 1           6003597.7 2110555.4 37.775386259915 -122.43103844044701 (37.775386259915, -122.431038440447)
104832 109350 5 253 2505 Pacific Ave 3 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
104353 98250 1 17 650 Eddy St   1 2 1         Sidewalk landscaping permit adjacent to building. 6007271.2 2113371.6 37.783326336649 -122.41853065554 (37.783326336649, -122.41853065554)
103907 106639 5 64 1321X CLAYTON ST 1 13 2 1           5998910.0 2105100.0 37.7601403710114 -122.44686158716699 (37.7601403710114, -122.446861587167)
102839 102414 2 60 1301 Page St 2 1 2 1           6000345.0 2109213.0 37.77151552050871 -122.44219387377399 (37.7715155205087, -122.442193873774)
102823 20136 1 82 890 Steiner St 1 1 2 1   01/11/2011 12:00:00 AM 3 8x4 Permit Number 54087 6003007.0 2111306.0 37.777413731872 -122.43313545029301 (37.777413731872, -122.433135450293)
Powered by Datasette · Query took 3.474ms · Data source: data.sfgov.org