3,965 rows where qSpecies_id = 70 sorted by Longitude

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)
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                      
182690 201544 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 601 Innes Ave 13 Sidewalk: Property side : Yard Tree Private 2     3     6020625.62552 2093377.92947 37.7291705267859 -122.370946000964 (37.7291705267859, -122.370946000964) 10 3 8 58 1
118510 201561 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 200 Jerrold Ave 12 Sidewalk: Property side : Yard Tree Private 2     24 Width 8ft   6019745.83299 2093765.29662 37.7301858218198 -122.374014373583 (37.7301858218198, -122.374014373583) 10 3 8 58 1
121059 187765 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 91 Kiska Rd 7 Sidewalk: Property side : Yard Tree Private 2     26     6019429.17387 2093568.53818 37.7296281423191 -122.375095487273 (37.7296281423191, -122.375095487273) 10 3 8 58 1
144674 187764 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 91 Kiska Rd 6 Sidewalk: Property side : Yard Tree Private 2     18     6019412.69298 2093581.83976 37.729663759061 -122.37515338563 (37.729663759061, -122.37515338563) 10 3 8 58 1
125378 187762 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 135 Reardon Rd 1 Sidewalk: Property side : Yard Tree Private 2     19     6018971.39793 2093438.50754 37.7292459043613 -122.376669068821 (37.7292459043613, -122.376669068821) 10 3 8 58 1
44642 187763 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 135 Reardon Rd 2 Sidewalk: Property side : Yard Tree Private 2     25     6018954.68397 2093453.67115 37.7292866202724 -122.376727902495 (37.7292866202724, -122.376727902495) 10 3 8 58 1
49681 116977 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 100x CARGO WAY 117 Front Yard : Yard Tree PUC 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
158492 3686 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 100X Cargo Way 1 Median : Cutout Tree Port 6     12 8   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
97390 11544 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 101X Jennings St 34 Sidewalk: Curb side : Cutout Tree DPW 1   12/23/1997 12:00:00 AM 3 3X3   6018840.43674 2097157.24182 37.7394496095988 -122.37737975539 (37.7394496095988, -122.37737975539) 10 3 8 58 1
158386 188642 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2x Cargo Way 3 Median : Yard Tree DPW 1     9     6018846.51114 2097536.89048 37.7404923843103 -122.377385089264 (37.7404923843103, -122.377385089264) 10 3 8 58 1
172225 201372 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 57 Hare St 1 Sidewalk: Property side : Yard Tree Private 2     31     6018490.42115 2095382.8253 37.7345581232662 -122.378466804612 (37.7345581232662, -122.378466804612) 10 3 8 58 1
100281 188677 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1001 Evans Ave 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 5ft   6018476.48235 2096364.95743 37.7372540964924 -122.378583166995 (37.7372540964924, -122.378583166995) 10 3 8 58 1
62455 187749 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1020 Griffith St 1 Sidewalk: Property side : Yard Tree Private 2     38     6018386.68976 2093315.1959 37.7288750976933 -122.378681918831 (37.7288750976933, -122.378681918831) 10 3 8 58 1
142676 188643 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 150x Cargo Way 2 Median : Yard Tree DPW 1     17     6018388.81738 2097879.37789 37.7414075614118 -122.378991412446 (37.7414075614118, -122.378991412446) 10 3 8 58 1
45747 201375 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Fairfax Ave 1 Sidewalk: Property side : Yard Tree Private 2     26     6018327.36542 2095666.89439 37.7353291318294 -122.379050271262 (37.7353291318294, -122.379050271262) 10 3 8 58 1
135111 201374 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Hare St 2 Sidewalk: Property side : Yard Tree Private 2     26     6018319.37911 2095383.77849 37.7345513108793 -122.37905822666 (37.7345513108793, -122.37905822666) 10 3 8 58 1
129789 6435 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1100X Evans Ave 17 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6018339.9760743 2096552.8140758 37.7377623877793 -122.379068180173 (37.7377623877793, -122.379068180173) 10 3 8 58 1
159877 6443 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1100X Evans Ave 25 Sidewalk: Curb side : Cutout Tree DPW 1   11/29/1990 12:00:00 AM 12 3x3   6018339.9760743 2096552.8140758 37.7377623877793 -122.379068180173 (37.7377623877793, -122.379068180173) 10 3 8 58 1
187020 6432 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1100X Evans Ave 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6018339.9760743 2096552.8140758 37.7377623877793 -122.379068180173 (37.7377623877793, -122.379068180173) 10 3 8 58 1
58804 6420 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1100X Evans Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/29/1990 12:00:00 AM 12 3x3   6018302.7051 2096585.42337 37.7378498712671 -122.379199309611 (37.7378498712671, -122.379199309611) 10 3 8 58 1
48525 188644 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 150x Cargo Way 4 Median : Yard Tree DPW 1     27     6018318.49597 2097930.97465 37.7415453582258 -122.379238145042 (37.7415453582258, -122.379238145042) 10 3 8 58 1
183663 201376 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Fairfax Ave 2 Sidewalk: Property side : Yard Tree Private 2     13 Width 9ft   6018269.69343 2095669.23069 37.7353323666994 -122.379249829039 (37.7353323666994, -122.379249829039) 10 3 8 58 1
160468 188678 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Middle Point Rd 1 Sidewalk: Curb side : Yard Tree Private 2     9     6018276.23172 2096494.25688 37.7375980862711 -122.37928451137 (37.7375980862711, -122.37928451137) 10 3 8 58 1
181395 187778 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 230 Middle Point Rd 1 Side Yard : Yard Tree Private 2     2 Width 6ft   6018276.18855 2096495.79876 37.7376023175876 -122.379284767699 (37.7376023175876, -122.379284767699) 10 3 8 58 1
156173 187779 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 230 Middle Point Rd 2 Side Yard : Yard Tree Private 2     5 Width 6ft   6018271.33931 2096490.0449 37.7375862512101 -122.379301134458 (37.7375862512101, -122.379301134458) 10 3 8 58 1
51426 188679 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Middle Point Rd 2 Sidewalk: Curb side : Yard Tree Private 2     8     6018264.75043 2096477.95592 37.7375526939091 -122.379323076118 (37.7375526939091, -122.379323076118) 10 3 8 58 1
134936 187750 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1000 Oakdale Ave 2 Sidewalk: Property side : Yard Tree Private 2     6     6018189.80767 2093163.42935 37.7284475204377 -122.379352023493 (37.7284475204377, -122.379352023493) 10 3 8 58 1
57249 187780 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 230 Middle Point Rd 3 Side Yard : Yard Tree Private 2     4 Width 6ft   6018250.04699 2096453.90064 37.7374858320104 -122.379372242948 (37.7374858320104, -122.379372242948) 10 3 8 58 1
49610 6423 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1100X Evans Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     10 3x3   6018250.03314 2096623.41897 37.7379512950012 -122.379384062749 (37.7379512950012, -122.379384062749) 10 3 8 58 1
109829 188680 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Middle Point Rd 3 Sidewalk: Curb side : Yard Tree Private 2     8     6018245.47476 2096448.12124 37.7374697107694 -122.379387650125 (37.7374697107694, -122.379387650125) 10 3 8 58 1
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
27223 188681 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Middle Point Rd 5 Sidewalk: Curb side : Yard Tree Private 2     20     6018210.72448 2096306.49238 37.7370789094531 -122.379497963675 (37.7370789094531, -122.379497963675) 10 3 8 58 1
159130 187751 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1000 Oakdale Ave 3 Sidewalk: Property side : Yard Tree Private 2     29     6018129.37329 2093209.50833 37.7285707113551 -122.379564150189 (37.7285707113551, -122.379564150189) 10 3 8 58 1
113147 187753 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1000 Oakdale Ave 5 Sidewalk: Property side : Yard Tree Private 2     8     6018088.91826 2093246.2132 37.7286692644523 -122.379706556009 (37.7286692644523, -122.379706556009) 10 3 8 58 1
193027 187752 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1000 Oakdale Ave 4 Sidewalk: Property side : Yard Tree Private 2     17     6018083.61672 2093238.62842 37.7286481456935 -122.379724357202 (37.7286481456935, -122.379724357202) 10 3 8 58 1
164322 6428 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1100X Evans Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1   11/29/1990 12:00:00 AM 6 3x3   6018145.74781 2096700.42192 37.7381569780515 -122.379749980697 (37.7381569780515, -122.379749980697) 10 3 8 58 1
174265 6429 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1100X Evans Ave 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6018128.86285 2096712.12629 37.7381881845457 -122.379809174075 (37.7381881845457, -122.379809174075) 10 3 8 58 1
180967 187754 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1000 Oakdale Ave 11 Sidewalk: Property side : Yard Tree Private 2     7     6018045.40924 2093280.41562 37.728760777668 -122.379859346358 (37.728760777668, -122.379859346358) 10 3 8 58 1
127702 188645 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 150x Cargo Way 8 Median : Yard Tree DPW 1     25     6018140.58939 2098064.90862 37.7419033019107 -122.379862595596 (37.7419033019107, -122.379862595596) 10 3 8 58 1
82358 187755 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1000 Oakdale Ave 12 Sidewalk: Property side : Yard Tree Private 2     9     6018042.26935 2093273.64193 37.7287420052256 -122.379869730822 (37.7287420052256, -122.379869730822) 10 3 8 58 1
71865 187756 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1000 Oakdale Ave 13 Sidewalk: Property side : Yard Tree Private 2     15     6018040.44211 2093268.12413 37.7287267536225 -122.379875664545 (37.7287267536225, -122.379875664545) 10 3 8 58 1
146547 6431 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1100X Evans Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6018097.17297 2096735.752 37.7382513079456 -122.379920384224 (37.7382513079456, -122.379920384224) 10 3 8 58 1
64568 188646 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 150x Cargo Way 9 Median : Yard Tree DPW 1     5     6018092.67534 2098102.14022 37.7420028892302 -122.380030855133 (37.7420028892302, -122.380030855133) 10 3 8 58 1
171345 188682 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 Evans Ave 1 : Tree Private 2     12 Width 3ft   6018053.21017 2096769.99546 37.7383429083925 -122.380074766353 (37.7383429083925, -122.380074766353) 10 3 8 58 1
191347 188647 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 150x Cargo Way 10 Median : Yard Tree DPW 1     17     6018073.11672 2098111.74487 37.7420281826481 -122.38009915058 (37.7420281826481, -122.38009915058) 10 3 8 58 1
63455 188683 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 Evans Ave 3 : Tree Private 2     13 Width 3ft   6018037.89274 2096788.1105 37.7383918036295 -122.380128985564 (37.7383918036295, -122.380128985564) 10 3 8 58 1
114712 188648 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 150x Cargo Way 11 Median : Yard Tree DPW 1     17     6018027.57667 2098147.26703 37.7421232068329 -122.380259083311 (37.7421232068329, -122.380259083311) 10 3 8 58 1
177180 188684 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 Evans Ave 6 : Tree Private 2     18 Width 4ft   6017995.68606 2096837.17504 37.7385241964319 -122.380278326092 (37.7385241964319, -122.380278326092) 10 3 8 58 1
61906 3693 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 300X Cargo Way 2 Median : Cutout Tree DPW 1     12 8   6017817.275253 2098336.256691 37.7426305289053 -122.380999383309 (37.7426305289053, -122.380999383309) 10 3 8 58 1
114360 3692 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 300X Cargo Way 1 Median : Cutout Tree DPW 1     18 8   6017817.275253 2098336.256691 37.7426305289053 -122.380999383309 (37.7426305289053, -122.380999383309) 10 3 8 58 1
40581 6463 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200X Evans Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017761.74901 2097023.16401 37.7390219747502 -122.381100103845 (37.7390219747502, -122.381100103845) 10 3 8 58 1
186445 188686 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300 Evans Ave 20 : Tree DPW 1     12 Width 3ft   6017760.57019 2097020.59109 37.7390148449557 -122.381104000867 (37.7390148449557, -122.381104000867) 10 3 8 58 1
76427 188664 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 501 Amador St 11 Front Yard : Yard Tree Private 2     10 Width 1ft   6017799.22634 2099547.38372 37.745955042685 -122.381145981202 (37.745955042685, -122.381145981202) 10 3 8 58 1
51410 187757 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1040 Palou Ave 8 Sidewalk: Property side : Yard Tree Private 2     23     6017577.45499 2093289.42876 37.7287597011768 -122.38147773753 (37.7287597011768, -122.38147773753) 10 3 8 58 1
176169 187758 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1040 Palou Ave 9 Sidewalk: Property side : Yard Tree Private 2     5     6017560.01516 2093300.23406 37.7287884075452 -122.381538779893 (37.7287884075452, -122.381538779893) 10 3 8 58 1
51248 188655 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 300x Cargo Way 5 Median : Yard Tree DPW 1     22     6017659.9469 2098420.67777 37.7428536469791 -122.381549254301 (37.7428536469791, -122.381549254301) 10 3 8 58 1
6378 6740 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300X Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1     26 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
57690 6714 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200X Fairfax Ave 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
88066 6718 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200X Fairfax Ave 15 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
118595 6717 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200X Fairfax Ave 14 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
125956 6706 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200X Fairfax Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     20 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
175642 6729 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200X Fairfax Ave 26 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
182961 6739 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300X Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
190591 6745 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1300X Fairfax Ave 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
180202 187759 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1040 Palou Ave 10 Sidewalk: Property side : Yard Tree Private 2     32     6017547.84189 2093311.88395 37.7288197237472 -122.381581673978 (37.7288197237472, -122.381581673978) 10 3 8 58 1
153812 188663 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 501 Amador St 10 Front Yard : Yard Tree Private 2     10 Width 1ft   6017654.78408 2099538.16845 37.7459217650856 -122.381644807281 (37.7459217650856, -122.381644807281) 10 3 8 58 1
103385 187760 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1040 Palou Ave 11 Sidewalk: Property side : Yard Tree Private 2     17     6017527.04391 2093321.80664 37.7288458211654 -122.381654264546 (37.7288458211654, -122.381654264546) 10 3 8 58 1
54987 187761 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1040 Palou Ave 12 Sidewalk: Property side : Yard Tree Private 2     24     6017511.07328 2093334.48306 37.7288797462969 -122.381710357951 (37.7288797462969, -122.381710357951) 10 3 8 58 1
15187 6707 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200X Fairfax Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6017570.5024 2096779.609 37.7383426628708 -122.381744418894 (37.7383426628708, -122.381744418894) 10 3 8 58 1
165169 6708 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200X Fairfax Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     36 3x3   6017556.67213 2096791.48157 37.7383744988848 -122.381793063219 (37.7383744988848, -122.381793063219) 10 3 8 58 1
54401 28708 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200X Evans Ave 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017551.81801 2097178.22601 37.7394361536971 -122.38183673875 (37.7394361536971, -122.38183673875) 10 3 8 58 1
128258 188671 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200 Fairfax Ave 6 : Tree Private 2     25 Width 4ft   6017541.51277 2096801.60961 37.7384014713541 -122.381846181672 (37.7384014713541, -122.381846181672) 10 3 8 58 1
46007 6753 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1215 Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6017521.0990665 2096743.3718322 37.7382404347673 -122.381912713319 (37.7382404347673, -122.381912713319) 10 3 8 58 1

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