Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 105611 | 105611 | 46170 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 22 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44499 | 5996115.83466209 | 2106813.26166937 | 37.7646845265696 | -122.456649119677 | (37.7646845265696, -122.456649119677) | ||
| 109178 | 109178 | 46185 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44512 | 5997625.24396619 | 2107656.90958664 | 37.767087516944706 | -122.451489352946 | (37.7670875169447, -122.451489352946) | ||
| 121280 | 121280 | 46172 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 34 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44501 | 5996117.860294099 | 2106765.38589744 | 37.7645531883122 | -122.456638651029 | (37.7645531883122, -122.456638651029) | ||
| 82066 | 82066 | 39487 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3723 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40945 | 6004943.29101021 | 2101913.34310631 | 37.7517333836283 | -122.42576846624901 | (37.7517333836283, -122.425768466249) | ||
| 84901 | 84901 | 39510 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 971 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40962 | 6003803.3913976 | 2102619.59957595 | 37.7536081166409 | -122.42976075902399 | (37.7536081166409, -122.429760759024) | ||
| 92032 | 92032 | 39485 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3856 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40943 | 6004065.71023863 | 2102497.52410689 | 37.7532877768544 | -122.428844900366 | (37.7532877768544, -122.428844900366) | ||
| 106345 | 106345 | 39515 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 62 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 2 | Permit Number 40966 | 6004070.08669275 | 2102696.50176505 | 37.75383437046089 | -122.428843949963 | (37.7538343704609, -122.428843949963) | |
| 139424 | 139424 | 39516 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 62 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40966 | 6004070.08669275 | 2102696.50176505 | 37.75383437046089 | -122.428843949963 | (37.7538343704609, -122.428843949963) | ||
| 173528 | 173528 | 39575 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 885 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 13 | Permit Number 40992 | 6011619.84178 | 2104260.65443 | 37.7585536119741 | -122.40284500428999 | (37.7585536119741, -122.40284500429) | |
| 179064 | 179064 | 39571 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 835 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 8 | Permit Number 40989 | 6011610.458330001 | 2104449.8311400004 | 37.7590725253066 | -122.402890761795 | (37.7590725253066, -122.402890761795) | |
| 83996 | 83996 | 68854 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 296 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32817 | 5998798.41525763 | 2094112.17808977 | 37.729964095359605 | -122.446457004656 | (37.7299640953596, -122.446457004656) | ||
| 2000 | 2000 | 237999 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4302 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2012 12:00:00 AM | 2 | Width 4ft | Permit Number 769743 | 6001218.46057 | 2101752.36044 | 37.7510801711245 | -122.438637864349 | (37.7510801711245, -122.438637864349) | |
| 20662 | 20662 | 84576 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3966 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769743 | 6003390.40048346 | 2101879.79659646 | 37.7515533971776 | -122.43113617160401 | (37.7515533971776, -122.431136171604) |
| 93247 | 93247 | 84579 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3930 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6003612.12595164 | 2101892.03490833 | 37.7515995627601 | -122.43037029061001 | (37.7515995627601, -122.43037029061) |
| 94175 | 94175 | 84667 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4045 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | Permit Number 769743 | 6002887.32453677 | 2101799.94982156 | 37.7513056360956 | -122.432870165781 | (37.7513056360956, -122.432870165781) | ||
| 100725 | 100725 | 84674 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4045 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769743 | 6002887.32453677 | 2101799.94982156 | 37.7513056360956 | -122.432870165781 | (37.7513056360956, -122.432870165781) |
| 103524 | 103524 | 84660 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 816 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6001872.13741629 | 2101710.47895055 | 37.751002338731 | -122.436374389271 | (37.751002338731, -122.436374389271) |
| 112631 | 112631 | 84578 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3934 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6003587.48978851 | 2101890.6750959 | 37.751594433496706 | -122.430455388545 | (37.7515944334967, -122.430455388545) |
| 113773 | 113773 | 84575 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3972-3976 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003353.44622149 | 2101877.75687686 | 37.7515457024264 | -122.431263818404 | (37.7515457024264, -122.431263818404) |
| 120819 | 120819 | 84577 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3950 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6003488.94513598 | 2101885.23584618 | 37.75157391582871 | -122.430795780168 | (37.7515739158287, -122.430795780168) |
| 14939 | 14939 | 6391 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 16 Espanola St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 3X3 | 6018056.47068 | 2094273.68663 | 37.7314887164161 | -122.379890092347 | (37.7314887164161, -122.379890092347) | ||
| 11815 | 11815 | 85960 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1230 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988027.116 | 2106908.7855 | 37.764479070899 | -122.48463252131201 | (37.764479070899, -122.484632521312) | ||
| 12090 | 12090 | 85962 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988020.9888 | 2107061.1992 | 37.7648972002579 | -122.484664894353 | (37.7648972002579, -122.484664894353) | ||
| 12727 | 12727 | 85961 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988024.0524 | 2107011.4158 | 37.7647606871244 | -122.484650646191 | (37.7647606871244, -122.484650646191) | ||
| 107220 | 107220 | 86544 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1743 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987792.632848 | 2103431.806163 | 37.75491857482479 | -122.48518838735201 | (37.7549185748248, -122.485188387352) | ||
| 113728 | 113728 | 85959 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1298X 26TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988007.0 | 2106798.0 | 37.764173712799 | -122.484693968894 | (37.764173712799, -122.484693968894) | ||
| 120382 | 120382 | 86542 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1731 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987789.915173001 | 2103510.132538 | 37.755133479572294 | -122.485203532524 | (37.7551334795723, -122.485203532524) | ||
| 141412 | 141412 | 86539 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1719 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5987787.197497 | 2103588.458912 | 37.755348384307105 | -122.485218677787 | (37.7553483843071, -122.485218677787) | ||
| 67570 | 67570 | 52458 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 557@ ANZA 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | Permit Number 48569 | 5992189.638752901 | 2111651.23752465 | 37.777742101383794 | -122.470581063094 | (37.7777421013838, -122.470581063094) | ||
| 140366 | 140366 | 52467 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 623@ BALBOA 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | Permit Number 48578 | 5993135.59943115 | 2111227.85704239 | 37.776634266775204 | -122.467277895236 | (37.7766342667752, -122.467277895236) | ||
| 144419 | 144419 | 52450 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 672 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48563 | 5992577.489440001 | 2110887.44098 | 37.7756673423473 | -122.46918376151501 | (37.7756673423473, -122.469183761515) |
| 158467 | 158467 | 52461 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 686@ CABRILLO 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 3 | Permit Number 48572 | 5992267.31152 | 2110802.49998 | 37.7754161894068 | -122.470250546869 | (37.7754161894068, -122.470250546869) | |
| 180921 | 180921 | 52459 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 584@ BALBOA 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 1 | Permit Number 48570 | 5992242.76591 | 2111511.4032400004 | 37.777361226341895 | -122.470387093473 | (37.7773612263419, -122.470387093473) | |
| 114798 | 114798 | 105147 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Mirabel Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/26/2013 12:00:00 AM | 3X3 | Permit Number 771012 | 6007663.7 | 2099931.8 | 37.7464458666696 | -122.41622057503099 | (37.7464458666696, -122.416220575031) | |||
| 11068 | 11068 | 86516 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1303 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987691.5588 | 2106373.6447 | 37.762990173852 | -122.48575382789801 | (37.762990173852, -122.485753827898) | ||
| 91229 | 91229 | 86519 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1309 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987691.436672 | 2106370.804533 | 37.7629823684162 | -122.485754041828 | (37.7629823684162, -122.485754041828) | ||
| 98755 | 98755 | 47002 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 133 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | Permit Number 45001 | 6004750.78049806 | 2108920.69040717 | 37.77096301566829 | -122.426933212426 | (37.7709630156683, -122.426933212426) | ||
| 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) | ||
| 11960 | 11960 | 108570 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772580 | 6010210.43031 | 2095090.8811299999 | 37.733296619935004 | -122.407073064382 | (37.733296619935, -122.407073064382) |
| 12065 | 12065 | 108545 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 150 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773707 | 6003013.00279 | 2094373.5586 | 37.7309216102277 | -122.431905334488 | (37.7309216102277, -122.431905334488) |
| 12580 | 12580 | 108559 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 247 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773718 | 6001785.96966 | 2094072.85918 | 37.7300263216596 | -122.43612587350701 | (37.7300263216596, -122.436125873507) |
| 12716 | 12716 | 108567 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773758 | 6009500.29517 | 2092233.5680799999 | 37.725411278805296 | -122.409326636833 | (37.7254112788053, -122.409326636833) |
| 14555 | 14555 | 86928 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 838 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774404 | 6011553.2134300005 | 2104436.20347 | 37.759031910124 | -122.403087784389 | (37.759031910124, -122.403087784389) | |
| 142929 | 142929 | 108563 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 60 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772473 | 6010406.15109 | 2094405.89757 | 37.7314267509243 | -122.406348153233 | (37.7314267509243, -122.406348153233) |
| 20643 | 20643 | 26635 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 359 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/24/1998 12:00:00 AM | 3 | 3X3 | 6005539.477000001 | 2106921.88393 | 37.7655193351826 | -122.42406291888001 | (37.7655193351826, -122.42406291888) | ||
| 110438 | 110438 | 12424 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1701X Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2015 12:00:00 AM | 2 | 4X4 | 6004421.35326 | 2114759.5543400003 | 37.7869764624576 | -122.428488960967 | (37.7869764624576, -122.428488960967) | ||
| 103165 | 103165 | 108498 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 762 10th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773796 | 5992905.3087 | 2110276.51424 | 37.774008838888996 | -122.468005315635 | (37.774008838889, -122.468005315635) | |
| 72213 | 72213 | 108460 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 944 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773734 | 6010189.19593 | 2103716.38941 | 37.7569791954421 | -122.40775446824301 | (37.7569791954421, -122.407754468243) |
| 78760 | 78760 | 63239 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3620-3622 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773724 | 6006149.84854852 | 2104367.47863685 | 37.7585399802366 | -122.421770322909 | (37.7585399802366, -122.421770322909) |
| 127421 | 127421 | 47277 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2633 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | Permit Number 773722 | 6010344.90771607 | 2104548.95765438 | 37.7592739569349 | -122.40727464517599 | (37.7592739569349, -122.407274645176) | |
| 141116 | 141116 | 66638 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 952-956 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | Permit Number 772673 | 6010185.68090669 | 2103671.40205978 | 37.756855473473394 | -122.407763452505 | (37.7568554734734, -122.407763452505) | |
| 43838 | 43838 | 52448 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 431 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 4 | Permit Number 48560 | 5992472.90838 | 2112504.99178 | 37.780102654065 | -122.469663313675 | (37.780102654065, -122.469663313675) | |
| 10479 | 10479 | 35851 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 500 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778923 | 6001833.39372 | 2090697.4113200002 | 37.720760799954206 | -122.435720519401 | (37.7207607999542, -122.435720519401) | |
| 45866 | 45866 | 35166 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 513 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | 6 | Permit Number 38699 | 6002123.1918 | 2110352.0553 | 37.7747442642137 | -122.43612454697399 | (37.7747442642137, -122.436124546974) | |
| 78092 | 78092 | 81703 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 99712 | 99712 | 81708 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 99872 | 99872 | 81707 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 106020 | 106020 | 81706 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 107902 | 107902 | 81705 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 108129 | 108129 | 81709 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 120717 | 120717 | 81704 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 139651 | 139651 | 81702 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 10454 | 10454 | 86246 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2292X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988581.0227 | 2099729.0585 | 37.744797709288605 | -122.48219068753401 | (37.7447977092886, -122.482190687534) | ||
| 10486 | 10486 | 86247 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2290 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988579.3157 | 2099752.9558 | 37.744863225687105 | -122.482198340398 | (37.7448632256871, -122.482198340398) | ||
| 10586 | 10586 | 85951 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1390 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988061.1772 | 2105842.3097 | 37.7615528036389 | -122.484436487246 | (37.7615528036389, -122.484436487246) | ||
| 10712 | 10712 | 85954 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1370 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988057.3894 | 2105986.2433 | 37.7619477854522 | -122.484460144927 | (37.7619477854522, -122.484460144927) | ||
| 10873 | 10873 | 85952 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1390 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988060.095 | 2105875.8581 | 37.761644855373895 | -122.484442690808 | (37.7616448553739, -122.484442690808) | ||
| 11850 | 11850 | 85953 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1374 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988058.4716 | 2105953.2359 | 37.76185721916121 | -122.48445398099899 | (37.7618572191612, -122.484453980999) | ||
| 11868 | 11868 | 85927 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1722 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988145.2074 | 2103551.0636 | 37.7552665558176 | -122.483977844866 | (37.7552665558176, -122.483977844866) | ||
| 12042 | 12042 | 85957 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1330 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988048.1907 | 2106230.8219999997 | 37.762618796080105 | -122.484509899399 | (37.7626187960801, -122.484509899399) | ||
| 12242 | 12242 | 86333 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2285 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988537.0686 | 2099797.3366 | 37.7449826262514 | -122.48234767234 | (37.7449826262514, -122.48234767234) | ||
| 12366 | 12366 | 86334 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2289 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988537.4954 | 2099766.6115 | 37.7448982880571 | -122.482343945808 | (37.7448982880571, -122.482343945808) | ||
| 12387 | 12387 | 85955 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1346 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988066.5882 | 2106122.0602 | 37.7623212372231 | -122.48443829226002 | (37.7623212372231, -122.48443829226) | ||
| 13091 | 13091 | 86495 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1534 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987787.3318 | 2104833.8728 | 37.7587679608906 | -122.485309594748 | (37.7587679608906, -122.485309594748) | ||
| 84650 | 84650 | 85958 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1300 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988039.866297 | 2106434.861495 | 37.7631785479619 | -122.48455365718 | (37.7631785479619, -122.48455365718) | ||
| 113189 | 113189 | 85956 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1334 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988047.4774629995 | 2106213.623528 | 37.762571532243705 | -122.484511104656 | (37.7625715322437, -122.484511104656) | ||
| 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 | ||||||||
| 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 | ||||||||
| 55722 | 55722 | 39388 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 414 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40926 | 6003200.97263054 | 2099519.74958744 | 37.745062524724204 | -122.43162276019501 | (37.7450625247242, -122.431622760195) | ||
| 93897 | 93897 | 39347 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 342 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40909 | 6007174.26983946 | 2105316.44942149 | 37.761203350475995 | -122.41829468784799 | (37.761203350476, -122.418294687848) | ||
| 104181 | 104181 | 39348 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 342 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40909 | 6007174.26983946 | 2105316.44942149 | 37.761203350475995 | -122.41829468784799 | (37.761203350476, -122.418294687848) | |||
| 104423 | 104423 | 39360 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 411 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40915 | 6007248.60489953 | 2104914.77803867 | 37.760104638015896 | -122.41800911826799 | (37.7601046380159, -122.418009118268) | ||
| 107349 | 107349 | 34197 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 15 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40888 | 6006506.82888523 | 2108404.56366519 | 37.76964499140821 | -122.42082233238001 | (37.7696449914082, -122.42082233238) | ||
| 9712 | 9712 | 121497 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 468 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2016 12:00:00 AM | 3 | 3x3 | 6002891.0 | 2099226.0 | 37.744238382256704 | -122.432673610292 | (37.7442383822567, -122.432673610292) | ||
| 9713 | 9713 | 121496 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 468 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2016 12:00:00 AM | 3 | 3x3 | 6002891.0 | 2099226.0 | 37.744238382256704 | -122.432673610292 | (37.7442383822567, -122.432673610292) | ||
| 90786 | 90786 | 37728 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 1228 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/20/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768579 | 6009213.61732255 | 2101997.11746506 | 37.752203798813795 | -122.411006967934 | (37.7522037988138, -122.411006967934) |
| 144537 | 144537 | 82361 | Permitted Site 1 | Prunus lyonii :: Catalina Cherry 300 | 1163 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/20/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768585 | 6007677.84129717 | 2102891.68819405 | 37.754573846019895 | -122.416381291371 | (37.7545738460199, -122.416381291371) |
| 73750 | 73750 | 81771 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 118 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 7 | 3x3 | Permit Number 50018 | 6009093.57763 | 2112998.11082 | 37.7824032504549 | -122.41219952198999 | (37.7824032504549, -122.41219952199) | |
| 101989 | 101989 | 53767 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 280 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 3x3 | Permit Number 50032 | 5992868.31748404 | 2094997.91347506 | 37.732055613263604 | -122.467022262159 | (37.7320556132636, -122.467022262159) | ||
| 120438 | 120438 | 81929 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 118 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 6 | 3x3 | Permit Number 50018 | 6009095.92555 | 2112986.0024900003 | 37.782370135616496 | -122.41219054315201 | (37.7823701356165, -122.412190543152) | |
| 10293 | 10293 | 86369 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1281 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5987992.2676 | 2106611.2343 | 37.7636600473858 | -122.484731221945 | (37.7636600473858, -122.484731221945) | ||
| 10702 | 10702 | 86368 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1235 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5987981.927999999 | 2106870.8736 | 37.764372343527704 | -122.48478603091999 | (37.7643723435277, -122.48478603092) | ||
| 10787 | 10787 | 86372 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1309 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988000.5736 | 2106373.6733 | 37.7630082536672 | -122.48468506709101 | (37.7630082536672, -122.484685067091) | ||
| 11039 | 11039 | 86373 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1309 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988001.1147 | 2106356.358 | 37.7629607421046 | -122.484681925407 | (37.7629607421046, -122.484681925407) | ||
| 11157 | 11157 | 86388 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1543 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988055.0728 | 2104801.2215 | 37.7586939032987 | -122.48438123978599 | (37.7586939032987, -122.484381239786) | ||
| 11238 | 11238 | 86381 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1449 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988033.2668 | 2105434.5266 | 37.760431517128296 | -122.48450310552299 | (37.7604315171283, -122.484503105523) | ||
| 11398 | 11398 | 86374 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1327 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988004.3613 | 2106238.9386 | 37.762638529629506 | -122.48466208303199 | (37.7626385296295, -122.484662083032) |
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");