Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22043 | 22043 | 859 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6008091.178180001 | 2095049.40427 | 37.7330639095777 | -122.41439699202299 | (37.7330639095777, -122.414396992023) | |||
| 30672 | 30672 | 220054 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 300 Virginia Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6006920.61613 | 2098340.82095 | 37.742035584087795 | -122.418677274846 | (37.7420355840878, -122.418677274846) | |||
| 30832 | 30832 | 203666 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 123 Detroit St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5999405.93855 | 2093561.74161 | 37.728487406244604 | -122.44431719010001 | (37.7284874062446, -122.4443171901) | |||
| 49836 | 49836 | 103888 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5999371.6507 | 2110859.3099 | 37.775980347483504 | -122.44567914075701 | (37.7759803474835, -122.445679140757) | |||
| 53857 | 53857 | 220052 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 50 Coleridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006851.995619999 | 2099403.94647 | 37.7449508246175 | -122.418989930439 | (37.7449508246175, -122.418989930439) | |||
| 65727 | 65727 | 19285 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1998 12:00:00 AM | 11 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.43816511087601 | (37.786078645055, -122.438165110876) | ||
| 70197 | 70197 | 138347 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1770 SCOTT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001586.1357 | 2114554.9139 | 37.786253721877706 | -122.438283486898 | (37.7862537218777, -122.438283486898) | |||
| 78530 | 78530 | 42106 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 305 Hearst Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42409 | 5999382.77994639 | 2094344.80390055 | 37.730636191213996 | -122.444453504412 | (37.730636191214, -122.444453504412) | ||
| 81412 | 81412 | 39503 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Jersey St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.42999018002399 | (37.7508086831914, -122.429990180024) | ||
| 90886 | 90886 | 42110 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 100@ Detroit Judson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42411 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 103765 | 103765 | 75790 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2080 FOLSOM ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/15/1997 12:00:00 AM | 3x3 | 6008075.0 | 2106289.0 | 37.763924410887206 | -122.41524828442499 | (37.7639244108872, -122.415248284425) | |||
| 107521 | 107521 | 49582 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400REVISED Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | |||
| 107814 | 107814 | 23676 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 319 Virginia Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 12 | 6006936.2458165 | 2098250.5638735 | 37.741788638281996 | -122.418616833275 | (37.741788638282, -122.418616833275) | |||
| 107835 | 107835 | 32345 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | ||
| 112271 | 112271 | 50471 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3010X Lyon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 5 | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.798579545974704 | -122.446920252577 | (37.7985795459747, -122.446920252577) | |
| 140001 | 140001 | 50664 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Santa Ynez Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.723760552916296 | -122.43875382021002 | (37.7237605529163, -122.43875382021) | ||||
| 150574 | 150574 | 138352 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001715.4366 | 2114603.3734 | 37.78639413258121 | -122.437839612353 | (37.7863941325812, -122.437839612353) | |||
| 166995 | 166995 | 203640 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 216 Ralston St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 5992221.60329 | 2089317.4306299998 | 37.7164210557753 | -122.468844858002 | (37.7164210557753, -122.468844858002) | |||
| 184876 | 184876 | 203227 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1575 07th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5993976.11047 | 2104705.81134 | 37.7587749306244 | -122.463896818706 | (37.7587749306244, -122.463896818706) | |||
| 188982 | 188982 | 220022 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001965.3710900005 | 2100066.86744 | 37.746494668288996 | -122.435934385359 | (37.746494668289, -122.435934385359) |
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");