Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9683 | 9683 | 173631 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 99X Everglade Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5986361.0 | 2095495.0 | 37.733042731061104 | -122.48955570953301 | (37.7330427310611, -122.489555709533) | ||||
| 79579 | 79579 | 25482 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 3x3 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
| 92671 | 92671 | 25483 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 12 | 3X3 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
| 126196 | 126196 | 18399 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 24 | 4x4 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
| 128737 | 128737 | 18408 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 05/23/1997 12:00:00 AM | 18 | 2X4 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | ||
| 138503 | 138503 | 18401 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 4x4 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
| 2943 | 2943 | 253276 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 998 Douglass St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | 3x3 | 6001226.0 | 2100921.0 | 37.748797883078495 | -122.43855223163901 | (37.7487978830785, -122.438552231639) | ||
| 2947 | 2947 | 253275 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 998 Douglass St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | 3x3 | 6001226.0 | 2100921.0 | 37.748797883078495 | -122.43855223163901 | (37.7487978830785, -122.438552231639) | ||
| 84341 | 84341 | 107502 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 998 CHESTNUT ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 773456 | 6007102.0 | 2120561.3 | 37.8030579393401 | -122.419626302363 | (37.8030579393401, -122.419626302363) | ||
| 104808 | 104808 | 107501 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 998 CHESTNUT ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 773456 | 6007102.0 | 2120561.3 | 37.8030579393401 | -122.419626302363 | (37.8030579393401, -122.419626302363) | ||
| 84899 | 84899 | 92547 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 99 Santa Marina St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 52890 | 6006207.5 | 2097640.2 | 37.740071660795 | -122.42109327168501 | (37.740071660795, -122.421093271685) | |||
| 1928 | 1928 | 252837 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1929 | 1929 | 252833 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1935 | 1935 | 252836 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1948 | 1948 | 252834 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1955 | 1955 | 252835 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 141354 | 141354 | 120533 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 951 Brannan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 22 | 3x3 | 6010745.0 | 2108673.0 | 37.7706200263658 | -122.40618148078501 | (37.7706200263658, -122.406181480785) | |||
| 97540 | 97540 | 99295 | Permitted Site 1 | Tree(s) :: 17 | 947 Lincoln Way | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5992761.5 | 2107248.3 | 37.765685864903396 | -122.468282426864 | (37.7656858649034, -122.468282426864) | |||||
| 119246 | 119246 | 99296 | Permitted Site 1 | Tree(s) :: 17 | 947 Lincoln Way | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5992761.5 | 2107248.3 | 37.765685864903396 | -122.468282426864 | (37.7656858649034, -122.468282426864) | |||||
| 92510 | 92510 | 88654 | Permitted Site 1 | Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 461 | 94 Danton St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 08/05/2008 12:00:00 AM | Permit Number 51634 | 6002844.0 | 2094598.0 | 37.7315282931893 | -122.43250562955099 | (37.7315282931893, -122.432505629551) | ||||
| 120372 | 120372 | 88656 | Permitted Site 1 | Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 461 | 94 Danton St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 08/05/2008 12:00:00 AM | Permit Number 51634 | 6002844.0 | 2094598.0 | 37.7315282931893 | -122.43250562955099 | (37.7315282931893, -122.432505629551) | ||||
| 125075 | 125075 | 53133 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 925 Holloway Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774158 | 5994000.81776041 | 2091173.40830125 | 37.7216197566197 | -122.46282963525199 | (37.7216197566197, -122.462829635252) | ||
| 91444 | 91444 | 107078 | Undocumented 2 | Tree(s) :: 17 | 92 Homestead St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 07/25/2014 12:00:00 AM | 3x3.5 | Permit Number 773562 | 6000948.33481 | 2101213.46128 | 37.7495851129185 | -122.439533357227 | (37.7495851129185, -122.439533357227) | |||
| 98119 | 98119 | 117314 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 910 Clayton St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 5998775.9 | 2106883.7 | 37.7650303025851 | -122.447453764259 | (37.7650303025851, -122.447453764259) | |||
| 113458 | 113458 | 103544 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 905X Phelps St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 6x12 | 6014832.8 | 2097357.7 | 37.7397784309436 | -122.39125052869 | (37.7397784309436, -122.39125052869) | |||
| 143955 | 143955 | 103545 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 905X Phelps St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 6x12 | 6014832.8 | 2097357.7 | 37.7397784309436 | -122.39125052869 | (37.7397784309436, -122.39125052869) | |||
| 265 | 265 | 109354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007474.1784 | 2120601.5824599997 | 37.803189502164294 | -122.418341225173 | (37.8031895021643, -122.418341225173) | |||
| 24884 | 24884 | 109356 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 5x45 | 6007464.49344 | 2120601.01033 | 37.8031873860571 | -122.41837469975 | (37.8031873860571, -122.41837469975) | |||
| 48049 | 48049 | 109359 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 5x45 | 6007452.06537 | 2120598.7604799997 | 37.8031805089269 | -122.41841754792802 | (37.8031805089269, -122.418417547928) | |||
| 70565 | 70565 | 109362 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 5x45 | 6007443.52896 | 2120597.58705 | 37.8031768064372 | -122.41844700523701 | (37.8031768064372, -122.418447005237) | |||
| 71497 | 71497 | 109357 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 9 | 5x45 | 6007459.04695 | 2120599.58062 | 37.8031831538387 | -122.41839344609801 | (37.8031831538387, -122.418393446098) | |||
| 75911 | 75911 | 109363 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007417.13772 | 2120593.69695 | 37.8031646394947 | -122.418538057081 | (37.8031646394947, -122.418538057081) | |||
| 147679 | 147679 | 109360 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007448.76613 | 2120598.25036 | 37.803178922540205 | -122.418428928878 | (37.8031789225402, -122.418428928878) | |||
| 155176 | 155176 | 109361 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 5x45 | 6007445.84949 | 2120597.53947 | 37.803176806427004 | -122.418438971581 | (37.803176806427, -122.418438971581) | |||
| 171997 | 171997 | 109358 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 5x45 | 6007454.77295 | 2120598.70497 | 37.8031805089291 | -122.41840817430901 | (37.8031805089291, -122.418408174309) | |||
| 173674 | 173674 | 109355 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 5x45 | 6007469.51339 | 2120600.5219 | 37.8031863275346 | -122.41835729337299 | (37.8031863275346, -122.418357293373) | |||
| 111836 | 111836 | 2071 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 20 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 125479 | 125479 | 2077 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 125618 | 125618 | 2079 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 126542 | 126542 | 2074 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Bosworth St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 21 | 3X3 | 6001652.8683327995 | 2095576.0345146998 | 37.734146132831796 | -122.436693577752 | (37.7341461328318, -122.436693577752) | |||
| 77762 | 77762 | 121681 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 900 Lawton St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5991505.0 | 2104920.0 | 37.7592203205256 | -122.472458589604 | (37.7592203205256, -122.472458589604) | ||||
| 114062 | 114062 | 107663 | Undocumented 2 | Melaleuca spp :: Melaleuca spp 130 | 900 CAROLINA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6012372.4 | 2103715.1 | 37.757097631281795 | -122.40020398695299 | (37.7570976312818, -122.400203986953) | |||||
| 101223 | 101223 | 110309 | Permitted Site 1 | Tree(s) :: 17 | 899x Stanyan St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Dept of Real Estate 5 | 04/03/2015 12:00:00 AM | 3x3 | 5997166.64381 | 2107575.86009 | 37.7668387037649 | -122.45306972128999 | (37.7668387037649, -122.45306972129) | |||
| 126079 | 126079 | 110307 | Permitted Site 1 | Tree(s) :: 17 | 899x Stanyan St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Dept of Real Estate 5 | 04/03/2015 12:00:00 AM | 3 | 4x11 | Permit Number 774992 | 5997166.64381 | 2107575.86009 | 37.7668387037649 | -122.45306972128999 | (37.7668387037649, -122.45306972129) | |
| 141052 | 141052 | 116899 | Undocumented 2 | Auranticarpa rhombifolia :: Queensland Pittosporum 428 | 898 PACHECO ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5992167.0 | 2103065.0 | 37.754165269847 | -122.470034026433 | (37.754165269847, -122.470034026433) | ||||
| 78882 | 78882 | 101964 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 80376 | 80376 | 101965 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 83391 | 83391 | 101966 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 93998 | 93998 | 101963 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 95948 | 95948 | 101961 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 97574 | 97574 | 101967 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 116514 | 116514 | 101962 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 127684 | 127684 | 101960 | Permitted Site 1 | Tree(s) :: 17 | 896 De Haro St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/11/2012 12:00:00 AM | Permit Number 769432 | 6012145.1 | 2104124.0 | 37.7582077038957 | -122.401018811941 | (37.7582077038957, -122.401018811941) | |||
| 79840 | 79840 | 97855 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 81293 | 81293 | 97871 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 82859 | 82859 | 97868 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 83719 | 83719 | 97864 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 91467 | 91467 | 97869 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 92675 | 92675 | 97866 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 94634 | 94634 | 97865 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 97516 | 97516 | 97859 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 98288 | 98288 | 97861 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 99796 | 99796 | 97867 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 101895 | 101895 | 97870 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 112922 | 112922 | 97862 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 121387 | 121387 | 97856 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 895 Indiana St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 142238 | 142238 | 97863 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 142400 | 142400 | 97858 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 145994 | 145994 | 97860 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 88815 | 88815 | 101381 | Permitted Site 1 | Tibochina urvilleana :: Princess Flower 260 | 875 43rd Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/18/2012 12:00:00 AM | Permit Number 769418 | 5982591.7 | 2109836.4 | 37.772199418349295 | -122.50364864512899 | (37.7721994183493, -122.503648645129) | |||
| 4027 | 4027 | 253600 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
| 4041 | 4041 | 253601 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
| 87649 | 87649 | 121661 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 96465 | 96465 | 121662 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 118078 | 118078 | 121664 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 126565 | 126565 | 121663 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 142340 | 142340 | 121660 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 860 Teresita Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998939.0 | 2095554.0 | 37.7339310276146 | -122.44607465500401 | (37.7339310276146, -122.446074655004) | ||||
| 88979 | 88979 | 109707 | Undocumented 2 | Washingtonia filifera :: California Fan Palm 189 | 850 PORTOLA DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996501.5 | 2099217.0 | 37.7438492362387 | -122.454766346821 | (37.7438492362387, -122.454766346821) | ||||
| 61493 | 61493 | 105361 | Permitted Site 1 | :: 54 | 850 Guerrero St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
| 81121 | 81121 | 105364 | Permitted Site 1 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 850 Guerrero St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12X2.75 | Permit Number 771789 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | |||
| 83497 | 83497 | 105359 | Permitted Site 1 | :: 54 | 850 Guerrero St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
| 91070 | 91070 | 105360 | Permitted Site 1 | :: 54 | 850 Guerrero St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
| 114746 | 114746 | 105363 | Permitted Site 1 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 850 Guerrero St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12X2.75 | Permit Number 771789 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | |||
| 116807 | 116807 | 105365 | Permitted Site 1 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 850 Guerrero St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12X2.75 | Permit Number 771789 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | |||
| 83562 | 83562 | 112807 | Undocumented 2 | Tree(s) :: 17 | 85 LOMITA AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5991376.0 | 2104593.0 | 37.7583149976739 | -122.472880884893 | (37.7583149976739, -122.472880884893) | ||||
| 3094 | 3094 | 253300 | Undocumented 2 | Tristania conferta :: 79 | 844 33rd Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5985769.0 | 2110141.0 | 37.773222058846 | -122.492680686455 | (37.773222058846, -122.492680686455) | ||||
| 3068 | 3068 | 253294 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 840x Sacramento St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010611.0 | 2116923.0 | 37.793265087793294 | -122.407226643637 | (37.7932650877933, -122.407226643637) | |||||
| 3072 | 3072 | 253293 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 840x Sacramento St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010611.0 | 2116923.0 | 37.793265087793294 | -122.407226643637 | (37.7932650877933, -122.407226643637) | |||||
| 89053 | 89053 | 102912 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 84 Vienna St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004823.0 | 2092922.0 | 37.7270383945734 | -122.42554460371599 | (37.7270383945734, -122.425544603716) | |||||
| 4538 | 4538 | 253635 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 830 Oak St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | ||||
| 4548 | 4548 | 253634 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 830 Oak St | 1 | Sidewalk: Property side : Cutout 5 | tree 3 | DPW 2 | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | |||||
| 104931 | 104931 | 98197 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 830 Joost Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6x24 | 5996641.8 | 2095053.2 | 37.732424500806204 | -122.45398057585 | (37.7324245008062, -122.45398057585) | ||||
| 11634 | 11634 | 101011 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 83 Santa Ynez Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 6x10 | 6000610.71791 | 2092062.1351 | 37.724438494726 | -122.44004473049101 | (37.724438494726, -122.440044730491) | |||
| 10128 | 10128 | 173868 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
| 10139 | 10139 | 173867 | Permitted Site 1 | :: 54 | 808 Capitol Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/31/2017 12:00:00 AM | 3 | 5995075.959430001 | 2089664.9067799998 | 37.717539636984206 | -122.45900401383601 | (37.7175396369842, -122.459004013836) | |||
| 10957 | 10957 | 17580 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003780.63082 | 2090335.5596900003 | 37.719877649504205 | -122.428963734788 | (37.7198776495042, -122.428963734788) | |||
| 11152 | 11152 | 17582 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003762.13068 | 2090345.22062 | 37.7199031291015 | -122.42902837176202 | (37.7199031291015, -122.429028371762) | |||
| 11319 | 11319 | 17589 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003683.23846 | 2090394.91559 | 37.720035114503006 | -122.42930461652 | (37.720035114503, -122.42930461652) | |||
| 11996 | 11996 | 17591 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 30 | 3x3 | 6003659.63671 | 2090407.2266799998 | 37.7200675818369 | -122.42938707716299 | (37.7200675818369, -122.429387077163) | |||
| 12305 | 12305 | 17584 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003740.32149 | 2090358.06458 | 37.7199371612464 | -122.42910467385201 | (37.7199371612464, -122.429104673852) |
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");