Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 381 | 381 | 122664 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 401x Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 424 | 424 | 122666 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 401x Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 501 | 501 | 251171 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:21:00 AM | 3 | ||||||||
| 3117 | 3117 | 38667 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | Permit Number 40586 | ||||||||
| 3395 | 3395 | 46141 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 3539 | 3539 | 46147 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 4441 | 4441 | 35439 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38882 | ||||||||
| 4975 | 4975 | 47475 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 5594 | 5594 | 47610 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1201 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1994 12:00:00 AM | Permit Number 45444 | ||||||||
| 6723 | 6723 | 36868 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 6846 | 6846 | 38806 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 7010 | 7010 | 38798 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 7226 | 7226 | 47614 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45446 | ||||||||
| 7395 | 7395 | 32307 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1097 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | Permit Number 36882 | ||||||||
| 8218 | 8218 | 49626 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 152211th/10th Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46481 | ||||||||
| 8297 | 8297 | 38797 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 8580 | 8580 | 36870 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 8851 | 8851 | 35438 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38882 | ||||||||
| 8984 | 8984 | 32308 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1097 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | Permit Number 36882 | ||||||||
| 9592 | 9592 | 38801 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 10219 | 10219 | 173924 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 500X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/05/2010 12:00:00 AM | 3x3 | ||||||||
| 10402 | 10402 | 47618 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45446 | ||||||||
| 10935 | 10935 | 47612 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1201 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1994 12:00:00 AM | Permit Number 45444 | ||||||||
| 11087 | 11087 | 38804 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 11608 | 11608 | 19893 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 STAIRWAY33 | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 11642 | 11642 | 122665 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 401x Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 11778 | 11778 | 108180 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 835 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
| 11836 | 11836 | 38805 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 11869 | 11869 | 38665 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | Permit Number 40586 | ||||||||
| 12478 | 12478 | 46150 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44491 | |||||||||
| 12569 | 12569 | 38803 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 12596 | 12596 | 35440 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38882 | ||||||||
| 12668 | 12668 | 38799 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 13157 | 13157 | 36846 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 13310 | 13310 | 38802 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 13441 | 13441 | 95083 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 730@ Waller Stanyan Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2010 12:00:00 AM | 3x3 | Permit Number 54023 | |||||||
| 13534 | 13534 | 46142 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 13812 | 13812 | 38664 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | Permit Number 40586 | ||||||||
| 13951 | 13951 | 19889 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 STAIRWAY33 | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 13983 | 13983 | 47477 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 14113 | 14113 | 88119 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1313 Dorado Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51123 | ||||||||
| 14223 | 14223 | 19896 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 STAIRWAY33 | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 14262 | 14262 | 35437 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38882 | ||||||||
| 14298 | 14298 | 46149 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44491 | |||||||||
| 14485 | 14485 | 47615 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45446 | ||||||||
| 14565 | 14565 | 47478 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 14731 | 14731 | 38800 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1998 12:00:00 AM | Permit Number 40645 | |||||||||
| 14833 | 14833 | 47617 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45446 | ||||||||
| 14971 | 14971 | 32309 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1097 Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | Permit Number 36882 | ||||||||
| 15357 | 15357 | 47616 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1209 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45446 | ||||||||
| 15399 | 15399 | 35441 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 757 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38882 | ||||||||
| 15807 | 15807 | 47476 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 16155 | 16155 | 19897 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 STAIRWAY33 | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 16669 | 16669 | 47611 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1201 Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1994 12:00:00 AM | Permit Number 45444 | ||||||||
| 16699 | 16699 | 36867 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 16882 | 16882 | 46143 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 16963 | 16963 | 38666 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | Permit Number 40586 | ||||||||
| 18305 | 18305 | 122667 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 401x Laguna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 18310 | 18310 | 122663 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 401x Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 83062 | 83062 | 87694 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2640X Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6010413.19181 | 2085847.77235 | 37.707928294454 | -122.40572122924401 | (37.707928294454, -122.405721229244) | |||
| 124612 | 124612 | 87693 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2640X Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6010430.21787 | 2085894.88295 | 37.70805860283 | -122.405665701193 | (37.70805860283, -122.405665701193) | |||
| 144219 | 144219 | 87692 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2640X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6010446.60881 | 2085937.89343 | 37.708177617555 | -122.405612079416 | (37.708177617555, -122.405612079416) | |||
| 107817 | 107817 | 87691 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2640X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6010453.75722 | 2085956.2731400002 | 37.7082284842795 | -122.40558866725 | (37.7082284842795, -122.40558866725) | |||
| 169260 | 169260 | 177163 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 189 Velasco Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 6ft | 6007991.7614400005 | 2086069.6109099998 | 37.70840170934729 | -122.41410563508002 | (37.7084017093473, -122.41410563508) | |||
| 12737 | 12737 | 87690 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2630 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6010490.11707 | 2086047.16098 | 37.7084800771634 | -122.405469399602 | (37.7084800771634, -122.405469399602) | |||
| 99599 | 99599 | 87689 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2630 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6010491.45707 | 2086051.50645 | 37.7084920838776 | -122.405465074207 | (37.7084920838776, -122.405465074207) | |||
| 12015 | 12015 | 87688 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2610 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010514.44412 | 2086115.5788099999 | 37.7086692990048 | -122.40539013695 | (37.7086692990048, -122.40539013695) | |||
| 151378 | 151378 | 177164 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 30 Kelloch Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6008391.56884 | 2086208.1675200001 | 37.708804605615896 | -122.41273363745701 | (37.7088046056159, -122.412733637457) | |||
| 39559 | 39559 | 68740 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 535 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1993 12:00:00 AM | 1 | Permit Number 32660 | 6002126.65992 | 2086442.09338 | 37.7090932906808 | -122.43440270504601 | (37.7090932906808, -122.434402705046) | ||
| 13139 | 13139 | 1863 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2555 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x4 | 6010687.82205 | 2086284.94522 | 37.7091440376363 | -122.40480283289301 | (37.7091440376363, -122.404802832893) | |||
| 10645 | 10645 | 25434 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2555 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1997 12:00:00 AM | 3 | 3X3 | 6010726.4249599995 | 2086380.40177 | 37.7094082998174 | -122.404676130107 | (37.7094082998174, -122.404676130107) | ||
| 71528 | 71528 | 87670 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2566 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2008 12:00:00 AM | 7 | 3x3 | 6010619.90068 | 2086394.2914900002 | 37.7094404838562 | -122.405045274813 | (37.7094404838562, -122.405045274813) | ||
| 36082 | 36082 | 177203 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2566 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010634.29235 | 2086429.2560700001 | 37.7095372940866 | -122.404997994767 | (37.7095372940866, -122.404997994767) | |||
| 10671 | 10671 | 1873 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2566 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2016 12:00:00 AM | 3 | 3X3 | 6010639.8141 | 2086443.56694 | 37.709576897530205 | -122.404979917507 | (37.7095768975302, -122.404979917507) | ||
| 72571 | 72571 | 177202 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2550 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010683.11352 | 2086534.8357 | 37.709829923570105 | -122.40483668787901 | (37.7098299235701, -122.404836687879) | |||
| 13013 | 13013 | 1304 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 10 | 5991645.96929 | 2086939.8139900002 | 37.7098594231521 | -122.470661434599 | (37.7098594231521, -122.470661434599) | |||
| 11332 | 11332 | 1303 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 10 | 5991684.008830001 | 2086976.4673900001 | 37.709962264210404 | -122.47053263188299 | (37.7099622642104, -122.470532631883) | |||
| 11780 | 11780 | 1871 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2550 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2000 12:00:00 AM | 3 | 3X3 | 6010716.96958 | 2086597.0486400002 | 37.7100026401694 | -122.40472405137 | (37.7100026401694, -122.40472405137) | ||
| 100721 | 100721 | 57262 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1063 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | Permit Number 14553 | 6001117.51152299 | 2086803.56775356 | 37.7100284852727 | -122.43791633997101 | (37.7100284852727, -122.437916339971) | ||
| 90771 | 90771 | 98853 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4043X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5991835.94326 | 2086997.82238 | 37.710029684074 | -122.470009076276 | (37.710029684074, -122.470009076276) | |||||
| 142295 | 142295 | 94596 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2520 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010715.9 | 2086627.1 | 37.710085095387 | -122.404729862288 | (37.710085095387, -122.404729862288) | ||||
| 10819 | 10819 | 1309 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4027 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1990 12:00:00 AM | 12 | 3x6 | 5991894.9163 | 2087061.7116099999 | 37.7102085174809 | -122.46980990430201 | (37.7102085174809, -122.469809904302) | ||
| 12049 | 12049 | 1300 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991824.5048400005 | 2087077.28239 | 37.7102472009077 | -122.470054391311 | (37.7102472009077, -122.470054391311) | |||
| 87233 | 87233 | 1315 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4050X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/1990 12:00:00 AM | 6 | TR | 5991740.4279021 | 2087082.0100679002 | 37.710255321179204 | -122.470345319704 | (37.7102553211792, -122.470345319704) | ||
| 121832 | 121832 | 1319 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4050X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 15 | TR | 5991740.4279021 | 2087082.0100679002 | 37.710255321179204 | -122.470345319704 | (37.7102553211792, -122.470345319704) | ||
| 141226 | 141226 | 1316 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4050X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 3 | TR | 5991740.4279021 | 2087082.0100679002 | 37.710255321179204 | -122.470345319704 | (37.7102553211792, -122.470345319704) | ||
| 10749 | 10749 | 1305 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4001 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/1990 12:00:00 AM | 12 | 3X6 | 5991918.74663 | 2087079.0784200002 | 37.710257579983 | -122.46972880613501 | (37.710257579983, -122.469728806135) | ||
| 146721 | 146721 | 177200 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 401 Lathrop Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012590.82817 | 2086718.74594 | 37.710441353745104 | -122.398256125432 | (37.7104413537451, -122.398256125432) | |||
| 137179 | 137179 | 177201 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 401 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012553.51492 | 2086730.60115 | 37.7104718272899 | -122.3983859201 | (37.7104718272899, -122.3983859201) | |||
| 146414 | 146414 | 177209 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 410 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012214.6354 | 2086747.5799900002 | 37.7104995641672 | -122.39955835902501 | (37.7104995641672, -122.399558359025) | |||
| 154523 | 154523 | 177157 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1027 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6008689.83875 | 2086868.9498700001 | 37.710635715231 | -122.41174943110799 | (37.710635715231, -122.411749431108) | |||
| 87448 | 87448 | 94595 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2450 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010809.3 | 2086846.3 | 37.7106921945144 | -122.404422470916 | (37.7106921945144, -122.404422470916) | ||||
| 13057 | 13057 | 87634 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2445 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6010990.9044699995 | 2086850.9551099997 | 37.710715123576705 | -122.403795129051 | (37.7107151235767, -122.403795129051) | ||||
| 10417 | 10417 | 1292 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3990 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5992119.08452 | 2087279.95314 | 37.710820711192 | -122.46905101320499 | (37.710820711192, -122.469051013205) | |||
| 710 | 710 | 1291 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3990 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/2017 01:08:00 PM | 3 | 3x3 | 5992151.4222 | 2087298.4709 | 37.7108734249293 | -122.468940594456 | (37.7108734249293, -122.468940594456) | ||
| 116396 | 116396 | 105996 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3990A ALEMANY BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2014 12:00:00 AM | 3 | 3x3 | 5992123.9 | 2087300.1 | 37.7108763078665 | -122.469035835215 | (37.7108763078665, -122.469035835215) | ||
| 12227 | 12227 | 1290 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3990 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2009 12:00:00 AM | 10 | 3x3 | 5992171.95554 | 2087305.7181400002 | 37.710894510437 | -122.468870154131 | (37.710894510437, -122.468870154131) | ||
| 10314 | 10314 | 87635 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2401 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6011029.25458 | 2086915.6444700002 | 37.7108948899543 | -122.40366713034099 | (37.7108948899543, -122.403667130341) | ||||
| 10334 | 10334 | 94592 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2428 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2016 10:36:00 AM | 3 | 3x3 | 6010911.88561 | 2086922.4145 | 37.7109069219836 | -122.404073263263 | (37.7109069219836, -122.404073263263) | ||
| 115715 | 115715 | 64080 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3034 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/2005 12:00:00 AM | Permit Number 24841 | 5996551.17505365 | 2087271.04793598 | 37.711051349474 | -122.453732129826 | (37.711051349474, -122.453732129826) |
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");