Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2984 | 2984 | 228440 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 451 Haight St | 1 | : 4 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 4 | Width 3ft | 6003980.50091 | 2109366.20592 | 37.7721427080557 | -122.42962941028401 | (37.7721427080557, -122.429629410284) | ||
| 3015 | 3015 | 244496 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 478 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 4 | Width 0ft | 6003878.5797 | 2109399.3843 | 37.7722280361906 | -122.429984331292 | (37.7722280361906, -122.429984331292) | ||
| 23307 | 23307 | 10286 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 412 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3x3 | 6004126.8809 | 2109434.3591 | 37.772338127403394 | -122.429127930043 | (37.7723381274034, -122.429127930043) | |||
| 24406 | 24406 | 228482 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 105 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006464.96947 | 2105462.2206200003 | 37.7615636518725 | -122.42075820894699 | (37.7615636518725, -122.420758208947) | |||
| 26787 | 26787 | 228493 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3748 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003428.54428 | 2103628.48028 | 37.7563570304699 | -122.431129066663 | (37.7563570304699, -122.431129066663) | |||
| 27192 | 27192 | 228497 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 487 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004262.22293 | 2106063.80962 | 37.7630910730105 | -122.428419488484 | (37.7630910730105, -122.428419488484) | |||
| 47551 | 47551 | 244231 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 576 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003405.9505 | 2109334.219 | 37.772022330462796 | -122.43161454270799 | (37.7720223304628, -122.431614542708) | |||
| 101599 | 101599 | 91194 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 412 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 4 | 3x3 | 6004119.82913 | 2109461.1016 | 37.7724111565911 | -122.42915422991999 | (37.7724111565911, -122.42915422992) | ||
| 130008 | 130008 | 95251 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 57 Avila St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767151 | 6001052.92994 | 2119937.28939 | 37.801001976825 | -122.440514414928 | (37.801001976825, -122.440514414928) | |
| 132848 | 132848 | 95250 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 57 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767151 | 6001050.95383 | 2119955.94053 | 37.8010530753849 | -122.440522591565 | (37.8010530753849, -122.440522591565) | |
| 147535 | 147535 | 129089 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6011405.84379 | 2120790.43469 | 37.8039285776094 | -122.40474881240601 | (37.8039285776094, -122.404748812406) | |||
| 153625 | 153625 | 244495 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 462 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003934.2301 | 2109407.8865 | 37.7722545326532 | -122.42979243828199 | (37.7722545326532, -122.429792438282) | |||
| 160550 | 160550 | 228458 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1332 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009514.46513 | 2101394.10676 | 37.7505649315368 | -122.409924021381 | (37.7505649315368, -122.409924021381) | |||
| 162506 | 162506 | 190651 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 501 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012696.96101 | 2105116.13755 | 37.760962664614 | -122.399179866755 | (37.760962664614, -122.399179866755) | |||
| 165619 | 165619 | 228447 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 365 Haight St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004400.01174 | 2109424.0096400003 | 37.7723251679145 | -122.428182407399 | (37.7723251679145, -122.428182407399) | |||
| 165639 | 165639 | 228444 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 399 Haight St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004268.91864 | 2109406.8209700002 | 37.772270553861496 | -122.428634644993 | (37.7722705538615, -122.428634644993) | |||
| 169717 | 169717 | 228491 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 544 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004217.2996 | 2105758.4451200003 | 37.762250072909104 | -122.428553095368 | (37.7622500729091, -122.428553095368) | |||
| 180413 | 180413 | 228448 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 353 Haight St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004452.39919 | 2109432.87501 | 37.7723524740195 | -122.42800182623002 | (37.7723524740195, -122.42800182623) | |||
| 183998 | 183998 | 228468 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 305 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004204.63343 | 2107110.4699 | 37.765961691906796 | -122.42869328709101 | (37.7659616919068, -122.428693287091) |
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");