trees
163,064 rows where qCaretaker_id = 2 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 | ||||
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 | |||
84 | 254457 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 1055X Duncan St | 2 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
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 | ||||
99 | 255073 | Private 9 | Tree(s) :: 17 | 173R Glenview Dr | Back Yard : Yard | Tree | Private 2 | ||||||||||||||||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||||
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 | |||
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 | |||||
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 | |||
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 | |||
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 | |||||
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 | |||||
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 | ||||||
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 | ||||
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 | |||||
175 | 184150 | DPW Maintained 1 | :: 45 | 1585 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982480.9001 | 2104357.3743 | 37.7571490682193 | -122.503626084685 | (37.7571490682193, -122.503626084685) | 1 | 8 | 3 | 56 | 35 | |||
176 | 194490 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 22nd St | 19 | Front Yard : Yard | Tree | Private 2 | 29 | 6013346.63868 | 2103825.44695 | 37.7574548949481 | -122.396842409144 | (37.7574548949481, -122.396842409144) | 10 | 3 | 8 | 28856 | 29 | ||||
177 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Lopez Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | ||||
178 | 233603 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 199 Franconia St | 9 | : Yard | Tree | Private 2 | 6 | Width 3ft | 6010152.72418 | 2099634.52308 | 37.7457692517475 | -122.407592814071 | (37.7457692517475, -122.407592814071) | 2 | 7 | 7 | 28859 | 2 | |||
180 | 110904 | Significant Tree 6 | Tree(s) :: 17 | 203 CORBETT AVE | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x3 | 6000094 | 2105620 | 37.7616357315689 | -122.442804047122 | (37.7616357315689, -122.442804047122) | 15 | 5 | 5 | 28862 | 3 | |||
183 | 253381 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 899 Waller St | 3 | Side Yard : Yard | Tree | Private 2 | 6001282 | 2108613 | 37.7699214264211 | -122.438909742148 | (37.7699214264211, -122.438909742148) | 15 | 5 | 5 | 29492 | 9 | |||||
185 | 184541 | DPW Maintained 1 | :: 45 | 1706 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984416.199 | 2103539.5001 | 37.7550170068332 | -122.496872815694 | (37.7550170068332, -122.496872815694) | 1 | 8 | 3 | 56 | 35 | |||
188 | 112351 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992711 | 2097652 | 37.7393339885882 | -122.467759098278 | (37.7393339885882, -122.467759098278) | 1 | 8 | 4 | 59 | 40 | ||||
189 | 178694 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 184 Mount Vernon Ave | 7 | Side Yard : Yard | Tree | Private 2 | 9 | 5998957.82756 | 2089383.479 | 37.7169892861082 | -122.445565994978 | (37.7169892861082, -122.445565994978) | 9 | 7 | 6 | 28861 | 25 | ||||
191 | 244985 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000147.9035 | 2108881.2284 | 37.7705933244615 | -122.442851810939 | (37.7705933244615, -122.442851810939) | 15 | 5 | 11 | 29492 | 9 | |||
192 | 137920 | DPW Maintained 1 | :: 45 | 2028 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002940.7431 | 2115305.2702 | 37.7883909617368 | -122.433650548643 | (37.7883909617368, -122.433650548643) | 13 | 9 | 1 | 29490 | 27 | |||
193 | 100595 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
194 | 112359 | Undocumented 4 | Tree(s) :: 17 | 1129 DOUGLASS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001379 | 2100423 | 37.7474391957634 | -122.437987492815 | (37.7474391957634, -122.437987492815) | 2 | 4 | 5 | 63 | 22 | ||||
195 | 101535 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46305 | 6014036.2 | 2116698.9 | 37.7928408582284 | -122.395359428861 | (37.7928408582284, -122.395359428861) | 12 | 2 | 9 | 28855 | 6 | ||||
197 | 104920 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 750 Gonzalez Dr | 1 | Median : Yard | Tree | Private 2 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | |||||
198 | 102463 | Undocumented 4 | Tree(s) :: 17 | 3119 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6007346.2 | 2103903.1 | 37.7573322957921 | -122.417599878082 | (37.7573322957921, -122.417599878082) | 2 | 4 | 7 | 28859 | 19 | |||
199 | 237529 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1197 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003874.24561 | 2101347.66783 | 37.7501197023675 | -122.429425031242 | (37.7501197023675, -122.429425031242) | 2 | 4 | 5 | 28862 | 22 | |||
201 | 229505 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 950 Church St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004360.58946 | 2103177.16015 | 37.7551705836636 | -122.427873571204 | (37.7551705836636, -122.427873571204) | 2 | 4 | 5 | 28862 | 22 | |||
202 | 190636 | DPW Maintained 1 | Hakea suaveolens :: Sweet Hakea Tree 73 | 1 01st St | 30 | : Yard | Tree | Private 2 | 8 | 6014391.99798 | 2105898.86804 | 37.7632061898228 | -122.393372206868 | (37.7632061898228, -122.393372206868) | 14 | 3 | 8 | 28856 | 29 | ||||
203 | 56596 | Permitted Site 7 | Tree(s) :: 17 | 536 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003173.97949504 | 2096124.55404861 | 37.7357385703685 | -122.431473765394 | (37.7357385703685, -122.431473765394) | 2 | 7 | 5 | 63 | 7 | |||||
207 | 251656 | DPW Maintained 1 | Tree(s) :: 17 | 31x Malta Dr | 1 | unknown : Yard | Tree | Private 2 | 3x3 | 5999423 | 2096089 | 37.7354276387403 | -122.44443976141 | (37.7354276387403, -122.44443976141) | 9 | 7 | 4 | 63 | 40 | ||||
208 | 107457 | Undocumented 4 | Prunus spp :: Cherry 68 | 2682 16TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991487.4 | 2097177.7 | 37.7379609526954 | -122.471955163509 | (37.7379609526954, -122.471955163509) | 1 | 8 | 4 | 29491 | 40 | |||||
209 | 138219 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998675.4325 | 2112652.6916 | 37.7808647356786 | -122.448216697429 | (37.7808647356786, -122.448216697429) | 15 | 6 | 2 | 54 | 16 | |||
211 | 196303 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 249 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011469.59111 | 2111688.37468 | 37.7789400547713 | -122.403887319468 | (37.7789400547713, -122.403887319468) | 14 | 2 | 9 | 28856 | 34 | |||
212 | 138278 | DPW Maintained 1 | :: 45 | 2181 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6001737.3169 | 2113910.2795 | 37.7844923181381 | -122.437714255164 | (37.7844923181381, -122.437714255164) | 13 | 6 | 11 | 29490 | 13 | |||
213 | 3891 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 23 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002162.16871 | 2108402.44463 | 37.7693933312702 | -122.435850193556 | (37.7693933312702, -122.435850193556) | 15 | 5 | 5 | 29492 | 9 | |||
214 | 138888 | DPW Maintained 1 | :: 45 | 675 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004166.2354 | 2110619.5066 | 37.7755944800015 | -122.429076315191 | (37.7755944800015, -122.429076315191) | 7 | 9 | 11 | 28852 | 10 | |||
217 | 105438 | Undocumented 4 | :: 45 | 1116 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002483 | 2102334 | 37.7527490702591 | -122.434306541099 | (37.7527490702591, -122.434306541099) | 2 | 4 | 5 | 28862 | 22 |
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) );