sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
105346 115752 6 6 100 Yerba Buena Ave 4 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 776558 5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769)
141630 115750 6 340 100 Yerba Buena Ave 2 1 1 1           5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769)
143813 115751 6 6 100 Yerba Buena Ave 3 1 1 1   05/10/2016 12:00:00 AM 3   Permit Number 776558 5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769)
143824 115749 6 340 100 Yerba Buena Ave 1 1 1 1           5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769)
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)
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)
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)
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)
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)
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)
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)
100978 121192 6 1 1000x Duncan St 13 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
102605 121181 6 1 1000x Duncan St 2 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
104617 121185 6 1 1000x Duncan St 6 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
104788 121183 6 1 1000x Duncan St 4 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
123005 121182 6 1 1000x Duncan St 3 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
145554 121180 6 47 1000x Duncan St 1 1 1 1       3x3   5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
113606 111093 6 3 100x FONT BLVD 1 1 1 1   06/04/2015 12:00:00 AM 50 3x3 Permit Number 775594 5990916.0 2088996.0 37.715462969911 -122.473334188491 (37.715462969911, -122.473334188491)
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)
114906 105678 6 11 101X 03RD ST 2 1 1 1     10 4x4   6012079.1 2114345.8 37.7862707590298 -122.401965633825 (37.7862707590298, -122.401965633825)
128185 101258 6 225 1049 Irving St 3 1 1 1       3x3   5992548.0 2106581.0 37.763841302397104 -122.46897230376699 (37.7638413023971, -122.468972303767)
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)
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)
93904 118327 6 26 109 ALPINE TER   1 1 1     8 4x7   6001716.4 2108199.1 37.7688096651516 -122.43737752181002 (37.7688096651516, -122.43737752181)
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)
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)
117245 116958 6 6 10x Yerba Buena Ave 4 1 1 1   05/10/2016 12:00:00 AM 3   Permit Number 777762 5993642.277480001 2097056.1949900002 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033)
138789 116957 6 340 10x Yerba Buena Ave 3 1 1 1           5993642.277480001 2097056.1949900002 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033)
175351 106611 6 28 1154 Rhode Island St 1 1 1 1     12 4x4   6011908.79849 2103025.7220099997 37.7551788898075 -122.401758852609 (37.7551788898075, -122.401758852609)
108692 116346 6 11 121 SAN BENITO WAY 1 1 1 1   03/24/2016 12:00:00 AM 3 3x3 Permit Number 777164 5992901.0 2095856.0 37.73441359171021 -122.46697163304701 (37.7344135917102, -122.466971633047)
105495 112955 6 24 121X Junipero Serra Blvd 1 1 1 1           5991652.84779157 2095347.0788301998 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136)
89824 110738 6 333 1299x PERSIA AVE 5 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
104170 110739 6 333 1299x PERSIA AVE 6 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
125443 110737 6 333 1299x PERSIA AVE 4 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
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)
138380 115753 6 6 135x Yerba Buena Ave 1 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 776552 5994185.89401 2096656.23912 37.7366849291808 -122.46258739592 (37.7366849291808, -122.46258739592)
143633 121087 6 1 1443 47th Ave 1 1 1 1       3x3 Permit Number 778784 5981521.320719999 2105258.5458 37.7595669638281 -122.507011468719 (37.7595669638281, -122.507011468719)
131725 88148 6 26 1475 Eddy St 5 1 1 1   07/07/2000 12:00:00 AM 6 3x3 Permit Number 51176 6003399.3649 2112760.0054 37.781428317697795 -122.431881978872 (37.7814283176978, -122.431881978872)
108992 88147 6 17 1475 Fillmore St 4 1 1 1   07/07/2000 12:00:00 AM   3x3 Permit Number 51176 6003147.8 2113351.1 37.7830370509294 -122.43279450975001 (37.7830370509294, -122.43279450975)
122706 88146 6 17 1475 Fillmore St 3 1 1 1   07/07/2000 12:00:00 AM   3x3 Permit Number 51176 6003147.8 2113351.1 37.7830370509294 -122.43279450975001 (37.7830370509294, -122.43279450975)
128937 88145 6 17 1475 Fillmore St 2 1 1 1   07/07/2000 12:00:00 AM   3x3 Permit Number 51176 6003147.8 2113351.1 37.7830370509294 -122.43279450975001 (37.7830370509294, -122.43279450975)
103313 115731 6 6 15 Yerba Buena Ave 2 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 776556 5993468.8 2097225.0 37.7382052810266 -122.465107977902 (37.7382052810266, -122.465107977902)
125242 111094 6 3 150x FONT BLVD   1 1 1   06/04/2015 12:00:00 AM 30 3x3 Permit Number 775594 5990976.0 2089133.0 37.715842612516106 -122.473136789074 (37.7158426125161, -122.473136789074)
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)
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)
105009 85087 6 82 1600 Chestnut St 3 1 1 1         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
119181 33327 6 61 1629 Green St 2 1 1 1   07/13/2010 12:00:00 AM   3x3 Originally issued under Permit Number 51411; permit expired; property changed owners; trees re-posted and permit 53716 issued 6005242.65792202 2118493.60609418 37.7972756709044 -122.425913331435 (37.7972756709044, -122.425913331435)
85687 113112 6 129 1633 OAKDALE AVE 1 1 1 1           6014731.0 2095647.0 37.735075549566204 -122.391482947841 (37.7350755495662, -122.391482947841)
102016 105368 6 2 180 CLIFFORD TER   1 1 1           5999283.1 2106587.2 37.7642451591147 -122.44567816768298 (37.7642451591147, -122.445678167683)
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)
10151 173889 6 67 190 Holladay Ave 1 1 1 1       3x3   6010824.0 2099939.0 37.746642831954496 -122.405293064953 (37.7466428319545, -122.405293064953)
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)
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)
105823 116009 6 198 199x SAN BUENAVENTURA WAY 1 1 1 1   11/07/2016 12:00:00 AM 3 3x3 Permit Number 777954 5993547.0 2095667.0 37.7339319096844 -122.464724497297 (37.7339319096844, -122.464724497297)
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)
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)
3204 253366 6 201 20 Laussat St 1 1 1 1       3x3   6004582.0 2109434.0 37.772362894278395 -122.427553605007 (37.7723628942784, -122.427553605007)
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)
90926 114099 6 85 201x VIDAL DR 1 1 1 1     14     5987665.0 2090646.0 37.719804665893605 -122.484691919383 (37.7198046658936, -122.484691919383)
109984 116585 6 19 2100 22ND ST 1 1 1 1     30 3x3   6011843.0 2103815.0 37.757342401329105 -122.402041888427 (37.7573424013291, -122.402041888427)
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)
108780 92311 6 18 2211 33rd Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5986022.3 2100155.2 37.7458186185696 -122.491069496457 (37.7458186185696, -122.491069496457)
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)
139196 72854 6 39 24 Lunado Way 4 1 1 1   09/26/1998 12:00:00 AM       5991516.52955398 2091408.89207172 37.722122935753106 -122.47143422303499 (37.7221229357531, -122.471434223035)
91812 107986 6 19 2401x SCOTT ST 4 1 1 1       3x3   6001257.0 2116757.0 37.7922813550603 -122.439580129378 (37.7922813550603, -122.439580129378)
98270 107984 6 13 2401x SCOTT ST 2 1 1 1       3x3   6001096.0 2116670.0 37.792033311180504 -122.440130949989 (37.7920333111805, -122.440130949989)
121982 107985 6 13 2401x SCOTT ST 9 1 1 1       3x3   6001096.0 2116670.0 37.792033311180504 -122.440130949989 (37.7920333111805, -122.440130949989)
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)
95855 112250 6 15 243 WINSTON DR 1 1 1 1       3x3   5990059.0 2093141.0 37.726794444209396 -122.47659897114599 (37.7267944442094, -122.476598971146)
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)
86822 114840 6 5 2455x HYDE ST   1 1 13     12 3x3   6006980.0 2120877.0 37.803917898432395 -122.42007090461901 (37.8039178984324, -122.420070904619)
13290 187642 6 13 2526 Polk St 1 1 1 1       3x3   6006264.0 2119500.0 37.8000966404513 -122.42245076966002 (37.8000966404513, -122.42245076966)
114328 121377 6 353 2701 Jackson St 1 1 1 1       3x3   6001200.0 2116539.0 37.79167953949779 -122.439761713662 (37.7916795394978, -122.439761713662)
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)
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)
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)
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)
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)
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)
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)
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)
111690 88457 6 17 2801 Oakdale Ave 6 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)
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)
120295 117249 6 3 299x GRAYSTONE TER 2 1 1 1     15 3x3   5999641.0 2104067.0 37.7573457417117 -122.44425918093 (37.7573457417117, -122.44425918093)
140584 117248 6 47 299x GRAYSTONE TER 1 1 1 1       3x3   5999641.0 2104067.0 37.7573457417117 -122.44425918093 (37.7573457417117, -122.44425918093)
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)
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)
Powered by Datasette · Query took 11.785ms · Data source: data.sfgov.org