Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2577 | 2577 | 42596 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1950 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 11 | 3x3 | Permit Number 42667 | 6005477.78345 | 2116550.81967 | 37.791954555107296 | -122.424961440544 | (37.7919545551073, -122.424961440544) | |
| 6913 | 6913 | 42637 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x4 | Permit Number 42688 | 6005203.48268 | 2118840.06651 | 37.7982247489172 | -122.42607356463999 | (37.7982247489172, -122.42607356464) |
| 7033 | 7033 | 42641 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1651 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 22 | 5x5 | Permit Number 42688 | 6005090.06351 | 2118821.9865599996 | 37.798168695097296 | -122.426464740961 | (37.7981686950973, -122.426464740961) |
| 7085 | 7085 | 42636 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x5 | Permit Number 42688 | 6005181.30457 | 2118838.80185 | 37.7982200229931 | -122.426150217479 | (37.7982200229931, -122.426150217479) |
| 7354 | 7354 | 42635 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x5 | Permit Number 42688 | 6005113.3477300005 | 2118824.42387 | 37.7981767035488 | -122.426384344263 | (37.7981767035488, -122.426384344263) |
| 7911 | 7911 | 42632 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x4 | Permit Number 42688 | 6005134.3142099995 | 2118828.07494 | 37.7981879136105 | -122.42631205408199 | (37.7981879136105, -122.426312054082) |
| 17915 | 17915 | 42604 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2000 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42672 | 6005206.416391299 | 2116498.11175578 | 37.791794500383794 | -122.425896619276 | (37.7917945003838, -122.425896619276) | ||
| 19134 | 19134 | 42608 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1775 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42675 | 6004555.83509625 | 2118398.4069888 | 37.796975439849 | -122.428283124742 | (37.796975439849, -122.428283124742) | ||
| 21198 | 21198 | 42536 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42642 | 6006853.97359683 | 2109407.99798814 | 37.772419743979896 | -122.419692774816 | (37.7724197439799, -122.419692774816) | ||
| 23823 | 23823 | 42743 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 295 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42737 | 6012647.1314 | 2087116.87515 | 37.7115376741026 | -122.398089440585 | (37.7115376741026, -122.398089440585) | ||
| 24146 | 24146 | 42768 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 837 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42744 | 6003836.146000001 | 2110735.9706 | 37.7758955707266 | -122.430226485287 | (37.7758955707266, -122.430226485287) | ||
| 24471 | 24471 | 42601 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2554 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42671 | 6005368.83302 | 2118821.0293400004 | 37.798181821601894 | -122.425500047192 | (37.7981818216019, -122.425500047192) | |
| 26098 | 26098 | 42705 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1035 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42722 | 6008002.308069999 | 2119233.94027 | 37.799464014698 | -122.41641668139499 | (37.799464014698, -122.416416681395) | |
| 27715 | 27715 | 42726 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1790 Yosemite Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42732 | 6013650.2169699995 | 2093413.4098599998 | 37.728882521597704 | -122.395063232696 | (37.7288825215977, -122.395063232696) | |
| 30888 | 30888 | 42696 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1751 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42713 | 6007796.58473 | 2118447.48214 | 37.7972930261196 | -122.417072803384 | (37.7972930261196, -122.417072803384) | |
| 32054 | 32054 | 42625 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1844 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42683 | 6004409.1039 | 2115238.2303 | 37.7882900931927 | -122.42856547432 | (37.7882900931927, -122.42856547432) | |
| 33214 | 33214 | 42542 | Permitted Site 1 | Cinnamomum camphora :: Camphor Tree 230 | 1011 23rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 2 | Permit Number 42643 | 6015259.27202 | 2102962.92018 | 37.755192853577 | -122.390167446697 | (37.755192853577, -122.390167446697) | ||
| 35351 | 35351 | 42685 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2335 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 8 | Permit Number 42709 | 6006717.2254 | 2119230.45195 | 37.7993820864644 | -122.420863284838 | (37.7993820864644, -122.420863284838) | |
| 37909 | 37909 | 42654 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2535 40th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42692 | 5983943.6088 | 2097975.8071 | 37.7397129317641 | -122.49809628306002 | (37.7397129317641, -122.49809628306) | |
| 38602 | 38602 | 42610 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1778 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42677 | 6004517.51154 | 2118442.44969 | 37.797094201301604 | -122.428418874228 | (37.7970942013016, -122.428418874228) | |
| 39437 | 39437 | 42652 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2535 40th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 3 | Permit Number 42692 | 5983937.5442 | 2098055.9454 | 37.7399326142193 | -122.49812316833099 | (37.7399326142193, -122.498123168331) | |
| 40411 | 40411 | 42617 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1790 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 8 | Permit Number 42679 | 6004487.31439 | 2118438.14954 | 37.7970806853794 | -122.42852305711901 | (37.7970806853794, -122.428523057119) | |
| 45061 | 45061 | 42647 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1800 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42689 | 6004863.7405 | 2118145.59195 | 37.7962986915986 | -122.427199680427 | (37.7962986915986, -122.427199680427) | ||
| 46606 | 46606 | 42787 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 413 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42754 | 6004586.33786017 | 2109969.42501453 | 37.773833286350396 | -122.427576752843 | (37.7738332863504, -122.427576752843) | |
| 49656 | 49656 | 42548 | Permitted Site 1 | Cinnamomum camphora :: Camphor Tree 230 | 1011 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 1 | Permit Number 42643 | 6015220.332780001 | 2102962.64952 | 37.755189950556996 | -122.39030209226699 | (37.755189950557, -122.390302092267) | ||
| 50109 | 50109 | 42729 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1790 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 9 | Permit Number 42732 | 6013696.1592 | 2093377.289 | 37.7287858957511 | -122.394901877244 | (37.7287858957511, -122.394901877244) | |
| 50910 | 50910 | 42731 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1790 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 10 | Permit Number 42732 | 6013724.8374 | 2093355.68235 | 37.728728162867604 | -122.394801221522 | (37.7287281628676, -122.394801221522) | |
| 52320 | 52320 | 38502 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2440 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42685 | 6006711.92416 | 2119615.77365 | 37.8004397836378 | -122.420909000977 | (37.8004397836378, -122.420909000977) | |
| 53443 | 53443 | 42672 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42700 | 6008565.6692 | 2121051.5528 | 37.80448638863479 | -122.414595938174 | (37.8044863886348, -122.414595938174) | |
| 56123 | 56123 | 42681 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42705 | 6006130.25606 | 2119709.67411 | 37.800664806599606 | -122.422928486179 | (37.8006648065996, -122.422928486179) | |
| 56980 | 56980 | 42624 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1838 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42682 | 6004413.9764 | 2115198.364 | 37.788180906101 | -122.42854577347201 | (37.788180906101, -122.428545773472) | |
| 57389 | 57389 | 42718 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 250 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 9 | Permit Number 42731 | 6012956.49189 | 2095364.4543700002 | 37.7342010861064 | -122.397598289347 | (37.7342010861064, -122.397598289347) | |
| 58445 | 58445 | 42730 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1790 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 3 | Permit Number 42732 | 6013704.8979400005 | 2093369.80818 | 37.728765840846705 | -122.39487114291 | (37.7287658408467, -122.39487114291) | |
| 58518 | 58518 | 42618 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 1615 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 11 | Permit Number 42680 | 6005139.94855 | 2119525.3007400003 | 37.800102635872506 | -122.426342225416 | (37.8001026358725, -122.426342225416) | |
| 58722 | 58722 | 42712 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1451 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42724 | 6006618.85507529 | 2118340.07511889 | 37.7969317909654 | -122.42114042440001 | (37.7969317909654, -122.4211404244) | ||
| 59086 | 59086 | 42720 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1790 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 9 | Permit Number 42732 | 6013734.25158 | 2093348.6306900003 | 37.7287093238776 | -122.394768182227 | (37.7287093238776, -122.394768182227) | |
| 59399 | 59399 | 42680 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42705 | 6006144.13607 | 2119711.1736 | 37.800669706999 | -122.42288056219401 | (37.800669706999, -122.422880562194) | |
| 61630 | 61630 | 42600 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2226 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42670 | 6003830.77571 | 2116325.44496 | 37.7912425636483 | -122.430644005628 | (37.7912425636483, -122.430644005628) | |
| 61689 | 61689 | 42736 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2155 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.712590845234296 | -122.400920338197 | (37.7125908452343, -122.400920338197) | ||
| 62082 | 62082 | 42541 | Permitted Site 1 | Cinnamomum camphora :: Camphor Tree 230 | 1011 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 8 | Permit Number 42643 | 6015248.2899 | 2102962.43718 | 37.7551909182313 | -122.390205392677 | (37.7551909182313, -122.390205392677) | ||
| 62259 | 62259 | 42628 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1999X Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 17 | Permit Number 42684 | 6004090.88731 | 2117989.41245 | 37.795826126623794 | -122.429862767246 | (37.7958261266238, -122.429862767246) | |
| 62315 | 62315 | 42683 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2200 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42708 | 6006824.96132 | 2118796.46674 | 37.7981965444044 | -122.42045965830401 | (37.7981965444044, -122.420459658304) | |
| 66925 | 66925 | 42593 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 18 | Permit Number 42666 | 6004942.09948 | 2117812.91349 | 37.7953896721531 | -122.42690483678601 | (37.7953896721531, -122.426904836786) | |
| 67811 | 67811 | 42713 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1740 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 8 | Permit Number 42726 | 6014522.39227 | 2095210.25322 | 37.7338647513416 | -122.392173650716 | (37.7338647513416, -122.392173650716) | |
| 68904 | 68904 | 42539 | Permitted Site 1 | Cinnamomum camphora :: Camphor Tree 230 | 1011 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42643 | 6015188.77329 | 2102959.76224 | 37.75518027207529 | -122.390411033451 | (37.7551802720753, -122.390411033451) | ||
| 70449 | 70449 | 42715 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 43 Pomona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 10 | Permit Number 42728 | 6014158.74539 | 2094459.1278900001 | 37.731782116644794 | -122.393378351035 | (37.7317821166448, -122.393378351035) | |
| 77162 | 77162 | 42763 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Buchanan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |||
| 77812 | 77812 | 42555 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 519 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | ||
| 78129 | 78129 | 42789 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 426 -28 -30 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42755 | 6004546.0 | 2110000.0 | 37.7739149561089 | -122.42771846696199 | (37.7739149561089, -122.427718466962) | ||
| 78680 | 78680 | 42784 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 180 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42752 | 6005674.99699727 | 2110173.44211567 | 37.774454985110296 | -122.423825410082 | (37.7744549851103, -122.423825410082) | ||
| 78985 | 78985 | 42571 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 240 San Fernando Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42653 | 5992105.55983914 | 2095227.71522931 | 37.7326425353626 | -122.469675980927 | (37.7326425353626, -122.469675980927) | |||
| 79449 | 79449 | 42553 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 82 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42645 | 5993073.36121291 | 2094485.358364 | 37.7306600968778 | -122.46627615105 | (37.7306600968778, -122.46627615105) | ||
| 79582 | 79582 | 42708 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1600 Union St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42723 | 6005315.92998199 | 2118904.40480493 | 37.7984077601464 | -122.42568904485 | (37.7984077601464, -122.42568904485) | |||
| 80098 | 80098 | 42773 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 595 Hayes St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42746 | 6005021.69046201 | 2110898.204752 | 37.7764081042584 | -122.426136930931 | (37.7764081042584, -122.426136930931) | ||
| 82077 | 82077 | 42546 | Permitted Site 1 | Cinnamomum camphora :: Camphor Tree 230 | 1011 23rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42643 | 6015278.958837001 | 2102962.15711273 | 37.7551918502677 | -122.39009931001301 | (37.7551918502677, -122.390099310013) | |||
| 82274 | 82274 | 42701 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1401 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42720 | 6008024.82454824 | 2099957.661983 | 37.746537177160604 | -122.41497367347401 | (37.7465371771606, -122.414973673474) | ||
| 82394 | 82394 | 42722 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1790 Yosemite Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42732 | 6013616.31802888 | 2093434.69648512 | 37.7289390851959 | -122.395181915037 | (37.7289390851959, -122.395181915037) | ||
| 82978 | 82978 | 42656 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 2535 40th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42692 | 5983940.43207636 | 2097907.45450521 | 37.7395250678136 | -122.49810222006901 | (37.7395250678136, -122.498102220069) | ||
| 83260 | 83260 | 42689 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 2500 Larkin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506045995 | 2119774.0082852 | 37.8008732765742 | -122.42098036158701 | (37.8008732765742, -122.420980361587) | |||
| 84050 | 84050 | 42545 | Permitted Site 1 | Cinnamomum camphora :: Camphor Tree 230 | 1011 23rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42643 | 6015278.958837001 | 2102962.15711273 | 37.7551918502677 | -122.39009931001301 | (37.7551918502677, -122.390099310013) | |||
| 84400 | 84400 | 42621 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1935 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42681 | 6004926.0999553 | 2117078.40533707 | 37.7933719944005 | -122.42690786074101 | (37.7933719944005, -122.426907860741) | |||
| 84456 | 84456 | 35589 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 59 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42715 | 6007013.60126505 | 2099209.55425367 | 37.744426166063 | -122.418417345369 | (37.744426166063, -122.418417345369) | ||
| 84537 | 84537 | 42566 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 301 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42651 | 5992913.86924171 | 2094884.15825329 | 37.7317458988107 | -122.466856514598 | (37.7317458988107, -122.466856514598) | ||
| 85516 | 85516 | 42721 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1790 Yosemite Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42732 | 6013616.31802888 | 2093434.69648512 | 37.7289390851959 | -122.395181915037 | (37.7289390851959, -122.395181915037) | ||
| 85562 | 85562 | 42761 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Buchanan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |||
| 85798 | 85798 | 42693 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2500 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 3 | 3x3 | Permit Number 42711 | 6006694.5506045995 | 2119774.0082852 | 37.8008732765742 | -122.42098036158701 | (37.8008732765742, -122.420980361587) | |
| 86242 | 86242 | 42581 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 175 San Rafael Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42660 | 5991893.22788807 | 2095086.42724375 | 37.732242319303104 | -122.47039977177499 | (37.7322423193031, -122.470399771775) | ||
| 87240 | 87240 | 42765 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |||
| 87241 | 87241 | 42758 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 65 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42741 | 6006721.87388992 | 2109543.46348291 | 37.772784257662295 | -122.420159337041 | (37.7727842576623, -122.420159337041) | ||
| 87829 | 87829 | 42622 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1935 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42681 | 6004926.0999553 | 2117078.40533707 | 37.7933719944005 | -122.42690786074101 | (37.7933719944005, -122.426907860741) | |||
| 88168 | 88168 | 42673 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42700 | 6008532.69397696 | 2121039.56256614 | 37.804451613820206 | -122.41470920319901 | (37.8044516138202, -122.414709203199) | ||
| 89848 | 89848 | 42757 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 65 Brady St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42741 | 6006721.87388992 | 2109543.46348291 | 37.772784257662295 | -122.420159337041 | (37.7727842576623, -122.420159337041) | |||
| 90034 | 90034 | 42692 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2500 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506045995 | 2119774.0082852 | 37.8008732765742 | -122.42098036158701 | (37.8008732765742, -122.420980361587) | |||
| 90288 | 90288 | 42615 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1791 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42678 | 6004482.657553299 | 2118388.26400306 | 37.7969434489311 | -122.428535613258 | (37.7969434489311, -122.428535613258) | |||
| 91259 | 91259 | 42580 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 161 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42659 | 5992414.36738179 | 2095647.79987072 | 37.73381382645321 | -122.468638922374 | (37.7338138264532, -122.468638922374) | |||
| 91702 | 91702 | 42611 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1791 Green St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42678 | 6004482.657553299 | 2118388.26400306 | 37.7969434489311 | -122.428535613258 | (37.7969434489311, -122.428535613258) | |||
| 91796 | 91796 | 42591 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 121 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42664 | 5991652.84779157 | 2095347.0788301998 | 37.7329441015396 | -122.471249796136 | (37.7329441015396, -122.471249796136) | ||
| 91899 | 91899 | 42764 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |||
| 92676 | 92676 | 42623 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1935 Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42681 | 6004926.0999553 | 2117078.40533707 | 37.7933719944005 | -122.42690786074101 | (37.7933719944005, -122.426907860741) | |||
| 92824 | 92824 | 40544 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 345 San Fernando Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42654 | 5992118.57883529 | 2094673.32580486 | 37.731121073004 | -122.46959062787501 | (37.731121073004, -122.469590627875) | ||
| 93365 | 93365 | 42582 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 185 San Rafael Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42661 | 5991890.25503734 | 2095041.13220649 | 37.7321177785894 | -122.470406751974 | (37.7321177785894, -122.470406751974) | ||
| 93460 | 93460 | 42558 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 569 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42647 | 5993311.64688617 | 2095009.94770187 | 37.73211423537111 | -122.465490462334 | (37.7321142353711, -122.465490462334) | ||
| 93484 | 93484 | 42563 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 201 San Benito Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42649 | 5992910.18577839 | 2095362.95085697 | 37.7330603317539 | -122.46690404336 | (37.7330603317539, -122.46690404336) | ||
| 94957 | 94957 | 42745 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 95509 | 95509 | 42585 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 307 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42662 | 5992649.56844103 | 2094840.54182045 | 37.731610881175605 | -122.467767077223 | (37.7316108811756, -122.467767077223) | ||
| 95859 | 95859 | 42786 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 269 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42753 | 6005259.26650222 | 2110063.08095744 | 37.774128482391205 | -122.425255647592 | (37.7741284823912, -122.425255647592) | ||
| 96433 | 96433 | 42687 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 2500 Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42711 | 6006694.5506045995 | 2119774.0082852 | 37.8008732765742 | -122.42098036158701 | (37.8008732765742, -122.420980361587) | ||
| 96597 | 96597 | 42644 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 10 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 96750 | 96750 | 42557 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 569 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42647 | 5993311.64688617 | 2095009.94770187 | 37.73211423537111 | -122.465490462334 | (37.7321142353711, -122.465490462334) | ||
| 97185 | 97185 | 42576 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 245 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42657 | 5992410.82570629 | 2095190.31186077 | 37.7325574740986 | -122.46861789084801 | (37.7325574740986, -122.468617890848) | ||
| 98494 | 98494 | 42724 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1790 Yosemite Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42732 | 6013616.31802888 | 2093434.69648512 | 37.7289390851959 | -122.395181915037 | (37.7289390851959, -122.395181915037) | ||
| 98609 | 98609 | 42762 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |||
| 100030 | 100030 | 42586 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 365 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42663 | 5992564.23479625 | 2094368.49404708 | 37.73030982758711 | -122.46802776610001 | (37.7303098275871, -122.4680277661) | ||
| 100590 | 100590 | 42602 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2000 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42672 | 6005206.416391299 | 2116498.11175578 | 37.791794500383794 | -122.425896619276 | (37.7917945003838, -122.425896619276) | ||
| 100633 | 100633 | 42646 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1600X GREEN ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 10 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 100805 | 100805 | 42544 | Permitted Site 1 | Cinnamomum camphora :: Camphor Tree 230 | 1011 23rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42643 | 6015278.958837001 | 2102962.15711273 | 37.7551918502677 | -122.39009931001301 | (37.7551918502677, -122.390099310013) | |||
| 101150 | 101150 | 42552 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 82 Aptos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42645 | 5993073.36121291 | 2094485.358364 | 37.7306600968778 | -122.46627615105 | (37.7306600968778, -122.46627615105) | ||
| 101582 | 101582 | 42735 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2155 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.712590845234296 | -122.400920338197 | (37.7125908452343, -122.400920338197) | ||
| 101688 | 101688 | 42549 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 75 Aptos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42644 | 5993133.29792536 | 2094520.9515080003 | 37.7307612849195 | -122.466071527857 | (37.7307612849195, -122.466071527857) | ||
| 101955 | 101955 | 42674 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42700 | 6008532.69397696 | 2121039.56256614 | 37.804451613820206 | -122.41470920319901 | (37.8044516138202, -122.414709203199) |
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");