sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
740 26411 3 110 34 Maple St 8 5 1 2     3 10   5996554.84409 2116119.62648 37.7902625562289 -122.45580349675699 (37.7902625562289, -122.455803496757)
821 251392 3 60 800x Bosworth St 9 5 1 2       Width 3ft   6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
843 216491 3 60 800x Bosworth St 4 5 1 2   01/29/1998 12:00:00 AM 0 Width 3ft   6001764.68694 2095507.97765 37.733965618424 -122.43630211726601 (37.733965618424, -122.436302117266)
1664 26404 3 15 34 Maple St 1 5 1 2     3 10   5996581.1026099995 2115987.02812 37.7898999837554 -122.455703055979 (37.7898999837554, -122.455703055979)
4439 26408 3 129 34 Maple St 5 5 1 2     3 10   5996561.99823 2116111.6508299997 37.7902410678174 -122.45577816732599 (37.7902410678174, -122.455778167326)
4446 253627 3 5 44 Stonecrest Dr 1 5 1 2       3x3   5991061.0 2093828.0 37.7287388406121 -122.4731851996 (37.7287388406121, -122.4731851996)
4530 26410 3 110 34 Maple St 7 5 1 2     3 10   5996557.377619999 2116117.2149400003 37.790256080189295 -122.455794556583 (37.7902560801893, -122.455794556583)
4532 253201 3 43 800 Oak St 3 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4536 253202 3 43 800 Oak St 4 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4538 253635 3 37 830 Oak St 2 5 1 2   02/22/2008 12:00:00 AM       6003018.63904 2109969.70237 37.7737452502421 -122.43299969185101 (37.7737452502421, -122.432999691851)
4541 253199 3 43 800 Oak St 1 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4545 253200 3 43 800 Oak St 2 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4548 253634 3 43 830 Oak St 1 5 3 2           6003018.63904 2109969.70237 37.7737452502421 -122.43299969185101 (37.7737452502421, -122.432999691851)
5088 206891 3 47 1675x 15th Ave 1 5 1 2     24 Width 3ft   5991393.559640001 2103864.47578 37.756315678748706 -122.472767037095 (37.7563156787487, -122.472767037095)
5678 26407 3 15 34 Maple St 4 5 1 2     3 10   5996568.426030001 2116078.0273700003 37.7901491157315 -122.455753496227 (37.7901491157315, -122.455753496227)
7571 26412 3 110 34 Maple St 9 5 1 2     3 10   5996536.01908 2116115.1957 37.7902493101054 -122.455868309095 (37.7902493101054, -122.455868309095)
8270 26409 3 110 34 Maple St 6 5 1 2     3 10   5996561.54746 2116120.98746 37.790266677821 -122.45578040214599 (37.790266677821, -122.455780402146)
8439 19025 3 16 3170 Sacramento St 4 5 1 2     8 2X2   5999621.132119999 2115414.4338700003 37.7885017807754 -122.445143681435 (37.7885017807754, -122.445143681435)
8634 26406 3 15 34 Maple St 3 5 1 2     3 10   5996571.148159999 2116042.19518 37.79005088639771 -122.45574148670099 (37.7900508863977, -122.455741486701)
8973 26405 3 15 34 Maple St 2 5 1 2     3 10   5996577.84585 2116013.8842599997 37.7899735365954 -122.455716266094 (37.7899735365954, -122.455716266094)
10214 173907 2 3 2200 Jerrold Ave 1 5 1 2           6012443.0 2099218.0 37.7447535037256 -122.399644080592 (37.7447535037256, -122.399644080592)
10957 17580 3 46 801X Persia Ave 4 5 1 2     18 3x3   6003780.63082 2090335.5596900003 37.719877649504205 -122.428963734788 (37.7198776495042, -122.428963734788)
11152 17582 3 46 801X Persia Ave 6 5 1 2     18 3x3   6003762.13068 2090345.22062 37.7199031291015 -122.42902837176202 (37.7199031291015, -122.429028371762)
11319 17589 3 46 801X Persia Ave 13 5 1 2     18 3x3   6003683.23846 2090394.91559 37.720035114503006 -122.42930461652 (37.720035114503, -122.42930461652)
11996 17591 3 46 801X Persia Ave 15 5 1 2     30 3x3   6003659.63671 2090407.2266799998 37.7200675818369 -122.42938707716299 (37.7200675818369, -122.429387077163)
12305 17584 3 46 801X Persia Ave 8 5 1 2     18 3x3   6003740.32149 2090358.06458 37.7199371612464 -122.42910467385201 (37.7199371612464, -122.429104673852)
12769 17578 3 46 801X Persia Ave 2 5 1 2     18 3x3   6003799.63122 2090323.6743700001 37.7198460905006 -122.428897210135 (37.7198460905006, -122.428897210135)
12852 17587 3 46 801X Persia Ave 11 5 1 2     35 3X3   6003703.481380001 2090378.19842 37.7199903588363 -122.42923345225901 (37.7199903588363, -122.429233452259)
13246 187614 2 168 100 Castro St 11 5 1 2       3x3   6002192.0 2107639.0 37.767298794762 -122.43569238083799 (37.767298794762, -122.435692380838)
13247 187613 2 168 100 Castro St 10 5 1 2       3x3   6002192.0 2107639.0 37.767298794762 -122.43569238083799 (37.767298794762, -122.435692380838)
13248 187615 2 168 100 Castro St 12 5 1 2       3x3   6002192.0 2107639.0 37.767298794762 -122.43569238083799 (37.767298794762, -122.435692380838)
13249 187612 2 168 100 Castro St 1 5 1 2       3x3   6002192.0 2107639.0 37.767298794762 -122.43569238083799 (37.767298794762, -122.435692380838)
14134 104461 3 41 1601X Kansas St 1 5 1 2     4 3x6   6011834.442419999 2100473.73914 37.748167551187 -122.401836621487 (37.748167551187, -122.401836621487)
14398 104044 3 131 1601X Kansas St 8 5 1 2     70 9x9   6011818.89895 2100809.64818 37.749089017243904 -122.401913980245 (37.7490890172439, -122.401913980245)
14780 104045 3 131 1601X Kansas St 7 5 1 2     4 3x6   6011820.27046 2100794.2900099996 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805)
15106 104458 3 146 1601X Kansas St 4 5 1 2     4 3x6   6011832.95066 2100589.70632 37.748485888729206 -122.40184993054501 (37.7484858887292, -122.401849930545)
15361 104046 3 131 1601X Kansas St 6 5 1 2     4 3x6   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295)
15563 104460 3 131 1601X Kansas St 2 5 1 2     4 3x6   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097)
21052 16925 3 51 512 Oak St 1 5 1 2     25     6004419.62206 2110173.45228 37.7743840640969 -122.42816799305099 (37.7743840640969, -122.428167993051)
22233 16926 3 168 514 Oak St 1 5 1 2     18 3X3   6004391.58115 2110176.00513 37.774389487009 -122.42826517381201 (37.774389487009, -122.428265173812)
23146 18396 3 21 1001X Potrero Ave 3 5 1 2     8 3X3   6010579.89975 2102879.8481400004 37.7547041035309 -122.406344319459 (37.7547041035309, -122.406344319459)
23258 18405 3 21 1001X Potrero Ave 12 5 1 2     15 3X3   6010556.98057 2103355.2247200003 37.756008099814295 -122.406457075558 (37.7560080998143, -122.406457075558)
23324 18403 3 21 1001X Potrero Ave 10 5 1 2   01/14/1991 12:00:00 AM 10 3X3   6010561.22501 2103261.37452 37.7557506454989 -122.406435784089 (37.7557506454989, -122.406435784089)
46604 2135 3 60 1100X Bosworth St 24 5 1 2     24     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
60904 16944 3 70 599X Oak St 7 5 1 2     20 3x3   6004143.777734599 2110082.9014722 37.774119822677996 -122.429115732545 (37.774119822678, -122.429115732545)
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)
79080 2058 3 60 800X Bosworth St 5 5 1 2   06/08/1992 12:00:00 AM 22 3X3   6001908.8431877 2095495.9697001998 37.7339408370986 -122.43580286684099 (37.7339408370986, -122.435802866841)
79829 26416 3 21 34 Maple St 13 5 1 2     3 10   5996568.2197254 2116061.2858977 37.790103136313206 -122.455752999345 (37.7901031363132, -122.455752999345)
80242 24613 3 301 1735 Mission St 1 5 1 2     24 6x7   6006758.7391800005 2108085.91697 37.768784258651706 -122.419928366315 (37.7687842586517, -122.419928366315)
81940 27502 3 60 198X LAKE ST 2 5 1 2     15 3X3   5995045.0 2114905.0 37.786840755254204 -122.46093934021002 (37.7868407552542, -122.46093934021)
82530 14583 3 10 1159 Masonic Ave 2 5 1 2     60 4X4   5999386.3171 2108834.4593 37.7704214603588 -122.445482773554 (37.7704214603588, -122.445482773554)
82755 2119 3 60 1100X Bosworth St 8 5 1 2     18     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
82883 92052 3 266 2323 Cesar Chavez St   5 1 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
84691 21808 3 43 2600X Taylor St 13 5 1 2   03/01/2016 12:00:00 AM 3 4x4   6008553.39113 2121935.04647 37.806911549800795 -122.414700989571 (37.8069115498008, -122.414700989571)
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)
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)
93747 26415 3 136 34 Maple St 12 5 1 2     3 10   5996568.2197254 2116061.2858977 37.790103136313206 -122.455752999345 (37.7901031363132, -122.455752999345)
94842 21807 3 43 2600X Taylor St 12 5 1 2   03/01/2016 12:00:00 AM 3 3X3   6008553.39113 2121935.04647 37.806911549800795 -122.414700989571 (37.8069115498008, -122.414700989571)
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)
95857 2117 3 60 1100X Bosworth St 6 5 1 2     12     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
96353 104459 3 17 1601X Kansas St 3 5 1 2     4 3x6   6011789.30586 2100707.09327 37.748805772054 -122.402009105448 (37.748805772054, -122.402009105448)
99878 6102 3 40 500X 08th St 4 5 1 2     6 18   6010526.812454099 2109340.6023904 37.772440902057795 -122.406983260044 (37.7724409020578, -122.406983260044)
100446 2113 3 60 1100X Bosworth St 2 5 1 2     12     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
100546 2062 3 60 800X Bosworth St 9 5 1 2     14 3X3   6001908.8431877 2095495.9697001998 37.7339408370986 -122.43580286684099 (37.7339408370986, -122.435802866841)
101382 108685 3 40 301X CHESTER AVE 1 5 1 2     18     5991720.0 2087146.0 37.7104298409998 -122.47042057923099 (37.7104298409998, -122.470420579231)
101916 26413 3 136 34 Maple St 10 5 1 2     3 10   5996568.2197254 2116061.2858977 37.790103136313206 -122.455752999345 (37.7901031363132, -122.455752999345)
103041 16943 3 70 599X Oak St 6 5 1 2     12 3x3   6004143.777734599 2110082.9014722 37.774119822677996 -122.429115732545 (37.774119822678, -122.429115732545)
103627 2130 3 60 1100X Bosworth St 19 5 1 2     12     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
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)
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)
105424 26414 3 136 34 Maple St 11 5 1 2     3 10   5996568.2197254 2116061.2858977 37.790103136313206 -122.455752999345 (37.7901031363132, -122.455752999345)
106968 2121 3 60 1100X Bosworth St 10 5 1 2   06/01/2000 12:00:00 AM 3     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
110122 14584 3 10 1159 Masonic Ave 3 5 1 2     100 4x4   5999323.48045 2108827.83023 37.7703996711999 -122.445699648114 (37.7703996711999, -122.445699648114)
111836 2071 3 60 900X Bosworth St 2 5 1 2     20 3X3   6001652.8683327995 2095576.0345146998 37.734146132831796 -122.436693577752 (37.7341461328318, -122.436693577752)
114504 10774 3 39 1120X Hudson Ave 39 5 1 2     6 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
119405 6105 3 40 500X 08th St 7 5 1 2     3 18   6010526.812454099 2109340.6023904 37.772440902057795 -122.406983260044 (37.7724409020578, -122.406983260044)
120534 2064 3 60 800X Bosworth St 11 5 1 2     14 3X3   6001908.8431877 2095495.9697001998 37.7339408370986 -122.43580286684099 (37.7339408370986, -122.435802866841)
122783 10768 3 39 1120X Hudson Ave 23 5 1 2     14 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
123207 10738 3 39 1120X Hudson Ave 9 5 1 2     8 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
123607 16942 3 70 599X Oak St 5 5 1 2     6 3x3   6004143.777734599 2110082.9014722 37.774119822677996 -122.429115732545 (37.774119822678, -122.429115732545)
125132 2061 3 60 800X Bosworth St 8 5 1 2     8 3X3   6001908.8431877 2095495.9697001998 37.7339408370986 -122.43580286684099 (37.7339408370986, -122.435802866841)
125275 2132 3 60 1100X Bosworth St 21 5 1 2     0     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
125479 2077 3 60 900X Bosworth St 8 5 1 2     12 3X3   6001652.8683327995 2095576.0345146998 37.734146132831796 -122.436693577752 (37.7341461328318, -122.436693577752)
125496 27503 3 60 198X LAKE ST 5 5 1 2     25 3x3   5995045.0 2114905.0 37.786840755254204 -122.46093934021002 (37.7868407552542, -122.46093934021)
125511 2128 3 60 1100X Bosworth St 17 5 1 2     12     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
125618 2079 3 60 900X Bosworth St 10 5 1 2     12 3X3   6001652.8683327995 2095576.0345146998 37.734146132831796 -122.436693577752 (37.7341461328318, -122.436693577752)
126542 2074 3 60 900X Bosworth St 5 5 1 2     21 3X3   6001652.8683327995 2095576.0345146998 37.734146132831796 -122.436693577752 (37.7341461328318, -122.436693577752)
126559 98132 3 39 1120X Hudson Ave 47 5 1 2     22 3x4   6017903.8 2094987.0 37.733438911814 -122.38046746904399 (37.733438911814, -122.380467469044)
127931 2101 3 60 1000X Bosworth St 9 5 1 2   04/09/1990 12:00:00 AM 14     6001184.3961352995 2095706.3375319 37.7344772801388 -122.438322562248 (37.7344772801388, -122.438322562248)
128760 2115 3 60 1100X Bosworth St 4 5 1 2     18     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
138901 2095 3 60 1000X Bosworth St 3 5 1 2     15 3X3   6001184.3961352995 2095706.3375319 37.7344772801388 -122.438322562248 (37.7344772801388, -122.438322562248)
139002 16934 3 43 534 Oak St 1 5 1 2     24 3X3   6004202.212169999 2110156.57626 37.774325423266895 -122.428918851232 (37.7743254232669, -122.428918851232)
140071 2139 3 60 1100X Bosworth St 28 5 1 2     12     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
140884 104457 3 17 1601X Kansas St 5 5 1 2     4 3x6   6011789.30586 2100707.09327 37.748805772054 -122.402009105448 (37.748805772054, -122.402009105448)
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)
141855 10769 3 40 1120X Hudson Ave 41 5 1 2     8 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
141869 21804 3 15 2600X Taylor St 9 5 1 2   01/22/2016 12:00:00 AM 12 3X3   6008553.39113 2121935.04647 37.806911549800795 -122.414700989571 (37.8069115498008, -122.414700989571)
143311 10754 3 39 1120X Hudson Ave 17 5 1 2     8 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
144479 10750 3 2 1120X Hudson Ave 19 5 1 2     6 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
144510 10758 3 39 1120X Hudson Ave 43 5 1 2     12 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
144628 9747 3 272 710X McAllister St 3 5 1 2   05/24/2011 12:00:00 AM 3 4x4   6005653.6676 2112008.06895 37.779491220069296 -122.424029686189 (37.7794912200693, -122.424029686189)
Powered by Datasette · Query took 13.039ms · Data source: data.sfgov.org