sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
49521 240131 2 82 0 Chattanooga St 3 1 1 1     11 Width 3ft   6004671.7789900005 2103561.17999 37.7562426115098 -122.426824733295 (37.7562426115098, -122.426824733295)
75125 240132 2 82 0 Chattanooga St 4 1 1 1     8 Width 3ft   6004672.38894 2103545.66672 37.7562000502026 -122.42682151911801 (37.7562000502026, -122.426821519118)
154817 240133 2 82 0 Chattanooga St 5 1 1 1     11 Width 3ft   6004672.52486 2103529.70008 37.756156217245604 -122.426819912015 (37.7561562172456, -122.426819912015)
87818 102145 2 82 0X Ford St 2 1 1 1     10 3x3   6003601.0 2105679.0 37.7619970392507 -122.430678972901 (37.7619970392507, -122.430678972901)
103400 102146 2 82 0X Ford St 3 1 1 1     12 3x3   6003601.0 2105679.0 37.7619970392507 -122.430678972901 (37.7619970392507, -122.430678972901)
114315 102144 2 82 0X Ford St 1 1 1 1     12 3x3   6003601.0 2105679.0 37.7619970392507 -122.430678972901 (37.7619970392507, -122.430678972901)
123602 120676 2 82 1 Ford St 1 1 1 1       3x3   6003502.0 2105614.0 37.7618129556584 -122.43101673587799 (37.7618129556584, -122.431016735878)
63119 213926 2 82 1 Hill Point Ave 1 1 1 1     8 Width 3ft   5996340.85636 2106804.33971 37.764672946334294 -122.45587018867501 (37.7646729463343, -122.455870188675)
131145 213991 2 82 1 Merced Ave 2 2 1 1     11 Width 3ft   5995344.90173 2100199.2685 37.7464798897511 -122.458836668093 (37.7464798897511, -122.458836668093)
19725 114507 2 82 10 LOMBARD ST 2 16 1 9       4x4   6011932.0 2120995.0 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468)
70153 179314 2 82 100 Hamilton St 2 1 1 1     8 Width 3ft   6009038.30764 2093734.4569599999 37.7295065063148 -122.411029655989 (37.7295065063148, -122.411029655989)
153317 179315 2 82 100 Hamilton St 3 1 1 1     11 Width 3ft   6009040.95061 2093717.83367 37.729461010514605 -122.411019345266 (37.7294610105146, -122.411019345266)
69300 179323 2 82 100 Merrill St 1 1 1 1     11 Width 3ft   6009520.85663 2094768.8785700002 37.7323738561678 -122.409434403484 (37.7323738561678, -122.409434403484)
179013 179324 2 82 100 Merrill St 2 1 1 1     8 Width 3ft   6009528.37304 2094747.8855599998 37.7323166349901 -122.409406936389 (37.7323166349901, -122.409406936389)
178446 179313 2 82 100 Yale St 4 1 1 1     2 Width 3ft   6006918.398519999 2093488.03593 37.728710780776 -122.418340943684 (37.728710780776, -122.418340943684)
50254 213950 2 82 1006 Capitol Ave 1 1 1 1     4 Width 3ft   5995061.44128 2090626.04133 37.720177849497794 -122.459123753274 (37.7201778494978, -122.459123753274)
67006 240153 2 82 1008 Cole St 1 1 1 1     8 Width 3ft   5998136.29263 2106764.45676 37.764666319205205 -122.449657403985 (37.7646663192052, -122.449657403985)
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)
152901 239239 2 82 101 Scott St 1 4 1 1     20 Width 6ft   6002329.06188 2108869.34471 37.7706848027038 -122.435306320439 (37.7706848027038, -122.435306320439)
167332 136212 2 82 101 Spruce St 3 2 1 1     7 Width 3ft   5997026.477630001 2115953.7993900003 37.7898342954728 -122.454159706 (37.7898342954728, -122.454159706)
178696 136211 2 82 101 Spruce St 2 2 1 1     9 Width 3ft   5997026.34564 2115964.00812 37.7898623183414 -122.454160900321 (37.7898623183414, -122.454160900321)
48422 197116 2 82 1015 Rhode Island St 1 4 1 1     2 Width 3ft   6011950.215340001 2103491.63171 37.75646048668521 -122.40164836548 (37.7564604866852, -122.40164836548)
64108 83143 2 82 101X Whitney Young Cir 2 1 1 1 1 03/17/2006 12:00:00 AM 1     6016637.512159999 2095504.68596 37.7347904181313 -122.384881478104 (37.7347904181313, -122.384881478104)
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)
181078 239315 2 82 1024 Hampshire St 1 1 1 1     3 Width 3ft   6010214.49456 2103222.56761 37.7556246873555 -122.40763215850599 (37.7556246873555, -122.407632158506)
38315 179295 2 82 103 Edinburgh St 1 1 1 1     6 Width 3ft   6004297.98606 2093012.3139099998 37.727256697520204 -122.42736600014 (37.7272566975202, -122.42736600014)
170019 141931 2 82 1050 MCALLISTER ST 6 1 1 1     5 Width 0ft   6004116.6344 2111867.0624 37.7790171527246 -122.42933687953999 (37.7790171527246, -122.42933687954)
185979 141928 2 82 1050 MCALLISTER ST 3 1 1 1     7 Width 0ft   6004234.8996 2111882.5726 37.779066434664294 -122.428928858602 (37.7790664346643, -122.428928858602)
40781 101046 2 82 1050 Sansome St 1 1 1 1     1 3x3 Permit Number 774347 6012049.4869099995 2119300.00717 37.799872179210894 -122.40241656909201 (37.7998721792109, -122.402416569092)
33428 197157 2 82 106 Whitney Young Cir 5 1 1 1     1 Width 3ft   6016598.7871900005 2095669.6865 37.7352413346217 -122.385026857123 (37.7352413346217, -122.385026857123)
173068 197158 2 82 106 Whitney Young Cir 6 1 1 1     2 Width 3ft   6016583.16711 2095682.22839 37.7352749081106 -122.385081735533 (37.7352749081106, -122.385081735533)
29544 213971 2 82 1061 Capitol Ave 4 1 1 1     10 Width 3ft   5995026.07265 2091112.6142099998 37.7215118291791 -122.459281227253 (37.7215118291791, -122.459281227253)
33788 213974 2 82 1061 Capitol Ave 7 1 1 1     7 Width 3ft   5995026.3935 2091022.299 37.7212638636298 -122.459273581222 (37.7212638636298, -122.459273581222)
36604 213973 2 82 1061 Capitol Ave 6 1 1 1     13 Width 3ft   5995027.24606 2091045.4090900002 37.721327367434604 -122.459272306869 (37.7213273674346, -122.459272306869)
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)
69936 213969 2 82 1061 Capitol Ave 2 1 1 1     9 Width 3ft   5995027.18674 2091165.82123 37.7216579869959 -122.459281227274 (37.7216579869959, -122.459281227274)
71421 213970 2 82 1061 Capitol Ave 3 1 1 1     6 Width 3ft   5995027.09423 2091143.79671 37.721597507607996 -122.45927995292699 (37.721597507608, -122.459279952927)
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)
172877 213968 2 82 1061 Capitol Ave 1 1 1 1     10 Width 3ft   5995026.496169999 2091185.65951 37.7217124184688 -122.459285050266 (37.7217124184688, -122.459285050266)
177551 213972 2 82 1061 Capitol Ave 5 1 1 1     11 Width 3ft   5995029.65711 2091072.52436 37.721401958108295 -122.459265935174 (37.7214019581083, -122.459265935174)
30190 136213 2 82 107 Spruce St 2 1 1 1     10 Width 3ft   5997027.70911 2115921.73522 37.78974632646779 -122.45415312837099 (37.7897463264678, -122.454153128371)
41318 240143 2 82 109 Cole St 1 1 1 1     10 Width 2ft   5998171.35185 2106192.58759 37.763098116497204 -122.449494935145 (37.7630981164972, -122.449494935145)
70424 124324 2 82 109 Jordan Ave 2 9 1 1     9 Width 3ft   5996182.48161 2113700.3553299997 37.7835985094544 -122.45691677945 (37.7835985094544, -122.45691677945)
27161 197088 2 82 1098 Pennsylvania Ave 6 9 1 1     5 Width 5ft   6014473.69906 2102184.6927400003 37.753012404101 -122.39282976818998 (37.753012404101, -122.39282976819)
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)
41596 197086 2 82 1098 Pennsylvania Ave 4 9 1 1     6 Width 5ft   6014471.44073 2102209.38753 37.7530800852958 -122.39283930551599 (37.7530800852958, -122.392839305516)
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)
62833 197084 2 82 1098 Pennsylvania Ave 2 9 1 1     6 Width 5ft   6014468.76337 2102245.03022 37.753177803814 -122.39285105782801 (37.753177803814, -122.392851057828)
134469 197089 2 82 1098 Pennsylvania Ave 7 9 1 1     7 Width 5ft   6014473.51573 2102162.27258 37.7529508329366 -122.39282883379101 (37.7529508329366, -122.392828833791)
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)
157085 197085 2 82 1098 Pennsylvania Ave 3 9 1 1     7 Width 5ft   6014468.858580001 2102236.49554 37.7531543746906 -122.392850131521 (37.7531543746906, -122.392850131521)
160169 197087 2 82 1098 Pennsylvania Ave 5 9 1 1     5 Width 5ft   6014472.10243 2102198.29911 37.753049675611 -122.39283624152 (37.753049675611, -122.39283624152)
170402 197083 2 82 1098 Pennsylvania Ave 1 9 1 1     6 Width 5ft   6014468.24915 2102256.69833 37.7532098133945 -122.392853652369 (37.7532098133945, -122.392853652369)
171068 197090 2 82 1098 Pennsylvania Ave 8 9 1 1     7 Width 5ft   6014474.311480001 2102148.65752 37.752913493081294 -122.39282512948 (37.7529134930813, -122.39282512948)
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)
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)
43382 246032 2 82 11 Belvedere St 1 1 1 1     1 Width 0ft   5998172.7746 2108470.8044 37.7693536035765 -122.44965419238501 (37.7693536035765, -122.449654192385)
36414 136262 2 82 11 Filbert St 7 2 1 1     7     6012539.8548099995 2120210.2855 37.8023989459081 -122.400783688018 (37.8023989459081, -122.400783688018)
77015 197152 2 82 11 Jakey Ct 1 1 1 1     3 Width 3ft   6016707.19345 2095564.5930700002 37.734958764918396 -122.384644735176 (37.7349587649184, -122.384644735176)
175020 197153 2 82 11 Jakey Ct 2 1 1 1     2 Width 3ft   6016721.84036 2095568.4819 37.734970252878796 -122.384594365947 (37.7349702528788, -122.384594365947)
45950 197160 2 82 11 Mabrey Ct 2 1 1 1     3 Width 3ft   6016488.26571 2095902.24457 37.7358737783612 -122.385425174944 (37.7358737783612, -122.385425174944)
39213 239316 2 82 1100 Hampshire St 1 1 1 1     8 Width 6ft   6010239.40016 2102763.26328 37.7543649341213 -122.407513645861 (37.7543649341213, -122.407513645861)
185144 239317 2 82 1100 Hampshire St 2 1 1 1     7 Width 6ft   6010240.72628 2102744.15996 37.7543125548829 -122.407507713025 (37.7543125548829, -122.407507713025)
25009 197076 2 82 1101 23rd St 1 1 1 1     8 Width 4ft   6014915.77906 2102946.7050400004 37.7551292724085 -122.39135422264098 (37.7551292724085, -122.391354222641)
64389 197077 2 82 1101 23rd St 2 1 1 1     7 Width 4ft   6014934.55258 2102947.77391 37.7551332492083 -122.391289372524 (37.7551332492083, -122.391289372524)
115937 197078 2 82 1101 23rd St 4 1 1 1     8 Width 4ft   6014978.14287 2102950.87924 37.75514419486029 -122.391138840404 (37.7551441948603, -122.391138840404)
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)
65185 141941 2 82 1101 GOLDEN GATE AVE 6 1 1 1     9 Width 0ft   6004098.4852 2112152.8429 37.779800807673794 -122.42942005016 (37.7798008076738, -122.42942005016)
66976 141938 2 82 1101 GOLDEN GATE AVE 3 1 1 1     12 Width 0ft   6004007.1195 2112144.3973 37.779772444920894 -122.42973552170099 (37.7797724449209, -122.429735521701)
161134 199943 2 82 1101 Quesada Ave 1 1 1 1     5 Width 0ft   6017830.3585 2092664.2977 37.7270571724447 -122.380559991407 (37.7270571724447, -122.380559991407)
72140 239356 2 82 111 Day St 1 1 1 1     11 Width 2ft   6005135.00311 2098711.3374 37.7429522432585 -122.42487771633101 (37.7429522432585, -122.424877716331)
31491 239296 2 82 1114 York St 1 1 1 1     18 Width 3ft   6009989.84018 2102603.83852 37.753913217229 -122.408365447707 (37.753913217229, -122.408365447707)
165666 179334 2 82 1119 Athens St 1 2 1 1     4 Width 6ft   6001947.96661 2087712.00011 37.7125700310481 -122.43511106143801 (37.7125700310481, -122.435111061438)
171035 179335 2 82 1119 Athens St 2 2 1 1     7 Width 6ft   6001959.57443 2087726.76645 37.7126112352992 -122.435071996701 (37.7126112352992, -122.435071996701)
65822 74096 2 82 1133 Athens St 1 1 1 1 1 01/29/1994 12:00:00 AM 10     6001902.78384 2087667.7277099998 37.712445903022704 -122.435264062185 (37.7124459030227, -122.435264062185)
8596 115210 2 82 115 Spruce St 2 1 1 1     8 3x3   5997031.37665 2115893.5791 37.789669227607604 -122.45413840466298 (37.7896692276076, -122.454138404663)
129542 199942 2 82 1151 Quesada Ave 1 1 1 1     4 Width 0ft   6017725.4053 2092742.7421 37.7272667732913 -122.38092826799401 (37.7272667732913, -122.380928267994)
167097 240168 2 82 116 Downey St 1 1 1 1     3 Width 4ft   5998899.29279 2107504.14215 37.766740931067204 -122.447071634562 (37.7667409310672, -122.447071634562)
138771 199941 2 82 1161 Quesada Ave 1 1 1 1     3 Width 0ft   6017637.7639999995 2092806.0386 37.7274357354826 -122.38123564590401 (37.7274357354826, -122.381235645904)
166740 239355 2 82 117 Day St 1 1 1 1     17 Width 2ft   6005097.05649 2098708.2685700003 37.7429416735155 -122.425008707103 (37.7429416735155, -122.425008707103)
136478 199940 2 82 1177 Quesada Ave 1 1 1 1     4 Width 0ft   6017562.0246 2092865.5482 37.7275949559017 -122.381501616556 (37.7275949559017, -122.381501616556)
4111 159295 2 82 118 Whipple Ave 2 1 1 1   10/05/2017 02:16:00 PM 3 Width 0ft   5998136.03876 2087321.1199900003 37.7112795695727 -122.448258085851 (37.7112795695727, -122.448258085851)
39057 120310 2 82 120 23rd Ave 1 1 1 1     12 Width 3ft   5988691.601840001 2114529.40052 37.7854418348342 -122.482892819932 (37.7854418348342, -122.482892819932)
4050 159297 2 82 120 Whipple Ave 2 1 1 1   10/05/2017 01:53:00 PM 3 Width 0ft   5998096.339240001 2087362.0634299999 37.711389721237104 -122.448398243388 (37.7113897212371, -122.448398243388)
161550 199972 2 82 1200 Shafter Ave 1 1 1 1     9 Width 0ft   6017032.2494 2092637.585 37.7269397498685 -122.38331721142401 (37.7269397498685, -122.383317211424)
54800 213913 2 82 1205 04th Ave 1 1 1 1     3 Width 5ft   5994820.88687 2107315.71116 37.7659896869053 -122.46116439324899 (37.7659896869053, -122.461164393249)
160675 213914 2 82 1205 04th Ave 2 1 1 1     8 Width 5ft   5994821.63869 2107263.01718 37.7658450462296 -122.46115797296999 (37.7658450462296, -122.46115797297)
56189 240144 2 82 1207 Cole St 1 1 1 1     10 Width 2ft   5998176.37667 2106172.1274099997 37.7630422254456 -122.449476081756 (37.7630422254456, -122.449476081756)
160986 240145 2 82 1209 Cole St 1 1 1 1     5 Width 2ft   5998178.05243 2106154.45126 37.7629937870534 -122.44946901220301 (37.7629937870534, -122.449469012203)
179770 71586 2 82 121 Goethe St 1 1 1 1 1 09/30/1995 12:00:00 AM 9     5994945.16185 2086428.98532 37.7086470380903 -122.459221923276 (37.7086470380903, -122.459221923276)
170342 240170 2 82 1210 Shrader St 5 1 1 1     5 Width 3ft   5997763.42944 2106350.69035 37.763508882764796 -122.45091719498699 (37.7635088827648, -122.450917194987)
70320 181741 2 82 1215 33rd Ave 1 1 1 1     7 Width 0ft   5985810.6327 2106942.082 37.7644411641486 -122.492301073815 (37.7644411641486, -122.492301073815)
171759 240146 2 82 1217 Cole St 1 1 1 1     10 Width 2ft   5998179.2817400005 2106131.69521 37.7629313749956 -122.449463120725 (37.7629313749956, -122.449463120725)
4003 159298 2 82 122 Whipple Ave 1 1 1 1   10/05/2017 02:11:00 PM 3 Width 0ft   5998090.67137 2087368.5047400002 37.711407083550704 -122.448418296488 (37.7114070835507, -122.448418296488)
41586 197159 2 82 122 Whitney Young Cir 5 1 1 1     1 Width 3ft   6016446.71962 2095806.9526900002 37.7356098273254 -122.385562178561 (37.7356098273254, -122.385562178561)
25023 213915 2 82 1221 07th Ave 1 1 1 1     5 Width 3ft   5993897.03256 2107168.07527 37.7655311082052 -122.464349072465 (37.7655311082052, -122.464349072465)
62773 213916 2 82 1221 07th Ave 2 1 1 1     16 Width 3ft   5993897.35256 2107155.07888 37.7654954419723 -122.46434702200199 (37.7654954419723, -122.464347022002)
61276 240147 2 82 1225 Cole St 1 1 1 1     12 Width 3ft   5998185.557080001 2106089.4961900003 37.762815866092794 -122.44943837589399 (37.7628158660928, -122.449438375894)
75524 120438 2 82 123 22nd Ave 1 1 1 1     6 Width 2ft   5988956.31634 2114501.1697400003 37.7853797200377 -122.48197492857099 (37.7853797200377, -122.481974928571)
54847 197162 2 82 123 Whitney Young Cir 6 1 1 1     2 Width 3ft   6016438.8167 2095743.2053 37.735434352517 -122.385585060917 (37.735434352517, -122.385585060917)
176449 197115 2 82 1231 Rhode Island St 1 4 1 1     7 Width 3ft   6011991.85547 2102642.48446 37.7541312380906 -122.40144468342301 (37.7541312380906, -122.401444683423)
Powered by Datasette · Query took 80.665ms · Data source: data.sfgov.org