trees
3,965 rows where qSpecies_id = 70 sorted by DBH 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114469 | 141190 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1771 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9999 | Width 0ft | 6002407.0405 | 2112959.471 | 37.7819196963173 | -122.435329208056 | (37.7819196963173, -122.435329208056) | 15 | 5 | 11 | 29490 | 41 | |||
| 4388 | 12732 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1619 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5990481.52989 | 2114717.45643 | 37.7860621686584 | -122.476714011555 | (37.7860621686584, -122.476714011555) | 11 | 6 | 2 | 55 | 26 | |||
| 27996 | 5415 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 430X Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 6 | 6004853.9708326 | 2105864.857711 | 37.7625782660478 | -122.426358665446 | (37.7625782660478, -122.426358665446) | 8 | 4 | 5 | 28859 | 3 | |||
| 33120 | 12727 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X4 | 5990457.1993 | 2114785.86556 | 37.7862485896694 | -122.476803188002 | (37.7862485896694, -122.476803188002) | 11 | 6 | 1 | 55 | 33 | |||
| 40260 | 14571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 5x5 | 5999361.6418 | 2109001.7234 | 37.7708793165263 | -122.445580154944 | (37.7708793165263, -122.445580154944) | 15 | 5 | 11 | 29492 | 9 | |||
| 53368 | 5410 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X6 | 6004853.94973 | 2105972.80188 | 37.7628746538756 | -122.426366424394 | (37.7628746538756, -122.426366424394) | 8 | 4 | 5 | 28859 | 3 | |||
| 57179 | 5423 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 460X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004889.2026724 | 2105697.5669462 | 37.7621209168257 | -122.426224900449 | (37.7621209168257, -122.426224900449) | 8 | 4 | 5 | 28862 | 3 | |||
| 63885 | 14497 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 350 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5999071.4256 | 2111558.1482 | 37.7778820323449 | -122.446767989356 | (37.7778820323449, -122.446767989356) | 15 | 5 | 11 | 54 | 16 | |||
| 70175 | 13127 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6004182.8465 | 2119787.4466 | 37.8007682730329 | -122.42967287413 | (37.8007682730329, -122.42967287413) | 13 | 9 | 1 | 57 | 17 | |||
| 74776 | 5398 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 347 Dolores St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004916.74294 | 2106419.98328 | 37.7641060568743 | -122.426181082194 | (37.7641060568743, -122.426181082194) | 8 | 4 | 5 | 28859 | 19 | |||
| 76421 | 10473 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1632 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 5998321.0771 | 2108628.9487 | 37.7697963108216 | -122.449152617838 | (37.7697963108216, -122.449152617838) | 15 | 5 | 11 | 29492 | 9 | |||
| 89100 | 10367 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X4 | 6000483.5353 | 2108928.9047 | 37.7707433605012 | -122.441694282188 | (37.7707433605012, -122.441694282188) | 15 | 5 | 11 | 29492 | 9 | |||
| 97143 | 10371 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1202 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6000331.2557 | 2108908.0315 | 37.7706773703693 | -122.442219519892 | (37.7706773703693, -122.442219519892) | 15 | 5 | 11 | 29492 | 9 | |||
| 99705 | 11447 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3 | 5995514.85453 | 2115936.98374 | 37.7897013284038 | -122.459388527967 | (37.7897013284038, -122.459388527967) | 11 | 1 | 61 | 31 | ||||
| 99902 | 10298 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 545 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6003525.02911 | 2109303.72593 | 37.77194535274 | -122.431200463837 | (37.77194535274, -122.431200463837) | 15 | 9 | 11 | 29492 | 10 | |||
| 140700 | 9984 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 699X Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5999124.13341 | 2110521.95513 | 37.7750399229531 | -122.446511088309 | (37.7750399229531, -122.446511088309) | 15 | 5 | 11 | 29492 | 16 | |||
| 142742 | 14599 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1250 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5999487.9613 | 2108521.9825 | 37.769569280143 | -122.44510871908 | (37.769569280143, -122.44510871908) | 15 | 5 | 11 | 29492 | 9 | |||
| 151084 | 10296 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 533 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6003575.42628 | 2109315.11731 | 37.7719794864975 | -122.431026949543 | (37.7719794864975, -122.431026949543) | 15 | 9 | 11 | 29492 | 10 | |||
| 157624 | 5729 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1699 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005355.71793 | 2098501.99006 | 37.7423898872871 | -122.424099659768 | (37.7423898872871, -122.424099659768) | 2 | 7 | 5 | 28859 | 22 | |||
| 162752 | 5435 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 500X Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 90 | 6 | 6004896.4850005 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | 2 | 4 | 5 | 28862 | 3 | |||
| 164017 | 10501 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1738 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 5997829.7408 | 2108561.4434 | 37.7695828440479 | -122.450847260907 | (37.7695828440479, -122.450847260907) | 15 | 5 | 11 | 29492 | 9 | |||
| 185590 | 10422 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1407 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 5999387.74957 | 2108726.34207 | 37.7701246795762 | -122.445470043217 | (37.7701246795762, -122.445470043217) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 3225 | 248333 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1329 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999495.3806 | 2108202.9521 | 37.7686937265955 | -122.445060117561 | (37.7686937265955, -122.445060117561) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 9651 | 140669 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 420 STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996810.1841 | 2110348.4784 | 37.7744311612044 | -122.4545029637 | (37.7744311612044, -122.4545029637) | 15 | 5 | 2 | 29492 | 16 | |||
| 11343 | 200776 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1630 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015219 | 2096207 | 37.736640269463 | -122.389834845939 | (37.736640269463, -122.389834845939) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | ||||
| 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 | ||
| 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 | |||
| 22959 | 124866 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 12 Rico Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001683.07545 | 2121358.73098 | 37.8049407402829 | -122.438435744435 | (37.8049407402829, -122.438435744435) | 13 | 9 | 1 | 57 | 17 | |||
| 23718 | 124908 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3837 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996520.53305 | 2115587.04423 | 37.7887982593656 | -122.455883692899 | (37.7887982593656, -122.455883692899) | 11 | 6 | 1 | 54 | 31 | |||
| 24289 | 30297 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2734 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1956 12:00:00 AM | 9 | Permit Number 140 | 6003569.97515 | 2117774.33074 | 37.7952060548567 | -122.43164985595 | (37.7952060548567, -122.43164985595) | 13 | 9 | 1 | 29490 | 27 | ||
| 27962 | 110465 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1485 FAIRFAX AVE | 2 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 9 | 3x3 | 6016296 | 2097688 | 37.7407664622153 | -122.386214376382 | (37.7407664622153, -122.386214376382) | 10 | 3 | 8 | 58 | 1 | |||
| 28116 | 125029 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1460 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002224.17314 | 2121593.74459 | 37.8056167885575 | -122.436580050938 | (37.8056167885575, -122.436580050938) | 13 | 9 | 1 | 57 | 17 | |||
| 28996 | 125108 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3157 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999114.64614 | 2116271.09078 | 37.7908250128999 | -122.446957707555 | (37.7908250128999, -122.446957707555) | 13 | 6 | 1 | 29490 | 31 | |||
| 30332 | 125323 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 640 Davis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6013152.59529 | 2118825.24429 | 37.7986301120473 | -122.398566041686 | (37.7986301120473, -122.398566041686) | 3 | 1 | 10 | 28860 | 6 | |||
| 32479 | 125072 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2559 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002527.91845 | 2116093.19627 | 37.7905309723786 | -122.435135231625 | (37.7905309723786, -122.435135231625) | 13 | 9 | 1 | 29490 | 27 | |||
| 33137 | 220158 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 66 | Front Yard : Yard | Tree | Private 2 | 9 | 6004531.65878 | 2096118.78837 | 37.7357995950731 | -122.426779327416 | (37.7357995950731, -122.426779327416) | 2 | 7 | 5 | 28861 | 2 | ||||
| 33407 | 125055 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1725 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002469.3064 | 2120890.0959 | 37.8036986821095 | -122.435681360206 | (37.8036986821095, -122.435681360206) | 13 | 9 | 1 | 57 | 17 | |||
| 33936 | 186603 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 74 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984731.2077 | 2104430.2197 | 37.7574811288953 | -122.495849144448 | (37.7574811288953, -122.495849144448) | 1 | 8 | 3 | 56 | 35 | |||
| 34562 | 187770 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 600 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015810.36395 | 2097629.59128 | 37.7405791922653 | -122.387889463049 | (37.7405791922653, -122.387889463049) | 10 | 3 | 8 | 58 | 1 | |||
| 35099 | 124895 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3757 Washington St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5996835.55355 | 2115629.96293 | 37.7889341775065 | -122.454796874798 | (37.7889341775065, -122.454796874798) | 11 | 6 | 1 | 54 | 31 | |||
| 36994 | 124856 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Casa Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001727.95085 | 2121436.12662 | 37.8051558005727 | -122.438285996516 | (37.8051558005727, -122.438285996516) | 13 | 9 | 1 | 57 | 17 | |||
| 38606 | 125013 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 691 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999680.43429 | 2121532.52371 | 37.8053038127916 | -122.445378585257 | (37.8053038127916, -122.445378585257) | 13 | 9 | 1 | 57 | 17 | |||
| 38892 | 183276 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1258 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5982450.6111 | 2106538.8 | 37.7631368622084 | -122.503892396491 | (37.7631368622084, -122.503892396491) | 1 | 8 | 3 | 56 | 35 | |||
| 40352 | 124921 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 125 Maple St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 5996572.93556 | 2115696.21149 | 37.789101010747 | -122.455710282907 | (37.789101010747, -122.455710282907) | 11 | 6 | 1 | 54 | 31 | |||
| 43833 | 125183 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2401 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002040.40043 | 2117703.29752 | 37.7949241983442 | -122.4369373282 | (37.7949241983442, -122.4369373282) | 13 | 9 | 1 | 57 | 27 | |||
| 44160 | 125030 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1460 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002217.62841 | 2121592.79721 | 37.8056138153882 | -122.436602632017 | (37.8056138153882, -122.436602632017) | 13 | 9 | 1 | 57 | 17 | |||
| 45455 | 249872 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 230 Greenwich St | 8 | Back Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011683.12279 | 2120489.80597 | 37.8031186185004 | -122.403768099014 | (37.8031186185004, -122.403768099014) | 3 | 1 | 10 | 28860 | 6 | |||
| 48049 | 175052 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100 Junipero Serra Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5991243.24078 | 2088948.27208 | 37.715350864326 | -122.472199632304 | (37.715350864326, -122.472199632304) | 1 | 8 | 4 | 64 | 14 | |||
| 48848 | 124979 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3751 Broderick St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999598.09637 | 2121437.70787 | 37.805038773582 | -122.445656702412 | (37.805038773582, -122.445656702412) | 13 | 9 | 1 | 57 | 17 | |||
| 51747 | 184113 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2345 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5986890.7956 | 2104347.1916 | 37.7573793976552 | -122.4883744219 | (37.7573793976552, -122.4883744219) | 1 | 8 | 3 | 56 | 35 | |||
| 55696 | 124779 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3060 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000978.44845 | 2118912.97952 | 37.7981852516096 | -122.440698637428 | (37.7981852516096, -122.440698637428) | 13 | 9 | 1 | 57 | 17 | |||
| 57165 | 142667 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2310 MASON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008909.645 | 2121229.1326 | 37.8049932972422 | -122.413418141285 | (37.8049932972422, -122.413418141285) | 3 | 1 | 10 | 308 | 23 | |||
| 59082 | 125194 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2809 Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003493.7526 | 2118004.10332 | 37.7958326305325 | -122.431930012777 | (37.7958326305325, -122.431930012777) | 13 | 9 | 1 | 57 | 17 | |||
| 61313 | 203955 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 76 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992541.99427 | 2098633.54376 | 37.7420192991609 | -122.468414831887 | (37.7420192991609, -122.468414831887) | 1 | 8 | 4 | 29491 | 40 | |||
| 62044 | 125038 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1455 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002263.62804 | 2121555.92749 | 37.8055151948229 | -122.436440803513 | (37.8055151948229, -122.436440803513) | 13 | 9 | 1 | 57 | 17 | |||
| 62917 | 203977 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1562 Portola Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992204.37013 | 2096701.60288 | 37.7366951714316 | -122.469441621142 | (37.7366951714316, -122.469441621142) | 1 | 8 | 4 | 59 | 40 | |||
| 64813 | 184114 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2345 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5986907.3806 | 2104346.5993 | 37.7573787390227 | -122.488317021639 | (37.7573787390227, -122.488317021639) | 1 | 8 | 3 | 56 | 35 | |||
| 67925 | 175029 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 54 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010591.02139 | 2086933.10615 | 37.7109183460773 | -122.405183003288 | (37.7109183460773, -122.405183003288) | 9 | 7 | 8 | 309 | 39 | |||
| 70395 | 174981 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 635 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002909.51396 | 2089790.51984 | 37.7183317437001 | -122.431935981587 | (37.7183317437001, -122.431935981587) | 9 | 7 | 6 | 28861 | 5 | |||
| 71589 | 124778 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3060 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000979.24454 | 2118899.59733 | 37.7981485529825 | -122.440694922327 | (37.7981485529825, -122.440694922327) | 13 | 9 | 1 | 57 | 17 | |||
| 73593 | 103939 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2300 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6008915.3132 | 2121187.3941 | 37.8048790120409 | -122.413395572179 | (37.8048790120409, -122.413395572179) | 3 | 1 | 10 | 308 | 23 | ||||
| 73763 | 125197 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2105 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003801.82703 | 2115762.87441 | 37.7896962477432 | -122.43070400478 | (37.7896962477432, -122.43070400478) | 13 | 9 | 1 | 29490 | 27 | |||
| 74212 | 93121 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151X Palm Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 5995892.67419 | 2113127.59534 | 37.7820092173573 | -122.457877934554 | (37.7820092173573, -122.457877934554) | 11 | 6 | 1 | 54 | 31 | ||
| 74551 | 125294 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 350 Green St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 2ft | 6011239.45333 | 2119379.16325 | 37.800044269893 | -122.405225180605 | (37.800044269893, -122.405225180605) | 3 | 1 | 10 | 308 | 23 | |||
| 75871 | 125324 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 640 Davis St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6013147.44886 | 2118845.30288 | 37.798684901431 | -122.398585258406 | (37.798684901431, -122.398585258406) | 3 | 1 | 10 | 28860 | 6 | |||
| 78115 | 124877 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3638 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997346.29339 | 2115748.84498 | 37.7892898791742 | -122.453038378217 | (37.7892898791742, -122.453038378217) | 11 | 6 | 1 | 54 | 31 | |||
| 81246 | 188635 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Helena St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6010991.60027 | 2096196.82144 | 37.736376982304 | -122.404450150255 | (37.736376982304, -122.404450150255) | 10 | 3 | 8 | 58 | 1 | ||||
| 81290 | 184115 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2345 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5986923.9656 | 2104348.9686 | 37.7573862121067 | -122.488259839014 | (37.7573862121067, -122.488259839014) | 1 | 8 | 3 | 56 | 35 | |||
| 81570 | 220168 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 32 | Front Yard : Yard | Tree | Private 2 | 9 | 6004945.76603 | 2096533.5746 | 37.7369619094711 | -122.425377103585 | (37.7369619094711, -122.425377103585) | 2 | 7 | 5 | 28859 | 2 | ||||
| 81982 | 125107 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3157 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999100.48549 | 2116268.51853 | 37.7908171411592 | -122.447006517363 | (37.7908171411592, -122.447006517363) | 13 | 6 | 1 | 29490 | 31 | |||
| 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 | ||||
| 83084 | 203918 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1337 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995159.43127 | 2106493.25781 | 37.7637509199981 | -122.45993386078 | (37.7637509199981, -122.45993386078) | 15 | 5 | 11 | 56 | 12 | |||
| 83981 | 220193 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 65 | Front Yard : Yard | Tree | Private 2 | 9 | Width 5ft | 6003549.85445 | 2095682.63787 | 37.7345464653385 | -122.430142703749 | (37.7345464653385, -122.430142703749) | 2 | 7 | 5 | 63 | 7 | |||
| 84849 | 121892 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 24 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990536.62201 | 2114915.49652 | 37.7866091267103 | -122.476537882487 | (37.7866091267103, -122.476537882487) | 11 | 6 | 1 | 54 | 33 | |||
| 87240 | 205126 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1255 Portola Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994342.21111 | 2097874.14592 | 37.7400380000418 | -122.46213524197 | (37.7400380000418, -122.46213524197) | 1 | 8 | 4 | 59 | 40 | |||
| 87539 | 181918 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2050 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5986786.8437 | 2098961.33 | 37.7425852097978 | -122.488338126362 | (37.7425852097978, -122.488338126362) | 1 | 8 | 3 | 29491 | 35 | |||
| 90347 | 143074 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 586 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010107.9769 | 2120266.5495 | 37.8024174920752 | -122.409203192611 | (37.8024174920752, -122.409203192611) | 3 | 1 | 10 | 308 | 23 | |||
| 91453 | 123513 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2736 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994846.89228 | 2110250.14134 | 37.7740483583966 | -122.461287183892 | (37.7740483583966, -122.461287183892) | 11 | 6 | 2 | 54 | 11 | |||
| 92338 | 125292 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 350 Green St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 2ft | 6011272.94246 | 2119383.82344 | 37.8000589378412 | -122.405109623112 | (37.8000589378412, -122.405109623112) | 3 | 1 | 10 | 308 | 23 | |||
| 92507 | 220134 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Duncan St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006146.14259 | 2099977.33061 | 37.7464854349651 | -122.421471358739 | (37.7464854349651, -122.421471358739) | 2 | 7 | 7 | 28859 | 2 | |||
| 93778 | 124863 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Rico Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001725.02336 | 2121364.05209 | 37.8049577365759 | -122.438290960774 | (37.8049577365759, -122.438290960774) | 13 | 9 | 1 | 57 | 17 | |||
| 96700 | 68331 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2338 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32146 | 5991366.81812 | 2112033.7901 | 37.7787448726356 | -122.473455364804 | (37.7787448726356, -122.473455364804) | 11 | 6 | 2 | 54 | 26 | ||
| 97413 | 184861 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984691.2095 | 2106834.308 | 37.7640797402699 | -122.496164839998 | (37.7640797402699, -122.496164839998) | 1 | 8 | 3 | 56 | 35 | |||
| 98724 | 221383 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 709 Duboce Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6002125.30194 | 2108240.77443 | 37.768947330488 | -122.435966144022 | (37.768947330488, -122.435966144022) | 15 | 5 | 5 | 29492 | 3 | |||
| 101389 | 174994 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 86 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000642.03466 | 2088027.29642 | 37.7133615216919 | -122.439647347957 | (37.7133615216919, -122.439647347957) | 9 | 7 | 6 | 28861 | 5 | |||
| 102493 | 125321 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 640 Davis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6013166.77909 | 2118747.41812 | 37.7984172101453 | -122.398511496916 | (37.7984172101453, -122.398511496916) | 3 | 1 | 10 | 28860 | 6 | |||
| 112372 | 175000 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 168 Rolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6000913.68292 | 2088416.04072 | 37.7144443845714 | -122.438736278079 | (37.7144443845714, -122.438736278079) | 9 | 7 | 6 | 28861 | 5 | |||
| 117984 | 184874 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984695.3865 | 2106820.2584 | 37.7640414086876 | -122.496149356564 | (37.7640414086876, -122.496149356564) | 1 | 8 | 3 | 56 | 35 | |||
| 118024 | 120026 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5250 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5987096.14835 | 2109840.54395 | 37.7724746032715 | -122.488067882219 | (37.7724746032715, -122.488067882219) | 11 | 6 | 2 | 55 | 26 | |||
| 119209 | 186957 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2800 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5985219.2845 | 2096104.714 | 37.734650122781 | -122.493547773215 | (37.734650122781, -122.493547773215) | 1 | 8 | 3 | 29491 | 35 | |||
| 119352 | 200611 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 51 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6016421.2138 | 2095153.2552 | 37.7338134937512 | -122.385604818769 | (37.7338134937512, -122.385604818769) | 10 | 3 | 8 | 58 | 1 | |||
| 121541 | 204008 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1283 Portola Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5993871.95865 | 2097835.56987 | 37.7399049930254 | -122.463758369879 | (37.7399049930254, -122.463758369879) | 1 | 8 | 4 | 59 | 40 | |||
| 123237 | 184879 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 Sunset Blvd | 68 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984636.1502 | 2106802.0319 | 37.7639878939354 | -122.496352889461 | (37.7639878939354, -122.496352889461) | 1 | 8 | 3 | 56 | 35 | |||
| 124652 | 124850 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 127 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001799.83316 | 2121605.38559 | 37.8056246288293 | -122.438049371377 | (37.8056246288293, -122.438049371377) | 13 | 9 | 1 | 57 | 17 | |||
| 125515 | 203683 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1499 14th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991788.98515 | 2105274.14974 | 37.7602091550515 | -122.471502247657 | (37.7602091550515, -122.471502247657) | 1 | 8 | 4 | 56 | 12 | |||
| 128205 | 48681 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3839 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2002 12:00:00 AM | 9 | Permit Number 45963 | 5996443.82133 | 2115574.81636 | 37.7887602819167 | -122.456148218592 | (37.7887602819167, -122.456148218592) | 11 | 6 | 1 | 54 | 31 |
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) );