Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, SiteOrder, DBH, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24801 | 24801 | 179172 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 766 Brussels St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6011071.2158 | 2091212.4916599998 | 37.7226955033774 | -122.403824260795 | (37.7226955033774, -122.403824260795) | |||
25845 | 25845 | 237234 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 110 Carmel St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 5998175.72217 | 2105385.27781 | 37.7608816968555 | -122.449421648503 | (37.7608816968555, -122.449421648503) | |||
27120 | 27120 | 135723 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1910 Baker St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 5999974.03757 | 2115574.89722 | 37.7889625079578 | -122.44393422098699 | (37.7889625079578, -122.443934220987) | |||
30789 | 30789 | 236735 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2235 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | Width 8ft | 6002728.24168 | 2098985.0046599996 | 37.7435674334864 | -122.433219176525 | (37.7435674334864, -122.433219176525) | |||
30862 | 30862 | 179685 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 218 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6003869.47166 | 2092417.36805 | 37.7255988638766 | -122.42880497658899 | (37.7255988638766, -122.428804976589) | |||
31993 | 31993 | 135726 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1910 Baker St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5999972.00363 | 2115592.60206 | 37.789011004802106 | -122.443942530717 | (37.7890110048021, -122.443942530717) | |||
33287 | 33287 | 118775 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 630 45th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 27 | Width 2ft | 5981986.088380001 | 2111427.82901 | 37.7765333919608 | -122.50586147692101 | (37.7765333919608, -122.505861476921) | |||
33419 | 33419 | 218015 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990772.5777900005 | 2099709.35635 | 37.7448708407289 | -122.474611345145 | (37.7448708407289, -122.474611345145) | |||
34860 | 34860 | 237993 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 480 Jersey St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6001987.72906 | 2101502.95079 | 37.7504390831161 | -122.43595981461701 | (37.7504390831161, -122.435959814617) | |||
38381 | 38381 | 136611 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1630 Bay St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 1ft | 6002977.377719999 | 2120668.13454 | 37.80311807979739 | -122.433907279317 | (37.8031180797974, -122.433907279317) | |||
39376 | 39376 | 239418 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2106 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 6002637.419840001 | 2099337.55033 | 37.7445302890331 | -122.433558405315 | (37.7445302890331, -122.433558405315) | ||||
40197 | 40197 | 236681 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 756 Grand View Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 6000049.04538 | 2100790.98488 | 37.7483738718507 | -122.442612790472 | (37.7483738718507, -122.442612790472) | |||
40900 | 40900 | 196108 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 553 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6014419.65969 | 2104542.9303 | 37.759484616234104 | -122.393181648629 | (37.7594846162341, -122.393181648629) | |||
41433 | 41433 | 139465 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 855 CENTRAL AVE | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 5999527.6632 | 2111481.3292 | 37.77769715931579 | -122.445184184965 | (37.7776971593158, -122.445184184965) | |||
41984 | 41984 | 135853 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 12 Filbert St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | 6012286.0131 | 2120198.4327700003 | 37.8023522396158 | -122.40166127704799 | (37.8023522396158, -122.401661277048) | ||||
42262 | 42262 | 214783 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 984 Portola Dr | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5996077.08302 | 2098544.42751 | 37.7419781641671 | -122.456185254462 | (37.7419781641671, -122.456185254462) | |||
42692 | 42692 | 139101 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2533 POST ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 6000038.1797 | 2113670.6976 | 37.78373772905571 | -122.443575453886 | (37.7837377290557, -122.443575453886) | |||
42756 | 42756 | 237448 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4609 25th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6000549.980269999 | 2101082.72419 | 37.7492034604754 | -122.440901499304 | (37.7492034604754, -122.440901499304) | |||
42808 | 42808 | 179717 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 17 Dunsmuir St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 2ft | 6008127.64953 | 2094206.23587 | 37.7307508001883 | -122.414211266754 | (37.7307508001883, -122.414211266754) | |||
43845 | 43845 | 236752 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 420 Collingwood St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 6002107.159440001 | 2103370.74755 | 37.755574390960604 | -122.435680430326 | (37.7555743909606, -122.435680430326) | ||||
47858 | 47858 | 142823 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1742 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6006601.0091 | 2116911.6099 | 37.79300857718 | -122.421100695716 | (37.79300857718, -122.421100695716) | |||
48400 | 48400 | 236754 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 456 Collingwood St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6002114.12722 | 2103211.5772 | 37.755137743137496 | -122.435644946673 | (37.7551377431375, -122.435644946673) | ||||
49057 | 49057 | 142822 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1742 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6006604.1049 | 2116897.4579 | 37.7929698938345 | -122.421088978741 | (37.7929698938345, -122.421088978741) | |||
50185 | 50185 | 238001 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 591 27th St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002762.01889 | 2100032.1411900003 | 37.746444541887705 | -122.43317718719601 | (37.7464445418877, -122.433177187196) | ||||
50974 | 50974 | 218020 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990823.88989 | 2099711.8646400003 | 37.7448807008746 | -122.474434102269 | (37.7448807008746, -122.474434102269) | |||
52379 | 52379 | 196126 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2251 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 2ft | 6011345.096580001 | 2104613.5358 | 37.759507200926706 | -122.40382003306601 | (37.7595072009267, -122.403820033066) | |||
53520 | 53520 | 196107 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 559 Pennsylvania Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6014419.73249 | 2104517.48217 | 37.759414745219296 | -122.39317961614799 | (37.7594147452193, -122.393179616148) | |||
54122 | 54122 | 239022 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 927 Church St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6004402.676659999 | 2103488.0295 | 37.7560265386112 | -122.42775016985 | (37.7560265386112, -122.42775016985) | |||
55416 | 55416 | 237434 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1206 Diamond St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6001928.49113 | 2100507.97364 | 37.7477037465288 | -122.436093471852 | (37.7477037465288, -122.436093471852) | |||
55435 | 55435 | 131324 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400 Cherry St | 14 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 9ft | 5996252.06992 | 2114879.22587 | 37.7868393686989 | -122.456761319676 | (37.7868393686989, -122.456761319676) | |||
55682 | 55682 | 124430 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 315 Cherry St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 5ft | 5996165.292669999 | 2115148.00048 | 37.7875723686265 | -122.457080995957 | (37.7875723686265, -122.457080995957) | |||
60327 | 60327 | 179707 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 8 Dunsmuir St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 2ft | 6008087.26111 | 2094229.35305 | 37.730812006246204 | -122.414352531355 | (37.7308120062462, -122.414352531355) | |||
63044 | 63044 | 196410 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1143 Howard St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6009614.35227 | 2111076.8827400003 | 37.7771572198736 | -122.410262172786 | (37.7771572198736, -122.410262172786) | |||
64348 | 64348 | 215243 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 284 Thrift St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 5994231.73056 | 2089665.2528900001 | 37.7174920206045 | -122.461922130513 | (37.7174920206045, -122.461922130513) | ||||
66040 | 66040 | 235919 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 149 Fair Oaks St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6005429.09615 | 2102853.14802 | 37.7543413107251 | -122.42415531613301 | (37.7543413107251, -122.424155316133) | |||
66177 | 66177 | 131322 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400 Cherry St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 9ft | 5996256.90517 | 2114854.47123 | 37.786771676724 | -122.45674279995501 | (37.786771676724, -122.456742799955) | |||
67962 | 67962 | 237811 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1837 Church St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6004597.73659 | 2098051.69085 | 37.7411106430416 | -122.426688472519 | (37.7411106430416, -122.426688472519) | |||
71385 | 71385 | 236704 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 400 Clipper St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6002466.37628 | 2100942.47279 | 37.7489273227364 | -122.434264554764 | (37.7489273227364, -122.434264554764) | |||
72729 | 72729 | 239396 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4109 23rd St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6002403.27601 | 2102357.88055 | 37.7528101150969 | -122.43458394808901 | (37.7528101150969, -122.434583948089) | |||
73699 | 73699 | 218021 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990833.9529 | 2099712.67814 | 37.744883517556 | -122.474399365956 | (37.744883517556, -122.474399365956) | |||
75447 | 75447 | 218016 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990785.97144 | 2099709.33017 | 37.7448715449012 | -122.474565030958 | (37.7448715449012, -122.474565030958) | |||
101358 | 101358 | 99777 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 492x Jersey St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 492-494x Jersey St 845-849 Diamond St | 6001966.3 | 2101499.0 | 37.7504270178067 | -122.43603363507799 | (37.7504270178067, -122.436033635078) | |||
104672 | 104672 | 64402 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 05/14/1988 12:00:00 AM | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||
123732 | 123732 | 196127 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2251 20th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6011374.07778 | 2104614.45279 | 37.7595113377868 | -122.403719865702 | (37.7595113377868, -122.403719865702) | |||
127063 | 127063 | 101446 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||||
129709 | 129709 | 131323 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400 Cherry St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 9ft | 5996254.50366 | 2114867.62545 | 37.7868076567964 | -122.456752060266 | (37.7868076567964, -122.456752060266) | |||
130149 | 130149 | 142311 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 448 LYON ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 6000194.2084 | 2110499.5828 | 37.775039556646206 | -122.442807870044 | (37.7750395566462, -122.442807870044) | |||
130535 | 130535 | 143436 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 725 STOCKTON ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6010474.6222 | 2116698.0575 | 37.792639816621 | -122.40768265432399 | (37.792639816621, -122.407682654324) | |||
131227 | 131227 | 199694 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1350 Underwood Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6015915.704 | 2092772.4292 | 37.727248236967704 | -122.38718652280701 | (37.7272482369677, -122.387186522807) | |||
132553 | 132553 | 236516 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 63 Bronte St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6009359.848619999 | 2097078.2444799999 | 37.7387058549889 | -122.410154031979 | (37.7387058549889, -122.410154031979) | |||
133870 | 133870 | 237233 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 110 Carmel St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5998197.90052 | 2105385.6119999997 | 37.760883883112506 | -122.449344967798 | (37.7608838831125, -122.449344967798) | |||
135318 | 135318 | 235918 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 149 Fair Oaks St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6005429.10381 | 2102843.41595 | 37.754314589155896 | -122.424154597561 | (37.7543145891559, -122.424154597561) | |||
136223 | 136223 | 179108 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 286 Trumbull St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6005259.27603 | 2094300.24021 | 37.7308473792844 | -122.42413437721301 | (37.7308473792844, -122.424134377213) | |||
137373 | 137373 | 136004 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1027 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 3ft | 6008655.5558400005 | 2118272.73317 | 37.796861491822604 | -122.41408816572999 | (37.7968614918226, -122.41408816573) | |||
143083 | 143083 | 101447 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||||
146756 | 146756 | 237444 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 909 Douglass St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6001322.75854 | 2101029.25442 | 37.7491006275095 | -122.438225395692 | (37.7491006275095, -122.438225395692) | |||
148635 | 148635 | 136026 | Undocumented 2 | Prunus spp :: Cherry 84 | 957 Sacramento St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6010195.26054 | 2116841.12509 | 37.793017003381706 | -122.408659357866 | (37.7930170033817, -122.408659357866) | |||
150797 | 150797 | 214670 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2250 15th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | 5991762.46474 | 2100100.36567 | 37.7460017588674 | -122.47121701506398 | (37.7460017588674, -122.471217015064) | ||||
152458 | 152458 | 179714 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 53 Dunsmuir St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 6008166.60456 | 2094034.8960099998 | 37.7302825259061 | -122.41406447582199 | (37.7302825259061, -122.414064475822) | |||
152516 | 152516 | 179088 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 177 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6004073.80671 | 2092653.92212 | 37.7262599519094 | -122.428115457389 | (37.7262599519094, -122.428115457389) | |||
154116 | 154116 | 218018 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990812.82418 | 2099712.3546 | 37.7448814050516 | -122.474472400799 | (37.7448814050516, -122.474472400799) | |||
154305 | 154305 | 218019 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990820.542769999 | 2099711.9352700002 | 37.744880700881794 | -122.474445681024 | (37.7448807008818, -122.474445681024) | |||
154374 | 154374 | 236703 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 400 Clipper St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6002502.2802 | 2100944.2817700002 | 37.748934327571995 | -122.43414052836201 | (37.748934327572, -122.434140528362) | |||
155116 | 155116 | 218017 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990797.83143 | 2099709.8496 | 37.7448736582987 | -122.474524059638 | (37.7448736582987, -122.474524059638) | |||
161934 | 161934 | 196371 | Undocumented 2 | Prunus spp :: Cherry 84 | 1797 Bancroft Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 6013429.501019999 | 2092789.94242 | 37.7271583305791 | -122.395782600389 | (37.7271583305791, -122.395782600389) | |||
161953 | 161953 | 179716 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 41 Dunsmuir St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 2ft | 6008151.38796 | 2094098.7186099999 | 37.7304569143427 | -122.414121595359 | (37.7304569143427, -122.414121595359) | |||
162013 | 162013 | 236751 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 420 Collingwood St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6002101.36864 | 2103370.60532 | 37.7555736715096 | -122.43570044651301 | (37.7555736715096, -122.435700446513) | ||||
165110 | 165110 | 238540 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 217 Montcalm St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6009894.85304 | 2099616.29886 | 37.7457047739516 | -122.40848321393699 | (37.7457047739516, -122.408483213937) | |||
167681 | 167681 | 237432 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1204 Diamond St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6001926.67486 | 2100538.92391 | 37.7477886254592 | -122.436101966853 | (37.7477886254592, -122.436101966853) | ||||
169782 | 169782 | 213119 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 215 Molimo Dr | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 5997893.97953 | 2096675.0128799998 | 37.7369493288531 | -122.44976835062799 | (37.7369493288531, -122.449768350628) | |||
170197 | 170197 | 237445 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 909 Douglass St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 3ft | 6001323.34412 | 2101039.65843 | 37.749129227744 | -122.43822411597701 | (37.749129227744, -122.438224115977) | |||
171106 | 171106 | 196409 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1143 Howard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6009598.37036 | 2111065.11658 | 37.7771240168943 | -122.41031662852801 | (37.7771240168943, -122.410316628528) | |||
173265 | 173265 | 196276 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1514 Innes Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6015988.30327 | 2096906.1918 | 37.738602740517294 | -122.38722376507499 | (37.7386027405173, -122.387223765075) | |||
173492 | 173492 | 196442 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 971 Kansas St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 5ft | 6011633.4910699995 | 2103859.13783 | 37.7574518984069 | -122.402769561075 | (37.7574518984069, -122.402769561075) | |||
176153 | 176153 | 237433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1206 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6001927.83941 | 2100530.44886 | 37.747765421138794 | -122.43609733352699 | (37.7477654211388, -122.436097333527) | |||
176432 | 176432 | 236680 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 756 Grand View Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6000047.77826 | 2100801.34251 | 37.748402239176706 | -122.442617915704 | (37.7484022391767, -122.442617915704) | |||
180881 | 180881 | 237295 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 614 Banks St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6008499.92821 | 2095980.82324 | 37.735644337901 | -122.413049665524 | (37.735644337901, -122.413049665524) | |||
181728 | 181728 | 136027 | Undocumented 2 | Prunus spp :: Cherry 84 | 957 Sacramento St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6010215.88282 | 2116843.14587 | 37.7930237069305 | -122.408588145932 | (37.7930237069305, -122.408588145932) | |||
186905 | 186905 | 236386 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 138 Carl St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 5997744.87985 | 2107159.8634 | 37.7657296047634 | -122.451039706011 | (37.7657296047634, -122.451039706011) | |||
187910 | 187910 | 237431 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1204 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6001926.93451 | 2100562.26984 | 37.747852742609204 | -122.43610273936899 | (37.7478527426092, -122.436102739369) | ||||
187989 | 187989 | 236401 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 620 Belvedere St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5998688.86487 | 2105557.55466 | 37.7613840662398 | -122.44765932353701 | (37.7613840662398, -122.447659323537) |
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");