trees
163,064 rows where qCaretaker_id = 2 sorted by Fire Prevention Districts descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts ▲ | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 |
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 | ||
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 | ||
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 | ||||
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 | ||||
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 | ||
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 | ||||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
832 | 211486 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 300 Junipero Serra Blvd | 17 | : | Tree | Private 2 | 56 | Width 0ft | 5991389.83684 | 2094502.84602 | 37.7306108333036 | -122.47209757005 | (37.7306108333036, -122.47209757005) | 9 | 8 | 4 | 64 | 40 | |||
851 | 175458 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1530 Felton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006357.8594 | 2092519.52911 | 37.72601990217 | -122.420210056863 | (37.72601990217, -122.420210056863) | 9 | 7 | 7 | 309 | 5 | |||
856 | 260411 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 10X Brotherhood Way | 2 | Side Yard : Yard | Tree | Private 2 | Width 0ft | 5992928.58802 | 2087852.90738 | 37.7124406464989 | -122.466294818667 | (37.7124406464989, -122.466294818667) | 9 | 8 | 4 | 64 | 24 | ||||
873 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | |||
886 | 73449 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 238 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6004263.46084 | 2092033.98232 | 37.7245684629353 | -122.427415688595 | (37.7245684629353, -122.427415688595) | 9 | 7 | 6 | 28861 | 5 | |||
902 | 213099 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 48 Brentwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996420.67751 | 2095562.94637 | 37.733811460225 | -122.454781859719 | (37.733811460225, -122.454781859719) | 9 | 7 | 4 | 59 | 40 | |||
903 | 212156 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 8 Keystone Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 5994073.78533 | 2092644.48269 | 37.7256631735017 | -122.462684068539 | (37.7256631735017, -122.462684068539) | 9 | 8 | 4 | 59 | 40 | |||
930 | 73626 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 249 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994249.97744 | 2086699.51142 | 37.7093498474797 | -122.461644153659 | (37.7093498474797, -122.461644153659) | 9 | 8 | 6 | 28861 | 25 | |||
936 | 215389 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 83 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5999561.07911 | 2095471.21433 | 37.7337392221924 | -122.443917999028 | (37.7337392221924, -122.443917999028) | 9 | 7 | 4 | 63 | 40 | ||||
937 | 95737 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 445 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767484 | 6003120.3 | 2091142.7 | 37.7220564786865 | -122.431303852024 | (37.7220564786865, -122.431303852024) | 9 | 7 | 6 | 28861 | 5 | |
943 | 103518 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 5234 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770228 | 5999957.27012 | 2088737.63684 | 37.7152729578673 | -122.442065082634 | (37.7152729578673, -122.442065082634) | 9 | 7 | 6 | 28861 | 25 | |
944 | 211787 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 145 Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994159.28368 | 2097331.60357 | 37.7385377797886 | -122.462728377219 | (37.7385377797886, -122.462728377219) | 9 | 8 | 4 | 59 | 40 | |||
950 | 72251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 437 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6001865.6588 | 2091176.05062 | 37.7220768687262 | -122.435643214558 | (37.7220768687262, -122.435643214558) | 9 | 7 | 6 | 28861 | 5 | |||
955 | 207211 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 351 Judson Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5997557.05916 | 2093521.06587 | 37.7282700608095 | -122.450705899268 | (37.7282700608095, -122.450705899268) | 9 | 7 | 4 | 28861 | 40 | |||
967 | 78568 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1192 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009666.22083 | 2090670.9365 | 37.7211299140849 | -122.408642858878 | (37.7211299140849, -122.408642858878) | 9 | 3 | 7 | 309 | 28 | |||
968 | 71603 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 171 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5994523.67906 | 2086453.64687 | 37.7086905122192 | -122.460680397897 | (37.7086905122192, -122.460680397897) | 9 | 8 | 6 | 28861 | 25 | |||
976 | 258329 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 105 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5998052 | 2087327 | 37.7112909098977 | -122.448548966881 | (37.7112909098977, -122.448548966881) | 9 | 7 | 6 | 28861 | 25 | ||||
979 | 171867 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 825 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | Width 3ft | 6009309.97305 | 2091452.93347 | 37.7232571551673 | -122.409929483882 | (37.7232571551673, -122.409929483882) | 9 | 3 | 7 | 309 | 28 | ||
997 | 42493 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092861.95301 | 37.7264342507672 | -122.452230525303 | (37.7264342507672, -122.452230525303) | 9 | 7 | 4 | 28861 | 40 | ||
1002 | 260458 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 835 Darien Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2019 12:00:00 AM | 3 | 6x10 | Permit Number 784514 | 5994066 | 2094094 | 37.7296427463027 | -122.462816092129 | (37.7296427463027, -122.462816092129) | 9 | 8 | 4 | 59 | 40 | |
1006 | 258081 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1205 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2019 03:01:00 PM | 3 | Width 2ft | 5995843.60881 | 2092100.29717 | 37.7242707405805 | -122.456526632611 | (37.7242707405805, -122.456526632611) | 9 | 7 | 4 | 28861 | 40 |
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) );