Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3953 | 3953 | 44431 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 859 Prague St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2017 11:19:00 AM | 3 | Permit Number 43768 | 6002228.37284 | 2086951.06128 | 37.71049657842789 | -122.434087529513 | (37.7104965784279, -122.434087529513) | |
| 10216 | 10216 | 173911 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | ||||
| 36133 | 36133 | 223495 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007975.84228 | 2103064.94118 | 37.75506631266121 | -122.41536298621901 | (37.7550663126612, -122.415362986219) | |||
| 61972 | 61972 | 223430 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 357 Precita Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008988.98291 | 2100229.74181 | 37.7473383798694 | -122.411658926928 | (37.7473383798694, -122.411658926928) | |||
| 79218 | 79218 | 99026 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351X 23rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | Permit Number 41415 | 6006571.0 | 2102346.4 | 37.753014305467794 | -122.420170352411 | (37.7530143054678, -122.420170352411) | |
| 84121 | 84121 | 117143 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 88901 | 88901 | 52808 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 25@ TEXAS Sierra St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | |||
| 98549 | 98549 | 99034 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 200X Bartlett St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6006692.0 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | ||
| 99849 | 99849 | 46991 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 102788 | 102788 | 6738 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2016 12:00:00 AM | 1 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 106339 | 106339 | 102645 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1800 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/2015 12:33:00 PM | 3 | 3x3 | 6013980.4 | 2096382.2 | 37.7370525675082 | -122.394129514082 | (37.7370525675082, -122.394129514082) | ||
| 117343 | 117343 | 98974 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
| 118877 | 118877 | 35079 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 129837 | 129837 | 94755 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010386.24454 | 2097752.48777 | 37.740614659735705 | -122.40665272486 | (37.7406146597357, -122.40665272486) | ||
| 138101 | 138101 | 223649 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1812 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008605.946830001 | 2107884.1672900002 | 37.768334196103794 | -122.413524717993 | (37.7683341961038, -122.413524717993) | |||
| 138966 | 138966 | 103921 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 149946 | 149946 | 207644 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 Funston Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992160.10563 | 2104906.0361 | 37.7592198747043 | -122.470191922822 | (37.7592198747043, -122.470191922822) | |||
| 156025 | 156025 | 223510 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 23rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006653.24947 | 2102596.28503 | 37.7537050664578 | -122.419903647955 | (37.7537050664578, -122.419903647955) | |||
| 158063 | 158063 | 224110 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006506.1757 | 2109285.6019900003 | 37.7720640758221 | -122.42088715194599 | (37.7720640758221, -122.420887151946) | |||
| 182754 | 182754 | 223635 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006712.94406 | 2102318.00043 | 37.752944323627204 | -122.41967746664 | (37.7529443236272, -122.41967746664) |
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");