sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
839 216492 3 12 800x Bosworth St 5 1 1 2     0 Width 3ft   6001736.84783 2095515.7705400002 37.7339854340776 -122.43639892299299 (37.7339854340776, -122.436398922993)
3723 253167 3 12 1X Brotherhood Way 1 7 1 2                    
11241 19489 3 12 355X Mansell St 1 1 1 2     18 3X3   6010833.1058 2090397.5651099999 37.7204445776412 -122.40459002092301 (37.7204445776412, -122.404590020923)
11347 117512 3 12 1890 27th Ave 1 1 1 2     5 3x3   5987869.5321 2102444.0363 37.752210904135104 -122.484849991664 (37.7522109041351, -122.484849991664)
13188 28810 3 12 945 Silver Ave 2 1 1 2     10 2X3   6007406.03432 2093542.49389 37.7288877484642 -122.416659008228 (37.7288877484642, -122.416659008228)
14810 4764 3 12 20 Commer Ct 1 1 1 2     100 3X3   6016747.24729 2094694.7761400002 37.7325726360097 -122.384445690014 (37.7325726360097, -122.384445690014)
16870 6554 3 12 1275 Evans Ave 6 1 1 2     18 4x8   6017477.53742 2097112.4140299999 37.7392513450766 -122.382088994133 (37.7392513450766, -122.382088994133)
17733 11662 3 12 700X Junipero Serra Blvd 4 11 1 2     9 6X6   5991320.71555 2093015.85848 37.726523937110294 -122.472228178599 (37.7265239371103, -122.472228178599)
18472 11680 3 12 700X Junipero Serra Blvd 12 11 1 2     18 2X2   5991310.78789 2092904.51417 37.726217638817296 -122.47225438484199 (37.7262176388173, -122.472254384842)
20123 11745 3 12 700X Junipero Serra Blvd 28 11 1 2     24 2X2   5991283.014280001 2092711.56765 37.7256862482988 -122.472336336474 (37.7256862482988, -122.472336336474)
22056 16608 3 12 106 Noe St 2 1 1 2     3     6002826.848230001 2107609.5605599997 37.7672540005999 -122.43349442931999 (37.7672540005999, -122.43349442932)
22616 249322 3 12 2100X Turk Blvd 7 1 1 2       3x3   5999950.0 2111978.0 37.7790849877594 -122.44375887340799 (37.7790849877594, -122.443758873408)
23154 5930 3 12 1346X Eddy St 2 1 1 2     4     6003972.1136 2112884.9103 37.7818037271844 -122.42990945845699 (37.7818037271844, -122.429909458457)
23986 204965 3 12 400x Miramar Ave 4 3 1 2     15     5995367.63483 2092532.42925 37.725429933419 -122.458203256674 (37.725429933419, -122.458203256674)
25213 112218 3 12 2000X Turk Blvd 20 1 1 2     2 3x3   6000205.46291 2111993.0991599998 37.779141013771 -122.442876210646 (37.779141013771, -122.442876210646)
29290 204967 3 12 500x Miramar Ave 6 3 1 2     15     5995373.3226 2092827.47447 37.7262403835647 -122.45820493933 (37.7262403835647, -122.45820493933)
43499 204970 3 12 650x Miramar Ave 8 3 1 2     6     5995394.3543300005 2093951.39661 37.729327611382 -122.458213544044 (37.729327611382, -122.458213544044)
46169 188192 3 12 860x Jamestown Ave 7 11 1 2     2 Width 5ft   6014712.4620199995 2089164.16636 37.7172739556962 -122.391094061367 (37.7172739556962, -122.391094061367)
46196 112202 3 12 2000X Turk Blvd 4 1 1 2     0 3x3   6000205.46291 2111993.0991599998 37.779141013771 -122.442876210646 (37.779141013771, -122.442876210646)
50839 113034 3 12 251 06th Ave 5 1 1 4     2 3x3   5993975.1139 2113804.1265 37.7837564355183 -122.464560902617 (37.7837564355183, -122.464560902617)
51554 28847 3 12 800X Bosworth St 6 1 1 2     5 3X3   6001908.8431877 2095495.9697001998 37.7339408370986 -122.43580286684099 (37.7339408370986, -122.435802866841)
58921 188193 3 12 860x Jamestown Ave 8 11 1 2     2 Width 5ft   6014700.6925800005 2089174.7091700002 37.7173022510631 -122.391135479631 (37.7173022510631, -122.391135479631)
65206 204969 3 12 650x Miramar Ave 7 3 1 2     9     5995393.40684 2093932.00201 37.729274304053796 -122.458215416425 (37.7292743040538, -122.458215416425)
66193 28811 3 12 1199X Silver Ave 1 1 1 2     6 3X3   6008563.737000001 2093993.84748 37.7301921129709 -122.41268862965799 (37.7301921129709, -122.412688629658)
72555 204955 3 12 1485x Northwood Dr 4 3 1 2     10     5995888.63962 2093952.75509 37.72935973156871 -122.45650486362 (37.7293597315687, -122.45650486362)
73694 188195 3 12 920x Jamestown Ave 6 11 1 2     3 Width 5ft   6014470.00417 2089321.4715900002 37.717692427352 -122.391943124797 (37.717692427352, -122.391943124797)
77959 16742 3 12 1735X O'Farrell St 1 1 1 2     6 3x3   6003067.524180001 2113392.76277 37.783146893199394 -122.433075208633 (37.7831468931994, -122.433075208633)
80919 28813 3 12 1199X Silver Ave 3 1 1 2     6 3X3   6008563.737000001 2093993.84748 37.7301921129709 -122.41268862965799 (37.7301921129709, -122.412688629658)
81291 29209 3 12 2002X 41st Ave 9 1 1 2     6 3X3   5983557.6109598 2101506.6699283 37.7493850732351 -122.499691774232 (37.7493850732351, -122.499691774232)
85795 27279 3 12 223X Duboce Ave 5 1 1 2     6 3X3   6005302.0235685 2108427.9420982 37.7696412012385 -122.424991381282 (37.7696412012385, -122.424991381282)
90339 100523 3 12 4012 Judah St 1 1 1 1       3x3   5982110.0 2105587.0 37.760503457086394 -122.504999898043 (37.7605034570864, -122.504999898043)
90630 98561 3 12 2035X Stockton St 4 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
91242 98559 3 12 2035X Stockton St 2 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
92868 11209 3 12 1001X Ingalls St 7 1 1 2     3 3X4   6018170.9910099 2094117.1281791 37.7310651541831 -122.379483297777 (37.7310651541831, -122.379483297777)
99216 11580 3 12 3940 Judah St 1 1 1 2     6 3X3   5982333.0 2105594.0 37.760535794591 -122.504229174925 (37.760535794591, -122.504229174925)
100808 11569 3 12 1391X 44th Ave 1 1 1 2     12 4X4   5982433.6200097 2105656.9427051996 37.760714534455204 -122.503885844083 (37.7607145344552, -122.503885844083)
101550 28814 3 12 1199X Silver Ave 4 1 1 2     6 3X3   6008563.737000001 2093993.84748 37.7301921129709 -122.41268862965799 (37.7301921129709, -122.412688629658)
102469 11628 3 12 300X Junipero Serra Blvd 7 1 1 2     3 2x2   5991444.7104442 2094652.0546396 37.7310236980815 -122.471918736195 (37.7310236980815, -122.471918736195)
104893 28812 3 12 1199X Silver Ave 2 1 1 2     6 3X3   6008563.737000001 2093993.84748 37.7301921129709 -122.41268862965799 (37.7301921129709, -122.412688629658)
105261 16743 3 12 1735X O'Farrell St 2 1 1 2     6 3x3   6003112.88898 2113403.1855900004 37.7831780847955 -122.432919009773 (37.7831780847955, -122.432919009773)
107073 12 3 12 97 12th St 6 11 1 2     3 3X3   6007166.5822125 2109668.7679164 37.7731533608049 -122.418629924651 (37.7731533608049, -122.418629924651)
114864 112213 3 12 2000X Turk Blvd 15 1 1 2       3x3   6000205.46291 2111993.0991599998 37.779141013771 -122.442876210646 (37.779141013771, -122.442876210646)
115219 98995 3 12 2190X Divisadero St 1 1 1 10       3x3   6000922.9 2115860.7 37.7898013277865 -122.44067180053001 (37.7898013277865, -122.44067180053)
117621 27277 3 12 223X Duboce Ave 3 1 1 2     6 3X3   6005302.0235685 2108427.9420982 37.7696412012385 -122.424991381282 (37.7696412012385, -122.424991381282)
119566 28815 3 12 1199X Silver Ave 5 1 1 2     6 3X3   6008563.737000001 2093993.84748 37.7301921129709 -122.41268862965799 (37.7301921129709, -122.412688629658)
122527 107851 3 12 1201X Anza St 3 1 1 2       3x3   5994909.387864 2112113.173405 37.7791673459947 -122.46120607579901 (37.7791673459947, -122.461206075799)
124013 11743 3 12 900X Junipero Serra Blvd 21 1 1 2     3 2x2   5991216.9689233005 2091217.0890623 37.7215789580388 -122.472455744827 (37.7215789580388, -122.472455744827)
126599 98562 3 12 2035X Stockton St 5 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
134352 188190 3 12 828x Jamestown Ave 5 11 1 2     4 Width 5ft   6014862.4902 2088981.3043400003 37.716780176644896 -122.390562709505 (37.7167801766449, -122.390562709505)
135183 204966 3 12 500x Miramar Ave 4 3 1 2     9     5995372.18711 2092773.2155 37.726091336224606 -122.458204939301 (37.7260913362246, -122.458204939301)
139143 28816 3 12 1199X Silver Ave 6 1 1 2     6 3X3   6008563.737000001 2093993.84748 37.7301921129709 -122.41268862965799 (37.7301921129709, -122.412688629658)
139658 29236 3 12 1902X 41st Ave 19 1 1 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
141315 98560 3 12 2035X Stockton St 3 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
144504 11739 3 12 900X Junipero Serra Blvd 17 1 1 2     3 2x2   5991216.9689233005 2091217.0890623 37.7215789580388 -122.472455744827 (37.7215789580388, -122.472455744827)
144533 11679 3 12 700X Junipero Serra Blvd 12 1 1 2     3 2x2   5991320.9947906 2093088.5989831001 37.7267236805691 -122.472232513363 (37.7267236805691, -122.472232513363)
145606 19318 3 12 101 Shields St 1 1 1 2     6 3X3   5993758.5543723 2089809.6356688999 37.717861208645296 -122.46356814314 (37.7178612086453, -122.46356814314)
159414 188194 3 12 920x Jamestown Ave 5 11 1 2     3 Width 5ft   6014479.07323 2089312.06804 37.717667110539395 -122.391911119697 (37.7176671105394, -122.391911119697)
161647 188189 3 12 828x Jamestown Ave 3 11 1 2     2 Width 5ft   6014874.8718 2088959.3424900002 37.716720560580605 -122.390518378346 (37.7167205605806, -122.390518378346)
163682 188196 3 12 920x Jamestown Ave 7 11 1 2     3 Width 5ft   6014458.158419999 2089328.2197 37.7177102986816 -122.39198454217698 (37.7177102986816, -122.391984542177)
175115 219878 3 12 2x Montezuma St 2 11 1 2     4 Width 3ft   6007278.55035 2099761.42955 37.7459564033742 -122.41754030963699 (37.7459564033742, -122.417540309637)
175789 204968 3 12 500x Miramar Ave 4 3 1 2     10     5995374.72288 2093080.44046 37.726935047798705 -122.45821839946301 (37.7269350477987, -122.458218399463)
181471 112223 3 12 2000X Turk Blvd 25 1 1 2     2 3x3   6000205.46291 2111993.0991599998 37.779141013771 -122.442876210646 (37.779141013771, -122.442876210646)
183163 188197 3 12 920x Jamestown Ave 8 11 1 2     2 Width 5ft   6014447.456130001 2089337.65595 37.717735614585294 -122.39202219499501 (37.7177356145853, -122.392022194995)
188458 188191 3 12 860x Jamestown Ave 6 11 1 2     2 Width 5ft   6014720.49682 2089157.49571 37.7172560852665 -122.39106582262501 (37.7172560852665, -122.391065822625)
144757 90848 3 12 2517 Cabrillo St 1 1 1 2   01/02/2013 12:00:00 AM 3 3x3   5987755.79015 2110488.1190299997 37.774291123146604 -122.485833684074 (37.7742911231466, -122.485833684074)
140265 11211 3 12 1001X Ingalls St 9 1 1 2   01/02/2016 08:36:00 AM 3 3X4   6018170.9910099 2094117.1281791 37.7310651541831 -122.379483297777 (37.7310651541831, -122.379483297777)
10561 86012 3 12 1642 28th Ave 1 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987499.1098 2104097.2319 37.7567285504541 -122.486252307696 (37.7567285504541, -122.486252307696)
10958 86016 3 12 1558 28th Ave 1 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987478.2324 2104678.8878 37.758324402436706 -122.486367210591 (37.7583244024367, -122.486367210591)
10988 86017 3 12 1554 28th Ave 1 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987479.1031 2104708.0563 37.758404541939704 -122.48636634081001 (37.7584045419397, -122.48636634081)
11542 86026 3 12 1400X 28th Ave 3 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987446.3624 2105678.3641 37.761066833582504 -122.48655081434099 (37.7610668335825, -122.486550814341)
11589 86020 3 12 1538 28th Ave 1 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987475.185 2104787.7256 37.7586230637425 -122.48638574025499 (37.7586230637425, -122.486385740255)
12745 86023 3 12 1422 28th Ave 1 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987448.5891 2105584.2307 37.7608084988449 -122.486536201474 (37.7608084988449, -122.486536201474)
12979 86019 3 12 1546 28th Ave 1 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987476.0557 2104753.7682 37.758529876731295 -122.486380235963 (37.7585298767313, -122.486380235963)
13152 86021 3 12 1514 28th Ave 1 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987469.9607 2104957.5126 37.759088948014394 -122.486416273524 (37.7590889480144, -122.486416273524)
89152 86024 3 12 1400X 28th Ave 1 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987442.897773 2105735.142686 37.7612225300608 -122.486566965883 (37.7612225300608, -122.486566965883)
97131 86025 3 12 1400X 28th Ave 2 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987442.897773 2105735.142686 37.7612225300608 -122.486566965883 (37.7612225300608, -122.486566965883)
103879 86014 3 12 1600X 28th Ave 2 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987488.648908 2104374.518026 37.7574892930565 -122.486308841123 (37.7574892930565, -122.486308841123)
128909 86013 3 12 1600X 28th Ave 1 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987488.648908 2104374.518026 37.7574892930565 -122.486308841123 (37.7574892930565, -122.486308841123)
129133 86015 3 12 1600X 28th Ave 3 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987488.648908 2104374.518026 37.7574892930565 -122.486308841123 (37.7574892930565, -122.486308841123)
88931 8306 3 12 40 Garlington Ct 1 1 1 2   01/06/1993 12:00:00 AM 3 3X3   6016763.2740618 2094684.3635524 37.7325449313393 -122.38438955609101 (37.7325449313393, -122.384389556091)
21281 26481 3 12 136 Gold Mine Dr 1 1 1 2   01/10/2003 12:00:00 AM 8 3X3   6001110.26965 2098672.57235 37.7426176504905 -122.438791328284 (37.7426176504905, -122.438791328284)
99718 86357 3 12 2455 25th Ave 1 1 1 2   01/10/2007 12:00:00 AM 3 3x3   5988578.388463 2098615.8745830003 37.7417410456376 -122.482118259843 (37.7417410456376, -122.482118259843)
10295 86058 3 12 1583 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987441.2276 2104514.7604 37.7578715963284 -122.486483137481 (37.7578715963284, -122.486483137481)
10327 86040 3 12 1307 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987380.4546 2106353.8076 37.762917573839104 -122.48682835991 (37.7629175738391, -122.48682835991)
10533 86042 3 12 1311 28th Ave 2 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987382.8738 2106304.4567 37.7627822108774 -122.48681636863701 (37.7627822108774, -122.486816368637)
10600 86037 3 12 1215 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987357.4179 2106982.0087 37.76464109793461 -122.48695417155899 (37.7646410979346, -122.486954171559)
10692 86045 3 12 1359 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987391.0989 2106016.5765 37.7619922504501 -122.48676678064899 (37.7619922504501, -122.486766780649)
10799 86031 3 12 1330 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987427.8702 2106214.9477 37.7625390669723 -122.48665417119601 (37.7625390669723, -122.486654171196)
10834 86046 3 12 1375 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987395.4534 2105935.2927 37.7617693213048 -122.486745751332 (37.7617693213048, -122.486745751332)
11079 86049 3 12 1419 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987407.2223 2105592.1823 37.7608279203014 -122.486679852889 (37.7608279203014, -122.486679852889)
11101 86030 3 12 1334 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987428.353999999 2106187.8531 37.7624647008461 -122.486650508346 (37.7624647008461, -122.486650508346)
11195 86041 3 12 1311 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987381.4223 2106332.0351 37.7628578489584 -122.48682341409099 (37.7628578489584, -122.486823414091)
11348 86053 3 12 1475 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987418.7989 2105258.6641 37.7599128454564 -122.48661532550699 (37.7599128454564, -122.486615325507)
11362 86054 3 12 1479 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987418.7989 2105231.1006 37.759837163621 -122.48661330160101 (37.759837163621, -122.486613301601)
11571 86048 3 12 1415 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987405.936000001 2105630.5874 37.7609332951993 -122.486687121684 (37.7609332951993, -122.486687121684)
11651 86050 3 12 1427 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 12 3x3   5987407.9573 2105562.7812 37.7607472357807 -122.486675151954 (37.7607472357807, -122.486675151954)
11656 86043 3 12 1319 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987384.3253 2106288.9741 37.762739784537004 -122.486810211478 (37.762739784537, -122.486810211478)
11675 86051 3 12 1435 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987409.7949 2105491.8512 37.7605525885461 -122.486663588231 (37.7605525885461, -122.486663588231)
11701 86027 3 12 1386 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987439.966 2105864.6532 37.7615779595308 -122.48658661511999 (37.7615779595308, -122.48658661512)
11860 86029 3 12 1358 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987436.0953 2106019.4795 37.7620028444435 -122.486611370794 (37.7620028444435, -122.486611370794)
12541 86032 3 12 1318 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987424.9672 2106284.1357 37.7627288689785 -122.48666929207899 (37.7627288689785, -122.486669292079)
Powered by Datasette · Query took 76.72ms · Data source: data.sfgov.org