Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25082 | 25082 | 240367 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 43 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997045.58025 | 2106312.21394 | 37.763362115200295 | -122.45339721491399 | (37.7633621152003, -122.453397214914) | |||
| 33157 | 33157 | 136297 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 1471 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007665.12866 | 2117142.06871 | 37.793701289428604 | -122.417435114148 | (37.7937012894286, -122.417435114148) | |||
| 52785 | 52785 | 139273 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 765 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004208.0444 | 2111479.3585 | 37.777957788247704 | -122.428993006008 | (37.7779577882477, -122.428993006008) | |||
| 54339 | 54339 | 124596 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 3999 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5995621.5881199995 | 2115140.66957 | 37.7875210010639 | -122.458961562411 | (37.7875210010639, -122.458961562411) | |||
| 54998 | 54998 | 240368 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 55 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997060.67774 | 2106228.7303 | 37.7631337557456 | -122.453338970317 | (37.7631337557456, -122.453338970317) | |||
| 60315 | 60315 | 61983 | Permitted Site 1 | Quillaja saponaria :: Chilean Soapbark 343 | 3154 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1985 12:00:00 AM | 4 | Permit Number 22050 | 6004222.7109199995 | 2120056.9871900002 | 37.801510618969104 | -122.429554160418 | (37.8015106189691, -122.429554160418) | |
| 62086 | 62086 | 240369 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 924 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997240.50236 | 2107274.95853 | 37.7660167375967 | -122.452792537768 | (37.7660167375967, -122.452792537768) | |||
| 67280 | 67280 | 249976 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 21 Napier Ln | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 6011642.19943 | 2120231.20207 | 37.8024062690918 | -122.403891507608 | (37.8024062690918, -122.403891507608) | |||
| 69077 | 69077 | 124597 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 3999 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5995606.88973 | 2115137.96045 | 37.78751271763029 | -122.45901221931999 | (37.7875127176303, -122.45901221932) | |||
| 82759 | 82759 | 51841 | Permitted Site 1 | Quillaja saponaria :: Chilean Soapbark 343 | 43 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50868 | 5997036.87173308 | 2106364.06035903 | 37.763503973090295 | -122.453431078199 | (37.7635039730903, -122.453431078199) | ||
| 87554 | 87554 | 108913 | Permitted Site 1 | Quillaja saponaria :: Chilean Soapbark 343 | 170 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773176 | 6005928.5 | 2096596.4 | 37.7371898878165 | -122.42198381060699 | (37.7371898878165, -122.421983810607) |
| 98844 | 98844 | 4508 | DPW Maintained 3 | Quillaja saponaria :: Chilean Soapbark 343 | 150X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 5995548.81365 | 2115103.97639 | 37.787416067917796 | -122.45921068768699 | (37.7874160679178, -122.459210687687) | |||
| 100856 | 100856 | 14543 | DPW Maintained 3 | Quillaja saponaria :: Chilean Soapbark 343 | 736 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999282.2180699995 | 2110225.9006 | 37.7742360610429 | -122.44594294328002 | (37.7742360610429, -122.44594294328) | |||
| 129345 | 129345 | 107666 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 140 STRATFORD DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 3 | Permit Number 774157 | 5990881.4 | 2091504.3 | 37.722348139716296 | -122.473636645054 | (37.7223481397163, -122.473636645054) | ||
| 129833 | 129833 | 139270 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 775 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004128.3145 | 2111467.9685 | 37.7779220007662 | -122.429268007542 | (37.7779220007662, -122.429268007542) | |||
| 135947 | 135947 | 240366 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 170 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005928.4079599995 | 2096616.55927 | 37.7372452354804 | -122.42198556048099 | (37.7372452354804, -122.421985560481) | |||
| 142930 | 142930 | 122459 | Permitted Site 1 | Quillaja saponaria :: Chilean Soapbark 343 | 1351 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | ||||
| 150844 | 150844 | 136296 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 25 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001770.3759699995 | 2121234.42741 | 37.8046044010407 | -122.43812472200199 | (37.8046044010407, -122.438124722002) | |||
| 159304 | 159304 | 240370 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 205 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997691.57416 | 2106447.88941 | 37.7637716529741 | -122.451172728342 | (37.7637716529741, -122.451172728342) | |||
| 168073 | 168073 | 136298 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 902 Vallejo St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6009157.405619999 | 2118748.49482 | 37.7981959904135 | -122.412385286869 | (37.7981959904135, -122.412385286869) | |||
| 168803 | 168803 | 249975 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 21 Napier Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 6011642.325669999 | 2120237.40655 | 37.8024233121334 | -122.403891507612 | (37.8024233121334, -122.403891507612) | |||
| 177213 | 177213 | 249977 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 21 Napier Ln | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 6011643.6544699995 | 2120226.12946 | 37.8023924222307 | -122.403886115262 | (37.8023924222307, -122.403886115262) |
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");