Data source: data.sfgov.org
This data as json, CSV (advanced)
qCaretaker ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5325 | 5325 | 40088 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1999 12:00:00 AM | Permit Number 41311 | |||||||||
5746 | 5746 | 31847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
7293 | 7293 | 31848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
9510 | 9510 | 46857 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | Permit Number 44926 | |||||||||
11795 | 11795 | 31846 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
11986 | 11986 | 31849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
13223 | 13223 | 33083 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
14881 | 14881 | 33084 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
15875 | 15875 | 31850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
15956 | 15956 | 31845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
3013 | 3013 | 39333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
5518 | 5518 | 39334 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
6740 | 6740 | 39332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
14197 | 14197 | 39331 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
168210 | 168210 | 218135 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 0 Noriega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5992409.03176 | 2103467.31015 | 37.7552838973381 | -122.469226308173 | (37.7552838973381, -122.469226308173) | |||
29380 | 29380 | 196093 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 25 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014406.1146599995 | 2105887.9731 | 37.763177058994 | -122.39332261913601 | (37.763177058994, -122.393322619136) | ||||
132015 | 132015 | 196092 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 24 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014425.82588 | 2105887.0502299997 | 37.7631756200823 | -122.393254379501 | (37.7631756200823, -122.393254379501) | ||||
152443 | 152443 | 196094 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 26 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014400.8809 | 2105882.83985 | 37.7631626734333 | -122.393340361863 | (37.7631626734333, -122.393340361863) | ||||
131128 | 131128 | 123933 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5993312.90228 | 2114946.82765 | 37.7868557832667 | -122.466934987319 | (37.7868557832667, -122.466934987319) | ||||
149532 | 149532 | 123932 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5993304.79465 | 2114951.8615900003 | 37.7868691371328 | -122.46696340370801 | (37.7868691371328, -122.466963403708) | ||||
30029 | 30029 | 196074 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 7 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014974.36324 | 2102149.68411 | 37.7529440736099 | -122.391095913948 | (37.7529440736099, -122.391095913948) | ||||
33649 | 33649 | 196072 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 4 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014990.91174 | 2102121.65719 | 37.7528680359305 | -122.391036726872 | (37.7528680359305, -122.391036726872) | ||||
66873 | 66873 | 196280 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 11 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015022.69172 | 2102195.1938 | 37.7530717153135 | -122.39093196394501 | (37.7530717153135, -122.390931963945) | ||||
74692 | 74692 | 196073 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 5 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014983.580569999 | 2102134.9117099997 | 37.752904023218605 | -122.391063005979 | (37.7529040232186, -122.391063005979) | ||||
130300 | 130300 | 196281 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 12 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015018.372359999 | 2102200.19302 | 37.7530852024401 | -122.39094725063102 | (37.7530852024401, -122.390947250631) | ||||
130498 | 130498 | 196075 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 17 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014963.469190001 | 2102214.24517 | 37.753120740043705 | -122.391138100256 | (37.7531207400437, -122.391138100256) | ||||
132022 | 132022 | 196279 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 6 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014984.46572 | 2102135.07494 | 37.7529045205317 | -122.39105995634701 | (37.7529045205317, -122.391059956347) | ||||
133863 | 133863 | 196076 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 18 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014971.87416 | 2102223.03647 | 37.753145345506795 | -122.39110964840401 | (37.7531453455068, -122.391109648404) | ||||
137606 | 137606 | 196282 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 13 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015015.25562 | 2102205.64875 | 37.75310000977571 | -122.39095841029499 | (37.7531000097757, -122.390958410295) | ||||
151585 | 151585 | 196077 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 25th St | 19 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014960.28506 | 2102234.79181 | 37.7531769800583 | -122.391150547759 | (37.7531769800583, -122.391150547759) | ||||
27679 | 27679 | 234916 | Undocumented 2 | Prunus spp :: Cherry 84 | 1 Albion St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005792.88209 | 2107221.84485 | 37.766357260514 | -122.423207770616 | (37.766357260514, -122.423207770616) | |||
76634 | 76634 | 237056 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Albion St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6005793.31637 | 2107190.9812 | 37.7662725407724 | -122.423204074428 | (37.7662725407724, -122.423204074428) | |||
151398 | 151398 | 237057 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Albion St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6005792.84324 | 2107206.9501900002 | 37.766316361124204 | -122.423206846131 | (37.7663163611242, -122.423206846131) | |||
177339 | 177339 | 237055 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Albion St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6005794.81287 | 2107159.8300900003 | 37.7661870916781 | -122.42319668379601 | (37.7661870916781, -122.423196683796) | |||
188326 | 188326 | 237054 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6005797.6398599995 | 2107141.4188 | 37.766136698186706 | -122.423185596933 | (37.7661366981867, -122.423185596933) | |||
89563 | 89563 | 84122 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 Alpha St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50683 | 6011538.02534932 | 2088764.33012973 | 37.715999417407495 | -122.402038569068 | (37.7159994174075, -122.402038569068) | ||
110550 | 110550 | 84281 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 Alpha St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50683 | 6011538.02534932 | 2088764.33012973 | 37.715999417407495 | -122.402038569068 | (37.7159994174075, -122.402038569068) | ||
122516 | 122516 | 84282 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 Alpha St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50683 | 6011538.02534932 | 2088764.33012973 | 37.715999417407495 | -122.402038569068 | (37.7159994174075, -122.402038569068) | ||
59649 | 59649 | 236881 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Ashbury Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999527.40106 | 2106977.39106 | 37.7653304712372 | -122.44486125295099 | (37.7653304712372, -122.444861252951) | |||
42481 | 42481 | 71284 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 5 | 5998802.9816 | 2111041.8064 | 37.7764489521659 | -122.447659448254 | (37.7764489521659, -122.447659448254) | ||
80000 | 80000 | 35936 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 Bache St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/1998 12:00:00 AM | Permit Number 39099 | 6007238.86373216 | 2095730.63225463 | 37.7348864958229 | -122.41739193639299 | (37.7348864958229, -122.417391936393) | |||
103105 | 103105 | 35935 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 Bache St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/1998 12:00:00 AM | Permit Number 39099 | 6007238.86373216 | 2095730.63225463 | 37.7348864958229 | -122.41739193639299 | (37.7348864958229, -122.417391936393) | |||
117049 | 117049 | 35934 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 Bache St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/1998 12:00:00 AM | Permit Number 39099 | 6007238.86373216 | 2095730.63225463 | 37.7348864958229 | -122.41739193639299 | (37.7348864958229, -122.417391936393) | |||
68818 | 68818 | 217865 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Belmont Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5996682.74655 | 2106173.09082 | 37.7629593142538 | -122.45464207989401 | (37.7629593142538, -122.454642079894) | |||
146573 | 146573 | 217864 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Belmont Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5996697.2006 | 2106163.46533 | 37.7629337141391 | -122.454591393188 | (37.7629337141391, -122.454591393188) | |||
152247 | 152247 | 217866 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Belmont Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5996652.66876 | 2106194.7988299998 | 37.7630171937018 | -122.454747676471 | (37.7630171937018, -122.454747676471) | |||
159244 | 159244 | 217867 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Belmont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5996638.61304 | 2106204.01086 | 37.763041681342 | -122.45479695573299 | (37.763041681342, -122.454796955733) | |||
38826 | 38826 | 237101 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Dearborn St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005826.7194 | 2106021.63498 | 37.7630636778686 | -122.423005419568 | (37.7630636778686, -122.423005419568) | |||
42225 | 42225 | 237100 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Dearborn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005826.477630001 | 2105998.8251400003 | 37.7630010337862 | -122.42300463446101 | (37.7630010337862, -122.423004634461) | |||
49810 | 49810 | 241024 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001778.75794 | 2099104.0320099997 | 37.7438403462637 | -122.436510768958 | (37.7438403462637, -122.436510768958) | |||
130419 | 130419 | 241025 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1 Gold Mine Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001786.88467 | 2099119.61673 | 37.74388360003871 | -122.43648378390199 | (37.7438836000387, -122.436483783902) | |||
38273 | 38273 | 202293 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Issleib Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 6012754.8343 | 2093244.37958 | 37.7283685671459 | -122.39814680025499 | (37.7283685671459, -122.398146800255) | |||
73712 | 73712 | 202295 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Issleib Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 6012780.58541 | 2093228.85419 | 37.7283273718953 | -122.398056688169 | (37.7283273718953, -122.398056688169) | |||
132706 | 132706 | 202294 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Issleib Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 6012769.019119999 | 2093237.37262 | 37.7283501175462 | -122.398097270977 | (37.7283501175462, -122.398097270977) | |||
147991 | 147991 | 202291 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Issleib Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 6012719.32075 | 2093257.8431 | 37.728403557061895 | -122.398270517286 | (37.7284035570619, -122.398270517286) | |||
34763 | 34763 | 196288 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012383.755890001 | 2104753.48944 | 37.7599494533344 | -122.40023764215799 | (37.7599494533344, -122.400237642158) | ||||
35147 | 35147 | 196292 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012388.17486 | 2104794.0427599996 | 37.760061050199596 | -122.400225207229 | (37.7600610501996, -122.400225207229) | ||||
45385 | 45385 | 196287 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012398.9699099995 | 2104759.28758 | 37.7599662220764 | -122.400185431124 | (37.7599662220764, -122.400185431124) | ||||
46448 | 46448 | 196295 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012406.535130001 | 2104796.6998799997 | 37.760069369818396 | -122.400161894071 | (37.7600693698184, -122.400161894071) | ||||
53555 | 53555 | 196289 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6012382.84954 | 2104763.06022 | 37.7599756820445 | -122.400241449008 | (37.7599756820445, -122.400241449008) | ||||
69480 | 69480 | 196293 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012394.755369999 | 2104793.13157 | 37.760058915200894 | -122.40020238425899 | (37.7600589152009, -122.400202384259) | ||||
72281 | 72281 | 196286 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6012387.37414 | 2104738.06992 | 37.7599073164914 | -122.40022404532301 | (37.7599073164914, -122.400224045323) | ||||
132745 | 132745 | 196291 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012380.38083 | 2104793.15065 | 37.7600581660633 | -122.40025210055401 | (37.7600581660633, -122.400252100554) | ||||
151012 | 151012 | 196294 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012397.7351 | 2104775.9114900003 | 37.7600117988112 | -122.400190869313 | (37.7600117988112, -122.400190869313) | ||||
174122 | 174122 | 196290 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012385.57921 | 2104781.3261 | 37.760025988325296 | -122.400233291241 | (37.7600259883253, -122.400233291241) | ||||
36563 | 36563 | 202259 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1 Kalmanovitz St | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6013218.01399 | 2093376.8881599999 | 37.7287581966316 | -122.396554840154 | (37.7287581966316, -122.396554840154) | ||||
150404 | 150404 | 237804 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Loma Vista Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6000006.51649 | 2106939.02785 | 37.7652524667463 | -122.443201354463 | (37.7652524667463, -122.443201354463) | |||
170839 | 170839 | 237803 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Loma Vista Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6000002.45309 | 2106902.83574 | 37.765152860531 | -122.44321280913601 | (37.765152860531, -122.443212809136) | |||
176936 | 176936 | 237802 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Loma Vista Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6000002.6635 | 2106881.0655400003 | 37.765093096983705 | -122.44321051766899 | (37.7650930969837, -122.443210517669) | |||
153474 | 153474 | 196471 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Middle Point Rd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6018269.46967 | 2096338.3756 | 37.7371696942217 | -122.379297066815 | (37.7371696942217, -122.379297066815) | |||
98840 | 98840 | 42078 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 Norwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42388 | 6009309.20723614 | 2099453.41599437 | 37.7452247183965 | -122.410496799342 | (37.7452247183965, -122.410496799342) | ||
121829 | 121829 | 42077 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42388 | 6009309.20723614 | 2099453.41599437 | 37.7452247183965 | -122.410496799342 | (37.7452247183965, -122.410496799342) | ||
184483 | 184483 | 237163 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009249.65239 | 2099454.9972599996 | 37.7452257212815 | -122.410702842362 | (37.7452257212815, -122.410702842362) | |||
136660 | 136660 | 238536 | Undocumented 2 | Prunus spp :: Cherry 84 | 1 Penny Ln | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002355.478619999 | 2096490.80035 | 37.736697774076 | -122.434329814067 | (37.736697774076, -122.434329814067) | |||
25491 | 25491 | 236748 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Romain St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001094.60828 | 2103699.72105 | 37.7564201071117 | -122.439205717892 | (37.7564201071117, -122.439205717892) | |||
57117 | 57117 | 236747 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Romain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001077.0051 | 2103698.81701 | 37.75641662313279 | -122.439266530936 | (37.7564166231328, -122.439266530936) | |||
69786 | 69786 | 212402 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991904.19278 | 2095912.91043 | 37.734512268621295 | -122.470422033273 | (37.7345122686213, -122.470422033273) | |||
172302 | 172302 | 212403 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 San Rafael Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5991902.57817 | 2095944.2843799999 | 37.734598320237296 | -122.470429899615 | (37.7345983202373, -122.470429899615) | |||
174012 | 174012 | 212401 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991904.4182 | 2095887.6067400002 | 37.7344428040878 | -122.470419411726 | (37.7344428040878, -122.470419411726) | |||
156323 | 156323 | 213482 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Sola Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994974.838219999 | 2100674.05314 | 37.7477622510295 | -122.460150689121 | (37.7477622510295, -122.460150689121) | |||
165527 | 165527 | 238521 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6002789.51517 | 2096155.18282 | 37.7358008721014 | -122.43280519430701 | (37.7358008721014, -122.432805194307) | |||
110198 | 110198 | 84097 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1-3 Romain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50459 | 6001154.30534256 | 2103349.66248879 | 37.7554623279051 | -122.43897417865 | (37.7554623279051, -122.43897417865) | ||
141258 | 141258 | 84096 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1-3 Romain St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50459 | 6001154.30534256 | 2103349.66248879 | 37.7554623279051 | -122.43897417865 | (37.7554623279051, -122.43897417865) | ||
71627 | 71627 | 121889 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 17th Ave | 0 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5990520.54715 | 2115002.72082 | 37.78684768786071 | -122.47659987163799 | (37.7868476878607, -122.476599871638) | |||
52991 | 52991 | 237609 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001055.552759999 | 2104949.38722 | 37.7598491636392 | -122.439430361332 | (37.7598491636392, -122.439430361332) | |||
134692 | 134692 | 237610 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Caselli Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001029.5229400005 | 2104945.6197 | 37.759837337548 | -122.439520115455 | (37.759837337548, -122.439520115455) | |||
147875 | 147875 | 237612 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Caselli Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001004.261469999 | 2104946.80592 | 37.7598391568788 | -122.439607567343 | (37.7598391568788, -122.439607567343) | |||
186867 | 186867 | 237611 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Caselli Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001014.58495 | 2104947.25452 | 37.759840976186396 | -122.43957189572399 | (37.7598409761864, -122.439571895724) | |||
71980 | 71980 | 196271 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Cashmere St | 1 | : 4 | Tree 1 | Private 1 | 31 | 6017110.310380001 | 2095865.5402400002 | 37.7358073912904 | -122.383271945238 | (37.7358073912904, -122.383271945238) | ||||
40170 | 40170 | 213651 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Edgehill Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994859.86261 | 2099088.6488 | 37.743402514010704 | -122.460433407183 | (37.7434025140107, -122.460433407183) | |||
72974 | 72974 | 213652 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Edgehill Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994842.29481 | 2099078.88139 | 37.743374684505206 | -122.46049344413099 | (37.7433746845052, -122.460493444131) | |||
76291 | 76291 | 213654 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Edgehill Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994824.078840001 | 2099066.74247 | 37.7433403061049 | -122.460555550413 | (37.7433403061049, -122.460555550413) | |||
76930 | 76930 | 213653 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Edgehill Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994833.218169999 | 2099074.30171 | 37.7433615876766 | -122.46052449682699 | (37.7433615876766, -122.460524496827) | |||
38648 | 38648 | 68912 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 10 Florence St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32890 | 6008496.870730001 | 2118345.67653 | 37.797052862167604 | -122.41464241973 | (37.7970528621676, -122.41464241973) | |
30216 | 30216 | 196205 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6013581.78975 | 2111736.47585 | 37.77918990623971 | -122.396583701171 | (37.7791899062397, -122.396583701171) | |||
46370 | 46370 | 196203 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013624.81706 | 2111774.8130099997 | 37.7792975658558 | -122.396437538871 | (37.7792975658558, -122.396437538871) | |||
49852 | 49852 | 196204 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013601.37493 | 2111753.2604400003 | 37.7792370828557 | -122.396517124359 | (37.7792370828557, -122.396517124359) | |||
72868 | 72868 | 196206 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6013551.06217 | 2111704.71777 | 37.7791009956579 | -122.39668777431999 | (37.7791009956579, -122.39668777432) | |||
75379 | 75379 | 196198 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6013719.80665 | 2111866.7259400003 | 37.779555223429604 | -122.39611537115 | (37.7795552234296, -122.39611537115) | |||
154401 | 154401 | 196207 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6013520.85267 | 2111676.69387 | 37.779022367025796 | -122.39679031682199 | (37.7790223670258, -122.396790316822) |
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");