Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187362 | 187362 | 179078 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 72 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004357.38264 | 2093191.8849400003 | 37.72775311880321 | -122.427173451712 | (37.7277531188032, -122.427173451712) | |||
| 186138 | 186138 | 238131 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 71 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003997.1048 | 2095455.09167 | 37.733946996161706 | -122.428580195541 | (37.7339469961617, -122.428580195541) | |||
| 183476 | 183476 | 238124 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3388 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006427.44061 | 2106137.94166 | 37.7634169081767 | -122.42093598331499 | (37.7634169081767, -122.420935983315) | |||
| 181396 | 181396 | 237285 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 670 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008121.44064 | 2095765.05814 | 37.735030639647 | -122.414342985035 | (37.735030639647, -122.414342985035) | |||
| 180862 | 180862 | 239523 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 102 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009546.51282 | 2097971.75612 | 37.7411697051097 | -122.40957167870701 | (37.7411697051097, -122.409571678707) | |||
| 180751 | 180751 | 238082 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 199 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008610.29695 | 2098081.7798200003 | 37.7414193011484 | -122.41281656574301 | (37.7414193011484, -122.412816565743) | |||
| 176155 | 176155 | 214821 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 481 Flood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5997537.2860900005 | 2094088.45494 | 37.729826844835 | -122.45081514891301 | (37.729826844835, -122.450815148913) | |||
| 175813 | 175813 | 72259 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 231 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 10 | 6002836.88949 | 2092205.7074400003 | 37.7249591941085 | -122.432359414777 | (37.7249591941085, -122.432359414777) | ||
| 175256 | 175256 | 214496 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1319 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5991751.43662 | 2106416.7365 | 37.763344223178294 | -122.471715377061 | (37.7633442231783, -122.471715377061) | |||
| 174754 | 174754 | 237160 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1728 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009299.881080001 | 2099261.81838 | 37.7446981106389 | -122.410515520788 | (37.7446981106389, -122.410515520788) | |||
| 173547 | 173547 | 37340 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 10 | Permit Number 39848 | 6000626.60293 | 2087367.0099799999 | 37.7115476439893 | -122.43965337791799 | (37.7115476439893, -122.439653377918) | |
| 173356 | 173356 | 38235 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 81 Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | 10 | Permit Number 40353 | 6010102.82343 | 2110824.83764 | 37.7764925318532 | -122.408554604827 | (37.7764925318532, -122.408554604827) | ||
| 172900 | 172900 | 238499 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003467.41472 | 2097812.46812 | 37.7403898229362 | -122.43057965014401 | (37.7403898229362, -122.430579650144) | |||
| 172523 | 172523 | 62479 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 10 | Permit Number 31826 | 6000682.25846 | 2093099.2989400001 | 37.7272903816351 | -122.43987175399499 | (37.7272903816351, -122.439871753995) | |
| 172079 | 172079 | 41946 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 690 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 10 | Permit Number 42304 | 5993510.89143 | 2110826.8547 | 37.775554879409206 | -122.46595051642299 | (37.7755548794092, -122.465950516423) | |
| 169496 | 169496 | 237016 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 401 Lily St | 6 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6004555.2204599995 | 2109981.3061599997 | 37.773864148951 | -122.42768523968 | (37.773864148951, -122.42768523968) | |||
| 169418 | 169418 | 237059 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 199 Tiffany Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6006039.83494 | 2099139.1612299997 | 37.7441780174179 | -122.42177943406901 | (37.7441780174179, -122.421779434069) | |||
| 168755 | 168755 | 41936 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 684 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 10 | 3x9 | Permit Number 42295 | 5994746.112840001 | 2110871.9454099997 | 37.7757498669665 | -122.461680887642 | (37.7757498669665, -122.461680887642) |
| 167989 | 167989 | 238266 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4080 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002483.72451 | 2104747.21531 | 37.7593752226938 | -122.434476564549 | (37.7593752226938, -122.434476564549) | |||
| 167320 | 167320 | 196491 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Jack London Aly | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6014437.84547 | 2112488.6537099998 | 37.7813028211009 | -122.393674889898 | (37.7813028211009, -122.393674889898) | |||
| 166260 | 166260 | 213436 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2320 Cecilia Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5991479.35771 | 2099619.1153 | 37.7446639894614 | -122.47216087873899 | (37.7446639894614, -122.472160878739) | |||
| 165881 | 165881 | 213595 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 444 08th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5993843.0022599995 | 2101824.40238 | 37.7508556508809 | -122.46414798674999 | (37.7508556508809, -122.46414798675) | |||
| 164891 | 164891 | 237135 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1346 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6010061.02642 | 2101350.15065 | 37.7504748545291 | -122.408030861231 | (37.7504748545291, -122.408030861231) | |||
| 164062 | 164062 | 238477 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 30 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004138.78564 | 2108905.73594 | 37.7708873309225 | -122.429049053472 | (37.7708873309225, -122.429049053472) | |||
| 163946 | 163946 | 218240 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 329 Wawona St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 2ft | 5992041.06009 | 2097211.89095 | 37.7380868543242 | -122.470043394412 | (37.7380868543242, -122.470043394412) | |||
| 160427 | 160427 | 213522 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995639.49669 | 2093392.9328599998 | 37.7278082877035 | -122.45732568475401 | (37.7278082877035, -122.457325684754) | |||
| 159216 | 159216 | 179109 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Valmar Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005498.42194 | 2092990.6944 | 37.7272651547613 | -122.42321455871 | (37.7272651547613, -122.42321455871) | |||
| 158324 | 158324 | 237257 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1270 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997531.16914 | 2105177.7995700003 | 37.7602751221279 | -122.45163589539601 | (37.7602751221279, -122.451635895396) | |||
| 156856 | 156856 | 237183 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3125 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008871.05134 | 2100530.81629 | 37.748158447349894 | -122.412088001584 | (37.7481584473499, -122.412088001584) | |||
| 155955 | 155955 | 238064 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 62 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008200.01991 | 2099811.02201 | 37.7461443796673 | -122.414357491117 | (37.7461443796673, -122.414357491117) | |||
| 155279 | 155279 | 238522 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 116 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002725.6397 | 2096751.70841 | 37.7374351713866 | -122.433068643513 | (37.7374351713866, -122.433068643513) | |||
| 154800 | 154800 | 79787 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1000 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 10 | 6003769.36441 | 2089501.7721900002 | 37.717587614063895 | -122.428943265313 | (37.7175876140639, -122.428943265313) | ||
| 152829 | 152829 | 135973 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2118 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6003393.9375599995 | 2117943.36114 | 37.79566018913221 | -122.43227105096202 | (37.7956601891322, -122.432271050962) | |||
| 149610 | 149610 | 213689 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 571 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997645.02441 | 2095249.5615599998 | 37.7330211342111 | -122.450526361304 | (37.7330211342111, -122.450526361304) | |||
| 148518 | 148518 | 237374 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6009217.6012 | 2102696.19703 | 37.7541235380848 | -122.41104256485599 | (37.7541235380848, -122.411042564856) | |||
| 147376 | 147376 | 214832 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Holloway Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995877.45425 | 2091234.14535 | 37.7218944367507 | -122.456347034403 | (37.7218944367507, -122.456347034403) | |||
| 147216 | 147216 | 238458 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 59 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002848.35176 | 2108633.14041 | 37.770065720176 | -122.43349320806601 | (37.770065720176, -122.433493208066) | |||
| 146881 | 146881 | 213437 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2316 Cecilia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5991477.149780001 | 2099652.715 | 37.7447561178165 | -122.47217096194599 | (37.7447561178165, -122.472170961946) | |||
| 145594 | 145594 | 46257 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1409 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2002 12:00:00 AM | 10 | 3x3 | Permit Number 44541 | 5992686.9 | 2105815.5 | 37.7617474653886 | -122.46843619791001 | (37.7617474653886, -122.46843619791) | |
| 139783 | 139783 | 39603 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 636 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 10 | Permit Number 41005 | 6012670.17637 | 2104503.85017 | 37.759279965615704 | -122.39922952194401 | (37.7592799656157, -122.399229521944) | |
| 138060 | 138060 | 238072 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 218 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007084.17206 | 2096913.8223700002 | 37.7381265701837 | -122.418010611006 | (37.7381265701837, -122.418010611006) | |||
| 137530 | 137530 | 237194 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004497.58496 | 2098963.6108 | 37.743608903939204 | -122.427099698313 | (37.7436089039392, -122.427099698313) | |||
| 135336 | 135336 | 214761 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 181 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5993672.24365 | 2094025.3463400002 | 37.7294315532264 | -122.46417235658001 | (37.7294315532264, -122.46417235658) | |||
| 133184 | 133184 | 213342 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 442 Vernon St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5992492.2832 | 2090792.26428 | 37.7204862252464 | -122.468016479897 | (37.7204862252464, -122.468016479897) | |||
| 131885 | 131885 | 238502 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 144 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003801.02731 | 2097515.16828 | 37.7395923994732 | -122.429404953883 | (37.7395923994732, -122.429404953883) | |||
| 131391 | 131391 | 213524 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 86 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995636.89154 | 2093200.93581 | 37.7272809603274 | -122.457320806821 | (37.7272809603274, -122.457320806821) | |||
| 130052 | 130052 | 213281 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 321 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5994152.3619099995 | 2092054.50461 | 37.724047761788505 | -122.462369665551 | (37.7240477617885, -122.462369665551) | ||||
| 129515 | 129515 | 238306 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4612 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000565.754869999 | 2104667.02259 | 37.7590459728225 | -122.44110406979901 | (37.7590459728225, -122.441104069799) | |||
| 126747 | 126747 | 250902 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 266 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5986843.33005 | 2114156.49339 | 37.7843102232907 | -122.489259776936 | (37.7843102232907, -122.489259776936) | |||
| 126699 | 126699 | 51677 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1398X 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2005 12:00:00 AM | 10 | 3x3 | Permit Number 47956 | 5993492.40184836 | 2105988.6022895 | 37.762269253020705 | -122.46566288928301 | (37.7622692530207, -122.465662889283) | |
| 126623 | 126623 | 56348 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111X Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 10 | 3x3 | Permit Number 52603 | 6002684.86057117 | 2105294.05500137 | 37.7608881281181 | -122.433820024128 | (37.7608881281181, -122.433820024128) |
| 120431 | 120431 | 179097 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Lisbon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003422.49187 | 2092720.48945 | 37.7264058588353 | -122.43037176555401 | (37.7264058588353, -122.430371765554) | |||
| 118380 | 118380 | 73360 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 236 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 10 | 6003402.60575 | 2092794.2901599999 | 37.72660737262 | -122.430445774353 | (37.72660737262, -122.430445774353) | ||
| 116241 | 116241 | 48973 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1409 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2002 12:00:00 AM | 10 | 3x3 | Permit Number 46160 | 5992699.25598435 | 2105862.87116543 | 37.7618782478409 | -122.468396910406 | (37.7618782478409, -122.468396910406) |
| 79774 | 79774 | 84648 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301X 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/21/2006 12:00:00 AM | 10 | 3x3 | 6004302.0 | 2098976.0 | 37.7436318598049 | -122.427776865938 | (37.7436318598049, -122.427776865938) | ||
| 75166 | 75166 | 213380 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1335 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994849.05504 | 2106429.73403 | 37.7635586449482 | -122.461002744587 | (37.7635586449482, -122.461002744587) | |||
| 74449 | 74449 | 41937 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 516 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 10 | Permit Number 42296 | 5994398.69166 | 2111972.43189 | 37.7787515041629 | -122.462962556291 | (37.7787515041629, -122.462962556291) | |
| 73030 | 73030 | 179053 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Santa Ysabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000877.24807 | 2093119.8452299999 | 37.7273578946334 | -122.439199149238 | (37.7273578946334, -122.439199149238) | |||
| 71742 | 71742 | 214825 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 306 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998773.87969 | 2093858.15153 | 37.7292651966219 | -122.446523558035 | (37.7292651966219, -122.446523558035) | |||
| 71086 | 71086 | 136009 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1173 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007981.4110900005 | 2118539.47865 | 37.797556021142 | -122.416439775085 | (37.797556021142, -122.416439775085) | |||
| 70449 | 70449 | 42715 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 43 Pomona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 10 | Permit Number 42728 | 6014158.74539 | 2094459.1278900001 | 37.731782116644794 | -122.393378351035 | (37.7317821166448, -122.393378351035) | |
| 69949 | 69949 | 179066 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 252 Otsego Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000335.97419 | 2091752.6020400003 | 37.723572943118 | -122.44097228404199 | (37.723572943118, -122.440972284042) | |||
| 69782 | 69782 | 213420 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2560 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991125.4471 | 2098003.0624700002 | 37.7402062362356 | -122.47326677954099 | (37.7402062362356, -122.473266779541) | |||
| 69768 | 69768 | 213525 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 54 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995664.8737699995 | 2092930.77365 | 37.7265407670194 | -122.457204537978 | (37.7265407670194, -122.457204537978) | |||
| 69220 | 69220 | 238359 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 311 Cumberland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003556.50227 | 2104466.76731 | 37.7586660173391 | -122.430746362877 | (37.7586660173391, -122.430746362877) | |||
| 69042 | 69042 | 237215 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 205 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6004483.70741 | 2099550.8339 | 37.745220498930294 | -122.4271895028 | (37.7452204989303, -122.4271895028) | |||
| 68247 | 68247 | 239413 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4218 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002390.21449 | 2100645.7093700003 | 37.7481081572724 | -122.434506706241 | (37.7481081572724, -122.434506706241) | |||
| 68159 | 68159 | 32124 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 70 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 10 | Permit Number 35486 | 6003846.92621 | 2106756.5408799998 | 37.764969637151 | -122.429905274625 | (37.764969637151, -122.429905274625) | |
| 67901 | 67901 | 238285 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002043.60824 | 2105208.24435 | 37.7606161036621 | -122.43603168931001 | (37.7606161036621, -122.43603168931) | |||
| 65573 | 65573 | 64859 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 45 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1993 12:00:00 AM | 10 | Permit Number 25875 | 5995863.10867 | 2112429.78445 | 37.7800915155758 | -122.457929703566 | (37.7800915155758, -122.457929703566) | |
| 62474 | 62474 | 239421 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1623 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6003378.23998 | 2098696.93749 | 37.7428133195871 | -122.43095108904801 | (37.7428133195871, -122.430951089048) | |||
| 62212 | 62212 | 78428 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1000 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 10 | 6003760.55793 | 2089507.02649 | 37.7176015427445 | -122.42897407970699 | (37.7176015427445, -122.428974079707) | ||
| 59878 | 59878 | 238532 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1345 Stevenson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006282.94694 | 2108817.86368 | 37.7707671931702 | -122.421626092496 | (37.7707671931702, -122.421626092496) | |||
| 59311 | 59311 | 239405 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 619 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6002530.69073 | 2098856.1049200003 | 37.74320229615479 | -122.43389304663 | (37.7432022961548, -122.43389304663) | |||
| 58895 | 58895 | 37862 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 286 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | 10 | Permit Number 40149 | 6004552.23885 | 2091481.5698 | 37.7230679881701 | -122.426378106562 | (37.7230679881701, -122.426378106562) | |
| 57573 | 57573 | 196445 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 722 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011248.3756099995 | 2104820.69662 | 37.76007061448 | -122.40416912381201 | (37.76007061448, -122.404169123812) | |||
| 56842 | 56842 | 237298 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008651.85996 | 2097990.76516 | 37.741171727704504 | -122.412666422143 | (37.7411717277045, -122.412666422143) | |||
| 56051 | 56051 | 136019 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Greenwich St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012283.42018 | 2120515.08235 | 37.803221537807204 | -122.401692519489 | (37.8032215378072, -122.401692519489) | ||||
| 56028 | 56028 | 34878 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3009 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/1997 12:00:00 AM | 10 | Permit Number 38491 | 6000242.0296 | 2115774.84436 | 37.789526793876206 | -122.443021372241 | (37.7895267938762, -122.443021372241) | ||
| 55242 | 55242 | 196488 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Jack London Aly | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6014277.716990001 | 2112657.65169 | 37.781757951802504 | -122.394240695653 | (37.7817579518025, -122.394240695653) | |||
| 53474 | 53474 | 213508 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995673.06429 | 2093783.3554599998 | 37.7288822221214 | -122.457237873151 | (37.7288822221214, -122.457237873151) | |||
| 51981 | 51981 | 238289 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4133 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002120.76588 | 2105266.14807 | 37.760779476310894 | -122.43576897936 | (37.7607794763109, -122.43576897936) | |||
| 49447 | 49447 | 238137 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006153.75076 | 2099102.37755 | 37.7440834411083 | -122.421382925706 | (37.7440834411083, -122.421382925706) | |||
| 47811 | 47811 | 237067 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3425 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006787.7435800005 | 2100522.77101 | 37.7480192458088 | -122.419291455163 | (37.7480192458088, -122.419291455163) | |||
| 47687 | 47687 | 213411 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2287 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991262.56515 | 2099870.28984 | 37.7453411016101 | -122.47292880982 | (37.7453411016101, -122.47292880982) | |||
| 45975 | 45975 | 238373 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 587 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002476.35848 | 2103824.63673 | 37.7568416256553 | -122.434436077082 | (37.7568416256553, -122.434436077082) | |||
| 45168 | 45168 | 238077 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 30 Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6007589.16184 | 2096127.64152 | 37.735996299297796 | -122.416208938894 | (37.7359962992978, -122.416208938894) | |||
| 43620 | 43620 | 239498 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 271 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008263.41375 | 2097308.16433 | 37.739275646539504 | -122.413961257899 | (37.7392756465395, -122.413961257899) | |||
| 41980 | 41980 | 54425 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 664 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1972 12:00:00 AM | 10 | Permit Number 10199 | 6012377.17429 | 2104832.12129 | 37.760164992032706 | -122.40026592765498 | (37.7601649920327, -122.400265927655) | ||
| 40854 | 40854 | 64351 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2829 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/1988 12:00:00 AM | 10 | Permit Number 25187 | 5999331.75802 | 2118714.3640900003 | 37.797545994610296 | -122.44638235637501 | (37.7975459946103, -122.446382356375) | ||
| 40677 | 40677 | 238040 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 49 Pearl St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005642.224280001 | 2108761.00256 | 37.7705749163322 | -122.423838323102 | (37.7705749163322, -122.423838323102) | |||
| 39049 | 39049 | 51052 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 326 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2004 12:00:00 AM | 10 | Permit Number 47522 | 5987167.50591 | 2113744.97071 | 37.7831992171669 | -122.488108007262 | (37.7831992171669, -122.488108007262) | ||
| 35006 | 35006 | 237391 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3153 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007712.5404 | 2106158.24187 | 37.763545002229 | -122.416492664228 | (37.763545002229, -122.416492664228) | |||
| 34567 | 34567 | 67434 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 772 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1992 12:00:00 AM | 10 | Permit Number 30936 | 5989473.46135 | 2110070.59902 | 37.7732446703113 | -122.479861453207 | (37.7732446703113, -122.479861453207) | ||
| 34528 | 34528 | 238223 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 151 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6004139.72853 | 2102237.92914 | 37.7525791790987 | -122.42857042708599 | (37.7525791790987, -122.428570427086) | |||
| 34321 | 34321 | 238276 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 185 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002068.9442300005 | 2104816.96627 | 37.759543188190605 | -122.43591606617201 | (37.7595431881906, -122.435916066172) | |||
| 33347 | 33347 | 238086 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 165 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010163.37962 | 2099757.60827 | 37.7461078132211 | -122.407564645485 | (37.7461078132211, -122.407564645485) | |||
| 32236 | 32236 | 238084 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 673 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009779.10173 | 2098199.02126 | 37.7418067560729 | -122.40878349576201 | (37.7418067560729, -122.408783495762) | |||
| 31915 | 31915 | 64862 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 74 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 10 | Permit Number 25878 | 5995911.37415 | 2112317.03505 | 37.779784708505105 | -122.45775457163401 | (37.7797847085051, -122.457754571634) | |
| 31444 | 31444 | 214759 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5995614.4665 | 2092314.08598 | 37.724844595287706 | -122.457334198611 | (37.7248445952877, -122.457334198611) |
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");