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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||
| 133290 | 133290 | 117891 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 506 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5982566.38409 | 2112290.68382 | 37.778936677318704 | -122.503918023894 | (37.7789366773187, -122.503918023894) | |||
| 142981 | 142981 | 65059 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 7700 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1989 12:00:00 AM | Permit Number 27015 | 5983151.6969943 | 2112515.42609005 | 37.779588154222296 | -122.501909859305 | (37.7795881542223, -122.501909859305) | ||
| 112008 | 112008 | 58890 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3900 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32466 | 5983513.05902354 | 2111069.36727446 | 37.775638918046 | -122.500552819741 | (37.775638918046, -122.500552819741) | ||
| 50158 | 50158 | 20507 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1211X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 85752 | 85752 | 20509 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1211X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 95897 | 95897 | 20508 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1211X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 80645 | 80645 | 21134 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2292X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
| 81283 | 81283 | 21136 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2292X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
| 114053 | 114053 | 117344 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 723 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778486 | 5985034.9 | 2110919.2 | 37.7753158216394 | -122.49527739893 | (37.7753158216394, -122.49527739893) | ||
| 50194 | 50194 | 118257 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 723 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5985049.68118 | 2110922.13778 | 37.7753247533513 | -122.495226484867 | (37.7753247533513, -122.495226484867) | |||
| 118046 | 118046 | 21244 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2401X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5985051.1945321 | 2098862.1753589 | 37.7422115377949 | -122.49433209823401 | (37.7422115377949, -122.494332098234) | |||
| 139431 | 139431 | 21245 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2401X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5985051.1945321 | 2098862.1753589 | 37.7422115377949 | -122.49433209823401 | (37.7422115377949, -122.494332098234) | |||
| 153821 | 153821 | 48728 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 771 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50259 | 5985060.71128 | 2110644.98954 | 37.7745644293194 | -122.49516788773799 | (37.7745644293194, -122.495167887738) | |
| 66441 | 66441 | 118254 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 771 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5985061.967180001 | 2110625.51599 | 37.7745110340434 | -122.495162107078 | (37.7745110340434, -122.495162107078) | |||
| 138850 | 138850 | 95501 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | 3x3 | 5985979.29593 | 2112362.71829 | 37.7793345591202 | -122.492116870392 | (37.7793345591202, -122.492116870392) | |||
| 93918 | 93918 | 95500 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | 3x3 | 5985980.30461 | 2112381.8602 | 37.779387176289504 | -122.49211479078899 | (37.7793871762895, -122.492114790789) | |||
| 108047 | 108047 | 95503 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | 3x3 | 5985983.49633 | 2112291.6636099997 | 37.7791397088392 | -122.49209710655701 | (37.7791397088392, -122.492097106557) | |||
| 102729 | 102729 | 95507 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | 3x3 | 5985983.58763 | 2112182.96811 | 37.778841267423296 | -122.492088785464 | (37.7788412674233, -122.492088785464) | |||
| 124241 | 124241 | 95506 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3X3 | 5985984.4170699995 | 2112207.80318 | 37.7789095059085 | -122.49208774520001 | (37.7789095059085, -122.4920877452) | |||
| 141874 | 141874 | 69444 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 295 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | Permit Number 33554 | 5986182.36725864 | 2113923.09081292 | 37.7836307630896 | -122.49152925861799 | (37.7836307630896, -122.491529258618) | ||
| 111877 | 111877 | 69465 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 55 Sea View Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | Permit Number 33580 | 5986199.91571588 | 2114165.23415041 | 37.7842966444278 | -122.491486377668 | (37.7842966444278, -122.491486377668) | ||
| 138339 | 138339 | 69464 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 45 Sea View Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | Permit Number 33579 | 5986250.30379846 | 2114173.621993 | 37.7843226194487 | -122.491312672565 | (37.7843226194487, -122.491312672565) | ||
| 93320 | 93320 | 69463 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 25 Sea View Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | Permit Number 33578 | 5986363.26585636 | 2114191.22559087 | 37.7843775538511 | -122.490923164564 | (37.7843775538511, -122.490923164564) | ||
| 18567 | 18567 | 84541 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 838 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51852 | 5986369.18358167 | 2110196.92433931 | 37.773410687311504 | -122.49060871536001 | (37.7734106873115, -122.49060871536) | ||
| 110175 | 110175 | 99910 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 710 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2012 12:00:00 AM | Permit Number 769055 | 5986442.0 | 2114842.0 | 37.7861689922045 | -122.490698673964 | (37.7861689922045, -122.490698673964) | |||
| 53246 | 53246 | 45774 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 610 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2001 12:00:00 AM | Permit Number 44417 | 5986681.45723276 | 2115112.83682499 | 37.7869266168429 | -122.489890152931 | (37.7869266168429, -122.489890152931) | |||
| 116280 | 116280 | 45773 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 610 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2001 12:00:00 AM | Permit Number 44417 | 5986681.45723276 | 2115112.83682499 | 37.7869266168429 | -122.489890152931 | (37.7869266168429, -122.489890152931) | |||
| 141017 | 141017 | 45775 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 610 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2001 12:00:00 AM | Permit Number 44417 | 5986681.45723276 | 2115112.83682499 | 37.7869266168429 | -122.489890152931 | (37.7869266168429, -122.489890152931) | |||
| 78211 | 78211 | 107727 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 727 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x4 | Permit Number 769036 | 5986913.815909999 | 2110969.7225200003 | 37.7755643712881 | -122.488781596408 | (37.7755643712881, -122.488781596408) | ||
| 159765 | 159765 | 50213 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 755@ BALBOA 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 10 | Permit Number 46921 | 5986919.50408 | 2110799.96946 | 37.7750986092321 | -122.488749439421 | (37.7750986092321, -122.488749439421) | |
| 40297 | 40297 | 250727 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2720 Lake St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5986989.77084 | 2114474.42914 | 37.7851917306499 | -122.488776528028 | (37.7851917306499, -122.488776528028) | |||
| 47429 | 47429 | 250726 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2720 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5987005.7157 | 2114475.31033 | 37.785195080640996 | -122.488721429273 | (37.785195080641, -122.488721429273) | |||
| 84416 | 84416 | 69305 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1597 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | Permit Number 33384 | 5987131.99926851 | 2104416.08526958 | 37.75758263129521 | -122.48754531591601 | (37.7575826312952, -122.487545315916) | ||
| 132673 | 132673 | 250933 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 258 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5987147.60505 | 2114230.18053 | 37.78453030356079 | -122.488212522694 | (37.7845303035608, -122.488212522694) | |||
| 63322 | 63322 | 250932 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 258 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5987148.83529 | 2114215.58098 | 37.7844902891505 | -122.488207193321 | (37.7844902891505, -122.488207193321) | |||
| 124110 | 124110 | 120099 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2501 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5987672.5212900005 | 2114613.19318 | 37.7856125573135 | -122.48642464438801 | (37.7856125573135, -122.486424644388) | |||
| 99702 | 99702 | 12861 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2505X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1990 12:00:00 AM | 60 | 3X3 | 5987711.035209999 | 2114617.00172 | 37.78562525933621 | -122.48629167878401 | (37.7856252593362, -122.486291678784) | ||
| 83370 | 83370 | 115588 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2574 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5987741.7 | 2097778.5 | 37.739393135719105 | -122.484949795247 | (37.7393931357191, -122.484949795247) | |||
| 72524 | 72524 | 12856 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2450 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2005 12:00:00 AM | 8 | 3X3 | 5987796.21957 | 2114672.62514 | 37.785782949969295 | -122.486001053684 | (37.7857829499693, -122.486001053684) | ||
| 62089 | 62089 | 250488 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 236 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987839.39614 | 2115354.89245 | 37.787658776979704 | -122.48590177317 | (37.7876587769797, -122.48590177317) | |||
| 100899 | 100899 | 12854 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2430 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2011 12:00:00 AM | 18 | 4X4 | 5987861.22269 | 2114676.5280299997 | 37.7857974541311 | -122.485776450604 | (37.7857974541311, -122.485776450604) |
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");