Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51 | 51 | 60867 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1983 12:00:00 AM | Permit Number 20649 | |||||||||
| 57 | 57 | 44642 | Permitted Site 1 | Tree(s) :: 17 | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 59 | 59 | 44994 | Permitted Site 1 | Tree(s) :: 17 | 106 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 169 | 169 | 251221 | Permitted Site 1 | Tree(s) :: 17 | 2401X Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778039 | ||||||
| 172 | 172 | 48332 | Permitted Site 1 | Tree(s) :: 17 | 142 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 204 | 204 | 61453 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1984 12:00:00 AM | Permit Number 21392 | |||||||||
| 235 | 235 | 45975 | Permitted Site 1 | Tree(s) :: 17 | 132 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 279 | 279 | 48153 | Permitted Site 1 | Tree(s) :: 17 | 263 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 308 | 308 | 46059 | Permitted Site 1 | Tree(s) :: 17 | 101 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 316 | 316 | 67789 | Permitted Site 1 | Tree(s) :: 17 | 7 4384 St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1992 12:00:00 AM | Permit Number 31429 | ||||||||
| 320 | 320 | 48259 | Permitted Site 1 | Tree(s) :: 17 | 123 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 321 | 321 | 65143 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | Permit Number 27118 | |||||||||
| 444 | 444 | 44838 | Permitted Site 1 | Tree(s) :: 17 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 515 | 515 | 48129 | Permitted Site 1 | Tree(s) :: 17 | 297 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 536 | 536 | 45913 | Permitted Site 1 | Tree(s) :: 17 | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 580 | 580 | 48268 | Permitted Site 1 | Tree(s) :: 17 | 132 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 617 | 617 | 57850 | Permitted Site 1 | Tree(s) :: 17 | 1700 S. Amaylett Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1977 12:00:00 AM | Permit Number 16791 | ||||||||
| 632 | 632 | 44905 | Permitted Site 1 | Tree(s) :: 17 | 139 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 633 | 633 | 48204 | Permitted Site 1 | Tree(s) :: 17 | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 689 | 689 | 48269 | Permitted Site 1 | Tree(s) :: 17 | 120 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 726 | 726 | 44958 | Permitted Site 1 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 729 | 729 | 48266 | Permitted Site 1 | Tree(s) :: 17 | 130 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 793 | 793 | 65876 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/1990 12:00:00 AM | Permit Number 28874 | |||||||||
| 809 | 809 | 46145 | Permitted Site 1 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 814 | 814 | 44650 | Permitted Site 1 | Tree(s) :: 17 | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 921 | 921 | 30278 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 128 | ||||||||||
| 937 | 937 | 45898 | Permitted Site 1 | Tree(s) :: 17 | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 952 | 952 | 48321 | Permitted Site 1 | Tree(s) :: 17 | 187 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 953 | 953 | 46022 | Permitted Site 1 | Tree(s) :: 17 | 215 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1010 | 1010 | 45949 | Permitted Site 1 | Tree(s) :: 17 | 146 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1015 | 1015 | 48313 | Permitted Site 1 | Tree(s) :: 17 | 179 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1038 | 1038 | 57888 | Permitted Site 1 | Tree(s) :: 17 | 2382 Fost St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1977 12:00:00 AM | Permit Number 16841 | ||||||||
| 1067 | 1067 | 48140 | Permitted Site 1 | Tree(s) :: 17 | 250 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1086 | 1086 | 48227 | Permitted Site 1 | Tree(s) :: 17 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1113 | 1113 | 45845 | Permitted Site 1 | Tree(s) :: 17 | 81 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1225 | 1225 | 44628 | Permitted Site 1 | Tree(s) :: 17 | 156 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 1418 | 1418 | 48339 | Permitted Site 1 | Tree(s) :: 17 | 156 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1493 | 1493 | 103663 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 1499 | 1499 | 44884 | Permitted Site 1 | Tree(s) :: 17 | 157 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 1511 | 1511 | 45972 | Permitted Site 1 | Tree(s) :: 17 | 119 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1526 | 1526 | 44588 | Permitted Site 1 | Tree(s) :: 17 | 116 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 1532 | 1532 | 44561 | Permitted Site 1 | Tree(s) :: 17 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 1765 | 1765 | 45968 | Permitted Site 1 | Tree(s) :: 17 | 155 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1804 | 1804 | 44554 | Permitted Site 1 | Tree(s) :: 17 | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 1885 | 1885 | 30481 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1956 12:00:00 AM | Permit Number 147 | |||||||||
| 1959 | 1959 | 48104 | Permitted Site 1 | Tree(s) :: 17 | 213 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1973 | 1973 | 66343 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/1990 12:00:00 AM | Permit Number 29464 | |||||||||
| 2019 | 2019 | 48201 | Permitted Site 1 | Tree(s) :: 17 | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 2023 | 2023 | 35053 | Permitted Site 1 | Tree(s) :: 17 | 700 Peninsula Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1998 12:00:00 AM | Permit Number 38613 | ||||||||
| 2086 | 2086 | 45988 | Permitted Site 1 | Tree(s) :: 17 | 223 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 2115 | 2115 | 44893 | Permitted Site 1 | Tree(s) :: 17 | 127 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2154 | 2154 | 45014 | Permitted Site 1 | Tree(s) :: 17 | 86 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2193 | 2193 | 46043 | Permitted Site 1 | Tree(s) :: 17 | 174 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 2195 | 2195 | 44993 | Permitted Site 1 | Tree(s) :: 17 | 105 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2304 | 2304 | 44646 | Permitted Site 1 | Tree(s) :: 17 | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 2366 | 2366 | 44966 | Permitted Site 1 | Tree(s) :: 17 | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2404 | 2404 | 67784 | Permitted Site 1 | Tree(s) :: 17 | 1030 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1992 12:00:00 AM | Permit Number 31421 | ||||||||
| 2434 | 2434 | 48283 | Permitted Site 1 | Tree(s) :: 17 | 93 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 2571 | 2571 | 253124 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 399x Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780530 | ||||||
| 2618 | 2618 | 55203 | Permitted Site 1 | Tree(s) :: 17 | 40 Dalmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1972 12:00:00 AM | Permit Number 11116 | ||||||||
| 2627 | 2627 | 44896 | Permitted Site 1 | Tree(s) :: 17 | 130 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2630 | 2630 | 44978 | Permitted Site 1 | Tree(s) :: 17 | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2673 | 2673 | 46063 | Permitted Site 1 | Tree(s) :: 17 | 105 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 2726 | 2726 | 46033 | Permitted Site 1 | Tree(s) :: 17 | 213 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 2860 | 2860 | 44877 | Permitted Site 1 | Tree(s) :: 17 | 150 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2904 | 2904 | 44678 | Permitted Site 1 | Tree(s) :: 17 | 98 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 2945 | 2945 | 44998 | Permitted Site 1 | Tree(s) :: 17 | 110 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2960 | 2960 | 44920 | Permitted Site 1 | Tree(s) :: 17 | 182 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 3027 | 3027 | 45855 | Permitted Site 1 | Tree(s) :: 17 | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 3090 | 3090 | 44576 | Permitted Site 1 | Tree(s) :: 17 | 140 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3118 | 3118 | 48324 | Permitted Site 1 | Tree(s) :: 17 | 176 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3134 | 3134 | 44852 | Permitted Site 1 | Tree(s) :: 17 | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 3178 | 3178 | 48242 | Permitted Site 1 | Tree(s) :: 17 | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3193 | 3193 | 48299 | Permitted Site 1 | Tree(s) :: 17 | 133 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3227 | 3227 | 48059 | Permitted Site 1 | Tree(s) :: 17 | 230 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3266 | 3266 | 44618 | Permitted Site 1 | Tree(s) :: 17 | 182 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3285 | 3285 | 44952 | Permitted Site 1 | Tree(s) :: 17 | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 3297 | 3297 | 44585 | Permitted Site 1 | Tree(s) :: 17 | 139 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3322 | 3322 | 44559 | Permitted Site 1 | Tree(s) :: 17 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3393 | 3393 | 33932 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1997 12:00:00 AM | Permit Number 37893 | |||||||||
| 3408 | 3408 | 44959 | Permitted Site 1 | Tree(s) :: 17 | 72 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 3444 | 3444 | 48277 | Permitted Site 1 | Tree(s) :: 17 | 87 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3448 | 3448 | 48107 | Permitted Site 1 | Tree(s) :: 17 | 202 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 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 | ||||||||
| 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 | |||||||||
| 3965 | 3965 | 253596 | Permitted Site 1 | Tree(s) :: 17 | 198X Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780230 | ||||||
| 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 | |||||||||
| 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 |
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");