Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, qCaretaker, PlantDate, DBH, PermitNotes, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2760 | 2760 | 251575 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 300 Sussex St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 08/02/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780395 | 6001194.0 | 2096647.0 | 37.737060666835205 | -122.438356728037 | (37.7370606668352, -122.438356728037) | |
| 11147 | 11147 | 83378 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 586 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52310 | 6003277.11077 | 2089949.83191 | 37.718790012118795 | -122.430676716663 | (37.7187900121188, -122.430676716663) | |
| 13306 | 13306 | 187657 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2072 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5991666.0 | 2101424.0 | 37.7496305363998 | -122.47164701446 | (37.7496305363998, -122.47164701446) | ||||
| 13307 | 13307 | 187654 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 375 Woodside Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5997267.0 | 2099886.0 | 37.7457300260474 | -122.452167701039 | (37.7457300260474, -122.452167701039) | ||||
| 83336 | 83336 | 91234 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 829 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52047: Correct address is 829: Replanted w/ Birch | 5988302.4 | 2089565.8 | 37.7168758094884 | -122.482409573013 | (37.7168758094884, -122.482409573013) | ||
| 87288 | 87288 | 62853 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 148 Banks St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/12/2008 12:00:00 AM | 3x3 | Permit Number 50260 | 6008633.00401989 | 2097879.43631783 | 37.7408649848181 | -122.412723750897 | (37.7408649848181, -122.412723750897) | ||
| 89093 | 89093 | 116527 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5732 GEARY BLVD | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | MTA 6 | DPW for City Agency 2 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 94497 | 94497 | 117289 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 26X GLADEVIEW WAY | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5997876.0 | 2101605.0 | 37.7504848455829 | -122.45018576131201 | (37.7504848455829, -122.450185761312) | ||||
| 99467 | 99467 | 117094 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2X 09TH AVE | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | |||
| 99765 | 99765 | 115276 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 598X PORTOLA DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5997411.0 | 2099824.0 | 37.74556803712711 | -122.451665301061 | (37.7455680371271, -122.451665301061) | ||||
| 101496 | 101496 | 117093 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 2X 09TH AVE | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | |||
| 102296 | 102296 | 117095 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 2X 09TH AVE | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | |||
| 110058 | 110058 | 91138 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 166 Kensington Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | Permit Number 52026 | 5994670.3 | 2098755.2 | 37.742476040106396 | -122.46106469780199 | (37.7424760401064, -122.461064697802) | |||
| 110349 | 110349 | 91139 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 166 Kensington Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | Permit Number 52026 | 5994670.3 | 2098755.2 | 37.742476040106396 | -122.46106469780199 | (37.7424760401064, -122.461064697802) | |||
| 112514 | 112514 | 41178 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1636 Beach St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/12/2008 12:00:00 AM | 3x3 | Permit Number 50261 | 6002352.98833886 | 2121268.85344667 | 37.80473204272371 | -122.436111004538 | (37.8047320427237, -122.436111004538) | ||
| 112750 | 112750 | 115527 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 25 FRANCONIA ST | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 3x3 | 6010006.0 | 2099954.0 | 37.746638251201404 | -122.408122694659 | (37.7466382512014, -122.408122694659) | |||
| 114274 | 114274 | 110143 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1130X PORTOLA DR | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 3x3 | 5994964.0 | 2098019.0 | 37.7404715144277 | -122.459995857341 | (37.7404715144277, -122.459995857341) | ||||
| 119453 | 119453 | 111088 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 136 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 45 | 3x3 | Permit Number 775596 | 5990091.0 | 2089770.0 | 37.71754037603979 | -122.476242228391 | (37.7175403760398, -122.476242228391) | |
| 121416 | 121416 | 117090 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2X 09TH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | |||
| 124442 | 124442 | 111071 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1908 15TH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5991632.0 | 2102414.0 | 37.7523468518329 | -122.471836728689 | (37.7523468518329, -122.471836728689) | ||||
| 125197 | 125197 | 110465 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1485 FAIRFAX AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 9 | 3x3 | 6016296.0 | 2097688.0 | 37.7407664622153 | -122.38621437638201 | (37.7407664622153, -122.386214376382) | |||
| 128744 | 128744 | 122536 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 199x Coso Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 3x3 | 6007478.0 | 2099565.0 | 37.7454282725128 | -122.41683672388399 | (37.7454282725128, -122.416836723884) | |||
| 140943 | 140943 | 120977 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 794x Gates St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3030 | 3x3 | 6008103.0 | 2095407.0 | 37.7340464539486 | -122.414381414226 | (37.7340464539486, -122.414381414226) | |||
| 141430 | 141430 | 117091 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2X 09TH AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | |||
| 142813 | 142813 | 117092 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2X 09TH AVE | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) |
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");