trees
39,840 rows where qLegalStatus_id = 7 sorted by Police 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10044 | 98961 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 10084 | 91045 | Permitted Site 7 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1100X Chestnut St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2006 12:00:00 AM | 3x3 | Permit Number 48418 | 6006545 | 2120445 | 37.8027072182013 | -122.42154555229 | (37.8027072182013, -122.42154555229) | 5 | 9 | 1 | 28858 | 32 | |||
| 10201 | 82046 | Permitted Site 7 | Carpinus betulus 'Fastigiata' :: Upright European Hornbeam 234 | 2400 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50643 | 6006311.22230334 | 2119027.09541009 | 37.7988008280599 | -122.422253744675 | (37.7988008280599, -122.422253744675) | 13 | 9 | 1 | 28858 | 32 | ||
| 10223 | 7769 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 490X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3X3 | 6006335.7213615 | 2111871.61132 | 37.7791550246023 | -122.421660473625 | (37.7791550246023, -122.421660473625) | 7 | 9 | 11 | 28852 | 10 | |||
| 10233 | 48519 | Permitted Site 7 | Tree(s) :: 17 | 1(REVISED) Church St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.429132262601 | (37.7703294028669, -122.429132262601) | 7 | 9 | 5 | 29492 | 10 | |||
| 10380 | 5959 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1499X Eddy St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1992 12:00:00 AM | 6 | 3X3 | 6003487.34677 | 2112767.17991 | 37.7814530042955 | -122.431578116755 | (37.7814530042955, -122.431578116755) | 15 | 9 | 11 | 29490 | 41 | ||
| 10415 | 43967 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 627 Turk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | Permit Number 43534 | 6006999.24602912 | 2112908.87547401 | 37.7820404937398 | -122.419438672428 | (37.7820404937398, -122.419438672428) | 7 | 9 | 9 | 28852 | 36 | |||
| 10493 | 59647 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 100 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1987 12:00:00 AM | 6x9 | Permit Number 24228 | 6003848.70238053 | 2108788.55742661 | 37.7705491626589 | -122.43004409806 | (37.7705491626589, -122.43004409806) | 7 | 9 | 11 | 29492 | 10 | |
| 10522 | 31312 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 709 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1995 12:00:00 AM | Permit Number 34949 | 6004473.77987727 | 2110903.29372292 | 37.7763910940647 | -122.428032671161 | (37.7763910940647, -122.428032671161) | 7 | 9 | 11 | 28852 | 10 | |||
| 10599 | 63494 | Permitted Site 7 | Tree(s) :: 17 | 2513 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/1987 12:00:00 AM | Permit Number 24091 | 6001599.24421586 | 2117284.80982338 | 37.7937500563512 | -122.438433791844 | (37.7937500563512, -122.438433791844) | 13 | 9 | 1 | 29490 | 27 | |||
| 10606 | 46465 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2098 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2002 12:00:00 AM | Permit Number 44668 | 6002328.64862435 | 2119517.88465055 | 37.7999229605029 | -122.436069860968 | (37.7999229605029, -122.436069860968) | 13 | 9 | 1 | 57 | 17 | |||
| 10699 | 50602 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1700 Buchanan St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2003 12:00:00 AM | Permit Number 47204 | 6004061.24207522 | 2114267.02341516 | 37.7856037113433 | -122.429699722138 | (37.7856037113433, -122.429699722138) | 13 | 9 | 11 | 29490 | 13 | |||
| 10777 | 35244 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38736 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | |||
| 10874 | 57412 | Permitted Site 7 | Tree(s) :: 17 | 2250 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/1976 12:00:00 AM | Permit Number 16579 | 6002738.79121903 | 2114797.05697252 | 37.7869840767613 | -122.434312920752 | (37.7869840767613, -122.434312920752) | 13 | 9 | 11 | 29490 | 27 | |||
| 10962 | 39426 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 395Bldg #9 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40929 | 6004623.83107143 | 2109808.7893301 | 37.7733943405421 | -122.42743561187 | (37.7733943405421, -122.42743561187) | 7 | 9 | 11 | 28852 | 10 | |||
| 10989 | 254569 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400x Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 6004613 | 2113717 | 37.7841247118733 | -122.427751595484 | (37.7841247118733, -122.427751595484) | 13 | 9 | 11 | 28858 | 41 | |||
| 11012 | 7356 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2309 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2007 12:00:00 AM | 4 | 3X3 | 6002769.01195 | 2116184.22684 | 37.7907946063198 | -122.434307574482 | (37.7907946063198, -122.434307574482) | 13 | 9 | 1 | 29490 | 27 | ||
| 11093 | 95037 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 8 | Sidewalk: Property side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
| 11292 | 23832 | Permitted Site 7 | Fraxinus x Moraine :: Moraine Ash 344 | 1302X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6003750.8656173 | 2113176.0104319 | 37.7825904834742 | -122.43069565207 | (37.7825904834742, -122.43069565207) | 7 | 9 | 11 | 29490 | 41 | |||
| 11297 | 12432 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1755 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004422.6934 | 2114848.24389 | 37.7872200575435 | -122.428490648397 | (37.7872200575435, -122.428490648397) | 13 | 9 | 11 | 29490 | 27 | |||
| 11380 | 92094 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1300 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2007 12:00:00 AM | 3x3 | Permit Number 52201 | 6004216 | 2112914 | 37.7818974087405 | -122.429067800125 | (37.7818974087405, -122.429067800125) | 7 | 9 | 11 | 29490 | 41 | ||
| 11772 | 225309 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 104 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1987 12:00:00 AM | 16 | Width 3ft | Permit Number 24228 | 6003856.7224 | 2108736.74248 | 37.7704073456534 | -122.430012659982 | (37.7704073456534, -122.430012659982) | 7 | 9 | 11 | 29492 | 10 | |
| 11831 | 66789 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1405 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1991 12:00:00 AM | 8 | 3x3 | Permit Number 30063 | 6006130.65101914 | 2119658.78326709 | 37.8005250955758 | -122.42292350049 | (37.8005250955758, -122.42292350049) | 13 | 9 | 1 | 28858 | 32 |
| 11946 | 33634 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 416 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37730 | 6005394.17412308 | 2110828.6660173 | 37.7762382136369 | -122.424843455434 | (37.7762382136369, -122.424843455434) | 7 | 9 | 11 | 28852 | 10 | |||
| 12038 | 50316 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1055 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.7834285368624 | -122.42353751819 | (37.7834285368624, -122.42353751819) | 7 | 9 | 11 | 28858 | 41 | |||
| 12071 | 81939 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1567 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50642 | 6006641.29456006 | 2117646.14573466 | 37.7950276999422 | -122.421013482861 | (37.7950276999422, -122.421013482861) | 13 | 9 | 10 | 28858 | 32 | ||
| 12227 | 33648 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 530 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37739 | 6004854.0578934 | 2110753.28886702 | 37.7760007246145 | -122.426706497307 | (37.7760007246145, -122.426706497307) | 7 | 9 | 11 | 28852 | 10 | |||
| 12237 | 88560 | Permitted Site 7 | Prunus spp :: Cherry 68 | 2901 Pierce St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51505 | 6001501 | 2118350 | 37.7966692015857 | -122.438850093229 | (37.7966692015857, -122.438850093229) | 13 | 9 | 1 | 57 | 17 | |||
| 12325 | 42608 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1775 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42675 | 6004555.83509625 | 2118398.4069888 | 37.796975439849 | -122.428283124742 | (37.796975439849, -122.428283124742) | 13 | 9 | 1 | 57 | 17 | ||
| 12408 | 33687 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 610 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 2x3 | Permit Number 37763 | 6004420.66783798 | 2111040.26799248 | 37.7767641867681 | -122.428226164884 | (37.7767641867681, -122.428226164884) | 7 | 9 | 11 | 28852 | 10 | ||
| 12471 | 76775 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
| 12582 | 32159 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
| 12638 | 23783 | Permitted Site 7 | Tree(s) :: 17 | 1010 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2014 12:00:00 AM | 30 | 3X3 | Permit Number 771274 | 6003903.8361546 | 2112182.8886989 | 37.7798722837048 | -122.430095570639 | (37.7798722837048, -122.430095570639) | 7 | 9 | 11 | 29490 | 41 | |
| 12889 | 48521 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1(REVISED) Church St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45844 | 6004110.55275805 | 2108703.1215343 | 37.7703294028669 | -122.429132262601 | (37.7703294028669, -122.429132262601) | 7 | 9 | 5 | 29492 | 10 | |||
| 13059 | 58732 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2385 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2005 12:00:00 AM | Permit Number 17967 | 6002968.76813263 | 2115478.70521399 | 37.7888687602145 | -122.433565986183 | (37.7888687602145, -122.433565986183) | 13 | 9 | 1 | 29490 | 27 | ||
| 13062 | 6292 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1700X Ellis St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 24 | 3X4 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816 | 37.7822123689276 | -122.434225051326 | (37.7822123689276, -122.434225051326) | 15 | 9 | 11 | 29490 | 41 | |
| 13384 | 39889 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41175 | 6005174.09555111 | 2114787.61295618 | 37.7870960726836 | -122.425886638993 | (37.7870960726836, -122.425886638993) | 13 | 9 | 11 | 28858 | 27 | |||
| 13474 | 23362 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1305 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3X3 | 6006311.12485 | 2115010.35559 | 37.7877718599489 | -122.421968591158 | (37.7877718599489, -122.421968591158) | 13 | 9 | 1 | 28858 | 41 | |||
| 13503 | 8051 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 601X Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/1990 12:00:00 AM | 12 | 3x3 | 6004844.36674 | 2111570.09006 | 37.7782429126773 | -122.426798203905 | (37.7782429126773, -122.426798203905) | 7 | 9 | 11 | 28852 | 10 | ||
| 13703 | 40148 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
| 13917 | 106712 | Permitted Site 7 | Tree(s) :: 17 | 3713 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2014 12:00:00 AM | 3x3 | Permit Number 772877 | 6000611 | 2121098.3 | 37.804164627793 | -122.442127063949 | (37.804164627793, -122.442127063949) | 13 | 9 | 1 | 57 | 17 | ||
| 14068 | 13261 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2443 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 6 | 3X3 | 6000701.59201 | 2119217.25602 | 37.7990049442386 | -122.441678488129 | (37.7990049442386, -122.441678488129) | 13 | 9 | 1 | 57 | 17 | ||
| 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 | ||||
| 14200 | 33719 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 27 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 13 | Permit Number 37787 | 6004127.51235208 | 2108864.68166901 | 37.7707739677449 | -122.429085120408 | (37.7707739677449, -122.429085120408) | 7 | 9 | 11 | 29492 | 10 | ||
| 14337 | 47497 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 2550 Lyon St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.3915837 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | 13 | 9 | 1 | 57 | 27 | ||
| 14444 | 7238 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1085 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4X4 | 6003353.84267 | 2112023.38614 | 37.7794031644909 | -122.431986847688 | (37.7794031644909, -122.431986847688) | 15 | 9 | 11 | 29490 | 41 | |||
| 14446 | 108991 | Permitted Site 7 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 2073-2099X Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2015 12:00:00 AM | 3 | Permit Number 772965 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | 13 | 9 | 1 | 57 | 17 | ||
| 14476 | 105974 | Permitted Site 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1336 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 771235 | 6006462.9 | 2119771 | 37.8008519560253 | -122.421781757787 | (37.8008519560253, -122.421781757787) | 13 | 9 | 1 | 28858 | 32 | ||||
| 14534 | 49518 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1483 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2006 12:00:00 AM | Permit Number 46423 | 6005507.92497714 | 2114781.52271548 | 37.7870982103643 | -122.42473122826 | (37.7870982103643, -122.42473122826) | 13 | 9 | 1 | 28858 | 41 | |||
| 14622 | 58380 | Permitted Site 7 | Tree(s) :: 17 | 1942 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1979 12:00:00 AM | Permit Number 17512 | 6004837.57646053 | 2117446.27673196 | 37.7943770702204 | -122.427240374859 | (37.7943770702204, -122.427240374859) | 13 | 9 | 1 | 28858 | 27 | |||
| 14779 | 31332 | Permitted Site 7 | Photinia fraseri :: Photinia Tree 225 | 500 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | Permit Number 34950 | 6004711 | 2111132 | 37.7770324835269 | -122.427228354699 | (37.7770324835269, -122.427228354699) | 7 | 9 | 11 | 28852 | 10 | ||
| 14790 | 16747 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1760 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1997 12:00:00 AM | 12 | 4X4 | 6002883.2905878 | 2113428.1185512 | 37.783233519123 | -122.433715109442 | (37.783233519123, -122.433715109442) | 13 | 9 | 11 | 29490 | 41 | ||
| 14852 | 9557 | Permitted Site 7 | Pittosporum spp :: Pittosporum spp 170 | 1195X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 01/19/2016 07:54:00 AM | 3 | 3x3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.430062547125 | (37.7797350134544, -122.430062547125) | 7 | 9 | 11 | 29490 | 41 | ||
| 15060 | 67218 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 67 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | Permit Number 30674 | 6004275.36148655 | 2108843.45765699 | 37.7707240599176 | -122.428572194222 | (37.7707240599176, -122.428572194222) | 7 | 9 | 11 | 29492 | 10 | ||
| 15062 | 102786 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3345 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4.5x6 | Permit Number 772480 | 6003174.4 | 2119873.2 | 37.8009465759098 | -122.433168646536 | (37.8009465759098, -122.433168646536) | 13 | 9 | 1 | 57 | 17 | ||
| 15127 | 103601 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
| 15184 | 32343 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2885 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36904 | 5999249.30586492 | 2118007.60671846 | 37.7956007178544 | -122.446616785481 | (37.7956007178544, -122.446616785481) | 13 | 9 | 1 | 57 | 17 | |||
| 15196 | 35624 | Permitted Site 7 | Tree(s) :: 17 | 701 Hayes St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38975 | 6004496.45349332 | 2110824.80795168 | 37.7761768741411 | -122.427948642674 | (37.7761768741411, -122.427948642674) | 7 | 9 | 11 | 28852 | 10 | |||
| 15414 | 96980 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
| 15513 | 9780 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
| 15615 | 94975 | Permitted Site 7 | Tree(s) :: 17 | 2040@Jackson Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2010 12:00:00 AM | 9 | 3x3 | Permit Number 54005 | 6005619 | 2117006 | 37.7932123416077 | -122.42450522172 | (37.7932123416077, -122.42450522172) | 13 | 9 | 1 | 28858 | 27 | |
| 15647 | 47041 | Permitted Site 7 | Acer spp :: Maple 88 | 50 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | 1 | 3x3 | Permit Number 45032 | 6004340.5553933 | 2108752.14114491 | 37.7704770161634 | -122.428340177957 | (37.7704770161634, -122.428340177957) | 7 | 9 | 11 | 28852 | 10 | |
| 15720 | 46217 | Permitted Site 7 | Tree(s) :: 17 | 1888 Lombard St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2002 12:00:00 AM | Permit Number 44530 | 6003335.27744655 | 2119677.01043482 | 37.8004170150887 | -122.432597920925 | (37.8004170150887, -122.432597920925) | 13 | 9 | 1 | 57 | 17 | |||
| 15794 | 63736 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 585 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1987 12:00:00 AM | Permit Number 24405 | 6003780.00958588 | 2109683.67127267 | 37.7730030357559 | -122.430345580362 | (37.7730030357559, -122.430345580362) | 7 | 9 | 11 | 29492 | 10 | ||
| 16247 | 57235 | Permitted Site 7 | Tree(s) :: 17 | 2032 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/1975 12:00:00 AM | Permit Number 14522 | 6003376.0386691 | 2115678.16974905 | 37.7894395384443 | -122.432171137582 | (37.7894395384443, -122.432171137582) | 13 | 9 | 1 | 29490 | 27 | |||
| 16310 | 38334 | Permitted Site 7 | Tree(s) :: 17 | 1 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1998 12:00:00 AM | Permit Number 40402 | 6006951.79358069 | 2110471.67174177 | 37.7753458477676 | -122.419429879592 | (37.7753458477676, -122.419429879592) | 7 | 9 | 11 | 28852 | 10 | |||
| 16312 | 42604 | Permitted Site 7 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2000 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42672 | 6005206.4163913 | 2116498.11175578 | 37.7917945003838 | -122.425896619276 | (37.7917945003838, -122.425896619276) | 13 | 9 | 1 | 28858 | 27 | ||
| 16325 | 38333 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 684 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40387 | 6006701.38591008 | 2112874.96361955 | 37.7819305989802 | -122.420466726707 | (37.7819305989802, -122.420466726707) | 7 | 9 | 9 | 28852 | 36 | |||
| 16377 | 94114 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200X Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006339.5 | 2111012.4 | 37.7767960515681 | -122.421586361388 | (37.7767960515681, -122.421586361388) | 7 | 9 | 11 | 28852 | 10 | |
| 16401 | 46226 | Permitted Site 7 | Tree(s) :: 17 | 1888 Lombard St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2002 12:00:00 AM | Permit Number 44530 | 6003335.27744655 | 2119677.01043482 | 37.8004170150887 | -122.432597920925 | (37.8004170150887, -122.432597920925) | 13 | 9 | 1 | 57 | 17 | |||
| 16455 | 61898 | Permitted Site 7 | Tree(s) :: 17 | 1109 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/1985 12:00:00 AM | 3x3 | Permit Number 21941 | 6006414.68057735 | 2114214.88071456 | 37.7855935218483 | -122.42155378935 | (37.7855935218483, -122.42155378935) | 13 | 9 | 11 | 28858 | 41 | ||
| 16475 | 110244 | Permitted Site 7 | Tree(s) :: 17 | 2582 Filbert St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2015 12:00:00 AM | 3 | Permit Number 775248 | 6000594.1 | 2118607.8 | 37.7973254142876 | -122.442006676457 | (37.7973254142876, -122.442006676457) | 13 | 9 | 1 | 57 | 17 | ||
| 16680 | 256664 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1381 Filbert St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 5x5 | Permit Number 782595 | 6006338.70929 | 2119347.35531 | 37.7996817310416 | -122.422181395696 | (37.7996817310416, -122.422181395696) | 13 | 9 | 1 | 28858 | 32 | |
| 16743 | 50472 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3010X Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.7985795459747 | -122.446920252577 | (37.7985795459747, -122.446920252577) | 13 | 9 | 1 | 57 | 17 | |
| 17087 | 95226 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2424@Vallejo Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2011 12:00:00 AM | 13 | 3x21 | Permit Number 767114 | 6005007 | 2117874 | 37.7955610696182 | -122.426684622292 | (37.7955610696182, -122.426684622292) | 13 | 9 | 1 | 28858 | 27 | |
| 17156 | 60894 | Permitted Site 7 | Tree(s) :: 17 | 1859 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1983 12:00:00 AM | Permit Number 20679 | 6004057.39639007 | 2119023.78706692 | 37.7986643569133 | -122.430052476684 | (37.7986643569133, -122.430052476684) | 13 | 9 | 1 | 57 | 17 | |||
| 17260 | 57706 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 268 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52597 | 6003986.30319774 | 2108724.10323801 | 37.7703799791966 | -122.429563538214 | (37.7703799791966, -122.429563538214) | 7 | 9 | 11 | 29492 | 10 | ||
| 17399 | 168461 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2016 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 6004605.43639 | 2115769.81971 | 37.7897608127558 | -122.427924090639 | (37.7897608127558, -122.427924090639) | 13 | 9 | 1 | 28858 | 27 | |||
| 17446 | 9465 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | ||
| 17468 | 6907 | Permitted Site 7 | Persea americana :: Avocado 34 | 333 Fell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6005876.17496 | 2110669.29389 | 37.7758278290987 | -122.423164749384 | (37.7758278290987, -122.423164749384) | 7 | 9 | 11 | 28852 | 10 | |||
| 17538 | 62279 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 402 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1985 12:00:00 AM | Permit Number 22417 | 6004194.0150087 | 2109446.81508952 | 37.7723761286117 | -122.42889659515 | (37.7723761286117, -122.42889659515) | 7 | 9 | 11 | 29492 | 10 | ||
| 17568 | 60045 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 235 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1986 12:00:00 AM | Permit Number 22998 | 6003601.05151902 | 2109138.05302848 | 37.7714947633279 | -122.430925670981 | (37.7714947633279, -122.430925670981) | 15 | 9 | 11 | 29492 | 10 | ||
| 17579 | 88953 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2008 12:00:00 AM | 3x3 | Permit Number 51722 | 6006386.3 | 2115344.1 | 37.7886924789506 | -122.421732213452 | (37.7886924789506, -122.421732213452) | 13 | 9 | 10 | 28858 | 21 | ||
| 17740 | 96032 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1314 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767671 | 6007241 | 2115796 | 37.7899814452739 | -122.418807131377 | (37.7899814452739, -122.418807131377) | 13 | 9 | 10 | 28858 | 21 | |
| 17860 | 134277 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1999 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2002 12:00:00 AM | 8 | Width 4ft | Permit Number 45113 | 6006028.3836 | 2117033.66191 | 37.7933114045495 | -122.423090693289 | (37.7933114045495, -122.423090693289) | 13 | 9 | 1 | 28858 | 27 | |
| 18154 | 26960 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1755 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6005137.68077 | 2115060.19605 | 37.7878424598464 | -122.426032037994 | (37.7878424598464, -122.426032037994) | 13 | 9 | 11 | 28858 | 27 | |||
| 18199 | 254500 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1715 Octavia St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769839 | 6004851.87126 | 2115244.61878 | 37.7883326812086 | -122.427034026756 | (37.7883326812086, -122.427034026756) | 13 | 9 | 11 | 28858 | 27 | |
| 18228 | 23252 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 780X Turk St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/1997 12:00:00 AM | 3 | 4X4 | 6006324.39299 | 2112868.49551 | 37.7818915869358 | -122.421770490906 | (37.7818915869358, -122.421770490906) | 7 | 9 | 11 | 28852 | 41 | ||
| 18249 | 31947 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2002 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | Permit Number 35358 | 6003915.74450462 | 2115298.16977388 | 37.7884267396179 | -122.43027669406 | (37.7884267396179, -122.43027669406) | 13 | 9 | 11 | 29490 | 27 | |||
| 18297 | 51025 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 51 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | Permit Number 47502 | 6005670.67188859 | 2109250.29159524 | 37.7719199923513 | -122.423774718207 | (37.7719199923513, -122.423774718207) | 7 | 9 | 5 | 28852 | 10 | |||
| 18397 | 41870 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 25 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42249 | 6003816.33085796 | 2108205.89422295 | 37.76894747793 | -122.430114498812 | (37.76894747793, -122.430114498812) | 7 | 9 | 5 | 28862 | 3 | ||
| 18434 | 105315 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2101 Laguna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | 13 | 9 | 1 | 28858 | 27 | |||||
| 18865 | 9713 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 505X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | 3 | 4X4 | 6005848.49792 | 2111505.90882 | 37.7781234086211 | -122.423319977441 | (37.7781234086211, -122.423319977441) | 7 | 9 | 11 | 28852 | 10 | ||
| 19018 | 28638 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 740 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.7773782078508 | -122.429572574215 | (37.7773782078508, -122.429572574215) | 7 | 9 | 11 | 28852 | 10 | |||
| 19107 | 22642 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1232 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1992 12:00:00 AM | 3 | 3X3 | 6004132.92548 | 2112556.27198 | 37.7809104736627 | -122.429329682354 | (37.7809104736627, -122.429329682354) | 7 | 9 | 11 | 29490 | 41 | ||
| 19144 | 30721 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 273 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1995 12:00:00 AM | Permit Number 34621 | 6005264.06153495 | 2109890.21668057 | 37.7736541098939 | -122.42522675761 | (37.7736541098939, -122.42522675761) | 7 | 9 | 11 | 28852 | 10 | |||
| 19179 | 61614 | Permitted Site 7 | Tree(s) :: 17 | 1554 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/1984 12:00:00 AM | Permit Number 21591 | 6006117.49406792 | 2118322.72943572 | 37.7968558879091 | -122.422874021655 | (37.7968558879091, -122.422874021655) | 13 | 9 | 10 | 28858 | 32 | |||
| 19273 | 27325 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 324 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2013 04:12:00 PM | 30 | 4x4 | 6004570.65008 | 2109631.91786 | 37.7729056865905 | -122.427606968753 | (37.7729056865905, -122.427606968753) | 7 | 9 | 11 | 28852 | 10 | ||
| 19308 | 64963 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1701 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | Permit Number 25998 | 6004752.02742796 | 2119466.94279483 | 37.7999204646826 | -122.427680422256 | (37.7999204646826, -122.427680422256) | 13 | 9 | 1 | 57 | 17 | ||
| 19638 | 3001 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2345 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6003166.87631 | 2115478.50558 | 37.7888794503509 | -122.432880545517 | (37.7888794503509, -122.432880545517) | 13 | 9 | 1 | 29490 | 27 |
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) );