Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlotSize, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 887 | 887 | 251303 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 2 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 896 | 896 | 251302 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 100855 | 100855 | 114731 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 934 BRANNAN ST | Back Yard : Yard 13 | Tree 1 | Private 1 | Dept of Real Estate 9 | 10x10 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 105251 | 105251 | 92899 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 105598 | 105598 | 106227 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 38 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997884.0 | 2095808.5 | 37.7345695210024 | -122.44974042873999 | (37.7345695210024, -122.44974042874) | |||||
| 115179 | 115179 | 106275 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 42 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997882.5 | 2095834.4 | 37.7346405503947 | -122.449747480555 | (37.7346405503947, -122.449747480555) | |||||
| 119166 | 119166 | 92897 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 128646 | 128646 | 92900 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 143929 | 143929 | 92898 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 164095 | 164095 | 249920 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 358 Greenwich St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011181.16541 | 2120413.994 | 37.8028824034529 | -122.405499802075 | (37.8028824034529, -122.405499802075) | |||
| 181159 | 181159 | 224265 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 58 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 38 | 6002671.84671 | 2096513.9082400003 | 37.7367791753169 | -122.433237644116 | (37.7367791753169, -122.433237644116) |
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");