sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
484 205880 6 47 44 Mendosa Ave 1 1 1 1     43 Width 3ft   5993348.04769 2101170.42115 37.7490314462559 -122.46581205990499 (37.7490314462559, -122.465812059905)
1674 251651 6 52 3237 Harrison St 1 1 1 1       3x3   6009049.0 2099828.0 37.746238652288106 -122.411423013741 (37.7462386522881, -122.411423013741)
1693 251659 6 41 1050 North Point St 3 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1702 251658 6 41 1050 North Point St 2 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1708 251660 6 3 1050 North Point St 4 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1710 251657 6 3 1050 North Point St 1 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1717 251661 6 41 3200X Van Ness Ave 1 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
2114 107983 6 15 2405x Scott St 1 1 1 1     10 3x3   6001231.007069999 2116743.47753 37.7922427464694 -122.43966909537599 (37.7922427464694, -122.439669095376)
2151 252916 6 47 101 Gold Mine Dr 1 1 1 1       3x3   6001472.0 2098865.0 37.7431665844065 -122.437554349716 (37.7431665844065, -122.437554349716)
2572 24480 6 182 108X Sussex St 2 1 1 1   07/19/2017 12:00:00 AM 3 3x3 Permit Number 780363 6002195.08262 2096706.93645 37.737282128351005 -122.434899824187 (37.737282128351, -122.434899824187)
3037 253283 6 44 673 San Jose Ave 1 1 1 1       3x3   6005929.0 2099335.0 37.7447094953859 -122.422176588207 (37.7447094953859, -122.422176588207)
3204 253366 6 201 20 Laussat St 1 1 1 1       3x3   6004582.0 2109434.0 37.772362894278395 -122.427553605007 (37.7723628942784, -122.427553605007)
3879 253286 6 17 40 Mendosa Ave 1 1 1 1   10/02/2017 12:00:00 AM 3 6x10 Permit Number 780599 5993445.0 2101187.0 37.7490825597194 -122.465478005037 (37.7490825597194, -122.465478005037)
8728 121206 6 12 930 Chestnut St 2 1 1 1   11/22/2016 12:00:00 AM 3 3x3 Permit Number 778903 6007356.48577 2120579.5282099997 37.803122321012296 -122.418746939923 (37.8031223210123, -122.418746939923)
9148 85030 6 17 411 Panama St 1 1 1 1   06/26/2007 12:00:00 AM     Permit Number 49384          
9738 173675 6 258 299x Beale St 5 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9740 173671 6 75 299x Beale St 1 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9741 173676 6 258 299x Beale St 6 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9743 173674 6 135 299x Beale St 4 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9744 173673 6 135 299x Beale St 3 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9749 173677 6 258 299x Beale St 7 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9750 173672 6 135 299x Beale St 2 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
9752 173678 6 75 299x Beale St 8 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
10151 173889 6 67 190 Holladay Ave 1 1 1 1       3x3   6010824.0 2099939.0 37.746642831954496 -122.405293064953 (37.7466428319545, -122.405293064953)
10461 92319 6 35 2788 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985889.2586 2096423.8922 37.7355656712712 -122.491254961509 (37.7355656712712, -122.491254961509)
10597 92315 6 35 2783 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985839.9086 2096474.3035 37.73570120363421 -122.491429290175 (37.7357012036342, -122.491429290175)
10790 80073 6 35 2788 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3     5985889.2586 2096432.3825 37.735588983385 -122.49125558617901 (37.735588983385, -122.491255586179)
10899 92314 6 35 2783 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985837.7861 2096464.2212 37.7356733962807 -122.491435886509 (37.7356733962807, -122.491435886509)
11570 174950 6 2 309 Crestlake Dr 1 1 1 1       3x3   5987294.0 2096147.0 37.7348873783654 -122.486377975564 (37.7348873783654, -122.486377975564)
12363 92312 6 12 2711 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985822.132 2096946.3119 37.7369961745626 -122.49152548244 (37.7369961745626, -122.49152548244)
12500 92318 6 35 2787 34th Ave 3 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985842.0312 2096446.1793 37.7356241060746 -122.49141988222999 (37.7356241060746, -122.49141988223)
12690 92317 6 35 2787 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985840.9699 2096433.9745 37.7355905329114 -122.491422653463 (37.7355905329114, -122.491422653463)
13114 92316 6 35 2787 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985840.4393 2096424.4229 37.7355642757438 -122.49142378511002 (37.7355642757438, -122.49142378511)
13290 187642 6 13 2526 Polk St 1 1 1 1       3x3   6006264.0 2119500.0 37.8000966404513 -122.42245076966002 (37.8000966404513, -122.42245076966)
15902 108047 6 44 1301 Evans Ave 4 1 1 1   06/12/2015 12:00:00 AM 3 3x3   6017036.144669999 2097442.01922 37.7401319873023 -122.383638088928 (37.7401319873023, -122.383638088928)
20387 121368 6 142 245 Mallorca Way 1 1 1 1     12 3x3 Permit Number 778992 6001431.0 2120732.0 37.8032055622797 -122.439263127997 (37.8032055622797, -122.439263127997)
22303 248958 6 105 98x Rosewood Dr 1 1 1 1   03/06/2017 12:00:00 AM 3 3x3   5994824.0 2095658.0 37.7339807377795 -122.460308897898 (37.7339807377795, -122.460308897898)
44089 109772 6 211 2200x SAN JOSE AVE 11 1 1 1     30 3x3   5998886.0 2091075.0 37.7216297132481 -122.44593585753599 (37.7216297132481, -122.445935857536)
47274 121088 6 3 1X Grand View Ave 1 1 1 1       3x3   6000227.0 2103854.0 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848)
50101 121189 6 47 1000x Duncan St 10 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
66014 120590 6 362 52 Prosper St 1 1 1 1       3x3   6003308.0 2106220.0 37.763465890993295 -122.43173097308998 (37.7634658909933, -122.43173097309)
78383 115661 6 5 341 HAZELWOOD AVE 1 1 1 1     15 3x3   5996066.0 2095432.0 37.7334315621613 -122.455998615118 (37.7334315621613, -122.455998615118)
78781 121184 6 1 1000x Duncan St 5 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
79242 121190 6 1 1000x Duncan St 11 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
80217 92320 6 2 2733 Wawona St 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5984522.0 2096783.0 37.736471699686206 -122.49600850837099 (37.7364716996862, -122.496008508371)
80352 121187 6 1 1000x Duncan St 8 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
80520 116010 6 198 199x SAN BUENAVENTURA WAY 2 1 1 1       3x3   5993547.0 2095667.0 37.7339319096844 -122.464724497297 (37.7339319096844, -122.464724497297)
80993 85086 6 82 1600 Chestnut St 2 1 1 1         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
82126 115125 6 11 499X MAIN ST 3 1 1 1     8     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
82400 115123 6 11 499X MAIN ST 1 1 1 1     12     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
82760 120597 6 3 499x Ocean Ave 5 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
82925 112725 6 47 40x BERNAL HEIGHTS BLVD 1 1 1 1     30 3x3   6009324.0 2098099.0 37.7415066181332 -122.41035003366801 (37.7415066181332, -122.410350033668)
83319 115736 6 6 66 Yerba Buena Ave 1 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 776551 5993801.4 2096894.7 37.7373175329251 -122.463934052027 (37.7373175329251, -122.463934052027)
83367 115940 6 41 3401x 17TH ST 1 1 1 18     20 3x3   6006069.0 2106010.0 37.7630453994978 -122.42216662533801 (37.7630453994978, -122.422166625338)
83893 110583 6 100 46 COOK ST 5 1 1 1     36     5997534.0 2113434.0 37.782944683725 -122.45222184269899 (37.782944683725, -122.452221842699)
83993 114406 6 203 500X ARBALLO DR 3 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
84141 120594 6 3 499x Ocean Ave 2 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
84791 108196 6 44 930 FLORIDA ST 1 1 1 1           6009368.6 2103733.3 37.7569796561067 -122.410593604092 (37.7569796561067, -122.410593604092)
84797 112378 6 54 1850 19TH AVE 1 1 1 1     10 3x3   5990394.0 2102783.0 37.7532883185876 -122.476144836826 (37.7532883185876, -122.476144836826)
84949 86910 6 163 1 Urbano Dr 1 1 1 1       3x3 Permit Number 49875 5993901.0 2092133.0 37.7242488135215 -122.463244271267 (37.7242488135215, -122.463244271267)
85026 99100 6 5 60 Santa Monica Way 1 1 1 1           5993700.7 2097327.0 37.7384987171226 -122.464313592449 (37.7384987171226, -122.464313592449)
85039 115729 6 6 10x Yerba Buena Ave 1 1 1 1     3   Permit Number 776540 5993642.277480001 2097056.1949900002 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033)
85687 113112 6 129 1633 OAKDALE AVE 1 1 1 1           6014731.0 2095647.0 37.735075549566204 -122.391482947841 (37.7350755495662, -122.391482947841)
86745 115730 6 6 10x Yerba Buena Ave 2 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 776540 5993642.277480001 2097056.1949900002 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033)
86822 114840 6 5 2455x HYDE ST   1 1 13     12 3x3   6006980.0 2120877.0 37.803917898432395 -122.42007090461901 (37.8039178984324, -122.420070904619)
88665 109838 6 143 200x MONTCALM ST 1 1 1 1     30 3x3   6009924.0 2099647.0 37.745790704819704 -122.408384592716 (37.7457907048197, -122.408384592716)
89056 121188 6 1 1000x Duncan St 9 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
89334 116094 6 86 300x EXECUTIVE PARK BLVD 4 1 1 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
89824 110738 6 333 1299x PERSIA AVE 5 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
90057 111634 6 142 3009 26th St 1 1 1 1 1   12     6009514.91537658 2100993.40768569 37.7494647260255 -122.40989418187 (37.7494647260255, -122.40989418187)
90639 117269 6 60 399X SANTA CLARA AVE 1 1 1 1       3x10   5993324.0 2095440.0 37.7332957649176 -122.46547898513701 (37.7332957649176, -122.465478985137)
90926 114099 6 85 201x VIDAL DR 1 1 1 1     14     5987665.0 2090646.0 37.719804665893605 -122.484691919383 (37.7198046658936, -122.484691919383)
90930 121191 6 1 1000x Duncan St 12 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
91008 120156 6 43 758 10th Ave 1 1 2 1     10     5992930.0 2110298.0 37.77406925887279 -122.467921468059 (37.7740692588728, -122.467921468059)
91506 121193 6 1 1000x Duncan St 14 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
91812 107986 6 19 2401x SCOTT ST 4 1 1 1       3x3   6001257.0 2116757.0 37.7922813550603 -122.439580129378 (37.7922813550603, -122.439580129378)
91855 122410 6 55 499x Ocean Ave 7 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
91870 122411 6 55 499x Ocean Ave 8 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
92339 115295 6 103 500X 08TH ST 1 1 1 1       3x3   6010511.0 2109243.0 37.77217202356729 -122.407031076357 (37.7721720235673, -122.407031076357)
92394 115737 6 6 9x Yerba Buena Ave 1 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 776557 5993642.277480001 2097056.1949900002 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033)
92450 116095 6 86 300x EXECUTIVE PARK BLVD 5 1 1 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
93266 114407 6 177 500X ARBALLO DR 4 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
93681 96767 6 94 2229 Webster St 1 1 1 1     12   Permit Number 768245 6003236.0 2116309.0 37.7911636966224 -122.43270073645701 (37.7911636966224, -122.432700736457)
93904 118327 6 26 109 ALPINE TER   1 1 1     8 4x7   6001716.4 2108199.1 37.7688096651516 -122.43737752181002 (37.7688096651516, -122.43737752181)
94007 112375 6 36 801 ULLOA ST 1 1 1 6     42     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
94160 113187 6 3 3340 FOLSOM ST 1 1 1 1     17 3x3   6008444.0 2099179.0 37.7444226899799 -122.41346914528499 (37.7444226899799, -122.413469145285)
94649 112577 6 21 3326 23RD ST 2 1 1 1     24   Permit Number 775776 6006851.0 2102663.4 37.753900487576296 -122.419224541208 (37.7539004875763, -122.419224541208)
94747 114034 6 53 198x FONT BLVD 1 1 1 1     40 3x3   5990818.0 2089012.0 37.7155012267577 -122.473674083302 (37.7155012267577, -122.473674083302)
95270 121186 6 1 1000x Duncan St 7 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
95523 117518 6 119 30 Santa Paula Ave 1 1 1 1   06/20/2016 12:00:00 AM 3   Permit Number 777803 5993995.8 2097679.6 37.7394838741894 -122.46331886635099 (37.7394838741894, -122.463318866351)
95855 112250 6 15 243 WINSTON DR 1 1 1 1       3x3   5990059.0 2093141.0 37.726794444209396 -122.47659897114599 (37.7267944442094, -122.476598971146)
96134 85085 6 82 1600 Chestnut St 1 1 1 1         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
96301 101476 6 54 541 Congo St 1 1 1 1   05/07/2015 12:00:00 AM 3   Permit Number 775316 6000089.0 2095440.1 37.7336838892166 -122.44209059296301 (37.7336838892166, -122.442090592963)
96798 111179 6 143 400 NORTH POINT ST 1 1 1 1   03/01/2016 12:00:00 AM 3 9x6   6008572.0 2121805.0 37.806555520543 -122.41462738080799 (37.806555520543, -122.414627380808)
96939 113833 6 43 932 SHOTWELL ST 1 1 1 1     30     6007966.0 2102301.0 37.752968150444204 -122.415342945464 (37.7529681504442, -122.415342945464)
96972 120593 6 2 499x Ocean Ave 4 1 1 6     34 3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
97751 110321 6 484 1x SAN PABLO AVE   1 1 1   04/06/2015 12:00:00 AM 3 3x3 Permit Number 774750 5994773.0 2097898.0 37.740128291439 -122.460647489756 (37.740128291439, -122.460647489756)
97871 115124 6 11 499X MAIN ST 2 1 1 1     8     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
98070 88456 6 17 2801 Oakdale Ave 5 1 1 1   07/15/2008 12:00:00 AM     Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
98270 107984 6 13 2401x SCOTT ST 2 1 1 1       3x3   6001096.0 2116670.0 37.792033311180504 -122.440130949989 (37.7920333111805, -122.440130949989)
98668 108560 6 164 3790 21st St 1 1 1 1           6003155.9 2103640.4 37.7563743055091 -122.432072816055 (37.7563743055091, -122.432072816055)
Powered by Datasette · Query took 11.372ms · Data source: data.sfgov.org