Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 128193 | 128193 | 81 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 899 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/29/2001 12:00:00 AM | 8 | 3X3 | 6002864.319993401 | 2107660.1796498 | 37.767395114191295 | -122.433368437593 | (37.7673951141913, -122.433368437593) | ||
| 12648 | 12648 | 1088 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2222 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 8 | 3X3 | 5999676.1210900005 | 2089518.7544200001 | 37.717401703502205 | -122.443092918703 | (37.7174017035022, -122.443092918703) | ||
| 21098 | 21098 | 10199 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2X2 | 6005752.31611 | 2101874.30524 | 37.7516718791661 | -122.42296797178801 | (37.7516718791661, -122.422967971788) | |||
| 106056 | 106056 | 10331 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 838 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2007 12:00:00 AM | 8 | 5x5 | 6002106.05232 | 2109235.22443 | 37.771676750694105 | -122.43610389900199 | (37.7716767506941, -122.436103899002) | ||
| 126862 | 126862 | 12763 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1806 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5989830.303719999 | 2114748.7330400003 | 37.786110250168704 | -122.478969342589 | (37.7861102501687, -122.478969342589) | |||
| 112791 | 112791 | 23845 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1360 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2001 12:00:00 AM | 8 | 3X3 | 6003737.7759918 | 2113383.7091882997 | 37.7831600307032 | -122.43075576300899 | (37.7831600307032, -122.430755763009) | ||
| 84414 | 84414 | 26169 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1320 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2004 12:00:00 AM | 8 | 3X3 | 6005780.5723577 | 2101269.3137616003 | 37.750012306137 | -122.422827266036 | (37.750012306137, -122.422827266036) | ||
| 21630 | 21630 | 26477 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 112 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2001 12:00:00 AM | 8 | 3x3 | 6001287.0278199995 | 2098748.5722 | 37.742836382684295 | -122.438185594392 | (37.7428363826843, -122.438185594392) | ||
| 17483 | 17483 | 27512 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005753.54797 | 2101830.48031 | 37.75155161552 | -122.422960597352 | (37.75155161552, -122.422960597352) | ||
| 16945 | 16945 | 27513 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2001 12:00:00 AM | 8 | 3X3 | 6005754.33518 | 2101803.9188099997 | 37.751478728181795 | -122.422955987444 | (37.7514787281818, -122.422955987444) | ||
| 18229 | 18229 | 27514 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005755.80226 | 2101784.51034 | 37.7514255197779 | -122.422949534811 | (37.7514255197779, -122.422949534811) | ||
| 17628 | 17628 | 27516 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005758.28533 | 2101749.6847900003 | 37.75133003695179 | -122.422938473144 | (37.7513300369518, -122.422938473144) | ||
| 21994 | 21994 | 27517 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005756.59865 | 2101732.46517 | 37.7512826606677 | -122.422943082157 | (37.7512826606677, -122.422943082157) | ||
| 20572 | 20572 | 27519 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005760.41969 | 2101697.87743 | 37.751187906306896 | -122.42292741057 | (37.7511879063069, -122.42292741057) | ||
| 12039 | 12039 | 28243 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3230 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/2004 12:00:00 AM | 8 | 2X3 | 6011870.75873 | 2090643.72462 | 37.7211784199346 | -122.401020454343 | (37.7211784199346, -122.401020454343) | ||
| 11353 | 11353 | 28245 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3312 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2002 12:00:00 AM | 8 | 2X3 | 6011933.46331 | 2090279.87862 | 37.7201828704297 | -122.40077815269899 | (37.7201828704297, -122.400778152699) | ||
| 12009 | 12009 | 28254 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3410 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2002 12:00:00 AM | 8 | 3X3 | 6012011.64722 | 2089824.91922 | 37.7189380045612 | -122.400475954423 | (37.7189380045612, -122.400475954423) | ||
| 13073 | 13073 | 28301 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3336 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2003 12:00:00 AM | 8 | 3X3 | 6011974.103080001 | 2090046.14983 | 37.719543365213 | -122.400621263274 | (37.719543365213, -122.400621263274) | ||
| 12903 | 12903 | 28302 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3410 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6012014.9954 | 2089805.7813099998 | 37.7188856424495 | -122.40046303743799 | (37.7188856424495, -122.400463037438) | |||
| 19226 | 19226 | 30599 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 82 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 8 | 5x7 | Permit Number 34566 | 6004311.30995 | 2108965.65965 | 37.771061631219 | -122.428456559416 | (37.771061631219, -122.428456559416) |
| 54523 | 54523 | 31006 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 8 | Permit Number 34780 | 6000669.33593 | 2088075.8661099998 | 37.713496437089894 | -122.43955646516599 | (37.7134964370899, -122.439556465166) | |
| 178402 | 178402 | 31022 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 330 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 8 | Permit Number 34788 | 6002783.56511 | 2086520.12567 | 37.7093448166924 | -122.43213791266001 | (37.7093448166924, -122.43213791266) | |
| 59928 | 59928 | 32098 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 134 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 8 | Permit Number 35471 | 6002656.28427 | 2105089.46023 | 37.7603247386273 | -122.433904232401 | (37.7603247386273, -122.433904232401) | |
| 161379 | 161379 | 33142 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3148 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2005 12:00:00 AM | 8 | Permit Number 37368 | 6001934.81136 | 2119023.6664400003 | 37.798543584677894 | -122.437397274777 | (37.7985435846779, -122.437397274777) | |
| 51525 | 51525 | 33649 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 541 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 8 | Permit Number 37740 | 6004806.91261 | 2110706.66354 | 37.775870037302106 | -122.426866263978 | (37.7758700373021, -122.426866263978) | ||
| 69559 | 69559 | 33659 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 545 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 8 | Permit Number 37747 | 6004792.43502 | 2110705.04365 | 37.7758647708832 | -122.42691623030599 | (37.7758647708832, -122.426916230306) | |
| 182770 | 182770 | 34483 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 845 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 8 | Permit Number 38210 | 6008918.6183400005 | 2119360.64227 | 37.7998633928514 | -122.413254875509 | (37.7998633928514, -122.413254875509) | |
| 54230 | 54230 | 34485 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 851 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 8 | Permit Number 38211 | 6008882.966680001 | 2119355.1714 | 37.799846369579704 | -122.41337785691299 | (37.7998463695797, -122.413377856913) | |
| 172628 | 172628 | 34523 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 586 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1997 12:00:00 AM | 8 | Permit Number 38233 | 6010643.980930001 | 2105619.91693 | 37.762231304058204 | -122.40631575879 | (37.7622313040582, -122.40631575879) | |
| 173766 | 173766 | 36753 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2579 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 8 | Permit Number 41197 | 6002394.06342 | 2116399.40669 | 37.7913641456997 | -122.435620277371 | (37.7913641456997, -122.435620277371) | |
| 40502 | 40502 | 38237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 81 Langton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | 8 | Permit Number 40353 | 6010112.774540001 | 2110816.57283 | 37.776470395916796 | -122.408519597801 | (37.7764703959168, -122.408519597801) | ||
| 50853 | 50853 | 38717 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 458 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40620 | 5994382.59481 | 2112404.76272 | 37.779937641475705 | -122.463049617411 | (37.7799376414757, -122.463049617411) | ||
| 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) | |
| 177715 | 177715 | 40658 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Congdon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 8 | Permit Number 47919 | 6004683.64689 | 2093722.1701 | 37.7292276094514 | -122.426083284515 | (37.7292276094514, -122.426083284515) | |
| 182902 | 182902 | 40949 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 543 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 8 | Permit Number 45163 | 5989370.51415 | 2111642.49878 | 37.7775546903632 | -122.480332633054 | (37.7775546903632, -122.480332633054) | |
| 169964 | 169964 | 43259 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 445 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 8 | Permit Number 43042 | 6010225.92511 | 2092216.8838799999 | 37.725406095999396 | -122.406817013015 | (37.7254060959994, -122.406817013015) | |
| 41435 | 41435 | 44490 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 49 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 8 | Permit Number 43795 | 6005454.79601 | 2093298.7109 | 37.728108438248704 | -122.423387260924 | (37.7281084382487, -122.423387260924) | |
| 36253 | 36253 | 46768 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 39 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 8 | Permit Number 44864 | 6002453.43832 | 2093143.7233900002 | 37.7275130240946 | -122.433751972693 | (37.7275130240946, -122.433751972693) | |
| 151037 | 151037 | 46787 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 42 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 8 | Permit Number 44878 | 6002762.13918 | 2093587.1286799998 | 37.7287480270995 | -122.43271645372101 | (37.7287480270995, -122.432716453721) | |
| 26032 | 26032 | 48415 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2475 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 8 | Permit Number 45793 | 6001140.73556 | 2118622.32163 | 37.797396422056295 | -122.440116223893 | (37.7973964220563, -122.440116223893) | |
| 31288 | 31288 | 49149 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2721 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2003 12:00:00 AM | 8 | Permit Number 46272 | 6001579.27273 | 2117782.40416 | 37.7951151846669 | -122.43853856390301 | (37.7951151846669, -122.438538563903) | ||
| 24585 | 24585 | 49743 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 114 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 8 | Permit Number 46542 | 6010621.23603 | 2087831.01483 | 37.7133855110935 | -122.405141759495 | (37.7133855110935, -122.405141759495) | |
| 110571 | 110571 | 51834 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 8 | 3x3 | Permit Number 48063 | 6005440.48678199 | 2099065.68713562 | 37.7439424571986 | -122.42384662792699 | (37.7439424571986, -122.423846627927) | |
| 151932 | 151932 | 55259 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/1972 12:00:00 AM | 8 | Permit Number 11181 | 6008604.18987 | 2088002.78931 | 37.7137441994136 | -122.41212553387501 | (37.7137441994136, -122.412125533875) | ||
| 12882 | 12882 | 62704 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 251 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1986 12:00:00 AM | 8 | 3x3 | Permit Number 23044 | 5999960.32769 | 2091545.33962 | 37.7229824455563 | -122.442255952067 | (37.7229824455563, -122.442255952067) | |
| 159954 | 159954 | 62779 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | 8 | Permit Number 23134 | 6000268.11132 | 2091745.7518099998 | 37.7235502685229 | -122.441206382083 | (37.7235502685229, -122.441206382083) | |
| 56536 | 56536 | 68520 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 643 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 8 | Permit Number 32400 | 5995312.0360199995 | 2111170.0323400004 | 37.77660089482001 | -122.45974482687402 | (37.77660089482, -122.459744826874) | |
| 183324 | 183324 | 68544 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 571 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 8 | Permit Number 32430 | 5982530.7498 | 2111896.5441900003 | 37.777852390021 | -122.504012093664 | (37.777852390021, -122.504012093664) | |
| 68144 | 68144 | 72942 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Gladstone Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1999 12:00:00 AM | 8 | 6006185.1456 | 2093706.6722400002 | 37.729269804734294 | -122.420891365245 | (37.7292698047343, -122.420891365245) | ||
| 67071 | 67071 | 78281 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 34 Wanda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 8 | 6000546.67018 | 2091525.62315 | 37.722961708992294 | -122.44022767776501 | (37.7229617089923, -122.440227677765) | ||
| 150319 | 150319 | 78354 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1125 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 8 | 6000366.91048 | 2090562.1790900002 | 37.7203060748337 | -122.44077999190701 | (37.7203060748337, -122.440779991907) | ||
| 51040 | 51040 | 80385 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1754 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 8 | 6011729.10125 | 2092748.5600299998 | 37.7269499630479 | -122.40165799273599 | (37.7269499630479, -122.401657992736) | ||
| 28887 | 28887 | 84197 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 551 Sawyer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50697 | 6007614.52495 | 2086883.3270299998 | 37.7106148095844 | -122.41546698201 | (37.7106148095844, -122.41546698201) | |
| 117051 | 117051 | 95275 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 728 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2013 12:00:00 AM | 8 | 3x3 | Permit Number 769625 | 6009044.4 | 2104856.4 | 37.760045252375605 | -122.411794171614 | (37.7600452523756, -122.411794171614) | |
| 125122 | 125122 | 96225 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 173 Marview Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2011 12:00:00 AM | 8 | 3x3 | Permit Number 767719 | 5998131.6 | 2103359.5 | 37.755316892676 | -122.449428282005 | (37.755316892676, -122.449428282005) | |
| 6734 | 6734 | 96373 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1315 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008912.46348 | 2117456.9297 | 37.7946359224745 | -122.41314148629499 | (37.7946359224745, -122.413141486295) | |
| 649 | 649 | 96374 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1315 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008916.2106800005 | 2117429.1962900003 | 37.7945599836999 | -122.41312655846599 | (37.7945599836999, -122.413126558466) | |
| 124035 | 124035 | 102758 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1392 09TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5993422.3 | 2106025.2 | 37.7623656970292 | -122.465908002531 | (37.7623656970292, -122.465908002531) | |||
| 88494 | 88494 | 113152 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 21 BRONTE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009396.0 | 2097313.0 | 37.7393524690061 | -122.410045605495 | (37.7393524690061, -122.410045605495) | |||
| 67642 | 67642 | 118478 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 578 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5981024.51617 | 2111800.84509 | 37.7775009394111 | -122.509215478972 | (37.7775009394111, -122.509215478972) | |||
| 162216 | 162216 | 121930 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 372 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5990921.90113 | 2112919.08197 | 37.781149865360206 | -122.47505913337099 | (37.7811498653602, -122.475059133371) | |||
| 26957 | 26957 | 135923 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 299 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001988.80401 | 2118923.8728 | 37.7982726468322 | -122.43720329460501 | (37.7982726468322, -122.437203294605) | |||
| 35216 | 35216 | 135924 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 273 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002069.33792 | 2118935.23427 | 37.7983084200504 | -122.436925437376 | (37.7983084200504, -122.436925437376) | |||
| 131832 | 131832 | 135926 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2575 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000595.0032 | 2118891.4120400003 | 37.7981041894114 | -122.44202391886299 | (37.7981041894114, -122.442023918863) | |||
| 52335 | 52335 | 135946 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 33 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001854.08706 | 2120729.8042200003 | 37.803223599954705 | -122.437798867946 | (37.8032235999547, -122.437798867946) | |||
| 75965 | 75965 | 135975 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2325 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6003558.57482 | 2116562.95168 | 37.79187927196 | -122.43160277647301 | (37.79187927196, -122.431602776473) | |||
| 148223 | 148223 | 178974 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 126 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 5998851.51754 | 2088138.5359099999 | 37.7135648862728 | -122.445843970916 | (37.7135648862728, -122.445843970916) | |||
| 165247 | 165247 | 179010 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 600 Edinburgh St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002473.362919999 | 2090193.0957900002 | 37.7194123924534 | -122.43347232401399 | (37.7194123924534, -122.433472324014) | |||
| 47569 | 47569 | 179024 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 947 Olmstead St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008925.8511 | 2090372.5517900002 | 37.7202691181059 | -122.411181045172 | (37.7202691181059, -122.411181045172) | |||
| 179002 | 179002 | 179025 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 947 Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008937.54219 | 2090376.09955 | 37.7202795151651 | -122.41114088325399 | (37.7202795151651, -122.411140883254) | |||
| 166375 | 166375 | 179050 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 7 Santa Ysabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001033.440769999 | 2093008.98993 | 37.727062398087895 | -122.438651252569 | (37.7270623980879, -122.438651252569) | |||
| 36765 | 36765 | 179054 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Santa Ysabel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000895.42593 | 2093107.17468 | 37.7273241385819 | -122.439135400803 | (37.7273241385819, -122.439135400803) | |||
| 38676 | 38676 | 179059 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 329 Santa Rosa Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000540.14475 | 2093725.6550599998 | 37.729002120636295 | -122.440407941486 | (37.7290021206363, -122.440407941486) | |||
| 147294 | 147294 | 179085 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004898.84219 | 2092984.2976099998 | 37.727213735105295 | -122.42528684943001 | (37.7272137351053, -122.42528684943) | |||
| 63078 | 63078 | 179090 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004283.33861 | 2092987.6886900002 | 37.727188253710295 | -122.427414882796 | (37.7271882537103, -122.427414882796) | |||
| 70697 | 70697 | 179091 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004289.65055 | 2092997.26304 | 37.72721489973979 | -122.42739374423 | (37.7272148997398, -122.42739374423) | |||
| 151967 | 151967 | 196468 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 12 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6015629.24905 | 2101065.86664 | 37.7500044578413 | -122.38875552004801 | (37.7500044578413, -122.388755520048) | |||
| 59450 | 59450 | 196470 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Newcomb Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6013295.589480001 | 2097174.20298 | 37.7391891560441 | -122.39655273032899 | (37.7391891560441, -122.396552730329) | |||
| 59440 | 59440 | 196504 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Russ St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010369.66301 | 2111467.46147 | 37.778271967325004 | -122.40767684761002 | (37.778271967325, -122.40767684761) | |||
| 160988 | 160988 | 202147 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1979 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6012955.252309999 | 2093506.82348 | 37.72910034549879 | -122.397472339298 | (37.7291003454988, -122.397472339298) | |||
| 148541 | 148541 | 213283 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 321 Ashton Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994158.95263 | 2092018.0634599999 | 37.7239480827215 | -122.46234424081499 | (37.7239480827215, -122.462344240815) | |||
| 151307 | 151307 | 213301 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 727 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994761.86207 | 2089904.6583900002 | 37.7181798769775 | -122.46010705669599 | (37.7181798769775, -122.460107056696) | |||
| 135117 | 135117 | 213323 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 395 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5991938.55148 | 2091189.98285 | 37.7215462696313 | -122.469959478668 | (37.7215462696313, -122.469959478668) | |||
| 68665 | 68665 | 213332 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 151 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5991918.25557 | 2089546.87165 | 37.717033514761 | -122.46991006271999 | (37.717033514761, -122.46991006272) | |||
| 24980 | 24980 | 213333 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991918.76578 | 2089524.2789200002 | 37.7169715101175 | -122.469906655166 | (37.7169715101175, -122.469906655166) | |||
| 63673 | 63673 | 213341 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 455 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5992454.16583 | 2090885.02641 | 37.7207387260928 | -122.468154982671 | (37.7207387260928, -122.468154982671) | |||
| 32614 | 32614 | 213347 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 529 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5993232.83209 | 2090695.6130099997 | 37.7202635827786 | -122.465449643 | (37.7202635827786, -122.465449643) | |||
| 137181 | 137181 | 213366 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1339 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994540.087040001 | 2106406.8839 | 37.76347812055079 | -122.46206970207899 | (37.7634781205508, -122.462069702079) | |||
| 185894 | 185894 | 213368 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1590 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992480.65426 | 2104648.2196 | 37.7585305048007 | -122.469064557877 | (37.7585305048007, -122.469064557877) | |||
| 62132 | 62132 | 213404 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2299 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991462.361409999 | 2099805.0928599997 | 37.7451736523548 | -122.472233202213 | (37.7451736523548, -122.472233202213) | |||
| 46495 | 46495 | 213405 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2291 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991470.93113 | 2099841.87305 | 37.7452751372339 | -122.47220625042802 | (37.7452751372339, -122.472206250428) | |||
| 63726 | 63726 | 213421 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2311 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991446.19939 | 2099675.30585 | 37.744816355291796 | -122.472279627908 | (37.7448163552918, -122.472279627908) | |||
| 69144 | 69144 | 213433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2326 Cecilia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991473.33081 | 2099563.7503299997 | 37.74451162271421 | -122.47217768345699 | (37.7445116227142, -122.472177683457) | |||
| 134795 | 134795 | 213445 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2343 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992609.1265199995 | 2099494.08516 | 37.7443860045008 | -122.468245299792 | (37.7443860045008, -122.468245299792) | |||
| 56005 | 56005 | 213450 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Cortes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993181.54452 | 2099646.75602 | 37.744838243897206 | -122.46627710741801 | (37.7448382438972, -122.466277107418) | |||
| 35919 | 35919 | 213457 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993075.78823 | 2099665.10758 | 37.7448825301024 | -122.466644123432 | (37.7448825301024, -122.466644123432) | |||
| 41345 | 41345 | 213459 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 331 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5992964.35444 | 2099654.10226 | 37.7448458809298 | -122.467028637559 | (37.7448458809298, -122.467028637559) | |||
| 27459 | 27459 | 213462 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 314 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993067.05595 | 2099698.4128799997 | 37.7449734740606 | -122.46667673826201 | (37.7449734740606, -122.466676738262) | |||
| 47141 | 47141 | 213471 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 390 Magellan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993863.77689 | 2099599.9221099997 | 37.744748989783 | -122.463914695418 | (37.744748989783, -122.463914695418) | |||
| 29081 | 29081 | 213477 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 240 San Fernando Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992115.588269999 | 2095197.1132200002 | 37.7325590895214 | -122.46963908349899 | (37.7325590895214, -122.469639083499) |
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");