sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
116897 108813 2 54 301-399 University St 10 1 1 1           6008160.407269999 2092653.74948 37.726489845684796 -122.41398823310301 (37.7264898456848, -122.413988233103)
83697 108792 1 54 201-299 University St 4 1 1 1 1         6008053.41125 2093004.09823 37.727445818429295 -122.414382893832 (37.7274458184293, -122.414382893832)
85159 108793 1 54 201-299 University St 5 1 1 1 1         6008053.41125 2093004.09823 37.727445818429295 -122.414382893832 (37.7274458184293, -122.414382893832)
135877 199650 2 54 0 1 4 1 1     0 Width 0ft   6014963.58685 2093280.8179400002 37.728591398452394 -122.390513521988 (37.7285913984524, -122.390513521988)
85350 40070 1 54 1434 Thomas Ave 1 1 1 1 1 02/19/1999 12:00:00 AM     Permit Number 41296 6015644.04223078 2093317.32333735 37.7287293601115 -122.388163675017 (37.7287293601115, -122.388163675017)
183672 200636 2 54 1301 Quesada Ave 1 2 1 1     0 Width 0ft   6016782.3625 2093458.8747 37.729181036936396 -122.384238246013 (37.7291810369364, -122.384238246013)
111918 109831 1 54 146 Staples Ave 1 5 2 1       12x15.3   5999109.5 2093827.3 37.7291996500545 -122.445361075989 (37.7291996500545, -122.445361075989)
92954 97034 7 54 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
113475 46634 1 54 1569 Underwood Ave 1 1 1 1 1 04/12/2002 12:00:00 AM     Permit Number 44755 6014739.185840401 2093576.72961431 37.729391461068204 -122.391309972305 (37.7293914610682, -122.391309972305)
127351 35482 1 54 1136 Silver Ave 1 1 1 1 1 09/16/2000 12:00:00 AM     Permit Number 40088 6008340.04148266 2093836.36406151 37.7297471396453 -122.413450843683 (37.7297471396453, -122.413450843683)
36680 200762 2 54 1999 Lane St 1 2 1 1     0 Width 0ft   6014632.1803 2093750.8421 37.7298635995705 -122.39169207228201 (37.7298635995705, -122.391692072282)
158995 200766 2 54 1901 Lane St 1 2 1 1     0 Width 0ft   6014720.1223 2093871.3227 37.7301992962685 -122.39139646330901 (37.7301992962685, -122.391396463309)
154317 200577 2 54 1701 Keith St 1 2 1 1     0 Width 0ft   6015592.5071 2093926.7262 37.7303998031535 -122.38838435336201 (37.7303998031535, -122.388384353362)
101816 31149 1 54 500 Hearst Ave 4 1 1 1 1 03/21/1995 12:00:00 AM     Permit Number 34853 5998089.630643 2094417.27408922 37.730761307799504 -122.44892931603 (37.7307613077995, -122.44892931603)
126759 31148 1 54 500 Hearst Ave 3 1 1 1 1 03/21/1995 12:00:00 AM     Permit Number 34853 5998089.630643 2094417.27408922 37.730761307799504 -122.44892931603 (37.7307613077995, -122.44892931603)
43479 122819 2 54 121 Cayuga Ave 1 1 1 1       3x3   6003309.0 2094407.0 37.7310302083694 -122.430884409483 (37.7310302083694, -122.430884409483)
85267 46322 1 54 3080 25th Ave 1 1 1 1   02/12/2002 12:00:00 AM     Permit Number 44576 5988871.55058969 2094853.71729449 37.731428183192705 -122.480829241755 (37.7314281831927, -122.480829241755)
100812 115070 6 54 401 DARIEN WAY 1 7 1 1     17     5992724.0 2094938.0 37.7318827746659 -122.467516839465 (37.7318827746659, -122.467516839465)
129662 200808 2 54 1401 Oakdale Ave 1 2 1 1     0 Width 0ft   6016065.8568 2094678.3259 37.732489764259896 -122.386800296411 (37.7324897642599, -122.386800296411)
74359 200626 2 54 1370 Newcomb Ave 1 1 1 1     0 Width 0ft   6016343.0854 2094895.2737 37.7331008048792 -122.38585695867201 (37.7331008048792, -122.385856958672)
187469 200742 2 54 1454 Oakdale Ave 1 19 1 1     0 Width 0ft   6015834.4667 2094922.2745 37.733146784173606 -122.38761728786601 (37.7331467841736, -122.387617287866)
125838 121591 2 54 162 Mangels Ave 1 9 1 1       3x3   6000339.0 2095263.0 37.7332118579221 -122.44121356967199 (37.7332118579221, -122.441213569672)
173333 200730 2 54 1466 Oakdale Ave 1 19 1 1     0 Width 0ft   6015770.4184 2094966.2292 37.733263927070006 -122.387841787924 (37.73326392707, -122.387841787924)
135055 200729 2 54 1481 Oakdale Ave 1 1 1 1     0 Width 0ft   6015678.7414 2094969.3688 37.7332674687178 -122.38815896225799 (37.7332674687178, -122.388158962258)
42125 200722 2 54 1476 Oakdale Ave 1 19 1 1     0 Width 0ft   6015747.1852 2094980.6714 37.7333022953684 -122.387923119588 (37.7333022953684, -122.387923119588)
96301 101476 6 54 541 Congo St 1 1 1 1   05/07/2015 12:00:00 AM 3   Permit Number 775316 6000089.0 2095440.1 37.7336838892166 -122.44209059296301 (37.7336838892166, -122.442090592963)
173497 200570 2 54 1445 La Salle Ave 3 1 1 1     0 Width 0ft   6016341.8296 2095299.657 37.7342110910182 -122.38588947759399 (37.7342110910182, -122.385889477594)
74054 185122 2 54 2850 34th Ave 2 1 1 1     0 Width 0ft   5985897.3509 2095993.4067 37.734384144878 -122.49119531195299 (37.734384144878, -122.491195311953)
183233 186926 2 54 2800 Sunset Blvd 1 2 1 1     0 Width 0ft   5985157.2666 2096011.7096 37.734391129301 -122.493755335707 (37.734391129301, -122.493755335707)
33122 185071 2 54 2800 37th Ave 1 2 1 1     0 Width 0ft   5984981.8139 2096034.5991 37.7344437114318 -122.49436361071899 (37.7344437114318, -122.494363610719)
58562 185072 2 54 2801 Sunset Blvd 1 2 1 1     0 Width 0ft   5985073.9331 2096042.9736 37.73447209618271 -122.494045746017 (37.7344720961827, -122.494045746017)
79667 109978 2 54 75 Escondido Ave 1 1 1 1       3x3   5986097.0 2096084.1 37.73464482809 -122.490511739576 (37.73464482809, -122.490511739576)
33065 185060 3 54 10x El Mirasol Pl 1 11 1 2     0 Width 0ft   5987413.8008 2096060.1353 37.7346558528299 -122.485957413668 (37.7346558528299, -122.485957413668)
174948 200699 2 54 1501 Lane St 1 2 1 1     0 Width 0ft   6015860.7307 2095472.4329 37.734658863200295 -122.38756485421699 (37.7346588632003, -122.387564854217)
19242 36516 1 54 430 Crescent Ave 3 1 1 1 1 05/18/1998 12:00:00 AM     Permit Number 39394 6007460.82693634 2095697.00770714 37.7348066562255 -122.416622148824 (37.7348066562255, -122.416622148824)
30528 36517 1 54 430 Crescent Ave 2 1 1 1 1 05/18/1998 12:00:00 AM     Permit Number 39394 6007460.82693634 2095697.00770714 37.7348066562255 -122.416622148824 (37.7348066562255, -122.416622148824)
89025 36518 1 54 430 Crescent Ave 4 1 1 1 1 05/18/1998 12:00:00 AM     Permit Number 39394 6007460.82693634 2095697.00770714 37.7348066562255 -122.416622148824 (37.7348066562255, -122.416622148824)
118134 36519 1 54 430 Crescent Ave 1 1 1 1 1 05/18/1998 12:00:00 AM     Permit Number 39394 6007460.82693634 2095697.00770714 37.7348066562255 -122.416622148824 (37.7348066562255, -122.416622148824)
116859 45263 1 54 673 Andover St 1 1 1 1 1 06/12/2001 12:00:00 AM     Permit Number 44109 6007439.21136226 2095836.00424965 37.7351870945672 -122.41670672522 (37.7351870945672, -122.41670672522)
69532 184973 2 54 2701 Sunset Blvd 8 1 1 1     0 Width 0ft   5985060.7433 2096318.9125 37.7352289790934 -122.494111677716 (37.7352289790934, -122.494111677716)
51515 120669 2 54 61 Paradise Ave 1 1 1 1   08/22/2016 12:00:00 AM 3 3x3   6000974.0 2096001.0 37.7352743855737 -122.43907108078899 (37.7352743855737, -122.439071080789)
30889 245370 2 54 3943 Mission St 1 1 1 1     0 Width 0ft   6005173.0525 2095986.3930000002 37.7354723102432 -122.42455236124201 (37.7354723102432, -122.424552361242)
132272 185049 2 54 2731 41st Ave 1 1 1 1     0 Width 0ft   5983672.3577 2096556.9514 37.7358012305935 -122.49892933938999 (37.7358012305935, -122.49892933939)
133705 184974 2 54 2700 37th Ave 1 1 1 1     0 Width 0ft   5984964.6462 2096531.6242 37.735807405046 -122.494459590864 (37.735807405046, -122.494459590864)
125370 3826 3 54 120 Cashmere St 1 1 1 2   11/16/1992 12:00:00 AM 3 3X3   6016868.5122165 2095917.6664165 37.7359371538987 -122.384111573291 (37.7359371538987, -122.384111573291)
188648 182915 2 54 2711 47th Ave 2 1 1 1     0 Width 0ft   5981812.2124 2096648.8938 37.7359443944789 -122.505367292654 (37.7359443944789, -122.505367292654)
127642 36507 1 54 584 Anderson St 2 1 1 1 1 03/29/2003 12:00:00 AM     Permit Number 39385 6007790.43718065 2096197.35426509 37.736199030760105 -122.41551798135401 (37.7361990307601, -122.415517981354)
151546 182946 2 54 3500 Wawona St 1 2 1 1     0 Width 0ft   5982068.7362 2096751.2664 37.7362405734928 -122.504487984804 (37.7362405734928, -122.504487984804)
29214 182945 2 54 2691 47th Ave 1 1 1 1     0 Width 0ft   5981809.5051 2096798.8146 37.7363558765881 -122.50538776138 (37.7363558765881, -122.50538776138)
77586 121129 2 54 201 Bemis St 4 1 1 1   09/09/2016 12:00:00 AM 3 3x3   6003216.0 2096386.0 37.7364588227531 -122.431347141396 (37.7364588227531, -122.431347141396)
97368 121128 2 54 201 Bemis St 3 1 1 1   09/09/2016 12:00:00 AM 3 3x3   6003216.0 2096386.0 37.7364588227531 -122.431347141396 (37.7364588227531, -122.431347141396)
99672 121127 2 54 201 Bemis St 2 1 1 1   09/09/2016 12:00:00 AM 3 3x3   6003216.0 2096386.0 37.7364588227531 -122.431347141396 (37.7364588227531, -122.431347141396)
119911 121130 2 54 201 Bemis St 5 1 1 1       3x3   6003216.0 2096386.0 37.7364588227531 -122.431347141396 (37.7364588227531, -122.431347141396)
145560 121126 2 54 201 Bemis St 1 1 1 1   09/09/2016 12:00:00 AM 3 3x3   6003216.0 2096386.0 37.7364588227531 -122.431347141396 (37.7364588227531, -122.431347141396)
154543 182944 2 54 2678 47th Ave 1 2 1 1     0 Width 0ft   5981851.131 2096866.8374 37.7365450979685 -122.50524888568701 (37.7365450979685, -122.505248885687)
147162 182943 2 54 2674 47th Ave 1 2 1 1     0 Width 0ft   5981850.1157 2096894.2496 37.7366203046104 -122.505254426993 (37.7366203046104, -122.505254426993)
137654 182938 2 54 2657 47th Ave 1 2 1 1     0 Width 0ft   5981803.7519 2096965.6566 37.7368136403966 -122.505420015001 (37.7368136403966, -122.505420015001)
35754 182933 2 54 2646 47th Ave 1 2 1 1     0 Width 0ft   5981845.0394 2097064.8142 37.7370883295038 -122.505284615423 (37.7370883295038, -122.505284615423)
48113 185273 2 54 2601 Sunset Blvd 6 2 1 1     0 Width 0ft   5985037.6088 2097007.6084 37.7371186003252 -122.494242407159 (37.7371186003252, -122.494242407159)
74865 182936 2 54 2643 46th Ave 1 1 1 1     0 Width 0ft   5982105.6241 2097104.0711 37.737211448275794 -122.50438657908998 (37.7372114482758, -122.50438657909)
181678 182929 2 54 2635 47th Ave 1 2 1 1     0 Width 0ft   5981797.6603 2097141.2975 37.737295543609996 -122.50545409100799 (37.73729554361, -122.505454091008)
67752 185275 2 54 2600 37th Ave 1 2 1 1     0 Width 0ft   5984941.5117 2097207.3396 37.7376613847371 -122.494589373511 (37.7376613847371, -122.494589373511)
40189 183398 2 54 2676 23rd Ave 1 2 1 1     0 Width 0ft   5989291.1458 2097146.7716 37.7377487006662 -122.479546347444 (37.7377487006662, -122.479546347444)
41622 183384 2 54 2659 23rd Ave 1 1 1 1     0 Width 0ft   5989243.3159 2097242.4314 37.7380085792734 -122.479718714161 (37.7380085792734, -122.479718714161)
34204 183601 2 54 2647 22nd Ave 1 2 1 1     0 Width 0ft   5989550.5846 2097326.397 37.7382569723881 -122.47866248497401 (37.7382569723881, -122.478662484974)
41764 183600 2 54 2639 22nd Ave 2 2 1 1     0 Width 0ft   5989549.7171 2097348.9516 37.738318851123 -122.47866713334 (37.738318851123, -122.47866713334)
51779 183592 2 54 2626 26th Ave 1 2 1 1     0 Width 0ft   5988353.2202 2097405.0036 37.738403211903204 -122.482808088928 (37.7384032119032, -122.482808088928)
93908 51029 1 54 133 Ellert St 1 1 1 1   07/19/2011 12:00:00 AM   3x3 Permit Number 767941 6007256.96585115 2097027.84886938 37.7384493854458 -122.417421253654 (37.7384493854458, -122.417421253654)
29089 183590 2 54 2630 23rd Ave 1 1 1 1     0 Width 0ft   5989282.842 2097424.4506 37.7385106529577 -122.47959536842899 (37.7385106529577, -122.479595368429)
155025 245380 2 54 3620 Mission St 2 1 1 1     0 Width 0ft   6005334.5439 2097112.3285 37.7385729952273 -122.424074069598 (37.7385729952273, -122.424074069598)
171810 183571 2 54 1950 Vicente St 1 2 1 1     0 Width 0ft   5986841.6497 2097598.0157 37.7388451080573 -122.48804847269699 (37.7388451080573, -122.488048472697)
117306 104857 1 54 2555 46th Ave   1 2 1           5982069.8 2097707.6 37.7388664658919 -122.504555139124 (37.7388664658919, -122.504555139124)
69546 183561 2 54 1842 Vicente St 1 2 1 1     0 Width 0ft   5987180.92 2097610.4334 37.7388989899745 -122.486876361154 (37.7388989899745, -122.486876361154)
110497 38040 1 54 271 Wawona St 1 1 1 1 1 07/10/1998 12:00:00 AM     Permit Number 40242 5992319.7729488 2097504.33557698 37.7389059415194 -122.46910103166401 (37.7389059415194, -122.469101031664)
176431 183053 2 54 2601 19th Ave 1 2 1 1     0 Width 0ft   5990456.6898 2097547.4037 37.738916368412106 -122.47554578609 (37.7389163684121, -122.47554578609)
151024 185250 2 54 2582 33rd Ave 1 2 1 1     0 Width 0ft   5986168.5104 2097675.5504 37.7390187057813 -122.49038154463301 (37.7390187057813, -122.490381544633)
115253 106460 2 54 701 Cortland Ave 3 1 1 2           6007932.0 2097222.5 37.739021812259104 -122.415101080128 (37.7390218122591, -122.415101080128)
117839 106461 2 54 701 Cortland Ave 4 1 1 2           6007932.0 2097222.5 37.739021812259104 -122.415101080128 (37.7390218122591, -122.415101080128)
130550 183044 2 54 2538 Lower Great Hwy 1 1 1 1     0 Width 0ft   5981509.8326 2097796.9898 37.739078951665704 -122.50649783936599 (37.7390789516657, -122.506497839366)
125761 108576 7 54 2479 Diamond St 1 7 2 1           6002240.0 2097369.0 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338)
181628 183542 2 54 2598 27th Ave 1 2 1 1     0 Width 0ft   5988033.5951 2097670.443 37.7391134369583 -122.483932641735 (37.7391134369583, -122.483932641735)
167902 185253 2 54 2566 35th Ave 1 2 1 1     0 Width 0ft   5985543.2782 2097747.3201 37.739179229362705 -122.4925485642 (37.7391792293627, -122.4925485642)
69138 185252 2 54 2567 33rd Ave 1 2 1 1     0 Width 0ft   5986119.691000001 2097773.7197 37.7392854011049 -122.49055755796302 (37.7392854011049, -122.490557557963)
157360 185251 2 54 2566 33rd Ave 1 2 1 1     0 Width 0ft   5986166.3878 2097773.7197 37.7392881285851 -122.490396103482 (37.7392881285851, -122.490396103482)
166140 183547 2 54 2596 23rd Ave 1 1 1 1     0 Width 0ft   5989272.1918 2097727.998 37.7393434967425 -122.47965439539101 (37.7393434967425, -122.479654395391)
51477 183544 2 54 2575 28th Ave 1 2 1 1     0 Width 0ft   5987672.5493 2097766.1311 37.739355145969206 -122.48518797755 (37.7393551459692, -122.48518797755)
67201 185245 2 54 2562 33rd Ave 1 2 1 1     0 Width 0ft   5986166.3878 2097803.4358 37.73936972108589 -122.49039828899599 (37.7393697210859, -122.490398288996)
72168 182979 2 54 800 Vicente St 1 2 1 1     0 Width 0ft   5990295.2626 2097717.7991 37.739374871061294 -122.47611636270099 (37.7393748710613, -122.476116362701)
171184 183041 2 54 2518 Lower Great Hwy 1 1 1 1     0 Width 0ft   5981505.7715 2097922.8827 37.7394243796804 -122.506521214497 (37.7394243796804, -122.506521214497)
148201 183536 2 54 2576 26th Ave 1 2 1 1     0 Width 0ft   5988338.1627 2097791.2913 37.7394629808799 -122.48288845238899 (37.7394629808799, -122.482888452389)
132675 183534 2 54 2575 26th Ave 1 2 1 1     0 Width 0ft   5988292.8495 2097803.675 37.739494346597795 -122.483046031116 (37.7394943465978, -122.483046031116)
153506 185241 2 54 2551 34th Ave 1 2 1 1     0 Width 0ft   5985807.672 2097858.4902 37.73949992809371 -122.49164260379601 (37.7394999280937, -122.491642603796)
131751 185242 2 54 2554 33rd Ave 1 2 1 1     0 Width 0ft   5986164.2652 2097852.2551 37.7395036419136 -122.490409218419 (37.7395036419136, -122.490409218419)
133418 185243 2 54 2555 33rd Ave 1 2 1 1     0 Width 0ft   5986116.5072 2097857.5616 37.7395154226653 -122.490574732795 (37.7395154226653, -122.490574732795)
32899 183517 2 54 2558 29th Ave 1 1 1 1     0 Width 0ft   5987405.7216 2097878.3252 37.739647654239604 -122.486118771525 (37.7396476542396, -122.486118771525)
76561 183521 2 54 2567 25th Ave 1 2 1 1     0 Width 0ft   5988601.5425 2097854.7918 37.739652658082 -122.481982461654 (37.739652658082, -122.481982461654)
172095 183010 2 54 2500 37th Ave 1 2 1 1     0 Width 0ft   5984919.7169 2097961.3416 37.7397303960744 -122.494720300824 (37.7397303960744, -122.494720300824)
81123 36532 1 54 3734St. Folsom St 1 1 1 1 1 05/18/1998 12:00:00 AM     Permit Number 39405 6008419.88910724 2097501.78967285 37.7398160862313 -122.413433924041 (37.7398160862313, -122.413433924041)
155656 183518 2 54 2547 29th Ave 1 2 1 1     0 Width 0ft   5987357.881 2097941.2897 37.73981774986029 -122.486288802943 (37.7398177498603, -122.486288802943)
171329 185237 2 54 2534 33rd Ave 1 2 1 1     0 Width 0ft   5986160.02 2097977.4873 37.7398472482312 -122.490433106843 (37.7398472482312, -122.490433106843)
60847 183475 2 54 2543 24th Ave 5 1 1 1     0 Width 0ft   5988910.1133 2097942.5592 37.739911585859296 -122.480921992881 (37.7399115858593, -122.480921992881)
Powered by Datasette · Query took 12.284ms · Data source: data.sfgov.org