Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9458 | 9458 | 34058 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37960 | |||||||||
| 19620 | 19620 | 34336 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 82566 | 82566 | 34320 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 82875 | 82875 | 34319 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 84473 | 84473 | 34314 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 85813 | 85813 | 34327 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 87912 | 87912 | 34338 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 89554 | 89554 | 34312 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 95285 | 95285 | 34307 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 96982 | 96982 | 34318 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 97685 | 97685 | 34326 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 99217 | 99217 | 34321 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 100479 | 100479 | 34313 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 101333 | 101333 | 34335 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 103871 | 103871 | 34311 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 111061 | 111061 | 34331 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 111513 | 111513 | 34317 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 114212 | 114212 | 34337 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 114934 | 114934 | 34324 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 120370 | 120370 | 34316 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 120485 | 120485 | 34334 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 120587 | 120587 | 34315 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 121018 | 121018 | 34333 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 122063 | 122063 | 34322 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 123214 | 123214 | 34325 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 123693 | 123693 | 34308 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 124842 | 124842 | 34329 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 125334 | 125334 | 34309 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 138330 | 138330 | 34330 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 142063 | 142063 | 34328 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 143487 | 143487 | 34332 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 143681 | 143681 | 34310 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 145262 | 145262 | 34323 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.40281462336901 | (37.7500487659499, -122.402814623369) | ||||
| 38255 | 38255 | 229744 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006129.97006 | 2100227.1008099997 | 37.747170335258204 | -122.421545017711 | (37.7471703352582, -122.421545017711) | |||
| 132415 | 132415 | 226334 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006673.9132199995 | 2103705.36513 | 37.756751509094 | -122.419910883878 | (37.756751509094, -122.419910883878) | |||
| 37979 | 37979 | 229803 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006754.853759999 | 2105853.73018 | 37.7626549800545 | -122.419783396906 | (37.7626549800545, -122.419783396906) | |||
| 42743 | 42743 | 108444 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 2 | 3x2.5 | 6014877.0 | 2117007.0 | 37.793733556134896 | -122.39247175850299 | (37.7937335561349, -122.392471758503) | |
| 155 | 155 | 251225 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Yukon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x2.5 | 6000238.0 | 2104757.0 | 37.7592743544717 | -122.442244057145 | (37.7592743544717, -122.442244057145) | ||||
| 187546 | 187546 | 32262 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 10 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 3 | Permit Number 35561 | 6005748.8799 | 2099664.71545 | 37.7456046578383 | -122.422822837406 | (37.7456046578383, -122.422822837406) | |
| 39582 | 39582 | 229804 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 10 Crescent Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 5ft | 6005354.49537 | 2095898.81655 | 37.7352420900484 | -122.423918818711 | (37.7352420900484, -122.423918818711) | |||
| 84571 | 84571 | 66285 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31629 | 6004295.09294916 | 2095637.08175846 | 37.7344635592859 | -122.427562920462 | (37.7344635592859, -122.427562920462) | ||
| 185514 | 185514 | 226765 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004241.0492 | 2095563.86697 | 37.7342594709862 | -122.427744552687 | (37.7342594709862, -122.427744552687) | |||
| 53457 | 53457 | 190730 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010525.46494 | 2107766.85443 | 37.76811967629639 | -122.40687698429599 | (37.7681196762964, -122.406876984296) | |||
| 132520 | 132520 | 190729 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010522.648990001 | 2107794.80164 | 37.7681962553765 | -122.406888694378 | (37.7681962553765, -122.406888694378) | |||
| 164271 | 164271 | 190731 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010525.632230001 | 2107742.1208900004 | 37.7680517730114 | -122.406874662236 | (37.7680517730114, -122.406874662236) | |||
| 181787 | 181787 | 190728 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6010522.48931 | 2107817.1778 | 37.768257686259105 | -122.406890823964 | (37.7682576862591, -122.406890823964) | |||
| 182053 | 182053 | 190732 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010527.29182 | 2107717.8289 | 37.767985165622605 | -122.40686720957899 | (37.7679851656226, -122.406867209579) | |||
| 25685 | 25685 | 228535 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009303.88793 | 2107359.3535700003 | 37.766932343692005 | -122.411073521351 | (37.766932343692, -122.411073521351) | |||
| 43204 | 43204 | 228534 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009327.35781 | 2107359.80868 | 37.7669349094434 | -122.41099237460699 | (37.7669349094434, -122.410992374607) | |||
| 56727 | 56727 | 228536 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009279.45147 | 2107357.51638 | 37.7669259288053 | -122.411157913712 | (37.7669259288053, -122.411157913712) | |||
| 68707 | 68707 | 228532 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009375.264140001 | 2107362.10106 | 37.766943890068205 | -122.410826835502 | (37.7669438900682, -122.410826835502) | |||
| 75738 | 75738 | 228537 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009258.78622 | 2107356.5369700002 | 37.76692208062529 | -122.411229322595 | (37.7669220806253, -122.411229322595) | |||
| 94248 | 94248 | 228533 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009349.90879 | 2107361.21702 | 37.7669400409627 | -122.410914473531 | (37.7669400409627, -122.410914473531) | |||
| 178077 | 178077 | 228538 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009238.1018900005 | 2107354.62318 | 37.7669156657401 | -122.411300731452 | (37.7669156657401, -122.411300731452) | |||
| 187160 | 187160 | 228539 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009212.74652 | 2107353.73928 | 37.766911816665704 | -122.41138836950199 | (37.7669118166657, -122.411388369502) | |||
| 62972 | 62972 | 190689 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1001 Minnesota St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6015296.26829 | 2103832.96006 | 37.757583849644796 | -122.39010027902701 | (37.7575838496448, -122.390100279027) | |||
| 163771 | 163771 | 190688 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1001 Minnesota St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6015295.35609 | 2103854.9870599997 | 37.7576442804869 | -122.390104972579 | (37.7576442804869, -122.390104972579) | |||
| 172607 | 172607 | 190687 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1001 Minnesota St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6015294.95519 | 2103873.52866 | 37.7576951695231 | -122.390107654354 | (37.7576951695231, -122.390107654354) | |||
| 45723 | 45723 | 190690 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1003 Minnesota St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6015296.6982 | 2103817.69544 | 37.757541960103396 | -122.39009772585501 | (37.7575419601034, -122.390097725855) | |||
| 42426 | 42426 | 190691 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1005 Minnesota St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6015298.330490001 | 2103800.67785 | 37.757495323968 | -122.39009089187901 | (37.757495323968, -122.390090891879) | |||
| 182992 | 182992 | 190692 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1007 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6015546.55953 | 2104430.7549099997 | 37.7592391453969 | -122.38927640559099 | (37.7592391453969, -122.389276405591) | |||
| 37810 | 37810 | 39586 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1011 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 4 | Permit Number 40997 | 6011941.43836 | 2103546.16349 | 37.756609729177896 | -122.401682552328 | (37.7566097291779, -122.401682552328) | |
| 47604 | 47604 | 69898 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1019 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 4 | 6011946.5334 | 2103437.3528 | 37.756311243277004 | -122.401657284058 | (37.756311243277, -122.401657284058) | ||
| 5445 | 5445 | 71960 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1020 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1995 12:00:00 AM | 3 | 6008996.95317 | 2116013.9295900003 | 37.7906785394346 | -122.41274707603701 | (37.7906785394346, -122.412747076037) | |||
| 5530 | 5530 | 73673 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1020 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1995 12:00:00 AM | 3 | 3x3 | Permit Number 49743 | 6009009.07055 | 2116016.5507400003 | 37.790686416582396 | -122.412705335782 | (37.7906864165824, -122.412705335782) | |
| 35695 | 35695 | 35366 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1034 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 10 | Permit Number 38826 | 6011879.44293 | 2103561.1446700003 | 37.756647404478 | -122.40189800918999 | (37.756647404478, -122.40189800919) | |
| 3172 | 3172 | 253340 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 1045 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780536 | 6004432.85841 | 2102813.20591 | 37.754175338839204 | -122.427597715268 | (37.7541753388392, -122.427597715268) | |
| 46199 | 46199 | 226315 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1045 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007642.72664 | 2103585.2825 | 37.756476322828 | -122.416551856705 | (37.756476322828, -122.416551856705) | |||
| 128911 | 128911 | 101946 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1045 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007665.9 | 2103581.6 | 37.756467514749396 | -122.41647145396999 | (37.7564675147494, -122.41647145397) | |||
| 15543 | 15543 | 106166 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1051 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6012226.18355 | 2103510.5202200003 | 37.7565277460814 | -122.400695290961 | (37.7565277460814, -122.400695290961) | ||||
| 72637 | 72637 | 226324 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1055 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008046.21468 | 2101786.36501 | 37.7515595871229 | -122.415029123693 | (37.7515595871229, -122.415029123693) | |||
| 143535 | 143535 | 96068 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1055 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767693 | 6008044.0 | 2101787.0 | 37.7515612062089 | -122.415036827298 | (37.7515612062089, -122.415036827298) | |
| 24273 | 24273 | 226430 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006668.67931 | 2102994.38705 | 37.75479903236629 | -122.41987853526899 | (37.7547990323663, -122.419878535269) | |||
| 25940 | 25940 | 226434 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006662.06006 | 2103117.82252 | 37.7551375848404 | -122.419910185127 | (37.7551375848404, -122.419910185127) | |||
| 36119 | 36119 | 226431 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006664.9239300005 | 2103021.2685 | 37.7548726310745 | -122.419893429847 | (37.7548726310745, -122.419893429847) | |||
| 38369 | 38369 | 226432 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006660.51047 | 2103068.53452 | 37.7550021640414 | -122.41991204671999 | (37.7550021640414, -122.41991204672) | |||
| 46113 | 46113 | 226433 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006663.83853 | 2103099.55931 | 37.7550875384663 | -122.41990273874201 | (37.7550875384663, -122.419902738742) | |||
| 56206 | 56206 | 226427 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006674.0476 | 2102914.93571 | 37.7545811796958 | -122.419854332733 | (37.7545811796958, -122.419854332733) | |||
| 106016 | 106016 | 226435 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006660.81941 | 2103136.07502 | 37.75518763210621 | -122.419915770819 | (37.7551876321062, -122.419915770819) | |||
| 130350 | 130350 | 226429 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006669.22772 | 2102968.64373 | 37.7547283780289 | -122.41987481207501 | (37.7547283780289, -122.419874812075) | |||
| 147445 | 147445 | 226428 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006671.335630001 | 2102940.18758 | 37.7546503627401 | -122.419865503217 | (37.7546503627401, -122.419865503217) | |||
| 162409 | 162409 | 226436 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 106 Bartlett St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006661.6983199995 | 2103152.67554 | 37.755233262826295 | -122.419913909217 | (37.7552332628263, -122.419913909217) | |||
| 186355 | 186355 | 39588 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1070 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 9 | Permit Number 40999 | 6011886.49797 | 2103421.1192799998 | 37.7562633193119 | -122.40186376750601 | (37.7562633193119, -122.401863767506) | |
| 67736 | 67736 | 226415 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1072 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009167.57752 | 2102926.6389599997 | 37.754753474499005 | -122.411231837073 | (37.754753474499, -122.411231837073) | |||
| 99513 | 99513 | 37008 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1072 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39622 | 6009161.44708429 | 2102917.71033779 | 37.7547286146948 | -122.411252407188 | (37.7547286146948, -122.411252407188) | ||
| 123477 | 123477 | 46609 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1078 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2002 12:00:00 AM | Permit Number 44732 | 6010490.67134457 | 2102955.14321265 | 37.7549058552549 | -122.406658202843 | (37.7549058552549, -122.406658202843) | |||
| 33217 | 33217 | 247662 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 108 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6001959.68947 | 2108344.83823 | 37.769223654362605 | -122.436546435187 | (37.7692236543626, -122.436546435187) | |||
| 81939 | 81939 | 39192 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1081 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1998 12:00:00 AM | Permit Number 40845 | 6008661.50268126 | 2102262.13718449 | 37.7529005072206 | -122.412935008702 | (37.7529005072206, -122.412935008702) | |||
| 61684 | 61684 | 69888 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1094 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 10 | 6012175.72633 | 2103309.76161 | 37.755973692659396 | -122.40085568686101 | (37.7559736926594, -122.400855686861) | ||
| 44200 | 44200 | 229830 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1097 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010012.5891 | 2102852.11627 | 37.7545962064773 | -122.408304286625 | (37.7545962064773, -122.408304286625) | |||
| 114033 | 114033 | 43929 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1097x York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2003 12:00:00 AM | Permit Number 43519 | 6010038.0 | 2102851.0 | 37.7545945643559 | -122.40821632984199 | (37.7545945643559, -122.408216329842) | ||
| 58267 | 58267 | 226467 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 11 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005807.5274 | 2099625.67838 | 37.7455007798334 | -122.42261726946998 | (37.7455007798334, -122.42261726947) | |||
| 51133 | 51133 | 35546 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 110 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.755159344788396 | -122.419928417644 | (37.7551593447884, -122.419928417644) | ||
| 79962 | 79962 | 35543 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 110 Bartlett St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.755159344788396 | -122.419928417644 | (37.7551593447884, -122.419928417644) | ||
| 81091 | 81091 | 35544 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 110 Bartlett St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.755159344788396 | -122.419928417644 | (37.7551593447884, -122.419928417644) | ||
| 114477 | 114477 | 35545 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 110 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.755159344788396 | -122.419928417644 | (37.7551593447884, -122.419928417644) | ||
| 118092 | 118092 | 35547 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 110 Bartlett St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.755159344788396 | -122.419928417644 | (37.7551593447884, -122.419928417644) | ||
| 146143 | 146143 | 35542 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 110 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.755159344788396 | -122.419928417644 | (37.7551593447884, -122.419928417644) | ||
| 152981 | 152981 | 226310 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 110 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010345.87417 | 2099884.35237 | 37.7464660383936 | -122.406942531387 | (37.7464660383936, -122.406942531387) | |||
| 15703 | 15703 | 108713 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1101 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773108 | 6011675.24376 | 2103231.93963 | 37.7557320816825 | -122.402581058681 | (37.7557320816825, -122.402581058681) |
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");