sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
93 251198 6 3 900X 14th St 3 7 1 1           6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
95 251197 6 3 900X 14th St 3 7 1 1   03/22/2017 12:00:00 AM 3   Permit Number 779570 6002798.55883 2107703.57748 37.7675105430125 -122.43359899801901 (37.7675105430125, -122.433598998019)
96 251196 6 3 900X 14th St 2 8 1 1   03/22/2017 12:00:00 AM 3     6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
1027 251426 6 3 5020 Diamond Heights Blvd 1 9 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1272 251489 3 3 900 Bosworth St 31 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
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)
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)
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)
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)
3537 102838 2 3 1101X Portola Dr 1 9 1 2                    
3818 178337 6 3 401 Ocean Ave 3 9 1 6     29     5998676.28102 2091524.0079700002 37.7228506076618 -122.44669308741301 (37.7228506076618, -122.446693087413)
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                    
8592 121500 5 3 251X Pennsylvania Ave 1 13 1 2                    
9639 114121 2 3 1200X JUNIPERO SERRA BLVD 14 9 1 1     28     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9641 114157 6 3 1200x JUNIPERO SERRA BLVD 18 7 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9642 114119 2 3 1200X JUNIPERO SERRA BLVD 12 9 1 1     24     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9643 114152 6 3 1200X JUNIPERO SERRA BLVD 11 7 1 1     8     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9644 114150 6 3 1200X JUNIPERO SERRA BLVD 9 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9645 114115 2 3 1200X JUNIPERO SERRA BLVD 8 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9647 114149 6 3 1200X JUNIPERO SERRA BLVD 8 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9651 114156 6 3 1200x JUNIPERO SERRA BLVD 17 7 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9652 114118 2 3 1200X JUNIPERO SERRA BLVD 11 9 1 1     28     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9653 114116 2 3 1200X JUNIPERO SERRA BLVD 9 9 1 1     18     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9656 114151 6 3 1200X JUNIPERO SERRA BLVD 10 7 1 1     8     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9657 114153 6 3 1200x JUNIPERO SERRA BLVD 12 7 1 1     40     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9659 114136 2 3 1200X JUNIPERO SERRA BLVD 31 9 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9661 114148 6 3 1200X JUNIPERO SERRA BLVD 7 7 1 1     19     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9663 114120 2 3 1200X JUNIPERO SERRA BLVD 13 9 1 1           5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9675 114114 2 3 1200X JUNIPERO SERRA BLVD 7 9 1 1     40     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9676 114117 2 3 1200X JUNIPERO SERRA BLVD 10 9 1 1     28     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9679 114122 2 3 1200X JUNIPERO SERRA BLVD 15 9 1 1     36     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)
9989 173658 2 3 1200X JUNIPERO SERRA BLVD 46 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9997 173656 2 3 1200X JUNIPERO SERRA BLVD 44 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10001 173622 2 3 1200X JUNIPERO SERRA BLVD 40 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10003 173619 2 3 1200X JUNIPERO SERRA BLVD 37 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10004 114140 6 3 1200X JUNIPERO SERRA BLVD 5 17 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10009 173621 2 3 1200X JUNIPERO SERRA BLVD 39 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10013 173624 2 3 1200X JUNIPERO SERRA BLVD 42 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10017 173623 2 3 1200X JUNIPERO SERRA BLVD 41 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10018 173657 2 3 1200X JUNIPERO SERRA BLVD 45 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10020 115676 2 3 1200X Junipero Serra Blvd 5 7 1 1   01/20/2017 12:00:00 AM 3     5991123.2 2089585.5 37.717093588438 -122.472660975441 (37.717093588438, -122.472660975441)
10022 173620 2 3 1200X JUNIPERO SERRA BLVD 38 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
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)
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)
11659 106061 3 3 12X Canyon Dr 1 3 1 2     40     6003256.93175 2086330.4794599998 37.7088509162175 -122.430488359046 (37.7088509162175, -122.430488359046)
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)
18835 114526 6 3 1 TIOGA AVE 2 2 1 1           6011351.0 2088602.0 37.715543251319204 -122.402673611341 (37.7155432513192, -122.402673611341)
18877 82435 6 3 51 Peralta Ave 1 7 1 1   04/02/2005 12:00:00 AM 20     6010636.52703341 2100363.58782589 37.7477981742678 -122.405971235802 (37.7477981742678, -122.405971235802)
19268 104883 2 3 132 Gonzalez Dr 1 2 1 1           5990322.1 2090011.1 37.718215776001294 -122.475461023549 (37.7182157760013, -122.475461023549)
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)
23001 251172 6 3 363 Jersey St 2 7 1 1           6002784.74363 2101501.25508 37.750479672211 -122.433203561601 (37.750479672211, -122.433203561601)
23115 5045 3 3 5399X Diamond Heights Blvd 6 1 1 2     12     6002018.5391 2098420.87622 37.741978183035606 -122.435632798636 (37.7419781830356, -122.435632798636)
23936 211142 2 3 100 Terrace Dr 1 2 1 1     31     5993344.399119999 2096880.05499 37.7372509740365 -122.465513038912 (37.7372509740365, -122.465513038912)
24072 246633 2 3 3320 Harrison St 4 7 1 1     3     6009029.84734 2099262.75496 37.7446855398981 -122.411449314735 (37.7446855398981, -122.411449314735)
24680 187543 2 3 1400 Somerset St 3 17 1 1     35     6011384.82868 2088240.1087599997 37.714551459646394 -122.402531250636 (37.7145514596464, -122.402531250636)
24719 247088 2 3 2301 Castro St 6 7 1 1     1     6002764.361830001 2098589.4854900003 37.74248347881979 -122.43306602918001 (37.7424834788198, -122.43306602918)
24871 178331 2 3 0 Crespi Dr 3 9 1 1     14     5990248.62782 2090529.4940400003 37.719634898219205 -122.47575281776001 (37.7196348982192, -122.47575281776)
25144 211274 2 3 198 Mangels Ave 2 9 1 1     10     6000155.24688 2095249.8649900001 37.733165323413296 -122.441847909861 (37.7331653234133, -122.441847909861)
25725 178308 2 3 0 Font Blvd 1 2 1 1     31     5990210.12045 2089417.27348 37.716578783365605 -122.47580474370501 (37.7165787833656, -122.475804743705)
26291 178180 2 3 491 La Grande Ave 4 23 1 1     20     6004422.927759999 2089235.71163 37.716894041605 -122.42666525741001 (37.716894041605, -122.42666525741)
26554 178310 2 3 0 Serrano Dr 5 2 1 1     34     5989465.34816 2090743.3229599998 37.7201765760646 -122.478475931633 (37.7201765760646, -122.478475931633)
27306 178328 2 3 0 Gonzalez Dr 2 2 1 1     29     5990317.34225 2090043.8786900002 37.718305502374704 -122.47547986090599 (37.7183055023747, -122.475479860906)
27377 211177 2 3 2 Lobos St 3 2 1 1     10     5996889.59605 2088696.8686799998 37.714985719781 -122.45266530885799 (37.714985719781, -122.452665308858)
29239 211277 2 3 232 Edna St 4 17 1 1     43     5998792.56249 2095483.7387400002 37.7337297433315 -122.44657587878599 (37.7337297433315, -122.446575878786)
29803 187601 2 3 748 University St 5 7 1 1     13     6008719.70605 2090696.0975099998 37.7211459436074 -122.41191647478998 (37.7211459436074, -122.41191647479)
30066 178334 2 3 11 Pilgrim Ave 1 7 1 1     79     6000689.70014 2093938.9080400001 37.729596178617705 -122.439906202537 (37.7295961786177, -122.439906202537)
30086 121490 3 3 400x Vermont St 1 7 1 2     24     6011163.12299 2106299.7163 37.7641269067524 -122.40456808916201 (37.7641269067524, -122.404568089162)
30555 233288 2 3 1101 San Jose Ave 50 7 1 1     16     6005007.65739 2096608.21233 37.7371703444393 -122.425168426689 (37.7371703444393, -122.425168426689)
31259 201730 2 3 1411 Phelps St 5 17 1 1     20     6013762.45417 2095926.0507 37.7357879596321 -122.39485111951001 (37.7357879596321, -122.39485111951)
31497 178323 2 3 0 Gonzalez Dr 1 2 1 1     26     5990245.32384 2089538.4798299999 37.7169136270349 -122.475691910275 (37.7169136270349, -122.475691910275)
31535 194476 3 3 900x Carolina St 43 3 1 2     22     6012491.75598 2103075.9348299997 37.755349278054 -122.39974632722799 (37.755349278054, -122.399746327228)
31604 194496 2 3 2 Tulare St 10 7 1 1     9     6016213.72406 2100305.90107 37.7479501266034 -122.386681367746 (37.7479501266034, -122.386681367746)
31759 246819 2 3 198 Brewster St 1 9 1 1     9     6010082.129869999 2098751.7799299997 37.7433414797155 -122.407774686679 (37.7433414797155, -122.407774686679)
31917 194488 2 3 1401 Rhode Island St 1 2 1 1     24     6012030.157269999 2101805.35505 37.751834800344 -122.40125340303601 (37.751834800344, -122.401253403036)
32328 211103 3 3 2187x 09th Ave 7 3 1 2     42     5993592.96046 2100932.97127 37.7483935940092 -122.464947913926 (37.7483935940092, -122.464947913926)
33366 124269 2 3 9 03rd Ave 1 7 1 1     28     5994882.44582 2114964.8982 37.7869958645771 -122.461506079992 (37.7869958645771, -122.461506079992)
Powered by Datasette · Query took 21.366ms · Data source: data.sfgov.org