Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189023 | 189023 | 238388 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 80 Collingwood St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6001986.47657 | 2105431.50433 | 37.7612258754818 | -122.436245259426 | (37.7612258754818, -122.436245259426) | |||
| 188912 | 188912 | 213530 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995845.09161 | 2092749.1474400002 | 37.7260524135838 | -122.456568407028 | (37.7260524135838, -122.456568407028) | |||
| 188294 | 188294 | 238393 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 80 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001682.14825 | 2105375.84228 | 37.761055745351 | -122.437293814064 | (37.761055745351, -122.437293814064) | |||
| 188084 | 188084 | 237121 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3008 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009469.279709999 | 2101040.98493 | 37.749592804880706 | -122.410055350289 | (37.7495928048807, -122.410055350289) | |||
| 187910 | 187910 | 237431 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1204 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6001926.93451 | 2100562.26984 | 37.747852742609204 | -122.43610273936899 | (37.7478527426092, -122.436102739369) | ||||
| 187828 | 187828 | 238273 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4134 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002159.93034 | 2104730.60743 | 37.7593112359535 | -122.435595213262 | (37.7593112359535, -122.435595213262) | |||
| 186142 | 186142 | 213502 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 799 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994882.72041 | 2093271.2307900002 | 37.727430628209795 | -122.459933045084 | (37.7274306282098, -122.459933045084) | |||
| 185894 | 185894 | 213368 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1590 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992480.65426 | 2104648.2196 | 37.7585305048007 | -122.469064557877 | (37.7585305048007, -122.469064557877) | |||
| 185307 | 185307 | 213627 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Sequoia Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998237.04023 | 2097606.63387 | 37.7395269584975 | -122.44864932061 | (37.7395269584975, -122.44864932061) | |||
| 185143 | 185143 | 237171 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1591 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008782.19605 | 2099461.78779 | 37.7452181462955 | -122.412319712805 | (37.7452181462955, -122.412319712805) | |||
| 184806 | 184806 | 237266 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 678 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007382.53265 | 2095779.6952 | 37.7350292942649 | -122.416898696427 | (37.7350292942649, -122.416898696427) | |||
| 184445 | 184445 | 214809 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 593 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5996723.66912 | 2094093.91182 | 37.729795219275 | -122.45362829392799 | (37.729795219275, -122.453628293928) | |||
| 184342 | 184342 | 237340 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 217 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006872.11608 | 2096713.55038 | 37.7375647304254 | -122.41872959740299 | (37.7375647304254, -122.418729597403) | |||
| 183886 | 183886 | 238104 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1070 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007407.26502 | 2101103.9240599996 | 37.7496498326723 | -122.417190343875 | (37.7496498326723, -122.417190343875) | |||
| 183442 | 183442 | 213520 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 112 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995641.95505 | 2093454.2437599998 | 37.7279767738852 | -122.4573216198 | (37.7279767738852, -122.4573216198) | |||
| 183324 | 183324 | 68544 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 571 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 8 | Permit Number 32430 | 5982530.7498 | 2111896.5441900003 | 37.777852390021 | -122.504012093664 | (37.777852390021, -122.504012093664) | |
| 182902 | 182902 | 40949 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 543 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 8 | Permit Number 45163 | 5989370.51415 | 2111642.49878 | 37.7775546903632 | -122.480332633054 | (37.7775546903632, -122.480332633054) | |
| 182770 | 182770 | 34483 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 845 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 8 | Permit Number 38210 | 6008918.6183400005 | 2119360.64227 | 37.7998633928514 | -122.413254875509 | (37.7998633928514, -122.413254875509) | |
| 182426 | 182426 | 237381 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 815 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009384.72144 | 2104412.66017 | 37.7588459294275 | -122.41058582258499 | (37.7588459294275, -122.410585822585) | |||
| 182218 | 182218 | 237013 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 401 Lily St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6004515.0923 | 2109975.33135 | 37.7738454736228 | -122.427823623763 | (37.7738454736228, -122.427823623763) | |||
| 182145 | 182145 | 214743 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 143 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995640.47159 | 2093655.78153 | 37.7285300628876 | -122.457341322169 | (37.7285300628876, -122.457341322169) | |||
| 181028 | 181028 | 237124 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1025 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6008637.74753 | 2102555.44614 | 37.7537045340508 | -122.413037896084 | (37.7537045340508, -122.413037896084) | |||
| 180565 | 180565 | 214799 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995018.72239 | 2097530.56608 | 37.7391335428916 | -122.459771279518 | (37.7391335428916, -122.459771279518) | |||
| 179064 | 179064 | 39571 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 835 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 8 | Permit Number 40989 | 6011610.458330001 | 2104449.8311400004 | 37.7590725253066 | -122.402890761795 | (37.7590725253066, -122.402890761795) | |
| 179002 | 179002 | 179025 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 947 Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008937.54219 | 2090376.09955 | 37.7202795151651 | -122.41114088325399 | (37.7202795151651, -122.411140883254) | |||
| 178402 | 178402 | 31022 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 8 | Permit Number 34788 | 6002783.56511 | 2086520.12567 | 37.7093448166924 | -122.43213791266001 | (37.7093448166924, -122.43213791266) | |
| 177715 | 177715 | 40658 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Congdon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 8 | Permit Number 47919 | 6004683.64689 | 2093722.1701 | 37.7292276094514 | -122.426083284515 | (37.7292276094514, -122.426083284515) | |
| 177527 | 177527 | 213633 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 530 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996856.78477 | 2093858.89472 | 37.7291575486716 | -122.453151141523 | (37.7291575486716, -122.453151141523) | |||
| 176589 | 176589 | 237443 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 692 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000740.185880001 | 2100908.5426 | 37.748736030656204 | -122.440231277748 | (37.7487360306562, -122.440231277748) | |||
| 176517 | 176517 | 214814 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 349 Kensington Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5994180.976419999 | 2099052.1679700003 | 37.7432632692845 | -122.462778159201 | (37.7432632692845, -122.462778159201) | |||
| 175956 | 175956 | 213531 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995850.23147 | 2092765.29861 | 37.726097055928705 | -122.456551806415 | (37.7260970559287, -122.456551806415) | |||
| 175856 | 175856 | 238379 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4045 20th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6003509.36574 | 2104168.85122 | 37.7578453401174 | -122.430888121192 | (37.7578453401174, -122.430888121192) | |||
| 175499 | 175499 | 214688 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2624 14th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992099.807580001 | 2097491.63696 | 37.7388583620299 | -122.46986063866899 | (37.7388583620299, -122.469860638669) | |||
| 173766 | 173766 | 36753 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2579 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 8 | Permit Number 41197 | 6002394.06342 | 2116399.40669 | 37.7913641456997 | -122.435620277371 | (37.7913641456997, -122.435620277371) | |
| 172628 | 172628 | 34523 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 586 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1997 12:00:00 AM | 8 | Permit Number 38233 | 6010643.980930001 | 2105619.91693 | 37.762231304058204 | -122.40631575879 | (37.7622313040582, -122.40631575879) | |
| 172451 | 172451 | 250881 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 154 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5986823.250630001 | 2114733.9114599996 | 37.78589447530229 | -122.489371714655 | (37.7858944753023, -122.489371714655) | |||
| 172185 | 172185 | 237128 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 846 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009894.17445 | 2104278.41833 | 37.7585058804499 | -122.408814418966 | (37.7585058804499, -122.408814418966) | |||
| 171092 | 171092 | 237224 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 481 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6003414.63088 | 2100074.85928 | 37.746598834972794 | -122.43092357787201 | (37.7465988349728, -122.430923577872) | |||
| 170823 | 170823 | 214722 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 601 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995335.81879 | 2093369.06722 | 37.7277253117639 | -122.458373771745 | (37.7277253117639, -122.458373771745) | |||
| 169964 | 169964 | 43259 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 445 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 8 | Permit Number 43042 | 6010225.92511 | 2092216.8838799999 | 37.725406095999396 | -122.406817013015 | (37.7254060959994, -122.406817013015) | |
| 168693 | 168693 | 239504 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 447 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008598.51297 | 2096699.9408200001 | 37.737624412144 | -122.412759642259 | (37.737624412144, -122.412759642259) | |||
| 168641 | 168641 | 238378 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4045 20th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6003444.5376699995 | 2104166.53773 | 37.7578353144667 | -122.43111215849702 | (37.7578353144667, -122.431112158497) | |||
| 168629 | 168629 | 213567 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994708.827190001 | 2099817.87371 | 37.745396093361705 | -122.46100848854799 | (37.7453960933617, -122.461008488548) | |||
| 168185 | 168185 | 237265 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 718 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007364.554719999 | 2095595.59213 | 37.7345227763072 | -122.416947812899 | (37.7345227763072, -122.416947812899) | |||
| 168007 | 168007 | 237332 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 136 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6005681.71691 | 2096637.35347 | 37.737288415535396 | -122.422839963208 | (37.7372884155354, -122.422839963208) | |||
| 166375 | 166375 | 179050 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 7 Santa Ysabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001033.440769999 | 2093008.98993 | 37.727062398087895 | -122.438651252569 | (37.7270623980879, -122.438651252569) | |||
| 166105 | 166105 | 238297 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4315 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001583.07839 | 2105233.68075 | 37.760659772044704 | -122.43762627186199 | (37.7606597720447, -122.437626271862) | |||
| 166035 | 166035 | 214700 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200x Vasquez Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 5994642.56982 | 2099211.09063 | 37.7437262061113 | -122.461193618499 | (37.7437262061113, -122.461193618499) | |||
| 165967 | 165967 | 238066 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 37 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007518.64485 | 2099934.94447 | 37.7464463432236 | -122.41672238342699 | (37.7464463432236, -122.416722383427) | |||
| 165927 | 165927 | 237195 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004521.432630001 | 2098964.75568 | 37.743613396045106 | -122.42701732040301 | (37.7436133960451, -122.427017320403) | |||
| 165651 | 165651 | 239424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 7 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000599.70336 | 2102797.60435 | 37.7539149394492 | -122.44085255730499 | (37.7539149394492, -122.440852557305) | |||
| 165247 | 165247 | 179010 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 600 Edinburgh St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002473.362919999 | 2090193.0957900002 | 37.7194123924534 | -122.43347232401399 | (37.7194123924534, -122.433472324014) | |||
| 164881 | 164881 | 213542 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 175 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996107.46568 | 2094090.3506599998 | 37.729750096675794 | -122.455758308509 | (37.7297500966758, -122.455758308509) | |||
| 164310 | 164310 | 238275 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4134 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002121.03954 | 2104729.33113 | 37.7593055225503 | -122.435729625026 | (37.7593055225503, -122.435729625026) | |||
| 164263 | 164263 | 238376 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 563 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002678.70022 | 2103837.08907 | 37.7568873004289 | -122.43373719501699 | (37.7568873004289, -122.433737195017) | |||
| 163314 | 163314 | 237363 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2498 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008189.87166 | 2104046.47558 | 37.757773409633 | -122.41469226643 | (37.757773409633, -122.41469226643) | |||
| 162389 | 162389 | 238267 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4080 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002464.90163 | 2104746.35591 | 37.7593717944886 | -122.434541601739 | (37.7593717944886, -122.434541601739) | |||
| 162216 | 162216 | 121930 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 372 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5990921.90113 | 2112919.08197 | 37.781149865360206 | -122.47505913337099 | (37.7811498653602, -122.475059133371) | |||
| 162028 | 162028 | 237362 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1024 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008600.1572 | 2102553.65045 | 37.753697493244296 | -122.41316776537901 | (37.7536974932443, -122.413167765379) | |||
| 161379 | 161379 | 33142 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3148 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2005 12:00:00 AM | 8 | Permit Number 37368 | 6001934.81136 | 2119023.6664400003 | 37.798543584677894 | -122.437397274777 | (37.7985435846779, -122.437397274777) | |
| 160988 | 160988 | 202147 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1979 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6012955.252309999 | 2093506.82348 | 37.72910034549879 | -122.397472339298 | (37.7291003454988, -122.397472339298) | |||
| 159954 | 159954 | 62779 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | 8 | Permit Number 23134 | 6000268.11132 | 2091745.7518099998 | 37.7235502685229 | -122.441206382083 | (37.7235502685229, -122.441206382083) | |
| 159836 | 159836 | 238128 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005448.09835 | 2099061.1826400002 | 37.743930518573606 | -122.42381998861201 | (37.7439305185736, -122.423819988612) | |||
| 157095 | 157095 | 237449 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 42 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6000330.97205 | 2101418.03285 | 37.75011166152311 | -122.441682891454 | (37.7501116615231, -122.441682891454) | |||
| 156722 | 156722 | 237065 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3425 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6006681.7614400005 | 2100522.87147 | 37.7480135522025 | -122.41965794506599 | (37.7480135522025, -122.419657945066) | |||
| 155046 | 155046 | 237178 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 102 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010211.56612 | 2100240.61937 | 37.747436753123395 | -122.407432068339 | (37.7474367531234, -122.407432068339) | |||
| 151967 | 151967 | 196468 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 12 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6015629.24905 | 2101065.86664 | 37.7500044578413 | -122.38875552004801 | (37.7500044578413, -122.388755520048) | |||
| 151932 | 151932 | 55259 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1972 12:00:00 AM | 8 | Permit Number 11181 | 6008604.18987 | 2088002.78931 | 37.7137441994136 | -122.41212553387501 | (37.7137441994136, -122.412125533875) | ||
| 151906 | 151906 | 237293 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 71 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008348.24706 | 2098292.52869 | 37.741983258835 | -122.41373754976601 | (37.741983258835, -122.413737549766) | |||
| 151398 | 151398 | 237057 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Albion St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6005792.84324 | 2107206.9501900002 | 37.766316361124204 | -122.423206846131 | (37.7663163611242, -122.423206846131) | |||
| 151307 | 151307 | 213301 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 727 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994761.86207 | 2089904.6583900002 | 37.7181798769775 | -122.46010705669599 | (37.7181798769775, -122.460107056696) | |||
| 151122 | 151122 | 239497 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 475 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008231.21734 | 2096641.1779599998 | 37.7374424397264 | -122.41402540656401 | (37.7374424397264, -122.414025406564) | |||
| 151037 | 151037 | 46787 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 42 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 8 | Permit Number 44878 | 6002762.13918 | 2093587.1286799998 | 37.7287480270995 | -122.43271645372101 | (37.7287480270995, -122.432716453721) | |
| 150786 | 150786 | 239550 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 173 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007148.228630001 | 2098090.56095 | 37.7413612382336 | -122.417872525497 | (37.7413612382336, -122.417872525497) | |||
| 150319 | 150319 | 78354 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1125 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 8 | 6000366.91048 | 2090562.1790900002 | 37.7203060748337 | -122.44077999190701 | (37.7203060748337, -122.440779991907) | ||
| 149697 | 149697 | 238353 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 737 Sanchez St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6003694.73227 | 2104140.3391 | 37.757777553703 | -122.43024501240299 | (37.757777553703, -122.430245012403) | |||
| 149691 | 149691 | 213626 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Sequoia Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998241.71999 | 2097608.8435400003 | 37.739533293312604 | -122.44863329921002 | (37.7395332933126, -122.44863329921) | |||
| 149463 | 149463 | 213540 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 185 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996102.56759 | 2094123.9077299999 | 37.7298419552203 | -122.455777666417 | (37.7298419552203, -122.455777666417) | |||
| 148541 | 148541 | 213283 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 321 Ashton Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994158.95263 | 2092018.0634599999 | 37.7239480827215 | -122.46234424081499 | (37.7239480827215, -122.462344240815) | |||
| 148223 | 148223 | 178974 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 126 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 5998851.51754 | 2088138.5359099999 | 37.7135648862728 | -122.445843970916 | (37.7135648862728, -122.445843970916) | |||
| 148010 | 148010 | 213498 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 202 Elmwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994844.316980001 | 2092680.71168 | 37.725806996680795 | -122.460023043831 | (37.7258069966808, -122.460023043831) | |||
| 147858 | 147858 | 238222 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 209 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004148.77666 | 2102090.97951 | 37.7521762018776 | -122.428528663484 | (37.7521762018776, -122.428528663484) | |||
| 147507 | 147507 | 237419 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 786 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001445.739469999 | 2100008.32461 | 37.7463043906404 | -122.43772701839599 | (37.7463043906404, -122.437727018396) | |||
| 147294 | 147294 | 179085 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004898.84219 | 2092984.2976099998 | 37.727213735105295 | -122.42528684943001 | (37.7272137351053, -122.42528684943) | |||
| 146405 | 146405 | 239481 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Shrader St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997782.47434 | 2105960.8807900003 | 37.76243965450129 | -122.450823216731 | (37.7624396545013, -122.450823216731) | |||
| 137972 | 137972 | 213512 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 150 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995679.11332 | 2093690.24968 | 37.7286269234873 | -122.45721022886299 | (37.7286269234873, -122.457210228863) | |||
| 137946 | 137946 | 214774 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 88 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5993702.75991 | 2101413.55838 | 37.7497194941621 | -122.464603124653 | (37.7497194941621, -122.464603124653) | |||
| 137936 | 137936 | 213519 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 124 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995650.751180001 | 2093537.43777 | 37.7282057098272 | -122.457297227496 | (37.7282057098272, -122.457297227496) | |||
| 137780 | 137780 | 213680 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 94 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6001486.953319999 | 2094958.6279799999 | 37.732441446519104 | -122.437223005055 | (37.7324414465191, -122.437223005055) | |||
| 137181 | 137181 | 213366 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1339 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994540.087040001 | 2106406.8839 | 37.76347812055079 | -122.46206970207899 | (37.7634781205508, -122.462069702079) | |||
| 135989 | 135989 | 214499 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1314 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992102.94479 | 2106463.61182 | 37.7634932615306 | -122.470503050471 | (37.7634932615306, -122.470503050471) | |||
| 135930 | 135930 | 237168 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 80 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009664.29211 | 2099854.40785 | 37.746345654235 | -122.40929726315201 | (37.746345654235, -122.409297263152) | |||
| 135117 | 135117 | 213323 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 395 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5991938.55148 | 2091189.98285 | 37.7215462696313 | -122.469959478668 | (37.7215462696313, -122.469959478668) | |||
| 134795 | 134795 | 213445 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2343 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992609.1265199995 | 2099494.08516 | 37.7443860045008 | -122.468245299792 | (37.7443860045008, -122.468245299792) | |||
| 134778 | 134778 | 214749 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995624.960659999 | 2093556.42251 | 37.7282563560431 | -122.45738775865699 | (37.7282563560431, -122.457387758657) | |||
| 134423 | 134423 | 214583 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990787.79928 | 2105160.7264400003 | 37.759839754027 | -122.474956561593 | (37.759839754027, -122.474956561593) | |||
| 134135 | 134135 | 213527 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Southwood Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5995752.91853 | 2092600.8246099998 | 37.7256398621782 | -122.456876318691 | (37.7256398621782, -122.456876318691) | |||
| 134002 | 134002 | 237375 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1071 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009203.81222 | 2102937.13478 | 37.7547843257492 | -122.41110726841299 | (37.7547843257492, -122.411107268413) | |||
| 133937 | 133937 | 214721 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 601 Upland Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993008.28484 | 2094364.45541 | 37.7303243722575 | -122.466492343942 | (37.7303243722575, -122.466492343942) | |||
| 133876 | 133876 | 237357 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1448 Treat Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008697.70775 | 2100711.62827 | 37.7486451892219 | -122.412700200662 | (37.7486451892219, -122.412700200662) |
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");