trees
4,014 rows where qSpecies_id = 40 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21104 | 237098 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 494 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005544.2957 | 2107858.77307 | 37.768092081506 | -122.4241128861 | (37.768092081506, -122.4241128861) | 8 | 4 | 5 | 28853 | 19 | |||
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 | |||
28749 | 237097 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 494 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005558.8545 | 2107858.94862 | 37.7680933855167 | -122.424062541178 | (37.7680933855167, -122.424062541178) | 8 | 4 | 5 | 28853 | 19 | |||
30026 | 36031 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1660X BRYANT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1998 12:00:00 AM | 3x3 | Permit Number 39178 | 6009346 | 2106886 | 37.7656349852358 | -122.410894426294 | (37.7656349852358, -122.410894426294) | 8 | 4 | 7 | 28853 | 19 | ||
30334 | 52177 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1X Albion St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2005 12:00:00 AM | Permit Number 48366 | 6005910.85537193 | 2107243.06588365 | 37.766422185477 | -122.422801230733 | (37.766422185477, -122.422801230733) | 8 | 4 | 5 | 28853 | 19 | |||
30595 | 237093 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006628.38963 | 2107330.3055 | 37.7667021837902 | -122.420325599041 | (37.7667021837902, -122.420325599041) | 8 | 4 | 7 | 28853 | 19 | |||
31331 | 110515 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
34005 | 238037 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Elgin Park | 2 | : | Tree | Private 2 | 3 | Width 2ft | 6005845.91582 | 2108560.69634 | 37.770036420279 | -122.423119511166 | (37.770036420279, -122.423119511166) | 8 | 2 | 5 | 28853 | 19 | |||
34471 | 237092 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006640.82063 | 2107331.42339 | 37.766705953729 | -122.420282681595 | (37.766705953729, -122.420282681595) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
41064 | 110513 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
42066 | 237057 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Albion St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6005792.84324 | 2107206.95019 | 37.7663163611242 | -122.423206846131 | (37.7663163611242, -122.423206846131) | 8 | 4 | 5 | 28853 | 19 | |||
42333 | 237115 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Hwy 101 Southbound | 6 | Back Yard : Yard | Tree | Private 2 | 6 | 6005846.05822 | 2108984.84199 | 37.7712010306339 | -122.423149171694 | (37.7712010306339, -122.423149171694) | 8 | 2 | 5 | 28853 | 19 | ||||
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 | ||
45958 | 91135 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 480 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2009 12:00:00 AM | 3x3 | Permit Number 52024 | 6005604 | 2107874.4 | 37.7681383601012 | -122.423907486341 | (37.7681383601012, -122.423907486341) | 8 | 4 | 5 | 28853 | 19 | ||
53799 | 237116 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100 Hwy 101 Southbound | 4 | Back Yard : Yard | Tree | Private 2 | 5 | 6005840.35144 | 2109000.46624 | 37.7712436090254 | -122.423170022474 | (37.7712436090254, -122.423170022474) | 8 | 2 | 5 | 28853 | 19 | ||||
55088 | 237044 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1650 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009421.66766 | 2107070.91245 | 37.7661469549539 | -122.410645766889 | (37.7661469549539, -122.410645766889) | 8 | 4 | 7 | 28853 | 19 | |||
57105 | 10022 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 282 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/01/2003 12:00:00 AM | 3 | 2x2 | 6005445.78054 | 2107378.48496 | 37.7667677623348 | -122.424419474005 | (37.7667677623348, -122.424419474005) | 8 | 4 | 5 | 28853 | 19 | ||
57981 | 110511 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
59447 | 52174 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1X Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2005 12:00:00 AM | Permit Number 48366 | 6005910.85537193 | 2107243.06588365 | 37.766422185477 | -122.422801230733 | (37.766422185477, -122.422801230733) | 8 | 4 | 5 | 28853 | 19 | |||
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 | |
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 | ||
68282 | 237087 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006704.33245 | 2107335.95471 | 37.7667219742591 | -122.420063326182 | (37.7667219742591, -122.420063326182) | 8 | 4 | 7 | 28853 | 19 | |||
68676 | 41285 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 494 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52403 | 6005499.65147882 | 2107857.73967205 | 37.7680867232876 | -122.424267232407 | (37.7680867232876, -122.424267232407) | 8 | 4 | 5 | 28853 | 19 | ||
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 | |||
72223 | 110504 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
75075 | 238039 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 89 Elgin Park | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6005843.94387 | 2108584.75014 | 37.7701023549756 | -122.423128042119 | (37.7701023549756, -122.423128042119) | 8 | 2 | 5 | 28853 | 19 | |||
75202 | 237086 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1401 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007954.52985 | 2107363.66833 | 37.7668684288492 | -122.415741054914 | (37.7668684288492, -122.415741054914) | 8 | 4 | 7 | 28853 | 19 | |||
75881 | 237088 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006692.25312 | 2107335.17282 | 37.7667191467912 | -122.420105051126 | (37.7667191467912, -122.420105051126) | 8 | 4 | 7 | 28853 | 19 | |||
76301 | 237094 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006486.26316 | 2107324.29875 | 37.7666776808499 | -122.420816764707 | (37.7666776808499, -122.420816764707) | 8 | 4 | 7 | 28853 | 19 | |||
76594 | 112568 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 455 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2015 12:00:00 AM | 3x3 | 6005755.8 | 2107791.7 | 37.7679198543098 | -122.423376545374 | (37.7679198543098, -122.423376545374) | 8 | 4 | 5 | 28853 | 19 | |||
80762 | 237043 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1650 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009416.72211 | 2107184.85565 | 37.7664595394906 | -122.410670920049 | (37.7664595394906, -122.410670920049) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
82701 | 237096 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 241 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005143.80451 | 2108206.06179 | 37.7690230327243 | -122.425522862995 | (37.7690230327243, -122.425522862995) | 8 | 4 | 5 | 28853 | 19 | |||
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 | ||
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 | |
104145 | 110510 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
104553 | 196462 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 199 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010596.91402 | 2107497.22593 | 37.7673833356888 | -122.406610845212 | (37.7673833356888, -122.406610845212) | 8 | 4 | 8 | 28853 | 19 | |||
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 | |||
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 | |||
114466 | 237045 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1650 Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009424.6793 | 2107033.19319 | 37.7660435553884 | -122.41063268625 | (37.7660435553884, -122.41063268625) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
115647 | 110505 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
118140 | 237046 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1650 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009426.03353 | 2107014.04663 | 37.7659910592617 | -122.410626650002 | (37.7659910592617, -122.410626650002) | 8 | 4 | 7 | 28853 | 19 | |||
122179 | 110509 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |
126037 | 110508 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
137434 | 110516 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
138037 | 110507 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
142977 | 237056 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Albion St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6005793.31637 | 2107190.9812 | 37.7662725407724 | -122.423204074428 | (37.7662725407724, -122.423204074428) | 8 | 4 | 5 | 28853 | 19 | |||
143147 | 237089 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006678.09953 | 2107334.09058 | 37.7667153777448 | -122.420153929277 | (37.7667153777448, -122.420153929277) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
144364 | 238040 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 49 Pearl St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6005642.22428 | 2108761.00256 | 37.7705749163322 | -122.423838323102 | (37.7705749163322, -122.423838323102) | 8 | 2 | 5 | 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 | |||
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 | |
157397 | 237090 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006663.58723 | 2107332.32887 | 37.766709722802 | -122.420203999914 | (37.766709722802, -122.420203999914) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
162658 | 52173 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1X Albion St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2005 12:00:00 AM | Permit Number 48366 | 6005910.85537193 | 2107243.06588365 | 37.766422185477 | -122.422801230733 | (37.766422185477, -122.422801230733) | 8 | 4 | 5 | 28853 | 19 | |||
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 | |||
172702 | 237091 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006652.56263 | 2107332.55511 | 37.7667097228027 | -122.420242148266 | (37.7667097228027, -122.420242148266) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |
174989 | 110512 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 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 | |||
177924 | 110506 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
178354 | 237054 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6005797.63986 | 2107141.4188 | 37.7661366981867 | -122.423185596933 | (37.7661366981867, -122.423185596933) | 8 | 4 | 5 | 28853 | 19 | |||
181743 | 237055 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Albion St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6005794.81287 | 2107159.83009 | 37.7661870916781 | -122.423196683796 | (37.7661870916781, -122.423196683796) | 8 | 4 | 5 | 28853 | 19 | |||
184491 | 237095 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6006471.77901 | 2107323.90958 | 37.7666757958826 | -122.420866835358 | (37.7666757958826, -122.420866835358) | 8 | 4 | 7 | 28853 | 19 | |||
188709 | 106920 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6006764 | 2107336 | 37.76672546023 | -122.419856949025 | (37.76672546023, -122.419856949025) | 8 | 4 | 7 | 28853 | 19 | ||||
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 | ||
193622 | 110514 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |
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 | |||
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 | |
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 | |||
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 | |||
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 | ||||
15749 | 108724 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 566 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773100 | 6011759.6093 | 2105732.18704 | 37.7626019164795 | -122.402465094694 | (37.7626019164795, -122.402465094694) | 8 | 3 | 8 | 28856 | 29 |
16871 | 83424 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 987 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6012206.17554 | 2103813.08601 | 37.7573574093248 | -122.400785742066 | (37.7573574093248, -122.400785742066) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||||
18514 | 79061 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1006 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6012156.57413 | 2103666.55961 | 37.7569523133274 | -122.400946989616 | (37.7569523133274, -122.400946989616) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||||
22886 | 27724 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1200 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015353.11348 | 2101161.82636 | 37.750252634764 | -122.389717121075 | (37.750252634764, -122.389717121075) | 10 | 3 | 8 | 28856 | 1 | ||
30199 | 196446 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 701 Wisconsin St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012741.003 | 2104236.29493 | 37.7585492646472 | -122.398965788556 | (37.7585492646472, -122.398965788556) | 10 | 3 | 8 | 28856 | 29 | |||
31187 | 27731 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015524.1696 | 2101161.19501 | 37.7502603851148 | -122.38912554882 | (37.7502603851148, -122.38912554882) | 10 | 3 | 8 | 28856 | 1 |
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) );