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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
445 | 445 | 251285 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1299x Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
1106 | 1106 | 251445 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6014884.877230001 | 2114997.01321 | 37.7882150346369 | -122.39230385636002 | (37.7882150346369, -122.39230385636) | ||||
1388 | 1388 | 251519 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1401 | 1401 | 251523 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1414 | 1414 | 251524 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1416 | 1416 | 251521 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1425 | 1425 | 251522 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1433 | 1433 | 251520 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
1768 | 1768 | 251696 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 98 11th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
1905 | 1905 | 251810 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 3 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
1912 | 1912 | 251809 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 2 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
1921 | 1921 | 251811 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 4 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
2085 | 2085 | 252880 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001313.0 | 2088154.0 | 37.7137475882422 | -122.43733732943001 | (37.7137475882422, -122.43733732943) | ||||
2156 | 2156 | 252915 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1924 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/27/2012 12:00:00 AM | 3x3 | 6007321.0 | 2118975.0 | 37.79871469295279 | -122.418755881393 | (37.7987146929528, -122.418755881393) | |||
2206 | 2206 | 252954 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5998847.0 | 2112431.0 | 37.7802658347108 | -122.44760720084999 | (37.7802658347108, -122.44760720085) | ||||
2208 | 2208 | 252955 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5998847.0 | 2112431.0 | 37.7802658347108 | -122.44760720084999 | (37.7802658347108, -122.44760720085) | ||||
2312 | 2312 | 253038 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778941 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | |||
2318 | 2318 | 253034 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
2328 | 2328 | 253035 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
2338 | 2338 | 253037 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
2339 | 2339 | 253036 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
2615 | 2615 | 253153 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2030 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2017 12:00:00 AM | Permit Number 779475 | 6015677.29531 | 2106131.10604 | 37.763915191309295 | -122.38894296750799 | (37.7639151913093, -122.388942967508) | |||
3023 | 3023 | 253281 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 5997149.818 | 2108070.0101 | 37.7681945486983 | -122.453163595144 | (37.7681945486983, -122.453163595144) | ||||
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 | |||||||||
3670 | 3670 | 253512 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2498 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/1997 12:00:00 AM | 3x3 | 6000414.87165 | 2119245.42001 | 37.7990659347341 | -122.442672656788 | (37.7990659347341, -122.442672656788) | |||
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 | ||||||||
6127 | 6127 | 130257 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2213 Jones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 5ft | 6008055.23608 | 2120086.8486599997 | 37.801808863839796 | -122.416293973386 | (37.8018088638398, -122.416293973386) | ||||
6660 | 6660 | 41451 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | Permit Number 42044 | 6006045.39578 | 2110879.4024400003 | 37.7764142845255 | -122.422594304391 | (37.7764142845255, -122.422594304391) | |||
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 | |||||||||
9827 | 9827 | 173704 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5997184.0 | 2089426.0 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | |||
9830 | 9830 | 60472 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | 3x3 | Permit Number 20066 | 5997184.0 | 2089426.0 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | |
9956 | 9956 | 173750 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 989 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007621.28893018 | 2103912.36255672 | 37.7573732040434 | -122.41664916584601 | (37.7573732040434, -122.416649165846) | ||||
10047 | 10047 | 121314 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 124 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
10052 | 10052 | 121312 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x4 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
10057 | 10057 | 121315 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 124 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
10061 | 10061 | 121311 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x4 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
10071 | 10071 | 121313 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x4 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
10075 | 10075 | 121310 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 298X Spear St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x4 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
10209 | 10209 | 173905 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1930 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6004432.0 | 2115392.0 | 37.7887136017889 | -122.428497222364 | (37.7887136017889, -122.428497222364) | ||||
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 | ||||||||
10220 | 10220 | 173929 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 95 High St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999870.0 | 2100717.0 | 37.7481605193068 | -122.443226610241 | (37.7481605193068, -122.443226610241) | |||||
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 | |||||||||
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 | |||||||||
13282 | 13282 | 187646 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 880x Clipper Ter | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999931.0 | 2100716.0 | 37.748161251694896 | -122.443015603116 | (37.7481612516949, -122.443015603116) | ||||
13283 | 13283 | 187645 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 880x Clipper Ter | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999931.0 | 2100716.0 | 37.748161251694896 | -122.443015603116 | (37.7481612516949, -122.443015603116) | ||||
13284 | 13284 | 187644 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 880x Clipper Ter | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999931.0 | 2100716.0 | 37.748161251694896 | -122.443015603116 | (37.7481612516949, -122.443015603116) | ||||
13286 | 13286 | 187643 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 890x Clipper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999931.0 | 2100716.0 | 37.748161251694896 | -122.443015603116 | (37.7481612516949, -122.443015603116) | ||||
13287 | 13287 | 187650 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 890x Clipper Ter | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999832.0 | 2100719.0 | 37.7481638439189 | -122.443358156196 | (37.7481638439189, -122.443358156196) | ||||
13288 | 13288 | 187649 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 890x Clipper Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999832.0 | 2100719.0 | 37.7481638439189 | -122.443358156196 | (37.7481638439189, -122.443358156196) | ||||
13292 | 13292 | 187648 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 890x Clipper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999832.0 | 2100719.0 | 37.7481638439189 | -122.443358156196 | (37.7481638439189, -122.443358156196) | ||||
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 | |||||||
13522 | 13522 | 51772 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2095 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
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 | |||||||||
13644 | 13644 | 51780 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2900x 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
13794 | 13794 | 51777 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2095 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
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 | ||||||||
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 | ||||||||
14170 | 14170 | 51783 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2900x 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
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 | |||||||||
14757 | 14757 | 51782 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2095 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
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 | |||||||||
15911 | 15911 | 51784 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2900X 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
16253 | 16253 | 51775 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2095 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
16539 | 16539 | 51776 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2095 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | Permit Number 48033 | 6008899.76382458 | 2106463.81267767 | 37.7644507242066 | -122.41240802024099 | (37.7644507242066, -122.412408020241) | |||
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 |
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");