trees

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

✎ View and edit SQL

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)
756 124716 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2195 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2                              
768 20385 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 262X Sunset Blvd 31 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
1032 39972 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 0 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41235                    
1631 30310 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 228 Jordan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 8                    
1923 20027 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY48 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
2304 19829 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY25 13 Sidewalk: Curb side : Cutout Tree DPW 1     6 60X                      
3125 20020 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY48 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
4411 20021 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY48 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
4760 20025 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY48 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
6048 19828 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY25 12 Sidewalk: Curb side : Cutout Tree DPW 1     6 60X                      
7821 19789 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY19 11 Sidewalk: Curb side : Cutout Tree DPW 1     18 50ST                      
8386 20019 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY48 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
8416 20389 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 262X Sunset Blvd 35 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
9682 19808 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY23 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
10444 20024 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY48 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
11795 20386 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 262X Sunset Blvd 32 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
12119 20453 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 495X Sunset Blvd 18 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
12733 102843 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1101X Portola Dr 10 Sidewalk: Property side : Yard Tree DPW 1                              
13471 20029 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY50 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
14545 30309 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 228 Jordan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 8                    
15463 20023 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY48 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
15711 20018 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY48 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
16079 20022 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY48 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 10ST                      
17223 39975 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 0 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 41235                    
17638 20026 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY48 10 Sidewalk: Curb side : Cutout Tree DPW 1     6 10ST                      
18796 19809 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY23 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
19569 19966 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 STAIRWAY41 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
40869 124965 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2635 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 4ft   5999176.9131 2117767.68697 37.7949378266841 -122.446850003851 (37.7949378266841, -122.446850003851) 11   1 57 30
99705 11447 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2X Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3   5995514.85453 2115936.98374 37.7897013284038 -122.459388527967 (37.7897013284038, -122.459388527967) 11   1 61 31
137914 124966 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2625 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 6ft   5999182.83697 2117719.69196 37.7948063835674 -122.446826051293 (37.7948063835674, -122.446826051293) 11   1 57 30
458 125288 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 943 Green St 11 Side Yard : Yard Tree Private 2     1     6008674.79926 2118995.08989 37.7988459853112 -122.414072708211 (37.7988459853112, -122.414072708211) 5 1 10 308 21
1343 23590 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3251X Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005329.9297952 2121916.8669395 37.8066799978444 -122.425855144407 (37.8066799978444, -122.425855144407) 13 1 1 28858 17
1460 30324 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 720 Montgomery St 3 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
2055 83818 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1653-1655 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   22     6008323.3908 2118208.09875 37.7966653595727 -122.415232960457 (37.7966653595727, -122.415232960457) 5 1 10 28858 21
5793 125253 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 20 Reed St 11 Sidewalk: Property side : Yard Tree Private 2     13     6008205.34429 2117069.05453 37.7935311907562 -122.415560743551 (37.7935311907562, -122.415560743551) 5 1 10 28858 21
6106 125254 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1299 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6008497.00299 2116907.63911 37.7931043734065 -122.414540150606 (37.7931043734065, -122.414540150606) 5 1 10 28858 21
8099 125296 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 510 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6010613.51109 2116010.55836 37.7907598831005 -122.407153607672 (37.7907598831005, -122.407153607672) 5 1 10 28857 6
10275 125283 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1022 Vallejo St 2 Sidewalk: Curb side : Yard Tree Private 2     19     6008553.3357 2118652.52979 37.7978985774107 -122.414468760628 (37.7978985774107, -122.414468760628) 5 1 10 308 21
10693 125255 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1299 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008483 2116904 37.7930935946089 -122.4145883443 (37.7930935946089, -122.4145883443) 5 1 10 28858 21
12857 125310 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 550 Davis St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6013216.03203 2118385.20589 37.7974254053999 -122.398315638071 (37.7974254053999, -122.398315638071) 3 1 10 28860 6
14224 83328 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1653-1655 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   23     6008329.52279 2118179.08917 37.7965860510686 -122.415209687771 (37.7965860510686, -122.415209687771) 5 1 10 28858 21
16200 103940 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2300 Mason St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008943.2 2121170.5 37.804834190774 -122.413297871125 (37.804834190774, -122.413297871125) 3 1 10 308 23
16703 99560 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1142 Montgomery St 3 Sidewalk: Curb side : Cutout Tree Private 2     13     6011556.95658 2119287.39483 37.7998100414445 -122.404120029814 (37.7998100414445, -122.404120029814) 3 1 10 308 23
19963 55630 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 836 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/1985 12:00:00 AM 17   Permit Number 22564 6011707.80627 2118223.65482 37.7968976958139 -122.403523149777 (37.7968976958139, -122.403523149777) 3 1 10 308 4
19982 142665 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 87 Vandewater St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6008980.7551 2121289.4217 37.8051628283357 -122.413176321677 (37.8051628283357, -122.413176321677) 3 1 10 308 23
20338 30322 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 720 Montgomery St 1 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
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
22336 98569 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301X Francisco St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
23204 125307 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 10 Jackson St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6013381 2118288 37.7971676890736 -122.397737980255 (37.7971676890736, -122.397737980255) 3 1 10 28860 6
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
23973 125308 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 10 Jackson St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6013381 2118288 37.7971676890736 -122.397737980255 (37.7971676890736, -122.397737980255) 3 1 10 28860 6
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
24470 125260 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 962 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6008372 2119361 37.7998336716629 -122.415146410717 (37.7998336716629, -122.415146410717) 5 1 10 308 32
27065 142985 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 293 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6010414.8862 2120952.2911 37.8043175584205 -122.408189522377 (37.8043175584205, -122.408189522377) 3 1 10 308 23
28670 125286 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 941 Vallejo St 6 Front Yard : Yard Tree Private 2     11     6008909.00848 2118677.12072 37.7979860724672 -122.413239767796 (37.7979860724672, -122.413239767796) 3 1 10 308 21
28763 30315 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1190 Sacramento St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/24/1955 12:00:00 AM     Permit Number 12 6009097.70753924 2116729.99483623 37.7926503347532 -122.412449106972 (37.7926503347532, -122.412449106972) 3 1 10 28857 21
29875 120994 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 838 Pacific Ave 15 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010100.08183161 2118181.67167684 37.7966924872417 -122.409083316519 (37.7966924872417, -122.409083316519) 3 1 10 308 4
29965 125256 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1245 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008510.03128 2116849.44854 37.7929453283033 -122.414490952301 (37.7929453283033, -122.414490952301) 5 1 10 28858 21
30100 125319 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 640 Davis St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6013180.28795 2118636.32064 37.7981129155272 -122.398456952143 (37.7981129155272, -122.398456952143) 3 1 10 28860 6
30332 125323 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 640 Davis St 8 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6013152.59529 2118825.24429 37.7986301120473 -122.398566041686 (37.7986301120473, -122.398566041686) 3 1 10 28860 6
30371 120985 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 838 Pacific Ave 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010100.08183161 2118181.67167684 37.7966924872417 -122.409083316519 (37.7966924872417, -122.409083316519) 3 1 10 308 4
32274 125245 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1360 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6008932.39466 2117598.66545 37.7950262129353 -122.413082548334 (37.7950262129353, -122.413082548334) 3 1 10 28857 21
33008 143325 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 771 BROADWAY 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6009931.4643 2118447.2128 37.7974121508724 -122.409685526133 (37.7974121508724, -122.409685526133) 3 1 10 308 4
33821 142984 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 295 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6010405.1529 2120950.1282 37.8043110746273 -122.408223052773 (37.8043110746273, -122.408223052773) 3 1 10 308 23
34294 125259 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 956 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6008388.69953 2119336.78158 37.7997681123759 -122.415086908746 (37.7997681123759, -122.415086908746) 5 1 10 308 32
35573 125242 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1182 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009131.5618 2116725.13893 37.7926389014101 -122.412331626128 (37.7926389014101, -122.412331626128) 3 1 10 28857 21
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
36795 125302 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 822 Pacific Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6010002.45629 2118162.14134 37.7966333922736 -122.409419745449 (37.7966333922736, -122.409419745449) 3 1 10 308 4
37511 142642 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2350 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6008900.3697 2121311.0639 37.8052177392472 -122.413456037604 (37.8052177392472, -122.413456037604) 3 1 10 308 23
38215 95363 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 775X Broadway 6 Sidewalk: Curb side : Cutout Tree Housing Authority 15 DPW for City Agency   20 3x3   6009884 2118395.5 37.7972675002992 -122.409846113399 (37.7972675002992, -122.409846113399) 3 1 10 308 4
41195 125273 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3150 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 5ft   6005555.61971 2121140.11755 37.8045599961102 -122.425018799299 (37.8045599961102, -122.425018799299) 5 1 1 28858 32
43119 125313 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 550 Davis St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6013202.9728 2118462.79402 37.7976377164748 -122.398366273498 (37.7976377164748, -122.398366273498) 3 1 10 28860 6
43856 111715 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2390x MASON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008938 2121373 37.8053899130211 -122.413330195558 (37.8053899130211, -122.413330195558) 3 1 10 308 23
43886 26538 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 500 Francisco St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6008873.5963 2121134.1535 37.8047304843802 -122.413536170716 (37.8047304843802, -122.413536170716) 3 1 10 308 23
44654 125275 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1036 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008484.89253 2118308.52925 37.7969501919583 -122.414681237168 (37.7969501919583, -122.414681237168) 5 1 10 308 21
45352 29770 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 640 Francisco St 3 Sidewalk: Curb side : Cutout Tree DPW 1     22 6x6   6008266.3741 2121051.4386 37.8044692557294 -122.415631670711 (37.8044692557294, -122.415631670711) 5 1 10 308 23
45455 249872 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 230 Greenwich St 8 Back Yard : Yard Tree Private 2     9 Width 0ft   6011683.12279 2120489.80597 37.8031186185004 -122.403768099014 (37.8031186185004, -122.403768099014) 3 1 10 28860 6
45839 13066 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 604 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 2X2   6009404.55183 2120549.65161 37.803155386878 -122.4116574143 (37.803155386878, -122.4116574143) 3 1 10 308 23
47188 249874 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 230 Greenwich St 10 Back Yard : Yard Tree Private 2     21 Width 0ft   6011664.09828 2120483.35155 37.8030998334423 -122.403833479743 (37.8030998334423, -122.403833479743) 3 1 10 28860 6
47583 23589 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3251X Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005329.9297952 2121916.8669395 37.8066799978444 -122.425855144407 (37.8066799978444, -122.425855144407) 13 1 1 28858 17
51179 142641 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 90 VANDEWATER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6008933.8636 2121305.911 37.8052054712311 -122.413339762783 (37.8052054712311, -122.413339762783) 3 1 10 308 23
52641 30419 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 599 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/24/1956 12:00:00 AM     Permit Number 74 6011244.65303661 2117958.27162773 37.7961431366669 -122.405107081517 (37.7961431366669, -122.405107081517) 3 1 10 28857 4
53884 125290 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 479 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6011226.07366 2118986.56843 37.7989655519813 -122.405243818175 (37.7989655519813, -122.405243818175) 3 1 10 308 23
54385 104698 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 455 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6011319.97304 2118997.10943 37.7989997441925 -122.404919635939 (37.7989997441925, -122.404919635939) 3 1 10 308 23
56112 112489 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2690x Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2015 12:00:00 AM   3x3   6007377.71104 2121658.59908 37.8060863706979 -122.418750060411 (37.8060863706979, -122.418750060411) 5 1 1 308 32
56732 142663 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 91 Vandewater St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6008956.5365 2121285.8147 37.8051515647648 -122.413259878143 (37.8051515647648, -122.413259878143) 3 1 10 308 23
57165 142667 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2310 MASON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6008909.645 2121229.1326 37.8049932972422 -122.413418141285 (37.8049932972422, -122.413418141285) 3 1 10 308 23
58924 120989 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 838 Pacific Ave 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010100.08183161 2118181.67167684 37.7966924872417 -122.409083316519 (37.7966924872417, -122.409083316519) 3 1 10 308 4
58946 30316 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1190 Sacramento St 6 Sidewalk: Curb side : Cutout Tree Private 2   10/24/1955 12:00:00 AM     Permit Number 12 6009097.70753924 2116729.99483623 37.7926503347532 -122.412449106972 (37.7926503347532, -122.412449106972) 3 1 10 28857 21
60685 142660 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 85 Vandewater St 5 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6008994.668 2121289.937 37.8051650242759 -122.41312821069 (37.8051650242759, -122.41312821069) 3 1 10 308 23
61387 114840 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2455x HYDE ST   Sidewalk: Curb side : Cutout Tree PUC 8     12 3x3   6006980 2120877 37.8039178984324 -122.420070904619 (37.8039178984324, -122.420070904619) 5 1 1 28858 32
61875 142662 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 93 Vandewater St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   6008939.5318 2121284.2688 37.8051463654169 -122.413318615775 (37.8051463654169, -122.413318615775) 3 1 10 308 23
62280 125311 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 550 Davis St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6013212.98295 2118400.3892 37.7974669253095 -122.398327254619 (37.7974669253095, -122.398327254619) 3 1 10 28860 6
63643 125300 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 822 Pacific Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6010027.66692 2118166.59425 37.7966470313847 -122.40933282505 (37.7966470313847, -122.40933282505) 3 1 10 308 4
63951 23585 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3205X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005442.50763 2121408.51694 37.8052905615414 -122.42542934689 (37.8052905615414, -122.42542934689) 13 1 1 28858 17
65057 142547 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301 FRANCISCO ST 9 Sidewalk: Curb side : Cutout Tree SFUSD 4     20 Width 0ft   6009612.5597 2121193.6724 37.8049353736756 -122.410983109438 (37.8049353736756, -122.410983109438) 3 1 10 308 23
66275 142545 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301 FRANCISCO ST 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     20 Width 0ft   6009562.3577 2121186.5007 37.8049128667558 -122.411156332795 (37.8049128667558, -122.411156332795) 3 1 10 308 23
67884 125304 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 10 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6013381 2118288 37.7971676890736 -122.397737980255 (37.7971676890736, -122.397737980255) 3 1 10 28860 6
68481 30420 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 599 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/1956 12:00:00 AM     Permit Number 74 6011244.65303661 2117958.27162773 37.7961431366669 -122.405107081517 (37.7961431366669, -122.405107081517) 3 1 10 28857 4
68675 7698 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 640 Francisco St 6 Sidewalk: Curb side : Cutout Tree DPW 1     14 6x6   6008421.7430194 2121075.8582463 37.8045450382595 -122.415095730646 (37.8045450382595, -122.415095730646) 5 1 10 308 23

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