trees
3,965 rows where qSpecies_id = 70 sorted by Longitude
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 | |||||||||||||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );