sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
115306 83302 1 48 2366 45th Ave 1 1 1 1   06/09/2008 12:00:00 AM   3x3 Permit Number 50740 5982401.73888916 2099005.47811571 37.7424496018256 -122.50350355043501 (37.7424496018256, -122.503503550435)
115536 50120 1 48 243 Vicente St 1 1 1 1   09/14/2012 12:00:00 AM     Permit Number 769150 5992346.75268289 2097836.73381964 37.7398201819052 -122.469031933295 (37.7398201819052, -122.469031933295)
116014 88480 1 48 1221 Newhall St 1 1 1 1   07/18/2008 12:00:00 AM   3x3 Permit Number 51432 6014837.0 2096254.0 37.7367481304458 -122.391158879645 (37.7367481304458, -122.391158879645)
117474 88087 1 48 1254 38th Ave   1 1 1   06/30/2008 12:00:00 AM   3x3 Permit Number 51087 5984334.6 2106629.9 37.7634975987144 -122.497383137852 (37.7634975987144, -122.497383137852)
117507 38914 1 48 70 Borica St 2 1 1 1 1 11/02/1998 12:00:00 AM     Permit Number 40725 5992519.41888039 2091685.55807474 37.722940558785794 -122.46798762393101 (37.7229405587858, -122.467987623931)
118027 79726 1 48 780 Post St 1 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50955 6008416.19534554 2114892.53002417 37.7875668360064 -122.414677080613 (37.7875668360064, -122.414677080613)
118463 102093 1 48 19 Stoneman St 2 1 1 1 1 12/18/2012 12:00:00 AM   3x3 Permit Number 769735 6008292.3 2099391.0 37.744996275991504 -122.414008688761 (37.7449962759915, -122.414008688761)
118548 48663 1 48 1300 11th Ave 3 1 1 1 1 08/03/2002 12:00:00 AM     Permit Number 45949 5992726.08644889 2106595.37916826 37.76389107150929 -122.468357408335 (37.7638910715093, -122.468357408335)
118920 113357 3 48 2 POINT LOBOS AVE 5 1 1 2       3X3   5982777.0 2112621.0 37.779856011140204 -122.50321389449499 (37.7798560111402, -122.503213894495)
119216 42105 1 48 305 Hearst Ave 1 1 1 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51455 5999382.77994639 2094344.80390055 37.730636191213996 -122.444453504412 (37.730636191214, -122.444453504412)
119242 87861 1 48 96 Caselli Ave 3 1 1 1   06/11/2008 12:00:00 AM   3x3 Permit Number 50803 6000485.4 2104954.1 37.7598296396585 -122.441402573572 (37.7598296396585, -122.441402573572)
120284 52292 1 48 100 Tiffany Ave 1 1 1 1 1 11/29/2005 12:00:00 AM     Permit Number 48451 6006201.82590602 2099532.89904471 37.7452682661505 -122.421247257698 (37.7452682661505, -122.421247257698)
120684 88438 1 48 1248 Mason St   1 1 1   06/30/2009 12:00:00 AM   3x3 Permit Number 52242 6009421.0 2117567.0 37.794966684082105 -122.41138965638599 (37.7949666840821, -122.411389656386)
120706 94162 1 48 1750 09th Ave 1 1 1 1   06/15/2010 12:00:00 AM   3x3 Permit Number 53533 5993469.4 2103573.4 37.7556364086322 -122.46556697517799 (37.7556364086322, -122.465566975178)
121973 51978 1 48 571 Noe St 1 1 1 1   06/11/2008 12:00:00 AM   3x3 Permit Number 50788 6003031.54377055 2104930.91129788 37.7599106895436 -122.432595060758 (37.7599106895436, -122.432595060758)
122238 94679 1 48 218 Roanoke St 1 5 1 1 1 10/22/2010 12:00:00 AM   3x3 Permit Number 53815 6003547.0 2096007.0 37.73543692838779 -122.43017570506201 (37.7354369283878, -122.430175705062)
122625 59404 1 48 129 Rousseau St 1 1 1 1   01/05/2016 12:00:00 AM     Permit Number 770892 6003547.68037437 2095024.45734525 37.732739127589895 -122.43010328255899 (37.7327391275899, -122.430103282559)
122796 95901 1 48 1700 23rd Ave 5 1 1 1 1 07/27/2011 12:00:00 AM   3x3 Permit Number 767603 5989092.0 2103686.6 37.7556937768723 -122.48071351405399 (37.7556937768723, -122.480713514054)
124038 95719 1 48 950 Avalon Ave 4 1 1 1 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047)
124292 43060 1 48 3054 TARAVAL ST 1 1 1 1   07/07/2000 12:00:00 AM     Permit Number 53563 5983697.0 2098912.0 37.7422690003261 -122.499018090006 (37.7422690003261, -122.499018090006)
124698 94673 1 48 662 Joost Ave 1 1 1 1 1 10/22/2010 12:00:00 AM   3x3 Permit Number 53809 5997706.3 2095032.9 37.7324297402139 -122.450298904109 (37.7324297402139, -122.450298904109)
125423 92663 1 48 791 San Bruno Ave 1 5 1 1   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.759644317200106 -122.404916188138 (37.7596443172001, -122.404916188138)
125426 88257 1 48 436 Belvedere St 2 1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51241 5998536.0 2106665.0 37.76441609532 -122.44826776566099 (37.76441609532, -122.448267765661)
125524 37416 1 48 1137 Diamond St 1 1 1 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51465 6001976.15825924 2100785.18555 37.748467612799104 -122.435948474317 (37.7484676127991, -122.435948474317)
125716 95718 1 48 950 Avalon Ave 3 1 1 1 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047)
125737 50110 1 48 250 Taraval St 1 1 1 1 1 07/28/2003 12:00:00 AM     Permit Number 46832 5992489.27392501 2099148.73533454 37.7434308389356 -122.468634598074 (37.7434308389356, -122.468634598074)
125857 39613 1 48 577 Frederick St 1 1 1 1 1 06/20/2000 12:00:00 AM     Permit Number 42206 5996839.91957309 2107330.11638831 37.7661452244472 -122.454182049235 (37.7661452244472, -122.454182049235)
126920 41825 1 48 2511 Turk Blvd 1 1 1 1   06/20/2000 12:00:00 AM     Permit Number 42211 5998436.39026341 2111725.32035622 37.77830474661771 -122.44897683474 (37.7783047466177, -122.44897683474)
127325 95684 1 48 334 Oxford St 1 1 1 1 1 03/08/2011 12:00:00 AM   3x3 Permit Number 767433 6006626.2 2092405.9 37.72572301772 -122.41927436138599 (37.72572301772, -122.419274361386)
128274 94410 1 48 63 Alpine Ter 1 1 1 1   07/27/2010 12:00:00 AM   3x3 Permit Number 53650 6001682.9 2108449.6 37.7694955715896 -122.43751133674101 (37.7694955715896, -122.437511336741)
128684 48661 1 48 1300 11th Ave 1 1 1 1 1 06/25/2005 12:00:00 AM     Permit Number 45949 5992726.08644889 2106595.37916826 37.76389107150929 -122.468357408335 (37.7638910715093, -122.468357408335)
129031 102064 1 48 102 Anderson St 1 1 1 1 1 07/10/2009 12:00:00 AM   3x3 Permit Number 52559 6007929.8 2098099.2 37.7414289135067 -122.415170728099 (37.7414289135067, -122.415170728099)
129114 88495 1 48 27 Reddy St   1 1 1   07/18/2008 12:00:00 AM   3x3 Permit Number 51437 6013659.0 2094063.0 37.7306666521666 -122.39507835000201 (37.7306666521666, -122.395078350002)
129402 88096 1 48 1795 40th Ave   1 1 1   06/30/2008 12:00:00 AM   3x3 Permit Number 51099 5983752.7 2102993.7 37.7534794912156 -122.49912702260201 (37.7534794912156, -122.499127022602)
138459 83961 1 48 180 Parnassus Ave 1 1 1 1   06/16/2008 12:00:00 AM   3x3 Permit Number 50859 5997460.19616594 2106774.33360384 37.7646547355545 -122.451996543237 (37.7646547355545, -122.451996543237)
138846 115174 1 48 1234 46th Ave 1 1 1 1   01/14/2016 12:00:00 AM     Permit Number 777353 5981842.5 2106688.0 37.7635107458641 -122.506006674694 (37.7635107458641, -122.506006674694)
139293 38921 1 48 749 Lakeview Ave 1 1 1 1 1 11/02/1998 12:00:00 AM     Permit Number 40731 5994544.80644489 2089901.89590816 37.718159804985795 -122.460857119734 (37.7181598049858, -122.460857119734)
139815 47598 1 48 100 Alemany Blvd 1 1 1 1 1 01/04/2003 12:00:00 AM     Permit Number 45435 6009710.93340167 2096438.06354235 37.7369677288425 -122.408894986555 (37.7369677288425, -122.408894986555)
140085 44279 1 48 1588 Newhall St 3 1 1 1 1 08/16/2011 12:00:00 AM   3x3 Permit Number 767652 6014189.45600011 2095460.4720273998 37.7345333093335 -122.393342225003 (37.7345333093335, -122.393342225003)
140129 52129 1 48 220 Pierce St 1 1 1 1   08/11/2008 12:00:00 AM   3x3 Permit Number 51660 6002806.0471415995 2109304.34219127 37.7719062747483 -122.433687517115 (37.7719062747483, -122.433687517115)
140250 50524 1 48 3651 20th St 1 1 1 1 1 11/03/2003 12:00:00 AM     Permit Number 47164 6005968.07304834 2104305.31315666 37.758359035924 -122.42239456826401 (37.758359035924, -122.422394568264)
141159 113139 1 48 1799x 25TH AVE 1 1 1 1       3x3   5988397.0 2103119.0 37.754094880795606 -122.48307541499399 (37.7540948807956, -122.483075414994)
142118 115183 1 48 3610 Quintara St 1 1 1 1   01/15/2016 12:00:00 AM     Permit Number 774488 5982230.3 2100857.8 37.747525483427296 -122.50423350924 (37.7475254834273, -122.50423350924)
143579 46893 1 48 1383 11th Ave 2 1 1 1 1 04/26/2002 12:00:00 AM     Permit Number 44948 5992692.47897134 2106059.86172468 37.7624187406256 -122.46843468168501 (37.7624187406256, -122.468434681685)
143883 88733 1 48 56 Webster St 1 1 1 1   08/11/2008 12:00:00 AM   3x3 Permit Number 51668 6004334.0 2108794.0 37.7705915794801 -122.428365836994 (37.7705915794801, -122.428365836994)
144080 47592 1 48 100 Alemany Blvd 8 1 1 1 1 05/20/2002 12:00:00 AM     Permit Number 45435 6009710.93340167 2096438.06354235 37.7369677288425 -122.408894986555 (37.7369677288425, -122.408894986555)
144304 88645 1 48 2500x Larkin St   1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51618 6006882.7 2119972.1 37.8014277902223 -122.420343352043 (37.8014277902223, -122.420343352043)
144821 47551 1 48 1689 Noe St 1 1 1 1 1 05/14/2002 12:00:00 AM     Permit Number 45415 6003395.23441175 2098403.20907691 37.7420077721371 -122.430871369414 (37.7420077721371, -122.430871369414)
144924 114895 5 48 820 30th Ave 1 1 1 1   12/21/2015 12:00:00 AM     Permit Number 775427 5986664.4 2110325.3 37.7737804103986 -122.489596975753 (37.7737804103986, -122.489596975753)
144940 88723 1 48 1001 Page St 1 1 1 1   08/11/2008 12:00:00 AM   3x3 Permit Number 51659 6001771.0 2109412.0 37.772143091507296 -122.43727552323799 (37.7721430915073, -122.437275523238)
145049 52944 1 48 20 Paulding St 1 1 1 1   08/03/2006 12:00:00 AM     Permit Number 48931 6000207.27773758 2093260.71462594 37.727706542786 -122.44152533408399 (37.727706542786, -122.441525334084)
145553 94670 1 48 654 Joost Ave 1 1 1 1 1 10/22/2010 12:00:00 AM   3x3 Permit Number 53807 5997755.7 2095032.2 37.7324306451966 -122.450128067067 (37.7324306451966, -122.450128067067)
145610 45368 1 48 201x OGDEN AVE 1 1 1 1 1 06/28/2001 12:00:00 AM     Permit Number 44193 6007843.0 2096159.0 37.7360966727045 -122.415333535238 (37.7360966727045, -122.415333535238)
145696 47037 1 48 714 Waller St 1 1 1 1 1 09/30/2015 12:00:00 AM     Permit Number 776491 6002280.60768666 2108833.96933031 37.770584918853395 -122.435471392977 (37.7705849188534, -122.435471392977)
145721 95900 1 48 1700 23rd Ave 4 1 1 1 1 07/27/2011 12:00:00 AM   3x3 Permit Number 767603 5989092.0 2103686.6 37.7556937768723 -122.48071351405399 (37.7556937768723, -122.480713514054)
145967 96065 1 48 168 Richland Ave 1 1 1 1 1 08/03/2011 12:00:00 AM   3x3 Permit Number 767690 6005459.8 2096128.8 37.7358795176789 -122.423571087421 (37.7358795176789, -122.423571087421)
11046 116538 3 48 1002x Naples St 1 3 1 2     1 3x3   6001578.1015800005 2088233.43486 37.7139807660769 -122.436426724612 (37.7139807660769, -122.436426724612)
11575 27064 3 48 801 Silver Ave 6 1 1 2   01/30/2009 12:00:00 AM 1 4   6007054.44286 2093598.3683099998 37.7290213868102 -122.41787844665899 (37.7290213868102, -122.417878446659)
22291 95431 1 48 1938 24th Ave 1 1 1 1 1 03/01/2011 12:00:00 AM 1 3x3 Permit Number 767296 5988810.2856 2102122.1786 37.7513819161329 -122.481573187512 (37.7513819161329, -122.481573187512)
24816 47267 1 48 1386 24th Ave 1 1 1 1 1 05/09/2002 12:00:00 AM 1   Permit Number 45208 5988680.1995 2105896.4201 37.7617374028544 -122.48229953296001 (37.7617374028544, -122.48229953296)
25668 118581 2 48 104 Point Lobos Ave 1 1 1 1     1 Width 3ft   5982478.43556 2112606.9372400003 37.7797998443253 -122.504245701476 (37.7797998443253, -122.504245701476)
27198 140780 2 48 5 Encanto Ave 1 1 1 1     1 Width 0ft   6000014.7367 2112198.3604 37.7796937331341 -122.44355075738399 (37.7796937331341, -122.443550757384)
27407 98851 1 48 1795X 31st Ave 4 1 1 1   04/11/2012 12:00:00 AM 1 3x3 Permit Number 768753 5986486.2 2103095.0 37.7539176067687 -122.489681571094 (37.7539176067687, -122.489681571094)
28890 182659 2 48 2252 Ortega St 2 1 1 1     1 Width 0ft   5986985.3742 2102363.8158 37.7519391046129 -122.487901613135 (37.7519391046129, -122.487901613135)
30724 92441 1 48 1368 45th Ave 1 1 1 1 1 07/30/2009 12:00:00 AM 1 3x3 Permit Number 52832 5982163.8853 2105798.2136 37.7610865595393 -122.504829187778 (37.7610865595393, -122.504829187778)
31111 207007 2 48 127 Westgate Dr 1 1 1 1     1 Width 3ft   5993382.1086800005 2093854.3174299998 37.7289452232334 -122.465162955333 (37.7289452232334, -122.465162955333)
34436 88394 1 48 139 25th Ave   1 1 1   07/10/2008 12:00:00 AM 1 3x3 Permit Number 51373 5988000.05712 2115038.19323 37.78679857243979 -122.485322676521 (37.7867985724398, -122.485322676521)
35363 98849 1 48 1795X 31st Ave 2 1 1 1   04/11/2012 12:00:00 AM 1 3x3 Permit Number 768753 5986486.2 2103095.0 37.7539176067687 -122.489681571094 (37.7539176067687, -122.489681571094)
35420 182699 2 48 1659 Moraga St 1 1 1 1     1 Width 0ft   5989088.7291 2103739.8915 37.755839910949895 -122.480728726959 (37.7558399109499, -122.480728726959)
35959 118588 2 48 150 Point Lobos Ave 1 1 1 1     1 Width 3ft   5982305.68238 2112631.11012 37.779856054488604 -122.50484511221701 (37.7798560544886, -122.504845112217)
36288 31158 1 48 600 Head St 1 1 1 1 1 07/28/2001 12:00:00 AM 1   Permit Number 34860 5993522.80361 2089878.90243 37.71803781197371 -122.464388049089 (37.7180378119737, -122.464388049089)
36328 119240 2 48 50 Sutro Heights Ave 1 9 1 1     1 Width 8ft   5981455.34518 2111336.83463 37.776252294734 -122.507690683983 (37.776252294734, -122.507690683983)
36351 119164 2 48 883 47th Ave 1 1 1 1     1 Width 3ft   5981372.52859 2109725.62562 37.7718235084184 -122.507857566702 (37.7718235084184, -122.507857566702)
37433 184723 2 48 1635 42nd Ave 1 1 1 1     1 Width 0ft   5983115.9866 2103988.5253 37.7561736313112 -122.501402462618 (37.7561736313112, -122.501402462618)
38258 113355 3 48 2 Point Lobos Ave 3 1 1 2     1 3X3   5982766.03998 2112575.4615 37.779730331527404 -122.503248436763 (37.7797303315274, -122.503248436763)
40793 78252 1 48 541 Naples St 1 1 1 1   12/17/2015 12:00:00 AM 1 3x3 Permit Number 776648 6003018.571219999 2090471.0211200002 37.7202064317688 -122.43160757344299 (37.7202064317688, -122.431607573443)
41516 46433 1 48 2St. Ankeny St 1 1 1 1 1 10/30/2003 12:00:00 AM 1   Permit Number 47151 6011103.47209 2089684.5822599998 37.718501979072 -122.403605308234 (37.718501979072, -122.403605308234)
41737 183303 2 48 1286 43rd Ave 1 1 1 1     1 Width 0ft   5982766.9656 2106385.9546 37.7627357893861 -122.502786935917 (37.7627357893861, -122.502786935917)
41920 227112 2 48 82 Mirabel Ave 1 1 1 1     1 Width 2ft   6007863.71848 2099963.32211 37.7465436642568 -122.41553116305 (37.7465436642568, -122.41553116305)
42609 227117 2 48 129 Rousseau St 1 1 1 1     1 Width 2ft   6003535.84775 2095026.7825099998 37.7327448417949 -122.430144356698 (37.7327448417949, -122.430144356698)
43034 140758 2 48 42 TERRA VISTA AVE 1 1 1 1     1 Width 0ft   6000316.7782 2112875.0348 37.781568928755895 -122.442554464995 (37.7815689287559, -122.442554464995)
43685 46431 1 48 2St. Ankeny St 3 1 1 1   03/15/2002 12:00:00 AM 1   Permit Number 44652 6011089.42189 2089718.35805 37.7185939356546 -122.40365624942899 (37.7185939356546, -122.403656249429)
43893 117895 2 48 635 38th Ave 2 1 1 1     1 Width 3ft   5984097.32613 2111483.29523 37.7768097259285 -122.498562310404 (37.7768097259285, -122.498562310404)
44865 46434 1 48 2St. Ankeny St 2 1 1 1 1 10/30/2003 12:00:00 AM 1   Permit Number 47151 6011096.25435 2089701.2859 37.7185474406786 -122.40363143174 (37.7185474406786, -122.40363143174)
46405 176898 2 48 167 Madison St 1 9 1 1     1 Width 4ft   6005619.38027 2092788.13013 37.7267157831975 -122.42278201629601 (37.7267157831975, -122.422782016296)
46553 95899 1 48 1700 23rd Ave 3 1 1 1 1 07/27/2011 12:00:00 AM 1 3x3 Permit Number 767603 5989072.0669 2103701.2996 37.7557329794721 -122.480783524363 (37.7557329794721, -122.480783524363)
47498 119083 2 48 863 45th Ave 1 1 1 1     1 Width 3ft   5981985.30992 2109867.54201 37.7722492542332 -122.505748473333 (37.7722492542332, -122.505748473333)
47585 176883 2 48 96 Alpha St 4 7 1 1     1     6011048.63475 2088252.8219299999 37.7145675926038 -122.40369417294501 (37.7145675926038, -122.403694172945)
48201 119241 2 48 50 Sutro Heights Ave 2 9 1 1     1 Width 8ft   5981435.03386 2111334.77238 37.776245435782 -122.50776079209999 (37.776245435782, -122.5077607921)
50178 206987 2 48 1248 Funston Ave 1 1 1 1     1 Width 4ft   5992091.43933 2106913.6178900003 37.7647281934706 -122.47057562128799 (37.7647281934706, -122.470575621288)
50519 201808 2 48 247 Friedell St 1 4 1 1     1 Width 6ft   6020927.8472 2093035.08257 37.7282457215548 -122.369877496672 (37.7282457215548, -122.369877496672)
52529 176915 2 48 143 Somerset St 1 1 1 1     1 Width 5ft   6009701.03874 2093769.75693 37.7296405745301 -122.408741008189 (37.7296405745301, -122.408741008189)
52735 176874 2 48 526 Lathrop Ave 3 1 1 1     1 Width 3ft   6012843.86934 2086597.3532 37.7101221250005 -122.397373047849 (37.7101221250005, -122.397373047849)
52877 118595 2 48 101 Point Lobos Ave 3 1 1 1     1 Width 3ft   5982415.15882 2112561.71552 37.7796719571588 -122.504461248614 (37.7796719571588, -122.504461248614)
53500 227128 2 48 248 Whitney St 1 1 1 1     1 Width 3ft   6004363.9622599995 2096949.7405400001 37.7380717187222 -122.427418297528 (37.7380717187222, -122.427418297528)
56558 207005 2 48 171 Wawona St 1 1 1 1     1 Width 3ft   5992787.45104 2098017.3287299997 37.7403415032629 -122.467521326669 (37.7403415032629, -122.467521326669)
56930 207038 2 48 270 Magellan Ave 2 2 1 1     1 Width 4ft   5994641.46146 2100307.8933900003 37.7467376875983 -122.461276941602 (37.7467376875983, -122.461276941602)
57165 176885 2 48 191 Rey St 1 1 1 1     1 Width 3ft   6008580.05361 2087004.5673599998 37.7110019335603 -122.412138452652 (37.7110019335603, -122.412138452652)
58124 206995 2 48 1584 08th Ave 1 1 1 1     1 Width 3ft   5993720.55073 2104714.02617 37.7587827556425 -122.464781251568 (37.7587827556425, -122.464781251568)
59233 108371 1 48 575 Paris St 1 1 1 1 1   1 3x3   6001620.80772 2090281.19611 37.719605888781295 -122.43642558878 (37.7196058887813, -122.43642558878)
62998 176882 2 48 371 Wilde Ave 1 1 1 1     1 Width 3ft   6010924.50069 2089093.90072 37.7168700890604 -122.404182392406 (37.7168700890604, -122.404182392406)
Powered by Datasette · Query took 14.673ms · Data source: data.sfgov.org