Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9543 | 9543 | 19690 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 89 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 12001 | 12001 | 19689 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 88 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 10305 | 10305 | 19688 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 87 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 1378 | 1378 | 19687 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 86 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 7622 | 7622 | 19686 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 85 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 9616 | 9616 | 19685 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 84 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 9612 | 9612 | 19684 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 83 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 7446 | 7446 | 19683 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 15679 | 15679 | 19682 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 81 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60ST | ||||||||
| 7322 | 7322 | 19681 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 80 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 5896 | 5896 | 19680 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 6263 | 6263 | 19679 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 78 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 9546 | 9546 | 19678 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 77 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 7153 | 7153 | 19677 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 76 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 141527 | 141527 | 204542 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 76 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 3ft | 5999719.35071 | 2097204.76728 | 37.738508176809 | -122.44349529248801 | (37.738508176809, -122.443495292488) | |||
| 7321 | 7321 | 19676 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 75 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 76485 | 76485 | 197585 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 900x Carolina St | 75 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6012517.30691 | 2102783.51804 | 37.7545477896502 | -122.399637433715 | (37.7545477896502, -122.399637433715) | ||||
| 136448 | 136448 | 204543 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 75 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 3ft | 5999719.20316 | 2097210.6996400002 | 37.7385244572495 | -122.44349622866301 | (37.7385244572495, -122.443496228663) | |||
| 7103 | 7103 | 19675 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 74 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 35348 | 35348 | 194039 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900x Carolina St | 74 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6012510.33858 | 2102789.20195 | 37.754563007990896 | -122.399661931254 | (37.7545630079909, -122.399661931254) | ||||
| 152488 | 152488 | 204544 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 74 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 3ft | 5999721.65299 | 2097224.39457 | 37.7385621999964 | -122.443488741827 | (37.7385621999964, -122.443488741827) | |||
| 14057 | 14057 | 19674 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 73 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 27066 | 27066 | 204545 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 73 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 3ft | 5999723.14356 | 2097244.03838 | 37.7386162222515 | -122.44348499883999 | (37.7386162222515, -122.44348499884) | |||
| 32869 | 32869 | 189966 | DPW Maintained 3 | Cercis canadensis :: Eastern Redbud 299 | 900x Carolina St | 73 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012515.82864 | 2102790.5172099997 | 37.754566925442795 | -122.39964303739201 | (37.7545669254428, -122.399643037392) | ||||
| 10253 | 10253 | 19673 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 72 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 26840 | 26840 | 194523 | DPW Maintained 3 | Pinus thunbergii :: Japanese Black Pine 306 | 900x Carolina St | 72 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6012512.869530001 | 2102814.17539 | 37.7546317206991 | -122.399654931846 | (37.7546317206991, -122.399654931846) | ||||
| 186357 | 186357 | 211055 | DPW Maintained 3 | Pinus muricata :: Bishop Pine 302 | 300x Marietta Dr | 72 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5999722.47175 | 2097250.7906299997 | 37.7386347240172 | -122.443487806529 | (37.7386347240172, -122.443487806529) | |||
| 6914 | 6914 | 19672 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 71 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 56546 | 56546 | 190677 | DPW Maintained 3 | Ilex spp :: Holly Species 163 | 900x Carolina St | 71 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6012520.45276 | 2102813.85342 | 37.7546312593522 | -122.39962868423201 | (37.7546312593522, -122.399628684232) | ||||
| 12748 | 12748 | 19671 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 61087 | 61087 | 190918 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 70 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6012519.44645 | 2102822.4393700003 | 37.754654778405296 | -122.399632767143 | (37.7546547784053, -122.399632767143) | ||||
| 12302 | 12302 | 19670 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 69 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 46296 | 46296 | 194557 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 900x Carolina St | 69 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012516.26815 | 2102828.89594 | 37.7546723295715 | -122.39964421193301 | (37.7546723295715, -122.399644211933) | ||||
| 186128 | 186128 | 204546 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 69 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 5999726.305480001 | 2097318.0909700003 | 37.738819733438504 | -122.443479384359 | (37.7388197334385, -122.443479384359) | |||
| 11204 | 11204 | 19669 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 68 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 54902 | 54902 | 204547 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 68 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 5999723.97514 | 2097336.19746 | 37.738869316670204 | -122.443488741839 | (37.7388693166702, -122.443488741839) | |||
| 63254 | 63254 | 190917 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 68 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6012519.74637 | 2102837.21301 | 37.7546953603194 | -122.399632767155 | (37.7546953603194, -122.399632767155) | ||||
| 11747 | 11747 | 19668 | DPW Maintained 3 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 100 STAIRWAY5 | 67 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 180985 | 180985 | 204548 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 67 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 5999721.47669 | 2097346.22168 | 37.738896698316005 | -122.443498100161 | (37.738896698316, -122.443498100161) | |||
| 14276 | 14276 | 19667 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 24818 | 24818 | 191371 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 66 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6012518.79145 | 2102845.53786 | 37.7547181653131 | -122.39963665401699 | (37.7547181653131, -122.399636654017) | ||||
| 180648 | 180648 | 204549 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 66 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 5999718.509930001 | 2097359.75923 | 37.7389337000243 | -122.44350932999 | (37.7389337000243, -122.44350932999) | |||
| 7433 | 7433 | 19666 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 49522 | 49522 | 193547 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 65 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012516.839980001 | 2102871.66546 | 37.7547897972265 | -122.39964523714501 | (37.7547897972265, -122.399645237145) | ||||
| 71033 | 71033 | 211427 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 300x Marietta Dr | 65 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5999709.393759999 | 2097376.92843 | 37.73898032267461 | -122.443542082395 | (37.7389803226746, -122.443542082395) | |||
| 4277 | 4277 | 19665 | DPW Maintained 3 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 100 STAIRWAY5 | 64 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 67188 | 67188 | 204553 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 64 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5999694.8834 | 2097395.01803 | 37.7390291648714 | -122.443593551518 | (37.7390291648714, -122.443593551518) | |||
| 89905 | 89905 | 3554 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 201X Cargo Way | 64 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016626.76696 | 2099218.04074 | 37.7449859443431 | -122.38517728139 | (37.7449859443431, -122.38517728139) | ||
| 157954 | 157954 | 194432 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 900x Carolina St | 64 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6012507.9331 | 2102881.1831400003 | 37.754815434199 | -122.39967670801599 | (37.754815434199, -122.399676708016) | ||||
| 11943 | 11943 | 19664 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 63 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 27702 | 27702 | 191370 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 63 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012517.15762 | 2102887.31193 | 37.75483277672829 | -122.399645237162 | (37.7548327767283, -122.399645237162) | ||||
| 133892 | 133892 | 204554 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 63 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 5999684.52262 | 2097404.39689 | 37.7390543260871 | -122.443630047808 | (37.7390543260871, -122.443630047808) | |||
| 140370 | 140370 | 3553 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 63 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1990 12:00:00 AM | 3 | 3X3 | 6016626.76696 | 2099218.04074 | 37.7449859443431 | -122.38517728139 | (37.7449859443431, -122.38517728139) | ||
| 182627 | 182627 | 200520 | DPW Maintained 3 | Tristania conferta :: 79 | 1400x La Salle Ave | 63 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6016476.5475 | 2095041.1188 | 37.7335086511389 | -122.38540570010599 | (37.7335086511389, -122.385405700106) | |||
| 1052 | 1052 | 187279 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 2401 Sunset Blvd | 62 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 0ft | 5984952.4466 | 2098301.7622 | 37.7406670151021 | -122.494632227246 | (37.7406670151021, -122.494632227246) | |||
| 11841 | 11841 | 19663 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 62 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 38640 | 38640 | 191369 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 62 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012514.91638 | 2102899.16549 | 37.7548651990855 | -122.399653820263 | (37.7548651990855, -122.399653820263) | ||||
| 45970 | 45970 | 204550 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 62 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 5999656.91248 | 2097430.30525 | 37.739123889545496 | -122.44372737153499 | (37.7391238895455, -122.443727371535) | |||
| 58587 | 58587 | 200519 | DPW Maintained 3 | Tristania conferta :: 79 | 1400x La Salle Ave | 62 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016469.2023 | 2095054.3401 | 37.7335445478075 | -122.38543201583401 | (37.7335445478075, -122.385432015834) | |||
| 81711 | 81711 | 3552 | DPW Maintained 3 | Quercus spp :: Oak 297 | 201X Cargo Way | 62 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016626.76696 | 2099218.04074 | 37.7449859443431 | -122.38517728139 | (37.7449859443431, -122.38517728139) | |||
| 15774 | 15774 | 19662 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 61 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 38728 | 38728 | 200604 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 61 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016455.981000001 | 2095075.886 | 37.7336029770488 | -122.385479227084 | (37.7336029770488, -122.385479227084) | |||
| 119957 | 119957 | 3551 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 61 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1990 12:00:00 AM | 6 | 3X3 | 6016626.76696 | 2099218.04074 | 37.7449859443431 | -122.38517728139 | (37.7449859443431, -122.38517728139) | ||
| 136728 | 136728 | 204551 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 61 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 5999648.64901 | 2097436.4062 | 37.739140169982 | -122.44375638096201 | (37.739140169982, -122.443756380962) | |||
| 184948 | 184948 | 190916 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 61 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012503.648130001 | 2102901.04205 | 37.754869723572895 | -122.39969292101601 | (37.7548697235729, -122.399692921016) | ||||
| 4990 | 4990 | 3550 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 201X Cargo Way | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1990 12:00:00 AM | 6 | 3X3 | 6018708.52549 | 2097590.55589 | 37.7406321362531 | -122.377865918974 | (37.7406321362531, -122.377865918974) | ||
| 10475 | 10475 | 19661 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 26004 | 26004 | 204552 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 60 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 5ft | 5999641.44525 | 2097441.40723 | 37.7391534907361 | -122.443781647414 | (37.7391534907361, -122.443781647414) | |||
| 76494 | 76494 | 233314 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200x Diamond Heights Blvd | 60 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6001944.7696 | 2098445.7713 | 37.742042348782 | -122.43588965038299 | (37.742042348782, -122.435889650383) | ||||
| 131762 | 131762 | 191368 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 60 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6012502.16132 | 2102909.3105599997 | 37.7548923442165 | -122.399698643387 | (37.7548923442165, -122.399698643387) | ||||
| 137132 | 137132 | 200619 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 60 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016453.0429 | 2095085.1899 | 37.733628361140106 | -122.38549003320101 | (37.7336283611401, -122.385490033201) | |||
| 5011 | 5011 | 3549 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 07:34:00 AM | 3 | 3X3 | 6018691.67406 | 2097603.0587400002 | 37.740665537995895 | -122.377925053006 | (37.7406655379959, -122.377925053006) | ||
| 15686 | 15686 | 19660 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 30866 | 30866 | 200618 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 59 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6016445.2081 | 2095088.6176 | 37.733637339432 | -122.38551735943399 | (37.733637339432, -122.385517359434) | |||
| 68371 | 68371 | 204555 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 59 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5999635.81986 | 2097444.2193400003 | 37.7391608912586 | -122.443801299384 | (37.7391608912586, -122.443801299384) | |||
| 5387 | 5387 | 19659 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 58 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 16339 | 16339 | 3548 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 58 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018674.8366 | 2097616.25665 | 37.7407008489755 | -122.37798418701999 | (37.7407008489755, -122.37798418702) | |||
| 58287 | 58287 | 200617 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 58 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6016444.7184 | 2095097.4319 | 37.7336615146436 | -122.385519666546 | (37.7336615146436, -122.385519666546) | |||
| 134194 | 134194 | 204556 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 58 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 5999628.6217 | 2097449.4898200002 | 37.739174952168206 | -122.443826565843 | (37.7391749521682, -122.443826565843) | |||
| 14263 | 14263 | 19658 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 57 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 16233 | 16233 | 3547 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 57 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6018659.18869 | 2097627.86643 | 37.7407318647912 | -122.378039097821 | (37.7407318647912, -122.378039097821) | |||
| 76733 | 76733 | 200616 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 57 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016436.8835 | 2095099.8803 | 37.7336678039609 | -122.385546924914 | (37.7336678039609, -122.385546924914) | |||
| 146647 | 146647 | 204557 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 57 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 5999620.61184 | 2097454.77716 | 37.7391890130662 | -122.443854640005 | (37.7391890130662, -122.443854640005) | |||
| 147407 | 147407 | 188588 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 57 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6012513.0739 | 2102944.23906 | 37.754988858573 | -122.399663356681 | (37.754988858573, -122.399663356681) | ||||
| 14729 | 14729 | 19657 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 16604 | 16604 | 3546 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018623.4169 | 2097653.5081700003 | 37.740800300486704 | -122.378164564055 | (37.7408003004867, -122.378164564055) | ||
| 25223 | 25223 | 208086 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800x Junipero Serra Blvd | 56 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991357.47228 | 2092905.4597099999 | 37.7262229367261 | -122.472093069866 | (37.7262229367261, -122.472093069866) | |||
| 40612 | 40612 | 193546 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 56 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6012511.31155 | 2102952.5131599996 | 37.7550114792069 | -122.39967003234699 | (37.7550114792069, -122.399670032347) | ||||
| 64773 | 64773 | 199615 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1700x Quesada Ave | 56 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6014226.56708 | 2095397.2747900002 | 37.734361844424704 | -122.393209497917 | (37.7343618444247, -122.393209497917) | ||||
| 127449 | 127449 | 10848 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1139X Hudson Ave | 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6018102.76401 | 2094614.84701 | 37.7324280296634 | -122.379753739799 | (37.7324280296634, -122.379753739799) | |||
| 164960 | 164960 | 200615 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1400x La Salle Ave | 56 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016438.8423 | 2095106.2461 | 37.7336853915549 | -122.38554059619301 | (37.7336853915549, -122.385540596193) | |||
| 175385 | 175385 | 204558 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 56 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 5999610.45434 | 2097460.9174599997 | 37.739205293478896 | -122.44389020099399 | (37.7392052934789, -122.443890200994) | |||
| 4862 | 4862 | 19656 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 55 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 4988 | 4988 | 3545 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 55 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 07:40:00 AM | 3 | 3X3 | 6018602.9683 | 2097669.9697 | 37.740844373569004 | -122.37823641090799 | (37.740844373569, -122.378236410908) | ||
| 60406 | 60406 | 194760 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1700x Quesada Ave | 55 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6014240.46002 | 2095410.02862 | 37.734397635636796 | -122.393162357259 | (37.7343976356368, -122.393162357259) | ||||
| 63150 | 63150 | 188587 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 55 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6012500.08207 | 2102956.31087 | 37.7550212809088 | -122.399709133985 | (37.7550212809088, -122.399709133985) | ||||
| 72294 | 72294 | 200614 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016432.4764 | 2095111.6325 | 37.73369982930821 | -122.385562980445 | (37.7336998293082, -122.385562980445) | |||
| 127427 | 127427 | 106795 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 199X ARLINGTON ST | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | ||||
| 150230 | 150230 | 208085 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800x Junipero Serra Blvd | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991358.2999 | 2092881.5903900003 | 37.726157445407296 | -122.47208846980301 | (37.7261574454073, -122.472088469803) | |||
| 174282 | 174282 | 204559 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 5ft | 5999606.142519999 | 2097461.8157099998 | 37.739207513906706 | -122.443905173798 | (37.7392075139067, -122.443905173798) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");