Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3019 | 3019 | 20034 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
3951 | 3951 | 20035 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
4351 | 4351 | 36746 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39516 | ||||||||
5302 | 5302 | 35167 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1998 12:00:00 AM | Permit Number 38700 | ||||||||
5746 | 5746 | 31847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
7293 | 7293 | 31848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
7527 | 7527 | 20039 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
9510 | 9510 | 46857 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | Permit Number 44926 | |||||||||
10575 | 10575 | 20040 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | ST | ||||||||
10952 | 10952 | 43297 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1501 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2000 12:00:00 AM | Permit Number 43066 | ||||||||
11795 | 11795 | 31846 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
11812 | 11812 | 20044 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
12976 | 12976 | 20042 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
13223 | 13223 | 33083 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
14695 | 14695 | 20043 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
14881 | 14881 | 33084 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
83651 | 83651 | 68577 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 139 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32471 | 5981217.74443457 | 2111271.39856875 | 37.7760586259822 | -122.508507736704 | (37.7760586259822, -122.508507736704) | ||
149511 | 149511 | 34721 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 5535 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38376 | 5981434.12386 | 2111625.14448 | 37.7770426583791 | -122.507785493074 | (37.7770426583791, -122.507785493074) | |
170734 | 170734 | 67270 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 539 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/1992 12:00:00 AM | 3 | Permit Number 30743 | 5981594.696269999 | 2112052.0019099996 | 37.7782241419477 | -122.50726170878299 | (37.7782241419477, -122.507261708783) | |
154522 | 154522 | 118420 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5501 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5981593.2087199995 | 2111630.13422 | 37.7770657300516 | -122.507235548964 | (37.7770657300516, -122.507235548964) | |||
105081 | 105081 | 36131 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1579 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/1998 12:00:00 AM | Permit Number 39226 | 5981546.79724008 | 2104343.49116474 | 37.7570559852656 | -122.50685548584299 | (37.7570559852656, -122.506855485843) | |||
24853 | 24853 | 47834 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 891 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49787 | 5981681.239030001 | 2109702.6053299997 | 37.7717784851525 | -122.50678802713199 | (37.7717784851525, -122.506788027132) | |
131523 | 131523 | 118430 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5400 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5981830.664890001 | 2111695.69394 | 37.7772597209712 | -122.506418991145 | (37.7772597209712, -122.506418991145) | |||
185018 | 185018 | 118428 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5400 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5981858.846609999 | 2111695.90062 | 37.7772619476301 | -122.50632151854099 | (37.7772619476301, -122.506321518541) | |||
9777 | 9777 | 88104 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1247 46th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 4x10 | Permit Number 51108 | 5981754.7 | 2106590.8 | 37.763238693975296 | -122.50630313344999 | (37.7632386939753, -122.50630313345) | |||
72566 | 72566 | 83831 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1249-1249 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 3 | 4x9 | Permit Number 50162 | 5981782.7749 | 2106603.6182 | 37.7632755418665 | -122.50620698388599 | (37.7632755418665, -122.506206983886) | |
160579 | 160579 | 68561 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 531 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 4 | Permit Number 32451 | 5981904.26903 | 2112120.67838 | 37.7784309363863 | -122.50619589543699 | (37.7784309363863, -122.506195895437) | |
168261 | 168261 | 68777 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 555 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | 4 | Permit Number 32707 | 5981911.30335 | 2111941.60843 | 37.777939677133205 | -122.506158280277 | (37.7779396771332, -122.506158280277) | |
45509 | 45509 | 68562 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 532 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 5 | Permit Number 32452 | 5981948.24889 | 2112111.86912 | 37.7784093377083 | -122.50604310187401 | (37.7784093377083, -122.506043101874) | |
33287 | 33287 | 118775 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 630 45th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 27 | Width 2ft | 5981986.088380001 | 2111427.82901 | 37.7765333919608 | -122.50586147692101 | (37.7765333919608, -122.505861476921) | |||
186216 | 186216 | 250997 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 415 44th Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5982186.75835 | 2112941.64621 | 37.7807016980586 | -122.505279538125 | (37.7807016980586, -122.505279538125) | |||
107860 | 107860 | 81964 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 455 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 3x3 | Permit Number 50002 | 5982191.84204192 | 2112715.55923715 | 37.780081229053 | -122.505245190233 | (37.780081229053, -122.505245190233) | ||
30707 | 30707 | 250995 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 453 44th Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5982194.00965 | 2112744.27477 | 37.780160200984604 | -122.505239820464 | (37.7801602009846, -122.505239820464) | |||
26055 | 26055 | 70169 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5233 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 3 | 5982394.507019999 | 2111657.31782 | 37.777187531817496 | -122.504465669217 | (37.7771875318175, -122.504465669217) | ||
121137 | 121137 | 68542 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 514 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32426 | 5982569.023547499 | 2112276.16618805 | 37.7788969713665 | -122.503907817569 | (37.7788969713665, -122.503907817569) | ||
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) | |
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) | ||
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) | |
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) | |||
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) | |||
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) | ||
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) | ||
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) | |
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) | ||
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) | ||
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) | |||
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) | |
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) | ||
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) | |
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) | |||
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) | |
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) | |||
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) | |||
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) | |||
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) | ||
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) | |
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) | |||
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) | |||
162710 | 162710 | 118025 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 455 37th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5984366.92897 | 2112698.04941 | 37.7801608967117 | -122.49771940229799 | (37.7801608967117, -122.497719402298) | |||
151019 | 151019 | 47423 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 679 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 3 | Permit Number 45334 | 5984421.41273 | 2111219.03192 | 37.7761031357935 | -122.497421700614 | (37.7761031357935, -122.497421700614) | |
66202 | 66202 | 46259 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2401 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2002 12:00:00 AM | 3 | Permit Number 44544 | 5984226.0421 | 2098787.5863 | 37.741958412916105 | -122.497179671255 | (37.7419584129161, -122.497179671255) | ||
62444 | 62444 | 46260 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2401 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2002 12:00:00 AM | 3 | Permit Number 44544 | 5984227.7748 | 2098774.5909 | 37.741922832622 | -122.497172721174 | (37.741922832622, -122.497172721174) | ||
59340 | 59340 | 184148 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1590 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984387.4321 | 2104376.7436 | 37.7573141589658 | -122.49703409299102 | (37.7573141589658, -122.497034092991) | |||
55066 | 55066 | 111025 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 699x 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5984730.84558 | 2111224.06012 | 37.7761350733047 | -122.496351676847 | (37.7761350733047, -122.496351676847) | |||
137039 | 137039 | 111026 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 699x 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5984732.6875 | 2111184.59691 | 37.7760268265664 | -122.496342392756 | (37.7760268265664, -122.496342392756) | |||
135677 | 135677 | 118269 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 699 36th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5984732.8096199995 | 2111158.8686 | 37.7759561911706 | -122.49634007150401 | (37.7759561911706, -122.496340071504) | |||
136753 | 136753 | 47422 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 882 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 3 | Permit Number 45333 | 5984826.62197 | 2109866.02853 | 37.7724119173032 | -122.49592016034201 | (37.7724119173032, -122.495920160342) | |
60410 | 60410 | 118066 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 415 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5984976.2398 | 2113055.57112 | 37.7811782471615 | -122.495637927617 | (37.7811782471615, -122.495637927617) | |||
130107 | 130107 | 47416 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 419 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 4 | Permit Number 45327 | 5984977.87864 | 2113027.24246 | 37.7811005608257 | -122.495630168001 | (37.7811005608257, -122.495630168001) | |
136014 | 136014 | 118067 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 423 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5984977.9667 | 2113013.83856 | 37.7810637627503 | -122.495628874406 | (37.7810637627503, -122.495628874406) | |||
185253 | 185253 | 38724 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 439 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45328 | 5984981.48092 | 2112906.9180099997 | 37.7807703956275 | -122.49560882850099 | (37.7807703956275, -122.495608828501) | |
124445 | 124445 | 60548 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 511 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20158 | 5984997.83219607 | 2112387.91202298 | 37.7793463125181 | -122.495513971823 | (37.7793463125181, -122.495513971823) | ||
180542 | 180542 | 118261 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 507 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5984999.83681 | 2112374.81786 | 37.779310477103294 | -122.49550607110599 | (37.7793104771033, -122.495506071106) | |||
139173 | 139173 | 60546 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 500 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20156 | 5985047.62508393 | 2112456.532077 | 37.7795376389344 | -122.495346781978 | (37.7795376389344, -122.495346781978) | ||
35350 | 35350 | 60550 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 538 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 4 | Permit Number 20160 | 5985052.81447 | 2112190.6948599997 | 37.7788080303748 | -122.49530921969601 | (37.7788080303748, -122.495309219696) | |
150768 | 150768 | 60565 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 695 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 6 | Permit Number 20175 | 5985042.36004 | 2111233.42242 | 37.7761790231769 | -122.49527477111299 | (37.7761790231769, -122.495274771113) |
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");