sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
8128 87100 1 3 700 Connecticut St 1 7 1 3       3x3 Permit Number 50056          
18074 112652 2 21 3100X 26TH ST 6 1 1 3       3x3   6008747.0 2100981.0 37.749387590387 -122.41254878695 (37.749387590387, -122.41254878695)
20082 111807 2 43 50X COLUMBIA SQUARE ST 4 1 1 3       3x3   6010857.0 2110997.0 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357)
20843 111792 2 43 55X SHERMAN ST 9 1 1 3       3x3   6010857.0 2110997.0 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357)
20862 116132 2 17 1601X Armstrong Ave 4 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
48565 112649 2 21 3100X 26TH ST 3 1 1 3       3x3   6008747.0 2100981.0 37.749387590387 -122.41254878695 (37.749387590387, -122.41254878695)
67560 117168 2 35 299x ALMA ST 5 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
72532 116318 2 54 1451 Hampshire St 1 1 1 3           6010547.7 2101110.8 37.749844886729996 -122.406331036849 (37.74984488673, -122.406331036849)
76816 104448 5 18 2490X Folsom St 3 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
77584 103197 3 104 1601X 28th Ave 15 5 1 3   03/26/2013 12:00:00 AM   3x4 Permit Number 770085 5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
77747 116129 2 17 1601X Armstrong Ave 1 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
77843 98421 3 15 1501X Steiner St 5 1 1 3       3x3 Permit Number 768629 6002677.2 2113386.1 37.7831064505465 -122.43442509431299 (37.7831064505465, -122.434425094313)
78427 111811 2 43 50X COLUMBIA SQUARE ST 8 1 1 3       3x3   6010857.0 2110997.0 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357)
78486 117170 2 35 299x ALMA ST 7 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
78776 85052 1 97 355x Page St 2 1 1 3   06/27/2007 12:00:00 AM     Permit Number 49332 6004826.8 2109751.4 37.7732482408903 -122.426729425627 (37.7732482408903, -122.426729425627)
78915 114478 2 189 45 HOFF ST 1 1 1 3       3x3   6006591.0 2106401.0 37.7641484227608 -122.420388955837 (37.7641484227608, -122.420388955837)
78978 87642 1 20 1002X Laguna St 1 1 1 3           6004813.344433 2112300.6630169996 37.7802471321724 -122.42695756751101 (37.7802471321724, -122.426957567511)
79036 116326 2 54 1400X Potrero Ave 6 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
79426 116125 2 43 2500X Keith St 1 1 1 3           6014198.52795 2092093.45262 37.7252886606488 -122.39307534923799 (37.7252886606488, -122.393075349238)
79670 100784 1 17 2101 Washington St 6 1 1 3           6004647.8 2116722.2 37.7923782050701 -122.42784540593 (37.7923782050701, -122.42784540593)
80868 116284 2 54 700X Greenwich St 11 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
80880 116148 2 17 3800X 20th St 9 1 1 3           6004661.9257 2104258.88373 37.758157784571296 -122.426908497787 (37.7581577845713, -122.426908497787)
81024 116130 2 17 1601X Armstrong Ave 2 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
81037 101512 3 15 240X DRUMM ST 3 1 1 3       3x3   6013870.0 2117910.0 37.796157009088 -122.396019403228 (37.796157009088, -122.396019403228)
81330 116229 2 127 1699 Steiner St 4 1 1 3           6002584.4 2114045.3 37.7849111787577 -122.434793299622 (37.7849111787577, -122.434793299622)
81721 112650 2 21 3100X 26TH ST 4 1 1 3       3x3   6008747.0 2100981.0 37.749387590387 -122.41254878695 (37.749387590387, -122.41254878695)
81886 116302 2 127 1550 Scott St 1 1 1 3           6002138.3 2113859.7 37.784376231358706 -122.436323371803 (37.7843762313587, -122.436323371803)
81945 98430 3 15 1401X Steiner St 5 1 1 3       3x3   6002724.9 2113044.1 37.782170112299795 -122.434235614198 (37.7821701122998, -122.434235614198)
82149 98423 3 44 1501X Steiner St 7 1 1 3   01/28/2013 12:00:00 AM   3x3 Permit Number 768629 6002677.2 2113386.1 37.7831064505465 -122.43442509431299 (37.7831064505465, -122.434425094313)
82559 116276 2 54 700X Greenwich St 3 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
82737 106281 2 474 399X Elliot St 2 14 1 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
83060 116290 2 127 1901X Powell St 6 1 1 3           6009504.70132 2120333.4249299997 37.802567299543206 -122.41129555893 (37.8025672995432, -122.41129555893)
83356 98424 3 15 1501X Steiner St 8 1 1 3       3x3   6002677.2 2113386.1 37.7831064505465 -122.43442509431299 (37.7831064505465, -122.434425094313)
83617 103231 3 104 1600X 29th Ave 22 5 1 3   03/26/2013 12:00:00 AM   3x4 Permit Number 770085 5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
84099 116291 2 127 1901X Powell St 7 1 1 3           6009504.70132 2120333.4249299997 37.802567299543206 -122.41129555893 (37.8025672995432, -122.41129555893)
84190 113977 2 225 1180 STANYAN ST 2 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
84664 103228 3 104 1600X 29th Ave 16 5 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
84777 116279 2 54 700X Greenwich St 6 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
84841 116134 2 17 1601X Armstrong Ave 6 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
85303 117173 2 17 299x ALMA ST 10 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
86577 115542 2 145 780 DOUGLASS ST 2 9 1 3       3x3   6001139.0 2101871.0 37.7514014062737 -122.43892114779301 (37.7514014062737, -122.438921147793)
87182 103211 3 15 1600X 29th Ave 13 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
87206 103229 3 104 1600X 29th Ave 18 5 1 3   03/26/2013 12:00:00 AM   3x4 Permit Number 770085 5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
87516 111787 2 37 55X SHERMAN ST 4 1 1 3       3x3   6010857.0 2110997.0 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357)
87523 116144 2 17 3800X 20th St 5 1 1 3           6004661.9257 2104258.88373 37.758157784571296 -122.426908497787 (37.7581577845713, -122.426908497787)
88078 116321 2 54 1400X Potrero Ave 1 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
88387 116329 2 54 1400X Potrero Ave 9 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
88440 116286 2 127 1901X Powell St 2 1 1 3           6009504.70132 2120333.4249299997 37.802567299543206 -122.41129555893 (37.8025672995432, -122.41129555893)
88615 100034 3 18 1199@Washington Mason St 2 1 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869)
88695 104451 5 5 2490X Folsom St 6 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
88981 117174 2 17 299x ALMA ST 11 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
89080 106004 2 103 695X CAMPBELL AVE   19 1 3           6009136.9 2088912.4 37.716271678506 -122.41034847162202 (37.716271678506, -122.410348471622)
89720 116304 2 127 1550 Scott St 3 1 1 3           6002138.3 2113859.7 37.784376231358706 -122.436323371803 (37.7843762313587, -122.436323371803)
90017 103176 3 15 2201 Lawton St 2 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
90489 113805 2 103 990X OSHAUGHNESSY BLVD 2 7 1 3       3x30   6000025.0 2096199.0 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687)
90745 98428 3 15 1401X Steiner St 3 1 1 3       3x3   6002724.9 2113044.1 37.782170112299795 -122.434235614198 (37.7821701122998, -122.434235614198)
90870 116303 2 127 1550 Scott St 2 1 1 3           6002138.3 2113859.7 37.784376231358706 -122.436323371803 (37.7843762313587, -122.436323371803)
91125 116146 2 17 3800X 20th St 7 1 1 3           6004661.9257 2104258.88373 37.758157784571296 -122.426908497787 (37.7581577845713, -122.426908497787)
91482 116332 2 54 1400X Potrero Ave 12 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
91746 87641 1 101 1002X Laguna St 4 1 1 3           6004813.344433 2112300.6630169996 37.7802471321724 -122.42695756751101 (37.7802471321724, -122.426957567511)
91930 113799 2 5 695x SHOTWELL ST 3 1 1 3       4x4   6008062.0 2103972.0 37.757561731467 -122.415129229314 (37.757561731467, -122.415129229314)
92470 116283 2 54 700X Greenwich St 10 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
92516 101511 3 15 240X DRUMM ST 1 1 1 3       3x3   6013870.0 2117910.0 37.796157009088 -122.396019403228 (37.796157009088, -122.396019403228)
92526 98417 3 15 1501X Steiner St 1 1 1 3       3x3 Permit Number 768629 6002677.2 2113386.1 37.7831064505465 -122.43442509431299 (37.7831064505465, -122.434425094313)
92543 116287 2 127 1901X Powell St 3 1 1 3           6009504.70132 2120333.4249299997 37.802567299543206 -122.41129555893 (37.8025672995432, -122.41129555893)
92561 104449 5 5 2490X Folsom St 4 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
92761 103201 3 15 1601X 28th Ave 16 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
92983 116128 2 43 2500X Keith St 4 1 1 3           6014198.52795 2092093.45262 37.7252886606488 -122.39307534923799 (37.7252886606488, -122.393075349238)
93124 116328 2 54 1400X Potrero Ave 8 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
93581 116133 2 17 1601X Armstrong Ave 5 1 1 3           6014258.08027 2092570.23406 37.726601114752604 -122.392902822978 (37.7266011147526, -122.392902822978)
93863 94301 6 101 1150X Fillmore St 5 5 1 3           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
94078 116333 2 54 1400X Potrero Ave 13 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
94106 116320 2 54 1451 Hampshire St 3 1 1 3           6010547.7 2101110.8 37.749844886729996 -122.406331036849 (37.74984488673, -122.406331036849)
94182 117166 2 35 299x ALMA ST 3 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
94547 116285 2 127 1901X Powell St 1 1 1 3           6009504.70132 2120333.4249299997 37.802567299543206 -122.41129555893 (37.8025672995432, -122.41129555893)
95183 116324 2 54 1400X Potrero Ave 4 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
95184 103170 3 15 2200X Moraga St 7 1 1 3       3x4   5987326.2 2104050.0 37.7565887850833 -122.48684681689801 (37.7565887850833, -122.486846816898)
95247 103226 3 104 1600X 29th Ave 12 5 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
95392 37236 3 20 2200X Moraga St 8 5 1 3   03/26/2013 12:00:00 AM     Permit Number 770085 5987459.55498562 2104367.82715752 37.757469225946295 -122.48640896705601 (37.7574692259463, -122.486408967056)
95834 106280 2 474 399X Elliot St 1 14 1 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
95903 97893 1 12 401x Russia Ave 2 1 1 3   03/02/2010 12:00:00 AM   3x3 Permit Number 55034 6002347.5 2090445.5 37.72009829646 -122.433925417029 (37.72009829646, -122.433925417029)
96429 116143 2 17 3800X 20th St 4 1 1 3           6004661.9257 2104258.88373 37.758157784571296 -122.426908497787 (37.7581577845713, -122.426908497787)
96944 116147 2 17 3800X 20th St 8 1 1 3           6004661.9257 2104258.88373 37.758157784571296 -122.426908497787 (37.7581577845713, -122.426908497787)
97474 112653 2 21 3100X 26TH ST 7 1 1 3       3x3   6008747.0 2100981.0 37.749387590387 -122.41254878695 (37.749387590387, -122.41254878695)
98178 116335 2 54 1400X Potrero Ave 15 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
98214 113797 2 5 695x SHOTWELL ST 1 1 1 3       4x4   6008062.0 2103972.0 37.757561731467 -122.415129229314 (37.757561731467, -122.415129229314)
98380 113980 2 225 1180 STANYAN ST 5 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
98385 115545 2 145 780 DOUGLASS ST 5 9 1 3       3x3   6001139.0 2101871.0 37.7514014062737 -122.43892114779301 (37.7514014062737, -122.438921147793)
98431 116227 2 127 1699 Steiner St 2 1 1 3           6002584.4 2114045.3 37.7849111787577 -122.434793299622 (37.7849111787577, -122.434793299622)
98449 103215 3 15 1600X 29th Ave 21 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
98464 116142 2 17 3800X 20th St 3 1 1 3           6004661.9257 2104258.88373 37.758157784571296 -122.426908497787 (37.7581577845713, -122.426908497787)
98757 116282 2 54 700X Greenwich St 9 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
98945 116341 2 54 201X Bright St 2 1 1 3           5993755.0695 2088847.02637 37.715217913096104 -122.463510368547 (37.7152179130961, -122.463510368547)
99142 116319 2 54 1451 Hampshire St 2 1 1 3           6010547.7 2101110.8 37.749844886729996 -122.406331036849 (37.74984488673, -122.406331036849)
99261 98426 3 15 1501X Steiner St 10 1 1 3       3x3 Permit Number 768629 6002677.2 2113386.1 37.7831064505465 -122.43442509431299 (37.7831064505465, -122.434425094313)
99569 98434 3 44 1401X Steiner St 9 1 1 3   01/28/2013 12:00:00 AM   3x3 Permit Number 768629 6002724.9 2113044.1 37.782170112299795 -122.434235614198 (37.7821701122998, -122.434235614198)
100067 116145 2 17 3800X 20th St 6 1 1 3           6004661.9257 2104258.88373 37.758157784571296 -122.426908497787 (37.7581577845713, -122.426908497787)
100218 117167 2 35 299x ALMA ST 4 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
100230 116306 2 127 1550 Scott St 5 1 1 3           6002138.3 2113859.7 37.784376231358706 -122.436323371803 (37.7843762313587, -122.436323371803)
100922 104446 5 18 2490X Folsom St 1 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
101069 111796 2 43 55X SHERMAN ST 13 1 1 3       3x3   6010857.0 2110997.0 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357)
Powered by Datasette · Query took 5.246ms · Data source: data.sfgov.org