Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36563 | 36563 | 202259 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1 Kalmanovitz St | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6013218.01399 | 2093376.8881599999 | 37.7287581966316 | -122.396554840154 | (37.7287581966316, -122.396554840154) | ||||
| 153474 | 153474 | 196471 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Middle Point Rd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6018269.46967 | 2096338.3756 | 37.7371696942217 | -122.379297066815 | (37.7371696942217, -122.379297066815) | |||
| 186399 | 186399 | 202168 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Kalmanovitz St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6013157.76295 | 2093232.82928 | 37.728359287049706 | -122.396753038148 | (37.7283592870497, -122.396753038148) | |||
| 60810 | 60810 | 215238 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 100 De Montfort Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995012.54401 | 2091916.70112 | 37.723718881496296 | -122.45938619431601 | (37.7237188814963, -122.459386194316) | |||
| 177454 | 177454 | 215237 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 100 De Montfort Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995021.72102 | 2091916.5089599998 | 37.7237188815105 | -122.45935445725901 | (37.7237188815105, -122.459354457259) | |||
| 132913 | 132913 | 215229 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 100 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6000677.32217 | 2094383.25488 | 37.7308155477923 | -122.439980842666 | (37.7308155477923, -122.439980842666) | |||
| 60094 | 60094 | 178818 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Ina Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6004783.72135 | 2091297.0719 | 37.722574479812 | -122.42556479298099 | (37.722574479812, -122.425564792981) | ||||
| 77900 | 77900 | 99712 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 90054 | 90054 | 99710 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 101806 | 101806 | 99709 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 113083 | 113083 | 99708 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 139212 | 139212 | 99711 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 180204 | 180204 | 201503 | Undocumented 2 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 1001 Innes Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6018539.45605 | 2094929.8909099998 | 37.7333171568604 | -122.378265839401 | (37.7333171568604, -122.378265839401) | ||||
| 114167 | 114167 | 99706 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100@Moncada Paloma Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 119703 | 119703 | 99707 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100@Moncada Paloma Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 34028 | 34028 | 213114 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 102 Omar Way | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998118.31509 | 2097542.20212 | 37.7393432548731 | -122.449055178356 | (37.7393432548731, -122.449055178356) | |||
| 49846 | 49846 | 213113 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 102 Omar Way | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998111.37586 | 2097542.73119 | 37.7393443106943 | -122.44907920913299 | (37.7393443106943, -122.449079209133) | |||
| 182842 | 182842 | 213112 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 102 Omar Way | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998102.48269 | 2097542.14739 | 37.73934219908271 | -122.449109915589 | (37.7393421990827, -122.449109915589) | |||
| 56418 | 56418 | 179719 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1021 Excelsior Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6004873.15059 | 2091207.68365 | 37.7223340919162 | -122.425249298216 | (37.7223340919162, -122.425249298216) | |||
| 88581 | 88581 | 94959 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1059 Evans Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/09/2010 12:00:00 AM | 6018613.9 | 2096078.3 | 37.7364745658864 | -122.37808815314199 | (37.7364745658864, -122.378088153142) | ||||
| 135885 | 135885 | 213118 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 107 Bella Vista Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998502.70249 | 2097027.05983 | 37.7379507743002 | -122.447689068603 | (37.7379507743002, -122.447689068603) | |||
| 178988 | 178988 | 213117 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 107 Bella Vista Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998491.69909 | 2097031.0960900001 | 37.737961228022 | -122.447727403094 | (37.737961228022, -122.447727403094) | |||
| 40064 | 40064 | 136617 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1075 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6006167.26583 | 2120699.80075 | 37.803385530067104 | -122.422870825248 | (37.8033855300671, -122.422870825248) | |||
| 176380 | 176380 | 136618 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1075 Francisco St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 6006192.108580001 | 2120703.43748 | 37.8033969172965 | -122.422785114443 | (37.8033969172965, -122.422785114443) | |||
| 146341 | 146341 | 131075 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 110 Cherry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5996123.96932 | 2115807.18448 | 37.7893799372718 | -122.45727167056101 | (37.7893799372718, -122.457271670561) | |||
| 172547 | 172547 | 131074 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 110 Cherry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5996123.3175099995 | 2115792.2897200002 | 37.7893390028406 | -122.45727284778 | (37.7893390028406, -122.45727284778) | |||
| 63588 | 63588 | 215230 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 110 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6000656.28267 | 2094383.33572 | 37.73081457202571 | -122.440053585198 | (37.7308145720257, -122.440053585198) | |||
| 65931 | 65931 | 179698 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1100 Felton St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6007685.78297 | 2092932.61475 | 37.72722888148479 | -122.415648730527 | (37.7272288814848, -122.415648730527) | |||
| 68806 | 68806 | 179697 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1100 Felton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6007690.32077 | 2092934.09301 | 37.72723319555121 | -122.41563314795799 | (37.7272331955512, -122.415633147958) | |||
| 156902 | 156902 | 179699 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1100 Felton St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6007650.85932 | 2092922.1083099998 | 37.7271980698357 | -122.415768718069 | (37.7271980698357, -122.415768718069) | |||
| 167636 | 167636 | 179700 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1100 Felton St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6007647.45718 | 2092921.0555200002 | 37.7271949878437 | -122.415780404758 | (37.7271949878437, -122.415780404758) | |||
| 42366 | 42366 | 179640 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1101 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6000461.77381 | 2090733.0608700002 | 37.7207806794643 | -122.440464330785 | (37.7207806794643, -122.440464330785) | |||
| 44474 | 44474 | 179641 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1101 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6000468.15764 | 2090746.71388 | 37.72081853103 | -122.440443242589 | (37.72081853103, -122.440443242589) | |||
| 157238 | 157238 | 136626 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1120 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6006933.58689 | 2120186.44007 | 37.8020191811091 | -122.420182480954 | (37.8020191811091, -122.420182480954) | |||
| 158879 | 158879 | 136624 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1120 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6006955.61886 | 2120188.67307 | 37.802026553733505 | -122.42010639828999 | (37.8020265537335, -122.42010639829) | |||
| 173603 | 173603 | 136625 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1120 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6006949.37366 | 2120187.56184 | 37.8020231507021 | -122.42012793078301 | (37.8020231507021, -122.420127930783) | |||
| 181666 | 181666 | 136627 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1120 Lombard St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6006926.939809999 | 2120185.95678 | 37.802017479583604 | -122.42020544873199 | (37.8020174795836, -122.420205448732) | |||
| 153489 | 153489 | 178740 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1127 Bowdoin St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6009628.53589 | 2090952.70997 | 37.7219014946373 | -122.408792994404 | (37.7219014946373, -122.408792994404) | |||
| 133064 | 133064 | 178900 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1128 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6009581.67769 | 2090926.3916900002 | 37.721826605402 | -122.40895311598699 | (37.721826605402, -122.408953115987) | |||
| 33407 | 33407 | 179702 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1142 Silliman St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6007383.5399400005 | 2093322.51563 | 37.7282824705509 | -122.41672119542801 | (37.7282824705509, -122.416721195428) | |||
| 44884 | 44884 | 179703 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1142 Silliman St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6007376.619519999 | 2093319.2452 | 37.7282731014193 | -122.41674488808 | (37.7282731014193, -122.41674488808) | |||
| 132682 | 132682 | 179701 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1142 Silliman St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6007388.41851 | 2093322.9544799998 | 37.72828394992929 | -122.416704361037 | (37.7282839499293, -122.416704361037) | |||
| 134436 | 134436 | 136614 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1146 Leavenworth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6008130.2397300005 | 2116469.59662 | 37.7918810049628 | -122.41577814565599 | (37.7918810049628, -122.415778145656) | |||
| 128 | 128 | 212622 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 115 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991392.0 | 2089980.0 | 37.718192344870296 | -122.471760605115 | (37.7181923448703, -122.471760605115) | |||
| 76941 | 76941 | 236972 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 115 Eugenia Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6006377.9227 | 2098202.61198 | 37.741625523788706 | -122.420543931068 | (37.7416255237887, -122.420543931068) | |||
| 175560 | 175560 | 214826 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5999324.23026 | 2093457.23325 | 37.728195788502795 | -122.444592150628 | (37.7281957885028, -122.444592150628) | |||
| 66183 | 66183 | 136615 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1152 Leavenworth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6008127.502669999 | 2116494.06688 | 37.791948040417296 | -122.41578934939501 | (37.7919480404173, -122.415789349395) | |||
| 43904 | 43904 | 135809 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1154 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6006309.30935 | 2120436.0273599997 | 37.8026692893277 | -122.422360524716 | (37.8026692893277, -122.422360524716) | |||
| 176542 | 176542 | 135906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1178 Greenwich St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6007265.472680001 | 2119876.0558700003 | 37.8011856390751 | -122.41901196834 | (37.8011856390751, -122.41901196834) | |||
| 57868 | 57868 | 179677 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1179 Alemany Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6003439.247769999 | 2094263.0787799999 | 37.730642412119295 | -122.43042385610201 | (37.7306424121193, -122.430423856102) | |||
| 166130 | 166130 | 238535 | Undocumented 2 | Prunus spp :: Cherry 84 | 118 Saint Marys Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6003941.15849 | 2095961.17353 | 37.735333416189206 | -122.42880968543899 | (37.7353334161892, -122.428809685439) | |||
| 25245 | 25245 | 179675 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1183 Alemany Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6003399.47661 | 2094250.7820700002 | 37.7306063951513 | -122.430560473899 | (37.7306063951513, -122.430560473899) | |||
| 77259 | 77259 | 179676 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1183 Alemany Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6003413.3537 | 2094255.0048599998 | 37.7306187761143 | -122.430512799925 | (37.7306187761143, -122.430512799925) | |||
| 64919 | 64919 | 212620 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 119 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5991404.09674 | 2089992.6496299999 | 37.7182277775561 | -122.47171971359501 | (37.7182277775561, -122.471719713595) | |||
| 54456 | 54456 | 130524 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 120 Cherry St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5996140.15322 | 2115718.74961 | 37.789138048438794 | -122.45720927651199 | (37.7891380484388, -122.457209276512) | |||
| 57093 | 57093 | 125606 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 120 Cherry St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5996136.29839 | 2115745.93668 | 37.7892124754164 | -122.45722458116998 | (37.7892124754164, -122.45722458117) | |||
| 170790 | 170790 | 130525 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 120 Cherry St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5996138.91299 | 2115724.5355700003 | 37.7891538638973 | -122.45721398625 | (37.7891538638973, -122.45721398625) | |||
| 45466 | 45466 | 179637 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 120 Farragut Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5997385.090419999 | 2087337.68892 | 37.7112821038472 | -122.45085473348301 | (37.7112821038472, -122.450854733483) | |||
| 51970 | 51970 | 136616 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1200 Jackson St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6008322.00574 | 2117598.96331 | 37.7949927464615 | -122.41519461245501 | (37.7949927464615, -122.415194612455) | |||
| 28334 | 28334 | 186775 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1200 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984844.3759 | 2106784.0328 | 37.7639506692175 | -122.495631381575 | (37.7639506692175, -122.495631381575) | |||
| 55286 | 55286 | 186809 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 118 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984810.136 | 2106955.7691 | 37.7644202036906 | -122.495762474243 | (37.7644202036906, -122.495762474243) | |||
| 55485 | 55485 | 186815 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1200 Sunset Blvd | 112 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984815.7546 | 2106849.1761 | 37.7641278583257 | -122.49573517813299 | (37.7641278583257, -122.495735178133) | |||
| 68183 | 68183 | 186811 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 116 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984818.3107 | 2106920.8907 | 37.7643249161453 | -122.495731627712 | (37.7643249161453, -122.495731627712) | |||
| 68654 | 68654 | 186773 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1200 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984840.0098 | 2106777.241 | 37.7639317651664 | -122.495645981391 | (37.7639317651664, -122.495645981391) | |||
| 75257 | 75257 | 186812 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 115 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984824.8504 | 2106905.6313 | 37.764283401100705 | -122.495707883417 | (37.7642834011007, -122.495707883417) | |||
| 132517 | 132517 | 186774 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1200 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984836.1288 | 2106787.9137 | 37.76396084213079 | -122.495660191684 | (37.7639608421308, -122.495660191684) | |||
| 155382 | 155382 | 186813 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 114 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984818.8556 | 2106897.4567 | 37.7642606048812 | -122.4957280144 | (37.7642606048812, -122.4957280144) | |||
| 163872 | 163872 | 186776 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1200 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984864.7511 | 2106787.9137 | 37.763962518214505 | -122.49556119714799 | (37.7639625182145, -122.495561197148) | |||
| 173050 | 173050 | 186810 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 117 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984819.4006 | 2106939.4198 | 37.7643758556702 | -122.49572922497102 | (37.7643758556702, -122.495729224971) | |||
| 135914 | 135914 | 215236 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1209 Capitol Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5995030.615069999 | 2091933.03172 | 37.723764760407704 | -122.45932490822099 | (37.7237647604077, -122.459324908221) | |||
| 148427 | 148427 | 237001 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 121 Montcalm St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6010275.886080001 | 2099801.95895 | 37.7462358874737 | -122.40717873653401 | (37.7462358874737, -122.407178736534) | |||
| 146415 | 146415 | 212619 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 123 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991404.11082 | 2090016.7036 | 37.718293824675996 | -122.47172141691799 | (37.718293824676, -122.471721416918) | |||
| 178321 | 178321 | 213623 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995805.80133 | 2096226.42669 | 37.7355979265959 | -122.456955630803 | (37.7355979265959, -122.456955630803) | |||
| 33866 | 33866 | 179632 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1277 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5999581.03215 | 2090102.7419900002 | 37.718999778104795 | -122.443463521241 | (37.7189997781048, -122.443463521241) | |||
| 177395 | 177395 | 135852 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 13 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6008609.879 | 2119160.01046 | 37.7992951697024 | -122.414309029333 | (37.7992951697024, -122.414309029333) | ||||
| 72395 | 72395 | 135807 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1311 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6005955.98541 | 2119974.55098 | 37.8013822560451 | -122.42355037726101 | (37.8013822560451, -122.423550377261) | ||||
| 29016 | 29016 | 179696 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1317 Felton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6007086.79477 | 2092691.09915 | 37.72653204271771 | -122.417702322507 | (37.7265320427177, -122.417702322507) | |||
| 3523 | 3523 | 253474 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 158077 | 158077 | 241014 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1340 Bryant St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6009365.12145 | 2107942.64044 | 37.7685373484578 | -122.41090292444599 | (37.7685373484578, -122.410902924446) | |||
| 158515 | 158515 | 241013 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1340 Bryant St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6009364.37303 | 2107955.02129 | 37.7685713014421 | -122.410906387729 | (37.7685713014421, -122.410906387729) | |||
| 167711 | 167711 | 241012 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1340 Bryant St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6009364.22558 | 2107957.61703 | 37.768578420475706 | -122.41090708110399 | (37.7685784204757, -122.410907081104) | |||
| 132832 | 132832 | 212341 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 136 Lawton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5993819.430480001 | 2104642.8186 | 37.7585929384414 | -122.46443411237101 | (37.7585929384414, -122.464434112371) | |||
| 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) | |||
| 151561 | 151561 | 136015 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Havens St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6007560.5835 | 2119380.86157 | 37.7998425735334 | -122.417955630044 | (37.7998425735334, -122.417955630044) | |||
| 181976 | 181976 | 136014 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Havens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6007575.68988 | 2119392.2209400004 | 37.7998746136871 | -122.417904161874 | (37.7998746136871, -122.417904161874) | |||
| 160571 | 160571 | 179684 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 141 Lisbon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6003403.73924 | 2092580.9820400001 | 37.7260217403927 | -122.43042664307501 | (37.7260217403927, -122.430426643075) | |||
| 164763 | 164763 | 215189 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1417 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5991114.02824 | 2105768.56149 | 37.761527607938206 | -122.473872651923 | (37.7615276079382, -122.473872651923) | |||
| 35627 | 35627 | 214221 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 144 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6000463.1265199995 | 2095257.0070900002 | 37.7332024726215 | -122.44078400199699 | (37.7332024726215, -122.440784001997) | ||||
| 43256 | 43256 | 215267 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 144 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6000534.409630001 | 2095247.93227 | 37.7331816146194 | -122.44053690695499 | (37.7331816146194, -122.440536906955) | |||
| 172732 | 172732 | 215266 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 144 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 6000556.38371 | 2095246.8523 | 37.7331799005214 | -122.44046085939199 | (37.7331799005214, -122.440460859392) | |||
| 29577 | 29577 | 213706 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 1444 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5990875.43177 | 2105581.50007 | 37.7610001645442 | -122.474684197434 | (37.7610001645442, -122.474684197434) | |||
| 24980 | 24980 | 213333 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991918.76578 | 2089524.2789200002 | 37.7169715101175 | -122.469906655166 | (37.7169715101175, -122.469906655166) | |||
| 74785 | 74785 | 213334 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5991917.942369999 | 2089508.58685 | 37.716928375916 | -122.469908359396 | (37.716928375916, -122.469908359396) | |||
| 30957 | 30957 | 212587 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 147 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5998729.2739699995 | 2093442.0374900002 | 37.7281200970646 | -122.446647836227 | (37.7281200970646, -122.446647836227) | |||
| 36648 | 36648 | 136020 | Undocumented 2 | Prunus spp :: Cherry 84 | 1477 Green St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6006004.56438 | 2118595.56069 | 37.7975986409201 | -122.423284189634 | (37.7975986409201, -122.423284189634) | |||
| 67337 | 67337 | 212892 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1485 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5991130.51563 | 2105331.7867 | 37.7603292954688 | -122.473783764707 | (37.7603292954688, -122.473783764707) | |||
| 148285 | 148285 | 212893 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1485 16th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991128.893730001 | 2105319.02448 | 37.760294159865 | -122.47378844299699 | (37.760294159865, -122.473788442997) | |||
| 158495 | 158495 | 136603 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1490 Jefferson St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6002078.64435 | 2121585.74714 | 37.8055865587436 | -122.437083100219 | (37.8055865587436, -122.437083100219) | |||
| 154458 | 154458 | 196297 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1501 22nd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6013586.24242 | 2103799.53475 | 37.7573970793204 | -122.396011941921 | (37.7573970793204, -122.396011941921) | ||||
| 68665 | 68665 | 213332 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 151 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5991918.25557 | 2089546.87165 | 37.717033514761 | -122.46991006271999 | (37.717033514761, -122.46991006272) |
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");