Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8520 | 8520 | 13297 | DPW Maintained 3 | Fagus sylvatica :: European Beech 250 | 2770 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | Permit Number 770074 | 5999236.740180001 | 2119108.9104400002 | 37.798623886028 | -122.44673954549101 | (37.798623886028, -122.446739545491) | ||
| 33388 | 33388 | 103092 | Section 143 8 | Fagus sylvatica :: European Beech 250 | 1540 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008422.05981 | 2117808.6375599997 | 37.7955740826282 | -122.41486325634399 | (37.7955740826282, -122.414863256344) | |
| 33409 | 33409 | 186354 | Undocumented 2 | Fagus sylvatica :: European Beech 250 | 1801 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984834.846 | 2102662.3098 | 37.7526330064509 | -122.495360347454 | (37.7526330064509, -122.495360347454) | |||
| 39536 | 39536 | 218797 | Undocumented 2 | Fagus sylvatica :: European Beech 250 | 215 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 4ft | 5994944.255919999 | 2100553.8552599996 | 37.7474304587646 | -122.46024773316499 | (37.7474304587646, -122.460247733165) | |||
| 40943 | 40943 | 126608 | Undocumented 2 | Fagus sylvatica :: European Beech 250 | 2770 Lombard St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999116.02879 | 2119093.57703 | 37.7985748882819 | -122.447156139343 | (37.7985748882819, -122.447156139343) | ||||
| 42795 | 42795 | 103093 | Section 143 8 | Fagus sylvatica :: European Beech 250 | 1540 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008420.39916 | 2117820.52002 | 37.79560661561779 | -122.41486984389401 | (37.7956066156178, -122.414869843894) | |
| 48701 | 48701 | 218798 | Undocumented 2 | Fagus sylvatica :: European Beech 250 | 215 Magellan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 4ft | 5994966.431530001 | 2100574.6456 | 37.7474888193606 | -122.460172557931 | (37.7474888193606, -122.460172557931) | |||
| 62948 | 62948 | 103091 | Section 143 8 | Fagus sylvatica :: European Beech 250 | 1540 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008424.20559 | 2117797.21945 | 37.7955428518875 | -122.414855023041 | (37.7955428518875, -122.414855023041) | |
| 82928 | 82928 | 102048 | Undocumented 2 | Fagus sylvatica :: European Beech 250 | 213 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994976.9 | 2100573.4 | 37.747486001387294 | -122.46013626866001 | (37.7474860013873, -122.46013626866) | |||||
| 99642 | 99642 | 113379 | Property Tree 7 | Fagus sylvatica :: European Beech 250 | 140 CASTENADA AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 5994437.0 | 2101097.0 | 37.7488926059174 | -122.462041158848 | (37.7488926059174, -122.462041158848) | ||||
| 109200 | 109200 | 101625 | Property Tree 7 | Fagus sylvatica :: European Beech 250 | 64 Levant St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 769362 | 6000275.9 | 2106473.5 | 37.76398959970761 | -122.442236202383 | (37.7639895997076, -122.442236202383) | ||||
| 110826 | 110826 | 102049 | Undocumented 2 | Fagus sylvatica :: European Beech 250 | 213 Magellan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994976.9 | 2100573.4 | 37.747486001387294 | -122.46013626866001 | (37.7474860013873, -122.46013626866) | |||||
| 133173 | 133173 | 249656 | Undocumented 2 | Fagus sylvatica :: European Beech 250 | 2401 Lyon St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 10ft | 5999224.178719999 | 2117231.2335900003 | 37.7934675682154 | -122.44664784252899 | (37.7934675682154, -122.446647842529) | |||
| 147838 | 147838 | 126609 | Undocumented 2 | Fagus sylvatica :: European Beech 250 | 1183 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008435.250630001 | 2117910.5789099997 | 37.7958547295674 | -122.414824831928 | (37.7958547295674, -122.414824831928) | |||
| 149863 | 149863 | 103095 | Section 143 8 | Fagus sylvatica :: European Beech 250 | 1540 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008416.42419 | 2117851.09099 | 37.7956903325975 | -122.414885762773 | (37.7956903325975, -122.414885762773) | |
| 155110 | 155110 | 123542 | Undocumented 2 | Fagus sylvatica :: European Beech 250 | 37 05th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5994230.38734 | 2115336.7433599997 | 37.7879792973558 | -122.463789037794 | (37.7879792973558, -122.463789037794) | |||
| 160143 | 160143 | 103094 | Section 143 8 | Fagus sylvatica :: European Beech 250 | 1540 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008418.50881 | 2117836.67229 | 37.7956508595435 | -122.414877528601 | (37.7956508595435, -122.414877528601) | |
| 168598 | 168598 | 218796 | Undocumented 2 | Fagus sylvatica :: European Beech 250 | 303 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5994310.29727 | 2099950.1625200002 | 37.745736384219704 | -122.462396123591 | (37.7457363842197, -122.462396123591) | |||
| 176988 | 176988 | 103096 | Section 143 8 | Fagus sylvatica :: European Beech 250 | 1540 Jones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008414.12252 | 2117870.41106 | 37.795743251405504 | -122.414895095058 | (37.7957432514055, -122.414895095058) | |
| 182060 | 182060 | 126607 | Undocumented 2 | Fagus sylvatica :: European Beech 250 | 2770 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 5999174.46407 | 2119100.3355799997 | 37.7985967840741 | -122.446954422315 | (37.7985967840741, -122.446954422315) | |||
| 186589 | 186589 | 123541 | Undocumented 2 | Fagus sylvatica :: European Beech 250 | 33 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994226.49475 | 2115389.59393 | 37.7881241862842 | -122.46380634291799 | (37.7881241862842, -122.463806342918) |
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");