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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34 | 34 | 240126 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006399.28254 | 2110261.0751 | 37.7747364652596 | -122.42132618837299 | (37.7747364652596, -122.421326188373) | |||
| 4125 | 4125 | 135979 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.63841 | 2115164.21663 | 37.788227554109504 | -122.419939904112 | (37.7882275541095, -122.419939904112) | ||
| 4128 | 4128 | 135978 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006877.42 | 2115159.3392 | 37.788212853775896 | -122.420019889812 | (37.7882128537759, -122.420019889812) | ||
| 4162 | 4162 | 135980 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.58425 | 2115187.77482 | 37.7882922360442 | -122.419941763898 | (37.7882922360442, -122.419941763898) | ||
| 4821 | 4821 | 214558 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1340 Irving St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 4 | Width 3ft | 5991564.93185 | 2106609.34919 | 37.7638622938456 | -122.472374472204 | (37.7638622938456, -122.472374472204) | ||
| 10801 | 10801 | 83237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769756 | 6004043.10746 | 2093201.4009 | 37.727761469894794 | -122.42826058457099 | (37.7277614698948, -122.428260584571) |
| 12196 | 12196 | 86961 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 212 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49929 | 5993495.99209 | 2087406.2303400002 | 37.7112468999028 | -122.464301303157 | (37.7112468999028, -122.464301303157) | |
| 20141 | 20141 | 27518 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 4 | 3x3 | 6005759.73558 | 2101716.47325 | 37.751238927544605 | -122.422931097816 | (37.7512389275446, -122.422931097816) | ||
| 20662 | 20662 | 84576 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3966 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769743 | 6003390.40048346 | 2101879.79659646 | 37.7515533971776 | -122.43113617160401 | (37.7515533971776, -122.431136171604) |
| 22297 | 22297 | 237232 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 156 Rivoli St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997863.35341 | 2105946.59714 | 37.7624050647642 | -122.450542457376 | (37.7624050647642, -122.450542457376) | |||
| 23585 | 23585 | 237396 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2797 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008140.86181 | 2106769.2911 | 37.7652468801621 | -122.415054485502 | (37.7652468801621, -122.415054485502) | |||
| 23875 | 23875 | 123972 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993617.67519 | 2115041.45387 | 37.78713318686079 | -122.46588743043002 | (37.7871331868608, -122.46588743043) | |||
| 24513 | 24513 | 213290 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5994132.71522 | 2090951.16156 | 37.721017116620004 | -122.46235759304399 | (37.72101711662, -122.462357593044) | |||
| 24800 | 24800 | 135988 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 90 Myrtle St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6007056.03202 | 2114170.93433 | 37.7855089979725 | -122.419331776245 | (37.7855089979725, -122.419331776245) | |||
| 25641 | 25641 | 239502 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 81 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008343.6627400005 | 2098237.0984400003 | 37.741830802146296 | -122.413749481054 | (37.7418308021463, -122.413749481054) | |||
| 25774 | 25774 | 237204 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Valley St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6003793.4294 | 2099263.1308 | 37.7443914724035 | -122.429555852029 | (37.7443914724035, -122.429555852029) | |||
| 25834 | 25834 | 214493 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1359 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991433.81997 | 2106159.32578 | 37.762619060232296 | -122.47279512831001 | (37.7626190602323, -122.47279512831) | |||
| 26022 | 26022 | 214523 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 929 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992854.95804 | 2106590.6252900003 | 37.7638854612741 | -122.46791133836099 | (37.7638854612741, -122.467911338361) | |||
| 27074 | 27074 | 250328 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 161 27th Ave | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987394.32135 | 2114885.37066 | 37.7863436587784 | -122.487407123146 | (37.7863436587784, -122.487407123146) | |||
| 27484 | 27484 | 238143 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 574 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001412.715419999 | 2101470.20367 | 37.7503164848156 | -122.43794590440201 | (37.7503164848156, -122.437945904402) | |||
| 27655 | 27655 | 135992 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009196.7187 | 2117357.70571 | 37.7943794313202 | -122.41215090645201 | (37.7943794313202, -122.412150906452) | |||
| 27798 | 27798 | 238400 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002888.32666 | 2107612.09162 | 37.7672644381318 | -122.433281965392 | (37.7672644381318, -122.433281965392) | |||
| 28028 | 28028 | 135997 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009336.40364 | 2117377.1493 | 37.794440655352794 | -122.411668952587 | (37.7944406553528, -122.411668952587) | |||
| 28128 | 28128 | 179162 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 171 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002093.74544 | 2086607.8879 | 37.7095466578231 | -122.434528308849 | (37.7095466578231, -122.434528308849) | |||
| 28267 | 28267 | 214528 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 839 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993110.1935 | 2106600.58981 | 37.7639275567412 | -122.467029287771 | (37.7639275567412, -122.467029287771) | |||
| 28288 | 28288 | 237148 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 416 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005481.686509999 | 2101250.07635 | 37.7499426159557 | -122.423859462545 | (37.7499426159557, -122.423859462545) | |||
| 28434 | 28434 | 196463 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Cesar Chavez St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014925.6309 | 2101062.89752 | 37.7499572830217 | -122.39118848116999 | (37.7499572830217, -122.39118848117) | |||
| 28530 | 28530 | 178973 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1501 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001853.9573099995 | 2094253.8181599998 | 37.7305270560629 | -122.43590377514299 | (37.7305270560629, -122.435903775143) | |||
| 28987 | 28987 | 135966 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6001187.63413 | 2117406.94715 | 37.7940619922234 | -122.43986675736099 | (37.7940619922234, -122.439866757361) | |||
| 29566 | 29566 | 135956 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3168 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5999589.9929599995 | 2115734.38967 | 37.789378518158 | -122.44527443117599 | (37.789378518158, -122.445274431176) | |||
| 29713 | 29713 | 88413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51386 | 6009439.10659 | 2116768.27237 | 37.792774588415796 | -122.411270553799 | (37.7927745884158, -122.411270553799) | |
| 30177 | 30177 | 237230 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 156 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997906.75784 | 2105953.1562 | 37.7624255585064 | -122.450392811082 | (37.7624255585064, -122.450392811082) | |||
| 30298 | 30298 | 214610 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1317 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993294.793 | 2106507.24559 | 37.7636819114108 | -122.466384034097 | (37.7636819114108, -122.466384034097) | |||
| 30695 | 30695 | 213637 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996768.7356 | 2094088.63508 | 37.7297833140429 | -122.45347211404899 | (37.7297833140429, -122.453472114049) | |||
| 30826 | 30826 | 51284 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2205 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2004 12:00:00 AM | 4 | Permit Number 47656 | 6000322.72568 | 2116238.1776 | 37.7908035865572 | -122.442775457127 | (37.7908035865572, -122.442775457127) | ||
| 30897 | 30897 | 214641 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1281 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993288.48621 | 2106790.9815599998 | 37.7644606118874 | -122.46642647040501 | (37.7644606118874, -122.466426470405) | |||
| 30960 | 30960 | 214687 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2624 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992121.72865 | 2097435.29348 | 37.7387049241844 | -122.46978074558999 | (37.7387049241844, -122.46978074559) | |||
| 31409 | 31409 | 135955 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3035 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6000215.874919999 | 2115769.86788 | 37.789511638505104 | -122.443111506798 | (37.7895116385051, -122.443111506798) | |||
| 31801 | 31801 | 213330 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 217 Byxbee St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5991929.42464 | 2089936.9124 | 37.7181051172336 | -122.46989983921101 | (37.7181051172336, -122.469899839211) | |||
| 31814 | 31814 | 196480 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1499 Rankin St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6012679.65409 | 2096682.3113 | 37.737804227083004 | -122.39864786201001 | (37.737804227083, -122.39864786201) | |||
| 32051 | 32051 | 68219 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 263 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 4 | Permit Number 32006 | 5990848.54158 | 2113649.76494 | 37.7831518664143 | -122.475366281729 | (37.7831518664143, -122.475366281729) | |
| 32373 | 32373 | 237328 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 63 Winfield St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 6007300.19334 | 2099134.5882099997 | 37.744236455340705 | -122.417421055037 | (37.7442364553407, -122.417421055037) | |||
| 33035 | 33035 | 238142 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 525 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001732.91125 | 2101443.22488 | 37.750260610843796 | -122.436836716552 | (37.7502606108438, -122.436836716552) | |||
| 33059 | 33059 | 135939 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Walnut St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998471.02227 | 2116380.3328400003 | 37.7910881707365 | -122.44919247964701 | (37.7910881707365, -122.449192479647) | |||
| 33377 | 33377 | 59100 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 574 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 4 | Permit Number 53750 | 5993480.53201 | 2111592.2596 | 37.777654724152896 | -122.46611116933201 | (37.7776547241529, -122.466111169332) | ||
| 33711 | 33711 | 49142 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 520 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 4 | Permit Number 46265 | 5985047.031690001 | 2112314.4789400003 | 37.7791475672211 | -122.495338355641 | (37.7791475672211, -122.495338355641) | ||
| 34126 | 34126 | 45776 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 782 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2001 12:00:00 AM | 4 | Permit Number 44418 | 5991347.84343 | 2110102.5113 | 37.7734410095192 | -122.47338010572399 | (37.7734410095192, -122.473380105724) | ||
| 34629 | 34629 | 238303 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 259 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001471.3059 | 2104316.27209 | 37.7581344352787 | -122.43794712837901 | (37.7581344352787, -122.437947128379) | |||
| 35028 | 35028 | 196446 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 701 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012741.003 | 2104236.29493 | 37.7585492646472 | -122.398965788556 | (37.7585492646472, -122.398965788556) | |||
| 35334 | 35334 | 238213 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 430 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003567.91941 | 2102172.09705 | 37.752366043358 | -122.43054314396002 | (37.752366043358, -122.43054314396) | |||
| 35975 | 35975 | 238202 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3998 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003242.67866 | 2101858.92936 | 37.751487728584706 | -122.431645522127 | (37.7514877285847, -122.431645522127) | |||
| 36336 | 36336 | 214656 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1797 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993098.06749 | 2103308.53562 | 37.7548877351851 | -122.466831895581 | (37.7548877351851, -122.466831895581) | |||
| 36399 | 36399 | 179158 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 148 Seville St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6001439.08808 | 2087342.2198599998 | 37.7115257868681 | -122.436843446185 | (37.7115257868681, -122.436843446185) | |||
| 36539 | 36539 | 179000 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002131.90364 | 2089651.07814 | 37.7179047536928 | -122.43461388473699 | (37.7179047536928, -122.434613884737) | |||
| 36712 | 36712 | 179027 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 376 Ordway St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010782.01904 | 2090025.31129 | 37.719419589727 | -122.404740419057 | (37.719419589727, -122.404740419057) | |||
| 37522 | 37522 | 213670 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 3ft | 5994884.54629 | 2098945.43271 | 37.74301069827921 | -122.460337683337 | (37.7430106982792, -122.460337683337) | |||
| 37540 | 37540 | 237268 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 170 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007556.9387 | 2097846.2780299997 | 37.740713484431296 | -122.416442045889 | (37.7407134844313, -122.416442045889) | |||
| 37655 | 37655 | 213628 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 518 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5997988.71827 | 2097660.25448 | 37.739659985321495 | -122.449511768669 | (37.7396599853215, -122.449511768669) | |||
| 37962 | 37962 | 31466 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 512 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35032 | 6002998.75397 | 2102141.19875 | 37.7522489444334 | -122.432509202251 | (37.7522489444334, -122.432509202251) | ||
| 38128 | 38128 | 88409 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009413.9789 | 2117291.03714 | 37.7942085637169 | -122.41139444529 | (37.7942085637169, -122.41139444529) | |
| 38427 | 38427 | 213600 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994324.50306 | 2101547.6622200003 | 37.7501235325769 | -122.46246285419501 | (37.7501235325769, -122.462462854195) | |||
| 38542 | 38542 | 214571 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1555 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990887.31471 | 2106522.14894 | 37.7635836236158 | -122.474711756267 | (37.7635836236158, -122.474711756267) | |||
| 38858 | 38858 | 238309 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 84 Seward St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6000741.11024 | 2104546.1812 | 37.758724158512 | -122.44048894251301 | (37.758724158512, -122.440488942513) | |||
| 39453 | 39453 | 68949 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 726 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 4 | Permit Number 32938 | 5988844.72891 | 2110346.33242 | 37.7739652106004 | -122.48205650095699 | (37.7739652106004, -122.482056500957) | |
| 39473 | 39473 | 250644 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Lake St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987312.1046400005 | 2114657.5756599996 | 37.785713403992 | -122.487674827026 | (37.785713403992, -122.487674827026) | |||
| 39823 | 39823 | 213412 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2295 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991244.48359 | 2099804.88144 | 37.7451604602052 | -122.472986563398 | (37.7451604602052, -122.472986563398) | |||
| 40188 | 40188 | 213362 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Elmhurst Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991224.3842 | 2094533.07073 | 37.730684246775205 | -122.472671762002 | (37.7306842467752, -122.472671762002) | |||
| 40522 | 40522 | 239475 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 192 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5999654.328290001 | 2106577.31498 | 37.7642392051089 | -122.444393488592 | (37.7642392051089, -122.444393488592) | |||
| 41715 | 41715 | 52943 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 428 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 4 | Permit Number 48930 | 6000112.39427 | 2091327.92801 | 37.722394148651 | -122.44171469507299 | (37.722394148651, -122.441714695073) | |
| 41729 | 41729 | 135951 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3566 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997226.42135 | 2116056.02078 | 37.790126431251394 | -122.453475306653 | (37.7901264312514, -122.453475306653) | |||
| 41923 | 41923 | 213613 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 El Verano Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994697.15129 | 2094857.83515 | 37.7317763834666 | -122.460689482843 | (37.7317763834666, -122.460689482843) | |||
| 42134 | 42134 | 135965 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2574 Broadway | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6001290.6793 | 2117307.18376 | 37.7937939330834 | -122.439503056242 | (37.7937939330834, -122.439503056242) | |||
| 42344 | 42344 | 238318 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 23 Clover Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6000458.56738 | 2105088.99316 | 37.760198494491796 | -122.441505054123 | (37.7601984944918, -122.441505054123) | |||
| 43068 | 43068 | 196481 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2075 Palou Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6012348.976530001 | 2097093.78891 | 37.738915629056 | -122.399820067148 | (37.738915629056, -122.399820067148) | |||
| 43236 | 43236 | 50295 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3052 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 4 | Permit Number 47008 | 5990301.1325 | 2094963.1495599998 | 37.7318116476733 | -122.47589494839501 | (37.7318116476733, -122.475894948395) | |
| 43689 | 43689 | 214508 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1961 11th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5992833.56281 | 2102184.357 | 37.751785762105705 | -122.46766486656401 | (37.7517857621057, -122.467664866564) | |||
| 43690 | 43690 | 135985 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91 Cedar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006979.98142 | 2114482.04959 | 37.7863589607546 | -122.419616971064 | (37.7863589607546, -122.419616971064) | |||
| 43768 | 43768 | 81737 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49969 | 5983468.0529 | 2111801.95258 | 37.7776477425111 | -122.500762690576 | (37.7776477425111, -122.500762690576) | |
| 44141 | 44141 | 88407 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009407.88363 | 2117347.72867 | 37.7943638829406 | -122.411419542685 | (37.7943638829406, -122.411419542685) | |
| 44379 | 44379 | 214636 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1254 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992710.27647 | 2106925.6088900003 | 37.7647968818831 | -122.46843611705299 | (37.7647968818831, -122.468436117053) | |||
| 44912 | 44912 | 213419 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1500 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991327.39795 | 2098430.88472 | 37.741392618264 | -122.47259970561701 | (37.741392618264, -122.472599705617) | |||
| 45036 | 45036 | 214593 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1359 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993615.46246 | 2106240.58605 | 37.7629682319156 | -122.46525557650801 | (37.7629682319156, -122.465255576508) | |||
| 45305 | 45305 | 214820 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 481 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997505.26463 | 2094090.09958 | 37.7298295275143 | -122.450925968752 | (37.7298295275143, -122.450925968752) | |||
| 45503 | 45503 | 214551 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 904 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992951.517530001 | 2106656.3795 | 37.7640715804553 | -122.46758215319299 | (37.7640715804553, -122.467582153193) | |||
| 45639 | 45639 | 237145 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 Linda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005834.28826 | 2105246.67983 | 37.7609362605317 | -122.422924160421 | (37.7609362605317, -122.422924160421) | |||
| 45659 | 45659 | 238401 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 153 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001728.46337 | 2107942.5756599996 | 37.7681059985158 | -122.43731742486601 | (37.7681059985158, -122.437317424866) | |||
| 45705 | 45705 | 239520 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009174.2731800005 | 2097387.06102 | 37.739543394514705 | -122.41081747084299 | (37.7395433945147, -122.410817470843) | |||
| 45711 | 45711 | 213490 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 600 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995429.38895 | 2093366.82572 | 37.7277245338512 | -122.45805013812901 | (37.7277245338512, -122.458050138129) | |||
| 45874 | 45874 | 213559 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Montecito Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996394.710419999 | 2094260.17076 | 37.7302328626481 | -122.45477754205099 | (37.7302328626481, -122.454777542051) | |||
| 46295 | 46295 | 213353 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 Bright St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993739.98906 | 2089300.2829200001 | 37.7164615783281 | -122.46359536864401 | (37.7164615783281, -122.463595368644) | |||
| 46586 | 46586 | 238050 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 400 Lily St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004531.272469999 | 2110000.08562 | 37.7739143581026 | -122.427769418044 | (37.7739143581026, -122.427769418044) | |||
| 46977 | 46977 | 179094 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 527 Avalon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004128.76783 | 2092448.66408 | 37.725699468329395 | -122.42791084003001 | (37.7256994683294, -122.42791084003) | |||
| 47314 | 47314 | 179018 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 27 Pope St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000118.2745199995 | 2088586.12335 | 37.7148661099687 | -122.441497716551 | (37.7148661099687, -122.441497716551) | |||
| 47842 | 47842 | 52649 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46@ LAKE 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2006 12:00:00 AM | 4 | Permit Number 48733 | 5993970.1832 | 2115226.91418 | 37.787662738807605 | -122.46468131190001 | (37.7876627388076, -122.4646813119) | ||
| 48001 | 48001 | 239526 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 90 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009313.28362 | 2096939.56022 | 37.738322447926706 | -122.410305243092 | (37.7383224479267, -122.410305243092) | |||
| 48451 | 48451 | 239392 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4182 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002032.982890001 | 2101799.84301 | 37.7512568492269 | -122.43582456377199 | (37.7512568492269, -122.435824563772) | |||
| 48714 | 48714 | 238099 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 869 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007946.69375 | 2102872.98642 | 37.7545376102364 | -122.41545020157301 | (37.7545376102364, -122.415450201573) | |||
| 49073 | 49073 | 179123 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 332 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009698.7682 | 2094025.87435 | 37.730343691484705 | -122.40876691948401 | (37.7303436914847, -122.408766919484) | |||
| 49624 | 49624 | 196458 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1760 Cesar Chavez St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6013820.908980001 | 2101070.2514 | 37.7499161066554 | -122.395009208608 | (37.7499161066554, -122.395009208608) | |||
| 49643 | 49643 | 214599 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1372 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993361.64911 | 2106161.3799 | 37.7627361123925 | -122.466127666177 | (37.7627361123925, -122.466127666177) |
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");