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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4256 | 4256 | 44534 | Permitted Site 1 | Tree(s) :: 17 | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 4347 | 4347 | 45877 | Permitted Site 1 | Tree(s) :: 17 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4378 | 4378 | 45905 | Permitted Site 1 | Tree(s) :: 17 | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4443 | 4443 | 67752 | Permitted Site 1 | Tree(s) :: 17 | 2281 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1992 12:00:00 AM | Permit Number 31376 | ||||||||
| 4492 | 4492 | 44688 | Permitted Site 1 | Tree(s) :: 17 | 108 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 4519 | 4519 | 46000 | Permitted Site 1 | Tree(s) :: 17 | 118 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4531 | 4531 | 48083 | Permitted Site 1 | Tree(s) :: 17 | 193 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 4552 | 4552 | 97357 | Permitted Site 1 | Tree(s) :: 17 | 7 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 4576 | 4576 | 60252 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/1982 12:00:00 AM | Permit Number 19804 | |||||||||
| 4714 | 4714 | 44605 | Permitted Site 1 | Tree(s) :: 17 | 148 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 4741 | 4741 | 48244 | Permitted Site 1 | Tree(s) :: 17 | 122 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 4774 | 4774 | 44595 | Permitted Site 1 | Tree(s) :: 17 | 150 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 4823 | 4823 | 45930 | Permitted Site 1 | Tree(s) :: 17 | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4831 | 4831 | 44933 | Permitted Site 1 | Tree(s) :: 17 | 166 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 4913 | 4913 | 97358 | Permitted Site 1 | Tree(s) :: 17 | 8 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 4991 | 4991 | 35276 | Permitted Site 1 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 5018 | 5018 | 44607 | Permitted Site 1 | Tree(s) :: 17 | 171 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5121 | 5121 | 45851 | Permitted Site 1 | Tree(s) :: 17 | 74 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 5128 | 5128 | 44995 | Permitted Site 1 | Tree(s) :: 17 | 107 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5147 | 5147 | 48270 | Permitted Site 1 | Tree(s) :: 17 | 94 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5156 | 5156 | 44926 | Permitted Site 1 | Tree(s) :: 17 | 199 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5208 | 5208 | 48263 | Permitted Site 1 | Tree(s) :: 17 | 127 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5261 | 5261 | 44583 | Permitted Site 1 | Tree(s) :: 17 | 147 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5262 | 5262 | 30644 | Permitted Site 1 | Tree(s) :: 17 | 1597 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | Permit Number 34586 | ||||||||
| 5268 | 5268 | 44602 | Permitted Site 1 | Tree(s) :: 17 | 130 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5270 | 5270 | 30482 | Permitted Site 1 | Tree(s) :: 17 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1956 12:00:00 AM | Permit Number 147 | |||||||||
| 5272 | 5272 | 65265 | Permitted Site 1 | Tree(s) :: 17 | 2884 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1989 12:00:00 AM | Permit Number 28066 | ||||||||
| 5277 | 5277 | 46045 | Permitted Site 1 | Tree(s) :: 17 | 172 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 5286 | 5286 | 48241 | Permitted Site 1 | Tree(s) :: 17 | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5321 | 5321 | 36650 | Permitted Site 1 | Tree(s) :: 17 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 5328 | 5328 | 63329 | Permitted Site 1 | Tree(s) :: 17 | 225 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1987 12:00:00 AM | Permit Number 23902 | ||||||||
| 5355 | 5355 | 48328 | Permitted Site 1 | Tree(s) :: 17 | 138 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5360 | 5360 | 45002 | Permitted Site 1 | Tree(s) :: 17 | 114 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5384 | 5384 | 58889 | Permitted Site 1 | Tree(s) :: 17 | 4377 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/1980 12:00:00 AM | Permit Number 18156 | ||||||||
| 5385 | 5385 | 44657 | Permitted Site 1 | Tree(s) :: 17 | 67 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5386 | 5386 | 44855 | Permitted Site 1 | Tree(s) :: 17 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5392 | 5392 | 44924 | Permitted Site 1 | Tree(s) :: 17 | 197 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5393 | 5393 | 44945 | Permitted Site 1 | Tree(s) :: 17 | 178 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5401 | 5401 | 36558 | Permitted Site 1 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1998 12:00:00 AM | Permit Number 39428 | |||||||||
| 5423 | 5423 | 55205 | Permitted Site 1 | Tree(s) :: 17 | 44 Dalmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1972 12:00:00 AM | Permit Number 11118 | ||||||||
| 5442 | 5442 | 59026 | Permitted Site 1 | Tree(s) :: 17 | 3145 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/1980 12:00:00 AM | Permit Number 18317 | ||||||||
| 5452 | 5452 | 44709 | Permitted Site 1 | Tree(s) :: 17 | 93 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5455 | 5455 | 48160 | Permitted Site 1 | Tree(s) :: 17 | 270 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5458 | 5458 | 44616 | Permitted Site 1 | Tree(s) :: 17 | 180 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5482 | 5482 | 44652 | Permitted Site 1 | Tree(s) :: 17 | 72 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5514 | 5514 | 66482 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1991 12:00:00 AM | Permit Number 29639 | |||||||||
| 5540 | 5540 | 48296 | Permitted Site 1 | Tree(s) :: 17 | 135 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5552 | 5552 | 44936 | Permitted Site 1 | Tree(s) :: 17 | 169 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5560 | 5560 | 65831 | Permitted Site 1 | Tree(s) :: 17 | 2200 North Point | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1990 12:00:00 AM | Permit Number 28821 | ||||||||
| 5567 | 5567 | 44850 | Permitted Site 1 | Tree(s) :: 17 | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5568 | 5568 | 48127 | Permitted Site 1 | Tree(s) :: 17 | 295 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5569 | 5569 | 65774 | Permitted Site 1 | Tree(s) :: 17 | 3904 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1990 12:00:00 AM | Permit Number 28739 | ||||||||
| 5571 | 5571 | 44915 | Permitted Site 1 | Tree(s) :: 17 | 188 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5573 | 5573 | 44667 | Permitted Site 1 | Tree(s) :: 17 | 78 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5574 | 5574 | 45943 | Permitted Site 1 | Tree(s) :: 17 | 183 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 5581 | 5581 | 44876 | Permitted Site 1 | Tree(s) :: 17 | 149 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5590 | 5590 | 45005 | Permitted Site 1 | Tree(s) :: 17 | 117 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5598 | 5598 | 103666 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 5602 | 5602 | 48314 | Permitted Site 1 | Tree(s) :: 17 | 180 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5616 | 5616 | 44680 | Permitted Site 1 | Tree(s) :: 17 | 100 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5642 | 5642 | 48249 | Permitted Site 1 | Tree(s) :: 17 | 113 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5692 | 5692 | 64906 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/1989 12:00:00 AM | Permit Number 25933 | |||||||||
| 5706 | 5706 | 48133 | Permitted Site 1 | Tree(s) :: 17 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5714 | 5714 | 46005 | Permitted Site 1 | Tree(s) :: 17 | 191 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 5721 | 5721 | 66161 | Permitted Site 1 | Tree(s) :: 17 | 199 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/1990 12:00:00 AM | Permit Number 29233 | ||||||||
| 5752 | 5752 | 44578 | Permitted Site 1 | Tree(s) :: 17 | 142 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5753 | 5753 | 44603 | Permitted Site 1 | Tree(s) :: 17 | 121 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5754 | 5754 | 48349 | Permitted Site 1 | Tree(s) :: 17 | 152 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5758 | 5758 | 48084 | Permitted Site 1 | Tree(s) :: 17 | 194 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5768 | 5768 | 44674 | Permitted Site 1 | Tree(s) :: 17 | 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5773 | 5773 | 45953 | Permitted Site 1 | Tree(s) :: 17 | 150 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 5774 | 5774 | 59308 | Permitted Site 1 | Tree(s) :: 17 | 3274 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1980 12:00:00 AM | Permit Number 18648 | ||||||||
| 5780 | 5780 | 59741 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1981 12:00:00 AM | Permit Number 19174 | |||||||||
| 5783 | 5783 | 44584 | Permitted Site 1 | Tree(s) :: 17 | 114 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5789 | 5789 | 48478 | Permitted Site 1 | Tree(s) :: 17 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 5797 | 5797 | 69288 | Permitted Site 1 | Tree(s) :: 17 | 555 Pullman Road | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1994 12:00:00 AM | Permit Number 33360 | ||||||||
| 5810 | 5810 | 48078 | Permitted Site 1 | Tree(s) :: 17 | 244 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5816 | 5816 | 48139 | Permitted Site 1 | Tree(s) :: 17 | 249 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5825 | 5825 | 45844 | Permitted Site 1 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 5838 | 5838 | 45000 | Permitted Site 1 | Tree(s) :: 17 | 112 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5841 | 5841 | 45969 | Permitted Site 1 | Tree(s) :: 17 | 154 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 5859 | 5859 | 48262 | Permitted Site 1 | Tree(s) :: 17 | 126 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5907 | 5907 | 48065 | Permitted Site 1 | Tree(s) :: 17 | 219 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5908 | 5908 | 55197 | Permitted Site 1 | Tree(s) :: 17 | 22 Dalmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1972 12:00:00 AM | Permit Number 11110 | ||||||||
| 5928 | 5928 | 58844 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1979 12:00:00 AM | Permit Number 18101 | |||||||||
| 5938 | 5938 | 44698 | Permitted Site 1 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 5941 | 5941 | 46066 | Permitted Site 1 | Tree(s) :: 17 | 135 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 5978 | 5978 | 44929 | Permitted Site 1 | Tree(s) :: 17 | 191 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5985 | 5985 | 53924 | Permitted Site 1 | Tree(s) :: 17 | 1430 Sunnyvale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1972 12:00:00 AM | Permit Number 9637 | ||||||||
| 5989 | 5989 | 48342 | Permitted Site 1 | Tree(s) :: 17 | 159 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 5998 | 5998 | 49875 | Permitted Site 1 | Tree(s) :: 17 | 0@ 14th ST Trainor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2003 12:00:00 AM | Permit Number 46642 | ||||||||
| 5999 | 5999 | 48335 | Permitted Site 1 | Tree(s) :: 17 | 145 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 6010 | 6010 | 58847 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/1979 12:00:00 AM | Permit Number 18105 | |||||||||
| 6015 | 6015 | 51068 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47530 | |||||||||
| 6016 | 6016 | 45847 | Permitted Site 1 | Tree(s) :: 17 | 86 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6024 | 6024 | 61432 | Permitted Site 1 | Tree(s) :: 17 | 234 La Espiral St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1984 12:00:00 AM | Permit Number 21363 | ||||||||
| 6037 | 6037 | 44640 | Permitted Site 1 | Tree(s) :: 17 | 69 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 6045 | 6045 | 48206 | Permitted Site 1 | Tree(s) :: 17 | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 6049 | 6049 | 67144 | Permitted Site 1 | Tree(s) :: 17 | 98 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1992 12:00:00 AM | Permit Number 30575 | ||||||||
| 6050 | 6050 | 62159 | Permitted Site 1 | Tree(s) :: 17 | 2630 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/1985 12:00:00 AM | Permit Number 22274 |
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");