sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9986 1263 6 3 3995X Alemany Blvd 3 5 1 1   12/02/1998 12:00:00 AM 10 3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10627 1283 6 44 3995X Alemany Blvd 1 5 1 1     10 10x10   5992081.50866 2087171.0422099999 37.710519496741206 -122.469172961285 (37.7105194967412, -122.469172961285)
11052 1284 6 120 3995X Alemany Blvd 2 5 1 1     12 3X10 Permit Number 778829 5992111.480830001 2087185.8440900003 37.7105618710011 -122.469070448459 (37.7105618710011, -122.469070448459)
109370 1414 1 41 15 Arguello Blvd 2 5 1 1     20 3X5   5995457.5707 2115860.24617 37.7894873341044 -122.459581162818 (37.7894873341044, -122.459581162818)
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)
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)
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)
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)
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)
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)
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)
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)
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)
146288 2099 3 60 1000X Bosworth St 7 5 1 2     10 3X3   6001184.3961352995 2095706.3375319 37.7344772801388 -122.438322562248 (37.7344772801388, -122.438322562248)
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)
100446 2113 3 60 1100X Bosworth St 2 5 1 2     12     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
128760 2115 3 60 1100X Bosworth St 4 5 1 2     18     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
95857 2117 3 60 1100X Bosworth St 6 5 1 2     12     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
82755 2119 3 60 1100X Bosworth St 8 5 1 2     18     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
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)
125511 2128 3 60 1100X Bosworth St 17 5 1 2     12     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
103627 2130 3 60 1100X Bosworth St 19 5 1 2     12     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
125275 2132 3 60 1100X Bosworth St 21 5 1 2     0     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
46604 2135 3 60 1100X Bosworth St 24 5 1 2     24     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
140071 2139 3 60 1100X Bosworth St 28 5 1 2     12     6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
13841 3685 1 5 100X Cargo Way 121 5 1 9     8 3x3   6016762.06772 2099192.87656 37.744924332395 -122.38470767871999 (37.744924332395, -122.38470767872)
140157 6099 6 40 500X 08th St 1 5 1 1     18 18   6010526.812454099 2109340.6023904 37.772440902057795 -122.406983260044 (37.7724409020578, -122.406983260044)
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)
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)
120905 9746 1 272 710X McAllister St 2 5 1 1   01/21/1998 12:00:00 AM 6 4x4   6005653.6676 2112008.06895 37.779491220069296 -122.424029686189 (37.7794912200693, -122.424029686189)
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)
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)
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)
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)
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)
145604 10747 3 39 1120X Hudson Ave 7 5 1 2     12 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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
94567 16912 1 70 474 Oak St 1 5 1 1     10 3X3   6004730.16481 2110223.37403 37.774538702608396 -122.42709732349701 (37.7745387026084, -122.427097323497)
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)
123906 16933 1 43 530 Oak St 1 5 1 1     24 3X3   6004214.004269999 2110149.1693700003 37.7743057532085 -122.42887753201401 (37.7743057532085, -122.428877532014)
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)
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)
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)
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)
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)
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)
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)
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)
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)
20727 18395 1 21 1001X Potrero Ave 2 5 1 8     18 3x3   6010583.3123699995 2102829.86253 37.7545670450388 -122.406328995892 (37.7545670450388, -122.406328995892)
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)
18091 18397 1 21 1001X Potrero Ave 4 5 1 8     18 3X3   6010576.96525 2102937.51144 37.7548622699958 -122.406358530544 (37.7548622699958, -122.406358530544)
20353 18398 1 21 1001X Potrero Ave 5 5 1 8   05/23/1997 12:00:00 AM 3 3X3   6010574.371780001 2102982.33848 37.7549852100133 -122.40637065790101 (37.7549852100133, -122.406370657901)
126196 18399 1 21 999X Potrero Ave 6 5 1 8     24 4x4   6010520.259169 2103656.1388783003 37.7568322886407 -122.406605275364 (37.7568322886407, -122.406605275364)
138503 18401 1 21 999X Potrero Ave 8 5 1 8     18 4x4   6010520.259169 2103656.1388783003 37.7568322886407 -122.406605275364 (37.7568322886407, -122.406605275364)
22206 18402 1 21 1001X Potrero Ave 9 5 1 8     18 3x3   6010563.4475 2103210.4803400002 37.755611025734 -122.40642451198299 (37.755611025734, -122.406424511983)
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)
21450 18404 1 21 1001X Potrero Ave 11 5 1 8     12 3x3   6010558.96581 2103310.46639 37.755885314463605 -122.40644705620001 (37.7558853144636, -122.4064470562)
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)
20860 18406 1 21 1001X Potrero Ave 13 5 1 8     24 3x3   6010555.16427 2103408.27395 37.7561536595775 -122.406467094883 (37.7561536595775, -122.406467094883)
17355 18407 1 21 1001X Potrero Ave 14 5 1 8   06/02/1992 12:00:00 AM 12 3X3   6010549.786619999 2103464.28095 37.7563071414784 -122.4064896391 (37.7563071414784, -122.4064896391)
128737 18408 1 21 999X Potrero Ave 15 5 1 8   05/23/1997 12:00:00 AM 18 2X4   6010520.259169 2103656.1388783003 37.7568322886407 -122.406605275364 (37.7568322886407, -122.406605275364)
92972 18426 1 21 1001X Potrero Ave 1 5 1 8   01/20/2016 12:00:00 AM 30 3X3   6010537.158904701 2103412.4254884 37.75616405148111 -122.406529656376 (37.7561640514811, -122.406529656376)
107467 18427 1 21 1001X Potrero Ave 2 5 1 8     40 3X3   6010537.158904701 2103412.4254884 37.75616405148111 -122.406529656376 (37.7561640514811, -122.406529656376)
99627 18428 1 21 1001X Potrero Ave 3 5 1 8     24 3X3   6010537.158904701 2103412.4254884 37.75616405148111 -122.406529656376 (37.7561640514811, -122.406529656376)
103504 18429 1 21 1001X Potrero Ave 4 5 1 8     30 3x3   6010537.158904701 2103412.4254884 37.75616405148111 -122.406529656376 (37.7561640514811, -122.406529656376)
112444 18430 1 21 1001X Potrero Ave 5 5 1 8     30 3X3   6010537.158904701 2103412.4254884 37.75616405148111 -122.406529656376 (37.7561640514811, -122.406529656376)
142641 18431 1 21 1001X Potrero Ave 6 5 1 8   01/20/2016 12:00:00 AM 24 3X3   6010537.158904701 2103412.4254884 37.75616405148111 -122.406529656376 (37.7561640514811, -122.406529656376)
76011 18432 1 21 1001X Potrero Ave 7 5 1 8   01/20/2016 12:00:00 AM 40 3X3   6010537.158904701 2103412.4254884 37.75616405148111 -122.406529656376 (37.7561640514811, -122.406529656376)
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)
90536 19034 1 84 3192 Sacramento St 2 5 1 1     12 2X2   5999529.89099 2115397.3219999997 37.7884495878023 -122.445458129536 (37.7884495878023, -122.445458129536)
100165 21796 1 15 2600X Taylor St 1 5 1 1   01/22/2016 12:00:00 AM 3 3X3   6008553.39113 2121935.04647 37.806911549800795 -122.414700989571 (37.8069115498008, -122.414700989571)
126832 21800 1 15 2600X Taylor St 5 5 1 1   01/22/2016 12:00:00 AM 12 3X3   6008553.39113 2121935.04647 37.806911549800795 -122.414700989571 (37.8069115498008, -122.414700989571)
80999 21801 1 15 2600X Taylor St 6 5 1 1   01/22/2016 12:00:00 AM 25 3X3   6008553.39113 2121935.04647 37.806911549800795 -122.414700989571 (37.8069115498008, -122.414700989571)
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)
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)
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)
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)
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)
79579 25482 1 21 999X Potrero Ave 16 5 1 8     18 3x3   6010520.259169 2103656.1388783003 37.7568322886407 -122.406605275364 (37.7568322886407, -122.406605275364)
92671 25483 1 21 999X Potrero Ave 17 5 1 8     12 3X3   6010520.259169 2103656.1388783003 37.7568322886407 -122.406605275364 (37.7568322886407, -122.406605275364)
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)
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)
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)
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)
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)
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)
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)
Powered by Datasette · Query took 11.128ms · Data source: data.sfgov.org