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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94759 | 94759 | 47444 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 651 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45354 | 5982550.9590229 | 2111342.50779778 | 37.7763323565324 | -122.503901138971 | (37.7763323565324, -122.503901138971) | |||
| 55330 | 55330 | 37078 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1318 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2002 12:00:00 AM | 2 | Permit Number 39680 | 5982466.3981 | 2106106.9098 | 37.761951943280394 | -122.50380580728 | (37.7619519432804, -122.50380580728) | |
| 136410 | 136410 | 82431 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 650 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52680 | 5982600.56645 | 2111346.95635 | 37.7763474878375 | -122.503729865488 | (37.7763474878375, -122.503729865488) | |
| 166287 | 166287 | 55604 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 658 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1973 12:00:00 AM | 1 | Permit Number 773340 | 5982601.78539 | 2111293.4380900003 | 37.7762006139918 | -122.50372168450501 | (37.7762006139918, -122.503721684505) | ||
| 61940 | 61940 | 92237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52681 | 5982614.54862 | 2110914.94505 | 37.7751621329201 | -122.503649497706 | (37.7751621329201, -122.503649497706) | |
| 171448 | 171448 | 83913 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1659 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50155 | 5982499.5096 | 2103826.5104 | 37.7556925599446 | -122.503522416925 | (37.7556925599446, -122.503522416925) | |
| 54349 | 54349 | 79894 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4119 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2001 12:00:00 AM | 7 | 5982716.5012300005 | 2113074.1195 | 37.78109658773229 | -122.503456745272 | (37.7810965877323, -122.503456745272) | ||
| 67159 | 67159 | 92236 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 551 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52679 | 5982837.48707 | 2112035.40062 | 37.7782516820937 | -122.502961282193 | (37.7782516820937, -122.502961282193) | |
| 57130 | 57130 | 92234 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 530 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52677 | 5982879.44866 | 2112163.93194 | 37.778607057674996 | -122.50282564106199 | (37.778607057675, -122.502825641062) |
| 155742 | 155742 | 40221 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1463 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1999 12:00:00 AM | 4 | Permit Number 41400 | 5982763.9993 | 2105167.6847 | 37.7593905919599 | -122.502707013206 | (37.7593905919599, -122.502707013206) | ||
| 171006 | 171006 | 72283 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 779 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 4 | 5982894.68666 | 2110493.65125 | 37.774021849099704 | -122.502649263154 | (37.7740218490997, -122.502649263154) | ||
| 171943 | 171943 | 184308 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1555 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982786.0012 | 2104528.3348 | 37.7576364108681 | -122.502583598561 | (37.7576364108681, -122.502583598561) | |||
| 30074 | 30074 | 47440 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 859 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45351 | 5982914.18523 | 2109947.95579 | 37.7725246733221 | -122.50254141771099 | (37.7725246733221, -122.502541417711) | |
| 70691 | 70691 | 184573 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1731 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982827.3086 | 2103329.3402 | 37.754346736395995 | -122.502352009826 | (37.754346736396, -122.502352009826) | |||
| 26539 | 26539 | 184576 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1735 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982829.6776 | 2103308.6964 | 37.75429019350779 | -122.50234228965799 | (37.7542901935078, -122.502342289658) | |||
| 24589 | 24589 | 184585 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1743 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982830.016 | 2103255.9026 | 37.754145256427606 | -122.50233721253099 | (37.7541452564276, -122.502337212531) | |||
| 157734 | 157734 | 46392 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2474 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 1 | Permit Number 44624 | 5982733.0582 | 2098295.9927 | 37.7405210225717 | -122.502305471655 | (37.7405210225717, -122.502305471655) | |
| 102609 | 102609 | 89562 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 5027 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983024.08969 | 2111679.84197 | 37.7772863874511 | -122.50228944566099 | (37.7772863874511, -122.502289445661) | ||
| 102770 | 102770 | 96076 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 767701 | 5983098.7 | 2113007.7 | 37.780936680817206 | -122.502129633812 | (37.7809366808172, -122.502129633812) | ||
| 175243 | 175243 | 96075 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767701 | 5983103.04582 | 2113013.19289 | 37.7809520179972 | -122.50211500631399 | (37.7809520179972, -122.502115006314) |
| 119284 | 119284 | 116071 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 4150X CLEMENT ST | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 8 | 3x3 | 5983115.0 | 2113126.0 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | |||
| 109056 | 109056 | 51769 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52851 | 5982925.7859 | 2104266.232 | 37.7569249636711 | -122.50208077934201 | (37.7569249636711, -122.502080779342) |
| 153533 | 153533 | 117710 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 477 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5983117.17834 | 2112671.33055 | 37.7800141944428 | -122.502040811752 | (37.7800141944428, -122.502040811752) | |||
| 40255 | 40255 | 51768 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52851 | 5982945.3427 | 2104265.0097 | 37.756922756494106 | -122.50201305526699 | (37.7569227564941, -122.502013055267) |
| 186101 | 186101 | 51766 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | 1 | Permit Number 48032 | 5982963.9827 | 2104265.9264 | 37.7569263685127 | -122.50194866004801 | (37.7569263685127, -122.501948660048) | ||
| 185728 | 185728 | 51437 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 535 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | 2 | Permit Number 47757 | 5983145.9728 | 2112126.6615400002 | 37.7785203841092 | -122.501900888351 | (37.7785203841092, -122.501900888351) | ||
| 167545 | 167545 | 51767 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2005 12:00:00 AM | 1 | Permit Number 48032 | 5982982.0116 | 2104266.5376 | 37.756929105781495 | -122.501886355597 | (37.7569291057815, -122.501886355597) | ||
| 136211 | 136211 | 183297 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1279 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5983033.5705 | 2106401.2294 | 37.762793394201005 | -122.501865989484 | (37.762793394201, -122.501865989484) | |||
| 132519 | 132519 | 47430 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 651 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45341 | 5983172.9702 | 2111364.55723 | 37.776429453588 | -122.501751096095 | (37.776429453588, -122.501751096095) | |
| 189079 | 189079 | 117920 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 727 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5983191.607000001 | 2110832.41366 | 37.7749694365706 | -122.501647249063 | (37.7749694365706, -122.501647249063) | |||
| 106043 | 106043 | 89022 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 801 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2008 12:00:00 AM | 3x3 | Permit Number 51767 | 5983196.2 | 2110303.4 | 37.7735171880717 | -122.501592216483 | (37.7735171880717, -122.501592216483) | ||
| 50531 | 50531 | 96079 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 664 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767703 | 5983226.11153 | 2111277.81973 | 37.7761944189321 | -122.501560849986 | (37.7761944189321, -122.501560849986) |
| 60980 | 60980 | 70441 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2443 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 2 | 5982992.9824 | 2098498.3633 | 37.741091945342795 | -122.501421735716 | (37.7410919453428, -122.501421735716) | ||
| 135433 | 135433 | 96081 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767704 | 5983251.84023 | 2110453.37841 | 37.773932253218 | -122.501410848383 | (37.773932253218, -122.501410848383) |
| 23887 | 23887 | 83255 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5983253.61867 | 2110435.38712 | 37.773882958787205 | -122.501403365431 | (37.7738829587872, -122.501403365431) | |||
| 94281 | 94281 | 96080 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 3x3 | Permit Number 767704 | 5983278.4 | 2110433.5 | 37.7738792326413 | -122.501317504516 | (37.7738792326413, -122.501317504516) | |
| 175787 | 175787 | 49394 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 868 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2003 12:00:00 AM | 4 | Permit Number 46347 | 5983274.10488 | 2109909.62702 | 37.7724405765784 | -122.50129360387301 | (37.7724405765784, -122.501293603873) | ||
| 45057 | 45057 | 70451 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2683 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 4 | 5983041.4986 | 2096885.6865 | 37.7366668238827 | -122.5011347377 | (37.7366668238827, -122.5011347377) | ||
| 51315 | 51315 | 34818 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 443 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38451 | 5983428.96299375 | 2112819.28622042 | 37.780438749009704 | -122.500973171264 | (37.7804387490097, -122.500973171264) | ||
| 139180 | 139180 | 34817 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 443 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38451 | 5983428.96299375 | 2112819.28622042 | 37.780438749009704 | -122.500973171264 | (37.7804387490097, -122.500973171264) | ||
| 130514 | 130514 | 117789 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3921 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5983401.92135 | 2111008.87073 | 37.7754662872697 | -122.500932791041 | (37.7754662872697, -122.500932791041) | |||
| 138008 | 138008 | 56715 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3550 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 5983275.5384 | 2103598.154 | 37.75511115010929 | -122.50082181985901 | (37.7551111501093, -122.500821819859) | ||||
| 46105 | 46105 | 117727 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 432 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5983474.89929 | 2112887.7743599997 | 37.780629494505796 | -122.50081932484501 | (37.7806294945058, -122.500819324845) | |||
| 67414 | 67414 | 117728 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 432 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5983476.79722 | 2112873.2862 | 37.780589825682895 | -122.50081168738001 | (37.7805898256829, -122.50081168738) | |||
| 43768 | 43768 | 81737 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49969 | 5983468.0529 | 2111801.95258 | 37.7776477425111 | -122.500762690576 | (37.7776477425111, -122.500762690576) | |
| 76643 | 76643 | 184445 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2143 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983233.2456 | 2100550.728 | 37.746741282577894 | -122.500742738194 | (37.7467412825779, -122.500742738194) | |||
| 25201 | 25201 | 183343 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1220 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983371.791 | 2106830.4783 | 37.7639918518381 | -122.500727966306 | (37.7639918518381, -122.500727966306) | |||
| 42925 | 42925 | 67228 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 679 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 5 | Permit Number 30687 | 5983489.7095099995 | 2111188.94144 | 37.775965863323 | -122.500642433993 | (37.775965863323, -122.500642433993) | |
| 66582 | 66582 | 47427 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 743 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 3 | Permit Number 45338 | 5983505.42349 | 2110743.75617 | 37.7747444359741 | -122.500555150992 | (37.7747444359741, -122.500555150992) | |
| 176672 | 176672 | 50404 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 650 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | 1 | Permit Number 47055 | 5983530.01588 | 2111373.74494 | 37.776475646301606 | -122.500516673446 | (37.7764756463016, -122.500516673446) | |
| 24630 | 24630 | 184291 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1543 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5983404.3155 | 2104639.3384 | 37.7579775103532 | -122.50045345703501 | (37.7579775103532, -122.500453457035) | |||
| 151092 | 151092 | 72277 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 819 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 6 | 5983524.1138 | 2110218.5518 | 37.773303473649605 | -122.500451657892 | (37.7733034736496, -122.500451657892) | ||
| 168858 | 168858 | 117913 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 893 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5983541.21756 | 2109770.57795 | 37.7720744705229 | -122.500359367665 | (37.7720744705229, -122.500359367665) | |||
| 166746 | 166746 | 117912 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 889 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5983541.524809999 | 2109784.94999 | 37.772113950042794 | -122.50035936764999 | (37.7721139500428, -122.50035936765) | |||
| 180951 | 180951 | 73633 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 782 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 1 | 5983562.4874599995 | 2110479.0519 | 37.7740209842304 | -122.500338183608 | (37.7740209842304, -122.500338183608) | ||
| 170495 | 170495 | 117867 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 842 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5983574.3920599995 | 2110074.48435 | 37.7729108571993 | -122.500267088216 | (37.7729108571993, -122.500267088216) | |||
| 177121 | 177121 | 117868 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 842 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5983575.47317 | 2110057.58486 | 37.7728645195254 | -122.500262098966 | (37.7728645195254, -122.500262098966) | |||
| 59594 | 59594 | 67226 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 858 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 2 | Permit Number 30685 | 5983581.64532 | 2109958.3486599997 | 37.7725924077801 | -122.500233411273 | (37.7725924077801, -122.500233411273) | |
| 51275 | 51275 | 67225 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 862 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 3 | Permit Number 30684 | 5983582.48092 | 2109929.96399 | 37.7725145206954 | -122.50022842205 | (37.7725145206954, -122.50022842205) | |
| 165978 | 165978 | 67253 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 878 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 4 | Permit Number 30717 | 5983587.04483 | 2109836.93635 | 37.7722593614509 | -122.50020575664101 | (37.7722593614509, -122.500205756641) | |
| 149853 | 149853 | 53802 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1758 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1972 12:00:00 AM | 1 | Permit Number 9494 | 5983498.0607 | 2103182.1267 | 37.7539819174643 | -122.500021533616 | (37.7539819174643, -122.500021533616) | ||
| 114510 | 114510 | 84877 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1951 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2007 12:00:00 AM | Permit No. 49250 | 5983480.4 | 2101864.4 | 37.7503627699789 | -122.499985207399 | (37.7503627699789, -122.499985207399) | |||
| 128529 | 128529 | 84876 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1951 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2007 12:00:00 AM | Permit No. 49250 | 5983480.4 | 2101864.4 | 37.7503627699789 | -122.499985207399 | (37.7503627699789, -122.499985207399) | |||
| 140762 | 140762 | 92430 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1758 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52821 | 5983521.6 | 2103180.6 | 37.7539791070225 | -122.499940017573 | (37.7539791070225, -122.499940017573) | |
| 131317 | 131317 | 117739 | Undocumented 2 | Prunus spp :: Cherry 84 | 475 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5983746.16527 | 2112679.78018 | 37.7800743257794 | -122.49986552243 | (37.7800743257794, -122.49986552243) | |||
| 171845 | 171845 | 54485 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 524 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 3 | Permit Number 10277 | 5983807.43995 | 2112211.38308 | 37.778791839243205 | -122.499618921418 | (37.7787918392432, -122.499618921418) | |
| 158906 | 158906 | 82734 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 663 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52670 | 5983795.84033 | 2111312.2935099998 | 37.776322519429606 | -122.499592582815 | (37.7763225194296, -122.499592582815) | |
| 175620 | 175620 | 117840 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 600x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983808.599090001 | 2111637.58628 | 37.777216427782896 | -122.499572493795 | (37.7772164277829, -122.499572493795) | |||
| 61829 | 61829 | 79376 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 683 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52671 | 5983799.61702 | 2111191.23616 | 37.7759903525694 | -122.499570569578 | (37.7759903525694, -122.499570569578) | |
| 60634 | 60634 | 117841 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 600x 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983809.68656 | 2111621.06726 | 37.7771711351486 | -122.499567510814 | (37.7771711351486, -122.499567510814) | |||
| 156479 | 156479 | 94817 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 683 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52671 | 5983800.6479400005 | 2111169.09276 | 37.775929613686294 | -122.499565366534 | (37.7759296136863, -122.499565366534) |
| 51598 | 51598 | 117842 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 620x 39th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983810.65643 | 2111554.107 | 37.7769873385843 | -122.499559205901 | (37.7769873385843, -122.499559205901) | |||
| 178771 | 178771 | 184275 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1535 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983712.9456 | 2104682.7299 | 37.7581147632448 | -122.499389306755 | (37.7581147632448, -122.499389306755) | |||
| 171595 | 171595 | 184311 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1563 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983718.446 | 2104512.8306 | 37.757648590113604 | -122.49935772939301 | (37.7576485901136, -122.499357729393) | |||
| 154043 | 154043 | 117830 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 870 39th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5983887.3151 | 2110064.19539 | 37.77290096878129 | -122.499183906851 | (37.7729009687813, -122.499183906851) | |||
| 33246 | 33246 | 102378 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 870 39th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 2 | 5983886.84831 | 2110037.48525 | 37.7728276030319 | -122.499183547509 | (37.7728276030319, -122.499183547509) | ||||
| 69190 | 69190 | 102377 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 870 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 5983889.8768 | 2109995.31333 | 37.7727119887219 | -122.49916995510901 | (37.7727119887219, -122.499169955109) | ||||
| 154893 | 154893 | 49552 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1606@ LAWTON 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2003 12:00:00 AM | 1 | Permit Number 46442 | 5983773.0639 | 2104184.1322 | 37.7567492805381 | -122.499144554539 | (37.7567492805381, -122.499144554539) | ||
| 164030 | 164030 | 184601 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1763 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983763.5526 | 2103165.7132 | 37.753952428223 | -122.49910220128099 | (37.753952428223, -122.499102201281) | |||
| 48191 | 48191 | 31876 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 457 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 2 | Permit Number 35315 | 5984053.55944 | 2112762.76101 | 37.7803202011246 | -122.49880825564199 | (37.7803202011246, -122.498808255642) | ||
| 34641 | 34641 | 31877 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 457 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 2 | Permit Number 35315 | 5984054.95538 | 2112747.63581 | 37.780278753599895 | -122.49880230879499 | (37.7802787535999, -122.498802308795) | ||
| 161530 | 161530 | 67267 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 552 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/1992 12:00:00 AM | 3 | Permit Number 30740 | 5984123.38609 | 2112065.40916 | 37.7784095705965 | -122.49851517128599 | (37.7784095705965, -122.498515171286) | |
| 158895 | 158895 | 92228 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 819 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52552 | 5984148.0757 | 2110235.49072 | 37.77338659024161 | -122.498294572929 | (37.7733865902416, -122.498294572929) | |
| 147200 | 147200 | 92229 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 831 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52669 | 5984149.10381 | 2110157.50395 | 37.7731725212481 | -122.498285255587 | (37.7731725212481, -122.498285255587) | |
| 123530 | 123530 | 88091 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1619 39th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51095 | 5984024.3 | 2104125.3 | 37.756602478656 | -122.498271356488 | (37.756602478656, -122.498271356488) | |||
| 56474 | 56474 | 183181 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2401 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983915.9024 | 2098758.6426 | 37.7418607608057 | -122.49824988070299 | (37.7418607608057, -122.498249880703) | |||
| 153700 | 153700 | 183184 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2415 40th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983915.9024 | 2098706.2108 | 37.7417167973555 | -122.49824600919202 | (37.7417167973555, -122.498246009192) | |||
| 155036 | 155036 | 183182 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2411 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983916.579 | 2098737.6699 | 37.74180321515429 | -122.498245992674 | (37.7418032151543, -122.498245992674) | |||
| 137406 | 137406 | 183183 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2413 40th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983917.2555 | 2098721.0947 | 37.7417577438343 | -122.49824242970399 | (37.7417577438343, -122.498242429704) | |||
| 24823 | 24823 | 47425 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 754 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45336 | 5984176.15569 | 2110679.3098400002 | 37.7746068364777 | -122.49823022658701 | (37.7746068364777, -122.498230226587) | |
| 188640 | 188640 | 184708 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1619 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984043.3081 | 2104133.2508 | 37.7566254238897 | -122.498206207845 | (37.7566254238897, -122.498206207845) | |||
| 51735 | 51735 | 88092 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1619 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51095 | 5984042.9711 | 2104115.7287 | 37.756577293333294 | -122.49820607925 | (37.7565772933333, -122.49820607925) | |
| 171549 | 171549 | 183196 | Undocumented 2 | Prunus spp :: Cherry 84 | 2479 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983931.1246 | 2098292.1691 | 37.740580843976005 | -122.49816280562901 | (37.740580843976, -122.498162805629) | |||
| 91592 | 91592 | 37724 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2400X 40TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1998 12:00:00 AM | Permit Number 40087 | 5983946.0 | 2098489.0 | 37.741122160337504 | -122.498125905701 | (37.7411221603375, -122.498125905701) | |||
| 96765 | 96765 | 37720 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2400X 40TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1998 12:00:00 AM | Permit Number 40087 | 5983946.0 | 2098489.0 | 37.741122160337504 | -122.498125905701 | (37.7411221603375, -122.498125905701) | |||
| 122602 | 122602 | 37719 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2400X 40TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1998 12:00:00 AM | Permit Number 40087 | 5983946.0 | 2098489.0 | 37.741122160337504 | -122.498125905701 | (37.7411221603375, -122.498125905701) | |||
| 124347 | 124347 | 37718 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2400X 40TH AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1998 12:00:00 AM | Permit Number 40087 | 5983946.0 | 2098489.0 | 37.741122160337504 | -122.498125905701 | (37.7411221603375, -122.498125905701) | |||
| 136125 | 136125 | 183176 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2446 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983967.9959 | 2098507.985 | 37.7411755776416 | -122.498051254673 | (37.7411755776416, -122.498051254673) | |||
| 135632 | 135632 | 183177 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2450 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983968.3342 | 2098473.4815 | 37.741080860242896 | -122.498047537544 | (37.7410808602429, -122.498047537544) | |||
| 178235 | 178235 | 51494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1767 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2005 12:00:00 AM | 1 | Permit Number 47806 | 5984074.2238 | 2103158.268 | 37.7539502052222 | -122.498027293704 | (37.7539502052222, -122.498027293704) |
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");