trees
39,840 rows where qLegalStatus_id = 7 sorted by qAddress descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75289 | 16471 | Permitted Site 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 9X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
| 81962 | 16476 | Permitted Site 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 9X Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6018697.2048701 | 2097076.1109207 | 37.7392189485182 | -122.377869364283 | (37.7392189485182, -122.377869364283) | 10 | 3 | 8 | 58 | 1 | |||
| 79494 | 102172 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 9X Hattie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) | 15 | 5 | 5 | 28862 | 3 |
| 187812 | 102171 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 9X Hattie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) | 15 | 5 | 5 | 28862 | 3 |
| 178712 | 33745 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x SAN JOSE AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1996 12:00:00 AM | 10 | 4x4 | Permit Number 37802 | 6006338 | 2102697 | 37.7539638411405 | -122.421001003808 | (37.7539638411405, -122.421001003808) | 2 | 4 | 5 | 28859 | 19 | |
| 23573 | 60472 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | 3x3 | Permit Number 20066 | 5997184 | 2089426 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | 9 | 8 | 6 | 28861 | 24 | |
| 79400 | 32464 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 99x Deming St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | Permit Number 36974 | 5999085.33670349 | 2105174.9537063 | 37.7603561904001 | -122.446260575093 | (37.7603561904001, -122.446260575093) | 15 | 5 | 5 | 28862 | 3 | ||
| 144870 | 24434 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 99X Peter Yorke Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2002 12:00:00 AM | 3 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | 13 | 9 | 1 | 28858 | 41 | ||
| 76518 | 52391 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 99X Park St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.424094095206 | (37.7368773658256, -122.424094095206) | 2 | 7 | 7 | 28859 | 2 |
| 96297 | 52390 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 99X Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.424094095206 | (37.7368773658256, -122.424094095206) | 2 | 7 | 7 | 28859 | 2 |
| 156134 | 52392 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 99X Park St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.424094095206 | (37.7368773658256, -122.424094095206) | 2 | 7 | 7 | 28859 | 2 |
| 190179 | 52389 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 99X Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.424094095206 | (37.7368773658256, -122.424094095206) | 2 | 7 | 7 | 28859 | 2 |
| 59968 | 47489 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 99X LYELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45384 | 6003192 | 2094433 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | 9 | 7 | 5 | 28861 | 25 | |
| 72072 | 47490 | Permitted Site 7 | Yucca gloriosa :: Spanish Dagger 126 | 99X LYELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | 2 | 3x3 | Permit Number 45384 | 6003192 | 2094433 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | 9 | 7 | 5 | 28861 | 25 | |
| 96582 | 47488 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 99X LYELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | 3x3 | Permit Number 45384 | 6003192 | 2094433 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | 9 | 7 | 5 | 28861 | 25 | ||
| 166623 | 32752 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 99X LOBOS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37130 | 5995934 | 2088667 | 37.7148489062392 | -122.455966075921 | (37.7148489062392, -122.455966075921) | 9 | 8 | 6 | 28861 | 24 | ||
| 92555 | 9315 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
| 125252 | 9316 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
| 21772 | 3914 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 99X Castro St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | ||
| 40390 | 3920 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
| 43569 | 3923 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2011 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | ||
| 55615 | 3918 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
| 69340 | 3912 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 99X Castro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | ||
| 77146 | 3910 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 99X Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | ||
| 78619 | 3922 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2001 12:00:00 AM | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | ||
| 81486 | 3924 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
| 88689 | 82306 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 99X Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002236.81411993 | 2107669.61965331 | 37.7673854141811 | -122.435539566136 | (37.7673854141811, -122.435539566136) | 15 | 5 | 5 | 28862 | 3 | ||
| 89700 | 3927 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
| 101939 | 3917 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
| 108333 | 3911 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 99X Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | ||
| 111951 | 3913 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
| 126241 | 27764 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
| 139918 | 3926 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
| 147445 | 3916 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
| 158946 | 3919 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
| 172617 | 3928 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
| 176655 | 3915 | Permitted Site 7 | Magnolia sargentiana 'Robusta' :: Robusta Magnolia 514 | 99X Castro St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | ||
| 187464 | 3921 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | |||
| 5959 | 36677 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 99X ALBION ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1998 12:00:00 AM | 16 | 3x3 | Permit Number 39481 | 6005790 | 2106965 | 37.7656518628938 | -122.42319948022 | (37.7656518628938, -122.42319948022) | 8 | 4 | 5 | 28853 | 19 | |
| 17724 | 36678 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 99X ALBION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1998 12:00:00 AM | 16 | 3x3 | Permit Number 39481 | 6005790 | 2106965 | 37.7656518628938 | -122.42319948022 | (37.7656518628938, -122.42319948022) | 8 | 4 | 5 | 28853 | 19 | |
| 64745 | 36679 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 99X ALBION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1998 12:00:00 AM | 14 | 3x3 | Permit Number 39481 | 6005790 | 2106965 | 37.7656518628938 | -122.42319948022 | (37.7656518628938, -122.42319948022) | 8 | 4 | 5 | 28853 | 19 | |
| 100199 | 36676 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 99X ALBION ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1998 12:00:00 AM | 14 | 3x3 | Permit Number 39481 | 6005790 | 2106965 | 37.7656518628938 | -122.42319948022 | (37.7656518628938, -122.42319948022) | 8 | 4 | 5 | 28853 | 19 | |
| 174066 | 36680 | Permitted Site 7 | Arecastrum romanzoffianum :: Queen Palm 135 | 99X ALBION ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1998 12:00:00 AM | 16 | 3x3 | Permit Number 39481 | 6005790 | 2106965 | 37.7656518628938 | -122.42319948022 | (37.7656518628938, -122.42319948022) | 8 | 4 | 5 | 28853 | 19 | |
| 104787 | 41729 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 99X 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | 8 | 4 | 7 | 28853 | 19 | ||
| 181210 | 41725 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 99X 14th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | 8 | 4 | 7 | 28853 | 19 | ||
| 185234 | 41728 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 99X 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | 8 | 4 | 7 | 28853 | 19 | ||
| 191578 | 41726 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 99X 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | 8 | 4 | 7 | 28853 | 19 | ||
| 122142 | 95091 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008785.98711 | 2111225.82851 | 37.777519721304 | -122.413138294803 | (37.777519721304, -122.413138294803) | 8 | 2 | 9 | 28853 | 34 | |
| 138911 | 95092 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2010 12:00:00 AM | 3 | 3x3 | Permit Number 771124 | 6008785.98711 | 2111225.82851 | 37.777519721304 | -122.413138294803 | (37.777519721304, -122.413138294803) | 8 | 2 | 9 | 28853 | 34 | |
| 14814 | 50011 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 99@ 20TH ST Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | Permit Number 46742 | |||||||||||||
| 22977 | 34457 | Permitted Site 7 | Arbutus unedo :: Strawberry Tree 106 | 999x UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 3x3 | Permit Number 38200 | 6008246 | 2119227 | 37.7994586593975 | -122.415572926479 | (37.7994586593975, -122.415572926479) | 5 | 1 | 10 | 308 | 32 | |
| 41044 | 34456 | Permitted Site 7 | Arbutus unedo :: Strawberry Tree 106 | 999x UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38200 | 6008246 | 2119227 | 37.7994586593975 | -122.415572926479 | (37.7994586593975, -122.415572926479) | 5 | 1 | 10 | 308 | 32 | ||
| 23960 | 18408 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 15 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 05/23/1997 12:00:00 AM | 18 | 2X4 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | ||
| 37801 | 18399 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 6 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 24 | 4x4 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | |||
| 49279 | 25482 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 16 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 18 | 3x3 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | |||
| 75845 | 25486 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 45 | 3X3 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | |||
| 79416 | 25483 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 17 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 12 | 3X3 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | |||
| 157580 | 25485 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 05/23/1997 12:00:00 AM | 8 | 3X3 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | ||
| 163918 | 18401 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 8 | Sidewalk: Property side : Cutout | Tree | Health Dept 13 | 18 | 4x4 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | |||
| 192557 | 25484 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 999X Potrero Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Health Dept 13 | 3 | 3x3 | 6010520.259169 | 2103656.1388783 | 37.7568322886407 | -122.406605275364 | (37.7568322886407, -122.406605275364) | 10 | 4 | 8 | 28859 | 19 | |||
| 136679 | 102437 | Permitted Site 7 | Washingtonia filifera :: California Fan Palm 176 | 999X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010518 | 2112007 | 37.77976171638 | -122.407201735558 | (37.77976171638, -122.407201735558) | 14 | 2 | 9 | 28853 | 34 | ||||
| 17286 | 24406 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/28/2000 12:00:00 AM | 6 | 3x3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
| 29397 | 24458 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 6 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
| 48230 | 11762 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | |||
| 63325 | 87708 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 999X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.52698 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | 9 | 8 | 6 | 64 | 24 | ||
| 71990 | 24457 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 999X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
| 88015 | 87706 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 999X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.52698 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | 9 | 8 | 6 | 64 | 24 | ||
| 92807 | 87707 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 999X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.52698 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | 9 | 8 | 6 | 64 | 24 | ||
| 98606 | 87710 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 999X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.52698 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | 9 | 8 | 6 | 64 | 24 | ||
| 99349 | 11760 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3x3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | |||
| 100522 | 11761 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 999X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
| 170020 | 24405 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/28/2000 12:00:00 AM | 12 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
| 170407 | 87709 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 999X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991255.914982 | 2090529.52698 | 37.719693336177 | -122.47227102474 | (37.719693336177, -122.47227102474) | 9 | 8 | 6 | 64 | 24 | ||
| 162587 | 20127 | Permitted Site 7 | Eucalyptus sideroxylon :: Red Ironbark 127 | 999X Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6003226.6736 | 2110648.3783 | 37.7756205244718 | -122.432328548686 | (37.7756205244718, -122.432328548686) | 15 | 9 | 11 | 29492 | 10 | |||
| 66620 | 28855 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 999X Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | 15 | 9 | 11 | 29492 | 10 | |||
| 72449 | 28851 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 999X Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | 15 | 9 | 11 | 29492 | 10 | |||
| 117417 | 28850 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 999X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | 15 | 9 | 11 | 29492 | 10 | |||
| 159153 | 28852 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 999X Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | 15 | 9 | 11 | 29492 | 10 | |||
| 176941 | 28854 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 999X Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | 15 | 9 | 11 | 29492 | 10 | |||
| 183767 | 28853 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 999X Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | 15 | 9 | 11 | 29492 | 10 | |||
| 79790 | 51611 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 999 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | Permit Number 47908 | 6006486.39229912 | 2113910.68802822 | 37.7847623267063 | -122.421284078173 | (37.7847623267063, -122.421284078173) | 13 | 9 | 11 | 28858 | 41 | |||
| 112342 | 23305 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 999 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6006374.81018 | 2113794.55882 | 37.7844371730387 | -122.421661865169 | (37.7844371730387, -122.421661865169) | 7 | 9 | 11 | 28858 | 41 | |||
| 32997 | 40317 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 999 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41459 | 6006351.75417313 | 2103777.48351974 | 37.7569313744996 | -122.421030150349 | (37.7569313744996, -122.421030150349) | 2 | 4 | 7 | 28859 | 19 | ||
| 191409 | 23304 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 999 VAN NESS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6006374 | 2113794 | 37.784435592971 | -122.421664628413 | (37.784435592971, -122.421664628413) | 7 | 9 | 11 | 28858 | 41 | |||
| 29089 | 27944 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | |||
| 39383 | 27948 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
| 86897 | 27949 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
| 113822 | 27947 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
| 129757 | 27951 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
| 137989 | 27946 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
| 145456 | 27950 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
| 177197 | 27945 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
| 74490 | 47919 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 999 Revised) Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | 6 | Permit Number 47908 | 6006486.39229912 | 2113910.68802822 | 37.7847623267063 | -122.421284078173 | (37.7847623267063, -122.421284078173) | 13 | 9 | 11 | 28858 | 41 | ||
| 79513 | 47917 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 999 Revised) Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2002 12:00:00 AM | Permit Number 45655 | 6006486.39229912 | 2113910.68802822 | 37.7847623267063 | -122.421284078173 | (37.7847623267063, -122.421284078173) | 13 | 9 | 11 | 28858 | 41 | |||
| 125915 | 47920 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 999 Revised) Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 45655 | 6006486.39229912 | 2113910.68802822 | 37.7847623267063 | -122.421284078173 | (37.7847623267063, -122.421284078173) | 13 | 9 | 11 | 28858 | 41 | ||||
| 138108 | 47918 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 999 Revised) Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 45655 | 6006486.39229912 | 2113910.68802822 | 37.7847623267063 | -122.421284078173 | (37.7847623267063, -122.421284078173) | 13 | 9 | 11 | 28858 | 41 | ||||
| 184138 | 59646 | Permitted Site 7 | Tree(s) :: 17 | 999 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1981 12:00:00 AM | Permit Number 19060 | 6002238.22079915 | 2109816.85060103 | 37.773281259813 | -122.435688339857 | (37.773281259813, -122.435688339857) | 15 | 5 | 11 | 29492 | 9 | |||
| 91740 | 31892 | Permitted Site 7 | Photinia fraseri :: Photinia Tree 225 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35322 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | 8 | 2 | 9 | 28853 | 34 | ||
| 157098 | 31891 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 999 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2002 12:00:00 AM | Permit Number 35322 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | 8 | 2 | 9 | 28853 | 34 | ||
| 50443 | 96012 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 999 California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767660 | 6009569 | 2116409 | 37.7917953978204 | -122.410795730189 | (37.7917953978204, -122.410795730189) | 5 | 1 | 10 | 28857 | 21 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );