Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33146 | 33146 | 123258 | Undocumented 2 | Corymbia calophylla :: 383 | 735 07th Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 4ft | 5993772.801419999 | 2110648.6089 | 37.7750805697855 | -122.465031565013 | (37.7750805697855, -122.465031565013) | |||
| 44466 | 44466 | 245799 | Undocumented 2 | Corymbia calophylla :: 383 | 50 Church St | 1 | : 4 | Tree 1 | Private 1 | 21 | Width 6ft | 6004070.9370099995 | 2108481.83175 | 37.7697195522468 | -122.429253511635 | (37.7697195522468, -122.429253511635) | |||
| 54941 | 54941 | 245803 | Undocumented 2 | Corymbia calophylla :: 383 | 1000 San Jose Ave | 57 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6005108.98123 | 2097067.8854 | 37.7384382266371 | -122.424850796934 | (37.7384382266371, -122.424850796934) | ||||
| 122846 | 122846 | 12855 | DPW Maintained 3 | Corymbia calophylla :: 383 | 2438 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x5 | 5987825.806890001 | 2114674.13525 | 37.7857888205012 | -122.48589880207199 | (37.7857888205012, -122.485898802072) | |||
| 136277 | 136277 | 245805 | Undocumented 2 | Corymbia calophylla :: 383 | 1000 San Jose Ave | 59 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6005091.99753 | 2097057.85602 | 37.7384097289195 | -122.42490880502399 | (37.7384097289195, -122.424908805024) | ||||
| 146835 | 146835 | 245800 | Undocumented 2 | Corymbia calophylla :: 383 | 1000 San Jose Ave | 49 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6005122.799790001 | 2097103.7787400002 | 37.7385375621556 | -122.42480557183701 | (37.7385375621556, -122.424805571837) | ||||
| 148877 | 148877 | 245801 | Undocumented 2 | Corymbia calophylla :: 383 | 1000 San Jose Ave | 50 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005117.51617 | 2097095.53018 | 37.7385146150421 | -122.424823253408 | (37.7385146150421, -122.424823253408) | ||||
| 167576 | 167576 | 245804 | Undocumented 2 | Corymbia calophylla :: 383 | 1000 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6005100.77229 | 2097064.25722 | 37.7384278008054 | -122.424878921434 | (37.7384278008054, -122.424878921434) | ||||
| 172163 | 172163 | 247766 | Undocumented 2 | Corymbia calophylla :: 383 | 25 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 21 | Width 3ft | 6001636.39273 | 2108565.80914 | 37.7698120088385 | -122.43768052703301 | (37.7698120088385, -122.437680527033) | |||
| 172631 | 172631 | 245806 | Undocumented 2 | Corymbia calophylla :: 383 | 1000 San Jose Ave | 61 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005088.09229 | 2097053.37977 | 37.738397217560205 | -122.42492198907401 | (37.7383972175602, -122.424921989074) | ||||
| 178881 | 178881 | 245802 | Undocumented 2 | Corymbia calophylla :: 383 | 1000 San Jose Ave | 56 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6005105.11346 | 2097077.58418 | 37.738464638836 | -122.424864859638 | (37.738464638836, -122.424864859638) |
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");