Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | qLegalStatus | qSpecies | qAddress ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PermitNotes |
|---|---|---|---|---|---|---|---|---|---|
| 3821 | 3821 | 1 | 21 | 1 | 1 | 1 | Permit Number 44518 | ||
| 3838 | 3838 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 3864 | 3864 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 3875 | 3875 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 3909 | 3909 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 4009 | 4009 | 1 | 15 | 1 | 1 | 1 | Permit Number 37940 | ||
| 4038 | 4038 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 4053 | 4053 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 4084 | 4084 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 4133 | 4133 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 4171 | 4171 | 1 | 15 | 1 | 1 | 1 | Permit Number 41185 | ||
| 4256 | 4256 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 4347 | 4347 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 4378 | 4378 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 4492 | 4492 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 4519 | 4519 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 4531 | 4531 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 4552 | 4552 | 1 | 17 | 14 | 1 | 1 | |||
| 4576 | 4576 | 1 | 17 | 1 | 1 | 1 | Permit Number 19804 | ||
| 4629 | 4629 | 1 | 155 | 1 | 1 | 1 | Permit Number 38555 | ||
| 4714 | 4714 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 4741 | 4741 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 4774 | 4774 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 4823 | 4823 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 4831 | 4831 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 4913 | 4913 | 1 | 17 | 14 | 1 | 1 | |||
| 4975 | 4975 | 1 | 11 | 1 | 1 | 1 | Permit Number 45375 | ||
| 4991 | 4991 | 1 | 17 | 1 | 1 | 1 | Permit Number 38758 | ||
| 5018 | 5018 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 5109 | 5109 | 1 | 21 | 1 | 1 | 1 | Permit Number 39461 | ||
| 5121 | 5121 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 5128 | 5128 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 5147 | 5147 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5156 | 5156 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 5208 | 5208 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5259 | 5259 | 1 | 50 | 1 | 1 | 1 | Permit Number 42829 | ||
| 5261 | 5261 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 5268 | 5268 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 5270 | 5270 | 1 | 17 | 1 | 1 | 1 | Permit Number 147 | ||
| 5277 | 5277 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 5286 | 5286 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5321 | 5321 | 1 | 17 | 1 | 1 | 1 | Permit Number 39461 | ||
| 5325 | 5325 | 1 | 84 | 1 | 1 | 1 | Permit Number 41311 | ||
| 5335 | 5335 | 1 | 155 | 1 | 1 | 1 | Permit Number 43169 | ||
| 5355 | 5355 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5360 | 5360 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 5385 | 5385 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 5386 | 5386 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 5392 | 5392 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 5393 | 5393 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 5401 | 5401 | 1 | 17 | 1 | 1 | 1 | Permit Number 39428 | ||
| 5431 | 5431 | 1 | 33 | 1 | 1 | 1 | Permit Number 39461 | ||
| 5452 | 5452 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 5455 | 5455 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5458 | 5458 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 5482 | 5482 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 5514 | 5514 | 1 | 17 | 1 | 1 | 1 | Permit Number 29639 | ||
| 5515 | 5515 | 1 | 60 | 1 | 1 | 1 | Permit Number 46023 | ||
| 5540 | 5540 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5552 | 5552 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 5567 | 5567 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 5568 | 5568 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5571 | 5571 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 5573 | 5573 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 5574 | 5574 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 5581 | 5581 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 5586 | 5586 | 1 | 68 | 1 | 1 | 1 | Permit Number 42880 | ||
| 5590 | 5590 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 5602 | 5602 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5603 | 5603 | 1 | 2 | 1 | 1 | 1 | Permit Number 38056 | ||
| 5605 | 5605 | 1 | 12 | 1 | 1 | 1 | Permit Number 37987 | ||
| 5612 | 5612 | 1 | 85 | 1 | 1 | 1 | Permit Number 38993 | ||
| 5616 | 5616 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 5617 | 5617 | 1 | 2 | 1 | 1 | 1 | Permit Number 38712 | ||
| 5642 | 5642 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5673 | 5673 | 1 | 12 | 1 | 1 | 1 | Permit Number 44843 | ||
| 5690 | 5690 | 1 | 12 | 1 | 1 | 1 | Permit Number 37975 | ||
| 5692 | 5692 | 1 | 17 | 1 | 1 | 1 | Permit Number 25933 | ||
| 5706 | 5706 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5714 | 5714 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 5746 | 5746 | 1 | 16 | 1 | 1 | 1 | Permit Number 35298 | ||
| 5752 | 5752 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 5753 | 5753 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 5754 | 5754 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5758 | 5758 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5768 | 5768 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 5773 | 5773 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 5780 | 5780 | 1 | 17 | 1 | 1 | 1 | Permit Number 19174 | ||
| 5783 | 5783 | 1 | 17 | 1 | 1 | 1 | Permit Number 43835 | ||
| 5789 | 5789 | 1 | 17 | 1 | 1 | 1 | Permit Number 45832 | ||
| 5809 | 5809 | 1 | 21 | 1 | 1 | 1 | Permit Number 44518 | ||
| 5810 | 5810 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5816 | 5816 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5825 | 5825 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 5838 | 5838 | 1 | 17 | 1 | 1 | 1 | Permit Number 43922 | ||
| 5841 | 5841 | 1 | 17 | 1 | 1 | 1 | Permit Number 44451 | ||
| 5859 | 5859 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
| 5873 | 5873 | 1 | 33 | 1 | 1 | 1 | Permit Number 39461 | ||
| 5885 | 5885 | 1 | 12 | 1 | 1 | 1 | Permit Number 44843 | ||
| 5893 | 5893 | 1 | 82 | 1 | 1 | 1 | Permit Number 44518 |
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");