sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
27576 103186 3 15 1601X 28th Ave 10 1 1 3     0 3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
30617 103185 3 15 1601X 28th Ave 8 1 1 3     0 3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
71729 103221 3 104 1600X 29th Ave 6 5 1 3   03/26/2013 12:00:00 AM 11 3x4 Permit Number 770085 5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
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)
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)
84664 103228 3 104 1600X 29th Ave 16 5 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
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)
90017 103176 3 15 2201 Lawton St 2 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
92761 103201 3 15 1601X 28th Ave 16 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
95247 103226 3 104 1600X 29th Ave 12 5 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
98449 103215 3 15 1600X 29th Ave 21 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
104711 103230 3 104 1600X 29th Ave 20 5 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
107221 103214 3 15 1600X 29th Ave 19 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
107523 103198 3 104 1601X 28th Ave 17 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)
108101 103227 3 104 1600X 29th Ave 14 5 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
108349 103203 3 15 1601X 28th Ave 18 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
109331 103194 3 104 1601X 28th Ave 13 5 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
110740 103217 3 15 1600X 29th Ave 24 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
111672 103212 3 15 1600X 29th Ave 15 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
113064 103225 3 104 1600X 29th Ave 11 5 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
118881 103195 3 104 1601X 28th Ave 14 5 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
119345 103179 3 15 2201 Lawton St 5 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
124567 103199 3 104 1601X 28th Ave 19 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)
124904 103177 3 15 2201 Lawton St 3 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
126040 103213 3 15 1600X 29th Ave 17 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
140247 103204 3 15 1601X 28th Ave 20 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
140434 103232 3 104 1600X 29th Ave 23 5 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
142111 103178 3 15 2201 Lawton St 4 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
142495 103187 3 15 1601X 28th Ave 12 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
142733 103174 3 15 2201 Lawton St 1 1 1 3       3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
146286 103200 3 104 1601X 28th Ave 21 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)
182999 103192 3 104 1601X 28th Ave 9 5 1 3     0 3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
122322 105909 2 5 1864X 14TH AVE 1 3 1 3     14     5991829.0 2102804.0 37.7534290869332 -122.47118388851999 (37.7534290869332, -122.47118388852)
21616 25457 1 37 100 Randolph St 2 1 1 3   12/10/1997 12:00:00 AM 6 3X3   5993681.7949 2088543.8714 37.7143812997511 -122.463741645146 (37.7143812997511, -122.463741645146)
21638 18577 1 37 100 Randolph St 1 1 1 3   10/12/1998 12:00:00 AM 6 3X3   5993712.2633 2088544.8235 37.7143856696584 -122.46363640417201 (37.7143856696584, -122.463636404172)
98945 116341 2 54 201X Bright St 2 1 1 3           5993755.0695 2088847.02637 37.715217913096104 -122.463510368547 (37.7152179130961, -122.463510368547)
119252 116340 2 54 201X Bright St 1 1 1 3           5993755.0695 2088847.02637 37.715217913096104 -122.463510368547 (37.7152179130961, -122.463510368547)
67560 117168 2 35 299x ALMA ST 5 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
78486 117170 2 35 299x ALMA ST 7 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
84190 113977 2 225 1180 STANYAN ST 2 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
85303 117173 2 17 299x ALMA ST 10 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
88981 117174 2 17 299x ALMA ST 11 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
94182 117166 2 35 299x ALMA ST 3 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
98380 113980 2 225 1180 STANYAN ST 5 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
100218 117167 2 35 299x ALMA ST 4 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
111214 117171 2 35 299x ALMA ST 8 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
112111 117165 2 225 299x ALMA ST 2 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
115442 117169 2 35 299x ALMA ST 6 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
120849 113976 2 225 1180 STANYAN ST 1 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
125476 117172 2 17 299x ALMA ST 9 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
128979 113978 2 225 1180 STANYAN ST 3 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
142159 113981 2 225 1180 STANYAN ST 6 1 1 3       3x3   5997407.0 2106053.0 37.7626710894654 -122.45212848427799 (37.7626710894654, -122.452128484278)
94686 25454 1 12 595X Geneva Ave 5 1 1 3   06/28/1996 12:00:00 AM 12 2X3   5999113.4172 2090550.32647 37.720202063668 -122.445112038783 (37.720202063668, -122.445112038783)
78609 26824 1 37 2000X San Jose Ave 17 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
79265 26306 1 37 2000X San Jose Ave 9 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
79960 26313 1 37 2000X San Jose Ave 16 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
80056 26299 1 37 2000X San Jose Ave 2 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
81506 26304 1 37 2000X San Jose Ave 7 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
85891 26298 1 37 2000X San Jose Ave 1 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
92206 26303 1 37 2000X San Jose Ave 6 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
95883 26312 1 37 2000X San Jose Ave 15 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
96826 26300 1 37 2000X San Jose Ave 3 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
99814 26311 1 37 2000X San Jose Ave 14 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
106413 26302 1 37 2000X San Jose Ave 5 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
107389 26297 1 37 2000X San Jose Ave 19 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
111375 26308 1 37 2000X San Jose Ave 11 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
114344 26310 1 37 2000X San Jose Ave 13 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
115681 26309 1 37 2000X San Jose Ave 12 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
122107 26305 1 37 2000X San Jose Ave 8 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
141627 26301 1 37 2000X San Jose Ave 4 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
146124 26307 1 37 2000X San Jose Ave 10 1 1 3   07/06/1998 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
90489 113805 2 103 990X OSHAUGHNESSY BLVD 2 7 1 3       3x30   6000025.0 2096199.0 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687)
109652 113804 2 103 990X OSHAUGHNESSY BLVD 1 7 1 3       3x30   6000025.0 2096199.0 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687)
1975 238619 2 15 4302 24th St 5 1 1 3     23 Width 4ft   6001066.93276 2101745.60422 37.7510529990026 -122.43916137771099 (37.7510529990026, -122.439161377711)
1964 238618 2 15 4302 24th St 4 1 1 3     14 Width 4ft   6001078.53558 2101746.02342 37.751054810249 -122.439121284114 (37.751054810249, -122.439121284114)
85540 115541 2 145 780 DOUGLASS ST 1 9 1 3     24 3x3   6001139.0 2101871.0 37.7514014062737 -122.43892114779301 (37.7514014062737, -122.438921147793)
86577 115542 2 145 780 DOUGLASS ST 2 9 1 3       3x3   6001139.0 2101871.0 37.7514014062737 -122.43892114779301 (37.7514014062737, -122.438921147793)
98385 115545 2 145 780 DOUGLASS ST 5 9 1 3       3x3   6001139.0 2101871.0 37.7514014062737 -122.43892114779301 (37.7514014062737, -122.438921147793)
105415 115546 2 145 780 DOUGLASS ST 6 9 1 3       3x3   6001139.0 2101871.0 37.7514014062737 -122.43892114779301 (37.7514014062737, -122.438921147793)
107914 115543 2 145 780 DOUGLASS ST 3 9 1 3       3x3   6001139.0 2101871.0 37.7514014062737 -122.43892114779301 (37.7514014062737, -122.438921147793)
141166 115544 2 145 780 DOUGLASS ST 4 9 1 3       3x3   6001139.0 2101871.0 37.7514014062737 -122.43892114779301 (37.7514014062737, -122.438921147793)
146308 115547 2 145 780 DOUGLASS ST 7 9 1 3       3x3   6001139.0 2101871.0 37.7514014062737 -122.43892114779301 (37.7514014062737, -122.438921147793)
1974 238616 2 15 4302 24th St 2 1 1 3     23 Width 4ft   6001186.94921 2101750.3744 37.7510729252903 -122.43874669133301 (37.7510729252903, -122.438746691333)
79290 102162 2 15 4300X 24th St 5 1 1 3     36 5x5   6001255.1 2101750.3 37.751076597898 -122.438511014093 (37.751076597898, -122.438511014093)
80331 102161 2 15 4300X 24th St 4 1 1 3     24 5x5   6001255.1 2101750.3 37.751076597898 -122.438511014093 (37.751076597898, -122.438511014093)
82310 102159 2 15 4300X 24th St 2 1 1 3     34 6x6   6001255.1 2101750.3 37.751076597898 -122.438511014093 (37.751076597898, -122.438511014093)
107282 100095 1 17 4372 26th St 1 1 1 3 3 07/03/2012 12:00:00 AM   3x3 Permit Number 769070 6001507.0 2100613.7 37.747970090970504 -122.43755853273001 (37.7479700909705, -122.43755853273)
80328 26645 1 316 2199X Post St 8 1 1 3   06/22/1998 12:00:00 AM 6 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313)
81892 26644 1 316 2199X Post St 7 1 1 3   06/22/1998 12:00:00 AM 3 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313)
81947 26643 1 316 2199X Post St 6 1 1 3   06/22/1998 12:00:00 AM 3 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313)
107462 24923 1 316 2199X Post St 3 1 1 3   02/22/1996 12:00:00 AM 6 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313)
112150 24950 1 44 2199X Post St 5 1 1 3   06/22/1998 12:00:00 AM 3 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313)
113430 24924 1 5 2199X Post St 4 1 1 3     12 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313)
139472 26647 1 316 2199X Post St 10 1 1 3   06/22/1998 12:00:00 AM 6 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313)
143087 24922 1 316 2199X Post St 2 1 1 3   04/05/2003 12:00:00 AM 3 3X3   6001667.079621499 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313)
80827 8522 1 15 1901 Geary Blvd 4 1 1 3     24 3X3   6001704.22181 2113592.17339 37.7836169980675 -122.43780596128799 (37.7836169980675, -122.437805961288)
84016 8521 1 127 1901 Geary Blvd 3 1 1 3   01/30/2005 12:00:00 AM 3 3X3   6001704.22181 2113592.17339 37.7836169980675 -122.43780596128799 (37.7836169980675, -122.437805961288)
87286 8528 1 15 1901 Geary Blvd 11 1 1 3     30 3X3   6001704.22181 2113592.17339 37.7836169980675 -122.43780596128799 (37.7836169980675, -122.437805961288)
94964 8519 1 15 1901 Geary Blvd 1 1 1 3     24 3X3   6001704.22181 2113592.17339 37.7836169980675 -122.43780596128799 (37.7836169980675, -122.437805961288)
129090 8524 1 15 1901 Geary Blvd 6 1 1 3     18 3X3   6001704.22181 2113592.17339 37.7836169980675 -122.43780596128799 (37.7836169980675, -122.437805961288)
Powered by Datasette · Query took 11.801ms · Data source: data.sfgov.org