Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119557 | 119557 | 16584 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 745X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 5993146.002730001 | 2114812.03373 | 37.7864760417982 | -122.46750261028299 | (37.7864760417982, -122.467502610283) | |||
| 7927 | 7927 | 13089 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 722 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008909.0684 | 2120447.731 | 37.8028477316821 | -122.41336484235 | (37.8028477316821, -122.41336484235) | |||
| 154192 | 154192 | 214784 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 222 Fowler Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 50 | Width 8ft | 5997118.36808 | 2099147.53648 | 37.7436938709906 | -122.45262836023399 | (37.7436938709906, -122.452628360234) | |||
| 3528 | 3528 | 13088 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 722 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6008925.6016 | 2120449.3844 | 37.802853199751794 | -122.413307745784 | (37.8028531997518, -122.413307745784) | |||
| 123086 | 123086 | 22830 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 88 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5999067.1751904 | 2099480.26243 | 37.7447189259574 | -122.44591380563101 | (37.7447189259574, -122.445913805631) | |||
| 10613 | 10613 | 16409 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1186X Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | TR | 6001094.970430001 | 2087182.82135 | 37.7110685499383 | -122.43802139438401 | (37.7110685499383, -122.438021394384) | |||
| 18880 | 18880 | 25589 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1380X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6009160.7320011 | 2097455.9675674997 | 37.7397318376167 | -122.410869155933 | (37.7397318376167, -122.410869155933) | |||
| 20555 | 20555 | 10100 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 750 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/1995 12:00:00 AM | 40 | 2x2 | 6005607.26399 | 2104540.55602 | 37.758984597670896 | -122.423659132264 | (37.7589845976709, -122.423659132264) | ||
| 127444 | 127444 | 12766 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1816 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5989782.53842 | 2114745.3914099997 | 37.7860983011374 | -122.479134351427 | (37.7860983011374, -122.479134351427) | |||
| 123989 | 123989 | 215225 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 500x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 39 | 5995372.41973 | 2092668.0374099999 | 37.7258025558202 | -122.458196526156 | (37.7258025558202, -122.458196526156) | ||||
| 70402 | 70402 | 215201 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 100 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 8ft | 5993358.68485 | 2095957.8363599998 | 37.7347196153991 | -122.46539667472601 | (37.7347196153991, -122.465396674726) | |||
| 7425 | 7425 | 8168 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1160 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6002214.9627 | 2111253.4218 | 37.7772244047313 | -122.435871600468 | (37.7772244047313, -122.435871600468) | |||
| 73968 | 73968 | 187552 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2 Beeman Ln | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6012028.620569999 | 2088183.9402700001 | 37.7144331529482 | -122.400302089394 | (37.7144331529482, -122.400302089394) | ||||
| 22299 | 22299 | 179788 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6004749.24947 | 2094369.67329 | 37.731009216793296 | -122.425902563064 | (37.7310092167933, -122.425902563064) | ||||
| 63846 | 63846 | 179734 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 4ft | 6004925.53632 | 2094359.72977 | 37.7309918751589 | -122.42529240184601 | (37.7309918751589, -122.425292401846) | |||
| 71980 | 71980 | 196271 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Cashmere St | 1 | : 4 | Tree 1 | Private 1 | 31 | 6017110.310380001 | 2095865.5402400002 | 37.7358073912904 | -122.383271945238 | (37.7358073912904, -122.383271945238) | ||||
| 159363 | 159363 | 249970 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011737.037830001 | 2120086.51138 | 37.802014281606205 | -122.403553132272 | (37.8020142816062, -122.403553132272) | |||
| 167790 | 167790 | 179107 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Congdon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 3ft | 6004727.316269999 | 2093590.79678 | 37.7288693555286 | -122.425922967771 | (37.7288693555286, -122.425922967771) | |||
| 5843 | 5843 | 8073 | DPW Maintained 3 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 664 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6004507.0606 | 2111574.6856 | 37.77823645397079 | -122.42796539753 | (37.7782364539708, -122.42796539753) | |||
| 6496 | 6496 | 23490 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2500X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005777.87956 | 2119177.1307599996 | 37.799182688783496 | -122.424109961515 | (37.7991826887835, -122.424109961515) | |||
| 8873 | 8873 | 8201 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1360 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001243.6294 | 2111120.8056 | 37.7768050488635 | -122.439222237812 | (37.7768050488635, -122.439222237812) | |||
| 19524 | 19524 | 8290 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50 Garcia Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 8 | 5995181.45452 | 2099378.2291200003 | 37.7442161243666 | -122.45934239824899 | (37.7442161243666, -122.459342398249) | |||
| 20569 | 20569 | 26702 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 140 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1998 12:00:00 AM | 30 | 3X3 | 6006456.60108 | 2097572.163 | 37.739898885722 | -122.42022715296899 | (37.739898885722, -122.420227152969) | ||
| 21103 | 21103 | 10099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 750 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1995 12:00:00 AM | 30 | 2x2 | 6005606.10854 | 2104557.89173 | 37.7590321322447 | -122.423664360924 | (37.7590321322447, -122.423664360924) | ||
| 21684 | 21684 | 10064 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 512 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1991 12:00:00 AM | 30 | 3X3 | 6005527.25593 | 2105966.68025 | 37.762895882361 | -122.42403725491 | (37.762895882361, -122.42403725491) | ||
| 25266 | 25266 | 215207 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 160 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 8ft | 5993414.72395 | 2095618.6966 | 37.7337916535606 | -122.465178304956 | (37.7337916535606, -122.465178304956) | |||
| 53144 | 53144 | 215210 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 175 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 8ft | 5993443.73697 | 2095631.67692 | 37.7338289673255 | -122.46507894154101 | (37.7338289673255, -122.465078941541) | |||
| 77008 | 77008 | 215208 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 170 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 8ft | 5993433.56613 | 2095587.2868599999 | 37.7337064967398 | -122.465110881879 | (37.7337064967398, -122.465110881879) | |||
| 78765 | 78765 | 122579 | Undocumented 2 | Prunus spp :: Cherry 84 | 2500X Lyon St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
| 102338 | 102338 | 10097 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 744 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X2 | 6005593.39843 | 2104652.72108 | 37.759291793936896 | -122.423715061076 | (37.7592917939369, -122.423715061076) | |||
| 108715 | 108715 | 26900 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 Amber Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/1999 12:00:00 AM | 30 | 3X3 | 5999908.8159045 | 2099289.8400101 | 37.7442440939699 | -122.44298991141001 | (37.7442440939699, -122.44298991141) | ||
| 149801 | 149801 | 236542 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 338 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 3ft | 6006772.4740699995 | 2097100.6709599998 | 37.738622066960204 | -122.419101558803 | (37.7386220669602, -122.419101558803) | |||
| 49497 | 49497 | 215224 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 400x Miramar Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 5995369.41897 | 2092571.1657099999 | 37.7255363969609 | -122.45819989143101 | (37.7255363969609, -122.458199891431) | ||||
| 65481 | 65481 | 215206 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 160 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 8ft | 5993391.84031 | 2095665.5531400002 | 37.73391899035779 | -122.465260822253 | (37.7339189903578, -122.465260822253) | |||
| 28833 | 28833 | 249969 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 28 | Width 0ft | 6011730.79134 | 2120085.86253 | 37.802012151107704 | -122.403574702535 | (37.8020121511077, -122.403574702535) | |||
| 42763 | 42763 | 241020 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 305 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 2ft | 6008973.83234 | 2096817.1945900002 | 37.737967424348795 | -122.411470260845 | (37.7379674243488, -122.411470260845) | |||
| 57778 | 57778 | 124704 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2x Cherry St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5996074.417169999 | 2115943.0366 | 37.789750104458 | -122.457452946984 | (37.789750104458, -122.457452946984) | ||||
| 63847 | 63847 | 215228 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 469 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5995237.23604 | 2098198.29542 | 37.7409795263953 | -122.459064099442 | (37.7409795263953, -122.459064099442) | |||
| 131775 | 131775 | 179759 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 10ft | 6004857.12989 | 2094362.0082599998 | 37.7309942664668 | -122.425529056646 | (37.7309942664668, -122.425529056646) | |||
| 133994 | 133994 | 132192 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2x Cherry St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5996086.73681 | 2115931.64437 | 37.789719532087396 | -122.457409497957 | (37.7897195320874, -122.457409497957) | ||||
| 163033 | 163033 | 238206 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 427 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6003541.496590001 | 2103297.00416 | 37.7554532756756 | -122.43071478496599 | (37.7554532756756, -122.430714784966) | |||
| 29456 | 29456 | 179778 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 10ft | 6004787.32766 | 2094370.8495200002 | 37.731014598327796 | -122.42577100392799 | (37.7310145983278, -122.425771003928) | |||
| 33287 | 33287 | 118775 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 630 45th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 27 | Width 2ft | 5981986.088380001 | 2111427.82901 | 37.7765333919608 | -122.50586147692101 | (37.7765333919608, -122.505861476921) | |||
| 37934 | 37934 | 249882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 27 | Width 0ft | 6011509.072430001 | 2120419.3733099997 | 37.8029155030083 | -122.40436544761499 | (37.8029155030083, -122.404365447615) | |||
| 43191 | 43191 | 196350 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6011973.312390001 | 2105136.40204 | 37.7609779512911 | -122.401684090158 | (37.7609779512911, -122.401684090158) | ||||
| 72281 | 72281 | 196286 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6012387.37414 | 2104738.06992 | 37.7599073164914 | -122.40022404532301 | (37.7599073164914, -122.400224045323) | ||||
| 131981 | 131981 | 215211 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 165 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 8ft | 5993424.832330001 | 2095670.3673599998 | 37.733934111557204 | -122.46514710927299 | (37.7339341115572, -122.465147109273) | |||
| 135145 | 135145 | 236977 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1495 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6008041.9336 | 2099491.9749 | 37.745259465660794 | -122.414881558454 | (37.7452594656608, -122.414881558454) | |||
| 176382 | 176382 | 84726 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 20 Cherry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2007 12:00:00 AM | 27 | Permit No. 49296 | 5996103.83143 | 2115975.82593 | 37.7898418245875 | -122.457353550252 | (37.7898418245875, -122.457353550252) | ||
| 41984 | 41984 | 135853 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 12 Filbert St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | 6012286.0131 | 2120198.4327700003 | 37.8023522396158 | -122.40166127704799 | (37.8023522396158, -122.401661277048) | ||||
| 49695 | 49695 | 215215 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 135 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 8ft | 5993391.6514800005 | 2095878.3056299998 | 37.734503144986796 | -122.46527692371299 | (37.7345031449868, -122.465276923713) | |||
| 111598 | 111598 | 102286 | Undocumented 2 | Prunus spp :: Cherry 84 | 122 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2014 12:00:00 AM | 26 | 4x4 | Permit Number 772865 | 6000574.8 | 2102350.7 | 37.7526864299915 | -122.44090662134501 | (37.7526864299915, -122.440906621345) | |
| 131807 | 131807 | 249873 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 26 | Width 0ft | 6011670.78297 | 2120474.23594 | 37.8030751776447 | -122.403809705266 | (37.8030751776447, -122.403809705266) | |||
| 14606 | 14606 | 15049 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1125 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1999 12:00:00 AM | 25 | 8X15 | 6015485.0268 | 2096001.9904 | 37.7360921037992 | -122.388900760186 | (37.7360921037992, -122.388900760186) | ||
| 19447 | 19447 | 2552 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 59 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/1999 12:00:00 AM | 25 | 3X3 | 6001211.45267 | 2095788.41504 | 37.7347041848314 | -122.43823489701799 | (37.7347041848314, -122.438234897018) | ||
| 21590 | 21590 | 22829 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 88 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999388.64339 | 2099036.75019 | 37.743519498737896 | -122.44477036118299 | (37.7435194987379, -122.444770361183) | |||
| 101182 | 101182 | 13415 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 430 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 5 | 5999619.6561933 | 2097087.2734828999 | 37.7381798806191 | -122.443831547884 | (37.7381798806191, -122.443831547884) | |||
| 117979 | 117979 | 476 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1110X Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2x2 | 6005715.8108342 | 2102491.4524088 | 37.753364362762 | -122.42313807467801 | (37.753364362762, -122.423138074678) | |||
| 164430 | 164430 | 179738 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 4ft | 6004912.83024 | 2094358.6843700001 | 37.730988286873796 | -122.425336254571 | (37.7309882868738, -122.425336254571) | |||
| 188892 | 188892 | 122076 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 363 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5990564.43068 | 2112959.17169 | 37.7812392167443 | -122.47629871950399 | (37.7812392167443, -122.476298719504) | |||
| 18799 | 18799 | 11188 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995291.088769999 | 2099424.10153 | 37.7443483813689 | -122.45896663000299 | (37.7443483813689, -122.458966630003) | |||
| 22042 | 22042 | 11684 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 700X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 2X2 | 5991290.8523 | 2092837.83415 | 37.7260333983166 | -122.472318441749 | (37.7260333983166, -122.472318441749) | |||
| 30557 | 30557 | 215212 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 165 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 8ft | 5993408.7609 | 2095708.9649099999 | 37.7340391640776 | -122.465205475246 | (37.7340391640776, -122.465205475246) | |||
| 30789 | 30789 | 236735 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2235 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | Width 8ft | 6002728.24168 | 2098985.0046599996 | 37.7435674334864 | -122.433219176525 | (37.7435674334864, -122.433219176525) | |||
| 34179 | 34179 | 197887 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1493 Kansas St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 6ft | 6011776.638040001 | 2101418.39447 | 37.7507581436897 | -122.40210291074699 | (37.7507581436897, -122.402102910747) | |||
| 67654 | 67654 | 215214 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 135 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 8ft | 5993392.86665 | 2095839.1505 | 37.7343957048025 | -122.465269879313 | (37.7343957048025, -122.465269879313) | |||
| 76837 | 76837 | 249945 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 325 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 0ft | 6011292.48387 | 2120026.50548 | 37.8018246784261 | -122.40508728037399 | (37.8018246784261, -122.405087280374) | |||
| 143081 | 143081 | 13118 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1633 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6004565.4050748 | 2119750.0667864 | 37.800687292153896 | -122.428346396238 | (37.8006872921539, -122.428346396238) | |||
| 174884 | 174884 | 196137 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 801 Arkansas St | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6013055.93777 | 2103788.3405299997 | 37.757336823850295 | -122.397845173025 | (37.7573368238503, -122.397845173025) | ||||
| 187970 | 187970 | 179765 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 10ft | 6004837.08963 | 2094365.9052400002 | 37.731003834354794 | -122.42559861649599 | (37.7310038343548, -122.425598616496) | |||
| 45051 | 45051 | 238283 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 119 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002051.74393 | 2105136.9168599998 | 37.760420717867206 | -122.435998447696 | (37.7604207178672, -122.435998447696) | |||
| 73796 | 73796 | 236843 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Woodland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5997044.29314 | 2105904.62743 | 37.7622429124985 | -122.45337223805001 | (37.7622429124985, -122.45337223805) | |||
| 154458 | 154458 | 196297 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1501 22nd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6013586.24242 | 2103799.53475 | 37.7573970793204 | -122.396011941921 | (37.7573970793204, -122.396011941921) | ||||
| 161733 | 161733 | 196296 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 383 Arkansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 9ft | 6012973.423830001 | 2105290.2988400003 | 37.7614562764103 | -122.398235915848 | (37.7614562764103, -122.398235915848) | |||
| 2229 | 2229 | 43306 | DPW Maintained 3 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 693 Vermont St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/12/2000 12:00:00 AM | 22 | Permit Number 43072 | 6011289.47877 | 2105149.93268 | 37.7609769197604 | -122.404050137204 | (37.7609769197604, -122.404050137204) | |
| 6855 | 6855 | 30870 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1922 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2013 12:00:00 AM | 22 | 3x3 | Permit Number 770521 | 6001989.3306 | 2115172.0478 | 37.787971137606895 | -122.436932736614 | (37.7879711376069, -122.436932736614) | |
| 35447 | 35447 | 215218 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 133 San Buenaventura Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 8ft | 5993390.45214 | 2095959.7776 | 37.734726777609296 | -122.465286986206 | (37.7347267776093, -122.465286986206) | |||
| 40224 | 40224 | 215216 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 133 San Buenaventura Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 8ft | 5993391.28977 | 2095902.6603400002 | 37.7345699961108 | -122.465279942742 | (37.7345699961108, -122.465279942742) | |||
| 52392 | 52392 | 136587 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2900 Steiner St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 1ft | 6002061.91311 | 2118175.42459 | 37.796221759089605 | -122.436896706732 | (37.7962217590896, -122.436896706732) | |||
| 68637 | 68637 | 179787 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 6004755.58459 | 2094369.3250900002 | 37.7310086187332 | -122.425880636693 | (37.7310086187332, -122.425880636693) | ||||
| 120872 | 120872 | 62780 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 83 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | 22 | Permit Number 23135 | 5999908.40819 | 2091902.69493 | 37.7239607020173 | -122.44246107033301 | (37.7239607020173, -122.442461070333) | |
| 157870 | 157870 | 215205 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 130 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 8ft | 5993367.47996 | 2095754.56333 | 37.7341619853887 | -122.465351506265 | (37.7341619853887, -122.465351506265) | |||
| 174521 | 174521 | 215264 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2339 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5992605.31115 | 2099537.9854 | 37.7445063230134 | -122.468261685453 | (37.7445063230134, -122.468261685453) | |||
| 175316 | 175316 | 235818 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1100 San Jose Ave | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6004748.03107 | 2096617.2038599998 | 37.7371803628754 | -122.426066713609 | (37.7371803628754, -122.426066713609) | ||||
| 31550 | 31550 | 237051 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1385 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6010363.50755 | 2101264.14929 | 37.7502556447887 | -122.406978792951 | (37.7502556447887, -122.406978792951) | |||
| 47915 | 47915 | 213379 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1229 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5993586.097030001 | 2107103.8483700003 | 37.7653368303421 | -122.46541985384701 | (37.7653368303421, -122.465419853847) | |||
| 50599 | 50599 | 236867 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1241 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5997443.07165 | 2105470.58706 | 37.7610739970807 | -122.451961705395 | (37.7610739970807, -122.451961705395) | |||
| 56687 | 56687 | 238466 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 48 Potomac St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6003144.15321 | 2108572.53902 | 37.7699161017881 | -122.43246570654301 | (37.7699161017881, -122.432465706543) | |||
| 58171 | 58171 | 62166 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 92 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | 21 | Permit Number 23136 | 5999904.31715 | 2091941.2410400002 | 37.7240663075915 | -122.44247797848301 | (37.7240663075915, -122.442477978483) | |
| 72283 | 72283 | 238188 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 249 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6003535.9156 | 2101543.50295 | 37.750638258661105 | -122.430608968043 | (37.7506382586611, -122.430608968043) | |||
| 75002 | 75002 | 237978 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 25 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5998568.181969999 | 2106878.54944 | 37.7650042880525 | -122.44817183545901 | (37.7650042880525, -122.448171835459) | |||
| 181592 | 181592 | 141558 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2 Loyola Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5998461.482000001 | 2110747.8394 | 37.775622271390006 | -122.448819607803 | (37.77562227139, -122.448819607803) | |||
| 187897 | 187897 | 179760 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 10ft | 6004853.85523 | 2094362.29345 | 37.730994864507 | -122.425540397994 | (37.730994864507, -122.425540397994) | |||
| 8129 | 8129 | 57513 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1534 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1976 12:00:00 AM | 20 | 3x3 | Permit Number 16366 | 6000152.6691 | 2114258.7858 | 37.7853589960394 | -122.443221617032 | (37.7853589960394, -122.443221617032) | |
| 10080 | 10080 | 10041 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 360 Guerrero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1991 12:00:00 AM | 20 | 3X3 | 6005475.31081 | 2106892.46038 | 37.765434922114295 | -122.42428276264299 | (37.7654349221143, -122.424282762643) | ||
| 18701 | 18701 | 22848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 1X1 | 5999801.2823 | 2099039.75864 | 37.743551298748 | -122.44334377921601 | (37.743551298748, -122.443343779216) | |||
| 19778 | 19778 | 10042 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 360 Guerrero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005475.5325 | 2106875.27322 | 37.7653877427782 | -122.424280773365 | (37.7653877427782, -122.424280773365) | |||
| 19919 | 19919 | 22857 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 140 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 5999962.5857 | 2099158.01646 | 37.743885203545396 | -122.442794523662 | (37.7438852035454, -122.442794523662) | ||||
| 20053 | 20053 | 5099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2621 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002328.495730001 | 2096416.0838900001 | 37.736491088285796 | -122.434417765086 | (37.7364910882858, -122.434417765086) | |||
| 20708 | 20708 | 10039 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 360 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1991 12:00:00 AM | 20 | 3X3 | 6005477.1925800005 | 2106955.99773 | 37.765609486820004 | -122.424280773358 | (37.76560948682, -122.424280773358) |
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");