sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
124888 48984 1 58 4215 26th St 1 1 1 1 1 12/05/2002 12:00:00 AM     Permit Number 46171 6002499.14803074 2100605.29142344 37.7480033622388 -122.43412712945299 (37.7480033622388, -122.434127129453)
125182 34411 1 58 191 Randall St 1 1 1 1 1 07/15/1997 12:00:00 AM     Permit Number 38159 6004342.16299585 2097508.24193041 37.739604003626795 -122.427533446458 (37.7396040036268, -122.427533446458)
125305 222705 2 58 77 Mirabel Ave 1 1 1 1     3 Width 3ft   6007841.33022 2100005.82897 37.74665912012979 -122.41561158852899 (37.7466591201298, -122.415611588529)
125410 45536 1 58 79 Melba Ave 1 1 1 1   07/24/2001 12:00:00 AM     Permit Number 44293 5989585.76469698 2094846.08328142 37.7314487101847 -122.478359538262 (37.7314487101847, -122.478359538262)
125714 102089 1 58 27 Santa Ana Ave 1 1 1 1 1 12/18/2012 12:00:00 AM   3x3 Permit Number 769734 5992609.4 2096703.2 37.7367229555432 -122.468041385671 (37.7367229555432, -122.468041385671)
126538 43593 1 58 2014 31st Ave 1 1 1 1 1 07/20/2000 12:00:00 AM     Permit Number 43254 5986663.03161814 2101533.45903453 37.7496403612652 -122.488955268867 (37.7496403612652, -122.488955268867)
127137 122679 2 58 598x Powhattan Ave 1 1 1 1       3x3   6008469.0 2098078.0 37.7414009906205 -122.413304856031 (37.7414009906205, -122.413304856031)
128258 204719 2 58 110 Dorantes Ave 1 2 1 1     2 Width 4ft   5993903.71897 2099982.29966 37.7458012037543 -122.46380433331001 (37.7458012037543, -122.46380433331)
128301 45396 1 58 135 Corona St 1 1 1 1 1 10/21/2006 12:00:00 AM     Permit Number 44206 5992967.23882057 2092102.4527906997 37.72411110068 -122.466469901656 (37.72411110068, -122.466469901656)
129111 51597 1 58 1478 Masonic Ave 1 1 1 1   03/04/2005 12:00:00 AM   3x3 Permit Number 47890 5999641.13876025 2107457.97579425 37.766656526924294 -122.444502404738 (37.7666565269243, -122.444502404738)
129702 204734 2 58 80 Merced Ave 1 2 1 1     3 Width 3ft   5994953.56479 2099867.13318 37.7455454275919 -122.460165799529 (37.7455454275919, -122.460165799529)
131430 204721 2 58 460 Staples Ave 1 1 1 1     3 Width 2ft   5997139.03164 2093838.66053 37.729118162849495 -122.452173936375 (37.7291181628495, -122.452173936375)
135290 222704 2 58 69 Mirabel Ave 1 1 1 1     2 Width 3ft   6007772.24851 2100018.26139 37.746689373329296 -122.415851346858 (37.7466893733293, -122.415851346858)
136522 204722 2 58 422 Bright St 1 9 1 1     6     5993793.315830001 2090006.70292 37.7184043108851 -122.46346228245501 (37.7184043108851, -122.463462282455)
137834 175805 2 58 35 Ervine St 1 1 1 1     1 Width 2ft   6009673.12409 2089221.0725599998 37.7171492746007 -122.408516774841 (37.7171492746007, -122.408516774841)
140864 53611 1 58 2266 15th Ave 1 1 1 1   12/18/1969 12:00:00 AM   3x3 Permit Number 50102 5991755.89113084 2099997.75858136 37.7457196459604 -122.47123227110201 (37.7457196459604, -122.471232271102)
144682 106923 2 58 196 States St 1 9 1 1   06/30/2014 12:00:00 AM     Permit Number 772939 6001039.87531 2106387.50014 37.7637969766711 -122.43958767886002 (37.7637969766711, -122.43958767886)
146575 222710 2 58 201 Randall St 1 9 1 1     2 Width 3ft   6004263.21249 2097476.0489 37.7395111430209 -122.427804130079 (37.7395111430209, -122.427804130079)
147518 188397 2 58 501 Utah St 1 1 1 1     11 Width 5ft   6010696.0277 2105850.49204 37.7628673226003 -122.406151993137 (37.7628673226003, -122.406151993137)
148165 222701 2 58 340 Chenery St 1 1 1 1     4 Width 3ft   6004099.43344 2096524.74955 37.7368898251991 -122.42830262426399 (37.7368898251991, -122.428302624264)
149036 32269 1 58 2033 22nd St 1 1 1 1 1 10/07/2000 12:00:00 AM 4   Permit Number 36855 6011970.48286 2103707.9911700003 37.7570556930908 -122.40159347895 (37.7570556930908, -122.40159347895)
149164 175811 2 58 15 Athens St 1 9 1 1     1     6005336.45581 2093162.3032099998 37.727727212929004 -122.423786672331 (37.727727212929, -122.423786672331)
149330 222691 2 58 2981 26th St 1 1 1 1     5 Width 3ft   6009598.49349 2101000.57831 37.7494890986626 -122.40960567126801 (37.7494890986626, -122.409605671268)
153957 218236 2 58 353 Wawona St 1 4 1 1     1 Width 3ft   5991977.13565 2097137.64691 37.7378793033766 -122.47025900595101 (37.7378793033766, -122.470259005951)
155099 222702 2 58 123 Gates St 1 1 1 1     3 Width 3ft   6008311.654 2097864.96994 37.7408072216699 -122.413833840154 (37.7408072216699, -122.413833840154)
156342 222693 2 58 440 29th St 1 1 1 1     2 Width 2ft   6003701.6023699995 2098966.92625 37.74357296341329 -122.42985224701 (37.7435729634133, -122.42985224701)
159639 188416 2 58 1790 McKinnon Ave 1 4 1 1     20 Width 8ft   6014390.68688 2096696.7168 37.7379389617097 -122.392732952571 (37.7379389617097, -122.392732952571)
165838 59091 1 58 3524 Fulton St 1 1 1 1   04/23/1980 12:00:00 AM 1   Permit Number 18392 5992426.174880001 2110042.4468799997 37.77333847202161 -122.46964566266001 (37.7733384720216, -122.46964566266)
167143 188401 2 58 909 Minnesota St 1 1 1 1     1 Width 5ft   6015267.441000001 2104396.98208 37.7591309344718 -122.39023938074101 (37.7591309344718, -122.390239380741)
167905 94813 1 58 2948 Fillmore St 1 1 1 1   11/09/2010 12:00:00 AM 2 3x3 Permit Number 53896 6002515.07841 2118365.04564 37.7967681547718 -122.43534223486799 (37.7967681547718, -122.435342234868)
170167 222677 2 58 1498 Hampshire St 1 1 1 1     1 Width 3ft   6010454.79524 2100826.85949 37.749060050992604 -122.40663230034201 (37.7490600509926, -122.406632300342)
175877 222699 2 58 2102 Castro St 1 10 1 1     2 Width 5ft   6002635.97774 2099387.5471900003 37.744667486907204 -122.43356696417 (37.7446674869072, -122.43356696417)
175957 204740 2 58 317 Mangels Ave 1 9 1 1     2 Width 6ft   5999296.31857 2095221.44608 37.7330383112512 -122.44481540373 (37.7330383112512, -122.44481540373)
176601 188418 2 58 1790 McKinnon Ave 1 4 1 1     9 Width 3ft   6014392.11707 2096695.01257 37.737934361678796 -122.39272788847401 (37.7379343616788, -122.392727888474)
183898 188402 2 58 654 Carolina St 1 1 1 1     6 Width 3ft   6012373.88939 2104883.09648 37.7603047754705 -122.40028086897 (37.7603047754705, -122.40028086897)
184518 39934 1 58 186 Arleta Ave 1 1 1 1 1 01/25/1999 12:00:00 AM 3 3x3 Permit Number 41205 6010249.35801 2088014.8431799999 37.7138694695674 -122.40644005139299 (37.7138694695674, -122.406440051393)
187407 175800 2 58 701 Madrid St 1 1 1 1     1 Width 2ft   6001959.2202699995 2089802.6495400001 37.71831113034379 -122.43522160969401 (37.7183111303438, -122.435221609694)
440 157410 1 58 125 Highland Ave 2 1 1 1   04/06/2017 12:00:00 AM 3 2x5   6005546.67522 2096690.9332 37.7374279129674 -122.423310672857 (37.7374279129674, -122.423310672857)
5660 39923 1 58 0 Arleta Ave 2 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41198          
6711 31341 1 58 430 Hayes St 2 1 1 1   12/29/2014 12:00:00 AM 3 3x3 Permit Number 772811 6005729.4209 2111051.1148 37.7768679337671 -122.423699563703 (37.7768679337671, -122.423699563703)
10397 108837 1 58 699 Paris St 2 1 1 1 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774665 6001210.74249 2089636.42248 37.7178121756617 -122.437796877731 (37.7178121756617, -122.437796877731)
12527 108378 1 58 358 Edinburgh St 2 1 1 1 1 12/19/2014 12:00:00 AM 3 3x3 Permit Number 773808 6003377.41913 2091635.77484 37.7234249209965 -122.43045021882 (37.7234249209965, -122.43045021882)
13070 93869 1 58 400-422X Tocoloma Ave 2 1 1 1 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773818 6012466.99875 2086683.8296 37.7103385819422 -122.398681660343 (37.7103385819422, -122.398681660343)
13992 108725 1 58 877 Rhode Island St 2 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773104 6011895.30838 2104315.65478 37.758720008153 -122.401896177292 (37.758720008153, -122.401896177292)
14920 37328 1 58   2 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39838          
24848 188408 2 58 2033 22nd St 2 9 1 1     1 Width 3ft   6011976.80987 2103707.86259 37.7570556930855 -122.40157158857299 (37.7570556930855, -122.401571588573)
26902 175812 2 58 15 Athens St 2 9 1 1     2     6005342.42292 2093158.1624099999 37.727716180055204 -122.42376574960899 (37.7277161800552, -122.423765749609)
29820 187571 2 58 73 Bishop St 2 17 1 1     7     6010860.52073 2089475.11103 37.7179132396708 -122.40443035886899 (37.7179132396708, -122.404430358869)
36978 187575 2 58 72 Bishop St 2 17 1 1     11     6010832.96557 2089490.7918200002 37.7179547559905 -122.40452670863998 (37.7179547559905, -122.40452670864)
38985 123068 2 58 678 12th Ave 2 1 1 1     1 Width 3ft   5992266.69336 2110864.34538 37.7755859643914 -122.47025718989201 (37.7755859643914, -122.470257189892)
39135 247897 2 58 351 Mayflower St 2 17 1 1     4     6010077.88258 2098386.8429099997 37.7423392041858 -122.407763645688 (37.7423392041858, -122.407763645688)
40968 91228 1 58 250 Texas St 2 1 1 1   02/02/2010 12:00:00 AM 4 3x3 Permit Number 53161 6013714.91861 2105876.83519 37.7631080513185 -122.39571247215 (37.7631080513185, -122.39571247215)
49133 247976 2 58 503 Peralta Ave 2 17 1 1     9     6009801.95016 2099270.17301 37.7447491849331 -122.408780045086 (37.7447491849331, -122.408780045086)
51309 222685 2 58 145 Coso Ave 2 9 1 1     5     6007512.1231 2099620.66206 37.74558302735271 -122.41672267392201 (37.7455830273527, -122.416722673922)
77059 188411 2 58 398 Mississippi St 2 4 1 1     1 Width 3ft   6014024.24871 2105357.36092 37.7616988910081 -122.394606216998 (37.7616988910081, -122.394606216998)
78290 37278 1 58 700 Sanchez St 2 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39817 6003661.86134005 2104206.66341524 37.7579578025996 -122.430363425655 (37.7579578025996, -122.430363425655)
78986 105989 1 58 651X Duncan St 2 1 1 1           6002337.0 2099724.0 37.745574339333 -122.434624822764 (37.745574339333, -122.434624822764)
81516 50910 1 58 2450 17th Ave 2 1 1 1 1 04/26/2004 12:00:00 AM 2 3x9 Permit Number 772737 5991103.05311172 2098729.45888754 37.742199437798 -122.47339717645399 (37.742199437798, -122.473397176454)
82156 36956 1 58 16 05th Ave 2 1 1 1 1 05/29/1998 12:00:00 AM     Permit Number 39587 5994274.56771258 2115474.49567321 37.7883600733979 -122.463646184404 (37.7883600733979, -122.463646184404)
83450 68449 1 58 4054 20th St 2 7 1 1 1 04/24/1999 12:00:00 AM     Permit Number 32307 6003251.17179249 2104206.64930012 37.757934492021604 -122.431783761852 (37.7579344920216, -122.431783761852)
91092 51953 1 58 82 Mary St 2 1 1 1   08/08/2005 12:00:00 AM     Permit Number 48176 6010868.83737248 2112458.01845687 37.781019735711006 -122.40601981145599 (37.781019735711, -122.406019811456)
94464 36069 1 58 1504 Bryant St 2 1 1 1 1 04/19/2002 12:00:00 AM     Permit Number 44775 6009387.99483758 2107777.56202059 37.7680853638298 -122.410812146882 (37.7680853638298, -122.410812146882)
96969 109399 2 58 1588 WALLER ST 2 1 1 1       3x3   5997977.9 2108248.0 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331)
97803 45537 1 58 79 Melba Ave 2 1 1 1   07/24/2001 12:00:00 AM     Permit Number 44293 5989585.76469698 2094846.08328142 37.7314487101847 -122.478359538262 (37.7314487101847, -122.478359538262)
107545 37854 1 58 50 Ina Ct 2 1 1 1   07/07/1998 12:00:00 AM     Permit Number 40144 6004964.50568845 2091639.69049004 37.7235254489092 -122.42496422599702 (37.7235254489092, -122.424964225997)
113561 115771 1 58 1204 Egbert Ave 2 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 775363 6015358.9 2090410.1 37.7207308974409 -122.38894654781099 (37.7207308974409, -122.388946547811)
114122 102090 1 58 27 Santa Ana Ave 2 1 1 1 1 12/18/2012 12:00:00 AM   3x3 Permit Number 769734 5992609.4 2096703.2 37.7367229555432 -122.468041385671 (37.7367229555432, -122.468041385671)
116006 106924 2 58 196 States St 2 9 1 1   06/30/2014 12:00:00 AM     Permit Number 772939 6001039.87531 2106387.50014 37.7637969766711 -122.43958767886002 (37.7637969766711, -122.43958767886)
116475 109575 1 58 400 France Ave 2 1 1 1 1 02/24/2015 12:00:00 AM 3 3x3 Permit Number 774875 6002004.0 2089808.9 37.7183308355338 -122.43506727205299 (37.7183308355338, -122.435067272053)
116919 175809 2 58 72 La Grande Ave 2 17 1 1     4     6005230.95207 2091785.5880000002 37.7239410985769 -122.424053538037 (37.7239410985769, -122.424053538037)
125292 40738 1 58 20 Alviso St 2 1 1 1   08/13/1999 12:00:00 AM     Permit Number 41717 5992072.81756498 2091384.27409538 37.7220875062624 -122.469509497536 (37.7220875062624, -122.469509497536)
127386 42819 1 58 801 Bay St 2 1 1 1 1 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
129209 37309 1 58 400 Hill St 2 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
130324 123045 2 58 568 Funston Ave 2 2 1 1     1 Width 3ft   5991929.81513 2111594.03006 37.777569997766705 -122.47147570428301 (37.7775699977667, -122.471475704283)
140417 108905 1 58 200 Cordova St 2 1 1 1 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772783 6001785.8 2087307.2 37.7114493293027 -122.43564261659901 (37.7114493293027, -122.435642616599)
144281 122680 2 58 598x Powhattan Ave 2 1 1 1       3x3   6008469.0 2098078.0 37.7414009906205 -122.413304856031 (37.7414009906205, -122.413304856031)
144836 51903 1 58 168 Caselli Ave 2 1 1 1   07/18/2005 12:00:00 AM     Permit Number 48111 6000192.99372442 2104905.40226883 37.7596792654558 -122.44241036439301 (37.7596792654558, -122.442410364393)
145019 96748 3 58 399X Liberty St 2 1 1 2     4 1.5x2   6003700.0 2103889.2 37.7570882837734 -122.430208878023 (37.7570882837734, -122.430208878023)
155156 125935 2 58 1132 Greenwich St 2 7 1 1     9     6007463.08276 2119890.85277 37.8012373932575 -122.418329199431 (37.8012373932575, -122.418329199431)
155781 222708 2 58 290 States St 2 7 1 1     8 Width 3ft   6000342.850880001 2106861.9429200003 37.76505998306129 -122.442032523579 (37.7650599830613, -122.442032523579)
156475 175816 2 58 616 Dwight St 2 1 1 1     1 Width 3ft   6009781.28405 2091163.7033900002 37.7224893931511 -122.40827985473699 (37.7224893931511, -122.408279854737)
166040 175807 2 58 156 San Juan Ave 2 9 1 1     3 Width 10ft   6001266.11551 2092303.88748 37.725139581023605 -122.437796421768 (37.7251395810236, -122.437796421768)
169588 204739 2 58 463 Mangels Ave 2 9 1 1     3 Width 10ft   5998365.55897 2095230.78545 37.7330107938072 -122.44803394331899 (37.7330107938072, -122.448033943319)
171201 175802 2 58 421 Wheeler Ave 2 1 1 1     3 Width 3ft   6011992.04716 2086775.8851599998 37.7105648747395 -122.400329663484 (37.7105648747395, -122.400329663484)
171203 204735 2 58 40 Vasquez Ave 2 1 1 1     1 Width 3ft   5995650.24765 2100035.09823 37.746046665624 -122.457768945275 (37.746046665624, -122.457768945275)
174132 188415 2 58 2 Jennings St 2 4 1 1     1 Width 3ft   6019090.329030001 2097590.47628 37.7406529492792 -122.37654576818998 (37.7406529492792, -122.37654576819)
176434 124049 2 58 651 11th Ave 2 9 1 1     2 Width 3ft   5992517.64773 2111006.08275 37.775989642541795 -122.469399404795 (37.7759896425418, -122.469399404795)
178316 202043 2 58 52 Exeter St 2 4 1 1     1 Width 3ft   6012522.16713 2090984.69593 37.722150974681604 -122.398792625891 (37.7221509746816, -122.398792625891)
178842 204733 2 58 80 Merced Ave 2 2 1 1     3 Width 3ft   5994927.12974 2099849.55804 37.745495650106605 -122.460255934077 (37.7454956501066, -122.460255934077)
179565 222694 2 58 427 Valley St 2 2 1 1     7     6003122.71421 2099186.4838799997 37.7441430185014 -122.431869572034 (37.7441430185014, -122.431869572034)
185050 204744 2 58 545 Melrose Ave 2 9 1 1     1 Width 6ft   5996927.5801099995 2095415.2897 37.733435093958896 -122.453018700168 (37.7334350939589, -122.453018700168)
3005 208852 2 58 42 Mangels Ave 3 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft   6001113.97001 2095223.0116299998 37.733146173254205 -122.43853142959101 (37.7331461732542, -122.438531429591)
3511 247940 4 58 29 Joy St 3 14 1 2     5   Permit Number 775404 6010280.31746 2098909.2881400003 37.7437850559498 -122.407100501782 (37.7437850559498, -122.407100501782)
8008 39924 1 58 0 Arleta Ave 3 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41198          
12503 93870 1 58 400-422X Tocoloma Ave 3 1 1 1 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773818 6012462.01959 2086667.4072599998 37.7102932120209 -122.398697717749 (37.7102932120209, -122.398697717749)
18455 51904 1 58 168 Caselli Ave 3 1 1 1   07/18/2005 12:00:00 AM     Permit Number 48111 6000192.99372442 2104905.40226883 37.7596792654558 -122.44241036439301 (37.7596792654558, -122.442410364393)
18868 15071 3 58 1X Minerva St 3 11 1 2     3 11   5995959.8595900005 2089005.6685900001 37.7157802951115 -122.45590116312201 (37.7157802951115, -122.455901163122)
35603 204716 2 58 155 Madrone Ave 3 1 1 1     1 Width 3ft   5992699.213880001 2098207.72713 37.7408591943976 -122.467840257748 (37.7408591943976, -122.467840257748)
39239 175813 2 58 15 Athens St 3 9 1 1     1     6005348.05368 2093155.48995 37.727709159929105 -122.42374609402201 (37.7277091599291, -122.423746094022)
45007 248046 2 58 38 Rutledge St 3 17 1 1     4     6010555.404680001 2099417.48898 37.745195855721995 -122.406185107956 (37.745195855722, -122.406185107956)
52153 125934 2 58 1715 Taylor St 3 9 1 1     7 Width 4ft   6008711.31794 2118818.3670900003 37.7983627993626 -122.41393383309799 (37.7983627993626, -122.413933833098)
Powered by Datasette · Query took 5.098ms · Data source: data.sfgov.org