Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2489 | 2489 | 119760 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2492 | 2492 | 119762 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2501 | 2501 | 119761 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2508 | 2508 | 119759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 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 | ||||||||
| 5373 | 5373 | 31852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 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 | ||||||||
| 11785 | 11785 | 31851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 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 | |||||||||
| 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 | ||||||||
| 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 | |||||||||
| 44810 | 44810 | 53918 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 188289 | 188289 | 178905 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 320 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999575.27021 | 2086527.1037599999 | 37.7091815546459 | -122.443226763913 | (37.7091815546459, -122.443226763913) | |||
| 172601 | 172601 | 117182 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 26 Watt Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000152.35367 | 2086600.7137400003 | 37.709416560993 | -122.441237557982 | (37.709416560993, -122.441237557982) | |||
| 52388 | 52388 | 178914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993788.47929 | 2086756.5816799998 | 37.7094799730978 | -122.463243292153 | (37.7094799730978, -122.463243292153) | ||||
| 66527 | 66527 | 178915 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993789.8911 | 2086758.89685 | 37.70948641134179 | -122.46323858062 | (37.7094864113418, -122.46323858062) | ||||
| 65590 | 65590 | 178916 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993790.44094 | 2086761.47706 | 37.7094935276652 | -122.46323686739599 | (37.7094935276652, -122.463236867396) | ||||
| 67795 | 67795 | 178907 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993774.9758 | 2086763.55645 | 37.7094983462303 | -122.46329046790501 | (37.7094983462303, -122.463290467905) | ||||
| 183985 | 183985 | 178917 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993792.21408 | 2086763.29106 | 37.7094986106303 | -122.463230870712 | (37.7094986106303, -122.463230870712) | ||||
| 48579 | 48579 | 178918 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993792.015380001 | 2086765.64003 | 37.709505048900496 | -122.46323172778 | (37.7095050489005, -122.46323172778) | ||||
| 76456 | 76456 | 178908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993776.62184 | 2086766.22044 | 37.7095057557476 | -122.463284972138 | (37.7095057557476, -122.463284972138) | ||||
| 184051 | 184051 | 178910 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993781.83724 | 2086767.02745 | 37.7095082720684 | -122.463267005492 | (37.7095082720684, -122.463267005492) | ||||
| 155097 | 155097 | 178919 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5993793.90715 | 2086767.20458 | 37.709509453768604 | -122.463225303004 | (37.7095094537686, -122.463225303004) | ||||
| 58079 | 58079 | 178920 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5993797.37837 | 2086767.25523 | 37.7095097928145 | -122.463213309645 | (37.7095097928145, -122.463213309645) | ||||
| 61631 | 61631 | 178909 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5993779.42986 | 2086768.12245 | 37.70951113998979 | -122.463275405145 | (37.7095111399898, -122.463275405145) | ||||
| 182335 | 182335 | 178911 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993783.22919 | 2086769.82188 | 37.709516025103895 | -122.46326239735201 | (37.7095160251039, -122.463262397352) | ||||
| 34928 | 34928 | 178912 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5993780.74611 | 2086770.03775 | 37.709516474781104 | -122.463270994886 | (37.7095164747811, -122.463270994886) | ||||
| 43104 | 43104 | 178921 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5993794.96049 | 2086770.14434 | 37.7095175863374 | -122.463221875682 | (37.7095175863374, -122.463221875682) | ||||
| 184333 | 184333 | 178913 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5993781.9303 | 2086773.16178 | 37.709525120851396 | -122.463267128695 | (37.7095251208514, -122.463267128695) | ||||
| 117477 | 117477 | 37344 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 571 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39852 | 5999120.28976365 | 2086823.35415522 | 37.7099690371181 | -122.444820521553 | (37.7099690371181, -122.444820521553) | ||
| 155848 | 155848 | 178895 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 240 Concord St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5999918.78145 | 2087003.9139 | 37.7105103506437 | -122.44207374220801 | (37.7105103506437, -122.442073742208) | |||
| 175027 | 175027 | 51531 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 175 Rae Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | 1 | Permit Number 47833 | 5997697.55511 | 2087175.4993200002 | 37.7108546506849 | -122.449763101302 | (37.7108546506849, -122.449763101302) | ||
| 85059 | 85059 | 51530 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 169 Rae Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | Permit Number 47832 | 5997730.87276608 | 2087189.13752554 | 37.710894004264205 | -122.449648930425 | (37.7108940042642, -122.449648930425) | |||
| 66305 | 66305 | 54661 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 2 | Permit Number 10485 | 6012308.35839 | 2086909.49761 | 37.71094938168571 | -122.399245788885 | (37.7109493816857, -122.399245788885) | ||
| 10668 | 10668 | 108896 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 312 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772786 | 6000205.0169 | 2087170.16849 | 37.7109831566161 | -122.441096373403 | (37.7109831566161, -122.441096373403) |
| 170429 | 170429 | 178896 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 424 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6012763.5947 | 2086999.9849599998 | 37.711223202768295 | -122.397678716599 | (37.7112232027683, -122.397678716599) | |||
| 89222 | 89222 | 89359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 308 Tocoloma Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50704 | 6012556.9 | 2087009.2 | 37.7112369933076 | -122.39839375585301 | (37.7112369933076, -122.398393755853) | ||
| 182222 | 182222 | 178965 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 748 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002497.1974599995 | 2087222.1001 | 37.7112560450962 | -122.433177768149 | (37.7112560450962, -122.433177768149) | |||
| 11772 | 11772 | 95029 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 13 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010870.6461 | 2087075.073 | 37.71132378726 | -122.40422653482 | (37.71132378726, -122.40422653482) | |||
| 10780 | 10780 | 26783 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010951.9721 | 2087077.0783 | 37.711333837408205 | -122.40394559103301 | (37.7113338374082, -122.403945591033) | |||
| 12055 | 12055 | 95028 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 21 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010854.6037 | 2087083.0942 | 37.711344915432 | -122.404282545919 | (37.711344915432, -122.404282545919) | |||
| 11844 | 11844 | 95027 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 29 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010839.0069 | 2087091.1154 | 37.711366068478 | -122.404337016935 | (37.711366068478, -122.404337016935) | |||
| 13116 | 13116 | 26784 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010928.7998 | 2087090.8926 | 37.7113704740421 | -122.40402665236999 | (37.7113704740421, -122.40402665237) | |||
| 10565 | 10565 | 94985 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010907.8555 | 2087101.5876 | 37.7113986701374 | -122.40409979381799 | (37.7113986701374, -122.404099793818) | |||
| 11754 | 11754 | 95026 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 33 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010809.5958 | 2087105.821 | 37.7114048035242 | -122.404439704211 | (37.7114048035242, -122.404439704211) | |||
| 12814 | 12814 | 95025 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 37 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010791.7709 | 2087116.9615 | 37.7114343969477 | -122.40450209567699 | (37.7114343969477, -122.404502095677) | |||
| 11522 | 11522 | 94986 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010873.097 | 2087120.3037 | 37.711448118617 | -122.404221245197 | (37.711448118617, -122.404221245197) | |||
| 12283 | 12283 | 95024 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010769.0442 | 2087127.6565 | 37.7114624931322 | -122.404581397838 | (37.7114624931322, -122.404581397838) | |||
| 10438 | 10438 | 95023 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 45 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010750.3281 | 2087136.1233 | 37.711484695229295 | -122.404646681546 | (37.7114846952293, -122.404646681546) | |||
| 11422 | 11422 | 26785 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 28 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1999 12:00:00 AM | 3 | 3X3 | 6010847.2509 | 2087135.4549 | 37.7114882765061 | -122.40431164223101 | (37.7114882765061, -122.404311642231) | ||
| 11927 | 11927 | 52333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 30 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2005 12:00:00 AM | 3 | Permit Number 48484 | 6010821.8504 | 2087147.4867 | 37.7115198939825 | -122.40440027981701 | (37.7115198939825, -122.404400279817) | ||
| 12802 | 12802 | 26786 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 34 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6010794.6675 | 2087161.3009 | 37.7115563058928 | -122.404495203342 | (37.7115563058928, -122.404495203342) | |||
| 11853 | 11853 | 94988 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 38 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010771.4951 | 2087173.3327 | 37.711588047755605 | -122.40457614013901 | (37.7115880477556, -122.404576140139) | |||
| 11288 | 11288 | 95020 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 57 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010631.1241 | 2087198.2876 | 37.711648722790706 | -122.40506305817699 | (37.7116487227907, -122.405063058177) | |||
| 11165 | 11165 | 95019 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 65 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010608.3974 | 2087210.3194 | 37.7116804891797 | -122.40514245485001 | (37.7116804891797, -122.40514245485) | |||
| 143612 | 143612 | 94987 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 36 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2015 03:25:00 PM | 3 | 3x3 | 6010827.4 | 2087210.2 | 37.711692402207106 | -122.40438551024401 | (37.7116924022071, -122.404385510244) | ||
| 11845 | 11845 | 95018 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 65 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010587.8988 | 2087221.4599 | 37.7117099327517 | -122.40521408790899 | (37.7117099327517, -122.405214087909) | |||
| 11612 | 11612 | 95017 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 73 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010561.1615 | 2087236.1655 | 37.7117488165229 | -122.40530753468501 | (37.7117488165229, -122.405307534685) | |||
| 11741 | 11741 | 94992 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 66 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010640.4822 | 2087242.4042 | 37.7117703812114 | -122.40503381823 | (37.7117703812114, -122.40503381823) | |||
| 11451 | 11451 | 94993 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 66 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010619.538 | 2087251.7622 | 37.711794905553106 | -122.405106866024 | (37.7117949055531, -122.405106866024) | |||
| 10403 | 10403 | 95015 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 83 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010521.9467 | 2087254.8816 | 37.711798014587295 | -122.40544438972 | (37.7117980145873, -122.40544438972) | ||||
| 10592 | 10592 | 26788 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 78 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1999 12:00:00 AM | 4 | 3X3 | 6010596.3656 | 2087261.1203 | 37.711819305554 | -122.40518761518801 | (37.711819305554, -122.405187615188) | ||
| 10400 | 10400 | 94994 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 82 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010574.5301 | 2087274.9346 | 37.7118560160688 | -122.405264057289 | (37.7118560160688, -122.405264057289) | |||
| 10788 | 10788 | 94995 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010547.3472 | 2087288.7489 | 37.711892427555796 | -122.40535898167299 | (37.7118924275558, -122.405358981673) | |||
| 39287 | 39287 | 31050 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 25 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51560 | 6002835.195830001 | 2087448.13614 | 37.711895858785894 | -122.432025692555 | (37.7118958587859, -122.432025692555) | |
| 12328 | 12328 | 26789 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 96 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2010 12:00:00 AM | 3 | 3X3 | 6010520.1642 | 2087302.5632 | 37.7119288389604 | -122.40545390649599 | (37.7119288389604, -122.405453906496) | ||
| 10354 | 10354 | 95012 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 107 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 3 | 3x3 | 6010407.8674 | 2087313.2581 | 37.7119519253908 | -122.40584279071301 | (37.7119519253908, -122.405842790713) | ||
| 11042 | 11042 | 26800 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1999 12:00:00 AM | 5 | 3x3 | 6010377.1195 | 2087327.5180000002 | 37.7119893605537 | -122.40595006858901 | (37.7119893605537, -122.405950068589) | ||
| 42943 | 42943 | 178899 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012660.08669 | 2087284.72268 | 37.7119992718279 | -122.39805643095801 | (37.7119992718279, -122.398056430958) | |||
| 164638 | 164638 | 178898 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012665.55046 | 2087301.61111 | 37.7120459484316 | -122.398038730507 | (37.7120459484316, -122.398038730507) | |||
| 11545 | 11545 | 26790 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 106 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/2015 09:40:00 AM | 3 | 3X3 | 6010430.5942 | 2087350.2448 | 37.7120547543657 | -122.405766843704 | (37.7120547543657, -122.405766843704) | ||
| 11181 | 11181 | 95011 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6010324.7589 | 2087356.7063 | 37.7120665771229 | -122.406133097694 | (37.7120665771229, -122.406133097694) | |||
| 37685 | 37685 | 178897 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012667.83856 | 2087309.2144 | 37.7120669530014 | -122.39803135517599 | (37.7120669530014, -122.398031355176) | |||
| 12918 | 12918 | 26791 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 110 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1999 12:00:00 AM | 4 | 3x3 | 6010397.1725 | 2087366.7328 | 37.712098157972605 | -122.40588352001801 | (37.7120981579726, -122.405883520018) | ||
| 12239 | 12239 | 95010 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010304.2603 | 2087368.7381 | 37.7120984674199 | -122.406204794273 | (37.7120984674199, -122.406204794273) | |||
| 12450 | 12450 | 26799 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010285.5441 | 2087377.2049 | 37.7121206686095 | -122.40627007937 | (37.7121206686095, -122.40627007937) | |||
| 11078 | 11078 | 94996 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 116 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010370.4352 | 2087379.2102 | 37.7121309230244 | -122.405976810763 | (37.7121309230244, -122.405976810763) | |||
| 12883 | 12883 | 26798 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010259.698 | 2087389.6823 | 37.71215348320929 | -122.406360290051 | (37.7121534832093, -122.406360290051) | |||
| 13045 | 13045 | 26792 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 128 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2002 12:00:00 AM | 3 | 3x3 | 6010340.5785 | 2087395.6982 | 37.7121745258223 | -122.40608116557199 | (37.7121745258223, -122.406081165572) | ||
| 12999 | 12999 | 94997 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 134 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010302.5304 | 2087413.7951 | 37.7122220880479 | -122.40621394582399 | (37.7122220880479, -122.406213945824) | |||
| 12910 | 12910 | 26795 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 159 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2010 12:00:00 AM | 3 | 3x3 | 6010135.8151 | 2087452.9607 | 37.712320301990204 | -122.40679292443501 | (37.7123203019902, -122.406792924435) | ||
| 108171 | 108171 | 51590 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 252 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2005 12:00:00 AM | Permit Number 47881 | 5994487.68194175 | 2087789.14028904 | 37.7123553921006 | -122.46090153342199 | (37.7123553921006, -122.460901533422) | |||
| 12621 | 12621 | 95008 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 167 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010080.5579 | 2087480.5892 | 37.712393072261705 | -122.40698585693501 | (37.7123930722617, -122.406985856935) | |||
| 10735 | 10735 | 95001 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 166 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010153.2106 | 2087493.0431 | 37.712431333442 | -122.40673562308099 | (37.712431333442, -122.406735623081) | |||
| 11134 | 11134 | 95007 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 185 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010037.7782 | 2087495.7404 | 37.712432280377705 | -122.40713478458 | (37.7124322803777, -122.40713478458) | |||
| 11856 | 11856 | 95002 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 170 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010131.1046 | 2087504.7217 | 37.712462163614795 | -122.406812851088 | (37.7124621636148, -122.406812851088) | |||
| 12204 | 12204 | 95003 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 176 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010111.9182 | 2087516.8174 | 37.7124943023778 | -122.406880017452 | (37.7124943023778, -122.406880017452) | |||
| 44585 | 44585 | 37353 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 131 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 4 | Permit Number 39859 | 6000725.3710199995 | 2087720.25032 | 37.7125231844795 | -122.43933731388 | (37.7125231844795, -122.43933731388) | |
| 10559 | 10559 | 26794 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 186 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1999 12:00:00 AM | 2 | 3x3 | 6010044.3489 | 2087538.0893 | 37.7125489295627 | -122.407115057358 | (37.7125489295627, -122.407115057358) | ||
| 128075 | 128075 | 120885 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6009830.0 | 2087548.0 | 37.7125641444482 | -122.407856615551 | (37.7125641444482, -122.407856615551) | ||||
| 63534 | 63534 | 120891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009886.0438 | 2087551.2204 | 37.71257612443421 | -122.407663136759 | (37.7125761244342, -122.407663136759) | |||
| 149958 | 149958 | 120890 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009870.8927 | 2087557.0134 | 37.71259118267999 | -122.40771591213999 | (37.71259118268, -122.40771591214) | |||
| 74957 | 74957 | 120889 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009853.959 | 2087561.9153 | 37.71260369432971 | -122.407774785999 | (37.7126036943297, -122.407774785999) | |||
| 61322 | 61322 | 120888 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009826.3305 | 2087573.9471 | 37.7126351844606 | -122.40787112709101 | (37.7126351844606, -122.407871127091) | |||
| 56141 | 56141 | 120887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | |||
| 187851 | 187851 | 120886 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009795.1369 | 2087583.7508 | 37.712660357001795 | -122.40797963340599 | (37.7126603570018, -122.407979633406) | |||
| 12738 | 12738 | 95005 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 201X Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6009777.312000001 | 2087590.4351 | 37.71267771272821 | -122.40804171326799 | (37.7126777127282, -122.408041713268) | ||||
| 89705 | 89705 | 109182 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 634 HURON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5998040.0 | 2087925.4 | 37.7129332935716 | -122.448633512376 | (37.7129332935716, -122.448633512376) |
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");