Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4542 | 4542 | 214731 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1999 12:00:00 AM | 8 | Width 2ft | Permit Number 41499 | 5994889.57203 | 2092796.33348 | 37.7261270689877 | -122.459874973176 | (37.7261270689877, -122.459874973176) | |
| 4558 | 4558 | 142520 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 7 | Width 0ft | 6009467.3323 | 2121175.1455 | 37.8048763586912 | -122.411484377145 | (37.8048763586912, -122.411484377145) | |||
| 4600 | 4600 | 103784 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006741.56415 | 2115141.24736 | 37.788155522905505 | -122.420488644345 | (37.7881555229055, -122.420488644345) | ||
| 4605 | 4605 | 142542 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | Width 0ft | 6009433.8643 | 2121170.962 | 37.8048629945672 | -122.411599901453 | (37.8048629945672, -122.411599901453) | |||
| 4611 | 4611 | 142519 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | Width 0ft | 6009452.9889 | 2121171.5596 | 37.804865708173104 | -122.411533760714 | (37.8048657081731, -122.411533760714) | |||
| 4622 | 4622 | 142543 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | Width 0ft | 6009503.7886 | 2121178.1337 | 37.8048866083098 | -122.411358426924 | (37.8048866083098, -122.411358426924) | |||
| 4696 | 4696 | 236340 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 60 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1993 12:00:00 AM | 11 | Width 3ft | Permit Number 31569 | 6005504.459869999 | 2099359.7250599996 | 37.7447534297269 | -122.423646325024 | (37.7447534297269, -122.423646325024) | |
| 4704 | 4704 | 253666 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 578 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5993791.71774 | 2111566.05198 | 37.7776007134003 | -122.465032776868 | (37.7776007134003, -122.465032776868) | ||||
| 4731 | 4731 | 237544 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 7x8 | 6003442.2831 | 2105633.6495 | 37.76186352451221 | -122.43122467539801 | (37.7618635245122, -122.431224675398) | |||
| 4753 | 4753 | 98088 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007178.15894 | 2115574.08384 | 37.7893685797349 | -122.41900880992901 | (37.7893685797349, -122.419008809929) | ||
| 4757 | 4757 | 179682 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 501X San Juan Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6000425.2781 | 2092808.87665 | 37.726478317196204 | -122.44073930839 | (37.7264783171962, -122.44073930839) | |||
| 4797 | 4797 | 214559 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1342 Irving St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | Width 3ft | 5991532.56497 | 2106606.32246 | 37.7638521099028 | -122.472486197695 | (37.7638521099028, -122.472486197695) | ||
| 4821 | 4821 | 214558 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1340 Irving St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 4 | Width 3ft | 5991564.93185 | 2106609.34919 | 37.7638622938456 | -122.472374472204 | (37.7638622938456, -122.472374472204) | ||
| 4841 | 4841 | 88280 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3261 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778851 | 5999200.48769 | 2115630.5359099996 | 37.789071121774796 | -122.446614594592 | (37.7890711217748, -122.446614594592) | |
| 4845 | 4845 | 38140 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 423 Burrows St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | 2 | Permit Number 40297 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | |
| 4846 | 4846 | 76677 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 423 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 3 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
| 4918 | 4918 | 43245 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 150 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 9 | Permit Number 43034 | 6010460.0 | 2093774.0 | 37.729694705520004 | -122.40611748494 | (37.72969470552, -122.40611748494) | |
| 5189 | 5189 | 50319 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 207 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Permit Number 780459 | 5994858.57459 | 2113511.06459 | 37.7830026560888 | -122.461483229537 | (37.7830026560888, -122.461483229537) | ||
| 5249 | 5249 | 243309 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 780 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6007491.9091300005 | 2105126.68883 | 37.760700186689796 | -122.41718265916799 | (37.7607001866898, -122.417182659168) | |||
| 5254 | 5254 | 253839 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 94 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6006239.0 | 2097690.0 | 37.740210176126794 | -122.42098789234 | (37.7402101761268, -122.42098789234) | ||||
| 5269 | 5269 | 8090 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 762 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004349.2473 | 2111557.1689 | 37.7781794280627 | -122.428510082803 | (37.7781794280627, -122.428510082803) | ||
| 5302 | 5302 | 35167 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1998 12:00:00 AM | Permit Number 38700 | ||||||||
| 5325 | 5325 | 40088 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1999 12:00:00 AM | Permit Number 41311 | |||||||||
| 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) | |||
| 5336 | 5336 | 2470 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1875 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/1998 12:00:00 AM | 7 | 5x5 | 6003922.7717 | 2114866.5529 | 37.787242026635 | -122.43022157640499 | (37.787242026635, -122.430221576405) | ||
| 5350 | 5350 | 28646 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003557.7645 | 2114374.9896 | 37.7858716371659 | -122.431449317827 | (37.7858716371659, -122.431449317827) | |||
| 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 | ||||||||
| 5453 | 5453 | 21659 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1750 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2015 12:00:00 AM | 3 | 4X4 | Permit Number 774105 | 6004291.1629 | 2114663.74 | 37.786706012119296 | -122.428932556586 | (37.7867060121193, -122.428932556586) | |
| 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) | ||
| 5481 | 5481 | 103804 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Hemlock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006974.73956 | 2114845.21209 | 37.7873558205593 | -122.419660883156 | (37.7873558205593, -122.419660883156) | ||
| 5494 | 5494 | 87738 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005444.64461 | 2121623.98788 | 37.8058823097966 | -122.425437295217 | (37.8058823097966, -122.425437295217) | ||
| 5495 | 5495 | 21662 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1750 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2015 12:00:00 AM | 3 | 4X4 | Permit Number 774105 | 6004219.9241 | 2114651.242 | 37.7866676632245 | -122.42917813434201 | (37.7866676632245, -122.429178134342) | |
| 5518 | 5518 | 39334 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 5536 | 5536 | 8091 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 762 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004317.1512 | 2111553.1108 | 37.7781664691559 | -122.42862082556499 | (37.7781664691559, -122.428620825565) | ||
| 5542 | 5542 | 8104 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 780 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004088.9733 | 2111516.0342 | 37.7780517500412 | -122.429407531137 | (37.7780517500412, -122.429407531137) | ||
| 5597 | 5597 | 109327 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 1868 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2015 12:00:00 AM | 3 | Permit Number 774911 | 6003963.48635 | 2119408.0409999997 | 37.7997140999836 | -122.430404865987 | (37.7997140999836, -122.430404865987) | ||
| 5618 | 5618 | 87403 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 10 | 3x3 | 6003687.1999 | 2113392.3659 | 37.7831809343135 | -122.430931353807 | (37.7831809343135, -122.430931353807) | ||
| 5641 | 5641 | 7950 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1735 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 3 | 3X3 | 6005696.54994 | 2116082.67925 | 37.7906815134801 | -122.424171198144 | (37.7906815134801, -122.424171198144) | ||
| 5717 | 5717 | 115706 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3055 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5999536.24333 | 2116655.51656 | 37.7919046220513 | -122.445526661347 | (37.7919046220513, -122.445526661347) | |||
| 5746 | 5746 | 31847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 5843 | 5843 | 8073 | DPW Maintained 3 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 664 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6004507.0606 | 2111574.6856 | 37.77823645397079 | -122.42796539753 | (37.7782364539708, -122.42796539753) | |||
| 5916 | 5916 | 12892 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 255X Larch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 3 | 3X3 | 6006398.20739 | 2113019.98592 | 37.7823117048675 | -122.421525889114 | (37.7823117048675, -122.421525889114) | ||
| 5957 | 5957 | 28643 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 20 | 6003700.2631 | 2113325.6745 | 37.7829985565916 | -122.43088139933201 | (37.7829985565916, -122.430881399332) | |||
| 5965 | 5965 | 32283 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2242 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768378 | 6002362.300419999 | 2115970.86289 | 37.7901856704892 | -122.435699503149 | (37.7901856704892, -122.435699503149) | |
| 5979 | 5979 | 98098 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 81 Frank Norris St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006897.32558 | 2115510.94052 | 37.789179385771604 | -122.41997598040399 | (37.7891793857716, -122.419975980404) | |||
| 5993 | 5993 | 23902 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 20 | 6003560.0188 | 2114334.411 | 37.7857603463241 | -122.431438620741 | (37.7857603463241, -122.431438620741) | |||
| 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) | ||
| 6090 | 6090 | 105252 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1875 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770851 | 6004061.8803 | 2118683.0933 | 37.7977291534815 | -122.43001264475201 | (37.7977291534815, -122.430012644752) | ||||
| 6091 | 6091 | 34255 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2280 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 6x4 | Permit Number 779106 | 6002701.36974 | 2117843.10011 | 37.7953456053627 | -122.43466028347099 | (37.7953456053627, -122.434660283471) | |
| 6107 | 6107 | 110275 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2612 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2016 12:00:00 AM | 3 | Permit Number 778382 | 6001183.56283 | 2117454.33561 | 37.794191876798 | -122.43988424377 | (37.794191876798, -122.43988424377) | ||
| 6267 | 6267 | 17356 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2200 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005536.16539 | 2117610.65272 | 37.794867887291396 | -122.424834871756 | (37.7948678872914, -122.424834871756) | |||
| 6273 | 6273 | 106722 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2905 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5999550.4676 | 2114295.9601 | 37.7854267102234 | -122.44530771900499 | (37.7854267102234, -122.445307719005) | |||
| 6354 | 6354 | 98096 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 81 Frank Norris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006843.26628 | 2115504.44745 | 37.789158511592 | -122.420162558272 | (37.789158511592, -122.420162558272) | |||
| 6439 | 6439 | 2463 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1826 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/1997 12:00:00 AM | 3 | 4X4 | 6003987.7732 | 2114755.2881 | 37.7869402029829 | -122.429988745219 | (37.7869402029829, -122.429988745219) | ||
| 6475 | 6475 | 23884 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1750X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6003258.4682 | 2113929.8349 | 37.7846323872704 | -122.432452992684 | (37.7846323872704, -122.432452992684) | |||
| 6496 | 6496 | 23490 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2500X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005777.87956 | 2119177.1307599996 | 37.799182688783496 | -122.424109961515 | (37.7991826887835, -122.424109961515) | |||
| 6501 | 6501 | 103875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006702.4202 | 2115509.69435 | 37.7891649813311 | -122.42065024171002 | (37.7891649813311, -122.42065024171) | ||
| 6513 | 6513 | 2467 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1848 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1989 12:00:00 AM | 12 | 4X4 | 6003976.525 | 2114838.4 | 37.7871677703016 | -122.430033592456 | (37.7871677703016, -122.430033592456) | ||
| 6573 | 6573 | 19697 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY9 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
| 6599 | 6599 | 2653 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1971 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1992 12:00:00 AM | 3 | 4X4 | 6004104.0049 | 2114930.2605 | 37.78742721503939 | -122.42959909363199 | (37.7874272150394, -122.429599093632) | ||
| 6617 | 6617 | 103761 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006685.575019999 | 2115508.13748 | 37.7891597571573 | -122.42070841348101 | (37.7891597571573, -122.420708413481) | ||
| 6734 | 6734 | 96373 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1315 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008912.46348 | 2117456.9297 | 37.7946359224745 | -122.41314148629499 | (37.7946359224745, -122.413141486295) | |
| 6740 | 6740 | 39332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 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) | ||
| 6792 | 6792 | 23871 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1499X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003600.3539 | 2113692.9201 | 37.784001259600295 | -122.43125326646499 | (37.7840012596003, -122.431253266465) | |||
| 6793 | 6793 | 106875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2014 12:00:00 AM | 9 | 3x3 | Permit Number 772880 | 5999376.012619999 | 2115702.7008599997 | 37.7892792923525 | -122.446012495778 | (37.7892792923525, -122.446012495778) | |
| 6845 | 6845 | 88234 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 301 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51223 | 6000216.1332 | 2109974.0504 | 37.77359782768 | -122.442694284612 | (37.77359782768, -122.442694284612) | |
| 6855 | 6855 | 30870 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1922 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2013 12:00:00 AM | 22 | 3x3 | Permit Number 770521 | 6001989.3306 | 2115172.0478 | 37.787971137606895 | -122.436932736614 | (37.7879711376069, -122.436932736614) | |
| 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) | ||
| 6896 | 6896 | 2469 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1875 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/1998 12:00:00 AM | 7 | 5x5 | 6003922.3005 | 2114887.2882 | 37.7872989338532 | -122.43022468652201 | (37.7872989338532, -122.430224686522) | ||
| 6904 | 6904 | 12893 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 255X Larch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 3 | 3X3 | 6006421.0816 | 2113018.78056 | 37.7823096849762 | -122.421446668727 | (37.7823096849762, -122.421446668727) | ||
| 6925 | 6925 | 2462 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1826 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1998 12:00:00 AM | 3 | 4X4 | 6003992.7724 | 2114732.7916 | 37.78687871637621 | -122.429969843785 | (37.7868787163762, -122.429969843785) | ||
| 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) | |||
| 6991 | 6991 | 103876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006716.01893 | 2115511.31786 | 37.7891702054911 | -122.420603306998 | (37.7891702054911, -122.420603306998) | ||
| 7045 | 7045 | 117250 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 2474 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773044 | 6001780.62325 | 2117368.05955 | 37.7939889537763 | -122.437812170719 | (37.7939889537763, -122.437812170719) | |
| 7047 | 7047 | 71287 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 225 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/16/1982 12:00:00 AM | 6 | 5998480.7052 | 2112368.9268 | 37.780074457240794 | -122.448869905513 | (37.7800744572408, -122.448869905513) | ||
| 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) | ||
| 7067 | 7067 | 28641 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 20 | 6003709.2011 | 2113267.9212 | 37.7828404869024 | -122.43084635463 | (37.7828404869024, -122.43084635463) | |||
| 7138 | 7138 | 29119 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 509 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6008381.9659 | 2113792.89597 | 37.7845455839642 | -122.414717657915 | (37.7845455839642, -122.414717657915) | ||
| 7194 | 7194 | 106948 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2710 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2014 12:00:00 AM | 1 | 3x3 | 5999606.41459 | 2118186.75395 | 37.7961130004661 | -122.445394018543 | (37.7961130004661, -122.445394018543) | ||
| 7207 | 7207 | 116159 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2660 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x5 | Permit Number 777886 | 6000321.54837 | 2117859.43879 | 37.795255076905704 | -122.442896004055 | (37.7952550769057, -122.442896004055) | |
| 7213 | 7213 | 105719 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2317 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775548 | 6003614.61217 | 2116568.84347 | 37.791898625373705 | -122.43140930798799 | (37.7918986253737, -122.431409307988) | |
| 7256 | 7256 | 71253 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1436 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 10 | 3x3 | 6007270.15279 | 2117448.61656 | 37.7945207624857 | -122.418823519012 | (37.7945207624857, -122.418823519012) | |
| 7289 | 7289 | 111196 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2317 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2015 12:00:00 AM | 3 | Permit Number 775548 | 6003599.3502400005 | 2116566.69152 | 37.7918918516902 | -122.43146196059601 | (37.7918918516902, -122.431461960596) | ||
| 7293 | 7293 | 31848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 7324 | 7324 | 114856 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1416x Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2016 12:00:00 AM | 3 | 3x3 | 6006677.767419999 | 2115342.38606 | 37.7887042046809 | -122.42072365519199 | (37.7887042046809, -122.420723655192) | ||
| 7328 | 7328 | 18943 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2799X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769995 | 6001475.92192 | 2115618.2324 | 37.7891670515542 | -122.438741019305 | (37.7891670515542, -122.438741019305) | |
| 7387 | 7387 | 98089 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007160.90241 | 2115572.1732 | 37.789362361841505 | -122.41906838009899 | (37.7893623618415, -122.419068380099) | ||
| 7408 | 7408 | 19027 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 3170 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 5999630.40201 | 2115407.06556 | 37.7884820784247 | -122.44511107923 | (37.7884820784247, -122.44511107923) | |||
| 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) | |||
| 7475 | 7475 | 28644 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003694.7628 | 2113348.3634 | 37.7830605429851 | -122.430902047868 | (37.7830605429851, -122.430902047868) | ||
| 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) | ||
| 7527 | 7527 | 20039 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 7538 | 7538 | 2644 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1911 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6004293.9749 | 2114957.7562 | 37.787513465908496 | -122.42894379742201 | (37.7875134659085, -122.428943797422) | |||
| 7584 | 7584 | 38094 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2624 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 6 | Permit Number 778879 | 5999853.7645 | 2114048.6642 | 37.7847650081627 | -122.444240628643 | (37.7847650081627, -122.444240628643) | |
| 7618 | 7618 | 2643 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1911 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6004268.353999999 | 2114955.8815 | 37.7875068682146 | -122.429032306872 | (37.7875068682146, -122.429032306872) | |||
| 7637 | 7637 | 36881 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2515 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002658.18112 | 2116991.83839 | 37.7930058086339 | -122.434748819925 | (37.7930058086339, -122.434748819925) | |
| 7650 | 7650 | 88367 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772880 | 5999340.32482 | 2115698.11509 | 37.7892646630799 | -122.44613564087099 | (37.7892646630799, -122.446135640871) | |
| 7662 | 7662 | 88451 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/07/2008 12:00:00 AM | 3 | 5x12 | 6005480.84439 | 2121378.35155 | 37.805209901088396 | -122.425294529632 | (37.8052099010884, -122.425294529632) | ||
| 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) |
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");