trees

1,011 rows where qLegalStatus_id = 2 sorted by qSpecies_id

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

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)
193110 109470 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013467.61268 2109523.16527 37.7731063019529 -122.396823476633 (37.7731063019529, -122.396823476633) 14 2 9 310 20
34272 115532 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 2 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007293.46404 2111265.83422 37.7775456658356 -122.418304279225 (37.7775456658356, -122.418304279225) 7 9 9 28852 36
93518 115534 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 4 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007259.83389 2111260.26588 37.7775284833993 -122.418420222514 (37.7775284833993, -122.418420222514) 7 9 9 28852 36
115681 115533 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 3 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007275.38703 2111262.82601 37.7775363884346 -122.418366600452 (37.7775363884346, -122.418366600452) 7 9 9 28852 36
168962 115531 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 1 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007312.73746 2111269.98589 37.7775581502144 -122.41823790028 (37.7775581502144, -122.41823790028) 7 9 9 28852 36
184734 115535 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 5 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007237.56945 2111260.60051 37.7775281488378 -122.418497266559 (37.7775281488378, -122.418497266559) 7 9 9 28852 36
31022 79408 Planning Code 138.1 required 2 Quercus agrifolia :: Coast Live Oak 172 322 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 4x4 Permit Number 776851 6004758.73696772 2101857.84943819 37.7515705801104 -122.426402728229 (37.7515705801104, -122.426402728229) 2 4 5 28862 22
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
60942 247939 Planning Code 138.1 required 2 Quercus agrifolia :: Coast Live Oak 172 29 Joy St 2 Unaccepted Street : Yard Tree DPW 1     12   Permit Number 775404 6010258.29977 2098917.51569 37.7438064148349 -122.40717721395 (37.7438064148349, -122.40717721395) 2 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
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
14313 261295 Planning Code 138.1 required 2 Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 185 Stonecrest Dr 1 Sidewalk: Property side : Yard Tree Private 2   12/20/2019 12:00:00 AM 3 3x10 Permit Number 782878 5990774.03183 2093262.32002 37.727169005397 -122.474135998689 (37.727169005397, -122.474135998689) 9 8 4 64 40
6587 261546 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 1955 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2020 12:00:00 AM 3 3X3 Permit Number 783144 5985360.77923 2101907.46183 37.750591180724 -122.493485992107 (37.750591180724, -122.493485992107) 1 8 3 29491 35
61488 254585 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 1236 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995818 2107128 37.7655316119834 -122.457702020035 (37.7655316119834, -122.457702020035) 15 5 11 29492 12
78246 143041 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 2000 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2017 12:00:00 AM 3 Width 0ft Permit Number 780933 6009568.471 2120534.3867 37.8031226669303 -122.411089086343 (37.8031226669303, -122.411089086343) 3 1 10 308 23
167690 256776 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 244 Ashton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/13/2018 12:00:00 AM 3 3x3 Permit Number 781951 5994190.23703 2091515.08881 37.7225688371899 -122.462199635944 (37.7225688371899, -122.462199635944) 9 8 4 28861 24
178223 256896 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 470 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2018 12:00:00 AM 3 3x3 Permit Number 780643 5985651.17942 2112710.44444 37.7802701294342 -122.493277571063 (37.7802701294342, -122.493277571063) 11 6 2 55 26
190939 13063 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 590 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/29/2017 12:00:00 AM 3 2X2 Permit Number 780933 6009554.3361 2120533.7978 37.803120257284 -122.411137959105 (37.803120257284, -122.411137959105) 3 1 10 308 23
4912 261377 Planning Code 138.1 required 2 Olea Majestic Beauty :: 183 3015 25th Ave 2 Sidewalk: Property side : Yard Tree Private 2   01/08/2020 12:00:00 AM 3 4x10 Permit Number 784883 5988814.87181 2095155.07295 37.7322523337557 -122.481047245899 (37.7322523337557, -122.481047245899) 1 8 4 64 35
17863 261376 Planning Code 138.1 required 2 Olea Majestic Beauty :: 183 3015 25th Ave 1 Sidewalk: Property side : Yard Tree Private 2   01/08/2020 12:00:00 AM 3 4x10 Permit Number 784883 5988814.87181 2095155.07295 37.7322523337557 -122.481047245899 (37.7322523337557, -122.481047245899) 1 8 4 64 35
79775 251140 Planning Code 138.1 required 2 Olea Majestic Beauty :: 183 138 Parker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996904.98449 2113495.29925 37.783076941712 -122.454402393245 (37.783076941712, -122.454402393245) 11 6 1 54 31
19209 122592 Planning Code 138.1 required 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 72 Townsend St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
8601 222646 Planning Code 138.1 required 2 Ceanothus Sps :: California lilac 192 4209 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/06/2018 12:00:00 AM 3 Width 3ft   6001770.77195 2101738.59247 37.7510737715579 -122.436726932715 (37.7510737715579, -122.436726932715) 2 4 5 28862 22
21868 221950 Planning Code 138.1 required 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 31 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3 Permit Number 780973 6006097.6775 2099053.58173 37.7439462971915 -122.421573349947 (37.7439462971915, -122.421573349947) 2 7 7 28859 2
2139 251538 Planning Code 138.1 required 2 Brahea edulis :: Guadalupe Palm 218 1746 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981086 2103156 37.753768326371 -122.508360924805 (37.753768326371, -122.508360924805) 1 8 3 56 35
55332 115079 Planning Code 138.1 required 2 Brahea edulis :: Guadalupe Palm 218 1746 Great Hwy 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981053.87958296 2103176.2415425 37.7538220108937 -122.508473505042 (37.7538220108937, -122.508473505042) 1 8 3 56 35
56397 251539 Planning Code 138.1 required 2 Brahea edulis :: Guadalupe Palm 218 1746 Great Hwy 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981086 2103156 37.753768326371 -122.508360924805 (37.753768326371, -122.508360924805) 1 8 3 56 35
104008 79418 Planning Code 138.1 required 2 Brahea edulis :: Guadalupe Palm 218 1746 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2   10/27/2001 12:00:00 AM   3x3   5981053.87958296 2103176.2415425 37.7538220108937 -122.508473505042 (37.7538220108937, -122.508473505042) 1 8 3 56 35
13240 157603 Planning Code 138.1 required 2 Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 16 Fountain St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2020 12:00:00 AM 3 5x5 Permit Number 784681 6000322.25182 2101567.57465 37.7505217703771 -122.441723777343 (37.7505217703771, -122.441723777343) 2 4 5 28862 22
6077 230988 Planning Code 138.1 required 2 Magnolia spp :: Magnolia 224 44 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2018 12:00:00 AM 3 3x6 Permit Number 778706 6007424.10799 2099038.48568 37.7439795505181 -122.416985775987 (37.7439795505181, -122.416985775987) 2 7 7 28859 2
6656 258684 Planning Code 138.1 required 2 Magnolia spp :: Magnolia 224 222 Eucalyptus Dr 2 Sidewalk: Property side : Yard Tree Private 2   06/06/2019 12:00:00 AM 3 4x4 Permit Number 782190 5990522.43491 2094710.12159 37.7311297256611 -122.475111403646 (37.7311297256611, -122.475111403646) 1 8 4 64 35
8278 258683 Planning Code 138.1 required 2 Magnolia spp :: Magnolia 224 222 Eucalyptus Dr 1 Sidewalk: Property side : Yard Tree Private 2   06/06/2019 12:00:00 AM 3 4x4 Permit Number 782190 5990522.43491 2094710.12159 37.7311297256611 -122.475111403646 (37.7311297256611, -122.475111403646) 1 8 4 64 35
167011 254235 Planning Code 138.1 required 2 Syzygium australe :: Eugenia 228 454 Ralston St 1 Unaccepted Street : Cutout Tree Private 2       10x10   5992261 2090872 37.7206918008503 -122.468821743954 (37.7206918008503, -122.468821743954) 9 8 6 64 24
96128 73589 Planning Code 138.1 required 2 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 468 Clementina St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/09/1995 12:00:00 AM 12 3x3 Permit Number 770905 6010928.13640467 2111848.51157587 37.7793494887795 -122.405771720076 (37.7793494887795, -122.405771720076) 14 2 9 28853 34
6664 226514 Planning Code 138.1 required 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 248 1225 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2019 12:00:00 AM 3 3x3 Permit Number 781565 6005204.64951 2101211.39699 37.7498207677153 -122.424814719741 (37.7498207677153, -122.424814719741) 2 4 5 28859 19
6093 45072 Planning Code 138.1 required 2 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 596 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3 Permit Number 770844 6012065 2105633 37.7623466149115 -122.401401881236 (37.7623466149115, -122.401401881236) 8 3 8 28856 29
7223 106240 Planning Code 138.1 required 2 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 586 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3 Permit Number 770844 6012063 2105678 37.7624700633024 -122.401411961161 (37.7624700633024, -122.401411961161) 8 3 8 28856 29
10557 106246 Planning Code 138.1 required 2 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 560 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 770844 6012026 2105714 37.7625668468002 -122.401542461625 (37.7625668468002, -122.401542461625) 8 3 8 28856 29
168421 241673 Planning Code 138.1 required 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 21 Rosemont Pl 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/2018 12:00:00 AM 3 4x4 Permit Number 778206 6005133.3823 2108100.0759 37.7687314320489 -122.425551368812 (37.7687314320489, -122.425551368812) 8 4 5 28853 19
17339 166211 Planning Code 138.1 required 2 Cercis canadensis :: Eastern Redbud 346 3140 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6008730.35876 2101584.0935 37.7510426163255 -122.412648961786 (37.7510426163255, -122.412648961786) 2 4 7 28859 19
57409 256506 Planning Code 138.1 required 2 Cercis canadensis :: Eastern Redbud 346 978 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/15/2018 12:00:00 AM 3 3x3   6005672.85931 2103292.97405 37.7555627312558 -122.423343584439 (37.7555627312558, -122.423343584439) 2 4 5 28859 19
107033 104876 Planning Code 138.1 required 2 Prunus laurocerasus :: English laurel 371 2478 43rd Ave   Sidewalk: Property side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3   Permit Number 778928 5983068.6 2098273.8 37.7404797966413 -122.501143676277 (37.7404797966413, -122.501143676277) 1 8 3 29491 35
19663 256686 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 11 Back Yard : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
32624 258085 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 12 Sidewalk: Property side : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 10x10   5998725.10706 2103975.38052 37.7570418811558 -122.447420092492 (37.7570418811558, -122.447420092492) 15 5 4 63 38
75229 256683 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 1 Back Yard : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
127405 256685 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 10 Back Yard : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
130529 256674 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 2 Side Yard : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
158426 256673 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 1 Side Yard : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
185964 256684 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 9 Back Yard : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
28863 115887 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 134 Lunado Way 2 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 2x4 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
29841 115885 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 134 Lunado Way 1 Sidewalk: Property side : Yard Tree Private 2   03/01/2016 12:00:00 AM 3 10x10 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
45389 115886 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 134 Lunado Way 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 2x4 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
82843 243896 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 4225 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2018 12:00:00 AM 3 3x3   6001659.32992 2102313.2065 37.7526451902403 -122.437153446982 (37.7526451902403, -122.437153446982) 2 4 5 28862 22
38353 256715 Planning Code 138.1 required 2 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 1540 17th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/15/2019 12:00:00 AM 3 4x8 Permit Number 779534 5990911 2104908 37.7591529734205 -122.474512031039 (37.7591529734205, -122.474512031039) 1 8 4 56 12
174013 257892 Planning Code 138.1 required 2 Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 493 91 Canyon Dr 1 Front Yard : Yard Tree Private 2   01/11/2019 12:00:00 AM 3 3x3   6002890 2086311 37.7087766368694 -122.43175513536 (37.7087766368694, -122.43175513536) 9 7 6 28861 5

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);