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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 675 | 675 | 47038 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 716 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45030 | ||||||||
| 1828 | 1828 | 35192 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 1869 | 1869 | 35202 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 2080 | 2080 | 34119 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37980 | |||||||||
| 3062 | 3062 | 34116 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37979 | |||||||||
| 3077 | 3077 | 35211 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 3212 | 3212 | 34102 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37975 | |||||||||
| 3420 | 3420 | 35199 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 3622 | 3622 | 34463 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 3663 | 3663 | 36860 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 5124 | 5124 | 56265 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 15 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2006 12:00:00 AM | Permit Number 12391 | 6006208.27079513 | 2104027.08283356 | 37.7576086269531 | -122.42154409690501 | (37.7576086269531, -122.421544096905) | ||
| 5605 | 5605 | 34138 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37987 | |||||||||
| 5673 | 5673 | 46713 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 5690 | 5690 | 34100 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37975 | |||||||||
| 5885 | 5885 | 46715 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 6242 | 6242 | 35188 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 6282 | 6282 | 46717 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 7169 | 7169 | 34120 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37980 | |||||||||
| 7188 | 7188 | 34462 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 7206 | 7206 | 46718 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 7464 | 7464 | 35185 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 7694 | 7694 | 36863 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 7712 | 7712 | 35193 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 8041 | 8041 | 46716 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 8802 | 8802 | 50777 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47304 | ||||||||||
| 8884 | 8884 | 34133 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37986 | |||||||||
| 9418 | 9418 | 34114 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37978 | |||||||||
| 9430 | 9430 | 47039 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 771 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45031 | ||||||||
| 9498 | 9498 | 36866 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9542 | 9542 | 34136 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37986 | |||||||||
| 9591 | 9591 | 36856 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9614 | 9614 | 36864 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 10275 | 10275 | 32464 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99x Deming St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36974 | 5999085.33670349 | 2105174.9537063 | 37.7603561904001 | -122.446260575093 | (37.7603561904001, -122.446260575093) | ||
| 10854 | 10854 | 34134 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37986 | |||||||||
| 10862 | 10862 | 34464 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 10907 | 10907 | 34118 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37979 | |||||||||
| 11057 | 11057 | 46152 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44491 | |||||||||
| 11070 | 11070 | 34466 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 11107 | 11107 | 34137 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37987 | |||||||||
| 11262 | 11262 | 34121 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37980 | |||||||||
| 11449 | 11449 | 35191 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 11627 | 11627 | 88529 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51479 | |||||||||
| 11728 | 11728 | 35200 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 11762 | 11762 | 47040 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 771 Walter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45031 | ||||||||
| 12079 | 12079 | 46714 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44843 | |||||||||
| 12275 | 12275 | 35186 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12401 | 12401 | 36861 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 12589 | 12589 | 34135 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37986 | |||||||||
| 13016 | 13016 | 35189 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 13086 | 13086 | 34123 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37981 | |||||||||
| 13445 | 13445 | 36857 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 13457 | 13457 | 36874 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14227 | 14227 | 35184 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14448 | 14448 | 34465 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 14687 | 14687 | 35195 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14730 | 14730 | 34101 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37975 | |||||||||
| 14763 | 14763 | 50776 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47304 | ||||||||||
| 14818 | 14818 | 35190 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14890 | 14890 | 36859 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14897 | 14897 | 36862 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 15003 | 15003 | 34117 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37979 | |||||||||
| 15057 | 15057 | 34122 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37981 | |||||||||
| 15117 | 15117 | 36858 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 15124 | 15124 | 35187 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 15510 | 15510 | 34461 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 15551 | 15551 | 34115 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37978 | |||||||||
| 15779 | 15779 | 50775 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47304 | ||||||||||
| 15869 | 15869 | 46153 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44491 | |||||||||
| 15972 | 15972 | 34132 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37986 | |||||||||
| 16027 | 16027 | 35201 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16469 | 16469 | 35182 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16677 | 16677 | 36865 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 16819 | 16819 | 34124 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37982 | |||||||||
| 16829 | 16829 | 35194 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16890 | 16890 | 34103 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37975 | |||||||||
| 17032 | 17032 | 94164 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 729 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53529 | 5991968.0 | 2104568.0 | 37.758280608436706 | -122.470831686794 | (37.7582806084367, -122.470831686794) | ||
| 17122 | 17122 | 35196 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 17905 | 17905 | 92094 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1300 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2007 12:00:00 AM | 3x3 | Permit Number 52201 | 6004216.0 | 2112914.0 | 37.7818974087405 | -122.42906780012501 | (37.7818974087405, -122.429067800125) | ||
| 17908 | 17908 | 45501 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3070 23rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | Permit Number 44273 | 5989380.64559271 | 2094892.34202186 | 37.731563814981605 | -122.47907204836399 | (37.7315638149816, -122.479072048364) | ||
| 17926 | 17926 | 85267 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49560 | ||||||||
| 18682 | 18682 | 87286 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1272 42nd Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/18/2007 12:00:00 AM | Permit Number 50303 | 5983096.8 | 2106514.6 | 37.7631083916796 | -122.501655692289 | (37.7631083916796, -122.501655692289) | ||||
| 18921 | 18921 | 32751 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X LOBOS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5996424.0 | 2088680.0 | 37.71491271306979 | -122.45427337935101 | (37.7149127130698, -122.454273379351) | ||
| 19059 | 19059 | 43844 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2736 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2003 12:00:00 AM | Permit Number 43466 | 5985584.65410627 | 2096702.64202879 | 37.7363132411039 | -122.492328600224 | (37.7363132411039, -122.492328600224) | ||
| 19106 | 19106 | 45210 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 600-698X Bowdoin St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2001 12:00:00 AM | Permit Number 44051 | 6008935.27610714 | 2093040.15073148 | 37.7275943109827 | -122.41133681828501 | (37.7275943109827, -122.411336818285) | ||
| 19118 | 19118 | 85268 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49560 | ||||||||
| 19353 | 19353 | 49110 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1411 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46250 | 5995842.78355552 | 2093401.69932097 | 37.7278440321398 | -122.456623556012 | (37.7278440321398, -122.456623556012) | ||
| 19426 | 19426 | 82960 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4774 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50809 | 5999900.41105831 | 2104653.85391663 | 37.7589718947663 | -122.443404190452 | (37.7589718947663, -122.443404190452) | ||
| 19470 | 19470 | 31542 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35092 | 5998688.18134384 | 2112713.18488923 | 37.7810315633484 | -122.44817695027099 | (37.7810315633484, -122.448176950271) | ||
| 19638 | 19638 | 88554 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 579 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51499 | 5990911.3 | 2111462.4 | 37.777149603591496 | -122.474989443149 | (37.7771496035915, -122.474989443149) | |||
| 19644 | 19644 | 44410 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1201 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2001 12:00:00 AM | Permit Number 43761 | 6001148.59414975 | 2087417.50046792 | 37.711715976255796 | -122.437852856075 | (37.7117159762558, -122.437852856075) | |||
| 19748 | 19748 | 42907 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2666 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 3x3 | Permit Number 42820 | 6010104.02523077 | 2104001.6158371996 | 37.757757594938 | -122.40806913661801 | (37.757757594938, -122.408069136618) | |
| 19784 | 19784 | 31175 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 230 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34873 | 5993424.36409325 | 2089864.86318911 | 37.7179935887517 | -122.464727290106 | (37.7179935887517, -122.464727290106) | ||
| 19804 | 19804 | 48657 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 601 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45947 | 5992474.12537509 | 2103859.88961246 | 37.7563655794475 | -122.469029766101 | (37.7563655794475, -122.469029766101) | ||
| 20267 | 20267 | 45221 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 801-899X Felton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2001 12:00:00 AM | Permit Number 44054 | 6008510.16746889 | 2093128.34888408 | 37.7278126322854 | -122.412812661196 | (37.7278126322854, -122.412812661196) | ||
| 20298 | 20298 | 115181 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2166 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775165 | 5981753.9 | 2100346.3 | 37.7460930178281 | -122.505842927008 | (37.7460930178281, -122.505842927008) | |||
| 20375 | 20375 | 36345 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 94 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39307 | 5995648.40057371 | 2093261.73046409 | 37.727448548862 | -122.45728541654199 | (37.727448548862, -122.457285416542) | ||
| 20376 | 20376 | 49064 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 820 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46228 | 5995441.21926362 | 2094283.33319861 | 37.7302417218115 | -122.45807554192699 | (37.7302417218115, -122.458075541927) | ||
| 21239 | 21239 | 84843 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1201 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/2007 12:00:00 AM | Permit No. 49246 | 6008311.7 | 2086994.1 | 37.7109581313437 | -122.41306521032699 | (37.7109581313437, -122.413065210327) | |||
| 21962 | 21962 | 85270 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000 Edinburgh St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49560 | ||||||||
| 25398 | 25398 | 48029 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 320 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45747 | 5992060.97145669 | 2097299.95564023 | 37.738329808716294 | -122.46998096184299 | (37.7383298087163, -122.469980961843) |
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");