Data source: data.sfgov.org
This data as json, CSV (advanced)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79312 | 79312 | 105448 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 453 WALLER ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003543.7 | 2108942.4 | 37.770954298248206 | -122.431110085749 | (37.7709542982482, -122.431110085749) | ||||
| 91512 | 91512 | 86835 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2845 Lake St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49778 | 5986671.0 | 2114422.0 | 37.7850291673476 | -122.489875504221 | (37.7850291673476, -122.489875504221) | |||
| 93481 | 93481 | 88107 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1883 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51111 | 5981622.6 | 2102278.7 | 37.7513911170729 | -122.50644021712799 | (37.7513911170729, -122.506440217128) | |||
| 96652 | 96652 | 88519 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 959 Monterey Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51450 | 5995460.1 | 2094437.2 | 37.730665287621996 | -122.458021400084 | (37.730665287622, -122.458021400084) | |||
| 96739 | 96739 | 88285 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3341 Scott St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51286 | 6000818.0 | 2119783.0 | 37.8005649590066 | -122.441316293875 | (37.8005649590066, -122.441316293875) | |||
| 97578 | 97578 | 86834 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2845 Lake St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49778 | 5986671.0 | 2114422.0 | 37.7850291673476 | -122.489875504221 | (37.7850291673476, -122.489875504221) | |||
| 97688 | 97688 | 103264 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1660 NORTH POINT ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x5 | 6002814.0 | 2121000.0 | 37.8040200224121 | -122.43449639401699 | (37.8040200224121, -122.434496394017) | |||||
| 98106 | 98106 | 86837 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2845 Lake St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49778 | 5986671.0 | 2114422.0 | 37.7850291673476 | -122.489875504221 | (37.7850291673476, -122.489875504221) | |||
| 101314 | 101314 | 86836 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2845 Lake St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49778 | 5986671.0 | 2114422.0 | 37.7850291673476 | -122.489875504221 | (37.7850291673476, -122.489875504221) | |||
| 101796 | 101796 | 86771 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 376 Eureka St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49744 | 6001477.0 | 2103473.0 | 37.755819338033206 | -122.437867037362 | (37.7558193380332, -122.437867037362) | ||||
| 103226 | 103226 | 104358 | Private 5 | Maytenus boaria :: Mayten 22 | 745X GOLDEN GATE AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3 | 6005986.0 | 2112447.0 | 37.7807151749226 | -122.42291120983299 | (37.7807151749226, -122.422911209833) | ||||
| 103947 | 103947 | 88134 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 785 Foerster St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51161 | 5998115.0 | 2096175.0 | 37.7355890560668 | -122.44896818014 | (37.7355890560668, -122.44896818014) | |||
| 105054 | 105054 | 104686 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 140 26TH AVE | Front Yard : Cutout 8 | Tree 1 | Private 1 | 22 | 4x4 | 5987812.9 | 2115041.6 | 37.786797021543 | -122.485970438221 | (37.786797021543, -122.485970438221) | ||||
| 107800 | 107800 | 88441 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3341 Scott St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51405 | 6000818.0 | 2119783.0 | 37.8005649590066 | -122.441316293875 | (37.8005649590066, -122.441316293875) | |||
| 118798 | 118798 | 86838 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2845 Lake St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49778 | 5986671.0 | 2114422.0 | 37.7850291673476 | -122.489875504221 | (37.7850291673476, -122.489875504221) | |||
| 123370 | 123370 | 88381 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 423 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51359 | 5990873.7 | 2112494.8 | 37.779982110660896 | -122.475194900005 | (37.7799821106609, -122.475194900005) | |||
| 125629 | 125629 | 86833 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2845 Lake St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49778 | 5986671.0 | 2114422.0 | 37.7850291673476 | -122.489875504221 | (37.7850291673476, -122.489875504221) | |||
| 139788 | 139788 | 104400 | Private 5 | Maytenus boaria :: Mayten 22 | 755 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 5999044.0 | 2107976.0 | 37.768044800389 | -122.44660507122101 | (37.768044800389, -122.446605071221) | ||||
| 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) | |
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 6562 | 6562 | 17937 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2430 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002084.443 | 2115054.4543 | 37.7876536614139 | -122.436595244995 | (37.7876536614139, -122.436595244995) | |||
| 6927 | 6927 | 2732 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2257 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002711.9331 | 2114741.6938 | 37.786830539072206 | -122.434401883901 | (37.7868305390722, -122.434401883901) | |||
| 7151 | 7151 | 9599 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1355 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1990 12:00:00 AM | 11 | 3X3 | 6003022.227000001 | 2112007.7178 | 37.7793413376686 | -122.43313292513201 | (37.7793413376686, -122.433132925132) | ||
| 7266 | 7266 | 17932 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2418 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002216.7357 | 2115077.2237 | 37.787723697261896 | -122.43613916872499 | (37.7877236972619, -122.436139168725) | |||
| 7350 | 7350 | 17974 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2519 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6001636.0692 | 2114939.9757 | 37.78731384268 | -122.438138324219 | (37.78731384268, -122.438138324219) | |||
| 7511 | 7511 | 17938 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2432 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4x4 | 6002059.6562 | 2115054.4543 | 37.7876522528246 | -122.436681002358 | (37.7876522528246, -122.436681002358) | |||
| 7512 | 7512 | 9485 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 847 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2002 12:00:00 AM | 3 | 3X3 | 6005536.7021 | 2112359.7712 | 37.7804503039159 | -122.424459343214 | (37.7804503039159, -122.424459343214) | ||
| 7565 | 7565 | 18105 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 3053 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999309.1186 | 2114616.1068 | 37.7862919697055 | -122.446165748193 | (37.7862919697055, -122.446165748193) | |||
| 7687 | 7687 | 5278 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1350 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001321.891 | 2113007.3577 | 37.781989495746394 | -122.439086749209 | (37.7819894957464, -122.439086749209) | |||
| 7740 | 7740 | 9445 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/01/1994 12:00:00 AM | 12 | 3X3 | 6005680.1419 | 2112439.5166 | 37.780677364386705 | -122.423968789396 | (37.7806773643867, -122.423968789396) | ||
| 7760 | 7760 | 14671 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 735 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 4x4 | 6005659.8218 | 2112023.5316 | 37.779534024179995 | -122.42400949606301 | (37.77953402418, -122.424009496063) | |||
| 7992 | 7992 | 111123 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2196 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5997448.8282 | 2109892.6608 | 37.773216211211 | -122.45226088690201 | (37.773216211211, -122.452260886902) | |||
| 8076 | 8076 | 17868 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2127 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/1992 12:00:00 AM | 12 | 3X3 | 6003572.046 | 2115203.4059 | 37.7881470684138 | -122.431459068113 | (37.7881470684138, -122.431459068113) | ||
| 8507 | 8507 | 13147 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1833 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6003597.2465 | 2119627.9507 | 37.8002971624487 | -122.431687899053 | (37.8002971624487, -122.431687899053) | |||
| 8570 | 8570 | 17936 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2428 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002109.8063 | 2115059.6423 | 37.7876693476195 | -122.436507864526 | (37.7876693476195, -122.436507864526) | |||
| 8588 | 8588 | 64901 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2100 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/1989 12:00:00 AM | 5 | 3x3 | 6003335.09871 | 2115955.0637 | 37.7901974974694 | -122.4323325691 | (37.7901974974694, -122.4323325691) | ||
| 8746 | 8746 | 9484 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 843 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005554.0072 | 2112361.9898 | 37.7804573728678 | -122.42439963452699 | (37.7804573728678, -122.424399634527) | |||
| 8748 | 8748 | 5273 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1320 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001321.5525 | 2112995.5129 | 37.7819569536833 | -122.439087071085 | (37.7819569536833, -122.439087071085) | |||
| 8827 | 8827 | 12430 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1734 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 3 | 3X3 | 6004454.6634 | 2114845.8604 | 37.787215322181794 | -122.428379869098 | (37.7872153221818, -122.428379869098) | ||
| 8974 | 8974 | 9427 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 727 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1998 12:00:00 AM | 6 | 3X3 | 6005864.05119 | 2112400.08095 | 37.78057946490821 | -122.423329753784 | (37.7805794649082, -122.423329753784) | ||
| 9143 | 9143 | 12567 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 311 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1992 12:00:00 AM | 6 | 3X3 | 5994495.46055 | 2114856.8855 | 37.786677009426604 | -122.462837112849 | (37.7866770094266, -122.462837112849) | ||
| 9198 | 9198 | 18049 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2827 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x4 | 6000144.0199 | 2114731.2352 | 37.7866557263604 | -122.443285486254 | (37.7866557263604, -122.443285486254) | |||
| 9258 | 9258 | 18059 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2895 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1990 12:00:00 AM | 6 | 3x4 | 6000110.4309 | 2114723.8195 | 37.786633449363606 | -122.443401162869 | (37.7866334493636, -122.443401162869) | ||
| 9412 | 9412 | 17939 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2445 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1991 12:00:00 AM | 6 | 3x3 | 6002249.5312774 | 2115023.8576257 | 37.7875790308508 | -122.43602188230601 | (37.7875790308508, -122.436021882306) | ||
| 9492 | 9492 | 4292 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 4338 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001697.8339599995 | 2100319.1603900003 | 37.7471722031488 | -122.43687755566299 | (37.7471722031488, -122.436877555663) | |||
| 9541 | 9541 | 5901 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1218 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2005 12:00:00 AM | 3 | 3X3 | 6001385.6835 | 2112540.5048 | 37.7807112660329 | -122.43883259166401 | (37.7807112660329, -122.438832591664) | ||
| 9572 | 9572 | 100227 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 542 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Permit Number 769993 | 6002426.0 | 2099190.0 | 37.7441131524814 | -122.434278904907 | (37.7441131524814, -122.434278904907) | |||
| 9674 | 9674 | 61426 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3501X 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1984 12:00:00 AM | Permit Number 21355 | 6006351.47468928 | 2100870.60661273 | 37.7489497429973 | -122.420824749243 | (37.7489497429973, -122.420824749243) | ||
| 9704 | 9704 | 104747 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2-X FORD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6003502.9 | 2105705.5 | 37.762064243675106 | -122.431020153892 | (37.7620642436751, -122.431020153892) | ||||
| 9733 | 9733 | 173666 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 37 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003363.0 | 2105606.0 | 37.7617831123707 | -122.431496910184 | (37.7617831123707, -122.431496910184) | ||||
| 10074 | 10074 | 60000 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1227 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2017 12:00:00 AM | 3 | Permit Number 19486 | 5991400.84514705 | 2107067.03072332 | 37.76510946688521 | -122.472975370228 | (37.7651094668852, -122.472975370228) | |
| 10171 | 10171 | 173890 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2593 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989209.0 | 2097724.0 | 37.7393288482101 | -122.479872589648 | (37.7393288482101, -122.479872589648) | ||||
| 10257 | 10257 | 101048 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3050 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008765.0 | 2105072.0 | 37.7606215625409 | -122.41277572810101 | (37.7606215625409, -122.412775728101) |
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");