Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24630 | 24630 | 184291 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1543 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5983404.3155 | 2104639.3384 | 37.7579775103532 | -122.50045345703501 | (37.7579775103532, -122.500453457035) | |||
24861 | 24861 | 182367 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1511 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5986186.5787 | 2104935.6262 | 37.758953963431 | -122.49085314669901 | (37.758953963431, -122.490853146699) | |||
25716 | 25716 | 135893 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 323 Marina Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6001843.597519999 | 2121830.48703 | 37.806245186226505 | -122.437914052191 | (37.8062451862265, -122.437914052191) | ||||
27002 | 27002 | 181705 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1206 22nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5989261.3602 | 2107107.536 | 37.7650965865931 | -122.48037820612 | (37.7650965865931, -122.48037820612) | |||
28134 | 28134 | 218416 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 206 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5994263.50524 | 2100633.1916900002 | 37.747609115379 | -122.46260745978901 | (37.747609115379, -122.462607459789) | |||
28949 | 28949 | 238015 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 77 Ashbury Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5999599.38464 | 2106733.87641 | 37.76466594869029 | -122.44459477575501 | (37.7646659486903, -122.444594775755) | |||
32181 | 32181 | 214447 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 265 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993364.21414 | 2099688.46118 | 37.7449632937192 | -122.465648504685 | (37.7449632937192, -122.465648504685) | |||
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) | ||||
35260 | 35260 | 135914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 414 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 10ft | 6011471.49553 | 2119063.8107 | 37.7991913582649 | -122.404400012157 | (37.7991913582649, -122.404400012157) | |||
35756 | 35756 | 218355 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 365 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5993521.424240001 | 2100014.7209799998 | 37.7458681870785 | -122.465128597612 | (37.7458681870785, -122.465128597612) | |||
39866 | 39866 | 182572 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2212 Ulloa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989118.5154 | 2098355.8518 | 37.7410584915124 | -122.48023167480301 | (37.7410584915124, -122.480231674803) | |||
39971 | 39971 | 218354 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 365 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5993503.7358800005 | 2100017.05504 | 37.745873575808794 | -122.46518993049801 | (37.7458735758088, -122.465189930498) | |||
41303 | 41303 | 118024 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 455 37th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5984366.776430001 | 2112718.2833 | 37.7802164441611 | -122.497721424423 | (37.7802164441611, -122.497721424423) | |||
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) | ||||
45248 | 45248 | 184305 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1562 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5984382.3056 | 2104532.0637 | 37.757740324240295 | -122.497063286444 | (37.7577403242403, -122.497063286444) | |||
47397 | 47397 | 135909 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011530.70294 | 2119058.88107 | 37.79918113116 | -122.40419478595501 | (37.79918113116, -122.404194785955) | ||||
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) | ||||
48637 | 48637 | 140842 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 133 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5996517.655 | 2113507.2067 | 37.783087415663 | -122.455743248453 | (37.783087415663, -122.455743248453) | |||
49180 | 49180 | 141238 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 31 PARKER AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5996802.437000001 | 2114389.98 | 37.7855276158827 | -122.45482182649599 | (37.7855276158827, -122.454821826496) | |||
51415 | 51415 | 182275 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3150 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985063.5912 | 2105018.8618 | 37.7591168373077 | -122.49474304376001 | (37.7591168373077, -122.49474304376) | |||
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) | ||||
52586 | 52586 | 214452 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 115 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993881.37151 | 2099908.46331 | 37.7455971799806 | -122.463876248508 | (37.7455971799806, -122.463876248508) | |||
54244 | 54244 | 196406 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1021 Minnesota St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6015301.01099 | 2103753.62638 | 37.7573662793475 | -122.390078334671 | (37.7573662793475, -122.390078334671) | |||
54310 | 54310 | 182541 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1587 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985582.1491 | 2104435.4669 | 37.7575453355233 | -122.492906676836 | (37.7575453355233, -122.492906676836) | |||
55304 | 55304 | 214412 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 441 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5995385.60147 | 2098278.36305 | 37.7412079002216 | -122.458556904286 | (37.7412079002216, -122.458556904286) | |||
56421 | 56421 | 118423 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981811.815769999 | 2111640.57092 | 37.7771072596016 | -122.50648010623001 | (37.7771072596016, -122.50648010623) | |||
56504 | 56504 | 214451 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 103 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993921.129 | 2099948.59538 | 37.7457096635647 | -122.463741686529 | (37.7457096635647, -122.463741686529) | |||
56855 | 56855 | 238020 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 20 Ashbury Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5999596.30607 | 2106935.78713 | 37.7652201693967 | -122.44461993696501 | (37.7652201693967, -122.444619936965) | |||
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) | ||||
59871 | 59871 | 214449 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 265 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993345.3112 | 2099686.63368 | 37.744957185531796 | -122.465713734328 | (37.7449571855318, -122.465713734328) | |||
60280 | 60280 | 218132 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Lopez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5993993.8202 | 2100664.7541 | 37.747680242765895 | -122.463542297865 | (37.7476802427659, -122.463542297865) | |||
60297 | 60297 | 182224 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1599 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985275.2811 | 2104383.8376 | 37.7573856255252 | -122.493964129886 | (37.7573856255252, -122.493964129886) | |||
61059 | 61059 | 182221 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2830 Lawton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985427.0921 | 2104352.0968 | 37.7573073554199 | -122.493436776332 | (37.7573073554199, -122.493436776332) | |||
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) | ||||
61750 | 61750 | 182581 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2462 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5989245.1110000005 | 2098590.7488 | 37.7417108128416 | -122.4798111426 | (37.7417108128416, -122.4798111426) | |||
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) | ||||
65666 | 65666 | 135911 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6011511.78534 | 2119057.5389799997 | 37.7991763890443 | -122.404260153176 | (37.7991763890443, -122.404260153176) | ||||
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) | ||||
67278 | 67278 | 237997 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4160 23rd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6002093.96349 | 2102384.7886200002 | 37.752866434239394 | -122.435655530791 | (37.7528664342394, -122.435655530791) | |||
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) | ||||
69155 | 69155 | 214404 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 66 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993883.93649 | 2101380.3383299997 | 37.7496387233569 | -122.46397420265801 | (37.7496387233569, -122.463974202658) | |||
70069 | 70069 | 118023 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 455 37th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5984366.09559 | 2112727.46699 | 37.780241619998 | -122.49772445801202 | (37.780241619998, -122.497724458012) | |||
70757 | 70757 | 182690 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1725 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988713.9908 | 2103546.8998 | 37.7552882198487 | -122.48201054093799 | (37.7552882198487, -122.482010540938) | |||
71684 | 71684 | 183874 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2253 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5987600.3776 | 2099940.7208 | 37.7453217895816 | -122.485597059998 | (37.7453217895816, -122.485597059998) | |||
74939 | 74939 | 135892 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 323 Marina Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6001823.0897 | 2121828.5954400003 | 37.8062388262166 | -122.437984887306 | (37.8062388262166, -122.437984887306) | |||
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) | ||||
76848 | 76848 | 135910 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6011521.095380001 | 2119068.1217 | 37.799205966851 | -122.404228682307 | (37.799205966851, -122.404228682307) | ||||
130597 | 130597 | 214411 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Ulloa St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5995342.99314 | 2098250.4042599997 | 37.74112868343371 | -122.45870220413799 | (37.7411286834337, -122.458702204138) | |||
131299 | 131299 | 135912 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011493.6768 | 2119059.8121 | 37.7991816185927 | -122.40432297534402 | (37.7991816185927, -122.404322975344) | ||||
131720 | 131720 | 238018 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Ashbury Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5999581.71277 | 2106854.10087 | 37.7649950466081 | -122.444664539759 | (37.7649950466081, -122.444664539759) | |||
132712 | 132712 | 141251 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 42 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5996544.3904 | 2114296.4063 | 37.785255882077706 | -122.455707820412 | (37.7852558820777, -122.455707820412) | |||
136120 | 136120 | 183843 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2242 25th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988571.2077 | 2100055.5134 | 37.745693497424796 | -122.48224853862699 | (37.7456934974248, -122.482248538627) | |||
136127 | 136127 | 238019 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Ashbury Ter | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 5999588.96153 | 2106868.76746 | 37.765035731038104 | -122.444640522441 | (37.7650357310381, -122.444640522441) | |||
137247 | 137247 | 214448 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 265 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993355.75758 | 2099687.65001 | 37.744960578675794 | -122.46567768677001 | (37.7449605786758, -122.46567768677) | |||
146957 | 146957 | 135913 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 414 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6011476.8778099995 | 2119044.52353 | 37.7991387011458 | -122.404380029217 | (37.7991387011458, -122.404380029217) | ||||
146988 | 146988 | 238017 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Ashbury Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5999577.21744 | 2106844.6450900002 | 37.7649688268778 | -122.444679408227 | (37.7649688268778, -122.444679408227) | |||
149250 | 149250 | 214410 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 319 Kensington Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994311.31652 | 2098976.3234200003 | 37.7430625253047 | -122.462321980781 | (37.7430625253047, -122.462321980781) | |||
152743 | 152743 | 182409 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1521 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985259.3217 | 2104833.2809 | 37.7586187384667 | -122.494052446724 | (37.7586187384667, -122.494052446724) | |||
153974 | 153974 | 214453 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 195 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994424.22111 | 2100746.43892 | 37.7479293180792 | -122.462059929142 | (37.7479293180792, -122.462059929142) | |||
154672 | 154672 | 182570 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2202 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5989157.6649 | 2098357.6812 | 37.7410657893771 | -122.480096445466 | (37.7410657893771, -122.480096445466) | |||
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) | ||||
156144 | 156144 | 183594 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2635 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988927.7716 | 2097397.2142 | 37.738415236787 | -122.48082102296999 | (37.738415236787, -122.48082102297) | |||
157232 | 157232 | 238013 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 77 Ashbury Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999618.479619999 | 2106729.8577400004 | 37.764656004003 | -122.44452844265899 | (37.764656004003, -122.444528442659) | |||
158401 | 158401 | 118027 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 51 Shore View Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5984327.56097 | 2112791.45591 | 37.780415056002205 | -122.49786249135201 | (37.7804150560022, -122.497862491352) | |||
159311 | 159311 | 183377 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2651 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5989551.7412 | 2097288.806 | 37.738153824368204 | -122.478655737727 | (37.7381538243682, -122.478655737727) | |||
160642 | 160642 | 214409 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 319 Kensington Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994299.528 | 2098982.87958 | 37.7430798480616 | -122.462363217409 | (37.7430798480616, -122.462363217409) | |||
162160 | 162160 | 238014 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 77 Ashbury Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5999606.96605 | 2106732.73135 | 37.7646632372481 | -122.444568471453 | (37.7646632372481, -122.444568471453) | |||
162372 | 162372 | 141250 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 42 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5996544.0519 | 2114280.1621 | 37.7852112604093 | -122.455707816901 | (37.7852112604093, -122.455707816901) | |||
162852 | 162852 | 140802 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 JORDAN AVE | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5996233.7192 | 2113991.8267 | 37.7844017542187 | -122.45676060516199 | (37.7844017542187, -122.456760605162) | |||
172286 | 172286 | 182571 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2208 Ulloa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989133.5167 | 2098356.5835 | 37.7410613722493 | -122.480179859895 | (37.7410613722493, -122.480179859895) | |||
172339 | 172339 | 140966 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 159 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5996524.4235 | 2113288.9246 | 37.782488459378 | -122.455704048946 | (37.782488459378, -122.455704048946) | |||
173783 | 173783 | 214446 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 500 Magellan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993157.34712 | 2099454.9185599997 | 37.744310110719205 | -122.46634683724 | (37.7443101107192, -122.46634683724) | |||
174540 | 174540 | 184306 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1562 38th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5984381.1972 | 2104548.1361 | 37.757784389614 | -122.497068306014 | (37.757784389614, -122.497068306014) | |||
175247 | 175247 | 238016 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 50 Ashbury Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5999571.744519999 | 2106835.86862 | 37.7649444165749 | -122.44469770674 | (37.7649444165749, -122.44469770674) | |||
176116 | 176116 | 183842 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2222 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5987636.2237 | 2100151.1028 | 37.745901531101396 | -122.485488547623 | (37.7459015311014, -122.485488547623) | |||
176610 | 176610 | 135908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 405 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6011535.18315 | 2119025.39151 | 37.7990894272815 | -122.40417692455 | (37.7990894272815, -122.40417692455) | |||
177635 | 177635 | 118425 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981790.15899 | 2111638.01027 | 37.7770989536906 | -122.506554832582 | (37.7770989536906, -122.506554832582) | |||
182223 | 182223 | 214385 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1955 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 5993134.95065 | 2102190.16883 | 37.7518191170825 | -122.46662305770501 | (37.7518191170825, -122.466623057705) | |||
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) | ||||
183024 | 183024 | 185612 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2101 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5985702.4651 | 2100891.7117 | 37.7478221885491 | -122.492229646849 | (37.7478221885491, -122.492229646849) | |||
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) | ||||
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) | ||||
184229 | 184229 | 218417 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 206 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5994252.951119999 | 2100616.68956 | 37.7475631968785 | -122.462642758156 | (37.7475631968785, -122.462642758156) | |||
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) | ||||
184575 | 184575 | 182425 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1538 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988098.2611 | 2104825.7625 | 37.758763800953005 | -122.484233676535 | (37.758763800953, -122.484233676535) | |||
186044 | 186044 | 185736 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2119 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5987568.4406 | 2100856.1259 | 37.7478333870661 | -122.485774665371 | (37.7478333870661, -122.485774665371) | |||
186494 | 186494 | 182276 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3150 Kirkham St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985061.2024 | 2105018.6781 | 37.759116193094 | -122.494751291704 | (37.759116193094, -122.494751291704) | |||
189051 | 189051 | 118424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5981802.00316 | 2111639.4369 | 37.7771035681701 | -122.50651396642 | (37.7771035681701, -122.50651396642) | |||
189121 | 189121 | 214450 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 45 Dorantes Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994111.5037 | 2100039.81972 | 37.7459711108718 | -122.463090021601 | (37.7459711108718, -122.463090021601) |
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");