Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
110779 | 110779 | 98279 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 900 Brotherhood Way | 501 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/07/2012 12:00:00 AM | Permit Number 768594 | 5988860.9 | 2088745.5 | 37.7146559434524 | -122.48041912379101 | (37.7146559434524, -122.480419123791) | |||
92410 | 92410 | 98278 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 900 Brotherhood Way | 500 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/07/2012 12:00:00 AM | Permit Number 768594 | 5988860.9 | 2088745.5 | 37.7146559434524 | -122.48041912379101 | (37.7146559434524, -122.480419123791) | |||
16780 | 16780 | 48132 | Permitted Site 1 | Tree(s) :: 17 | 300 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
15076 | 15076 | 48131 | Permitted Site 1 | Tree(s) :: 17 | 299 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
9460 | 9460 | 48130 | Permitted Site 1 | Tree(s) :: 17 | 298 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
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 | |||||||||
11434 | 11434 | 48128 | Permitted Site 1 | Tree(s) :: 17 | 296 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
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 | |||||||||
8489 | 8489 | 48126 | Permitted Site 1 | Tree(s) :: 17 | 294 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
11603 | 11603 | 48125 | Permitted Site 1 | Tree(s) :: 17 | 293 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
12962 | 12962 | 48124 | Permitted Site 1 | Tree(s) :: 17 | 292 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
6230 | 6230 | 48123 | Permitted Site 1 | Tree(s) :: 17 | 291 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
8711 | 8711 | 48108 | Permitted Site 1 | Tree(s) :: 17 | 290 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
10419 | 10419 | 48121 | Permitted Site 1 | Tree(s) :: 17 | 289 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
14438 | 14438 | 48135 | Permitted Site 1 | Tree(s) :: 17 | 288 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
16078 | 16078 | 48119 | Permitted Site 1 | Tree(s) :: 17 | 287 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
15865 | 15865 | 48118 | Permitted Site 1 | Tree(s) :: 17 | 286 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
14378 | 14378 | 48117 | Permitted Site 1 | Tree(s) :: 17 | 285 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
13037 | 13037 | 48100 | Permitted Site 1 | Tree(s) :: 17 | 284 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
8433 | 8433 | 48116 | Permitted Site 1 | Tree(s) :: 17 | 283 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
7094 | 7094 | 48109 | Permitted Site 1 | Tree(s) :: 17 | 282 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
15252 | 15252 | 48115 | Permitted Site 1 | Tree(s) :: 17 | 281 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
7494 | 7494 | 48114 | Permitted Site 1 | Tree(s) :: 17 | 280 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
7841 | 7841 | 48113 | Permitted Site 1 | Tree(s) :: 17 | 279 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
6277 | 6277 | 48112 | Permitted Site 1 | Tree(s) :: 17 | 278 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
16761 | 16761 | 48111 | Permitted Site 1 | Tree(s) :: 17 | 277 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
8557 | 8557 | 48110 | Permitted Site 1 | Tree(s) :: 17 | 276 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
10908 | 10908 | 48148 | Permitted Site 1 | Tree(s) :: 17 | 275 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
13796 | 13796 | 48120 | Permitted Site 1 | Tree(s) :: 17 | 274 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
15162 | 15162 | 48122 | Permitted Site 1 | Tree(s) :: 17 | 273 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
6121 | 6121 | 48162 | Permitted Site 1 | Tree(s) :: 17 | 272 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
15392 | 15392 | 48161 | Permitted Site 1 | Tree(s) :: 17 | 271 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
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 | |||||||||
8121 | 8121 | 48159 | Permitted Site 1 | Tree(s) :: 17 | 269 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
13558 | 13558 | 48158 | Permitted Site 1 | Tree(s) :: 17 | 268 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
139364 | 139364 | 96618 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ 19th St 19th St | 268 | Sidewalk: Property side : 26 | Tree 1 | Rec/Park 3 | Permit Number 771218 | 6006277.0 | 2104934.0 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | ||||
10625 | 10625 | 48157 | Permitted Site 1 | Tree(s) :: 17 | 267 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
13828 | 13828 | 48156 | Permitted Site 1 | Tree(s) :: 17 | 266 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
8603 | 8603 | 48155 | Permitted Site 1 | Tree(s) :: 17 | 265 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
16001 | 16001 | 48154 | Permitted Site 1 | Tree(s) :: 17 | 264 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
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 | |||||||||
6515 | 6515 | 48152 | Permitted Site 1 | Tree(s) :: 17 | 262 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
9813 | 9813 | 48151 | Permitted Site 1 | Tree(s) :: 17 | 261 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
13653 | 13653 | 48136 | Permitted Site 1 | Tree(s) :: 17 | 260 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
14979 | 14979 | 48149 | Permitted Site 1 | Tree(s) :: 17 | 259 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
13592 | 13592 | 48163 | Permitted Site 1 | Tree(s) :: 17 | 258 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
12531 | 12531 | 48147 | Permitted Site 1 | Tree(s) :: 17 | 257 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
12611 | 12611 | 48146 | Permitted Site 1 | Tree(s) :: 17 | 256 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
11037 | 11037 | 48145 | Permitted Site 1 | Tree(s) :: 17 | 255 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
12351 | 12351 | 48144 | Permitted Site 1 | Tree(s) :: 17 | 254 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
17029 | 17029 | 48143 | Permitted Site 1 | Tree(s) :: 17 | 253 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
11501 | 11501 | 48142 | Permitted Site 1 | Tree(s) :: 17 | 252 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
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 | |||||||||
111357 | 111357 | 96617 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ Valencia 19th St | 251 | Sidewalk: Property side : 26 | Tree 1 | Rec/Park 3 | Permit Number 771218 | 6006277.0 | 2104934.0 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | ||||
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 | |||||||||
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 | |||||||||
13453 | 13453 | 48138 | Permitted Site 1 | Tree(s) :: 17 | 248 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
9787 | 9787 | 48137 | Permitted Site 1 | Tree(s) :: 17 | 247 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
15676 | 15676 | 48150 | Permitted Site 1 | Tree(s) :: 17 | 246 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
9047 | 9047 | 48081 | Permitted Site 1 | Tree(s) :: 17 | 245 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
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 | |||||||||
12162 | 12162 | 48077 | Permitted Site 1 | Tree(s) :: 17 | 243 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
16777 | 16777 | 48076 | Permitted Site 1 | Tree(s) :: 17 | 242 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
10221 | 10221 | 48075 | Permitted Site 1 | Tree(s) :: 17 | 241 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
6337 | 6337 | 48074 | Permitted Site 1 | Tree(s) :: 17 | 240 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
12398 | 12398 | 48073 | Permitted Site 1 | Tree(s) :: 17 | 239 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
15655 | 15655 | 48072 | Permitted Site 1 | Tree(s) :: 17 | 238 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
13691 | 13691 | 48071 | Permitted Site 1 | Tree(s) :: 17 | 237 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
13798 | 13798 | 48070 | Permitted Site 1 | Tree(s) :: 17 | 236 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
13760 | 13760 | 48069 | Permitted Site 1 | Tree(s) :: 17 | 235 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
6635 | 6635 | 48068 | Permitted Site 1 | Tree(s) :: 17 | 234 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
13112 | 13112 | 48061 | Permitted Site 1 | Tree(s) :: 17 | 233 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
11379 | 11379 | 48066 | Permitted Site 1 | Tree(s) :: 17 | 232 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
15953 | 15953 | 48079 | Permitted Site 1 | Tree(s) :: 17 | 231 | 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 | |||||||||
16750 | 16750 | 48053 | Permitted Site 1 | Tree(s) :: 17 | 229 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
13594 | 13594 | 48054 | Permitted Site 1 | Tree(s) :: 17 | 228 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
10046 | 10046 | 48055 | Permitted Site 1 | Tree(s) :: 17 | 227 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
13730 | 13730 | 45986 | Permitted Site 1 | Tree(s) :: 17 | 226 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
14246 | 14246 | 48056 | Permitted Site 1 | Tree(s) :: 17 | 226 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
8986 | 8986 | 48057 | Permitted Site 1 | Tree(s) :: 17 | 225 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
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 | |||||||||
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 | |||||||||
9697 | 9697 | 48058 | Permitted Site 1 | Tree(s) :: 17 | 224 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
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 | |||||||||
15915 | 15915 | 48064 | Permitted Site 1 | Tree(s) :: 17 | 223 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
9691 | 9691 | 45989 | Permitted Site 1 | Tree(s) :: 17 | 222 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
15754 | 15754 | 48060 | Permitted Site 1 | Tree(s) :: 17 | 222 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
15490 | 15490 | 48062 | Permitted Site 1 | Tree(s) :: 17 | 221 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
16336 | 16336 | 46065 | Permitted Site 1 | Tree(s) :: 17 | 221 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
10822 | 10822 | 45962 | Permitted Site 1 | Tree(s) :: 17 | 220 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
14281 | 14281 | 48063 | Permitted Site 1 | Tree(s) :: 17 | 220 | 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 | |||||||||
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 | |||||||||
7240 | 7240 | 48094 | Permitted Site 1 | Tree(s) :: 17 | 218 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
14436 | 14436 | 46019 | Permitted Site 1 | Tree(s) :: 17 | 218 | 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 | |||||||||
8176 | 8176 | 48106 | Permitted Site 1 | Tree(s) :: 17 | 217 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
16300 | 16300 | 48092 | Permitted Site 1 | Tree(s) :: 17 | 216 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
16710 | 16710 | 46021 | Permitted Site 1 | Tree(s) :: 17 | 216 | 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");