trees
8,298 rows where qLegalStatus_id = 4 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
81891 | 110202 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1039 PAGE ST | Front Yard : Cutout | Tree | Private 2 | 4x5 | 6001572.7 | 2109358.5 | 37.771984919077 | -122.437957625293 | (37.771984919077, -122.437957625293) | 15 | 5 | 11 | 29492 | 9 | |||||
81928 | 107454 | Undocumented 4 | Tree(s) :: 17 | 2101 CHESTNUT ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001686.4 | 2119715.1 | 37.8004279539124 | -122.438306415372 | (37.8004279539124, -122.438306415372) | 13 | 9 | 1 | 57 | 17 | ||||||
83802 | 115379 | Undocumented 4 | Tree(s) :: 17 | 4004 20TH ST | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 6003604 | 2104237 | 37.758037821948 | -122.430565699194 | (37.758037821948, -122.430565699194) | 2 | 4 | 5 | 28862 | 3 | |||||
84057 | 113779 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 322 LISBON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002684 | 2091576 | 37.723221487961 | -122.432842971004 | (37.723221487961, -122.432842971004) | 9 | 7 | 6 | 28861 | 5 | |||||
84307 | 104677 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 65 ZIRCON PL | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 770985 | 6002398.2 | 2098694.7 | 37.7427515964219 | -122.434339626982 | (37.7427515964219, -122.434339626982) | 2 | 7 | 5 | 63 | 7 | |||||
84518 | 112016 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 115 Red Rock Way | Sidewalk: Property side : Yard | Tree | Private 2 | 07/08/2015 12:00:00 AM | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | 2 | 7 | 5 | 63 | 22 | ||||
87519 | 112589 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 TEHAMA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009004 | 2110266 | 37.7748964951756 | -122.41231625471 | (37.7748964951756, -122.41231625471) | 8 | 2 | 9 | 28853 | 34 | |||||
88038 | 112005 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 115 Red Rock Way | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | 2 | 7 | 5 | 63 | 22 | |||||
88123 | 101366 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 1348 Noe St | Unaccepted Street : Yard | Tree | Private 2 | 24 | Owner: Brent Sommer 519-1119 nocmout@gmail.com | 6003163.2 | 2100416 | 37.7475212781449 | -122.43181735246 | (37.7475212781449, -122.43181735246) | 2 | 4 | 5 | 63 | 22 | ||||
89187 | 251679 | Undocumented 4 | Dodonaea viscosa :: Hop Bush 43 | 5 Dwight St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011495 | 2091622 | 37.7238435952898 | -122.402388102511 | (37.7238435952898, -122.402388102511) | 10 | 3 | 7 | 309 | 28 | |||||
90033 | 107359 | Undocumented 4 | Tree(s) :: 17 | 3636 Clay St | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 771771 | 5997400.59946 | 2115444.59193 | 37.7884575935217 | -122.452828517416 | (37.7884575935217, -122.452828517416) | 11 | 6 | 1 | 54 | 31 | |||||
91308 | 107509 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 240 PIXLEY ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002182.3 | 2118985.3 | 37.7984523071777 | -122.436538140501 | (37.7984523071777, -122.436538140501) | 13 | 9 | 1 | 57 | 17 | ||||||
91615 | 95952 | Undocumented 4 | Tree(s) :: 17 | 46 Bosworth St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 1x1 | 6004452 | 2095346 | 37.7336731880288 | -122.426999715945 | (37.7336731880288, -122.426999715945) | 2 | 7 | 5 | 28861 | 25 | ||||
92882 | 110101 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1348 Douglass St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | 3x3 | Permit Number 774671 | 6001379 | 2099692 | 37.7454320431231 | -122.437935141467 | (37.7454320431231, -122.437935141467) | 2 | 4 | 5 | 63 | 22 | |||
95413 | 106022 | Undocumented 4 | Photinia fraseri :: Photinia: Chinese photinia 166 | 181 Buena Vista Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 771765 | 6001436.7 | 2108377.5 | 37.7692836023561 | -122.438357764726 | (37.7692836023561, -122.438357764726) | 15 | 5 | 5 | 29492 | 9 | |||||
98050 | 110259 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 655 SANCHEZ ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003729.2 | 2104438 | 37.7585968119418 | -122.430147043342 | (37.7585968119418, -122.430147043342) | 2 | 4 | 5 | 28862 | 3 | |||||
98463 | 107295 | Undocumented 4 | Tree(s) :: 17 | 218 Howth St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2014 12:00:00 AM | Permit Number 773357 | 5997350.11104 | 2090721.936 | 37.7205724606378 | -122.451219539387 | (37.7205724606378, -122.451219539387) | 9 | 8 | 6 | 28861 | 24 | ||||
99018 | 106237 | Undocumented 4 | Tree(s) :: 17 | 607 BRUSSELS ST | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010922.6 | 2091903.6 | 37.724584840414 | -122.404386617586 | (37.724584840414, -122.404386617586) | 10 | 3 | 7 | 309 | 28 | ||||||
100310 | 110968 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2411 WASHINGTON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x6 | 6003071 | 2116473 | 37.7916046396744 | -122.433283354559 | (37.7916046396744, -122.433283354559) | 13 | 9 | 1 | 29490 | 27 | ||||
100355 | 103264 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 1660 NORTH POINT ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 6002814 | 2121000 | 37.8040200224121 | -122.434496394017 | (37.8040200224121, -122.434496394017) | 13 | 9 | 1 | 57 | 17 | |||||
101116 | 107368 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 660 OFARRELL ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008096 | 2114145 | 37.7854963051764 | -122.415731945695 | (37.7854963051764, -122.415731945695) | 13 | 10 | 9 | 28858 | 36 | ||||||
104393 | 112422 | Undocumented 4 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard | Tree | Private 2 | 07/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775772 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.438398959733 | (37.7402178594385, -122.438398959733) | 2 | 7 | 5 | 63 | 7 | ||
104437 | 106758 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 445 Grafton Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | Permit Number 772911 | 5995409.1 | 2090523.2 | 37.7199154518997 | -122.457914582927 | (37.7199154518997, -122.457914582927) | 9 | 8 | 6 | 28861 | 24 | ||||
107867 | 105219 | Undocumented 4 | Tree(s) :: 17 | 1799X 26TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988124 | 2103397 | 37.7548423040305 | -122.484039888389 | (37.7548423040305, -122.484039888389) | 1 | 8 | 3 | 56 | 35 | |||||
111235 | 107371 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 448 BROADWAY | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011394.4 | 2118786.8 | 37.798426445485 | -122.404647279275 | (37.798426445485, -122.404647279275) | 3 | 1 | 10 | 308 | 23 | ||||
111371 | 255520 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 77 Belgrave Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 781419 | 5998149.61527 | 2104897.27011 | 37.7595402565853 | -122.449476776674 | (37.7595402565853, -122.449476776674) | 15 | 5 | 11 | 28862 | 12 | ||||
111710 | 107283 | Undocumented 4 | Tree(s) :: 17 | 4214 26TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002441.8 | 2100664.9 | 37.7481637783896 | -122.434329697409 | (37.7481637783896, -122.434329697409) | 2 | 4 | 5 | 28862 | 22 | ||||||
112578 | 112394 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2 AMAZON AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6000472 | 2089324 | 37.7169122992795 | -122.440327982322 | (37.7169122992795, -122.440327982322) | 9 | 7 | 6 | 28861 | 5 | ||||
112679 | 106961 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 325 DWIGHT ST | Sidewalk: Curb side : Yard | Tree | Private 2 | 6010604 | 2091349 | 37.7230442144558 | -122.405448941518 | (37.7230442144558, -122.405448941518) | 10 | 3 | 7 | 309 | 28 | ||||||
112972 | 88538 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1306 York St | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x12 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367022 | (37.7511299031436, -122.40816367022) | 2 | 4 | 7 | 28859 | 19 | |||
113514 | 109631 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 390 BUCKINGHAM WAY | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x9 | 5989374 | 2093588 | 37.7279820381776 | -122.478999652651 | (37.7279820381776, -122.478999652651) | 1 | 8 | 4 | 64 | 14 | |||||
114368 | 104686 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 140 26TH AVE | Front Yard : Cutout | Tree | Private 2 | 22 | 4x4 | 5987812.9 | 2115041.6 | 37.786797021543 | -122.485970438221 | (37.786797021543, -122.485970438221) | 11 | 6 | 1 | 55 | 33 | ||||
117007 | 115060 | Undocumented 4 | Betula pendula :: European White Birch 253 | 26 CRESCENT AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6005316 | 2095906 | 37.735259640844 | -122.424052422112 | (37.735259640844, -122.424052422112) | 2 | 7 | 7 | 28859 | 2 | ||||
117938 | 105930 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 971 Florida St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009455 | 2103552.4 | 37.7564877890416 | -122.410282026926 | (37.7564877890416, -122.410282026926) | 2 | 4 | 7 | 28859 | 19 | |||||
118552 | 110612 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 15 MAGELLAN AVE | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775412 | 5994586 | 2101167 | 37.7490933856104 | -122.461530994698 | (37.7490933856104, -122.461530994698) | 1 | 8 | 4 | 29491 | 40 | ||
119382 | 112588 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 TEHAMA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009004 | 2110266 | 37.7748964951756 | -122.41231625471 | (37.7748964951756, -122.41231625471) | 8 | 2 | 9 | 28853 | 34 | |||||
119429 | 121764 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |||||
120937 | 109516 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 105 MIDCREST WAY | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 12x12 | 5998180.4 | 2101012.8 | 37.7488762246558 | -122.4490904711 | (37.7488762246558, -122.4490904711) | 1 | 5 | 4 | 63 | 38 | ||||
121061 | 107631 | Undocumented 4 | :: 45 | 4059 26th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003507 | 2100669 | 37.7482354401484 | -122.430646564887 | (37.7482354401484, -122.430646564887) | 2 | 4 | 5 | 63 | 22 | ||||||
124884 | 104764 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1855 08TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x4 | Permit Number 770861 | 5993717.5 | 2102872.4 | 37.7537259496496 | -122.464658073456 | (37.7537259496496, -122.464658073456) | 1 | 8 | 4 | 56 | 12 | |||
127070 | 254844 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 475 Arkansas St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 6013011 | 2104854 | 37.7602603887437 | -122.398075345371 | (37.7602603887437, -122.398075345371) | 10 | 3 | 8 | 28856 | 29 | ||
127413 | 99743 | Undocumented 4 | Tree(s) :: 17 | 447 Clipper St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002285 | 2100894 | 37.7487839315189 | -122.43488828753 | (37.7487839315189, -122.43488828753) | 2 | 4 | 5 | 28862 | 22 | ||||||
127808 | 113438 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 180x LOWER TER | Median : Yard | Tree | Private 2 | 22 | 3x3 | 6000120 | 2106246 | 37.7633560547765 | -122.44275907578 | (37.7633560547765, -122.44275907578) | 15 | 5 | 5 | 28862 | 3 | ||||
127951 | 106236 | Undocumented 4 | Tree(s) :: 17 | 921 DWIGHT ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008890 | 2090823.6 | 37.721505591324 | -122.411336818418 | (37.721505591324, -122.411336818418) | 9 | 3 | 7 | 309 | 28 | ||||||
130088 | 100868 | Undocumented 4 | Tree(s) :: 17 | 655 03rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014591.2 | 2111956.1 | 37.7798490696224 | -122.393107079978 | (37.7798490696224, -122.393107079978) | 6 | 2 | 9 | 28856 | 6 | |||||
130833 | 106685 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 100 Yukon St | Front Yard : Cutout | Tree | Private 2 | Permit Number 772768 | 6000197.4 | 2104288 | 37.757984281634 | -122.442350801363 | (37.757984281634, -122.442350801363) | 2 | 4 | 5 | 28862 | 3 | |||||
131215 | 104942 | Undocumented 4 | Tree(s) :: 17 | 840X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/11/2014 12:00:00 AM | 3 | Permit Number 770723 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||
132903 | 255181 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1176x Ingalls St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017715 | 2093956 | 37.7305975684905 | -122.381048555108 | (37.7305975684905, -122.381048555108) | 10 | 3 | 8 | 58 | 1 | |||||
134080 | 114044 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 549X ARLINGTON ST | Median : Cutout | Tree | Private 2 | 70 | 6003400 | 2095634 | 37.7344044281823 | -122.430657330781 | (37.7344044281823, -122.430657330781) | 2 | 7 | 5 | 63 | 7 | |||||
134751 | 121762 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |||||
135057 | 114039 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1328 TREAT WAY | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6008689 | 2100921 | 37.7492195885474 | -122.412745111821 | (37.7492195885474, -122.412745111821) | 2 | 4 | 7 | 28859 | 19 | ||||
135459 | 106967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1225 02ND AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995419.1 | 2107212.6 | 37.7657409782079 | -122.459087842629 | (37.7657409782079, -122.459087842629) | 15 | 5 | 11 | 56 | 12 | ||||||
141479 | 112010 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 115 Red Rock Way | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | 2 | 7 | 5 | 63 | 22 | |||||
142853 | 107503 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4140 19th Ave | Back Yard : Yard | Tree | Private 2 | 5992157.71887 | 2088336.37745 | 37.7137236301705 | -122.46899431666 | (37.7137236301705, -122.46899431666) | 9 | 8 | 6 | 64 | 24 | ||||||
145199 | 110197 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 3965 SACRAMENTO ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995791.8 | 2114806.4 | 37.7866129696327 | -122.458348463038 | (37.7866129696327, -122.458348463038) | 11 | 6 | 1 | 54 | 31 | |||||
145350 | 107354 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 34 Princeton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2014 12:00:00 AM | Permit Number 773911 | 6007504.47131 | 2093847.45075 | 37.7297306299075 | -122.41634029479 | (37.7297306299075, -122.41634029479) | 9 | 3 | 7 | 309 | 28 | ||||
147509 | 105514 | Undocumented 4 | Tree(s) :: 17 | 4004 20TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003604.3 | 2104237.3 | 37.7580386626716 | -122.430564683072 | (37.7580386626716, -122.430564683072) | 2 | 4 | 5 | 28862 | 3 | |||||
148155 | 107599 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 177 CORBETT AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6000269.8 | 2105595.5 | 37.7615784812961 | -122.442194269292 | (37.7615784812961, -122.442194269292) | 15 | 5 | 5 | 28862 | 3 | ||||||
148408 | 106044 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 415 DEWEY BLVD | Sidewalk: Curb side : Yard | Tree | Private 2 | 5995172.1 | 2100351 | 37.7468865723154 | -122.459445180048 | (37.7468865723154, -122.459445180048) | 1 | 8 | 4 | 59 | 40 | ||||||
148762 | 104745 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 845 25TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4x4 | 5988152.6 | 2110221.5 | 37.7735821764225 | -122.484441503692 | (37.7735821764225, -122.484441503692) | 11 | 6 | 2 | 55 | 26 | ||||
148822 | 107196 | Undocumented 4 | Tree(s) :: 17 | 3359 21st St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x8 | 6005949 | 2103729 | 37.7567755383179 | -122.422419582476 | (37.7567755383179, -122.422419582476) | 2 | 4 | 5 | 28859 | 19 | |||||
149412 | 107468 | Undocumented 4 | Tree(s) :: 17 | 479 SANCHEZ ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003670.2 | 2105503.2 | 37.7615182547925 | -122.430427093318 | (37.7615182547925, -122.430427093318) | 8 | 4 | 5 | 28862 | 3 | ||||||
151200 | 119244 | Undocumented 4 | :: 45 | 311 30th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2016 12:00:00 AM | 3 | 3x3 | 6004402 | 2098353 | 37.7419269008751 | -122.427386718491 | (37.7419269008751, -122.427386718491) | 2 | 7 | 5 | 63 | 7 | |||
151938 | 104939 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 109X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | 1 | 8 | 4 | 64 | 14 | ||||||
152104 | 113148 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 470X BEACON ST | Sidewalk: Property side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002259 | 2098542 | 37.7423244157255 | -122.434810022855 | (37.7423244157255, -122.434810022855) | 2 | 7 | 5 | 63 | 7 | ||||
154012 | 112004 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 115 Red Rock Way | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | 2 | 7 | 5 | 63 | 22 | |||||
154039 | 107119 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 41 Elsie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2014 12:00:00 AM | 3x3 | Permit Number 773430 | 6007557.36556 | 2099188.16218 | 37.7443980238935 | -122.416535600799 | (37.7443980238935, -122.416535600799) | 2 | 7 | 7 | 28859 | 2 | |||
154139 | 106709 | Undocumented 4 | Aesculus hippocastanum :: White Horsechestnut 190 | 1027 Florida St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2014 12:00:00 AM | 3X3 | Permit Number 772684 | 6009474.8 | 2103180.3 | 37.7554671959872 | -122.410187281194 | (37.7554671959872, -122.410187281194) | 2 | 4 | 7 | 28859 | 19 | |||
154719 | 104817 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3170 BALBOA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5985841 | 2111127 | 37.7759335444794 | -122.492504259099 | (37.7759335444794, -122.492504259099) | 11 | 6 | 2 | 55 | 26 | ||||
156467 | 109326 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1624 VALLEJO ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005582.1 | 2118270.7 | 37.7966828044962 | -122.424722909098 | (37.7966828044962, -122.424722909098) | 13 | 9 | 1 | 57 | 17 | |||||
157016 | 107476 | Undocumented 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 69 Mirabel Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2014 12:00:00 AM | 3 | 10x6 | Permit Number 773500 | 6007782.91071 | 2100032.55813 | 37.7467292283859 | -122.415815490129 | (37.7467292283859, -122.415815490129) | 2 | 7 | 7 | 28859 | 2 | ||
157112 | 256075 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 1919 Jennings St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015778 | 2093027 | 37.7279396111572 | -122.387680322808 | (37.7279396111572, -122.387680322808) | 10 | 3 | 8 | 58 | 1 | |||||
157484 | 105210 | Undocumented 4 | Tree(s) :: 17 | 2467 38TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x3 | 5984528 | 2098448 | 37.7410436924745 | -122.496110565766 | (37.7410436924745, -122.496110565766) | 1 | 8 | 3 | 29491 | 35 | |||||
158139 | 112006 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 115 Red Rock Way | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | 2 | 7 | 5 | 63 | 22 | |||||
158298 | 107212 | Undocumented 4 | Tree(s) :: 17 | 556 NATOMA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009971.5 | 2111821.4 | 37.7792215026621 | -122.4090792269 | (37.7792215026621, -122.4090792269) | 14 | 2 | 9 | 28853 | 34 | |||||
159886 | 255452 | Undocumented 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1300 25th St | Side Yard : Yard | Tree | Private 2 | 3x3 | 6014722 | 2102062 | 37.7526893042179 | -122.391962509783 | (37.7526893042179, -122.391962509783) | 10 | 3 | 8 | 28856 | 29 | |||||
160970 | 107168 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 65 SCOTT ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6002336.3 | 2108640.7 | 37.7700574118158 | -122.435264926513 | (37.7700574118158, -122.435264926513) | 15 | 5 | 5 | 29492 | 9 | |||||
163788 | 105008 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1957 - 1959 15TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2014 12:00:00 AM | 11 | 3x3 | Permit Number 771758 | 6004438.4 | 2107144.3 | 37.7660678085542 | -122.427887146988 | (37.7660678085542, -122.427887146988) | 8 | 4 | 5 | 28862 | 3 | ||
164159 | 108025 | Undocumented 4 | Tree(s) :: 17 | 250 Duncan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004900 | 2099907 | 37.7462219824614 | -122.425775379215 | (37.7462219824614, -122.425775379215) | 2 | 7 | 5 | 63 | 22 | |||||
164435 | 105521 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1787 32ND AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5986257.6 | 2103091.7 | 37.7538951964507 | -122.490471869912 | (37.7538951964507, -122.490471869912) | 1 | 8 | 3 | 56 | 35 | ||||
165624 | 106158 | Undocumented 4 | Ulmus spp :: Elm Spp 98 | 450 MAGELLAN AVE | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6x6 | 5993514.2 | 2099497.2 | 37.7444467889139 | -122.465115996043 | (37.7444467889139, -122.465115996043) | 1 | 8 | 4 | 29491 | 40 | ||||
167509 | 104990 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1931 21ST AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5989677.9 | 2102204.3 | 37.7516578107149 | -122.478578913714 | (37.7516578107149, -122.478578913714) | 1 | 8 | 3 | 29491 | 35 | ||||
167631 | 112904 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 727 BURNETT AVE | Back Yard : Yard | Tree | Private 2 | 3x3 | 5999303 | 2101616 | 37.750596607185 | -122.44525189688 | (37.750596607185, -122.44525189688) | 2 | 5 | 5 | 63 | 38 | |||||
169002 | 106507 | Undocumented 4 | Ceanothus thyrsiflorus :: Blueblossom Ceanothus 319 | 50 FANNING WAY | Front Yard : Yard | Tree | Private 2 | 5991716.2 | 2101233.1 | 37.7491092786828 | -122.471459514348 | (37.7491092786828, -122.471459514348) | 1 | 8 | 4 | 29491 | 12 | ||||||
169013 | 105767 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 245 RUTLEDGE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 3x3 | 6010031.3 | 2099465.2 | 37.7452975299559 | -122.40800074457 | (37.7452975299559, -122.40800074457) | 2 | 7 | 7 | 28859 | 2 | ||||
170218 | 112428 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2819 JACKSON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | 3x3 | 6000608 | 2116457 | 37.7914206746057 | -122.441804136035 | (37.7914206746057, -122.441804136035) | 13 | 6 | 1 | 29490 | 27 | ||||
170611 | 104729 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 250-252 FRANCISCO ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 5x5 | 6010061.3 | 2121325.4 | 37.805322217951 | -122.409439489572 | (37.805322217951, -122.409439489572) | 3 | 1 | 10 | 308 | 23 | ||||
170969 | 104893 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 233 Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | ||||||
172476 | 98706 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 353 UPPER TER | Unaccepted Street : Yard | Tree | Private 2 | 5999086.1 | 2105914.9 | 37.7623879420949 | -122.446311165521 | (37.7623879420949, -122.446311165521) | 15 | 5 | 5 | 29492 | 9 | ||||||
172539 | 104894 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 235 Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | ||||||
175635 | 106332 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 1160 MISSION ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2014 12:00:00 AM | 3x3 | Permit Number 778325 | 6009057.1 | 2111529.8 | 37.7783695713182 | -122.412221910581 | (37.7783695713182, -122.412221910581) | 8 | 2 | 9 | 28853 | 34 | |||
175909 | 111092 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 801 GONZALEZ DR | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/04/2015 12:00:00 AM | 2 | Permit Number 775593 | 5988333 | 2089769 | 37.7174355256527 | -122.48231868452 | (37.7174355256527, -122.48231868452) | 1 | 8 | 4 | 64 | 14 | |||
176501 | 104744 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 15 WAVERLY PL | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010745.5 | 2116998.1 | 37.7934788206973 | -122.406766557506 | (37.7934788206973, -122.406766557506) | 3 | 1 | 10 | 28857 | 4 | ||||
176607 | 106677 | Undocumented 4 | Tree(s) :: 17 | 2862 21ST ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009011 | 2103999 | 37.7576891530245 | -122.41184909914 | (37.7576891530245, -122.41184909914) | 2 | 4 | 7 | 28859 | 19 | ||||||
179557 | 115853 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 401x KANSAS ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011620 | 2106285 | 37.7641120222234 | -122.402986839965 | (37.7641120222234, -122.402986839965) | 8 | 3 | 8 | 28856 | 29 | |||||
179825 | 111997 | Undocumented 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 69 Divisadero St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2015 12:00:00 AM | 3 | 6x3 | Permit Number 775676 | 6001902.9 | 2108046.4 | 37.7684009894266 | -122.436721500778 | (37.7684009894266, -122.436721500778) | 15 | 5 | 5 | 29492 | 3 | ||
180499 | 110077 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4099x ALEMANY BLVD | Median : Cutout | Tree | Private 2 | 48 | 5991599 | 2086829 | 37.7095524384103 | -122.470815701049 | (37.7095524384103, -122.470815701049) | 9 | 8 | 4 | 64 | 24 | |||||
180663 | 106366 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 9 SEAL ROCK DR | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981833.1 | 2112945.4 | 37.7806911884837 | -122.506503269885 | (37.7806911884837, -122.506503269885) | 11 | 6 | 2 | 55 | 26 | ||||||
182747 | 256564 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 2501 California St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002352 | 2115365 | 37.7885215412843 | -122.435691777518 | (37.7885215412843, -122.435691777518) | 13 | 6 | 1 | 29490 | 27 | |||||
183946 | 112252 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 5301x DIAMOND HEIGHTS BLVD | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 3x3 | 6001927 | 2098732 | 37.7428272563398 | -122.435971568238 | (37.7428272563398, -122.435971568238) | 2 | 7 | 5 | 63 | 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) );