Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4723 | 4723 | 253676 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 6 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x3.75 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 10097 | 10097 | 173851 | Permitted Site 1 | :: 54 | 450 Toland St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 27.75x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 39959 | 39959 | 141131 | Undocumented 2 | :: 54 | 1760 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002332.7569 | 2113004.3119 | 37.7820385992621 | -122.435589403585 | (37.7820385992621, -122.435589403585) | |||
| 48113 | 48113 | 185273 | Undocumented 2 | :: 54 | 2601 Sunset Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985037.6088 | 2097007.6084 | 37.7371186003252 | -122.494242407159 | (37.7371186003252, -122.494242407159) | |||
| 48404 | 48404 | 141143 | Undocumented 2 | :: 54 | 2011 Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001931.7546 | 2113588.2444 | 37.783619145517896 | -122.43701850487301 | (37.7836191455179, -122.437018504873) | |||
| 54373 | 54373 | 246202 | Undocumented 2 | :: 54 | 737 Buena Vista Ave West | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999863.7722 | 2107959.3261 | 37.7680458100097 | -122.443768378658 | (37.7680458100097, -122.443768378658) | |||
| 65435 | 65435 | 183890 | Undocumented 2 | :: 54 | 1390 Quintara St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988977.7676 | 2101017.0459 | 37.748357251925604 | -122.480913117409 | (37.7483572519256, -122.480913117409) | |||
| 69387 | 69387 | 139039 | Undocumented 2 | :: 54 | 1501 BRODERICK ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000650.9974 | 2113849.5584 | 37.7842637658196 | -122.441468180362 | (37.7842637658196, -122.441468180362) | |||
| 78523 | 78523 | 108805 | Undocumented 2 | :: 54 | 401-499 University St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008323.152369999 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | |||||
| 79036 | 79036 | 116326 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 84777 | 84777 | 116279 | Undocumented 2 | :: 54 | 700X Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 91200 | 91200 | 33411 | Permitted Site 1 | :: 54 | 100 Ulloa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
| 95556 | 95556 | 104158 | Permitted Site 1 | :: 54 | 525X Church St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 96655 | 96655 | 105086 | Significant Tree 6 | :: 54 | 344 Fulton St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 106237 | 106237 | 115066 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 120303 | 120303 | 114621 | Undocumented 2 | :: 54 | 2400X Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
| 138812 | 138812 | 108798 | Undocumented 2 | :: 54 | 501-599 University St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |||||
| 139188 | 139188 | 108993 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
| 145400 | 145400 | 116946 | Undocumented 2 | :: 54 | 3676 23RD ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005238.0 | 2102584.0 | 37.753591501312705 | -122.424797029407 | (37.7535915013127, -122.424797029407) | ||||
| 147382 | 147382 | 185840 | Undocumented 2 | :: 54 | 2000 35th Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985426.2822 | 2101257.1323 | 37.7488093846788 | -122.493211576533 | (37.7488093846788, -122.493211576533) | |||
| 158360 | 158360 | 137787 | Undocumented 2 | :: 54 | 2190 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999114.5715 | 2111518.024 | 37.7777743262559 | -122.44661584556101 | (37.7777743262559, -122.446615845561) | |||
| 159669 | 159669 | 137910 | Undocumented 2 | :: 54 | 1911 Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004805.9953 | 2115383.078 | 37.78871026126421 | -122.427202616598 | (37.7887102612642, -122.427202616598) | |||
| 175934 | 175934 | 140091 | Undocumented 2 | :: 54 | 1250 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001831.6388 | 2112795.421 | 37.781436562836106 | -122.43730807844801 | (37.7814365628361, -122.437308078448) |
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");