Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | qLegalStatus | qSpecies | qAddress | qSiteInfo | PlantType | qCaretaker ▲ | qCareAssistant | PermitNotes |
---|---|---|---|---|---|---|---|---|---|
77542 | 77542 | 1 | 144 | 1000X McAllister St | 1 | 1 | 21 | ||
77557 | 77557 | 1 | 128 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
77576 | 77576 | 1 | 26 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
78822 | 78822 | 1 | 11 | 1000X McAllister St | 1 | 1 | 21 | ||
80298 | 80298 | 1 | 150 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
83117 | 83117 | 1 | 25 | 1000X McAllister St | 1 | 1 | 21 | ||
85143 | 85143 | 5 | 16 | 1050 MCALLISTER ST | 8 | 1 | 21 | 4 | |
86826 | 86826 | 1 | 6 | 1000X McAllister St | 1 | 1 | 21 | ||
99583 | 99583 | 1 | 82 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
104137 | 104137 | 1 | 26 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
106272 | 106272 | 5 | 80 | 1050 MCALLISTER ST | 8 | 1 | 21 | 4 | |
108008 | 108008 | 1 | 82 | 1000X McAllister St | 1 | 1 | 21 | ||
110180 | 110180 | 1 | 25 | 1000X McAllister St | 1 | 1 | 21 | ||
111085 | 111085 | 1 | 26 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
112538 | 112538 | 1 | 82 | 1000X McAllister St | 1 | 1 | 21 | ||
122469 | 122469 | 1 | 25 | 1000X McAllister St | 1 | 1 | 21 | ||
123500 | 123500 | 1 | 25 | 1000X McAllister St | 1 | 1 | 21 | ||
123863 | 123863 | 1 | 128 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
124348 | 124348 | 1 | 11 | 1000X McAllister St | 1 | 1 | 21 | ||
126868 | 126868 | 1 | 25 | 1000X McAllister St | 1 | 1 | 21 | ||
140317 | 140317 | 1 | 82 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
141722 | 141722 | 1 | 82 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
143620 | 143620 | 1 | 26 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
145179 | 145179 | 1 | 6 | 1000X McAllister St | 1 | 1 | 21 | ||
145804 | 145804 | 1 | 26 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
6478 | 6478 | 2 | 5 | 1150 Scott St | 1 | 1 | 20 | 2 | |
19054 | 19054 | 6 | 311 | 2451X Griffith St | 5 | 1 | 20 | 1 | |
50102 | 50102 | 6 | 417 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
76012 | 76012 | 7 | 88 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
78805 | 78805 | 7 | 180 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
81078 | 81078 | 6 | 469 | 2451X Griffith St | 5 | 1 | 20 | 1 | |
81165 | 81165 | 7 | 353 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
81341 | 81341 | 7 | 195 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
81359 | 81359 | 2 | 43 | 135X TRENTON ST | 1 | 1 | 20 | 3 | |
82893 | 82893 | 7 | 322 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
84182 | 84182 | 6 | 17 | 150X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
85013 | 85013 | 7 | 353 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
86272 | 86272 | 6 | 17 | 137X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
86815 | 86815 | 2 | 21 | 135X TRENTON ST | 1 | 1 | 20 | 3 | |
87276 | 87276 | 2 | 11 | 699x WILLOW ST | 1 | 1 | 20 | 4 | |
87538 | 87538 | 7 | 1 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
88058 | 88058 | 6 | 498 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
88802 | 88802 | 7 | 232 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
90248 | 90248 | 7 | 14 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
90953 | 90953 | 6 | 17 | 11X Hare St | 7 | 1 | 20 | Permit Number 770341 | |
92954 | 92954 | 7 | 54 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
94845 | 94845 | 7 | 353 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
94993 | 94993 | 2 | 11 | 699x WILLOW ST | 1 | 1 | 20 | 4 | |
96189 | 96189 | 6 | 112 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
99914 | 99914 | 7 | 112 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
101441 | 101441 | 2 | 43 | 135X TRENTON ST | 1 | 1 | 20 | 3 | |
102473 | 102473 | 3 | 5 | 775X Broadway | 1 | 1 | 20 | 2 | Permit Number 778058 |
104476 | 104476 | 7 | 322 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
104783 | 104783 | 7 | 20 | 195A Kiska Rd | 5 | 1 | 20 | 1 | |
107391 | 107391 | 6 | 17 | 10X Hare St | 7 | 1 | 20 | Permit Number 770341 | |
107550 | 107550 | 7 | 477 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
108419 | 108419 | 6 | 17 | 150X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
111421 | 111421 | 3 | 5 | 775X Broadway | 1 | 1 | 20 | 2 | Permit Number 778058 |
111442 | 111442 | 6 | 17 | 200X West Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
111560 | 111560 | 6 | 112 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
111884 | 111884 | 6 | 112 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
112944 | 112944 | 3 | 5 | 775X Broadway | 1 | 1 | 20 | 2 | Permit Number 778058 |
112975 | 112975 | 6 | 498 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
114297 | 114297 | 3 | 5 | 775X Broadway | 1 | 1 | 20 | 2 | Permit Number 778058 |
114699 | 114699 | 2 | 5 | 1150 Scott St | 1 | 1 | 20 | 2 | |
118079 | 118079 | 3 | 5 | 775X Broadway | 1 | 1 | 20 | 2 | Permit Number 778058 |
118120 | 118120 | 2 | 40 | 200x MIDDLE POINT RD | 1 | 1 | 20 | 3 | |
119692 | 119692 | 6 | 17 | 45X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
120473 | 120473 | 2 | 11 | 699x WILLOW ST | 1 | 1 | 20 | 4 | |
120602 | 120602 | 2 | 9 | 1514 SUNNYDALE AVE | 9 | 1 | 20 | 3 | |
125137 | 125137 | 6 | 17 | 71X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
125485 | 125485 | 7 | 14 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
125835 | 125835 | 7 | 20 | 195A Kiska Rd | 5 | 1 | 20 | 1 | |
126442 | 126442 | 3 | 5 | 775X Broadway | 1 | 1 | 20 | 2 | |
126702 | 126702 | 2 | 5 | 1150 Scott St | 1 | 1 | 20 | 2 | |
127056 | 127056 | 6 | 17 | 150X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
127473 | 127473 | 7 | 207 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
128761 | 128761 | 2 | 5 | 1150 Scott St | 1 | 1 | 20 | 2 | |
128784 | 128784 | 7 | 14 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
129300 | 129300 | 6 | 17 | 150X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
138572 | 138572 | 2 | 21 | 135X TRENTON ST | 1 | 1 | 20 | 3 | |
139320 | 139320 | 6 | 498 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
140389 | 140389 | 7 | 477 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
140586 | 140586 | 7 | 322 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
140629 | 140629 | 7 | 14 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
140648 | 140648 | 6 | 17 | 150X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
141507 | 141507 | 6 | 17 | 119X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
141804 | 141804 | 6 | 235 | 2451X Griffith St | 5 | 1 | 20 | 1 | |
142369 | 142369 | 7 | 309 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
143629 | 143629 | 6 | 84 | 2451X Griffith St | 5 | 1 | 20 | 1 | |
144144 | 144144 | 6 | 540 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
144482 | 144482 | 2 | 51 | 1150 Scott St | 1 | 1 | 20 | 2 | |
144883 | 144883 | 6 | 417 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
145213 | 145213 | 7 | 208 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
145522 | 145522 | 7 | 477 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
145720 | 145720 | 2 | 51 | 1150 Scott St | 1 | 1 | 20 | 2 | |
181574 | 181574 | 1 | 37 | 400 Beale St | 1 | 1 | 20 | 3 | Permit Number 769373 |
4504 | 4504 | 1 | 35 | 762 Fulton St | 1 | 1 | 19 | ||
5269 | 5269 | 1 | 35 | 762 Fulton St | 1 | 1 | 19 | ||
5536 | 5536 | 1 | 35 | 762 Fulton St | 1 | 1 | 19 |
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");