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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97285 | 97285 | 102172 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 143029 | 143029 | 102171 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 92691 | 92691 | 52391 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 99103 | 99103 | 52390 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 119408 | 119408 | 52392 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 145547 | 145547 | 52389 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 99X Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48514 | 6005316.06148505 | 2096495.16732584 | 37.7368773658256 | -122.42409409520599 | (37.7368773658256, -122.424094095206) |
| 8877 | 8877 | 103815 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Hemlock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006959.84507 | 2114826.77891 | 37.7873043685578 | -122.419711106691 | (37.7873043685578, -122.419711106691) | ||
| 9028 | 9028 | 103814 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Hemlock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006931.25215 | 2114822.01169 | 37.787289668217795 | -122.41980969397 | (37.7872896682178, -122.41980969397) | ||
| 113153 | 113153 | 106104 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X HARTFORD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x3 | 6002644.0 | 2105609.0 | 37.761750572206104 | -122.433983855891 | (37.7617505722061, -122.433983855891) | |||
| 95984 | 95984 | 103790 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.788327510680205 | -122.41938487643999 | (37.7883275106802, -122.41938487644) | ||
| 108374 | 108374 | 103789 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.788327510680205 | -122.41938487643999 | (37.7883275106802, -122.41938487644) | ||
| 139518 | 139518 | 103788 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.788327510680205 | -122.41938487643999 | (37.7883275106802, -122.41938487644) | ||
| 88514 | 88514 | 28851 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 90239 | 90239 | 28855 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 105963 | 105963 | 28850 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 123223 | 123223 | 28852 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 139447 | 139447 | 28854 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 141442 | 141442 | 28853 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 96428 | 96428 | 117621 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999X BRAZIL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6004288.0 | 2090756.0 | 37.7210607924735 | -122.42723986886601 | (37.7210607924735, -122.427239868866) | |||
| 105246 | 105246 | 117625 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999X BRAZIL AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6004288.0 | 2090756.0 | 37.7210607924735 | -122.42723986886601 | (37.7210607924735, -122.427239868866) | |||
| 116417 | 116417 | 117623 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999X BRAZIL AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6004288.0 | 2090756.0 | 37.7210607924735 | -122.42723986886601 | (37.7210607924735, -122.427239868866) | |||
| 43631 | 43631 | 50013 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 999 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2009 12:00:00 AM | 2 | Permit Number 52022 | 6012813.23846 | 2102916.22313 | 37.7549286606329 | -122.398623329429 | (37.7549286606329, -122.398623329429) | ||
| 151180 | 151180 | 50012 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 999 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2009 12:00:00 AM | 3 | Permit Number 52022 | 6012815.30679 | 2102898.98068 | 37.7548814318474 | -122.398614966606 | (37.7548814318474, -122.398614966606) | ||
| 155812 | 155812 | 92795 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 999 Wisconsin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 52022 | 6012811.72806 | 2102960.97452 | 37.755051454067505 | -122.398631693097 | (37.7550514540675, -122.398631693097) | ||
| 164625 | 164625 | 235855 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008625.313519999 | 2102772.01425 | 37.7542984832041 | -122.41309620812001 | (37.7542984832041, -122.41309620812) | |||
| 78401 | 78401 | 49775 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 996@ ORDWAY Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | ||
| 92628 | 92628 | 49774 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 996@ ORDWAY Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | ||
| 93261 | 93261 | 67116 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 994 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30535 | 5998844.26522705 | 2106564.92896199 | 37.7641589439786 | -122.447194363227 | (37.7641589439786, -122.447194363227) | ||
| 147971 | 147971 | 236445 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 994 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998851.72609 | 2106478.89575 | 37.763923144673704 | -122.447162366272 | (37.7639231446737, -122.447162366272) | |||
| 53262 | 53262 | 238586 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 991 San Bruno Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 6011096.081069999 | 2103736.7001400003 | 37.7570856908704 | -122.40461953036501 | (37.7570856908704, -122.404619530365) | |||
| 80315 | 80315 | 88754 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 990 Polk St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284.0 | 37.785814090273796 | -122.41966893082501 | (37.7858140902738, -122.419668930825) | ||
| 89010 | 89010 | 88756 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 990 Polk St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284.0 | 37.785814090273796 | -122.41966893082501 | (37.7858140902738, -122.419668930825) | ||
| 90494 | 90494 | 88757 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 990 Polk St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284.0 | 37.785814090273796 | -122.41966893082501 | (37.7858140902738, -122.419668930825) | ||
| 122948 | 122948 | 88758 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 990 Polk St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284.0 | 37.785814090273796 | -122.41966893082501 | (37.7858140902738, -122.419668930825) | ||
| 128943 | 128943 | 88755 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 990 Polk St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284.0 | 37.785814090273796 | -122.41966893082501 | (37.7858140902738, -122.419668930825) | ||
| 155001 | 155001 | 65968 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 990 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1990 12:00:00 AM | 4 | Permit Number 28992 | 6007125.46509 | 2120550.16631 | 37.8030286907859 | -122.419544310327 | (37.8030286907859, -122.419544310327) | ||
| 25052 | 25052 | 196384 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 6013750.52811 | 2112736.60264 | 37.781945415491705 | -122.396070069587 | (37.7819454154917, -122.396070069587) | |||
| 179071 | 179071 | 67710 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 7 | Permit Number 31321 | 6013724.697430001 | 2112718.68187 | 37.7818947719595 | -122.396158176154 | (37.7818947719595, -122.396158176154) | |
| 130993 | 130993 | 236272 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007737.48047 | 2107411.94537 | 37.76698878242561 | -122.416495215585 | (37.7669887824256, -122.416495215585) | |||
| 171691 | 171691 | 236271 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007736.0102 | 2107427.5754299997 | 37.7670316162303 | -122.416501408308 | (37.7670316162303, -122.416501408308) | |||
| 42915 | 42915 | 214589 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Lurline St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991796.94128 | 2105115.28006 | 37.7597734011291 | -122.47146315499701 | (37.7597734011291, -122.471463154997) | |||
| 57314 | 57314 | 214586 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Lurline St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991797.242819999 | 2105160.13834 | 37.759896587568896 | -122.471465380821 | (37.7598965875689, -122.471465380821) | |||
| 175566 | 175566 | 214587 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Lurline St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991795.61852 | 2105144.1496 | 37.7598525927434 | -122.47146983337299 | (37.7598525927434, -122.471469833373) | |||
| 177523 | 177523 | 214588 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Lurline St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991798.55182 | 2105130.62844 | 37.7598156368994 | -122.47145870337299 | (37.7598156368994, -122.471458703373) | |||
| 4125 | 4125 | 135979 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.63841 | 2115164.21663 | 37.788227554109504 | -122.419939904112 | (37.7882275541095, -122.419939904112) | ||
| 4128 | 4128 | 135978 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006877.42 | 2115159.3392 | 37.788212853775896 | -122.420019889812 | (37.7882128537759, -122.420019889812) | ||
| 54786 | 54786 | 238038 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Elgin Park | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6005844.524569999 | 2108573.0044 | 37.7700701367551 | -122.423125198471 | (37.7700701367551, -122.423125198471) | |||
| 152297 | 152297 | 238037 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Elgin Park | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6005845.91582 | 2108560.6963400003 | 37.770036420279006 | -122.423119511166 | (37.770036420279, -122.423119511166) | |||
| 180662 | 180662 | 235668 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Elgin Park | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6005845.909440001 | 2108547.05251 | 37.7699989572271 | -122.423118563291 | (37.7699989572271, -122.423118563291) | |||
| 30587 | 30587 | 178835 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Drake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001544.783340001 | 2086699.50707 | 37.709767045691294 | -122.436432165527 | (37.7097670456913, -122.436432165527) | |||
| 53625 | 53625 | 178836 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Drake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001534.9682599995 | 2086713.04585 | 37.7098036624786 | -122.436467056534 | (37.7098036624786, -122.436467056534) | |||
| 167416 | 167416 | 178834 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Drake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6001553.31629 | 2086683.73815 | 37.7097242325659 | -122.43640154631201 | (37.7097242325659, -122.436401546312) | |||
| 176572 | 176572 | 178833 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 99 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 6ft | 6001567.75342 | 2086664.56423 | 37.709672405530796 | -122.43635027774401 | (37.7096724055308, -122.436350277744) | |||
| 31357 | 31357 | 237945 | Undocumented 2 | Prunus spp :: Cherry 84 | 99 Aztec St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6007968.29609 | 2099608.22097 | 37.7455745134701 | -122.415144412305 | (37.7455745134701, -122.415144412305) | ||||
| 100305 | 100305 | 103832 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Myrtle St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.7906599995 | 2114178.2136 | 37.7855373621017 | -122.41881763042299 | (37.7855373621017, -122.418817630423) | ||
| 107032 | 107032 | 103833 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Myrtle St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.7906599995 | 2114178.2136 | 37.7855373621017 | -122.41881763042299 | (37.7855373621017, -122.418817630423) | ||
| 113587 | 113587 | 103831 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Myrtle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.7906599995 | 2114178.2136 | 37.7855373621017 | -122.41881763042299 | (37.7855373621017, -122.418817630423) | ||
| 114756 | 114756 | 41603 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 98X Hoff St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | 8 | 3x3 | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.42047837166099 | (37.7634444777116, -122.420478371661) | |
| 1237 | 1237 | 103805 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Hemlock St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006953.73656 | 2114843.50125 | 37.7873499398897 | -122.41973342786999 | (37.7873499398897, -122.41973342787) | ||
| 4456 | 4456 | 103803 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Hemlock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007001.17193 | 2114849.4881599997 | 37.7873690504995 | -122.419569735969 | (37.7873690504995, -122.419569735969) | ||
| 5481 | 5481 | 103804 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Hemlock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006974.73956 | 2114845.21209 | 37.7873558205593 | -122.419660883156 | (37.7873558205593, -122.419660883156) | ||
| 8222 | 8222 | 103806 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Hemlock St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006930.58351 | 2114841.83487 | 37.787344060129705 | -122.419813414468 | (37.7873440601297, -122.419813414468) | ||
| 83638 | 83638 | 115104 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 98X HEMLOCK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006944.0 | 2114961.0 | 37.787672014079206 | -122.419775454842 | (37.7876720140792, -122.419775454842) | ||||
| 83985 | 83985 | 115105 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 98X HEMLOCK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006944.0 | 2114961.0 | 37.787672014079206 | -122.419775454842 | (37.7876720140792, -122.419775454842) | ||||
| 88654 | 88654 | 115106 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 98X HEMLOCK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006944.0 | 2114961.0 | 37.787672014079206 | -122.419775454842 | (37.7876720140792, -122.419775454842) | ||||
| 146157 | 146157 | 115103 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 98X HEMLOCK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006944.0 | 2114961.0 | 37.787672014079206 | -122.419775454842 | (37.7876720140792, -122.419775454842) | |||
| 98949 | 98949 | 53019 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 98@ 9TH AVE Sotelo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | Permit Number 48999 | 5993583.56657104 | 2101415.66580256 | 37.7497184085015 | -122.46501544964501 | (37.7497184085015, -122.465015449645) | |||
| 17165 | 17165 | 23041 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 987 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1994 12:00:00 AM | 12 | 3X3 | 6006352.9755 | 2103862.85209 | 37.7571658456457 | -122.421031987753 | (37.7571658456457, -122.421031987753) | ||
| 113453 | 113453 | 26851 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 987 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6006383.06935 | 2103878.3785200003 | 37.7572101739855 | -122.420929013752 | (37.7572101739855, -122.420929013752) | |||
| 154117 | 154117 | 83424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 987 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 3 | 6012206.17554 | 2103813.0860099997 | 37.7573574093248 | -122.400785742066 | (37.7573574093248, -122.400785742066) | ||
| 92890 | 92890 | 35815 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 985 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 39053 | 6006347.1524299 | 2103860.86986085 | 37.7571600746524 | -122.42105198546999 | (37.7571600746524, -122.42105198547) | ||
| 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) | |||
| 40596 | 40596 | 69408 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 981 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33513 | 6001538.598040001 | 2086768.9797900002 | 37.7099574510375 | -122.43645851206301 | (37.7099574510375, -122.436458512063) | |
| 60318 | 60318 | 178838 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 981 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001561.306469999 | 2086771.17725 | 37.7099647751299 | -122.436380184711 | (37.7099647751299, -122.436380184711) | |||
| 99158 | 99158 | 178837 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 981 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001551.41306 | 2086770.9715900002 | 37.7099636482706 | -122.43641436345301 | (37.7099636482706, -122.436414363453) | |||
| 108284 | 108284 | 86728 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 980 Huron Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49704 | 5996769.2 | 2086717.1 | 37.7095428329763 | -122.452938628006 | (37.7095428329763, -122.452938628006) | ||||
| 134446 | 134446 | 178705 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 980 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996782.39454 | 2086708.5296099999 | 37.7095200567877 | -122.452892407466 | (37.7095200567877, -122.452892407466) | |||
| 57298 | 57298 | 235757 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005370.52103 | 2099351.03927 | 37.7447220191116 | -122.424108842766 | (37.7447220191116, -122.424108842766) | |||
| 1998 | 1998 | 135937 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 98 Spruce St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780098 | 5997052.02369 | 2116054.59656 | 37.7901125223289 | -122.45407860247299 | (37.7901125223289, -122.454078602473) | |
| 49995 | 49995 | 135934 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997041.86737 | 2116129.80097 | 37.790318431109704 | -122.454119176269 | (37.7903184311097, -122.454119176269) | |||
| 63980 | 63980 | 135933 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997039.44005 | 2116145.17864 | 37.790360514882394 | -122.45412868571002 | (37.7903605148824, -122.45412868571) | |||
| 158254 | 158254 | 135936 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Spruce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997050.12682 | 2116069.05064 | 37.7901521005919 | -122.45408620982501 | (37.7901521005919, -122.454086209825) | |||
| 179105 | 179105 | 135935 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Spruce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997049.33252 | 2116083.6644599997 | 37.7901921806791 | -122.45409001393999 | (37.7901921806791, -122.45409001394) | |||
| 186426 | 186426 | 214765 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5993613.7342 | 2101408.96874 | 37.7497017595309 | -122.464910643325 | (37.7497017595309, -122.464910643325) | |||
| 82584 | 82584 | 35849 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 98 Russia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | Permit Number 39073 | 6001624.34206398 | 2090846.82261337 | 37.7211591730388 | -122.43645383368401 | (37.7211591730388, -122.436453833684) | ||
| 97773 | 97773 | 35848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 98 Russia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | Permit Number 39073 | 6001624.34206398 | 2090846.82261337 | 37.7211591730388 | -122.43645383368401 | (37.7211591730388, -122.436453833684) | ||
| 109478 | 109478 | 35846 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 98 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | Permit Number 39073 | 6001624.34206398 | 2090846.82261337 | 37.7211591730388 | -122.43645383368401 | (37.7211591730388, -122.436453833684) | ||
| 141697 | 141697 | 35847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 98 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | Permit Number 39073 | 6001624.34206398 | 2090846.82261337 | 37.7211591730388 | -122.43645383368401 | (37.7211591730388, -122.436453833684) | ||
| 133685 | 133685 | 202276 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012835.94642 | 2093268.61779 | 37.7284396378725 | -122.39786808953998 | (37.7284396378725, -122.39786808954) | |||
| 69810 | 69810 | 65716 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 98 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 7 | 3x3 | Permit Number 28648 | 6000919.98791 | 2088014.07766 | 37.7133410423274 | -122.438685700186 | (37.7133410423274, -122.438685700186) |
| 74923 | 74923 | 196096 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 Missouri St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6013385.07965 | 2106714.42564 | 37.765389536021296 | -122.39691200949301 | (37.7653895360213, -122.396912009493) | |||
| 146941 | 146941 | 196095 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013384.4505199995 | 2106734.28469 | 37.7654440295562 | -122.396915577987 | (37.7654440295562, -122.396915577987) | |||
| 154637 | 154637 | 196097 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 Missouri St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6013386.06824 | 2106698.22763 | 37.7653451148996 | -122.396907454408 | (37.7653451148996, -122.396907454408) | |||
| 174295 | 174295 | 235689 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 Laussat St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004329.17404 | 2109279.26981 | 37.7719237393213 | -122.428417123276 | (37.7719237393213, -122.428417123276) | |||
| 167017 | 167017 | 36182 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 98 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 6 | Permit Number 39251 | 5996240.3184 | 2113866.2722 | 37.7840573939643 | -122.456728690929 | (37.7840573939643, -122.456728690929) | |
| 44976 | 44976 | 140824 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 JORDAN AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5996239.98 | 2113878.2862 | 37.784090361774794 | -122.456730730831 | (37.7840903617748, -122.456730730831) | |||
| 30148 | 30148 | 237085 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Hoff St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006552.13964 | 2106214.02177 | 37.7636328345225 | -122.420510089594 | (37.7636328345225, -122.420510089594) | |||
| 66450 | 66450 | 237084 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Hoff St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006548.40896 | 2106250.77586 | 37.7637335423826 | -122.420525601982 | (37.7637335423826, -122.420525601982) | |||
| 4141 | 4141 | 135981 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | Width 4ft | 6006885.98637 | 2115183.79121 | 37.7882804756017 | -122.419991987453 | (37.7882804756017, -122.419991987453) | ||
| 4143 | 4143 | 135982 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | Width 4ft | 6006867.714380001 | 2115184.1661400003 | 37.788280475609795 | -122.420055232261 | (37.7882804756098, -122.420055232261) |
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");