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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187540 | 187540 | 36806 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 4 | Permit Number 39531 | 6014725.6758 | 2091211.782 | 37.722897037873395 | -122.391191434704 | (37.7228970378734, -122.391191434704) | |
| 187529 | 187529 | 38847 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1470 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 9 | Permit Number 40676 | 5989942.9457 | 2105353.4021 | 37.7603197919591 | -122.47789255007099 | (37.7603197919591, -122.477892550071) | |
| 187496 | 187496 | 73575 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1088 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | 6012040.57569 | 2119341.71147 | 37.7999861916725 | -122.40245033952 | (37.7999861916725, -122.40245033952) | ||
| 187482 | 187482 | 32718 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1059 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 13 | Permit Number 37112 | 6008124.13541 | 2116125.0175900003 | 37.790934532354605 | -122.415774856832 | (37.7909345323546, -122.415774856832) | |
| 187480 | 187480 | 71692 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 364 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 26 | 6x7 | 6006147.03421 | 2111101.3621799997 | 37.777029465781496 | -122.422258481339 | (37.7770294657815, -122.422258481339) | |
| 187474 | 187474 | 75968 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 539 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 13 | 6013460.77935 | 2112129.46261 | 37.7802622227699 | -122.397029890811 | (37.7802622227699, -122.397029890811) | ||
| 187473 | 187473 | 60579 | Permitted Site 1 | Tristania conferta :: 79 | 556 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 13 | Permit Number 20193 | 6000143.5821 | 2110857.5211 | 37.7760194779825 | -122.443008707696 | (37.7760194779825, -122.443008707696) | |
| 187467 | 187467 | 30971 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1918 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 21 | Permit Number 34762 | 6004982.43732 | 2117138.20342 | 37.79353937010811 | -122.426717189659 | (37.7935393701081, -122.426717189659) | |
| 187464 | 187464 | 70495 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 41 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 8 | 6004160.9944400005 | 2093317.3094099998 | 37.728086398555206 | -122.427861302663 | (37.7280863985552, -122.427861302663) | ||
| 187452 | 187452 | 67020 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 149 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 6 | Permit Number 32112 | 5990819.4847800005 | 2114429.04391 | 37.785289865300996 | -122.475523724044 | (37.785289865301, -122.475523724044) | |
| 187451 | 187451 | 44412 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 33 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 13 | Permit Number 43763 | 6002334.21635 | 2087134.94604 | 37.7110074922697 | -122.43373484600201 | (37.7110074922697, -122.433734846002) | |
| 187421 | 187421 | 70618 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1557 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 2 | 6007346.38924 | 2116443.2469099998 | 37.7917645589423 | -122.418488407316 | (37.7917645589423, -122.418488407316) | ||
| 187409 | 187409 | 71109 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1280 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1995 12:00:00 AM | 9 | 6004811.8428 | 2113348.9801 | 37.783125466661296 | -122.42703744955601 | (37.7831254666613, -122.427037449556) | ||
| 187404 | 187404 | 31226 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2598 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 6 | Permit Number 34913 | 5992091.73833 | 2097813.94877 | 37.7397428821404 | -122.469911998937 | (37.7397428821404, -122.469911998937) | |
| 187401 | 187401 | 73399 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 318 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 6 | 6010326.194680001 | 2093255.95612 | 37.7282647808735 | -122.406543575948 | (37.7282647808735, -122.406543575948) | ||
| 187398 | 187398 | 68529 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 614 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 10 | Permit Number 32410 | 5994730.36077 | 2111314.5868 | 37.776964335760496 | -122.461767479865 | (37.7769643357605, -122.461767479865) | |
| 187381 | 187381 | 71611 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 623 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 12 | 5984406.18035 | 2111579.9668900003 | 37.777093266380895 | -122.497501046096 | (37.7770932663809, -122.497501046096) | ||
| 187374 | 187374 | 36805 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 10 | Permit Number 39531 | 6014737.8573 | 2091203.2549 | 37.7228743001584 | -122.39114872971001 | (37.7228743001584, -122.39114872971) | |
| 187355 | 187355 | 50504 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 671 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 9 | Permit Number 47140 | 6001297.56946 | 2089761.94857 | 37.7181617790314 | -122.437505740198 | (37.7181617790314, -122.437505740198) | |
| 187344 | 187344 | 31692 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 61 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 7 | Permit Number 35553 | 5998816.4378 | 2107906.1796 | 37.767840090069896 | -122.44738715512501 | (37.7678400900699, -122.447387155125) | |
| 187342 | 187342 | 65766 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1937 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1992 12:00:00 AM | 15 | Permit Number 28729 | 6003642.45675 | 2118972.66599 | 37.7985004828598 | -122.431484647806 | (37.7985004828598, -122.431484647806) | |
| 187335 | 187335 | 33110 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2626 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37348 | 6000381.41365 | 2118563.70291 | 37.7971922129921 | -122.442739455458 | (37.7971922129921, -122.442739455458) | |
| 187324 | 187324 | 60799 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 275 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | 5 | Permit Number 20474 | 5998494.132 | 2112280.5701 | 37.7798326205261 | -122.448817090257 | (37.7798326205261, -122.448817090257) | |
| 187307 | 187307 | 44187 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 248 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | 3 | Permit Number 44776 | 5990894.1972 | 2113727.7318 | 37.783368588065706 | -122.47521402717399 | (37.7833685880657, -122.475214027174) | |
| 187296 | 187296 | 32212 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 131 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 6 | Permit Number 35533 | 6009893.25149 | 2099852.66085 | 37.746353682475096 | -122.408505421789 | (37.7463536824751, -122.408505421789) | |
| 187272 | 187272 | 45474 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1349 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 4 | Permit Number 44253 | 5999367.63833 | 2089888.0893 | 37.718398218877 | -122.444185721794 | (37.718398218877, -122.444185721794) | |
| 187269 | 187269 | 49212 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1901 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | 5 | Permit Number 46298 | 6001466.4689 | 2115088.0238 | 37.7877106976566 | -122.438735717029 | (37.7877106976566, -122.438735717029) | |
| 187263 | 187263 | 47468 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1903 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 12 | Permit Number 45369 | 6000460.76384 | 2115231.99782 | 37.7880487472944 | -122.442225592756 | (37.7880487472944, -122.442225592756) | |
| 187252 | 187252 | 38795 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 667 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1998 12:00:00 AM | 4 | Permit Number 40643 | 6013193.0271 | 2113622.9268 | 37.7843480231413 | -122.398060977557 | (37.7843480231413, -122.398060977557) | |
| 187244 | 187244 | 61219 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 179 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | 7 | Permit Number 21088 | 6011237.71128 | 2095645.3560099998 | 37.734876525537295 | -122.403560449172 | (37.7348765255373, -122.403560449172) | |
| 187243 | 187243 | 95930 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 525 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767627 | 5987483.09565 | 2112350.67987 | 37.7793892963815 | -122.486913781541 | (37.7793892963815, -122.486913781541) |
| 187236 | 187236 | 31352 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2359 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 4 | Permit Number 34962 | 5992611.197240001 | 2099415.5021599997 | 37.744170355193795 | -122.46823242419501 | (37.7441703551938, -122.468232424195) | |
| 187232 | 187232 | 42883 | Permitted Site 1 | Tree(s) :: 17 | 2511 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 2 | Permit Number 42804 | 5985798.1204 | 2098115.3222 | 37.740204561911 | -122.491694530042 | (37.740204561911, -122.491694530042) | |
| 187231 | 187231 | 71911 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 54 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1989 12:00:00 AM | 12 | 6008864.223730001 | 2112520.0320599996 | 37.781077688412104 | -122.41295917575 | (37.7810776884121, -122.41295917575) | ||
| 187222 | 187222 | 51407 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1554 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | 5 | Permit Number 47732 | 5989341.6825 | 2104766.5057 | 37.7586734173793 | -122.479929065557 | (37.7586734173793, -122.479929065557) | |
| 187219 | 187219 | 43613 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 2278 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 3 | Permit Number 43266 | 5986102.56484148 | 2099736.52612164 | 37.7446737419753 | -122.49076115557399 | (37.7446737419753, -122.490761155574) | |
| 187206 | 187206 | 47445 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 811 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45355 | 5982594.30489 | 2110210.15333 | 37.77322578967961 | -122.50366731846701 | (37.7732257896796, -122.503667318467) | |
| 187162 | 187162 | 68554 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 735 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2016 12:00:00 AM | 1 | Permit Number 777390 | 5982265.00656 | 2110745.36563 | 37.7746759600384 | -122.504846052747 | (37.7746759600384, -122.504846052747) | |
| 187157 | 187157 | 40689 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 156 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 4 | Permit Number 41672 | 6004442.73992 | 2094023.43219 | 37.7300411892414 | -122.42693756853501 | (37.7300411892414, -122.426937568535) | |
| 187149 | 187149 | 38860 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1549 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 0 | Permit Number 40687 | 5989292.62615578 | 2104803.36922141 | 37.758771784471996 | -122.480101420695 | (37.758771784472, -122.480101420695) | |
| 187137 | 187137 | 87178 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1850 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50167 | 5987398.7116 | 2100339.5275 | 37.7464050543011 | -122.486323651924 | (37.7464050543011, -122.486323651924) |
| 187131 | 187131 | 73537 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Huntington Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1995 12:00:00 AM | 5 | 5984627.56608 | 2094712.4640000002 | 37.7307927427943 | -122.495490862808 | (37.7307927427943, -122.495490862808) | ||
| 187128 | 187128 | 78262 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501 Wayland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 6 | 6010118.26182 | 2092179.1105400003 | 37.725296353538795 | -122.40718653543699 | (37.7252963535388, -122.407186535437) | ||
| 187104 | 187104 | 36787 | Permitted Site 1 | Rhaphiolepis indica :: India Hawthorn 144 | 1420 Carroll Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 3 | Permit Number 39525 | 6014949.8148 | 2091395.7221 | 37.723414537097 | -122.39042947233 | (37.723414537097, -122.39042947233) | |
| 187062 | 187062 | 34615 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3251 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38299 | 5999148.918409999 | 2115949.9944 | 37.789945324867396 | -122.44681601304801 | (37.7899453248674, -122.446816013048) | |
| 187061 | 187061 | 65596 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 660 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/1990 12:00:00 AM | 26 | Permit Number 28498 | 6002534.62585 | 2089782.9928599999 | 37.718289816404706 | -122.433231273322 | (37.7182898164047, -122.433231273322) | |
| 187031 | 187031 | 48598 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1444 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | 8 | Permit Number 45908 | 6006635.91115 | 2118390.9929400003 | 37.79707255999389 | -122.42108502346501 | (37.7970725599939, -122.421085023465) | |
| 186971 | 186971 | 72130 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2030 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 7 | 6012329.14835 | 2102847.44399 | 37.7547128260461 | -122.400292629422 | (37.7547128260461, -122.400292629422) | ||
| 186970 | 186970 | 43222 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 640 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 5 | Permit Number 43011 | 6007646.36593 | 2094163.38617 | 37.7306060983812 | -122.415872111321 | (37.7306060983812, -122.415872111321) | |
| 186960 | 186960 | 30764 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1547 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 11 | Permit Number 34645 | 6014848.357000001 | 2093490.2228 | 37.7291599890213 | -122.390926510702 | (37.7291599890213, -122.390926510702) | |
| 186959 | 186959 | 66501 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1625 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 7 | Permit Number 29664 | 5999574.2556 | 2114579.9293 | 37.7862077735321 | -122.44524584382 | (37.7862077735321, -122.44524584382) | |
| 186957 | 186957 | 62466 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 708 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/2012 12:00:00 AM | 2 | Permit Number 769096 | 6011238.859 | 2104985.8972 | 37.76052368662629 | -122.40421366453998 | (37.7605236866263, -122.40421366454) | |
| 186953 | 186953 | 32087 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3964 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 9 | Permit Number 35460 | 6003256.89159 | 2104790.94057 | 37.759539140335995 | -122.43180569859899 | (37.759539140336, -122.431805698599) | |
| 186946 | 186946 | 62774 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 36 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | 6 | Permit Number 23129 | 6000628.75653 | 2093088.58335 | 37.7272579134153 | -122.440055941455 | (37.7272579134153, -122.440055941455) | |
| 186939 | 186939 | 49811 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 820 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46603 | 6015361.637130001 | 2103953.4257900002 | 37.7579182481496 | -122.389882619693 | (37.7579182481496, -122.389882619693) | |
| 186935 | 186935 | 73355 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 235 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/1993 12:00:00 AM | 9 | 6000483.29937 | 2091960.66988 | 37.7241526398265 | -122.440477924021 | (37.7241526398265, -122.440477924021) | ||
| 186925 | 186925 | 92365 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1911 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52778 | 5985970.1405 | 2102197.0919999997 | 37.7514220529755 | -122.491400116824 | (37.7514220529755, -122.491400116824) |
| 186899 | 186899 | 50249 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1379 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 4 | Permit Number 46954 | 5985223.881 | 2105833.3788 | 37.761362655281296 | -122.49424873007 | (37.7613626552813, -122.49424873007) | |
| 186885 | 186885 | 66156 | Permitted Site 1 | Styphnolobium japonicum :: Chinese scholar tree 156 | 1751 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/1990 12:00:00 AM | 13 | Permit Number 29227 | 6013871.1718 | 2094957.56097 | 37.7331347302712 | -122.394407446159 | (37.7331347302712, -122.394407446159) | |
| 186882 | 186882 | 61980 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3105 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1985 12:00:00 AM | 11 | Permit Number 22047 | 6004204.10885 | 2119849.9786 | 37.8009411736685 | -122.42960375979999 | (37.8009411736685, -122.4296037598) | |
| 186874 | 186874 | 95891 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1691 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767599 | 5989637.9664 | 2103875.5933 | 37.7562444194269 | -122.478839232097 | (37.7562444194269, -122.478839232097) |
| 186836 | 186836 | 78525 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3550 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 4 | 5981839.9629999995 | 2099470.1472 | 37.7436924112004 | -122.505480405304 | (37.7436924112004, -122.505480405304) | ||
| 186833 | 186833 | 30969 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1910 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 16 | Permit Number 34760 | 6005001.01631 | 2117138.70127 | 37.7935417874622 | -122.42665294030701 | (37.7935417874622, -122.426652940307) | |
| 186813 | 186813 | 43524 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1664 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | 9 | Permit Number 43200 | 5999863.2001 | 2110580.0951 | 37.775241746809 | -122.44395868218001 | (37.775241746809, -122.44395868218) | |
| 186799 | 186799 | 72306 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3434 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 8 | 5997784.02089 | 2116132.98563 | 37.7903697032501 | -122.451551619911 | (37.7903697032501, -122.451551619911) | ||
| 186794 | 186794 | 31340 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 430 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/2002 12:00:00 AM | 7 | 3x3 | Permit Number 45975 | 6005768.2475 | 2111055.2748 | 37.7768815477511 | -122.423565546393 | (37.7768815477511, -122.423565546393) |
| 186785 | 186785 | 70386 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1536 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | 13 | 6000423.3259 | 2110656.0694 | 37.7754822883832 | -122.442026539723 | (37.7754822883832, -122.442026539723) | ||
| 186784 | 186784 | 52475 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 576 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48585 | 5991930.93358 | 2111531.3322 | 37.7773979112296 | -122.471467265516 | (37.7773979112296, -122.471467265516) |
| 186782 | 186782 | 38856 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1530 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 3 | Permit Number 40683 | 5989340.55843436 | 2104922.50162386 | 37.7591016749524 | -122.479944368724 | (37.7591016749524, -122.479944368724) | |
| 186773 | 186773 | 31937 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1334 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 13 | Permit Number 35352 | 5981537.7523 | 2105991.1857 | 37.761579550806 | -122.50700898865801 | (37.761579550806, -122.507008988658) | |
| 186770 | 186770 | 78427 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 721 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 2 | 6001123.9692400005 | 2089480.39079 | 37.7173788130682 | -122.43808564286199 | (37.7173788130682, -122.438085642862) | ||
| 186762 | 186762 | 83484 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 901 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 3 | 3x3 | 6015527.06927 | 2104778.0236400003 | 37.760191590401895 | -122.389368063579 | (37.7601915904019, -122.389368063579) | |
| 186737 | 186737 | 73860 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1652 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/1993 12:00:00 AM | 12 | 6008793.24364 | 2118610.57457 | 37.7977968533 | -122.41363563948299 | (37.7977968533, -122.413635639483) | ||
| 186686 | 186686 | 68301 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 274 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 10 | Permit Number 32110 | 5991223.89195 | 2113593.03088 | 37.783017840242294 | -122.47406359339199 | (37.7830178402423, -122.474063593392) | |
| 186674 | 186674 | 71812 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 340 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1982 12:00:00 AM | 7 | 5997177.69428 | 2115152.46792 | 37.787642723191 | -122.45357862886499 | (37.787642723191, -122.453578628865) | ||
| 186673 | 186673 | 78599 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1721 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 6 | 6012838.148159999 | 2104697.96448 | 37.7598223206635 | -122.39866221248501 | (37.7598223206635, -122.398662212485) | ||
| 186671 | 186671 | 73754 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1815 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 6 | 6009969.6946 | 2120303.1237 | 37.8025101678048 | -122.40968430266199 | (37.8025101678048, -122.409684302662) | ||
| 186659 | 186659 | 94703 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 658 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53843 | 5992262.68777 | 2110962.91491 | 37.77585637803789 | -122.470278225754 | (37.7758563780379, -122.470278225754) |
| 186653 | 186653 | 75060 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 390x Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 7 | 6010594.46043 | 2106517.2504 | 37.76469240853879 | -122.406550267789 | (37.7646924085388, -122.406550267789) | ||
| 186651 | 186651 | 96029 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 730 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767669 | 6007514.32648 | 2113867.32169 | 37.78470115228 | -122.417724680544 | (37.78470115228, -122.417724680544) |
| 186630 | 186630 | 36960 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 40 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 4 | Permit Number 39590 | 5994276.373459999 | 2115318.71773 | 37.787932453726604 | -122.463628626536 | (37.7879324537266, -122.463628626536) | |
| 186625 | 186625 | 61561 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2018 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 13 | Permit Number 21521 | 6012372.92464 | 2102851.20002 | 37.754725580248 | -122.40014150193399 | (37.754725580248, -122.400141501934) | |
| 186613 | 186613 | 52520 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 54 Norton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 30 | Permit Number 48621 | 6001810.81862 | 2092293.7166900001 | 37.7251426126309 | -122.4359127153 | (37.7251426126309, -122.4359127153) | |
| 186607 | 186607 | 84551 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 711 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 4 | 5987529.79137 | 2111085.3149599996 | 37.775917683596504 | -122.486659304996 | (37.7759176835965, -122.486659304996) | ||
| 186568 | 186568 | 37600 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 767 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 4 | 5x6 | Permit Number 40027 | 5992555.22947 | 2110228.65123 | 37.773857197137 | -122.46921280405701 | (37.773857197137, -122.469212804057) |
| 186560 | 186560 | 43794 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 270 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 9 | Permit Number 43424 | 5989036.4193400005 | 2113527.4816400004 | 37.7827109054518 | -122.48162645948 | (37.7827109054518, -122.48162645948) | |
| 186553 | 186553 | 34813 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 4 | Permit Number 38704 | 5984088.07189 | 2113071.94778 | 37.7811711621882 | -122.498711710109 | (37.7811711621882, -122.498711710109) | |
| 186545 | 186545 | 75860 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 9 | 6011761.31231 | 2118758.70866 | 37.7983698131588 | -122.40337566547701 | (37.7983698131588, -122.403375665477) | ||
| 186535 | 186535 | 47265 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1522 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 6 | Permit Number 45206 | 5989024.0272 | 2104940.8762 | 37.759133731330294 | -122.481040417074 | (37.7591337313303, -122.481040417074) | |
| 186519 | 186519 | 32589 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1286 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 4 | Permit Number 37058 | 5985555.6068 | 2106469.8118 | 37.763129529589705 | -122.493148331917 | (37.7631295295897, -122.493148331917) | |
| 186510 | 186510 | 46853 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 454 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 9 | Permit Number 44921 | 6003277.3604 | 2090963.48682 | 37.7215732987425 | -122.430748150718 | (37.7215732987425, -122.430748150718) | |
| 186509 | 186509 | 47837 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 548 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 3 | Permit Number 45599 | 5981333.02429 | 2111993.2264799997 | 37.7780473459501 | -122.50816254832701 | (37.7780473459501, -122.508162548327) | |
| 186496 | 186496 | 65188 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 259 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 15 | 3x3 | Permit Number 27172 | 6002967.27009 | 2091905.5125900002 | 37.7241423183013 | -122.43188727879101 | (37.7241423183013, -122.431887278791) |
| 186439 | 186439 | 42699 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 839 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2007 12:00:00 AM | 4 | Permit No. 49315 | 6006686.40585 | 2121480.76195 | 37.805559128512 | -122.421129804292 | (37.805559128512, -122.421129804292) | |
| 186437 | 186437 | 71320 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 11 | 6004289.26563 | 2090538.0021799998 | 37.720462289783896 | -122.42721997362601 | (37.7204622897839, -122.427219973626) | ||
| 186415 | 186415 | 31371 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 537 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 4 | Permit Number 34973 | 5991501.22289 | 2099052.17268 | 37.7431085759965 | -122.472043958778 | (37.7431085759965, -122.472043958778) | |
| 186409 | 186409 | 45569 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 310 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44312 | 5997642.12042 | 2115315.11009 | 37.7881159077753 | -122.451983551718 | (37.7881159077753, -122.451983551718) | |
| 186394 | 186394 | 32945 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 251 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 2 | 3x3 | Permit Number 37263 | 6012936.27157 | 2105882.30903 | 37.7630797361667 | -122.398405951572 | (37.7630797361667, -122.398405951572) |
| 186390 | 186390 | 62603 | Permitted Site 1 | Eriobotrya japonica :: Edible Loquat 190 | 792 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 6 | Permit Number 22911 | 5984491.42084 | 2110500.08946 | 37.7741332293959 | -122.497126446837 | (37.7741332293959, -122.497126446837) | |
| 186371 | 186371 | 43586 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1983 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 2 | Permit Number 43247 | 5986913.6448 | 2101776.5179 | 37.7503223588527 | -122.48810650903799 | (37.7503223588527, -122.488106509038) |
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");