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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4808 | 4808 | 248401 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 721 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 10 | Width 0ft | Permit Number 35191 | 5998539.5007 | 2108099.8388 | 37.7683559999766 | -122.44835899152099 | (37.7683559999766, -122.448358991521) | |
| 5373 | 5373 | 31852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 5613 | 5613 | 31854 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 1263 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35300 | ||||||||
| 5746 | 5746 | 31847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 7293 | 7293 | 31848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 11785 | 11785 | 31851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 11795 | 11795 | 31846 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 11986 | 11986 | 31849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 14764 | 14764 | 31856 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 44 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | 3x3 | Permit Number 35302 | 6009920.26283 | 2110981.2883599997 | 37.7769118830094 | -122.40919717941401 | (37.7769118830094, -122.409197179414) |
| 15642 | 15642 | 31853 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 1263 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35300 | ||||||||
| 15875 | 15875 | 31850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 15956 | 15956 | 31845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 23636 | 23636 | 31756 | Permitted Site 1 | Tree(s) :: 17 | 2450 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35242 | 5989554.0796 | 2098675.0659 | 37.7419602704622 | -122.478749009163 | (37.7419602704622, -122.478749009163) | |
| 24411 | 24411 | 31817 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 378 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 11 | Permit Number 35283 | 6003458.13683 | 2099246.4861 | 37.7443267796662 | -122.43071403581999 | (37.7443267796662, -122.43071403582) | |
| 24645 | 24645 | 31679 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4909 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35185 | 5997751.25621 | 2105611.0193 | 37.7614772360152 | -122.450905959737 | (37.7614772360152, -122.450905959737) | |
| 26893 | 26893 | 31681 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 59 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35187 | 5998307.66476 | 2107187.9506099997 | 37.7658389290403 | -122.44909518650101 | (37.7658389290403, -122.449095186501) | |
| 28083 | 28083 | 31759 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2654 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35245 | 5989289.1529 | 2097265.3499 | 37.7380741702289 | -122.479561911147 | (37.7380741702289, -122.479561911147) | |
| 29689 | 29689 | 31744 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2435 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35234 | 5989813.6936 | 2098781.7399 | 37.742268240421204 | -122.47785915361601 | (37.7422682404212, -122.477859153616) | |
| 31081 | 31081 | 31782 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35254 | 5989426.762 | 2097686.0113 | 37.739237190033705 | -122.47911689568501 | (37.7392371900337, -122.479116895685) | ||
| 32189 | 32189 | 31714 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 122 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35214 | 5998115.883119999 | 2105983.06318 | 37.7625196419841 | -122.44967168249799 | (37.7625196419841, -122.449671682498) | |
| 33081 | 33081 | 31729 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2467 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35226 | 5990125.4261 | 2098592.0294 | 37.7417654319331 | -122.47676743237601 | (37.7417654319331, -122.476767432376) | |
| 34278 | 34278 | 31819 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 195 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35284 | 6009854.1227 | 2111441.50203 | 37.778171816101704 | -122.409458466633 | (37.7781718161017, -122.409458466633) | |
| 34377 | 34377 | 31801 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 49 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35271 | 6001922.64301 | 2107937.51024 | 37.76810312699671 | -122.436645416353 | (37.7681031269967, -122.436645416353) | |
| 34651 | 34651 | 31752 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2642 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35239 | 5989905.4007 | 2097381.577 | 37.738429077279896 | -122.47743975125601 | (37.7384290772799, -122.477439751256) | |
| 37305 | 37305 | 31761 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1007 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35247 | 5990066.9971 | 2099007.5245 | 37.7429028843685 | -122.47699981190901 | (37.7429028843685, -122.476999811909) | |
| 37659 | 37659 | 31833 | Permitted Site 1 | Schefflera species :: Umbrella tree 386 | 234 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 14 | Permit Number 35290 | 6009600.901869999 | 2109052.05463 | 37.771596761117394 | -122.41016571237199 | (37.7715967611174, -122.410165712372) | |
| 37770 | 37770 | 31798 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 39 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35268 | 6001935.84631 | 2107865.07775 | 37.7679049955509 | -122.436594562416 | (37.7679049955509, -122.436594562416) | |
| 37903 | 37903 | 31762 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1007 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35247 | 5990024.3559 | 2099006.1709 | 37.7428966939048 | -122.477147152853 | (37.7428966939048, -122.477147152853) | |
| 38920 | 38920 | 31779 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 926 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35253 | 5990034.0009 | 2097707.4772 | 37.73933137655229 | -122.477018926471 | (37.7393313765523, -122.477018926471) | |
| 40778 | 40778 | 31726 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2457 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35224 | 5990124.6943 | 2098653.4978 | 37.741934165798995 | -122.47677445266599 | (37.741934165799, -122.476774452666) | |
| 41708 | 41708 | 31804 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 66 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 10 | Permit Number 35274 | 6001963.376 | 2108028.17278 | 37.7683543786925 | -122.436511015378 | (37.7683543786925, -122.436511015378) | |
| 42639 | 42639 | 31790 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 182 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35260 | 6001703.42145 | 2107747.5323099997 | 37.767569034012794 | -122.437390073887 | (37.7675690340128, -122.437390073887) | |
| 42659 | 42659 | 31690 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 720 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35194 | 5997967.7593 | 2107982.3411 | 37.7680006769011 | -122.45032811149599 | (37.7680006769011, -122.450328111496) | |
| 44859 | 44859 | 31760 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2679 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35246 | 5989245.641 | 2097123.1889 | 37.7376813053048 | -122.479701952637 | (37.7376813053048, -122.479701952637) | |
| 45510 | 45510 | 31694 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 78 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35198 | 5998855.957 | 2107820.6304 | 37.7676074517958 | -122.447244305581 | (37.7676074517958, -122.447244305581) | |
| 45843 | 45843 | 31770 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990241.9611 | 2098396.6732 | 37.7412357933409 | -122.47635023030199 | (37.7412357933409, -122.476350230302) | ||
| 45948 | 45948 | 31821 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 195 07th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35284 | 6009820.27489 | 2111475.42861 | 37.778263073931704 | -122.409577954154 | (37.7782630739317, -122.409577954154) | |
| 47454 | 47454 | 31832 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 229 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35289 | 6009612.2122 | 2109078.06285 | 37.7716688076043 | -122.410128425607 | (37.7716688076043, -122.410128425607) | |
| 47664 | 47664 | 31712 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 144#8 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35212 | 5997752.60888 | 2106811.6334 | 37.764773896114 | -122.450987860098 | (37.764773896114, -122.450987860098) | |
| 47756 | 47756 | 31725 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2446 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35223 | 5990173.7227 | 2098712.5879 | 37.7420992557504 | -122.47660924601101 | (37.7420992557504, -122.476609246011) | |
| 47909 | 47909 | 31837 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1162 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35293 | 6009869.4904 | 2110535.9885 | 37.77568634927629 | -122.409341384883 | (37.7756863492763, -122.409341384883) | |
| 49607 | 49607 | 31748 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2445 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35236 | 5989815.8889 | 2098699.4161 | 37.7420423280539 | -122.477845546337 | (37.7420423280539, -122.477845546337) | |
| 49717 | 49717 | 31828 | Permitted Site 1 | Citrus spp :: Lemon: Orange: Lime 278 | 219 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35287 | 6009577.38465 | 2109112.56676 | 37.7717615951562 | -122.41025133326 | (37.7717615951562, -122.41025133326) | |
| 49930 | 49930 | 31747 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2445 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35236 | 5989815.8889 | 2098715.8809 | 37.74208753612 | -122.47784674967501 | (37.74208753612, -122.477846749675) | |
| 54012 | 54012 | 31710 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 619 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35210 | 5996583.34698 | 2107294.12432 | 37.7660316834511 | -122.45506687733999 | (37.7660316834511, -122.45506687734) | |
| 55587 | 55587 | 31746 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2441 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35235 | 5989812.2301 | 2098750.2739 | 37.7421817580184 | -122.477861914162 | (37.7421817580184, -122.477861914162) | |
| 56759 | 56759 | 31780 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1100 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35254 | 5989503.5112 | 2097688.2686 | 37.7392478449055 | -122.47885169937099 | (37.7392478449055, -122.478851699371) | ||
| 57239 | 57239 | 31767 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990299.8313 | 2098399.3806 | 37.741246583105294 | -122.47615033552201 | (37.7412465831053, -122.476150335522) | ||
| 58192 | 58192 | 31751 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2546 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35238 | 5989883.0648 | 2098033.3774 | 37.7402174568148 | -122.477564605136 | (37.7402174568148, -122.477564605136) | |
| 60185 | 60185 | 31836 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1160 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35292 | 6009898.9199 | 2110564.6005 | 37.7757665599557 | -122.409241600011 | (37.7757665599557, -122.409241600011) | |
| 66250 | 66250 | 31765 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990223.0095 | 2098395.3195 | 37.7412309773369 | -122.47641565864299 | (37.7412309773369, -122.476415658643) | ||
| 69247 | 69247 | 31696 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 169 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35200 | 5998909.79856 | 2107175.07195 | 37.7658379874718 | -122.44701161379 | (37.7658379874718, -122.44701161379) | |
| 69426 | 69426 | 31778 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2138 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35252 | 5989340.4236 | 2098364.0841 | 37.741093987339895 | -122.479465007736 | (37.7410939873399, -122.479465007736) | |
| 71587 | 71587 | 31739 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2671 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35229 | 5990174.1076 | 2097212.0277 | 37.737979126750005 | -122.47649832068599 | (37.73797912675, -122.476498320686) | |
| 73002 | 73002 | 31750 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2546 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35238 | 5989885.0953 | 2098017.81 | 37.7401748305885 | -122.477556447005 | (37.7401748305885, -122.477556447005) | |
| 74665 | 74665 | 31730 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2467 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35226 | 5990125.0602 | 2098571.5399 | 37.7417091518445 | -122.47676720086201 | (37.7417091518445, -122.476767200862) | |
| 75236 | 75236 | 31704 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 445 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 15 | Permit Number 35206 | 5997671.58785 | 2107448.25781 | 37.7665172660868 | -122.45131400735399 | (37.7665172660868, -122.451314007354) | |
| 76229 | 76229 | 31768 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990284.9407 | 2098399.3806 | 37.741245719618895 | -122.47620182139 | (37.7412457196189, -122.47620182139) | ||
| 76744 | 76744 | 31691 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1549 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35195 | 5998318.3005 | 2105128.80455 | 37.7601856404696 | -122.448910060177 | (37.7601856404696, -122.448910060177) | |
| 77433 | 77433 | 31711 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1250X Shrader St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/19/1995 12:00:00 AM | 6 | 3x3 | Permit Number 35211 | 5997882.313818 | 2106467.94501531 | 37.763837639523395 | -122.450514467435 | (37.7638376395234, -122.450514467435) |
| 77958 | 77958 | 31771 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 80933 | 80933 | 31735 | Permitted Site 1 | Tree(s) :: 17 | 2595 20th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35228 | 5990159.8127928 | 2097729.87361868 | 37.7394001693262 | -122.476585565174 | (37.7394001693262, -122.476585565174) | |||
| 81396 | 81396 | 31787 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 156 Alpine Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35257 | 6001685.52281778 | 2107907.98384485 | 37.7680085767455 | -122.43746347404199 | (37.7680085767455, -122.437463474042) | |||
| 81432 | 81432 | 31662 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 116 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35280 | 6001959.7290679 | 2108357.31064937 | 37.769257902794706 | -122.436547191068 | (37.7692579027947, -122.436547191068) | ||
| 82228 | 82228 | 31734 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1900x ULLOA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35227 | 5990005.0 | 2098357.0 | 37.741113115877795 | -122.47716665025699 | (37.7411131158778, -122.477166650257) | ||
| 85569 | 85569 | 31855 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 15 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35301 | 6009805.81882643 | 2111161.45127671 | 37.7774001559158 | -122.409605796854 | (37.7774001559158, -122.409605796854) | ||
| 86392 | 86392 | 31763 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1018 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35248 | 5990018.1797 | 2099070.5556 | 37.7430731192473 | -122.477173212243 | (37.7430731192473, -122.477173212243) | |
| 86981 | 86981 | 31835 | Permitted Site 1 | Tree(s) :: 17 | 237 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35291 | 6009638.9380413 | 2109067.0653134 | 37.771640108885606 | -122.41003520238998 | (37.7716401088856, -122.41003520239) | ||
| 88740 | 88740 | 31764 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1018 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35248 | 5990072.01927063 | 2099066.23490799 | 37.7430643792619 | -122.476986735886 | (37.7430643792619, -122.476986735886) | ||
| 89302 | 89302 | 31777 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2126 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35251 | 5989451.98537783 | 2098364.25532499 | 37.74110093693479 | -122.47907928432699 | (37.7411009369348, -122.479079284327) | ||
| 90035 | 90035 | 31685 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 199 Carl St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35189 | 5997261.38189671 | 2107041.72248487 | 37.765377527370504 | -122.45270348511801 | (37.7653775273705, -122.452703485118) | |||
| 92021 | 92021 | 31781 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35254 | 5989534.8469239995 | 2097688.46988301 | 37.7392502171048 | -122.478743370392 | (37.7392502171048, -122.478743370392) | |||
| 95736 | 95736 | 31792 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35262 | 6001241.81019665 | 2108627.72464151 | 37.7699595699392 | -122.439049813001 | (37.7699595699392, -122.439049813001) | ||
| 98035 | 98035 | 31731 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1900x ULLOA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35227 | 5990005.0 | 2098357.0 | 37.741113115877795 | -122.47716665025699 | (37.7411131158778, -122.477166650257) | ||
| 98388 | 98388 | 31822 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 195 07th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35284 | 6009867.88042491 | 2111413.49607624 | 37.7780956891825 | -122.40940889647699 | (37.7780956891825, -122.409408896477) | ||
| 98639 | 98639 | 31839 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1x Rodgers St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35294 | 6009849.9489278 | 2110436.85417448 | 37.7754130547148 | -122.40940198622101 | (37.7754130547148, -122.409401986221) | ||
| 99071 | 99071 | 31766 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1850 Ulloa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35249 | 5990314.165659901 | 2098394.22190886 | 37.74123324988071 | -122.476100396225 | (37.7412332498807, -122.476100396225) | ||
| 99320 | 99320 | 31776 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 100830 | 100830 | 31795 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 141 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35265 | 6001336.75578377 | 2108526.84088843 | 37.7696879701055 | -122.438714168685 | (37.7696879701055, -122.438714168685) | ||
| 103338 | 103338 | 31720 | Permitted Site 1 | Ilex altaclarensis 'Wilsonii' :: Wilson Holly Tree 310 | 2570 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 3x3 | Permit Number 35219 | 5990538.39897979 | 2097898.04616563 | 37.7398838789348 | -122.47528886917601 | (37.7398838789348, -122.475288869176) | |
| 104171 | 104171 | 31738 | Permitted Site 1 | Tree(s) :: 17 | 2595 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35228 | 5990159.8127928 | 2097729.87361868 | 37.7394001693262 | -122.476585565174 | (37.7394001693262, -122.476585565174) | |||
| 104472 | 104472 | 31683 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 199 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35189 | 5997261.38189671 | 2107041.72248487 | 37.765377527370504 | -122.45270348511801 | (37.7653775273705, -122.452703485118) | ||
| 104583 | 104583 | 31689 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 625 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35193 | 5997855.49293134 | 2108447.65367576 | 37.7692718807295 | -122.45074998014401 | (37.7692718807295, -122.450749980144) | ||
| 105593 | 105593 | 31773 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 107363 | 107363 | 31709 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 494 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 3x3 | Permit Number 35209 | 5997243.8482988 | 2107438.78274184 | 37.7664667487492 | -122.452792790242 | (37.7664667487492, -122.452792790242) | |
| 109958 | 109958 | 31826 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 204 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35286 | 6009467.18551703 | 2109171.58635448 | 37.7719174714901 | -122.41063668938601 | (37.7719174714901, -122.410636689386) | ||
| 115914 | 115914 | 31829 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 222 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | ||
| 116677 | 116677 | 31684 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 199 Carl St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35189 | 5997261.38189671 | 2107041.72248487 | 37.765377527370504 | -122.45270348511801 | (37.7653775273705, -122.452703485118) | |||
| 117122 | 117122 | 31809 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 90 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35278 | 6001962.43851734 | 2108198.93498174 | 37.7688231962915 | -122.436526481908 | (37.7688231962915, -122.436526481908) | ||
| 117131 | 117131 | 31678 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 568 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35184 | 5984441.54106734 | 2111980.46046246 | 37.7781949786835 | -122.497408297818 | (37.7781949786835, -122.497408297818) | |||
| 117577 | 117577 | 31772 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 119489 | 119489 | 31701 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 263 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35203 | 5998787.10007 | 2107605.9925 | 37.7670141756857 | -122.44746702060199 | (37.7670141756857, -122.447467020602) | |
| 121377 | 121377 | 31830 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 222 Dore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | ||
| 122961 | 122961 | 31688 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 816 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35192 | 5998677.08875 | 2107434.65955 | 37.766537451377204 | -122.44783519493099 | (37.7665374513772, -122.447835194931) | |
| 124206 | 124206 | 31718 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 Twin Peaks Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35217 | 5999015.35080387 | 2105425.59790745 | 37.7610403997541 | -122.446520655595 | (37.7610403997541, -122.446520655595) | ||
| 124308 | 124308 | 31783 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35254 | 5989534.8469239995 | 2097688.46988301 | 37.7392502171048 | -122.478743370392 | (37.7392502171048, -122.478743370392) | |||
| 126607 | 126607 | 31834 | Permitted Site 1 | Tree(s) :: 17 | 237 Dore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35291 | 6009638.9380413 | 2109067.0653134 | 37.771640108885606 | -122.41003520238998 | (37.7716401088856, -122.41003520239) | ||
| 126833 | 126833 | 31736 | Permitted Site 1 | Tree(s) :: 17 | 2595 20th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35228 | 5990159.8127928 | 2097729.87361868 | 37.7394001693262 | -122.476585565174 | (37.7394001693262, -122.476585565174) | |||
| 128370 | 128370 | 31687 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 723 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35191 | 5998531.56699721 | 2108118.02123307 | 37.768405470730706 | -122.44838774288701 | (37.7684054707307, -122.448387742887) | |||
| 128993 | 128993 | 31717 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 Twin Peaks Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35217 | 5999015.35080387 | 2105425.59790745 | 37.7610403997541 | -122.446520655595 | (37.7610403997541, -122.446520655595) |
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");