Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102237 | 102237 | 104721 | Undocumented 2 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5x5 | 6002949.0 | 2107631.0 | 37.7673197977372 | -122.43307345634199 | (37.7673197977372, -122.433073456342) | ||||
157253 | 157253 | 131214 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | * Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004570.89315 | 2118403.70426 | 37.7969908368189 | -122.428231397978 | (37.7969908368189, -122.428231397978) | |||
135877 | 135877 | 199650 | Undocumented 2 | :: 54 | 0 | 1 | : 4 | Tree 1 | Private 1 | 0 | Width 0ft | 6014963.58685 | 2093280.8179400002 | 37.728591398452394 | -122.390513521988 | (37.7285913984524, -122.390513521988) | |||
178220 | 178220 | 199651 | Undocumented 2 | :: 54 | 0 | 37 | : 4 | Tree 1 | Private 1 | 0 | Width 0ft | 6018297.01834 | 2097895.80454 | 37.7414476037323 | -122.37930996579901 | (37.7414476037323, -122.379309965799) | |||
53867 | 53867 | 204800 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 0 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5991281.57381 | 2102416.71556 | 37.752334025717296 | -122.473048745206 | (37.7523340257173, -122.473048745206) | |||
29152 | 29152 | 247788 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 4 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004361.25599 | 2098418.6984200003 | 37.742104989252894 | -122.427532277614 | (37.7421049892529, -122.427532277614) | |||
38229 | 38229 | 247791 | Undocumented 2 | Corymbia maculata :: Spotted Gum 165 | 0 30th St | 7 | : 4 | Tree 1 | Private 1 | 24 | Width 3ft | 6004198.23071 | 2098409.9185599997 | 37.74207165946871 | -122.428095342253 | (37.7420716594687, -122.428095342253) | |||
137783 | 137783 | 247787 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 0 30th St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6004405.04711 | 2098420.28659 | 37.74211182679821 | -122.42738097477199 | (37.7421118267982, -122.427380974772) | |||
154157 | 154157 | 247786 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 0 30th St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004434.4666 | 2098422.1705099996 | 37.7421186634473 | -122.42727938556101 | (37.7421186634473, -122.427279385561) | |||
157576 | 157576 | 247792 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6004127.24522 | 2098408.26883 | 37.742063113214996 | -122.42834067009 | (37.742063113215, -122.42834067009) | |||
163763 | 163763 | 247789 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 5 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004321.812940001 | 2098415.77613 | 37.742094734277 | -122.427668451138 | (37.742094734277, -122.427668451138) | |||
179978 | 179978 | 247790 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 30th St | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6004284.58274 | 2098414.05293 | 37.742087896749794 | -122.42779705870501 | (37.7420878967498, -122.427797058705) | |||
29723 | 29723 | 177927 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5988959.91996 | 2089504.3338 | 37.716745265857 | -122.48013237763 | (37.716745265857, -122.48013237763) | ||||
61160 | 61160 | 177926 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5988935.7978 | 2089543.3512799998 | 37.7168509964648 | -122.480218609114 | (37.7168509964648, -122.480218609114) | ||||
61899 | 61899 | 177929 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5988839.75679 | 2089455.3276 | 37.7166037242653 | -122.48054413220699 | (37.7166037242653, -122.480544132207) | ||||
69696 | 69696 | 177930 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5988862.76325 | 2089422.54432 | 37.7165150466091 | -122.480462212988 | (37.7165150466091, -122.480462212988) | ||||
70010 | 70010 | 177934 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5988635.61259 | 2089280.10032 | 37.7161107276166 | -122.481236924063 | (37.7161107276166, -122.481236924063) | ||||
131812 | 131812 | 177931 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5988808.760919999 | 2089375.86435 | 37.716383736599205 | -122.480645454328 | (37.7163837365992, -122.480645454328) | ||||
135710 | 135710 | 177932 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5988789.67714 | 2089358.2569799998 | 37.7163342819918 | -122.480710128176 | (37.7163342819918, -122.480710128176) | ||||
146613 | 146613 | 177923 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5988561.02848 | 2089156.81478 | 37.715767879956104 | -122.481485695422 | (37.7157678799561, -122.481485695422) | ||||
148235 | 148235 | 177933 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5988685.34824 | 2089320.7162799998 | 37.7162251402652 | -122.481067988213 | (37.7162251402652, -122.481067988213) | ||||
178623 | 178623 | 177928 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5988855.6313 | 2089468.65527 | 37.716641241284705 | -122.480490237638 | (37.7166412412847, -122.480490237638) | ||||
67404 | 67404 | 177922 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Cambon Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5990625.846609999 | 2089245.25322 | 37.7161305522573 | -122.474355255986 | (37.7161305522573, -122.474355255986) | |||
72659 | 72659 | 177921 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Cambon Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5990636.51581 | 2089256.00468 | 37.7161606912434 | -122.47431916261499 | (37.7161606912434, -122.474319162615) | |||
57235 | 57235 | 175648 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990403.32902 | 2090274.19266 | 37.7189428716957 | -122.475199448694 | (37.7189428716957, -122.475199448694) | |||
67405 | 67405 | 175650 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990453.87404 | 2090277.7472299999 | 37.718955561137705 | -122.475024995517 | (37.7189555611377, -122.475024995517) | |||
180905 | 180905 | 175649 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5990437.61377 | 2090276.93523 | 37.7189523892072 | -122.47508114108 | (37.7189523892072, -122.47508114108) | |||
185753 | 185753 | 175651 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990482.39675 | 2090282.34445 | 37.7189698369625 | -122.47492674008001 | (37.7189698369625, -122.47492674008) | |||
49521 | 49521 | 240131 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0 Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004671.7789900005 | 2103561.17999 | 37.7562426115098 | -122.426824733295 | (37.7562426115098, -122.426824733295) | |||
50268 | 50268 | 226146 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 0 Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004672.1171 | 2103577.59935 | 37.756287714330796 | -122.42682473328199 | (37.7562877143308, -122.426824733282) | |||
75125 | 75125 | 240132 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0 Chattanooga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004672.38894 | 2103545.66672 | 37.7562000502026 | -122.42682151911801 | (37.7562000502026, -122.426821519118) | |||
154817 | 154817 | 240133 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0 Chattanooga St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004672.52486 | 2103529.70008 | 37.756156217245604 | -122.426819912015 | (37.7561562172456, -122.426819912015) | |||
24871 | 24871 | 178331 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Crespi Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5990248.62782 | 2090529.4940400003 | 37.719634898219205 | -122.47575281776001 | (37.7196348982192, -122.47575281776) | ||||
35071 | 35071 | 176378 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Crespi Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5989827.05129 | 2090325.18948 | 37.7190494782331 | -122.477195118066 | (37.7190494782331, -122.477195118066) | ||||
36449 | 36449 | 176377 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Crespi Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989839.20092 | 2090334.4554299999 | 37.7190756251255 | -122.47715379871201 | (37.7190756251255, -122.477153798712) | ||||
39653 | 39653 | 178330 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Crespi Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5990231.62588 | 2090527.9032400001 | 37.7196295445501 | -122.47581147062 | (37.7196295445501, -122.47581147062) | ||||
73344 | 73344 | 176058 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Crespi Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 5989854.78687 | 2090110.33741 | 37.7184611570226 | -122.47708355628599 | (37.7184611570226, -122.477083556286) | ||||
135205 | 135205 | 177925 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Crespi Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5989826.52584 | 2090074.03315 | 37.71835983492971 | -122.477178590321 | (37.7183598349297, -122.477178590321) | ||||
154609 | 154609 | 178329 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Crespi Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5990213.26487 | 2090523.74185 | 37.719617053850996 | -122.47587463361 | (37.719617053851, -122.47587463361) | ||||
184101 | 184101 | 177924 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Crespi Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5989730.82285 | 2090240.32639 | 37.718810881792 | -122.47752153959 | (37.718810881792, -122.47752153959) | ||||
69468 | 69468 | 177945 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Diaz Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5990273.00331 | 2089979.48461 | 37.718126121809604 | -122.47562842082701 | (37.7181261218096, -122.475628420827) | ||||
22882 | 22882 | 176369 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990491.08034 | 2089186.3269 | 37.7159609464097 | -122.47481676917101 | (37.7159609464097, -122.474816769171) | ||||
25725 | 25725 | 178308 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 5990210.12045 | 2089417.27348 | 37.716578783365605 | -122.47580474370501 | (37.7165787833656, -122.475804743705) | ||||
38217 | 38217 | 176045 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990157.58815 | 2089581.85402 | 37.7170276349961 | -122.475998332672 | (37.7170276349961, -122.475998332672) | ||||
44468 | 44468 | 176364 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5988874.21496 | 2090711.48965 | 37.720054833031504 | -122.480516928613 | (37.7200548330315, -122.480516928613) | ||||
53417 | 53417 | 176367 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989068.70923 | 2090618.6052 | 37.7198110969962 | -122.479837842465 | (37.7198110969962, -122.479837842465) | ||||
65336 | 65336 | 176043 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5989267.954919999 | 2090414.23117 | 37.7192615104927 | -122.47913418591499 | (37.7192615104927, -122.479134185915) | ||||
71655 | 71655 | 176365 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5988916.46599 | 2090663.1949 | 37.719924683163 | -122.48036734976999 | (37.719924683163, -122.48036734977) | ||||
75369 | 75369 | 176363 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5988462.773440001 | 2091307.9607099998 | 37.7216686718604 | -122.48198279658399 | (37.7216686718604, -122.481982796584) | ||||
134960 | 134960 | 176366 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5989001.162169999 | 2090698.46083 | 37.720026436042104 | -122.48007716733801 | (37.7200264360421, -122.480077167338) | ||||
136145 | 136145 | 176368 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5990356.63176 | 2089404.5642 | 37.7165523801656 | -122.475297405564 | (37.7165523801656, -122.475297405564) | ||||
136573 | 136573 | 177298 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988403.4281 | 2091243.7200900002 | 37.721488831717 | -122.48218323117099 | (37.721488831717, -122.482183231171) | ||||
151804 | 151804 | 176362 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 5988643.66331 | 2091104.1894200002 | 37.721119686105204 | -122.481342600695 | (37.7211196861052, -122.481342600695) | ||||
153599 | 153599 | 176040 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 5989182.3515099995 | 2090508.47222 | 37.719515300969206 | -122.479436972335 | (37.7195153009692, -122.479436972335) | ||||
161995 | 161995 | 176044 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 5990534.22824 | 2089263.3063400001 | 37.7161748133009 | -122.47467324639099 | (37.7161748133009, -122.474673246391) | ||||
163843 | 163843 | 176041 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5989102.080019999 | 2090436.91452 | 37.71931415859461 | -122.479709205217 | (37.7193141585946, -122.479709205217) | ||||
166239 | 166239 | 176046 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 5990073.98867 | 2089647.08481 | 37.7172018948419 | -122.47629205486 | (37.7172018948419, -122.47629205486) | ||||
183286 | 183286 | 177914 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Font Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5989849.3669300005 | 2089820.74775 | 37.7176657012986 | -122.477081140675 | (37.7176657012986, -122.477081140675) | ||||
185959 | 185959 | 176042 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5989234.3289 | 2090278.8910299998 | 37.7188879474116 | -122.47924052173599 | (37.7188879474116, -122.479240521736) | ||||
25292 | 25292 | 177947 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989601.96089 | 2090504.09134 | 37.7195276360688 | -122.477986231896 | (37.7195276360688, -122.477986231896) | ||||
32094 | 32094 | 177949 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Fuente Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989559.04866 | 2090448.7873900002 | 37.7193732944219 | -122.47813052091101 | (37.7193732944219, -122.478130520911) | ||||
54108 | 54108 | 176348 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 0 Fuente Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5989603.79735 | 2090546.09261 | 37.7196430676648 | -122.47798295295799 | (37.7196430676648, -122.477982952958) | ||||
62097 | 62097 | 177948 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989566.53985 | 2090511.4530000002 | 37.7195457933774 | -122.47810920609601 | (37.7195457933774, -122.478109206096) | ||||
123716 | 123716 | 177946 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5989610.43005 | 2090657.9013200002 | 37.7199504514394 | -122.477968195982 | (37.7199504514394, -122.477968195982) | ||||
27126 | 27126 | 177939 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989472.35628 | 2089125.29207 | 37.7157342731997 | -122.478333458321 | (37.7157342731997, -122.478333458321) | ||||
51889 | 51889 | 177940 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989427.62768 | 2089128.0215200002 | 37.7157391708956 | -122.478488258642 | (37.7157391708956, -122.478488258642) | ||||
136838 | 136838 | 104722 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Garces Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 770294 | 5989426.465469999 | 2089157.7784799999 | 37.7158208086468 | -122.478494450472 | (37.7158208086468, -122.478494450472) | |||
149147 | 149147 | 177935 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989493.36658 | 2088932.77712 | 37.715206894553795 | -122.47824676997699 | (37.7152068945538, -122.478246769977) | ||||
172901 | 172901 | 177937 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5989487.39768 | 2088989.39507 | 37.7153620069155 | -122.47827153820299 | (37.7153620069155, -122.478271538203) | ||||
176036 | 176036 | 177936 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5989491.06081 | 2088964.9371200001 | 37.715295064093205 | -122.478257089699 | (37.7152950640932, -122.478257089699) | ||||
184364 | 184364 | 177938 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5989480.9198900005 | 2089050.18574 | 37.71552854698071 | -122.478298370392 | (37.7155285469807, -122.478298370392) | ||||
71030 | 71030 | 225636 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 0 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008158.437390001 | 2095854.0250900001 | 37.7352770017363 | -122.414221366146 | (37.7352770017363, -122.414221366146) | |||
24035 | 24035 | 178607 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990327.66617 | 2089955.55198 | 37.7180635775375 | -122.47543773036101 | (37.7180635775375, -122.475437730361) | ||||
24183 | 24183 | 175768 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989578.68884 | 2089185.3656400002 | 37.7159053925979 | -122.47797031747801 | (37.7159053925979, -122.477970317478) | ||||
24841 | 24841 | 175769 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5989661.94364 | 2089233.64885 | 37.716042798215206 | -122.477686080452 | (37.7160427982152, -122.477686080452) | ||||
24880 | 24880 | 178117 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988789.573419999 | 2089765.1297400002 | 37.717451446800204 | -122.480740256365 | (37.7174514468002, -122.480740256365) | ||||
27306 | 27306 | 178328 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | 5990317.34225 | 2090043.8786900002 | 37.718305502374704 | -122.47547986090599 | (37.7183055023747, -122.475479860906) | ||||
29157 | 29157 | 175654 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5989491.89044 | 2089216.44658 | 37.7159856948481 | -122.478272601196 | (37.7159856948481, -122.478272601196) | ||||
29386 | 29386 | 177222 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5989183.517969999 | 2089355.54971 | 37.7163497314364 | -122.479348640047 | (37.7163497314364, -122.479348640047) | ||||
31497 | 31497 | 178323 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5990245.32384 | 2089538.4798299999 | 37.7169136270349 | -122.475691910275 | (37.7169136270349, -122.475691910275) | ||||
36738 | 36738 | 181277 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5988402.74919 | 2089827.8491900002 | 37.7176011677477 | -122.482081905481 | (37.7176011677477, -122.482081905481) | ||||
36921 | 36921 | 175655 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5989994.06268 | 2089291.6225400001 | 37.7162212479866 | -122.476542364932 | (37.7162212479866, -122.476542364932) | ||||
40050 | 40050 | 176160 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990378.89561 | 2089837.21304 | 37.7177416175535 | -122.47525201947701 | (37.7177416175535, -122.475252019477) | ||||
40111 | 40111 | 178175 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5989026.35056 | 2089515.5020599999 | 37.7167797908382 | -122.47990357931002 | (37.7167797908382, -122.47990357931) | ||||
40567 | 40567 | 176049 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989054.79394 | 2089564.29309 | 37.716915411303 | -122.479808833919 | (37.716915411303, -122.479808833919) | ||||
40789 | 40789 | 176052 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5989234.209980001 | 2089407.1197400002 | 37.716494274064495 | -122.47917719598 | (37.7164942740645, -122.47917719598) | ||||
41434 | 41434 | 175767 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989494.93952 | 2089175.43765 | 37.7158732715029 | -122.478259065526 | (37.7158732715029, -122.478259065526) | ||||
43657 | 43657 | 177729 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990316.61378 | 2090071.1896099998 | 37.718380449173395 | -122.47548437190399 | (37.7183804491734, -122.475484371904) | ||||
44057 | 44057 | 175774 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5990113.97654 | 2089437.91841 | 37.7166298945381 | -122.47613856845 | (37.7166298945381, -122.47613856845) | ||||
44691 | 44691 | 175766 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989094.03032 | 2089506.27121 | 37.7167583770722 | -122.47966897135001 | (37.7167583770722, -122.47966897135) | ||||
44701 | 44701 | 175656 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5990014.1272599995 | 2089314.5953099998 | 37.716285489253 | -122.476474690052 | (37.716285489253, -122.476474690052) | ||||
51076 | 51076 | 177220 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5989003.1682400005 | 2089530.2906900002 | 37.7168190498446 | -122.47998478988801 | (37.7168190498446, -122.479984789888) | ||||
53937 | 53937 | 175653 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5988966.88544 | 2089648.46014 | 37.7171414055178 | -122.480118843736 | (37.7171414055178, -122.480118843736) | ||||
55378 | 55378 | 176054 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5989245.31981 | 2089315.2477799999 | 37.7162426617475 | -122.47913207879101 | (37.7162426617475, -122.479132078791) | ||||
56400 | 56400 | 175657 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5990127.49163 | 2089397.98883 | 37.716521041479204 | -122.476088939347 | (37.7165210414792, -122.476088939347) | ||||
56811 | 56811 | 178172 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 0 Gonzalez Dr | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988133.68649 | 2089845.1312099998 | 37.7176329668754 | -122.483013187625 | (37.7176329668754, -122.483013187625) | ||||
59851 | 59851 | 175772 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989911.02174 | 2089222.5365 | 37.716026738112 | -122.47682434649201 | (37.716026738112, -122.476824346492) | ||||
60239 | 60239 | 178116 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988774.083930001 | 2089765.9400900002 | 37.7174527715132 | -122.480793855056 | (37.7174527715132, -122.480793855056) | ||||
62427 | 62427 | 176057 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989281.98257 | 2089351.5172299999 | 37.7163443777799 | -122.479008007435 | (37.7163443777799, -122.479008007435) | ||||
63730 | 63730 | 178606 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5989765.07873 | 2089203.5232 | 37.715966065363205 | -122.47732740025499 | (37.7159660653632, -122.477327400255) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");