sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
25716 135893 2 35 323 Marina Blvd 2 2 1 1     8     6001843.597519999 2121830.48703 37.806245186226505 -122.437914052191 (37.8062451862265, -122.437914052191)
74939 135892 2 35 323 Marina Blvd 1 2 1 1     7 Width 7ft   6001823.0897 2121828.5954400003 37.8062388262166 -122.437984887306 (37.8062388262166, -122.437984887306)
168893 41226 1 16 155 Retiro Way 1 1 1 1 1 11/30/1999 12:00:00 AM 8   Permit Number 41932 6001878.60529 2121714.18401 37.805927839759896 -122.437784566908 (37.8059278397599, -122.437784566908)
173199 136030 2 370 475 Marina Blvd 1 9 1 1     5 Width 5ft   6000838.224669999 2121681.08222 37.805777738417795 -122.441382580867 (37.8057777384178, -122.441382580867)
68012 136610 2 198 3798 Webster St 7 17 1 1     15 Width 4ft   6002559.08771 2121673.9848 37.805856133210895 -122.43542677652 (37.8058561332109, -122.43542677652)
188021 136609 2 198 3798 Webster St 6 17 1 1     7 Width 4ft   6002557.10875 2121672.73918 37.805852600677795 -122.435433535844 (37.8058526006778, -122.435433535844)
72627 136608 2 198 3798 Webster St 5 17 1 1     14 Width 4ft   6002554.72948 2121670.19367 37.8058454762555 -122.435441587454 (37.8058454762555, -122.435441587454)
75463 136607 2 198 3798 Webster St 4 17 1 1     11 Width 5ft   6002552.02607 2121667.51893 37.8058379785924 -122.435450751546 (37.8058379785924, -122.435450751546)
188746 136606 2 198 3798 Webster St 3 17 1 1     8 Width 5ft   6002550.09467 2121664.33857 37.8058291364749 -122.43545720778799 (37.8058291364749, -122.435457207788)
52420 136605 2 198 3798 Webster St 2 17 1 1     10 Width 4ft   6002548.49635 2121661.6698 37.805821717964605 -122.43546254797701 (37.8058217179646, -122.435462547977)
37251 136604 2 198 3798 Webster St 1 17 1 1     2 Width 2ft   6002548.10466 2121650.0452 37.8057897776435 -122.435463071378 (37.8057897776435, -122.435463071378)
5494 87738 3 18 3200X Van Ness Ave 10 11 1 2   05/10/2008 12:00:00 AM 3 4x4   6005444.64461 2121623.98788 37.8058823097966 -122.425437295217 (37.8058823097966, -122.425437295217)
8626 87739 3 18 3200X Van Ness Ave 11 11 1 2   05/10/2008 12:00:00 AM 3 4x4   6005433.618530001 2121623.41722 37.8058801199389 -122.42547541206699 (37.8058801199389, -122.425475412067)
42905 51703 1 237 54 Casa Way 1 1 1 1   04/29/2005 12:00:00 AM 3   Permit Number 47979 6001520.693580001 2121621.59135 37.805653247063 -122.439016533799 (37.805653247063, -122.439016533799)
159197 44057 1 35 708 North Point St 1 1 1 1   10/19/2000 12:00:00 AM 7   Permit Number 43584 6007279.94096 2121616.88851 37.8059663388498 -122.419085450154 (37.8059663388498, -122.419085450154)
158495 136603 2 198 1490 Jefferson St 14 9 1 1     7 Width 2ft   6002078.64435 2121585.74714 37.8055865587436 -122.437083100219 (37.8055865587436, -122.437083100219)
61737 106161 1 16 827 North Point St 1 1 1 1   03/31/2014 12:00:00 AM 3 3x3 Permit Number 770049 6006757.57528 2121490.3236599998 37.8055893943007 -122.42088419136499 (37.8055893943007, -122.420884191365)
176628 41234 1 16 3743 Webster St 1 1 1 1 1 11/30/1999 12:00:00 AM 5   Permit Number 41939 6002518.8447 2121486.57255 37.805339263172606 -122.435552627664 (37.8053392631726, -122.435552627664)
95840 51935 1 18 329 Bay St 3 1 1 1   07/22/2005 12:00:00 AM     Permit Number 48161 6009200.27838208 2121477.92859384 37.805692742557 -122.412429964781 (37.805692742557, -122.412429964781)
168116 136592 2 198 3751 Broderick St 11 9 1 1     7 Width 6ft   5999587.9447800005 2121442.35116 37.8050509432145 -122.445692167157 (37.8050509432145, -122.445692167157)
136401 136593 2 198 3751 Broderick St 12 9 1 1     5 Width 6ft   5999588.18576 2121438.86805 37.8050413932949 -122.445691082582 (37.8050413932949, -122.445691082582)
180397 136594 2 198 3751 Broderick St 14 9 1 1     7 Width 6ft   5999588.789480001 2121434.9578400003 37.805030691384204 -122.44568871197501 (37.8050306913842, -122.445688711975)
115727 93018 1 18 963 North Point St 1 1 1 1   01/08/2010 12:00:00 AM   3x3 Permit Number 53140 6006134.0 2121397.0 37.805297983444 -122.42303552725402 (37.805297983444, -122.423035527254)
7662 88451 3 18 3200X Van Ness Ave 1 11 1 2   06/07/2008 12:00:00 AM 3 5x12   6005480.84439 2121378.35155 37.805209901088396 -122.425294529632 (37.8052099010884, -122.425294529632)
187959 88452 3 18 3200X Van Ness Ave 2 11 1 2   06/07/2008 12:00:00 AM 4 5x12   6005470.42698 2121378.16696 37.8052088057127 -122.425330567252 (37.8052088057127, -122.425330567252)
170996 136595 2 198 3801 Divisadero St 2 9 1 1     13 Width 3ft   6000087.86823 2121359.44111 37.804851824321 -122.44395616894501 (37.804851824321, -122.443956168945)
57496 136596 2 198 3801 Divisadero St 3 9 1 1     5 Width 3ft   6000089.42959 2121343.8815599997 37.8048091910506 -122.443949647073 (37.8048091910506, -122.443949647073)
164242 136597 2 198 3801 Divisadero St 4 9 1 1     8 Width 3ft   6000090.23448 2121338.2924900004 37.804793890882294 -122.443946459857 (37.8047938908823, -122.443946459857)
184236 65288 1 18 41 Rico Way 1 1 1 1 1 05/07/1990 12:00:00 AM 7   Permit Number 28836 6001457.593230001 2121333.88235 37.8048596843835 -122.439214266819 (37.8048596843835, -122.439214266819)
40934 142736 2 16 15 VANDEWATER ST 2 1 1 1     3 Width 0ft   6009218.8197 2121322.4003 37.805266741303 -122.412354799662 (37.805266741303, -122.412354799662)
133655 112372 2 16 15 Vandewater St 1 1 1 1     6 3x3   6009194.601 2121319.3086 37.805256893193494 -122.412438393162 (37.8052568931935, -122.412438393162)
137394 142655 2 16 55 VANDEWATER ST 4 1 1 1     8 Width 0ft   6009102.8791 2121306.4263 37.8052163739487 -122.412754898161 (37.8052163739487, -122.412754898161)
51491 118370 2 16 55 Vandewater St 3 1 1 1     2 2x2   6009076.084 2121302.8193 37.8052049660579 -122.41284737107901 (37.8052049660579, -122.412847371079)
50875 118368 2 16 55 Vandewater St 1 1 1 1     6 2x2   6009048.7736 2121299.2122 37.8051935288948 -122.412941627226 (37.8051935288948, -122.412941627226)
27129 136601 2 198 1900 Jefferson St 4 9 1 1     8 Width 4ft   6000030.07826 2121297.6398099996 37.80467883793111 -122.444151713048 (37.8046788379311, -122.444151713048)
54813 143215 2 16 215 FRANCISCO ST 2 1 1 1     5 Width 0ft   6010264.7976 2121285.9953 37.805225422298996 -122.408732475128 (37.805225422299, -122.408732475128)
67735 135944 2 18 1998 Jefferson St 1 1 1 1     3 Width 3ft   5999737.82806 2121247.80693 37.804525333529796 -122.44515948523399 (37.8045253335298, -122.445159485234)
59892 135945 2 18 1998 Jefferson St 4 1 1 1     3 Width 3ft   5999716.32151 2121244.69535 37.8045155623958 -122.44523368650499 (37.8045155623958, -122.445233686505)
186749 136029 2 370 3743 Scott St 1 4 1 1     4 Width 2ft   6000599.31455 2121234.7075799997 37.804538500507995 -122.44217730004101 (37.804538500508, -122.442177300041)
105255 98564 3 16 301X Francisco St 2 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
112530 98567 3 16 301X Francisco St 5 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
123219 98563 3 16 301X Francisco St 1 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
138890 98565 3 16 301X Francisco St 3 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
160416 142656 2 16 382 Francisco St 1 1 1 1     7 Width 0ft   6009478.0111 2121215.2198 37.8049869916815 -122.411450254798 (37.8049869916815, -122.411450254798)
69906 142657 2 16 392 Francisco St 2 1 1 1     7 Width 0ft   6009464.6135 2121214.7045 37.8049848253291 -122.411496582459 (37.8049848253291, -122.411496582459)
154475 142658 2 16 396 Francisco St 3 1 1 1     7 Width 0ft   6009447.6089 2121213.6739 37.8049810417497 -122.411555356166 (37.8049810417497, -122.411555356166)
187914 135943 2 18 2056 Jefferson St 1 9 1 1     6 Width 8ft   5999351.778519999 2121203.50658 37.8043816542415 -122.446492250814 (37.8043816542415, -122.446492250814)
134214 142744 2 16 410 FRANCISCO ST 1 1 1 1     8 Width 0ft   6009308.9956 2121195.6387 37.804923745513 -122.41203376959 (37.804923745513, -122.41203376959)
4622 142543 3 16 301 FRANCISCO ST 5 1 1 4     6 Width 0ft   6009503.7886 2121178.1337 37.8048866083098 -122.411358426924 (37.8048866083098, -122.411358426924)
4558 142520 3 16 301 FRANCISCO ST 3 1 1 4     7 Width 0ft   6009467.3323 2121175.1455 37.8048763586912 -122.411484377145 (37.8048763586912, -122.411484377145)
4611 142519 3 16 301 FRANCISCO ST 2 1 1 4     6 Width 0ft   6009452.9889 2121171.5596 37.804865708173104 -122.411533760714 (37.8048657081731, -122.411533760714)
4605 142542 3 16 301 FRANCISCO ST 1 1 1 4     8 Width 0ft   6009433.8643 2121170.962 37.8048629945672 -122.411599901453 (37.8048629945672, -122.411599901453)
70496 249782 2 198 115 Pfeiffer St 1 13 1 1     4 Width 0ft   6010481.39254 2121146.06325 37.804853332490296 -122.40797304381701 (37.8048533324903, -122.407973043817)
152357 136602 2 198 3698 Beach St 1 9 1 1     12 Width 5ft   6002136.39741 2121144.63129 37.8043786541109 -122.43685163990101 (37.8043786541109, -122.436851639901)
129840 249783 2 198 115 Pfeiffer St 2 13 1 1     4 Width 0ft   6010478.38783 2121144.55662 37.804849027432105 -122.407983335672 (37.8048490274321, -122.407983335672)
185006 52876 1 18 118@ BEACH Cervantes Blvd 2 1 1 1   07/10/2006 12:00:00 AM 3   Permit Number 48887 6001354.74762 2121139.05445 37.8043188860645 -122.439556198976 (37.8043188860645, -122.439556198976)
25791 135673 2 133 3639 Webster St 1 4 1 1     5 Width 3ft   6002560.08245 2121134.92796 37.8043760820531 -122.435384749408 (37.8043760820531, -122.435384749408)
57824 142965 2 198 111 Pfeiffer St 3 1 1 1     9 Width 0ft   6010321.3688 2121130.7743 37.8048023922739 -122.40852574641599 (37.8048023922739, -122.408525746416)
156227 52875 1 18 118@ BEACH Cervantes Blvd 1 1 1 1   07/10/2006 12:00:00 AM 5 3x3 Permit Number 48887 6001367.786590001 2121129.52184 37.8042934541427 -122.439510392889 (37.8042934541427, -122.439510392889)
135712 142964 2 198 115 Pfeiffer St 2 1 1 1     5 Width 0ft   6010284.5248 2121125.6441 37.8047862425651 -122.408652887366 (37.8047862425651, -122.408652887366)
137419 142963 2 198 119 Pfeiffer St 1 1 1 1     9 Width 0ft   6010263.5377 2121122.3795 37.804776103337296 -122.408725285275 (37.8047761033373, -122.408725285275)
166742 142968 2 198 123 PFEIFFER ST 1 1 1 1     9 Width 0ft   6010234.1558 2121117.7157 37.8047616520024 -122.408826635586 (37.8047616520024, -122.408826635586)
46269 41181 1 18 1780 Beach St 1 1 1 1 1 11/24/1999 12:00:00 AM 11   Permit Number 41899 6001559.95191 2121091.33566 37.8041995397404 -122.438842652585 (37.8041995397404, -122.438842652585)
149267 41180 1 18 1780 Beach St 2 1 1 1 1 11/24/1999 12:00:00 AM 3   Permit Number 41899 6001541.153 2121088.1531 37.804189731738 -122.43890747929701 (37.804189731738, -122.438907479297)
128967 142540 2 16 2100 POWELL ST 9 1 1 1     9 Width 0ft   6009421.7884 2121061.7254 37.8045623807522 -122.411633968656 (37.8045623807522, -122.411633968656)
32276 31868 1 16 3633 Broderick St 1 1 1 1 1 11/29/1999 12:00:00 AM 7   Permit Number 41912 5999648.6988 2121058.91348 37.804001595372604 -122.445454333359 (37.8040015953726, -122.445454333359)
87567 100981 3 468 2190 Powell St 2 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
89035 100982 3 468 2190 Powell St 3 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
97910 100983 3 16 2190 Powell St 4 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
107842 100984 3 16 2190 Powell St 5 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
119959 100985 3 18 2190 Powell St 6 1 1 4 4 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
140818 100980 3 468 2190 Powell St 1 1 1 4 4 05/03/2013 12:00:00 AM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
145388 100987 3 16 2190 Powell St 8 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
169417 249809 2 16 258 Chestnut St 8 13 1 1     5 Width 0ft   6010708.4562800005 2121025.2354099997 37.804534279087704 -122.407178739215 (37.8045342790877, -122.407178739215)
53839 249807 2 16 258 Chestnut St 6 13 1 1     7 Width 0ft   6010752.11734 2121021.55825 37.8045266258517 -122.407027386026 (37.8045266258517, -122.407027386026)
154849 135905 2 35 2843 Larkin St 13 9 1 1     3 Width 5ft   6006460.32075 2121020.9303099997 37.804283800830795 -122.42187952052099 (37.8042838008308, -122.421879520521)
52205 249810 2 16 258 Chestnut St 9 13 1 1     5 Width 0ft   6010696.08755 2121019.21593 37.804517058874396 -122.407221117962 (37.8045170588744, -122.407221117962)
156801 249808 2 16 258 Chestnut St 7 13 1 1     12 Width 0ft   6010714.23144 2121016.75548 37.80451131849129 -122.40715815553101 (37.8045113184913, -122.407158155531)
127326 108693 1 18 1950X Beach St 2 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774617 6001046.33677 2120996.58295 37.803910139733794 -122.440613252117 (37.8039101397338, -122.440613252117)
139925 108694 1 18 1950X Beach St 3 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774617 6001046.33677 2120996.58295 37.803910139733794 -122.440613252117 (37.8039101397338, -122.440613252117)
143086 108692 1 18 1950X Beach St 1 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774617 6001046.33677 2120996.58295 37.803910139733794 -122.440613252117 (37.8039101397338, -122.440613252117)
165767 135928 2 18 1960 Beach St 1 1 1 1     2 Width 3ft   6000881.44205 2120995.2314 37.8038970374844 -122.44118378211901 (37.8038970374844, -122.441183782119)
64989 142537 2 16 2100 POWELL ST 6 1 1 1     11 Width 0ft   6009436.3973 2120993.5505 37.8043760089549 -122.411578593269 (37.8043760089549, -122.411578593269)
172041 135929 2 18 1960 Beach St 2 1 1 1     2 Width 3ft   6000857.17484 2120992.84894 37.8038891135616 -122.44126758904 (37.8038891135616, -122.44126758904)
154793 135930 2 18 1960 Beach St 3 1 1 1     2 Width 3ft   6000826.2402099995 2120988.3379599997 37.8038749654115 -122.441374316075 (37.8038749654115, -122.441374316075)
32782 142536 2 16 2100 POWELL ST 5 1 1 1     13 Width 0ft   6009440.4553 2120971.6371 37.8043160678486 -122.411563000977 (37.8043160678486, -122.411563000977)
58041 135851 2 16 787 Francisco St 1 1 1 1     15 Width 3ft   6007518.53532 2120901.3436 37.804015067204105 -122.41820899156299 (37.8040150672041, -122.418208991563)
60338 135850 2 16 2456 Leavenworth St 3 1 1 1     12 Width 2ft   6007513.5376 2120862.81684 37.803909001168606 -122.418223553398 (37.8039090011686, -122.418223553398)
137794 142584 2 35 2232 Mason St 3 1 1 1     12 Width 0ft   6008967.5673 2120856.1596 37.803972458794796 -122.41319130359699 (37.8039724587948, -122.413191303597)
23468 136049 2 237 2258 Beach St 2 1 1 1     7 Width 3ft   5999403.25073 2120854.72135 37.8034269240649 -122.44628902201299 (37.8034269240649, -122.446289022013)
43716 136598 2 198 2298 Beach St 1 9 1 1     14 Width 6ft   5999341.14558 2120854.69423 37.803423302506 -122.446503936615 (37.803423302506, -122.446503936615)
135196 136599 2 198 2298 Beach St 2 9 1 1     5 Width 6ft   5999338.92824 2120854.31751 37.8034221414854 -122.44651158266001 (37.8034221414854, -122.44651158266)
40688 136600 2 198 2298 Beach St 3 9 1 1     5 Width 6ft   5999337.17722 2120854.21997 37.8034217736525 -122.44651763508999 (37.8034217736525, -122.44651763509)
67124 135849 2 16 2456 Leavenworth St 2 1 1 1     10 Width 3ft   6007515.30382 2120841.49853 37.8038505659037 -122.418215928918 (37.8038505659037, -122.418215928918)
49365 142583 2 35 2234 Mason St 2 1 1 1     13 Width 0ft   6008971.4462 2120841.4199 37.80393220502779 -122.41317683745301 (37.8039322050278, -122.413176837453)
98671 50376 1 16 1620 Montgomery St 5 1 1 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
112875 50379 1 16 1620 Montgomery St 3 1 1 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
144023 50380 1 16 1620 Montgomery St 4 1 1 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
136311 142582 2 35 2236 Mason St 1 1 1 1     15 Width 0ft   6008972.9977 2120827.456 37.8038939507527 -122.413170480356 (37.8038939507527, -122.413170480356)
183700 68974 1 16 3555 Broderick St 1 1 1 1 1 01/04/1994 12:00:00 AM 8   Permit Number 32964 5999680.68438 2120824.08507 37.803358645751295 -122.44532675102501 (37.8033586457513, -122.445326751025)
31936 48575 1 18 2275 Beach St 1 1 1 1   08/27/2002 12:00:00 AM 6   Permit Number 45888 5999350.9725 2120803.18902 37.80328244439271 -122.446466222664 (37.8032824443927, -122.446466222664)
Powered by Datasette · Query took 68.089ms · Data source: data.sfgov.org