sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1389 251532 1 54 2100X 20th St 4 1 2 1   05/15/2017 12:00:00 AM 3 4x11            
1391 251531 1 54 2100X 20th St 2 1 2 1   05/15/2017 12:00:00 AM 3 4x11            
1824 251724 1 54 1630 Clay St 1 1 1 1   06/06/2017 12:00:00 AM 3 3x3   6006933.88533 2116748.92044 37.792580631742204 -122.419937373279 (37.7925806317422, -122.419937373279)
2270 253008 1 54 1201 Tennessee St 1 1 2 1   07/10/2017 12:00:00 AM 3 11x477   6015595.17459 2103370.35297 37.756330202721 -122.389034232236 (37.756330202721, -122.389034232236)
2865 253261 1 54 339 18th Ave 1 1 1 1       3x3   5990256.0 2113097.0 37.78159976365421 -122.477375802178 (37.7815997636542, -122.477375802178)
2881 253260 1 54 734 09th Ave 1 1 1 1       3x3   5993234.0 2110465.0 37.7745453462497 -122.46688203122801 (37.7745453462497, -122.466882031228)
2900 70091 1 54 752 24th Ave 1 1 1 1 1 12/12/1992 12:00:00 AM 6 3x3   5988512.5089 2110855.81451 37.7753447787774 -122.483243045223 (37.7753447787774, -122.483243045223)
3276 149033 1 54 3916 Sacramento St 1 1 1 1   08/28/2017 12:00:00 AM 3 5.5x12   5996085.364440001 2114918.02173 37.7869363183091 -122.45734088598302 (37.7869363183091, -122.457340885983)
3639 253517 1 54 559 24th Ave 2 5 2 1   09/15/2017 12:00:00 AM 3 2x4.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3643 253515 1 54 559 24th Ave 1 1 2 1   09/15/2017 12:00:00 AM 3 7x9.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3650 253518 1 54 559 24th Ave 3 5 2 1   09/15/2017 12:00:00 AM 3 2x1   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3660 253516 1 54 559 24th Ave 1 5 2 1   09/15/2017 12:00:00 AM 3 2x2   5988392.0 2112177.0 37.778965370493495 -122.483756799769 (37.7789653704935, -122.483756799769)
4723 253676 1 54 2975 Van Ness Ave 6 5 2 1   10/24/2017 12:00:00 AM 3 3.2x3.75   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
4726 253675 1 54 2975 Van Ness Ave 1 5 2 1   10/24/2017 12:00:00 AM 3 3.2x14.2   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
5211 253829 1 54 869 Ellis St 1 1 1 1 4     3x3   6006713.1749 2113568.2957099997 37.7838349840749 -122.420475171434 (37.7838349840749, -122.420475171434)
5216 253831 1 54 651X Polk St 5 1 1 1 4     3x3            
5222 253825 1 54 725 Ellis St 1 1 1 1 4     3x3   6007393.727109999 2113660.9435900003 37.784127700976896 -122.418127279043 (37.7841277009769, -122.418127279043)
5224 253827 1 54 825 Polk St 1 1 1 1 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5226 253832 1 54 665 Eddy St 1 1 1 1 4     3x3   6007254.7956 2113297.42725 37.783121752773 -122.41858214693501 (37.783121752773, -122.418582146935)
5228 253828 1 54 825 Polk St 2 1 1 1 4     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967)
5229 253834 1 54 747 Eddy St 1 1 1 1 4     3x3   6006860.78535 2113242.76542 37.7829494746502 -122.419941385136 (37.7829494746502, -122.419941385136)
5230 253826 1 54 701 Ellis St 1 1 1 1 4     3x3            
5236 253833 1 54 607 Eddy St 2 1 1 1 4     3x3            
5239 253830 1 54 651X Polk St 3 1 1 1 4     3x3            
10092 173852 1 54 450 Toland St 7 1 2 1   01/27/2017 12:00:00 AM 3 8.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10093 173849 1 54 450 Toland St 4 1 2 1   01/27/2017 12:00:00 AM 3 17.6x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10096 173850 1 54 450 Toland St 5 1 2 1   01/27/2017 12:00:00 AM 3 13.9x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10097 173851 1 54 450 Toland St 6 1 2 1   01/27/2017 12:00:00 AM 3 27.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10098 173848 1 54 450 Toland St 3 1 2 1   01/27/2017 12:00:00 AM 3 19.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10101 173846 1 54 450 Toland St 1 1 2 1   01/27/2017 12:00:00 AM 3 15x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10104 173847 1 54 450 Toland St 2 1 2 1   01/27/2017 12:00:00 AM 3 11.85x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10106 173853 1 54 450 Toland St 8 1 2 1   01/27/2017 12:00:00 AM 3 26.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10128 173868 1 54 808 Capitol Ave 2 5 1 1   01/31/2017 12:00:00 AM 3     5995075.959430001 2089664.9067799998 37.717539636984206 -122.45900401383601 (37.7175396369842, -122.459004013836)
10139 173867 1 54 808 Capitol Ave 1 5 1 1   01/31/2017 12:00:00 AM 3     5995075.959430001 2089664.9067799998 37.717539636984206 -122.45900401383601 (37.7175396369842, -122.459004013836)
20483 109769 1 54 2502X Bush St 2 5 2 1       1.5x12.75   6001313.62368 2114572.17699 37.786285618589204 -122.43922754338101 (37.7862856185892, -122.439227543381)
42994 109343 1 54 3211 Baker St 2 9 2 1   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
49594 112605 1 54 1534 Hayes St 1 1 2 1   08/10/2015 12:00:00 AM   5.6x12   6000465.0 2110329.2 37.7745871625182 -122.441858914128 (37.7745871625182, -122.441858914128)
61493 105361 1 54 850 Guerrero St 3 5 1 1       12x2.75   6005583.5 2103975.8 37.7574325683666 -122.423701164602 (37.7574325683666, -122.423701164602)
77940 114567 1 54 1930 Taylor St 1 1 1 1 1 11/24/2015 12:00:00 AM   3x3   6008702.7 2119505.5 37.8002490116896 -122.414012289596 (37.8002490116896, -122.414012289596)
78123 104843 1 54 1320 21st Ave   1 1 1           5989622.0 2106334.7 37.7629955389606 -122.47907431964701 (37.7629955389606, -122.479074319647)
81163 104152 1 54 525X Church St 2 5 2 4 4     2x68   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
81298 104856 1 54 739 27th St   1 2 1   02/12/2015 12:00:00 AM 3     6001722.3 2099959.7 37.746186600460604 -122.43676722664301 (37.7461866004606, -122.436767226643)
81722 104155 1 54 525X Church St 3 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
83041 109366 1 54 1205 Filbert St 3 5 2 1 1 02/11/2015 12:00:00 AM 3 3.125x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
83497 105359 1 54 850 Guerrero St 1 5 1 1       12x2.75   6005583.5 2103975.8 37.7574325683666 -122.423701164602 (37.7574325683666, -122.423701164602)
83697 108792 1 54 201-299 University St 4 1 1 1 1         6008053.41125 2093004.09823 37.727445818429295 -122.414382893832 (37.7274458184293, -122.414382893832)
85159 108793 1 54 201-299 University St 5 1 1 1 1         6008053.41125 2093004.09823 37.727445818429295 -122.414382893832 (37.7274458184293, -122.414382893832)
85310 105043 1 54 2660 Harrison St 5 5 2 1       2x4   6008902.0 2102968.0 37.754852144595795 -122.41215320319701 (37.7548521445958, -122.412153203197)
85364 115892 1 54 1900X Kirkham St 2 1 1 1   03/02/2016 12:00:00 AM 3     5988841.66469 2105121.6083400003 37.75961937033 -122.48168434385401 (37.75961937033, -122.481684343854)
85839 105039 1 54 2660 Harrison St 1 5 2 1       2x7   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586)
86957 109262 1 54 3338X Ortega St 3 1 1 1 1     3x3   5983663.54917 2102222.75157 37.7513574508855 -122.499378353213 (37.7513574508855, -122.499378353213)
87925 104864 1 54 45 Hoffman Ave   1 2 1           6000629.3 2102650.0 37.7535113392088 -122.440739618385 (37.7535113392088, -122.440739618385)
88689 109762 1 54 1801 Scott St 1 5 2 1       1.5x6.5   6001511.7 2114646.3 37.786500410729104 -122.43854756475099 (37.7865004107291, -122.438547564751)
88984 109756 1 54 601 Steiner St 3 5 2 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
89307 105925 1 54 4166 20th St   1 1 1       3X3   6002608.6 2104160.0 37.7577699584222 -122.434002709079 (37.7577699584222, -122.434002709079)
91070 105360 1 54 850 Guerrero St 2 5 1 1       12x2.75   6005583.5 2103975.8 37.7574325683666 -122.423701164602 (37.7574325683666, -122.423701164602)
91154 109365 1 54 1205 Filbert St 2 1 2 1 1 02/11/2015 12:00:00 AM 3 4.5x16   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
92536 114785 1 54 2459 Post St 1 1 1 1   12/09/2015 12:00:00 AM       6000398.9 2113706.0 37.7838552262656 -122.44233003645701 (37.7838552262656, -122.442330036457)
92619 115024 1 54 2500 42nd Ave 1 1 1 1   01/06/2016 12:00:00 AM       5983385.7 2098079.0 37.739963544351504 -122.500032889381 (37.7399635443515, -122.500032889381)
92935 104156 1 54 525X Church St 4 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
93962 115298 1 54 84 Forest Side Ave 1 1 1 1           5992506.3 2098571.2 37.7418460572185 -122.468533715231 (37.7418460572185, -122.468533715231)
94853 104637 1 54 217 Montcalm St   7 2 1       16x16   6010036.0 2099691.0 37.7459177905176 -122.40800041337499 (37.7459177905176, -122.408000413375)
95495 104151 1 54 525X Church St 1 5 2 4 4     2x58   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
95556 104158 1 54 525X Church St 6 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
96077 104157 1 54 525X Church St 5 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
96541 110246 1 54 1706 28th Ave 1 1 2 1   04/01/2015 12:00:00 AM 3 1.5x12   5987540.7 2103643.4 37.755484875136204 -122.486075162345 (37.7554848751362, -122.486075162345)
97307 109345 1 54 3211 Baker St 4 9 2 1   02/11/2015 12:00:00 AM 3 8.75x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
97786 109767 1 54 1801 Scott St 2 5 2 1       11.75x1.5+3.6x3.6   6001511.7 2114646.3 37.786500410729104 -122.43854756475099 (37.7865004107291, -122.438547564751)
98032 114972 1 54 1431 Grove St 1 1 1 1   12/28/2015 12:00:00 AM   3x3   6000962.5 2110659.8 37.775523242518794 -122.440161680014 (37.7755232425188, -122.440161680014)
98437 113995 1 54 3221 Washington St 1 1 2 1   10/27/2015 12:00:00 AM   39x3   5999265.7 2115942.6 37.789931692456996 -122.44641142836599 (37.789931692457, -122.446411428366)
98575 115891 1 54 1900X Kirkham St 1 1 1 1   03/02/2016 12:00:00 AM 3     5988841.66469 2105121.6083400003 37.75961937033 -122.48168434385401 (37.75961937033, -122.481684343854)
99206 115258 1 54 2150 Jackson St   24 2 1   01/21/2016 12:00:00 AM   6x12   6003858.0 2116995.5 37.7930839063862 -122.430597643601 (37.7930839063862, -122.430597643601)
99253 117318 1 54 1935 09th Ave 1 1 1 1           5993426.4 2102307.1 37.7521569948021 -122.465623688401 (37.7521569948021, -122.465623688401)
99464 109344 1 54 3211 Baker St 3 9 2 1   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
100579 117313 1 54 883 47th Ave 1 1 1 1           5981355.6 2109736.3 37.7718518197324 -122.50791691513099 (37.7718518197324, -122.507916915131)
101115 109364 1 54 1205 Filbert St 1 1 2 1 1 02/11/2015 12:00:00 AM 3 4.5x6   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
101195 115894 1 54 1900X Kirkham St 4 1 1 1   03/02/2016 12:00:00 AM 3     5988841.66469 2105121.6083400003 37.75961937033 -122.48168434385401 (37.75961937033, -122.481684343854)
101235 109535 1 54 1234 Filbert St 3 5 2 1 1 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677)
102661 117259 1 54 670 Eddy St 1 5 2 1       3x3   6007197.5 2113350.2 37.7832634280904 -122.418784110751 (37.7832634280904, -122.418784110751)
105108 104859 1 54 650 Fillmore St   1 2 1           6003597.7 2110555.4 37.775386259915 -122.43103844044701 (37.775386259915, -122.431038440447)
105387 117319 1 54 1935 09th Ave 1 1 1 1           5993426.4 2102307.1 37.7521569948021 -122.465623688401 (37.7521569948021, -122.465623688401)
105398 117608 1 54 450 Hayes St 1 1 2 1   06/29/2016 12:00:00 AM 3     6005708.4 2111040.6 37.776837876057 -122.423771533631 (37.776837876057, -122.423771533631)
106819 105042 1 54 2660 Harrison St 4 5 2 1       2x10   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586)
106864 109768 1 54 2502X Bush St 1 5 2 1       1.5x13   6001313.62368 2114572.17699 37.786285618589204 -122.43922754338101 (37.7862856185892, -122.439227543381)
111744 104636 1 54 217 Montcalm St   7 2 1       16x16   6010036.0 2099691.0 37.7459177905176 -122.40800041337499 (37.7459177905176, -122.408000413375)
111918 109831 1 54 146 Staples Ave 1 5 2 1       12x15.3   5999109.5 2093827.3 37.7291996500545 -122.445361075989 (37.7291996500545, -122.445361075989)
112218 109536 1 54 1234 Filbert St 4 5 2 1 1 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677)
112497 104858 1 54 4205 24th St   5 2 1           6001816.0 2101720.7 37.7510272133613 -122.43656924920201 (37.7510272133613, -122.436569249202)
113500 109261 1 54 3338X Ortega St 2 1 1 1 1     3x3   5983663.54917 2102222.75157 37.7513574508855 -122.499378353213 (37.7513574508855, -122.499378353213)
113603 104154 1 54 525X Church St 2 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
114617 105046 1 54 268 Capitol Ave   1 1 1           5995102.1 2087921.7 37.7127547049329 -122.458787524461 (37.7127547049329, -122.458787524461)
114741 104860 1 54 283 Randall St   1 2 1           6003774.7 2097827.3 37.7404479510811 -122.429518236565 (37.7404479510811, -122.429518236565)
114892 115259 1 54 2130 Jackson St   1 2 1   01/21/2016 12:00:00 AM   6x12   6003918.8 2117004.0 37.7931106894063 -122.43038787884501 (37.7931106894063, -122.430387878845)
116050 111759 1 54 1235 47th Ave 2 2 2 1   06/23/2015 12:00:00 AM 3 6x4   5981472.7 2106671.7 37.7634442160317 -122.50728446314301 (37.7634442160317, -122.507284463143)
116207 109368 1 54 1205 Filbert St 5 1 2 1 1 02/11/2015 12:00:00 AM 3 3x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
117141 115013 1 54 2493 Francisco St 1 1 1 1   01/05/2016 12:00:00 AM       5999602.09209 2119817.77431 37.8005911003042 -122.44552631681499 (37.8005911003042, -122.445526316815)
117306 104857 1 54 2555 46th Ave   1 2 1           5982069.8 2097707.6 37.7388664658919 -122.504555139124 (37.7388664658919, -122.504555139124)
118010 109755 1 54 601 Steiner St 2 5 2 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
118218 104635 1 54 217 Montcalm St   7 2 1       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
119022 104960 1 54 2895 San Bruno Ave   1 1 2           6011715.1 2091289.8 37.7229437265236 -122.401603910944 (37.7229437265236, -122.401603910944)
121197 109754 1 54 601 Steiner St 1 5 2 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
Powered by Datasette · Query took 82.252ms · Data source: data.sfgov.org