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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
125 | 125 | 119758 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 151X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
549 | 549 | 251321 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Monument Way | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | ||||||||||
1493 | 1493 | 103663 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
1620 | 1620 | 251543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard 17 | Tree 1 | Private 1 | |||||||||||
3007 | 3007 | 253279 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10x10 | ROW IS 10' tree is street tree | ||||||||
3239 | 3239 | 100549 | Undocumented 2 | Acer spp :: Maple 158 | 290X Tehama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x4 | ||||||||
3537 | 3537 | 102838 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
3610 | 3610 | 115725 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250X Octavia St | 2 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
4085 | 4085 | 101532 | Undocumented 2 | Tree(s) :: 17 | 11323 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
4222 | 4222 | 253622 | Undocumented 2 | Pittosporum spp :: Pittosporum spp 128 | 300x Naglee Ave | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
5598 | 5598 | 103666 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
6680 | 6680 | 112268 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
6704 | 6704 | 112269 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
7764 | 7764 | 103662 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
8408 | 8408 | 103664 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
9596 | 9596 | 102839 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1101X Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
9694 | 9694 | 173632 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3300X Market St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | ||||||||||
10149 | 10149 | 173884 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100X Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2017 12:00:00 AM | 3 | 3x3 | |||||||
10201 | 10201 | 173901 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4201x Lincoln Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x5 | |||||||||
10204 | 10204 | 173902 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
10665 | 10665 | 103665 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
10892 | 10892 | 112910 | Undocumented 2 | Tree(s) :: 17 | 1899X Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
10955 | 10955 | 109923 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 214 state st | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
10998 | 10998 | 112267 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
11273 | 11273 | 102842 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
11415 | 11415 | 103667 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
11778 | 11778 | 108180 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 835 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
12636 | 12636 | 99746 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
15743 | 15743 | 115724 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250x Octavia St | 1 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
16111 | 16111 | 102843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
16481 | 16481 | 112908 | Undocumented 2 | Tree(s) :: 17 | 1899X Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
16653 | 16653 | 100543 | Undocumented 2 | Acer spp :: Maple 158 | 290X Tehama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x4 | ||||||||
16896 | 16896 | 100001 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 501X 01st St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Address is 100 1st Street | |||||||||
17073 | 17073 | 112909 | Undocumented 2 | Tree(s) :: 17 | 1899X Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
18528 | 18528 | 120131 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 799x Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
20185 | 20185 | 120130 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 799x Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
185502 | 185502 | 122532 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1900X Castro St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | ||||||||||
169260 | 169260 | 177163 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 189 Velasco Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 6ft | 6007991.7614400005 | 2086069.6109099998 | 37.70840170934729 | -122.41410563508002 | (37.7084017093473, -122.41410563508) | |||
160891 | 160891 | 177329 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2610 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010501.25874 | 2086080.5894099998 | 37.708572487900895 | -122.405433245075 | (37.7085724879009, -122.405433245075) | |||
39571 | 39571 | 175574 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 262 Taber Pl | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6009969.129269999 | 2086111.4112900002 | 37.708627351035794 | -122.407274531388 | (37.7086273510358, -122.407274531388) | |||
51116 | 51116 | 179953 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Peabody St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6009701.772480001 | 2086128.1297 | 37.708658289510204 | -122.408199733244 | (37.7086582895102, -122.408199733244) | |||
157417 | 157417 | 175573 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 256 Taber Pl | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6009978.06824 | 2086136.62452 | 37.7086970817661 | -122.40724541316901 | (37.7086970817661, -122.407245413169) | |||
48575 | 48575 | 177328 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2610 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010526.80865 | 2086149.78348 | 37.708763909485796 | -122.405349810469 | (37.7087639094858, -122.405349810469) | |||
60822 | 60822 | 175987 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 170 Baltimore Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6002239.25029 | 2086152.9627200002 | 37.708305791247504 | -122.43399292266199 | (37.7083057912475, -122.433992922662) | |||
41818 | 41818 | 175988 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 170 Baltimore Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6002235.39507 | 2086153.26872 | 37.708306412667206 | -122.43400626858299 | (37.7083064126672, -122.434006268583) | |||
159960 | 159960 | 178246 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 334 Schwerin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 59 | Width 8ft | 6008498.73338 | 2086169.5102900001 | 37.7087044750874 | -122.412360530312 | (37.7087044750874, -122.412360530312) | |||
94141 | 94141 | 179594 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2115 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006118.53039 | 2086176.0114900002 | 37.7085884697411 | -122.420587301759 | (37.7085884697411, -122.420587301759) | |||
175340 | 175340 | 179595 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2109 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006095.08243 | 2086183.72557 | 37.7086083294779 | -122.420668888264 | (37.7086083294779, -122.420668888264) | |||
71336 | 71336 | 179596 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2101 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006079.302180001 | 2086189.0223299998 | 37.7086219838753 | -122.42072380268299 | (37.7086219838753, -122.420723802683) | |||
59888 | 59888 | 177028 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 164 Baltimore Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6002357.56159 | 2086195.5289200002 | 37.7084293823926 | -122.433587065817 | (37.7084293823926, -122.433587065817) | |||
151491 | 151491 | 176168 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 30 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 8ft | 6008416.5566300005 | 2086198.9199700002 | 37.7087806162127 | -122.412646622645 | (37.7087806162127, -122.412646622645) | |||
137871 | 137871 | 175986 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 164 Baltimore Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6002363.53933 | 2086199.02425 | 37.708439318980396 | -122.43356665568399 | (37.7084393189804, -122.433566655684) | |||
68299 | 68299 | 176169 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 30 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 8ft | 6008410.17529 | 2086203.98853 | 37.7087941752841 | -122.41266903556999 | (37.7087941752841, -122.41266903557) | |||
41727 | 41727 | 175985 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 160 Baltimore Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002380.953509999 | 2086206.35478 | 37.7084604350668 | -122.433506993768 | (37.7084604350668, -122.433506993768) | |||
50962 | 50962 | 179971 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 160 Baltimore Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6002384.15556 | 2086207.4195700001 | 37.708463540423104 | -122.43349600315001 | (37.7084635404231, -122.43349600315) | |||
66352 | 66352 | 176873 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 34 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008389.4363 | 2086207.95793 | 37.7088039104301 | -122.412740993025 | (37.7088039104301, -122.412740993025) | |||
151378 | 151378 | 177164 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 30 Kelloch Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6008391.56884 | 2086208.1675200001 | 37.708804605615896 | -122.41273363745701 | (37.7088046056159, -122.412733637457) | |||
161932 | 161932 | 72806 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 382 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 6 | 5999864.9815 | 2086214.70068 | 37.70834028115829 | -122.44220306922399 | (37.7083402811583, -122.442203069224) | ||
152396 | 152396 | 177857 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 435 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010447.87727 | 2086216.0665099998 | 37.7089414959281 | -122.40562727470501 | (37.7089414959281, -122.405627274705) | |||
171717 | 171717 | 176170 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 42 Kelloch Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6008360.10661 | 2086217.92738 | 37.7088296382394 | -122.41284306515499 | (37.7088296382394, -122.412843065155) | |||
176962 | 176962 | 175882 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008037.77895 | 2086218.44055 | 37.708812949517394 | -122.413957113834 | (37.7088129495174, -122.413957113834) | |||
179124 | 179124 | 175881 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 4 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6008040.46364 | 2086219.1455 | 37.7088150359462 | -122.413947884982 | (37.7088150359462, -122.413947884982) | |||
156719 | 156719 | 178517 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 328 Schwerin St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6008541.04755 | 2086224.10569 | 37.708856757315395 | -122.41221814244801 | (37.7088567573154, -122.412218142448) | |||
55394 | 55394 | 175880 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6008040.572369999 | 2086224.4613400002 | 37.7088296382554 | -122.413947884988 | (37.7088296382554, -122.413947884988) | |||
162521 | 162521 | 178554 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 575 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007838.70528 | 2086225.04271 | 37.7088198950039 | -122.414645608726 | (37.7088198950039, -122.414645608726) | |||
119122 | 119122 | 178548 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 328 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008543.60628 | 2086225.1928599998 | 37.7088598860379 | -122.412209375875 | (37.7088598860379, -122.412209375875) | |||
188869 | 188869 | 178549 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 42 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008341.68171 | 2086226.9900599997 | 37.7088534882771 | -122.412907384688 | (37.7088534882771, -122.412907384688) | |||
154303 | 154303 | 175879 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6008041.81725 | 2086229.374 | 37.708843197325 | -122.41394392978701 | (37.708843197325, -122.413943929787) | |||
60233 | 60233 | 176171 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 46 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 6ft | 6008338.63627 | 2086231.2816700002 | 37.708865101208204 | -122.412918213412 | (37.7088651012082, -122.412918213412) | |||
52100 | 52100 | 178508 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 575 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007843.72677 | 2086231.7813400002 | 37.708838680016704 | -122.414628730257 | (37.7088386800167, -122.414628730257) | |||
70441 | 70441 | 177856 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 435 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010405.93473 | 2086233.7709700002 | 37.7089877633386 | -122.405773481086 | (37.7089877633386, -122.405773481086) | |||
57129 | 57129 | 175878 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 140 Kelloch Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6008044.64173 | 2086236.91355 | 37.7088640580086 | -122.413934700952 | (37.7088640580086, -122.413934700952) | |||
183428 | 183428 | 177855 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 435 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010393.78556 | 2086237.29466 | 37.7089967592527 | -122.40581571863301 | (37.7089967592527, -122.405815718633) | |||
50693 | 50693 | 176103 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 50 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008313.99103 | 2086238.6229700001 | 37.7088838754685 | -122.413003909814 | (37.7088838754685, -122.413003909814) | |||
65025 | 65025 | 179986 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 818 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997558.28952 | 2086239.87811 | 37.708277679339 | -122.450177037641 | (37.708277679339, -122.450177037641) | |||
145728 | 145728 | 178555 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 580 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6007810.831590001 | 2086243.5160299998 | 37.708869052843 | -122.414743250798 | (37.708869052843, -122.414743250798) | |||
147503 | 147503 | 178547 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 322 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008553.87122 | 2086250.69527 | 37.7089304864164 | -122.412175699859 | (37.7089304864164, -122.412175699859) | |||
76451 | 76451 | 178516 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 322 Schwerin St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6008552.66413 | 2086251.2184400002 | 37.70893185520271 | -122.41217990870001 | (37.7089318552027, -122.4121799087) | |||
169985 | 169985 | 177495 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 818 Brunswick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997608.02587 | 2086258.36889 | 37.7083312969119 | -122.45000647583299 | (37.7083312969119, -122.450006475833) | |||
184172 | 184172 | 178271 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 3ft | 6009176.170940001 | 2086260.2904299998 | 37.7089917311415 | -122.41002561149901 | (37.7089917311415, -122.410025611499) | |||
179831 | 179831 | 178849 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 13 Liebig St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5995911.23484 | 2086261.34028 | 37.7082422172863 | -122.455870959398 | (37.7082422172863, -122.455870959398) | |||
32945 | 32945 | 178518 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 62 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008249.62715 | 2086262.35093 | 37.708945414261606 | -122.41322803793899 | (37.7089454142616, -122.413228037939) | |||
70516 | 70516 | 178550 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 62 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008247.372380001 | 2086262.5391799998 | 37.7089458045697 | -122.413235844076 | (37.7089458045697, -122.413235844076) | |||
176645 | 176645 | 178270 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6009167.93697 | 2086263.08528 | 37.7089989437285 | -122.41005426658701 | (37.7089989437285, -122.410054266587) | |||
30008 | 30008 | 178244 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 62 Tomaso Ct | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 8ft | 6009170.0421 | 2086265.24197 | 37.7090049835504 | -122.410047143074 | (37.7090049835504, -122.410047143074) | |||
168635 | 168635 | 177817 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009184.18934 | 2086265.3806200002 | 37.7090061571804 | -122.409998257729 | (37.7090061571804, -122.409998257729) | |||
132962 | 132962 | 175854 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 13 Liebig St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5995905.68343 | 2086266.21958 | 37.708255296101896 | -122.455890498056 | (37.7082552961019, -122.455890498056) | |||
37802 | 37802 | 178243 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 62 Tomaso Ct | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | Width 8ft | 6009152.06447 | 2086268.0035 | 37.7090115585089 | -122.410109471469 | (37.7090115585089, -122.410109471469) | |||
180452 | 180452 | 177816 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 60 Tomaso Ct | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 3ft | 6009147.33252 | 2086269.1354099999 | 37.7090144012735 | -122.41012590570601 | (37.7090144012735, -122.410125905706) | |||
132971 | 132971 | 178242 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 62 Tomaso Ct | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 8ft | 6009144.65272 | 2086270.07017 | 37.709016817728 | -122.41013523347401 | (37.709016817728, -122.410135233474) | |||
183568 | 183568 | 176102 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 62 Tomaso Ct | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 8ft | 6009173.04361 | 2086270.9274900001 | 37.709020763061396 | -122.41003717048099 | (37.7090207630614, -122.410037170481) | |||
62440 | 62440 | 178519 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 74 Kelloch Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6008207.90106 | 2086273.84024 | 37.7089746188665 | -122.413373061735 | (37.7089746188665, -122.413373061735) | |||
66895 | 66895 | 176112 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Tomaso Ct | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009187.4096 | 2086275.4475900002 | 37.7090339795175 | -122.409987838189 | (37.7090339795175, -122.409987838189) | |||
109852 | 109852 | 112633 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 800x BRUNSWICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5x6 | 5997602.0 | 2086276.0 | 37.70837936312 | -122.450028571713 | (37.70837936312, -122.450028571713) | |||
113003 | 113003 | 112634 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800x BRUNSWICK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x6 | 5997602.0 | 2086276.0 | 37.70837936312 | -122.450028571713 | (37.70837936312, -122.450028571713) | ||||
166145 | 166145 | 178551 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 74 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008208.8909599995 | 2086276.4009099999 | 37.70898170551929 | -122.413369821453 | (37.7089817055193, -122.413369821453) | |||
53016 | 53016 | 180001 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 62 Tomaso Ct | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 8ft | 6009181.15123 | 2086279.38185 | 37.709044431429604 | -122.41000974567899 | (37.7090444314296, -122.410009745679) | |||
164474 | 164474 | 177818 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009189.876619999 | 2086285.53025 | 37.7090618027185 | -122.409980023068 | (37.7090618027185, -122.409980023068) | |||
176642 | 176642 | 178078 | Undocumented 2 | Persea americana :: Avocado 113 | 230 Rhine St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5994079.51921 | 2086287.10063 | 37.7082076509257 | -122.46220339079399 | (37.7082076509257, -122.462203390794) | |||
55176 | 55176 | 178556 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 550 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6007824.59893 | 2086288.7583 | 37.708994052312 | -122.414698868372 | (37.708994052312, -122.414698868372) |
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");