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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||
| 15875 | 15875 | 31850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 15956 | 15956 | 31845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 3013 | 3013 | 39333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 5518 | 5518 | 39334 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 6740 | 6740 | 39332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 14197 | 14197 | 39331 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 98840 | 98840 | 42078 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 Norwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42388 | 6009309.20723614 | 2099453.41599437 | 37.7452247183965 | -122.410496799342 | (37.7452247183965, -122.410496799342) | ||
| 121829 | 121829 | 42077 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42388 | 6009309.20723614 | 2099453.41599437 | 37.7452247183965 | -122.410496799342 | (37.7452247183965, -122.410496799342) | ||
| 105011 | 105011 | 46168 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44497 | 5996113.80902962 | 2106861.13745227 | 37.7648158648531 | -122.45665958836399 | (37.7648158648531, -122.456659588364) | ||
| 123229 | 123229 | 42079 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42389 | 6009265.41363365 | 2099503.07167939 | 37.7453586067376 | -122.41065173677299 | (37.7453586067376, -122.410651736773) | ||
| 183681 | 183681 | 250308 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 10 Redfield Aly | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.41476992380801 | (37.8002391853351, -122.414769923808) | |||
| 79328 | 79328 | 88522 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Valdez Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51454 | 5996417.0 | 2093827.6 | 37.7290464055545 | -122.45466924520201 | (37.7290464055545, -122.454669245202) | |||
| 82956 | 82956 | 47713 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Bemis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | ||
| 85199 | 85199 | 47712 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | ||
| 85911 | 85911 | 47714 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Bemis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | ||
| 98555 | 98555 | 42815 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | Permit Number 42760 | 6001684.72316119 | 2105247.9392865 | 37.760704701255 | -122.437275750105 | (37.760704701255, -122.437275750105) | ||
| 18799 | 18799 | 11188 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995291.088769999 | 2099424.10153 | 37.7443483813689 | -122.45896663000299 | (37.7443483813689, -122.458966630003) | |||
| 18983 | 18983 | 11186 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 5995298.39303 | 2099423.25523 | 37.7443464775133 | -122.458941312315 | (37.7443464775133, -122.458941312315) | |||
| 115201 | 115201 | 121666 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 100 Montalvo Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5993653.0 | 2099666.0 | 37.7449182738718 | -122.46464831295299 | (37.7449182738718, -122.464648312953) | ||||
| 105631 | 105631 | 34419 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38167 | 6003358.09011166 | 2096226.49076231 | 37.7360288984966 | -122.43084449611601 | (37.7360288984966, -122.430844496116) | ||
| 38906 | 38906 | 237981 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 100 Rousseau St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003493.73736 | 2095146.1048599998 | 37.7330700888164 | -122.43029845283002 | (37.7330700888164, -122.43029845283) | |||
| 80558 | 80558 | 49133 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | Permit Number 46261 | 5996360.20601003 | 2094239.45226773 | 37.7301739953755 | -122.454895331277 | (37.7301739953755, -122.454895331277) | |||
| 93419 | 93419 | 49134 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | Permit Number 46261 | 5996360.20601003 | 2094239.45226773 | 37.7301739953755 | -122.454895331277 | (37.7301739953755, -122.454895331277) | |||
| 108763 | 108763 | 41855 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1001 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | ||
| 121275 | 121275 | 41858 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1001 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | ||
| 122844 | 122844 | 41857 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1001 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | ||
| 143410 | 143410 | 41856 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1001 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | ||
| 165001 | 165001 | 139978 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1002 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001945.5177 | 2111990.8232 | 37.7792338137079 | -122.436856496835 | (37.7792338137079, -122.436856496835) | |||
| 94813 | 94813 | 115487 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1004 SANCHEZ ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003744.0 | 2102383.0 | 37.7529551066007 | -122.4299492716 | (37.7529551066007, -122.4299492716) | ||||
| 81601 | 81601 | 65210 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1008 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27196 | 6003122.02248491 | 2102364.94475265 | 37.7528702875206 | -122.432098897252 | (37.7528702875206, -122.432098897252) | ||
| 143462 | 143462 | 53023 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100@ DEWEY Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | Permit Number 49002 | 5994618.97974152 | 2099903.5858652 | 37.7456262668668 | -122.461325376527 | (37.7456262668668, -122.461325376527) | |||
| 146780 | 146780 | 214408 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Idora Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 9ft | 5995751.653580001 | 2099314.25679 | 37.7440732391823 | -122.457366158726 | (37.7440732391823, -122.457366158726) | |||
| 79671 | 79671 | 115684 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 103534 | 103534 | 115686 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 115299 | 115299 | 115687 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 143683 | 143683 | 115685 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 86979 | 86979 | 16604 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 101 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778401 | 6002878.7558281 | 2107677.2386141997 | 37.7674427729111 | -122.433319725194 | (37.7674427729111, -122.433319725194) | |
| 92552 | 92552 | 36557 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 101 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39427 | 6008880.2941613 | 2098058.52124465 | 37.7413705893714 | -122.411881362374 | (37.7413705893714, -122.411881362374) | ||
| 120573 | 120573 | 40228 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 101 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1999 12:00:00 AM | Permit Number 41410 | 6014331.14035058 | 2112607.2540326 | 37.7816225406641 | -122.394052345281 | (37.7816225406641, -122.394052345281) | |||
| 128168 | 128168 | 40229 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 101 South Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1999 12:00:00 AM | Permit Number 41410 | 6014331.14035058 | 2112607.2540326 | 37.7816225406641 | -122.394052345281 | (37.7816225406641, -122.394052345281) | |||
| 103592 | 103592 | 121759 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1019 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015338.0 | 2103772.0 | 37.7574187808175 | -122.389951694408 | (37.7574187808175, -122.389951694408) | ||||
| 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 | |||||||||
| 94204 | 94204 | 34536 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 102 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | Permit Number 38245 | 6009539.66453921 | 2097997.54688011 | 37.7412401371814 | -122.409597177582 | (37.7412401371814, -122.409597177582) | ||
| 54244 | 54244 | 196406 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1021 Minnesota St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6015301.01099 | 2103753.62638 | 37.7573662793475 | -122.390078334671 | (37.7573662793475, -122.390078334671) | |||
| 87307 | 87307 | 37016 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1024 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39629 | 6008593.31384349 | 2102571.16222478 | 37.7537451924393 | -122.413192669543 | (37.7537451924393, -122.413192669543) | ||
| 93473 | 93473 | 88253 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1025 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51238 | 5999131.0 | 2106547.0 | 37.7641260948648 | -122.446201344399 | (37.7641260948648, -122.446201344399) | |||
| 141471 | 141471 | 39191 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1025 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40844 | 6008645.24325538 | 2102573.87076335 | 37.7537555446899 | -122.413013276733 | (37.7537555446899, -122.413013276733) | ||
| 54951 | 54951 | 178873 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1029 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003894.97731 | 2089471.2893700001 | 37.7175110241788 | -122.428506907095 | (37.7175110241788, -122.428506907095) | |||
| 165537 | 165537 | 178872 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1029 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003905.75349 | 2089465.8631799999 | 37.717496734867396 | -122.428469272232 | (37.7174967348674, -122.428469272232) | |||
| 84888 | 84888 | 88277 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 103 Aptos Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51270 | 5993062.0 | 2093861.6 | 37.7289467548913 | -122.46627011422899 | (37.7289467548913, -122.466270114229) | |||
| 124580 | 124580 | 88278 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 103 Aptos Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51270 | 5993062.0 | 2093861.6 | 37.7289467548913 | -122.46627011422899 | (37.7289467548913, -122.466270114229) | |||
| 56504 | 56504 | 214451 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 103 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993921.129 | 2099948.59538 | 37.7457096635647 | -122.463741686529 | (37.7457096635647, -122.463741686529) | |||
| 89041 | 89041 | 84214 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 103 Tucker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50754 | 6010384.580416299 | 2088747.67100343 | 37.7158892293049 | -122.406024264993 | (37.7158892293049, -122.406024264993) | ||
| 112903 | 112903 | 84224 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 103 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50754 | 6010384.580416299 | 2088747.67100343 | 37.7158892293049 | -122.406024264993 | (37.7158892293049, -122.406024264993) | ||
| 123029 | 123029 | 116779 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1031 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 3x3 | 6008650.0 | 2118281.0 | 37.796883878440795 | -122.41410797545099 | (37.7968838784408, -122.414107975451) | ||
| 49913 | 49913 | 199985 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1032 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018147.7753 | 2092169.4169 | 37.725715836336896 | -122.379428312297 | (37.7257158363369, -122.379428312297) | |||
| 167611 | 167611 | 95528 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1032 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767319 | 5989620.9197 | 2099732.2391 | 37.7448668732681 | -122.478595193308 | (37.7448668732681, -122.478595193308) |
| 74159 | 74159 | 135907 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1034 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007940.29606 | 2119623.01107 | 37.80052881831 | -122.416658842755 | (37.80052881831, -122.416658842755) | |||
| 83546 | 83546 | 48870 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 105 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46813 | 5992505.4658098 | 2098397.03654372 | 37.7413678003574 | -122.468523930768 | (37.7413678003574, -122.468523930768) | ||
| 142993 | 142993 | 62195 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 105 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1985 12:00:00 AM | Permit Number 22314 | 6000493.57908868 | 2092148.88322612 | 37.7246700159736 | -122.440455881068 | (37.7246700159736, -122.440455881068) | ||
| 87723 | 87723 | 43903 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) | |
| 100074 | 100074 | 43904 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) |
| 146100 | 146100 | 43905 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) |
| 102086 | 102086 | 62849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1986 12:00:00 AM | Permit Number 23217 | 6008647.40750977 | 2098052.96381421 | 37.7413422616597 | -122.41268621320101 | (37.7413422616597, -122.412686213201) | ||
| 115997 | 115997 | 36347 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39309 | 5995651.79090977 | 2093374.88380892 | 37.7277594354695 | -122.457281878498 | (37.7277594354695, -122.457281878498) | ||
| 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) | ||
| 90220 | 90220 | 32381 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
| 113477 | 113477 | 32383 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
| 114011 | 114011 | 32382 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
| 128135 | 128135 | 32384 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
| 122373 | 122373 | 63019 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1986 12:00:00 AM | Permit Number 23434 | 6007356.32584056 | 2097719.32736654 | 37.740353622343 | -122.417126697503 | (37.740353622343, -122.417126697503) | ||
| 124372 | 124372 | 37006 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1065 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39620 | 6009210.89939839 | 2102965.35956072 | 37.754862222093294 | -122.411084752447 | (37.7548622220933, -122.411084752447) | ||
| 86071 | 86071 | 36348 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 107 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39310 | 5995599.90527543 | 2093378.33068424 | 37.7277659195994 | -122.457461496194 | (37.7277659195994, -122.457461496194) | ||
| 129117 | 129117 | 36349 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 107 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39310 | 5995599.90527543 | 2093378.33068424 | 37.7277659195994 | -122.457461496194 | (37.7277659195994, -122.457461496194) | ||
| 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) | ||
| 110833 | 110833 | 16607 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 107 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6002880.641859099 | 2107642.9841193003 | 37.7673488254303 | -122.433310753696 | (37.7673488254303, -122.433310753696) | |||
| 86014 | 86014 | 51430 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1070 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | Permit Number 47751 | 6007408.58996673 | 2101077.89386609 | 37.7495784341832 | -122.417183917873 | (37.7495784341832, -122.417183917873) | |||
| 121355 | 121355 | 51429 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1070 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | Permit Number 47751 | 6007408.58996673 | 2101077.89386609 | 37.7495784341832 | -122.417183917873 | (37.7495784341832, -122.417183917873) | |||
| 99007 | 99007 | 37007 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1071 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39621 | 6009212.75104301 | 2102931.76923387 | 37.7547700944461 | -122.411075976411 | (37.7547700944461, -122.411075976411) | ||
| 25034 | 25034 | 245135 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 108 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000350.1465 | 2109371.4561 | 37.7719508943795 | -122.442187448391 | (37.7719508943795, -122.442187448391) | |||
| 128860 | 128860 | 39140 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1084 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40818 | 6007412.89120014 | 2100999.62033196 | 37.749363754724996 | -122.417163498301 | (37.749363754725, -122.417163498301) | ||
| 132838 | 132838 | 178906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 109 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009976.781880001 | 2089389.92306 | 37.7176299046612 | -122.40747906690399 | (37.7176299046612, -122.407479066904) | |||
| 127102 | 127102 | 27759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1099X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/25/2005 12:00:00 AM | 4 | 3x3 | 6015711.817910201 | 2101113.2850563 | 37.750139234821 | -122.38847329943701 | (37.750139234821, -122.388473299437) | ||
| 27753 | 27753 | 178904 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011792.88406 | 2090769.7339700002 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | |||
| 54864 | 54864 | 178902 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6011813.97335 | 2090761.03311 | 37.721497357285706 | -122.401224985361 | (37.7214973572857, -122.401224985361) | |||
| 154431 | 154431 | 178903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011814.45609 | 2090752.0893599999 | 37.7214728265024 | -122.401222688486 | (37.7214728265024, -122.401222688486) | |||
| 101473 | 101473 | 67117 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 110 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30537 | 5998254.46044174 | 2105394.41401324 | 37.7609112863716 | -122.449149986975 | (37.7609112863716, -122.449149986975) | ||
| 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) | ||
| 91136 | 91136 | 45127 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 110 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2001 12:00:00 AM | Permit Number 43984 | 6000366.86976442 | 2109279.71080278 | 37.7716999379516 | -122.442123014739 | (37.7716999379516, -122.442123014739) | ||
| 78757 | 78757 | 65245 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1106 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28039 | 6009173.38165211 | 2102703.44295541 | 37.7541409539447 | -122.411195999264 | (37.7541409539447, -122.411195999264) | ||
| 75758 | 75758 | 47310 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1107 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | Permit Number 45241 | 6010288.16181634 | 2102764.77938432 | 37.7543718262723 | -122.407345121668 | (37.7543718262723, -122.407345121668) | ||
| 103053 | 103053 | 40468 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 111 Caine Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41553 | 5997316.73360061 | 2089179.17157647 | 37.71633447730439 | -122.45122371003599 | (37.7163344773044, -122.451223710036) | ||
| 142556 | 142556 | 45132 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1114 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43991 | 6001218.6094792 | 2109380.86443699 | 37.7720261837752 | -122.43918405170099 | (37.7720261837752, -122.439184051701) | ||
| 50138 | 50138 | 245099 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1116 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001200.4602 | 2109374.4683 | 37.7720075888162 | -122.43924637279899 | (37.7720075888162, -122.439246372799) | |||
| 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 | ||||||||
| 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 |
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");