Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 120148 | 120148 | 7766 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 325X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006199.471782 | 2111757.686674 | 37.7788345313197 | -122.42212372172101 | (37.7788345313197, -122.422123721721) | |||
| 66199 | 66199 | 7767 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 325X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/2010 12:00:00 AM | 3X3 | 6006199.471782 | 2111757.686674 | 37.7788345313197 | -122.42212372172101 | (37.7788345313197, -122.422123721721) | |||
| 37396 | 37396 | 7768 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 325X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006199.471782 | 2111757.686674 | 37.7788345313197 | -122.42212372172101 | (37.7788345313197, -122.422123721721) | |||
| 5413 | 5413 | 14844 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 1327 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/1987 12:00:00 AM | 6 | 3x3 | 6002796.5861 | 2111629.8173 | 37.7782909152526 | -122.43388649174999 | (37.7782909152526, -122.43388649175) | ||
| 16836 | 16836 | 15111 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6013962.82131 | 2116101.4847 | 37.79119641403479 | -122.395571449475 | (37.7911964140348, -122.395571449475) | |||
| 14513 | 14513 | 15112 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6013977.3910300005 | 2116114.5164400004 | 37.7912330065583 | -122.395521951701 | (37.7912330065583, -122.395521951701) | |||
| 16815 | 16815 | 15113 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6013991.513259999 | 2116128.24604 | 37.7912714903321 | -122.395474051105 | (37.7912714903321, -122.395474051105) | |||
| 13467 | 13467 | 15114 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014005.1464 | 2116140.60731 | 37.79130618976829 | -122.39542774681001 | (37.7913061897683, -122.39542774681) | |||
| 13924 | 13924 | 15115 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014020.20981 | 2116155.23725 | 37.7913471979732 | -122.395376652733 | (37.7913471979732, -122.395376652733) | |||
| 15272 | 15272 | 15116 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6014033.6168599995 | 2116167.8327099998 | 37.7913825278275 | -122.39533114703 | (37.7913825278275, -122.39533114703) | |||
| 15920 | 15920 | 15117 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014044.26076 | 2116180.71375 | 37.7914184881275 | -122.39529522181401 | (37.7914184881275, -122.395295221814) | |||
| 14190 | 14190 | 15118 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014060.69419 | 2116194.6265 | 37.7914576032294 | -122.395239337045 | (37.7914576032294, -122.395239337045) | |||
| 16130 | 16130 | 15119 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6014087.04677 | 2116219.82682 | 37.7915282629576 | -122.395149922854 | (37.7915282629576, -122.395149922854) | |||
| 14159 | 14159 | 15120 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014101.62567 | 2116233.31764 | 37.791566116339204 | -122.395100425058 | (37.7915661163392, -122.395100425058) | |||
| 75743 | 75743 | 17631 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | ||
| 102325 | 102325 | 17634 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 145599 | 145599 | 17635 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 85032 | 85032 | 17636 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 83164 | 83164 | 17638 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 92402 | 92402 | 17639 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 123909 | 123909 | 17641 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 10 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
| 85626 | 85626 | 17642 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 6 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
| 109408 | 109408 | 17643 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 8 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
| 145002 | 145002 | 17644 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 8 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
| 94447 | 94447 | 17645 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 10 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
| 116101 | 116101 | 17647 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 650X Phelps St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 6 | 2x2 | 6015137.8127243 | 2097842.4274143996 | 37.7411263152677 | -122.39022977121401 | (37.7411263152677, -122.390229771214) | |||
| 104025 | 104025 | 17656 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | ||
| 83384 | 83384 | 17658 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 117411 | 117411 | 17659 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 125491 | 125491 | 17660 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 87807 | 87807 | 17661 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 104908 | 104908 | 17662 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 127590 | 127590 | 27659 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6014051.97429 | 2116162.8349200003 | 37.7913698260154 | -122.395267279985 | (37.7913698260154, -122.395267279985) | |||
| 7889 | 7889 | 29752 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 532 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6009988.1989 | 2119378.2609 | 37.7999717596155 | -122.40955495470502 | (37.7999717596155, -122.409554954705) | |||
| 5782 | 5782 | 29753 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 532 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6009968.1915 | 2119398.824 | 37.8000270997238 | -122.409625640361 | (37.8000270997238, -122.409625640361) | |||
| 3401 | 3401 | 29754 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 532 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6009953.7417 | 2119408.8277 | 37.800053757708994 | -122.40967634888099 | (37.800053757709, -122.409676348881) | |||
| 127002 | 127002 | 29755 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 532 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6010020.30224 | 2119411.75263 | 37.800065518477 | -122.409446229453 | (37.800065518477, -122.409446229453) | |||
| 109863 | 109863 | 31388 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36942 | 6014160.17669171 | 2116306.66761031 | 37.7917707740774 | -122.394902977188 | (37.7917707740774, -122.394902977188) | |||
| 83335 | 83335 | 31389 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36942 | 6014160.17669171 | 2116306.66761031 | 37.7917707740774 | -122.394902977188 | (37.7917707740774, -122.394902977188) | |||
| 138977 | 138977 | 32406 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36942 | 6014160.17669171 | 2116306.66761031 | 37.7917707740774 | -122.394902977188 | (37.7917707740774, -122.394902977188) | |||
| 100984 | 100984 | 32407 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36942 | 6014160.17669171 | 2116306.66761031 | 37.7917707740774 | -122.394902977188 | (37.7917707740774, -122.394902977188) | |||
| 116567 | 116567 | 32408 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36942 | 6014160.17669171 | 2116306.66761031 | 37.7917707740774 | -122.394902977188 | (37.7917707740774, -122.394902977188) | |||
| 15690 | 15690 | 35690 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 15958 | 15958 | 35692 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 16152 | 16152 | 35693 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 11435 | 11435 | 35694 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 11560 | 11560 | 35695 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 12226 | 12226 | 35696 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 7342 | 7342 | 35697 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 8272 | 8272 | 35698 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 10284 | 10284 | 35699 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 5612 | 5612 | 35700 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 14850 | 14850 | 35701 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 1981 | 1981 | 35702 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 15799 | 15799 | 35703 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 11610 | 11610 | 35704 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 11246 | 11246 | 35705 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 32103 | 32103 | 38388 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1150 Phelps St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1998 12:00:00 AM | 5 | Permit Number 40446 | 6014255.1081300005 | 2096652.83017 | 37.737810927032704 | -122.39319864851801 | (37.7378109270327, -122.393198648518) | ||
| 133858 | 133858 | 38495 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1353 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40489 | 6006548.48859 | 2118678.2473299997 | 37.7978563596483 | -122.421407937635 | (37.7978563596483, -122.421407937635) |
| 134375 | 134375 | 39384 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 7 | Permit Number 40925 | 6000588.20452 | 2117202.1206900002 | 37.793465453027395 | -122.441926131987 | (37.7934654530274, -122.441926131987) | ||
| 168945 | 168945 | 39385 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 9 | Permit Number 40925 | 6000567.4477 | 2117199.7395900004 | 37.7934577323376 | -122.441997780973 | (37.7934577323376, -122.441997780973) | ||
| 36450 | 36450 | 39386 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 9 | Permit Number 40925 | 6000600.16704 | 2117204.05937 | 37.7934714577907 | -122.441884880082 | (37.7934714577907, -122.441884880082) | ||
| 62368 | 62368 | 39387 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 7 | Permit Number 40925 | 6000579.41048 | 2117201.67826 | 37.7934637371134 | -122.44195652817899 | (37.7934637371134, -122.441956528179) | ||
| 84551 | 84551 | 45668 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 46(REVISED) Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 44364 | 6004865.19751473 | 2101080.41704042 | 37.7494419484142 | -122.425979237767 | (37.7494419484142, -122.425979237767) | ||
| 88835 | 88835 | 49214 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 500 Howard St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 91400 | 91400 | 49223 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 500 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 75153 | 75153 | 49224 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 500 Howard St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 116184 | 116184 | 49225 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 500 Howard St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 144578 | 144578 | 49226 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 500 Howard St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 99398 | 99398 | 49230 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 500 Howard St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 111666 | 111666 | 49232 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 500 Howard St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 168339 | 168339 | 49588 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2333 REVISED Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2003 12:00:00 AM | 16 | Permit Number 46464 | 6003709.90767 | 2116419.2146400004 | 37.7914931831193 | -122.431068901134 | (37.7914931831193, -122.431068901134) | ||
| 142828 | 142828 | 50615 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2004 12:00:00 AM | Permit Number 47216 | 6004288.29588296 | 2104553.28636794 | 37.7589450112214 | -122.42822165267 | (37.7589450112214, -122.42822165267) | |||
| 121680 | 121680 | 50616 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2004 12:00:00 AM | Permit Number 47216 | 6004288.29588296 | 2104553.28636794 | 37.7589450112214 | -122.42822165267 | (37.7589450112214, -122.42822165267) | |||
| 98558 | 98558 | 50617 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2004 12:00:00 AM | Permit Number 47216 | 6004288.29588296 | 2104553.28636794 | 37.7589450112214 | -122.42822165267 | (37.7589450112214, -122.42822165267) | ||
| 166496 | 166496 | 51593 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1960 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53890 | 5998519.8939 | 2110042.61 | 37.773689232881395 | -122.44856674553301 | (37.7736892328814, -122.448566745533) | |
| 91941 | 91941 | 52992 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1800 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 48973 | 6013995.42685531 | 2096291.44248921 | 37.7368042013217 | -122.394071207374 | (37.7368042013217, -122.394071207374) | |||
| 90132 | 90132 | 61067 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 532 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | Permit Number 46064 | 6010044.29985327 | 2119322.50303189 | 37.7998218055895 | -122.40935688621799 | (37.7998218055895, -122.409356886218) | |||
| 176440 | 176440 | 62970 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1827 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | 10 | Permit Number 23357 | 6008241.174219999 | 2118766.33453 | 37.7981935154844 | -122.41555699245701 | (37.7981935154844, -122.415556992457) | |
| 51118 | 51118 | 62971 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1833 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | 6 | Permit Number 23358 | 6008235.84849 | 2118785.82593 | 37.7982467346621 | -122.415576801855 | (37.7982467346621, -122.415576801855) | |
| 94681 | 94681 | 63072 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 709 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1986 12:00:00 AM | Permit Number 23550 | 6007407.20126882 | 2097784.26133742 | 37.740534778558605 | -122.416955389518 | (37.7405347785586, -122.416955389518) | ||
| 61384 | 61384 | 63581 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1360 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1987 12:00:00 AM | 13 | Permit Number 24204 | 6006506.63769 | 2118721.20057 | 37.7979719387185 | -122.421555805959 | (37.7979719387185, -122.421555805959) | |
| 120380 | 120380 | 64146 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 465 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | Permit Number 24921 | 6002780.16143913 | 2098575.90057442 | 37.7424470739996 | -122.433010428517 | (37.7424470739996, -122.433010428517) | ||
| 164671 | 164671 | 64662 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2786 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1989 12:00:00 AM | 14 | 6x4 | Permit Number 26052 | 5999613.31909 | 2118454.39818 | 37.796848274496206 | -122.445389381638 | (37.7968482744962, -122.445389381638) | |
| 57135 | 57135 | 65057 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1989 12:00:00 AM | 14 | Permit Number 27011 | 6012481.29964 | 2118678.07069 | 37.7981885871952 | -122.400878606079 | (37.7981885871952, -122.400878606079) | ||
| 16326 | 16326 | 66490 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 280 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2015 12:00:00 AM | 3 | Permit Number 775748 | 6010181.76408 | 2110999.12752 | 37.776975511839396 | -122.408293821201 | (37.7769755118394, -122.408293821201) | |
| 67057 | 67057 | 66847 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 45 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | 2 | Permit Number 30151 | 5998689.6182 | 2110496.1606 | 37.7749442695784 | -122.448012307244 | (37.7749442695784, -122.448012307244) | |
| 145231 | 145231 | 68365 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 945 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32186 | 6010298.82314684 | 2116844.8632648997 | 37.7930330672197 | -122.40830128766501 | (37.7930330672197, -122.408301287665) | ||
| 78762 | 78762 | 85037 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994836.8 | 2099436.6 | 37.7443565743554 | -122.460538359387 | (37.7443565743554, -122.460538359387) | |||||
| 90885 | 90885 | 85038 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994836.8 | 2099436.6 | 37.7443565743554 | -122.460538359387 | (37.7443565743554, -122.460538359387) | |||||
| 90452 | 90452 | 86806 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 700X Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 9 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | |||
| 93009 | 93009 | 86807 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 700X Phelps St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 6 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | |||
| 88337 | 88337 | 96318 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011857.0 | 2120322.0 | 37.802667576079 | -122.403154578184 | (37.802667576079, -122.403154578184) | |||
| 119723 | 119723 | 96319 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 128349 | 128349 | 96320 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 139177 | 139177 | 96321 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 107979 | 107979 | 96322 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 84349 | 84349 | 96323 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 91499 | 91499 | 96324 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 19672 | 19672 | 96325 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2011 12:00:00 AM | 5 | 4x4 | Permit Number 768012 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) |
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");