Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3059 | 3059 | 126695 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2829 Divisadero St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 10x10 | Permit Number 779774 | 6000551.43021 | 2118023.61416 | 37.7957189625051 | -122.44211236900601 | (37.7957189625051, -122.442112369006) | ||
| 8003 | 8003 | 109210 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2637 Larkin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774817 | 6006569.78732 | 2120282.61277 | 37.802262741793704 | -122.421448236261 | (37.8022627417937, -122.421448236261) | |
| 36569 | 36569 | 225566 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 250 States St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6000669.45689 | 2106618.65673 | 37.7644105861974 | -122.440885423048 | (37.7644105861974, -122.440885423048) | |||
| 37960 | 37960 | 246672 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 950 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 8ft | 6005247.4068 | 2097710.7023400003 | 37.7402110745895 | -122.42441789747299 | (37.7402110745895, -122.424417897473) | |||
| 48262 | 48262 | 246674 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 950 San Jose Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 8ft | 6005286.18809 | 2097704.16876 | 37.740195324763704 | -122.424283342697 | (37.7401953247637, -122.424283342697) | |||
| 60281 | 60281 | 202078 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Gould St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6012742.601 | 2090834.0731400002 | 37.721749674703496 | -122.398020073164 | (37.7217496747035, -122.398020073164) | ||||
| 76606 | 76606 | 246675 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 950 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 8ft | 6005283.663509999 | 2097689.92499 | 37.7401560720365 | -122.424291058881 | (37.7401560720365, -122.424291058881) | |||
| 127276 | 127276 | 189776 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Jack Balestreri Way | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012433.20724 | 2104795.86153 | 37.760068555049 | -122.400069588557 | (37.760068555049, -122.400069588557) | ||||
| 132636 | 132636 | 246673 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 950 San Jose Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 8ft | 6005263.852999999 | 2097708.23975 | 37.740205241579396 | -122.424360857976 | (37.7402052415794, -122.424360857976) | |||
| 174488 | 174488 | 225567 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 250 States St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 3ft | 6000654.11768 | 2106628.02953 | 37.764435447960295 | -122.440939149426 | (37.7644354479603, -122.440939149426) | |||
| 176579 | 176579 | 225568 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 250 States St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 3ft | 6000637.33416 | 2106640.8278200002 | 37.7644696329839 | -122.440998117062 | (37.7644696329839, -122.440998117062) |
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");