Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20750 | 20750 | 4205 | DPW Maintained 3 | Gleditsia triacanthos :: Honey Locust 67 | 3912 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6004396.20206 | 2100464.83316 | 37.747725180966796 | -122.42755718612699 | (37.7477251809668, -122.427557186127) | |||
| 21463 | 21463 | 4204 | DPW Maintained 3 | Gleditsia triacanthos :: Honey Locust 67 | 3912 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6004409.0470900005 | 2100465.8043299997 | 37.7477285741092 | -122.427512837863 | (37.7477285741092, -122.427512837863) | |||
| 30001 | 30001 | 228357 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 650 Florida St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009240.17832 | 2105294.68845 | 37.7612596738224 | -122.411148025686 | (37.7612596738224, -122.411148025686) | |||
| 50328 | 50328 | 228358 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 650 Florida St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009245.00145 | 2105258.31078 | 37.7611600595138 | -122.41112877478399 | (37.7611600595138, -122.411128774784) | |||
| 78665 | 78665 | 116223 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 195 COLLINGWOOD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6002090.0 | 2104773.0 | 37.7594236635512 | -122.435840099174 | (37.7594236635512, -122.435840099174) | |||
| 119589 | 119589 | 228365 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 685 Florida St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009254.87399 | 2105047.99063 | 37.7605831219216 | -122.411079773416 | (37.7605831219216, -122.411079773416) | |||
| 119601 | 119601 | 219143 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 225 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994147.2133599995 | 2105277.0556799998 | 37.7603532786058 | -122.463346523547 | (37.7603532786058, -122.463346523547) | |||
| 120424 | 120424 | 72837 | Section 143 8 | Gleditsia triacanthos :: Honey Locust 67 | 2624 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770762 | 6010331.33933918 | 2104014.11752446 | 37.7578046465334 | -122.407283867997 | (37.7578046465334, -122.407283867997) | |
| 144928 | 144928 | 98487 | Permitted Site 1 | Gleditsia triacanthos :: Honey Locust 67 | 531X Franconia St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6009973.6 | 2098264.6 | 37.7419977132603 | -122.408115605514 | (37.7419977132603, -122.408115605514) | |||
| 149100 | 149100 | 228364 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 685 Florida St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009253.05651 | 2105058.10552 | 37.7606107931857 | -122.41108677375799 | (37.7606107931857, -122.411086773758) | |||
| 163178 | 163178 | 228354 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 650 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009234.96967 | 2105386.50054 | 37.761511476782495 | -122.411172525907 | (37.7615114767825, -122.411172525907) | |||
| 170296 | 170296 | 190623 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 111 Vermont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011128.17741 | 2108047.25299 | 37.7689232933915 | -122.404811996975 | (37.7689232933915, -122.404811996975) | |||
| 175181 | 175181 | 228355 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 650 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009239.492459999 | 2105360.20677 | 37.761439533729 | -122.41115502598801 | (37.761439533729, -122.411155025988) | |||
| 185405 | 185405 | 201614 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 98 Jerrold Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 4ft | 6020747.34365 | 2092993.8196 | 37.728122515333396 | -122.370498661104 | (37.7281225153334, -122.370498661104) |
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");