Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7597 | 7597 | 98002 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1904 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x12 | 6003787.47736 | 2119037.49851 | 37.7986867144679 | -122.430987461215 | (37.7986867144679, -122.430987461215) | |||
| 28361 | 28361 | 214344 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 498 Vernon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5992505.71978 | 2091140.82125 | 37.7214440535804 | -122.467995374584 | (37.7214440535804, -122.467995374584) | |||
| 28940 | 28940 | 237901 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 185 Graystone Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999340.2051099995 | 2104037.6986700003 | 37.7572481219159 | -122.44529733780399 | (37.7572481219159, -122.445297337804) | |||
| 32055 | 32055 | 116119 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1649x Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2x2 | 6014063.167280001 | 2095217.05774 | 37.7338579263887 | -122.393761818374 | (37.7338579263887, -122.393761818374) | |||
| 37189 | 37189 | 196334 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 185 Hampshire St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 5ft | 6010020.7902 | 2107448.7072099997 | 37.767217864928206 | -122.408600163592 | (37.7672178649282, -122.408600163592) | |||
| 38247 | 38247 | 237913 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 256 Bemis St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6003021.95871 | 2096302.8591099998 | 37.736219537998 | -122.432012088491 | (37.736219537998, -122.432012088491) | ||||
| 58805 | 58805 | 237927 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 4780 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999842.984730001 | 2104684.3807599996 | 37.75905243893521 | -122.44360498998999 | (37.7590524389352, -122.44360498999) | |||
| 59899 | 59899 | 237911 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 414 Collingwood St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002101.71196 | 2103425.3535700003 | 37.7557240165608 | -122.435703175975 | (37.7557240165608, -122.435703175975) | ||||
| 62421 | 62421 | 214311 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1616 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 6ft | 5993417.73262 | 2104465.9003 | 37.7580840030825 | -122.46581049954901 | (37.7580840030825, -122.465810499549) | |||
| 135434 | 135434 | 214312 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1616 09th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 6ft | 5993417.09067 | 2104452.78428 | 37.758047952866605 | -122.465811766705 | (37.7580479528666, -122.465811766705) | |||
| 155130 | 155130 | 237898 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1087 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009471.98593 | 2102823.41576 | 37.754487114207 | -122.41017181789101 | (37.754487114207, -122.410171817891) | |||
| 155167 | 155167 | 214341 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 144 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995498.01894 | 2089341.3443900002 | 37.7166754640834 | -122.457521759431 | (37.7166754640834, -122.457521759431) | |||
| 159793 | 159793 | 58839 | Permitted Site 1 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 2385 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1979 12:00:00 AM | 8 | Permit Number 18096 | 6002233.54572 | 2117374.3754 | 37.7940320393926 | -122.43624546807699 | (37.7940320393926, -122.436245468077) | ||
| 171890 | 171890 | 196322 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 320 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6014284.29861 | 2105571.05325 | 37.7623000976946 | -122.393721759867 | (37.7623000976946, -122.393721759867) | |||
| 174855 | 174855 | 196321 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1018 Pennsylvania Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 6ft | 6014465.23121 | 2102394.5848 | 37.753588252598796 | -122.392873735151 | (37.7535882525988, -122.392873735151) | |||
| 180799 | 180799 | 135866 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 200 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999037.7073 | 2115878.6146 | 37.7897429809958 | -122.447195652882 | (37.7897429809958, -122.447195652882) | |||
| 186903 | 186903 | 214342 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 331 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5996752.352000001 | 2089647.99235 | 37.7175894189894 | -122.45320830242599 | (37.7175894189894, -122.453208302426) |
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");