sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3 119263 3 3 495X Lakeshore Dr 1 3 1 2       10x30            
78 251199 6 3 900X 14th St 4 7 1 1       3X3   6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
93 251198 6 3 900X 14th St 3 7 1 1           6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
162 251231 2 3 164 Serrano Dr 1 1 1 1       3x3   5989598.0 2090848.0 37.7204716934452 -122.478025052476 (37.7204716934452, -122.478025052476)
818 251389 2 3 202x Mangels Ave 1 9 1 1       3x3   5999774.0 2095231.0 37.7330917931436 -122.44316462438499 (37.7330917931436, -122.443164624385)
934 251409 2 3 95x Andover St 1 14 1 1       3x3   6007642.0 2098274.0 37.741892697320296 -122.41617822056101 (37.7418926973203, -122.416178220561)
1027 251426 6 3 5020 Diamond Heights Blvd 1 9 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1034 251427 2 3 5028 Diamond Heights Blvd 1 9 1 1       3x3   5999606.0 2100130.0 37.7465337016449 -122.44409733772801 (37.7465337016449, -122.444097337728)
1272 251489 3 3 900 Bosworth St 31 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1273 251481 7 3 32 Peralta Ave 1 13 1 2       3x3   6010779.0 2100499.0 37.7481779538542 -122.40548810426901 (37.7481779538542, -122.405488104269)
1282 251482 3 3 900 Bosworth St 1 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1283 251493 3 3 900 Bosworth St 35 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1286 251492 3 3 900 Bosworth St 34 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1288 251487 3 3 900 Bosworth St 29 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1290 251486 3 3 900 Bosworth St 28 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1295 251491 3 3 900 Bosworth St 33 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1298 251490 3 3 900 Bosworth St 32 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1299 251494 3 3 900 Bosworth St 36 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1310 251480 6 3 51 Peralta Ave 1 7 1 1       3x3   6010641.0 2100362.0 37.747794064611604 -122.40595565659201 (37.7477940646116, -122.405955656592)
1316 251488 3 3 900 Bosworth St 30 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1322 251483 3 3 900 Bosworth St 8 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1332 251484 3 3 900 Bosworth St 7 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1338 251485 3 3 900 Bosworth St 6 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1347 251504 3 3 620x Noriega St 1 11 1 2       3x3   5992030.0 2103590.0 37.7555988620986 -122.470546036282 (37.7555988620986, -122.470546036282)
1384 251515 6 3 99x Mountview Ct 1 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1409 251514 6 3 99x Mountview Ct 2 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1547 251582 3 3 691x Ulloa St 1 16 1 2       3x3   5994175.0 2098101.0 37.7406512558576 -122.462729837498 (37.7406512558576, -122.462729837498)
1598 251612 6 3 60R Amber Dr 1 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1603 251636 6 3 22R Amethyst Way 1 13 1 1           5999148.0 2100052.0 37.74629339412971 -122.44567543770901 (37.7462933941297, -122.445675437709)
1615 251604 6 3 48R Amber Dr 1 13 1 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1616 251607 6 3 52R Amber Dr 2 13 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1620 251543 2 3 0X Bay Shore Blvd Off Ramp   17 1 1                    
1648 251606 6 3 52R Amber Dr 1 13 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
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)
2399 253072 2 3 1350 46th Ave 1 9 1 1       5x10 Permit Number 780489 5981849.666569999 2105897.22193 37.761339917853896 -122.50592325662 (37.7613399178539, -122.50592325662)
2502 253119 5 3 185 Belgrave Ave 1 13 1 1         Permit Number 780239 5997636.85301 2104869.74588 37.759435335978296 -122.45124816933 (37.7594353359783, -122.45124816933)
2503 253120 1 3 815 Buena Vista Ave West 1 9 1 1       10x100   6000071.60031 2108311.04493 37.769023393565604 -122.44307478834801 (37.7690233935656, -122.443074788348)
2859 253251 6 3 99X Lopez Ave 2 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2869 253250 6 3 99X Lopez Ave 1 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2874 253252 6 3 99X Lopez Ave 3 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
3034 253070 2 3 132 Sagamore St 2 7 1 1       Width 0ft Permit Number 780451 5995539.3842400005 2087458.9579900003 37.7115092483173 -122.45724268539699 (37.7115092483173, -122.457242685397)
3138 253254 6 3 270 Castenada Ave 1 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
3537 102838 2 3 1101X Portola Dr 1 9 1 2                    
4553 253637 6 3 701 Noe St 2 7 1 1       Width 3ft   6003144.80454 2104133.37104 37.757727257313704 -122.43214639144101 (37.7577272573137, -122.432146391441)
4659 253652 6 3 131 Font Blvd 2 9 1 1       10x10   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
5104 253785 3 3 1675X 15th Ave 1 11 1 2       3x3   5991390.0 2103897.0 37.7564047756354 -122.47278171886002 (37.7564047756354, -122.47278171886)
5106 253787 3 3 1675X 15th Ave 3 11 1 2       3x3   5991390.0 2103897.0 37.7564047756354 -122.47278171886002 (37.7564047756354, -122.47278171886)
5112 253808 6 3 2 Garfield St 2 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5120 253810 2 3 281 Ralston St 5 9 1 1       3x6   5992187.95019 2089731.22021 37.7175552771373 -122.46899127483299 (37.7175552771373, -122.468991274833)
5161 253809 6 3 2 Garfield St 3 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5176 253818 2 3 219 Concord St 2 1 1 1 1         5999956.6131 2087048.59536 37.7106351918399 -122.44194619318 (37.7106351918399, -122.44194619318)
7810 119607 6 3 299x Avalon Ave 3 7 1 1                    
8128 87100 1 3 700 Connecticut St 1 7 1 3       3x3 Permit Number 50056          
8592 121500 5 3 251X Pennsylvania Ave 1 13 1 2                    
9593 94859 1 3   1 1 1 1       3x3 Permit Number 53932          
9663 114120 2 3 1200X JUNIPERO SERRA BLVD 13 9 1 1           5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9680 173618 2 3 1200X JUNIPERO SERRA BLVD 36 9 1 1           5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9694 173632 2 3 3300X Market St 1 17 1 1                    
9883 173726 6 3 1101 Connecticut St 1 7 1 1           6013424.0 2101939.0 37.752279425117294 -122.396442635345 (37.7522794251173, -122.396442635345)
9968 173756 2 3 1X Emil Ln 2 14 1 1       3x3   5996276.0 2095955.0 37.734879644622296 -122.455310374086 (37.7348796446223, -122.455310374086)
9970 173755 2 3 1X Emil Ln 1 14 1 1       3x3   5996276.0 2095955.0 37.734879644622296 -122.455310374086 (37.7348796446223, -122.455310374086)
9985 120925 6 3 3995X Alemany Blvd 8 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9994 120923 6 3 3995X Alemany Blvd 6 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9998 120931 6 3 3995X Alemany Blvd 14 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9999 120922 6 3 3995X Alemany Blvd 5 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10006 120927 6 3 3995X Alemany Blvd 10 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10015 120928 6 3 3995X Alemany Blvd 11 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10021 120935 6 3 3995X Alemany Blvd 18 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10099 173842 2 3 288X Graystone Ter 1 7 1 1           5999483.0 2103863.0 37.7567765924541 -122.444790942005 (37.7567765924541, -122.444790942005)
10146 173882 2 3 201x Howth St 1 13 1 1           5997459.0 2090748.0 37.7206502603184 -122.450845024895 (37.7206502603184, -122.450845024895)
10199 173896 2 3 326x Dellbrook Ave 1 13 1 1       3x3   5997295.0 2102064.0 37.7517118802849 -122.452228008054 (37.7517118802849, -122.452228008054)
10208 173903 6 3 675 Corbett Ave 1 9 1 1           5999984.0 2103563.0 37.7559814441149 -122.44303676104799 (37.7559814441149, -122.443036761048)
10214 173907 2 3 2200 Jerrold Ave 1 5 1 2           6012443.0 2099218.0 37.7447535037256 -122.399644080592 (37.7447535037256, -122.399644080592)
10223 173927 6 3 240 States St 1 13 1 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
10236 173928 2 3 51 Vulcan Stwy 1 8 1 1           6000543.0 2106304.0 37.763539413759204 -122.441300222472 (37.7635394137592, -122.441300222472)
13319 93075 1 3 1230 Twin Peaks Blvd 1 9 1 1   02/01/2010 12:00:00 AM     Permit Number 53156 5997905.5 2100119.1 37.7464066170132 -122.449976668748 (37.7464066170132, -122.449976668748)
13321 187670 7 3 230 Victoria St 1 13 1 1       3x3   5993274.0 2088748.0 37.7149182807441 -122.465165952001 (37.7149182807441, -122.465165952001)
14837 94862 1 3   2 1 1 1       3x3 Permit Number 53932          
18835 114526 6 3 1 TIOGA AVE 2 2 1 1           6011351.0 2088602.0 37.715543251319204 -122.402673611341 (37.7155432513192, -122.402673611341)
19268 104883 2 3 132 Gonzalez Dr 1 2 1 1           5990322.1 2090011.1 37.718215776001294 -122.475461023549 (37.7182157760013, -122.475461023549)
19583 119914 3 3 400X Brotherhood Way 1 7 1 2       100x100            
19656 101900 7 3 1100 Ocean Ave 1 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
20076 98360 1 3 807 Francisco St 1 2 1 1         Permit Number 768654 6007370.5 2120864.5 37.8039055703948 -122.418718664572 (37.8039055703948, -122.418718664572)
20477 104866 6 3 411 Holladay Ave 1 7 1 1           6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202)
20864 112443 3 3 2199x 25TH ST 3 9 1 2       3x3   6012503.0 2101856.0 37.752000229136705 -122.399621792735 (37.7520002291367, -122.399621792735)
22919 251161 2 3 528 Noriega St 1 11 1 1       3x3   5992330.0 2103518.0 37.7554185113149 -122.46950331083401 (37.7554185113149, -122.469503310834)
23001 251172 6 3 363 Jersey St 2 7 1 1           6002784.74363 2101501.25508 37.750479672211 -122.433203561601 (37.750479672211, -122.433203561601)
41816 104919 2 3 732 Gonzalez Dr 1 2 1 1           5990421.0 2090607.0 37.719857702396 -122.47516265050699 (37.719857702396, -122.475162650507)
44573 112444 3 3 2199x 25TH ST 4 9 1 2       3x3   6012503.0 2101856.0 37.752000229136705 -122.399621792735 (37.7520002291367, -122.399621792735)
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)
49637 114270 2 3 27x ESMERALDA AVE 2 14 1 1       3x3   6006799.0 2098981.0 37.743786524331 -122.41914318493001 (37.743786524331, -122.41914318493)
50075 113043 6 3 500 RAYMOND AVE 2 8 1 1   10/06/2015 12:00:00 AM   3x3   6008527.0 2088690.0 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248)
65540 100177 1 3 252 States St 3 7 1 1         Permit Number 768965 6000636.0 2106677.4 37.764569975148895 -122.44100535545 (37.7645699751489, -122.44100535545)
66024 87113 1 3 470 West Portal Ave 4 19 1 1   01/03/2008 12:00:00 AM     Permit Number 50062 5991694.0 2096460.0 37.736002282933704 -122.47118857830601 (37.7360022829337, -122.471188578306)
67566 87917 1 3 160 Gardenside Dr 2 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50940 5999367.0 2102115.0 37.751970392561496 -122.445066449965 (37.7519703925615, -122.445066449965)
69379 122419 2 3 2200 San Jose Ave 1 1 1 6       3x3   5998886.0 2091075.0 37.7216297132481 -122.44593585753599 (37.7216297132481, -122.445935857536)
74398 97290 7 3 55 Hiliritas Ave   7 1 1         Permit Number 778896 6001461.7 2096833.2 37.7375871516219 -122.437444499981 (37.7375871516219, -122.437444499981)
77320 122488 2 3 69x Bonview St 4 1 1 2       3x3   6007716.0 2099172.0 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063)
77674 116662 3 3 199x Esmeralda Ave 15 14 1 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
77706 114927 2 3 4400x OCEAN AVE 1 8 1 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
Powered by Datasette · Query took 10.163ms · Data source: data.sfgov.org