Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, PlantDate, DBH, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16411 | 16411 | 27537 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016137.088719999 | 2102884.43561 | 37.755026000570105 | -122.38712619673599 | (37.7550260005701, -122.387126196736) | ||
16646 | 16646 | 27538 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 15 | 3X3 | 6016138.60969 | 2102846.2663 | 37.7549212799101 | -122.38711827459998 | (37.7549212799101, -122.3871182746) | ||
22321 | 22321 | 3630 | Private 5 | Melaleuca quinquenervia :: Cajeput 50 | 100X Cargo Way | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017698.24794 | 2098446.68655 | 37.7429271764597 | -122.381418626885 | (37.7429271764597, -122.381418626885) | |||
65718 | 65718 | 27548 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1301X Illinois St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/05/2001 12:00:00 AM | 8 | 3X3 | 6016173.411126 | 2103023.95301 | 37.755411097271704 | -122.387010312465 | (37.7554110972717, -122.387010312465) | ||
76132 | 76132 | 27559 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
78499 | 78499 | 27578 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/12/2003 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
93692 | 93692 | 27580 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/12/2003 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
95538 | 95538 | 27564 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
96480 | 96480 | 27535 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/05/2001 12:00:00 AM | 15 | 3X3 | 6016127.146980001 | 2102787.87807 | 37.754760323366206 | -122.38715384385 | (37.7547603233662, -122.38715384385) | ||
96943 | 96943 | 27557 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
97959 | 97959 | 27560 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
100667 | 100667 | 27576 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/12/2003 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
102773 | 102773 | 27540 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/24/2004 12:00:00 AM | 15 | 3X3 | 6016127.146980001 | 2102787.87807 | 37.754760323366206 | -122.38715384385 | (37.7547603233662, -122.38715384385) | ||
102836 | 102836 | 27575 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/12/2003 12:00:00 AM | 12 | 3x3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
103651 | 103651 | 27572 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/12/2003 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
106917 | 106917 | 27562 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
107131 | 107131 | 27549 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1301X Illinois St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/05/2001 12:00:00 AM | 10 | 3X3 | 6016173.411126 | 2103023.95301 | 37.755411097271704 | -122.387010312465 | (37.7554110972717, -122.387010312465) | ||
110177 | 110177 | 27543 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1301X Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016173.411126 | 2103023.95301 | 37.755411097271704 | -122.387010312465 | (37.7554110972717, -122.387010312465) | ||
110311 | 110311 | 27555 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
113199 | 113199 | 27567 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
115540 | 115540 | 27577 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/12/2003 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
116049 | 116049 | 27565 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
116444 | 116444 | 27544 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1301X Illinois St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016173.411126 | 2103023.95301 | 37.755411097271704 | -122.387010312465 | (37.7554110972717, -122.387010312465) | ||
118360 | 118360 | 27579 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/12/2003 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
123397 | 123397 | 27568 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
125005 | 125005 | 27552 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
125497 | 125497 | 27561 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/12/2003 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
126682 | 126682 | 27563 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
145710 | 145710 | 27554 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) |
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");