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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
48986 | 48986 | 131800 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3646 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5999162.81759 | 2121382.5362400003 | 37.8048624264288 | -122.44715905583901 | (37.8048624264288, -122.447159055839) | |||
40409 | 40409 | 130495 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3636 Baker St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5999167.03977 | 2121341.8360099997 | 37.804750915876 | -122.44714151369 | (37.804750915876, -122.44714151369) | |||
112514 | 112514 | 41178 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1636 Beach St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/12/2008 12:00:00 AM | 3x3 | Permit Number 50261 | 6002352.98833886 | 2121268.85344667 | 37.80473204272371 | -122.436111004538 | (37.8047320427237, -122.436111004538) | ||
166686 | 166686 | 130493 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3636 Baker St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5999170.74175 | 2121320.42041 | 37.8046923259617 | -122.447127160497 | (37.8046923259617, -122.447127160497) | |||
171929 | 171929 | 143282 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1919 GRANT AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 6010347.0196 | 2121086.0019 | 37.8046808948511 | -122.408433818682 | (37.8046808948511, -122.408433818682) | |||
33910 | 33910 | 131087 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3626 Lyon St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5998871.85834 | 2121254.17538 | 37.8044933536415 | -122.448156698972 | (37.8044933536415, -122.448156698972) | |||
74237 | 74237 | 131849 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3601 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 5999142.98862 | 2121202.5970099997 | 37.804367229113396 | -122.447214717591 | (37.8043672291134, -122.447214717591) | |||
50235 | 50235 | 131850 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3601 Baker St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 5999143.57978 | 2121190.63067 | 37.8043344065648 | -122.447211810097 | (37.8043344065648, -122.447211810097) | |||
186863 | 186863 | 131851 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3601 Baker St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 5999147.80126 | 2121174.2853 | 37.8042897678153 | -122.447196024289 | (37.8042897678153, -122.447196024289) | |||
65528 | 65528 | 132163 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 150 Lombard St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 6011528.08163 | 2120803.5748799997 | 37.8039714887622 | -122.40432672370399 | (37.8039714887622, -122.404326723704) | |||
39232 | 39232 | 132164 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 150 Lombard St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 6011515.19186 | 2120799.8495099996 | 37.8039605395195 | -122.404371067467 | (37.8039605395195, -122.404371067467) | |||
163130 | 163130 | 126790 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3544 Baker St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5999208.90607 | 2121045.78714 | 37.803940437864 | -122.44697531446998 | (37.803940437864, -122.44697531447) | |||
26899 | 26899 | 126789 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3544 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5999210.07801 | 2121038.76235 | 37.8039212166464 | -122.446970753095 | (37.8039212166464, -122.446970753095) | |||
20076 | 20076 | 98360 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 807 Francisco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Permit Number 768654 | 6007370.5 | 2120864.5 | 37.8039055703948 | -122.418718664572 | (37.8039055703948, -122.418718664572) | ||||
76706 | 76706 | 126788 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3544 Baker St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5999213.04425 | 2121022.9498099997 | 37.803877969155295 | -122.44695934970301 | (37.8038779691553, -122.446959349703) | |||
152876 | 152876 | 136783 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1739 North Point St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6002414.55619 | 2120883.51152 | 37.80367749317671 | -122.435870354529 | (37.8036774931767, -122.435870354529) | |||
49563 | 49563 | 127109 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1751 North Point St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 6002382.406280001 | 2120876.71316 | 37.8036570003292 | -122.435981124049 | (37.8036570003292, -122.435981124049) | |||
178910 | 178910 | 127108 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1751 North Point St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 3ft | 6002363.1671400005 | 2120875.0896799997 | 37.803651449711104 | -122.436047585732 | (37.8036514497111, -122.436047585732) | |||
157917 | 157917 | 136767 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3520 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5999224.40422 | 2120935.42639 | 37.8036383025204 | -122.44691373607799 | (37.8036383025204, -122.446913736078) | |||
57993 | 57993 | 127107 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1763 North Point St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6002331.82998 | 2120869.8297 | 37.8036352268581 | -122.436155652762 | (37.8036352268581, -122.436155652762) | |||
58487 | 58487 | 136766 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3520 Baker St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5999225.95627 | 2120925.5493900003 | 37.8036112716175 | -122.44690765398799 | (37.8036112716175, -122.446907653988) | |||
58027 | 58027 | 143033 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 LOMBARD ST | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6010849.0879 | 2120667.4053 | 37.803559635028 | -122.40666683581001 | (37.803559635028, -122.40666683581) | |||
48587 | 48587 | 131797 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3510 Baker St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5999228.200069999 | 2120906.6891 | 37.8035596145482 | -122.446898531266 | (37.8035596145482, -122.446898531266) | |||
34948 | 34948 | 143032 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 LOMBARD ST | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 6010840.9204 | 2120666.3163 | 37.8035561879378 | -122.40669502317199 | (37.8035561879378, -122.406695023172) | |||
188332 | 188332 | 143031 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 LOMBARD ST | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6010830.5748 | 2120664.6828 | 37.8035511239121 | -122.406730709589 | (37.8035511239121, -122.406730709589) | |||
148282 | 148282 | 143030 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 LOMBARD ST | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 6010819.1403 | 2120662.5048 | 37.8035445038868 | -122.40677012581001 | (37.8035445038868, -122.40677012581) | |||
172808 | 172808 | 143029 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 LOMBARD ST | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 0ft | 6010799.5382 | 2120661.4158 | 37.80354041697021 | -122.406837883311 | (37.8035404169702, -122.406837883311) | |||
55939 | 55939 | 143028 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 LOMBARD ST | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 6010783.2032 | 2120659.2378 | 37.8035335227011 | -122.406894258002 | (37.8035335227011, -122.406894258002) | |||
129667 | 129667 | 143027 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 LOMBARD ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 6010772.8577 | 2120657.0598 | 37.80352696355779 | -122.40692990564699 | (37.8035269635578, -122.406929905647) | |||
151993 | 151993 | 136531 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2200 Beach St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5999585.07501 | 2120878.20565 | 37.8035017881435 | -122.445661503881 | (37.8035017881435, -122.445661503881) | |||
83741 | 83741 | 130600 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2220 Beach St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5999571.11438 | 2120878.32333 | 37.8035013142 | -122.445709823545 | (37.8035013142, -122.445709823545) | |||
67691 | 67691 | 130601 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2220 Beach St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5999556.85937 | 2120873.79549 | 37.803488068083794 | -122.44575882763 | (37.8034880680838, -122.44575882763) | |||
53774 | 53774 | 129486 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6012297.60436 | 2120565.6201 | 37.803361093695 | -122.40164698862199 | (37.803361093695, -122.401646988622) | ||||
30356 | 30356 | 131206 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 12 Greenwich St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6012268.92363 | 2120560.78169 | 37.8033462081302 | -122.401745899659 | (37.8033462081302, -122.401745899659) | ||||
187326 | 187326 | 131207 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 12 Greenwich St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6012263.47251 | 2120560.44048 | 37.803344967053 | -122.40176473957399 | (37.803344967053, -122.401764739574) | ||||
166033 | 166033 | 129485 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012301.33061 | 2120559.21941 | 37.803343726885 | -122.40163364357099 | (37.803343726885, -122.401633643571) | ||||
155029 | 155029 | 132204 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 12 Greenwich St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 6012294.06984 | 2120559.14097 | 37.803343106346794 | -122.40165876436501 | (37.8033431063468, -122.401658764365) | ||||
55849 | 55849 | 131205 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 12 Greenwich St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6012278.60501 | 2120557.19628 | 37.803336903723796 | -122.401712144524 | (37.8033369037238, -122.401712144524) | ||||
43545 | 43545 | 129484 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6012303.2887699995 | 2120555.11364 | 37.8033325627054 | -122.401626578498 | (37.8033325627054, -122.401626578498) | ||||
160154 | 160154 | 131208 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 12 Greenwich St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6012252.03872 | 2120555.92923 | 37.803331942189395 | -122.401803989565 | (37.8033319421894, -122.401803989565) | ||||
77249 | 77249 | 131209 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 12 Greenwich St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 6012245.65295 | 2120554.2516900003 | 37.80332697970589 | -122.401825969894 | (37.8033269797059, -122.401825969894) | ||||
186348 | 186348 | 129483 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6012307.75016 | 2120551.4086599997 | 37.8033226386787 | -122.401610879045 | (37.8033226386787, -122.401610879045) | ||||
166697 | 166697 | 136434 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 12 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6012298.4076 | 2120549.33954 | 37.8033164360554 | -122.401643063984 | (37.8033164360554, -122.401643063984) | ||||
187393 | 187393 | 132205 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 12 Greenwich St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6012257.5514 | 2120548.1369 | 37.8033108539845 | -122.401784364564 | (37.8033108539845, -122.401784364564) | ||||
176379 | 176379 | 129482 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6012315.37501 | 2120537.75286 | 37.803285568636 | -122.401583532467 | (37.803285568636, -122.401583532467) | ||||
175563 | 175563 | 129481 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Greenwich St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6012317.54236 | 2120532.7765200003 | 37.8032720257522 | -122.401575682271 | (37.8032720257522, -122.401575682271) | ||||
156001 | 156001 | 124819 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2299 Beach St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5999280.13249 | 2120792.1869200002 | 37.803248189218 | -122.44671057385901 | (37.803248189218, -122.446710573859) | |||
171814 | 171814 | 129480 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Greenwich St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6012320.77236 | 2120522.45554 | 37.8032438670795 | -122.401563778859 | (37.8032438670795, -122.401563778859) | ||||
154989 | 154989 | 136018 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Greenwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6012250.392990001 | 2120519.5939 | 37.8032320823636 | -122.401807129095 | (37.8032320823636, -122.401807129095) | ||||
56051 | 56051 | 136019 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Greenwich St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012283.42018 | 2120515.08235 | 37.803221537807204 | -122.401692519489 | (37.8032215378072, -122.401692519489) | ||||
155494 | 155494 | 131796 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3460 Baker St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5999247.61713 | 2120773.49431 | 37.8031950069149 | -122.446821748024 | (37.8031950069149, -122.446821748024) | |||
182176 | 182176 | 131795 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3460 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5999250.6254900005 | 2120749.14861 | 37.8031283320577 | -122.446809584704 | (37.8031283320577, -122.446809584704) | |||
70586 | 70586 | 249867 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 230 Greenwich St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 0ft | 6011726.07393 | 2120469.26255 | 37.8030646105966 | -122.403618018374 | (37.8030646105966, -122.403618018374) | |||
131669 | 131669 | 249870 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 230 Greenwich St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 6011716.19315 | 2120469.03614 | 37.803063436992105 | -122.403652195296 | (37.8030634369921, -122.403652195296) | |||
133692 | 133692 | 249871 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 230 Greenwich St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6011715.31721 | 2120468.19877 | 37.8030610888482 | -122.40365516757099 | (37.8030610888482, -122.403655167571) | |||
26255 | 26255 | 249868 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 230 Greenwich St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 6011723.02594 | 2120467.18676 | 37.803058740725 | -122.403628419935 | (37.803058740725, -122.403628419935) | |||
188898 | 188898 | 131794 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3456 Baker St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5999255.89477 | 2120717.3179 | 37.8030412345399 | -122.446789058571 | (37.8030412345399, -122.446789058571) | |||
172422 | 172422 | 249869 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 230 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 6011727.52121 | 2120455.9779 | 37.8030282150334 | -122.403612074753 | (37.8030282150334, -122.403612074753) | |||
62349 | 62349 | 131793 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3456 Baker St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5999257.06785 | 2120699.792 | 37.8029931801649 | -122.446783737307 | (37.8029931801649, -122.446783737307) | |||
174450 | 174450 | 133680 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3301 Laguna St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 5ft | 6003615.46517 | 2120605.5540400003 | 37.8029824395391 | -122.43169469167 | (37.8029824395391, -122.43169469167) | |||
185203 | 185203 | 133681 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3301 Laguna St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 5ft | 6003622.3030199995 | 2120535.90565 | 37.8027915908132 | -122.43166605363899 | (37.8027915908132, -122.431666053639) | |||
164238 | 164238 | 124813 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3434 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5999267.3425900005 | 2120623.4473599996 | 37.802784145342 | -122.446742685044 | (37.802784145342, -122.446742685044) | |||
181060 | 181060 | 124812 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3434 Baker St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5999269.00527 | 2120608.3176700003 | 37.8027426982766 | -122.44673584208401 | (37.8027426982766, -122.446735842084) | |||
73929 | 73929 | 124811 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3420 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5999272.70884 | 2120585.7075400003 | 37.8026808285249 | -122.44672139809799 | (37.8026808285249, -122.446721398098) | |||
158845 | 158845 | 133682 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3301 Laguna St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 5ft | 6003631.491909999 | 2120480.79086 | 37.802640780810705 | -122.431630318206 | (37.8026407808107, -122.431630318206) | |||
150525 | 150525 | 143095 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 483 Greenwich St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6010551.3522 | 2120281.1845 | 37.8024825054705 | -122.407669920622 | (37.8024825054705, -122.407669920622) | |||
28469 | 28469 | 133683 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3301 Laguna St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 6003639.65716 | 2120421.26895 | 37.8024778119699 | -122.431597810397 | (37.8024778119699, -122.431597810397) | |||
180945 | 180945 | 143094 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 483 Greenwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 6010536.1149 | 2120279.3375 | 37.802476581095796 | -122.407722519182 | (37.8024765810958, -122.407722519182) | |||
24939 | 24939 | 143093 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 487 Greenwich St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 6010518.569 | 2120277.0289 | 37.8024692600192 | -122.407783074103 | (37.8024692600192, -122.407783074103) | |||
64529 | 64529 | 129477 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6012514.7758 | 2120236.23138 | 37.8024687881724 | -122.40087229823901 | (37.8024687881724, -122.400872298239) | ||||
39739 | 39739 | 129479 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Filbert St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012506.1322099995 | 2120230.97584 | 37.8024538756 | -122.400901840066 | (37.8024538756, -122.400901840066) | ||||
152532 | 152532 | 129478 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Filbert St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6012509.68294 | 2120230.66756 | 37.80245322719529 | -122.400889531035 | (37.8024532271953, -122.400889531035) | ||||
39767 | 39767 | 137066 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 12 Filbert St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012425.54206 | 2120223.78485 | 37.8024296352708 | -122.401180217987 | (37.8024296352708, -122.401180217987) | ||||
168803 | 168803 | 249975 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 21 Napier Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 6011642.325669999 | 2120237.40655 | 37.8024233121334 | -122.403891507612 | (37.8024233121334, -122.403891507612) | |||
67280 | 67280 | 249976 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 21 Napier Ln | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 6011642.19943 | 2120231.20207 | 37.8024062690918 | -122.403891507608 | (37.8024062690918, -122.403891507608) | |||
36414 | 36414 | 136262 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Filbert St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012539.8548099995 | 2120210.2855 | 37.8023989459081 | -122.400783688018 | (37.8023989459081, -122.400783688018) | ||||
177213 | 177213 | 249977 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 21 Napier Ln | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 6011643.6544699995 | 2120226.12946 | 37.8023924222307 | -122.403886115262 | (37.8023924222307, -122.403886115262) | |||
147602 | 147602 | 129471 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6012526.59847 | 2120207.76193 | 37.8023912773999 | -122.40082938436701 | (37.8023912773999, -122.400829384367) | ||||
132469 | 132469 | 129472 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012528.94679 | 2120206.6635 | 37.8023883923599 | -122.400821180758 | (37.8023883923599, -122.400821180758) | ||||
174070 | 174070 | 129473 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6012532.2991 | 2120205.0438900003 | 37.8023841322847 | -122.400809466192 | (37.8023841322847, -122.400809466192) | ||||
137937 | 137937 | 129474 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 6012536.27851 | 2120200.91706 | 37.8023730229664 | -122.400795405292 | (37.8023730229664, -122.400795405292) | ||||
43013 | 43013 | 137065 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 11 Filbert St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6012521.25442 | 2120194.7201 | 37.8023551696124 | -122.40084696071399 | (37.8023551696124, -122.400846960714) | ||||
154830 | 154830 | 135013 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 11 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 6012368.5376 | 2120177.6875299998 | 37.8022998828874 | -122.401374241337 | (37.8022998828874, -122.401374241337) | ||||
24286 | 24286 | 249978 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 13 Napier Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 6011650.66928 | 2120187.96882 | 37.8022880343123 | -122.403859153579 | (37.8022880343123, -122.403859153579) | |||
37571 | 37571 | 249979 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 13 Napier Ln | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6011649.02488 | 2120183.7348700003 | 37.802276317051 | -122.403864545927 | (37.802276317051, -122.403864545927) | |||
157479 | 157479 | 135014 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1077 Front St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6012567.827330001 | 2120162.89439 | 37.8022703815431 | -122.400683557523 | (37.8022703815431, -122.400683557523) | ||||
39130 | 39130 | 134791 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Lombard St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6007500.8396 | 2120253.7585299998 | 37.802235966276 | -122.418224288116 | (37.802235966276, -122.418224288116) | ||||
171848 | 171848 | 134790 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Lombard St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6007519.93595 | 2120253.20952 | 37.802235533706 | -122.41815816638099 | (37.802235533706, -122.418158166381) | ||||
76569 | 76569 | 136021 | Undocumented 2 | Prunus spp :: Cherry 84 | 1010 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6007482.49892 | 2120248.47345 | 37.802220422406705 | -122.418287380977 | (37.8022204224067, -122.418287380977) | ||||
35307 | 35307 | 135015 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1077 Front St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6012578.55568 | 2120142.36821 | 37.802214619965206 | -122.40064498919399 | (37.8022146199652, -122.400644989194) | ||||
135925 | 135925 | 134792 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1016 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 6007425.34562 | 2120240.11235 | 37.8021942476325 | -122.418484566311 | (37.8021942476325, -122.418484566311) | ||||
174868 | 174868 | 135016 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1077 Front St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6012585.731319999 | 2120133.72105 | 37.802191277152204 | -122.400619550052 | (37.8021912771522, -122.400619550052) | ||||
184768 | 184768 | 134793 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1028 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6007395.86697 | 2120236.40414 | 37.8021824062669 | -122.418586313803 | (37.8021824062669, -122.418586313803) | ||||
31084 | 31084 | 134794 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6007385.13093 | 2120235.26271 | 37.8021786677605 | -122.418623384776 | (37.8021786677605, -122.418623384776) | ||||
74619 | 74619 | 129475 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1077 Front St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6012586.0999300005 | 2120128.51859 | 37.8021770130129 | -122.40061790879999 | (37.8021770130129, -122.4006179088) | ||||
43299 | 43299 | 129476 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1077 Front St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6012591.305319999 | 2120127.94056 | 37.8021757161919 | -122.4005998549 | (37.8021757161919, -122.4005998549) | ||||
185394 | 185394 | 135017 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1077 Front St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6012595.7467 | 2120124.7804 | 37.8021672868545 | -122.40058426336701 | (37.8021672868545, -122.400584263367) | ||||
147241 | 147241 | 134795 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1050 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6007333.04572 | 2120229.52133 | 37.802159970872395 | -122.41880321771099 | (37.8021599708724, -122.418803217711) | ||||
165476 | 165476 | 134796 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1050 Lombard St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6007325.26696 | 2120228.09198 | 37.802155608254 | -122.418830034596 | (37.802155608254, -122.418830034596) | ||||
181345 | 181345 | 134797 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1050 Lombard St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6007318.65057 | 2120227.7737 | 37.8021543617957 | -122.418852907954 | (37.8021543617957, -122.418852907954) |
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");