3,965 rows where qSpecies_id = 70 sorted by Supervisor Districts

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)
20469 114842 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2670 LEAVENWORTH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007398 2121652 37.8060693936166 -122.418679378695 (37.8060693936166, -122.418679378695) 5 1 1 308 23
20506 250806 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 279 31st Ave 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 4ft   5986182.48717 2114056.18318 37.7839962033991 -122.491538643706 (37.7839962033991, -122.491538643706) 11 6 1 55 33
20526 125225 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1606 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6005725.27471 2118266.64899 37.7966797667037 -122.424227203437 (37.7966797667037, -122.424227203437) 13 9 1 28858 17
20738 18077 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2946 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     16 3X3   5999820.6048 2114741.0687 37.7866642791044 -122.444405127725 (37.7866642791044, -122.444405127725) 15 6 1 29490 31
21431 124977 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3751 Broderick St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5999590.28353 2121474.47758 37.8051392872022 -122.445686385433 (37.8051392872022, -122.445686385433) 13 9 1 57 17
21465 104273 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3675 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997210.1 2115656.5 37.7890285184352 -122.453502918425 (37.7890285184352, -122.453502918425) 11 6 1 54 31
21969 125176 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2519 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6001330.49234 2117251.0663 37.7936421149431 -122.439361275412 (37.7936421149431, -122.439361275412) 13 9 1 29490 27
22096 124305 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 169 Jordan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     17 Width 4ft   5996209.82243 2113206.80783 37.7822449293206 -122.456786484191 (37.7822449293206, -122.456786484191) 11 6 1 54 31
22235 125135 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2655 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6000111.60795 2117732.00363 37.7948932023106 -122.44361327005 (37.7948932023106, -122.44361327005) 13 9 1 57 27
22295 99908 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 10 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
22416 38478 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 201 El Camino Del Mar 3 Sidewalk: Curb side : Cutout Tree Private 2   08/25/1998 12:00:00 AM 21   Permit Number 40477 5987978.37889 2115306.2666 37.7875333623487 -122.485417356275 (37.7875333623487, -122.485417356275) 11 6 1 55 33
22458 125100 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3298 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5999060.86441 2115983.22168 37.7900315275801 -122.4471230632 (37.7900315275801, -122.4471230632) 13 6 1 29490 31
22904 95659 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 499@Cervantes Marina Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6000674 2121505 37.805284907113 -122.441938257064 (37.805284907113, -122.441938257064) 13 9 1 57 17
22959 124866 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 12 Rico Way 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001683.07545 2121358.73098 37.8049407402829 -122.438435744435 (37.8049407402829, -122.438435744435) 13 9 1 57 17
22983 125092 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2145 Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   5999827.24336 2116322.83843 37.7910077839349 -122.444495883591 (37.7910077839349, -122.444495883591) 13 6 1 29490 27
23415 125278 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200 Greenwich St 4 Front Yard : Yard Tree Private 2     16     6006716.82854 2119779.13638 37.8008886127761 -122.420903634692 (37.8008886127761, -122.420903634692) 5 1 1 28858 32
23492 99901 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2001X Washington St 3 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
23626 99853 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 755 Marina Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       3x12 Permit Number 768797 5999383.5 2121460.3 37.8050885512442 -122.446400961387 (37.8050885512442, -122.446400961387) 13 9 1 57 17
23699 124946 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3636 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 6ft   5997401.33489 2115425.81933 37.7884060911058 -122.452824617461 (37.7884060911058, -122.452824617461) 11 6 1 54 31
23702 124834 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 60 Retiro Way 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6001777.19779 2121403.36061 37.8050686346845 -122.438113223249 (37.8050686346845, -122.438113223249) 13 9 1 57 17
23718 124908 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3837 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5996520.53305 2115587.04423 37.7887982593656 -122.455883692899 (37.7887982593656, -122.455883692899) 11 6 1 54 31
24026 125179 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2401 Broadway 2 Sidewalk: Curb side : Yard Tree Private 2     24 Width 4ft   6002026.35862 2117343.77621 37.793936248109 -122.436960163797 (37.793936248109, -122.436960163797) 13 9 1 29490 27
24289 30297 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2734 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/1956 12:00:00 AM 9   Permit Number 140 6003569.97515 2117774.33074 37.7952060548567 -122.43164985595 (37.7952060548567, -122.43164985595) 13 9 1 29490 27
24362 125167 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2647 Vallejo St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6001006.56911 2117558.99371 37.7944691638671 -122.440504169841 (37.7944691638671, -122.440504169841) 13 9 1 57 27
24398 23561 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2930 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6005650.5577 2120458.20498 37.8026930017358 -122.424641718951 (37.8026930017358, -122.424641718951) 5 9 1 28858 32
24417 125274 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1255 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6007531.27909 2121531.59091 37.8057462837276 -122.418209601296 (37.8057462837276, -122.418209601296) 5 1 1 308 32
24454 111167 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100X Magnolia St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003205.80331 2119813.99508 37.8007857959727 -122.433055745441 (37.8007857959727, -122.433055745441) 13 9 1 57 17
24486 124784 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3055 Scott St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6000935.85485 2118878.39953 37.7980878784058 -122.440843541621 (37.7980878784058, -122.440843541621) 13 9 1 57 17
24934 125171 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2711 Divisadero St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6000618.48773 2117603.50665 37.7945692791008 -122.441850171667 (37.7945692791008, -122.441850171667) 13 9 1 57 27
25250 137823 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2188 Pine St 2 Sidewalk: Curb side : Cutout Tree DPW 1     13 Width 0ft   6003472.4181 2115248.3783 37.7882649041847 -122.431806975674 (37.7882649041847, -122.431806975674) 13 9 1 29490 27
25306 116489 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2149 LYON ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999319 2116238 37.7907458271484 -122.446248274058 (37.7907458271484, -122.446248274058) 13 6 1 29490 31
25341 138422 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1739 PIERCE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6002029.7373 2114496.7631 37.786119275153 -122.436744579025 (37.786119275153, -122.436744579025) 13 6 1 29490 27
25791 124961 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3146 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   5999036.86973 2119627.81105 37.800037228206 -122.447468527859 (37.800037228206, -122.447468527859) 13 9 1 57 17
26046 124954 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 222 Maple St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   5996644.15697 2115487.85447 37.7885330052342 -122.455448802332 (37.7885330052342, -122.455448802332) 11 6 1 54 31
26093 124678 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3855 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5995722.23749 2115802.66967 37.7893444597434 -122.458661280755 (37.7893444597434, -122.458661280755) 11 6 1 54 31
26287 119617 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3536 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/02/2016 12:00:00 AM 3 3x10   5999214.99092 2121000.37655 37.8038161003064 -122.446950987796 (37.8038161003064, -122.446950987796) 13 9 1 57 17
26390 97260 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1994@ Octavia Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2           6004661.4 2117107.1 37.7934358122691 -122.427825787413 (37.7934358122691, -122.427825787413) 13 9 1 28858 27
26482 125136 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2655 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6000114.20701 2117720.96546 37.7948630426412 -122.443603483632 (37.7948630426412, -122.443603483632) 13 9 1 57 27
26485 124878 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3638 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5997336.3936 2115745.57778 37.7892803409597 -122.453072394193 (37.7892803409597, -122.453072394193) 11 6 1 54 31
26679 124855 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1 Casa Way 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6001720.89506 2121441.74849 37.805170835422 -122.438310816889 (37.805170835422, -122.438310816889) 13 9 1 57 17
27095 104422 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2362 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 3x3   5999509.01294 2120174.0716 37.8015640827681 -122.445874046945 (37.8015640827681, -122.445874046945) 13 9 1 57 17
27128 124972 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2957 Divisadero St 2 Sidewalk: Curb side : Yard Tree Private 2     21 Width 6ft   6000499.51434 2118479.2792 37.7969671396726 -122.442324734908 (37.7969671396726, -122.442324734908) 13 9 1 57 17
27228 124845 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 120 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6001817.73408 2121573.58628 37.8055383343822 -122.437985143623 (37.8055383343822, -122.437985143623) 13 9 1 57 17
27408 124833 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 60 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001778.79024 2121390.34711 37.8050329936375 -122.438106779619 (37.8050329936375, -122.438106779619) 13 9 1 57 17
27527 51878 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2251 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2005 12:00:00 AM 14   Permit Number 48095 6002306.75433 2116015.71739 37.790305674209 -122.435894898847 (37.790305674209, -122.435894898847) 13 9 1 29490 27
27561 116787 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 200 Locust St 7 Sidewalk: Curb side : Cutout Tree Private 2     19 3x3   5997585.95933 2115721.09611 37.7892274203572 -122.452207163638 (37.7892274203572, -122.452207163638) 11 6 1 54 31
27576 23937 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2186X PINE ST 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6003453 2115265 37.7883094423957 -122.431875346345 (37.7883094423957, -122.431875346345) 13 9 1 29490 27
27780 250630 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 161 28th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   5987115.47488 2114730.85404 37.7859031348758 -122.488360488171 (37.7859031348758, -122.488360488171) 11 6 1 55 33
27997 111166 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100X Magnolia St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6003221.39002 2119816.29205 37.8007929869658 -122.433001973165 (37.8007929869658, -122.433001973165) 13 9 1 57 17
28116 125029 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1460 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002224.17314 2121593.74459 37.8056167885575 -122.436580050938 (37.8056167885575, -122.436580050938) 13 9 1 57 17
28808 125112 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3140 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5999143.47803 2116326.58568 37.7909790343956 -122.446861945921 (37.7909790343956, -122.446861945921) 13 6 1 29490 31
28996 125108 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3157 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999114.64614 2116271.09078 37.7908250128999 -122.446957707555 (37.7908250128999, -122.446957707555) 13 6 1 29490 31
29051 44174 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 3898 Washington St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2000 12:00:00 AM   3x3 Permit Number 49758 5996140.20734213 2115579.73573661 37.7887563568945 -122.457199029036 (37.7887563568945, -122.457199029036) 11 6 1 54 31
29295 125189 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2360 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6002270.60471 2117783.5161 37.7951575391526 -122.436146532744 (37.7951575391526, -122.436146532744) 13 9 1 57 17
29455 23464 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2305 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005842.188 2118344.10635 37.7968990457145 -122.423828167031 (37.7968990457145, -122.423828167031) 13 9 1 57 17
29539 138615 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2926 PINE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 0ft   5999888.2411 2114747.6353 37.7866861681099 -122.444171595218 (37.7866861681099, -122.444171595218) 15 6 1 29490 31
29568 125050 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3025 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6005509.11521 2120789.62029 37.8035949938703 -122.425154777693 (37.8035949938703, -122.425154777693) 13 9 1 28858 17
29784 12809 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2112 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2     60 5   5988863.55424 2114711.62184 37.7859521665696 -122.482311278452 (37.7859521665696, -122.482311278452) 11 6 1 55 33
30177 125126 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2921 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   5999560.3078 2117361.82624 37.7938453356549 -122.445494209301 (37.7938453356549, -122.445494209301) 13 9 1 57 27
30506 124772 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2630 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   5999644.99215 2117912.00689 37.7953608200945 -122.445240769548 (37.7953608200945, -122.445240769548) 13 9 1 57 17
30715 73286 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1999 12:00:00 AM 8 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
30901 103929 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 191 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       4x10   5994248.3 2114379.9 37.7853530981444 -122.463657591004 (37.7853530981444, -122.463657591004) 11 6 1 54 11
30945 125193 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2809 Buchanan St 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6003491.11176 2118014.84394 37.7958619718008 -122.431939917892 (37.7958619718008, -122.431939917892) 13 9 1 57 17
31010 249714 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2975 Broadway 3 Back Yard : Yard Tree Private 2     20     5999388.9274 2116973.59042 37.7927695576174 -122.446059261445 (37.7927695576174, -122.446059261445) 13 9 1 29490 27
31521 124836 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 66 Retiro Way 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001774.9431 2121429.36866 37.8051399176477 -122.438122890072 (37.8051399176477, -122.438122890072) 13 9 1 57 17
31574 125219 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2269 Sacramento St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 Width 4ft   6003923.5815 2115960.33762 37.7902453288032 -122.430296840347 (37.7902453288032, -122.430296840347) 13 9 1 29490 27
31693 143121 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1869 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6003430.714 2119601.3681 37.8002147325944 -122.432262267287 (37.8002147325944, -122.432262267287) 13 9 1 57 17
31878 125201 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2201 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   6003579.67641 2116899.4218 37.7928043289977 -122.431553796666 (37.7928043289977, -122.431553796666) 13 9 1 29490 27
32061 49500 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2003 12:00:00 AM   3x3 Permit Number 46414 5994271.00866961 2115572.53954866 37.7886290700296 -122.463665616673 (37.7886290700296, -122.463665616673) 11 6 1 54 11
32384 46269 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2373 REVISED Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     14   Permit Number 44553 6003358.75375 2116535.00791 37.7917912175406 -122.432292160763 (37.7917912175406, -122.432292160763) 13 9 1 29490 27
32479 125072 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2559 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002527.91845 2116093.19627 37.7905309723786 -122.435135231625 (37.7905309723786, -122.435135231625) 13 9 1 29490 27
32544 105274 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 232 30th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5986553.3 2114252.8 37.784557719608 -122.490270252434 (37.784557719608, -122.490270252434) 11 6 1 55 33
32695 38515 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2735 Green St 2 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
32867 124933 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 313 Maple St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5996636.27305 2115218.34892 37.78779256281 -122.45545659314 (37.78779256281, -122.45545659314) 11 6 1 54 31
32977 125002 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 69 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6001637.34931 2120884.52761 37.8036361027929 -122.438559986648 (37.8036361027929, -122.438559986648) 13 9 1 57 17
32979 125014 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 691 Marina Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5999712.95085 2121535.70639 37.8053144077071 -122.445266286916 (37.8053144077071, -122.445266286916) 13 9 1 57 17
33026 125054 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1733 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6002453.36276 2120887.52869 37.8036907276167 -122.435736350154 (37.8036907276167, -122.435736350154) 13 9 1 57 17
33055 250847 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 232 30th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     14 Width 4ft   5986528.24832 2114250.81305 37.7845508009207 -122.490356775353 (37.7845508009207, -122.490356775353) 11 6 1 55 33
33120 12727 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 4X4   5990457.1993 2114785.86556 37.7862485896694 -122.476803188002 (37.7862485896694, -122.476803188002) 11 6 1 55 33
33190 7922 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1295X Franklin St 4 Sidewalk: Curb side : Cutout Tree DPW 1     32 4x6   6005919.56037 2114492.67616 37.786328349346 -122.423286518029 (37.786328349346, -122.423286518029) 13 9 1 28858 41
33207 124998 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 155 Cervantes Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6001147.91549 2121233.53954 37.8045665431681 -122.440278736772 (37.8045665431681, -122.440278736772) 13 9 1 57 17
33344 125185 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2757 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6002077.54743 2117675.01873 37.7948486633864 -122.436806769111 (37.7948486633864, -122.436806769111) 13 9 1 57 27
33368 103490 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2601 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6001053.62878 2117568.22705 37.7944971957398 -122.440342000495 (37.7944971957398, -122.440342000495) 13 9 1 57 27
33407 125055 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1725 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6002469.3064 2120890.0959 37.8036986821095 -122.435681360206 (37.8036986821095, -122.435681360206) 13 9 1 57 17
34132 111168 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 100X Magnolia St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6003190.19669 2119810.74673 37.8007759915841 -122.43310951859 (37.8007759915841, -122.43310951859) 13 9 1 57 17
34135 106832 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 138 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2     10   Permit Number 774880 5997571.74884 2115814.60363 37.7894833530272 -122.452263079899 (37.7894833530272, -122.452263079899) 11 6 1 54 31
34145 23560 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2909 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6005511.81289 2120357.28421 37.8024080624664 -122.425114661564 (37.8024080624664, -122.425114661564) 13 9 1 28858 17
34218 32423 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2641 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/1996 12:00:00 AM 12   Permit Number 36950 6000352.62092 2118166.60357 37.7961002417749 -122.442810555866 (37.7961002417749, -122.442810555866) 13 9 1 57 17
34522 124953 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 222 Maple St 1 Sidewalk: Curb side : Yard Tree Private 2     14 Width 4ft   5996648.39198 2115469.91468 37.7884839903839 -122.45543285284 (37.7884839903839, -122.45543285284) 11 6 1 54 31
35099 124895 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3757 Washington St 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   5996835.55355 2115629.96293 37.7889341775065 -122.454796874798 (37.7889341775065, -122.454796874798) 11 6 1 54 31
35200 250846 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 232 30th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     20 Width 4ft   5986528.43338 2114238.12689 37.7845159791832 -122.490355201546 (37.7845159791832, -122.490355201546) 11 6 1 55 33
35437 115478 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 54X Laurel St 5 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   5998000.5009 2116231.73295 37.7906532316094 -122.450809740384 (37.7906532316094, -122.450809740384) 13 6 1 54 31
35606 124793 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2661 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 2ft   6000281.59874 2118154.61893 37.7960632859464 -122.443055444859 (37.7960632859464, -122.443055444859) 13 9 1 57 17
35847 249706 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2400 Baker St 38 Front Yard : Yard Tree Private 2     10     5999689.68932 2117193.09573 37.7933894315405 -122.445034403012 (37.7933894315405, -122.445034403012) 13 9 1 57 27
36070 125169 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2647 Vallejo St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6001017.71367 2117559.63744 37.7944715659634 -122.440465654581 (37.7944715659634, -122.440465654581) 13 9 1 57 27
36081 124796 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2700 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6000021.82645 2118165.23175 37.7960776112345 -122.443955068183 (37.7960776112345, -122.443955068183) 13 9 1 57 17
36128 124795 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2643 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6000315.12191 2118159.5515 37.7960787407936 -122.442939802828 (37.7960787407936, -122.442939802828) 13 9 1 57 17
36288 125048 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3101 Van Ness Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6005420.68062 2121375.93261 37.8051998601557 -122.425502561696 (37.8051998601557, -122.425502561696) 13 1 1 28858 17
36351 125212 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2010 Washington St 1 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   6004876.33851 2116792.20983 37.7925833601806 -122.427059645199 (37.7925833601806, -122.427059645199) 13 9 1 28858 27
36619 43982 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 58 Blake St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/2000 12:00:00 AM 11   Permit Number 43545 5997823.8786 2113381.5676 37.7828173196945 -122.451215205093 (37.7828173196945, -122.451215205093) 15 6 1 54 31

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