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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1171 | 1171 | 172952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3000X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 0 | Width 3ft | 6005556.34576 | 2120733.12845 | 37.8034425497953 | -122.42498731221201 | (37.8034425497953, -122.424987312212) | ||
| 79317 | 79317 | 95366 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3101X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 14 | 3x3 | 6005504.90819 | 2120981.97244 | 37.8041229057048 | -122.42518303152201 | (37.8041229057048, -122.425183031522) | ||
| 87235 | 87235 | 117162 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1383X VERMONT ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | DPW 4 | 6011571.0 | 2102081.0 | 37.752566033842896 | -122.40286062573799 | (37.7525660338429, -122.402860625738) | ||||
| 6478 | 6478 | 98738 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1150 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 3 | 4X4 | 6001885.6171 | 2112431.4484 | 37.780440254610205 | -122.43709527307301 | (37.7804402546102, -122.437095273073) | ||
| 77569 | 77569 | 98569 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301X Francisco St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 79463 | 79463 | 116977 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100x CARGO WAY | 117 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 79583 | 79583 | 73289 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1999 12:00:00 AM | 10 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 80033 | 80033 | 96215 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Collingwood St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 26 | 4x4 | 6002035.7 | 2104682.0 | 37.7591707149085 | -122.436021383266 | (37.7591707149085, -122.436021383266) | ||
| 81902 | 81902 | 96211 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 201X Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.43696480408701 | (37.759113460692, -122.436964804087) | ||
| 85600 | 85600 | 93121 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 151X Palm Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 5995892.67419 | 2113127.59534 | 37.7820092173573 | -122.457877934554 | (37.7820092173573, -122.457877934554) | ||
| 86000 | 86000 | 102186 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3999X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
| 90252 | 90252 | 96214 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 3x3 | 6002035.7 | 2104682.0 | 37.7591707149085 | -122.436021383266 | (37.7591707149085, -122.436021383266) | ||
| 96597 | 96597 | 42644 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 10 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 98830 | 98830 | 96212 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 201X Diamond St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.43696480408701 | (37.759113460692, -122.436964804087) | ||
| 99139 | 99139 | 74759 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250 Foerster St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 30 | 5x7 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 100783 | 100783 | 73287 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 102473 | 102473 | 95360 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 12 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
| 105405 | 105405 | 98743 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 155 Masonic Ave | 5 | Sidewalk: Property side : 26 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5998843.8 | 2112455.0 | 37.7803315496091 | -122.447619999218 | (37.7803315496091, -122.447619999218) | ||||
| 105706 | 105706 | 96216 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Collingwood St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 4x4 | 6002035.7 | 2104682.0 | 37.7591707149085 | -122.436021383266 | (37.7591707149085, -122.436021383266) | ||
| 108653 | 108653 | 73528 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 4235 19th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/05/1995 12:00:00 AM | 12 | 4x4 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | |
| 111189 | 111189 | 98571 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301X Francisco St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 111421 | 111421 | 95362 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | ||
| 112944 | 112944 | 95359 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 12 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
| 114297 | 114297 | 95361 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 10 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
| 114699 | 114699 | 98740 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1150 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 20 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | ||
| 118079 | 118079 | 95358 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 25 | 3x3 | Permit Number 778058 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | |
| 118717 | 118717 | 102187 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3999X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
| 124535 | 124535 | 73286 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 126442 | 126442 | 95363 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 20 | 3x3 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | ||
| 126702 | 126702 | 98737 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1150 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 24 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | ||
| 127279 | 127279 | 71177 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 4235 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/05/1995 12:00:00 AM | 12 | 4x4 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | |
| 128247 | 128247 | 116052 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 650x KANSAS ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6011530.0 | 2105347.0 | 37.761531458187 | -122.403232137637 | (37.761531458187, -122.403232137637) | |||
| 128761 | 128761 | 98739 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1150 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 20 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | ||
| 129870 | 129870 | 116056 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 650x Kansas St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 23 | 4x4 | 6011515.191980001 | 2105171.68257 | 37.7610492486475 | -122.40327101944901 | (37.7610492486475, -122.403271019449) | ||
| 139596 | 139596 | 73288 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 140357 | 140357 | 73285 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1999 12:00:00 AM | 13 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 142663 | 142663 | 42642 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 5 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 19684 | 19684 | 50106 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672002 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | ||
| 22305 | 22305 | 68937 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 518 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/2017 12:00:00 AM | 3 | Permit Number 779489 | 5992539.41235 | 2111890.04765 | 37.7784180283155 | -122.46938847408998 | (37.7784180283155, -122.46938847409) | |
| 33086 | 33086 | 59887 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 21 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 23 | Permit Number 19353 | 5998815.1407 | 2110971.0405 | 37.776255342115604 | -122.447612291383 | (37.7762553421156, -122.447612291383) | |
| 39815 | 39815 | 38562 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1620 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40527 | 6015255.0701 | 2096054.7136 | 37.736224122234205 | -122.389699501807 | (37.7362241222342, -122.389699501807) | |
| 50321 | 50321 | 74916 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2350 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 20 | 5991352.5470199995 | 2112035.32766 | 37.778748267925295 | -122.473504845805 | (37.7787482679253, -122.473504845805) | ||
| 51035 | 51035 | 68988 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3336 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 15 | Permit Number 32980 | 6000849.989680001 | 2119837.16995 | 37.8007155175595 | -122.441209485631 | (37.8007155175595, -122.441209485631) | |
| 58950 | 58950 | 121048 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2652 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006192.78395747 | 2119877.54417008 | 37.80112926306921 | -122.422724050002 | (37.8011292630692, -122.422724050002) | ||||
| 65608 | 65608 | 73728 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1714 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/1988 12:00:00 AM | 20 | 6010056.6035 | 2120001.6041 | 37.8016871392069 | -122.409362262219 | (37.8016871392069, -122.409362262219) | ||
| 66114 | 66114 | 83328 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1653-1655 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 23 | 6008329.52279 | 2118179.08917 | 37.7965860510686 | -122.415209687771 | (37.7965860510686, -122.415209687771) | ||
| 67457 | 67457 | 43163 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 222 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 42973 | 6005640.84958 | 2092540.2669400002 | 37.7260364164322 | -122.42269019099301 | (37.7260364164322, -122.422690190993) | |
| 80803 | 80803 | 47791 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 415 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45915 | 5995369.31891331 | 2098249.44976906 | 37.741127575703004 | -122.45861111062 | (37.741127575703, -122.45861111062) | ||
| 86002 | 86002 | 50101 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1520 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46828 | 5992463.83947388 | 2096912.47054003 | 37.7372891525979 | -122.46855986898599 | (37.7372891525979, -122.468559868986) | ||
| 86265 | 86265 | 41311 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Garcia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2002 12:00:00 AM | Permit Number 41984 | 5995254.05842615 | 2099498.8895679 | 37.7445516019752 | -122.459100086565 | (37.7445516019752, -122.459100086565) | ||
| 92300 | 92300 | 50099 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1510 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46827 | 5992486.72879777 | 2096933.93018279 | 37.7373493975579 | -122.468482291601 | (37.7373493975579, -122.468482291601) | ||
| 93820 | 93820 | 50105 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672002 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | ||
| 94268 | 94268 | 50109 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1562 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.736989442757505 | -122.468964178249 | (37.7369894427575, -122.468964178249) | ||
| 94598 | 94598 | 50108 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1562 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.736989442757505 | -122.468964178249 | (37.7369894427575, -122.468964178249) | ||
| 102797 | 102797 | 50102 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1530 Portola Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.737221572040205 | -122.468657807095 | (37.7372215720402, -122.468657807095) | ||
| 109013 | 109013 | 50104 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1530 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.737221572040205 | -122.468657807095 | (37.7372215720402, -122.468657807095) | ||
| 113694 | 113694 | 41284 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2652 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2000 12:00:00 AM | Permit Number 41962 | 6006192.78395747 | 2119877.54417008 | 37.80112926306921 | -122.422724050002 | (37.8011292630692, -122.422724050002) | ||
| 116268 | 116268 | 42069 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 10 | 3x3 | Permit Number 42381 | 6015269.0 | 2115673.0 | 37.790092461076604 | -122.39102211089701 | (37.7900924610766, -122.391022110897) |
| 120400 | 120400 | 36261 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 48818 | 5991187.85899012 | 2094553.0256483997 | 37.7307369236006 | -122.47279948850701 | (37.7307369236006, -122.472799488507) | ||
| 121443 | 121443 | 52926 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 171 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48909 | 5988008.14773 | 2114828.39565 | 37.786222999509704 | -122.485279285217 | (37.7862229995097, -122.485279285217) |
| 122709 | 122709 | 50100 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1520 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46828 | 5992463.83947388 | 2096912.47054003 | 37.7372891525979 | -122.46855986898599 | (37.7372891525979, -122.468559868986) | ||
| 128368 | 128368 | 50103 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1530 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.737221572040205 | -122.468657807095 | (37.7372215720402, -122.468657807095) | ||
| 141974 | 141974 | 50107 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1562 Portola Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.736989442757505 | -122.468964178249 | (37.7369894427575, -122.468964178249) | ||
| 142443 | 142443 | 53040 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3666@ GUERRERO 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/2006 12:00:00 AM | Permit Number 49018 | 6005866.70904359 | 2104351.76912463 | 37.758480874637 | -122.42274843163 | (37.758480874637, -122.42274843163) | ||
| 155288 | 155288 | 83818 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1653-1655 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 22 | 6008323.3908 | 2118208.09875 | 37.7966653595727 | -122.415232960457 | (37.7966653595727, -122.415232960457) | ||
| 156403 | 156403 | 60095 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3343 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1982 12:00:00 AM | 10 | Permit Number 19596 | 5998235.21709 | 2116151.87187 | 37.7904473875938 | -122.449991880723 | (37.7904473875938, -122.449991880723) | |
| 156775 | 156775 | 68873 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 161 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 10 | Permit Number 32844 | 5992095.21626 | 2114354.3372400003 | 37.7851586118271 | -122.47110467851499 | (37.7851586118271, -122.471104678515) | |
| 157818 | 157818 | 35381 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 531 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 3 | Permit Number 38837 | 6011249.266919999 | 2105860.5302 | 37.76292581448371 | -122.404239227767 | (37.7629258144837, -122.404239227767) | |
| 185884 | 185884 | 59890 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 12 | Permit Number 19356 | 5998808.9736 | 2111008.0431 | 37.77635658928261 | -122.447636289265 | (37.7763565892826, -122.447636289265) | |
| 186352 | 186352 | 47483 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1736 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 22 | Permit Number 45378 | 6002071.5211 | 2114540.3904 | 37.786241439117205 | -122.436603142325 | (37.7862414391172, -122.436603142325) | |
| 5 | 5 | 188702 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Evans Ave | 2 | : 4 | Tree 1 | DPW 2 | 17 | Width 4ft | 6015994.71985 | 2098219.31717 | 37.7422086702947 | -122.387293152263 | (37.7422086702947, -122.387293152263) | |||
| 7 | 7 | 188697 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Evans Ave | 13 | : 4 | Tree 1 | DPW 2 | 15 | Width 3ft | 6017236.81305 | 2097292.98379 | 37.7397338556296 | -122.38293388291001 | (37.7397338556296, -122.38293388291) | |||
| 29 | 29 | 188686 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Evans Ave | 20 | : 4 | Tree 1 | DPW 2 | 12 | Width 3ft | 6017760.57019 | 2097020.5910900002 | 37.739014844955705 | -122.381104000867 | (37.7390148449557, -122.381104000867) | |||
| 31 | 31 | 22614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.781365013820206 | -122.424863625752 | (37.7813650138202, -122.424863625752) | |||
| 58 | 58 | 4749 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1255 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 8 | 3X3 | 6007516.58505 | 2121541.63395 | 37.805773032263296 | -122.41826116482599 | (37.8057730322633, -122.418261164826) | ||
| 74 | 74 | 188665 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2175X Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 37 | 6011669.71313 | 2097723.45025 | 37.740606653987705 | -122.402212916691 | (37.7406066539877, -122.402212916691) | ||||
| 85 | 85 | 22613 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005358.7073 | 2112686.5825 | 37.7813375942673 | -122.42509837168001 | (37.7813375942673, -122.42509837168) | |||
| 105 | 105 | 6251 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1315 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/06/2003 12:00:00 AM | 24 | 3X3 | 6004480.8051 | 2113256.6545 | 37.7828532389184 | -122.428176124144 | (37.7828532389184, -122.428176124144) | ||
| 341 | 341 | 14553 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 875 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999239.2853 | 2109883.9856 | 37.7732947980524 | -122.446066856713 | (37.7732947980524, -122.446066856713) | |||
| 613 | 613 | 20019 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 670 | 670 | 13108 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1557 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6004929.5061 | 2119810.12 | 37.80087277869679 | -122.427090735634 | (37.8008727786968, -122.427090735634) | |||
| 769 | 769 | 110848 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2668 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 778643 | 6000804.34505 | 2117582.1485 | 37.7945212238167 | -122.441205550194 | (37.7945212238167, -122.441205550194) | ||
| 854 | 854 | 203901 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3794 19th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 12 | Width 3ft | 5990470.121669999 | 2090714.3108400002 | 37.720155198286 | -122.475000685058 | (37.720155198286, -122.475000685058) | |||
| 940 | 940 | 51496 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1350 REVISED Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47808 | 6000958.86990754 | 2110035.78536621 | 37.773809648853 | -122.44012948036101 | (37.773809648853, -122.440129480361) | |||
| 1022 | 1022 | 186874 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 0ft | 5985204.8462 | 2096382.2812 | 37.7354114037883 | -122.493618136413 | (37.7354114037883, -122.493618136413) | |||
| 1059 | 1059 | 186952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 0ft | 5985204.8226 | 2096075.4539 | 37.734568936321295 | -122.493595616872 | (37.7345689363213, -122.493595616872) | |||
| 1084 | 1084 | 8287 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1601 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2017 12:00:00 AM | 6 | 3x3 | 6015799.31492 | 2097666.33838 | 37.7406794801837 | -122.387930230222 | (37.7406794801837, -122.387930230222) | ||
| 1109 | 1109 | 20024 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
| 1175 | 1175 | 2161 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x100 | 6009743.36579 | 2090187.72527 | 37.71980743673429 | -122.408342124702 | (37.7198074367343, -122.408342124702) | |||
| 1261 | 1261 | 122608 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1214 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5987092.2626 | 2106978.1702 | 37.7646150951119 | -122.487870979055 | (37.7646150951119, -122.487870979055) | |||
| 1297 | 1297 | 245226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 451 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | Width 0ft | 6005125.512 | 2110566.2977 | 37.7755026358833 | -122.42575415301701 | (37.7755026358833, -122.425754153017) | |||
| 1309 | 1309 | 9930 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6005037.50257 | 2117672.2143200003 | 37.7950087418189 | -122.42656470240699 | (37.7950087418189, -122.426564702407) | |||
| 1376 | 1376 | 141859 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1126 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 0ft | 6004579.5781 | 2112622.703 | 37.7811181533984 | -122.42778922577801 | (37.7811181533984, -122.427789225778) | |||
| 1399 | 1399 | 116632 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2332 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2017 12:00:00 AM | 17 | 3x3 | Permit Number 779740 | 5991403.36215 | 2112037.8136299998 | 37.7787580362874 | -122.473329239514 | (37.7787580362874, -122.473329239514) | |
| 1407 | 1407 | 220312 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 4235 19th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 08/05/1995 12:00:00 AM | 15 | Width 3ft | 6002007.42492 | 2104678.29116 | 37.759158924972404 | -122.436118906483 | (37.7591589249724, -122.436118906483) | ||
| 1431 | 1431 | 220311 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 4235 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 08/05/1995 12:00:00 AM | 18 | Width 3ft | 6001938.02984 | 2104676.35813 | 37.7591496745354 | -122.436358769151 | (37.7591496745354, -122.436358769151) | ||
| 1479 | 1479 | 23464 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2305 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005842.187999999 | 2118344.10635 | 37.796899045714504 | -122.423828167031 | (37.7968990457145, -122.423828167031) | |||
| 1500 | 1500 | 251574 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 191 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999731.0 | 2100707.0 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | ||||
| 1523 | 1523 | 142666 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2310 MASON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6008911.1908 | 2121214.7045 | 37.8049537680909 | -122.413411770849 | (37.8049537680909, -122.413411770849) | |||
| 1555 | 1555 | 18077 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2946 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5999820.6048 | 2114741.0687 | 37.7866642791044 | -122.44440512772499 | (37.7866642791044, -122.444405127725) |
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");