Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 61594 | 61594 | 203663 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 271 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5998288.8054599995 | 2093783.09686 | 37.7290313953773 | -122.44819509282699 | (37.7290313953773, -122.448195092827) | |||
| 148365 | 148365 | 203637 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 270 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998290.1238 | 2093810.02027 | 37.7291053960882 | -122.448192473116 | (37.7291053960882, -122.448192473116) | |||
| 110661 | 110661 | 30763 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1542 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34644 | 6014903.15895955 | 2093519.78776627 | 37.729244209154295 | -122.39073911946801 | (37.7292442091543, -122.390739119468) | ||
| 174458 | 174458 | 203224 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 30 Northgate Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5994449.32754 | 2093942.03458 | 37.7292475573046 | -122.461479885289 | (37.7292475573046, -122.461479885289) | |||
| 152716 | 152716 | 40191 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 600 Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008969.320719999 | 2093798.8519 | 37.7296794522306 | -122.411272698701 | (37.7296794522306, -122.411272698701) | ||
| 73601 | 73601 | 40189 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 600 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008978.52665 | 2093804.69628 | 37.7296960159571 | -122.411241285381 | (37.7296960159571, -122.411241285381) | ||
| 31368 | 31368 | 40190 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 600 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008992.69015 | 2093809.01989 | 37.729708681998 | -122.411192625738 | (37.729708681998, -122.411192625738) | ||
| 34582 | 34582 | 174966 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 44 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009006.884330001 | 2093841.0199900002 | 37.729797343475596 | -122.411145814235 | (37.7297973434756, -122.411145814235) | |||
| 81910 | 81910 | 42335 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 207 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | ||
| 91322 | 91322 | 42334 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 207 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | ||
| 173679 | 173679 | 30757 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1553 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 11 | Permit Number 34638 | 6014989.6074 | 2093734.2507 | 37.729837877239795 | -122.390455236274 | (37.7298378772398, -122.390455236274) | |
| 98266 | 98266 | 30758 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1557 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34639 | 6014967.84012217 | 2093755.65118605 | 37.7298954311335 | -122.390531983655 | (37.7298954311335, -122.390531983655) | ||
| 149037 | 149037 | 70299 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 237 Theresa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 9 | 6001826.3531599995 | 2094025.88285 | 37.7298996296434 | -122.435982902906 | (37.7298996296434, -122.435982902906) | ||
| 3060 | 3060 | 203634 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 432 Flood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 11 | Width 2ft | Permit Number 42544 | 5997859.0322900005 | 2094116.10367 | 37.7299211747225 | -122.449704832412 | (37.7299211747225, -122.449704832412) | |
| 35427 | 35427 | 203633 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 458 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997727.849830001 | 2094119.15999 | 37.7299220605503 | -122.45015856377199 | (37.7299220605503, -122.450158563772) | |||
| 183501 | 183501 | 203636 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 418 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997970.50252 | 2094115.71728 | 37.7299264906074 | -122.449319440552 | (37.7299264906074, -122.449319440552) | |||
| 54361 | 54361 | 203635 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 418 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5997950.41926 | 2094116.13567 | 37.7299264906077 | -122.44938890058201 | (37.7299264906077, -122.449388900582) | |||
| 47147 | 47147 | 73391 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 237 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 10 | 6001816.88591 | 2094039.23102 | 37.72993574283429 | -122.43601658701999 | (37.7299357428343, -122.43601658702) | ||
| 108121 | 108121 | 42339 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 432 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42544 | 5997882.68725291 | 2094126.21532195 | 37.7299502922476 | -122.449623783134 | (37.7299502922476, -122.449623783134) | ||
| 162381 | 162381 | 40685 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 114 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 6 | Permit Number 41668 | 6004151.556609999 | 2094012.13266 | 37.7299936942445 | -122.42794342066001 | (37.7299936942445, -122.42794342066) | |
| 138983 | 138983 | 30760 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1571 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34641 | 6014896.23757332 | 2093808.81402101 | 37.7300374330916 | -122.390783237924 | (37.7300374330916, -122.390783237924) | ||
| 97186 | 97186 | 30761 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1575 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34642 | 6014875.77973499 | 2093824.0033781002 | 37.7300780049156 | -122.39085502491999 | (37.7300780049156, -122.39085502492) | ||
| 145378 | 145378 | 42099 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 337 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42405 | 5999399.61952202 | 2094185.90721086 | 37.730200858866205 | -122.44438387280898 | (37.7302008588662, -122.444383872809) | ||
| 146004 | 146004 | 203662 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 337 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5999398.70847 | 2094267.55477 | 37.7304249920009 | -122.44439288782301 | (37.7304249920009, -122.444392887823) | |||
| 82740 | 82740 | 67907 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 557 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/08/1994 12:00:00 AM | Permit Number 31610 | 5997734.62104287 | 2094370.88558597 | 37.7306136268107 | -122.450153291964 | (37.7306136268107, -122.450153291964) | ||
| 143846 | 143846 | 67906 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 351 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31609 | 5999092.51556245 | 2094349.39726639 | 37.7306322373229 | -122.44545731887 | (37.7306322373229, -122.44545731887) | ||
| 78530 | 78530 | 42106 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 305 Hearst Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42409 | 5999382.77994639 | 2094344.80390055 | 37.730636191213996 | -122.444453504412 | (37.730636191214, -122.444453504412) | ||
| 155339 | 155339 | 31136 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 371 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34851 | 5998968.1475599995 | 2094360.3261099998 | 37.730655144717105 | -122.445888061981 | (37.7306551447171, -122.445888061981) | |
| 161456 | 161456 | 78061 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 107 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2000 12:00:00 AM | 8 | 6006671.077740001 | 2094291.78297 | 37.730903769473706 | -122.41925294078699 | (37.7309037694737, -122.419252940787) | ||
| 93807 | 93807 | 43210 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 350 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 43001 | 6008795.91385 | 2094346.1745799999 | 37.7311725561519 | -122.41191084861299 | (37.7311725561519, -122.411910848613) | |
| 119059 | 119059 | 47172 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 310 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | Permit Number 45136 | 5992595.84229454 | 2094810.68405906 | 37.731525796784 | -122.46795064653 | (37.731525796784, -122.46795064653) | ||
| 178200 | 178200 | 203649 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5993852.26622 | 2094804.8663700002 | 37.731582298063394 | -122.46360655802201 | (37.7315822980634, -122.463606558022) | |||
| 157925 | 157925 | 203650 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5993848.38247 | 2094813.0241599998 | 37.7316044735649 | -122.46362057664699 | (37.7316044735649, -122.463620576647) | |||
| 151268 | 151268 | 203651 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5993846.97887 | 2094818.6059299998 | 37.731619718855704 | -122.46362583408701 | (37.7316197188557, -122.463625834087) | |||
| 186555 | 186555 | 203630 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1400 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 5993843.17005 | 2094826.47883 | 37.731641116434496 | -122.46363957301 | (37.7316411164345, -122.46363957301) | |||
| 158134 | 158134 | 203631 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1400 Monterey Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 5993837.01835 | 2094842.09298 | 37.7316836345786 | -122.46366197331801 | (37.7316836345786, -122.463661973318) | |||
| 66468 | 66468 | 203632 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1400 Monterey Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5993831.29855 | 2094857.6984 | 37.7317261536347 | -122.463682879865 | (37.7317261536347, -122.463682879865) | |||
| 88651 | 88651 | 51518 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 622 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | Permit Number 47821 | 5998596.12110377 | 2094762.07724114 | 37.731737008800394 | -122.44720311183701 | (37.7317370088004, -122.447203111837) | |||
| 125998 | 125998 | 33399 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 300 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37517 | 5992600.35501271 | 2094892.48894855 | 37.7317506732587 | -122.467940993296 | (37.7317506732587, -122.467940993296) | ||
| 127159 | 127159 | 39701 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 625 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41086 | 5998544.21434681 | 2094768.39031032 | 37.7317513769747 | -122.447383017512 | (37.7317513769747, -122.447383017512) | ||
| 108082 | 108082 | 39702 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 628 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/2004 12:00:00 AM | Permit Number 41087 | 5998596.38137062 | 2094778.55233682 | 37.731782260395 | -122.447203397318 | (37.731782260395, -122.447203397318) | ||
| 18568 | 18568 | 39703 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41088 | 5998596.64163755 | 2094795.02743762 | 37.7318275120035 | -122.44720368280001 | (37.7318275120035, -122.4472036828) | ||
| 145627 | 145627 | 38582 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1565 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40542 | 6015429.1390942 | 2094459.97574961 | 37.7318549452945 | -122.388986360684 | (37.7318549452945, -122.388986360684) | ||
| 166210 | 166210 | 203659 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 628 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998583.28764 | 2094893.18321 | 37.7320962615306 | -122.44725691200199 | (37.7320962615306, -122.447256912002) | |||
| 179419 | 179419 | 203660 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998582.52704 | 2094910.5588200002 | 37.732143927389295 | -122.44726079165399 | (37.7321439273893, -122.447260791654) | |||
| 41760 | 41760 | 203657 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 226 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6000556.64604 | 2094979.3129099999 | 37.7324453144793 | -122.440440771241 | (37.7324453144793, -122.440440771241) | |||
| 79707 | 79707 | 46270 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 16 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/2002 12:00:00 AM | Permit Number 44554 | 6001971.15717323 | 2094954.12044598 | 37.732456582979495 | -122.435548678389 | (37.7324565829795, -122.435548678389) | ||
| 96633 | 96633 | 42373 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42548 | 5998094.3919548 | 2095072.92519048 | 37.7325618425703 | -122.448960067148 | (37.7325618425703, -122.448960067148) | ||
| 116996 | 116996 | 42372 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42548 | 5998094.3919548 | 2095072.92519048 | 37.7325618425703 | -122.448960067148 | (37.7325618425703, -122.448960067148) | ||
| 107642 | 107642 | 24822 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2006 12:00:00 AM | 3 | 3x3 | 6007873.98451 | 2094939.34624 | 37.732749510625 | -122.41514010253701 | (37.732749510625, -122.415140102537) | ||
| 21499 | 21499 | 24820 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 05/22/2008 12:00:00 AM | 12 | 3x3 | 6007910.58435 | 2094958.48618 | 37.732804121515606 | -122.415014921609 | (37.7328041215156, -122.415014921609) | ||
| 132310 | 132310 | 203658 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998103.1876300005 | 2095162.16833 | 37.732807386054795 | -122.448936084745 | (37.7328073860548, -122.448936084745) | |||
| 108432 | 108432 | 24819 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2001 12:00:00 AM | 18 | 3x3 | 6007950.68171 | 2094974.0594400002 | 37.7328491354706 | -122.41487739629801 | (37.7328491354706, -122.414877396298) | ||
| 31819 | 31819 | 220062 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 College Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6005376.5701 | 2095055.5296099999 | 37.7329278583224 | -122.423782556133 | (37.7329278583224, -122.423782556133) | |||
| 151645 | 151645 | 38575 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1511 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40535 | 6015329.8173 | 2094876.8945 | 37.732994214171704 | -122.389358843431 | (37.7329942141717, -122.389358843431) | |
| 107693 | 107693 | 42716 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 316 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42729 | 6012832.57789486 | 2094932.06844711 | 37.7330069432561 | -122.397996379955 | (37.7330069432561, -122.397996379955) | ||
| 118307 | 118307 | 38576 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1515 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/2005 12:00:00 AM | Permit Number 40536 | 6015316.8681654995 | 2094894.06453978 | 37.7330406417059 | -122.38940481098601 | (37.7330406417059, -122.389404810986) | ||
| 22043 | 22043 | 859 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6008091.178180001 | 2095049.40427 | 37.7330639095777 | -122.41439699202299 | (37.7330639095777, -122.414396992023) | |||
| 42561 | 42561 | 203661 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 582 Mangels Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5997537.55728 | 2095290.5878599999 | 37.7331276310309 | -122.450900858796 | (37.7331276310309, -122.450900858796) | |||
| 62065 | 62065 | 188522 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6016938.13191 | 2094902.8329099999 | 37.7331544721811 | -122.38380023041701 | (37.7331544721811, -122.383800230417) | |||
| 103637 | 103637 | 66324 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 88 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1995 12:00:00 AM | Permit Number 29443 | 6000832.40008628 | 2095235.41670142 | 37.733164213776796 | -122.439505779041 | (37.7331642137768, -122.439505779041) | ||
| 88150 | 88150 | 121723 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 199 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6001086.0 | 2095247.0 | 37.7332104486713 | -122.438629847451 | (37.7332104486713, -122.438629847451) | ||||
| 32980 | 32980 | 30799 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 131 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 8 | Permit Number 34665 | 6002107.114019999 | 2095231.84638 | 37.733226875715296 | -122.43509850062 | (37.7332268757153, -122.43509850062) | |
| 19290 | 19290 | 24816 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1996 12:00:00 AM | 12 | 2x3 | 6008197.49032 | 2095113.0796700001 | 37.733244720069706 | -122.414033944713 | (37.7332447200697, -122.414033944713) | ||
| 95100 | 95100 | 49583 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 95511 | 95511 | 49584 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | 8 | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | ||
| 107521 | 107521 | 49582 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 107975 | 107975 | 49585 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 108705 | 108705 | 49578 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 109529 | 109529 | 49577 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 111771 | 111771 | 49580 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 122865 | 122865 | 49581 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 128456 | 128456 | 49579 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 136405 | 136405 | 203653 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 125 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6002114.00252 | 2095255.92738 | 37.733293387768995 | -122.435076406948 | (37.733293387769, -122.435076406948) | |||
| 103358 | 103358 | 66155 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1741 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/1990 12:00:00 AM | Permit Number 29226 | 6013929.0546693 | 2095023.1611058 | 37.7333180723286 | -122.394211919223 | (37.7333180723286, -122.394211919223) | ||
| 125120 | 125120 | 68814 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 125 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32757 | 6002131.57604717 | 2095277.55167817 | 37.7333537609923 | -122.435017196532 | (37.7333537609923, -122.435017196532) | ||
| 187683 | 187683 | 188523 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney Young Cir | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6017281.36531 | 2094970.41702 | 37.733359012210606 | -122.382618269437 | (37.7333590122106, -122.382618269437) | |||
| 178617 | 178617 | 188524 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney Young Cir | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6017319.36932 | 2094988.95682 | 37.7334120182438 | -122.38248816719299 | (37.7334120182438, -122.382488167193) | |||
| 180380 | 180380 | 203655 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 230 Edna St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998797.91036 | 2095380.6148 | 37.7334468948521 | -122.446549972903 | (37.7334468948521, -122.446549972903) | ||||
| 181115 | 181115 | 203656 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 232 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5998785.56076 | 2095387.29688 | 37.733464536852395 | -122.446593149381 | (37.7334645368524, -122.446593149381) | ||||
| 88609 | 88609 | 67673 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1776 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31276 | 6014200.74997189 | 2095090.82766105 | 37.733518969015996 | -122.393277319642 | (37.733518969016, -122.393277319642) | ||
| 34993 | 34993 | 188525 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 10 Bell Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6016572.5482 | 2095212.67149 | 37.7339850114017 | -122.38508574382799 | (37.7339850114017, -122.385085743828) | |||
| 9300 | 9300 | 1913 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 8 Bell Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016615.0158522995 | 2095214.1533182 | 37.7339914292631 | -122.384939021898 | (37.7339914292631, -122.384939021898) | ||
| 51056 | 51056 | 203627 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 133 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5994260.237269999 | 2095673.9858 | 37.7339921852793 | -122.462259143365 | (37.7339921852793, -122.462259143365) | |||
| 64167 | 64167 | 203628 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 133 Maywood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5994258.53071 | 2095683.80268 | 37.734019041749 | -122.46226575516701 | (37.734019041749, -122.462265755167) | |||
| 97900 | 97900 | 36509 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 734 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39386 | 6007727.24180812 | 2095500.96385803 | 37.7342833425639 | -122.41568718150499 | (37.7342833425639, -122.415687181505) | ||
| 102450 | 102450 | 67937 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 82 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31650 | 6004338.16538286 | 2095684.17990183 | 37.734595316364796 | -122.427417358908 | (37.7345953163648, -122.427417358908) | ||
| 34587 | 34587 | 78000 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2804 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2000 12:00:00 AM | 7 | 5985608.4149 | 2096224.5025 | 37.735001786065 | -122.492211254352 | (37.735001786065, -122.492211254352) | ||
| 92505 | 92505 | 36515 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 263 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39393 | 6006742.46472301 | 2095809.17822197 | 37.735074223818 | -122.41911373442801 | (37.735074223818, -122.419113734428) | ||
| 16814 | 16814 | 105175 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1601X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 10 | 3x3 | 6015153.3918 | 2095715.6028 | 37.735287354242395 | -122.390027366589 | (37.7352873542424, -122.390027366589) | |||
| 96893 | 96893 | 105172 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1601X NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12 | 3x3 | Permit Number 770204 | 6015135.0 | 2095759.0 | 37.735405494081505 | -122.390093985074 | (37.7354054940815, -122.390093985074) | ||
| 41095 | 41095 | 220673 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 100 Alemany Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009345.21028 | 2095878.12902 | 37.735409776738294 | -122.410119940478 | (37.7354097767383, -122.410119940478) | |||
| 73916 | 73916 | 200693 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1607 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6015092.9345 | 2095762.8694 | 37.7354137854933 | -122.39023969268999 | (37.7354137854933, -122.39023969269) | |||
| 81411 | 81411 | 24833 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 200X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 01/12/1996 12:00:00 AM | 25 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.735490432624104 | -122.409874802768 | (37.7354904326241, -122.409874802768) | ||
| 25432 | 25432 | 220094 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 436 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6003910.2005900005 | 2096060.2503799999 | 37.735603706528394 | -122.42892377971 | (37.7356037065284, -122.42892377971) | |||
| 142784 | 142784 | 67651 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1919 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31250 | 6013521.72915428 | 2095881.08409425 | 37.7356511027367 | -122.39568025647101 | (37.7356511027367, -122.395680256471) | ||
| 79057 | 79057 | 32274 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 623 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39911 | 6007825.97257693 | 2096019.31993336 | 37.7357121847697 | -122.415382520688 | (37.7357121847697, -122.415382520688) | ||
| 124549 | 124549 | 36508 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 584 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/29/2003 12:00:00 AM | Permit Number 39385 | 6007790.43718065 | 2096197.35426509 | 37.736199030760105 | -122.41551798135401 | (37.7361990307601, -122.415517981354) | ||
| 92747 | 92747 | 61034 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 130 Swiss Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2011 12:00:00 AM | 3x5 | Permit Number 768338 | 6001256.29714973 | 2096400.69751215 | 37.736387920753295 | -122.43812370070101 | (37.7363879207533, -122.438123700701) | |
| 159982 | 159982 | 220096 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002436.28409 | 2096397.8300700001 | 37.736447085360105 | -122.43404379100402 | (37.7364470853601, -122.434043791004) |
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");