trees
194,517 rows sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7 | 188479 | Prune Opt Out 3 | Ceratonia siliqua :: Carob 5 | 2208 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | Permit Number 787847 | 6010817.79084 | 2106032.71885 | 37.7633744862602 | -122.405743691032 | (37.7633744862602, -122.405743691032) | 8 | 4 | 8 | 28859 | 19 | ||
24 | 264941 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Portola Dr | 12 | Median : Cutout | Tree | Private 2 | 3x3 | 5999749 | 2101261 | 37.7496473113918 | -122.443684097942 | (37.7496473113918, -122.443684097942) | 2 | 5 | 5 | 28862 | 38 | ||||
34 | 262408 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 66X Edgehill Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5994840 | 2098758 | 37.7424934921887 | -122.46047813267 | (37.7424934921887, -122.46047813267) | 1 | 8 | 4 | 59 | 40 | ||||
40 | 6039 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1822 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001574.3819 | 2112547.6661 | 37.7807416628926 | -122.438180307395 | (37.7807416628926, -122.438180307395) | 15 | 5 | 11 | 29490 | 41 | |||
42 | 221891 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 180 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006685.21207 | 2102724.39469 | 37.7540586268078 | -122.419802203518 | (37.7540586268078, -122.419802203518) | 2 | 4 | 7 | 28859 | 19 | |||
43 | 264724 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 2901 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999656 | 2116990 | 37.7928298614365 | -122.445136362104 | (37.7928298614365, -122.445136362104) | 13 | 6 | 1 | 29490 | 27 | ||||
46 | 6035 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1826 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001552.687 | 2112546.4084 | 37.7807369756783 | -122.438255270265 | (37.7807369756783, -122.438255270265) | 15 | 5 | 11 | 29490 | 41 | |||
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 | ||||
50 | 264964 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3641 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 5996989 | 2114619 | 37.7861671437011 | -122.454192924446 | (37.7861671437011, -122.454192924446) | 11 | 6 | 1 | 54 | 31 | ||||
52 | 264970 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1026 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014048 | 2089990 | 37.7195046364539 | -122.393448574201 | (37.7195046364539, -122.393448574201) | 10 | 3 | 8 | 58 | 1 | ||||
53 | 264969 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1099X Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15x15 | 6014337 | 2089983 | 37.719501468928 | -122.392449109694 | (37.719501468928, -122.392449109694) | 10 | 3 | 8 | 58 | 1 | |||
62 | 264980 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 222 Winfield St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6006740 | 2098205 | 37.7416524795013 | -122.419292156581 | (37.7416524795013, -122.419292156581) | 2 | 7 | 7 | 28859 | 2 | ||||
63 | 264975 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 445 Ortega St | 1 | Front Yard : Yard | Tree | Private 2 | 10x30 | 5992686 | 2102646 | 37.7530447932571 | -122.468208733714 | (37.7530447932571, -122.468208733714) | 1 | 8 | 4 | 56 | 12 | ||||
64 | 264974 | Significant Tree 6 | Persea americana :: Avocado 34 | 1868 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003954 | 2119422 | 37.7997518904289 | -122.430438688757 | (37.7997518904289, -122.430438688757) | 13 | 9 | 1 | 57 | 17 | ||||
65 | 264979 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2450 California St | 1 | Front Yard : Yard | Tree | MTA 3 | 6002592 | 2115500 | 37.7889058459562 | -122.434871073784 | (37.7889058459562, -122.434871073784) | 13 | 9 | 1 | 29490 | 27 | |||||
66 | 132469 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3135 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001403 | 2119193 | 37.7989782820217 | -122.43924964791 | (37.7989782820217, -122.43924964791) | 13 | 9 | 1 | 57 | 17 | |||
68 | 264976 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 445 Ortega St | 2 | Front Yard : Yard | Tree | Private 2 | 10x30 | 5992686 | 2102646 | 37.7530447932571 | -122.468208733714 | (37.7530447932571, -122.468208733714) | 1 | 8 | 4 | 56 | 12 | ||||
69 | 126274 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1240 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 6ft | 6006421.51674 | 2120105.21307 | 37.8017672864012 | -122.421948716173 | (37.8017672864012, -122.421948716173) | 5 | 9 | 1 | 28858 | 32 | |||
72 | 135801 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 16 Phoenix Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6008610.92916 | 2117913.61927 | 37.7958729471262 | -122.414217164494 | (37.7958729471262, -122.414217164494) | 5 | 1 | 10 | 308 | 21 | |||
73 | 127010 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1931 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003752.87677 | 2118634.51429 | 37.7975782631807 | -122.431078412364 | (37.7975782631807, -122.431078412364) | 13 | 9 | 1 | 57 | 17 | |||
74 | 106076 | Permitted Site 7 | Tree(s) :: 17 | 2500 Arelious Walker Dr | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 772788 | 6016510.6 | 2089868.7 | 37.7193080887588 | -122.384927739753 | (37.7193080887588, -122.384927739753) | 10 | 3 | 8 | 58 | 1 | ||||
77 | 225344 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 207 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004214.46195 | 2097518.65353 | 37.7396253677099 | -122.42797572342 | (37.7396253677099, -122.42797572342) | 2 | 7 | 5 | 63 | 7 | |||
78 | 237365 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2463 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008244.71386 | 2104091.00553 | 37.7578987598438 | -122.414505749733 | (37.7578987598438, -122.414505749733) | 2 | 4 | 7 | 28859 | 19 | |||
79 | 121399 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349X Cargo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
80 | 260998 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard | Tree | SFUSD 4 | 10x10 | ||||||||||||||
84 | 254457 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 1055X Duncan St | 2 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
85 | 259368 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1646 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
86 | 239818 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 219 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007803 | 2098062 | 37.7413196437149 | -122.415606526646 | (37.7413196437149, -122.415606526646) | 2 | 7 | 7 | 28859 | 2 | |||
95 | 261359 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007238 | 2095678 | 37.7347419306018 | -122.417391193891 | (37.7347419306018, -122.417391193891) | 2 | 7 | 7 | 28859 | 2 | ||||
97 | 261358 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2x Bache St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2095707 | 37.7348180134015 | -122.417611061749 | (37.7348180134015, -122.417611061749) | 2 | 7 | 7 | 28859 | 2 | ||||
98 | 261380 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 298x Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008523 | 2113477 | 37.7836861327236 | -122.414207368753 | (37.7836861327236, -122.414207368753) | 7 | 10 | 9 | 28852 | 36 | ||||
99 | 255073 | Private 9 | Tree(s) :: 17 | 173R Glenview Dr | Back Yard : Yard | Tree | Private 2 | ||||||||||||||||
100 | 255131 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
101 | 255229 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
102 | 258152 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 500X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | |||||||||||||
103 | 253831 | DPW Maintained 1 | :: 45 | 699X Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | |||||||||||||
105 | 70839 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 939 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010931.16123 | 2112337.60471 | 37.780692593337 | -122.405795716794 | (37.780692593337, -122.405795716794) | 14 | 2 | 9 | 28853 | 34 | |||
106 | 251438 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2501X Santiago St | 1 | Median : Yard | Tree | DPW 1 | |||||||||||||||
109 | 34921 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
111 | 97355 | Permitted Site 7 | Tree(s) :: 17 | 5 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
113 | 182915 | DPW Maintained 1 | :: 45 | 2711 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981812.2124 | 2096648.8938 | 37.7359443944789 | -122.505367292654 | (37.7359443944789, -122.505367292654) | 1 | 8 | 3 | 29491 | 35 | |||
115 | 121173 | Significant Tree 6 | Tree(s) :: 17 | 950 Duncan St | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000333 | 2099683 | 37.7453477932295 | -122.441551386161 | (37.7453477932295, -122.441551386161) | 2 | 7 | 5 | 63 | 22 | ||||
116 | 113159 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 555 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005146 | 2111243 | 37.777361853017 | -122.425731455878 | (37.777361853017, -122.425731455878) | 7 | 9 | 11 | 28852 | 10 | ||||
117 | 108152 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2232 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
118 | 236256 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 151 Valencia St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6006073.15075 | 2108915.83898 | 37.7710243776945 | -122.422358744984 | (37.7710243776945, -122.422358744984) | 8 | 2 | 9 | 28853 | 19 | |||
119 | 184195 | DPW Maintained 1 | :: 45 | 1459 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984624.9154 | 2105245.6219 | 37.759713770345 | -122.49627690204 | (37.759713770345, -122.49627690204) | 1 | 8 | 3 | 56 | 35 | |||
120 | 141225 | DPW Maintained 1 | :: 45 | 3 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5996479.075 | 2114520.1031 | 37.7858663452689 | -122.455949967769 | (37.7858663452689, -122.455949967769) | 11 | 6 | 1 | 54 | 31 | |||
122 | 17067 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1355 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000506.9486 | 2109572.2346 | 37.7725111167076 | -122.441659471159 | (37.7725111167076, -122.441659471159) | 15 | 5 | 11 | 29492 | 9 | |||
123 | 221263 | DPW Maintained 1 | Betula spp :: Birch 55 | 1 Church St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6004132.36771 | 2108477.00924 | 37.7697097883113 | -122.429040680782 | (37.7697097883113, -122.429040680782) | 7 | 9 | 5 | 29492 | 10 | |||
124 | 114040 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 LINARES AVE | 1 | Front Yard : Yard | Tree | DPW 1 | 40 | 3x3 | 5994258 | 2102054 | 37.7515099774588 | -122.462729551044 | (37.7515099774588, -122.462729551044) | 1 | 8 | 4 | 29491 | 40 | |||
125 | 92934 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 339 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5992211 | 2096907 | 37.737259523291 | -122.46943364564 | (37.737259523291, -122.46943364564) | 1 | 8 | 4 | 59 | 40 | ||||
126 | 173890 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2593 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989209 | 2097724 | 37.7393288482101 | -122.479872589648 | (37.7393288482101, -122.479872589648) | 1 | 8 | 3 | 29491 | 35 | ||||
127 | 119777 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
128 | 110722 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
129 | 107934 | DPW Maintained 1 | Tree(s) :: 17 | 3098X Market St | 3 | Median : Yard | Tree | DPW 1 | 5999920 | 2105144 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | 2 | 4 | 5 | 28862 | 3 | |||||
130 | 13128 | DPW Maintained 1 | Tristania conferta :: 61 | 1714 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6004131.2449 | 2119777.2826 | 37.8007374433085 | -122.429850711739 | (37.8007374433085, -122.429850711739) | 13 | 9 | 1 | 57 | 17 | |||
131 | 109387 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 300X BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000704 | 2110147 | 37.7741005029649 | -122.441019094263 | (37.7741005029649, -122.441019094263) | 15 | 5 | 11 | 29492 | 16 | ||||
132 | 182257 | DPW Maintained 1 | :: 45 | 1439 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985240.365 | 2105399.9729 | 37.7601736080068 | -122.494159774452 | (37.7601736080068, -122.494159774452) | 1 | 8 | 3 | 56 | 35 | |||
133 | 211075 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 650x Miramar Ave | 6 | Median : Yard | Tree | DPW 1 | 34 | 5995390.83549 | 2093912.64173 | 37.7292209976493 | -122.458222905073 | (37.7292209976493, -122.458222905073) | 9 | 7 | 4 | 28861 | 40 | ||||
134 | 257900 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5701x 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014158 | 2092336 | 37.7259523956068 | -122.393232416121 | (37.7259523956068, -122.393232416121) | 10 | 3 | 8 | 58 | 1 | ||||
135 | 99586 | Permitted Site 7 | Tree(s) :: 17 | 2299 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002978.6 | 2106459.9 | 37.7641059209125 | -122.432887400675 | (37.7641059209125, -122.432887400675) | 15 | 4 | 5 | 28862 | 3 | |||||
136 | 11131 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2400X Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007074.9072505 | 2120528.613771 | 37.802966665104 | -122.419717737051 | (37.802966665104, -122.419717737051) | 5 | 1 | 1 | 28858 | 32 | |||
137 | 189330 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 23 | Median : Yard | Tree | DPW 1 | 15 | 6016163.75351 | 2096735.77367 | 37.7381445215441 | -122.386605256348 | (37.7381445215441, -122.386605256348) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
139 | 106382 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 9 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
140 | 97920 | Undocumented 4 | Tree(s) :: 17 | 399X Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6000685 | 2110085 | 37.7739291843989 | -122.441080369401 | (37.7739291843989, -122.441080369401) | 15 | 5 | 11 | 29492 | 16 | |||
141 | 254165 | DPW Maintained 1 | :: 45 | 579 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983759 | 2111886 | 37.7778955894485 | -122.499762435435 | (37.7778955894485, -122.499762435435) | 11 | 6 | 2 | 55 | 26 | ||||
142 | 186181 | DPW Maintained 1 | :: 45 | 1700 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984741.0761 | 2103142.2522 | 37.75394530503 | -122.495720014116 | (37.75394530503, -122.495720014116) | 1 | 8 | 3 | 56 | 35 | |||
143 | 251305 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1 Cashmere St | 4 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6017463 | 2095772 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||||
145 | 193492 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1918 23rd St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 6012632.36685 | 2102863.5529 | 37.7547739610597 | -122.399245141377 | (37.7547739610597, -122.399245141377) | 10 | 3 | 8 | 28856 | 29 | ||||
146 | 190658 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6016241.73559 | 2097685.48667 | 37.7407565574799 | -122.386401828788 | (37.7407565574799, -122.386401828788) | 10 | 3 | 8 | 58 | 1 | |||
147 | 198543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 1 | : | Tree | Private 2 | 3 | Width 0ft | 6014375.16951 | 2096346.21278 | 37.7369756879815 | -122.392762090617 | (37.7369756879815, -122.392762090617) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||||
149 | 244279 | Undocumented 4 | :: 45 | 585 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004230.7823 | 2110095.842 | 37.7741602789386 | -122.428815691218 | (37.7741602789386, -122.428815691218) | 7 | 9 | 11 | 28852 | 10 | |||
150 | 247856 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 80 Bradford St | 5 | Side Yard : Yard | Tree | Private 2 | 32 | 6009566.84713 | 2098148.32022 | 37.7416556510973 | -122.409513828008 | (37.7416556510973, -122.409513828008) | 10 | 7 | 7 | 28859 | 2 | ||||
151 | 233915 | DPW Maintained 1 | Persea americana :: Avocado 34 | 998 York St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 7ft | 6009943.01185 | 2103432.65253 | 37.7561863328563 | -122.408585854469 | (37.7561863328563, -122.408585854469) | 2 | 4 | 7 | 28859 | 19 | |||
152 | 235666 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Jessie St | 4 | : | Tree | Private 2 | 3 | Width 2ft | 6006462.25734 | 2109005.38337 | 37.7712921868165 | -122.421019169707 | (37.7712921868165, -122.421019169707) | 8 | 2 | 9 | 28853 | 19 | |||
153 | 185313 | DPW Maintained 1 | Shrub :: Shrub 66 | 2601 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984983.1747 | 2097234.3473 | 37.7377379790483 | -122.494447317023 | (37.7377379790483, -122.494447317023) | 1 | 8 | 3 | 29491 | 35 | |||
154 | 119838 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
155 | 142339 | DPW Maintained 1 | :: 45 | 516 Central Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5999737.6235 | 2110265.9409 | 37.7743719952599 | -122.444370497086 | (37.7743719952599, -122.444370497086) | 15 | 5 | 11 | 29492 | 16 | |||
156 | 222165 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 953 Elizabeth St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6000303.11526 | 2101951.8939 | 37.7515759277946 | -122.441817532557 | (37.7515759277946, -122.441817532557) | 2 | 4 | 5 | 28862 | 22 | |||
157 | 114186 | Undocumented 4 | Shrub :: Shrub 66 | 2200 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997096 | 2109871 | 37.7731365175856 | -122.453479795748 | (37.7731365175856, -122.453479795748) | 15 | 5 | 2 | 29492 | 16 | ||||
158 | 100607 | Permitted Site 7 | Tree(s) :: 17 | 270x 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011410.5 | 2112131.8 | 37.7801542961347 | -122.404122955966 | (37.7801542961347, -122.404122955966) | 14 | 2 | 9 | 28853 | 34 | |||||
159 | 117627 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 890x VERMONT ST | 4 | Unaccepted Street : Yard | Tree | Private 2 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
160 | 107490 | DPW Maintained 1 | Prunus spp :: Cherry 68 | 1306x Montgomery St | 19 | Median : Cutout | Tree | DPW 1 | 12 | 6011447.18476 | 2119974.76336 | 37.8016912541172 | -122.404548295963 | (37.8016912541172, -122.404548295963) | 3 | 1 | 10 | 308 | 23 | ||||
161 | 194506 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 299x Cashmere St | 26 | Median : Yard | Tree | DPW 1 | 18 | 6016624.93937 | 2096021.78221 | 37.7362095654157 | -122.384960961105 | (37.7362095654157, -122.384960961105) | 10 | 3 | 8 | 58 | 1 | ||||
162 | 105806 | Undocumented 4 | Tree(s) :: 17 | 1248X ANZA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x3 | 5994834 | 2112130 | 37.7792092085373 | -122.461468091676 | (37.7792092085373, -122.461468091676) | 11 | 6 | 2 | 54 | 11 | |||||
163 | 17253 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 15 Osceola Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017345.102761 | 2094248.0837329 | 37.7313791485056 | -122.382347671583 | (37.7313791485056, -122.382347671583) | 10 | 3 | 8 | 58 | 1 | |||
164 | 116129 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
165 | 104843 | Permitted Site 7 | :: 45 | 1320 21st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5989622 | 2106334.7 | 37.7629955389606 | -122.479074319647 | (37.7629955389606, -122.479074319647) | 1 | 8 | 3 | 56 | 35 | ||||||
166 | 8632 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 2600 Geary Blvd | 20 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 5999387.1761445 | 2113256.6615953 | 37.7825637442266 | -122.445797886011 | (37.7825637442266, -122.445797886011) | 15 | 5 | 1 | 29490 | 31 | |||
167 | 99668 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
168 | 222969 | DPW Maintained 1 | Corymbia maculata :: Spotted Gum 69 | 1300 San Jose Ave | 47 | Front Yard : Yard | Tree | Private 2 | 16 | 6003392.92926 | 2095549.99469 | 37.7341733681018 | -122.430675784084 | (37.7341733681018, -122.430675784084) | 2 | 7 | 5 | 63 | 7 | ||||
169 | 258020 | DPW Maintained 1 | Tree(s) :: 17 | 1001X San Jose Ave | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
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 | ||||
172 | 176155 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Brotherhood Way | 9 | Median : Cutout | Tree | DPW 1 | 25 | 10x10 | 5988860 | 2088745 | 37.7146545182747 | -122.480422197946 | (37.7146545182747, -122.480422197946) | 1 | 8 | 4 | 64 | 14 | |||
173 | 27068 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 801 Silver Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4 | 6006971.0744 | 2093616.11167 | 37.7290654140285 | -122.418167915919 | (37.7290654140285, -122.418167915919) | 9 | 3 | 7 | 309 | 28 | |||
174 | 113728 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 5 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 |
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) );