sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
10299 1295 3 39 4000X Alemany Blvd 3 11 1 2     25 10   5991914.74417 2087134.82891 37.710410426081 -122.46974669545901 (37.710410426081, -122.469746695459)
10785 1296 3 39 4000X Alemany Blvd 4 11 1 2     35 10   5991907.39965 2087130.17274 37.710397216839496 -122.46977174067499 (37.7103972168395, -122.469771740675)
11437 1297 3 39 4000X Alemany Blvd 5 11 1 2     25 10   5991899.37983 2087126.21827 37.7103858952584 -122.46979917089199 (37.7103858952584, -122.469799170892)
10727 1298 3 39 4000X Alemany Blvd 6 11 1 2     25 10   5991889.9079 2087118.85792 37.7103651380077 -122.46983137204599 (37.7103651380077, -122.469831372046)
10821 1299 3 39 4000X Alemany Blvd 7 11 1 2     40 10   5991881.88808 2087114.90346 37.7103538164401 -122.46985880224301 (37.7103538164401, -122.469858802243)
87838 1360 1 39 1 Amethyst Way 1 1 1 1     18 3X3   5999260.364281501 2099960.847629 37.7460495263909 -122.445280344305 (37.7460495263909, -122.445280344305)
124289 2008 3 39 500X Bosworth St 1 11 1 2     18 12x100   6002728.1222807 2095276.2570246002 37.733384060718 -122.432954679755 (37.733384060718, -122.432954679755)
19231 2011 3 39 500X Bosworth St 4 11 1 2     12 10   6002543.1242 2095301.43659 37.7334427031002 -122.433596068029 (37.7334427031002, -122.433596068029)
21568 2012 3 39 500X Bosworth St 5 11 1 2     18 10   6002566.51434 2095294.967 37.7334262662011 -122.43351473961599 (37.7334262662011, -122.433514739616)
17146 2013 3 39 500X Bosworth St 6 11 1 2     12 10   6002577.1884699995 2095292.92439 37.7334212632741 -122.433477690263 (37.7334212632741, -122.433477690263)
19416 2014 3 39 500X Bosworth St 7 11 1 2     18 10   6002609.44021 2095285.23051 37.733401967419205 -122.43336563743799 (37.7334019674192, -122.433365637438)
20093 2015 3 39 500X Bosworth St 8 11 1 2     12 10   6002627.0989 2095279.66022 37.733387674484604 -122.433304188563 (37.7333876744846, -122.433304188563)
21291 2046 3 39 701X Bosworth St 1 1 1 2     6 3X3   6001912.87216 2095420.3332200001 37.733733385587 -122.43578352768299 (37.733733385587, -122.435783527683)
128637 2140 3 39 1100X Bosworth St 1 11 1 2     18 4   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
121107 2142 3 39 1100X Bosworth St 3 11 1 2     18 4   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
116746 2143 3 39 1100X Bosworth St 4 11 1 2     18 6   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
97478 2145 3 39 1100X Bosworth St 6 11 1 2     6 6   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
91725 2147 3 39 1100X Bosworth St 8 11 1 2     18 6   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
76168 2148 3 39 1100X Bosworth St 9 11 1 2     12 6   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
88140 2149 3 39 1100X Bosworth St 10 11 1 2     24 6   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
112688 2150 3 39 1100X Bosworth St 11 11 1 2   04/12/2006 12:00:00 AM 24 6   6001043.628513 2095761.867481 37.734621744877295 -122.438813219285 (37.7346217448773, -122.438813219285)
17421 4245 3 39 4038 Cesar Chavez St 1 1 1 2     12 3X3   6003639.78589 2100421.5344700003 37.7475634792894 -122.430169743652 (37.7475634792894, -122.430169743652)
20209 4252 3 39 4072 Cesar Chavez St 1 1 1 2     12 3X3   6003430.396430001 2100411.11399 37.747523005287206 -122.430893055767 (37.7475230052872, -122.430893055767)
117201 4253 1 39 4078 Cesar Chavez St 2 1 1 1     12 3X3   6003401.3861068 2100414.7966430997 37.7475314732241 -122.430993634389 (37.7475314732241, -122.430993634389)
23224 4372 3 39 1007 Chenery St 1 1 1 2     17 3X3   6000961.422590001 2096155.46194 37.7356977864326 -122.439125632357 (37.7356977864326, -122.439125632357)
22187 4461 3 39 1451 Church St 1 1 1 2     18 4X4   6004572.77209 2100404.42204 37.74756929159079 -122.42694231424299 (37.7475692915908, -122.426942314243)
18999 4466 1 39 1484 Church St 1 1 1 1     18 4X4   6004525.42539 2100206.65772 37.747023599154204 -122.427091952431 (37.7470235991542, -122.427091952431)
16971 4468 3 39 1497 Church St 1 1 1 2     18 3X3   6004583.98516 2100211.8834700002 37.7470412591526 -122.426889829809 (37.7470412591526, -122.426889829809)
17710 4470 1 39 1500 Church St 2 1 1 1     12 3X3   6004528.8343 2100105.60966 37.746746337268206 -122.42707296863999 (37.7467463372682, -122.42707296864)
21257 4479 1 39 1542 Church St 1 1 1 1     18 4X4   6004543.28364 2099929.0819200003 37.7462624498637 -122.427010433384 (37.7462624498637, -122.427010433384)
49627 4480 3 39 1544 Church St 1 1 1 2     18 3X3   6004537.43405 2099923.54921 37.7462469275435 -122.427030266568 (37.7462469275435, -122.427030266568)
19220 4482 1 39 1551 Church St 1 1 1 1     12 3X3   6004606.71516 2099825.83197 37.7459825358766 -122.426783743093 (37.7459825358766, -122.426783743093)
14426 4895 3 39 10 Rosie Lee Ln 1 1 1 2   04/19/1993 12:00:00 AM 12 3X4   6018140.882180001 2094365.07214 37.7317442992597 -122.379604608867 (37.7317442992597, -122.379604608867)
85254 6176 3 39 1075 Ellis St 11 1 1 2     24 3X3   6005893.15301 2113273.27935 37.782978696051 -122.423291166859 (37.782978696051, -122.423291166859)
85139 6395 3 39 5X Rosie Lee Ln 1 1 1 2   04/19/1993 12:00:00 AM 3 3X4   6018168.8629005 2094369.8502073998 37.7317589621466 -122.379508204595 (37.7317589621466, -122.379508204595)
5531 7687 1 39 521 Francisco St 3 1 1 1     12 3X3   6008787.0132 2121079.8095 37.8045764073538 -122.413831954826 (37.8045764073538, -122.413831954826)
139368 8587 3 39 2355X Geary Blvd 1 1 1 2     6 3X3   6000490.27762 2113338.60243 37.7828516547291 -122.44198752522699 (37.7828516547291, -122.441987525227)
95728 8589 3 39 2355X Geary Blvd 3 1 1 2     6 3X3   6000490.27762 2113338.60243 37.7828516547291 -122.44198752522699 (37.7828516547291, -122.441987525227)
104800 8590 3 39 2355X Geary Blvd 4 1 1 2     36 3X3   6000490.27762 2113338.60243 37.7828516547291 -122.44198752522699 (37.7828516547291, -122.441987525227)
38339 8592 3 39 2355X Geary Blvd 6 1 1 2     6 3X3   6000490.27762 2113338.60243 37.7828516547291 -122.44198752522699 (37.7828516547291, -122.441987525227)
86336 8593 3 39 2355X Geary Blvd 7 1 1 2     12 3X3   6000490.27762 2113338.60243 37.7828516547291 -122.44198752522699 (37.7828516547291, -122.441987525227)
112808 8594 3 39 2355X Geary Blvd 8 1 1 2     6 3X3   6000490.27762 2113338.60243 37.7828516547291 -122.44198752522699 (37.7828516547291, -122.441987525227)
144450 8595 3 39 2355X Geary Blvd 9 1 1 2     12 3X3   6000490.27762 2113338.60243 37.7828516547291 -122.44198752522699 (37.7828516547291, -122.441987525227)
81260 10730 3 39 1100 Hudson Ave 1 1 1 2     12 3X4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
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)
84760 10732 3 39 1100 Hudson Ave 3 1 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)
79233 10737 3 39 1120X Hudson Ave 34 1 1 2     16 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)
99737 10739 3 39 1120X Hudson Ave 11 1 1 2     16 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
94761 10740 3 39 1120X Hudson Ave 1 1 1 2     8 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
82997 10741 3 39 1120X Hudson Ave 2 1 1 2     18 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
117900 10742 3 39 1120X Hudson Ave 3 1 1 2     18 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
91396 10743 3 39 1120X Hudson Ave 4 1 1 2     18 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
106941 10744 3 39 1120X Hudson Ave 5 1 1 2     18 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
113353 10745 3 39 1120X Hudson Ave 15 1 1 2     20 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
105607 10746 3 39 1120X Hudson Ave 12 1 1 2     15 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)
115375 10748 3 39 1120X Hudson Ave 25 1 1 2     25 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
127830 10751 3 39 1120X Hudson Ave 20 1 1 2     14 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
18452 10752 3 39 1120X Hudson Ave 26 1 1 2     20 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
108965 10753 3 39 1120X Hudson Ave 16 1 1 2     20 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)
141300 10755 3 39 1120X Hudson Ave 44 1 1 2     18 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
47273 10756 3 39 1120X Hudson Ave 37 1 1 2     20 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
105402 10757 3 39 1120X Hudson Ave 10 1 1 2     15 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)
99336 10761 3 39 1120X Hudson Ave 14 1 1 2   01/11/1999 12:00:00 AM 8 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
120117 10762 3 39 1120X Hudson Ave 24 1 1 2     18 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)
143187 10764 3 39 1120X Hudson Ave 22 1 1 2     14 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
102867 10766 3 39 1120X Hudson Ave 40 1 1 2     18 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)
139201 10772 3 39 1120X Hudson Ave 35 1 1 2     18 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)
102487 10778 3 39 1200X Hudson Ave 1 1 1 2     12 3x4   6017715.991199099 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913)
94331 10779 3 39 1200X Hudson Ave 2 1 1 2     18 3x4   6017715.991199099 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913)
88915 10784 3 39 1200X Hudson Ave 7 1 1 2     24 3x4   6017715.991199099 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913)
90150 10785 3 39 1200X Hudson Ave 8 1 1 2     18 3x4   6017715.991199099 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913)
146047 10786 3 39 1200X Hudson Ave 9 1 1 2     18 3x4   6017715.991199099 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913)
112033 10798 3 39 1139X Hudson Ave 6 1 1 2     12 3x4   6017482.97201 2094892.1900099998 37.7331553517533 -122.381915812499 (37.7331553517533, -122.381915812499)
77931 10799 3 39 1139X Hudson Ave 7 1 1 2     10 3x4   6017498.59701 2094875.2630099999 37.733109736403705 -122.381860615174 (37.7331097364037, -122.381860615174)
128914 10800 3 39 1139X Hudson Ave 8 1 1 2     12 3X4   6017507.71201 2094860.9400099998 37.7330709116139 -122.38182810599501 (37.7330709116139, -122.381828105995)
104681 10805 3 39 1139X Hudson Ave 13 1 1 2   03/29/1990 12:00:00 AM 12 3x4   6017572.81601 2094794.5340099998 37.732892168704204 -122.381598405298 (37.7328921687042, -122.381598405298)
142398 10808 3 39 1139X Hudson Ave 15 1 1 2     12 3X4   6017594.95201 2094772.3990099998 37.7328326125475 -122.381520335899 (37.7328326125475, -122.381520335899)
86062 10809 3 39 1139X Hudson Ave 16 1 1 2     12 3X4   6017607.97201 2094759.3780099999 37.7327975782942 -122.381474416821 (37.7327975782942, -122.381474416821)
72160 10810 3 39 1139X Hudson Ave 17 1 1 2     12 3x4   6017615.78501 2094776.3050099998 37.7328444878546 -122.38144858171499 (37.7328444878546, -122.381448581715)
126260 10819 3 39 1139X Hudson Ave 26 1 1 2     12 3X4   6017712.13901 2094678.6490099998 37.7325816628845 -122.38110867061701 (37.7325816628845, -122.381108670617)
88419 10839 3 39 1139X Hudson Ave 46 1 1 2     12 3X4   6017986.87901 2094607.0340099998 37.732400183828396 -122.380153842969 (37.7324001838284, -122.380153842969)
108988 10842 3 39 1139X Hudson Ave 49 1 1 2     12 3X4   6018020.73301 2094608.3360099997 37.732405626582796 -122.380036890979 (37.7324056265828, -122.380036890979)
127821 11203 3 39 1001X Ingalls St 1 1 1 2     60 3X4   6018170.9910099 2094117.1281791 37.7310651541831 -122.379483297777 (37.7310651541831, -122.379483297777)
127234 11208 1 39 1001X Ingalls St 6 1 1 1     30 3X4   6018170.9910099 2094117.1281791 37.7310651541831 -122.379483297777 (37.7310651541831, -122.379483297777)
16356 11215 3 39 1050X Ingalls St 1 1 1 2     80 3X4   6018142.31163 2094695.6186 37.732651993985705 -122.37962262229799 (37.7326519939857, -122.379622622298)
14069 11218 3 39 1050X Ingalls St 4 1 1 2     70 3X4   6018145.287959999 2094715.08165 37.73270559986911 -122.379613683941 (37.7327055998691, -122.379613683941)
13889 11219 3 39 1050X Ingalls St 5 1 1 2   10/28/1992 12:00:00 AM 30 3X4   6018141.66576 2094727.81231 37.7327403559813 -122.379627091035 (37.7327403559813, -122.379627091035)
16458 11221 3 39 1050X Ingalls St 7 1 1 2     60 3X4   6018130.45859 2094749.06198 37.7327980852604 -122.379667313208 (37.7327980852604, -122.379667313208)
14846 11225 3 39 1050X Ingalls St 11 1 1 2   10/29/1992 12:00:00 AM 35 3X4   6018100.6161400005 2094835.81488 37.733034645636394 -122.37977651247101 (37.7330346456364, -122.379776512471)
14285 11226 3 39 1050X Ingalls St 12 1 1 2   10/29/1992 12:00:00 AM 35 3X4   6018091.97554 2094860.3210200001 37.7331014580651 -122.379808087687 (37.7331014580651, -122.379808087687)
138594 11229 3 39 1050X Ingalls St 15 1 1 2     45 3X4   6018085.661882901 2094069.8743192002 37.7309306978843 -122.379775016493 (37.7309306978843, -122.379775016493)
126235 11232 3 39 1100X Ingalls St 1 1 1 2     60 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
86825 11235 3 39 1100X Ingalls St 4 1 1 2   01/06/2016 12:00:00 AM 18 3X4   6018021.124713 2094004.401623 37.7307473625426 -122.37999358681499 (37.7307473625426, -122.379993586815)
Powered by Datasette · Query took 11.052ms · Data source: data.sfgov.org