194,517 rows sorted by Fire Prevention Districts descending

View and edit SQL

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)
3 121463 Planning Code 138.1 required 2 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 415 Oxford St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2020 12:00:00 AM 3 3x3 Permit Number 778984 6006773.54328 2092061.724 37.7247862819155 -122.418740608563 (37.7247862819155, -122.418740608563) 9 7 7 309 28
11 264841 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1601 Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6007819 2087884 37.7133739406818 -122.41483104388 (37.7133739406818, -122.41483104388) 9 7 8 309 39
17 164866 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 719 Faxon Ave 1 Sidewalk: Property side : Yard Tree Private 2   11/16/2020 12:00:00 AM 3 4x6 Permit Number 782492 5994853.78052 2092811.30491 37.7261661184654 -122.459999785581 (37.7261661184654, -122.459999785581) 9 7 4 28861 40
21 264839 DPW Maintained 1 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1601 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6007819 2087884 37.7133739406818 -122.41483104388 (37.7133739406818, -122.41483104388) 9 7 8 309 39
27 121462 Planning Code 138.1 required 2 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 415 Oxford St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2020 12:00:00 AM 3 3x3 Permit Number 778984 6006773.54328 2092061.724 37.7247862819155 -122.418740608563 (37.7247862819155, -122.418740608563) 9 7 7 309 28
30 254372 Permitted Site 7 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 62 Tioga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2020 12:00:00 AM 3 3x3 Permit Number 778036 6010859.22958 2088882.34048 37.7162855403434 -122.404393121162 (37.7162855403434, -122.404393121162) 9 7 8 309 39
32 264850 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 172 University St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6007951 2093149 37.7278379340298 -122.414747181337 (37.7278379340298, -122.414747181337) 9 3 7 309 5
41 159866 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 20 Ruth St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2020 12:00:00 AM 3 4x6   6001590.27181 2091627.71254 37.7233013847479 -122.436627471279 (37.7233013847479, -122.436627471279) 9 7 6 28861 25
44 159867 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 20 Ruth St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2020 12:00:00 AM 3 4x6   6001543.73914 2091652.70256 37.7233673572035 -122.436790113668 (37.7233673572035, -122.436790113668) 9 7 6 28861 25
47 264965 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 951 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994993 2090257 37.7191606150529 -122.45933361899 (37.7191606150529, -122.45933361899) 9 8 6 28861 24
48 159865 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 20 Ruth St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2020 12:00:00 AM 3 4x6   6001621.37029 2091612.17517 37.7232604898693 -122.436518858358 (37.7232604898693, -122.436518858358) 9 7 6 28861 25
49 261834 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 20x Ruth St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/19/2020 12:00:00 AM 3 4x6   6001536 2091749 37.7236313283612 -122.436823756643 (37.7236313283612, -122.436823756643) 9 7 6 28861 25
54 216739 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 11 Brighton Ave 1 Sidewalk: Curb side : Yard Tree Private 2   11/23/2020 12:00:00 AM 3 Width 3ft   5996185.57101 2089978.26988 37.7184637821573 -122.4551912491 (37.7184637821573, -122.4551912491) 9 8 6 28861 24
55 1166 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2900 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/23/2020 12:00:00 AM 25 3X3   5997012.91474 2087625.16187 37.7120501257788 -122.45216178836 (37.7120501257788, -122.45216178836) 9 7 6 28861 25
133 211075 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 650x Miramar Ave 6 Median : Yard Tree DPW 1     34     5995390.83549 2093912.64173 37.7292209976493 -122.458222905073 (37.7292209976493, -122.458222905073) 9 7 4 28861 40
138 203559 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 145 Lakeview Ave 1 : Tree Private 2     1 Width 3ft   5997146.51683 2089373.33367 37.7168578537955 -122.45182605794 (37.7168578537955, -122.45182605794) 9 8 6 28861 24
144 108797 Undocumented 4 :: 45 501-599 University St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008503.45306 2091469.83252 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961) 9 3 7 309 18
148 108238 Undocumented 4 Tree(s) :: 17 764x JUNIPERO SERRA BLVD 1 Median : Yard Tree Private 2           5991289.6 2092496.8 37.7250969308873 -122.472297921456 (37.7250969308873, -122.472297921456) 9 8 4 64 40
170 108637 Property Tree 8 Pinus radiata :: Monterey Pine 15 15 TUCKER AVE   Back Yard : Yard Tree Private 2           6011049.2 2088423.2 37.7150354478954 -122.403704200211 (37.7150354478954, -122.403704200211) 9 7 8 309 39
171 50655 Permitted Site 7 Tree(s) :: 17 430 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47238 6008643.36799877 2088325.11427356 37.7146314352433 -122.412012884014 (37.7146314352433, -122.412012884014) 9 7 8 309 18
173 27068 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 801 Silver Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1     3 4   6006971.0744 2093616.11167 37.7290654140285 -122.418167915919 (37.7290654140285, -122.418167915919) 9 3 7 309 28
184 204541 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 400x Marietta Dr 4 Median : Cutout Tree DPW 1     16 Width 3ft   5999538.51913 2097033.8732 37.7380286277303 -122.444108242518 (37.7380286277303, -122.444108242518) 9 7 4 59 40
189 178694 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 184 Mount Vernon Ave 7 Side Yard : Yard Tree Private 2     9     5998957.82756 2089383.479 37.7169892861082 -122.445565994978 (37.7169892861082, -122.445565994978) 9 7 6 28861 25
207 251656 DPW Maintained 1 Tree(s) :: 17 31x Malta Dr 1 unknown : Yard Tree Private 2       3x3   5999423 2096089 37.7354276387403 -122.44443976141 (37.7354276387403, -122.44443976141) 9 7 4 63 40
210 1023 DPW Maintained 1 Ulmus americana :: American Elm 74 1925 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6000937.4135 2090832.4174 37.7210805620079 -122.438827310136 (37.7210805620079, -122.438827310136) 9 7 6 28861 25
226 56655 Permitted Site 7 Tree(s) :: 17 491 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2           5993749.22353597 2090472.28724098 37.7196801529508 -122.463648462413 (37.7196801529508, -122.463648462413) 9 8 6 64 24
237 15807 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 4959 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1995 12:00:00 AM 6 3X3   6000887.014 2090089.1979 37.7190369816005 -122.438948290663 (37.7190369816005, -122.438948290663) 9 7 6 28861 5
245 251484 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 900 Bosworth St 7 Front Yard : Yard Tree DPW 1           6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
252 204152 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 900 Junipero Serra Blvd 37 : Tree Private 2     1 Width 0ft   5991169.92245 2090751.38969 37.7202975393725 -122.472584434247 (37.7202975393725, -122.472584434247) 9 8 4 64 40
261 119280 Undocumented 4 Ficus nitida :: Laurel Fig 53 95 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995293 2090512 37.7198780283713 -122.458315087488 (37.7198780283713, -122.458315087488) 9 8 6 28861 24
263 17585 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 801X Persia Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6003724.8526 2090366.56287 37.71995962001 -122.429158750084 (37.71995962001, -122.429158750084) 9 7 6 28861 5
289 211158 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 300x Marietta Dr 38 Median : Cutout Tree DPW 1     21 Width 5ft   5999457.51761 2097516.55077 37.7393493243992 -122.444422982731 (37.7393493243992, -122.444422982731) 9 7 4 59 40
291 210733 DPW Maintained 1 Olea europaea :: Olive Tree 9 239 Ramsell St 1 : Tree Private 2     7 Width 3ft   5992956.15258 2088805.34296 37.7150573966491 -122.466268722147 (37.7150573966491, -122.466268722147) 9 8 6 64 24
294 53493 Permitted Site 7 Tree(s) :: 17 262 Ralston St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1969 12:00:00 AM     Permit Number 6403 5992228.28376051 2089608.56362168 37.717220822263 -122.468842940668 (37.717220822263, -122.468842940668) 9 8 6 64 24
301 108803 Undocumented 4 :: 45 401-499 University St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008323.15237 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207) 9 3 7 309 28
310 218546 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 25 Elmhurst Dr 5 : Tree Private 2     7 Width 3ft   5991216.07157 2094485.7269 37.730553771324 -122.472697049151 (37.730553771324, -122.472697049151) 9 8 4 64 40
321 219060 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 221 Congo St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6000072.85251 2094491.10418 37.731077247812 -122.442078323383 (37.731077247812, -122.442078323383) 9 7 4 63 40
323 106136 Undocumented 4 Tree(s) :: 17 200X RIDGEWOOD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996801 2094865 37.7319168756422 -122.453416604011 (37.7319168756422, -122.453416604011) 9 7 4 59 40
379 215760 DPW Maintained 1 Ulmus spp :: Elm Spp 98 811 Congo St 21 Sidewalk: Property side : Yard Tree Private 2     13 Width 10ft   6000555.25402 2095877.7313 37.734912082925 -122.440509997443 (37.734912082925, -122.440509997443) 9 7 4 63 40
383 94356 DPW Maintained 1 Tree(s) :: 17 455 Delano Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   5999581.42646 2091332.3229 37.7223759483442 -122.443550437353 (37.7223759483442, -122.443550437353) 9 7 6 28861 25
384 415 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 3862 19th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 2X6   5990878.96388 2090116.60552 37.7185377326944 -122.473543893183 (37.7185377326944, -122.473543893183) 9 8 4 64 40
390 255918 Property Tree 8 Pinus radiata :: Monterey Pine 15 80 Molimo Dr 1 Back Yard : Yard Tree Private 2       10x10   5998634.42423 2096706.77911 37.7370788872961 -122.447210599537 (37.7370788872961, -122.447210599537) 9 7 4 59 40
392 108811 Undocumented 4 :: 45 301-399 University St 5 Sidewalk: Curb side : Cutout Tree Private 2           6008160.40727 2092653.74948 37.7264898456848 -122.413988233103 (37.7264898456848, -122.413988233103) 9 3 7 309 28
420 35740 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 9 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/15/1998 12:00:00 AM 12   Permit Number 39014 6007525.01662 2093953.73286 37.7300236128799 -122.416276791867 (37.7300236128799, -122.416276791867) 9 3 7 309 28
421 65202 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 415 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM 29   Permit Number 27188 6004121.81538 2090701.65991 37.7209021868562 -122.4278104505 (37.7209021868562, -122.4278104505) 9 7 6 28861 5
430 121151 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1X Payson St 1 Side Yard : Yard Tree DPW 1     25 3x3   5992041 2087761 37.7121370380572 -122.469355880776 (37.7121370380572, -122.469355880776) 9 8 4 64 24
434 102445 Undocumented 4 Tree(s) :: 17 900 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6001563.3 2088855.6 37.7156882523244 -122.436522388875 (37.7156882523244, -122.436522388875) 9 7 6 28861 5
435 108949 Permitted Site 7 :: 45 254 Dublin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6003932.1 2088992 37.7161971007686 -122.428344449747 (37.7161971007686, -122.428344449747) 9 7 6 28861 5
440 204255 DPW Maintained 1 Arbutus unedo :: Strawberry Tree 106 40 Rossmoor Dr 1 : Tree Private 2     2 Width 3ft   5991076.25798 2094451.16026 37.7304507656815 -122.473177880653 (37.7304507656815, -122.473177880653) 9 8 4 64 40
444 105900 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 11X ELLIOT ST 1 Unaccepted Street : Yard Tree DPW 1     30     6009059 2088845 37.716082244868 -122.410612975888 (37.716082244868, -122.410612975888) 9 7 8 309 18
450 178165 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 20 Median : Cutout Tree Private 2     5 Width 0ft   5992928.58802 2087852.90738 37.7124406464989 -122.466294818667 (37.7124406464989, -122.466294818667) 9 8 4 64 24
471 205972 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 400x Marietta Dr 49 Median : Cutout Tree DPW 1     2 Width 3ft   5998976.04571 2096922.6715 37.7376911903888 -122.446044988292 (37.7376911903888, -122.446044988292) 9 7 4 59 40
473 175337 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 114 De Long St 4 : Tree Private 2     14 Width 3ft   5994455.45704 2086824.92953 37.7097060419823 -122.460943071888 (37.7097060419823, -122.460943071888) 9 8 6 28861 25
485 251655 DPW Maintained 1 Shrub :: Shrub 66 300x Chester Ave 1 Sidewalk: Property side : Yard Tree DPW 1       3x3   5991691 2087193 37.7105572148468 -122.470524229297 (37.7105572148468, -122.470524229297) 9 8 4 64 24
498 260403 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500X Brotherhood Way 1 Median : Yard Tree Private 2       30x30   5992691 2087881 37.712504070633 -122.467118029673 (37.712504070633, -122.467118029673) 9 8 6 64 24
499 180799 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 315 Mount Vernon Ave 1 Front Yard : Yard Tree Private 2   10/23/2019 12:00:00 AM 3 8x8 Permit Number 782754 5998557.73755 2089669.84713 37.7177527376786 -122.446969503064 (37.7177527376786, -122.446969503064) 9 7 6 28861 25
504 78734 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 901 Huron Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5997023.15719 2086886.03529 37.710021240846 -122.452073093618 (37.710021240846, -122.452073093618) 9 7 6 28861 25
506 264804 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 600X Visitacion Ave 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6010564 2086911 37.7108561363482 -122.405274840324 (37.7108561363482, -122.405274840324) 9 7 8 309 39
513 159793 DPW Maintained 1 Ulmus 'Frontier' :: Frontier Elm 115 2555 Alemany Blvd 5 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5998756.20778 2088659.33531 37.7149894402837 -122.446210834072 (37.7149894402837, -122.446210834072) 9 7 6 28861 25
519 259637 DPW Maintained 1 :: 45 95 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3     6010745.67067 2087724.79538 37.7131008096728 -122.404704194453 (37.7131008096728, -122.404704194453) 9 7 8 309 39
528 57932 Permitted Site 7 Tree(s) :: 17 583 Brunswick St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/1977 12:00:00 AM     Permit Number 16891 5999047.47505332 2086793.7936429 37.7098837148731 -122.445070058439 (37.7098837148731, -122.445070058439) 9 7 6 28861 5
533 257925 Property Tree 8 Pinus radiata :: Monterey Pine 15 274 Staples Ave   Back Yard : Yard Tree Private 2       10x10   5998272.17919 2093819.44967 37.7291302611298 -122.448255187535 (37.7291302611298, -122.448255187535) 9 7 4 28861 40
539 178708 DPW Maintained 1 Podocarpus gracilor :: Fern Pine 51 500 London St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 3 Width 3ft   6001593.53028 2090821.75006 37.721088578565 -122.436558547244 (37.721088578565, -122.436558547244) 9 7 6 28861 5
540 35140 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 911 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1998 12:00:00 AM 7   Permit Number 38670 6001882.60594 2088665.49745 37.7151844124098 -122.435405132561 (37.7151844124098, -122.435405132561) 9 7 6 28861 5
559 65188 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 259 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM 15 3x3 Permit Number 27172 6002967.27009 2091905.51259 37.7241423183013 -122.431887278791 (37.7241423183013, -122.431887278791) 9 7 6 28861 5
564 67334 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 801 University St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/21/1992 12:00:00 AM 12   Permit Number 30818 6008868.73151 2090340.18885 37.7201770527016 -122.411376204361 (37.7201770527016, -122.411376204361) 9 3 7 309 28
565 170476 DPW Maintained 1 Quercus suber :: Cork Oak 78 46 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6003788.04729 2094625.21712 37.7316565146416 -122.429243816075 (37.7316565146416, -122.429243816075) 9 7 5 28861 25
568 78813 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 110 Foote Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5998921.12979 2088066.27223 37.713370441156 -122.445598173631 (37.713370441156, -122.445598173631) 9 7 6 28861 25
570 259611 DPW Maintained 1 :: 45 1420 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/01/2019 12:00:00 AM 3     6008434.50928 2087674.99824 37.7128346308013 -122.412688855365 (37.7128346308013, -122.412688855365) 9 7 8 309 39
577 205386 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1 Rosewood Dr 3 Sidewalk: Property side : Yard Tree Private 2     15 Width 3ft   5994512.47364 2095959.37509 37.7347903147287 -122.461407773158 (37.7347903147287, -122.461407773158) 9 8 4 59 40
584 170688 DPW Maintained 1 Podocarpus gracilor :: Fern Pine 51 499X San Juan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6000526.86487 2092744.73897 37.726307994602 -122.440383530269 (37.726307994602, -122.440383530269) 9 7 6 28861 25
586 178423 DPW Maintained 1 Pittosporum tobira :: Japanese Mockorange 118 226 Athens St 2 Sidewalk: Property side : Yard Tree Private 2     5     6004525.81285 2091935.4006 37.7243126139184 -122.426501755257 (37.7243126139184, -122.426501755257) 9 7 6 28861 5
591 264763 Section 806 (d) 5 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 274 Victoria St 1 Sidewalk: Property side : Cutout Tree Private 2   10/05/2020 12:00:00 AM 3 3x3 Permit Number 781692 5993256.27541 2089011.86791 37.7156417766237 -122.465246370223 (37.7156417766237, -122.465246370223) 9 8 6 64 24
592 211675 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 140 Jules Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/14/2020 12:00:00 AM 3 Width 4ft Permit Number 785250 5994473.3982 2090822.99818 37.7206848225258 -122.461170675896 (37.7206848225258, -122.461170675896) 9 8 6 28861 24
599 78256 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 754 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6002680.72455 2088998.08405 37.7161429170478 -122.432670234864 (37.7161429170478, -122.432670234864) 9 7 6 28861 5
613 161126 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 485 London St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 0ft   6001694.7774 2090903.55181 37.721318940793 -122.436214417168 (37.721318940793, -122.436214417168) 9 7 6 28861 5
619 177547 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1202 Sunnydale Ave 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 6ft   6008380.57452 2087049.08192 37.7111129665536 -122.412831047535 (37.7111129665536, -122.412831047535) 9 7 8 309 39
638 217502 DPW Maintained 1 Yucca gloriosa :: Spanish Dagger 126 426 Hearst Ave 2 Sidewalk: Curb side : Pot Tree Private 2     12 Width 10ft   5998544.81231 2094412.25403 37.7307735449502 -122.447355326608 (37.7307735449502, -122.447355326608) 9 7 4 59 40
639 261347 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 780859 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
660 261647 DPW Maintained 1 Tree(s) :: 17 605 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2020 12:00:00 AM 3 3x5   5995910 2089162 37.7162066827324 -122.456084795666 (37.7162066827324, -122.456084795666) 9 8 6 28861 24
662 181218 DPW Maintained 1 Washingtonia robusta :: Mexican Fan Palm 72 765 Delano Ave 10 Sidewalk: Property side : Yard Tree Private 2     26 Width 10ft   5998962.78764 2090178.02559 37.7191712122718 -122.445605954547 (37.7191712122718, -122.445605954547) 9 7 6 28861 25
665 203589 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 50 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1993 12:00:00 AM 24 Width 3ft Permit Number 32829 5999730.96004 2093799.89189 37.7291598500324 -122.443210675031 (37.7291598500324, -122.443210675031) 9 7 4 63 40
667 175396 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 12 Capistrano Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6001357.36761 2093739.15823 37.7290856955434 -122.437583712342 (37.7290856955434, -122.437583712342) 9 7 6 28861 25
672 218447 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 468 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   5997663.70622 2094120.17429 37.7299211747216 -122.450380387859 (37.7299211747216, -122.450380387859) 9 7 4 28861 40
719 80747 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1111 Munich St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6001772.74556 2087054.04067 37.7107534679609 -122.435669635744 (37.7107534679609, -122.435669635744) 9 7 6 28861 5
727 208976 DPW Maintained 1 Tree(s) :: 17 100 Yerba Buena Ave 3 Sidewalk: Curb side : Yard Tree Private 2   09/28/2020 12:00:00 AM 3 Width 6ft Permit Number 784904 5994151.01662 2096664.66272 37.7367060496466 -122.462708592139 (37.7367060496466, -122.462708592139) 9 8 4 59 40
730 160454 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 11 France Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 0ft   6001177.46897 2090398.6691 37.7199032415307 -122.437966457494 (37.7199032415307, -122.437966457494) 9 7 6 28861 5
733 218511 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 318 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2000 12:00:00 AM 7 Width 3ft Permit Number 43359 5996829.51445 2089654.64111 37.7176120972009 -122.45294206803 (37.7176120972009, -122.45294206803) 9 8 6 28861 24
741 262415 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 122 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6003235 2094463 37.731179778599 -122.431144235496 (37.731179778599, -122.431144235496) 9 7 5 28861 25
748 259270 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 8 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
762 161390 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 467 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2020 12:00:00 AM 3 Width 0ft   6002831.42521 2091188.97801 37.7221671723558 -122.432305723439 (37.7221671723558, -122.432305723439) 9 7 6 28861 5
764 163220 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 45 Farallones St 9 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2020 12:00:00 AM 3 Width 0ft   5996567.29942 2088361.68289 37.714046904924 -122.453755106407 (37.714046904924, -122.453755106407) 9 8 6 28861 24
774 208910 DPW Maintained 1 Malus floribunda :: Showy Crab Apple: Japanese Crabapple 139 24 Melrose Ave 1 Sidewalk: Property side : Yard Tree Private 2     13     5999949.61858 2095523.77288 37.7339056911991 -122.442578479527 (37.7339056911991, -122.442578479527) 9 7 4 63 40
780 210671 DPW Maintained 1 Olea europaea :: Olive Tree 9 2043 Monterey Blvd 4 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   5992088.794 2095394.24092 37.7330988041611 -122.469746063247 (37.7330988041611, -122.469746063247) 9 8 4 59 40
797 260459 Significant Tree 6 Tree(s) :: 17 1798X Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2019 12:00:00 AM 3 5x10 Permit Number 784470 5992678 2095461 37.733316146518 -122.467713892437 (37.733316146518, -122.467713892437) 9 8 4 59 40
804 175950 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 326 Avalon Ave 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 4ft   6003638.04232 2092697.69928 37.7263554895976 -122.42962499282 (37.7263554895976, -122.42962499282) 9 7 6 28861 5
807 204166 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 284 Los Palmos Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5997871.38298 2096295.336 37.7359055343221 -122.449819122777 (37.7359055343221, -122.449819122777) 9 7 4 59 40
811 160771 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 667 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 0ft   6003251.82484 2089320.66382 37.7170610223232 -122.430719246496 (37.7170610223232, -122.430719246496) 9 7 6 28861 5
812 210575 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 222 Ridgewood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2018 12:00:00 AM 3 Width 2ft Permit Number 778918 5996813.55952 2094844.51305 37.7318613433091 -122.453371704763 (37.7318613433091, -122.453371704763) 9 7 4 59 40
821 261708 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 20 Entrada Ct 1 Front Yard : Yard Tree Private 2   02/21/2020 12:00:00 AM 3 3x3 Permit Number 783258 5992481.8221 2092418.55282 37.724951011222 -122.468170882637 (37.724951011222, -122.468170882637) 9 8 4 59 40

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