Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, qCaretaker, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3018 | 3018 | 128709 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4x Columbus Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 19 | Width 9ft | 6011726.08303 | 2117794.9108 | 37.795721488711294 | -122.403429729102 | (37.7957214887113, -122.403429729102) | |||
25864 | 25864 | 211289 | DPW Maintained 3 | Pinus thunbergii :: Japanese Black Pine 306 | 100x Idora Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 5995366.53481 | 2099407.6063200003 | 37.744307426259205 | -122.45870456127399 | (37.7443074262592, -122.458704561274) | |||
26492 | 26492 | 242374 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 6006546.0037 | 2109148.1970900004 | 37.771689039651896 | -122.42073962714899 | (37.7716890396519, -122.420739627149) | |||
27503 | 27503 | 208879 | DPW Maintained 3 | Malus :: Crab Apple 235 | 100x Idora Ave | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 9ft | 5995727.40355 | 2099320.3409700003 | 37.74408855195821 | -122.457450449475 | (37.7440885519582, -122.457450449475) | |||
28868 | 28868 | 208175 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Lawton St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 9ft | 5991060.8036 | 2104516.28775 | 37.758086113802904 | -122.473965364836 | (37.7580861138029, -122.473965364836) | |||
37375 | 37375 | 211161 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Idora Ave | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 41 | Width 9ft | 5995684.4738300005 | 2099331.0800900003 | 37.7441155729727 | -122.45759966680599 | (37.7441155729727, -122.457599666806) | |||
38489 | 38489 | 214330 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 100x Idora Ave | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 9ft | 5995527.4625 | 2099368.48178 | 37.7442092481691 | -122.458145280077 | (37.7442092481691, -122.458145280077) | |||
44924 | 44924 | 217728 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100x Lincoln Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 9ft | 5995225.13962 | 2107407.04812 | 37.766263730121004 | -122.45977279128901 | (37.766263730121, -122.459772791289) | |||
50547 | 50547 | 211162 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Idora Ave | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995762.15632 | 2099312.39681 | 37.744068735376295 | -122.457329708294 | (37.7440687353763, -122.457329708294) | |||
51364 | 51364 | 214329 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 100x Idora Ave | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 9ft | 5995487.46893 | 2099377.84768 | 37.744232666505106 | -122.45828424602301 | (37.7442326665051, -122.458284246023) | |||
57260 | 57260 | 242793 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2x Coso Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 9ft | 6007083.58829 | 2099965.0449 | 37.746504513177 | -122.418228897148 | (37.746504513177, -122.418228897148) | |||
60126 | 60126 | 205301 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100x Idora Ave | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 9ft | 5995644.80929 | 2099340.4392 | 37.7441389922109 | -122.45773749420799 | (37.7441389922109, -122.457737494208) | |||
65522 | 65522 | 205300 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100x Idora Ave | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 9ft | 5995637.606269999 | 2099342.55805 | 37.7441443962476 | -122.457762553794 | (37.7441443962476, -122.457762553794) | |||
67961 | 67961 | 206836 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100x Idora Ave | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 66 | Width 9ft | 5995604.17085 | 2099350.4744700002 | 37.7441642119029 | -122.45787873812799 | (37.7441642119029, -122.457878738128) | |||
73631 | 73631 | 211163 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Idora Ave | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 5995808.0564 | 2099301.9235400003 | 37.744042614569295 | -122.45717023961001 | (37.7440426145693, -122.45717023961) | |||
115432 | 115432 | 210682 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100x Idora Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 9ft | 5995339.29404 | 2099412.4410200003 | 37.7443191354124 | -122.4587991034 | (37.7443191354124, -122.4587991034) | |||
134715 | 134715 | 211077 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 100x Idora Ave | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 9ft | 5995433.6180300005 | 2099390.76131 | 37.7442650295015 | -122.45847138416799 | (37.7442650295015, -122.458471384168) | |||
136941 | 136941 | 211477 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 100x Idora Ave | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | Width 9ft | 5995466.33774 | 2099382.46662 | 37.7442441346666 | -122.45835764690001 | (37.7442441346666, -122.4583576469) | |||
137327 | 137327 | 214332 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 100x Idora Ave | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 9ft | 5995718.21124 | 2099321.8453599997 | 37.7440921546362 | -122.457482343055 | (37.7440921546362, -122.457482343055) | |||
146356 | 146356 | 199366 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300x Division St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 9ft | 6009946.07759 | 2108167.65587 | 37.769187748042704 | -122.40890931543801 | (37.7691877480427, -122.408909315438) | |||
146780 | 146780 | 214408 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Idora Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 9ft | 5995751.653580001 | 2099314.25679 | 37.7440732391823 | -122.457366158726 | (37.7440732391823, -122.457366158726) | |||
148511 | 148511 | 212576 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100x Idora Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995353.74805 | 2099410.49817 | 37.74431463161879 | -122.458748984199 | (37.7443146316188, -122.458748984199) | |||
160927 | 160927 | 242373 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 6006573.34583 | 2109150.3275 | 37.771696430266 | -122.420645200112 | (37.771696430266, -122.420645200112) | |||
166774 | 166774 | 242781 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 95x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 9ft | 6006152.38517 | 2109124.27435 | 37.771601160584 | -122.42209948031099 | (37.771601160584, -122.422099480311) | |||
167931 | 167931 | 124291 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4401x Cornwall St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 9ft | 5993813.763719999 | 2114194.95027 | 37.7848202285685 | -122.465147505193 | (37.7848202285685, -122.465147505193) | |||
174532 | 174532 | 214331 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 100x Idora Ave | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995540.56521 | 2099364.9270200003 | 37.7442002405496 | -122.458099716827 | (37.7442002405496, -122.458099716827) | |||
185473 | 185473 | 242779 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 9ft | 6006556.42632 | 2109149.52189 | 37.77169326466979 | -122.420703668659 | (37.7716932646698, -122.420703668659) | |||
185898 | 185898 | 188406 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1300x De Haro St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 9ft | 6012288.20028 | 2102185.92507 | 37.75289415586 | -122.400387777694 | (37.75289415586, -122.400387777694) | |||
187642 | 187642 | 206837 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100x Idora Ave | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 63 | Width 9ft | 5995840.17489 | 2099294.03492 | 37.7440227989188 | -122.45705861128401 | (37.7440227989188, -122.457058611284) | |||
187703 | 187703 | 187521 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 100x Mary Teresa St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 9ft | 6012597.41848 | 2087914.4030799998 | 37.7137247587658 | -122.398317184005 | (37.7137247587658, -122.398317184005) |
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");