sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
161050 199671 2 66 1905 Keith St 6 1 1 1     2 Width 0ft   6015210.0019 2093419.3228 37.728985371993396 -122.389671313679 (37.7289853719934, -122.389671313679)
96011 53145 1 66 1498@ KEITH Underwood Ave 7 1 1 1 1 11/02/2006 12:00:00 AM     Permit Number 49074 6015150.01654287 2093336.52012549 37.7287546860169 -122.389872907792 (37.7287546860169, -122.389872907792)
163888 38590 1 66 1614 Quesada Ave 1 1 1 1 1 09/17/1998 12:00:00 AM 2   Permit Number 40545 6015168.4288 2094722.1342 37.732560324707705 -122.38990600380698 (37.7325603247077, -122.389906003807)
176558 38592 1 66 1618 Quesada Ave 1 1 1 1 1 09/17/1998 12:00:00 AM 2   Permit Number 40547 6015152.7308 2094735.8699 37.7325971695789 -122.389961235194 (37.7325971695789, -122.389961235194)
42780 200073 2 66 1500 Van Dyke Ave 1 1 1 1     3 Width 0ft   6014933.989 2093151.8218 37.7282355589188 -122.390606833955 (37.7282355589188, -122.390606833955)
175342 200074 2 66 1500 Van Dyke Ave 2 1 1 1     3 Width 0ft   6014921.0644 2093162.4986 37.728264158228896 -122.39065226097 (37.7282641582289, -122.39065226097)
179097 30759 1 66 1563 Thomas Ave 1 1 1 1 1 10/31/2005 12:00:00 AM 5   Permit Number 48354 6014932.9973 2093776.0212 37.7299494300904 -122.39065386327499 (37.7299494300904, -122.390653863275)
116485 200075 2 66 1500 Van Dyke Ave 3 1 1 1     3 Width 0ft   6014900.2728 2093175.985 37.7283000356482 -122.390725081061 (37.7283000356482, -122.390725081061)
36442 200076 2 66 1500 Van Dyke Ave 4 1 1 1     4 Width 0ft   6014887.9102 2093187.7857 37.728331752097795 -122.390768643797 (37.7283317520978, -122.390768643797)
72707 190928 2 66 1778 Quesada Ave 1 4 1 1     4 Width 3ft   6014320.53257 2095360.07162 37.73426491189 -122.39288202418301 (37.73426491189, -122.392882024183)
16162 51360 3 66 50 Pomona St 12 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014114.6767 2094431.72556 37.7317044268964 -122.39352878961999 (37.7317044268964, -122.39352878962)
13409 51359 3 66 50 Pomona St 13 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014112.78564 2094416.99761 37.73166388187129 -122.393534297068 (37.7316638818713, -122.393534297068)
14652 51358 3 66 50 Pomona St 14 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014110.4538 2094404.7193099998 37.7316300385939 -122.393541499766 (37.7316300385939, -122.393541499766)
16408 78332 3 66 50 Pomona St 15 1 1 4 2 07/01/2009 12:00:00 AM 3 3x3 Permit Number 52305 6014106.86245 2094390.7581099998 37.73159150443121 -122.393552939125 (37.7315915044312, -122.393552939125)
84074 66157 1 66 1765 Newhall St 1 1 1 1 1 09/04/1990 12:00:00 AM     Permit Number 29228 6013882.21689766 2094959.68148484 37.733141166757896 -122.39436940843201 (37.7331411667579, -122.394369408432)
61905 190927 2 66 1050 Wisconsin St 2 9 1 1     5 Width 3ft   6012767.00645 2102579.68997 37.7540020378723 -122.39875959738 (37.7540020378723, -122.39875959738)
122539 190926 2 66 1303 Rhode Island St 2 2 1 1     8 Width 7ft   6012003.88758 2102215.75937 37.7529602155494 -122.40137308660401 (37.7529602155494, -122.401373086604)
88498 35377 1 66 767 San Bruno Ave 1 1 1 1 1 02/23/1998 12:00:00 AM     Permit Number 38834 6011637.61839103 2091581.433538 37.7237401685956 -122.401892240977 (37.7237401685956, -122.401892240977)
107745 49836 1 66 572 Rhode Island St 1 1 1 1 1 04/28/2005 12:00:00 AM     Permit Number 46619 6011764.04798466 2105724.17808831 37.76258017347929 -122.402449179614 (37.7625801734793, -122.402449179614)
186978 190925 2 66 651 Kansas St 1 1 1 1     1 Width 3ft   6011562.1933699995 2105343.91486 37.761524784975 -122.40312057635 (37.761524784975, -122.40312057635)
128328 67340 1 66 2520 25th St 1 1 1 1 1 07/22/1992 12:00:00 AM     Permit Number 30824 6011380.01787368 2101864.42331106 37.75196069589111 -122.403505842523 (37.7519606958911, -122.403505842523)
141700 37459 1 66 30 Montcalm St 1 1 1 1 1 06/19/1998 12:00:00 AM     Permit Number 39931 6010620.6907028 2100238.51379536 37.7474538625831 -122.40601718747 (37.7474538625831, -122.40601718747)
99952 34302 1 66 1261 Hampshire St 1 1 1 1 1 07/14/1997 12:00:00 AM     Permit Number 38090 6010338.30191232 2101880.05024725 37.7519453623814 -122.407109364623 (37.7519453623814, -122.407109364623)
115026 34301 1 66 1257 Hampshire St 1 1 1 1 1 07/14/1997 12:00:00 AM     Permit Number 38089 6010337.06875453 2101902.38195398 37.7520066112995 -122.407115203053 (37.7520066112995, -122.407115203053)
136007 143086 2 66 459 Greenwich St 1 1 1 1     7 Width 0ft   6010641.4481 2120294.7479 37.8025247902186 -122.407359099343 (37.8025247902186, -122.407359099343)
121588 34344 1 66 1325 York St 1 1 1 1 1 07/14/1997 12:00:00 AM     Permit Number 38101 6010099.44079349 2101484.52277039 37.7508459613928 -122.40790749535499 (37.7508459613928, -122.407907495355)
78195 47741 1 66 1384 York St 1 1 1 1 1 06/08/2002 12:00:00 AM     Permit Number 45524 6010066.05430582 2101146.00958918 37.7499146097647 -122.40799907978399 (37.7499146097647, -122.407999079784)
40226 223024 2 66 979 York St 1 1 1 1     2 Width 3ft   6009975.926030001 2103539.78877 37.756482348291996 -122.40847958248399 (37.756482348292, -122.408479582484)
78925 69199 1 66 1342 Florida St 1 1 1 1 1 01/31/1994 12:00:00 AM     Permit Number 33247 6009509.54623645 2101351.16759285 37.7504467544428 -122.409938000531 (37.7504467544428, -122.409938000531)
119254 65260 1 66 1153 Florida St 1 1 1 1 1 06/08/2002 12:00:00 AM     Permit Number 28059 6009500.12226017 2102463.02471256 37.7534991381214 -122.410049073844 (37.7534991381214, -122.410049073844)
164832 71420 2 66 637 Greenwich St 1 1 1 1 1 08/26/1995 12:00:00 AM 5     6009832.0273 2120182.0847 37.8021701092209 -122.410152151595 (37.8021701092209, -122.410152151595)
89728 82956 2 66 660X Clementina St 1 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
96002 82952 2 66 660X Clementina St 5 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
96209 82955 2 66 660X Clementina St 2 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
100905 82953 2 66 660X Clementina St 4 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
117382 82954 2 66 660X Clementina St 3 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
107468 84505 2 66 650 Clementina St 1 1 1 1 1 10/14/2006 12:00:00 AM 3 3x3   6009485.16866501 2110503.49163991 37.775575580460206 -122.410668559049 (37.7755755804602, -122.410668559049)
107733 84504 2 66 650X Clementina St 2 1 1 1 1 10/14/2006 12:00:00 AM 3 3x3   6009485.16866501 2110503.49163991 37.775575580460206 -122.410668559049 (37.7755755804602, -122.410668559049)
77680 63803 1 66 75 Putnam St 1 1 1 1 1 07/09/1987 12:00:00 AM     Permit Number 24490 6009186.19603238 2097034.65488427 37.7385764323817 -122.41075136529899 (37.7385764323817, -122.410751365299)
97694 63806 1 66 8 Putnam St 1 1 1 1 1 07/09/1987 12:00:00 AM     Permit Number 24493 6009169.73778237 2097426.78712757 37.7396522194543 -122.41083595729299 (37.7396522194543, -122.410835957293)
96993 63825 1 66 271 Nevada St 1 1 1 1 1 07/10/1987 12:00:00 AM     Permit Number 24513 6009008.49456519 2097079.12708776 37.738688578203295 -122.41136891509899 (37.7386885782033, -122.411368915099)
60482 247587 2 66 800 Tompkins Ave 8 7 1 1     6     6008949.04431 2096428.8077599998 37.7368996080238 -122.41152853331499 (37.7368996080238, -122.411528533315)
127030 69506 1 66 401 Nevada St 1 1 1 1 1 05/24/1994 12:00:00 AM     Permit Number 33632 6008948.22977241 2096437.66011224 37.7369238689745 -122.41153197478901 (37.7369238689745, -122.411531974789)
63732 247588 2 66 800 Tompkins Ave 9 7 1 1     6     6008943.011630001 2096440.0672900002 37.7369301858647 -122.411550186315 (37.7369301858647, -122.411550186315)
55439 223036 2 66 2743 Harrison St 1 1 1 1     5 Width 3ft   6008969.13541 2102480.10351 37.7535162573804 -122.411886554326 (37.7535162573804, -122.411886554326)
20561 28791 1 66 2737 Harrison St 1 1 1 1     6 3x3   6008967.21311 2102509.30076 37.7535963186214 -122.41189526514799 (37.7535963186214, -122.411895265148)
18434 28792 1 66 2731 Harrison St 1 1 1 1     6 3x3   6008964.243480001 2102548.86607 37.753704789464294 -122.411908330514 (37.7537047894643, -122.411908330514)
96973 43489 1 66 731 Banks St 2 1 1 1 1 07/19/2000 12:00:00 AM     Permit Number 43170 6008504.61569086 2095547.09041526 37.734453664768296 -122.413002801242 (37.7344536647683, -122.413002801242)
111195 43490 1 66 731 Banks St 1 1 1 1 1 07/19/2000 12:00:00 AM     Permit Number 43170 6008504.61569086 2095547.09041526 37.734453664768296 -122.413002801242 (37.7344536647683, -122.413002801242)
126743 223043 2 66 4107 Ogden Ave 2 1 1 1     6 Width 3ft   6008381.78974 2096055.8705400003 37.735843768863795 -122.413463422917 (37.7358437688638, -122.413463422917)
158851 223045 2 66 13 Stoneman St 1 1 1 1     2 Width 3ft   6008341.10325 2099446.02772 37.745150110794896 -122.413843827126 (37.7451501107949, -122.413843827126)
152052 223044 2 66 13 Stoneman St 2 1 1 1     6 Width 3ft   6008324.57166 2099444.87133 37.7451460071793 -122.413900908902 (37.7451460071793, -122.413900908902)
160368 126382 2 66 1001 Vallejo St 4 9 1 1     9 Width 4ft   6008670.39988 2118624.74661 37.7978288673746 -122.414061717575 (37.7978288673746, -122.414061717575)
130622 223035 2 66 99 Manchester St 1 1 1 1     3 Width 3ft   6008263.26696 2099462.20339 37.7451901540099 -122.414114116572 (37.7451901540099, -122.414114116572)
18096 24588 3 66 820 Cortland Ave 1 1 1 2   04/10/1996 12:00:00 AM 20 3X3   6008195.26733 2097153.24719 37.7388464504963 -122.414185921141 (37.7388464504963, -122.414185921141)
148524 126381 2 66 1022 Vallejo St 1 7 1 1     5     6008596.5256900005 2118672.84077 37.7979567725457 -122.414320748412 (37.7979567725457, -122.414320748412)
20665 24587 3 66 804 Cortland Ave 1 1 1 2   04/10/1996 12:00:00 AM 18 3X3   6008146.87115 2097150.7739799998 37.738836941075 -122.414353078142 (37.738836941075, -122.414353078142)
7079 108929 2 66 12x MacOndray Ln 3 1 1 1     14 3x3   6008556.45633 2119171.5746400002 37.79932392101129 -122.41449470968399 (37.7993239210113, -122.414494709684)
102257 62913 1 66 503 Moultrie St 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23293 6007737.75654809 2096994.92041001 37.7383860110425 -122.41575657686 (37.7383860110425, -122.41575657686)
105369 62916 1 66 543 Moultrie St 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23296 6007721.5198304 2096821.74854603 37.737909606417496 -122.415800456905 (37.7379096064175, -122.415800456905)
168058 223039 2 66 543 Moultrie St 1 1 1 1     9 Width 3ft   6007708.387180001 2096815.6091900002 37.7378920108046 -122.41584542843201 (37.7378920108046, -122.415845428432)
39350 223040 2 66 567 Moultrie St 1 1 1 1     4 Width 3ft   6007699.61186 2096703.5074099998 37.7375837106174 -122.41586783322799 (37.7375837106174, -122.415867833228)
25265 223034 2 66 578 Moultrie St 1 1 1 1     9 Width 3ft   6007664.494030001 2096661.03983 37.7374651296141 -122.41598624606199 (37.7374651296141, -122.415986246062)
121238 62920 1 66 578 Moultrie St 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23300 6007655.13385737 2096670.74814693 37.7374912602593 -122.41601929597999 (37.7374912602593, -122.41601929598)
19529 24597 1 66 451 Cortland Ave 1 1 1 1   04/10/1996 12:00:00 AM 6 3X3   6007425.33634 2097280.23764 37.7391518611665 -122.41685698498101 (37.7391518611665, -122.416856984981)
104121 67138 1 66 453 Cortland Ave 1 1 1 1 1 06/18/1994 12:00:00 AM     Permit Number 30567 6007391.81828007 2097290.23033564 37.739177413508 -122.416973583395 (37.739177413508, -122.416973583395)
104124 61289 1 66 424 Cortland Ave 1 1 1 1 1 07/16/1994 12:00:00 AM     Permit Number 21181 6007345.32477323 2097244.32339637 37.7390487477576 -122.417131085359 (37.7390487477576, -122.417131085359)
20916 24556 1 66 416 Cortland Ave 1 1 1 1     24 3X3   6007294.81147 2097256.19199 37.739078494466 -122.41730657855801 (37.739078494466, -122.417306578558)
121976 62909 1 66 414 Cortland Ave 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23286 6007271.29358338 2097254.92250183 37.739073685552896 -122.41738780295601 (37.7390736855529, -122.417387802956)
18010 24554 1 66 412 Cortland Ave 1 1 1 1     24 3X3   6007266.67907 2097258.15357 37.7390822977194 -122.41740398679899 (37.7390822977194, -122.417403986799)
74097 223041 2 66 410 Cortland Ave 1 1 1 1     6 Width 3ft   6007256.618290001 2097259.39898 37.7390851512711 -122.41743886071899 (37.7390851512711, -122.417438860719)
79811 62908 1 66 410 Cortland Ave 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23285 6007239.73762584 2097259.44248715 37.7390843209207 -122.41749722959699 (37.7390843209207, -122.417497229597)
16913 24553 1 66 404 Cortland Ave 1 1 1 1     24 3X3   6007222.65374 2097265.29025 37.7390994163072 -122.41755671238501 (37.7390994163072, -122.417556712385)
114576 61288 1 66 402 Cortland Ave 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23284 6007176.62571904 2097268.48245659 37.739105591348704 -122.417716082945 (37.7391055913487, -122.417716082945)
78398 62968 1 66 1136 Green St 1 1 1 1 1 08/21/1986 12:00:00 AM     Permit Number 23354 6007556.73602589 2118875.23289672 37.7984540273893 -122.41793308103901 (37.7984540273893, -122.417933081039)
70261 126380 2 66 1136 Havens St 3 9 1 1     7 Width 7ft   6007510.81799 2119357.46903 37.799775542566294 -122.41812617837401 (37.7997755425663, -122.418126178374)
175387 126379 2 66 1136 Havens St 2 9 1 1     7 Width 7ft   6007507.74968 2119357.27743 37.7997748437807 -122.418136782297 (37.7997748437807, -122.418136782297)
76330 126383 2 66 1116 Greenwich St 3 7 1 1     4     6007504.98606 2119897.57415 37.801258207159 -122.418184672095 (37.801258207159, -122.418184672095)
165172 50986 1 66 1120REVISED Greenwich St 1 1 1 1   08/06/2004 12:00:00 AM 6   Permit Number 47576 6007503.31376 2119893.93908 37.801248132044 -122.418190201138 (37.801248132044, -122.418190201138)
156749 126384 2 66 1120 Greenwich St 2 7 1 1     4     6007500.24433 2119896.2377400002 37.8012542708165 -122.418200985801 (37.8012542708165, -122.418200985801)
91932 62709 1 66 1171 Green St 1 1 1 1 1 05/20/1986 12:00:00 AM     Permit Number 23049 6007422.95308964 2118804.22805474 37.798251535762205 -122.418390975112 (37.7982515357622, -122.418390975112)
69745 223042 2 66 330 Park St 1 1 1 1     7 Width 4ft   6006921.22556 2096271.82147 37.736354605390204 -122.418528488295 (37.7363546053902, -122.418528488295)
103091 62944 1 66 33 Ellert St 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23326 6006898.05353177 2097079.16721331 37.738570093545796 -122.41866583942 (37.7385700935458, -122.41866583942)
103775 62943 1 66 32 Ellert St 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23325 6006886.21663048 2097028.33083041 37.738429841676 -122.418703161695 (37.738429841676, -122.418703161695)
127085 58683 1 66 26 Ellert St 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23324 6006866.27520727 2097031.18211361 37.7384365478954 -122.418772311755 (37.7384365478954, -122.418772311755)
17038 115537 4 66 99X Lech Walesa St 2 1 1 1   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
78927 115540 4 66 99X Lech Walesa St 5 1 1 1   02/08/2016 12:00:00 AM 3 3x5 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
89451 115539 4 66 99X Lech Walesa St 4 1 1 1   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
120364 115538 4 66 99X Lech Walesa St 3 1 1 1   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
142150 115536 4 66 99X Lech Walesa St 1 1 1 1   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
120898 62937 1 66 324 Bocana St 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23318 6006824.33458428 2097207.20889429 37.7389175168089 -122.418929803603 (37.7389175168089, -122.418929803603)
77548 51448 1 66 326 Bocana St 2 1 1 1   10/19/2004 12:00:00 AM     Permit Number 47765 6006818.05257651 2097195.51767411 37.7388850615796 -122.41895069494 (37.7388850615796, -122.41895069494)
119395 51449 1 66 326 Bocana St 1 1 1 1   10/19/2004 12:00:00 AM     Permit Number 47765 6006818.05257651 2097195.51767411 37.7388850615796 -122.41895069494 (37.7388850615796, -122.41895069494)
114488 62940 1 66 355 Bocana St 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23321 6006807.32064873 2097065.68374167 37.7385279621224 -122.41897859484399 (37.7385279621224, -122.418978594844)
123110 62941 1 66 357 Bocana St 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23322 6006800.83841041 2097053.62300346 37.738494480992706 -122.419000152151 (37.7384944809927, -122.419000152151)
90333 53193 1 66 44COLERIDGE Powers Ave 1 1 1 1 1 11/28/2006 12:00:00 AM     Permit Number 49130 6006839.19551401 2099757.71286836 37.745921466667205 -122.419059278748 (37.7459214666672, -122.419059278748)
127990 62939 1 66 338 Bocana St 1 1 1 1 1 08/05/1986 12:00:00 AM     Permit Number 23320 6006780.36050357 2097125.37030396 37.7386903299864 -122.41907604266899 (37.7386903299864, -122.419076042669)
52114 223023 2 66 330 Lexington St 1 1 1 1     4 Width 3ft   6006515.400219999 2104174.73701 37.7580313639845 -122.420492397202 (37.7580313639845, -122.420492397202)
80468 51543 1 66 330 Lexington St 1 1 1 1 1 07/22/2006 12:00:00 AM     Permit Number 47842 6006500.80110502 2104175.14616456 37.7580316646871 -122.4205429163 (37.7580316646871, -122.4205429163)
174269 223032 2 66 281 Richland Ave 1 1 1 1     5 Width 3ft   6006256.18709 2096109.4549 37.735871320489395 -122.42081628443898 (37.7358713204894, -122.420816284439)
162977 223033 2 66 281 Richland Ave 2 1 1 1     6 Width 3ft   6006248.27078 2096110.4955099998 37.735873731571395 -122.420843728155 (37.7358737315714, -122.420843728155)
Powered by Datasette · Query took 7.457ms · Data source: data.sfgov.org