trees
3,965 rows where qSpecies_id = 70 sorted by qLegalStatus_id descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
76291 | 48969 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/2002 12:00:00 AM | Permit Number 46156 | 5996812.82347571 | 2110321.29788885 | 37.7743566819763 | -122.454491869748 | (37.7743566819763, -122.454491869748) | 15 | 5 | 2 | 29492 | 16 | |||
76614 | 43901 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2940 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2000 12:00:00 AM | Permit Number 43503 | 6000066.19718413 | 2116781.74083104 | 37.7922814409941 | -122.443702097084 | (37.7922814409941, -122.443702097084) | 13 | 6 | 1 | 29490 | 27 | |||
76918 | 11791 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
77073 | 85503 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Nebraska St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
77387 | 96356 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3622 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2011 12:00:00 AM | 2.5 x6 | 5999184 | 2121228 | 37.8044393220775 | -122.447074624063 | (37.8044393220775, -122.447074624063) | 13 | 9 | 1 | 57 | 17 | |||
78544 | 24934 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/28/1999 12:00:00 AM | 24 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | ||
78581 | 5467 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 600X Dolores St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 6004918.8923427 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | 2 | 4 | 5 | 28862 | 3 | ||||
79561 | 11788 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
80669 | 38644 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2371 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/1998 12:00:00 AM | Permit Number 40569 | 5991667.78903268 | 2099298.30551377 | 37.7437940310181 | -122.471485954341 | (37.7437940310181, -122.471485954341) | 1 | 8 | 4 | 29491 | 40 | |||
81766 | 87010 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
81795 | 46254 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2161 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44539 | 6000422.21933345 | 2120600.45809947 | 37.8027869270392 | -122.442744582339 | (37.8027869270392, -122.442744582339) | 13 | 9 | 1 | 57 | 17 | ||||
82582 | 55547 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 90- 92 CASELLI AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1972 12:00:00 AM | Permit Number 11515 | 6000515.5 | 2104940.8 | 37.759794835822 | -122.441297518402 | (37.759794835822, -122.441297518402) | 2 | 4 | 5 | 28862 | 3 | |||
82653 | 50099 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1510 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46827 | 5992486.72879777 | 2096933.93018279 | 37.7373493975579 | -122.468482291601 | (37.7373493975579, -122.468482291601) | 1 | 8 | 4 | 59 | 40 | ||
83292 | 39249 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3168 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.412982801874 | (37.7483859278404, -122.412982801874) | 2 | 4 | 7 | 28859 | 19 | |||
83487 | 11823 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1299X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991432.1718154 | 2088660.0347764 | 37.7145703669544 | -122.471525618465 | (37.7145703669544, -122.471525618465) | 9 | 8 | 6 | 64 | 24 | |||
83660 | 38514 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2735 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40502 | 5999957.99990299 | 2117760.48412278 | 37.7949626403238 | -122.444146821557 | (37.7949626403238, -122.444146821557) | 13 | 9 | 1 | 57 | 27 | |||
84675 | 42562 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 San Benito Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51025 | 5992910.18577839 | 2095362.95085697 | 37.7330603317539 | -122.46690404336 | (37.7330603317539, -122.46690404336) | 9 | 8 | 4 | 59 | 40 | ||
85214 | 32418 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1996 12:00:00 AM | Permit Number 36947 | 5990009.30581449 | 2102467.22445118 | 37.752398967394 | -122.477452096473 | (37.752398967394, -122.477452096473) | 1 | 8 | 3 | 56 | 35 | |||
85457 | 32033 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3321 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | Permit Number 35417 | 6004720.37722217 | 2106583.67854581 | 37.7645444241082 | -122.42687191329 | (37.7645444241082, -122.42687191329) | 8 | 4 | 5 | 28862 | 3 | |||
87168 | 97262 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1994@ Octavia Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004661.4 | 2117107.1 | 37.7934358122691 | -122.427825787413 | (37.7934358122691, -122.427825787413) | 13 | 9 | 1 | 28858 | 27 | |||||
88656 | 50105 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1550 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | 1 | 8 | 4 | 59 | 40 | ||
88938 | 87293 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 763 45th Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | 11 | 6 | 2 | 55 | 26 | |||
89490 | 85305 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 365 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2007 12:00:00 AM | Permit Number 49591 | 5995968.6 | 2095545 | 37.7337362418337 | -122.456343520233 | (37.7337362418337, -122.456343520233) | 9 | 7 | 4 | 59 | 40 | |||
89524 | 52877 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1801@ NORIEGA 08th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48888 | 5993719.57975271 | 2103223.93352011 | 37.7546912902093 | -122.464676406209 | (37.7546912902093, -122.464676406209) | 1 | 8 | 4 | 56 | 12 | ||||
91337 | 49320 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 595 Marina Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2003 12:00:00 AM | Permit Number 46320 | 6000116.71946789 | 2121594.09727993 | 37.8054977726587 | -122.443873196152 | (37.8054977726587, -122.443873196152) | 13 | 9 | 1 | 57 | 17 | |||
91547 | 95374 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2270 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999358 | 2120844 | 37.8033949017064 | -122.446444841619 | (37.8033949017064, -122.446444841619) | 13 | 9 | 1 | 57 | 17 | |||||
91561 | 34180 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 104 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1997 12:00:00 AM | Permit Number 38006 | 5998990.33122805 | 2116224.12146592 | 37.7906889445626 | -122.447384447462 | (37.7906889445626, -122.447384447462) | 13 | 6 | 1 | 29490 | 31 | |||
91619 | 50998 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2404 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2004 12:00:00 AM | Permit Number 47480 | 6002104.70119173 | 2117406.84878453 | 37.7941138815303 | -122.436693608205 | (37.7941138815303, -122.436693608205) | 13 | 9 | 1 | 57 | 27 | |||
91712 | 100394 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1800X Lincoln Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | 11 | 8 | 2 | 29492 | 8 | ||||
92771 | 30421 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 530 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/1956 12:00:00 AM | Permit Number 75 | 6009285.11323863 | 2120849.80325768 | 37.803972827811 | -122.412091961384 | (37.803972827811, -122.412091961384) | 3 | 1 | 10 | 308 | 23 | |||
93359 | 50109 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1562 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.7369894427575 | -122.468964178249 | (37.7369894427575, -122.468964178249) | 1 | 8 | 4 | 59 | 40 | ||
93884 | 50108 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1562 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46831 | 5992344.65613496 | 2096805.82402753 | 37.7369894427575 | -122.468964178249 | (37.7369894427575, -122.468964178249) | 1 | 8 | 4 | 59 | 40 | ||
94513 | 121667 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 243 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992346.75268289 | 2097836.73381964 | 37.7398201819052 | -122.469031933295 | (37.7398201819052, -122.469031933295) | 1 | 8 | 4 | 59 | 40 | |||||
95376 | 88602 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 370 Parnassus Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51547 | 5996151.9 | 2106560.1 | 37.7639914803102 | -122.45650607155 | (37.7639914803102, -122.45650607155) | 15 | 5 | 11 | 29492 | 12 | |||
95554 | 32029 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3321 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | Permit Number 35417 | 6004720.37722217 | 2106583.67854581 | 37.7645444241082 | -122.42687191329 | (37.7645444241082, -122.42687191329) | 8 | 4 | 5 | 28862 | 3 | |||
96331 | 6978 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 762 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003781.28082 | 2110436.25509 | 37.7750695180517 | -122.430394888902 | (37.7750695180517, -122.430394888902) | 7 | 9 | 11 | 29492 | 10 | |||
97253 | 50102 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1530 Portola Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.7372215720402 | -122.468657807095 | (37.7372215720402, -122.468657807095) | 1 | 8 | 4 | 59 | 40 | ||
98534 | 52660 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1596 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 5.5x6 | Permit Number 48740 | 5993413.6797412 | 2104632.19014775 | 37.7585403580185 | -122.465836598218 | (37.7585403580185, -122.465836598218) | 1 | 8 | 4 | 56 | 12 | ||
100294 | 11789 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1199X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3x4 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | |||
100329 | 51666 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 444 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2005 12:00:00 AM | Permit Number 47943 | 5998559.54409269 | 2106579.38545488 | 37.7641823653154 | -122.448180168308 | (37.7641823653154, -122.448180168308) | 15 | 5 | 11 | 29492 | 9 | |||
101150 | 99904 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
101546 | 96646 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2350 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2011 12:00:00 AM | Permit Number 768028 | 5991735.4 | 2099423.9 | 37.7441427924065 | -122.471261322589 | (37.7441427924065, -122.471261322589) | 1 | 8 | 4 | 29491 | 40 | |||
102639 | 38645 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2371 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 40569 | 5991667.78903268 | 2099298.30551377 | 37.7437940310181 | -122.471485954341 | (37.7437940310181, -122.471485954341) | 1 | 8 | 4 | 29491 | 40 | ||||
103924 | 30856 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
104052 | 99855 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2900 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768992 | 5999541.6 | 2118827.3 | 37.7978680691774 | -122.445664375651 | (37.7978680691774, -122.445664375651) | 13 | 9 | 1 | 57 | 17 | ||||
104200 | 51634 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 77 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47924 | 6005437.59121376 | 2109217.8235753 | 37.7718176826133 | -122.424578652037 | (37.7718176826133, -122.424578652037) | 7 | 9 | 5 | 28852 | 10 | |||
104325 | 3689 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 3 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
104514 | 87964 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 393 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895 | 2121449 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | 3 | 1 | 10 | 308 | 23 | ||
104618 | 92788 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53006 | 6001506.4 | 2107657.3 | 37.7673100756575 | -122.438065079874 | (37.7673100756575, -122.438065079874) | 15 | 5 | 5 | 29492 | 3 | |||
104922 | 49319 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 595 Marina Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2003 12:00:00 AM | Permit Number 46320 | 6000116.71946789 | 2121594.09727993 | 37.8054977726587 | -122.443873196152 | (37.8054977726587, -122.443873196152) | 13 | 9 | 1 | 57 | 17 | |||
105134 | 87963 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 393 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895 | 2121449 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | 3 | 1 | 10 | 308 | 23 | ||
106345 | 23450 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6006201.29445 | 2118123.14104 | 37.796312596515 | -122.422569862433 | (37.796312596515, -122.422569862433) | 13 | 9 | 10 | 28858 | 32 | |||
107746 | 103283 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3195X Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998987.7 | 2116257.6 | 37.790780717413 | -122.447395962042 | (37.790780717413, -122.447395962042) | 13 | 6 | 1 | 29490 | 31 | ||||
107831 | 48968 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/2002 12:00:00 AM | Permit Number 46156 | 5996812.82347571 | 2110321.29788885 | 37.7743566819763 | -122.454491869748 | (37.7743566819763, -122.454491869748) | 15 | 5 | 2 | 29492 | 16 | |||
110062 | 6573 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1329 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6017090.4856833 | 2097396.2206334 | 37.7400092370914 | -122.383447010551 | (37.7400092370914, -122.383447010551) | 10 | 3 | 8 | 58 | 1 | |||
110415 | 49016 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 San Marcos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46202 | 5993947.57587841 | 2100008.88350341 | 37.7458767234594 | -122.463654612612 | (37.7458767234594, -122.463654612612) | 1 | 8 | 4 | 29491 | 40 | ||||
110591 | 100393 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1800X Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | 11 | 8 | 2 | 29492 | 8 | ||||
110931 | 99607 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
111172 | 5321 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1861X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6001005.43894 | 2114739.90905 | 37.7867286257608 | -122.440305813645 | (37.7867286257608, -122.440305813645) | 13 | 6 | 1 | 29490 | 27 | |||
111262 | 99854 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 755 Marina Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x7 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.8050885512442 | -122.446400961387 | (37.8050885512442, -122.446400961387) | 13 | 9 | 1 | 57 | 17 | |||
112187 | 97888 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 30 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768367 | 6003432.2 | 2108510.8 | 37.7697629112822 | -122.431464951074 | (37.7697629112822, -122.431464951074) | 15 | 9 | 5 | 29492 | 10 | ||||
114168 | 115175 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1899X 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x20 | Permit Number 775764 | 5993756.36006 | 2102907.65397 | 37.7538249882276 | -122.464526247261 | (37.7538249882276, -122.464526247261) | 1 | 8 | 4 | 56 | 12 | |||
114494 | 92815 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Cerritos Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/06/2009 12:00:00 AM | 3x3 | Permit Number 53023 | 5992579.4 | 2093009.1 | 37.7265781434944 | -122.46787650278 | (37.7265781434944, -122.46787650278) | 9 | 8 | 4 | 59 | 40 | ||
114499 | 98702 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3150 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2012 12:00:00 AM | 4x4 | Permit Number 768335 | 5999122.2 | 2116336.3 | 37.7910044917558 | -122.446936266113 | (37.7910044917558, -122.446936266113) | 13 | 6 | 1 | 29490 | 31 | ||
114735 | 50104 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1530 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.7372215720402 | -122.468657807095 | (37.7372215720402, -122.468657807095) | 1 | 8 | 4 | 59 | 40 | ||
114773 | 98600 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2195X Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1981 12:00:00 AM | 3x3 | Permit Number 768644 | 6002468 | 2118693 | 37.7976659583882 | -122.435528609991 | (37.7976659583882, -122.435528609991) | 13 | 9 | 1 | 57 | 17 | ||
114820 | 12747 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1711 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5x5 | 5990137.03852 | 2114678.28277 | 37.7859346208741 | -122.477902981363 | (37.7859346208741, -122.477902981363) | 11 | 6 | 2 | 55 | 26 | |||
115501 | 42535 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3800 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2005 12:00:00 AM | Permit Number 47852 | 5996586.74903344 | 2115641.8686237 | 37.7889525925387 | -122.455658560713 | (37.7889525925387, -122.455658560713) | 11 | 6 | 1 | 54 | 31 | |||
117038 | 24929 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2099X Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | 13 | 6 | 11 | 29490 | 13 | |||
117900 | 30855 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
119157 | 50997 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2404 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2004 12:00:00 AM | Permit Number 47480 | 6002104.70119173 | 2117406.84878453 | 37.7941138815303 | -122.436693608205 | (37.7941138815303, -122.436693608205) | 13 | 9 | 1 | 57 | 27 | |||
119243 | 48778 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1144REVISED Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46034 | 6000652.0009049 | 2108954.44361468 | 37.7708230811383 | -122.441113390762 | (37.7708230811383, -122.441113390762) | 15 | 5 | 11 | 29492 | 9 | ||||
119395 | 99900 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
119508 | 30325 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 720 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1956 12:00:00 AM | Permit Number 16 | 6011772.9424544 | 2117800.56968196 | 37.7957396438077 | -122.403267984357 | (37.7957396438077, -122.403267984357) | 3 | 1 | 10 | 28860 | 4 | |||
119649 | 109048 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2146 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 774033 | 6000515.3 | 2120331 | 37.8020523729009 | -122.442403120222 | (37.8020523729009, -122.442403120222) | 13 | 9 | 1 | 57 | 17 | ||||
120279 | 97259 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1994@ Octavia Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004661.4 | 2117107.1 | 37.7934358122691 | -122.427825787413 | (37.7934358122691, -122.427825787413) | 13 | 9 | 1 | 28858 | 27 | |||||
121826 | 51665 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 444 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2005 12:00:00 AM | Permit Number 47943 | 5998559.54409269 | 2106579.38545488 | 37.7641823653154 | -122.448180168308 | (37.7641823653154, -122.448180168308) | 15 | 5 | 11 | 29492 | 9 | |||
122110 | 113061 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2775 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 776016 | 6000301.4 | 2117440.5 | 37.7941036326689 | -122.442935620895 | (37.7941036326689, -122.442935620895) | 13 | 9 | 1 | 57 | 27 | |||
122177 | 39257 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3168 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/1998 12:00:00 AM | Permit Number 40877 | 6008614.08848489 | 2100618.91579037 | 37.7483859278404 | -122.412982801874 | (37.7483859278404, -122.412982801874) | 2 | 4 | 7 | 28859 | 19 | |||
122402 | 41576 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/22/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53640 | 6004804.85382115 | 2107218.95663379 | 37.7662935218736 | -122.426624972491 | (37.7662935218736, -122.426624972491) | 8 | 4 | 5 | 28862 | 3 | |
123206 | 87292 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 763 45th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | 11 | 6 | 2 | 55 | 26 | |||
124560 | 95658 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 499@Cervantes Marina Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000674 | 2121505 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | 13 | 9 | 1 | 57 | 17 | |||
125626 | 30323 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 720 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1956 12:00:00 AM | Permit Number 16 | 6011772.9424544 | 2117800.56968196 | 37.7957396438077 | -122.403267984357 | (37.7957396438077, -122.403267984357) | 3 | 1 | 10 | 28860 | 4 | |||
125803 | 34161 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 679 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 37994 | 5993148.74751892 | 2110862.72772908 | 37.7756324789651 | -122.467205858084 | (37.7756324789651, -122.467205858084) | 11 | 6 | 2 | 54 | 11 | ||||
128620 | 58830 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 733 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1979 12:00:00 AM | 24 | Permit Number 18084 | 6007395.77559951 | 2095369.75005937 | 37.7339044195491 | -122.416823876683 | (37.7339044195491, -122.416823876683) | 2 | 7 | 7 | 28859 | 2 | ||
130547 | 98318 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1811 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773893 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | 13 | 6 | 11 | 29490 | 27 | |
133480 | 94646 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 30 Middle Point Rd | 35 | : | Tree | Private 2 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||||
133602 | 89212 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1540 Pacheco St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51845 | 5990117.7 | 2101817.3 | 37.7506207352004 | -122.47702976858 | (37.7506207352004, -122.47702976858) | 1 | 8 | 3 | 29491 | 35 | |||
134008 | 100395 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1800X Lincoln Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | 11 | 8 | 2 | 29492 | 8 | ||||
134179 | 48976 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 304 Upper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2002 12:00:00 AM | 3x3 | Permit Number 46163 | 5999195.98170881 | 2105884.18320097 | 37.7623098764083 | -122.445928917549 | (37.7623098764083, -122.445928917549) | 15 | 5 | 5 | 29492 | 9 | ||
134245 | 11817 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3X3 | 5991184.5559808 | 2089595.7938425 | 37.7171254042551 | -122.472449649239 | (37.7171254042551, -122.472449649239) | 9 | 8 | 6 | 64 | 24 | |||
134464 | 98317 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1811 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773893 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | 13 | 6 | 11 | 29490 | 27 | |
135204 | 43419 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1181 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43160 | 6005197.0928245 | 2101475.30196221 | 37.7505449630015 | -122.424859624053 | (37.7505449630015, -122.424859624053) | 2 | 4 | 5 | 28859 | 19 | ||||
136556 | 13202 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2131 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002190.75878 | 2119430.36525 | 37.7996748204961 | -122.436540743333 | (37.7996748204961, -122.436540743333) | 13 | 9 | 1 | 57 | 17 | |||
136803 | 98808 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 399X 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994945.2 | 2112858.1 | 37.78121477611 | -122.461136198189 | (37.78121477611, -122.461136198189) | 11 | 6 | 2 | 54 | 11 | ||||
137512 | 44107 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1244 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43617 | 6007592.1489348 | 2118533.63720141 | 37.7975180839438 | -122.417786315081 | (37.7975180839438, -122.417786315081) | 5 | 1 | 10 | 28858 | 32 | ||||
137753 | 203913 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1626 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/1991 12:00:00 AM | 12 | Width 2ft | Permit Number 29961 | 5992490.03892 | 2104357.70043 | 37.7577333574154 | -122.469010959213 | (37.7577333574154, -122.469010959213) | 1 | 8 | 4 | 56 | 12 | |
138101 | 41284 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2652 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2000 12:00:00 AM | Permit Number 41962 | 6006192.78395747 | 2119877.54417008 | 37.8011292630692 | -122.422724050002 | (37.8011292630692, -122.422724050002) | 13 | 9 | 1 | 28858 | 32 | ||
138494 | 99602 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
138773 | 88989 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1696 McAllister St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51741 | 5997688 | 2111682 | 37.7781429711136 | -122.451562655149 | (37.7781429711136, -122.451562655149) | 15 | 6 | 2 | 54 | 16 |
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) );