sf-trees

Data source: data.sfgov.org

Custom SQL query returning 97 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
123571 42821 1 58 801 Bay St 9 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)
124574 87268 1 58 727 Moraga St   5 1 1   03/05/2008 12:00:00 AM     Permit Number 50290 5992077.0 2103851.0 37.756318217439706 -122.47040250406201 (37.7563182174397, -122.470402504062)
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)
125228 109402 2 58 1588 WALLER ST 5 1 1 1       3x3   5997977.9 2108248.0 37.7687306888354 -122.450312188331 (37.7687306888354, -122.450312188331)
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)
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)
125842 37280 1 58 700 Sanchez St 3 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)
126150 42826 1 58 801 Bay St 3 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)
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)
127057 116678 3 58 100 Esmeralda Ave 17 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
127137 122679 2 58 598x Powhattan Ave 1 1 1 1       3x3   6008469.0 2098078.0 37.7414009906205 -122.413304856031 (37.7414009906205, -122.413304856031)
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)
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)
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)
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)
129739 204728 2 58 400 Junipero Serra Blvd 13 4 1 1     2 Width 0ft   5991366.51565 2094145.3724 37.729627950748295 -122.47215214722401 (37.7296279507483, -122.472152147224)
129974 222689 2 58 200 Eugenia Ave 33 7 1 1     7 Width 10ft   6006609.95498 2098107.9290400003 37.7413786194175 -122.419734923451 (37.7413786194175, -122.419734923451)
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)
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)
133308 222682 2 58 2 Trainor St 12 1 1 1     2 Width 3ft   6008292.2753800005 2108046.95875 37.768763565716704 -122.41462120290501 (37.7687635657167, -122.414621202905)
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)
135308 204726 2 58 300 Junipero Serra Blvd 30 4 1 1     5 Width 0ft   5991392.43358 2094433.51883 37.7304206284982 -122.472083541544 (37.7304206284982, -122.472083541544)
136139 222692 2 58 501 York St 5 9 1 1     5 Width 2ft   6009835.7153900005 2105907.76012 37.7629764094606 -122.409131567579 (37.7629764094606, -122.409131567579)
136522 204722 2 58 422 Bright St 1 9 1 1     6     5993793.315830001 2090006.70292 37.7184043108851 -122.46346228245501 (37.7184043108851, -122.463462282455)
136961 205922 2 58 370 Monterey Blvd 19 9 1 1     4 Width 8ft   5999640.50046 2094726.6696 37.7316994068856 -122.443589949734 (37.7316994068856, -122.443589949734)
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)
138640 37856 1 58 50 Ina Ct 4 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)
139508 37304 1 58 400 Hill St 5 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)
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)
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)
141053 51954 1 58 82 Mary St 3 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)
141381 42823 1 58 801 Bay St 7 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)
141695 37284 1 58 700 Sanchez St 4 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)
142039 36072 1 58 1504 Bryant St 4 1 1 1 1 04/28/1998 12:00:00 AM     Permit Number 39187 6009387.99483758 2107777.56202059 37.7680853638298 -122.410812146882 (37.7680853638298, -122.410812146882)
143101 37299 1 58 400 Hill St 4 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)
144281 122680 2 58 598x Powhattan Ave 2 1 1 1       3x3   6008469.0 2098078.0 37.7414009906205 -122.413304856031 (37.7414009906205, -122.413304856031)
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)
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)
145383 37308 1 58 400 Hill St 11 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)
145814 106327 1 58 37 Elsie St   1 1 1       3X3 Permit Number 772574 6007569.3 2099210.3 37.7444594805766 -122.4164959017 (37.7444594805766, -122.4164959017)
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)
146973 187576 2 58 72 Bishop St 3 17 1 1     6     6010826.85106 2089479.8583099998 37.7179243930824 -122.40454707471301 (37.7179243930824, -122.404547074713)
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)
148509 188398 2 58 501 Utah St 4 1 1 1     12 Width 5ft   6010694.68122 2105889.4054 37.7629740945886 -122.406159391868 (37.7629740945886, -122.406159391868)
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)
154057 204723 2 58 300 Junipero Serra Blvd 12 4 1 1     5 Width 0ft   5991397.3981 2094531.5501400002 37.7306900851772 -122.47207352129801 (37.7306900851772, -122.472073521298)
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)
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)
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)
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)
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)
162264 187573 2 58 73 Bishop St 4 17 1 1     14     6010858.37792 2089492.3055900002 37.717960332674295 -122.404438975305 (37.7179603326743, -122.404438975305)
162790 222684 2 58 1100 San Jose Ave 28 7 1 1     4     6004829.85448 2096667.61167 37.7373233955514 -122.42578739946501 (37.7373233955514, -122.425787399465)
165084 204743 2 58 280 Joost Ave 6 1 1 1     5 Width 7ft   6000165.05205 2094974.5458099998 37.732409919872 -122.441794258103 (37.732409919872, -122.441794258103)
165288 188407 3 58 1300x De Haro St 5 3 1 2     6     6012285.79175 2102196.41625 37.7529228280459 -122.400396843734 (37.7529228280459, -122.400396843734)
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)
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)
166591 222687 2 58 200 Eugenia Ave 19 7 1 1     5     6006597.39234 2098081.5973 37.741305610657 -122.419776492811 (37.741305610657, -122.419776492811)
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)
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)
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)
170368 204724 2 58 300 Junipero Serra Blvd 21 4 1 1     8 Width 0ft   5991391.18592 2094484.3447599998 37.730560111554496 -122.47209155808999 (37.7305601115545, -122.47209155809)
170450 204725 2 58 300 Junipero Serra Blvd 29 4 1 1     5 Width 0ft   5991390.23736 2094439.33755 37.730436478151496 -122.47209155807501 (37.7304364781515, -122.472091558075)
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)
171476 188405 3 58 1300x De Haro St 9 3 1 2     9     6012256.82794 2102204.54617 37.752943535820606 -122.400497577699 (37.7529435358206, -122.400497577699)
171726 204714 2 58 1484 16th Ave 4 2 1 1     6 Width 5ft   5991182.79274 2105342.1880099997 37.7603608823676 -122.473603723127 (37.7603608823676, -122.473603723127)
172205 222688 2 58 200 Eugenia Ave 20 7 1 1     10     6006604.22222 2098080.62198 37.741303317398206 -122.419752808255 (37.7413033173982, -122.419752808255)
172403 204736 2 58 40 Vasquez Ave 4 1 1 1     1 Width 3ft   5995677.52131 2100065.8007099996 37.7461325337836 -122.457676858293 (37.7461325337836, -122.457676858293)
173385 175810 2 58 72 La Grande Ave 3 17 1 1     6     6005231.38021 2091782.6619 37.7239330883183 -122.424051850035 (37.7239330883183, -122.424051850035)
173848 188410 2 58 1501 22nd St 23 7 1 1     15     6013292.91596 2103788.2689099996 37.7573498217412 -122.397025598364 (37.7573498217412, -122.397025598364)
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)
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)
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)
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)
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)
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)
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)
185898 188406 3 58 1300x De Haro St 6 3 1 2     6 Width 9ft   6012288.20028 2102185.92507 37.75289415586 -122.400387777694 (37.75289415586, -122.400387777694)
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)
188538 204729 2 58 400 Junipero Serra Blvd 16 4 1 1     1 Width 0ft   5991368.5463 2094108.06034 37.729525618690204 -122.47214240847 (37.7295256186902, -122.47214240847)
Powered by Datasette · Query took 2.46ms · Data source: data.sfgov.org