trees
3,965 rows where qSpecies_id = 70 sorted by XCoord descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 71561 | 6553 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1275 Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x8 | 6017462.04156 | 2097126.15561 | 37.7392882208803 | -122.382143528109 | (37.7392882208803, -122.382143528109) | 10 | 3 | 8 | 58 | 1 | |||
| 54548 | 28654 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1275 Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2004 12:00:00 AM | 3 | 6x3 | 6017442.42343 | 2097139.52518 | 37.739323847514 | -122.38221228939 | (37.739323847514, -122.38221228939) | 10 | 3 | 8 | 58 | 1 | ||
| 42718 | 6479 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017436.11701 | 2097265.30001 | 37.7396688516514 | -122.382242842132 | (37.7396688516514, -122.382242842132) | 10 | 3 | 8 | 58 | 1 | |||
| 156185 | 188654 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300x Cargo Way | 12 | Median : Yard | Tree | DPW 1 | 1 | 6017424.39169 | 2098619.4012 | 37.7433862929421 | -122.382377569482 | (37.7433862929421, -122.382377569482) | 10 | 3 | 8 | 58 | 1 | ||||
| 152895 | 188672 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1224 Fairfax Ave | 3 | : | Tree | Private 2 | 14 | Width 4ft | 6017423.58872 | 2096888.36438 | 37.7386331699882 | -122.382259943553 | (37.7386331699882, -122.382259943553) | 10 | 3 | 8 | 58 | 1 | |||
| 110537 | 188653 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300x Cargo Way | 13 | Median : Yard | Tree | DPW 1 | 1 | 6017421.68385 | 2098629.86939 | 37.7434148869 | -122.382387660761 | (37.7434148869, -122.382387660761) | 10 | 3 | 8 | 58 | 1 | ||||
| 114994 | 188652 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300x Cargo Way | 14 | Median : Yard | Tree | DPW 1 | 19 | 6017392.84765 | 2098647.15958 | 37.7434607693943 | -122.382488572792 | (37.7434607693943, -122.382488572792) | 10 | 3 | 8 | 58 | 1 | ||||
| 192020 | 6747 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1215 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6017390.63175 | 2096829.56918 | 37.7384699097667 | -122.382369804725 | (37.7384699097667, -122.382369804725) | 10 | 3 | 8 | 58 | 1 | |||
| 32564 | 187777 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1215 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 4ft | 6017388.24402 | 2096830.64368 | 37.7384727282386 | -122.382378135159 | (37.7384727282386, -122.382378135159) | 10 | 3 | 8 | 58 | 1 | |||
| 121884 | 188651 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300x Cargo Way | 15 | Median : Yard | Tree | DPW 1 | 6 | 6017373.96429 | 2098663.52344 | 37.7435046581055 | -122.382555005724 | (37.7435046581055, -122.382555005724) | 10 | 3 | 8 | 58 | 1 | ||||
| 140188 | 188673 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1224 Fairfax Ave | 6 | : | Tree | Private 2 | 17 | Width 3ft | 6017369.13061 | 2096930.52417 | 37.7387459242774 | -122.382451168193 | (37.7387459242774, -122.382451168193) | 10 | 3 | 8 | 58 | 1 | |||
| 176568 | 188674 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1270 Fairfax Ave | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6017349.18345 | 2096943.80807 | 37.7387812973263 | -122.382521060803 | (37.7387812973263, -122.382521060803) | 10 | 3 | 8 | 58 | 1 | |||
| 52580 | 187748 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1322 Hudson Ave | 49 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017296.56701 | 2095239.40453 | 37.734098438398 | -122.382584422552 | (37.734098438398, -122.382584422552) | 10 | 3 | 8 | 58 | 1 | |||
| 82195 | 188689 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Evans Ave | 42 | : | Tree | Private 2 | 11 | Width 3ft | 6017291.85289 | 2097369.22431 | 37.7399462377322 | -122.382748880668 | (37.7399462377322, -122.382748880668) | 10 | 3 | 8 | 58 | 1 | |||
| 155744 | 6486 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017283.44001 | 2097385.77201 | 37.7399912095936 | -122.382779120446 | (37.7399912095936, -122.382779120446) | 10 | 3 | 8 | 58 | 1 | |||
| 9851 | 187722 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6017248.25374 | 2094957.00254 | 37.7333203494413 | -122.382731813344 | (37.7333203494413, -122.382731813344) | 10 | 3 | 8 | 58 | 1 | |||
| 30838 | 188697 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 13 | : | Tree | DPW 1 | 15 | Width 3ft | 6017236.81305 | 2097292.98379 | 37.7397338556296 | -122.38293388291 | (37.7397338556296, -122.38293388291) | 10 | 3 | 8 | 58 | 1 | |||
| 15006 | 6568 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6017234.1596238 | 2097288.6286052 | 37.7397217505579 | -122.382942754401 | (37.7397217505579, -122.382942754401) | 10 | 3 | 8 | 58 | 1 | |||
| 188731 | 24220 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 52 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017233.65569 | 2094997.27182 | 37.7334301143948 | -122.38278508468 | (37.7334301143948, -122.38278508468) | 10 | 3 | 8 | 58 | 1 | |||
| 176691 | 187721 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6017221.17911 | 2094948.917 | 37.7332966523177 | -122.382824856279 | (37.7332966523177, -122.382824856279) | 10 | 3 | 8 | 58 | 1 | |||
| 35108 | 3688 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 2 | Median : Cutout | Tree | Port 6 | 18 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
| 35347 | 3691 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 5 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
| 35762 | 3690 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 4 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
| 104325 | 3689 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 3 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
| 179402 | 3687 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 1 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
| 153144 | 6771 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1275 Fairfax Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6017217.4089567 | 2096970.3613046 | 37.7388469269577 | -122.382978527185 | (37.7388469269577, -122.382978527185) | 10 | 3 | 8 | 58 | 1 | |||
| 38953 | 3694 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400X Cargo Way | 1 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6017199.673909 | 2098835.752969 | 37.7439679357533 | -122.383169649574 | (37.7439679357533, -122.383169649574) | 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) );