131 rows where qLegalStatus_id = 10 sorted by Supervisor Districts

View and edit SQL

qCaretaker_id

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)
23848 114246 Section 143 10 Magnolia grandiflora :: Southern Magnolia 19 54 COMMONWEALTH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996571 2114184 37.7849487713586 -122.455607632252 (37.7849487713586, -122.455607632252) 11 6 1 54 31
52587 107964 Section 143 10 Platanus x hispanica :: Sycamore: London Plane 27 2401x SCOTT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001096 2116670 37.7920333111805 -122.440130949989 (37.7920333111805, -122.440130949989) 13 6 1 29490 27
138302 107977 Section 143 10 Platanus x hispanica :: Sycamore: London Plane 27 2750 JACKSON ST 7 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001096.4 2116670.4 37.7920344322485 -122.440129594684 (37.7920344322485, -122.440129594684) 13 6 1 29490 27
143556 112627 Section 143 10 Tristaniopsis laurina :: Swamp Myrtle 1 2385 BUSH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002100 2114635 37.7865028312467 -122.436511387034 (37.7865028312467, -122.436511387034) 13 6 1 29490 27
189972 17872 Section 143 10 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2148 Pine St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 07/21/2010 12:00:00 AM 0 3X3 Permit Number 53638 6003654.7045158 2115269.5781823 37.7883334451781 -122.431177809024 (37.7883334451781, -122.431177809024) 13 9 1 29490 27
20128 103466 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 890X Sansome St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012118 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264) 3 1 10 28860 6
22900 103469 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 799X Battery St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012272.7 2118721.6 37.7982964705447 -122.401603488036 (37.7982964705447, -122.401603488036) 3 1 10 28860 6
41083 101926 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1099X Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639 2116135.7 37.7909365792809 -122.417454166812 (37.7909365792809, -122.417454166812) 13 1 10 28858 21
43905 103465 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 890X Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012118 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264) 3 1 10 28860 6
56667 103097 Section 143 10 Fagus sylvatica 'Red Obelisk' :: Red Obelisk Beech 483 1199X Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2013 12:00:00 AM   3x3 Permit Number 768649 6008392.3 2117900.9 37.7958257402639 -122.414972764224 (37.7958257402639, -122.414972764224) 5 1 10 308 21
134560 101923 Section 143 10 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1401X California St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007402.7 2116063.9 37.7907261358602 -122.418266664095 (37.7907261358602, -122.418266664095) 13 1 10 28858 21
169034 103467 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 890X Sansome St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012118 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264) 3 1 10 28860 6
184745 101925 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1099X Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639 2116135.7 37.7909365792809 -122.417454166812 (37.7909365792809, -122.417454166812) 13 1 10 28858 21
188204 101924 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1099X Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639 2116135.7 37.7909365792809 -122.417454166812 (37.7909365792809, -122.417454166812) 13 1 10 28858 21
4156 221064 Section 143 10 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6006466.14931 2110109.21502 37.7743232636311 -122.421084097148 (37.7743232636311, -122.421084097148) 7 9 11 28852 10
52698 118340 Section 143 10 Lophostemon confertus :: Brisbane Box 11 1 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006507 2110162 37.7744705012603 -122.420946535292 (37.7744705012603, -122.420946535292) 7 9 11 28852 10
106989 118337 Section 143 10 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006507 2110162 37.7744705012603 -122.420946535292 (37.7744705012603, -122.420946535292) 7 9 11 28852 10
117249 110651 Section 143 10 Metrosideros excelsa :: New Zealand Xmas Tree 16 127 CENTRAL AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   5999845 2108967 37.770811558248 -122.44390571749 (37.770811558248, -122.44390571749) 15 5 11 29492 9
131560 118336 Section 143 10 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006507 2110162 37.7744705012603 -122.420946535292 (37.7744705012603, -122.420946535292) 7 9 11 28852 10
138658 118338 Section 143 10 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2 Page St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006507 2110162 37.7744705012603 -122.420946535292 (37.7744705012603, -122.420946535292) 7 9 11 28852 10
168085 118341 Section 143 10 Lophostemon confertus :: Brisbane Box 11 1 Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006507 2110162 37.7744705012603 -122.420946535292 (37.7744705012603, -122.420946535292) 7 9 11 28852 10
179441 94563 Section 143 10 Tristaniopsis laurina :: Swamp Myrtle 1 301X Oak St 3 Sidewalk: Curb side : Tree Private 2   09/15/2010 12:00:00 AM     Permit Number 53745 6005493 2110231 37.7746027492624 -122.424459067949 (37.7746027492624, -122.424459067949) 7 9 11 28852 10
186791 118339 Section 143 10 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2 Page St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006507 2110162 37.7744705012603 -122.420946535292 (37.7744705012603, -122.420946535292) 7 9 11 28852 10
41654 112585 Section 143 10 Lagunaria patersonii :: Primrose Tree 6 3400x WAWONA ST 6 Sidewalk: Property side : Cutout Tree Private 2       4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
46414 112583 Section 143 10 Lagunaria patersonii :: Primrose Tree 6 3400x WAWONA ST 1 Sidewalk: Property side : Cutout Tree Private 2     1 4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
132551 112584 Section 143 10 Lagunaria patersonii :: Primrose Tree 6 3400x WAWONA ST 5 Sidewalk: Property side : Cutout Tree Private 2       4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
147556 112586 Section 143 10 Lagunaria patersonii :: Primrose Tree 6 3400x WAWONA ST 7 Sidewalk: Property side : Cutout Tree Private 2       4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
43048 98285 Section 143 10 Cercis occidentalis :: Western Redbud 136 300 Mangels Ave 1 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
54018 98287 Section 143 10 Cercis occidentalis :: Western Redbud 136 300 Mangels Ave 3 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
54581 98286 Section 143 10 Cercis occidentalis :: Western Redbud 136 300 Mangels Ave 2 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
54759 102523 Section 143 10 Liquidambar styraciflua :: American Sweet Gum 37 2192 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2013 12:00:00 AM   3X3 Permit Number 769544 5992300.8 2100554.8 37.7472806432819 -122.469388612726 (37.7472806432819, -122.469388612726) 1 8 4 29491 40
67384 112573 Section 143 10 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 56 ROCKWOOD CT 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2015 12:00:00 AM   3x6 Permit Number 776002 5995685 2098946 37.7430582687021 -122.457569991387 (37.7430582687021, -122.457569991387) 1 8 4 59 40
90728 113796 Section 143 10 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 331 TERESITA BLVD 2 Hanging basket : Cutout Tree Private 2       3x3   5997873 2098382 37.7416351035083 -122.449963874894 (37.7416351035083, -122.449963874894) 9 7 4 59 40
102643 98306 Section 143 10 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 155 Terrace Dr   Sidewalk: Curb side : Cutout Tree Private 2           5993776 2096639 37.7366139805049 -122.464003314893 (37.7366139805049, -122.464003314893) 1 8 4 59 40
144718 112574 Section 143 10 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 56 ROCKWOOD CT 2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2015 12:00:00 AM   3x6 Permit Number 776002 5995685 2098946 37.7430582687021 -122.457569991387 (37.7430582687021, -122.457569991387) 1 8 4 59 40
153338 113795 Section 143 10 Maytenus boaria :: Mayten 58 331 TERESITA BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997873 2098382 37.7416351035083 -122.449963874894 (37.7416351035083, -122.449963874894) 9 7 4 59 40
6989 109119 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
20563 109121 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 7 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
21125 109116 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
25414 109115 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
33280 110797 Section 143 10 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 440 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2015 12:00:00 AM 3     6003697.7 2098979.2 37.7436064433062 -122.429866615733 (37.7436064433062, -122.429866615733) 2 7 5 63 22
37646 110789 Section 143 10 Pinus radiata :: Monterey Pine 15 850x SANCHEZ ST 3 Front Yard : Cutout Tree Private 2       3x3   6003717 2103349 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694) 2 4 5 28862 22
42158 43568 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 601 29TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2000 12:00:00 AM     Permit Number 43230 6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7
43321 108260 Section 143 10 Liquidambar styraciflua :: American Sweet Gum 37 45 Belcher St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3     6003817.04493 2108084.54469 37.7686143220373 -122.430103370918 (37.7686143220373, -122.430103370918) 7 9 5 28862 3
51111 112619 Section 143 10 Cassia leptophylla :: Gold Medallion Tree 152 3534 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2015 12:00:00 AM   3x3   6005980 2102026.6 37.7521028905256 -122.42219142885 (37.7521028905256, -122.42219142885) 2 4 5 28859 19
57202 109123 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
67230 107533 Section 143 10 Tree(s) :: 17 130 MATEO ST 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2015 12:00:00 AM 3 3x3 Permit Number 774373 6003821.3 2096389.2 37.7365018950939 -122.429254591879 (37.7365018950939, -122.429254591879) 2 7 5 63 7
73175 85449 Section 143 10 Tree(s) :: 17 287 GUERRERO ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6005798 2107491.2 37.7670971345308 -122.423209217168 (37.7670971345308, -122.423209217168) 8 4 5 28853 19
77706 85451 Section 143 10 Tree(s) :: 17 281 GUERRERO ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6005518.5 2107341.2 37.7666694929162 -122.424165297356 (37.7666694929162, -122.424165297356) 8 4 5 28853 19
84488 112892 Section 143 10 Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 373 1X WEBSTER ST 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6004219 2108568 37.7699645303419 -122.428747509741 (37.7699645303419, -122.428747509741) 7 9 5 28862 10
89702 109120 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
92107 109124 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 10 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
94624 110787 Section 143 10 Tree(s) :: 17 850x SANCHEZ ST 1 Front Yard : Cutout Tree Private 2   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717 2103349 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694) 2 4 5 28862 22
98942 113300 Section 143 10 Magnolia grandiflora :: Southern Magnolia 19 29 DORLAND ST 1 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2015 12:00:00 AM 3 3x3   6005366 2105717 37.7622012138481 -122.424577222119 (37.7622012138481, -122.424577222119) 8 4 5 28859 19
103216 112891 Section 143 10 Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 373 1X WEBSTER ST 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6004219 2108568 37.7699645303419 -122.428747509741 (37.7699645303419, -122.428747509741) 7 9 5 28862 10
109575 109117 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
111448 111204 Section 143 10 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 168 CLIPPER ST 1 Sidewalk: Curb side : Cutout Tree Private 2   05/27/2015 12:00:00 AM 3 3x3   6004024 2101044 37.7492943788142 -122.428885525131 (37.7492943788142, -122.428885525131) 2 4 5 28862 22
126583 109122 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 8 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
172048 110788 Section 143 10 Tree(s) :: 17 850x SANCHEZ ST 2 Front Yard : Cutout Tree Private 2   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717 2103349 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694) 2 4 5 28862 22
182184 109118 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
107804 112688 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 259 BRIGHT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/18/2015 12:00:00 AM 3 5x4   5993720 2088919 37.71541351482 -122.4636368036 (37.71541351482, -122.4636368036) 9 8 6 64 24
183384 70518 Section 143 10 Prunus serrulata :: Ornamental Cherry 84 27 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/1994 12:00:00 AM   3x3 Permit Number 775094 6004529.42153392 2093371.60291271 37.7282563119694 -122.426591501924 (37.7282563119694, -122.426591501924) 9 7 6 28861 5
15934 113606 Section 143 10 Olea europaea :: Olive Tree 9 2900 18TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
38343 85458 Section 143 10 Tree(s) :: 17 265 Guerrero St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
38713 113610 Section 143 10 Olea europaea :: Olive Tree 9 595 ALABAMA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009000 2105472 37.7617330585457 -122.411991234579 (37.7617330585457, -122.411991234579) 8 4 7 28859 19
42613 85457 Section 143 10 Tree(s) :: 17 265 Guerrero St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
43092 85452 Section 143 10 Tree(s) :: 17 275 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006138 2107427 37.7669400383946 -122.422028645748 (37.7669400383946, -122.422028645748) 8 4 7 28853 19
53747 113998 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 1110 SOUTH VAN NESS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   10/27/2015 12:00:00 AM 3 3x3   6007591 2103152 37.7552837189859 -122.416700052453 (37.7552837189859, -122.416700052453) 2 4 7 28859 19
59693 113605 Section 143 10 Olea europaea :: Olive Tree 9 2900 18TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
65275 113613 Section 143 10 Olea europaea :: Olive Tree 9 595 ALABAMA ST 4 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009000 2105472 37.7617330585457 -122.411991234579 (37.7617330585457, -122.411991234579) 8 4 7 28859 19
69927 113600 Section 143 10 Olea europaea :: Olive Tree 9 550 FLORIDA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM 1 3x3 Permit Number 773946 6009233 2105681 37.7623199946126 -122.411200142124 (37.7623199946126, -122.411200142124) 8 4 7 28859 19
71895 113602 Section 143 10 Olea europaea :: Olive Tree 9 550 FLORIDA ST 3 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3 Permit Number 773946 6009233 2105681 37.7623199946126 -122.411200142124 (37.7623199946126, -122.411200142124) 8 4 7 28859 19
89445 113603 Section 143 10 Olea europaea :: Olive Tree 9 2900 18TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
102176 85456 Section 143 10 Tree(s) :: 17 265 Guerrero St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
106808 113611 Section 143 10 Olea europaea :: Olive Tree 9 595 ALABAMA ST 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009000 2105472 37.7617330585457 -122.411991234579 (37.7617330585457, -122.411991234579) 8 4 7 28859 19
106857 111194 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 890x JARBOE AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2015 12:00:00 AM   3x3 Permit Number 774267 6009115 2096842 37.7380434517433 -122.410983924329 (37.7380434517433, -122.410983924329) 10 7 7 28859 2
109380 111193 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 890x JARBOE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2015 12:00:00 AM 1 3x3 Permit Number 774267 6009115 2096842 37.7380434517433 -122.410983924329 (37.7380434517433, -122.410983924329) 10 7 7 28859 2
115452 113608 Section 143 10 Olea europaea :: Olive Tree 9 2900 18TH ST 6 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
118056 111195 Section 143 10 Corymbia ficifolia :: Red Flowering Gum 28 890x JARBOE AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     20 3x12   6009115 2096842 37.7380434517433 -122.410983924329 (37.7380434517433, -122.410983924329) 10 7 7 28859 2
119541 85450 Section 143 10 Tree(s) :: 17 285 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006141 2107369 37.7667809533476 -122.422014148516 (37.7667809533476, -122.422014148516) 8 4 7 28853 19
124812 85460 Section 143 10 Tree(s) :: 17 245x Guerrero St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128 2107603 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783) 8 4 7 28853 19
125555 85455 Section 143 10 Tree(s) :: 17 265 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
131278 85454 Section 143 10 Tree(s) :: 17 269 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
138839 113607 Section 143 10 Olea europaea :: Olive Tree 9 2900 18TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
140705 85459 Section 143 10 Tree(s) :: 17 245x Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128 2107603 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783) 8 4 7 28853 19
142909 85461 Section 143 10 Tree(s) :: 17 245x Guerrero St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128 2107603 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783) 8 4 7 28853 19
157435 113601 Section 143 10 Olea europaea :: Olive Tree 9 550 FLORIDA ST 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3 Permit Number 773946 6009233 2105681 37.7623199946126 -122.411200142124 (37.7623199946126, -122.411200142124) 8 4 7 28859 19
160668 72837 Section 143 10 Gleditsia triacanthos :: Honey Locust 182 2624 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2015 12:00:00 AM 3 3x3 Permit Number 770762 6010331.33933918 2104014.11752446 37.7578046465334 -122.407283867997 (37.7578046465334, -122.407283867997) 10 4 7 28859 19
161647 111085 Section 143 10 Acer japonicum :: Japanese Maple 124 117 Manchester St 1 Front Yard : Yard Tree Private 2   05/20/2015 12:00:00 AM 3   Permit Number 774000 6008295.8 2099262.4 37.7446433655077 -122.413987490618 (37.7446433655077, -122.413987490618) 2 7 7 28859 2
163668 113604 Section 143 10 Olea europaea :: Olive Tree 9 2900 18TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
170467 85453 Section 143 10 Tree(s) :: 17 271 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
181612 113609 Section 143 10 Olea europaea :: Olive Tree 9 2900 18TH ST 7 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
193056 113612 Section 143 10 Olea europaea :: Olive Tree 9 595 ALABAMA ST 3 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM   3x3   6009000 2105472 37.7617330585457 -122.411991234579 (37.7617330585457, -122.411991234579) 8 4 7 28859 19
6326 117138 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 2203x NEWCOMB AVE 3 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
34396 116471 Section 143 10 Olea europaea 'Fruitless' :: Fruitless Olive 177 882 Carolina St   Sidewalk: Curb side : Cutout Tree Private 2   04/04/2016 12:00:00 AM 3 3x3   6012399.9 2103853.8 37.757480004392 -122.400118621436 (37.757480004392, -122.400118621436) 10 3 8 28856 29
55582 117143 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 2203x NEWCOMB AVE 8 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
90738 117140 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 2203x NEWCOMB AVE 5 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
114728 117145 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 2203x NEWCOMB AVE 10 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
126441 117136 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 2203x NEWCOMB AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
132994 117150 Section 143 10 Eriobotrya deflexa :: Bronze Loquat 8 928 TOLAND ST 5 Front Yard : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011950 2098029 37.7414612698949 -122.401265252936 (37.7414612698949, -122.401265252936) 10 3 8 58 1

Next page

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