Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 123154 | 123154 | 4019 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1760 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 3 | 2X3 | 6013957.30178 | 2101067.5315943 | 37.7499162221241 | -122.39453736171801 | (37.7499162221241, -122.394537361718) | ||
| 7425 | 7425 | 8168 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1160 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6002214.9627 | 2111253.4218 | 37.7772244047313 | -122.435871600468 | (37.7772244047313, -122.435871600468) | |||
| 8037 | 8037 | 12253 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 528 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2003 12:00:00 AM | 6 | 3x3 | 6005030.2517 | 2110722.9994 | 37.7759275170107 | -122.426094839447 | (37.7759275170107, -122.426094839447) | ||
| 83620 | 83620 | 12440 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1595X Laguna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004488.80475 | 2114299.5475 | 37.785717215657 | -122.428222797765 | (37.785717215657, -122.428222797765) | |||
| 3528 | 3528 | 13088 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 722 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6008925.6016 | 2120449.3844 | 37.802853199751794 | -122.413307745784 | (37.8028531997518, -122.413307745784) | |||
| 7927 | 7927 | 13089 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 722 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008909.0684 | 2120447.731 | 37.8028477316821 | -122.41336484235 | (37.8028477316821, -122.41336484235) | |||
| 6874 | 6874 | 13090 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 724 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/2004 12:00:00 AM | 12 | 3X3 | 6008885.9219 | 2120447.4555 | 37.8028456756355 | -122.413444921903 | (37.8028456756355, -122.413444921903) | ||
| 86979 | 86979 | 16604 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 101 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778401 | 6002878.7558281 | 2107677.2386141997 | 37.7674427729111 | -122.433319725194 | (37.7674427729111, -122.433319725194) | |
| 107990 | 107990 | 18204 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1570 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6004662.4699013 | 2114369.5525339 | 37.7859192566668 | -122.42762695498699 | (37.7859192566668, -122.427626954987) | |||
| 20466 | 20466 | 18597 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1999 12:00:00 AM | 6 | 3X3 | 5992871.5273 | 2088492.4561 | 37.7141934014371 | -122.466538492306 | (37.7141934014371, -122.466538492306) | ||
| 426 | 426 | 21683 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1840 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1999 12:00:00 AM | 6 | 2x2 | 6003770.0848 | 2114594.6383 | 37.786486768354294 | -122.430730428794 | (37.7864867683543, -122.430730428794) | ||
| 2665 | 2665 | 21684 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1840 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2004 12:00:00 AM | 3 | 4x4 | 6003739.9244 | 2114585.2131 | 37.7864591803505 | -122.43083410335501 | (37.7864591803505, -122.430834103355) | ||
| 6750 | 6750 | 21685 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1840 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1999 12:00:00 AM | 6 | 4x4 | 6003694.6838 | 2114582.3856 | 37.7864488534059 | -122.43099042257299 | (37.7864488534059, -122.430990422573) | ||
| 5466 | 5466 | 21688 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1881 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1992 12:00:00 AM | 2 | 4x4 | 6003696.9634 | 2114537.7544 | 37.7863264365495 | -122.430979349218 | (37.7863264365495, -122.430979349218) | ||
| 92173 | 92173 | 21707 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1710X Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 6 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | ||
| 90524 | 90524 | 21708 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1710X Webster St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 7 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | ||
| 7481 | 7481 | 21730 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1955 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1990 12:00:00 AM | 6 | 3X3 | 6003249.1628 | 2114463.8768 | 37.786098203806205 | -122.43252334451599 | (37.7860982038062, -122.432523344516) | ||
| 4179 | 4179 | 23894 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1581 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:37:00 AM | 3 | 3X3 | 6003529.5219 | 2114142.2135 | 37.7852308919409 | -122.431530405312 | (37.7852308919409, -122.431530405312) | ||
| 2427 | 2427 | 23895 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1581 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6003532.7108 | 2114115.4269999997 | 37.7851575236987 | -122.431517459739 | (37.7851575236987, -122.431517459739) | ||
| 7053 | 7053 | 23897 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1581 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6003549.9307 | 2114010.8321 | 37.784871308404 | -122.431450414863 | (37.784871308404, -122.431450414863) | ||
| 6039 | 6039 | 23898 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1581 Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6003553.1196 | 2113987.2345 | 37.7848066960652 | -122.43143769715701 | (37.7848066960652, -122.431437697157) | ||
| 22231 | 22231 | 25471 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 237 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993297.6081 | 2088487.2193 | 37.7142036007288 | -122.465065423908 | (37.7142036007288, -122.465065423908) | ||
| 18656 | 18656 | 25472 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 205X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/1999 12:00:00 AM | 6 | 3X3 | 5993432.494 | 2088486.2672 | 37.714208763487896 | -122.46459914058599 | (37.7142087634879, -122.464599140586) | ||
| 10780 | 10780 | 26783 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010951.9721 | 2087077.0783 | 37.711333837408205 | -122.40394559103301 | (37.7113338374082, -122.403945591033) | |||
| 13116 | 13116 | 26784 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010928.7998 | 2087090.8926 | 37.7113704740421 | -122.40402665236999 | (37.7113704740421, -122.40402665237) | |||
| 11422 | 11422 | 26785 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 28 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1999 12:00:00 AM | 3 | 3X3 | 6010847.2509 | 2087135.4549 | 37.7114882765061 | -122.40431164223101 | (37.7114882765061, -122.404311642231) | ||
| 12802 | 12802 | 26786 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 34 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6010794.6675 | 2087161.3009 | 37.7115563058928 | -122.404495203342 | (37.7115563058928, -122.404495203342) | |||
| 10592 | 10592 | 26788 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 78 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1999 12:00:00 AM | 4 | 3X3 | 6010596.3656 | 2087261.1203 | 37.711819305554 | -122.40518761518801 | (37.711819305554, -122.405187615188) | ||
| 12328 | 12328 | 26789 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 96 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2010 12:00:00 AM | 3 | 3X3 | 6010520.1642 | 2087302.5632 | 37.7119288389604 | -122.40545390649599 | (37.7119288389604, -122.405453906496) | ||
| 12918 | 12918 | 26791 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 110 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1999 12:00:00 AM | 4 | 3x3 | 6010397.1725 | 2087366.7328 | 37.712098157972605 | -122.40588352001801 | (37.7120981579726, -122.405883520018) | ||
| 13045 | 13045 | 26792 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 128 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2002 12:00:00 AM | 3 | 3x3 | 6010340.5785 | 2087395.6982 | 37.7121745258223 | -122.40608116557199 | (37.7121745258223, -122.406081165572) | ||
| 10559 | 10559 | 26794 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 186 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1999 12:00:00 AM | 2 | 3x3 | 6010044.3489 | 2087538.0893 | 37.7125489295627 | -122.407115057358 | (37.7125489295627, -122.407115057358) | ||
| 12883 | 12883 | 26798 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010259.698 | 2087389.6823 | 37.71215348320929 | -122.406360290051 | (37.7121534832093, -122.406360290051) | |||
| 12450 | 12450 | 26799 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010285.5441 | 2087377.2049 | 37.7121206686095 | -122.40627007937 | (37.7121206686095, -122.40627007937) | |||
| 11042 | 11042 | 26800 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1999 12:00:00 AM | 5 | 3x3 | 6010377.1195 | 2087327.5180000002 | 37.7119893605537 | -122.40595006858901 | (37.7119893605537, -122.405950068589) | ||
| 6947 | 6947 | 26936 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1529 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6002004.7416 | 2111860.8692 | 37.7788803585551 | -122.436642312661 | (37.7788803585551, -122.436642312661) | |||
| 5333 | 5333 | 26937 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1529 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6002019.9705 | 2111862.8998 | 37.7788867994939 | -122.436589775324 | (37.7788867994939, -122.436589775324) | |||
| 11559 | 11559 | 27104 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 637 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2X3 | 6005511.99058 | 2093568.16222 | 37.7288515201802 | -122.423208682549 | (37.7288515201802, -122.423208682549) | |||
| 10932 | 10932 | 27180 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 225 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/1999 12:00:00 AM | 3 | 2X3 | 6002717.36844 | 2093904.29403 | 37.7296163521897 | -122.432893878247 | (37.7296163521897, -122.432893878247) | ||
| 126999 | 126999 | 30734 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 281 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34629 | 6005251.19976575 | 2109714.98569866 | 37.7731722414546 | -122.42525877680299 | (37.7731722414546, -122.425258776803) | ||
| 169020 | 169020 | 30735 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 281 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34629 | 6005244.0655 | 2109725.8172 | 37.773201579085004 | -122.42528422609699 | (37.773201579085, -122.425284226097) | |
| 99267 | 99267 | 30767 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1595 Underwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34647 | 6014606.20359025 | 2093675.42749231 | 37.729655084274995 | -122.39177660646999 | (37.729655084275, -122.39177660647) | ||
| 172828 | 172828 | 30770 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1662 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 2 | Permit Number 51077 | 6014463.7744 | 2093152.8983 | 37.7282124168861 | -122.39223247286101 | (37.7282124168861, -122.392232472861) | ||
| 96892 | 96892 | 30797 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 142 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | Permit Number 34664 | 6001440.7282053 | 2094773.69226545 | 37.7319310278176 | -122.43736957803301 | (37.7319310278176, -122.437369578033) | ||
| 70597 | 70597 | 30894 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 1 | Permit Number 34721 | 5996515.6245 | 2113531.2346 | 37.783153273367205 | -122.45575201055 | (37.7831532733672, -122.45575201055) | ||
| 39287 | 39287 | 31050 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 25 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51560 | 6002835.195830001 | 2087448.13614 | 37.711895858785894 | -122.432025692555 | (37.7118958587859, -122.432025692555) | |
| 80096 | 80096 | 31127 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 121 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 5.5x4 | Permit Number 34844 | 5998074.93385537 | 2093867.82881443 | 37.729251820430605 | -122.448940561252 | (37.7292518204306, -122.448940561252) | |
| 134091 | 134091 | 31134 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 154 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 2 | Permit Number 34849 | 6000371.52521 | 2094373.11197 | 37.730770284917895 | -122.441037301429 | (37.7307702849179, -122.441037301429) | |
| 150611 | 150611 | 31299 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 519 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 8 | Permit Number 34943 | 6005251.2106 | 2111468.7266 | 37.777987587802 | -122.42538356524099 | (37.777987587802, -122.425383565241) | |
| 179096 | 179096 | 31300 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 519 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 10 | Permit Number 34943 | 6005263.3007 | 2111469.3023 | 37.7779898515936 | -122.425341782234 | (37.7779898515936, -122.425341782234) | |
| 74745 | 74745 | 31301 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 529 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 8 | Permit Number 34944 | 6005236.8177 | 2111465.8481 | 37.7779788709631 | -122.425433150534 | (37.7779788709631, -122.425433150534) | |
| 182779 | 182779 | 31302 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 529 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 9 | Permit Number 34944 | 6005223.0006 | 2111465.2723 | 37.7779765092875 | -122.42548090783501 | (37.7779765092875, -122.425480907835) | |
| 187911 | 187911 | 31303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 535 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005167.7319 | 2111457.2123 | 37.777951255610795 | -122.425671528209 | (37.7779512556108, -122.425671528209) | |
| 71730 | 71730 | 31304 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 535 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005195.9419 | 2111461.818 | 37.7779654957454 | -122.425574267643 | (37.7779654957454, -122.425574267643) | |
| 151643 | 151643 | 31579 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1766 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 10 | Permit Number 35118 | 5989083.5648 | 2103328.988 | 37.7547113797178 | -122.480716506349 | (37.7547113797178, -122.480716506349) | |
| 84774 | 84774 | 31652 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2066 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/1995 12:00:00 AM | Permit Number 35162 | 6001931.34452098 | 2119821.7914856 | 37.8007348293225 | -122.437466455186 | (37.8007348293225, -122.437466455186) | |||
| 128993 | 128993 | 31717 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 Twin Peaks Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35217 | 5999015.35080387 | 2105425.59790745 | 37.7610403997541 | -122.446520655595 | (37.7610403997541, -122.446520655595) | ||
| 124206 | 124206 | 31718 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 Twin Peaks Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35217 | 5999015.35080387 | 2105425.59790745 | 37.7610403997541 | -122.446520655595 | (37.7610403997541, -122.446520655595) | ||
| 169349 | 169349 | 31758 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2646 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35244 | 5989596.3538 | 2097340.4362 | 37.738298177735 | -122.478505265789 | (37.738298177735, -122.478505265789) | |
| 15956 | 15956 | 31845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 11986 | 11986 | 31849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 15875 | 15875 | 31850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 11785 | 11785 | 31851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 5373 | 5373 | 31852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 85569 | 85569 | 31855 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 15 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35301 | 6009805.81882643 | 2111161.45127671 | 37.7774001559158 | -122.409605796854 | (37.7774001559158, -122.409605796854) | ||
| 142824 | 142824 | 31920 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2296 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.47136143824699 | (37.7451690123809, -122.471361438247) | ||
| 93746 | 93746 | 31921 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2296 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.47136143824699 | (37.7451690123809, -122.471361438247) | ||
| 145099 | 145099 | 31922 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2296 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.47136143824699 | (37.7451690123809, -122.471361438247) | ||
| 20378 | 20378 | 31923 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2296 15th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.47136143824699 | (37.7451690123809, -122.471361438247) | ||
| 109568 | 109568 | 32092 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4043 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | Permit Number 35465 | 6002732.39068371 | 2104711.97751981 | 37.759292580613604 | -122.433614037894 | (37.7592925806136, -122.433614037894) | ||
| 116548 | 116548 | 32093 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4043 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | Permit Number 35465 | 6002732.39068371 | 2104711.97751981 | 37.759292580613604 | -122.433614037894 | (37.7592925806136, -122.433614037894) | ||
| 145699 | 145699 | 32137 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 618 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35496 | 6004564.35276407 | 2110630.82762794 | 37.7756480927458 | -122.42769993653499 | (37.7756480927458, -122.427699936535) | |||
| 115410 | 115410 | 32139 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 618 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35496 | 6004564.35276407 | 2110630.82762794 | 37.7756480927458 | -122.42769993653499 | (37.7756480927458, -122.427699936535) | |||
| 139535 | 139535 | 32140 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 618 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35496 | 6004564.35276407 | 2110630.82762794 | 37.7756480927458 | -122.42769993653499 | (37.7756480927458, -122.427699936535) | |||
| 145007 | 145007 | 32149 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 131 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35500 | 6006458.85096741 | 2110609.91009121 | 37.775697640431396 | -122.42114490355699 | (37.7756976404314, -122.421144903557) | ||
| 114564 | 114564 | 32169 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 127685 | 127685 | 32170 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 88347 | 88347 | 32171 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 107326 | 107326 | 32172 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 18086 | 18086 | 32173 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 124447 | 124447 | 32174 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.49433563765699 | (37.7296472241819, -122.494335637657) | ||
| 145196 | 145196 | 32175 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.49433563765699 | (37.7296472241819, -122.494335637657) | ||
| 120359 | 120359 | 32267 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 267 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | Permit Number 36853 | 6013772.46926434 | 2105862.13808331 | 37.7630708975316 | -122.395512392676 | (37.7630708975316, -122.395512392676) | |||
| 90220 | 90220 | 32381 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
| 114011 | 114011 | 32382 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
| 113477 | 113477 | 32383 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
| 128135 | 128135 | 32384 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
| 99137 | 99137 | 32397 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 226 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36938 | 6005820.24941842 | 2096097.7148736 | 37.7358145039443 | -122.42232266151301 | (37.7358145039443, -122.422322661513) | ||
| 104370 | 104370 | 32431 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 30 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1996 12:00:00 AM | Permit Number 36958 | 6002847.4322838 | 2093541.64136391 | 37.72862796611629 | -122.432418342718 | (37.7286279661163, -122.432418342718) | |||
| 141694 | 141694 | 32790 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1704 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37155 | 5999594.67382686 | 2110888.19372737 | 37.776072385759605 | -122.44490972486601 | (37.7760723857596, -122.444909724866) | ||
| 18075 | 18075 | 32820 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4231 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37179 | 6001652.66778496 | 2102313.08223681 | 37.7526444703409 | -122.43717647687599 | (37.7526444703409, -122.437176476876) | ||
| 40005 | 40005 | 32827 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4107 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | 3x3 | Permit Number 37185 | 6002480.53446063 | 2101776.94850735 | 37.751219399221604 | -122.434275246016 | (37.7512193992216, -122.434275246016) |
| 79577 | 79577 | 32850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 743 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/2006 12:00:00 AM | Permit Number 37201 | 6001607.63275994 | 2102018.09259502 | 37.751831939335204 | -122.437311094932 | (37.7518319393352, -122.437311094932) | ||
| 128893 | 128893 | 32852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 764 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41115 | 6001471.9166257 | 2102062.60736984 | 37.751946450075394 | -122.437783607007 | (37.7519464500754, -122.437783607007) | ||
| 104375 | 104375 | 32883 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1272 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37227 | 5994266.48992242 | 2106860.31836546 | 37.7647073772985 | -122.463048880777 | (37.7647073772985, -122.463048880777) | ||
| 79015 | 79015 | 32921 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1392 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37251 | 5993527.89393066 | 2105989.81652966 | 37.7622746341272 | -122.465540224747 | (37.7622746341272, -122.465540224747) | ||
| 98796 | 98796 | 32922 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1392 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37251 | 5993527.89393066 | 2105989.81652966 | 37.7622746341272 | -122.465540224747 | (37.7622746341272, -122.465540224747) | ||
| 111078 | 111078 | 32925 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 338 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | 3x3 | Permit Number 37251 | 5993527.89393066 | 2105989.81652966 | 37.7622746341272 | -122.465540224747 | (37.7622746341272, -122.465540224747) | |
| 126352 | 126352 | 33042 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 407 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37319 | 6005521.73281863 | 2101332.19930241 | 37.750170367356 | -122.423726818664 | (37.750170367356, -122.423726818664) | ||
| 88624 | 88624 | 33180 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 521 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | Permit Number 42760 | 5994469.49128291 | 2099720.55055185 | 37.7451150932518 | -122.461829011712 | (37.7451150932518, -122.461829011712) |
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");