Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2743 | 2743 | 1163 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 2849X Alemany Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5997232.586019999 | 2087721.56451 | 37.7123274065466 | -122.451409493752 | (37.7123274065466, -122.451409493752) | ||
| 2745 | 2745 | 1164 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 2849X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5997509.5346800005 | 2087964.66518 | 37.7130107600005 | -122.450469794845 | (37.7130107600005, -122.450469794845) | ||
| 10901 | 10901 | 1162 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 2849X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5997216.55451 | 2087707.3234400002 | 37.7122873858304 | -122.451463876663 | (37.7122873858304, -122.451463876663) | ||
| 11470 | 11470 | 1268 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 3995X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3X3 | 5992221.4773699995 | 2087241.7214099998 | 37.7107216517569 | -122.468694342994 | (37.7107216517569, -122.468694342994) | ||
| 11698 | 11698 | 1252 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 3802X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X5 | 5992874.60396 | 2087610.17758 | 37.7117710535519 | -122.46646377159401 | (37.7117710535519, -122.466463771594) | |||
| 12877 | 12877 | 1237 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 3702X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 25 | 3X5 | 5993171.03745 | 2087640.69975 | 37.7118719610995 | -122.465441440287 | (37.7118719610995, -122.465441440287) | ||
| 12928 | 12928 | 1172 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 2900 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5996885.41862 | 2087511.8997099998 | 37.7117318296412 | -122.45259428042 | (37.7117318296412, -122.45259428042) | ||
| 13390 | 13390 | 19368 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 352-360 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 54655 | 6011200.48284 | 2111246.22274 | 37.7777109702346 | -122.40478714063299 | (37.7777109702346, -122.404787140633) | |
| 13411 | 13411 | 86613 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 1060 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010229.125990001 | 2109123.9963599998 | 37.7718294894697 | -122.40799771313601 | (37.7718294894697, -122.407997713136) | ||
| 13655 | 13655 | 86615 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 1090 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/03/2011 12:00:00 AM | 3 | 3x3 | 6010138.02723 | 2109041.45906 | 37.7715977602665 | -122.40830700887 | (37.7715977602665, -122.40830700887) | ||
| 13769 | 13769 | 85678 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 750 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012220.56503 | 2111028.15837 | 37.777169179061104 | -122.40124297808501 | (37.7771691790611, -122.401242978085) | ||
| 13830 | 13830 | 85692 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 598 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013183.76112 | 2111957.2599 | 37.7797739691436 | -122.397976147576 | (37.7797739691436, -122.397976147576) | ||
| 14109 | 14109 | 85683 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 660 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012787.21783 | 2111572.91246 | 37.7786965462587 | -122.39932098479099 | (37.7786965462587, -122.399320984791) | ||
| 14118 | 14118 | 85688 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 510 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013697.52765 | 2112441.63878 | 37.7811325632525 | -122.396232748844 | (37.7811325632525, -122.396232748844) | ||
| 14169 | 14169 | 85694 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 474 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013953.88261 | 2112679.45572 | 37.7817998152473 | -122.39536254686001 | (37.7817998152473, -122.39536254686) | ||
| 14208 | 14208 | 85682 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 660 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012794.814730001 | 2111581.55636 | 37.778720703824604 | -122.39929531095 | (37.7787207038246, -122.39929531095) | ||
| 14743 | 14743 | 85681 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 660 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012801.64822 | 2111587.40032 | 37.7787371308451 | -122.39927208143801 | (37.7787371308451, -122.399272081438) | ||
| 14982 | 14982 | 86620 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 1000x Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010457.56671 | 2109345.4237900004 | 37.772450265390795 | -122.407223128867 | (37.7724502653908, -122.407223128867) | ||
| 15462 | 15462 | 85684 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 660 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012659.22444 | 2111448.1134 | 37.7783467423358 | -122.399755001218 | (37.7783467423358, -122.399755001218) | ||
| 15929 | 15929 | 85680 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 600 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012945.936430001 | 2111731.57619 | 37.7791410451674 | -122.398783049916 | (37.7791410451674, -122.398783049916) | ||
| 16091 | 16091 | 85690 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 570 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/2011 12:00:00 AM | 3 | 3x3 | 6013313.890430001 | 2112083.07139 | 37.780126665260795 | -122.39753479629 | (37.7801266652608, -122.39753479629) | ||
| 16175 | 16175 | 86618 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 1090 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010101.61266 | 2109009.68223 | 37.7715084692605 | -122.40843072772101 | (37.7715084692605, -122.408430727721) | ||
| 16293 | 16293 | 85677 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 750 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012237.71739 | 2111051.30981 | 37.7772337045105 | -122.401185269499 | (37.7772337045105, -122.401185269499) | ||
| 19836 | 19836 | 1214 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 3435 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993805.15459 | 2087379.06858 | 37.7111901355994 | -122.463230798779 | (37.7111901355994, -122.463230798779) | ||
| 20306 | 20306 | 4842 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 144 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2003 12:00:00 AM | 3 | 4X4 | 6006504.57355 | 2097544.92188 | 37.7398267906861 | -122.420059351163 | (37.7398267906861, -122.420059351163) | ||
| 41171 | 41171 | 1251 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 3802X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3X5 | 5992934.9168 | 2087623.17149 | 37.7118102118326 | -122.466256259321 | (37.7118102118326, -122.466256259321) | ||
| 68226 | 68226 | 113035 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 251 06th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 1 | 3x3 | 5993975.80165 | 2113783.25834 | 37.7836991768592 | -122.464557007516 | (37.7836991768592, -122.464557007516) | |||
| 104647 | 104647 | 107423 | DPW Maintained 3 | Acer buergeranum :: Trident Maple 120 | 251 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 2 | 3x3 | 5993968.46376 | 2113916.3836 | 37.7840642796834 | -122.46459206338498 | (37.7840642796834, -122.464592063385) |
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");