sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9 203507 2 7 920 Kirkham St 2 1 1 1     23 Width 3ft   5991972.62617 2105259.8491700003 37.76018051163321 -122.470866084321 (37.7601805116332, -122.470866084321)
22 203506 2 7 910 Kirkham St 4 1 1 1     15 Width 3ft   5992059.0 2105289.0 37.760265546982495 -122.470569484113 (37.7602655469825, -122.470569484113)
1165 249373 1 7 649 Jones St 1 4 1 1   06/22/1998 12:00:00 AM 21 Width 4ft Permit Number 39973 6008805.56783 2114728.1661400003 37.78713740130579 -122.4133182966 (37.7871374013058, -122.4133182966)
2135 57208 1 7 2238 Divisadero St 1 1 1 1   03/26/2015 12:00:00 AM 3   Permit Number 775007 6000879.71894 2116143.1485 37.7905743988346 -122.440841472269 (37.7905743988346, -122.440841472269)
2378 221860 1 7 516 Douglass St 1 1 1 1   05/27/1998 12:00:00 AM 15 Width 3ft Permit Number 39568 6001163.03933 2103237.69221 37.7551553815387 -122.438935950032 (37.7551553815387, -122.438935950032)
3745 221791 1 7 867 Hampshire St 1 1 1 1   05/15/1991 12:00:00 AM 30 Width 6ft Permit Number 29826 6010196.62735 2104192.74111 37.7582875664398 -122.407762355146 (37.7582875664398, -122.407762355146)
4866 253703 2 7 1221 Clayton St 1 1 1 1       3x3   5998953.0 2105574.0 37.7614443133046 -122.44674697738199 (37.7614443133046, -122.446746977382)
5123 175078 2 7 1584 Alemany Blvd 1 1 1 1     15 Width 3ft   6001809.644719999 2092991.8257799998 37.7270593952569 -122.435966703417 (37.7270593952569, -122.435966703417)
5762 107230 2 7 1445 Greenwich St 1 1 1 1     12 3x3   6005960.15833 2119639.59713 37.8004627936866 -122.423512110213 (37.8004627936866, -122.423512110213)
9773 114349 1 7 1240 46th Ave 1 1 1 1   01/14/2016 12:00:00 AM   3x15 Permit Number 777354 5981849.8 2106648.5 37.7634027199113 -122.50597849798001 (37.7634027199113, -122.50597849798)
11084 121328 2 7 2455 32nd Ave 1 1 1 1     15 3x3   5986403.9195 2098529.3345 37.7413767161187 -122.48963038732401 (37.7413767161187, -122.489630387324)
11329 1275 3 7 3995X Alemany Blvd 11 1 1 2     18 3X3   5992427.65168 2087335.5500599998 37.710991191174 -122.467988584733 (37.710991191174, -122.467988584733)
11336 97263 1 7 220 Gaven St 1 1 1 1   12/24/2014 12:00:00 AM 3 3x3 Permit Number 773740 6009330.61336 2094994.9708200002 37.732983995812795 -122.41010807752599 (37.7329839958128, -122.410108077526)
11746 1274 1 7 3995X Alemany Blvd 12 1 1 1   01/20/2017 12:00:00 AM 3 3X3 Permit Number 778829 5992454.25389 2087344.9239400001 37.71101846581121 -122.467897323323 (37.7110184658112, -122.467897323323)
11911 1278 3 7 3995X Alemany Blvd 16 1 1 2   02/21/1990 12:00:00 AM 12 3X3   5992545.036040001 2087392.68167 37.711154838998 -122.467587032028 (37.711154838998, -122.467587032028)
12345 96872 2 7 620 Palmetto Ave 5 1 1 1     12 2x3   5991838.49017 2087239.3222700001 37.7106929318927 -122.470017846453 (37.7106929318927, -122.470017846453)
12394 1269 3 7 3995X Alemany Blvd 8 1 1 2     12 3X3   5992328.07158 2087287.97745 37.7108548170665 -122.468329295555 (37.7108548170665, -122.468329295555)
12505 1266 3 7 3995X Alemany Blvd 3 1 1 2     18 3x3   5992143.8312800005 2087204.7899900002 37.7106157610663 -122.46896001711 (37.7106157610663, -122.46896001711)
12571 1265 3 7 3995X Alemany Blvd 4 1 1 2   04/22/2008 12:00:00 AM 3 3x3   5992172.84146 2087217.03484 37.710651058571294 -122.468860642897 (37.7106510585713, -122.468860642897)
12826 117427 1 7 690 Athens St 1 1 1 1   06/14/2016 12:00:00 AM 3   Permit Number 776915 6002940.91679 2089412.4481900001 37.7172954225231 -122.431800455543 (37.7172954225231, -122.431800455543)
13215 96870 2 7 620 Palmetto Ave 4 1 1 1     12 2x3   5991859.908319999 2087240.59875 37.710697674923104 -122.469943914081 (37.7106976749231, -122.469943914081)
16903 203213 2 7 626 Paris St 1 1 1 1     3 10x4 Permit Number 779632 6001387.0 2090021.0 37.7188781603148 -122.437215155763 (37.7188781603148, -122.437215155763)
17027 4845 1 7 202 Cortland Ave 1 1 1 1   10/27/1992 12:00:00 AM 24 3X3   6006694.31051 2097440.2331 37.7395500270059 -122.41939589431999 (37.7395500270059, -122.41939589432)
17413 225 3 7 2962 19th Ave 1 1 1 2   10/17/1991 12:00:00 AM 40 3X4   5990608.66265 2095460.33335 37.7331946143326 -122.47486804133301 (37.7331946143326, -122.474868041333)
18583 26511 1 7 2850 Harrison St 1 1 1 1     12 3x3   6008945.12722 2101866.39993 37.75182981809429 -122.411926215341 (37.7518298180943, -122.411926215341)
19069 4572 1 7 233 Coleridge St 1 1 1 1   11/30/2015 12:00:00 AM 1 6x6 Permit Number 775065 6006398.09865 2098473.12689 37.742369434016 -122.420493366683 (37.742369434016, -122.420493366683)
20064 4846 1 7 210 Cortland Ave 1 1 1 1   10/27/1992 12:00:00 AM 15 3X3   6006713.9746 2097429.76412 37.7395223890352 -122.419327161814 (37.7395223890352, -122.419327161814)
21024 228 3 7 2974 19th Ave 1 1 1 2   01/10/1992 12:00:00 AM 70 3X4   5990613.87863 2095369.93557 37.732946707226205 -122.47484341251601 (37.7329467072262, -122.474843412516)
21771 27336 1 7 615 Bosworth St 1 1 1 1   07/27/2000 12:00:00 AM 3 2X3   6002282.10236 2095328.3579400002 37.7335018092598 -122.434500417276 (37.7335018092598, -122.434500417276)
22901 183545 4 7 2580 26th Ave 1 1 1 1   03/13/2017 12:00:00 AM 3 4x4 Permit Number 777874 5988340.9772 2097760.0505 37.73937736557679 -122.482876432223 (37.7393773655768, -122.482876432223)
22945 104992 2 7 2423 47TH AVE 1 2 1 1   01/14/2016 12:00:00 AM 10 2x6 Permit Number 775156 5981729.7 2098576.9 37.74123331264771 -122.505795454359 (37.7412333126477, -122.505795454359)
23487 203522 2 7 62 Aloha Ave 1 1 1 1     1 Width 2ft   5991862.2088 2104389.33207 37.757783914625705 -122.471184538744 (37.7577839146257, -122.471184538744)
23776 40163 1 7 39201 Dashiell Hammett St 1 1 1 1     18   Permit Number 41356 6010358.38502 2116055.23844 37.7908682829043 -122.40803948753 (37.7908682829043, -122.40803948753)
24259 175213 2 7 87 Valmar Ter 2 1 1 1     11 Width 3ft   6005270.21686 2092560.99775 37.726072420781705 -122.423972920124 (37.7260724207817, -122.423972920124)
25502 109922 2 7 20 Dashiell Hammett St 4 1 1 1     10 3x3   6010385.90065 2115990.02467 37.790690762107204 -122.40793968347602 (37.7906907621072, -122.407939683476)
25751 221793 2 7 26 Norwich St 1 1 1 1     14 Width 5ft   6009169.37019 2099491.8572 37.745322428990995 -122.410983048655 (37.745322428991, -122.410983048655)
25764 104693 1 7 2132 Clement St 1 1 1 1   10/31/2013 12:00:00 AM 2 3x3 Permit Number 770783 5988848.42745 2113351.68498 37.7822172841496 -122.482263939923 (37.7822172841496, -122.482263939923)
26216 221933 2 7 4166 17th St 1 1 1 1     1 Width 3ft   6001253.22781 2105851.44827 37.7623372504834 -122.43881134358601 (37.7623372504834, -122.438811343586)
26999 221859 2 7 861 Elizabeth St 1 1 1 1     1 Width 4ft   6000847.19345 2101982.1025099996 37.7516898602076 -122.43993821209499 (37.7516898602076, -122.439938212095)
28549 189215 2 7 1400 20th St 2 4 1 1     14 Width 3ft   6013696.2967300005 2104791.67795 37.7601274111746 -122.39570084212299 (37.7601274111746, -122.395700842123)
28689 248075 2 7 407 Holladay Ave 1 1 1 1     11 Width 3ft   6010292.794840001 2098665.98806 37.743117705012004 -122.407040212138 (37.743117705012, -122.407040212138)
28728 175190 2 7 2201 Bay Shore Blvd 7 1 1 1     24 Width 3ft   6011418.48668 2087333.2761400002 37.712063358416295 -122.402351191059 (37.7120633584163, -122.402351191059)
29547 218232 2 7 371 Wawona St 1 4 1 1     33 Width 2ft   5991901.5455 2097060.86466 37.7376641082099 -122.47051476505 (37.7376641082099, -122.47051476505)
29783 175207 2 7 9 Athens St 1 1 1 1     14 Width 2ft   6005359.84242 2093211.4983700002 37.7278636122004 -122.423709320725 (37.7278636122004, -122.423709320725)
30409 221881 2 7 4 Coleridge St 1 1 1 1     24 Width 3ft   6007048.87361 2099774.96937 37.745980654479204 -122.41833546232401 (37.7459806544792, -122.418335462324)
30513 203538 2 7 313 Hearst Ave 2 1 1 1     11 Width 2ft   5999326.9827 2094355.3161799998 37.7306618716326 -122.444647158563 (37.7306618716326, -122.444647158563)
30611 113546 1 7 2017 19th St 1 1 1 1   09/30/2015 12:00:00 AM 1   Permit Number 775016 6011705.090480001 2105100.1338299997 37.7608633956443 -122.40260920746701 (37.7608633956443, -122.402609207467)
30945 203540 2 7 305 Foerster St 1 1 1 1     16 Width 3ft   5998091.5711199995 2094441.2535 37.7308272605603 -122.448924334186 (37.7308272605603, -122.448924334186)
31047 38227 1 7 1099 Mississippi St 4 1 1 1   07/21/1998 12:00:00 AM 14   Permit Number 40351 6014264.01456 2102105.05687 37.7527820922208 -122.39354933016199 (37.7527820922208, -122.393549330162)
31166 125541 2 7 65 Heather Ave 1 10 1 1     4     5997339.5515 2114115.46943 37.7848046777406 -122.45294375606501 (37.7848046777406, -122.452943756065)
31428 221908 2 7 1175 Noe St 1 1 1 1     15 Width 5ft   6003228.296569999 2101452.81084 37.750371807525504 -122.431666264992 (37.7503718075255, -122.431666264992)
31679 181649 2 7 1265 32nd Ave 1 1 1 1     17 Width 0ft   5986124.6924 2106639.2388 37.763627996398796 -122.491192553457 (37.7636279963988, -122.491192553457)
32063 221835 2 7 585 Capp St 2 1 1 1     14 Width 3ft   6007295.482009999 2103941.6910599996 37.7574354039359 -122.41777801665 (37.7574354039359, -122.41777801665)
32259 248073 2 7 440 Holladay Ave 1 1 1 1     23 Width 3ft   6010194.1579599995 2098463.12553 37.7425551682987 -122.407366975408 (37.7425551682987, -122.407366975408)
32786 221912 2 7 424 Alvarado St 1 1 1 1     1 Width 3ft   6003582.2659599995 2102758.00468 37.7539756202844 -122.43053533425 (37.7539756202844, -122.43053533425)
32856 138631 2 7 1704 Baker St 2 1 1 1     12 Width 0ft   6000076.1375 2114809.8269 37.786867647634395 -122.443525989893 (37.7868676476344, -122.443525989893)
33071 175210 2 7 66 Madison St 3 1 1 1     17 Width 2ft   6005427.44885 2093231.2859200002 37.72792176057511 -122.423477009653 (37.7279217605751, -122.423477009653)
33188 247526 2 7 1101 Waller St 7 17 1 1     25     6000042.11565 2108480.23517 37.76948626629979 -122.44318892675 (37.7694862662998, -122.44318892675)
33303 221855 2 7 310 Hoffman Ave 1 1 1 1     10 Width 3ft   6000611.21677 2101947.64163 37.751581803057206 -122.440751776575 (37.7515818030572, -122.440751776575)
33683 221802 2 7 325 Day St 1 10 1 1     18 Width 3ft   6003816.248819999 2098634.77002 37.7426674306639 -122.42943214577 (37.7426674306639, -122.42943214577)
33735 221857 2 7 679 Duncan St 1 1 1 1     8 Width 2ft   6002187.97645 2099712.9638400003 37.7455355755051 -122.435139333412 (37.7455355755051, -122.435139333412)
34188 221823 2 7 588 Ogden Ave 6 10 1 1     13 Width 4ft   6007760.27568 2096148.55485 37.7360633428545 -122.41561880828199 (37.7360633428545, -122.415618808282)
34380 221910 2 7 1175 Noe St 3 1 1 1     17 Width 5ft   6003225.80615 2101486.76003 37.750464882852604 -122.43167730058599 (37.7504648828526, -122.431677300586)
35521 244965 2 7 250 Lily St 3 1 1 1     14 Width 0ft   6005276.5809 2110102.9361 37.774238893094896 -122.42519859053002 (37.7742388930949, -122.42519859053)
35641 51092 1 7 1962 29th Ave 1 1 1 1   07/26/2004 12:00:00 AM 8   Permit Number 47549 5987266.4855 2101911.4788 37.75071350308671 -122.486896287824 (37.7507135030867, -122.486896287824)
35978 175198 2 7 648 Peru Ave 2 17 1 1     12     6005048.079 2092617.03467 37.726213742054604 -122.424744822616 (37.7262137420546, -122.424744822616)
35991 221810 2 7 1214 Cole St 1 1 1 1     1 Width 3ft   5998223.78162 2106145.0747700003 37.762970657401205 -122.44931017573299 (37.7629706574012, -122.449310175733)
36004 203502 2 7 1277 17th Ave 1 1 1 1     4 Width 3ft   5990781.19981 2106711.0066299997 37.7640960267437 -122.47509255800301 (37.7640960267437, -122.475092558003)
36093 203577 2 7 268 Joost Ave 1 1 1 1     23 Width 4ft   6000290.88836 2094968.3024400002 37.7323999463844 -122.44135876589701 (37.7323999463844, -122.441358765897)
36231 203575 2 7 60 Mangels Ave 1 9 1 1     12 Width 5ft   6001009.56246 2095231.0134 37.7331622045591 -122.438892966938 (37.7331622045591, -122.438892966938)
36915 125556 2 7 22 Dashiell Hammett St 5 1 1 1     12 Width 1ft   6010373.889880001 2116082.2243 37.7909432476765 -122.407987745034 (37.7909432476765, -122.407987745034)
37344 221931 2 7 2136 15th St 1 1 1 1     2 Width 3ft   6003273.64696 2107146.54353 37.76600800788229 -122.431915952764 (37.7660080078823, -122.431915952764)
37393 90780 3 7 3745 Cabrillo St 1 1 1 2   04/07/2008 12:00:00 AM 3 3x3   5983969.87464 2110351.83219 37.7736955796118 -122.498919582943 (37.7736955796118, -122.498919582943)
37550 203520 2 7 1537 06th Ave 1 1 1 1     7 Width 2ft   5994273.74981 2105115.42997 37.7599167854573 -122.46289717008699 (37.7599167854573, -122.462897170087)
37591 125540 2 7 47 Casa Way 1 1 1 1     1 Width 3ft   6001554.266480001 2121557.3314 37.8054787165372 -122.438895742254 (37.8054787165372, -122.438895742254)
39283 203548 2 7 181 Flood Ave 2 1 1 1     1 Width 3ft   5999484.36005 2094058.99303 37.7298572167403 -122.44408179885401 (37.7298572167403, -122.444081798854)
39285 221786 2 7 65 Scott St 1 4 1 1     20 Width 2ft   6002363.3837 2108638.99661 37.7700542727214 -122.435171122647 (37.7700542727214, -122.435171122647)
39493 221819 2 7 68 Santa Marina St 1 1 1 1     1 Width 3ft   6006048.67396 2097610.71259 37.7399817402673 -122.421640334157 (37.7399817402673, -122.421640334157)
40283 221794 2 7 63 Mullen Ave 1 1 1 1     4 Width 3ft   6009581.165709999 2099887.27047 37.7464312301328 -122.40958702472099 (37.7464312301328, -122.409587024721)
40525 83821 1 7 1514 46th Ave 1 1 1 1   01/23/2008 12:00:00 AM 6 3x3 Permit Number 50163 5981890.7885 2104754.0668 37.75820356042521 -122.505696289301 (37.7582035604252, -122.505696289301)
40604 125547 2 7 1445 Greenwich St 3 1 1 1     13 Width 4ft   6005968.56582 2119641.09275 37.8004673748183 -122.423483123267 (37.8004673748183, -122.423483123267)
40674 124538 2 7 1001 Balboa St 10 1 1 1     12 Width 4ft   5992462.99268 2111339.00328 37.776900593517205 -122.469612710685 (37.7769005935172, -122.469612710685)
40716 124539 2 7 1001 Balboa St 8 1 1 1     18 Width 4ft   5992452.39614 2111338.25505 37.7768979266396 -122.46964931253001 (37.7768979266396, -122.46964931253)
40756 83009 1 7 622 De Haro St 1 1 1 1   07/02/2009 12:00:00 AM 10 3x3 Permit Number 52378 6012068.99141 2105489.9515299997 37.7619540583423 -122.40137802299499 (37.7619540583423, -122.401378022995)
41259 221817 2 7 25 Winfield St 1 1 1 1     24 Width 3ft   6007435.65723 2099387.93304 37.744939704512205 -122.416970595441 (37.7449397045122, -122.416970595441)
41444 118284 2 7 3549 Cabrillo St 4 1 1 1     8 Width 3ft   5984589.17158 2110373.61993 37.773791708306 -122.496778979398 (37.773791708306, -122.496778979398)
41955 83487 1 7 2051 44th Ave 1 1 1 1   01/23/2008 12:00:00 AM 10 3x3 Permit Number 50156 5982589.2289 2101159.5488 37.7483751044578 -122.503014711943 (37.7483751044578, -122.503014711943)
42022 221917 2 7 1033 Sanchez St 1 1 1 1     18 Width 3ft   6003826.31981 2102255.52555 37.7526097533439 -122.429655503209 (37.7526097533439, -122.429655503209)
43081 123202 2 7 1310 09th Ave 1 1 1 1     15 Width 4ft   5993110.48216 2112011.5710299998 37.7787846837447 -122.467421785255 (37.7787846837447, -122.467421785255)
43186 221869 2 7 673 Andover St 1 1 1 1     15 Width 3ft   6007432.02888 2095820.07599 37.7351429550833 -122.416730429683 (37.7351429550833, -122.416730429683)
44268 203544 2 7 522 Hearst Ave 1 1 1 1     19 Width 2ft   5997938.28847 2094411.0721200001 37.730735622335 -122.449452080662 (37.730735622335, -122.449452080662)
44514 248074 2 7 440 Holladay Ave 2 1 1 1     21 Width 3ft   6010189.61639 2098448.43347 37.742514572897 -122.407381643363 (37.742514572897, -122.407381643363)
44597 203581 2 7 24 Gennessee St 1 1 1 1     19 Width 4ft   5997456.8868 2093709.9818900002 37.7287830449036 -122.451065815142 (37.7287830449036, -122.451065815142)
45131 221870 2 7 530 Banks St 1 1 1 1     16 Width 3ft   6008584.18129 2096552.27767 37.7372181568784 -122.412798757353 (37.7372181568784, -122.412798757353)
45263 221889 2 7 190 Bartlett St 2 1 1 1     15 Width 3ft   6006689.37303 2102664.80303 37.7538952362014 -122.419783585756 (37.7538952362014, -122.419783585756)
45288 125558 2 7 39 Dashiell Hammett St 2 1 1 1     18 Width 1ft   6010359.2219 2116035.15877 37.790813195815794 -122.408035175278 (37.7908131958158, -122.408035175278)
45348 123272 2 7 550 07th Ave 1 1 1 1     6 Width 4ft   5993787.321169999 2111737.84714 37.7780721632368 -122.465060466509 (37.7780721632368, -122.465060466509)
45546 221848 2 7 19 Saint Marys Ave 4 1 1 1     10 Width 2ft   6004429.19741 2095585.11426 37.7343284525969 -122.427095576708 (37.7343284525969, -122.427095576708)
46056 203567 2 7 209 Colon Ave 3 2 1 1     18 Width 3ft   5996068.02094 2094221.27645 37.7301073235953 -122.455904133578 (37.7301073235953, -122.455904133578)
46327 203556 2 7 209 Farallones St 3 1 1 1     10 Width 2ft   5994991.30881 2088378.07982 37.7140014477822 -122.45920347906001 (37.7140014477822, -122.45920347906)
46344 221789 2 7 3456 22nd St 1 1 1 1     21 Width 5ft   6005341.04131 2103147.38287 37.7551442389361 -122.424480760089 (37.7551442389361, -122.424480760089)
Powered by Datasette · Query took 5.759ms · Data source: data.sfgov.org