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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 6176 | 6176 | 45944 | Permitted Site 1 | Tree(s) :: 17 | 133 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6198 | 6198 | 45895 | Permitted Site 1 | Tree(s) :: 17 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6243 | 6243 | 45919 | Permitted Site 1 | Tree(s) :: 17 | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6252 | 6252 | 46001 | Permitted Site 1 | Tree(s) :: 17 | 169 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6271 | 6271 | 46008 | Permitted Site 1 | Tree(s) :: 17 | 194 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6328 | 6328 | 45965 | Permitted Site 1 | Tree(s) :: 17 | 158 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6339 | 6339 | 45970 | Permitted Site 1 | Tree(s) :: 17 | 224 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6374 | 6374 | 46054 | Permitted Site 1 | Tree(s) :: 17 | 184 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6561 | 6561 | 46020 | Permitted Site 1 | Tree(s) :: 17 | 217 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6571 | 6571 | 45997 | Permitted Site 1 | Tree(s) :: 17 | 115 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6624 | 6624 | 46053 | Permitted Site 1 | Tree(s) :: 17 | 185 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6763 | 6763 | 45963 | Permitted Site 1 | Tree(s) :: 17 | 160 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6791 | 6791 | 45978 | Permitted Site 1 | Tree(s) :: 17 | 129 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6810 | 6810 | 45888 | Permitted Site 1 | Tree(s) :: 17 | 181 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6814 | 6814 | 45915 | Permitted Site 1 | Tree(s) :: 17 | 61 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6837 | 6837 | 45957 | Permitted Site 1 | Tree(s) :: 17 | 166 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6901 | 6901 | 46002 | Permitted Site 1 | Tree(s) :: 17 | 138 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6983 | 6983 | 46026 | Permitted Site 1 | Tree(s) :: 17 | 204 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7034 | 7034 | 46048 | Permitted Site 1 | Tree(s) :: 17 | 219 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7119 | 7119 | 45981 | Permitted Site 1 | Tree(s) :: 17 | 126 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7122 | 7122 | 45999 | Permitted Site 1 | Tree(s) :: 17 | 117 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7222 | 7222 | 45890 | Permitted Site 1 | Tree(s) :: 17 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7262 | 7262 | 45874 | Permitted Site 1 | Tree(s) :: 17 | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7308 | 7308 | 45900 | Permitted Site 1 | Tree(s) :: 17 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7356 | 7356 | 45954 | Permitted Site 1 | Tree(s) :: 17 | 151 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7380 | 7380 | 46034 | Permitted Site 1 | Tree(s) :: 17 | 175 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7398 | 7398 | 46003 | Permitted Site 1 | Tree(s) :: 17 | 205 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7437 | 7437 | 45977 | Permitted Site 1 | Tree(s) :: 17 | 130 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7457 | 7457 | 45918 | Permitted Site 1 | Tree(s) :: 17 | 64 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7535 | 7535 | 45866 | Permitted Site 1 | Tree(s) :: 17 | 92 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7537 | 7537 | 46027 | Permitted Site 1 | Tree(s) :: 17 | 210 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7703 | 7703 | 46024 | Permitted Site 1 | Tree(s) :: 17 | 203 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7710 | 7710 | 46011 | Permitted Site 1 | Tree(s) :: 17 | 197 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7882 | 7882 | 45841 | Permitted Site 1 | Tree(s) :: 17 | 77 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7910 | 7910 | 45922 | Permitted Site 1 | Tree(s) :: 17 | 68 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 7943 | 7943 | 46025 | Permitted Site 1 | Tree(s) :: 17 | 212 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8027 | 8027 | 46014 | Permitted Site 1 | Tree(s) :: 17 | 200 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8046 | 8046 | 45908 | Permitted Site 1 | Tree(s) :: 17 | 54 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8097 | 8097 | 45871 | Permitted Site 1 | Tree(s) :: 17 | 87 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8163 | 8163 | 46009 | Permitted Site 1 | Tree(s) :: 17 | 195 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8173 | 8173 | 45904 | Permitted Site 1 | Tree(s) :: 17 | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8185 | 8185 | 45860 | Permitted Site 1 | Tree(s) :: 17 | 98 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8193 | 8193 | 45951 | Permitted Site 1 | Tree(s) :: 17 | 148 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8209 | 8209 | 45883 | Permitted Site 1 | Tree(s) :: 17 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8250 | 8250 | 45924 | Permitted Site 1 | Tree(s) :: 17 | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8362 | 8362 | 45862 | Permitted Site 1 | Tree(s) :: 17 | 96 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8399 | 8399 | 45982 | Permitted Site 1 | Tree(s) :: 17 | 125 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8405 | 8405 | 46042 | Permitted Site 1 | Tree(s) :: 17 | 107 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8412 | 8412 | 46017 | Permitted Site 1 | Tree(s) :: 17 | 167 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8414 | 8414 | 45852 | Permitted Site 1 | Tree(s) :: 17 | 73 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8510 | 8510 | 45959 | Permitted Site 1 | Tree(s) :: 17 | 164 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8558 | 8558 | 45985 | Permitted Site 1 | Tree(s) :: 17 | 122 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8610 | 8610 | 45864 | Permitted Site 1 | Tree(s) :: 17 | 94 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8631 | 8631 | 46028 | Permitted Site 1 | Tree(s) :: 17 | 209 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8694 | 8694 | 46010 | Permitted Site 1 | Tree(s) :: 17 | 196 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8772 | 8772 | 45848 | Permitted Site 1 | Tree(s) :: 17 | 78 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8804 | 8804 | 45865 | Permitted Site 1 | Tree(s) :: 17 | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8837 | 8837 | 46023 | Permitted Site 1 | Tree(s) :: 17 | 214 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8850 | 8850 | 45935 | Permitted Site 1 | Tree(s) :: 17 | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8901 | 8901 | 45928 | Permitted Site 1 | Tree(s) :: 17 | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8988 | 8988 | 45941 | Permitted Site 1 | Tree(s) :: 17 | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 8989 | 8989 | 45927 | Permitted Site 1 | Tree(s) :: 17 | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 9014 | 9014 | 45955 | Permitted Site 1 | Tree(s) :: 17 | 225 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 9092 | 9092 | 45923 | Permitted Site 1 | Tree(s) :: 17 | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 9176 | 9176 | 46037 | Permitted Site 1 | Tree(s) :: 17 | 111 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 9204 | 9204 | 45950 | Permitted Site 1 | Tree(s) :: 17 | 147 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 9371 | 9371 | 45990 | Permitted Site 1 | Tree(s) :: 17 | 141 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 9494 | 9494 | 46051 | Permitted Site 1 | Tree(s) :: 17 | 168 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 |
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");