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 | ||||||||||
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) | |||
156682 | 156682 | 175042 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 98 San Diego Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | 5992757.09235 | 2086323.81583 | 37.7082322293939 | -122.466776470378 | (37.7082322293939, -122.466776470378) | ||||
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) | |||
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) | |||
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) | |||
52762 | 52762 | 71598 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 126 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 9 | 5994743.91592 | 2086305.62835 | 37.70829675666771 | -122.45990852057301 | (37.7082967566677, -122.459908520573) | ||
62380 | 62380 | 176134 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 John Muir Dr | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5987222.73644 | 2086464.9299599999 | 37.7082987351809 | -122.48591391940901 | (37.7082987351809, -122.485913919409) | |||
48038 | 48038 | 176133 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 John Muir Dr | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5987205.94604 | 2086467.2590400001 | 37.708304151783295 | -122.48597211903099 | (37.7083041517833, -122.485972119031) | |||
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) | |||
160483 | 160483 | 176136 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 John Muir Dr | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 0ft | 5987247.74108 | 2086476.2363 | 37.7083312366754 | -122.48582833093599 | (37.7083312366754, -122.485828330936) | |||
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) | |||
35802 | 35802 | 71599 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 130 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994726.40181 | 2086320.41636 | 37.7083363538073 | -122.45997012143101 | (37.7083363538073, -122.459970121431) | ||
150864 | 150864 | 178273 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 98 San Diego Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5992768.65673 | 2086361.85687 | 37.708337348457896 | -122.46673926632499 | (37.7083373484579, -122.466739266325) | ||||
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) | ||
59353 | 59353 | 176135 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 John Muir Dr | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 0ft | 5987227.516530001 | 2086480.11804 | 37.7083407164149 | -122.485898513129 | (37.7083407164149, -122.485898513129) | |||
161785 | 161785 | 176137 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 John Muir Dr | 5 | : 4 | Tree 1 | Private 1 | 11 | Width 0ft | 5987255.345 | 2086484.45942 | 37.708354258405 | -122.485802654386 | (37.708354258405, -122.485802654386) | |||
137279 | 137279 | 73608 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 136 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 14 | 5994710.3414 | 2086333.6948099998 | 37.7083718896252 | -122.46002658894899 | (37.7083718896252, -122.460026588949) | ||
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) | ||||
24631 | 24631 | 176638 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 65 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993323.454919999 | 2086371.47099 | 37.7083957495352 | -122.46482253315399 | (37.7083957495352, -122.464822533154) | |||
27333 | 27333 | 180168 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5935 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996569.70599 | 2086304.01805 | 37.7083971704608 | -122.453598302421 | (37.7083971704608, -122.453598302421) | |||
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) | |||
159957 | 159957 | 71600 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 136 Wilson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994689.24707 | 2086354.8441299999 | 37.708428747449204 | -122.460101024051 | (37.7084287474492, -122.460101024051) | ||
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) | |||
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) | |||
63245 | 63245 | 71602 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 149 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994628.01123 | 2086360.41662 | 37.7084405258897 | -122.46031306439899 | (37.7084405258897, -122.460313064399) | ||
55464 | 55464 | 74182 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 138 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994679.00139 | 2086362.0842900001 | 37.7084480379267 | -122.46013695827 | (37.7084480379267, -122.46013695827) | ||
4188 | 4188 | 181057 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5931 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:33:00 PM | 3 | Width 3ft | 5996618.07355 | 2086323.26043 | 37.7084527782463 | -122.453432527712 | (37.7084527782463, -122.453432527712) | ||
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) | |||
65128 | 65128 | 73960 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 138 Wilson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994666.9696 | 2086372.6899 | 37.7084764663958 | -122.46017930913601 | (37.7084764663958, -122.460179309136) | ||
136095 | 136095 | 71601 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 138 Wilson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994653.0975 | 2086384.07363 | 37.708506925528795 | -122.46022807666401 | (37.7085069255288, -122.460228076664) | ||
131206 | 131206 | 179380 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 77 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5993077.06779 | 2086425.7469099998 | 37.7085305695939 | -122.46567800964199 | (37.7085305695939, -122.465678009642) | |||
162639 | 162639 | 177639 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5900 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 4ft | 5996554.50989 | 2086363.6080900002 | 37.708559919867895 | -122.45365512159799 | (37.7085599198679, -122.453655121598) | |||
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) | |||
77398 | 77398 | 106965 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 63 BELLE AVE | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991753.8 | 2086471.1 | 37.7085786821221 | -122.47025464516001 | (37.7085786821221, -122.47025464516) | ||||||
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) | |||
60858 | 60858 | 177640 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5900 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 4ft | 5996580.5488 | 2086374.8113099998 | 37.7085921740666 | -122.453565936738 | (37.7085921740666, -122.453565936738) | |||
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) | |||
1556 | 1556 | 251583 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 75 Rice St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995352.0 | 2086409.0 | 37.7086155444167 | -122.45781440192499 | (37.7086155444167, -122.457814401925) | |||||
72189 | 72189 | 178591 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 67 Belle Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5991713.92465 | 2086485.44715 | 37.70861577046671 | -122.470393502266 | (37.7086157704667, -122.470393502266) | |||
137765 | 137765 | 178592 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 67 Belle Ave | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5991724.32675 | 2086485.2281099998 | 37.7086157704725 | -122.470357535671 | (37.7086157704725, -122.470357535671) | |||
48697 | 48697 | 177826 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 89 Belle Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 5991639.3875 | 2086487.5926299999 | 37.708617351468895 | -122.47065126593999 | (37.7086173514689, -122.47065126594) | |||
154719 | 154719 | 178860 | Undocumented 2 | Prunus laurocerasus :: English laurel 227 | 89 Belle Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 5991691.410619999 | 2086487.07285 | 37.708618932476504 | -122.470471431226 | (37.7086189324765, -122.470471431226) | |||
132730 | 132730 | 71684 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 163 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994555.12862 | 2086427.38157 | 37.7086202032335 | -122.46056980286501 | (37.7086202032335, -122.460569802865) | ||
146626 | 146626 | 179832 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 89 Belle Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 5991610.51667 | 2086489.35195 | 37.708620512585895 | -122.470751174349 | (37.7086205125859, -122.470751174349) | |||
82512 | 82512 | 176641 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 89 Belle Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 5991622.07464 | 2086489.1085299999 | 37.708620512601705 | -122.47071121118 | (37.7086205126017, -122.47071121118) | |||
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) | |||
90824 | 90824 | 73959 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 75 Rice St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1995 12:00:00 AM | 4 | 2x4 | Permit Number 773591 | 5995358.56494273 | 2086411.36688337 | 37.7086224204841 | -122.457791883945 | (37.7086224204841, -122.457791883945) | |
146195 | 146195 | 71596 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 75 Rice St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1995 12:00:00 AM | 12 | 2x3 | 5995358.56494273 | 2086411.36688337 | 37.7086224204841 | -122.457791883945 | (37.7086224204841, -122.457791883945) | ||
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) | |||
152808 | 152808 | 180169 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5921 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996782.55272 | 2086390.1360799999 | 37.7086458303022 | -122.45286889471001 | (37.7086458303022, -122.45286889471) | |||
179770 | 179770 | 71586 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 121 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 9 | 5994945.16185 | 2086428.98532 | 37.7086470380903 | -122.459221923276 | (37.7086470380903, -122.459221923276) | ||
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) | |||
57495 | 57495 | 71603 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 171 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994523.67906 | 2086453.64687 | 37.708690512219206 | -122.460680397897 | (37.7086905122192, -122.460680397897) | ||
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) | |||
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) | |||
134907 | 134907 | 176619 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 375 Hanover St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 5999272.06122 | 2086368.18274 | 37.7087278988324 | -122.444263284724 | (37.7087278988324, -122.444263284724) | |||
170302 | 170302 | 71651 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 177 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994505.19973 | 2086471.6739 | 37.7087389470079 | -122.46074556997101 | (37.7087389470079, -122.460745569971) | ||
11387 | 11387 | 104350 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 349 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5999840.77458 | 2086361.4281900001 | 37.708741782568104 | -122.44229725703 | (37.7087417825681, -122.44229725703) | |||
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) | |||
68899 | 68899 | 71587 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 129 Goethe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994891.94658 | 2086476.6908099998 | 37.7087749666595 | -122.459409293405 | (37.7087749666595, -122.459409293405) |
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");