Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | qLegalStatus | qSpecies | qAddress ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PermitNotes |
|---|---|---|---|---|---|---|---|---|---|
| 51 | 51 | 1 | 17 | 1 | 1 | 1 | Permit Number 20649 | ||
| 57 | 57 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 59 | 59 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 84 | 84 | 1 | 33 | 1 | 1 | 1 | Permit Number 39461 | ||
| 103 | 103 | 1 | 38 | 1 | 1 | 1 | Permit Number 776915 | ||
| 151 | 151 | 1 | 33 | 1 | 1 | 1 | Permit Number 39461 | ||
| 172 | 172 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 204 | 204 | 1 | 17 | 1 | 1 | 1 | Permit Number 21392 | ||
| 235 | 235 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 279 | 279 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 308 | 308 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 320 | 320 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 321 | 321 | 1 | 17 | 1 | 1 | 1 | Permit Number 27118 | ||
| 444 | 444 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 515 | 515 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 536 | 536 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 580 | 580 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 632 | 632 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 633 | 633 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 689 | 689 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 726 | 726 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 729 | 729 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 793 | 793 | 1 | 17 | 1 | 1 | 1 | Permit Number 28874 | ||
| 809 | 809 | 1 | 17 | 1 | 1 | 1 | Permit Number 44490 | ||
| 814 | 814 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 921 | 921 | 1 | 17 | 1 | 1 | 1 | Permit Number 128 | ||
| 937 | 937 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 952 | 952 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 953 | 953 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 1010 | 1010 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 1015 | 1015 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 1067 | 1067 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 1086 | 1086 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 1113 | 1113 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 1225 | 1225 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 1418 | 1418 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 1499 | 1499 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 1511 | 1511 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 1526 | 1526 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 1532 | 1532 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 1765 | 1765 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 1804 | 1804 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 1828 | 1828 | 1 | 12 | 1 | 1 | 1 | Permit Number 38712 | ||
| 1869 | 1869 | 1 | 12 | 1 | 1 | 1 | Permit Number 38712 | ||
| 1885 | 1885 | 1 | 17 | 1 | 1 | 1 | Permit Number 147 | ||
| 1959 | 1959 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 1973 | 1973 | 1 | 17 | 1 | 1 | 1 | Permit Number 29464 | ||
| 1981 | 1981 | 1 | 85 | 1 | 1 | 1 | Permit Number 38993 | ||
| 2019 | 2019 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 2080 | 2080 | 1 | 12 | 1 | 1 | 1 | Permit Number 37980 | ||
| 2086 | 2086 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 2115 | 2115 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 2154 | 2154 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 2193 | 2193 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 2195 | 2195 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 2304 | 2304 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 2366 | 2366 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 2434 | 2434 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 2627 | 2627 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 2630 | 2630 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 2673 | 2673 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 2699 | 2699 | 1 | 33 | 1 | 1 | 1 | Permit Number 39461 | ||
| 2726 | 2726 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 2842 | 2842 | 1 | 155 | 1 | 1 | 1 | Permit Number 39538 | ||
| 2860 | 2860 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 2904 | 2904 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 2945 | 2945 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 2960 | 2960 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 2992 | 2992 | 1 | 68 | 1 | 1 | 1 | Permit Number 42880 | ||
| 3027 | 3027 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 3062 | 3062 | 1 | 12 | 1 | 1 | 1 | Permit Number 37979 | ||
| 3077 | 3077 | 1 | 12 | 1 | 1 | 1 | Permit Number 38712 | ||
| 3090 | 3090 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 3118 | 3118 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 3134 | 3134 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 3168 | 3168 | 1 | 15 | 1 | 1 | 1 | Permit Number 37336 | ||
| 3178 | 3178 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 3193 | 3193 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 3212 | 3212 | 1 | 12 | 1 | 1 | 1 | Permit Number 37975 | ||
| 3227 | 3227 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 3266 | 3266 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 3285 | 3285 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 3297 | 3297 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 3322 | 3322 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 3393 | 3393 | 1 | 17 | 1 | 1 | 1 | Permit Number 37893 | ||
| 3395 | 3395 | 1 | 11 | 1 | 1 | 1 | Permit Number 44490 | ||
| 3408 | 3408 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 3420 | 3420 | 1 | 12 | 1 | 1 | 1 | Permit Number 38712 | ||
| 3444 | 3444 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 3448 | 3448 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 3458 | 3458 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 3539 | 3539 | 1 | 11 | 1 | 1 | 1 | Permit Number 44490 | ||
| 3543 | 3543 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 3545 | 3545 | 1 | 68 | 1 | 1 | 1 | Permit Number 42880 | ||
| 3614 | 3614 | 1 | 17 | 1 | 1 | 1 | Permit Number 44940 | ||
| 3663 | 3663 | 1 | 12 | 1 | 1 | 1 | Permit Number 39538 | ||
| 3668 | 3668 | 1 | 68 | 1 | 1 | 1 | Permit Number 42880 | ||
| 3744 | 3744 | 1 | 33 | 1 | 1 | 1 | Permit Number 44564 | ||
| 3751 | 3751 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 3765 | 3765 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 |
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");