sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
93668 48814 1 82 1082Street Pennsylvania Ave 24 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
169823 197148 2 82 65 Whitney Young Cir 24 1 1 1     2 Width 3ft   6017233.106869999 2094952.3109 37.7333066302946 -122.382783854412 (37.7333066302946, -122.382783854412)
116610 48792 1 82 1082Street Pennsylvania Ave 23 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
33109 197147 2 82 65 Whitney Young Cir 22 1 1 1     3 Width 3ft   6017204.67342 2094944.70699 37.7332841805136 -122.38288162868099 (37.7332841805136, -122.382881628681)
127193 48801 1 82 1082Street Pennsylvania Ave 22 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
124980 48800 1 82 1082Street Pennsylvania Ave 21 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
95001 48798 1 82 1082Street Pennsylvania Ave 20 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
115877 93831 1 82 178 Bluxome St 20 1 1 1   04/05/2010 12:00:00 AM   3x3 Permit Number 53343 6012557.4 2110038.2 37.7744697656056 -122.40000821426001 (37.7744697656056, -122.40000821426)
103218 48813 1 82 1082Street Pennsylvania Ave 19 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
144943 93830 1 82 178 Bluxome St 19 1 1 1   04/05/2010 12:00:00 AM   3x3 Permit Number 53343 6012557.4 2110038.2 37.7744697656056 -122.40000821426001 (37.7744697656056, -122.40000821426)
9464 24167 1 82 110X Whitney Young Cir 18 1 1 1   01/01/2011 12:00:00 AM 2 3x3   6016346.0952597 2096044.1423308998 37.736255534298 -122.38592660691401 (37.736255534298, -122.385926606914)
108677 93829 1 82 178 Bluxome St 18 1 1 1   04/05/2010 12:00:00 AM   3x3 Permit Number 53343 6012557.4 2110038.2 37.7744697656056 -122.40000821426001 (37.7744697656056, -122.40000821426)
119141 48803 1 82 1082Street Pennsylvania Ave 18 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
188730 136221 2 82 2901 Steiner St 18 1 1 1     10 Width 3ft   6002012.26452 2118128.8819999998 37.7960911433324 -122.437065166822 (37.7960911433324, -122.437065166822)
56408 197131 2 82 400 Newhall St 17 4 1 1     5 Width 3ft   6015885.54456 2097735.3383299997 37.740873716654 -122.38763689115 (37.740873716654, -122.38763689115)
79486 48797 1 82 1082Street Pennsylvania Ave 17 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
89401 93828 1 82 178 Bluxome St 17 1 1 1   04/05/2010 12:00:00 AM   3x3 Permit Number 53343 6012557.4 2110038.2 37.7744697656056 -122.40000821426001 (37.7744697656056, -122.40000821426)
9206 24109 1 82 105X Whitney Young Cir 16 1 1 1   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.0813580002 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885)
73028 197130 2 82 400 Newhall St 16 4 1 1     5 Width 3ft   6015893.1870800005 2097747.64492 37.7409079313583 -122.38761132431299 (37.7409079313583, -122.387611324313)
102094 93827 1 82 178 Bluxome St 16 1 1 1   04/05/2010 12:00:00 AM   3x3 Permit Number 53343 6012557.4 2110038.2 37.7744697656056 -122.40000821426001 (37.7744697656056, -122.40000821426)
105017 48796 1 82 1082Street Pennsylvania Ave 16 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
171836 197146 2 82 65 Whitney Young Cir 16 1 1 1     2 Width 3ft   6017111.39408 2094922.05635 37.733216832081396 -122.383202548153 (37.7332168320814, -122.383202548153)
87368 48795 1 82 1082Street Pennsylvania Ave 15 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
100700 93826 1 82 178 Bluxome St 15 1 1 1   04/05/2010 12:00:00 AM   3x3 Permit Number 53343 6012557.4 2110038.2 37.7744697656056 -122.40000821426001 (37.7744697656056, -122.40000821426)
9055 24107 1 82 105X Whitney Young Cir 14 1 1 1   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.0813580002 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885)
61184 197150 2 82 102 Whitney Young Cir 14 1 1 1     1 Width 3ft   6016678.04362 2095528.85162 37.7348590139212 -122.38474302838999 (37.7348590139212, -122.38474302839)
114793 48794 1 82 1082Street Pennsylvania Ave 14 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
125824 21211 3 82 2392X Sunset Blvd 14 1 1 2     3 60   5984971.116957701 2098921.2732344 37.7423691180201 -122.494613333405 (37.7423691180201, -122.494613333405)
126822 93825 1 82 178 Bluxome St 14 1 1 1   04/05/2010 12:00:00 AM   3x3 Permit Number 53343 6012557.4 2110038.2 37.7744697656056 -122.40000821426001 (37.7744697656056, -122.40000821426)
161525 136220 2 82 2901 Steiner St 14 1 1 1     9 Width 3ft   6002011.27576 2118147.89877 37.7961433022242 -122.43706995031201 (37.7961433022242, -122.437069950312)
14061 24180 3 82 101X Whitney Young Cir 13 1 1 2     30 3x3   6016621.33395 2095295.74377 37.7342158098126 -122.384922860422 (37.7342158098126, -122.384922860422)
16023 30631 1 82 1690 Folsom St 13 1 1 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008010.753 2108447.9304 37.769848719225294 -122.415623364383 (37.7698487192253, -122.415623364383)
25564 197127 2 82 101 Newhall St 13 4 1 1     3 Width 3ft   6017303.080490001 2098110.9339400004 37.7419834431736 -122.382761660942 (37.7419834431736, -122.382761660942)
36178 197095 2 82 1098 Pennsylvania Ave 13 9 1 1     4 Width 5ft   6014479.30677 2102077.89395 37.7527194688438 -122.39280290452601 (37.7527194688438, -122.392802904526)
97538 48793 1 82 1082Street Pennsylvania Ave 13 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
97607 4924 3 82 195X Newhall St 13 1 1 2   03/30/2006 12:00:00 AM 3 3X3   6017015.097207401 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687)
109191 24106 3 82 105X Whitney Young Cir 13 1 1 2   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.0813580002 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885)
145886 93824 1 82 178 Bluxome St 13 1 1 1   04/05/2010 12:00:00 AM   3x3 Permit Number 53343 6012557.4 2110038.2 37.7744697656056 -122.40000821426001 (37.7744697656056, -122.40000821426)
15041 24179 3 82 101X Whitney Young Cir 12 1 1 2   03/29/1990 12:00:00 AM 12 5x3   6016625.58798 2095312.02915 37.7342607615082 -122.38490928693199 (37.7342607615082, -122.384909286932)
15083 30628 1 82 1690 Folsom St 12 1 1 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008014.7624 2108466.4739 37.769899860698295 -122.415610809035 (37.7698998606983, -122.415610809035)
34091 197124 2 82 2 Napoleon St 12 4 1 1     3 Width 4ft   6013733.0286 2100130.5529400003 37.747331007214896 -122.395247287949 (37.7473310072149, -122.395247287949)
45418 197094 2 82 1098 Pennsylvania Ave 12 9 1 1     5 Width 5ft   6014478.47867 2102089.9100099998 37.7527524163908 -122.392806608832 (37.7527524163908, -122.392806608832)
109207 21209 3 82 2392X Sunset Blvd 12 1 1 2     3 60   5984971.116957701 2098921.2732344 37.7423691180201 -122.494613333405 (37.7423691180201, -122.494613333405)
113270 48802 1 82 1082Street Pennsylvania Ave 12 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
120937 120517 2 82 888 Brannan St 12 1 1 1       3x3   6011018.0 2109170.0 37.771999940852105 -122.40527216982201 (37.7719999408521, -122.405272169822)
142790 93823 1 82 178 Bluxome St 12 1 1 1   04/05/2010 12:00:00 AM   3x3 Permit Number 53343 6012557.4 2110038.2 37.7744697656056 -122.40000821426001 (37.7744697656056, -122.40000821426)
160304 247591 2 82 800 Tompkins Ave 12 7 1 1     10     6008974.65943 2096434.5209700002 37.736916732029705 -122.411440373668 (37.7369167320297, -122.411440373668)
9227 24151 1 82 100X Whitney Young Cir 11 1 1 1   03/11/2006 12:00:00 AM 3 3x3   6016357.373923 2096088.8828188 37.736379006835996 -122.385890729183 (37.736379006836, -122.385890729183)
14634 24178 3 82 101X Whitney Young Cir 11 1 1 2   02/15/2001 12:00:00 AM 4 4x3   6016619.186290001 2095310.93644 37.7342574070589 -122.384931343733 (37.7342574070589, -122.384931343733)
16359 30629 1 82 1690 Folsom St 11 1 1 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008019.272999999 2108482.0104 37.7699427738264 -122.415596307092 (37.7699427738264, -122.415596307092)
77592 120516 2 82 888 Brannan St 11 1 1 1       3x3   6011018.0 2109170.0 37.771999940852105 -122.40527216982201 (37.7719999408521, -122.405272169822)
89744 93822 1 82 178 Bluxome St 11 1 1 1   04/05/2010 12:00:00 AM   3x3 Permit Number 53343 6012557.4 2110038.2 37.7744697656056 -122.40000821426001 (37.7744697656056, -122.40000821426)
93857 8232 3 82 1500X Galvez Ave 11 1 1 2   11/13/1992 12:00:00 AM 6 3x3   6016396.247314 2097296.3974116 37.739696749128896 -122.385840466933 (37.7396967491289, -122.385840466933)
112016 48804 1 82 1082Street Pennsylvania Ave 11 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
117485 87401   82 400X Monterey Blvd 11 11 1 2   03/17/2008 12:00:00 AM 3 3x3   5999413.960874 2094696.855647 37.7316046219852 -122.44437099815 (37.7316046219852, -122.44437099815)
135664 213984 2 82 201 Lobos St 11 1 1 1     1 Width 3ft   5994978.50476 2088691.4656200001 37.7148611951759 -122.459270414704 (37.7148611951759, -122.459270414704)
143816 21208 3 82 2392X Sunset Blvd 11 1 1 2     3 60   5984971.116957701 2098921.2732344 37.7423691180201 -122.494613333405 (37.7423691180201, -122.494613333405)
165428 197129 2 82 400 Newhall St 11 4 1 1     5 Width 3ft   6015974.4503 2097856.83037 37.741212233148495 -122.387337958305 (37.7412122331485, -122.387337958305)
181135 197093 2 82 1098 Pennsylvania Ave 11 9 1 1     6 Width 5ft   6014477.98301 2102105.11898 37.7527941494528 -122.392809386851 (37.7527941494528, -122.392809386851)
13407 16508 3 82 325 Newhall St 10 1 1 2     12 3x3   6016639.93914 2098306.03692 37.7424824967653 -122.385068203435 (37.7424824967653, -122.385068203435)
13898 30637 1 82 1690 Folsom St 10 1 1 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008025.7883 2108500.0528 37.7699926802506 -122.415575048334 (37.7699926802506, -122.415575048334)
14570 16549 1 82 400X Newhall St 10 1 1 1     6 3x3   6015994.10911 2097882.11034 37.7412827355083 -122.38727174751001 (37.7412827355083, -122.38727174751)
66294 213983 2 82 201 Lobos St 10 1 1 1     1 Width 3ft   5994955.32932 2088691.9508900002 37.7148611951615 -122.45935055329201 (37.7148611951615, -122.459350553292)
80482 48805 1 82 1082Street Pennsylvania Ave 10 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
83194 87400   82 400X Monterey Blvd 10 11 1 2   03/17/2008 12:00:00 AM 3 3x3   5999413.960874 2094696.855647 37.7316046219852 -122.44437099815 (37.7316046219852, -122.44437099815)
83756 120515 2 82 888 Brannan St 10 1 1 1       3x3   6011018.0 2109170.0 37.771999940852105 -122.40527216982201 (37.7719999408521, -122.405272169822)
98467 24177 3 82 95X Whitney Young Cir 10 1 1 2   03/11/2006 12:00:00 AM 4 3X3   6016412.1769872 2096105.6107163997 37.736427970914 -122.38570241578998 (37.736427970914, -122.38570241579)
105931 24194 3 82 55X Whitney Young Cir 10 1 1 2   01/01/2008 12:00:00 AM 3 3x3   6016412.1769872 2096105.6107163997 37.736427970914 -122.38570241578998 (37.736427970914, -122.38570241579)
125612 93821 1 82 178 Bluxome St 10 1 1 1   04/05/2010 12:00:00 AM   3x3 Permit Number 53343 6012557.4 2110038.2 37.7744697656056 -122.40000821426001 (37.7744697656056, -122.40000821426)
132810 138448 2 82 1820 POST ST 10 1 1 1     7 Width 0ft   6003221.0376 2114171.7858 37.7852946007927 -122.43259977843901 (37.7852946007927, -122.432599778439)
149097 197092 2 82 1098 Pennsylvania Ave 10 9 1 1     5 Width 5ft   6014476.97343 2102121.40509 37.752838811567 -122.392814017467 (37.752838811567, -122.392814017467)
152226 197145 2 82 65 Whitney Young Cir 10 1 1 1     4 Width 4ft   6016890.6542 2094912.19179 37.7331775451961 -122.38396502668199 (37.7331775451961, -122.383965026682)
152237 213961 2 82 360 Faxon Ave 10 1 1 1     5 Width 3ft   5994775.27388 2091185.74798 37.7216982145873 -122.460153459921 (37.7216982145873, -122.460153459921)
666 237028 3 82 8 Octavia St 9 4 1 2   04/15/2017 01:55:00 PM 3 Width 6ft   6005756.39315 2109517.28856 37.7726579404383 -122.423497186858 (37.7726579404383, -122.423497186858)
9197 24149 1 82 100X Whitney Young Cir 9 1 1 1   03/11/2006 12:00:00 AM 3 3x3   6016357.373923 2096088.8828188 37.736379006835996 -122.385890729183 (37.736379006836, -122.385890729183)
25710 138447 2 82 1820 POST ST 9 1 1 1     2 Width 0ft   6003269.2692 2114178.8859 37.7853168309586 -122.432433419204 (37.7853168309586, -122.432433419204)
28648 213960 2 82 360 Faxon Ave 9 1 1 1     13 Width 3ft   5994774.81066 2091163.6355700002 37.7216374725616 -122.460153459937 (37.7216374725616, -122.460153459937)
75202 197123 2 82 2 Napoleon St 9 4 1 1     4 Width 4ft   6013823.14287 2100134.6938099996 37.7473473883884 -122.39493596693 (37.7473473883884, -122.39493596693)
80405 16518 3 82 330 Newhall St 9 1 1 2   03/30/2006 12:00:00 AM 3 3X3   6016409.970087901 2098376.06541 37.742662057146795 -122.385868255606 (37.7426620571468, -122.385868255606)
84970 93820 1 82 178 Bluxome St 9 1 1 1   04/05/2010 12:00:00 AM   3x3 Permit Number 53343 6012557.4 2110038.2 37.7744697656056 -122.40000821426001 (37.7744697656056, -122.40000821426)
89430 16558 3 82 500X Newhall St 9 1 1 2   12/27/1997 12:00:00 AM 3 3x3   6016006.287148001 2097894.9109735 37.74131855784729 -122.387230532448 (37.7413185578473, -122.387230532448)
96662 87399   82 400X Monterey Blvd 9 11 1 2   03/17/2008 12:00:00 AM 3 3x3   5999413.960874 2094696.855647 37.7316046219852 -122.44437099815 (37.7316046219852, -122.44437099815)
107290 48806 1 82 1082Street Pennsylvania Ave 9 1 1 1   11/06/2002 12:00:00 AM     Permit Number 46042 6014495.63347758 2102077.94418173 37.7527205135809 -122.39274644691601 (37.7527205135809, -122.392746446916)
108930 30630 1 82 1690 Folsom St 9 1 1 1   01/30/1995 12:00:00 AM 3 3x3 Permit Number 34583 6008012.82240629 2108413.03711614 37.7697530267823 -122.41561373544901 (37.7697530267823, -122.415613735449)
124104 213976 2 82 1061 Capitol Ave 9 1 1 1     11 Width 3ft   5995023.46765 2090970.5982400002 37.7211217374705 -122.459279952923 (37.7211217374705, -122.459279952923)
132220 102493 1 82 2001 McAllister St 9 1 1 1     8 3x3   5999461.6709 2111166.2585 37.7768282889466 -122.445389813922 (37.7768282889466, -122.445389813922)
135819 197165 2 82 15 Reuel Ct 9 1 1 1     5 Width 3ft   6017366.51517 2096051.5594799998 37.7363323183867 -122.382399074074 (37.7363323183867, -122.382399074074)
150336 213982 2 82 201 Lobos St 9 1 1 1     1 Width 3ft   5994935.45629 2088691.9546700001 37.714860062915 -122.459419242599 (37.714860062915, -122.459419242599)
167314 138129 2 82 1850 FILLMORE ST 9 1 1 1     2 Width 0ft   6003011.9121 2114750.6049 37.7868720297123 -122.433364664404 (37.7868720297123, -122.433364664404)
181973 197091 2 82 1098 Pennsylvania Ave 9 9 1 1     7 Width 5ft   6014475.63706 2102134.7648099996 37.7528754202862 -122.39281957348601 (37.7528754202862, -122.392819573486)
9107 24086 1 82 141X Whitney Young Cir 8 1 1 1   03/11/2006 12:00:00 AM 3 3X3   6016393.5495733 2095983.6738742 37.7360921261264 -122.38575832291299 (37.7360921261264, -122.385758322913)
10418 77647 3 82 1300X Silliman St 8 1 1 4 2 10/26/1984 12:00:00 AM 10 3x3   6006841.82551 2093150.82877 37.7277805724005 -122.418581759638 (37.7277805724005, -122.418581759638)
15489 30626 1 82 1690 Folsom St 8 1 1 1   02/24/2016 12:00:00 AM 3 3x3 Permit Number 769481 6008034.8095 2108530.1235 37.7700757544141 -122.415545973379 (37.7700757544141, -122.415545973379)
26410 138128 2 82 1850 FILLMORE ST 8 1 1 1     4 Width 0ft   6003016.992000001 2114720.1259 37.786788630304706 -122.433344910367 (37.7867886303047, -122.433344910367)
51590 138446 2 82 1820 POST ST 8 1 1 1     6 Width 0ft   6003295.7109 2114182.3135 37.7853277416205 -122.43234218389799 (37.7853277416205, -122.432342183898)
59382 213975 2 82 1061 Capitol Ave 8 1 1 1     11 Width 3ft   5995024.51997 2091003.2487299999 37.7212114484221 -122.45927867859501 (37.7212114484221, -122.459278678595)
59671 213985 2 82 431 Capitol Ave 8 1 1 1     1 Width 3ft   5995022.34889 2088455.31671 37.714215306566 -122.45910178282301 (37.714215306566, -122.459101782823)
64317 141943 2 82 1101 GOLDEN GATE AVE 8 1 1 1     9 Width 0ft   6004162.7275 2112162.4936 37.77983094307 -122.42919849613199 (37.77983094307, -122.429198496132)
65412 136219 2 82 2901 Steiner St 8 1 1 1     9 Width 3ft   6002007.17609 2118176.89143 37.79622267548079 -122.437086212761 (37.7962226754808, -122.437086212761)
85555 90388 1 82 20 12th St 8 1 1 1   02/21/2008 12:00:00 AM 3 3x3   6006777.292282 2110019.638696 37.7740948433326 -122.42000143597099 (37.7740948433326, -122.420001435971)
88975 93819 1 82 178 Bluxome St 8 1 1 1   04/05/2010 12:00:00 AM   3x3 Permit Number 53343 6012557.4 2110038.2 37.7744697656056 -122.40000821426001 (37.7744697656056, -122.40000821426)
Powered by Datasette · Query took 9.931ms · Data source: data.sfgov.org