Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | qLegalStatus | qSpecies ▼ | qAddress | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PermitNotes |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 1 | 1 | 501X Baker St | 1 | 1 | 1 | Permit Number 25401 | |
| 6 | 6 | 1 | 1 | 501X Baker St | 1 | 1 | 1 | ||
| 35 | 35 | 2 | 1 | 2562 26th Ave | 2 | 1 | 1 | Permit Number 779639 | |
| 114 | 114 | 6 | 1 | 399X Townsend St | 5 | 1 | 1 | ||
| 118 | 118 | 6 | 1 | 399X Townsend St | 5 | 1 | 1 | ||
| 191 | 191 | 2 | 1 | 365 San Leandro Way | 1 | 1 | 1 | Permit Number 779799 | |
| 263 | 263 | 2 | 1 | 1499X Hayes St | 1 | 1 | 1 | ||
| 595 | 595 | 6 | 1 | 299x Avalon Ave | 7 | 1 | 1 | ||
| 654 | 654 | 2 | 1 | 3015 Turk Blvd | 1 | 1 | 1 | Permit Number 779630 | |
| 694 | 694 | 2 | 1 | 700x 20th Ave | 1 | 1 | 1 | ||
| 717 | 717 | 2 | 1 | 700X 20TH AVE | 1 | 1 | 1 | Permit Number 779658 | |
| 720 | 720 | 2 | 1 | 700X 20th Ave | 1 | 1 | 1 | Permit Number 779658 | |
| 828 | 828 | 3 | 1 | 2600 Geary Blvd | 11 | 1 | 2 | ||
| 867 | 867 | 3 | 1 | 1000 Dolores St | 1 | 1 | 2 | ||
| 883 | 883 | 2 | 1 | 1 Cashmere St | 13 | 1 | 1 | ||
| 885 | 885 | 2 | 1 | 1 Cashmere St | 13 | 1 | 1 | ||
| 891 | 891 | 2 | 1 | 1 Cashmere St | 13 | 1 | 1 | 5 | |
| 1011 | 1011 | 1 | 1 | 1018 Shrader St | 1 | 1 | 1 | Permit Number 17854 | |
| 1095 | 1095 | 1 | 1 | 1649 48th Ave | 1 | 1 | 1 | Permit Number 9793 | |
| 1214 | 1214 | 3 | 1 | 57 Masonic Ave | 1 | 1 | 2 | ||
| 1262 | 1262 | 2 | 1 | 1214 29th Ave | 1 | 1 | 1 | Permit Number 779194 | |
| 1333 | 1333 | 2 | 1 | 148 28th Ave | 1 | 1 | 1 | Permit Number 779931 | |
| 1412 | 1412 | 2 | 1 | 330 23rd Ave | 1 | 1 | 1 | Permit Number 779745 | |
| 1423 | 1423 | 1 | 1 | 330 23rd Ave | 1 | 1 | 1 | Permit Number 779745 | |
| 1465 | 1465 | 1 | 1 | 855 Lincoln Way | 1 | 1 | 1 | Permit Number 41828 | |
| 1545 | 1545 | 2 | 1 | 1499X Fulton St | 1 | 1 | 1 | ||
| 1549 | 1549 | 2 | 1 | 1499X Fulton St | 1 | 1 | 1 | ||
| 1550 | 1550 | 2 | 1 | 1499X Fulton St | 1 | 1 | 1 | ||
| 1687 | 1687 | 3 | 1 | 2407 Sacramento St | 1 | 1 | 2 | ||
| 1992 | 1992 | 1 | 1 | 4235 24th St | 1 | 1 | 1 | Permit Number 10249 | |
| 2528 | 2528 | 3 | 1 | 1865 Buchanan St | 1 | 1 | 2 | ||
| 2855 | 2855 | 2 | 1 | 2300x Franklin St | 1 | 1 | 1 | ||
| 3267 | 3267 | 3 | 1 | 1200 California St | 1 | 1 | 2 | ||
| 3830 | 3830 | 3 | 1 | 45 Masonic Ave | 1 | 1 | 2 | ||
| 4023 | 4023 | 1 | 1 | 737 Elizabeth St | 1 | 1 | 1 | ||
| 4468 | 4468 | 2 | 1 | 527 Oak St | 5 | 1 | 1 | ||
| 4547 | 4547 | 2 | 1 | 135 Locust St | 1 | 1 | 1 | ||
| 4551 | 4551 | 2 | 1 | 135 Locust St | 1 | 1 | 1 | ||
| 4979 | 4979 | 3 | 1 | 2600 Geary Blvd | 11 | 1 | 2 | ||
| 5081 | 5081 | 2 | 1 | 1698X 08th Ave | 14 | 1 | 2 | ||
| 5085 | 5085 | 2 | 1 | 1698X 08th Ave | 14 | 1 | 2 | ||
| 5086 | 5086 | 2 | 1 | 2300x Franklin St | 1 | 1 | 1 | ||
| 5092 | 5092 | 2 | 1 | 1698X 08th Ave | 14 | 1 | 2 | ||
| 5097 | 5097 | 2 | 1 | 1698X 08th Ave | 14 | 1 | 2 | ||
| 5099 | 5099 | 2 | 1 | 1698X 08th Ave | 14 | 1 | 2 | ||
| 5433 | 5433 | 3 | 1 | 2600 Geary Blvd | 11 | 1 | 2 | ||
| 5601 | 5601 | 2 | 1 | 3801 Sacramento St | 1 | 1 | 1 | Permit Number 778748 | |
| 5798 | 5798 | 3 | 1 | 2600 Geary Blvd | 11 | 1 | 2 | ||
| 5802 | 5802 | 2 | 1 | 2233 Post St | 1 | 1 | 1 | Permit Number 779046 | |
| 6568 | 6568 | 3 | 1 | 2049 Grove St | 1 | 1 | 4 | 2 | Permit Number 52971 |
| 6574 | 6574 | 3 | 1 | 1200 California St | 1 | 1 | 2 | ||
| 6978 | 6978 | 1 | 1 | 1826 Eddy St | 1 | 1 | 1 | ||
| 7105 | 7105 | 1 | 1 | 2584 Post St | 1 | 1 | 1 | Permit Number 21315 | |
| 7106 | 7106 | 3 | 1 | 2600X Geary Blvd | 1 | 1 | 2 | ||
| 7131 | 7131 | 1 | 1 | 1425 Vallejo St | 1 | 1 | 1 | ||
| 7159 | 7159 | 2 | 1 | 3801 Sacramento St | 1 | 1 | 1 | Permit Number 778748 | |
| 7236 | 7236 | 3 | 1 | 2600 Geary Blvd | 11 | 1 | 2 | ||
| 7502 | 7502 | 2 | 1 | 3801 Sacramento St | 1 | 1 | 1 | Permit Number 778748 | |
| 7592 | 7592 | 3 | 1 | 3020 Pine St | 1 | 1 | 2 | ||
| 8062 | 8062 | 2 | 1 | 2300x Franklin St | 1 | 1 | 1 | ||
| 8281 | 8281 | 2 | 1 | 1985 Golden Gate Ave | 1 | 1 | 1 | ||
| 8418 | 8418 | 3 | 1 | 3022 Pine St | 1 | 1 | 2 | ||
| 8476 | 8476 | 3 | 1 | 2600 Geary Blvd | 11 | 1 | 2 | ||
| 8703 | 8703 | 3 | 1 | 1200 California St | 1 | 1 | 2 | ||
| 8762 | 8762 | 3 | 1 | 2660 Geary Blvd | 11 | 1 | 2 | ||
| 8845 | 8845 | 2 | 1 | 2X Masonic Ave | 1 | 1 | 1 | ||
| 8885 | 8885 | 1 | 1 | 1435 Pacific Ave | 1 | 1 | 1 | Permit Number 6112 | |
| 9190 | 9190 | 1 | 1 | 2031X Bush St | 1 | 1 | 1 | ||
| 9615 | 9615 | 2 | 1 | 1670 Scott St | 1 | 1 | 1 | ||
| 9684 | 9684 | 6 | 1 | 2699x OCEAN AVE | 5 | 1 | 6 | 4 | |
| 9779 | 9779 | 2 | 1 | 486 32nd Ave | 1 | 1 | 1 | ||
| 9808 | 9808 | 2 | 1 | 421 Alvarado St | 1 | 1 | 1 | Permit Number 779269 | |
| 9810 | 9810 | 2 | 1 | 421 Alvarado St | 1 | 1 | 1 | Permit Number 779269 | |
| 9833 | 9833 | 2 | 1 | 181 Addison St | 1 | 1 | 1 | ||
| 9861 | 9861 | 2 | 1 | 7300 Fulton St | 1 | 1 | 1 | Permit Number 779332 | |
| 9868 | 9868 | 2 | 1 | 699x 29th St | 8 | 1 | 1 | ||
| 9873 | 9873 | 2 | 1 | 855 La Playa | 1 | 1 | 1 | ||
| 9874 | 9874 | 2 | 1 | 7300 Fulton St | 1 | 1 | 1 | Permit Number 779332 | |
| 9880 | 9880 | 3 | 1 | 1100X Carolina St | 11 | 1 | 2 | ||
| 9884 | 9884 | 3 | 1 | 906 Carolina St | 11 | 1 | 2 | ||
| 9912 | 9912 | 6 | 1 | 484 Chenery St | 7 | 1 | 1 | ||
| 9946 | 9946 | 2 | 1 | 2799x 47th Ave | 1 | 1 | 1 | ||
| 10036 | 10036 | 1 | 1 | 110X VALLEY ST | 1 | 1 | 1 | 1 | Permit Number 779438 |
| 10037 | 10037 | 2 | 1 | 401 04th Ave | 1 | 1 | 1 | ||
| 10039 | 10039 | 2 | 1 | 706 20TH AVE | 1 | 1 | 1 | ||
| 10229 | 10229 | 1 | 1 | 26 Alma St | 1 | 1 | 1 | ||
| 10231 | 10231 | 1 | 1 | 26 Alma St | 1 | 1 | 1 | Permit Number 12417 | |
| 10258 | 10258 | 2 | 1 | 1109x Alemany Blvd | 1 | 1 | 1 | ||
| 10642 | 10642 | 2 | 1 | 3601 Wawona St | 1 | 1 | 1 | ||
| 10678 | 10678 | 1 | 1 | 1631 40th Ave | 1 | 1 | 1 | Permit Number 779477 | |
| 10779 | 10779 | 3 | 1 | 1388 47th Ave | 1 | 1 | 2 | ||
| 10811 | 10811 | 3 | 1 | 1381 46th Ave | 1 | 1 | 2 | ||
| 11098 | 11098 | 1 | 1 | 1055 Taraval St | 1 | 1 | 1 | Permit Number 25639 | |
| 11179 | 11179 | 1 | 1 | 1026 Taraval St | 1 | 1 | 1 | ||
| 11201 | 11201 | 3 | 1 | 100 STAIRWAY15 | 1 | 1 | 2 | ||
| 11232 | 11232 | 2 | 1 | 1948 Irving St | 1 | 1 | 1 | ||
| 11276 | 11276 | 2 | 1 | 4130 Moraga St | 1 | 1 | 1 | ||
| 11284 | 11284 | 2 | 1 | 1619 47th Ave | 1 | 1 | 1 | Permit Number 777355 | |
| 11349 | 11349 | 2 | 1 | 80 Dichiera Ct | 15 | 1 | 1 | ||
| 11464 | 11464 | 1 | 1 | 916 Taraval St | 1 | 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");