sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
81149 91472 1 118 601 25th St 3 1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
81595 32527 1 118 6 Porter St 1 1 1 1 1 10/15/1996 12:00:00 AM     Permit Number 37029 6007006.64286664 2095736.82242552 37.734890424251496 -122.41819524564899 (37.7348904242515, -122.418195245649)
83132 34215 1 118 123 Faith St 1 1 1 1 1 10/18/1997 12:00:00 AM     Permit Number 38031 6010471.85076762 2099030.12086895 37.7441275531286 -122.40644673425 (37.7441275531286, -122.40644673425)
84214 121763 2 118 580 07th St   1 1 1       3x3   6011520.0 2109619.0 37.7732608451695 -122.403567299641 (37.7732608451695, -122.403567299641)
85599 41099 1 118 2 Powhattan Ave 3 1 1 1   11/10/1999 12:00:00 AM     Permit Number 41846 6007385.16398243 2098172.89678414 37.741600645555295 -122.41705911631 (37.7416006455553, -122.41705911631)
85815 91477 1 118 601 25th St 8 1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
86117 46711 1 118 1337 Willard St 1 1 1 1 1 04/24/2002 12:00:00 AM     Permit Number 44841 5996760.70858802 2106869.35577873 37.7648755513325 -122.454422736012 (37.7648755513325, -122.454422736012)
91336 34210 1 118 110 Faith St 1 1 1 1 1 10/18/1997 12:00:00 AM     Permit Number 38026 6010548.985067501 2099059.00866257 37.7442111875512 -122.406182054391 (37.7442111875512, -122.406182054391)
91947 63833 1 118 91 Bronte St 1 1 1 1 1 07/10/1987 12:00:00 AM     Permit Number 24521 6009354.9233329 2096920.48394154 37.738272402670106 -122.41015992638799 (37.7382724026701, -122.410159926388)
92629 84195 1 118 455 Joost Ave 1 1 1 1   01/17/2008 12:00:00 AM   3x3 Permit Number 50117 5999074.87038552 2094946.18270708 37.732269862610295 -122.445561218581 (37.7322698626103, -122.445561218581)
93015 38002 1 118 2468 14th Ave 1 1 1 1 1 07/08/1998 12:00:00 AM     Permit Number 40214 5992067.43945644 2098644.28132388 37.742021359605104 -122.47005645773599 (37.7420213596051, -122.470056457736)
94957 42745 1 118 333 Tunnel Ave 10 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42738 6011765.57664352 2086774.37059761 37.7105480846287 -122.40111229342399 (37.7105480846287, -122.401112293424)
95276 206793 2 118 106 Thrift St 1 1 1 1     18 Width 2ft   5995874.19015 2089646.87055 37.7175359677985 -122.456243608772 (37.7175359677985, -122.456243608772)
95636 34306 1 118 1260 Utah St 1 1 1 1 1 07/14/1997 12:00:00 AM     Permit Number 38094 6010824.33318422 2102458.44647529 37.7535606982702 -122.405469321452 (37.7535606982702, -122.405469321452)
96045 52379 1 118 8TA MARINA Gladeview Way 3 1 1 1   12/14/2005 12:00:00 AM     Permit Number 48506 5997748.93752219 2101838.53853326 37.751118812629 -122.450641986228 (37.751118812629, -122.450641986228)
100833 32757 1 118 100x THRIFT ST 1 1 1 1 1 10/29/1996 12:00:00 AM     Permit Number 37135 5995486.0 2089629.0 37.7174646081384 -122.45758410365801 (37.7174646081384, -122.457584103658)
101511 51444 1 118 336 Banks St 1 1 1 1 1 10/19/2004 12:00:00 AM     Permit Number 47763 6008602.30832967 2097174.95707039 37.7389289161491 -122.412780092695 (37.7389289161491, -122.412780092695)
101822 110133 2 118 2569x Polk St 1 1 1 1     4 3x3   6006170.473730001 2119650.67093 37.800505068104 -122.42278512073901 (37.800505068104, -122.422785120739)
102765 52378 1 118 8TA MARINA Gladeview Way 2 1 1 1   12/14/2005 12:00:00 AM     Permit Number 48506 5997748.93752219 2101838.53853326 37.751118812629 -122.450641986228 (37.751118812629, -122.450641986228)
103388 45564 1 118 3500 Clay St 3 1 1 1 1 07/24/2001 12:00:00 AM     Permit Number 44308 5998062.56908828 2115523.19421657 37.788711325308 -122.45054388629801 (37.788711325308, -122.450543886298)
103570 33814 1 118 543 23rd Ave 1 1 1 1   01/21/1997 12:00:00 AM     Permit Number 37829 5988747.93564593 2111618.41829501 37.7774523741972 -122.482484550136 (37.7774523741972, -122.482484550136)
104272 42748 1 118 333 Tunnel Ave 5 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42738 6011765.57664352 2086774.37059761 37.7105480846287 -122.40111229342399 (37.7105480846287, -122.401112293424)
104865 42746 1 118 333 Tunnel Ave 7 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42738 6011765.57664352 2086774.37059761 37.7105480846287 -122.40111229342399 (37.7105480846287, -122.401112293424)
105153 91474 1 118 601 25th St 5 1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
105225 88672 1 118 601 25th St 13 1 1 1   08/05/2008 12:00:00 AM 4 3x3 Permit Number 51637 6016937.47244 2102122.1356099998 37.7529771731841 -122.384305125986 (37.7529771731841, -122.384305125986)
105580 121764 2 118 580 07th St   1 1 1       3x3   6011520.0 2109619.0 37.7732608451695 -122.403567299641 (37.7732608451695, -122.403567299641)
107600 67504 1 118 477 Flood Ave 1 1 1 1 1 09/16/1992 12:00:00 AM     Permit Number 31033 5997603.60235184 2094078.4650036998 37.729803210873 -122.450585167202 (37.729803210873, -122.450585167202)
107706 16072 3 118 258 Monterey Blvd 2 1 1 2     12 3X3   6000364.9354737 2094709.7194476002 37.7316941555853 -122.441084223383 (37.7316941555853, -122.441084223383)
107956 34211 1 118 132 Faith St 1 1 1 1 1 10/18/1997 12:00:00 AM     Permit Number 38027 6010446.19872622 2099093.63297516 37.7443005084973 -122.406539908391 (37.7443005084973, -122.406539908391)
108363 32760 1 118 100x THRIFT ST 4 1 1 1 1 10/29/1996 12:00:00 AM 8 3x3 Permit Number 37135 5995486.0 2089629.0 37.7174646081384 -122.45758410365801 (37.7174646081384, -122.457584103658)
108806 91480 1 118 601 25th St 11 1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
108856 52142 1 118 16 Gladys St 1 1 1 1 1 10/27/2005 12:00:00 AM     Permit Number 48323 6005795.19032335 2097640.79736733 37.7400500494445 -122.42251891414101 (37.7400500494445, -122.422518914141)
109689 91479 1 118 601 25th St 10 1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
109736 34214 1 118 135 Faith St 1 1 1 1 1 10/18/1997 12:00:00 AM     Permit Number 38030 6010413.34787543 2099049.82798569 37.744178391599704 -122.40665041382299 (37.7441783915997, -122.406650413823)
114050 45419 1 118 3690 Washington St 10 1 1 1   07/12/2001 12:00:00 AM     Permit Number 44217 5997130.30152423 2115717.50370466 37.7891914436893 -122.45378341626301 (37.7891914436893, -122.453783416263)
114283 33419 1 118 498X KENWOOD WAY 2 1 1 1 1 11/19/1996 12:00:00 AM 2   Permit Number 37528 5993404.0 2093661.0 37.7284156834141 -122.46507324106301 (37.7284156834141, -122.465073241063)
115812 176086 2 118 301 Tunnel Ave 3 1 1 1     3 Width 3ft   6011743.1903099995 2086704.18251 37.710354113216894 -122.401184737092 (37.7103541132169, -122.401184737092)
116523 121762 2 118 580 07th St   1 1 1       3x3   6011520.0 2109619.0 37.7732608451695 -122.403567299641 (37.7732608451695, -122.403567299641)
117521 42753 1 118 333 Tunnel Ave 8 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42738 6011765.57664352 2086774.37059761 37.7105480846287 -122.40111229342399 (37.7105480846287, -122.401112293424)
117542 45418 1 118 3690 Washington St 9 1 1 1   07/12/2001 12:00:00 AM     Permit Number 44217 5997130.30152423 2115717.50370466 37.7891914436893 -122.45378341626301 (37.7891914436893, -122.453783416263)
117952 35259 1 118 15 North View Ct 1 1 1 1 1 02/17/1998 12:00:00 AM     Permit Number 38745 6006261.16028369 2120974.78404058 37.8041458613164 -122.422565451189 (37.8041458613164, -122.422565451189)
118866 32528 1 118 17 Porter St 1 1 1 1 1 10/15/1996 12:00:00 AM     Permit Number 37030 6007054.5480271 2095691.64868794 37.734769083447205 -122.418026418979 (37.7347690834472, -122.418026418979)
120556 42751 1 118 333 Tunnel Ave 9 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42738 6011765.57664352 2086774.37059761 37.7105480846287 -122.40111229342399 (37.7105480846287, -122.401112293424)
121590 33418 1 118 498X KENWOOD WAY 1 1 1 1 1 11/19/1996 12:00:00 AM 2   Permit Number 37528 5993404.0 2093661.0 37.7284156834141 -122.46507324106301 (37.7284156834141, -122.465073241063)
121918 42752 1 118 333 Tunnel Ave 3 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42738 6011765.57664352 2086774.37059761 37.7105480846287 -122.40111229342399 (37.7105480846287, -122.401112293424)
122324 42048 1 118 214 Duncan St 1 1 1 1   06/21/2000 12:00:00 AM     Permit Number 42365 6005128.75403076 2099926.75275442 37.746289143211 -122.424985780451 (37.746289143211, -122.424985780451)
122799 34212 1 118 146 Faith St 1 1 1 1 1 10/18/1997 12:00:00 AM     Permit Number 38028 6010380.78922037 2099115.666634 37.74435734854671 -122.40676763416599 (37.7443573485467, -122.406767634166)
122851 33431 1 118 127 Stillings Ave 1 1 1 1 1 11/19/1996 12:00:00 AM     Permit Number 37535 5999930.67607914 2095733.95298446 37.7344817167018 -122.44265905551799 (37.7344817167018, -122.442659055518)
123033 16091 3 118 284 Monterey Blvd 2 1 1 2     12 3X3   6000198.548030901 2094712.9146897998 37.7316934502774 -122.44165968578001 (37.7316934502774, -122.44165968578)
123346 42750 1 118 333 Tunnel Ave 2 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42738 6011765.57664352 2086774.37059761 37.7105480846287 -122.40111229342399 (37.7105480846287, -122.401112293424)
123357 34213 1 118 137 Faith St 1 1 1 1 1 10/18/1997 12:00:00 AM     Permit Number 38029 6010403.59737914 2099053.11250995 37.7441868646564 -122.40668436049499 (37.7441868646564, -122.406684360495)
123965 41097 1 118 2 Powhattan Ave 1 1 1 1 1 11/10/1999 12:00:00 AM     Permit Number 41846 6007385.16398243 2098172.89678414 37.741600645555295 -122.41705911631 (37.7416006455553, -122.41705911631)
124807 32759 1 118 100x THRIFT ST 3 1 1 1 1 10/29/1996 12:00:00 AM     Permit Number 37135 5995486.0 2089629.0 37.7174646081384 -122.45758410365801 (37.7174646081384, -122.457584103658)
125526 41098 1 118 2 Powhattan Ave 2 1 1 1   11/10/1999 12:00:00 AM     Permit Number 41846 6007385.16398243 2098172.89678414 37.741600645555295 -122.41705911631 (37.7416006455553, -122.41705911631)
126803 45808 1 118 151 Charles St 1 1 1 1   12/04/2001 12:00:00 AM     Permit Number 44436 6004877.73984335 2097041.07807041 37.7383515558837 -122.42564841052 (37.7383515558837, -122.42564841052)
128365 39517 1 118 3964 25TH ST 1 1 1 1 1 12/28/1998 12:00:00 AM 8   Permit Number 40967 6004074.0 2101323.0 37.750063277719704 -122.42873251065399 (37.7500632777197, -122.428732510654)
129334 91470 1 118 601 25th St 1 1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
131603 126404 2 118 2501 Jackson St 7 1 1 1     4 Width 3ft   6001524.31807 2116606.64238 37.7918837227069 -122.438644426709 (37.7918837227069, -122.438644426709)
131951 176083 2 118 120 Lathrop Ave 3 1 1 1     9 Width 3ft   6011939.3192 2086886.00886 37.7108643121037 -122.40051963449899 (37.7108643121037, -122.400519634499)
134346 223676 2 118 300 Clipper St 10 1 1 1     6 Width 3ft   6002874.24252 2100962.2133 37.749004667153 -122.432855563559 (37.749004667153, -122.432855563559)
135109 223274 2 118 91 Bronte St 1 1 1 1     10 Width 3ft   6009343.02898 2096929.97476 37.738297795693995 -122.41020172124901 (37.738297795694, -122.410201721249)
135159 223673 2 118 300 Clipper St 1 1 1 1     11 Width 3ft   6003155.02499 2100979.4719700003 37.7490679767212 -122.43188584885799 (37.7490679767212, -122.431885848858)
135209 202143 2 118 1999 Armstrong Ave 1 2 1 1     11 Width 3ft   6012908.83816 2093533.00853 37.7291696598447 -122.39763463365601 (37.7291696598447, -122.397634633656)
135441 36943 1 118 152 03rd Ave 3 1 1 1 1 05/29/1998 12:00:00 AM 4   Permit Number 39580 5994926.19435 2114520.7878400004 37.7857789756862 -122.46132251465099 (37.7857789756862, -122.461322514651)
135598 88666 1 118 601 25th St 7 1 1 1   08/05/2008 12:00:00 AM 4 3x3 Permit Number 51637 6016578.93003 2102100.6702900003 37.7528984024518 -122.385543550016 (37.7528984024518, -122.385543550016)
135878 223668 2 118 10 Gladys St 3 1 1 1     6 Width 3ft   6005828.6404800005 2097671.05304 37.740135011734 -122.42240540628299 (37.740135011734, -122.422405406283)
137005 120451 2 118 5 West Clay St 4 2 1 1     3 Width 6ft   5988873.724640001 2114983.29043 37.7866986830782 -122.482296003521 (37.7866986830782, -122.482296003521)
138514 100279 2 118 3460X 20th St 2 1 1 1     4 3x3   6007182.0 2104415.0 37.7587286142457 -122.41820403955799 (37.7587286142457, -122.418204039558)
140007 100278 2 118 3460X 20th St 1 1 1 1     4 3x3   6007182.0 2104415.0 37.7587286142457 -122.41820403955799 (37.7587286142457, -122.418204039558)
141044 46131 1 118 137 Beulah St 1 1 1 1 1 12/27/2001 12:00:00 AM     Permit Number 44481 5997450.10216271 2107762.76782376 37.7673681457069 -122.452102777266 (37.7673681457069, -122.452102777266)
141049 91471 1 118 601 25th St 2 1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
141272 91473 1 118 601 25th St 4 1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
141602 42744 1 118 333 Tunnel Ave 1 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42738 6011765.57664352 2086774.37059761 37.7105480846287 -122.40111229342399 (37.7105480846287, -122.401112293424)
144135 42747 1 118 333 Tunnel Ave 6 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42738 6011765.57664352 2086774.37059761 37.7105480846287 -122.40111229342399 (37.7105480846287, -122.401112293424)
144300 42749 1 118 333 Tunnel Ave 4 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42738 6011765.57664352 2086774.37059761 37.7105480846287 -122.40111229342399 (37.7105480846287, -122.401112293424)
144321 91475 1 118 601 25th St 6 1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
145175 108885 5 118 707 NOE ST 5 13 1 1       3x3   6003152.4 2104071.5 37.757557804850705 -122.43211570496099 (37.7575578048507, -122.432115704961)
145322 33995 1 118 120 Faith St 1 1 1 1 1 10/18/1997 12:00:00 AM     Permit Number 38457 6010502.26399862 2099074.74698805 37.7442517881202 -122.40634471521003 (37.7442517881202, -122.40634471521)
145468 32758 1 118 100x THRIFT ST 2 1 1 1 1 10/29/1996 12:00:00 AM     Permit Number 37135 5995486.0 2089629.0 37.7174646081384 -122.45758410365801 (37.7174646081384, -122.457584103658)
145817 91476 1 118 601 25th St 7 1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51637 6016776.9 2102119.9 37.7529621548081 -122.384860265748 (37.7529621548081, -122.384860265748)
146611 206798 2 118 714 Detroit St 15 17 1 1     13     5999465.474230001 2095438.72707 37.7336445658277 -122.444246198512 (37.7336445658277, -122.444246198512)
147051 223674 2 118 300 Clipper St 5 1 1 1     7 Width 3ft   6003026.25386 2100972.90795 37.7490426526966 -122.432330671519 (37.7490426526966, -122.432330671519)
147774 223681 2 118 300 Clipper St 17 1 1 1     13 Width 3ft   6002667.71298 2100952.64567 37.7489666806705 -122.433569059575 (37.7489666806705, -122.433569059575)
148055 202149 2 118 1967 Armstrong Ave 1 9 1 1     7 Width 7ft   6012987.61375 2093482.17002 37.7290344539678 -122.39735873424101 (37.7290344539678, -122.397358734241)
150287 176084 2 118 301 Tunnel Ave 1 1 1 1     4 Width 3ft   6011735.35451 2086672.5104200002 37.710266710803104 -122.401209595273 (37.7102667108031, -122.401209595273)
151533 126407 2 118 2610 Clay St 22 1 1 1     10 Width 5ft   6001526.97686 2116002.32801 37.7902245832452 -122.43859190811399 (37.7902245832452, -122.438591908114)
151741 176091 2 118 301 Tunnel Ave 8 1 1 1     2 Width 3ft   6011761.10909 2086779.81535 37.7105627856051 -122.401128116692 (37.7105627856051, -122.401128116692)
152240 202158 2 118 1913 Armstrong Ave 1 9 1 1     5 Width 7ft   6013140.94695 2093368.78005 37.7287316441256 -122.39682069951701 (37.7287316441256, -122.396820699517)
154499 88668 1 118 601 25th St 9 1 1 1   08/05/2008 12:00:00 AM 5 3x3 Permit Number 51637 6016777.6314900005 2102112.60454 37.7529421634534 -122.38485722789 (37.7529421634534, -122.38485722789)
155140 202207 2 118 1968 Armstrong Ave 1 9 1 1     9 Width 7ft   6013020.76239 2093529.61913 37.72916658504629 -122.397247462005 (37.7291665850463, -122.397247462005)
155539 190952 2 118 50 Southern Heights Ave 3 2 1 1     5 Width 7ft   6012228.79731 2104083.07063 37.7580999894276 -122.400726473151 (37.7580999894276, -122.400726473151)
156099 88662 1 118 601 25th St 3 1 1 1   08/05/2008 12:00:00 AM 3 3x3 Permit Number 51637 6016419.5289900005 2102093.1245 37.7528688624307 -122.386094267831 (37.7528688624307, -122.386094267831)
158662 223670 2 118 2 Powhattan Ave 2 1 1 1     7 Width 3ft   6007488.19675 2098176.2850900004 37.7416157445795 -122.416703102889 (37.7416157445795, -122.416703102889)
158962 202201 2 118 1948 Armstrong Ave 1 9 1 1     9 Width 7ft   6013078.4423 2093486.02938 37.729050107561605 -122.39704500125099 (37.7290501075616, -122.397045001251)
159166 202148 2 118 1973 Armstrong Ave 1 9 1 1     8 Width 7ft   6012979.956230001 2093488.41205 37.7290511669581 -122.397385644629 (37.7290511669581, -122.397385644629)
161132 202144 2 118 1999 Armstrong Ave 2 2 1 1     7 Width 7ft   6012917.46969 2093534.23595 37.7291735107263 -122.39760487958598 (37.7291735107263, -122.397604879586)
161404 36946 1 118 165 03rd Ave 2 1 1 1 1 05/29/1998 12:00:00 AM 7   Permit Number 39581 5994879.55101 2114458.4572900003 37.7856051482988 -122.461479365875 (37.7856051482988, -122.461479365875)
161512 190957 2 118 580 07th St 1 1 1 1     9 Width 3ft   6011496.47934 2109620.41486 37.773263416204294 -122.403648760805 (37.7732634162043, -122.403648760805)
162671 206797 2 118 415 Garfield St 1 4 1 1     2 Width 3ft   5992912.29675 2090464.70197 37.7196110652749 -122.466540843488 (37.7196110652749, -122.466540843488)
163960 248035 2 118 132 Faith St 1 1 1 1     7 Width 2ft   6010441.24954 2099079.47689 37.744261362076294 -122.40655602435899 (37.7442613620763, -122.406556024359)
164286 202206 2 118 1976 Armstrong Ave 1 9 1 1     7 Width 7ft   6013013.79593 2093534.14859 37.7291786341692 -122.397271863302 (37.7291786341692, -122.397271863302)
Powered by Datasette · Query took 5.221ms · Data source: data.sfgov.org