Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCareAssistant
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46 | 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 | 125 | 119758 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 151X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 130 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 5341 | 19786 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY19 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 50ST | ||||||||
| 5375 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
JSON shape: default, array, newline-delimited
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");