Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: PlantType, qCareAssistant
qLegalStatus ✖
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |||
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) | ||
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) | ||
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) | |||
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) | |
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) | |||
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) | |||
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) | ||
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) | ||
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) | ||
87007 | 87007 | 12853 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2430 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/26/2001 12:00:00 AM | 18 | 4X4 | 5987942.80456 | 2114670.37051 | 37.785785300768104 | -122.485493751784 | (37.7857853007681, -122.485493751784) |
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");