sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
11570 174950 6 2 309 Crestlake Dr 1 1 1 1       3x3   5987294.0 2096147.0 37.7348873783654 -122.486377975564 (37.7348873783654, -122.486377975564)
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)
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)
102016 105368 6 2 180 CLIFFORD TER   1 1 1           5999283.1 2106587.2 37.7642451591147 -122.44567816768298 (37.7642451591147, -122.445678167683)
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)
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)
82760 120597 6 3 499x Ocean Ave 5 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
84141 120594 6 3 499x Ocean Ave 2 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
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)
103031 120596 6 3 499x Ocean Ave 1 1 1 6     36 3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
105748 120595 6 3 499x Ocean Ave 3 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
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)
115908 85032 6 3 411 Panorama Dr 1 1 1 1           5997300.0 2101977.0 37.7514732863106 -122.452204440653 (37.7514732863106, -122.452204440653)
118230 120598 6 3 499x Ocean Ave 6 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
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)
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)
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)
85026 99100 6 5 60 Santa Monica Way 1 1 1 1           5993700.7 2097327.0 37.7384987171226 -122.464313592449 (37.7384987171226, -122.464313592449)
86822 114840 6 5 2455x HYDE ST   1 1 13     12 3x3   6006980.0 2120877.0 37.803917898432395 -122.42007090461901 (37.8039178984324, -122.420070904619)
101747 113695 6 5 907 FLORIDA ST 1 1 1 1     24 3x3   6009441.0 2103786.0 37.7571284172194 -122.41034693748101 (37.7571284172194, -122.410346937481)
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)
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)
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)
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)
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)
112912 115733 6 6 50 Yerba Buena Ave 1 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 776548 5993693.2 2096969.0 37.7375153061033 -122.46431353926701 (37.7375153061033, -122.464313539267)
115585 112290 6 6 34 YERBA BUENA AVE 1 1 1 1   02/24/2016 12:00:00 AM 3 3x3 Permit Number 776546 5993584.0 2097045.0 37.7377176881769 -122.464696609393 (37.7377176881769, -122.464696609393)
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)
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)
139076 115734 6 6 55 Yerba Buena Ave 2 1 1 1         Permit Number 776555 5993732.7 2097034.0 37.7376960566374 -122.464181687663 (37.7376960566374, -122.464181687663)
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)
144044 115738 6 6 95x Yerba Buena Ave 2 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 776553 5993642.277480001 2097056.1949900002 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033)
146206 115735 6 6 57 Yerba Buena Ave 1 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 776554 5993777.6 2097002.8 37.737612976998896 -122.464024183823 (37.7376129769989, -122.464024183823)
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)
97871 115124 6 11 499X MAIN ST 2 1 1 1     8     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
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)
112243 99098 6 11 66 Santa Monica Way 1 1 1 1   04/07/2012 12:00:00 AM     Permit Number 768466 5993736.6 2097303.5 37.7384362612216 -122.464187762983 (37.7384362612216, -122.464187762983)
114111 112626 6 11 3430X 23rd St 2 1 1 1     12     6006285.0 2102686.4 37.753931748244604 -122.421183538041 (37.7539317482446, -122.421183538041)
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)
120452 100055 6 11 401X Tehama St 2 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.78098480794971 -122.404421471201 (37.7809848079497, -122.404421471201)
126303 100056 6 11 401X Tehama St 3 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.78098480794971 -122.404421471201 (37.7809848079497, -122.404421471201)
138786 99099 6 11 65X Santa Monica Way 1 1 1 1   04/07/2012 12:00:00 AM     Permit Number 768467 5993743.4 2097365.9 37.7386079879791 -122.464168780849 (37.7386079879791, -122.464168780849)
142304 100054 6 11 401X Tehama St 1 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.78098480794971 -122.404421471201 (37.7809848079497, -122.404421471201)
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)
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)
13290 187642 6 13 2526 Polk St 1 1 1 1       3x3   6006264.0 2119500.0 37.8000966404513 -122.42245076966002 (37.8000966404513, -122.42245076966)
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)
99634 99847 6 15 850@14th Ave Judah St 1 1 1 1           5991942.0 2105939.0 37.7620435090796 -122.47102148161501 (37.7620435090796, -122.471021481615)
144015 108197 6 15 930 FLORIDA ST 2 1 1 1           6009368.6 2103733.3 37.7569796561067 -122.410593604092 (37.7569796561067, -122.410593604092)
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)
9148 85030 6 17 411 Panama St 1 1 1 1   06/26/2007 12:00:00 AM     Permit Number 49384          
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)
103510 92813 6 17 365 Fulton St 2 1 1 2       3x3 Permit Number 53020 6006011.0 2111744.0 37.7787863189721 -122.42277474798 (37.7787863189721, -122.42277474798)
103692 57910 6 17 446 Valley St 1 1 1 1   06/10/1977 12:00:00 AM     Permit Number 16868 6003019.35193275 2099229.53580249 37.7442553690473 -122.432230049776 (37.7442553690473, -122.432230049776)
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)
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)
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)
143961 116345 6 17 85x SANTA CLARA AVE 1 1 1 1   03/24/2016 12:00:00 AM 3 3x3 Permit Number 777165 5993361.0 2096925.0 37.7373753392635 -122.465458906558 (37.7373753392635, -122.465458906558)
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)
91812 107986 6 19 2401x SCOTT ST 4 1 1 1       3x3   6001257.0 2116757.0 37.7922813550603 -122.439580129378 (37.7922813550603, -122.439580129378)
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)
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)
105495 112955 6 24 121X Junipero Serra Blvd 1 1 1 1           5991652.84779157 2095347.0788301998 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136)
93904 118327 6 26 109 ALPINE TER   1 1 1     8 4x7   6001716.4 2108199.1 37.7688096651516 -122.43737752181002 (37.7688096651516, -122.43737752181)
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)
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)
164545 82366 6 31 51 Princeton St 3 1 1 1 1 05/28/2005 12:00:00 AM 9     6007564.92616 2093725.05049 37.7293979446509 -122.416122630059 (37.7293979446509, -122.416122630059)
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)
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)
94007 112375 6 36 801 ULLOA ST 1 1 1 6     42     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
107199 112376 6 36 801 ULLOA ST 2 1 1 6     24     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
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)
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)
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)
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)
Powered by Datasette · Query took 14.97ms · Data source: data.sfgov.org