Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
148678 | 148678 | 180562 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4101 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5991620.890430001 | 2086817.0358099998 | 37.70952085356139 | -122.470739173794 | (37.7095208535614, -122.470739173794) | |||
147164 | 147164 | 215518 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 278 Howth St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997249.4841 | 2090499.4445099998 | 37.719955788905295 | -122.451551333026 | (37.7199557889053, -122.451551333026) | |||
72890 | 72890 | 215517 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 164 Howth St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5997515.643519999 | 2090995.9765400002 | 37.7213343884584 | -122.450667096231 | (37.7213343884584, -122.450667096231) | |||
152982 | 152982 | 198514 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1601 Bay Shore Blvd | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012038.03347 | 2091375.16372 | 37.723196132582395 | -122.400493582929 | (37.7231961325824, -122.400493582929) | |||
174425 | 174425 | 201913 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013833.24742 | 2093196.5259999998 | 37.728297178952204 | -122.394415299033 | (37.7282971789522, -122.394415299033) | |||
156847 | 156847 | 201912 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013819.77778 | 2093207.08272 | 37.7283254167788 | -122.394462603388 | (37.7283254167788, -122.394462603388) | |||
136167 | 136167 | 201911 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013805.76571 | 2093216.36455 | 37.72835012384171 | -122.394511693764 | (37.7283501238417, -122.394511693764) | |||
178128 | 178128 | 201910 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013794.8405 | 2093225.07 | 37.728373419872604 | -122.39455007233101 | (37.7283734198726, -122.394550072331) | |||
189004 | 189004 | 201909 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013782.36653 | 2093233.80649 | 37.728396715017 | -122.39459380727101 | (37.728396715017, -122.394593807271) | |||
39939 | 39939 | 201908 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013768.13816 | 2093245.14959 | 37.7284270698286 | -122.39464378978901 | (37.7284270698286, -122.394643789789) | |||
153607 | 153607 | 201907 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013751.60826 | 2093257.56774 | 37.7284602485269 | -122.394701804167 | (37.7284602485269, -122.394701804167) | |||
157811 | 157811 | 201906 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6013735.56827 | 2093268.6904400003 | 37.728489897392706 | -122.394758034254 | (37.7284898973927, -122.394758034254) | |||
154868 | 154868 | 198522 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1725 Newcomb Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 7ft | 6014552.77288 | 2096169.8984700001 | 37.736501427800896 | -122.392135704718 | (37.7365014278009, -122.392135704718) | |||
146604 | 146604 | 198554 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 6014551.87687 | 2096170.8022200002 | 37.7365038595638 | -122.392138865814 | (37.7365038595638, -122.392138865814) | |||
61347 | 61347 | 198555 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 6014573.3931599995 | 2096202.10779 | 37.7365910128673 | -122.39206666287 | (37.7365910128673, -122.39206666287) | |||
34416 | 34416 | 198529 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1722 Newcomb Ave | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 7ft | 6014569.28946 | 2096208.9031099998 | 37.73660944358 | -122.392081326305 | (37.73660944358, -122.392081326305) | |||
153660 | 153660 | 198544 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 6014356.36657 | 2096313.21091 | 37.7368840272751 | -122.392824793156 | (37.7368840272751, -122.392824793156) | |||
58767 | 58767 | 198517 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1763 Newcomb Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 7ft | 6014346.73951 | 2096322.78373 | 37.736909777547204 | -122.392858747949 | (37.7369097775472, -122.392858747949) | |||
150695 | 150695 | 198543 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 6014375.169509999 | 2096346.21278 | 37.7369756879815 | -122.39276209061701 | (37.7369756879815, -122.392762090617) | |||
59151 | 59151 | 198532 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1762 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 7ft | 6014372.17182 | 2096354.40755 | 37.736998022638105 | -122.39277302817301 | (37.7369980226381, -122.392773028173) | |||
62956 | 62956 | 198537 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1799 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6014201.9546 | 2096422.50115 | 37.737175538007996 | -122.393366313629 | (37.737175538008, -122.393366313629) | |||
149140 | 149140 | 198515 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1799 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 7ft | 6014195.4851 | 2096428.16661 | 37.7371907347515 | -122.39338907816999 | (37.7371907347515, -122.39338907817) | |||
74031 | 74031 | 198538 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1782 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014279.64227 | 2096432.4215799998 | 37.737207093417 | -122.39309840377899 | (37.737207093417, -122.393098403779) | |||
42863 | 42863 | 246813 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 174 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6010206.83584 | 2098924.9753900003 | 37.7438240172737 | -122.40735569070699 | (37.7438240172737, -122.407355690707) | |||
28826 | 28826 | 247019 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 530 Valley St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6002475.46095 | 2099175.15499 | 37.744075198804204 | -122.43410681909799 | (37.7440751988042, -122.434106819098) | |||
150485 | 150485 | 198513 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2216 23rd St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6011806.19785 | 2102818.97218 | 37.754605473977996 | -122.402099143454 | (37.754605473978, -122.402099143454) | |||
181672 | 181672 | 198508 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 998 Rhode Island St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6011865.97365 | 2103785.48158 | 37.757262632470606 | -122.401960360989 | (37.7572626324706, -122.401960360989) | |||
60796 | 60796 | 198511 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 678 Arkansas St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012984.38366 | 2103919.0559799997 | 37.7576917548011 | -122.398101807147 | (37.7576917548011, -122.398101807147) | |||
62923 | 62923 | 198510 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 678 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6012982.1442 | 2103924.05495 | 37.7577053561473 | -122.39810990286999 | (37.7577053561473, -122.39810990287) | |||
150607 | 150607 | 198505 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 743 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6011863.14571 | 2104907.21276 | 37.7603425002176 | -122.40204899817499 | (37.7603425002176, -122.402048998175) | |||
146421 | 146421 | 242605 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1315 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5999041.02625 | 2105175.78998 | 37.7603559558947 | -122.44641388389299 | (37.7603559558947, -122.446413883893) | |||
167287 | 167287 | 198506 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 743 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 14 | Width 2ft | 6011861.67877 | 2104921.79011 | 37.7603824445082 | -122.40205509648999 | (37.7603824445082, -122.40205509649) | |||
58522 | 58522 | 242604 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1311 Clayton St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5999041.21728 | 2105197.03695 | 37.7604143056979 | -122.446414751759 | (37.7604143056979, -122.446414751759) | |||
157714 | 157714 | 242603 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1311 Clayton St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5999039.00902 | 2105211.58372 | 37.7604541213822 | -122.44642343560699 | (37.7604541213822, -122.446423435607) | |||
153242 | 153242 | 242602 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1311 Clayton St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5999038.72124 | 2105222.15033 | 37.7604831182267 | -122.44642519108801 | (37.7604831182267, -122.446425191088) | |||
147821 | 147821 | 242601 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1311 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5999037.14179 | 2105234.87473 | 37.7605179660504 | -122.44643156908501 | (37.7605179660504, -122.446431569085) | |||
133625 | 133625 | 198509 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 361 Texas St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6013800.26675 | 2105409.79767 | 37.7618304159729 | -122.395384559572 | (37.7618304159729, -122.395384559572) | |||
176128 | 176128 | 246976 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 221 Noe St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 6ft | 6002925.65155 | 2106953.9304400003 | 37.765459405239504 | -122.43310583406799 | (37.7654594052395, -122.433105834068) | |||
40920 | 40920 | 242375 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 130 Church St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6004079.07598 | 2108183.78189 | 37.7689016404155 | -122.429204103801 | (37.7689016404155, -122.429204103801) | |||
64710 | 64710 | 242372 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 65 McCoppin St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6006293.4937 | 2109105.47321 | 37.7715574949158 | -122.42161004138201 | (37.7715574949158, -122.421610041382) | |||
184354 | 184354 | 242780 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 95 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 9ft | 6006179.77173 | 2109125.10938 | 37.7716049979898 | -122.422004807797 | (37.7716049979898, -122.422004807797) | |||
159564 | 159564 | 242778 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 9ft | 6006595.78841 | 2109152.55753 | 37.7717038182152 | -122.420567728011 | (37.7717038182152, -122.420567728011) | |||
134733 | 134733 | 136986 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 689 Hayes St | 3 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6004705.5479 | 2110850.60835 | 37.776259542675604 | -122.42722716640101 | (37.7762595426756, -122.427227166401) |
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");