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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3458 | 3458 | 44636 | Permitted Site 1 | Tree(s) :: 17 | 164 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3543 | 3543 | 44857 | Permitted Site 1 | Tree(s) :: 17 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 3614 | 3614 | 46882 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2002 12:00:00 AM | Permit Number 44940 | |||||||||
| 3636 | 3636 | 64705 | Permitted Site 1 | Tree(s) :: 17 | 252 Walker Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1988 12:00:00 AM | Permit Number 25649 | ||||||||
| 3649 | 3649 | 253514 | Permitted Site 1 | Tree(s) :: 17 | 128 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2007 12:00:00 AM | Permit No. 49290 | 5994510.638119999 | 2105337.44986 | 37.760540036372205 | -122.46209399567199 | (37.7605400363722, -122.462093995672) | |||
| 3695 | 3695 | 57738 | Permitted Site 1 | Tree(s) :: 17 | 1999 So. Bascom Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1976 12:00:00 AM | Permit Number 16656 | ||||||||
| 3751 | 3751 | 45854 | Permitted Site 1 | Tree(s) :: 17 | 71 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 3765 | 3765 | 45857 | Permitted Site 1 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 3838 | 3838 | 48141 | Permitted Site 1 | Tree(s) :: 17 | 251 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3864 | 3864 | 44703 | Permitted Site 1 | Tree(s) :: 17 | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3875 | 3875 | 48176 | Permitted Site 1 | Tree(s) :: 17 | 57 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3909 | 3909 | 48174 | Permitted Site 1 | Tree(s) :: 17 | 67 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 4002 | 4002 | 253607 | Undocumented 2 | Tree(s) :: 17 | 499x Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010464.0 | 2112150.0 | 37.7801513385768 | -122.407398630227 | (37.7801513385768, -122.407398630227) | ||||
| 4038 | 4038 | 45886 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4053 | 4053 | 45907 | Permitted Site 1 | Tree(s) :: 17 | 62 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4084 | 4084 | 45961 | Permitted Site 1 | Tree(s) :: 17 | 162 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4085 | 4085 | 101532 | Undocumented 2 | Tree(s) :: 17 | 11323 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
| 4089 | 4089 | 253606 | Undocumented 2 | Tree(s) :: 17 | 499x Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010464.0 | 2112150.0 | 37.7801513385768 | -122.407398630227 | (37.7801513385768, -122.407398630227) | ||||
| 4133 | 4133 | 48248 | Permitted Site 1 | Tree(s) :: 17 | 112 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 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 | |||||||||
| 4719 | 4719 | 253672 | DPW Maintained 3 | Tree(s) :: 17 | 390 06th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 4740 | 4740 | 124733 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 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 | |||||||||
| 4863 | 4863 | 253702 | Undocumented 2 | Tree(s) :: 17 | 293 Capp St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007203.0 | 2105623.0 | 37.76204668432629 | -122.41821705685899 | (37.7620466843263, -122.418217056859) | ||||
| 4865 | 4865 | 253699 | Undocumented 2 | Tree(s) :: 17 | 3076 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000057.0 | 2105400.0 | 37.761029556529294 | -122.44291621566002 | (37.7610295565293, -122.44291621566) | ||||
| 4870 | 4870 | 253696 | Undocumented 2 | Tree(s) :: 17 | 235 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6003605.0 | 2109124.0 | 37.77145640087421 | -122.430911009882 | (37.7714564008742, -122.430911009882) | ||||
| 4871 | 4871 | 253700 | Undocumented 2 | Tree(s) :: 17 | 293 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007203.0 | 2105623.0 | 37.76204668432629 | -122.41821705685899 | (37.7620466843263, -122.418217056859) | ||||
| 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 | |||||||||
| 5210 | 5210 | 83637 | Permitted Site 1 | Tree(s) :: 17 | 840 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 11/19/2005 12:00:00 AM | 3x3 | 6006834.966315799 | 2113631.30048912 | 37.784014842491395 | -122.420058290383 | (37.7840148424914, -122.420058290383) | ||
| 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 |
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");