trees
2,421 rows where qSpecies_id = 8 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49564 | 114655 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2200 Post St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001302.3779 | 2113905.5111 | 37.7844544851842 | -122.439218650192 | (37.7844544851842, -122.439218650192) | 15 | 6 | 11 | 29490 | 13 | |||
69628 | 114796 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 719 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2015 12:00:00 AM | Permit Number 775428 | 5990315.8 | 2110460.7 | 37.7743646815998 | -122.476976231877 | (37.7743646815998, -122.476976231877) | 11 | 6 | 2 | 55 | 26 | |||
47336 | 114900 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1518 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2015 12:00:00 AM | Permit Number 775911 | 5994035.5 | 2105147.2 | 37.7599902919139 | -122.463723459922 | (37.7599902919139, -122.463723459922) | 1 | 5 | 4 | 56 | 12 | |||
119910 | 115159 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
77440 | 115160 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
178149 | 115161 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
183774 | 115293 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2167 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776197 | 5990660.3 | 2100644 | 37.7474306230823 | -122.475067792345 | (37.7474306230823, -122.475067792345) | 1 | 8 | 4 | 29491 | 40 | |||
30001 | 115382 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 625 Moultrie St | 1 | Side Yard : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776180 | 6007689.5 | 2096426.5 | 37.7368225406079 | -122.415883184956 | (37.7368225406079, -122.415883184956) | 2 | 7 | 7 | 28859 | 2 | ||
38375 | 115384 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 324 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777467 | 6006881.6 | 2096254.2 | 37.7363039898307 | -122.418664241464 | (37.7363039898307, -122.418664241464) | 2 | 7 | 7 | 28859 | 2 | ||
34097 | 115876 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1880 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005184.1768 | 2117160.91115 | 37.793613123489 | -122.426020771756 | (37.793613123489, -122.426020771756) | 13 | 9 | 1 | 28858 | 27 | ||
36476 | 115877 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1880 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005144.10497 | 2117158.82947 | 37.7936051429156 | -122.42615927544 | (37.7936051429156, -122.42615927544) | 13 | 9 | 1 | 28858 | 27 | ||
69384 | 115938 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 718 16TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773052 | 5991032 | 2110485 | 37.7744729248175 | -122.474500561298 | (37.7744729248175, -122.474500561298) | 11 | 6 | 2 | 54 | 26 | |
161023 | 116584 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 GOUGH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006450 | 2109317 | 37.7721471206774 | -122.421083698286 | (37.7721471206774, -122.421083698286) | 8 | 2 | 9 | 28853 | 19 | |||
101627 | 116814 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3660x 23RD ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779082 | 6005401 | 2102665 | 37.7538231135776 | -122.42423909942 | (37.7538231135776, -122.42423909942) | 2 | 4 | 5 | 28859 | 19 | |
73815 | 117002 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 161 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778235 | 6001002.4 | 2094897.4 | 37.7322457718664 | -122.438893830128 | (37.7322457718664, -122.438893830128) | 9 | 7 | 4 | 63 | 40 | |
126441 | 117136 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
143699 | 117137 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
6326 | 117138 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
167623 | 117139 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
90738 | 117140 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
154253 | 117141 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
140065 | 117142 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
55582 | 117143 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
172332 | 117144 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
114728 | 117145 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
8525 | 117146 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011982.52405 | 2098055.99364 | 37.741537203178 | -122.401154691646 | (37.741537203178, -122.401154691646) | 10 | 3 | 8 | 58 | 1 | |
10674 | 117147 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011972.25416 | 2098042.58697 | 37.7414998183769 | -122.40118925978 | (37.7414998183769, -122.40118925978) | 10 | 3 | 8 | 58 | 1 | |
18014 | 117148 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011961.8463 | 2098027.63913 | 37.7414581941431 | -122.401224196662 | (37.7414581941431, -122.401224196662) | 10 | 3 | 8 | 58 | 1 | |
8512 | 117149 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011929.15518 | 2097982.19203 | 37.7413315821976 | -122.401334038935 | (37.7413315821976, -122.401334038935) | 10 | 3 | 8 | 58 | 1 | |
132994 | 117150 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 TOLAND ST | 5 | Front Yard : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011950 | 2098029 | 37.7414612698949 | -122.401265252936 | (37.7414612698949, -122.401265252936) | 10 | 3 | 8 | 58 | 1 | |
183033 | 117303 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1075 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778518 | 6009488.7 | 2102920.1 | 37.754753524299 | -122.410120841459 | (37.754753524299, -122.410120841459) | 2 | 4 | 7 | 28859 | 19 | ||
102665 | 117316 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778503 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | 1 | 8 | 4 | 29491 | 12 | |||
177260 | 117317 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778503 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | 1 | 8 | 4 | 29491 | 12 | ||
100097 | 117321 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1648 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778498 | 5999899 | 2110608.7 | 37.7753223306588 | -122.443836898167 | (37.7753223306588, -122.443836898167) | 15 | 5 | 11 | 29492 | 16 | |||
126151 | 117332 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.472286093711 | (37.7384265182794, -122.472286093711) | 1 | 8 | 4 | 29491 | 40 | |||
54968 | 117333 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.472286093711 | (37.7384265182794, -122.472286093711) | 1 | 8 | 4 | 29491 | 40 | |||
109443 | 117334 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.472286093711 | (37.7384265182794, -122.472286093711) | 1 | 8 | 4 | 29491 | 40 | |||
19777 | 117430 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 724 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776863 | 6004182.22692 | 2091583.55482 | 37.7233270936563 | -122.427664426683 | (37.7233270936563, -122.427664426683) | 9 | 7 | 6 | 28861 | 5 | ||
178036 | 117440 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1290 20TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5989944 | 2106611 | 37.763772878654 | -122.477980844758 | (37.763772878654, -122.477980844758) | 1 | 8 | 3 | 56 | 35 | ||||
142189 | 117442 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 683 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778575 | 6002740.92134 | 2089524.8599 | 37.7175927411032 | -122.432499770158 | (37.7175927411032, -122.432499770158) | 9 | 7 | 6 | 28861 | 5 | ||
182736 | 118075 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 426 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5985334.53877 | 2112983.7129 | 37.7810019204378 | -122.494393110571 | (37.7810019204378, -122.494393110571) | 11 | 6 | 2 | 55 | 26 | |||
14120 | 11922 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 620X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/10/2016 12:00:00 AM | 3 | 3X4 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | ||
73262 | 119937 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5987300.15523 | 2111149.41702 | 37.7760803002726 | -122.487458375319 | (37.7760803002726, -122.487458375319) | 11 | 6 | 2 | 55 | 26 | |||
68724 | 120402 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 191 23rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5988664 | 2114068 | 37.7841733536199 | -122.482954484434 | (37.7841733536199, -122.482954484434) | 11 | 6 | 2 | 55 | 26 | |||
71479 | 120490 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2101 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5989039.20971 | 2110535.30773 | 37.7744953937056 | -122.481397609154 | (37.7744953937056, -122.481397609154) | 11 | 6 | 2 | 55 | 26 | |||
20721 | 120492 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2101 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5989019.39617 | 2110533.53925 | 37.7744893859398 | -122.481466017661 | (37.7744893859398, -122.481466017661) | 11 | 6 | 2 | 55 | 26 | |||
24453 | 120820 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 20th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5989571.70093 | 2114608.17958 | 37.7857093094708 | -122.47985374027 | (37.7857093094708, -122.47985374027) | 11 | 6 | 2 | 55 | 26 | |||
158104 | 120821 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 20th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5989570.27097 | 2114621.23399 | 37.7857450701275 | -122.479859643088 | (37.7857450701275, -122.479859643088) | 11 | 6 | 2 | 55 | 26 | |||
112806 | 121021 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1649 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6005068.54414 | 2119516.86917 | 37.8000754484782 | -122.42658871161 | (37.8000754484782, -122.42658871161) | 13 | 9 | 1 | 57 | 17 | |||
149177 | 121570 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1530 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779159 | 6010119 | 2100471 | 37.7480641462346 | -122.40776839944 | (37.7480641462346, -122.40776839944) | 2 | 7 | 7 | 28859 | 2 | |
11087 | 122015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1799 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990132.5051 | 2110630.33529 | 37.7748198185001 | -122.477622678128 | (37.7748198185001, -122.477622678128) | 11 | 6 | 2 | 55 | 26 | |||
50283 | 122031 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 719 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990343.843 | 2110450.87965 | 37.7743393443985 | -122.476878509257 | (37.7743393443985, -122.476878509257) | 11 | 6 | 2 | 55 | 26 | |||
23398 | 122165 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 631 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991266.55577 | 2111104.42075 | 37.776187272392 | -122.473734392293 | (37.776187272392, -122.473734392293) | 11 | 6 | 2 | 54 | 26 | |||
179426 | 122167 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701 15th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991287.4219 | 2110535.49053 | 37.7746263536906 | -122.473620700628 | (37.7746263536906, -122.473620700628) | 11 | 6 | 2 | 54 | 26 | |||
99140 | 122168 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701 15th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991287.03341 | 2110517.07148 | 37.7745757574979 | -122.473620700601 | (37.7745757574979, -122.473620700601) | 11 | 6 | 2 | 54 | 26 | |||
137391 | 122258 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991414.12952 | 2113444.52375 | 37.7826210986154 | -122.473394620723 | (37.7826210986154, -122.473394620723) | 11 | 6 | 2 | 54 | 26 | |||
32637 | 122259 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Clement St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991408.07058 | 2113443.99656 | 37.7826193002424 | -122.473415543385 | (37.7826193002424, -122.473415543385) | 11 | 6 | 2 | 54 | 26 | |||
112641 | 122276 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1718 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990220.44471 | 2111314.15807 | 37.7767025104298 | -122.477368467498 | (37.7767025104298, -122.477368467498) | 11 | 6 | 2 | 55 | 26 | |||
121704 | 122306 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1609 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990561.02616 | 2111270.95171 | 37.7766036334271 | -122.476187151446 | (37.7766036334271, -122.476187151446) | 11 | 6 | 2 | 55 | 26 | |||
22379 | 122307 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1617 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990526.29521 | 2111270.38864 | 37.7766000733292 | -122.476307253497 | (37.7766000733292, -122.476307253497) | 11 | 6 | 2 | 55 | 26 | |||
48792 | 122341 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 401 04th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2017 12:00:00 AM | 3 | 3x3 | 5994600 | 2112752 | 37.780903582725 | -122.462322713118 | (37.780903582725, -122.462322713118) | 11 | 6 | 2 | 54 | 11 | ||
51660 | 122788 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007172 | 2109097 | 37.7715837270561 | -122.418570631079 | (37.7715837270561, -122.418570631079) | 8 | 2 | 9 | 28853 | 19 | ||||
51936 | 123028 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 738 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5991970.4168 | 2110394.80661 | 37.7742796046287 | -122.471247855577 | (37.7742796046287, -122.471247855577) | 11 | 6 | 2 | 54 | 11 | |||
185690 | 123088 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 681 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992531.98412 | 2110836.60467 | 37.77552513003 | -122.469337473167 | (37.77552513003, -122.469337473167) | 11 | 6 | 2 | 54 | 11 | |||
181661 | 123098 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 575 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992506.57833 | 2111546.13645 | 37.777471844019 | -122.469477017446 | (37.777471844019, -122.469477017446) | 11 | 6 | 2 | 54 | 11 | |||
32114 | 123721 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995382.67333 | 2111440.05096 | 37.7773463562681 | -122.459520034239 | (37.7773463562681, -122.459520034239) | 11 | 6 | 2 | 54 | 11 | |||
101192 | 123725 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 549 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993866.33866 | 2110708.86626 | 37.7752514134392 | -122.464712378338 | (37.7752514134392, -122.464712378338) | 11 | 6 | 2 | 54 | 11 | |||
66682 | 123726 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 598 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993863.8164 | 2110765.62701 | 37.7754071178751 | -122.464725226052 | (37.7754071178751, -122.464725226052) | 11 | 6 | 2 | 54 | 11 | |||
115693 | 123727 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 598 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993898.69651 | 2110767.53624 | 37.7754143709704 | -122.46460470717 | (37.7754143709704, -122.46460470717) | 11 | 6 | 2 | 54 | 11 | |||
73552 | 123730 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 442 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 3ft | 5994233.00826 | 2110778.83471 | 37.7754646605749 | -122.463449073067 | (37.7754646605749, -122.463449073067) | 11 | 6 | 2 | 54 | 11 | ||
190955 | 123735 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 398 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5994515.79324 | 2110787.16748 | 37.7755038287288 | -122.462471464384 | (37.7755038287288, -122.462471464384) | 11 | 6 | 2 | 54 | 11 | |||
189816 | 123739 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5994624.79373 | 2110737.82643 | 37.7753746276433 | -122.462090829336 | (37.7753746276433, -122.462090829336) | 11 | 6 | 2 | 54 | 11 | |||
187096 | 123740 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994649.40915 | 2110738.31442 | 37.7753773847387 | -122.462005714867 | (37.7753773847387, -122.462005714867) | 11 | 6 | 2 | 54 | 11 | |||
178186 | 123744 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 202 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994990.89316 | 2110807.47376 | 37.775586932168 | -122.460829463509 | (37.775586932168, -122.460829463509) | 11 | 6 | 2 | 54 | 11 | |||
9088 | 123748 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/05/2015 07:10:00 AM | 15 | Width 3ft | 5995551.56394 | 2110826.65908 | 37.7756718539675 | -122.458891368973 | (37.7756718539675, -122.458891368973) | 11 | 6 | 2 | 54 | 11 | ||
51535 | 123749 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 3ft | 5995567.69989 | 2110826.72314 | 37.7756729573603 | -122.458835555737 | (37.7756729573603, -122.458835555737) | 11 | 6 | 2 | 54 | 11 | ||
185944 | 123751 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 3ft | 5995599.55133 | 2110826.05638 | 37.7756729573693 | -122.458725326168 | (37.7756729573693, -122.458725326168) | 11 | 6 | 2 | 54 | 11 | ||
161015 | 123752 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/29/2018 12:00:00 AM | 3 | Width 3ft | 5995621.16362 | 2110827.61225 | 37.77567847155 | -122.458650677058 | (37.77567847155, -122.458650677058) | 11 | 6 | 2 | 54 | 11 | ||
166852 | 123774 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 921 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5992733.94745 | 2110666.64167 | 37.7750701263922 | -122.468626470068 | (37.7750701263922, -122.468626470068) | 11 | 6 | 2 | 54 | 11 | |||
123439 | 123775 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 999 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992633.47404 | 2110664.48077 | 37.7750583885988 | -122.468973869259 | (37.7750583885988, -122.468973869259) | 11 | 6 | 2 | 54 | 11 | |||
145589 | 123776 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 999 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992611.69228 | 2110664.0229 | 37.7750558729015 | -122.469049183134 | (37.7750558729015, -122.469049183134) | 11 | 6 | 2 | 54 | 11 | |||
153986 | 123783 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 950 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992630.21461 | 2110720.88883 | 37.7752130815921 | -122.468989250215 | (37.7752130815921, -122.468989250215) | 11 | 6 | 2 | 54 | 11 | |||
158433 | 124028 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 Funston Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5991796.1991 | 2114253.0901 | 37.7848633156564 | -122.472131792452 | (37.7848633156564, -122.472131792452) | 11 | 6 | 2 | 54 | 11 | |||
132262 | 124029 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 Funston Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5991795.62331 | 2114277.55052 | 37.7849304438848 | -122.472135568047 | (37.7849304438848, -122.472135568047) | 11 | 6 | 2 | 54 | 11 | |||
21414 | 124354 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1100 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992180.38847 | 2111384.61555 | 37.7770094950384 | -122.470593638633 | (37.7770094950384, -122.470593638633) | 11 | 6 | 2 | 54 | 11 | |||
189860 | 124355 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1108 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5992124.25378 | 2111386.32559 | 37.7770109442204 | -122.470787948699 | (37.7770109442204, -122.470787948699) | 11 | 6 | 2 | 54 | 11 | |||
104784 | 124478 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 286 Willard St North | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996252.67686 | 2110874.20088 | 37.7758426671593 | -122.456469499274 | (37.7758426671593, -122.456469499274) | 11 | 6 | 2 | 54 | 16 | |||
95594 | 124479 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 286 Willard St North | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996254.72028 | 2110859.07081 | 37.7758012412704 | -122.456461336274 | (37.7758012412704, -122.456461336274) | 11 | 6 | 2 | 54 | 16 | |||
52362 | 124532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 951 Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992651.91776 | 2111347.60988 | 37.7769351421706 | -122.468959793565 | (37.7769351421706, -122.468959793565) | 11 | 6 | 2 | 54 | 11 | |||
77104 | 124533 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 951 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992637.18811 | 2111348.18178 | 37.7769358614128 | -122.469010789113 | (37.7769358614128, -122.469010789113) | 11 | 6 | 2 | 54 | 11 | |||
78978 | 124534 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 951 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992622.68332 | 2111346.91424 | 37.7769315430211 | -122.469060872907 | (37.7769315430211, -122.469060872907) | 11 | 6 | 2 | 54 | 11 | |||
158538 | 124535 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 951 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992606.88484 | 2111346.72253 | 37.7769301037952 | -122.469115510242 | (37.7769301037952, -122.469115510242) | 11 | 6 | 2 | 54 | 11 | |||
91649 | 124536 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 951 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992595.02758 | 2111346.18567 | 37.7769279445894 | -122.469156488684 | (37.7769279445894, -122.469156488684) | 11 | 6 | 2 | 54 | 11 | |||
68414 | 126491 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3041 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002852.03397 | 2119100.62162 | 37.7988069853068 | -122.434228905666 | (37.7988069853068, -122.434228905666) | 13 | 9 | 1 | 57 | 17 | |||
36215 | 126492 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2901 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003445.69979 | 2118326.5799 | 37.7967153438803 | -122.432119324565 | (37.7967153438803, -122.432119324565) | 13 | 9 | 1 | 57 | 17 | |||
147719 | 126493 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2901 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003443.96116 | 2118340.85925 | 37.796754452719 | -122.432126360859 | (37.796754452719, -122.432126360859) | 13 | 9 | 1 | 57 | 17 | |||
116466 | 126494 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2901 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003442.2603 | 2118361.73826 | 37.7968116846621 | -122.432133738008 | (37.7968116846621, -122.432133738008) | 13 | 9 | 1 | 57 | 17 | |||
84723 | 126495 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2700 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6000053.14506 | 2117822.05774 | 37.7951371326294 | -122.44382203238 | (37.7951371326294, -122.44382203238) | 13 | 9 | 1 | 57 | 17 | |||
92943 | 126496 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1695 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004921.92717 | 2119147.20146 | 37.7990521458892 | -122.42706971849 | (37.7990521458892, -122.42706971849) | 13 | 9 | 1 | 57 | 17 | |||
9657 | 126497 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1651 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005046.68269 | 2119164.91299 | 37.7991078310233 | -122.426639284086 | (37.7991078310233, -122.426639284086) | 13 | 9 | 1 | 57 | 17 |
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) );