Street_Tree_List_fts

189,144 rows sorted by PermitNotes

Search:

descending

Link	rowid	qLegalStatus	qSpecies	qAddress	qSiteInfo	PlantType	qCaretaker	qCareAssistant
3	3	3	3	495X Lakeshore Dr	3	1	2
4	4	2	4	920 Kirkham St	1	1	1
5	5	3	5	1501 Evans Ave	4	1	2
6	6	1	1	501X Baker St	1	1	1
7	7	3	5	1301 Evans Ave	4	1	2
8	8	1	6	300x Hickory St	1	1	1
9	9	2	7	920 Kirkham St	1	1	1
10	10	1	8	301x Hickory St	1	1	1
11	11	1	6	300x Hickory St	1	1	1
12	12	1	6	300x Hickory St	1	1	1
13	13	1	6	300x Hickory St	1	1	1
16	16	1	6	300x Hickory St	1	1	1
19	19	2	12	1471 28th Ave	1	1	1
20	20	4	13	1043 Minna St	5	1	1
21	21	4	13	1043 Minna St	5	1	1
22	22	2	7	910 Kirkham St	1	1	1
24	24	3	11	5280 03rd St	1	1	2
25	25	3	15	2975 Van Ness Ave	1	1	2
28	28	1	15	2741 Taylor St	1	1	1
29	29	3	5	1300 Evans Ave	4	1	2
31	31	1	5	1001 Turk St	1	1	3
32	32	3	11	1359 Hudson Ave	1	1	2
33	33	1	15	1545 California St	1	1	1
34	34	2	18	20 Lily St	1	1	1
36	36	3	15	2X Market St	1	1	2
37	37	2	19	1 Newburg St	6	1	1
38	38	2	11	1390 Mission St	1	1	1
39	39	1	11	101 Cargo Way	1	1	1
40	40	2	20	1 Newburg St	1	1	1
41	41	2	11	1390 Mission St	1	1	1
43	43	2	20	1 Newburg St	1	1	1
44	44	2	19	1 Newburg St	6	1	1
45	45	1	2	3201 California St	1	1	1
46	46	3	22	1737-1795 Post St	1	1	2
47	47	3	23	150 Otis St	1	1	2
48	48	3	11	201X Cargo Way	1	1	2
49	49	2	19	3042 Steiner St	5	1	1
52	52	2	24	1021 Noe St	1	1	1
53	53	2	25	1 Baker St	1	1	1
54	54	4	26	1388x Minna St	1	1	1
55	55	1	15	1700 California St	1	1	1
56	56	1	26	988 Fulton St	1	1	1
58	58	1	5	1255 Columbus Ave	1	1	1
60	60	4	26	1388x Minna St	1	1	1
61	61	2	27	1 Newburg St	6	1	1
62	62	2	9	10 12th St	1	1	1
64	64	2	11	1614 Broderick St	1	1	1
65	65	2	19	1 Newburg St	6	1	1
66	66	2	20	1 Newburg St	1	1	1
68	68	2	25	1 Baker St	1	1	1
69	69	3	30	630 Sansome St	1	1	2
70	70	4	26	1388x Minna St	1	1	1
71	71	2	18	270 Trumbull St	1	1	1
72	72	3	15	729 Grove St	1	1	2
74	74	3	5	2175X Palou Ave	1	1	2
75	75	1	15	729 GROVE ST	1	1	1
78	78	6	3	900X 14th St	7	1	1
79	79	2	2	2000X Market St	5	1	1
85	85	1	5	1001 Turk St	1	1	3
87	87	1	32	1500 Hyde St	1	1	1
88	88	2	2	4115 Kirkham St	1	1	1
89	89	1	17	1493 Hudson Ave	1	1	1
92	92	3	35	2X Frank Norris St	1	1	4	2
93	93	6	3	900X 14th St	7	1	1
94	94	2	36	1051 Ingalls St	1	1	1
96	96	6	3	900X 14th St	8	1	1
97	97	3	26	1245 Divisadero St	1	1	2
98	98	2	26	1384X GROVE ST	1	1	1
99	99	1	9	2247 Franklin St	1	1	1
101	101	2	11	1399X Mission St	1	1	1
104	104	3	39	1170 Ingalls St	1	1	2
105	105	3	5	1315 Ellis St	1	1	2
106	106	3	36	906 Hayes St	1	1	2
107	107	2	26	1384X GROVE ST	1	1	1
108	108	2	11	1399X Mission St	1	1	1
109	109	3	40	1800X Pine St	1	1	2
110	110	2	2	1824 Noriega St	1	1	1
111	111	1	15	400X Franklin St	1	1	1
112	112	3	11	1800X Pine St	1	1	2
113	113	1	41	1341 42nd Ave	1	1	1
114	114	6	1	399X Townsend St	5	1	1
115	115	1	26	700 Fell St	1	1	1
116	116	1	32	220 Richardson Ave	1	1	1
118	118	6	1	399X Townsend St	5	1	1
119	119	3	43	175X Otis St	1	1	2
122	122	1	45	1341 42nd Ave	1	1	1
123	123	3	41	2621 Sacramento St	1	1	2
124	124	3	2	20X Sunset Blvd	1	1	2
125	125	2	22	151X Octavia St Frontage West	1	1	1
126	126	3	11	700 Valencia St	1	1	2
127	127	3	46	2840 Pine St	1	1	2
128	128	2	16	115 Beverly St	9	1	1
129	129	3	47	262X Sunset Blvd	1	1	2
131	131	3	18	100 Octavia St	4	1	2
132	132	1	44	270 Brannan St	5	1	1
135	135	3	18	100 Octavia St	4	1	2
137	137	3	11	700 Valencia St	1	1	2
139	139	4	44	270 Brannan St	5	1	1
140	140	3	2	1916 Ellis St	1	1	2
141	141	3	48	1396 47th Ave	1	1	2

Advanced export

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");