3,965 rows where qSpecies_id = 70 sorted by qLegalStatus_id descending

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);