Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2501 | 2501 | 119761 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 3013 | 3013 | 39333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 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 | |||||||||
| 61631 | 61631 | 178909 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5993779.42986 | 2086768.12245 | 37.70951113998979 | -122.463275405145 | (37.7095111399898, -122.463275405145) | ||||
| 89222 | 89222 | 89359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 308 Tocoloma Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50704 | 6012556.9 | 2087009.2 | 37.7112369933076 | -122.39839375585301 | (37.7112369933076, -122.398393755853) | ||
| 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) | |||
| 42943 | 42943 | 178899 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012660.08669 | 2087284.72268 | 37.7119992718279 | -122.39805643095801 | (37.7119992718279, -122.398056430958) | |||
| 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) | |||
| 56141 | 56141 | 120887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | |||
| 177236 | 177236 | 178894 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 38 Curtis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000524.98993 | 2088394.3572900002 | 37.714362726143 | -122.44007819877 | (37.714362726143, -122.44007819877) | |||
| 19239 | 19239 | 40472 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 43 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | |||
| 141140 | 141140 | 47334 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 142 Garfield St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45265 | 5993656.96278859 | 2090531.97182441 | 37.719838715813104 | -122.463971702484 | (37.7198387158131, -122.463971702484) | ||
| 10557 | 10557 | 37839 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003658.0147400005 | 2090473.5929 | 37.720249717041504 | -122.42939741397 | (37.7202497170415, -122.42939741397) |
| 154431 | 154431 | 178903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011814.45609 | 2090752.0893599999 | 37.7214728265024 | -122.401222688486 | (37.7214728265024, -122.401222688486) | |||
| 88018 | 88018 | 46638 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 670 Victoria St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2002 12:00:00 AM | Permit Number 44768 | 5993413.9529017 | 2091571.4332661 | 37.7226788173129 | -122.46488714503201 | (37.7226788173129, -122.464887145032) | |||
| 61894 | 61894 | 178932 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000025.30894 | 2091607.27425 | 37.7231562071699 | -122.44203576925501 | (37.7231562071699, -122.442035769255) | |||
| 141213 | 141213 | 52530 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 142 San Juan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48628 | 6001389.835788901 | 2092264.63848184 | 37.725038846492794 | -122.43736592524701 | (37.7250388464928, -122.437365925247) | ||
| 120418 | 120418 | 36384 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 701 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965563998 | 37.725848495794395 | -122.459920281258 | (37.7258484957944, -122.459920281258) | ||
| 138307 | 138307 | 37889 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1301 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1998 12:00:00 AM | Permit Number 40164 | 5995819.25622169 | 2092686.22988595 | 37.725878173698796 | -122.45665316971001 | (37.7258781736988, -122.45665316971) | |||
| 122559 | 122559 | 49139 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Westwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46263 | 5995223.85849165 | 2092714.15560614 | 37.7259206476516 | -122.458713425318 | (37.7259206476516, -122.458713425318) | ||
| 115696 | 115696 | 40388 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 706 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41499 | 5994916.05908376 | 2092743.92651485 | 37.725984695353105 | -122.459779615207 | (37.7259846953531, -122.459779615207) | ||
| 106645 | 106645 | 34098 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600 Miramar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37974 | 5995414.643408099 | 2093328.34737639 | 37.727618034343706 | -122.45809832977899 | (37.7276180343437, -122.458098329779) | |||
| 96310 | 96310 | 34129 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1401 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37983 | 5995840.26429469 | 2093321.75315516 | 37.7276243745144 | -122.45662648597799 | (37.7276243745144, -122.456626485978) | ||
| 124282 | 124282 | 36360 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 131 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39315 | 5995616.87742593 | 2093562.88394601 | 37.728273633305996 | -122.45741616982401 | (37.728273633306, -122.457416169824) | ||
| 161927 | 161927 | 214476 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 270 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5998285.21453 | 2093571.32939 | 37.7284497264529 | -122.448192264458 | (37.7284497264529, -122.448192264458) | ||||
| 44205 | 44205 | 178924 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 88 San Gabriel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6000939.255030001 | 2093544.2007900001 | 37.7285266059143 | -122.43901519111 | (37.7285266059143, -122.43901519111) | |||
| 115422 | 115422 | 36368 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 143 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39319 | 5995629.61458477 | 2093656.01088528 | 37.7285300690508 | -122.457378871767 | (37.7285300690508, -122.457378871767) | ||
| 123312 | 123312 | 42439 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 550 Judson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42584 | 5996829.49530885 | 2093648.57745681 | 37.7285785035344 | -122.45323030571801 | (37.7285785035344, -122.453230305718) | ||
| 86937 | 86937 | 36430 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 435 Montecito Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39339 | 5995738.77288151 | 2093964.11788292 | 37.7293823258224 | -122.457023785093 | (37.7293823258224, -122.457023785093) | ||
| 63020 | 63020 | 178940 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 231 Craut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004061.97855 | 2093834.65882 | 37.729501322606 | -122.428240459522 | (37.729501322606, -122.428240459522) | |||
| 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) | ||
| 90463 | 90463 | 37879 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 591 Flood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40158 | 5996748.50508252 | 2094082.2355121998 | 37.7297645826714 | -122.45354159093701 | (37.7297645826714, -122.453541590937) | ||
| 119096 | 119096 | 36426 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 301 Montecito Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39338 | 5996108.64471019 | 2094137.0690645 | 37.729878441846104 | -122.455757608246 | (37.7298784418461, -122.455757608246) | |||
| 119894 | 119894 | 36423 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Montecito Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39337 | 5996091.95170793 | 2094186.31684288 | 37.7300127063789 | -122.455818876187 | (37.7300127063789, -122.455818876187) | |||
| 171955 | 171955 | 96275 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 55@ Alemany Trumbull St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6003967.5577300005 | 2094330.4049099998 | 37.73085718729 | -122.428602205549 | (37.73085718729, -122.428602205549) | ||||
| 115915 | 115915 | 40512 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 445 Darien Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41576 | 5992747.41981015 | 2094935.12337926 | 37.7318762282888 | -122.46743566386299 | (37.7318762282888, -122.467435663863) | ||
| 77100 | 77100 | 214458 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001469.66795 | 2094911.1287900002 | 37.73231004206529 | -122.437279364672 | (37.7323100420653, -122.437279364672) | |||
| 46200 | 46200 | 214462 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 139 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6000481.8425900005 | 2095189.9969400002 | 37.7330195442146 | -122.440714490676 | (37.7330195442146, -122.440714490676) | |||
| 93484 | 93484 | 42563 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 201 San Benito Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42649 | 5992910.18577839 | 2095362.95085697 | 37.7330603317539 | -122.46690404336 | (37.7330603317539, -122.46690404336) | ||
| 38906 | 38906 | 237981 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 100 Rousseau St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003493.73736 | 2095146.1048599998 | 37.7330700888164 | -122.43029845283002 | (37.7330700888164, -122.43029845283) | |||
| 140278 | 140278 | 116700 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1X CARRIE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6002805.0 | 2095529.0 | 37.734082395521895 | -122.43270694044399 | (37.7340823955219, -122.432706940444) | ||||
| 12500 | 12500 | 92318 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985842.0312 | 2096446.1793 | 37.7356241060746 | -122.49141988222999 | (37.7356241060746, -122.49141988223) | |
| 84406 | 84406 | 122604 | Prunus serrulata :: Ornamental Cherry 35 | 132 Surrey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779127 | 6002205.30607 | 2096205.3193700002 | 37.7359053840536 | -122.434828615692 | (37.7359053840536, -122.434828615692) | ||
| 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) | |||
| 132824 | 132824 | 237988 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 114 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005544.33972 | 2096386.4343299998 | 37.736591695453896 | -122.42329710838001 | (37.7365916954539, -122.42329710838) | |||
| 116072 | 116072 | 43862 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2345 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43481 | 5985730.68059538 | 2097009.14058612 | 37.7371633406591 | -122.491846290454 | (37.7371633406591, -122.491846290454) | ||
| 54862 | 54862 | 183412 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2350 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5985653.7417 | 2097035.0769 | 37.7372300576086 | -122.492114208587 | (37.7372300576086, -122.492114208587) | |||
| 82968 | 82968 | 43831 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2690 35th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | Permit Number 43458 | 5985573.35768067 | 2097037.8388718998 | 37.737232941963605 | -122.492392332362 | (37.7372329419636, -122.492392332362) | ||
| 48024 | 48024 | 183421 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1214 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989156.9564 | 2096994.6461 | 37.7373232077722 | -122.47999917002701 | (37.7373232077722, -122.479999170027) | |||
| 85911 | 85911 | 47714 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Bemis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | ||
| 178587 | 178587 | 183559 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1616 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987905.5766 | 2097633.8663 | 37.7390055533414 | -122.484372584152 | (37.7390055533414, -122.484372584152) | |||
| 39866 | 39866 | 182572 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2212 Ulloa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989118.5154 | 2098355.8518 | 37.7410584915124 | -122.48023167480301 | (37.7410584915124, -122.480231674803) | |||
| 96807 | 96807 | 48495 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 688(REVISED) Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45836 | 6008651.5358149 | 2098064.55146278 | 37.7413743105027 | -122.412672757895 | (37.7413743105027, -122.412672757895) | |||
| 43582 | 43582 | 214394 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 191 Granville Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5994343.40984 | 2098666.78046 | 37.742214445742896 | -122.46218856725201 | (37.7422144457429, -122.462188567252) | |||
| 77549 | 77549 | 36014 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 97 Winfield St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1998 12:00:00 AM | Permit Number 39160 | 6007176.510261099 | 2098875.10334415 | 37.743517008192796 | -122.41783033575001 | (37.7435170081928, -122.41783033575) | |||
| 104740 | 104740 | 42036 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42358 | 6004596.89230657 | 2098983.86286022 | 37.7436701266667 | -122.42675775960501 | (37.7436701266667, -122.426757759605) | |||
| 173783 | 173783 | 214446 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 500 Magellan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993157.34712 | 2099454.9185599997 | 37.744310110719205 | -122.46634683724 | (37.7443101107192, -122.46634683724) | |||
| 126193 | 126193 | 50547 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 60 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180.0 | 2099188.0 | 37.74432002092679 | -122.421298240567 | (37.7443200209268, -122.421298240567) | |||
| 83883 | 83883 | 50539 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 199 Tiffany Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006096.0 | 2099195.0 | 37.744334505185705 | -122.421589192303 | (37.7443345051857, -122.421589192303) | |||
| 141416 | 141416 | 11200 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 186 Idora Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5995344.6608195 | 2099448.7962231003 | 37.74441926622529 | -122.45878317784799 | (37.7444192662253, -122.458783177848) | |||
| 52716 | 52716 | 92396 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2290 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52799 | 5985787.3792 | 2099657.153 | 37.7444373876676 | -122.491845148303 | (37.7444373876676, -122.491845148303) |
| 32181 | 32181 | 214447 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 265 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993364.21414 | 2099688.46118 | 37.7449632937192 | -122.465648504685 | (37.7449632937192, -122.465648504685) | |||
| 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) | ||
| 121025 | 121025 | 111845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1550 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | ||
| 153974 | 153974 | 214453 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 195 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994424.22111 | 2100746.43892 | 37.7479293180792 | -122.462059929142 | (37.7479293180792, -122.462059929142) | |||
| 107585 | 107585 | 45063 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2101 27th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2001 12:00:00 AM | Permit Number 43947 | 5987870.53797958 | 2100985.88306806 | 37.748207264307496 | -122.484739557427 | (37.7482072643075, -122.484739557427) | |||
| 80303 | 80303 | 42522 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 688 Clipper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | Permit Number 42635 | 6000743.4333065 | 2100900.95079718 | 37.748715370273 | -122.44021950385 | (37.748715370273, -122.44021950385) | |||
| 158937 | 158937 | 214443 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 720 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991170.54389 | 2101147.50148 | 37.7488426659675 | -122.473340138153 | (37.7488426659675, -122.473340138153) | |||
| 143514 | 143514 | 4029 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2150 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.955900401 | 2100994.1740901 | 37.749640248492604 | -122.39916376626199 | (37.7496402484926, -122.399163766262) | ||
| 121773 | 121773 | 4025 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1900 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/25/2015 03:01:00 PM | 3 | 3X3 | 6013444.007912099 | 2101040.051797 | 37.7498122193832 | -122.39631044368099 | (37.7498122193832, -122.396310443681) | ||
| 83929 | 83929 | 27750 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1299 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | ||
| 34860 | 34860 | 237993 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 480 Jersey St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6001987.72906 | 2101502.95079 | 37.7504390831161 | -122.43595981461701 | (37.7504390831161, -122.435959814617) | |||
| 100849 | 100849 | 41304 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1387 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2000 12:00:00 AM | Permit Number 41977 | 6006476.01966821 | 2101521.23564445 | 37.7507432410359 | -122.420440247305 | (37.7507432410359, -122.420440247305) | |||
| 115038 | 115038 | 116014 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 469 PACHECO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 5993702.0 | 2101802.0 | 37.7507860118971 | -122.464633955158 | (37.7507860118971, -122.464633955158) | ||||
| 38483 | 38483 | 237995 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4120 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002335.689069999 | 2101815.5144 | 37.751317069626204 | -122.434778894126 | (37.7513170696262, -122.434778894126) | |||
| 112820 | 112820 | 121653 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 306 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993098.0 | 2103247.0 | 37.7547187703987 | -122.466827655897 | (37.7547187703987, -122.466827655897) | ||||
| 100074 | 100074 | 43904 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) |
| 121592 | 121592 | 37267 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 910 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | ||
| 40255 | 40255 | 51768 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52851 | 5982945.3427 | 2104265.0097 | 37.756922756494106 | -122.50201305526699 | (37.7569227564941, -122.502013055267) |
| 61059 | 61059 | 182221 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2830 Lawton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985427.0921 | 2104352.0968 | 37.7573073554199 | -122.493436776332 | (37.7573073554199, -122.493436776332) | |||
| 123189 | 123189 | 37285 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 699 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39818 | 6002432.10165251 | 2104152.77929012 | 37.757740114019 | -122.434612596377 | (37.757740114019, -122.434612596377) | |||
| 127304 | 127304 | 39161 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 301x Cumberland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40829 | 6003629.0 | 2104450.0 | 37.758624085440104 | -122.43049443639099 | (37.7586240854401, -122.430494436391) | ||
| 141980 | 141980 | 37295 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 286 Cumberland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39824 | 6003747.0165405 | 2104527.26651018 | 37.758842925599396 | -122.430091793701 | (37.7588429255994, -122.430091793701) | ||
| 77745 | 77745 | 109408 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 185 BELGRAVE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2015 12:00:00 AM | 3 | 3x3 | 5997621.5 | 2104846.8 | 37.759371453278206 | -122.45129961243099 | (37.7593714532782, -122.451299612431) | ||
| 97850 | 97850 | 97824 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 595X Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6002402.0 | 2104748.0 | 37.7593727378271 | -122.434759263601 | (37.7593727378271, -122.434759263601) | |||
| 107704 | 107704 | 37692 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 562 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | Permit Number 40078 | 6007845.87669797 | 2104655.5935128 | 37.759426574444106 | -122.415925080154 | (37.7594265744441, -122.415925080154) | ||
| 143410 | 143410 | 41856 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1001 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | ||
| 121128 | 121128 | 39754 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 183 Hancock St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41121 | 6003118.27900273 | 2105026.07032459 | 37.7601768917443 | -122.432301882241 | (37.7601768917443, -122.432301882241) | ||
| 105211 | 105211 | 84787 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 300 Corbett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | Permit No. 49308 | 5999615.8 | 2105217.4 | 37.76050301831479 | -122.444429006349 | (37.7605030183148, -122.444429006349) | |||
| 37082 | 37082 | 182550 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1408 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986517.6568 | 2105641.9803 | 37.760912753017394 | -122.48976008582899 | (37.7609127530174, -122.489760085829) | |||
| 44471 | 44471 | 182556 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2535 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986624.9706 | 2105696.7397 | 37.7610693723866 | -122.48939296609501 | (37.7610693723866, -122.489392966095) | |||
| 151338 | 151338 | 182066 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1383 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988020.5944 | 2105839.0631 | 37.761541526107 | -122.48457660662399 | (37.761541526107, -122.484576606624) | |||
| 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) | |
| 105582 | 105582 | 44167 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Sycamore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2000 12:00:00 AM | Permit Number 43637 | 6006615.48283376 | 2105833.54152838 | 37.762591694443294 | -122.420263998944 | (37.7625916944433, -122.420263998944) | |||
| 94182 | 94182 | 117166 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 11039 | 11039 | 86373 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1309 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988001.1147 | 2106356.358 | 37.7629607421046 | -122.484681925407 | (37.7629607421046, -122.484681925407) | ||
| 102813 | 102813 | 35300 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3459 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/1998 12:00:00 AM | Permit Number 38773 | 6005812.46547868 | 2106053.59345559 | 37.763150623964 | -122.423056990755 | (37.763150623964, -122.423056990755) | |||
| 141926 | 141926 | 40944 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88209 Hoff St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1999 12:00:00 AM | Permit Number 41805 | 6006542.66951499 | 2106194.13608518 | 37.76357769940321 | -122.42054143219102 | (37.7635776994032, -122.420541432191) | |||
| 157232 | 157232 | 238013 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 77 Ashbury Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999618.479619999 | 2106729.8577400004 | 37.764656004003 | -122.44452844265899 | (37.764656004003, -122.444528442659) | |||
| 131720 | 131720 | 238018 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Ashbury Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5999581.71277 | 2106854.10087 | 37.7649950466081 | -122.444664539759 | (37.7649950466081, -122.444664539759) |
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");