Street_Tree_List

Data source: data.sfgov.org

3,888 rows where qSpecies = 22

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
46 18228 DPW Maintained 3 Maytenus boaria :: Mayten 22 1737-1795 Post St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/09/2004 12:00:00 AM 12 3X3   6003682.1522 2114179.2812 37.785341320174396 -122.431004998109 (37.7853413201744, -122.431004998109)
125 119758 Undocumented 2 Maytenus boaria :: Mayten 22 151X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
130 66855 Permitted Site 1 Maytenus boaria :: Mayten 22 2041 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/15/1991 12:00:00 AM 8   Permit Number 30161 5998071.2779 2109932.9259 37.7733624072524 -122.450110663343 (37.7733624072524, -122.450110663343)
184 138801 Permitted Site 1 Maytenus boaria :: Mayten 22 2375 PINE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/09/1997 12:00:00 AM 2 Width 0ft   6002525.8905 2115062.7753 37.787701584977704 -122.43506851988899 (37.7877015849777, -122.435068519889)
202 138810 DPW Maintained 3 Maytenus boaria :: Mayten 22 2355 PINE ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     11 Width 0ft   6002718.089 2115091.954 37.787792613821004 -122.434405637805 (37.787792613821, -122.434405637805)
212 138800 DPW Maintained 3 Maytenus boaria :: Mayten 22 2375 PINE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 0ft   6002511.9355 2115060.8724 37.7876955676952 -122.435116665287 (37.7876955676952, -122.435116665287)
237 2654 DPW Maintained 3 Maytenus boaria :: Mayten 22 1988 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/30/2005 12:00:00 AM 12 3X3   6004003.2237 2114978.8425 37.7875549020514 -122.429951242636 (37.7875549020514, -122.429951242636)
278 9598 DPW Maintained 3 Maytenus boaria :: Mayten 22 1350 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003113.217999999 2112071.7207 37.7795222347306 -122.43282272296999 (37.7795222347306, -122.43282272297)
548 18094 Permitted Site 1 Maytenus boaria :: Mayten 22 3001 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   5999514.29 2114642.3727 37.786375803755895 -122.445457799993 (37.7863758037559, -122.445457799993)
686 23735 DPW Maintained 3 Maytenus boaria :: Mayten 22 805 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/29/2016 12:00:00 AM 12 4X4   6003900.7925 2111534.0109 37.778090453740504 -122.430059798517 (37.7780904537405, -122.430059798517)
736 231004 Permitted Site 1 Maytenus boaria :: Mayten 22 660 Alabama St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2003 12:00:00 AM 7 Width 3ft Permit Number 46247 6008974.97232 2105068.82517 37.7606246283465 -122.412049301945 (37.7606246283465, -122.412049301945)
741 9506 Permitted Site 1 Maytenus boaria :: Mayten 22 935 Golden Gate Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/10/2002 12:00:00 AM 3 3X3   6005056.2117 2112292.3227 37.7802379614696 -122.426116783326 (37.7802379614696, -122.426116783326)
744 231007 Permitted Site 1 Maytenus boaria :: Mayten 22 660 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2003 12:00:00 AM 7 Width 3ft Permit Number 46247 6008969.23961 2105134.95103 37.7608058732193 -122.412073802181 (37.7608058732193, -122.412073802181)
753 48 DPW Maintained 3 Maytenus boaria :: Mayten 22 810 14th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 3X3   6003376.13457 2107738.85817 37.767640169485105 -122.43160376032499 (37.7676401694851, -122.431603760325)
756 231006 Permitted Site 1 Maytenus boaria :: Mayten 22 660 Alabama St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2003 12:00:00 AM 9 Width 3ft Permit Number 46247 6008972.79201 2105110.692 37.760739462776606 -122.41205980151199 (37.7607394627766, -122.412059801512)
758 231035 Permitted Site 1 Maytenus boaria :: Mayten 22 3050 19th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2003 12:00:00 AM 7 Width 3ft Permit Number 46247 6008913.51781 2104995.63577 37.7604202187369 -122.41225667301799 (37.7604202187369, -122.412256673018)
765 231003 Permitted Site 1 Maytenus boaria :: Mayten 22 660 Alabama St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2003 12:00:00 AM 9 Width 3ft Permit Number 46247 6008977.98805 2105043.06556 37.760554067537704 -122.412037051387 (37.7605540675377, -122.412037051387)
770 231129 DPW Maintained 3 Maytenus boaria :: Mayten 22 821 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 Width 3ft   6003305.97559 2107686.68734 37.7674929441754 -122.431842705671 (37.7674929441754, -122.431842705671)
775 231005 Permitted Site 1 Maytenus boaria :: Mayten 22 660 Alabama St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2003 12:00:00 AM 8 Width 3ft Permit Number 46247 6008971.29667 2105087.04019 37.7606744364044 -122.41206330170401 (37.7606744364044, -122.412063301704)
795 140241 Undocumented 2 Maytenus boaria :: Mayten 22 160 Ashbury St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5998775.6798 2110202.3294 37.7741424035345 -122.44769344620701 (37.7741424035345, -122.447693446207)
850 14550 Permitted Site 1 Maytenus boaria :: Mayten 22 834 Masonic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/12/1993 12:00:00 AM 12 3X3   5999292.7589 2109954.5102 37.7734914941004 -122.445886958088 (37.7734914941004, -122.445886958088)
884 20233 Permitted Site 1 Maytenus boaria :: Mayten 22 1724 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4X4   6002600.0088 2114219.702 37.785390928556396 -122.43475177403499 (37.7853909285564, -122.434751774035)
893 18095 DPW Maintained 3 Maytenus boaria :: Mayten 22 3001 Pine St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3X3   5999540.0604 2114647.8242 37.7863922432736 -122.44536903339501 (37.7863922432736, -122.445369033395)
1080 9610 Permitted Site 1 Maytenus boaria :: Mayten 22 1388X Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   05/01/2017 01:42:00 PM 3 3X3   6002958.1886 2112049.4711 37.7794523489738 -122.433357444963 (37.7794523489738, -122.433357444963)
1155 14734 DPW Maintained 3 Maytenus boaria :: Mayten 22 895 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 4x4   6004929.3578 2111921.9134 37.7792137381495 -122.42652924677799 (37.7792137381495, -122.426529246778)
1353 14712 DPW Maintained 3 Maytenus boaria :: Mayten 22 845 McAllister St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/27/1993 12:00:00 AM 8 4x4   6005208.5684 2111961.5273 37.779338288494 -122.42556616152099 (37.779338288494, -122.425566161521)
1491 110535 Private 5 Maytenus boaria :: Mayten 22 100X ASHBURY ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 City College 12 Private 3 04/21/2015 04:52:00 PM 3 3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
1498 251577 Undocumented 2 Maytenus boaria :: Mayten 22 490X Ashbury St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998892.0 2109203.0 37.7714051474644 -122.447219139052 (37.7714051474644, -122.447219139052)
1581 111 DPW Maintained 3 Maytenus boaria :: Mayten 22 955 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6002518.0 2107623.0 37.767273374303706 -122.43456365047399 (37.7672733743037, -122.434563650474)
1818 139879 DPW Maintained 3 Maytenus boaria :: Mayten 22 870 MCALLISTER ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/16/2000 12:00:00 AM 12 Width 0ft   6005009.3284 2111993.411 37.779414573538205 -122.42625768702801 (37.7794145735382, -122.426257687028)
1897 245386 DPW Maintained 3 Maytenus boaria :: Mayten 22 3243 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/17/1998 12:00:00 AM 6 Width 0ft   6006500.2854 2099391.485 37.7448967968639 -122.420205198271 (37.7448967968639, -122.420205198271)
1950 252823 Significant Tree 6 Maytenus boaria :: Mayten 22 3852 17th St 2 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1951 9609 Permitted Site 1 Maytenus boaria :: Mayten 22 1386 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6002986.18 2112056.6484 37.779473644014104 -122.433261123937 (37.7794736440141, -122.433261123937)
2124 22782 DPW Maintained 3 Maytenus boaria :: Mayten 22 1866 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001070.0369 2112136.3428 37.7795835769795 -122.439895576072 (37.7795835769795, -122.439895576072)
2202 139878 Permitted Site 1 Maytenus boaria :: Mayten 22 870 MCALLISTER ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6005025.9501 2111995.4887 37.779421217898204 -122.426200333481 (37.7794212178982, -122.426200333481)
2277 230875 Undocumented 2 Maytenus boaria :: Mayten 22 236 Whitney St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2017 12:00:00 AM 3 Width 3ft Permit Number 780225 6004378.79824 2096997.6993900002 37.7382042419264 -122.42737041762 (37.7382042419264, -122.42737041762)
2407 9490 Permitted Site 1 Maytenus boaria :: Mayten 22 871 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/06/2002 12:00:00 AM 3 3X3   6005401.3681 2112340.2476 37.7803890535333 -122.42492613811301 (37.7803890535333, -122.424926138113)
2458 9644 DPW Maintained 3 Maytenus boaria :: Mayten 22 1495 Golden Gate Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 3X3   6002520.4964 2111934.6452 37.7791122249761 -122.434863391819 (37.7791122249761, -122.434863391819)
2579 14672 DPW Maintained 3 Maytenus boaria :: Mayten 22 739 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6005639.1537 2112019.7041 37.7795223479045 -122.424080723662 (37.7795223479045, -122.424080723662)
2696 9611 Permitted Site 1 Maytenus boaria :: Mayten 22 1390X Golden Gate Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   05/14/1992 12:00:00 AM 3 3X3   6002925.8908 2112046.6002 37.7794426338279 -122.43346897140499 (37.7794426338279, -122.433468971405)
2727 209330 Permitted Site 1 Maytenus boaria :: Mayten 22 1561 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/16/1994 12:00:00 AM 1 Width 1ft Permit Number 33584 5991111.55189 2104793.24425 37.7588495024191 -122.47381006179701 (37.7588495024191, -122.473810061797)
2827 18276 DPW Maintained 3 Maytenus boaria :: Mayten 22 1950 Post St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6002797.4872 2114109.7892 37.78510034529771 -122.434060698947 (37.7851003452977, -122.434060698947)
3075 231047 Permitted Site 1 Maytenus boaria :: Mayten 22 1006 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/1989 12:00:00 AM 6 Width 3ft Permit Number 27195 6003118.79075 2102352.8042 37.752836769210504 -122.432109206276 (37.7528367692105, -122.432109206276)
3102 231048 Permitted Site 1 Maytenus boaria :: Mayten 22 1028 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/1989 12:00:00 AM 10 Width 4ft Permit Number 27198 6003126.30081 2102253.4394 37.752564362754896 -122.43207614 (37.7525643627549, -122.43207614)
3222 5838 DPW Maintained 3 Maytenus boaria :: Mayten 22 860 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/17/1997 12:00:00 AM 6 3X3   6006312.21276 2113211.9775099996 37.7828340176265 -122.421837034768 (37.7828340176265, -122.421837034768)
3331 140432 Permitted Site 1 Maytenus boaria :: Mayten 22 1499 Turk St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Police Dept 18     13 Width 0ft   6003204.3695 2112383.9326 37.7803846599605 -122.432529697936 (37.7803846599605, -122.432529697936)
3346 139859 DPW Maintained 3 Maytenus boaria :: Mayten 22 704 McAllister St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 0ft   6005699.1313 2112090.0249 37.7797188177748 -122.423878237045 (37.7797188177748, -122.423878237045)
3348 140430 Permitted Site 1 Maytenus boaria :: Mayten 22 1499 TURK ST 9 Sidewalk: Curb side : Cutout 1 Tree 1 Police Dept 18   05/18/1992 12:00:00 AM 5 Width 0ft   6003115.3712 2112373.8844 37.7803520228236 -122.432836866316 (37.7803520228236, -122.432836866316)
3353 139860 DPW Maintained 3 Maytenus boaria :: Mayten 22 706 McAllister St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/12/2016 12:00:00 AM 8 Width 0ft   6005680.9512 2112087.9472 37.7797120865642 -122.42394098222 (37.7797120865642, -122.42394098222)
3356 231847 Undocumented 2 Maytenus boaria :: Mayten 22 4050 17th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/22/2016 12:00:00 AM 3 Width 2ft Permit Number 778753 6001932.15846 2105889.72854 37.762480961257296 -122.436465919794 (37.7624809612573, -122.436465919794)
3388 102820 Permitted Site 1 Maytenus boaria :: Mayten 22 340 Presidio Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3 Permit Number 46302 5999107.42963 2115375.9923 37.7883668959543 -122.446918238085 (37.7883668959543, -122.446918238085)
3400 209440 Permitted Site 1 Maytenus boaria :: Mayten 22 1643 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/10/1994 12:00:00 AM 5 Width 4ft Permit Number 33110 5992755.638719999 2104278.4953 37.757531223117 -122.46808665218599 (37.757531223117, -122.468086652186)
3462 109 Permitted Site 1 Maytenus boaria :: Mayten 22 941 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3X3   6002569.29571 2107648.70327 37.767346860988 -122.434388064079 (37.767346860988, -122.434388064079)
3471 49244 Permitted Site 1 Maytenus boaria :: Mayten 22 340 Presidio Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/13/2003 12:00:00 AM 6 3x3 Permit Number 46302 5999109.05449 2115365.28711 37.7883375951433 -122.446911845714 (37.7883375951433, -122.446911845714)
3501 247943 Planning Code 138.1 required 4 Maytenus boaria :: Mayten 22 29 Joy St 6 Unaccepted Street : Yard 14 Tree 1 DPW 2     2   Permit Number 775404 6010304.2598 2098903.51059 37.7437705318851 -122.407017307297 (37.7437705318851, -122.407017307297)
3542 9627 Permitted Site 1 Maytenus boaria :: Mayten 22 1415 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6002784.4654 2111969.5026 37.779222918296206 -122.433952708708 (37.7792229182962, -122.433952708708)
3576 22792 Permitted Site 1 Maytenus boaria :: Mayten 22 1900 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/1995 12:00:00 AM 6 3X3   6000871.3270000005 2112110.8774 37.7795023421352 -122.44058117022199 (37.7795023421352, -122.440581170222)
3681 210783 Undocumented 2 Maytenus boaria :: Mayten 22 102 Kirkham St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5994553.24166 2105346.7379 37.7605679917509 -122.46194732411001 (37.7605679917509, -122.46194732411)
3715 240037 Undocumented 2 Maytenus boaria :: Mayten 22 4109 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6002258.67075 2105277.61191 37.7608187856797 -122.435292848592 (37.7608187856797, -122.435292848592)
3735 63212 Permitted Site 1 Maytenus boaria :: Mayten 22 450 38th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1986 12:00:00 AM 10   Permit Number 23755 5984123.0 2112760.0 37.7803166927985 -122.498567828267 (37.7803166927985, -122.498567828267)
3771 47 DPW Maintained 3 Maytenus boaria :: Mayten 22 810 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/03/1998 12:00:00 AM 6 3X3   6003389.5525400005 2107739.47109 37.7676426129451 -122.431557393053 (37.7676426129451, -122.431557393053)
3777 121577 Undocumented 2 Maytenus boaria :: Mayten 22 358 Walnut St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   5998615.65144 2115302.1022900003 37.788135906006104 -122.448614380145 (37.7881359060061, -122.448614380145)
4160 209715 Permitted Site 1 Maytenus boaria :: Mayten 22 2351 12th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/30/2005 12:00:00 AM 6 Width 3ft Permit Number 46346 5992610.11483 2099444.51388 37.7442499514734 -122.468238276996 (37.7442499514734, -122.468238276996)
4327 103839 DPW Maintained 3 Maytenus boaria :: Mayten 22 1552 Polk St 1 Sidewalk: Curb side : Pot 10 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6006685.2576 2116316.1212 37.791378262309706 -122.420766896 (37.7913782623097, -122.420766896)
4535 12416 DPW Maintained 3 Maytenus boaria :: Mayten 22 1660 Laguna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/13/1989 12:00:00 AM 6 4X4   6004502.1372 2114559.4680000003 37.786431646664205 -122.428195201763 (37.7864316466642, -122.428195201763)
4607 138309 Permitted Site 1 Maytenus boaria :: Mayten 22 2271 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/02/2015 12:00:00 AM 5 Width 0ft   6002610.839 2114725.8359 37.7867812584334 -122.434750511093 (37.7867812584334, -122.434750511093)
4928 24232 Permitted Site 1 Maytenus boaria :: Mayten 22 200X Willow St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/1990 12:00:00 AM 6 4X4   6006507.65863 2113391.7198099997 37.7833385660635 -122.421173639975 (37.7833385660635, -122.421173639975)
5061 253757 Undocumented 2 Maytenus boaria :: Mayten 22 330 Twin Peaks Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5072 253758 Undocumented 2 Maytenus boaria :: Mayten 22 330 Twin Peaks Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5078 253759 Undocumented 2 Maytenus boaria :: Mayten 22 330 Twin Peaks Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5150 12412 DPW Maintained 3 Maytenus boaria :: Mayten 22 1620 Laguna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6004511.4773 2114458.3749 37.786154598782396 -122.428155680217 (37.7861545987824, -122.428155680217)
5265 5279 DPW Maintained 3 Maytenus boaria :: Mayten 22 1350 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6001320.5373 2113019.2025 37.7820219415228 -122.43909228156001 (37.7820219415228, -122.43909228156)
5341 19786 DPW Maintained 3 Maytenus boaria :: Mayten 22 100 STAIRWAY19 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 50ST            
5375 9508 Permitted Site 1 Maytenus boaria :: Mayten 22 935 Golden Gate Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6005101.6314 2112299.4943 37.7802602199167 -122.42596016623399 (37.7802602199167, -122.425960166234)
5378 9456 Permitted Site 1 Maytenus boaria :: Mayten 22 800X Golden Gate Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   12/15/2005 12:00:00 AM 3 3X3   6005442.4 2112406.4818 37.780573233977705 -122.424788902821 (37.7805732339777, -122.424788902821)
5415 18101 Permitted Site 1 Maytenus boaria :: Mayten 22 3031 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   5999398.8192 2114627.0097 37.7863270284134 -122.44585619283 (37.7863270284134, -122.44585619283)
5438 7826 DPW Maintained 3 Maytenus boaria :: Mayten 22 807 Franklin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 4x4   6006132.89126 2112941.5799 37.7820814577469 -122.422438193788 (37.7820814577469, -122.422438193788)
5464 18230 DPW Maintained 3 Maytenus boaria :: Mayten 22 1737-1795 Post St 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/09/2004 12:00:00 AM 3 3X3   6003859.0712 2114201.8624 37.7854133456405 -122.430394523724 (37.7854133456405, -122.430394523724)
5510 20148 DPW Maintained 3 Maytenus boaria :: Mayten 22 1028 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/19/1999 12:00:00 AM 3 4X4   6002939.2419 2111824.3037 37.7788330206804 -122.433406894695 (37.7788330206804, -122.433406894695)
5562 2725 Permitted Site 1 Maytenus boaria :: Mayten 22 2211 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/12/1992 12:00:00 AM 12 3x3   6002784.7803 2114750.1183 37.7868578053346 -122.434150452304 (37.7868578053346, -122.434150452304)
5621 6044 DPW Maintained 3 Maytenus boaria :: Mayten 22 1834 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001440.1248 2112530.373 37.780686543842705 -122.43864352716801 (37.7806865438427, -122.438643527168)
5685 95207 Undocumented 2 Maytenus boaria :: Mayten 22 2203 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6000850.32239 2115965.74375 37.7900856173129 -122.440930450291 (37.7900856173129, -122.440930450291)
5723 9483 Permitted Site 1 Maytenus boaria :: Mayten 22 839 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6005577.0805 2112364.6521 37.7804659857949 -122.424320002456 (37.7804659857949, -122.424320002456)
5760 20149 DPW Maintained 3 Maytenus boaria :: Mayten 22 1040 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6002932.4508 2111847.2891 37.7788957475604 -122.433432030761 (37.7788957475604, -122.433432030761)
5778 24244 DPW Maintained 3 Maytenus boaria :: Mayten 22 289X Willow St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 4X4   6006236.37633 2113335.30136 37.7831683576867 -122.42210816146499 (37.7831683576867, -122.422108161465)
5790 18038 DPW Maintained 3 Maytenus boaria :: Mayten 22 2809 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000359.9496 2114756.9723 37.7867387044094 -122.442540272299 (37.7867387044094, -122.442540272299)
5833 18102 Permitted Site 1 Maytenus boaria :: Mayten 22 3037 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   5999372.5533 2114624.5318 37.786318724964204 -122.445946887489 (37.7863187249642, -122.445946887489)
5863 9461 Permitted Site 1 Maytenus boaria :: Mayten 22 800X Golden Gate Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   12/15/2005 12:00:00 AM 3 3X3   6005331.3816 2112388.6106 37.780517893039395 -122.425171696602 (37.7805178930394, -122.425171696602)
6100 60881 Permitted Site 1 Maytenus boaria :: Mayten 22 1944 Mason St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/12/1983 12:00:00 AM 10 3x3 Permit Number 20664 6009093.1364 2119961.1446 37.8015220194232 -122.412693451029 (37.8015220194232, -122.412693451029)
6156 99174 Permitted Site 1 Maytenus boaria :: Mayten 22 2100 Webster St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   6003313.97613 2116148.97888 37.790728741394894 -122.432419507463 (37.7907287413949, -122.432419507463)
6164 5280 DPW Maintained 3 Maytenus boaria :: Mayten 22 1350 Divisadero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6001316.1378 2113050.3373 37.7821071794141 -122.43910973392799 (37.7821071794141, -122.439109733928)
6207 17935 DPW Maintained 3 Maytenus boaria :: Mayten 22 2426 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6002142.0869 2115065.9831 37.787688592105205 -122.436396634074 (37.7876885921052, -122.436396634074)
6304 9451 Permitted Site 1 Maytenus boaria :: Mayten 22 800X Golden Gate Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   12/15/2005 12:00:00 AM 3 3X3   6005532.2979 2112418.9375 37.7806125113537 -122.424478789137 (37.7806125113537, -122.424478789137)
6313 9487 Permitted Site 1 Maytenus boaria :: Mayten 22 851 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6005519.3971 2112356.6652 37.7804407983566 -122.424518988404 (37.7804407983566, -122.424518988404)
6320 9597 DPW Maintained 3 Maytenus boaria :: Mayten 22 1340 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/11/1994 12:00:00 AM 12 3X3   6003188.5795 2112083.2043 37.779558039769505 -122.432562836067 (37.7795580397695, -122.432562836067)
6324 14845 Permitted Site 1 Maytenus boaria :: Mayten 22 1328 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/13/1992 12:00:00 AM 10 3x3   6002789.0932 2111678.3235 37.778423675949 -122.43391588048999 (37.778423675949, -122.43391588049)
6358 14669 DPW Maintained 3 Maytenus boaria :: Mayten 22 731 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 4x4   6005678.1934 2112026.9763 37.7795445196864 -122.423946185798 (37.7795445196864, -122.423946185798)
6367 24233 Permitted Site 1 Maytenus boaria :: Mayten 22 200X Willow St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/1997 12:00:00 AM 12 4X4   6006482.09077 2113391.69124 37.7833370462081 -122.42126209278099 (37.7833370462081, -122.421262092781)
6451 17934 DPW Maintained 3 Maytenus boaria :: Mayten 22 2424 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6002175.8086 2115067.4242 37.7876944650438 -122.436280066856 (37.7876944650438, -122.436280066856)
6498 18062 DPW Maintained 3 Maytenus boaria :: Mayten 22 2901 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/20/1994 12:00:00 AM 12 3X3   6000020.8872 2114713.4888 37.786599977163704 -122.443710218956 (37.7865999771637, -122.443710218956)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 876.541ms · Data source: data.sfgov.org