Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1932 | 1932 | 252826 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
1933 | 1933 | 252830 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
1936 | 1936 | 252824 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
1938 | 1938 | 252827 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
10174 | 10174 | 173886 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 2931 20th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009454.0 | 2104482.0 | 37.759040204703496 | -122.41035112011801 | (37.7590402047035, -122.410351120118) | |||||
10190 | 10190 | 173887 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 2931 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009454.0 | 2104482.0 | 37.759040204703496 | -122.41035112011801 | (37.7590402047035, -122.410351120118) | |||||
23162 | 23162 | 251173 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 367 Jersey St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 3ft | 6002770.52649 | 2101500.0126900002 | 37.7504754543841 | -122.43325263672399 | (37.7504754543841, -122.433252636724) | ||||
34652 | 34652 | 243942 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Church St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 3ft | 6004361.46086 | 2104388.80864 | 37.7584975338534 | -122.427956893407 | (37.7584975338534, -122.427956893407) | |||
41272 | 41272 | 243941 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Church St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 3ft | 6004362.39063 | 2104350.06977 | 37.758391218686796 | -122.4279509174 | (37.7583912186868, -122.4279509174) | |||
43953 | 43953 | 249965 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 265 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 0ft | 6011638.85917 | 2120086.18138 | 37.802007891017205 | -122.40389285566799 | (37.8020078910172, -122.403892855668) | |||
47352 | 47352 | 203175 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2338 Lane St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6013915.08418 | 2092868.40903 | 37.7274007851107 | -122.394109422506 | (37.7274007851107, -122.394109422506) | ||||
51983 | 51983 | 203178 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1301 Minnesota St | 65 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6015363.87101 | 2102334.663 | 37.75347359354279 | -122.38976182994 | (37.7534735935428, -122.38976182994) | ||||
54015 | 54015 | 250212 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 300 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 6011360.92473 | 2120092.038 | 37.8020084404915 | -122.404855058325 | (37.8020084404915, -122.404855058325) | |||
87949 | 87949 | 96848 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 1486 Innes Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016133.4 | 2096820.6 | 37.7383757570157 | -122.386716118251 | (37.7383757570157, -122.386716118251) | ||||||
107366 | 107366 | 101903 | Property Tree 7 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
108424 | 108424 | 106038 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 230 Lakeview Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 772456 | 5997013.1 | 2089546.6 | 37.7173259605404 | -122.452299707743 | (37.7173259605404, -122.452299707743) | |||||
110616 | 110616 | 101905 | Property Tree 7 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
146191 | 146191 | 101904 | Property Tree 7 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
156480 | 156480 | 247960 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 14 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6010368.04056 | 2098905.3223200003 | 37.743779075439704 | -122.406796895161 | (37.7437790754397, -122.406796895161) | ||||
163853 | 163853 | 247589 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 800 Tompkins Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008947.19059 | 2096447.5550400002 | 37.7369509800105 | -122.411536266603 | (37.7369509800105, -122.411536266603) | ||||
167968 | 167968 | 203187 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2209 25th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6012122.25902 | 2101859.12536 | 37.7519875798856 | -122.400938678078 | (37.7519875798856, -122.400938678078) | ||||
174438 | 174438 | 203177 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1301 Minnesota St | 61 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6015358.55131 | 2102374.09965 | 37.7535815832452 | -122.38978298111401 | (37.7535815832452, -122.389782981114) | ||||
178669 | 178669 | 243943 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 671 Church St | 56 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 3ft | 6004315.82343 | 2105235.1157 | 37.7608187101375 | -122.428175041065 | (37.7608187101375, -122.428175041065) | |||
184842 | 184842 | 203176 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1301 Minnesota St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6015380.59839 | 2102345.27771 | 37.753503666864205 | -122.38970472391199 | (37.7535036668642, -122.389704723912) |
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");