Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4142 | 4142 | 216723 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 08:05:00 AM | 3 | Width 2ft | 5995305.86266 | 2090248.9874099998 | 37.7191565973781 | -122.458251599737 | (37.7191565973781, -122.458251599737) | ||
| 4276 | 4276 | 180842 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 87 Laura St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:54:00 PM | 3 | Width 2ft | 5997291.8877 | 2087045.22216 | 37.710473721248 | -122.45115578601299 | (37.710473721248, -122.451155786013) | ||
| 4375 | 4375 | 176488 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 295 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 09:25:00 AM | 3 | Width 2ft | 6004452.7164199995 | 2090718.28415 | 37.7209665468512 | -122.4266678079 | (37.7209665468512, -122.4266678079) | ||
| 4432 | 4432 | 172375 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 216 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 07:37:00 AM | 3 | Width 2ft | 6002574.0 | 2086750.0 | 37.7099641176609 | -122.432878614235 | (37.7099641176609, -122.432878614235) | ||
| 26506 | 26506 | 191237 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014127.4828 | 2095367.51286 | 37.7342746191851 | -122.39354998485001 | (37.7342746191851, -122.39354998485) | |||
| 35687 | 35687 | 191236 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014135.07988 | 2095376.9884099998 | 37.734301059229104 | -122.39352438203998 | (37.7343010592291, -122.39352438204) | |||
| 37096 | 37096 | 207011 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 16 Circular Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001351.22893 | 2094512.68179 | 37.731209264673296 | -122.437660309391 | (37.7312092646733, -122.437660309391) | |||
| 37870 | 37870 | 247053 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 507 Valley St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6002585.442419999 | 2099146.1836099997 | 37.744001891474 | -122.43372445791599 | (37.744001891474, -122.433724457916) | |||
| 41022 | 41022 | 191235 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014141.54444 | 2095385.83675 | 37.7343257141509 | -122.393502650848 | (37.7343257141509, -122.393502650848) | |||
| 50864 | 50864 | 191241 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014082.94285 | 2095307.88657 | 37.7341084226719 | -122.39369980292601 | (37.7341084226719, -122.393699802926) | |||
| 58507 | 58507 | 191240 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014102.75792 | 2095335.27393 | 37.734184723832996 | -122.393633211698 | (37.734184723833, -122.393633211698) | |||
| 72347 | 72347 | 191244 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014050.660540001 | 2095263.98772 | 37.733986091481206 | -122.39380834209801 | (37.7339860914812, -122.393808342098) | |||
| 72880 | 72880 | 248155 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 235 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010048.23979 | 2099492.4434599997 | 37.7453732829604 | -122.40794409015 | (37.7453732829604, -122.40794409015) | |||
| 134827 | 134827 | 206996 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1607 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993365.5475 | 2104527.17443 | 37.758249235518605 | -122.465995428957 | (37.7582492355186, -122.465995428957) | |||
| 135130 | 135130 | 207012 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 16 Circular Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001339.26796 | 2094505.8060299999 | 37.731189705325 | -122.43770116826799 | (37.731189705325, -122.437701168268) | |||
| 152707 | 152707 | 191242 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014072.32553 | 2095292.84785 | 37.734066539429996 | -122.39373545834299 | (37.73406653943, -122.393735458343) | |||
| 153555 | 153555 | 207048 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 658 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5997718.79866 | 2095007.66028 | 37.7323611532403 | -122.450253874818 | (37.7323611532403, -122.450253874818) | |||
| 159032 | 159032 | 191243 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014061.56884 | 2095278.41625 | 37.734026315459104 | -122.39377163804899 | (37.7340263154591, -122.393771638049) |
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");