trees
6,714 rows where qSpecies_id = 7 sorted by XCoord
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
604 | 20034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
1515 | 31846 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
3055 | 20039 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
3242 | 43297 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1501 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2000 12:00:00 AM | Permit Number 43066 | |||||||||||||
4991 | 20043 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
6396 | 36746 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39516 | |||||||||||||
7114 | 20035 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
7286 | 33084 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
7976 | 20040 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | ST | |||||||||||||
9521 | 35167 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1998 12:00:00 AM | Permit Number 38700 | |||||||||||||
9968 | 31847 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
14278 | 31848 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
14721 | 20044 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
18188 | 33083 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
18800 | 20042 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
19322 | 46857 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | Permit Number 44926 | ||||||||||||||
40834 | 68577 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 139 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32471 | 5981217.74443457 | 2111271.39856875 | 37.7760586259822 | -122.508507736704 | (37.7760586259822, -122.508507736704) | 11 | 6 | 2 | 55 | 26 | ||
58837 | 34721 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 5535 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 4 | Permit Number 38376 | 5981434.12386 | 2111625.14448 | 37.7770426583791 | -122.507785493074 | (37.7770426583791, -122.507785493074) | 11 | 6 | 2 | 55 | 26 | |
132849 | 36131 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1579 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1998 12:00:00 AM | Permit Number 39226 | 5981546.79724008 | 2104343.49116474 | 37.7570559852656 | -122.506855485843 | (37.7570559852656, -122.506855485843) | 1 | 8 | 3 | 56 | 35 | |||
75267 | 118420 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 5501 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5981593.20872 | 2111630.13422 | 37.7770657300516 | -122.507235548964 | (37.7770657300516, -122.507235548964) | 11 | 6 | 2 | 55 | 26 | |||
129103 | 67270 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 539 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/1992 12:00:00 AM | 3 | Permit Number 30743 | 5981594.69627 | 2112052.00191 | 37.7782241419477 | -122.507261708783 | (37.7782241419477, -122.507261708783) | 11 | 6 | 2 | 55 | 26 | |
128749 | 47834 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 891 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49787 | 5981681.23903 | 2109702.60533 | 37.7717784851525 | -122.506788027132 | (37.7717784851525, -122.506788027132) | 11 | 6 | 2 | 55 | 26 | |
42489 | 88104 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1247 46th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 4x10 | Permit Number 51108 | 5981754.7 | 2106590.8 | 37.7632386939753 | -122.50630313345 | (37.7632386939753, -122.50630313345) | 1 | 8 | 3 | 56 | 35 | |||
126158 | 83831 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1249-1249 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 3 | 4x9 | Permit Number 50162 | 5981782.7749 | 2106603.6182 | 37.7632755418665 | -122.506206983886 | (37.7632755418665, -122.506206983886) | 1 | 8 | 3 | 56 | 35 | |
65093 | 118430 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 5400 Anza St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5981830.66489 | 2111695.69394 | 37.7772597209712 | -122.506418991145 | (37.7772597209712, -122.506418991145) | 11 | 6 | 2 | 55 | 26 | |||
91841 | 118428 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 5400 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5981858.84661 | 2111695.90062 | 37.7772619476301 | -122.506321518541 | (37.7772619476301, -122.506321518541) | 11 | 6 | 2 | 55 | 26 | |||
135396 | 68561 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 531 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 4 | Permit Number 32451 | 5981904.26903 | 2112120.67838 | 37.7784309363863 | -122.506195895437 | (37.7784309363863, -122.506195895437) | 11 | 6 | 2 | 55 | 26 | |
72935 | 68777 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 555 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | 4 | Permit Number 32707 | 5981911.30335 | 2111941.60843 | 37.7779396771332 | -122.506158280277 | (37.7779396771332, -122.506158280277) | 11 | 6 | 2 | 55 | 26 | |
140523 | 68562 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 532 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 5 | Permit Number 32452 | 5981948.24889 | 2112111.86912 | 37.7784093377083 | -122.506043101874 | (37.7784093377083, -122.506043101874) | 11 | 6 | 2 | 55 | 26 | |
80218 | 118775 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 630 45th Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 27 | Width 2ft | 5981986.08838 | 2111427.82901 | 37.7765333919608 | -122.505861476921 | (37.7765333919608, -122.505861476921) | 11 | 6 | 2 | 55 | 26 | |||
91418 | 250997 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 415 44th Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5982186.75835 | 2112941.64621 | 37.7807016980586 | -122.505279538125 | (37.7807016980586, -122.505279538125) | 11 | 6 | 2 | 55 | 26 | |||
124506 | 81964 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 455 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2007 12:00:00 AM | 3x3 | Permit Number 50002 | 5982191.84204192 | 2112715.55923715 | 37.780081229053 | -122.505245190233 | (37.780081229053, -122.505245190233) | 11 | 6 | 2 | 55 | 26 | ||
144125 | 250995 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 453 44th Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5982194.00965 | 2112744.27477 | 37.7801602009846 | -122.505239820464 | (37.7801602009846, -122.505239820464) | 11 | 6 | 2 | 55 | 26 | |||
7604 | 70169 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 5233 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5982394.50702 | 2111657.31782 | 37.7771875318175 | -122.504465669217 | (37.7771875318175, -122.504465669217) | 11 | 6 | 2 | 55 | 26 | |||
587 | 37078 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1318 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 2 | Permit Number 39680 | 5982466.3981 | 2106106.9098 | 37.7619519432804 | -122.50380580728 | (37.7619519432804, -122.50380580728) | 1 | 8 | 3 | 56 | 35 | |
31399 | 83913 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1659 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50155 | 5982499.5096 | 2103826.5104 | 37.7556925599446 | -122.503522416925 | (37.7556925599446, -122.503522416925) | 1 | 8 | 3 | 56 | 35 | |
89529 | 47444 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 651 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45354 | 5982550.9590229 | 2111342.50779778 | 37.7763323565324 | -122.503901138971 | (37.7763323565324, -122.503901138971) | 11 | 6 | 2 | 55 | 26 | |||
153360 | 68542 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 514 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32426 | 5982569.0235475 | 2112276.16618805 | 37.7788969713665 | -122.503907817569 | (37.7788969713665, -122.503907817569) | 11 | 6 | 2 | 55 | 26 | ||
103181 | 55604 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 658 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1973 12:00:00 AM | 1 | Permit Number 773340 | 5982601.78539 | 2111293.43809 | 37.7762006139918 | -122.503721684505 | (37.7762006139918, -122.503721684505) | 11 | 6 | 2 | 55 | 26 | ||
18201 | 79894 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 4119 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5982716.50123 | 2113074.1195 | 37.7810965877323 | -122.503456745272 | (37.7810965877323, -122.503456745272) | 11 | 6 | 2 | 55 | 26 | |||
63275 | 40221 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1463 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | 4 | Permit Number 41400 | 5982763.9993 | 2105167.6847 | 37.7593905919599 | -122.502707013206 | (37.7593905919599, -122.502707013206) | 1 | 8 | 3 | 56 | 35 | ||
175841 | 184308 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1555 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982786.0012 | 2104528.3348 | 37.7576364108681 | -122.502583598561 | (37.7576364108681, -122.502583598561) | 1 | 8 | 3 | 56 | 35 | |||
69974 | 184573 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1731 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982827.3086 | 2103329.3402 | 37.754346736396 | -122.502352009826 | (37.754346736396, -122.502352009826) | 1 | 8 | 3 | 56 | 35 | |||
13321 | 184576 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1735 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982829.6776 | 2103308.6964 | 37.7542901935078 | -122.502342289658 | (37.7542901935078, -122.502342289658) | 1 | 8 | 3 | 56 | 35 | |||
185711 | 184585 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1743 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982830.016 | 2103255.9026 | 37.7541452564276 | -122.502337212531 | (37.7541452564276, -122.502337212531) | 1 | 8 | 3 | 56 | 35 | |||
185731 | 92236 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 551 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52679 | 5982837.48707 | 2112035.40062 | 37.7782516820937 | -122.502961282193 | (37.7782516820937, -122.502961282193) | 11 | 6 | 2 | 55 | 26 | |
13126 | 72283 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 779 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5982894.68666 | 2110493.65125 | 37.7740218490997 | -122.502649263154 | (37.7740218490997, -122.502649263154) | 11 | 6 | 2 | 55 | 26 | |||
113474 | 89562 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 5027 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983024.08969 | 2111679.84197 | 37.7772863874511 | -122.502289445661 | (37.7772863874511, -122.502289445661) | 11 | 6 | 2 | 55 | 26 | ||
1159 | 70451 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2683 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983041.4986 | 2096885.6865 | 37.7366668238827 | -122.5011347377 | (37.7366668238827, -122.5011347377) | 1 | 8 | 3 | 29491 | 35 | |||
112180 | 51437 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 535 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | 2 | Permit Number 47757 | 5983145.9728 | 2112126.66154 | 37.7785203841092 | -122.501900888351 | (37.7785203841092, -122.501900888351) | 11 | 6 | 2 | 55 | 26 | ||
168937 | 47430 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 651 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 5 | Permit Number 45341 | 5983172.9702 | 2111364.55723 | 37.776429453588 | -122.501751096095 | (37.776429453588, -122.501751096095) | 11 | 6 | 2 | 55 | 26 | |
129044 | 89022 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 801 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2008 12:00:00 AM | 3x3 | Permit Number 51767 | 5983196.2 | 2110303.4 | 37.7735171880717 | -122.501592216483 | (37.7735171880717, -122.501592216483) | 11 | 6 | 2 | 55 | 26 | ||
179172 | 49394 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 868 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2003 12:00:00 AM | 4 | Permit Number 46347 | 5983274.10488 | 2109909.62702 | 37.7724405765784 | -122.501293603873 | (37.7724405765784, -122.501293603873) | 11 | 6 | 2 | 55 | 26 | ||
183282 | 56715 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3550 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 5983275.5384 | 2103598.154 | 37.7551111501093 | -122.500821819859 | (37.7551111501093, -122.500821819859) | 1 | 8 | 3 | 56 | 35 | ||||
16964 | 264738 | Section 806 (d) 5 | Prunus cerasifera :: Cherry Plum 7 | 2722 42nd Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/29/2020 12:00:00 AM | 3 | 3x6 | Permit Number 781841 | 5983409.1923 | 2096639.50516 | 37.7360124610612 | -122.499845290879 | (37.7360124610612, -122.499845290879) | 1 | 8 | 3 | 29491 | 35 | |
192489 | 117727 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 432 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5983474.89929 | 2112887.77436 | 37.7806294945058 | -122.500819324845 | (37.7806294945058, -122.500819324845) | 11 | 6 | 2 | 55 | 26 | |||
174976 | 117728 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 432 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5983476.79722 | 2112873.2862 | 37.7805898256829 | -122.50081168738 | (37.7805898256829, -122.50081168738) | 11 | 6 | 2 | 55 | 26 | |||
21069 | 84876 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1951 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/2007 12:00:00 AM | Permit No. 49250 | 5983480.4 | 2101864.4 | 37.7503627699789 | -122.499985207399 | (37.7503627699789, -122.499985207399) | 1 | 8 | 3 | 29491 | 35 | |||
134527 | 84877 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1951 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/2007 12:00:00 AM | Permit No. 49250 | 5983480.4 | 2101864.4 | 37.7503627699789 | -122.499985207399 | (37.7503627699789, -122.499985207399) | 1 | 8 | 3 | 29491 | 35 | |||
36589 | 67228 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 679 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | 5 | Permit Number 30687 | 5983489.70951 | 2111188.94144 | 37.775965863323 | -122.500642433993 | (37.775965863323, -122.500642433993) | 11 | 6 | 2 | 55 | 26 | |
15237 | 47427 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 743 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45338 | 5983505.42349 | 2110743.75617 | 37.7747444359741 | -122.500555150992 | (37.7747444359741, -122.500555150992) | 11 | 6 | 2 | 55 | 26 | |
1276 | 72277 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 819 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5983524.1138 | 2110218.5518 | 37.7733034736496 | -122.500451657892 | (37.7733034736496, -122.500451657892) | 11 | 6 | 2 | 55 | 26 | |||
96952 | 50404 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 650 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | 1 | Permit Number 47055 | 5983530.01588 | 2111373.74494 | 37.7764756463016 | -122.500516673446 | (37.7764756463016, -122.500516673446) | 11 | 6 | 2 | 55 | 26 | |
57646 | 67226 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 858 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | 2 | Permit Number 30685 | 5983581.64532 | 2109958.34866 | 37.7725924077801 | -122.500233411273 | (37.7725924077801, -122.500233411273) | 11 | 6 | 2 | 55 | 26 | |
90147 | 67225 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 862 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | 3 | Permit Number 30684 | 5983582.48092 | 2109929.96399 | 37.7725145206954 | -122.50022842205 | (37.7725145206954, -122.50022842205) | 11 | 6 | 2 | 55 | 26 | |
111738 | 67253 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 878 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 4 | Permit Number 30717 | 5983587.04483 | 2109836.93635 | 37.7722593614509 | -122.500205756641 | (37.7722593614509, -122.500205756641) | 11 | 6 | 2 | 55 | 26 | |
97574 | 49552 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1606@ LAWTON 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2003 12:00:00 AM | 1 | Permit Number 46442 | 5983773.0639 | 2104184.1322 | 37.7567492805381 | -122.499144554539 | (37.7567492805381, -122.499144554539) | 1 | 8 | 3 | 56 | 35 | ||
1235 | 54485 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 524 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/1972 12:00:00 AM | 3 | Permit Number 10277 | 5983807.43995 | 2112211.38308 | 37.7787918392432 | -122.499618921418 | (37.7787918392432, -122.499618921418) | 11 | 6 | 2 | 55 | 26 | |
166897 | 117840 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 600x 39th Ave | 2 | Median : Cutout | Tree | DPW 1 | 2 | Width 6ft | 5983808.59909 | 2111637.58628 | 37.7772164277829 | -122.499572493795 | (37.7772164277829, -122.499572493795) | 11 | 6 | 2 | 55 | 26 | |||
59235 | 117841 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 600x 39th Ave | 1 | Median : Cutout | Tree | DPW 1 | 2 | Width 6ft | 5983809.68656 | 2111621.06726 | 37.7771711351486 | -122.499567510814 | (37.7771711351486, -122.499567510814) | 11 | 6 | 2 | 55 | 26 | |||
63625 | 117842 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 620x 39th Ave | 5 | Median : Cutout | Tree | DPW 1 | 2 | Width 6ft | 5983810.65643 | 2111554.107 | 37.7769873385843 | -122.499559205901 | (37.7769873385843, -122.499559205901) | 11 | 6 | 2 | 55 | 26 | |||
120564 | 102378 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 870 39th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 2 | 5983886.84831 | 2110037.48525 | 37.7728276030319 | -122.499183547509 | (37.7728276030319, -122.499183547509) | 11 | 6 | 2 | 55 | 26 | ||||
73868 | 117830 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 870 39th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5983887.3151 | 2110064.19539 | 37.7729009687813 | -122.499183906851 | (37.7729009687813, -122.499183906851) | 11 | 6 | 2 | 55 | 26 | |||
72745 | 102377 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 870 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 5983889.8768 | 2109995.31333 | 37.7727119887219 | -122.499169955109 | (37.7727119887219, -122.499169955109) | 11 | 6 | 2 | 55 | 26 | ||||
34064 | 183184 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2415 40th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983915.9024 | 2098706.2108 | 37.7417167973555 | -122.498246009192 | (37.7417167973555, -122.498246009192) | 1 | 8 | 3 | 29491 | 35 | |||
183844 | 183181 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2401 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5983915.9024 | 2098758.6426 | 37.7418607608057 | -122.498249880703 | (37.7418607608057, -122.498249880703) | 1 | 8 | 3 | 29491 | 35 | |||
146784 | 183182 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2411 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983916.579 | 2098737.6699 | 37.7418032151543 | -122.498245992674 | (37.7418032151543, -122.498245992674) | 1 | 8 | 3 | 29491 | 35 | |||
141565 | 183183 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2413 40th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983917.2555 | 2098721.0947 | 37.7417577438343 | -122.498242429704 | (37.7417577438343, -122.498242429704) | 1 | 8 | 3 | 29491 | 35 | |||
23446 | 37718 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2400X 40TH AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40087 | 5983946 | 2098489 | 37.7411221603375 | -122.498125905701 | (37.7411221603375, -122.498125905701) | 1 | 8 | 3 | 29491 | 35 | |||
77518 | 37724 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2400X 40TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40087 | 5983946 | 2098489 | 37.7411221603375 | -122.498125905701 | (37.7411221603375, -122.498125905701) | 1 | 8 | 3 | 29491 | 35 | |||
87924 | 37720 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2400X 40TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40087 | 5983946 | 2098489 | 37.7411221603375 | -122.498125905701 | (37.7411221603375, -122.498125905701) | 1 | 8 | 3 | 29491 | 35 | |||
168907 | 37719 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2400X 40TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40087 | 5983946 | 2098489 | 37.7411221603375 | -122.498125905701 | (37.7411221603375, -122.498125905701) | 1 | 8 | 3 | 29491 | 35 | |||
114081 | 67267 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 552 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/1992 12:00:00 AM | 3 | Permit Number 30740 | 5984123.38609 | 2112065.40916 | 37.7784095705965 | -122.498515171286 | (37.7784095705965, -122.498515171286) | 11 | 6 | 2 | 55 | 26 | |
173641 | 46259 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2401 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2002 12:00:00 AM | 3 | Permit Number 44544 | 5984226.0421 | 2098787.5863 | 37.7419584129161 | -122.497179671255 | (37.7419584129161, -122.497179671255) | 1 | 8 | 3 | 29491 | 35 | ||
29582 | 46260 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2401 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2002 12:00:00 AM | 3 | Permit Number 44544 | 5984227.7748 | 2098774.5909 | 37.741922832622 | -122.497172721174 | (37.741922832622, -122.497172721174) | 1 | 8 | 3 | 29491 | 35 | ||
43186 | 118025 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 455 37th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5984366.92897 | 2112698.04941 | 37.7801608967117 | -122.497719402298 | (37.7801608967117, -122.497719402298) | 11 | 6 | 2 | 55 | 26 | |||
81007 | 184148 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1590 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5984387.4321 | 2104376.7436 | 37.7573141589658 | -122.497034092991 | (37.7573141589658, -122.497034092991) | 1 | 8 | 3 | 56 | 35 | |||
119428 | 47423 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 679 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45334 | 5984421.41273 | 2111219.03192 | 37.7761031357935 | -122.497421700614 | (37.7761031357935, -122.497421700614) | 11 | 6 | 2 | 55 | 26 | |
76446 | 178757 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 475 Country Club Dr | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5984730.24902 | 2094611.59389 | 37.7305217923373 | -122.495128441421 | (37.7305217923373, -122.495128441421) | 1 | 8 | 4 | 64 | 35 | |||
79117 | 111025 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 699x 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5984730.84558 | 2111224.06012 | 37.7761350733047 | -122.496351676847 | (37.7761350733047, -122.496351676847) | 11 | 6 | 2 | 55 | 26 | |||
37966 | 118269 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 699 36th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5984732.80962 | 2111158.8686 | 37.7759561911706 | -122.496340071504 | (37.7759561911706, -122.496340071504) | 11 | 6 | 2 | 55 | 26 | |||
166723 | 47422 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 882 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45333 | 5984826.62197 | 2109866.02853 | 37.7724119173032 | -122.495920160342 | (37.7724119173032, -122.495920160342) | 11 | 6 | 2 | 55 | 26 | |
47477 | 20854 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1892X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | |||
79477 | 32606 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1374 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 4 | Permit Number 37072 | 5984960.6662 | 2105837.4888 | 37.7613585336811 | -122.495159369435 | (37.7613585336811, -122.495159369435) | 1 | 8 | 3 | 56 | 35 | |
59126 | 21221 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2392X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
117202 | 21218 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2392X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
174929 | 21220 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2392X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
141585 | 118066 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 415 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5984976.2398 | 2113055.57112 | 37.7811782471615 | -122.495637927617 | (37.7811782471615, -122.495637927617) | 11 | 6 | 2 | 55 | 26 | |||
43250 | 47416 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 419 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 4 | Permit Number 45327 | 5984977.87864 | 2113027.24246 | 37.7811005608257 | -122.495630168001 | (37.7811005608257, -122.495630168001) | 11 | 6 | 2 | 55 | 26 | |
77169 | 118067 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 423 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5984977.9667 | 2113013.83856 | 37.7810637627503 | -122.495628874406 | (37.7810637627503, -122.495628874406) | 11 | 6 | 2 | 55 | 26 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );