sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
21324 621 3 31 3151 24th St 1 1 1 2   09/23/1992 12:00:00 AM 18 3X3   6007979.07595 2102079.2423799997 37.7523599891254 -122.41528202924101 (37.7523599891254, -122.415282029241)
83290 11584 3 31 4001 Judah St 1 1 1 2     0 3X3   5982142.686634201 2105549.2773534 37.7604018044904 -122.504884056543 (37.7604018044904, -122.504884056543)
87474 16273 3 31 692X Monterey Blvd 2 11 1 2   02/02/2003 12:00:00 AM 12 3X3   5997509.7184819 2094751.8939266002 37.7316469123248 -122.450958273614 (37.7316469123248, -122.450958273614)
97652 4167 3 31 3781 Cesar Chavez St 1 1 1 2   01/04/1993 12:00:00 AM 12 3X3   6005338.8489102 2100470.9859700003 37.7477953482432 -122.424297997893 (37.7477953482432, -122.424297997893)
98438 117606 1 31 420 Castro St 2 1 1 1     6 3X3   6002292.2454566 2105806.2278627 37.7622721434766 -122.43521453981701 (37.7622721434766, -122.435214539817)
101513 83941 1 31 60 13th St 1 1 1 1   01/18/2008 12:00:00 AM   3X3 Permit Number 50121 6008302.41836553 2108360.42350377 37.7696248364946 -122.41460830425899 (37.7696248364946, -122.414608304259)
110655 28415 3 31 692X Monterey Blvd 3 11 1 2   02/02/2003 12:00:00 AM 12 3X3   5997509.7184819 2094751.8939266002 37.7316469123248 -122.450958273614 (37.7316469123248, -122.450958273614)
128524 117607 1 31 420 Castro St 3 1 1 1     6 3X3   6002292.2454566 2105806.2278627 37.7622721434766 -122.43521453981701 (37.7622721434766, -122.435214539817)
3525 253489 4 31 1x Gordon St 7 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3532 253483 4 31 1x Gordon St 1 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3533 253491 4 31 1x Gordon St 9 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3538 253485 4 31 1x Gordon St 3 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3546 253495 4 31 1x Gordon St 13 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3553 253492 4 31 1x Gordon St 10 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3554 253490 4 31 1x Gordon St 8 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3555 253487 4 31 1x Gordon St 5 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3562 253488 4 31 1x Gordon St 6 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3563 253493 4 31 1x Gordon St 11 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3573 253496 4 31 1x Gordon St 14 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3581 253486 4 31 1x Gordon St 4 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3582 253484 4 31 1x Gordon St 2 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3587 253494 4 31 1x Gordon St 12 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
6292 87392 1 31 3322 Fillmore St 2 1 1 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002333.63287 2119648.2941900003 37.800281314083705 -122.43606195061199 (37.8002813140837, -122.436061950612)
6671 87391 1 31 3322 Fillmore St 1 1 1 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002335.87278 2119635.99284 37.800247665053 -122.43605331890801 (37.800247665053, -122.436053318908)
15504 49998 1 31 1101X 19th St 1 1 1 1 1 07/25/2003 12:00:00 AM 12 3x3 Permit Number 46740 6014225.48172 2105233.1729900003 37.7613690835438 -122.39390153433901 (37.7613690835438, -122.393901534339)
18713 34080 1 31 240 Shotwell St 3 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
19051 582 3 31 3013 24th St 1 1 1 2   09/23/1992 12:00:00 AM 12 3x3   6008818.92095 2102127.6459 37.7525400594852 -122.41238111940099 (37.7525400594852, -122.412381119401)
29943 83166 1 31 1089 Gilman Ave 1 1 1 1   07/02/2009 12:00:00 AM 7 3x3 Permit Number 52361 6015096.6014 2089812.1317 37.719074451264 -122.389811494874 (37.719074451264, -122.389811494874)
34945 113776 2 31 1710 Baker St 1 1 1 1     12 3x3   6000070.198 2114878.1306 37.7870548531015 -122.443551447546 (37.7870548531015, -122.443551447546)
47070 83362 1 31 3325 Rivera St 1 1 1 1   07/01/2008 12:00:00 AM 5 3x3 Permit Number 51120 5982822.4546 2100126.935 37.745553538391206 -122.50213183404101 (37.7455535383912, -122.502131834041)
48125 36793 1 31 1350 Donner Ave 2 1 1 1   05/26/1998 12:00:00 AM 8 3x3 Permit Number 39527 6015250.697000001 2090820.757 37.721852482589796 -122.38934923747601 (37.7218524825898, -122.389349237476)
53611 109316 2 31 1516 BROADWAY 3 1 1 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
80153 82685 1 31 35 Jennings Ct 1 1 1 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52459 6012802.99497586 2089176.16957459 37.7172007679129 -122.397695078281 (37.7172007679129, -122.397695078281)
80434 30020 3 31 710X San Jose Ave 12 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005718.76576524 2099005.5772577 37.7437931149581 -122.42288013057501 (37.7437931149581, -122.422880130575)
80952 109314 2 31 1516 BROADWAY 1 1 1 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
81156 109317 2 31 1516 BROADWAY 4 1 1 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
82547 30021 3 31 710X San Jose Ave 13 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005718.76576524 2099005.5772577 37.7437931149581 -122.42288013057501 (37.7437931149581, -122.422880130575)
83323 30003 3 31 610X San Jose Ave 15 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6006030.83928578 2099887.5672939997 37.74623246341729 -122.42186369026399 (37.7462324634173, -122.421863690264)
86383 34081 1 31 240 SHOTWELL ST 4 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
86898 34083 1 31 240 Shotwell St 6 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
87668 103568 2 31 223 Parnassus Ave 1 1 1 1     8 3x3   5997125.5 2106655.6 37.76430954658429 -122.45314559026801 (37.7643095465843, -122.453145590268)
94982 39859 1 31 70 13th St 2 1 1 1   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008235.62773227 2108364.64558499 37.7696326766808 -122.41483963035499 (37.7696326766808, -122.414839630355)
96207 108286 2 31 1 HENRY ADAMS ST 11 5 1 1       3x3   6011517.4 2108140.5 37.769201076268395 -122.40347225564399 (37.7692010762684, -122.403472255644)
98468 34082 1 31 240 Shotwell St 5 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
98537 34079 1 31 240 Shotwell St 2 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
100434 108225 1 31 240 Shotwell St 14 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
103766 85491 1 31 4400 24th St   1 1 1   09/05/2007 12:00:00 AM   3x3 Permit Number 52154 6000641.0 2101716.0 37.7509474670616 -122.440632169404 (37.7509474670616, -122.440632169404)
105965 108221 1 31 240 Shotwell St 10 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
106308 34076 1 31 2851X 16th St 2 1 1 1 1 12/19/2011 12:00:00 AM 6 3x3 Permit Number 768574 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
106980 108282 2 31 1 HENRY ADAMS ST 7 5 1 1     10 3x3   6011517.4 2108140.5 37.769201076268395 -122.40347225564399 (37.7692010762684, -122.403472255644)
107863 39860 1 31 70 13th St 3 1 1 1   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008235.62773227 2108364.64558499 37.7696326766808 -122.41483963035499 (37.7696326766808, -122.414839630355)
109559 98644 2 31 2391 Folsom St 1 1 1 1     8 3x3   6008222.0 2104509.0 37.7590452010005 -122.414613883143 (37.7590452010005, -122.414613883143)
111471 52313 1 31 4400HOFFMAN 24th St 3 1 1 1   05/22/2009 12:00:00 AM   3x3 Permit Number 52154 6000634.55195661 2101724.81174328 37.7509712947951 -122.440655099281 (37.7509712947951, -122.440655099281)
112993 99104 2 31 3644 20th St 1 1 1 1       3x3   6006000.9 2104423.0 37.7586840282695 -122.422289399469 (37.7586840282695, -122.422289399469)
113895 52312 1 31 4400HOFFMAN 24th St 2 1 1 1   05/22/2009 12:00:00 AM   3x3 Permit Number 52154 6000634.55195661 2101724.81174328 37.7509712947951 -122.440655099281 (37.7509712947951, -122.440655099281)
113940 107411 1 31 3634 20th St 2 10 1 1       3x3   6006068.0 2104353.0 37.7584956093101 -122.422052363883 (37.7584956093101, -122.422052363883)
114868 83791 1 31 369 Prentiss St 1 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50933 6008828.16902132 2097088.78446754 37.7387049796432 -122.411993079981 (37.7387049796432, -122.411993079981)
115414 52311 1 31 4400HOFFMAN 24th St 1 1 1 1   05/22/2009 12:00:00 AM   3x3 Permit Number 52154 6000634.55195661 2101724.81174328 37.7509712947951 -122.440655099281 (37.7509712947951, -122.440655099281)
116911 109315 2 31 1516 BROADWAY 2 1 1 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
117733 62050 1 31 70 13th St 1 1 1 1   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008120.0 2108416.0 37.769767186200795 -122.41524321981701 (37.7697671862008, -122.415243219817)
118122 108224 1 31 240 Shotwell St 13 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
118194 108227 1 31 240 Shotwell St 16 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
118249 39861 1 31 70 13th St 4 1 1 1   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008235.62773227 2108364.64558499 37.7696326766808 -122.41483963035499 (37.7696326766808, -122.414839630355)
120475 108220 1 31 240 Shotwell St 9 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
120751 34077 1 31 2851X 16th St 3 1 1 1 1 12/19/2011 12:00:00 AM 6 3x3 Permit Number 768574 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
121741 99249 1 31 435 Paul Ave 1 1 1 1   08/27/2012 12:00:00 AM   3x3 Permit Number 769233 6012286.9 2091380.6 37.7232249352354 -122.399633675727 (37.7232249352354, -122.399633675727)
126801 34084 1 31 240 Shotwell St 7 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
127065 84127 1 31 88 Mill St 1 1 1 1   06/19/2008 12:00:00 AM   3x3 Permit Number 50980 6010360.09243836 2089687.02520781 37.7184671339256 -122.406175049692 (37.7184671339256, -122.406175049692)
127307 110182 1 31 339 ELSIE ST 1 1 1 1   10/20/2015 12:00:00 AM   3x3 Permit Number 776744 6006513.8 2097161.9 37.7387756178582 -122.420000276005 (37.7387756178582, -122.420000276005)
129363 108222 1 31 240 Shotwell St 11 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
137872 82840 1 31 1379 Quesada Ave 1 1 1 1   07/08/2009 12:00:00 AM 13 3x3 Permit Number 52465 6016423.5899 2093711.7525 37.729855545757 -122.38549618052299 (37.729855545757, -122.385496180523)
138600 30004 3 31 610X San Jose Ave 16 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6006030.83928578 2099887.5672939997 37.74623246341729 -122.42186369026399 (37.7462324634173, -122.421863690264)
140788 34085 1 31 2851X 16th St 1 1 1 1 1 12/19/2011 12:00:00 AM 6 3x3 Permit Number 768574 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
141713 82360 1 31 415-421 South Van Ness Ave 1 1 1 1 1 12/23/2011 12:00:00 AM 10 3x3 Permit Number 768604 6007434.83105048 2107262.94030089 37.766562624561 -122.417531473498 (37.766562624561, -122.417531473498)
142472 108226 1 31 240 Shotwell St 15 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
145082 88286 1 31 240 Shotwell St 1 1 1 1   07/09/2008 12:00:00 AM   3x3 Permit Number 51287 6007754.0 2106536.0 37.7645845697556 -122.416376026653 (37.7645845697556, -122.416376026653)
145218 71944 1 31 1342 Shotwell St 1 1 1 1   11/04/1995 12:00:00 AM   3x3 Permit Number 50253 6008035.06455956 2100432.68279191 37.7478420534954 -122.414971880187 (37.7478420534954, -122.414971880187)
145642 108223 1 31 240 Shotwell St 12 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
145835 80165 1 31 415-421 South Van Ness Ave 2 1 1 1 1 12/23/2011 12:00:00 AM 10 3x3 Permit Number 768604 6007434.83105048 2107262.94030089 37.766562624561 -122.417531473498 (37.766562624561, -122.417531473498)
163040 82715 1 31 1379 Quesada Ave 2 1 1 1   07/08/2009 12:00:00 AM 11 3x3 Permit Number 52465 6016442.9825 2093699.9014 37.7298240779238 -122.385428311894 (37.7298240779238, -122.385428311894)
166782 36797 1 31 1350 Donner Ave 3 1 1 1   05/26/1998 12:00:00 AM 8 3x3 Permit Number 39527 6015213.5435 2090847.5562 37.721924008003604 -122.389479539312 (37.7219240080036, -122.389479539312)
174472 36791 1 31 1350 Donner Ave 4 1 1 1   05/26/1998 12:00:00 AM 9 3x3 Permit Number 39527 6015186.7443 2090870.701 37.7219860731406 -122.389573793771 (37.7219860731406, -122.389573793771)
179138 36792 1 31 1350 Donner Ave 5 1 1 1 1 05/26/1998 12:00:00 AM 9 3x3 Permit Number 39527 6015166.6448 2090882.8824 37.7220184063671 -122.38964412365499 (37.7220184063671, -122.389644123655)
87848 100205 2 31 4085 20th St 1 1 1 1   09/27/2012 12:00:00 AM 12 3x4 Permit Number 769140 6003091.0 2104064.0 37.757533730328205 -122.43232751517901 (37.7575337303282, -122.432327515179)
13285 187639 4 31 1671 34th Ave 1 1 1 1   02/22/2017 12:00:00 AM 3 3x6   5985585.0 2103854.0 37.7559489545124 -122.492853989295 (37.7559489545124, -122.492853989295)
59569 115612 1 31 1400 16th St 2 1 1 1     7 4x4   6012209.3182 2107055.3618 37.7662601539356 -122.401002678345 (37.7662601539356, -122.401002678345)
107827 115617 1 31 1400 16th St 7 1 1 1       4x4   6012270.55026102 2107054.03832976 37.7662599354936 -122.400790794031 (37.7662599354936, -122.400790794031)
110007 115616 1 31 1400 16th St 6 1 1 1       4x4   6012270.55026102 2107054.03832976 37.7662599354936 -122.400790794031 (37.7662599354936, -122.400790794031)
110112 115632 2 31 55x 15TH ST 4 1 1 1       4x4   6012114.0 2107494.0 37.7674592382642 -122.40136319642001 (37.7674592382642, -122.40136319642)
157293 60204 1 31 1400 16th St 1 1 1 1   06/04/1982 12:00:00 AM 8 4x4 Permit Number 19750 6012229.2906 2107053.9352 37.766257350909704 -122.400933496957 (37.7662573509097, -122.400933496957)
172140 115615 1 31 1400 16th St 5 1 1 1     7 4x4   6012069.0366 2107045.8512 37.766226213653 -122.40148722008699 (37.766226213653, -122.401487220087)
78446 16228 3 31 564X Monterey Blvd 2 11 1 2   02/02/2003 12:00:00 AM 12 5   5998342.280841901 2094738.2735002 37.731657141982204 -122.44807897208 (37.7316571419822, -122.44807897208)
78838 16202 3 31 500X Monterey Blvd 2 11 1 2   02/02/2003 12:00:00 AM 12 5   5998782.1299536 2094714.7967047 37.7316178141427 -122.446556643647 (37.7316178141427, -122.446556643647)
87736 16286 3 31 700X Monterey Blvd 3 11 1 2   02/02/2003 12:00:00 AM 12 5   5997448.036427 2094744.2173306 37.7316223027997 -122.45117096626998 (37.7316223027997, -122.45117096627)
96559 16227 3 31 564X Monterey Blvd 1 11 1 2   02/02/2003 12:00:00 AM 12 5   5998342.280841901 2094738.2735002 37.731657141982204 -122.44807897208 (37.7316571419822, -122.44807897208)
109605 16314 3 31 758X Monterey Blvd 6 11 1 2   02/02/2003 12:00:00 AM 12 5   5997070.7706475 2094757.2260752 37.7316364140758 -122.45247618016899 (37.7316364140758, -122.452476180169)
111546 28414 3 31 600X Monterey Blvd 3 11 1 2   02/02/2003 12:00:00 AM 12 5   5998107.3609693 2094732.8027768002 37.7316286888145 -122.448890739326 (37.7316286888145, -122.448890739326)
118733 16313 3 31 758X Monterey Blvd 5 11 1 2   02/02/2003 12:00:00 AM 12 5   5997070.7706475 2094757.2260752 37.7316364140758 -122.45247618016899 (37.7316364140758, -122.452476180169)
139874 16201 3 31 500X Monterey Blvd 1 11 1 2   02/02/2003 12:00:00 AM 12 5   5998782.1299536 2094714.7967047 37.7316178141427 -122.446556643647 (37.7316178141427, -122.446556643647)
144031 16312 3 31 758X Monterey Blvd 4 11 1 2   02/02/2003 12:00:00 AM 12 5   5997070.7706475 2094757.2260752 37.7316364140758 -122.45247618016899 (37.7316364140758, -122.452476180169)
7036 16366 3 31 1306X Montgomery St 9 11 1 2     8 8   6011454.042780001 2119896.37482 37.8014764015683 -122.40451904281299 (37.8014764015683, -122.404519042813)
Powered by Datasette · Query took 4.041ms · Data source: data.sfgov.org