Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94710 | 94710 | 101366 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1348 Noe St | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 24 | Owner: Brent Sommer 519-1119 nocmout@gmail.com | 6003163.2 | 2100416.0 | 37.7475212781449 | -122.43181735246 | (37.7475212781449, -122.43181735246) | ||||
| 95399 | 95399 | 95952 | Undocumented 2 | Tree(s) :: 17 | 46 Bosworth St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 1x1 | 6004452.0 | 2095346.0 | 37.733673188028796 | -122.426999715945 | (37.7336731880288, -122.426999715945) | ||||
| 95977 | 95977 | 112005 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 96282 | 96282 | 104677 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 65 ZIRCON PL | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770985 | 6002398.2 | 2098694.7 | 37.7427515964219 | -122.43433962698201 | (37.7427515964219, -122.434339626982) | |||||
| 96669 | 96669 | 112123 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 771 WALLER ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | 3x3 | 6002060.0 | 2108730.0 | 37.770286913106204 | -122.43622703445601 | (37.7702869131062, -122.436227034456) | ||||
| 96965 | 96965 | 112126 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 8245 Geary Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3x3 | 5981385.27932 | 2112314.25515 | 37.7789318748139 | -122.508005614464 | (37.7789318748139, -122.508005614464) | ||||
| 96974 | 96974 | 112589 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 776 TEHAMA ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009004.0 | 2110266.0 | 37.7748964951756 | -122.41231625471 | (37.7748964951756, -122.41231625471) | |||||
| 97448 | 97448 | 107454 | Undocumented 2 | Tree(s) :: 17 | 2101 CHESTNUT ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6001686.4 | 2119715.1 | 37.8004279539124 | -122.43830641537201 | (37.8004279539124, -122.438306415372) | ||||||
| 97688 | 97688 | 103264 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1660 NORTH POINT ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x5 | 6002814.0 | 2121000.0 | 37.8040200224121 | -122.43449639401699 | (37.8040200224121, -122.434496394017) | |||||
| 98164 | 98164 | 112394 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2 AMAZON AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6000472.0 | 2089324.0 | 37.7169122992795 | -122.440327982322 | (37.7169122992795, -122.440327982322) | ||||
| 98308 | 98308 | 107371 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 448 BROADWAY | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011394.4 | 2118786.8 | 37.798426445485 | -122.404647279275 | (37.798426445485, -122.404647279275) | ||||
| 98498 | 98498 | 109631 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 390 BUCKINGHAM WAY | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9x9 | 5989374.0 | 2093588.0 | 37.7279820381776 | -122.478999652651 | (37.7279820381776, -122.478999652651) | |||||
| 98769 | 98769 | 112422 | Undocumented 2 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775772 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.43839895973301 | (37.7402178594385, -122.438398959733) | ||
| 98835 | 98835 | 107295 | Undocumented 2 | Tree(s) :: 17 | 218 Howth St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2014 12:00:00 AM | Permit Number 773357 | 5997350.11104 | 2090721.936 | 37.7205724606378 | -122.451219539387 | (37.7205724606378, -122.451219539387) | ||||
| 99355 | 99355 | 106961 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 325 DWIGHT ST | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6010604.0 | 2091349.0 | 37.7230442144558 | -122.405448941518 | (37.7230442144558, -122.405448941518) | ||||||
| 99447 | 99447 | 106022 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 181 Buena Vista Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 771765 | 6001436.7 | 2108377.5 | 37.7692836023561 | -122.438357764726 | (37.7692836023561, -122.438357764726) | |||||
| 100274 | 100274 | 99610 | Undocumented 2 | Tree(s) :: 17 | 111 Corwin St | Unaccepted Street : Yard 14 | Landscaping 2 | Private 1 | 6000616.0 | 2104331.0 | 37.7581261988062 | -122.44090619353999 | (37.7581261988062, -122.44090619354) | ||||||
| 100393 | 100393 | 106237 | Undocumented 2 | Tree(s) :: 17 | 607 BRUSSELS ST | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010922.6 | 2091903.6 | 37.724584840413996 | -122.404386617586 | (37.724584840414, -122.404386617586) | ||||||
| 100575 | 100575 | 110968 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2411 WASHINGTON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x6 | 6003071.0 | 2116473.0 | 37.7916046396744 | -122.433283354559 | (37.7916046396744, -122.433283354559) | ||||
| 101374 | 101374 | 106758 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 445 Grafton Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | Permit Number 772911 | 5995409.1 | 2090523.2 | 37.7199154518997 | -122.457914582927 | (37.7199154518997, -122.457914582927) | ||||
| 101468 | 101468 | 107283 | Undocumented 2 | Tree(s) :: 17 | 4214 26TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002441.8 | 2100664.9 | 37.7481637783896 | -122.434329697409 | (37.7481637783896, -122.434329697409) | ||||||
| 101497 | 101497 | 105219 | Undocumented 2 | Tree(s) :: 17 | 1799X 26TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988124.0 | 2103397.0 | 37.7548423040305 | -122.48403988838899 | (37.7548423040305, -122.484039888389) | |||||
| 101905 | 101905 | 97139 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Goettingen St | Front Yard : 25 | Landscaping 2 | Private 1 | 6011052.0 | 2090410.0 | 37.720490952554606 | -122.40383424464399 | (37.7204909525546, -122.403834244644) | ||||||
| 102018 | 102018 | 110259 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 655 SANCHEZ ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003729.2 | 2104438.0 | 37.75859681194179 | -122.430147043342 | (37.7585968119418, -122.430147043342) | |||||
| 102090 | 102090 | 107368 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 660 OFARRELL ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008096.0 | 2114145.0 | 37.785496305176395 | -122.415731945695 | (37.7854963051764, -122.415731945695) | ||||||
| 104195 | 104195 | 105930 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 971 Florida St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009455.0 | 2103552.4 | 37.7564877890416 | -122.410282026926 | (37.7564877890416, -122.410282026926) | |||||
| 104404 | 104404 | 106685 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Yukon St | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 772768 | 6000197.4 | 2104288.0 | 37.757984281634 | -122.44235080136299 | (37.757984281634, -122.442350801363) | |||||
| 105054 | 105054 | 104686 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 140 26TH AVE | Front Yard : Cutout 8 | Tree 1 | Private 1 | 22 | 4x4 | 5987812.9 | 2115041.6 | 37.786797021543 | -122.485970438221 | (37.786797021543, -122.485970438221) | ||||
| 105296 | 105296 | 107631 | Undocumented 2 | :: 54 | 4059 26th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003507.0 | 2100669.0 | 37.7482354401484 | -122.43064656488701 | (37.7482354401484, -122.430646564887) | ||||||
| 105477 | 105477 | 112588 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 776 TEHAMA ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009004.0 | 2110266.0 | 37.7748964951756 | -122.41231625471 | (37.7748964951756, -122.41231625471) | |||||
| 105580 | 105580 | 121764 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 580 07th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011520.0 | 2109619.0 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | |||||
| 105728 | 105728 | 104942 | Undocumented 2 | Tree(s) :: 17 | 840X Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 09/11/2014 12:00:00 AM | 3 | Permit Number 770723 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||
| 106735 | 106735 | 115060 | Undocumented 2 | Betula pendula :: European White Birch 146 | 26 CRESCENT AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6005316.0 | 2095906.0 | 37.735259640844 | -122.42405242211201 | (37.735259640844, -122.424052422112) | ||||
| 106788 | 106788 | 99743 | Undocumented 2 | Tree(s) :: 17 | 447 Clipper St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002285.0 | 2100894.0 | 37.7487839315189 | -122.43488828753 | (37.7487839315189, -122.43488828753) | ||||||
| 107243 | 107243 | 106236 | Undocumented 2 | Tree(s) :: 17 | 921 DWIGHT ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008890.0 | 2090823.6 | 37.721505591324004 | -122.41133681841801 | (37.721505591324, -122.411336818418) | ||||||
| 107319 | 107319 | 100868 | Undocumented 2 | Tree(s) :: 17 | 655 03rd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014591.2 | 2111956.1 | 37.7798490696224 | -122.39310707997801 | (37.7798490696224, -122.393107079978) | |||||
| 107475 | 107475 | 110612 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 15 MAGELLAN AVE | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775412 | 5994586.0 | 2101167.0 | 37.7490933856104 | -122.46153099469801 | (37.7490933856104, -122.461530994698) | ||
| 108086 | 108086 | 104764 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1855 08TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2x4 | Permit Number 770861 | 5993717.5 | 2102872.4 | 37.7537259496496 | -122.46465807345601 | (37.7537259496496, -122.464658073456) | |||
| 108934 | 108934 | 113438 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 180x LOWER TER | Median : Yard 3 | Tree 1 | Private 1 | 22 | 3x3 | 6000120.0 | 2106246.0 | 37.7633560547765 | -122.44275907578 | (37.7633560547765, -122.44275907578) | ||||
| 109226 | 109226 | 109516 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 105 MIDCREST WAY | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 12x12 | 5998180.4 | 2101012.8 | 37.748876224655795 | -122.4490904711 | (37.7488762246558, -122.4490904711) | ||||
| 110015 | 110015 | 107354 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 34 Princeton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2014 12:00:00 AM | Permit Number 773911 | 6007504.47131 | 2093847.45075 | 37.7297306299075 | -122.41634029478998 | (37.7297306299075, -122.41634029479) | ||||
| 110490 | 110490 | 107141 | Undocumented 2 | Tree(s) :: 17 | 3498 16TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003565.7 | 2106565.7 | 37.764429704069 | -122.430864344516 | (37.764429704069, -122.430864344516) | ||||||
| 110713 | 110713 | 105514 | Undocumented 2 | Tree(s) :: 17 | 4004 20TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003604.3 | 2104237.3 | 37.7580386626716 | -122.43056468307199 | (37.7580386626716, -122.430564683072) | |||||
| 111179 | 111179 | 107196 | Undocumented 2 | Tree(s) :: 17 | 3359 21st St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x8 | 6005949.0 | 2103729.0 | 37.756775538317896 | -122.42241958247601 | (37.7567755383179, -122.422419582476) | |||||
| 112197 | 112197 | 104793 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700 39th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5983853.5987599995 | 2111004.1266 | 37.775479771007205 | -122.499370005427 | (37.7754797710072, -122.499370005427) | ||||
| 112494 | 112494 | 119244 | Undocumented 2 | :: 54 | 311 30th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2016 12:00:00 AM | 3 | 3x3 | 6004402.0 | 2098353.0 | 37.7419269008751 | -122.42738671849101 | (37.7419269008751, -122.427386718491) | |||
| 112663 | 112663 | 114044 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 549X ARLINGTON ST | Median : Cutout 11 | Tree 1 | Private 1 | 70 | 6003400.0 | 2095634.0 | 37.734404428182295 | -122.430657330781 | (37.7344044281823, -122.430657330781) | |||||
| 112733 | 112733 | 107503 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4140 19th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992157.71887 | 2088336.37745 | 37.7137236301705 | -122.46899431666 | (37.7137236301705, -122.46899431666) | ||||||
| 113032 | 113032 | 107468 | Undocumented 2 | Tree(s) :: 17 | 479 SANCHEZ ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003670.2 | 2105503.2 | 37.7615182547925 | -122.430427093318 | (37.7615182547925, -122.430427093318) | ||||||
| 113411 | 113411 | 114039 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1328 TREAT WAY | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6008689.0 | 2100921.0 | 37.7492195885474 | -122.412745111821 | (37.7492195885474, -122.412745111821) | ||||
| 113702 | 113702 | 112010 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 113901 | 113901 | 105206 | Undocumented 2 | Tree(s) :: 17 | 2938 SLOAT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774528 | 5981725.3 | 2096580.0 | 37.7357501162313 | -122.50566267275299 | (37.7357501162313, -122.505662672753) | ||
| 114809 | 114809 | 110197 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3965 SACRAMENTO ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995791.8 | 2114806.4 | 37.7866129696327 | -122.458348463038 | (37.7866129696327, -122.458348463038) | |||||
| 115298 | 115298 | 104745 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 845 25TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x4 | 5988152.6 | 2110221.5 | 37.7735821764225 | -122.484441503692 | (37.7735821764225, -122.484441503692) | ||||
| 115348 | 115348 | 106967 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1225 02ND AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995419.1 | 2107212.6 | 37.7657409782079 | -122.45908784262899 | (37.7657409782079, -122.459087842629) | ||||||
| 115356 | 115356 | 106044 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 415 DEWEY BLVD | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5995172.1 | 2100351.0 | 37.7468865723154 | -122.45944518004801 | (37.7468865723154, -122.459445180048) | ||||||
| 115379 | 115379 | 107599 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 177 CORBETT AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000269.8 | 2105595.5 | 37.7615784812961 | -122.44219426929199 | (37.7615784812961, -122.442194269292) | ||||||
| 116410 | 116410 | 112904 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 727 BURNETT AVE | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5999303.0 | 2101616.0 | 37.750596607185 | -122.44525189688 | (37.750596607185, -122.44525189688) | |||||
| 116523 | 116523 | 121762 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 580 07th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011520.0 | 2109619.0 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | |||||
| 116646 | 116646 | 105767 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 245 RUTLEDGE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | 6010031.3 | 2099465.2 | 37.7452975299559 | -122.40800074456999 | (37.7452975299559, -122.40800074457) | ||||
| 116776 | 116776 | 104817 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3170 BALBOA ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5985841.0 | 2111127.0 | 37.7759335444794 | -122.49250425909901 | (37.7759335444794, -122.492504259099) | ||||
| 117009 | 117009 | 112004 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 117432 | 117432 | 107476 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 69 Mirabel Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2014 12:00:00 AM | 3 | 10x6 | Permit Number 773500 | 6007782.9107099995 | 2100032.55813 | 37.746729228385895 | -122.41581549012899 | (37.7467292283859, -122.415815490129) | ||
| 118000 | 118000 | 108025 | Undocumented 2 | Tree(s) :: 17 | 250 Duncan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004900.0 | 2099907.0 | 37.7462219824614 | -122.425775379215 | (37.7462219824614, -122.425775379215) | |||||
| 118422 | 118422 | 112428 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2819 JACKSON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | 3x3 | 6000608.0 | 2116457.0 | 37.7914206746057 | -122.441804136035 | (37.7914206746057, -122.441804136035) | ||||
| 118510 | 118510 | 121320 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 550 07th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5993807.0 | 2111747.0 | 37.7780984292352 | -122.46499305582701 | (37.7780984292352, -122.464993055827) | ||||
| 118986 | 118986 | 113148 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 470X BEACON ST | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | 6002259.0 | 2098542.0 | 37.7423244157255 | -122.43481002285499 | (37.7423244157255, -122.434810022855) | ||||
| 119002 | 119002 | 104729 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 250-252 FRANCISCO ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 5x5 | 6010061.3 | 2121325.4 | 37.805322217951 | -122.409439489572 | (37.805322217951, -122.409439489572) | ||||
| 119380 | 119380 | 109326 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1624 VALLEJO ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005582.1 | 2118270.7 | 37.7966828044962 | -122.424722909098 | (37.7966828044962, -122.424722909098) | |||||
| 119410 | 119410 | 106709 | Undocumented 2 | Aesculus hippocastanum :: White Horsechestnut 364 | 1027 Florida St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2014 12:00:00 AM | 3X3 | Permit Number 772684 | 6009474.8 | 2103180.3 | 37.75546719598721 | -122.410187281194 | (37.7554671959872, -122.410187281194) | |||
| 119999 | 119999 | 105851 | Undocumented 2 | Tree(s) :: 17 | 2590 16TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991465.4 | 2097806.4 | 37.7396859298071 | -122.47207703990802 | (37.7396859298071, -122.472077039908) | |||||
| 120337 | 120337 | 106158 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 450 MAGELLAN AVE | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6x6 | 5993514.2 | 2099497.2 | 37.7444467889139 | -122.465115996043 | (37.7444467889139, -122.465115996043) | ||||
| 120561 | 120561 | 107212 | Undocumented 2 | Tree(s) :: 17 | 556 NATOMA ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6009971.5 | 2111821.4 | 37.779221502662104 | -122.4090792269 | (37.7792215026621, -122.4090792269) | |||||
| 121044 | 121044 | 107168 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 65 SCOTT ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 6002336.3 | 2108640.7 | 37.7700574118158 | -122.435264926513 | (37.7700574118158, -122.435264926513) | |||||
| 121102 | 121102 | 105210 | Undocumented 2 | Tree(s) :: 17 | 2467 38TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x3 | 5984528.0 | 2098448.0 | 37.7410436924745 | -122.49611056576599 | (37.7410436924745, -122.496110565766) | |||||
| 121140 | 121140 | 112006 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 121452 | 121452 | 107119 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 41 Elsie St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | 3x3 | Permit Number 773430 | 6007557.36556 | 2099188.16218 | 37.7443980238935 | -122.41653560079901 | (37.7443980238935, -122.416535600799) | |||
| 121547 | 121547 | 104939 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 109X Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | ||||||
| 122874 | 122874 | 105008 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1957 - 1959 15TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2014 12:00:00 AM | 11 | 3x3 | Permit Number 771758 | 6004438.4 | 2107144.3 | 37.766067808554205 | -122.42788714698798 | (37.7660678085542, -122.427887146988) | ||
| 122921 | 122921 | 106507 | Undocumented 2 | Ceanothus thyrsiflorus :: Blueblossom Ceanothus 529 | 50 FANNING WAY | Front Yard : Yard 7 | Tree 1 | Private 1 | 5991716.2 | 2101233.1 | 37.749109278682795 | -122.471459514348 | (37.7491092786828, -122.471459514348) | ||||||
| 123255 | 123255 | 105521 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1787 32ND AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5986257.6 | 2103091.7 | 37.7538951964507 | -122.490471869912 | (37.7538951964507, -122.490471869912) | ||||
| 123496 | 123496 | 107519 | Undocumented 2 | Tree(s) :: 17 | 100x CHURCH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004015.5 | 2108290.9 | 37.7691921614924 | -122.42943164871402 | (37.7691921614924, -122.429431648714) | ||||||
| 123696 | 123696 | 107118 | Undocumented 2 | Tree(s) :: 17 | 49 Elsie St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | 6x3 | Permit Number 773429 | 6007534.56738 | 2099145.8971700002 | 37.7442806914439 | -122.41661143894 | (37.7442806914439, -122.41661143894) | |||
| 123856 | 123856 | 106896 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2958 SLOAT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981703.3 | 2096579.8 | 37.7357482722765 | -122.505738719186 | (37.7357482722765, -122.505738719186) | ||||||
| 123871 | 123871 | 106711 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 3990 FOLSOM ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008366.1 | 2096547.2 | 37.7371919715517 | -122.413552407719 | (37.7371919715517, -122.413552407719) | |||||
| 124168 | 124168 | 103088 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 256 SHIPLEY ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6011387.0 | 2111652.0 | 37.7788355638527 | -122.404170475964 | (37.7788355638527, -122.404170475964) | ||||
| 124459 | 124459 | 104719 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 61- 63 SUSSEX ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 771137 | 6002409.7 | 2096544.3 | 37.7368477492981 | -122.434146170859 | (37.7368477492981, -122.434146170859) | |||
| 124788 | 124788 | 104692 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 2201 SUTTER ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001996.0 | 2114241.0 | 37.7854150975946 | -122.436842984948 | (37.7854150975946, -122.436842984948) | ||||
| 125529 | 125529 | 106710 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 3869 19th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | Permit Number 772840 | 6003862.3 | 2104785.7 | 37.7595590509906 | -122.429711522366 | (37.7595590509906, -122.429711522366) | ||||
| 125908 | 125908 | 104941 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 133X Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | ||||||
| 125985 | 125985 | 121447 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1251 03rd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015574.0 | 2109248.0 | 37.7724677756099 | -122.389517929907 | (37.7724677756099, -122.389517929907) | |||||
| 126000 | 126000 | 104740 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 200X Fair Oaks St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | On the 23rd side of property. | 6005413.0 | 2102541.0 | 37.753483315938 | -122.42418878244499 | (37.753483315938, -122.424188782445) | |||||
| 126098 | 126098 | 110616 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 182X LOWER TER | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999820.0 | 2106230.0 | 37.763295015778205 | -122.44379552503 | (37.7632950157782, -122.44379552503) | |||||
| 126264 | 126264 | 104551 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 428 PANORAMA DR | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5997536.0 | 2102327.0 | 37.7524478160364 | -122.451413569464 | (37.7524478160364, -122.451413569464) | ||||
| 126392 | 126392 | 111935 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 66 SEACLIFF AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 5987847.0 | 2115823.0 | 37.788944509176 | -122.485909838035 | (37.788944509176, -122.485909838035) | |||||
| 126776 | 126776 | 102902 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 290 PACIFIC AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6012556.0 | 2118523.0 | 37.797766966668 | -122.400609219963 | (37.797766966668, -122.400609219963) | ||||
| 127139 | 127139 | 108935 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 12X CAMP ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005858.0 | 2106413.0 | 37.764140038871396 | -122.422925047265 | (37.7641400388714, -122.422925047265) | ||||
| 127290 | 127290 | 106849 | Undocumented 2 | Tree(s) :: 17 | 111 Conrad St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2014 12:00:00 AM | 2X3 | Permit Number 772929 | 6001823.82453 | 2096683.04547 | 37.737195443088396 | -122.436181723191 | (37.7371954430884, -122.436181723191) | |||
| 127458 | 127458 | 112008 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 127904 | 127904 | 105121 | Undocumented 2 | :: 54 | 721 BEACH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6006739.7 | 2121813.5 | 37.8064757462399 | -122.42096901139601 | (37.8064757462399, -122.420969011396) |
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");