Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||
| 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 | |||||||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 158933 | 158933 | 196200 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6013682.55541 | 2111829.59348 | 37.7794511934496 | -122.396241636866 | (37.7794511934496, -122.396241636866) | |||
| 159252 | 159252 | 196208 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013488.1481 | 2111645.63657 | 37.778935270397206 | -122.396901277881 | (37.7789352703972, -122.396901277881) | |||
| 166958 | 166958 | 196199 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6013692.0119 | 2111837.7722 | 37.7794741765351 | -122.396209495994 | (37.7794741765351, -122.396209495994) | |||
| 168103 | 168103 | 196201 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013661.85599 | 2111812.39055 | 37.7794028063227 | -122.396312039369 | (37.7794028063227, -122.396312039369) | |||
| 182692 | 182692 | 196202 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Freelon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6013641.30182 | 2111791.44038 | 37.779344138168895 | -122.396381676574 | (37.7793441381689, -122.396381676574) | |||
| 42760 | 42760 | 212608 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995646.24598 | 2089933.0697299999 | 37.718308715656704 | -122.45705219282699 | (37.7183087156567, -122.457052192827) | |||
| 71201 | 71201 | 236654 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006198.97088 | 2103487.79706 | 37.7561273490041 | -122.42153795981301 | (37.7561273490041, -122.421537959813) | |||
| 135709 | 135709 | 212315 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996111.7334 | 2106830.07991 | 37.764730469656 | -122.45666452114901 | (37.764730469656, -122.456664521149) | |||
| 168699 | 168699 | 247958 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010403.29697 | 2098902.73698 | 37.7437739492996 | -122.406674804102 | (37.7437739492996, -122.406674804102) | ||||
| 37243 | 37243 | 202167 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Kalmanovitz St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6013164.547619999 | 2093230.83795 | 37.7283541968866 | -122.396729443526 | (37.7283541968866, -122.396729443526) | |||
| 45654 | 45654 | 202165 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Kalmanovitz St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 2ft | 6013169.468859999 | 2093279.75554 | 37.7284887885067 | -122.39671585835698 | (37.7284887885067, -122.396715858357) | |||
| 64207 | 64207 | 202166 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Kalmanovitz St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 6013167.38298 | 2093268.67632 | 37.7284582511357 | -122.39672229302201 | (37.7284582511357, -122.396722293022) | |||
| 186399 | 186399 | 202168 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Kalmanovitz St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6013157.76295 | 2093232.82928 | 37.728359287049706 | -122.396753038148 | (37.7283592870497, -122.396753038148) | |||
| 31422 | 31422 | 237707 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Levant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000247.199630001 | 2106827.67898 | 37.764960451486004 | -122.44236089665002 | (37.764960451486, -122.44236089665) | |||
| 173487 | 173487 | 237708 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Levant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6000245.79944 | 2106807.6241 | 37.764905305964206 | -122.442364299668 | (37.7649053059642, -122.442364299668) | |||
| 29000 | 29000 | 237789 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Loma Vista Ter | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5999974.87074 | 2106875.7261900003 | 37.7650768516417 | -122.443306262176 | (37.7650768516417, -122.443306262176) | |||
| 48155 | 48155 | 237787 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Loma Vista Ter | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5999975.78391 | 2106902.16823 | 37.76514950696679 | -122.44330500312701 | (37.7651495069668, -122.443305003127) | |||
| 59446 | 59446 | 237788 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Loma Vista Ter | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5999974.057569999 | 2106889.15487 | 37.7651136770803 | -122.44331003932699 | (37.7651136770803, -122.443310039327) | |||
| 151324 | 151324 | 237790 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Loma Vista Ter | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5999973.591030001 | 2106866.6906 | 37.765051969188704 | -122.443310039322 | (37.7650519691887, -122.443310039322) | |||
| 165156 | 165156 | 69496 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 10 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 6 | Permit Number 33619 | 6000930.02783 | 2092989.43743 | 37.7270028279165 | -122.439007348127 | (37.7270028279165, -122.439007348127) | |
| 60101 | 60101 | 135697 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Walnut St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5998449.317000001 | 2116481.46771 | 37.7913646187353 | -122.449274868335 | (37.7913646187353, -122.449274868335) | |||
| 172696 | 172696 | 135698 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Walnut St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5998453.121780001 | 2116461.2064400003 | 37.7913092042995 | -122.449260243563 | (37.7913092042995, -122.449260243563) | |||
| 175435 | 175435 | 236824 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997056.16867 | 2106590.5026700003 | 37.7641268320976 | -122.453380686287 | (37.7641268320976, -122.453380686287) | |||
| 57160 | 57160 | 46089 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2001 12:00:00 AM | 3 | Permit Number 44465 | 5989928.0373599995 | 2114622.7859900002 | 37.7857701098965 | -122.478621999998 | (37.7857701098965, -122.478621999998) | ||
| 146276 | 146276 | 33499 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37589 | 6006683.58482984 | 2099106.89574168 | 37.74412570540729 | -122.419551194294 | (37.7441257054073, -122.419551194294) | |||
| 38558 | 38558 | 57413 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1976 12:00:00 AM | 5 | Permit Number 16255 | 5996562.3267 | 2113747.4862 | 37.78374972289961 | -122.455606076565 | (37.7837497228996, -122.455606076565) | ||
| 104017 | 104017 | 102628 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/2013 12:00:00 AM | 3x3 | Permit Number 769972 | 6013417.4 | 2111578.2 | 37.778746166691 | -122.397141295625 | (37.778746166691, -122.397141295625) | |
| 60094 | 60094 | 178818 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Ina Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6004783.72135 | 2091297.0719 | 37.722574479812 | -122.42556479298099 | (37.722574479812, -122.425564792981) | ||||
| 74220 | 74220 | 214218 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001377.44838 | 2094959.38668 | 37.7324373042189 | -122.43760164301399 | (37.7324373042189, -122.437601643014) | |||
| 149527 | 149527 | 214291 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999381.70111 | 2093509.42542 | 37.7283423752946 | -122.444397221682 | (37.7283423752946, -122.444397221682) |
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");