Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4061 | 4061 | 252970 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whipple Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 12:21:00 PM | 3 | ||||||||
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) | |||
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) | |||
120051 | 120051 | 175838 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994346.0156 | 2086520.6232200002 | 37.708864190212296 | -122.461299273568 | (37.7088641902123, -122.461299273568) | |||
156268 | 156268 | 177815 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 520 Carter St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6005230.32972 | 2086303.80615 | 37.708889269593705 | -122.42366611910299 | (37.7088892695937, -122.423666119103) | ||||
149597 | 149597 | 175837 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994356.88277 | 2086531.76861 | 37.7088954182656 | -122.461262522762 | (37.7088954182656, -122.461262522762) | |||
60266 | 60266 | 177814 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 520 Carter St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6005234.109619999 | 2086313.99971 | 37.70891747232 | -122.423653779491 | (37.70891747232, -122.423653779491) | ||||
3065 | 3065 | 175836 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Rhine St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994366.585519999 | 2086543.72285 | 37.70892880020671 | -122.46122985488998 | (37.7089288002067, -122.46122985489) | |||
892 | 892 | 251400 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5994375.43496 | 2086552.5575599999 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | ||||
171265 | 171265 | 175835 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994375.43496 | 2086552.5575599999 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | |||
168435 | 168435 | 176111 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 64 | 6005239.18473 | 2086329.3019599998 | 37.7089597755375 | -122.423637326411 | (37.7089597755375, -122.423637326411) | ||||
111059 | 111059 | 108382 | Undocumented 2 | Tree(s) :: 17 | 30 CASTILLO ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6x12 | 6006869.1 | 2086298.1 | 37.7089659714277 | -122.418001881162 | (37.7089659714277, -122.418001881162) | ||||
183973 | 183973 | 176110 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 47 | 6005248.37143 | 2086351.63031 | 37.709021603021604 | -122.423607162245 | (37.7090216030216, -122.423607162245) | ||||
63565 | 63565 | 178691 | Undocumented 2 | Prunus armeniaca :: Apricot 259 | 549 Cordova St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6002129.66344 | 2086422.5793700002 | 37.709039879958 | -122.43439093020099 | (37.709039879958, -122.434390930201) | |||
45207 | 45207 | 178692 | Undocumented 2 | Prunus armeniaca :: Apricot 259 | 549 Cordova St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6002131.76754 | 2086425.47642 | 37.7090479540599 | -122.43438386511801 | (37.7090479540599, -122.434383865118) | |||
24565 | 24565 | 176109 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6005252.95246 | 2086362.20208 | 37.7090508894465 | -122.42359208063299 | (37.7090508894465, -122.423592080633) | ||||
163592 | 163592 | 178693 | Undocumented 2 | Prunus armeniaca :: Apricot 259 | 549 Cordova St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6002128.86761 | 2086428.02428 | 37.7090547853188 | -122.434394069733 | (37.7090547853188, -122.434394069733) | |||
172551 | 172551 | 176108 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 6005255.13814 | 2086372.0334299998 | 37.7090780076251 | -122.4235852251 | (37.7090780076251, -122.4235852251) | ||||
4209 | 4209 | 180663 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 355 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:48:00 PM | 3 | Width 6ft | 6002383.84355 | 2086445.14687 | 37.709116270155604 | -122.43351405884898 | (37.7091162701556, -122.433514058849) | ||
30355 | 30355 | 180399 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 349 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002410.48398 | 2086459.29818 | 37.7091566380421 | -122.433422996175 | (37.7091566380421, -122.433422996175) | |||
4254 | 4254 | 180668 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:45:00 PM | 3 | Width 6ft | 6002314.90905 | 2086461.72548 | 37.709157880008 | -122.433753490754 | (37.709157880008, -122.433753490754) | ||
130867 | 130867 | 179477 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 245 Wilson St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5994326.32135 | 2086634.18047 | 37.709174858293295 | -122.461375565754 | (37.7091748582933, -122.461375565754) | ||||
56147 | 56147 | 179476 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 245 Wilson St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5994306.081069999 | 2086649.9682200002 | 37.7092170428021 | -122.461446662549 | (37.7092170428021, -122.461446662549) | ||||
137396 | 137396 | 175750 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 348 Naylor St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6002816.75765 | 2086477.59625 | 37.7092299219895 | -122.43202015901899 | (37.7092299219895, -122.432020159019) | |||
186888 | 186888 | 175547 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 348 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002373.36986 | 2086487.8856799998 | 37.709233027364995 | -122.433553309758 | (37.709233027365, -122.433553309758) | |||
4244 | 4244 | 180664 | Undocumented 2 | Magnolia champaca :: Champa 170 | 339 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:55:00 PM | 3 | Width 6ft | 6002468.5653 | 2086489.08528 | 37.7092417219876 | -122.43322438540399 | (37.7092417219876, -122.433224385404) | ||
177290 | 177290 | 179475 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 245 Wilson St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5994292.07601 | 2086663.3492700001 | 37.7092529779255 | -122.46149603531401 | (37.7092529779255, -122.461496035314) | ||||
169725 | 169725 | 175749 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 348 Naylor St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6002804.80085 | 2086492.5452299998 | 37.7092702907661 | -122.432062550353 | (37.7092702907661, -122.432062550353) | |||
4231 | 4231 | 180667 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 344 Chicago Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:51:00 PM | 3 | Width 6ft | 6002403.88387 | 2086502.6359 | 37.709275259527296 | -122.43344890203998 | (37.7092752595273, -122.43344890204) | ||
63848 | 63848 | 177912 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Rhine St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994504.97936 | 2086701.6160799998 | 37.709370301666496 | -122.460762984428 | (37.7093703016665, -122.460762984428) | |||
59246 | 59246 | 177825 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 253 Wilson St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 10ft | 5994242.183759999 | 2086709.3481 | 37.709376408063 | -122.461671802408 | (37.709376408063, -122.461671802408) | |||
45423 | 45423 | 177824 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 253 Wilson St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 10ft | 5994231.54615 | 2086719.8133200002 | 37.7094045307537 | -122.461709325737 | (37.7094045307537, -122.461709325737) | |||
52388 | 52388 | 178914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993788.47929 | 2086756.5816799998 | 37.7094799730978 | -122.463243292153 | (37.7094799730978, -122.463243292153) | ||||
169162 | 169162 | 175123 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 316 Naylor St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6002739.89335 | 2086572.14483 | 37.7094851738594 | -122.43229256186399 | (37.7094851738594, -122.432292561864) | |||
57453 | 57453 | 175343 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 19 Rhine St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994542.86208 | 2086742.78517 | 37.709485521912605 | -122.460635037876 | (37.7094855219126, -122.460635037876) | |||
66527 | 66527 | 178915 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993789.8911 | 2086758.89685 | 37.70948641134179 | -122.46323858062 | (37.7094864113418, -122.46323858062) | ||||
65590 | 65590 | 178916 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993790.44094 | 2086761.47706 | 37.7094935276652 | -122.46323686739599 | (37.7094935276652, -122.463236867396) | ||||
67795 | 67795 | 178907 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993774.9758 | 2086763.55645 | 37.7094983462303 | -122.46329046790501 | (37.7094983462303, -122.463290467905) | ||||
183985 | 183985 | 178917 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993792.21408 | 2086763.29106 | 37.7094986106303 | -122.463230870712 | (37.7094986106303, -122.463230870712) | ||||
48579 | 48579 | 178918 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993792.015380001 | 2086765.64003 | 37.709505048900496 | -122.46323172778 | (37.7095050489005, -122.46323172778) | ||||
76456 | 76456 | 178908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993776.62184 | 2086766.22044 | 37.7095057557476 | -122.463284972138 | (37.7095057557476, -122.463284972138) | ||||
184051 | 184051 | 178910 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993781.83724 | 2086767.02745 | 37.7095082720684 | -122.463267005492 | (37.7095082720684, -122.463267005492) | ||||
155097 | 155097 | 178919 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5993793.90715 | 2086767.20458 | 37.709509453768604 | -122.463225303004 | (37.7095094537686, -122.463225303004) | ||||
58079 | 58079 | 178920 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5993797.37837 | 2086767.25523 | 37.7095097928145 | -122.463213309645 | (37.7095097928145, -122.463213309645) | ||||
61631 | 61631 | 178909 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5993779.42986 | 2086768.12245 | 37.70951113998979 | -122.463275405145 | (37.7095111399898, -122.463275405145) | ||||
182335 | 182335 | 178911 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993783.22919 | 2086769.82188 | 37.709516025103895 | -122.46326239735201 | (37.7095160251039, -122.463262397352) | ||||
34928 | 34928 | 178912 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5993780.74611 | 2086770.03775 | 37.709516474781104 | -122.463270994886 | (37.7095164747811, -122.463270994886) | ||||
156857 | 156857 | 176639 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 19 Rhine St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994551.36715 | 2086753.98013 | 37.7095167499667 | -122.460606453835 | (37.7095167499667, -122.460606453835) | |||
43104 | 43104 | 178921 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5993794.96049 | 2086770.14434 | 37.7095175863374 | -122.463221875682 | (37.7095175863374, -122.463221875682) | ||||
184333 | 184333 | 178913 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5993781.9303 | 2086773.16178 | 37.709525120851396 | -122.463267128695 | (37.7095251208514, -122.463267128695) | ||||
149818 | 149818 | 175582 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 263 Flournoy St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5993786.39269 | 2086775.2603200001 | 37.7095311400252 | -122.463251858209 | (37.7095311400252, -122.463251858209) | ||||
132972 | 132972 | 178114 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 251 De Long St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 10ft | 5993733.77465 | 2086791.3315400002 | 37.709572236344 | -122.463434879221 | (37.709572236344, -122.463434879221) | |||
184163 | 184163 | 176435 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 275 De Long St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 10ft | 5993714.58235 | 2086792.86785 | 37.7095753489021 | -122.46350132202299 | (37.7095753489021, -122.463501322023) | |||
183970 | 183970 | 177479 | Undocumented 2 | Malus :: Crab Apple 235 | 275 De Long St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 10ft | 5993713.98854 | 2086795.12422 | 37.709581510147295 | -122.463503537957 | (37.7095815101473, -122.463503537957) | |||
166358 | 166358 | 175641 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 De Long St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 10ft | 5993718.84188 | 2086795.50483 | 37.709582834847005 | -122.463486791709 | (37.709582834847, -122.463486791709) | |||
172703 | 172703 | 176284 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 251 De Long St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 10ft | 5993742.60383 | 2086796.45358 | 37.7095868089467 | -122.46340473574101 | (37.7095868089467, -122.463404735741) | |||
54344 | 54344 | 175642 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 De Long St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 10ft | 5993719.3869 | 2086798.3884400001 | 37.709590783961 | -122.463485117168 | (37.709590783961, -122.463485117168) | |||
67037 | 67037 | 175746 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 52 Baltimore Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6002987.27121 | 2086606.3933299999 | 37.7095932364015 | -122.43144002615401 | (37.7095932364015, -122.431440026154) | |||
85192 | 85192 | 175643 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 De Long St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 10ft | 5993719.91168 | 2086800.3072400002 | 37.7095960827685 | -122.463483442609 | (37.7095960827685, -122.463483442609) | |||
172959 | 172959 | 175860 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 251 De Long St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 10ft | 5993744.6321 | 2086800.75375 | 37.7095987330548 | -122.463398037591 | (37.7095987330548, -122.463398037591) | |||
173769 | 173769 | 175581 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 251 De Long St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 10ft | 5993749.01127 | 2086801.62677 | 37.7096013824625 | -122.46338296584699 | (37.7096013824625, -122.463382965847) | |||
162718 | 162718 | 175644 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 De Long St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 10ft | 5993719.95216 | 2086802.2365299999 | 37.7096013824754 | -122.463483442623 | (37.7096013824754, -122.463483442623) | |||
38639 | 38639 | 174959 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 103 De Long St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 10ft | 5994397.11424 | 2086788.06602 | 37.709601466104104 | -122.461142043293 | (37.7096014661041, -122.461142043293) | |||
156503 | 156503 | 174960 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 103 De Long St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 10ft | 5994409.5991400005 | 2086788.1181299998 | 37.709602327657706 | -122.461098897396 | (37.7096023276577, -122.461098897396) | |||
12169 | 12169 | 107579 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992416.91174 | 2086830.03613 | 37.7096025506984 | -122.467988957943 | (37.7096025506984, -122.467988957943) | ||
10524 | 10524 | 107581 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992393.946819999 | 2086830.9956900002 | 37.7096038591978 | -122.46806839775299 | (37.7096038591978, -122.468068397753) | ||
10370 | 10370 | 107580 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992406.39157 | 2086830.73395 | 37.709603859212706 | -122.468025367885 | (37.7096038592127, -122.468025367885) | ||
37841 | 37841 | 175646 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 De Long St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 10ft | 5993722.898680001 | 2086804.1045099997 | 37.7096066812751 | -122.46347339448799 | (37.7096066812751, -122.463473394488) | |||
26717 | 26717 | 176589 | Undocumented 2 | Juglans nigra :: Eastern black walnut 288 | 161 De Long St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 10ft | 5994383.03058 | 2086790.743 | 37.7096080059674 | -122.461190912432 | (37.7096080059674, -122.461190912432) | |||
52770 | 52770 | 175645 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 De Long St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 10ft | 5993719.51846 | 2086804.6578900001 | 37.7096080059695 | -122.46348511715799 | (37.7096080059695, -122.463485117158) | |||
11907 | 11907 | 107582 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992337.55751 | 2086836.4734200002 | 37.7096156430274 | -122.46826368552 | (37.7096156430274, -122.46826368552) | ||
3405 | 3405 | 180669 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 171 Winding Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 6ft | 6002170.184219999 | 2086635.71157 | 37.70962739445179 | -122.434266111507 | (37.7096273944518, -122.434266111507) | |||
150121 | 150121 | 175745 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 52 Baltimore Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6003007.00361 | 2086627.02122 | 37.7096509944604 | -122.431373299139 | (37.7096509944604, -122.431373299139) | |||
4271 | 4271 | 180665 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 316 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 02:13:00 PM | 3 | Width 6ft | 6002643.65919 | 2086652.61793 | 37.7097006784091 | -122.432630907484 | (37.7097006784091, -122.432630907484) | ||
74650 | 74650 | 175744 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 46 Baltimore Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6003028.75595 | 2086646.47615 | 37.709705646261796 | -122.431299507078 | (37.7097056462618, -122.431299507078) | |||
47892 | 47892 | 176012 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 460 Peninsula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 6012147.1719 | 2086483.56891 | 37.709770881279205 | -122.399773002936 | (37.7097708812792, -122.399773002936) | |||
160488 | 160488 | 178507 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 40 Baltimore Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6003050.64825 | 2086672.7139400002 | 37.7097789302122 | -122.431225715016 | (37.7097789302122, -122.431225715016) | |||
57572 | 57572 | 175913 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Baltimore Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 6003123.75236 | 2086687.83288 | 37.7098245860981 | -122.430974132365 | (37.7098245860981, -122.430974132365) | |||
184257 | 184257 | 175743 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 262 Chicago Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6002717.2522 | 2086712.6010099999 | 37.7098695521959 | -122.43238083839701 | (37.7098695521959, -122.432380838397) | |||
158716 | 158716 | 175914 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Baltimore Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 51 | Width 4ft | 6003141.02013 | 2086709.17727 | 37.709884171596606 | -122.43091597409901 | (37.7098841715966, -122.430915974099) | |||
132995 | 132995 | 175742 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 262 Chicago Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6002727.11736 | 2086720.5871400002 | 37.709892039762295 | -122.43234731259399 | (37.7098920397623, -122.432347312594) | |||
36617 | 36617 | 175739 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 Chicago Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6002794.41849 | 2086722.1369599998 | 37.709900111181604 | -122.432114818072 | (37.7099001111816, -122.432114818072) | |||
70435 | 70435 | 187490 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 750 Velasco Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6006575.2964699995 | 2086657.1322 | 37.709935258482 | -122.419042759324 | (37.709935258482, -122.419042759324) | ||||
35376 | 35376 | 179161 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 233 Naylor St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002647.79999 | 2086739.6543400001 | 37.7099398962889 | -122.432622809119 | (37.7099398962889, -122.432622809119) | |||
28772 | 28772 | 175741 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 262 Chicago Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6002753.09913 | 2086743.14922 | 37.709955463542 | -122.432259125067 | (37.709955463542, -122.432259125067) | |||
167538 | 167538 | 179336 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 225 Naylor St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6002643.14283 | 2086748.99011 | 37.709965266168105 | -122.43263957156 | (37.7099652661681, -122.43263957156) | |||
32246 | 32246 | 187491 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 750 Velasco Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6006526.88476 | 2086669.8859599999 | 37.7099675513223 | -122.419210983794 | (37.7099675513223, -122.419210983794) | ||||
53899 | 53899 | 175227 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 225 Naylor St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6002635.08266 | 2086756.92621 | 37.709986599863 | -122.43266799554199 | (37.709986599863, -122.432667995542) | |||
151648 | 151648 | 187492 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 750 Velasco Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6006524.35531 | 2086677.42218 | 37.7099881017507 | -122.419220260308 | (37.7099881017507, -122.419220260308) | ||||
167207 | 167207 | 175740 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 262 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6002767.48185 | 2086755.4515900002 | 37.709990058672794 | -122.432210293693 | (37.7099900586728, -122.432210293693) | |||
4358 | 4358 | 180653 | Undocumented 2 | Magnolia champaca :: Champa 170 | 245 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/11/2017 07:56:00 AM | 3 | Width 6ft | 6002847.75966 | 2086772.69306 | 37.7100419513527 | -122.43193406871299 | (37.7100419513527, -122.431934068713) | ||
46503 | 46503 | 176289 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 140 South Hill Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6003155.69301 | 2086832.03957 | 37.710222356236 | -122.430874024341 | (37.710222356236, -122.430874024341) | |||
4071 | 4071 | 251734 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 856 Prague St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 08:08:00 AM | 3 | Width 6ft | 6002039.2106099995 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | ||
137051 | 137051 | 178842 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 856 Prague St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6002039.2106099995 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | |||
59060 | 59060 | 178841 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 856 Prague St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002067.276880001 | 2086921.00065 | 37.710404894347704 | -122.434642162998 | (37.7104048943477, -122.434642162998) | |||
3423 | 3423 | 251752 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | ||||
3432 | 3432 | 180655 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | |||
3488 | 3488 | 251753 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) |
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");