sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
145 111561 2 49 1498x Kansas St 2 1 1 1   03/28/2017 12:00:00 AM 3 3x3 Permit Number 779654 6011715.78319 2101470.3886700002 37.7508975116216 -122.40231700873699 (37.7508975116216, -122.402317008737)
469 85530 1 49 101X 12th St 2 1 1 1   05/29/2007 12:00:00 AM 6     6007333.48731 2109350.5044400003 37.772288880253704 -122.418030010287 (37.7722888802537, -122.418030010287)
479 85531 3 49 101X 12th St 3 1 1 2   05/29/2007 12:00:00 AM 6     6007317.968280001 2109362.68703 37.7723214572932 -122.418084555959 (37.7723214572932, -122.418084555959)
490 85529 3 49 101 12th St 1 1 1 2   05/29/2007 12:00:00 AM 6 3x3   6007351.89443 2109342.45047 37.7722678019432 -122.417965767207 (37.7722678019432, -122.417965767207)
541 251317 2 49 399X 12th St 3 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
635 251315 2 49 399X 12th St 5 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
644 251319 2 49 399X 12th St 1 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
645 251316 2 49 399X 12th St 4 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
851 234149 2 49 3652 23rd St 5 1 1 1     17 Width 4ft   6005288.48907 2102558.72214 37.753524945734 -122.42462062893601 (37.753524945734, -122.424620628936)
1009 223537 1 49 1300 Noe St 2 2 1 1     15 Width 5ft   6003218.0959 2100594.3408 37.7480140720016 -122.431640256605 (37.7480140720016, -122.431640256605)
1100 2952 3 49 2001 California St 1 1 1 2     45 3X3   6004785.43 2115651.1441 37.789445140420604 -122.427292872615 (37.7894451404206, -122.427292872615)
1527 103937 1 49 2300 Mason St 1 1 1 1   06/24/2013 12:00:00 AM 26   Permit Number 770288 6008943.2 2121170.5 37.804834190774 -122.413297871125 (37.804834190774, -122.413297871125)
1562 251589 1 49 339 Crescent Ave 1 1 1 1   05/23/2017 12:00:00 AM 3 3x3 Permit Number 778123 6007098.02705 2095773.46513 37.7349961804395 -122.417881894445 (37.7349961804395, -122.417881894445)
1729 223604 2 49 54 Shotwell St 1 1 1 1     10 Width 3ft   6007683.47887 2107616.2985400003 37.7675468513265 -122.41669647756599 (37.7675468513265, -122.416696477566)
1827 251744 2 49 70 Winding Way 1 1 1 1       3x3   6002620.0 2086992.0 37.710631205907 -122.43273690550899 (37.710631205907, -122.432736905509)
1840 251759 2 49 248 Winding Way 1 1 1 1       3x3   6001757.0 2086582.0 37.709456453529796 -122.43569030601002 (37.7094564535298, -122.43569030601)
1849 251761 2 49 236 Winding Way 1 1 1 1       3x3   6001827.0 2086593.0 37.709490632951706 -122.43544916105199 (37.7094906329517, -122.435449161052)
1859 251772 2 49 90x Seville St 2 1 1 1       3x3   6002045.0 2087474.0 37.7119220445534 -122.434758675533 (37.7119220445534, -122.434758675533)
1861 251780 2 49 1219 Naples St 11 1 1 1       3x3   6001110.0 2087312.0 37.7114241006266 -122.437978695611 (37.7114241006266, -122.437978695611)
1874 251773 2 49 90x Seville St 3 1 1 1       3x3   6002045.0 2087474.0 37.7119220445534 -122.434758675533 (37.7119220445534, -122.434758675533)
1997 28906 3 49 354 05th St 3 1 1 2   02/28/2014 12:00:00 AM 5 3X3 Permit Number 779305 6011835.68516 2111895.24936 37.779528530663704 -122.402635398413 (37.7795285306637, -122.402635398413)
2026 252856 2 49 926 Edinburgh St 2 1 1 1       3x3   6001578.0 2088750.0 37.7153991335272 -122.43646402536001 (37.7153991335272, -122.43646402536)
2035 252855 2 49 926 Edinburgh St 1 1 1 1       3x3   6001578.0 2088750.0 37.7153991335272 -122.43646402536001 (37.7153991335272, -122.43646402536)
2516 251771 2 49 90x Seville St 1 1 1 1       3x3   6002045.0 2087474.0 37.7119220445534 -122.434758675533 (37.7119220445534, -122.434758675533)
2524 141906 2 49 900 MCALLISTER ST 7 1 1 1     7 Width 0ft   6004683.4832 2111946.7944 37.7792681524686 -122.427381601663 (37.7792681524686, -122.427381601663)
2540 141909 2 49 900 MCALLISTER ST 9 1 1 1     5 Width 0ft   6004576.1236 2111931.0419 37.779218827498205 -122.427751880486 (37.7792188274982, -122.427751880486)
2565 191072 2 49 396 12th St 4 4 1 1     5 Width 3ft Permit Number 779704 6008614.31812 2108613.9778 37.770338555601505 -122.41354738542101 (37.7703385556015, -122.413547385421)
2608 115877 1 49 1880 Jackson St 2 1 1 1   03/01/2016 12:00:00 AM 3   Permit Number 775798 6005144.10497 2117158.82947 37.7936051429156 -122.42615927543999 (37.7936051429156, -122.42615927544)
2674 223658 1 49 336 Bosworth St 3 1 1 1     5 Width 3ft Permit Number 18811 6003665.26948 2095270.38526 37.7334210492488 -122.429714281988 (37.7334210492488, -122.429714281988)
2675 223660 1 49 336 Bosworth St 1 1 1 1   12/04/1980 12:00:00 AM 7 Width 3ft Permit Number 18811 6003709.54346 2095276.16661 37.7334394304696 -122.429561626586 (37.7334394304696, -122.429561626586)
2678 223657 1 49 336 Bosworth St 4 1 1 1     5 Width 3ft Permit Number 18811 6003655.959980001 2095270.88152 37.7334218847062 -122.429746502924 (37.7334218847062, -122.429746502924)
2680 223656 1 49 336 Bosworth St 5 1 1 1     6 Width 3ft Permit Number 18811 6003648.753819999 2095269.66073 37.7334181246305 -122.42977132959601 (37.7334181246305, -122.429771329596)
2685 223659 1 49 336 Bosworth St 2 1 1 1     5 Width 3ft Permit Number 18811 6003694.10013 2095275.57225 37.7334369240608 -122.42961497614901 (37.7334369240608, -122.429614976149)
2771 248515 1 49 170 Belvedere St 1 1 1 1   04/10/1979 12:00:00 AM 14 Width 0ft Permit Number 17884 5998314.3472 2107764.7584 37.7674230792249 -122.44911363069099 (37.7674230792249, -122.449113630691)
2978 246035 1 49 640 Ashbury St 1 1 1 1   12/27/2001 12:00:00 AM 6 Width 0ft Permit Number 44478 5999014.0338 2108493.5166 37.7694640582811 -122.446745961985 (37.7694640582811, -122.446745961985)
3065 175836 2 49 101 Rhine St 3 2 1 1     5 Width 3ft   5994366.585519999 2086543.72285 37.70892880020671 -122.46122985488998 (37.7089288002067, -122.46122985489)
3083 252820 4 49 2339 41st Ave 1 1 1 1   08/21/2017 12:00:00 AM 3 3x3   5983590.30233 2099230.6863599997 37.743137766616 -122.49941055724301 (37.743137766616, -122.499410557243)
3126 170290 2 49 112 Judson Ave 1 1 1 1   08/22/2017 12:00:00 AM 3 Width 3ft   5999300.3013 2093511.3105799998 37.7283429067858 -122.44467875893999 (37.7283429067858, -122.44467875894)
3406 172261 2 49 230 Winding Way 1 1 1 1     0 Width 3ft   6001860.0 2086600.0 37.7095117275676 -122.435335608043 (37.7095117275676, -122.435335608043)
3437 180625 2 49 18 Winding Way 1 1 1 1     0 Width 6ft   6002816.84046 2087215.85653 37.711257028952495 -122.432072557104 (37.7112570289525, -122.432072557104)
3478 180626 2 49 18 Winding Way 2 1 1 1     0 Width 6ft   6002802.39914 2087193.02957 37.7111935323316 -122.432120840807 (37.7111935323316, -122.432120840807)
3489 74967 2 49 998 Sansome St 1 1 1 1 1 10/07/1995 12:00:00 AM 8 3x3   6012084.12824 2119041.9172900002 37.799165460472295 -122.40227854024401 (37.7991654604723, -122.402278540244)
3736 223410 1 49 898 Hampshire St 3 1 1 1   10/18/1993 12:00:00 AM 9 Width 4ft Permit Number 32344 6010171.02881 2104045.21453 37.7578810584907 -122.407840483778 (37.7578810584907, -122.407840483778)
3749 223601 2 49 280x Shotwell St 2 1 1 1     8 Width 3ft   6007724.0 2106220.0 37.7637152201621 -122.41645740380899 (37.7637152201621, -122.416457403809)
3792 223602 2 49 280x Shotwell St 1 1 1 1   09/25/2017 12:00:00 AM 3 Width 3ft   6007724.0 2106220.0 37.7637152201621 -122.41645740380899 (37.7637152201621, -122.416457403809)
3890 161753 4 49 175x Newton St 1 1 1 1   08/09/2017 12:00:00 AM 3 4x4 Permit Number 780462 6001022.0 2087749.0 37.7126190008501 -122.43831413288 (37.7126190008501, -122.43831413288)
3901 253246 4 49 1192 Naples St 1 1 1 1   08/09/2017 12:00:00 AM 3 4x4 Permit Number 780462 6001173.0 2087586.0 37.7121800264355 -122.437780563503 (37.7121800264355, -122.437780563503)
3916 179075 2 49 2 Edinburgh St 2 1 1 1   08/27/2017 08:37:00 AM 3 Width 3ft   6004507.82534 2093430.5210099998 37.7284168670376 -122.426670354762 (37.7284168670376, -122.426670354762)
3923 251683 2 49 46 Lee Ave 1 1 1 1   10/04/2017 02:00:00 PM 3 3x3   5996555.0 2090205.0 37.7191075183288 -122.453930658436 (37.7191075183288, -122.453930658436)
3929 251760 2 49 242 Winding Way 1 1 1 1   10/04/2017 10:24:00 AM 3 3x3   6001791.0 2086587.0 37.709472113614396 -122.43557315397499 (37.7094721136144, -122.435573153975)
3943 216737 2 49 11 Lee Ave 1 2 1 1   10/04/2017 02:31:00 PM 3 Width 2ft   5996481.70655 2089974.5093900003 37.7184704425356 -122.45416736555799 (37.7184704425356, -122.454167365558)
3948 251682 2 49 40 Lee Ave 1 1 1 1   10/04/2017 02:02:00 PM 3 3x3   5996554.0 2090155.0 37.7189701727187 -122.45393050605401 (37.7189701727187, -122.453930506054)
3953 44431 1 49 859 Prague St 8 1 1 1 1 10/04/2017 11:19:00 AM 3   Permit Number 43768 6002228.37284 2086951.06128 37.71049657842789 -122.434087529513 (37.7104965784279, -122.434087529513)
3954 216641 2 49 8 Lee Ave 1 1 1 1   10/04/2017 02:34:00 PM 3 Width 2ft   5996523.62122 2089940.0235400002 37.7183781559031 -122.45401999544399 (37.7183781559031, -122.454019995444)
3959 216642 2 49 50 Lee Ave 1 2 1 1   10/04/2017 01:57:00 PM 3 Width 2ft   5996528.83108 2090217.4765599999 37.7191402755735 -122.45402201441999 (37.7191402755735, -122.45402201442)
3988 159293 2 49 486 Ellington Ave 1 1 1 1   10/05/2017 11:16:00 AM 3 Width 0ft   5998231.36405 2087340.7209 37.711338838486206 -122.44793002935499 (37.7113388384862, -122.447930029355)
3991 44420 1 49 859 Prague St 12 1 1 1 1 10/05/2017 08:03:00 AM 3   Permit Number 43768 6002331.23577 2087017.31055 37.710684321803896 -122.433736745364 (37.7106843218039, -122.433736745364)
3993 180622 2 49 771 Prague St 1 1 1 1   10/05/2017 10:19:00 AM 3 Width 6ft   6002476.28052 2087135.9896900002 37.7110184181363 -122.433243913293 (37.7110184181363, -122.433243913293)
3996 251731 2 49 749 Prague St 1 1 1 1   10/05/2017 10:28:00 AM 3 3x3   6002542.0 2087174.0 37.7111265141547 -122.433019485161 (37.7111265141547, -122.433019485161)
3997 251702 2 49 910 Plymouth Ave 1 1 1 1   10/05/2017 08:10:00 AM 3 3x3   5995959.0 2089989.0 37.7184802428284 -122.455975181765 (37.7184802428284, -122.455975181765)
4017 159290 2 49 476 Ellington Ave 1 1 1 1   10/05/2017 12:01:00 PM 3 Width 0ft   5998270.831130001 2087378.17542 37.71144393594879 -122.447796316346 (37.7114439359488, -122.447796316346)
4020 159292 2 49 482 Ellington Ave 1 1 1 1   10/05/2017 11:20:00 AM 3 Width 0ft   5998250.20897 2087358.72103 37.7113893399111 -122.447866191868 (37.7113893399111, -122.447866191868)
4024 162893 2 49 989 Plymouth Ave 1 1 1 1   10/05/2017 07:55:00 AM 3 Width 0ft   5995900.9159699995 2090507.1472900002 37.719899619041705 -122.45621339603301 (37.7198996190417, -122.456213396033)
4049 216738 2 49 55 Brighton Ave 1 1 1 1   10/05/2017 08:15:00 AM 3 Width 3ft   5996190.92128 2090248.8159599998 37.7192069450213 -122.455192295882 (37.7192069450213, -122.455192295882)
4054 212592 2 49 626 Holloway Ave 1 1 1 1   10/05/2017 02:33:00 PM 3 Width 3ft   5994858.52059 2091254.05594 37.7218905597914 -122.459870645607 (37.7218905597914, -122.459870645607)
4059 251733 2 49 824 Prague St 3 1 1 1   10/05/2017 08:24:00 AM 3 Width 6ft   6002320.95082 2087061.4224099999 37.7108048597154 -122.43377544319401 (37.7108048597154, -122.433775443194)
4062 216659 2 49 1022 Plymouth Ave 1 1 1 1   10/05/2017 07:44:00 AM 3 Width 4ft   5995946.33237 2090713.9624 37.7204700913979 -122.456071352615 (37.7204700913979, -122.456071352615)
4065 216746 2 49 935 Plymouth Ave 1 1 1 1   10/05/2017 08:04:00 AM 3 Width 3ft   5995893.729730001 2090148.9347 37.71891563932461 -122.456212350117 (37.7189156393246, -122.456212350117)
4069 251732 2 49 824 Prague St 2 1 1 1   10/05/2017 08:20:00 AM 3 Width 6ft   6002320.95082 2087061.4224099999 37.7108048597154 -122.43377544319401 (37.7108048597154, -122.433775443194)
4071 251734 2 49 856 Prague St 3 2 1 1   10/05/2017 08:08:00 AM 3 Width 6ft   6002039.2106099995 2086908.72872 37.7103696049432 -122.434738288839 (37.7103696049432, -122.434738288839)
4079 162895 2 49 989 Plymouth Ave 3 1 1 1   10/05/2017 07:58:00 AM 3 Width 0ft   5995899.78819 2090467.68802 37.7197912084714 -122.45621444283998 (37.7197912084714, -122.45621444284)
4088 30930 1 49 342 Holloway Ave 1 1 1 1 1 10/05/2017 02:15:00 PM 3 4.5x9 Permit Number 779282 5995716.95289 2091237.86508 37.7218954350219 -122.45690211214199 (37.7218954350219, -122.456902112142)
4108 180634 2 49 824 Prague St 1 1 1 1   10/05/2017 08:16:00 AM 3 Width 6ft   6002320.95082 2087061.4224099999 37.7108048597154 -122.43377544319401 (37.7108048597154, -122.433775443194)
4114 180623 2 49 755 Prague St 1 1 1 1   10/05/2017 10:23:00 AM 3 Width 6ft   6002495.21129 2087156.5558200001 37.711075962150204 -122.43317995261499 (37.7110759621502, -122.433179952615)
4144 216652 2 49 329 Faxon Ave 1 2 1 1   10/06/2017 08:15:00 AM 3 Width 4ft   5994725.9247 2090785.7094700001 37.7205969659665 -122.460295076156 (37.7205969659665, -122.460295076156)
4183 180766 2 49 1206 Naples St 1 2 1 1   10/10/2017 09:29:00 AM 3 Width 8ft   6001093.57723 2087421.33847 37.7117233858917 -122.438043283865 (37.7117233858917, -122.438043283865)
4195 181063 2 49 280 Guttenberg St 1 1 1 1   10/10/2017 04:21:00 PM 3 Width 3ft   5999687.90058 2086653.1482400002 37.7095340664096 -122.44284654223999 (37.7095340664096, -122.44284654224)
4207 251781 2 49 1237 Naples St 1 1 1 1   10/10/2017 09:14:00 AM 3 3x3   6001070.0 2087245.0 37.711237858655295 -122.438112149268 (37.7112378586553, -122.438112149268)
4209 180663 2 49 355 Chicago Way 1 2 1 1   10/10/2017 01:48:00 PM 3 Width 6ft   6002383.84355 2086445.14687 37.709116270155604 -122.43351405884898 (37.7091162701556, -122.433514058849)
4210 251779 2 49 1207 Naples St 1 1 1 1   10/10/2017 09:23:00 AM 3 3x3   6001136.0 2087356.0 37.7115463934242 -122.437891982586 (37.7115463934242, -122.437891982586)
4218 181054 2 49 120 Brunswick St 1 1 1 1   10/10/2017 09:03:00 AM 3 Width 2ft   6000669.11916 2087419.81595 37.711695057256605 -122.439510213951 (37.7116950572566, -122.439510213951)
4253 216859 2 49 249 Sadowa St 1 1 1 1   10/10/2017 08:28:00 AM 3 Width 3ft   5994500.65492 2087744.1970099998 37.712232734922104 -122.46085344003299 (37.7122327349221, -122.460853440033)
4293 216862 2 49 272 Sadowa St 1 2 1 1   10/10/2017 08:43:00 AM 3 Width 3ft   5994260.82584 2087785.69998 37.7123328897311 -122.461685361516 (37.7123328897311, -122.461685361516)
4304 181055 2 49 120 Brunswick St 2 1 1 1   10/10/2017 09:09:00 AM 3 Width 2ft   6000651.24572 2087413.96665 37.711677979129604 -122.43957157019899 (37.7116779791296, -122.439571570199)
4315 216902 2 49 174 Bright St 1 2 1 1   10/11/2017 11:02:00 AM 3 Width 3ft   5993764.72474 2088364.55203 37.7138937098892 -122.46344200363899 (37.7138937098892, -122.463442003639)
4376 160888 2 49 679 Edinburgh St 1 1 1 1 1 10/11/2017 08:26:00 AM 3 Width 0ft   6002304.816330001 2089843.73714 37.7184435671833 -122.43402996661999 (37.7184435671833, -122.43402996662)
4389 177791 2 49 400 Cordova St 1 1 1 1   10/11/2017 11:44:00 AM 3 Width 8ft   6001956.24423 2086810.19432 37.710094340458 -122.435017995105 (37.710094340458, -122.435017995105)
4426 160887 2 49 687 Edinburgh St 1 1 1 1 1 10/11/2017 08:35:00 AM 3 Width 0ft   6002277.9096800005 2089801.2576099997 37.7183254007788 -122.434119936579 (37.7183254007788, -122.434119936579)
4458 253080 3 49 2849X Alemany Blvd 13 1 1 2   10/13/2017 11:00:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4465 253081 3 49 2849X Alemany Blvd 14 1 1 2   10/13/2017 10:35:00 AM 3 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
4475 253631 2 49 39 Mason St 1 1 1 1 4         6009957.290080001 2113442.89538 37.783672949399204 -122.409242840109 (37.7836729493992, -122.409242840109)
4506 253629 3 49 123 Eddy St 2 1 1 2           6009831.1503800005 2113653.7445799997 37.7842448233884 -122.409694124829 (37.7842448233884, -122.409694124829)
4520 253628 3 49 123 Eddy St 1 1 1 2           6009831.1503800005 2113653.7445799997 37.7842448233884 -122.409694124829 (37.7842448233884, -122.409694124829)
4635 160567 2 49 790 Naples St 1 1 1 1 1 10/18/2017 11:57:00 AM 3 Width 0ft   6002104.08605 2089098.7371 37.716386568565 -122.43467056358999 (37.716386568565, -122.43467056359)
4648 160560 2 49 718 Naples St 1 1 1 1 1 10/18/2017 01:51:00 PM 3 Width 0ft   6002343.44923 2089479.7194599998 37.7174462478135 -122.43387042418301 (37.7174462478135, -122.433870424183)
4653 160561 2 49 730 Naples St 1 1 1 1 1 10/18/2017 01:42:00 PM 3 Width 0ft   6002306.04947 2089419.84324 37.7172797185636 -122.43399542008001 (37.7172797185636, -122.43399542008)
4654 160563 2 49 750 Naples St 1 1 1 1 1 10/18/2017 01:34:00 PM 3 Width 0ft   6002231.24921 2089300.0903 37.7169466582377 -122.434245412715 (37.7169466582377, -122.434245412715)
4662 50502 1 49 744 Naples St 1 1 1 1 1 10/18/2017 01:37:00 PM 3 3x3 Permit Number 767517 6002255.61475 2089339.38797 37.7170559438579 -122.434164000676 (37.7170559438579, -122.434164000676)
4665 160559 2 49 710 Naples St 1 1 1 1 1 10/18/2017 03:15:00 PM 3 Width 0ft   6002373.4779900005 2089525.5110400002 37.7175736853632 -122.433769899784 (37.7175736853632, -122.433769899784)
4718 160845 2 49 669 Vienna St 1 1 1 1 1 10/24/2017 03:09:00 PM 3 Width 0ft   6002769.79165 2089568.5134700001 37.7177142412877 -122.432403094831 (37.7177142412877, -122.432403094831)
4728 160846 2 49 669 Vienna St 2 1 1 1 1 10/24/2017 12:20:00 PM 3 Width 0ft   6002781.71244 2089588.8302099998 37.717770702526295 -122.432363340291 (37.7177707025263, -122.432363340291)
Powered by Datasette · Query took 2.586ms · Data source: data.sfgov.org