Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, PlotSize
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
186554 | 186554 | 250195 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011875.28376 | 2119779.56963 | 37.8011792152183 | -122.40305313080401 | (37.8011792152183, -122.403053130804) | |||
186272 | 186272 | 223809 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 6 Miguel St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6003330.909440001 | 2097346.2966299998 | 37.7391020890899 | -122.431018368229 | (37.7391020890899, -122.431018368229) | ||||
184674 | 184674 | 126416 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 46 | 6006501.512069999 | 2121012.26216 | 37.804262323204895 | -122.421736358356 | (37.8042623232049, -122.421736358356) | ||||
181873 | 181873 | 250227 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 312 Filbert St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011220.88869 | 2120048.61475 | 37.8018813824768 | -122.40533659221902 | (37.8018813824768, -122.405336592219) | |||
180895 | 180895 | 176096 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 5998966.43073 | 2089373.6298 | 37.7169627336137 | -122.445535550248 | (37.7169627336137, -122.445535550248) | ||||
179538 | 179538 | 176165 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 654 Peru Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6005141.81262 | 2092533.90812 | 37.7259907884276 | -122.42441488026199 | (37.7259907884276, -122.424414880262) | ||||
171449 | 171449 | 249865 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1497 Montgomery St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 0ft | 6011350.601919999 | 2120707.91777 | 37.8036989186248 | -122.404934168095 | (37.8036989186248, -122.404934168095) | |||
167728 | 167728 | 201724 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | 6017165.24184 | 2095383.9343 | 37.7344880327856 | -122.383048514986 | (37.7344880327856, -122.383048514986) | ||||
167034 | 167034 | 176166 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 654 Peru Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 30 | 6005147.67241 | 2092530.2100099998 | 37.7259809651314 | -122.424394360408 | (37.7259809651314, -122.424394360408) | ||||
166544 | 166544 | 176163 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 654 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6005125.75661 | 2092550.7271200002 | 37.726036063007705 | -122.42447158070601 | (37.7260360630077, -122.424471580706) | ||||
158925 | 158925 | 248059 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 18 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 41 | 6010698.28988 | 2099365.5413599997 | 37.7450612101031 | -122.40568737459299 | (37.7450612101031, -122.405687374593) | ||||
156317 | 156317 | 250196 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011857.70339 | 2119785.90004 | 37.801195615236395 | -122.403114412425 | (37.8011956152364, -122.403114412425) | |||
152144 | 152144 | 223808 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 6 Miguel St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6003326.01138 | 2097344.7820099997 | 37.739097652747205 | -122.431035195413 | (37.7390976527472, -122.431035195413) | ||||
146514 | 146514 | 201719 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6017095.79964 | 2095357.4210400002 | 37.7344113952763 | -122.38328675710501 | (37.7344113952763, -122.383286757105) | ||||
136128 | 136128 | 218153 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 Ashton Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5994153.71185 | 2090014.1877400002 | 37.7184456203604 | -122.46221709555 | (37.7184456203604, -122.46221709555) | ||||
135623 | 135623 | 247911 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 399 Franconia St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 39 | 6009944.29918 | 2098783.53182 | 37.7434209465163 | -122.408253510886 | (37.7434209465163, -122.408253510886) | ||||
75219 | 75219 | 176164 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 654 Peru Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 33 | 6005136.16004 | 2092540.09119 | 37.7260074465758 | -122.42443486048201 | (37.7260074465758, -122.424434860482) | ||||
69463 | 69463 | 205919 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 230 Edna St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 5998797.1475 | 2095343.94395 | 37.7333461617934 | -122.44654997291599 | (37.7333461617934, -122.446549972916) | ||||
67552 | 67552 | 223719 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Crescent Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 3ft | 6005300.64092 | 2095902.62438 | 37.735249504969104 | -122.424105284154 | (37.7352495049691, -122.424105284154) | |||
66895 | 66895 | 176112 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Tomaso Ct | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009187.4096 | 2086275.4475900002 | 37.7090339795175 | -122.409987838189 | (37.7090339795175, -122.409987838189) | |||
65775 | 65775 | 176097 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998962.663240001 | 2089377.08137 | 37.716971995749795 | -122.445548820645 | (37.7169719957498, -122.445548820645) | ||||
65706 | 65706 | 201723 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6017160.60225 | 2095378.34378 | 37.734472425960895 | -122.383064166774 | (37.7344724259609, -122.383064166774) | ||||
60552 | 60552 | 250197 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011839.72623 | 2119769.92251 | 37.8011507408769 | -122.403175497057 | (37.8011507408769, -122.403175497057) | |||
59780 | 59780 | 126415 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 48 | 6006502.51226 | 2121001.4648 | 37.804232732814704 | -122.421732129727 | (37.8042327328147, -122.421732129727) | ||||
58146 | 58146 | 201718 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6017093.28201 | 2095356.3247099998 | 37.7344082458391 | -122.38329538517401 | (37.7344082458391, -122.383295385174) | ||||
55847 | 55847 | 201720 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6017109.38533 | 2095355.2358400002 | 37.734406145933704 | -122.383239634411 | (37.7344061459337, -122.383239634411) | ||||
53056 | 53056 | 248184 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 216 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | 6007432.5204300005 | 2098714.89498 | 37.7430915158666 | -122.416933765486 | (37.7430915158666, -122.416933765486) | ||||
51235 | 51235 | 201716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6017085.9132900005 | 2095352.6498 | 37.7343977480421 | -122.38332060578001 | (37.7343977480421, -122.38332060578) | ||||
46469 | 46469 | 250199 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 0ft | 6011821.07725 | 2119768.34547 | 37.8011453692141 | -122.403239919993 | (37.8011453692141, -122.403239919993) | |||
44565 | 44565 | 201717 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6017089.1408 | 2095350.86435 | 37.7343930239173 | -122.38330932287201 | (37.7343930239173, -122.383309322872) | ||||
38454 | 38454 | 249866 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1497 Montgomery St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011357.005059999 | 2120690.5710400003 | 37.8036516466761 | -122.404910787509 | (37.8036516466761, -122.404910787509) | |||
35448 | 35448 | 176098 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5998949.65718 | 2089392.42013 | 37.717013369950706 | -122.44559487852699 | (37.7170133699507, -122.445594878527) | ||||
35115 | 35115 | 126414 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006501.05561 | 2120998.5397099997 | 37.804224619123296 | -122.421736962694 | (37.8042246191233, -122.421736962694) | ||||
34240 | 34240 | 247903 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 582 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6009830.823 | 2098729.7061900003 | 37.743266798225605 | -122.40864208815701 | (37.7432667982256, -122.408642088157) | ||||
30768 | 30768 | 223720 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Crescent Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6005295.72226 | 2095902.89747 | 37.7352499770995 | -122.424122309196 | (37.7352499770995, -122.424122309196) | |||
13275 | 13275 | 187637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
13271 | 13271 | 187638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
9916 | 9916 | 173733 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 14 Richland Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 3x3 | 6004601.0 | 2096122.0 | 37.7358123337564 | -122.426539816145 | (37.7358123337564, -122.426539816145) | ||||
1875 | 1875 | 251783 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 610 Clipper St | 5 | Side Yard : Yard 17 | Tree 1 | DPW 2 | Width 2ft | 6001275.75039 | 2100902.7174 | 37.7487505133321 | -122.438378885672 | (37.7487505133321, -122.438378885672) |
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");