sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
39687 80561 2 97 1820X Palou Ave 4 1 1 1 1 09/07/2002 12:00:00 AM 15     6013651.87309 2096197.8113799999 37.736528009043795 -122.395252475224 (37.7365280090438, -122.395252475224)
13616 83038 2 97 100X Cargo Way 14 1 1 1 1 02/04/2006 12:00:00 AM       6018593.33009 2097780.6594 37.7411477742489 -122.378277419086 (37.7411477742489, -122.378277419086)
102430 96852 2 97 1x Bennington St 1 1 1 1     5 3x3   6007194.0 2097789.0 37.7405357947447 -122.417692894396 (37.7405357947447, -122.417692894396)
120289 96855 2 97 600 Eugenia Ave 2 1 1 1     6 3x3   6007257.0 2097738.0 37.740399305054005 -122.41747145076599 (37.740399305054, -122.417471450766)
124887 97179 2 97 10X Fremont St 1 1 1 1     5 3x3   6013408.0 2116114.0 37.7911999015077 -122.397492006217 (37.7911999015077, -122.397492006217)
79194 97180 2 97 10X Fremont St 2 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
109098 97181 2 97 10X Fremont St 3 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
107120 97182 2 97 10X Fremont St 4 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
122587 97183 2 97 10X Fremont St 5 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
109377 97184 2 97 10X Fremont St 6 1 1 1     5 3x3   6013138.0 2116168.0 37.791333135618 -122.398429995238 (37.791333135618, -122.398429995238)
123040 97185 2 97 10X Fremont St 7 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
103650 97186 2 97 10X Fremont St 8 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
20496 97187 2 97 10X Fremont St 9 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
103733 97188 2 97 10X Fremont St 10 1 1 1     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086)
124125 101489 2 97 59X Waller St 1 1 1 1   10/26/2012 12:00:00 AM 1 3x3 Permit Number 769087 6005416.7 2109221.0 37.7718252244657 -122.424651142233 (37.7718252244657, -122.424651142233)
108621 101685 2 97 363 Missouri St 1 1 1 1     16 12x9   6013519.417230001 2105388.32273 37.7617558261822 -122.396354408248 (37.7617558261822, -122.396354408248)
81394 103339 2 97 590X 09th St 1 1 1 1     10 3x3   6010323.0 2108639.0 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146)
109877 103340 2 97 590X 09th St 2 1 1 1     9 3x3 Permit Number 772809 6010323.0 2108639.0 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146)
86488 103341 2 97 590X 09th St 3 1 1 1     8 3x3   6010323.0 2108639.0 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146)
102694 103342 2 97 590X 09th St 4 1 1 1     10 3x3   6010323.0 2108639.0 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146)
49114 103343 2 97 590X 09th St 5 1 1 1     9 3x3   6010323.0 2108639.0 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146)
119633 103345 2 97 1000 Brannan St 3 1 1 1     16 3x3 Permit Number 29899 6010491.0 2108479.0 37.7700731362443 -122.407046397751 (37.7700731362443, -122.407046397751)
125918 103687 2 97 903 SHOTWELL ST 2 1 1 1     24 3x3   6008052.0 2102672.0 37.7539916655216 -122.41507179826799 (37.7539916655216, -122.415071798268)
91314 104633 2 97 850 Florida St 1 1 1 1     16 3x3   6009360.0 2104224.0 37.7583265252915 -122.41065799814301 (37.7583265252915, -122.410657998143)
92531 105449 2 97 890 Alabama St 1 1 1 1           6009082.7 2103985.1 37.7576550089679 -122.411600148106 (37.7576550089679, -122.411600148106)
84282 105450 2 97 890 Alabama St 2 1 1 1           6009082.7 2103985.1 37.7576550089679 -122.411600148106 (37.7576550089679, -122.411600148106)
104195 105930 2 97 971 Florida St   1 1 1       3x3   6009455.0 2103552.4 37.7564877890416 -122.410282026926 (37.7564877890416, -122.410282026926)
4380 106727 2 97 2809 Bush St 2 1 1 1     10 3x3   6000017.8025 2114366.8285 37.785647962066996 -122.443695977864 (37.785647962067, -122.443695977864)
14523 107150 2 97 219 Missouri St 1 1 1 1     15 5x5   6013483.53646 2106027.96623 37.7635101499066 -122.396523344982 (37.7635101499066, -122.396523344982)
13493 107151 2 97 215 Missouri St 1 1 1 1     12 4x4   6013483.16907 2106058.28155 37.7635933686511 -122.396526740817 (37.7635933686511, -122.396526740817)
95567 110183 2 97 1500x LYON ST 1 1 1 1       3x3   5999718.0 2114083.0 37.7848515388794 -122.444712796347 (37.7848515388794, -122.444712796347)
89436 110184 2 97 1500x LYON ST 2 1 1 1       3x3   5999718.0 2114083.0 37.7848515388794 -122.444712796347 (37.7848515388794, -122.444712796347)
97353 110185 2 97 1500x LYON ST 3 1 1 1       3x3   5999718.0 2114083.0 37.7848515388794 -122.444712796347 (37.7848515388794, -122.444712796347)
61155 111886 2 97 140 LUNDYS LN 1 1 1 1     12 3x12   6006709.0 2098750.0 37.7431471814186 -122.41943799965 (37.7431471814186, -122.41943799965)
126258 111887 2 97 140 LUNDYS LN 2 1 1 1     12 3x12   6006709.0 2098750.0 37.7431471814186 -122.41943799965 (37.7431471814186, -122.41943799965)
104253 111888 2 97 140 LUNDYS LN 3 1 1 1       3x12   6006709.0 2098750.0 37.7431471814186 -122.41943799965 (37.7431471814186, -122.41943799965)
121279 112815 2 97 10 LOMITA AVE 1 1 1 1       3x3   5991472.0 2104830.0 37.7589712942358 -122.472566156736 (37.7589712942358, -122.472566156736)
119338 113383 2 97 146 CASTENADA AVE 2 1 1 1     7 3x3   5994461.0 2101055.0 37.7487786662853 -122.46195512222401 (37.7487786662853, -122.461955122224)
144112 113692 2 97 112 LUNDYS LN 1 1 1 1     14 3x3   6006814.0 2098928.0 37.7436418429474 -122.419087559811 (37.7436418429474, -122.419087559811)
113525 113693 2 97 112 LUNDYS LN 2 1 1 1       3x5   6006814.0 2098928.0 37.7436418429474 -122.419087559811 (37.7436418429474, -122.419087559811)
101854 114592 2 97 70 LOMITA AVE 2 1 1 1     6 3x3   5991433.0 2104626.0 37.7584089066312 -122.472686161822 (37.7584089066312, -122.472686161822)
79181 115360 2 97 205 ARKANSAS ST 1 1 1 1       3x4   6012944.0 2106057.0 37.763559829435295 -122.39839147938801 (37.7635598294353, -122.398391479388)
100386 115557 2 97 2500x 19TH ST 1 1 1 1       3x3   6010357.0 2105131.0 37.7608727909959 -122.407273854716 (37.7608727909959, -122.407273854716)
85487 115558 2 97 2500x 19TH ST 2 1 1 1       3x3   6010357.0 2105131.0 37.7608727909959 -122.407273854716 (37.7608727909959, -122.407273854716)
174264 115842 2 97 1500 Bay St 1 1 1 1     5 3x3   6003573.215530001 2120746.37029 37.8033666892713 -122.431850957862 (37.8033666892713, -122.431850957862)
42092 115843 2 97 1500 Bay St 2 1 1 1     10 3x3   6003556.384769999 2120742.54729 37.80335523820229 -122.431908928161 (37.8033552382023, -122.431908928161)
46321 115844 2 97 1500 Bay St 3 1 1 1     10 3x3   6003543.04696 2120740.86009 37.8033498494719 -122.43195496357 (37.8033498494719, -122.43195496357)
32206 115845 2 97 1500 Bay St 4 1 1 1     9 3x3   6003527.72894 2120738.7231400004 37.8033431135653 -122.432007819421 (37.8033431135653, -122.432007819421)
135731 115846 2 97 1500 Bay St 5 1 1 1     12 3x3   6003504.2747 2120736.26354 37.8033350304463 -122.432088807873 (37.8033350304463, -122.432088807873)
49414 115847 2 97 3501 Laguna St 1 1 1 1     8 3x3   6003582.67693 2120834.7351599997 37.80360985246121 -122.431824529496 (37.8036098524612, -122.431824529496)
168072 115848 2 97 3501 Laguna St 3 1 1 1     6 3x3   6003586.42591 2120801.53952 37.8035189184231 -122.43180918435499 (37.8035189184231, -122.431809184355)
177272 115849 2 97 3501 Laguna St 4 1 1 1     7 3x3   6003588.62501 2120788.7376599996 37.803483892518294 -122.43180065966801 (37.8034838925183, -122.431800659668)
151213 115850 2 97 3501 Laguna St 5 1 1 1     7 3x3   6003589.56269 2120774.48991 37.8034448250715 -122.431796396884 (37.8034448250715, -122.431796396884)
127358 119741 2 97 15X Fremont St 1 1 1 1       3x3   6013411.0 2116073.0 37.7910874921548 -122.39747874956998 (37.7910874921548, -122.39747874957)
96123 119742 2 97 15X Fremont St 2 1 1 1       3x3   6013411.0 2116073.0 37.7910874921548 -122.39747874956998 (37.7910874921548, -122.39747874957)
119094 119743 2 97 15X Fremont St 3 1 1 1       3x3   6013411.0 2116073.0 37.7910874921548 -122.39747874956998 (37.7910874921548, -122.39747874957)
83439 119744 2 97 15X Fremont St 4 1 1 1       3x3   6013411.0 2116073.0 37.7910874921548 -122.39747874956998 (37.7910874921548, -122.39747874957)
101673 119745 2 97 15X Fremont St 5 1 1 1       3x3   6013411.0 2116073.0 37.7910874921548 -122.39747874956998 (37.7910874921548, -122.39747874957)
139540 119746 2 97 15X Fremont St 6 1 1 1       3x3   6013411.0 2116073.0 37.7910874921548 -122.39747874956998 (37.7910874921548, -122.39747874957)
33051 123914 2 97 389 09th Ave 9 1 1 1     2 Width 3ft   5993078.53663 2112857.8084299997 37.7811063777719 -122.467593853963 (37.7811063777719, -122.467593853963)
51566 124321 2 97 115 Jordan Ave 2 2 1 1     14 Width 3ft   5996193.40211 2113658.2283900003 37.783483467186706 -122.45687595100901 (37.7834834671867, -122.456875951009)
32711 124322 2 97 115 Jordan Ave 1 2 1 1     8 Width 3ft   5996192.87314 2113669.7360400003 37.7835150337529 -122.456878613619 (37.7835150337529, -122.456878613619)
38071 125966 2 97 2198 Filbert St 1 1 1 1     14 Width 4ft   6002473.45784 2118854.30827 37.7981091788388 -122.435521270088 (37.7981091788388, -122.435521270088)
35330 125967 2 97 3440 Clay St 1 1 1 1     11 Width 6ft   5998347.68841 2115559.3339299997 37.7888268704136 -122.449560024485 (37.7888268704136, -122.449560024485)
71217 125968 2 97 2810 Sacramento St 2 1 1 1     12 Width 3ft   6001336.417830001 2115647.62359 37.7892398148051 -122.43922579254101 (37.7892398148051, -122.439225792541)
71848 125969 2 97 2672 Sacramento St 1 1 1 1     16 Width 3ft   6002023.76351 2115741.9503 37.7895379005066 -122.43685441882 (37.7895379005066, -122.43685441882)
71480 125970 2 97 2301 Sacramento St 1 1 1 1     19 Width 4ft   6003734.22562 2115934.13704 37.7901626613254 -122.430950126753 (37.7901626613254, -122.430950126753)
34241 125971 2 97 100 Hyde St 1 1 1 1     19 Width 4ft   6008148.4886 2112831.1491900003 37.7818917385495 -122.415457300812 (37.7818917385495, -122.415457300812)
137044 125972 2 97 633 Beach St 1 1 1 1     5 Width 2ft   6006913.21617 2121857.59743 37.806606605779294 -122.42037165782601 (37.8066066057793, -122.420371657826)
54617 125973 2 97 633 Beach St 2 1 1 1     5 Width 2ft   6006932.43872 2121860.17562 37.8066147680158 -122.420305317544 (37.8066147680158, -122.420305317544)
28725 125974 2 97 633 Beach St 3 1 1 1     5 Width 2ft   6007013.058230001 2121870.81717 37.806648529474295 -122.42002707360399 (37.8066485294743, -122.420027073604)
58420 125975 2 97 633 Beach St 4 1 1 1     7 Width 3ft   6007035.474780001 2121873.14157 37.806656174619704 -122.41994966175601 (37.8066561746197, -122.419949661756)
182201 125976 2 97 633 Beach St 5 1 1 1     5 Width 3ft   6007074.37921 2121877.42075 37.8066701158897 -122.419815329109 (37.8066701158897, -122.419815329109)
175928 125977 2 97 2360 Taylor St 1 1 1 1     13 Width 4ft   6008401.628880001 2121444.29683 37.8055555474172 -122.415191434251 (37.8055555474172, -122.415191434251)
174929 125978 2 97 2360 Taylor St 2 1 1 1     7 Width 4ft   6008392.85025 2121496.40648 37.8056981340166 -122.415225505068 (37.8056981340166, -122.415225505068)
169791 125979 2 97 2360 Taylor St 3 1 1 1     12 Width 4ft   6008389.02756 2121512.5692 37.80574229793179 -122.41523987893999 (37.8057422979318, -122.41523987894)
39568 125980 2 97 2362 Taylor St 1 1 1 1     4 Width 4ft   6008387.31056 2121533.89692 37.8058007619722 -122.415247331605 (37.8058007619722, -122.415247331605)
188551 125981 2 97 2362 Taylor St 2 1 1 1     19 Width 6ft   6008384.91577 2121552.17509 37.8058508146246 -122.415256913874 (37.8058508146246, -122.415256913874)
136904 125982 2 97 2362 Taylor St 3 1 1 1     19 Width 6ft   6008379.56749 2121591.49972 37.8059584895516 -122.415278208017 (37.8059584895516, -122.415278208017)
136532 125983 2 97 2362 Taylor St 4 1 1 1     14 Width 5ft   6008377.32314 2121617.1276 37.8060287311026 -122.415287790321 (37.8060287311026, -122.415287790321)
52501 125984 2 97 2362 Taylor St 5 1 1 1     18 Width 6ft   6008373.73288 2121637.11508 37.8060834098955 -122.41530163086 (37.8060834098955, -122.41530163086)
40966 125985 2 97 2362 Taylor St 6 1 1 1     16 Width 6ft   6008371.27829 2121652.4837 37.8061254702907 -122.415311214049 (37.8061254702907, -122.415311214049)
44097 125986 2 97 2362 Taylor St 7 1 1 1     19 Width 6ft   6008368.52895 2121668.4711599997 37.8061692132974 -122.415321861121 (37.8061692132974, -122.415321861121)
56220 125987 2 97 2362 Taylor St 8 1 1 1     14 Width 6ft   6008367.52131 2121686.8739 37.8062196859398 -122.415326651828 (37.8062196859398, -122.415326651828)
174828 125988 2 97 2361 Taylor St 1 1 1 1     10 Width 3ft   6008319.39655 2121673.00017 37.806178887323 -122.41549221341101 (37.806178887323, -122.415492213411)
160878 125989 2 97 2361 Taylor St 2 1 1 1     10 Width 3ft   6008326.45195 2121634.40634 37.8060733149832 -122.41546506288 (37.8060733149832, -122.41546506288)
57395 125990 2 97 2361 Taylor St 4 1 1 1     9 Width 3ft   6008335.581590001 2121584.4344900004 37.8059366180507 -122.415429928145 (37.8059366180507, -122.415429928145)
25271 125991 2 97 2361 Taylor St 5 1 1 1     11 Width 3ft   6008338.82398 2121554.9566599997 37.805855861614795 -122.41541661910699 (37.8058558616148, -122.415416619107)
174972 125992 2 97 2361 Taylor St 6 1 1 1     9 Width 3ft   6008341.11218 2121531.47257 37.8057915088426 -122.41540703681801 (37.8057915088426, -122.415407036818)
137305 125993 2 97 2361 Taylor St 7 1 1 1     9 Width 3ft   6008342.4716300005 2121500.19485 37.8057057045282 -122.415400116539 (37.8057057045282, -122.415400116539)
188434 125994 2 97 2361 Taylor St 8 1 1 1     10 Width 3ft   6008347.52133 2121476.34798 37.805640510859206 -122.41538095198901 (37.8056405108592, -122.415380951989)
67946 125995 2 97 2361 Taylor St 9 1 1 1     12 Width 3ft   6008349.66203 2121453.17315 37.8055769989413 -122.41537190211201 (37.8055769989413, -122.415371902112)
60413 125996 2 97 2510 Jones St 1 1 1 1     16 Width 4ft   6007913.10752 2121457.27998 37.8055637294392 -122.41688295558001 (37.8055637294392, -122.41688295558)
67137 125997 2 97 2510 Jones St 2 1 1 1     12 Width 4ft   6007910.60432 2121475.9089200003 37.8056147389887 -122.416892938958 (37.8056147389887, -122.416892938958)
180722 125998 2 97 2510 Jones St 3 1 1 1     18 Width 4ft   6007907.02571 2121498.39071 37.8056762669961 -122.416906917118 (37.8056762669961, -122.416906917118)
70834 125999 2 97 2510 Jones St 4 1 1 1     7 Width 4ft   6007905.9664 2121521.7786 37.8057404246312 -122.41691224110399 (37.8057404246312, -122.416912241104)
23831 126000 2 97 2510 Jones St 5 1 1 1     14 Width 4ft   6007902.73328 2121542.33791 37.805796693425705 -122.41692488738501 (37.8057966934257, -122.416924887385)
61924 126001 2 97 2510 Jones St 6 1 1 1     16 Width 4ft   6007899.07258 2121560.79928 37.8058471777553 -122.41693886466001 (37.8058471777553, -122.41693886466)
28181 126002 2 97 2510 Jones St 7 1 1 1     11 Width 4ft   6007897.34981 2121579.9870599997 37.805899765629704 -122.41694618692699 (37.8058997656297, -122.416946186927)
71925 126003 2 97 2510 Jones St 8 1 1 1     19 Width 4ft   6007892.3710199995 2121599.81603 37.80595393089521 -122.41696482266501 (37.8059539308952, -122.416964822665)
65703 138239 2 97 1509 Lyon St 1 1 1 1     11 Width 0ft   5999639.177 2114119.037 37.784945988756 -122.444988088871 (37.784945988756, -122.444988088871)
Powered by Datasette · Query took 89.079ms · Data source: data.sfgov.org