trees
159 rows where Supervisor Districts = 7 and qLegalStatus_id = 2 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
105170 | 252909 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 3201x 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x6 | Permit Number 777588 | 6007417 | 2106083 | 37.7633217807187 | -122.417509514421 | (37.7633217807187, -122.417509514421) | 8 | 4 | 7 | 28859 | 19 | |
41739 | 253164 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 146 Cambridge St | 1 | Front Yard : Cutout | Tree | Private 2 | 07/27/2017 12:00:00 AM | 3 | 4x4 | 6006598.94029 | 2094006.41191 | 37.7301161400075 | -122.419482094225 | (37.7301161400075, -122.419482094225) | 9 | 7 | 7 | 309 | 5 | ||
122256 | 254396 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 167 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 774780 | 6006150.23201 | 2093073.81475 | 37.7275301484246 | -122.420967149802 | (37.7275301484246, -122.420967149802) | 9 | 7 | 7 | 309 | 5 | |
119230 | 254617 | Planning Code 138.1 required 2 | :: 45 | 685 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 773164 | 6009303.1948 | 2105068.09113 | 37.7606410229668 | -122.410914072761 | (37.7606410229668, -122.410914072761) | 2 | 4 | 7 | 28859 | 19 | |
27287 | 255049 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 925 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779631 | 6009075.60356 | 2091383.60862 | 37.7230536656288 | -122.410734764023 | (37.7230536656288, -122.410734764023) | 9 | 3 | 7 | 309 | 28 | |
133371 | 255306 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1163 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2018 12:00:00 AM | 3 | 3x6 | Permit Number 777039 | 6008085.276 | 2101160.09095 | 37.7498421745418 | -122.414849724814 | (37.7498421745418, -122.414849724814) | 2 | 4 | 7 | 28859 | 19 | |
183741 | 255653 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 298X Coso Ave | 1 | Side Yard : Yard | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 10x10 | Permit Number 776462 | 6007785 | 2099424 | 37.7450583812321 | -122.415765181935 | (37.7450583812321, -122.415765181935) | 2 | 7 | 7 | 28859 | 2 | |
48760 | 255654 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 298X Coso Ave | 2 | Side Yard : Yard | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 10x10 | Permit Number 776462 | 6007785 | 2099424 | 37.7450583812321 | -122.415765181935 | (37.7450583812321, -122.415765181935) | 2 | 7 | 7 | 28859 | 2 | |
173437 | 255664 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 368 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781650 | 6007860.32032 | 2092132.7947 | 37.7250425565594 | -122.414988767826 | (37.7250425565594, -122.414988767826) | 9 | 3 | 7 | 309 | 28 | |
182774 | 255792 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2018 12:00:00 AM | 3 | 3x3 | 6007843 | 2092137 | 37.7250531301082 | -122.415048939995 | (37.7250531301082, -122.415048939995) | 9 | 3 | 7 | 309 | 28 | ||
131611 | 255979 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 965 Powhattan Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776273 | 6009246 | 2098072 | 37.7414281092456 | -122.410617825786 | (37.7414281092456, -122.410617825786) | 10 | 7 | 7 | 28859 | 2 | ||
176317 | 256115 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 503 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 774745 | 6007867.72621 | 2096528.91607 | 37.7371137709195 | -122.41527422465 | (37.7371137709195, -122.41527422465) | 2 | 7 | 7 | 28859 | 2 | |
172871 | 256721 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 1025 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 776275 | 6009358 | 2098062 | 37.7414069300959 | -122.410229861131 | (37.7414069300959, -122.410229861131) | 10 | 7 | 7 | 28859 | 2 | |||
71921 | 256722 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 985 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776274 | 6009288 | 2098069 | 37.7414222265504 | -122.410472391962 | (37.7414222265504, -122.410472391962) | 10 | 7 | 7 | 28859 | 2 | |
98671 | 256868 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 965 Powhattan Ave | 1 | Side Yard : Yard | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776273 | 6009246.49493 | 2098072.65991 | 37.7414299489627 | -122.410616161073 | (37.7414299489627, -122.410616161073) | 10 | 7 | 7 | 28859 | 2 | |
155799 | 256869 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 985 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776274 | 6009287.99434 | 2098069.06568 | 37.7414224065761 | -122.410472416169 | (37.7414224065761, -122.410472416169) | 10 | 7 | 7 | 28859 | 2 | |
93272 | 256871 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 1025 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776275 | 6009358.6182 | 2098062.94866 | 37.7414095695618 | -122.410227790564 | (37.7414095695618, -122.410227790564) | 10 | 7 | 7 | 28859 | 2 | |
125934 | 256878 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3098 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009121.70897 | 2101021.23838 | 37.7495190982493 | -122.411255871462 | (37.7495190982493, -122.411255871462) | 2 | 4 | 7 | 28859 | 19 | |
99548 | 256905 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 338 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781421 | 6007824.5446 | 2092249.93927 | 37.7253622000817 | -122.415120729164 | (37.7253622000817, -122.415120729164) | 9 | 3 | 7 | 309 | 28 | |
125325 | 256910 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 835 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2019 12:00:00 AM | 3 | 3x3 | 6007598 | 2104806 | 37.7598256170474 | -122.416793017555 | (37.7598256170474, -122.416793017555) | 2 | 4 | 7 | 28859 | 19 | ||
76348 | 258086 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 381 Lexington St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x1 | 6006575 | 2103913 | 37.7573160533564 | -122.420267699006 | (37.7573160533564, -122.420267699006) | 2 | 4 | 7 | 28859 | 19 | ||||
180002 | 258222 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 2997 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3x3 | 6009042 | 2101022 | 37.7495167187784 | -122.41153156233 | (37.7495167187784, -122.41153156233) | 2 | 4 | 7 | 28859 | 19 | |||
152958 | 258304 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 2946 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008567 | 2103911 | 37.7574226061115 | -122.413378415329 | (37.7574226061115, -122.413378415329) | 2 | 4 | 7 | 28859 | 19 | ||||
18610 | 259660 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008872.21502 | 2103120.32489 | 37.7552687230844 | -122.412266973836 | (37.7552687230844, -122.412266973836) | 2 | 4 | 7 | 28859 | 19 | |
3329 | 260429 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
12438 | 260430 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
5901 | 260465 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3933 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2019 12:00:00 AM | 3 | 3x4 | Permit Number 782033 | 6005003.24747 | 2095750.87761 | 37.7348160467336 | -122.425122689163 | (37.7348160467336, -122.425122689163) | 2 | 7 | 7 | 28861 | 2 | |
8319 | 260505 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 760 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784870 | 6007464 | 2105234 | 37.7609932681872 | -122.417286789238 | (37.7609932681872, -122.417286789238) | 2 | 4 | 7 | 28859 | 19 | |
11040 | 260952 | Planning Code 138.1 required 2 | Nyssa sylvatica :: Tupelo: Sour Gum 92 | 1296 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x8 | 6008013 | 2100716 | 37.7486187391462 | -122.4150682294 | (37.7486187391462, -122.4150682294) | 2 | 4 | 7 | 28859 | 19 | ||||
13412 | 260953 | Planning Code 138.1 required 2 | Nyssa sylvatica :: Tupelo: Sour Gum 92 | 1296 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x8 | 6008013 | 2100716 | 37.7486187391462 | -122.4150682294 | (37.7486187391462, -122.4150682294) | 2 | 4 | 7 | 28859 | 19 | ||||
11620 | 260954 | Planning Code 138.1 required 2 | Nyssa sylvatica :: Tupelo: Sour Gum 92 | 1296 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x8 | 6008013 | 2100716 | 37.7486187391462 | -122.4150682294 | (37.7486187391462, -122.4150682294) | 2 | 4 | 7 | 28859 | 19 | ||||
4803 | 260955 | Planning Code 138.1 required 2 | Nyssa sylvatica :: Tupelo: Sour Gum 92 | 1296 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x8 | 6008013 | 2100716 | 37.7486187391462 | -122.4150682294 | (37.7486187391462, -122.4150682294) | 2 | 4 | 7 | 28859 | 19 | ||||
8190 | 261370 | Planning Code 138.1 required 2 | Eriobotrya japonica :: Edible Loquat 119 | 102 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007140 | 2095356 | 37.7338522748733 | -122.417707198486 | (37.7338522748733, -122.417707198486) | 2 | 7 | 7 | 28859 | 2 | ||||
11346 | 261371 | Planning Code 138.1 required 2 | Syagrus romanzoffianum :: Queen Palm 85 | 105 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007217 | 2095358 | 37.7338620991787 | -122.417441127318 | (37.7338620991787, -122.417441127318) | 2 | 7 | 7 | 28859 | 2 | ||||
6487 | 261445 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007092 | 2095790 | 37.7350412423636 | -122.417903903871 | (37.7350412423636, -122.417903903871) | 2 | 7 | 7 | 28859 | 2 | ||||
12221 | 261589 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 299x 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006795 | 2107850 | 37.7681385292637 | -122.41978620049 | (37.7681385292637, -122.41978620049) | 8 | 4 | 7 | 28853 | 19 | ||||
2941 | 261590 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 299x 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006795 | 2107850 | 37.7681385292637 | -122.41978620049 | (37.7681385292637, -122.41978620049) | 8 | 4 | 7 | 28853 | 19 | ||||
1902 | 261997 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
10030 | 261998 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
8936 | 261999 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
9770 | 262000 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
7258 | 262001 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
18826 | 262002 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
17746 | 262424 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 328 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2020 12:00:00 AM | 3 | 3x3 | 6006735.98718 | 2096026.524 | 37.7356706425738 | -122.419151541699 | (37.7356706425738, -122.419151541699) | 2 | 7 | 7 | 28859 | 2 | ||
170272 | 31068 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1450 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007659.7746 | 2107385.50696 | 37.7669118184545 | -122.4167621155 | (37.7669118184545, -122.4167621155) | 8 | 4 | 7 | 28853 | 19 | |
74821 | 36044 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3030 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.7638748076146 | -122.413665776536 | (37.7638748076146, -122.413665776536) | 8 | 4 | 7 | 28859 | 19 | |
177206 | 36045 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3030 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.7638748076146 | -122.413665776536 | (37.7638748076146, -122.413665776536) | 8 | 4 | 7 | 28859 | 19 | |
34711 | 44001 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
37180 | 44003 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
177064 | 44004 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
145930 | 44005 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
72715 | 44010 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 405x Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
176140 | 44012 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 405X Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
191118 | 44013 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
3990 | 60261 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2495 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776014 | 6008888.61229415 | 2103948.71328851 | 37.7575442102667 | -122.412268813453 | (37.7575442102667, -122.412268813453) | 2 | 4 | 7 | 28859 | 19 | |
119022 | 60277 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2690 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51145 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | 2 | 4 | 7 | 28859 | 19 | ||
88632 | 60705 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 963 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1983 12:00:00 AM | 1 | 3x3 | Permit Number 20354 | 6009178.18020232 | 2103559.73737881 | 37.7564924147418 | -122.4112398899 | (37.7564924147418, -122.4112398899) | 2 | 4 | 7 | 28859 | 19 | |
32243 | 66394 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 504 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2016 12:00:00 AM | 3 | 3x4 | Permit Number 772815 | 6007447.25872729 | 2096493.62336554 | 37.7369932248849 | -122.41672547553 | (37.7369932248849, -122.41672547553) | 2 | 7 | 7 | 28859 | 2 | |
53742 | 82615 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2901 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777487 | 6010040.72394239 | 2101604.72592715 | 37.7511727251881 | -122.408119020981 | (37.7511727251881, -122.408119020981) | 2 | 4 | 7 | 28859 | 19 |
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) );