Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90238 | 90238 | 16471 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
| 96388 | 96388 | 16476 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
| 97285 | 97285 | 102172 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 143029 | 143029 | 102171 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 144546 | 144546 | 33745 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x SAN JOSE AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 10 | 4x4 | Permit Number 37802 | 6006338.0 | 2102697.0 | 37.7539638411405 | -122.421001003808 | (37.7539638411405, -122.421001003808) | |
| 9827 | 9827 | 173704 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5997184.0 | 2089426.0 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | |||
| 9830 | 9830 | 60472 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | 3x3 | Permit Number 20066 | 5997184.0 | 2089426.0 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | |
| 10275 | 10275 | 32464 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99x Deming St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36974 | 5999085.33670349 | 2105174.9537063 | 37.7603561904001 | -122.446260575093 | (37.7603561904001, -122.446260575093) | ||
| 5935 | 5935 | 18670 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99X Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 5999509.53732 | 2119357.2628900004 | 37.799321375051704 | -122.445813455145 | (37.7993213750517, -122.445813455145) | |||
| 112421 | 112421 | 24434 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2002 12:00:00 AM | 3 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 92691 | 92691 | 52391 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 99103 | 99103 | 52390 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 119408 | 119408 | 52392 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 145547 | 145547 | 52389 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 88365 | 88365 | 47489 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 99X LYELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45384 | 6003192.0 | 2094433.0 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | |
| 90674 | 90674 | 47490 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 99X LYELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 2 | 3x3 | Permit Number 45384 | 6003192.0 | 2094433.0 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | |
| 101202 | 101202 | 47488 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 99X LYELL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 3x3 | Permit Number 45384 | 6003192.0 | 2094433.0 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | ||
| 119045 | 119045 | 32752 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X LOBOS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5995934.0 | 2088667.0 | 37.714848906239204 | -122.455966075921 | (37.7148489062392, -122.455966075921) | ||
| 8877 | 8877 | 103815 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Hemlock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006959.84507 | 2114826.77891 | 37.7873043685578 | -122.419711106691 | (37.7873043685578, -122.419711106691) | ||
| 9028 | 9028 | 103814 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Hemlock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006931.25215 | 2114822.01169 | 37.787289668217795 | -122.41980969397 | (37.7872896682178, -122.41980969397) | ||
| 92322 | 92322 | 9315 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 99X Gold Mine Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
| 104495 | 104495 | 9316 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 99X Gold Mine Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
| 9230 | 9230 | 3927 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 9370 | 9370 | 3926 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 9417 | 9417 | 3919 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 9469 | 9469 | 3928 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 77675 | 77675 | 3914 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X Castro St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
| 80306 | 80306 | 3923 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2011 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
| 83397 | 83397 | 3920 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 83410 | 83410 | 3918 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 88015 | 88015 | 3912 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X Castro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
| 91216 | 91216 | 3922 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2001 12:00:00 AM | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
| 92302 | 92302 | 3924 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 95881 | 95881 | 3910 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
| 97279 | 97279 | 82306 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002236.81411993 | 2107669.61965331 | 37.767385414181106 | -122.435539566136 | (37.7673854141811, -122.435539566136) | ||
| 97813 | 97813 | 3917 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 99898 | 99898 | 3913 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 102127 | 102127 | 3911 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
| 109662 | 109662 | 27764 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 112046 | 112046 | 3916 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 141616 | 141616 | 3915 | Permitted Site 1 | Magnolia sargentiana 'Robusta' :: Robusta Magnolia 508 | 99X Castro St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
| 142642 | 142642 | 3921 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | |||
| 17862 | 17862 | 36678 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 99X ALBION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1998 12:00:00 AM | 16 | 3x3 | Permit Number 39481 | 6005790.0 | 2106965.0 | 37.7656518628938 | -122.42319948021999 | (37.7656518628938, -122.42319948022) | |
| 91727 | 91727 | 36679 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 99X ALBION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1998 12:00:00 AM | 14 | 3x3 | Permit Number 39481 | 6005790.0 | 2106965.0 | 37.7656518628938 | -122.42319948021999 | (37.7656518628938, -122.42319948022) | |
| 99940 | 99940 | 36676 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 99X ALBION ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1998 12:00:00 AM | 14 | 3x3 | Permit Number 39481 | 6005790.0 | 2106965.0 | 37.7656518628938 | -122.42319948021999 | (37.7656518628938, -122.42319948022) | |
| 123834 | 123834 | 36677 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 99X ALBION ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1998 12:00:00 AM | 16 | 3x3 | Permit Number 39481 | 6005790.0 | 2106965.0 | 37.7656518628938 | -122.42319948021999 | (37.7656518628938, -122.42319948022) | |
| 141828 | 141828 | 36680 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 99X ALBION ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1998 12:00:00 AM | 16 | 3x3 | Permit Number 39481 | 6005790.0 | 2106965.0 | 37.7656518628938 | -122.42319948021999 | (37.7656518628938, -122.42319948022) | |
| 102043 | 102043 | 41729 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | ||
| 143280 | 143280 | 41725 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | ||
| 144874 | 144874 | 41728 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | ||
| 145443 | 145443 | 41726 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | ||
| 108776 | 108776 | 95091 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008785.98711 | 2111225.82851 | 37.777519721304 | -122.413138294803 | (37.777519721304, -122.413138294803) | |
| 115636 | 115636 | 95092 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2010 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008785.98711 | 2111225.82851 | 37.777519721304 | -122.413138294803 | (37.777519721304, -122.413138294803) | |
| 4834 | 4834 | 50011 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 99@ 20TH ST Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2003 12:00:00 AM | Permit Number 46742 | ||||||||
| 79343 | 79343 | 34456 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 999x UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38200 | 6008246.0 | 2119227.0 | 37.7994586593975 | -122.415572926479 | (37.7994586593975, -122.415572926479) | ||
| 124171 | 124171 | 34457 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 999x UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 3x3 | Permit Number 38200 | 6008246.0 | 2119227.0 | 37.7994586593975 | -122.415572926479 | (37.7994586593975, -122.415572926479) | |
| 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) | |||
| 85135 | 85135 | 25486 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 45 | 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) | |||
| 116367 | 116367 | 25485 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 05/23/1997 12:00:00 AM | 8 | 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) | |||
| 145249 | 145249 | 25484 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 999X Potrero Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 3 | 3x3 | 6010520.259169 | 2103656.1388783003 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | |||
| 116100 | 116100 | 102437 | Permitted Site 1 | Washingtonia filifera :: California Fan Palm 189 | 999X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6010518.0 | 2112007.0 | 37.77976171638 | -122.40720173555799 | (37.77976171638, -122.407201735558) | ||||
| 14778 | 14778 | 32943 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 999X Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37261 | 6015287.47006 | 2104039.63341 | 37.7581508424957 | -122.39014514528499 | (37.7581508424957, -122.390145145285) |
| 134683 | 134683 | 32942 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 999X Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 13 | Permit Number 37261 | 6015289.11919 | 2103969.2804799997 | 37.757957759865604 | -122.39013452698299 | (37.7579577598656, -122.390134526983) | |
| 81627 | 81627 | 11762 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3X3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | |||
| 86548 | 86548 | 24457 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
| 90644 | 90644 | 87708 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.5269799998 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | ||
| 94232 | 94232 | 87707 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.5269799998 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | ||
| 97337 | 97337 | 87706 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.5269799998 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | ||
| 98322 | 98322 | 87710 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.5269799998 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | ||
| 101927 | 101927 | 11761 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
| 103241 | 103241 | 11760 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3x3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | |||
| 117787 | 117787 | 24405 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/28/2000 12:00:00 AM | 12 | 3X3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
| 123921 | 123921 | 24406 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/28/2000 12:00:00 AM | 6 | 3x3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
| 125742 | 125742 | 24458 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 999X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 6 | 3X3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
| 138768 | 138768 | 87709 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.5269799998 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | ||
| 119460 | 119460 | 20127 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 999X Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6003226.6736 | 2110648.3783 | 37.7756205244718 | -122.432328548686 | (37.7756205244718, -122.432328548686) | |||
| 88514 | 88514 | 28851 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 90239 | 90239 | 28855 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 105963 | 105963 | 28850 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 123223 | 123223 | 28852 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 139447 | 139447 | 28854 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 141442 | 141442 | 28853 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 18727 | 18727 | 3939 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 999X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002271.23678 | 2107631.4399099997 | 37.7672825369934 | -122.43541777162201 | (37.7672825369934, -122.435417771622) | |||
| 15200 | 15200 | 92794 | Permitted Site 1 | Acacia decurrens :: Acacia: Silver Wattle 181 | 999 Wisconsin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2009 12:00:00 AM | 3 | Permit Number 52022 | 6012812.69075 | 2102940.3148 | 37.754994780604704 | -122.398626914107 | (37.7549947806047, -122.398626914107) | ||
| 43631 | 43631 | 50013 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 999 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2009 12:00:00 AM | 2 | Permit Number 52022 | 6012813.23846 | 2102916.22313 | 37.7549286606329 | -122.398623329429 | (37.7549286606329, -122.398623329429) | ||
| 151180 | 151180 | 50012 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 999 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2009 12:00:00 AM | 3 | Permit Number 52022 | 6012815.30679 | 2102898.98068 | 37.7548814318474 | -122.398614966606 | (37.7548814318474, -122.398614966606) | ||
| 155812 | 155812 | 92795 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 999 Wisconsin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 52022 | 6012811.72806 | 2102960.97452 | 37.755051454067505 | -122.398631693097 | (37.7550514540675, -122.398631693097) | ||
| 97115 | 97115 | 51611 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 999 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | Permit Number 47908 | 6006486.39229912 | 2113910.68802822 | 37.78476232670629 | -122.421284078173 | (37.7847623267063, -122.421284078173) | |||
| 100421 | 100421 | 23305 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 999 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006374.81018 | 2113794.55882 | 37.784437173038704 | -122.42166186516899 | (37.7844371730387, -122.421661865169) | |||
| 78138 | 78138 | 40317 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 999 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41459 | 6006351.75417313 | 2103777.48351974 | 37.7569313744996 | -122.42103015034901 | (37.7569313744996, -122.421030150349) | ||
| 145301 | 145301 | 23304 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 999 VAN NESS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6006374.0 | 2113794.0 | 37.784435592971 | -122.42166462841298 | (37.784435592971, -122.421664628413) | |||
| 76348 | 76348 | 27944 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | |||
| 83420 | 83420 | 27948 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 91110 | 91110 | 27949 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 98325 | 98325 | 27947 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 106831 | 106831 | 27951 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) |
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");