trees
194,517 rows sorted by TreeID 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
52174 | 99998 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501X Mission St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013420 | 2115433 | 37.7893307029327 | -122.397402707509 | (37.7893307029327, -122.397402707509) | 12 | 2 | 9 | 28855 | 6 | |||
178138 | 99997 | Permitted Site 7 | Corymbia maculata :: Spotted Gum 69 | 600@Clay Montgomery St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
60177 | 99996 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
169008 | 99995 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Permit Number 44594 | 6011799.65117 | 2117580.00293 | 37.795135512042 | -122.403160044009 | (37.795135512042, -122.403160044009) | 3 | 1 | 10 | 28860 | 4 | |||
175597 | 99994 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
84637 | 99993 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
179677 | 99992 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
5844 | 99991 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
148277 | 99990 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Permit Number 44594 | 6011811.05033 | 2117521.86685 | 37.7949765208901 | -122.403116509626 | (37.7949765208901, -122.403116509626) | 3 | 1 | 10 | 28860 | 4 | |||
127074 | 9999 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 126 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x12 | 6005395.58344 | 2108269.7872 | 37.7692122302826 | -122.424656508299 | (37.7692122302826, -122.424656508299) | 8 | 4 | 5 | 28853 | 19 | |||
189935 | 99989 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Permit Number 44594 | 6011816.52839 | 2117490.26365 | 37.7948900519939 | -122.403095330591 | (37.7948900519939, -122.403095330591) | 3 | 1 | 10 | 28860 | 4 | |||
167930 | 99988 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
20003 | 99987 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 535@Clay Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
163853 | 99986 | Undocumented 4 | Corymbia maculata :: Spotted Gum 69 | 535 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
108297 | 99985 | Undocumented 4 | Corymbia maculata :: Spotted Gum 69 | 535 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
152273 | 99984 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 535 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
173075 | 99983 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 535@Clay Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
177588 | 99982 | Undocumented 4 | Corymbia maculata :: Spotted Gum 69 | 535@Clay Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012018 | 2117734 | 37.7955705425922 | -122.402415352518 | (37.7955705425922, -122.402415352518) | 3 | 1 | 10 | 28860 | 4 | |||||
20802 | 99981 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 535@Clay Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6012012.90465 | 2117729.4246 | 37.7955576951954 | -122.402432661541 | (37.7955576951954, -122.402432661541) | 3 | 1 | 10 | 28860 | 4 | ||||
24671 | 99980 | Undocumented 4 | Corymbia maculata :: Spotted Gum 69 | 441 Castenada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993079.9 | 2099895.8 | 37.7455161901456 | -122.466646671257 | (37.7455161901456, -122.466646671257) | 1 | 8 | 4 | 29491 | 40 | |||||
53821 | 9998 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 122 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 6005390.2576582 | 2108319.0051408 | 37.7693470701553 | -122.424678431625 | (37.7693470701553, -122.424678431625) | 8 | 4 | 5 | 28853 | 19 | |||
169611 | 99979 | Undocumented 4 | Corymbia maculata :: Spotted Gum 69 | 441 Castenada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993079.9 | 2099895.8 | 37.7455161901456 | -122.466646671257 | (37.7455161901456, -122.466646671257) | 1 | 8 | 4 | 29491 | 40 | |||||
151198 | 99978 | Undocumented 4 | Corymbia maculata :: Spotted Gum 69 | 441 Castenada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993079.9 | 2099895.8 | 37.7455161901456 | -122.466646671257 | (37.7455161901456, -122.466646671257) | 1 | 8 | 4 | 29491 | 40 | |||||
96928 | 99977 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 2295 Folsom St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||||
115415 | 99976 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 2295 Folsom St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | |||||
183646 | 99975 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2295 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||||
111853 | 99974 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||||
3230 | 99973 | Permitted Site 7 | Corymbia maculata :: Spotted Gum 69 | 2295 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||||
80873 | 99972 | Undocumented 4 | Tree(s) :: 17 | 143 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3x3 | Permit Number 776811 | 5988622.1 | 2114374.2 | 37.7850116539768 | -122.483121892919 | (37.7850116539768, -122.483121892919) | 11 | 6 | 2 | 55 | 26 | ||
128468 | 99971 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
9226 | 99970 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
39226 | 9997 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 120 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1997 12:00:00 AM | 18 | 2X2 | 6005389.5589835 | 2108331.2308198 | 37.7693805994769 | -122.424681718135 | (37.7693805994769, -122.424681718135) | 8 | 4 | 5 | 28853 | 19 | ||
33189 | 99969 | Undocumented 4 | Tree(s) :: 17 | 2270 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2013 12:00:00 AM | Permit Number 767924 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||
48096 | 99968 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
8269 | 99967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2270 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
20880 | 99966 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2270 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
152512 | 99965 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2270 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007986.9 | 2105322.2 | 37.7612648499102 | -122.415484545241 | (37.7612648499102, -122.415484545241) | 2 | 4 | 7 | 28859 | 19 | |||||
107862 | 99964 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2439 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769385 | 6003671 | 2116729 | 37.7923415699538 | -122.431225642925 | (37.7923415699538, -122.431225642925) | 13 | 9 | 1 | 29490 | 27 | ||||
81970 | 99963 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2439 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Permit Number 769118 | 6003656.75521 | 2116793.16502 | 37.7925169434648 | -122.43127951245 | (37.7925169434648, -122.43127951245) | 13 | 9 | 1 | 29490 | 27 | |||
165987 | 99962 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1202X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 8 | 9x5 | 6006588.9 | 2114703 | 37.7869435992692 | -122.420985708971 | (37.7869435992692, -122.420985708971) | 13 | 9 | 10 | 28858 | 21 | |||
68497 | 99961 | Property Tree 8 | Callistemon citrinus :: Lemon Bottlebrush 67 | 537 Valley St | 1 | Front Yard : Yard | Tree | Private 2 | 07/25/2012 12:00:00 AM | Permit Number 768880 | 6002459 | 2099152 | 37.7440106863694 | -122.434162082356 | (37.7440106863694, -122.434162082356) | 2 | 7 | 5 | 63 | 22 | |||
147160 | 99960 | Undocumented 4 | Ulmus americana :: American Elm 74 | 279 Filbert St | 1 | Unaccepted Street : Yard | Tree | Private 2 | shared responsibility with 1400 Montgomery | 6011546.2 | 2120046.5 | 37.8018937585678 | -122.40421070766 | (37.8018937585678, -122.40421070766) | 3 | 1 | 10 | 308 | 23 | ||||
121293 | 9996 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 115 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/2014 06:44:00 AM | 3 | 3X2 | 6005461.13944 | 2108328.79796 | 37.769377961859 | -122.424433951272 | (37.769377961859, -122.424433951272) | 8 | 4 | 5 | 28853 | 19 | ||
179834 | 99959 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 19 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2014 12:00:00 AM | 28 | 3x3 | Permit Number 772856 | 6009640 | 2110980 | 37.776892640268 | -122.410166607108 | (37.776892640268, -122.410166607108) | 8 | 2 | 9 | 28853 | 34 | |
189821 | 99958 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4204 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003489 | 2093971 | 37.7298432476922 | -122.430231025456 | (37.7298432476922, -122.430231025456) | 9 | 7 | 6 | 28861 | 25 | |||
165282 | 99957 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 308 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2012 12:00:00 AM | 3 | 7x7 | Permit Number 768921 | 5998118.54102 | 2115379.99567 | 37.7883213434981 | -122.450339905768 | (37.7883213434981, -122.450339905768) | 13 | 6 | 1 | 54 | 31 | |
99885 | 99952 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 420 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778491 | 5993609 | 2105311 | 37.760415458577 | -122.465210403501 | (37.760415458577, -122.465210403501) | 1 | 8 | 11 | 56 | 12 | |
47218 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1160 Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.401550680127 | (37.8018575696458, -122.401550680127) | 3 | 1 | 10 | 28860 | 6 | |||
167818 | 99950 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1545 05th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 08/14/2012 12:00:00 AM | Permit Number 768941 | 5994712.1 | 2105033.7 | 37.7597176147703 | -122.461375215787 | (37.7597176147703, -122.461375215787) | 1 | 5 | 4 | 56 | 12 | |||
30291 | 9995 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 109 GUERRERO ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/06/2015 12:59:00 PM | 3 | 2X2 | 6005457 | 2108414 | 37.7696116724665 | -122.424454330606 | (37.7696116724665, -122.424454330606) | 8 | 4 | 5 | 28853 | 19 | ||
131318 | 99947 | Permitted Site 7 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 522 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2012 12:00:00 AM | 4x4 | Permit Number 54785 | 6007824 | 2104880.2 | 37.7600420622217 | -122.416016646831 | (37.7600420622217, -122.416016646831) | 2 | 4 | 7 | 28859 | 19 | |
36492 | 99946 | DPW Maintained 1 | Tree(s) :: 17 | 499X FOLSOM ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769035 | 6014477 | 2114572 | 37.787025389439 | -122.393685294607 | (37.787025389439, -122.393685294607) | 6 | 2 | 9 | 28855 | 6 | |
74500 | 99945 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 499X FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769035 | 6014477 | 2114572 | 37.787025389439 | -122.393685294607 | (37.787025389439, -122.393685294607) | 6 | 2 | 9 | 28855 | 6 | |
138820 | 99944 | Undocumented 4 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 221 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6006240 | 2101855 | 37.7516463781161 | -122.421280123778 | (37.7516463781161, -122.421280123778) | 2 | 4 | 5 | 28859 | 19 | |||
85255 | 99943 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2790 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2012 12:00:00 AM | 6 | 4x4 | Permit Number 768876 | 6000263.51246 | 2117158.55941 | 37.7933273378328 | -122.443046457948 | (37.7933273378328, -122.443046457948) | 13 | 9 | 1 | 57 | 27 | |
41751 | 99942 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2790 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2012 12:00:00 AM | 5 | 4x4 | Permit Number 768876 | 6000286.44523 | 2117159.95802 | 37.79333248556 | -122.442967209691 | (37.79333248556, -122.442967209691) | 13 | 9 | 1 | 57 | 27 | |
130683 | 99941 | Permitted Site 7 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 298 | 182 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x3 | Permit Number 769134 | 6003955.9 | 2092670 | 37.7262974264753 | -122.42852420031 | (37.7262974264753, -122.42852420031) | 9 | 7 | 6 | 28861 | 5 | ||
77831 | 9994 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 102 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005389.27087 | 2108406.08421 | 37.7695861126487 | -122.424688040346 | (37.7695861126487, -122.424688040346) | 8 | 4 | 5 | 28853 | 19 | |||
44771 | 99937 | Undocumented 4 | Tree(s) :: 17 | 315 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2012 12:00:00 AM | 3c3 | Permit Number 768708 | 6006226 | 2098169 | 37.7415246698481 | -122.421066843418 | (37.7415246698481, -122.421066843418) | 2 | 7 | 7 | 28859 | 2 | ||
97025 | 99934 | Undocumented 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 63 Manchester St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 768712 | 6008250 | 2099654 | 37.7457160396744 | -122.41417355851 | (37.7457160396744, -122.41417355851) | 2 | 7 | 7 | 28859 | 2 | |||
132137 | 99933 | Undocumented 4 | Tree(s) :: 17 | 63 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2012 12:00:00 AM | 3x3 | Permit Number 768712 | 6008250 | 2099654 | 37.7457160396744 | -122.41417355851 | (37.7457160396744, -122.41417355851) | 2 | 7 | 7 | 28859 | 2 | ||
152098 | 99932 | Permitted Site 7 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 277 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2012 12:00:00 AM | 3x3 | Permit Number 768952 | 6006756.8 | 2104530.9 | 37.7590229060886 | -122.419682802567 | (37.7590229060886, -122.419682802567) | 2 | 4 | 7 | 28859 | 19 | ||
142116 | 99931 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 801X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2012 12:00:00 AM | 3x3 | Permit Number 768924 | 6003100.6 | 2103580.4 | 37.7562064244422 | -122.432259777723 | (37.7562064244422, -122.432259777723) | 2 | 4 | 5 | 28862 | 22 | ||
118680 | 9993 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 65 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2001 12:00:00 AM | 6 | 2X2 | 6005451.908597 | 2108608.747745 | 37.770146115502 | -122.424485796032 | (37.770146115502, -122.424485796032) | 8 | 2 | 5 | 28853 | 19 | ||
179365 | 99928 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3331 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54787 | 6007298 | 2105556 | 37.7618680647923 | -122.417883738243 | (37.7618680647923, -122.417883738243) | 2 | 4 | 7 | 28859 | 19 |
137800 | 99927 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 665 Bowdoin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6008996.47999 | 2092997.06161 | 37.7274794299239 | -122.411122192648 | (37.7274794299239, -122.411122192648) | 9 | 3 | 7 | 309 | 28 | ||||
50016 | 99924 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 125 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2012 12:00:00 AM | Permit Number 769009 | 5992063.9 | 2092889.6 | 37.7262202448731 | -122.469649855245 | (37.7262202448731, -122.469649855245) | 9 | 8 | 4 | 59 | 40 | |||
67 | 99921 | Section 806 (d) 5 | Olea europaea :: Olive Tree 9 | 1740 Jones St | 1 | Front Yard : Yard | Tree | Private 2 | 06/01/2015 12:00:00 AM | 3 | Permit Number 774389 | 6008331.64636 | 2118443.68708 | 37.7973126906849 | -122.415221079511 | (37.7973126906849, -122.415221079511) | 5 | 1 | 10 | 308 | 21 | ||
102213 | 99920 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1740 Jones St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
127988 | 9992 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 67 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/02/2014 12:00:00 AM | 3 | 2x2 | 6005450.48952 | 2108526.98568 | 37.7699215363694 | -122.424484887989 | (37.7699215363694, -122.424484887989) | 8 | 2 | 5 | 28853 | 19 | ||
140038 | 99919 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 1740 Jones St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
103648 | 99918 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 1740 Jones St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
114624 | 99917 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 1740 Jones St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
118511 | 99916 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 1740 Jones St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
83394 | 99914 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 85 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2012 12:00:00 AM | 4 | 3x3 | Permit Number 768764 | 6005244.6 | 2107384.2 | 37.7667720917659 | -122.425115731153 | (37.7667720917659, -122.425115731153) | 8 | 4 | 5 | 28853 | 19 | |
31355 | 99913 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 3751X Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 768933 | 6005509.05056 | 2101091.11643 | 37.7495076933522 | -122.42375353502 | (37.7495076933522, -122.42375353502) | 2 | 4 | 5 | 28859 | 19 | |||
18105 | 99912 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 3751X Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005509.05056 | 2101091.11643 | 37.7495076933522 | -122.42375353502 | (37.7495076933522, -122.42375353502) | 2 | 4 | 5 | 28859 | 19 | ||||
132451 | 99911 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 400 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005460.7 | 2101331.3 | 37.7501644526018 | -122.423937810125 | (37.7501644526018, -122.423937810125) | 2 | 4 | 5 | 28859 | 19 | ||||
127896 | 99910 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 710 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 769055 | 5986442 | 2114842 | 37.7861689922045 | -122.490698673964 | (37.7861689922045, -122.490698673964) | 11 | 6 | 1 | 55 | 33 | |||
38594 | 9991 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 43 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6005443.37728 | 2108628.68203 | 37.7702003684767 | -122.424516723968 | (37.7702003684767, -122.424516723968) | 8 | 2 | 5 | 28853 | 19 | |||
183598 | 99909 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 210 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774553 | 6009399.78383 | 2095020.31894 | 37.7330574731105 | -122.409870724875 | (37.7330574731105, -122.409870724875) | 10 | 3 | 7 | 309 | 28 | |
22295 | 99908 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
184283 | 99907 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
189714 | 99906 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
156825 | 99905 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
101150 | 99904 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
14158 | 99903 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
53086 | 99902 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
23492 | 99901 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
119395 | 99900 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
27680 | 9990 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 33 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005438.43144 | 2108674.6093 | 37.7703261944175 | -122.424537099004 | (37.7703261944175, -122.424537099004) | 8 | 2 | 5 | 28853 | 19 | |||
148575 | 999 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1725 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6001467.99656 | 2092045.35722 | 37.7244411930178 | -122.437080040045 | (37.7244411930178, -122.437080040045) | 9 | 7 | 6 | 28861 | 25 | |||
189388 | 99899 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||
163505 | 99898 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101X Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 768908 | 6004438.52556 | 2116689.23299 | 37.7922758451055 | -122.428567149951 | (37.7922758451055, -122.428567149951) | 13 | 9 | 1 | 28858 | 27 | |||
80066 | 99897 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2101X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Permit Number 768908 | 6004409.82631 | 2116680.57597 | 37.7922504509529 | -122.428665832574 | (37.7922504509529, -122.428665832574) | 13 | 9 | 1 | 28858 | 27 | |||
72946 | 99896 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 768908 | 6004371.30251 | 2116674.47154 | 37.7922315094359 | -122.428798690309 | (37.7922315094359, -122.428798690309) | 13 | 9 | 1 | 28858 | 27 | |||
25519 | 99895 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101X Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | Permit Number 768908 | 6004333.92311 | 2116670.59896 | 37.7922187606381 | -122.428927747522 | (37.7922187606381, -122.428927747522) | 13 | 9 | 1 | 28858 | 27 | ||
164727 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 99 | 1636 Bush St | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665 | 2115204 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | 13 | 9 | 1 | 28858 | 41 | |||
189259 | 99893 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 715 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997893.2 | 2108079.1 | 37.7682620848422 | -122.450592979377 | (37.7682620848422, -122.450592979377) | 15 | 5 | 11 | 29492 | 9 | |||||
97482 | 99892 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 5646@ Whipple Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.7109047702551 | -122.447663697002 | (37.7109047702551, -122.447663697002) | 9 | 7 | 6 | 28861 | 25 |
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) );