trees
891 rows where qSpecies_id = 75 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189983 | 1004 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1810X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6001283.16417 | 2091702.46996 | 37.7234891944335 | -122.437694433548 | (37.7234891944335, -122.437694433548) | 9 | 7 | 6 | 28861 | 25 | ||
53217 | 100773 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
184236 | 100774 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
62005 | 100775 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
149926 | 100776 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
83821 | 100777 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 4x3 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
42224 | 100778 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
104491 | 100779 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
87946 | 101990 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 25 Essex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | 6 | 2 | 9 | 28855 | 6 | ||||
19345 | 101991 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 25 Essex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | 6 | 2 | 9 | 28855 | 6 | ||||
158549 | 101992 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 25 Essex St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | 6 | 2 | 9 | 28855 | 6 | ||||
28512 | 101993 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 25 Essex St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | 6 | 2 | 9 | 28855 | 6 | ||||
142769 | 101994 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 25 Essex St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | 6 | 2 | 9 | 28855 | 6 | ||||
100082 | 102507 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1700X Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.435126576612 | (37.782944132882, -122.435126576612) | 15 | 5 | 11 | 29490 | 41 | ||
122737 | 102508 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1700X Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.435126576612 | (37.782944132882, -122.435126576612) | 15 | 5 | 11 | 29490 | 41 | ||
162823 | 102934 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 801X Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004394.3 | 2104124.7 | 37.7577742117678 | -122.427824502367 | (37.7577742117678, -122.427824502367) | 2 | 4 | 5 | 28862 | 3 | |||
66306 | 103269 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1175 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003540.3 | 2111739 | 37.7786328797101 | -122.431321507712 | (37.7786328797101, -122.431321507712) | 15 | 9 | 11 | 29492 | 41 | ||||
136590 | 104201 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3135 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2015 12:00:00 AM | 1 | 3x3 | Permit Number 770708 | 6008143.9 | 2102068.3 | 37.7523392058798 | -122.41471126484 | (37.7523392058798, -122.41471126484) | 2 | 4 | 7 | 28859 | 19 | |
37592 | 104202 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3135 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2015 12:00:00 AM | 2 | 3x3 | Permit Number 770708 | 6008143.9 | 2102068.3 | 37.7523392058798 | -122.41471126484 | (37.7523392058798, -122.41471126484) | 2 | 4 | 7 | 28859 | 19 | |
93780 | 104203 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3135 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2015 12:00:00 AM | 2 | 3x3 | Permit Number 770708 | 6008143.9 | 2102068.3 | 37.7523392058798 | -122.41471126484 | (37.7523392058798, -122.41471126484) | 2 | 4 | 7 | 28859 | 19 | |
64187 | 107152 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | In front of Gap Inc. | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | |||
102686 | 107153 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | ||||
147641 | 107154 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | ||||
47438 | 107155 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | ||||
119049 | 107156 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | ||||
127705 | 108060 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 333 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014722.47105 | 2114748.49264 | 37.7875236349662 | -122.392848365253 | (37.7875236349662, -122.392848365253) | 6 | 2 | 9 | 28855 | 6 | ||
20764 | 108061 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 333 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014711.31667 | 2114762.04187 | 37.7875602184789 | -122.392887905777 | (37.7875602184789, -122.392887905777) | 6 | 2 | 9 | 28855 | 6 | ||
99183 | 108062 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 333 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014690.02107 | 2114784.12371 | 37.7876196672567 | -122.392963130455 | (37.7876196672567, -122.392963130455) | 6 | 2 | 9 | 28855 | 6 | ||
148004 | 109047 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2146 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6000527.7493 | 2120317.86339 | 37.802017012843 | -122.442359096207 | (37.802017012843, -122.442359096207) | 13 | 9 | 1 | 57 | 17 | ||||
6991 | 112084 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99X Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.7905278405438 | -122.396700174955 | (37.7905278405438, -122.396700174955) | 12 | 2 | 9 | 28855 | 6 | |||
120325 | 112085 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.7905278405438 | -122.396700174955 | (37.7905278405438, -122.396700174955) | 12 | 2 | 9 | 28855 | 6 | |||
149763 | 112290 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 34 YERBA BUENA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776546 | 5993584 | 2097045 | 37.7377176881769 | -122.464696609393 | (37.7377176881769, -122.464696609393) | 1 | 8 | 4 | 59 | 40 | |
49904 | 1124 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2463 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5999036.51586 | 2088791.07267 | 37.715367165446 | -122.445251440001 | (37.715367165446, -122.445251440001) | 9 | 7 | 6 | 28861 | 25 | ||
18758 | 112591 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200X Divisadero St | 1 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | 6001352.6873 | 2112575.8699 | 37.7808064923129 | -122.438949276348 | (37.7808064923129, -122.438949276348) | 15 | 5 | 11 | 29490 | 41 | |||
147872 | 112592 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200M Divisadero St | 2 | Median : Cutout | Tree | DPW 1 | 4 | 3x3 | 6001349.3031 | 2112591.7757 | 37.7808499730483 | -122.438962124144 | (37.7808499730483, -122.438962124144) | 15 | 5 | 11 | 29490 | 41 | |||
168532 | 112593 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200M Divisadero St | 3 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001345.5805 | 2112610.0505 | 37.7808999391999 | -122.438976312469 | (37.7808999391999, -122.438976312469) | 15 | 5 | 11 | 29490 | 41 | |||
177710 | 112594 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200M Divisadero St | 4 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001343.2115 | 2112635.4321 | 37.7809694958311 | -122.438986327521 | (37.7809694958311, -122.438986327521) | 15 | 5 | 11 | 29490 | 41 | |||
22294 | 112595 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200X Divisadero St | 5 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001326.7981 | 2112711.2386 | 37.7811767073085 | -122.439048543991 | (37.7811767073085, -122.439048543991) | 15 | 5 | 11 | 29490 | 41 | |||
191156 | 112596 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200x Divisadero St | 6 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001324.7675 | 2112728.8365 | 37.7812249111251 | -122.439056830439 | (37.7812249111251, -122.439056830439) | 15 | 5 | 11 | 29490 | 41 | |||
353 | 112597 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200X Divisadero St | 7 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001322.3986 | 2112740.3429 | 37.7812563699828 | -122.439065850543 | (37.7812563699828, -122.439065850543) | 15 | 5 | 11 | 29490 | 41 | |||
131621 | 112598 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1200X Divisadero St | 8 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001320.7065 | 2112754.895 | 37.7812962300665 | -122.439072747614 | (37.7812962300665, -122.439072747614) | 15 | 5 | 11 | 29490 | 41 | |||
168375 | 1128 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2525 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 3 | 3X6 | 5998741.2887 | 2088615.01895 | 37.7148669056281 | -122.446259214537 | (37.7148669056281, -122.446259214537) | 9 | 7 | 6 | 28861 | 25 | ||
216 | 114440 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2961 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011605 | 2091859 | 37.724500488626 | -122.402024501601 | (37.724500488626, -122.402024501601) | 10 | 3 | 7 | 309 | 28 | ||||
17808 | 114441 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2809 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011711 | 2091301 | 37.7229742506471 | -122.401618870695 | (37.7229742506471, -122.401618870695) | 10 | 3 | 7 | 309 | 28 | ||||
151914 | 114457 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 1985 GOLDEN GATE AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6000094 | 2111584 | 37.7780113768023 | -122.443232414545 | (37.7780113768023, -122.443232414545) | 15 | 5 | 11 | 29490 | 16 | |||
30147 | 115348 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014915.48611 | 2114547.78532 | 37.7869832575075 | -122.39216652446 | (37.7869832575075, -122.39216652446) | 6 | 2 | 9 | 28855 | 6 | |
152753 | 115349 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014896.08459 | 2114567.05321 | 37.7870350854597 | -122.392234997951 | (37.7870350854597, -122.392234997951) | 6 | 2 | 9 | 28855 | 6 | |
101037 | 115350 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014880.23802 | 2114582.9179 | 37.7870777663613 | -122.392290933986 | (37.7870777663613, -122.392290933986) | 6 | 2 | 9 | 28855 | 6 | |
153202 | 115351 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014858.41874 | 2114606.67601 | 37.7871417890985 | -122.392368086818 | (37.7871417890985, -122.392368086818) | 6 | 2 | 9 | 28855 | 6 | |
60187 | 115352 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014845.33617 | 2114621.37484 | 37.7871814222392 | -122.392414378515 | (37.7871814222392, -122.392414378515) | 6 | 2 | 9 | 28855 | 6 | |
22052 | 115353 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014819.91687 | 2114646.31579 | 37.7872484927813 | -122.39250406973 | (37.7872484927813, -122.39250406973) | 6 | 2 | 9 | 28855 | 6 | |
116898 | 115354 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014804.62773 | 2114662.16926 | 37.7872911737029 | -122.39255807669 | (37.7872911737029, -122.39255807669) | 6 | 2 | 9 | 28855 | 6 | |
65353 | 115355 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014786.34664 | 2114681.69198 | 37.7873437633547 | -122.392622692086 | (37.7873437633547, -122.392622692086) | 6 | 2 | 9 | 28855 | 6 | |
26350 | 115356 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014763.69701 | 2114705.74438 | 37.7874085478076 | -122.392702738938 | (37.7874085478076, -122.392702738938) | 6 | 2 | 9 | 28855 | 6 | |
73267 | 115729 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 776540 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | |||
71364 | 115730 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776540 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
96718 | 115731 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 15 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776556 | 5993468.8 | 2097225 | 37.7382052810266 | -122.465107977902 | (37.7382052810266, -122.465107977902) | 1 | 8 | 4 | 59 | 40 | ||
139444 | 115733 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 50 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776548 | 5993693.2 | 2096969 | 37.7375153061033 | -122.464313539267 | (37.7375153061033, -122.464313539267) | 1 | 8 | 4 | 59 | 40 | ||
188463 | 115734 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 776555 | 5993732.7 | 2097034 | 37.7376960566374 | -122.464181687663 | (37.7376960566374, -122.464181687663) | 1 | 8 | 4 | 59 | 40 | ||||
193868 | 115735 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776554 | 5993777.6 | 2097002.8 | 37.7376129769989 | -122.464024183823 | (37.7376129769989, -122.464024183823) | 1 | 8 | 4 | 59 | 40 | ||
54288 | 115736 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 66 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776551 | 5993801.4 | 2096894.7 | 37.7373175329251 | -122.463934052027 | (37.7373175329251, -122.463934052027) | 1 | 8 | 4 | 59 | 40 | ||
83163 | 115737 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 9x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776557 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
182457 | 115738 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 95x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776553 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
177311 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
116051 | 115752 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
179132 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | 9 | 8 | 4 | 59 | 40 | ||
79511 | 116155 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 167X Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777681 | 6011953.87529 | 2114523.89639 | 37.7867527801633 | -122.402411408766 | (37.7867527801633, -122.402411408766) | 12 | 2 | 9 | 28855 | 6 | |
69264 | 116464 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
120869 | 116465 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
61751 | 116466 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
42049 | 116467 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
25740 | 116468 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
107853 | 116469 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
98543 | 116470 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
155480 | 116958 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777762 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
8638 | 116994 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 600M Divisadero St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 6001630.0135 | 2110553.7073 | 37.7752699186497 | -122.43784499429 | (37.7752699186497, -122.43784499429) | 15 | 5 | 11 | 29492 | 10 | ||||
70059 | 118374 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x6 | 6014693.17098 | 2114681.80971 | 37.787338911495 | -122.392945071183 | (37.787338911495, -122.392945071183) | 6 | 2 | 9 | 28855 | 6 | |||
5835 | 118375 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x6 | 6014712.48727 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | 6 | 2 | 9 | 28855 | 6 | |||
132870 | 118376 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
42633 | 118377 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
64723 | 118378 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
32270 | 118379 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
75283 | 118380 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6014683 | 2114666 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | 6 | 2 | 9 | 28855 | 6 | ||||
78827 | 1203 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 3111X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.455574291439 | (37.7101888713812, -122.455574291439) | 9 | 7 | 6 | 28861 | 25 | ||
65478 | 1204 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 3101X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.455574291439 | (37.7101888713812, -122.455574291439) | 9 | 7 | 6 | 28861 | 25 | ||
94294 | 1205 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 3101X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.455574291439 | (37.7101888713812, -122.455574291439) | 9 | 7 | 6 | 28861 | 25 | ||
32571 | 121222 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 690 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6007452 | 2105652 | 37.7621403241605 | -122.417357915219 | (37.7621403241605, -122.417357915219) | 8 | 4 | 7 | 28859 | 19 | |||
66507 | 121501 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4 | 10x4 | 6014441.60375 | 2115047.86993 | 37.7883300516388 | -122.393841081021 | (37.7883300516388, -122.393841081021) | 6 | 2 | 9 | 28855 | 6 | |||
37189 | 121502 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | 6 | 2 | 9 | 28855 | 6 | |||
120636 | 121503 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 10x4 | 6014412.49464 | 2115075.87435 | 37.7884053276005 | -122.393943755694 | (37.7884053276005, -122.393943755694) | 6 | 2 | 9 | 28855 | 6 | |||
35800 | 121504 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 10x4 | 6014396.4001 | 2115093.29031 | 37.7884522533286 | -122.394000660325 | (37.7884522533286, -122.394000660325) | 6 | 2 | 9 | 28855 | 6 | |||
40751 | 121505 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 299 Fremont St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 10x4 | 6014377.50413 | 2115113.61118 | 37.7885069995398 | -122.394067461056 | (37.7885069995398, -122.394067461056) | 6 | 2 | 9 | 28855 | 6 | |||
30239 | 121540 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
186332 | 121541 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
117838 | 121542 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
46657 | 121543 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
21732 | 121544 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
73712 | 121545 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
139844 | 121546 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
48226 | 121547 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 |
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) );