trees
4,014 rows where qSpecies_id = 40 sorted by Supervisor Districts descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts ▲ | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1029 | 65280 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 435 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1989 12:00:00 AM | 1 | Permit Number 28085 | 6011091.92612 | 2112217.73363 | 37.7803724445696 | -122.405231107147 | (37.7803724445696, -122.405231107147) | 14 | 2 | 9 | 28853 | 34 | |
3725 | 73662 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 828 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011416.18719 | 2109390.39573 | 37.7726273509159 | -122.403910314231 | (37.7726273509159, -122.403910314231) | 14 | 2 | 9 | 28853 | 34 | |||
6764 | 95833 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 520 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767565 | 6010212.70231 | 2112022.42286 | 37.7797869733249 | -122.408258986859 | (37.7797869733249, -122.408258986859) | 14 | 2 | 9 | 28853 | 34 |
7876 | 196488 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Jack London Aly | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014277.71699 | 2112657.65169 | 37.7817579518025 | -122.394240695653 | (37.7817579518025, -122.394240695653) | 6 | 2 | 9 | 28856 | 6 | |||
9518 | 65278 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 415 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1989 12:00:00 AM | 1 | Permit Number 28081 | 6011215.3927 | 2112332.46737 | 37.7806943784819 | -122.40481205634 | (37.7806943784819, -122.40481205634) | 14 | 2 | 9 | 28853 | 34 | |
14747 | 260897 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 65 Colin P Kelly Jr St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6015356.8087 | 2112701.67439 | 37.7819387497011 | -122.390510590187 | (37.7819387497011, -122.390510590187) | 6 | 2 | 9 | 28856 | 6 | ||||
17422 | 260898 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 65 Colin P Kelly Jr St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6015356.8087 | 2112701.67439 | 37.7819387497011 | -122.390510590187 | (37.7819387497011, -122.390510590187) | 6 | 2 | 9 | 28856 | 6 | ||||
22165 | 108189 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 490X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013735.53307 | 2112587.71036 | 37.7815357570631 | -122.396111508062 | (37.7815357570631, -122.396111508062) | 6 | 2 | 9 | 28856 | 6 | ||||
25662 | 196496 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 27 Boardman Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6011659.04329 | 2110178.7456 | 37.7748055439625 | -122.403125707899 | (37.7748055439625, -122.403125707899) | 14 | 2 | 9 | 28853 | 34 | |||
30730 | 96024 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 668 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 0 | 3x3 | Permit Number 767665 | 6007552 | 2113596 | 37.78395828879 | -122.41757510582 | (37.78395828879, -122.41757510582) | 7 | 9 | 9 | 28858 | 36 |
31877 | 96029 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 730 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767669 | 6007514.32648 | 2113867.32169 | 37.78470115228 | -122.417724680544 | (37.78470115228, -122.417724680544) | 7 | 9 | 9 | 28858 | 36 |
36730 | 88755 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 990 Polk St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
37357 | 196493 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 728 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012209.40916 | 2110147.41872 | 37.7747502473676 | -122.401219664968 | (37.7747502473676, -122.401219664968) | 14 | 2 | 9 | 28853 | 34 | |||
41061 | 88754 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 990 Polk St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
42345 | 135983 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 664 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6007541.15354 | 2113647.81181 | 37.7840999411125 | -122.417616304154 | (37.7840999411125, -122.417616304154) | 7 | 9 | 9 | 28858 | 36 | |||
45597 | 51890 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 475 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | 1 | Permit Number 48103 | 6010867.53759 | 2112000.42013 | 37.7797632051362 | -122.405992062203 | (37.7797632051362, -122.405992062203) | 14 | 2 | 9 | 28853 | 34 | ||
46076 | 65441 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 625 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51040 | 6007520.81272 | 2113468.90286 | 37.7836075559752 | -122.417673991168 | (37.7836075559752, -122.417673991168) | 7 | 9 | 9 | 28858 | 36 | |
46712 | 96028 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 730 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767669 | 6007516.24853 | 2113853.8784 | 37.7846643484356 | -122.417717077682 | (37.7846643484356, -122.417717077682) | 7 | 9 | 9 | 28858 | 36 |
47299 | 104364 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
49289 | 196487 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Jack London Aly | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6014260.97705 | 2112675.46167 | 37.7818059234575 | -122.394299855773 | (37.7818059234575, -122.394299855773) | 6 | 2 | 9 | 28856 | 6 | |||
59525 | 88201 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 436 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51208 | 6011209.66735 | 2112097.91592 | 37.7800500349251 | -122.404815345178 | (37.7800500349251, -122.404815345178) | 14 | 2 | 9 | 28853 | 34 | |
61126 | 88757 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 990 Polk St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
61675 | 135990 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90 Myrtle St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6007019.38816 | 2114166.03312 | 37.7854934765818 | -122.419458205643 | (37.7854934765818, -122.419458205643) | 13 | 9 | 9 | 28858 | 36 | |||
61691 | 135987 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90 Myrtle St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6007069.18975 | 2114172.43083 | 37.7855138480361 | -122.419286360472 | (37.7855138480361, -122.419286360472) | 13 | 9 | 9 | 28858 | 36 | |||
62451 | 91030 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1086 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6009941.213427 | 2111462.810786 | 37.7782352043229 | -122.409158690819 | (37.7782352043229, -122.409158690819) | 14 | 2 | 9 | 28853 | 34 | ||
62747 | 40637 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 142 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | 13 | Permit Number 41636 | 6010361.02696 | 2111479.70343 | 37.7783050974438 | -122.407707586435 | (37.7783050974438, -122.407707586435) | 14 | 2 | 9 | 28853 | 34 | ||
65480 | 196425 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 282 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011155.75972 | 2111427.64984 | 37.7782066270623 | -122.404954631245 | (37.7782066270623, -122.404954631245) | 14 | 2 | 9 | 28856 | 34 | |||
67107 | 88756 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 990 Polk St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
68283 | 196492 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Jack London Aly | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6014449.0241 | 2112477.93082 | 37.7812739996458 | -122.393635466299 | (37.7812739996458, -122.393635466299) | 6 | 2 | 9 | 28856 | 6 | |||
72077 | 196426 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 55 Sherman St | 24 | : | Tree | Private 2 | 4 | Width 10ft | 6010646.14926 | 2111067.55451 | 37.7771893895099 | -122.406692185292 | (37.7771893895099, -122.406692185292) | 14 | 2 | 9 | 28853 | 34 | |||
72271 | 238036 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1345 Stevenson St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6006282.85406 | 2108818.1643 | 37.7707680133637 | -122.421626435124 | (37.7707680133637, -122.421626435124) | 8 | 2 | 9 | 28853 | 19 | |||
72744 | 135985 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 91 Cedar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006979.98142 | 2114482.04959 | 37.7863589607546 | -122.419616971064 | (37.7863589607546, -122.419616971064) | 13 | 9 | 9 | 28858 | 36 | |||
75212 | 196491 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Jack London Aly | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014437.84547 | 2112488.65371 | 37.7813028211009 | -122.393674889898 | (37.7813028211009, -122.393674889898) | 6 | 2 | 9 | 28856 | 6 | |||
82671 | 196501 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 351 Tehama St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6011701.40176 | 2112798.07009 | 37.7819999683719 | -122.403163468629 | (37.7819999683719, -122.403163468629) | 6 | 2 | 9 | 28853 | 34 | |||
85090 | 196485 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Jack London Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6014233.73328 | 2112701.00373 | 37.7818745417214 | -122.394395896169 | (37.7818745417214, -122.394395896169) | 6 | 2 | 9 | 28856 | 6 | |||
88770 | 135989 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90 Myrtle St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6007041.41912 | 2114167.70099 | 37.7854992969958 | -122.419382103224 | (37.7854992969958, -122.419382103224) | 13 | 9 | 9 | 28858 | 36 | |||
90448 | 38235 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 81 Langton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | 10 | Permit Number 40353 | 6010102.82343 | 2110824.83764 | 37.7764925318532 | -122.408554604827 | (37.7764925318532, -122.408554604827) | 8 | 2 | 9 | 28853 | 34 | ||
90536 | 196502 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 351 Tehama St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6011719.28839 | 2112815.50725 | 37.7820488456301 | -122.403102815636 | (37.7820488456301, -122.403102815636) | 6 | 2 | 9 | 28853 | 34 | |||
92242 | 47388 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 476Howard Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | 1 | Permit Number 45304 | 6010838.51311 | 2112011.8477 | 37.7797929592141 | -122.406093276399 | (37.7797929592141, -122.406093276399) | 14 | 2 | 9 | 28853 | 34 | ||
97227 | 51393 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 12 Rausch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2004 12:00:00 AM | Permit Number 47720 | 6009581.33332398 | 2110978.5612901 | 37.7768854013703 | -122.410369452214 | (37.7768854013703, -122.410369452214) | 8 | 2 | 9 | 28853 | 34 | ||
98261 | 36732 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 South Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 9 | Permit Number 39511 | 6014611.90402 | 2112877.28923 | 37.7823795964711 | -122.393099929045 | (37.7823795964711, -122.393099929045) | 6 | 2 | 9 | 28856 | 6 | |
99732 | 51392 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 12 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2004 12:00:00 AM | Permit Number 47720 | 6009581.33332398 | 2110978.5612901 | 37.7768854013703 | -122.410369452214 | (37.7768854013703, -122.410369452214) | 8 | 2 | 9 | 28853 | 34 | ||
103467 | 32690 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 480 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 1 | Permit Number 37101 | 6010817.62236 | 2111993.44255 | 37.7797412544913 | -122.406164249981 | (37.7797412544913, -122.406164249981) | 14 | 2 | 9 | 28853 | 34 | |
105172 | 238532 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1345 Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006282.94694 | 2108817.86368 | 37.7707671931702 | -122.421626092496 | (37.7707671931702, -122.421626092496) | 8 | 2 | 9 | 28853 | 19 | |||
109043 | 103832 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Myrtle St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.79066 | 2114178.2136 | 37.7855373621017 | -122.418817630423 | (37.7855373621017, -122.418817630423) | 13 | 9 | 9 | 28858 | 36 | ||
109748 | 135988 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90 Myrtle St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6007056.03202 | 2114170.93433 | 37.7855089979725 | -122.419331776245 | (37.7855089979725, -122.419331776245) | 13 | 9 | 9 | 28858 | 36 | |||
111639 | 95831 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 520 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767565 | 6010225.58113 | 2112036.57812 | 37.7798265614898 | -122.408215431797 | (37.7798265614898, -122.408215431797) | 14 | 2 | 9 | 28853 | 34 |
111674 | 196497 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3 Decatur St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6010842.88512 | 2109312.67957 | 37.7723819142361 | -122.405887961173 | (37.7723819142361, -122.405887961173) | 14 | 2 | 9 | 28853 | 34 | |||
115124 | 90437 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 34 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/14/2014 12:00:00 AM | 3 | 3x3 | 6006497.945377 | 2109373.750238 | 37.7723056459237 | -122.420921880831 | (37.7723056459237, -122.420921880831) | 8 | 2 | 9 | 28853 | 19 | ||
115597 | 196503 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 351 Tehama St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6011737.82052 | 2112830.87734 | 37.7820920832107 | -122.403039783975 | (37.7820920832107, -122.403039783975) | 6 | 2 | 9 | 28853 | 34 | |||
115666 | 96026 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 684 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767667 | 6007537.6 | 2113648.8 | 37.7841024544834 | -122.417628668217 | (37.7841024544834, -122.417628668217) | 7 | 9 | 9 | 28858 | 36 | |
116975 | 196498 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 649 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6012784.03099 | 2111475.7584 | 37.7784296058662 | -122.399325187321 | (37.7784296058662, -122.399325187321) | 6 | 2 | 9 | 28856 | 34 | |||
119650 | 96025 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 670 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767666 | 6007551 | 2113603 | 37.7839774528213 | -122.417579061754 | (37.7839774528213, -122.417579061754) | 7 | 9 | 9 | 28858 | 36 | |
122072 | 103833 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Myrtle St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.79066 | 2114178.2136 | 37.7855373621017 | -122.418817630423 | (37.7855373621017, -122.418817630423) | 13 | 9 | 9 | 28858 | 36 | ||
123585 | 85007 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 850 Bryant St | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49366 | 6010976 | 2110190 | 37.7747982776561 | -122.40548930108 | (37.7747982776561, -122.40548930108) | 14 | 2 | 9 | 28853 | 34 | |||||
125890 | 32691 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 480 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 1 | Permit Number 37101 | 6010795.05101 | 2111971.34075 | 37.7796793055824 | -122.406240776896 | (37.7796793055824, -122.406240776896) | 14 | 2 | 9 | 28853 | 34 | |
126194 | 65922 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 6 | Permit Number 28938 | 6014500.58115 | 2112811.20719 | 37.7821919655182 | -122.393480434 | (37.7821919655182, -122.393480434) | 6 | 2 | 9 | 28856 | 6 | |
126486 | 196483 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 65 Colin P Kelly Jr St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015356.8087 | 2112701.67439 | 37.7819387497011 | -122.390510590187 | (37.7819387497011, -122.390510590187) | 6 | 2 | 9 | 28856 | 6 | |||
127618 | 29119 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 509 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6008381.9659 | 2113792.89597 | 37.7845455839642 | -122.414717657915 | (37.7845455839642, -122.414717657915) | 7 | 10 | 9 | 28858 | 36 | ||
128145 | 196504 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 142 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010369.66301 | 2111467.46147 | 37.778271967325 | -122.40767684761 | (37.778271967325, -122.40767684761) | 14 | 2 | 9 | 28853 | 34 | |||
129562 | 196489 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Jack London Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6014409.66856 | 2112518.16121 | 37.7813822762217 | -122.393774434946 | (37.7813822762217, -122.393774434946) | 6 | 2 | 9 | 28856 | 6 | |||
130909 | 104361 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
133115 | 103831 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.79066 | 2114178.2136 | 37.7855373621017 | -122.418817630423 | (37.7855373621017, -122.418817630423) | 13 | 9 | 9 | 28858 | 36 | ||
141339 | 196499 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 468 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010888.37201 | 2112059.86341 | 37.779927587715 | -122.405924175061 | (37.779927587715, -122.405924175061) | 14 | 2 | 9 | 28853 | 34 | |||
143063 | 196490 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Jack London Aly | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014419.45189 | 2112508.88507 | 37.7813573497108 | -122.393739939655 | (37.7813573497108, -122.393739939655) | 6 | 2 | 9 | 28856 | 6 | |||
143687 | 238531 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 32 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006504.27757 | 2109384.99653 | 37.7723368824788 | -122.420900775765 | (37.7723368824788, -122.420900775765) | 8 | 2 | 9 | 28853 | 19 | |||
147096 | 196495 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 728 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012138.91764 | 2110082.47387 | 37.7745679907399 | -122.401458945783 | (37.7745679907399, -122.401458945783) | 14 | 2 | 9 | 28853 | 34 | |||
147470 | 196484 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6014481.0981 | 2112803.55306 | 37.7821698664821 | -122.393547301273 | (37.7821698664821, -122.393547301273) | 6 | 2 | 9 | 28856 | 6 | |||
147787 | 57783 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 132 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/1977 12:00:00 AM | 5 | Permit Number 16708 | 6010300.60698 | 2110589.59695 | 37.7758576905205 | -122.407853819819 | (37.7758576905205, -122.407853819819) | 8 | 2 | 9 | 28853 | 34 | ||
148214 | 38237 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 81 Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | 8 | Permit Number 40353 | 6010112.77454 | 2110816.57283 | 37.7764703959168 | -122.408519597801 | (37.7764703959168, -122.408519597801) | 8 | 2 | 9 | 28853 | 34 | ||
152349 | 88202 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 436 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51208 | 6011181.03672 | 2112067.6395 | 37.7799653025987 | -122.404912259701 | (37.7799653025987, -122.404912259701) | 14 | 2 | 9 | 28853 | 34 | |
161112 | 196494 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 728 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012174.00966 | 2110114.91402 | 37.7746590219179 | -122.401339835074 | (37.7746590219179, -122.401339835074) | 14 | 2 | 9 | 28853 | 34 | |||
163654 | 96021 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 611 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767662 | 6007529 | 2113423 | 37.7834819785693 | -122.417642411696 | (37.7834819785693, -122.417642411696) | 7 | 9 | 9 | 28858 | 36 | |
168679 | 196500 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 468 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010880.72676 | 2112052.38014 | 37.7799066128255 | -122.405950096213 | (37.7799066128255, -122.405950096213) | 14 | 2 | 9 | 28853 | 34 | |||
168965 | 88758 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 990 Polk St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284 | 37.7858140902738 | -122.419668930825 | (37.7858140902738, -122.419668930825) | 13 | 9 | 9 | 28858 | 36 | ||
172790 | 196486 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Jack London Aly | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6014249.44841 | 2112687.41636 | 37.7818381074737 | -122.394340577066 | (37.7818381074737, -122.394340577066) | 6 | 2 | 9 | 28856 | 6 | |||
173357 | 104362 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
174057 | 44031 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 96 Lafayette St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52444 | 6007775.95033 | 2109430.42042 | 37.7725332035812 | -122.416505148587 | (37.7725332035812, -122.416505148587) | 8 | 2 | 9 | 28853 | 19 | |
177022 | 196427 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 25 McLea Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010117 | 2109248 | 37.7721636964118 | -122.408394314545 | (37.7721636964118, -122.408394314545) | 14 | 2 | 9 | 28853 | 34 | |||
179287 | 135984 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 625 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6007522.81969 | 2113458.34568 | 37.7835786814566 | -122.417666299282 | (37.7835786814566, -122.417666299282) | 7 | 9 | 9 | 28858 | 36 | |||
180426 | 104366 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
180637 | 63769 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2013 12:00:00 AM | 18 | 3x3 | Permit Number 768706 | 6013040.47104 | 2113998.55413 | 37.7853709106802 | -122.398615140189 | (37.7853709106802, -122.398615140189) | 6 | 2 | 9 | 28855 | 6 | |
183597 | 135986 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90 Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6007090.57681 | 2114177.29162 | 37.7855283990541 | -122.4192127123 | (37.7855283990541, -122.4192127123) | 13 | 9 | 9 | 28858 | 36 | |||
184202 | 40853 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 126 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | 11 | Permit Number 45449 | 6014213.93466 | 2112556.76874 | 37.781477404701 | -122.394454288235 | (37.781477404701, -122.394454288235) | 6 | 2 | 9 | 28856 | 6 | |
188115 | 104360 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
191463 | 85006 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 850 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49366 | 6010976 | 2110190 | 37.7747982776561 | -122.40548930108 | (37.7747982776561, -122.40548930108) | 14 | 2 | 9 | 28853 | 34 | ||||
191703 | 104979 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 423 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 2x3 | 6011155.37894 | 2112276.30906 | 37.7805368262604 | -122.405015718617 | (37.7805368262604, -122.405015718617) | 14 | 2 | 9 | 28853 | 34 | |||
192366 | 38239 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 81 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | 11 | Permit Number 40353 | 6010121.79913 | 2110806.9834 | 37.7764445709857 | -122.408487702448 | (37.7764445709857, -122.408487702448) | 8 | 2 | 9 | 28853 | 34 | ||
1166 | 196429 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 506 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010627.65958 | 2105903.22248 | 37.7630082841384 | -122.406392171455 | (37.7630082841384, -122.406392171455) | 8 | 4 | 8 | 28859 | 19 | |||
2321 | 48402 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 706 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2010 12:00:00 AM | Permit Number 53935 | 6012689.64928807 | 2104214.1545054 | 37.7584856101735 | -122.399141839868 | (37.7584856101735, -122.399141839868) | 10 | 3 | 8 | 28856 | 29 | |||
2473 | 88167 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 189 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 51184 | 6010014.6058 | 2087504.2072 | 37.7124542316575 | -122.407215472312 | (37.7124542316575, -122.407215472312) | 9 | 7 | 8 | 309 | 39 | |
2569 | 49452 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1483 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2003 12:00:00 AM | 4 | Permit Number 46386 | 6011771.85534 | 2101466.16969 | 37.7508890570981 | -122.402122808245 | (37.7508890570981, -122.402122808245) | 10 | 3 | 8 | 28856 | 29 | |
3431 | 80385 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1754 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011729.10125 | 2092748.56003 | 37.7269499630479 | -122.401657992736 | (37.7269499630479, -122.401657992736) | 10 | 3 | 8 | 58 | 1 | |||
3608 | 71395 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1553 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6015450.35777 | 2096531.9462 | 37.7375453329415 | -122.389057616714 | (37.7375453329415, -122.389057616714) | 10 | 3 | 8 | 58 | 1 | |||
4873 | 151570 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1300x Vermont St | 2 | Side Yard : Cutout | Tree | Private 2 | DPW | 06/22/2019 12:00:00 AM | 3 | Width 4ft | 6011393.71667 | 2102232.58713 | 37.7529723581964 | -122.403484369222 | (37.7529723581964, -122.403484369222) | 10 | 4 | 8 | 28859 | 19 | |
5062 | 80388 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1746 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011768.66094 | 2092717.74347 | 37.7268675545821 | -122.401519069956 | (37.7268675545821, -122.401519069956) | 10 | 3 | 8 | 58 | 1 | |||
7115 | 4034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2150 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/28/1995 12:00:00 AM | 3 | 3X3 | 6012617.9559004 | 2100994.1740901 | 37.7496402484926 | -122.399163766262 | (37.7496402484926, -122.399163766262) | 10 | 3 | 8 | 58 | 1 | ||
9279 | 196461 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 615 Mississippi St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6014144.28645 | 2104277.08263 | 37.7587393543665 | -122.39411542099 | (37.7587393543665, -122.39411542099) | 10 | 3 | 8 | 28856 | 29 | |||
13155 | 196442 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 971 Kansas St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 5ft | 6011633.49107 | 2103859.13783 | 37.7574518984069 | -122.402769561075 | (37.7574518984069, -122.402769561075) | 10 | 3 | 8 | 28856 | 29 | |||
13408 | 28246 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3326 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/2002 12:00:00 AM | 3 | 2X3 | 6011947.80562 | 2090200.17318 | 37.7199648154144 | -122.400722979282 | (37.7199648154144, -122.400722979282) | 10 | 7 | 8 | 309 | 28 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );