trees

3,965 rows where qSpecies_id = 70 sorted by Fire Prevention 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                      
57615 188567 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 500 24th St 2 Sidewalk: Property side : Yard Tree Private 2     25     6016949.54535 2102644.83882 37.7544130748234 -122.384299775913 (37.7544130748234, -122.384299775913)   3 8 28856 29
185202 188630 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Tulare St 12 Front Yard : Yard Tree Private 2     14     6016199.1477 2100300.81075 37.7479353426391 -122.386731417715 (37.7479353426391, -122.386731417715)   3 8 58 1
177 253253 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
609 203926 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1799X 12th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     21 Width 3ft   5992472.81762 2103516.18857 37.7554217903919 -122.469009276583 (37.7554217903919, -122.469009276583) 1 8 4 56 12
729 203987 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1520 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5992392.5651 2096889.45083 37.7372218288298 -122.46880462056 (37.7372218288298, -122.46880462056) 1 8 4 59 40
837 203953 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2360 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5991715.8619 2099340.71022 37.7439132444177 -122.471322820316 (37.7439132444177, -122.471322820316) 1 8 4 29491 40
885 203703 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 633 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   5992869.03861 2105232.1882 37.7601563630469 -122.467763833333 (37.7601563630469, -122.467763833333) 1 8 4 56 12
1633 50106 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1550 Portola Dr 1 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
1805 203698 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1696 09th Ave 1 Front Yard : Yard Tree Private 2     25 Width 6ft   5993434.49176 2103973.54477 37.7567330891842 -122.46571676863 (37.7567330891842, -122.46571676863) 1 8 4 56 12
2252 203962 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 48 Madrone Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5992865.45174 2098775.16765 37.7424268404178 -122.467306724153 (37.7424268404178, -122.467306724153) 1 8 4 59 40
2343 99661 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1365 Portola Dr 2 Sidewalk: Curb side : Cutout Tree Private 2           5993416.2 2097683.7 37.7394617231066 -122.465323151466 (37.7394617231066, -122.465323151466) 1 8 4 59 40
3042 184887 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1201 Sunset Blvd 75 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984636.53 2106768.6166 37.7638961671737 -122.496349110122 (37.7638961671737, -122.496349110122) 1 8 3 56 35
3500 186187 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1701 Sunset Blvd 6 Sidewalk: Curb side : Yard Tree Private 2     21 Width 0ft   5984844.928 2103185.6655 37.7540705871913 -122.495364076569 (37.7540705871913, -122.495364076569) 1 8 3 56 35
3855 203845 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 535 Castenada Ave 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 2ft   5992715.17465 2100010.79955 37.7458108948644 -122.467916186599 (37.7458108948644, -122.467916186599) 1 8 4 29491 40
4276 186874 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2700 Sunset Blvd 23 Median : Yard Tree DPW 1     13 Width 0ft   5985204.8462 2096382.2812 37.7354114037883 -122.493618136413 (37.7354114037883, -122.493618136413) 1 8 3 29491 35
4509 262192 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1799x 12th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992411 2103494 37.7553572944486 -122.469221443954 (37.7553572944486, -122.469221443954) 1 8 4 56 12
4800 203692 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 Judah St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5994219.3315 2106013.86798 37.762380528552 -122.46315056576 (37.762380528552, -122.46315056576) 1 5 11 56 12
4842 204009 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1283 Portola Dr 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5993898.99812 2097834.64802 37.7399040199511 -122.463664812507 (37.7399040199511, -122.463664812507) 1 8 4 59 40
4872 262191 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1799x 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992411 2103494 37.7553572944486 -122.469221443954 (37.7553572944486, -122.469221443954) 1 8 4 56 12
5033 186921 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2700 Sunset Blvd 70 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5985168.1725 2096748.5598 37.7364149616327 -122.493771912003 (37.7364149616327, -122.493771912003) 1 8 3 29491 35
5521 203236 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1 Sotelo Ave 3 Sidewalk: Curb side : Yard Tree Private 2     22 Width 3ft   5994079.6101 2100830.73723 37.7481409330618 -122.463257685817 (37.7481409330618, -122.463257685817) 1 8 4 29491 40
6317 204000 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1570 07th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5994021.37267 2104949.86003 37.7594476334284 -122.463757995738 (37.7594476334284, -122.463757995738) 1 5 4 56 12
7763 204002 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1301 Portola Dr 3 Sidewalk: Curb side : Yard Tree Private 2   02/10/2020 12:00:00 AM 3 Width 3ft   5993726.75775 2097804.5817 37.7398115390838 -122.464258160896 (37.7398115390838, -122.464258160896) 1 8 4 59 40
8592 186947 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2800 Sunset Blvd 21 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985208.6903 2095991.5414 37.7343387611716 -122.493576064205 (37.7343387611716, -122.493576064205) 1 8 3 29491 35
8880 218201 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 950 Ulloa St 2 Sidewalk: Curb side : Yard Tree Private 2     14 Width 2ft   5993067.47845 2098384.45783 37.7413657105616 -122.466579789523 (37.7413657105616, -122.466579789523) 1 8 4 59 40
9246 254278 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 80X Junipero Serra Blvd 2 Median : Yard Tree Private 2       3x3   5991405 2095520 37.733404559811 -122.472119261767 (37.733404559811, -122.472119261767) 1 8 4 64 40
9702 254280 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 80X Junipero Serra Blvd 4 Median : Yard Tree Private 2       3x3   5991405 2095520 37.733404559811 -122.472119261767 (37.733404559811, -122.472119261767) 1 8 4 64 40
9745 175056 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 0 Juan Bautista Cir 3 Sidewalk: Curb side : Yard Tree Private 2     16 Width 6ft   5989706.76868 2089771.19579 37.7175213699925 -122.477570413242 (37.7175213699925, -122.477570413242) 1 8 4 64 14
9883 262003 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1503X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1       10   5984810 2104956 37.7589293895364 -122.495615433308 (37.7589293895364, -122.495615433308) 1 8 3 56 35
10864 203957 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 191 Taraval St 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5992667.73438 2099093.54036 37.743289595145 -122.468013518407 (37.743289595145, -122.468013518407) 1 8 4 29491 40
11242 203747 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 265 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5992322.04503 2097512.5452 37.7389286143523 -122.469093773255 (37.7389286143523, -122.469093773255) 1 8 4 59 40
11322 203935 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 30 Lomita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5991414.01915 2104819.13724 37.7589381117154 -122.472765887756 (37.7589381117154, -122.472765887756) 1 8 4 56 12
11389 203909 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1596 09th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   5993407.09821 2104662.05397 37.7586219766534 -122.465861529796 (37.7586219766534, -122.465861529796) 1 8 4 56 12
11390 186929 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2800 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5985223.4885 2095932.3487 37.7341770994248 -122.493520542824 (37.7341770994248, -122.493520542824) 1 8 3 29491 35
11391 260515 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 487 Eucalyptus Dr 1 Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 784711 5989595 2094714 37.7310865793073 -122.478317956131 (37.7310865793073, -122.478317956131) 1 8 4 64 14
12035 182056 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1338 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5987434.16 2106158.3393 37.7623840025198 -122.486628260583 (37.7623840025198, -122.486628260583) 1 8 3 56 35
12631 184116 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2345 Lawton St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5986935.2197 2104347.7839 37.7573836158365 -122.488220831337 (37.7573836158365, -122.488220831337) 1 8 3 56 35
12663 203708 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2492 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5991744.37549 2098480.08331 37.7415518324448 -122.471161539499 (37.7415518324448, -122.471161539499) 1 8 4 29491 40
12706 203693 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 Judah St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5994214.99035 2106013.29581 37.7623787074434 -122.463165538553 (37.7623787074434, -122.463165538553) 1 5 11 56 12
12860 203770 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1601 Portola Dr 2 Sidewalk: Curb side : Yard Tree Private 2     21 Width 5ft   5992012.04264 2096406.00998 37.7358724311684 -122.470085057304 (37.7358724311684, -122.470085057304) 1 8 4 59 40
13033 20683 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1505X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 10   5984801 2104643 37.7580694516324 -122.495623472482 (37.7580694516324, -122.495623472482) 1 8 3 56 35
14017 181325 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1229 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5987669.8168 2106894.9032 37.7644201395656 -122.485867286736 (37.7644201395656, -122.485867286736) 1 8 3 56 35
14554 205138 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1998 08th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     21 Width 3ft   5993815.52591 2101897.64726 37.7510551789624 -122.464248318725 (37.7510551789624, -122.464248318725) 1 8 4 29491 12
14773 203979 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1550 Portola Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5992248.70603 2096739.03136 37.7368005027325 -122.469291057549 (37.7368005027325, -122.469291057549) 1 8 4 59 40
15095 182345 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1522 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x8   5988118 2104920 37.7590237008279 -122.484172322146 (37.7590237008279, -122.484172322146) 1 8 3 56 35
15115 203925 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1799X 12th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     20 Width 3ft   5992470.02129 2103495.15392 37.755363873152 -122.469017416317 (37.755363873152, -122.469017416317) 1 8 4 56 12
16567 175055 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 0 Juan Bautista Cir 2 Sidewalk: Curb side : Yard Tree Private 2     16 Width 6ft   5989631.25858 2089762.2141 37.7174923263774 -122.477830757993 (37.7174923263774, -122.477830757993) 1 8 4 64 14
17306 203240 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 175 Vasquez Ave 2 Sidewalk: Curb side : Yard Tree Private 2     27 Width 3ft   5994884.38137 2099419.15994 37.7443114255431 -122.460372570763 (37.7443114255431, -122.460372570763) 1 8 4 59 40
17330 203948 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2401 16th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5991355.40682 2098983.74406 37.7429122494956 -122.472543158936 (37.7429122494956, -122.472543158936) 1 8 4 29491 40
17547 203960 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 317 Dorantes Ave 2 Sidewalk: Curb side : Yard Tree Private 2     30 Width 3ft   5993052.38285 2099661.64456 37.7448716708006 -122.466724802526 (37.7448716708006, -122.466724802526) 1 8 4 29491 40
17802 203691 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5994228.79771 2106016.63225 37.7623886638276 -122.463118026482 (37.7623886638276, -122.463118026482) 1 5 11 56 12
18026 175051 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1100 Junipero Serra Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     16 Width 3ft   5991233.90488 2088989.0818 37.7154623775575 -122.472234874046 (37.7154623775575, -122.472234874046) 1 8 4 64 14
18623 99145 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 302X Pacheco St 29 Median : Cutout Tree Private 2     9     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
18624 184510 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1975 42nd Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5983188.0663 2101709.4842 37.7499202536606 -122.500984645445 (37.7499202536606, -122.500984645445) 1 8 3 29491 35
19486 186864 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2700 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985200.7204 2096355.2343 37.7353368988439 -122.493630408308 (37.7353368988439, -122.493630408308) 1 8 3 29491 35
20221 187212 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2401 Sunset Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     25 Width 0ft   5984988.5085 2098705.0047 37.741776320928 -122.494537260078 (37.741776320928, -122.494537260078) 1 8 3 29491 35
20332 203978 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1562 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5992223.47194 2096717.87979 37.7367409676228 -122.469376762928 (37.7367409676228, -122.469376762928) 1 8 4 59 40
20381 186821 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200 Sunset Blvd 105 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984828.6477 2106722.4547 37.7637806720109 -122.495681237536 (37.7637806720109, -122.495681237536) 1 8 3 56 35
20826 203829 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 200x Terrace Dr 41 Median : Yard Tree DPW 1     18     5993865.8273 2096513.9581 37.7362758229773 -122.463683673072 (37.7362758229773, -122.463683673072) 1 8 4 59 40
20901 181396 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1500 Sunset Blvd 29 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984914.2437 2104590.3992 37.757931655251 -122.495227954147 (37.757931655251, -122.495227954147) 1 8 3 56 35
21150 187379 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2200 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5985060.734 2100052.5124 37.7454804393236 -122.494386838151 (37.7454804393236, -122.494386838151) 1 8 3 29491 35
21220 182980 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2500 20th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     23 Width 0ft   5990206.2576 2097911.7147 37.739902151809 -122.47643826121 (37.739902151809, -122.47643826121) 1 8 3 29491 35
21247 203924 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 828 Quintara St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5990829.70497 2101134.74222 37.7487878900543 -122.474517815648 (37.7487878900543, -122.474517815648) 1 8 4 29491 12
21261 55934 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2665 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/1973 12:00:00 AM 9   Permit Number 11998 5986719.3111 2097252.7279 37.7378899014651 -122.488446087215 (37.7378899014651, -122.488446087215) 1 8 3 29491 35
21920 184111 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1604 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5986875.3953 2104311.06 37.7572792915924 -122.488425026161 (37.7572792915924, -122.488425026161) 1 8 3 56 35
22035 185597 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2200 Quintara St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   5986575.4427 2100993.2848 37.748152076203 -122.489218440489 (37.748152076203, -122.489218440489) 1 8 3 29491 35
22316 185668 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2101 Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 0ft   5984929.7381 2100287.489 37.7461179540332 -122.494857116456 (37.7461179540332, -122.494857116456) 1 8 3 29491 35
22338 203950 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600 17th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5991063.90943 2098465.7038 37.7414729672935 -122.473513287329 (37.7414729672935, -122.473513287329) 1 8 4 29491 40
22388 98555 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2360 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5991737.8 2099355.8 37.7439559460975 -122.471248063337 (37.7439559460975, -122.471248063337) 1 8 4 29491 40
22707 184072 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600 Sunset Blvd 73 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984928.5463 2103997.684 37.7563050611127 -122.495134783659 (37.7563050611127, -122.495134783659) 1 8 3 56 35
23008 203710 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1350 Ulloa St 4 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   5991762.04169 2098443.18108 37.7414515301631 -122.471097768574 (37.7414515301631, -122.471097768574) 1 8 4 29491 40
23078 203707 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2198 17th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   5991036.98423 2100539.076 37.7471643529643 -122.473757603451 (37.7471643529643, -122.473757603451) 1 8 4 29491 40
23787 50103 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1530 Portola Dr 2 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

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