Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▲ | qLegalStatus | qSpecies | qAddress | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PermitNotes |
|---|---|---|---|---|---|---|---|---|---|
| 189144 | 189144 | 3 | 60 | 349X Cargo Way | 1 | 1 | 2 | ||
| 189143 | 189143 | 2 | 41 | 1800 PINE ST | 1 | 1 | 1 | ||
| 189142 | 189142 | 2 | 25 | 444 FRANCISCO ST | 1 | 1 | 1 | ||
| 189141 | 189141 | 2 | 75 | 1000 03rd St | 1 | 1 | 1 | ||
| 189140 | 189140 | 2 | 135 | 876 Treat Ave | 1 | 1 | 1 | ||
| 189139 | 189139 | 2 | 26 | 92 Frederick St | 1 | 1 | 1 | ||
| 189138 | 189138 | 2 | 1 | 90 Gold Mine Dr | 1 | 1 | 1 | ||
| 189137 | 189137 | 2 | 16 | 365 Corbett Ave | 1 | 1 | 1 | ||
| 189136 | 189136 | 2 | 235 | 430 Lansdale Ave | 1 | 1 | 1 | ||
| 189135 | 189135 | 2 | 15 | 201 Market St | 1 | 1 | 1 | ||
| 189134 | 189134 | 2 | 73 | 70 Douglass St | 1 | 1 | 1 | ||
| 189133 | 189133 | 2 | 106 | 439 Hill St | 1 | 1 | 1 | ||
| 189132 | 189132 | 2 | 32 | 351 Hayes St | 1 | 1 | 1 | ||
| 189131 | 189131 | 2 | 1 | 1750 MCALLISTER ST | 1 | 1 | 1 | ||
| 189130 | 189130 | 2 | 30 | 1193 Shotwell St | 1 | 1 | 1 | ||
| 189129 | 189129 | 2 | 62 | 2537 Kirkham St | 1 | 1 | 1 | ||
| 189128 | 189128 | 2 | 19 | 103 Bowdoin St | 9 | 1 | 1 | ||
| 189127 | 189127 | 2 | 41 | 3640 Lyon St | 9 | 1 | 1 | ||
| 189126 | 189126 | 2 | 37 | 1400 Revere Ave | 1 | 1 | 1 | 1 | |
| 189125 | 189125 | 2 | 22 | 1986 15th St | 1 | 1 | 1 | ||
| 189124 | 189124 | 2 | 31 | 299 Lathrop Ave | 1 | 1 | 1 | ||
| 189123 | 189123 | 1 | 30 | 2029-22031 Beach St | 1 | 1 | 1 | Permit Number 50833 | |
| 189122 | 189122 | 2 | 12 | 2690 Ocean Ave | 4 | 1 | 1 | ||
| 189121 | 189121 | 2 | 35 | 45 Dorantes Ave | 2 | 1 | 1 | ||
| 189120 | 189120 | 1 | 1 | 2941 Washington St | 1 | 1 | 1 | Permit Number 775039 | |
| 189119 | 189119 | 2 | 83 | 193 Rhode Island St | 1 | 1 | 1 | ||
| 189118 | 189118 | 2 | 15 | 2410 Scott St | 1 | 1 | 1 | ||
| 189117 | 189117 | 2 | 135 | 1479 16th Ave | 2 | 1 | 1 | ||
| 189116 | 189116 | 2 | 323 | 190 Irwin St | 1 | 1 | 1 | ||
| 189115 | 189115 | 1 | 18 | 2517@ SCOTT Broadway | 1 | 1 | 1 | 1 | Permit Number 49029 |
| 189114 | 189114 | 2 | 44 | 148 Banks St | 1 | 1 | 1 | ||
| 189113 | 189113 | 2 | 5 | 574 11th Ave | 9 | 1 | 1 | ||
| 189112 | 189112 | 2 | 350 | 2211 25th St | 9 | 1 | 1 | ||
| 189111 | 189111 | 2 | 48 | 3651 20th St | 1 | 1 | 1 | ||
| 189110 | 189110 | 2 | 59 | 20 Orben Pl | 1 | 1 | 1 | ||
| 189109 | 189109 | 2 | 28 | 902 Noe St | 1 | 1 | 1 | ||
| 189108 | 189108 | 2 | 83 | 1490 Harrison St | 1 | 1 | 1 | ||
| 189107 | 189107 | 2 | 1 | 851 48th Ave | 1 | 1 | 1 | ||
| 189106 | 189106 | 2 | 142 | 99 Albion St | 1 | 1 | 1 | ||
| 189105 | 189105 | 2 | 15 | 443 Valencia St | 1 | 1 | 1 | ||
| 189104 | 189104 | 2 | 131 | 900 Pennsylvania Ave | 1 | 1 | 1 | ||
| 189103 | 189103 | 1 | 75 | 108 Palm Ave | 1 | 1 | 1 | ||
| 189102 | 189102 | 2 | 15 | 3050 22nd St | 1 | 1 | 1 | ||
| 189101 | 189101 | 2 | 11 | 700 Junipero Serra Blvd | 4 | 1 | 1 | ||
| 189100 | 189100 | 2 | 59 | 1486 Waller St | 1 | 1 | 1 | ||
| 189099 | 189099 | 2 | 22 | 1472 16th Ave | 9 | 1 | 1 | ||
| 189098 | 189098 | 2 | 12 | 500 Joost Ave | 1 | 1 | 1 | ||
| 189097 | 189097 | 2 | 28 | 33 Sotelo Ave | 2 | 1 | 1 | ||
| 189096 | 189096 | 2 | 16 | 1950 17th Ave | 1 | 1 | 1 | ||
| 189095 | 189095 | 1 | 2 | 745 Polk St | 1 | 1 | 1 | Permit Number 52540 | |
| 189094 | 189094 | 3 | 109 | 900x Guerrero St | 11 | 1 | 2 | ||
| 189093 | 189093 | 2 | 138 | 2593 23rd Ave | 1 | 1 | 1 | ||
| 189092 | 189092 | 2 | 59 | 2133 UNION ST | 1 | 1 | 1 | ||
| 189091 | 189091 | 1 | 138 | 340 Brannan St | 1 | 1 | 1 | ||
| 189090 | 189090 | 2 | 18 | 68 Douglass St | 1 | 1 | 1 | ||
| 189089 | 189089 | 2 | 2 | 3840 Balboa St | 1 | 1 | 1 | ||
| 189088 | 189088 | 1 | 12 | 2643 45th Ave | 1 | 1 | 1 | 1 | Permit Number 52835 |
| 189087 | 189087 | 2 | 60 | 300 Lake St | 1 | 1 | 1 | ||
| 189086 | 189086 | 2 | 12 | 203 Darien Way | 1 | 1 | 1 | ||
| 189085 | 189085 | 2 | 27 | 1535 BRODERICK ST | 1 | 1 | 1 | ||
| 189084 | 189084 | 2 | 44 | 3388 22nd St | 1 | 1 | 1 | ||
| 189083 | 189083 | 2 | 2 | 7 Winfield St | 1 | 1 | 1 | ||
| 189082 | 189082 | 2 | 18 | 1271 Noe St | 1 | 1 | 1 | ||
| 189081 | 189081 | 2 | 141 | 1976 16th Ave | 2 | 1 | 1 | ||
| 189080 | 189080 | 2 | 5 | 3601 03rd St | 4 | 1 | 1 | ||
| 189079 | 189079 | 2 | 198 | 727 41st Ave | 1 | 1 | 1 | ||
| 189078 | 189078 | 2 | 6 | 300 Main St | 2 | 1 | 1 | ||
| 189077 | 189077 | 2 | 21 | 345 04th St | 4 | 1 | 1 | ||
| 189076 | 189076 | 2 | 114 | 470 Hoffman Ave | 1 | 1 | 1 | ||
| 189075 | 189075 | 2 | 44 | 1511 06th Ave | 1 | 1 | 1 | ||
| 189074 | 189074 | 2 | 15 | 2299 Lawton St | 1 | 1 | 1 | ||
| 189073 | 189073 | 2 | 16 | 2445 Folsom St | 1 | 1 | 1 | ||
| 189072 | 189072 | 2 | 11 | 700 Mission Bay Blvd North | 1 | 1 | 1 | ||
| 189071 | 189071 | 2 | 2 | 116 Taraval St | 1 | 1 | 1 | ||
| 189070 | 189070 | 2 | 70 | 585 Mangels Ave | 1 | 1 | 1 | ||
| 189069 | 189069 | 3 | 15 | 1200x Evans Ave | 3 | 1 | 2 | ||
| 189068 | 189068 | 2 | 35 | 289 Rose St | 1 | 1 | 1 | ||
| 189067 | 189067 | 2 | 138 | 3691 21st St | 1 | 1 | 1 | ||
| 189066 | 189066 | 2 | 46 | 149 Russ St | 1 | 1 | 1 | ||
| 189065 | 189065 | 2 | 12 | 1300 03rd St | 1 | 1 | 1 | ||
| 189064 | 189064 | 2 | 2 | 2300 Sunset Blvd | 2 | 1 | 1 | ||
| 189063 | 189063 | 1 | 239 | 1279 Union St | 1 | 1 | 1 | 1 | Permit Number 23045 |
| 189062 | 189062 | 2 | 26 | 250 29th Ave | 2 | 1 | 1 | ||
| 189061 | 189061 | 2 | 41 | 1280 10th Ave | 1 | 1 | 1 | ||
| 189060 | 189060 | 2 | 46 | 1746 Folsom St | 1 | 1 | 1 | ||
| 189059 | 189059 | 2 | 12 | 701 Portola Dr | 1 | 1 | 1 | ||
| 189058 | 189058 | 2 | 79 | 1499 16th St | 1 | 1 | 1 | ||
| 189057 | 189057 | 2 | 12 | 1763 Page St | 1 | 1 | 1 | ||
| 189056 | 189056 | 2 | 75 | 1940 Mission St | 1 | 1 | 1 | ||
| 189055 | 189055 | 2 | 2 | 283 30th Ave | 2 | 1 | 1 | ||
| 189054 | 189054 | 2 | 3 | 51 Prentiss St | 2 | 1 | 1 | ||
| 189053 | 189053 | 2 | 37 | 1305 Eugenia Ave | 1 | 1 | 1 | ||
| 189052 | 189052 | 2 | 35 | 1470 Lyon St | 1 | 1 | 1 | ||
| 189051 | 189051 | 2 | 35 | 5421 Anza St | 2 | 1 | 1 | ||
| 189050 | 189050 | 2 | 22 | 875 Castro St | 1 | 1 | 1 | ||
| 189049 | 189049 | 2 | 32 | 601 Treat Ave | 1 | 1 | 1 | ||
| 189048 | 189048 | 1 | 18 | 275 22nd Ave | 1 | 1 | 1 | 1 | Permit Number 767619 |
| 189047 | 189047 | 2 | 37 | 4264 22nd St | 1 | 1 | 1 | ||
| 189046 | 189046 | 2 | 163 | 489 45th Ave | 2 | 1 | 1 | ||
| 189045 | 189045 | 2 | 19 | 322 Havelock St | 9 | 1 | 1 |
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE "Street_Tree_List_fts" USING FTS4 ("qLegalStatus", "qSpecies", "qAddress", "qSiteInfo", "PlantType", "qCaretaker", "qCareAssistant", "PermitNotes", content="Street_Tree_List");