sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
107894 111381 2 3 301x OCEAN AVE 3 5 1 10 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
121695 111379 2 3 301x OCEAN AVE 1 5 1 10 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
86120 114712 1 161 601X Somerset St 1 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
92714 114713 1 161 601X Somerset St 2 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
97865 114715 1 161 601X Somerset St 4 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
105879 114717 1 161 601X Somerset St 6 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
110071 114718 1 161 601X Somerset St 7 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
118222 114719 1 161 601X Somerset St 8 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
125441 114716 1 161 601X Somerset St 5 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
143907 114714 1 161 601X Somerset St 3 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
12084 43317 1 18 263 Athens St 2 5 1 1   07/10/2008 12:00:00 AM 3 3x3 Permit Number 51344 6004450.31399 2091734.8767 37.7237577510972 -122.42674847077299 (37.7237577510972, -122.426748470773)
100393 106237 2 17 607 BRUSSELS ST   5 1 1           6010922.6 2091903.6 37.724584840413996 -122.404386617586 (37.724584840414, -122.404386617586)
1720 251666 2 98 76 Denslowe Dr 1 5 1 1       3x3   5990680.0 2091936.0 37.723521814492294 -122.474364317808 (37.7235218144923, -122.474364317808)
94753 110144 2 24 129 DE SOTO ST 1 5 1 1     15 10x10   5993256.9 2092045.6 37.723971707155705 -122.465464466989 (37.7239717071557, -122.465464466989)
11634 101011 2 18 83 Santa Ynez Ave 1 5 1 1     10 6x10   6000610.71791 2092062.1351 37.724438494726 -122.44004473049101 (37.724438494726, -122.440044730491)
111568 94421 1 191 5800 03rd St 6 5 1 1   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849.0 2092184.0 37.72551786281171 -122.39428997927601 (37.7255178628117, -122.394289979276)
119473 94422 1 191 5800 03rd St 10 5 1 1   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849.0 2092184.0 37.72551786281171 -122.39428997927601 (37.7255178628117, -122.394289979276)
119718 94425 1 191 5800 03rd St 15 5 1 1   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849.0 2092184.0 37.72551786281171 -122.39428997927601 (37.7255178628117, -122.394289979276)
128487 94424 1 191 5800 03rd St 13 5 1 1   07/29/2010 12:00:00 AM   3x3 Permit Number 53653 6013849.0 2092184.0 37.72551786281171 -122.39428997927601 (37.7255178628117, -122.394289979276)
96017 115668 2 3 193 VALMAR TER 2 5 1 1       3x3   6004786.0 2092223.0 37.72511700396829 -122.425622784245 (37.7251170039683, -122.425622784245)
117455 115667 2 3 193 VALMAR TER 1 5 1 1     15 3x3   6004786.0 2092223.0 37.72511700396829 -122.425622784245 (37.7251170039683, -122.425622784245)
2587 253128 2 139 129 Lisbon St 2 5 1 1       3x3   6003441.615680001 2092643.9430799999 37.726196762848794 -122.430300196616 (37.7261967628488, -122.430300196616)
2589 113754 2 185 129 Lisbon St 1 5 1 1     7 3x3   6003441.615680001 2092643.9430799999 37.726196762848794 -122.430300196616 (37.7261967628488, -122.430300196616)
87899 94618 1 204 1780 Bancroft Ave 3 5 1 1   10/13/2010 12:00:00 AM 9   Permit Number 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726)
90012 94626 1 204 1740 Bancroft Ave 1 5 1 1   10/13/2010 12:00:00 AM 9   permit 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726)
104154 94623 1 204 1728 Bancroft Ave 3 5 1 1   10/13/2010 12:00:00 AM 8   Permit Number 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726)
111591 94625 1 204 1740 Bancroft Ave 2 5 1 1   10/13/2010 12:00:00 AM 9   Permit Number 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726)
121493 94621 1 291 1769X Armstrong Ave 2 5 1 1   10/13/2010 12:00:00 AM 2   Permit Number 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726)
138528 94624 1 204 1728 Bancroft Ave 4 5 1 1   10/13/2010 12:00:00 AM 9   Permit Number 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726)
144156 94620 1 291 1799X Armstrong Ave 3 5 1 1   10/13/2010 12:00:00 AM 4   Permit Number 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726)
144675 94622 1 291 1769 Armstrong Ave 1 5 1 1   10/13/2010 12:00:00 AM 3   Permit Number 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726)
97126 36330 1 264 40@San Ramon Eastwood Dr 1 5 1 1   05/14/1998 12:00:00 AM     Permit Number 39300 5995640.5044713 2092769.77027097 37.7260972907371 -122.457277138944 (37.7260972907371, -122.457277138944)
107750 36332 1 264 40 Eastwood Dr 2 5 1 1   05/14/1998 12:00:00 AM     Permit Number 39300 5995640.5044713 2092769.77027097 37.7260972907371 -122.457277138944 (37.7260972907371, -122.457277138944)
81069 113145 2 5 150 BROADMOOR DR 2 5 1 1       3x3   5990980.0 2092843.0 37.726029586770395 -122.473393404688 (37.7260295867704, -122.473393404688)
131875 95679 1 18 318 Holyoke St 1 5 1 1 1 03/08/2011 12:00:00 AM 3 3x3 Permit Number 767431 6009609.49645 2092896.87368 37.727238694008705 -122.408995916549 (37.7272386940087, -122.408995916549)
89053 102912 2 19 84 Vienna St 1 5 1 1           6004823.0 2092922.0 37.7270383945734 -122.42554460371599 (37.7270383945734, -122.425544603716)
79506 117197 2 60 70 CERRITOS AVE 1 5 1 1       10x6   5992485.0 2092977.0 37.7264845532002 -122.4682005031 (37.7264845532002, -122.4682005031)
109255 92815 1 5 54 Cerritos Ave 1 5 1 1   11/06/2009 12:00:00 AM   3x3 Permit Number 53023 5992579.4 2093009.1 37.72657814349439 -122.46787650278 (37.7265781434944, -122.46787650278)
82391 105357 2 17 171X Dorado Ter 1 5 1 1     18 3x9   5994283.2391 2093059.23457 37.7268140423665 -122.461990071604 (37.7268140423665, -122.461990071604)
107922 105358 2 17 171X Dorado Ter 2 5 1 1     18 3x9   5994283.2391 2093059.23457 37.7268140423665 -122.461990071604 (37.7268140423665, -122.461990071604)
106512 117420 1 17 77 Dorado Ter 1 5 1 1   06/08/2016 12:00:00 AM 3 3x3 Permit Number 777175 5994584.4 2093084.8 37.7269015728644 -122.46095082579399 (37.7269015728644, -122.460950825794)
15294 94619 1 147 1799X Armstrong Ave 1 5 1 1   10/13/2010 12:00:00 AM 2   Permit Number 53777 6013459.79784 2093130.5142700002 37.7280951570487 -122.39570171627199 (37.7280951570487, -122.395701716272)
79054 100424 1 131 200X Stonecrest Dr 1 5 1 1       3x6   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264)
88841 100425 1 131 200X Stonecrest Dr 2 5 1 1       3x6   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264)
53739 107420 2 75 62 Naples St 1 5 1 1     23     6004646.42863 2093164.0318599998 37.727692982045205 -122.426172231973 (37.7276929820452, -122.426172231973)
90228 111728 2 2 45 MANOR DR 1 5 1 1       3x3   5993477.0 2093271.0 37.7273490481485 -122.464792568508 (37.7273490481485, -122.464792568508)
141580 109627 2 190 500 CIRCULAR AVE 1 5 1 1       3x3   5999334.0 2093430.0 37.728121569817 -122.444556419888 (37.728121569817, -122.444556419888)
76012 97025 7 88 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
78805 97021 7 180 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
81165 97014 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
81341 97022 7 195 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
82893 97042 7 322 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
85013 97015 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
87538 97027 7 1 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
88802 97029 7 232 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
90248 97040 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
92954 97034 7 54 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
94845 97016 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
99914 97028 7 112 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
104476 97043 7 322 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
104783 96999 7 20 195A Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
107550 97032 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
125485 97041 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
125835 97004 7 20 195A Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
127473 97045 7 207 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
128784 97039 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
140389 97037 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
140586 97044 7 322 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
140629 97038 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
142369 97035 7 309 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
145213 97026 7 208 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
145522 97036 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
78574 109626 2 190 117 JUDSON AVE   5 1 1       3x12   5999286.5 2093444.4 37.728158398345705 -122.44472166307101 (37.7281583983457, -122.444721663071)
11005 108841 1 58 125 Pioche St 1 5 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 773762 6006499.8637 2093472.98879 37.7286458955893 -122.419786780156 (37.7286458955893, -122.419786780156)
140792 94868 6 31 51 Princeton St   5 1 1 1         6007547.0 2093670.0 37.729245779959 -122.416180705349 (37.729245779959, -122.416180705349)
97089 102584 2 17 22 Gennessee St 2 5 1 1           5997479.4 2093692.8 37.7287371564084 -122.450986747444 (37.7287371564084, -122.450986747444)
105312 122403 2 141 400X Circular Ave 1 5 1 1       3x3   5999746.0 2093731.0 37.7289715465039 -122.443153734972 (37.7289715465039, -122.443153734972)
105446 38572 1 361 1222 Palou Ave 1 5 1 1   03/25/2016 12:00:00 AM 3   Permit Number 777465 6016907.86791438 2093772.63366009 37.730049495784 -122.38382619652398 (37.730049495784, -122.383826196524)
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)
4446 253627 3 5 44 Stonecrest Dr 1 5 1 2       3x3   5991061.0 2093828.0 37.7287388406121 -122.4731851996 (37.7287388406121, -122.4731851996)
77166 77218 3 37 499X Hearst Ave 22 5 1 4 2 05/15/1999 12:00:00 AM 3 6x50   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
82646 42355 3 184 380X Flood Ave 14 5 1 4 2 06/23/2000 12:00:00 AM 9 8x90 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
88765 42344 3 184 380X Flood Ave 3 5 1 4 2 06/23/2000 12:00:00 AM 8 8x45 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
99139 74759 3 5 250 Foerster St 13 5 1 4 2 05/15/1999 12:00:00 AM 30 5x7   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
123438 42348 3 28 380X Flood Ave 7 5 1 4 2 06/23/2000 12:00:00 AM 3 8x45 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
141689 75040 3 17 499X Hearst Ave 2 5 1 4 2 05/15/1999 12:00:00 AM 18 6x20   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
145137 77213 3 184 499X Hearst Ave 20 5 1 4 2 05/15/1999 12:00:00 AM 8 6x50   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
141647 122627 4 12 34 Country Club Dr 1 5 1 1   11/15/2016 12:00:00 AM 3 3x4 Permit Number 775279 5984731.0 2094410.0 37.729968312905505 -122.49511098534401 (37.7299683129055, -122.495110985344)
93623 94948 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
103824 94947 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
114698 94946 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
103209 122566 1 95 378 Sweeny St 1 5 1 1   11/07/2016 12:00:00 AM 3 3x3 Permit Number 779091 6008597.7357 2094518.65936 37.731635041845706 -122.412608176508 (37.7316350418457, -122.412608176508)
92510 88654 1 461 94 Danton St   5 2 1   08/05/2008 12:00:00 AM     Permit Number 51634 6002844.0 2094598.0 37.7315282931893 -122.43250562955099 (37.7315282931893, -122.432505629551)
120372 88656 1 461 94 Danton St   5 2 1   08/05/2008 12:00:00 AM     Permit Number 51634 6002844.0 2094598.0 37.7315282931893 -122.43250562955099 (37.7315282931893, -122.432505629551)
88044 10731 3 39 1100 Hudson Ave 2 5 1 2     12 3X4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
103686 10735 3 39 1100 Hudson Ave 6 5 1 2     12 3x4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
141733 10733 3 76 1100 Hudson Ave 4 5 1 2   01/28/2016 08:19:00 AM 3 3x4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
78294 24522 3 39 1120X Hudson Ave 45 5 1 2     18 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
92247 10776 3 37 1120X Hudson Ave 50 5 1 2   10/26/2011 12:00:00 AM 3 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
95381 10763 3 39 1120X Hudson Ave 21 5 1 2     22 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
103746 10775 3 76 1120X Hudson Ave 48 5 1 2   03/10/2007 12:00:00 AM 3 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
Powered by Datasette · Query took 14.382ms · Data source: data.sfgov.org