sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
6932 36849 1 26   3 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
7300 36853 1 26   7 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
7845 36850 1 26   4 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
10591 36848 1 26   2 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
13714 36844 1 26   8 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
14679 36852 1 26   6 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
14747 36851 1 26   5 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
16842 36847 1 26   1 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
131406 246712 2 26 1 Bonview St 18 2 1 1     7     6007754.64499 2099212.81872 37.7444768180465 -122.41585519326999 (37.7444768180465, -122.41585519327)
25017 234053 2 26 1 Brook St 6 1 1 1     8 Width 3ft   6005540.23116 2097855.95931 37.740626448943296 -122.423415751429 (37.7406264489433, -122.423415751429)
158551 234052 2 26 1 Brook St 4 4 1 1     10 Width 3ft   6005500.71002 2097843.84085 37.7405909437068 -122.42355153917102 (37.7405909437068, -122.423551539171)
162260 234051 2 26 1 Brook St 3 4 1 1     12 Width 3ft   6005484.21565 2097842.60321 37.7405866143931 -122.42360848244101 (37.7405866143931, -122.423608482441)
169069 234055 2 26 1 Brook St 8 1 1 1     13 Width 3ft   6005570.68759 2097858.4870599997 37.740635108510496 -122.423310624296 (37.7406351085105, -122.423310624296)
173799 234054 2 26 1 Brook St 7 1 1 1     13 Width 3ft   6005553.57285 2097857.89262 37.740632510382 -122.42336975833099 (37.740632510382, -122.423369758331)
99591 48511 1 26 1 Church St 4 1 1 1   08/22/2002 12:00:00 AM     Permit Number 45844 6004110.55275805 2108703.1215343 37.7703294028669 -122.42913226260099 (37.7703294028669, -122.429132262601)
107490 48507 1 26 1 Church St 1 1 1 1   08/22/2002 12:00:00 AM     Permit Number 45844 6004110.55275805 2108703.1215343 37.7703294028669 -122.42913226260099 (37.7703294028669, -122.429132262601)
109791 48514 1 26 1 Church St 2 1 1 1   08/22/2002 12:00:00 AM     Permit Number 45844 6004110.55275805 2108703.1215343 37.7703294028669 -122.42913226260099 (37.7703294028669, -122.429132262601)
40887 194779 2 26 1 Flora St 10 4 1 1     2 Width 3ft   6013891.08255 2094437.3418 37.7317074216406 -122.39430219851101 (37.7317074216406, -122.394302198511)
47073 194776 2 26 1 Flora St 1 4 1 1     3 Width 3ft   6013845.42665 2094215.0863299998 37.731094615528995 -122.394444484728 (37.731094615529, -122.394444484728)
133745 194780 2 26 1 Flora St 12 4 1 1     5 Width 3ft   6013896.88916 2094468.31049 37.731792778107604 -122.394284291187 (37.7317927781076, -122.394284291187)
155280 194778 2 26 1 Flora St 4 4 1 1     6 Width 3ft   6013858.89274 2094278.65917 37.7312699221594 -122.394402379375 (37.7312699221594, -122.394402379375)
155912 194777 2 26 1 Flora St 2 4 1 1     2 Width 3ft   6013848.41828 2094231.4751400002 37.731139782164604 -122.394435289176 (37.7311397821646, -122.394435289176)
14025 50692 1 26 1 Harrison St 8 1 1 1   06/12/2004 12:00:00 AM 4 4x4 Permit Number 47259 6015887.628819999 2115316.72883 37.789148530024704 -122.388856803509 (37.7891485300247, -122.388856803509)
24815 50693 1 26 1 Harrison St 9 1 1 1 1 06/12/2004 12:00:00 AM 3   Permit Number 47259 6015899.29772 2115328.09963 37.789180398403396 -122.388817224359 (37.7891803984034, -122.388817224359)
31060 50697 1 26 1 Harrison St 1 1 1 1 1 07/31/2004 12:00:00 AM 5   Permit Number 47259 6015787.30845 2115222.67912 37.7888847301024 -122.389197332691 (37.7888847301024, -122.389197332691)
31340 50690 1 26 1 Harrison St 5 1 1 1 1 06/12/2004 12:00:00 AM 5   Permit Number 47259 6015829.14658 2115263.74647 37.7889998109335 -122.38905544574699 (37.7889998109335, -122.389055445747)
58180 50686 1 26 1 Harrison St 6 1 1 1 1 06/12/2004 12:00:00 AM 5   Permit Number 47259 6015866.591659999 2115301.03346 37.7891042680871 -122.38892849385701 (37.7891042680871, -122.388928493857)
65933 50696 1 26 1 Harrison St 11 1 1 1 1 06/12/2004 12:00:00 AM 4   Permit Number 47259 6015925.73831 2115354.86226 37.7892553479159 -122.388727611399 (37.7892553479159, -122.388727611399)
132524 50689 1 26 1 Harrison St 4 1 1 1 1 06/12/2004 12:00:00 AM 6   Permit Number 47259 6015816.80871 2115251.31458 37.7889649918797 -122.389097265149 (37.7889649918797, -122.389097265149)
137508 50695 1 26 1 Harrison St 12 1 1 1 1 06/12/2004 12:00:00 AM 4   Permit Number 47259 6015937.15224 2115364.30383 37.7892819048945 -122.38868877958099 (37.7892819048945, -122.388688779581)
150556 50687 1 26 1 Harrison St 2 1 1 1 1 07/31/2004 12:00:00 AM 5   Permit Number 47259 6015799.79693 2115231.8840799998 37.7889106971282 -122.389154766877 (37.7889106971282, -122.389154766877)
165482 50688 1 26 1 Harrison St 3 1 1 1 1 06/12/2004 12:00:00 AM 4   Permit Number 47259 6015806.91345 2115242.27212 37.788939614816606 -122.389130870094 (37.7889396148166, -122.389130870094)
166065 50694 1 26 1 Harrison St 10 1 1 1 1 06/12/2004 12:00:00 AM 3   Permit Number 47259 6015915.16555 2115344.32909 37.7892258402606 -122.388763456582 (37.7892258402606, -122.388763456582)
185949 50691 1 26 1 Harrison St 7 1 1 1 1 06/12/2004 12:00:00 AM 5   Permit Number 47259 6015877.9319 2115306.82257 37.789120792226704 -122.38888966205201 (37.7891207922267, -122.388889662052)
59764 132675 2 26 1 Heather Ave 2 9 1 1     10 Width 9ft   5997331.41397 2114381.51283 37.7855346961081 -122.45299111975201 (37.7855346961081, -122.452991119752)
168624 132674 2 26 1 Heather Ave 1 9 1 1     8     5997331.30843 2114427.41928 37.7856607370015 -122.452994799771 (37.7856607370015, -122.452994799771)
27043 194682 2 26 1 Jack Balestreri Way 22 7 1 1     8     6012380.91774 2104784.0825900002 37.760033297111704 -122.400249606728 (37.7600332971117, -122.400249606728)
31877 194684 2 26 1 Jack Balestreri Way 28 7 1 1     9     6012406.88691 2104790.52602 37.7600524373766 -122.40016024382099 (37.7600524373766, -122.400160243821)
56843 194686 2 26 1 Jack Balestreri Way 44 7 1 1     4     6012432.36762 2104808.71902 37.760103812064706 -122.40007339538799 (37.7601038120647, -122.400073395388)
73120 194685 2 26 1 Jack Balestreri Way 43 7 1 1     3     6012432.71198 2104802.44836 37.7600866134166 -122.40007176402099 (37.7600866134166, -122.400071764021)
148136 194683 2 26 1 Jack Balestreri Way 27 7 1 1     12     6012398.62743 2104785.66422 37.7600386274099 -122.400188468119 (37.7600386274099, -122.400188468119)
150800 194681 2 26 1 Jack Balestreri Way 17 7 1 1     4     6012405.53198 2104761.19385 37.759971822165 -122.400162869837 (37.759971822165, -122.400162869837)
174735 236183 2 26 1 Penny Ln 3 13 1 1     7 Width 2ft   6002335.35488 2096511.4177599999 37.7367532424671 -122.434400864109 (37.7367532424671, -122.434400864109)
135106 234258 2 26 1 Prospect Ave 1 1 1 1     12 Width 3ft   6007356.335469999 2099625.42284 37.745587335989 -122.417261702379 (37.745587335989, -122.417261702379)
29003 211592 2 26 1 San Fernando Way 1 2 1 1     15 Width 8ft   5992116.4659 2096423.88969 37.7359275605095 -122.46972532938801 (37.7359275605095, -122.469725329388)
168332 211593 2 26 1 San Fernando Way 2 2 1 1     8 Width 8ft   5992107.01458 2096453.37497 37.736007973377205 -122.469760152022 (37.7360079733772, -122.469760152022)
84170 46737 1 26 1 Sargent St 4 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44847 5994017.67630199 2089152.6927278999 37.7160723272597 -122.46262485198 (37.7160723272597, -122.46262485198)
108156 46738 1 26 1 Sargent St 1 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44847 5994017.67630199 2089152.6927278999 37.7160723272597 -122.46262485198 (37.7160723272597, -122.46262485198)
108219 46736 1 26 1 Sargent St 3 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44847 5994017.67630199 2089152.6927278999 37.7160723272597 -122.46262485198 (37.7160723272597, -122.46262485198)
142486 46739 1 26 1 Sargent St 2 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44847 5994017.67630199 2089152.6927278999 37.7160723272597 -122.46262485198 (37.7160723272597, -122.46262485198)
76958 236156 2 26 1 Sussex St 3 1 1 1     6 Width 3ft   6002802.5744 2096155.9438099999 37.735803702267496 -122.43276009781601 (37.7358037022675, -122.432760097816)
96407 52543 1 26 1 Webster St 2 1 1 1   01/12/2006 12:00:00 AM 3 4x4 Permit Number 48641 6004341.39214804 2108373.29158865 37.7694368344775 -122.428310278261 (37.7694368344775, -122.428310278261)
96642 52544 1 26 1 Webster St 1 1 1 1   01/12/2006 12:00:00 AM 3 4x4 Permit Number 48641 6004341.39214804 2108373.29158865 37.7694368344775 -122.428310278261 (37.7694368344775, -122.428310278261)
80302 48515 1 26 1(REVISED) Church St 8 1 1 1   08/22/2002 12:00:00 AM     Permit Number 45844 6004110.55275805 2108703.1215343 37.7703294028669 -122.42913226260099 (37.7703294028669, -122.429132262601)
108841 48508 1 26 1(REVISED) Church St 18 1 1 1   08/22/2002 12:00:00 AM     Permit Number 45844 6004110.55275805 2108703.1215343 37.7703294028669 -122.42913226260099 (37.7703294028669, -122.429132262601)
117125 48510 1 26 1(REVISED) Church St 6 1 1 1   08/22/2002 12:00:00 AM     Permit Number 45844 6004110.55275805 2108703.1215343 37.7703294028669 -122.42913226260099 (37.7703294028669, -122.429132262601)
119645 48509 1 26 1(REVISED) Church St 20 1 1 1   08/22/2002 12:00:00 AM     Permit Number 45844 6004110.55275805 2108703.1215343 37.7703294028669 -122.42913226260099 (37.7703294028669, -122.429132262601)
141991 48513 1 26 1(REVISED) Church St 13 1 1 1   08/22/2002 12:00:00 AM     Permit Number 45844 6004110.55275805 2108703.1215343 37.7703294028669 -122.42913226260099 (37.7703294028669, -122.429132262601)
156995 140759 2 26 10 Beideman St 1 1 1 1     8 Width 0ft   6001565.2162 2112926.4749 37.78178125436779 -122.438239161137 (37.7817812543678, -122.438239161137)
39131 234106 2 26 10 Crescent Ave 1 17 1 1     7 Width 3ft   6005252.57338 2095904.2217 37.735251176793604 -122.424271584978 (37.7352511767936, -122.424271584978)
165697 37346 1 26 10 Curtis St 1 1 1 1 1 06/15/1998 12:00:00 AM 8   Permit Number 39854 6000448.88189 2088637.7293200002 37.7150266380306 -122.44035870091899 (37.7150266380306, -122.440358700919)
27476 235145 2 26 10 San Jose Ave 1 1 1 1     18 Width 3ft   6006174.3860599995 2102065.41685 37.7522204350421 -122.421521968085 (37.7522204350421, -122.421521968085)
36662 211806 2 26 10 Stanford Heights Ave 1 1 1 1     7 Width 3ft   5997816.16234 2095636.52302 37.7340934318661 -122.449962574533 (37.7340934318661, -122.449962574533)
62962 120712 2 26 100 21st Ave 1 1 1 1     11 Width 3ft   5989308.10234 2114637.9084900003 37.7857756190772 -122.480767882959 (37.7857756190772, -122.480767882959)
66530 234250 2 26 100 Anderson St 1 1 1 1     4 Width 3ft   6007942.739709999 2098122.6091400003 37.7414939170179 -122.415127643537 (37.7414939170179, -122.415127643537)
55911 211657 2 26 100 Burlwood Dr 1 1 1 1     18 Width 2ft   5996947.51757 2096015.0330400001 37.7350829873752 -122.452993047911 (37.7350829873752, -122.452993047911)
158018 141095 2 26 100 Cook St 1 1 1 1     8 Width 0ft   5997577.9306 2112955.9176 37.7816345116266 -122.45203535783001 (37.7816345116266, -122.45203535783)
176199 133001 2 26 100 Elm St 1 1 1 1     8 Width 4ft   6007101.26739 2112781.6713900003 37.7816969678802 -122.419076698841 (37.7816969678802, -122.419076698841)
186640 133002 2 26 100 Elm St 2 1 1 1     11 Width 4ft   6007050.35685 2112775.93042 37.781678337512105 -122.419252418291 (37.7816783375121, -122.419252418291)
77609 90441 3 26 100 Otis St 2 1 1 2   04/25/2008 12:00:00 AM 3 3x3   6006647.189885 2109151.6036549998 37.771704095793794 -122.420389859033 (37.7717040957938, -122.420389859033)
80884 90442 3 26 100 Otis St 3 1 1 2   04/25/2008 12:00:00 AM 3 3x3   6006647.189885 2109151.6036549998 37.771704095793794 -122.420389859033 (37.7717040957938, -122.420389859033)
83668 90443 3 26 100 Otis St 4 1 1 2   04/25/2008 12:00:00 AM 3 3x3   6006647.189885 2109151.6036549998 37.771704095793794 -122.420389859033 (37.7717040957938, -122.420389859033)
96784 106352 2 26 100 PUTNAM ST 2 1 1 1     12 3x3   6009115.8 2096842.2 37.7380440457606 -122.410981172443 (37.7380440457606, -122.410981172443)
127882 106351 2 26 100 PUTNAM ST 1 1 1 1     12 3x3   6009115.8 2096842.2 37.7380440457606 -122.410981172443 (37.7380440457606, -122.410981172443)
5366 19799 3 26 100 STAIRWAY21 4 1 1 2     3 40ST            
15753 19798 3 26 100 STAIRWAY21 3 1 1 2     3 40ST            
7669 19837 3 26 100 STAIRWAY25 21 1 1 2     6 60X            
1887 20008 3 26 100 STAIRWAY46 28 1 1 2     3 2            
2790 20006 3 26 100 STAIRWAY46 26 1 1 2     6 2            
12819 20005 3 26 100 STAIRWAY46 25 1 1 2     6 2            
14114 20007 3 26 100 STAIRWAY46 27 1 1 2     6 2            
10643 20031 3 26 100 STAIRWAY51 2 1 1 2     6 ST            
13103 20037 3 26 100 STAIRWAY51 8 1 1 2     12 ST            
14029 20030 3 26 100 STAIRWAY51 1 1 1 2     6 ST            
16463 20033 3 26 100 STAIRWAY51 4 1 1 2     6 ST            
15278 20067 3 26 100 STAIRWAY54 14 1 1 2     6 15ST            
56705 211553 2 26 100 San Fernando Way 1 2 1 1     4 Width 6ft   5992139.83794 2095903.04051 37.7344987904706 -122.469606618863 (37.7344987904706, -122.469606618863)
106534 211552 2 26 100 San Fernando Way 2 2 1 1     23 Width 6ft   5992136.87405 2095942.3724099998 37.7346066146902 -122.46961972826401 (37.7346066146902, -122.469619728264)
39058 62196 1 26 100 Santa Ynez Ave 1 1 1 1 1 09/20/1985 12:00:00 AM 8   Permit Number 22315 6000474.13806 2092219.5232900002 37.7248628704139 -122.440528150264 (37.7248628704139, -122.440528150264)
152610 211713 2 26 100 Tara St 1 4 1 1     14 Width 0ft   5998129.35341 2090944.33961 37.7212277153738 -122.448541965862 (37.7212277153738, -122.448541965862)
182113 211714 2 26 100 Tara St 3 4 1 1     13 Width 0ft   5998092.2362 2090928.9060400003 37.7211832160136 -122.44866915786001 (37.7211832160136, -122.44866915786)
80696 91886 3 26 1000 Irving St 4 1 1 2   12/11/2008 12:00:00 AM 3 3x3   5992689.421729 2106634.512722 37.763996404124796 -122.468487066847 (37.7639964041248, -122.468487066847)
96148 91883 3 26 1000 Irving St 1 1 1 2   12/11/2008 12:00:00 AM 3 3x3   5992689.421729 2106634.512722 37.763996404124796 -122.468487066847 (37.7639964041248, -122.468487066847)
126503 91885 3 26 1000 Irving St 3 1 1 2   12/11/2008 12:00:00 AM 3 3x3   5992689.421729 2106634.512722 37.763996404124796 -122.468487066847 (37.7639964041248, -122.468487066847)
144422 91884 3 26 1000 Irving St 2 1 1 2   12/11/2008 12:00:00 AM 3 3x3   5992689.421729 2106634.512722 37.763996404124796 -122.468487066847 (37.7639964041248, -122.468487066847)
52329 140435 2 26 1001 WEBSTER ST 2 1 1 1     10 Width 0ft   6003707.8022 2112153.0721 37.7797793101471 -122.430771610301 (37.7797793101471, -122.430771610301)
8738 23769 1 26 1001 Webster St 2 1 1 1     40 3X3   6003798.9822 2112259.587 37.780076939071 -122.430463780858 (37.780076939071, -122.430463780858)
102359 20130 3 26 1001X HAYES ST 1 1 1 2     12 3X3   6002842.0 2110620.0 37.775520785482 -122.433657198955 (37.775520785482, -122.433657198955)
93486 91937 3 26 1005 Irving St 1 1 1 2   12/11/2008 12:00:00 AM 3 3x3   5992678.9035370005 2106594.1289709997 37.763884913443604 -122.46852050741998 (37.7638849134436, -122.46852050742)
106732 65090 1 26 100X 21st Ave 1 1 1 1 1 06/26/1989 12:00:00 AM 10 6x6 Permit Number 27055 5995195.0 2114938.0 37.7869399943714 -122.46042277069799 (37.7869399943714, -122.460422770698)
139370 90440 3 26 100X Otis St 1 1 1 2   04/25/2008 12:00:00 AM 3 3x3   6006647.189885 2109151.6036549998 37.771704095793794 -122.420389859033 (37.7717040957938, -122.420389859033)
Powered by Datasette · Query took 41.427ms · Data source: data.sfgov.org