Street_Tree_List

Data source: data.sfgov.org

151 rows where qSiteInfo = 2 and qSpecies = 103 sorted by qAddress

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: SiteOrder, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
54108	54108	176348	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	0 Fuente Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26			5989603.79735	2090546.09261	37.7196430676648	-122.47798295295799	(37.7196430676648, -122.477982952958)
52160	52160	208998	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	10 Yerba Buena Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 4ft		5993381.76992	2097221.25805	37.7381899876824	-122.465408610532	(37.7381899876824, -122.465408610532)
75055	75055	208997	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	10 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 4ft		5993343.646380001	2097250.7379	37.738268733207605	-122.465542562746	(37.7382687332076, -122.465542562746)
77037	77037	208999	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	10 Yerba Buena Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 4ft		5993404.322790001	2097201.32336	37.7381365526709	-122.465329186907	(37.7381365526709, -122.465329186907)
26365	26365	208940	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	100 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			37	Width 10ft		5992201.32921	2095978.5342700002	37.7347096311457	-122.469399518468	(37.7347096311457, -122.469399518468)
185411	185411	208939	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	100 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 10ft		5992155.70572	2095974.23732	37.7346951961161	-122.469556940308	(37.7346951961161, -122.469556940308)
36761	36761	208976	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	100 Yerba Buena Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 6ft		5994151.01662	2096664.6627200001	37.7367060496466	-122.462708592139	(37.7367060496466, -122.462708592139)
160755	160755	208975	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	100 Yerba Buena Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 6ft		5994177.11325	2096643.32557	37.7366489660835	-122.462616818123	(37.7366489660835, -122.462616818123)
49984	49984	208918	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 10ft		5992207.01448	2096041.6179	37.7348831715052	-122.46938445304899	(37.7348831715052, -122.469384453049)
74311	74311	208919	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 10ft		5992247.91507	2096042.0705099998	37.734886777797996	-122.469243079632	(37.734886777798, -122.469243079632)
137770	137770	208917	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Saint Francis Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 10ft		5992152.90186	2096040.12972	37.734875958047496	-122.46957142927499	(37.7348759580475, -122.469571429275)
34400	34400	207800	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Santa Clara Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			42	Width 10ft		5993292.571380001	2096874.95335	37.737233976861205	-122.465691859205	(37.7372339768612, -122.465691859205)
40777	40777	207799	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 10ft		5993278.012180001	2096833.03373	37.7371180362587	-122.465739151856	(37.7371180362587, -122.465739151856)
165361	165361	207798	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 10ft		5993265.61107	2096796.17632	37.7370161196856	-122.465779350629	(37.7370161196856, -122.465779350629)
73251	73251	208996	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	11 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 4ft		5993421.96829	2097241.5815	37.7382481090644	-122.465271101502	(37.7382481090644, -122.465271101502)
30634	30634	207776	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	110 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 10ft		5993235.98614	2096867.2882599998	37.7372096663776	-122.46588694193001	(37.7372096663776, -122.46588694193)
41418	41418	207775	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	110 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 10ft		5993244.34274	2096906.29835	37.737317260394	-122.465860883191	(37.737317260394, -122.465860883191)
43077	43077	191722	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1100 25th St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			6014479.640380001	2101959.5389	37.752394509601494	-122.392793471535	(37.7523945096015, -122.392793471535)
29186	29186	209002	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	115 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			36	Width 4ft		5994119.61861	2096725.9639	37.736872559114104	-122.462821593742	(37.7368725591141, -122.462821593742)
77267	77267	207777	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	118 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			34	Width 10ft		5993220.0955300005	2096827.0991599998	37.737098400464795	-122.465938963216	(37.7370984004648, -122.465938963216)
32381	32381	207778	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	124 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 10ft		5993200.08857	2096786.31561	37.7369852648432	-122.46600517310699	(37.7369852648432, -122.466005173107)
133286	133286	209001	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	125 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 4ft		5994148.93284	2096709.76404	37.7368297666801	-122.462719067425	(37.7368297666801, -122.462719067425)
76666	76666	207779	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	126 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			36	Width 10ft		5993175.19587	2096740.86685	37.7368590378112	-122.46608793591001	(37.7368590378112, -122.46608793591)
41832	41832	208941	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	130 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 10ft		5992287.573419999	2095984.60456	37.734731282309106	-122.469101787134	(37.7347312823091, -122.469101787134)
44792	44792	208974	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	130 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 6ft		5994229.97779	2096604.2011400003	37.7365445844613	-122.462431207033	(37.7365445844613, -122.462431207033)
26956	26956	208920	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	135 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 10ft		5992288.77396	2096040.55395	37.734884974665	-122.46910170710301	(37.734884974665, -122.469101707103)
173563	173563	208921	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	135 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 10ft		5992336.36345	2096045.4635	37.7349012047205	-122.46893753225001	(37.7349012047205, -122.46893753225)
133032	133032	209000	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	135 Yerba Buena Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 4ft		5994206.5655	2096669.1829099997	37.7367216600723	-122.462516864768	(37.7367216600723, -122.462516864768)
47668	47668	208973	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	136 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 6ft		5994259.725980001	2096572.0955299998	37.7364581434207	-122.46232602774799	(37.7364581434207, -122.462326027748)
187171	187171	208972	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	136 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 6ft		5994281.63654	2096550.25213	37.7363994284866	-122.462248690521	(37.7363994284866, -122.462248690521)
60450	60450	207766	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	14 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			32	Width 10ft		5993184.09693	2097461.91411	37.7388393665447	-122.46610954301799	(37.7388393665447, -122.466109543018)
74106	74106	207797	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	145 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			42	Width 10ft		5993240.654130001	2096747.6644599999	37.7368814785997	-122.465862113458	(37.7368814785997, -122.465862113458)
178890	178890	207796	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	145 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			45	Width 10ft		5993217.29355	2096710.01575	37.736776757040204	-122.465940145823	(37.7367767570402, -122.465940145823)
149306	149306	207808	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	15 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 10ft		5993219.0538800005	2097526.21938	37.7390179494069	-122.46599335061899	(37.7390179494069, -122.465993350619)
154505	154505	208971	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	150 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 6ft		5994318.90627	2096521.2556599998	37.736321957275706	-122.462117732164	(37.7363219572757, -122.462117732164)
65353	65353	207764	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1520 Monterey Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		5993438.38203	2095281.4007599999	37.7328668869905	-122.46507202306299	(37.7328668869905, -122.465072023063)
28820	28820	209004	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	156 Kensington Way	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 3ft		5994803.6888	2098556.09355	37.7419370183784	-122.460589057359	(37.7419370183784, -122.460589057359)
51062	51062	224245	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	160 Coso Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			32			6007485.6356	2099587.10163	37.7454893881214	-122.41681188667201	(37.7454893881214, -122.416811886672)
51100	51100	209006	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	172 Kensington Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 3ft		5994773.63128	2098602.47798	37.7420626491773	-122.46069634646099	(37.7420626491773, -122.460696346461)
130326	130326	209005	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	172 Kensington Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		5994782.01847	2098589.82391	37.7420283868014	-122.460666429624	(37.7420283868014, -122.460666429624)
166974	166974	209007	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	172 Kensington Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 3ft		5994745.50567	2098641.39451	37.7421678860404	-122.460796414937	(37.7421678860404, -122.460796414937)
113956	113956	114069	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	2 HIGUERA AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			40			5988091.0	2090188.0	37.7185719141165	-122.483185851801	(37.7185719141165, -122.483185851801)
43824	43824	207767	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	20 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 10ft		5993205.662140001	2097402.75145	37.7386781648646	-122.466030683288	(37.7386781648646, -122.466030683288)
53873	53873	207768	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	20 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 10ft		5993209.58572	2097384.67012	37.7386287444209	-122.466015804002	(37.7386287444209, -122.466015804002)
188184	188184	208970	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	20 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 6ft		5993484.40904	2097144.7715200002	37.7379858937365	-122.46504818472499	(37.7379858937365, -122.465048184725)
66266	66266	191737	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	200 Helena St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6010885.73151	2096220.33708	37.736435634280895	-122.40481783988199	(37.7364356342809, -122.404817839882)
181003	181003	191736	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	200 Helena St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			57			6010895.577219999	2096228.10312	37.7364575084979	-122.40478434551399	(37.7364575084979, -122.404784345514)
64951	64951	208942	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	200 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			32	Width 10ft		5992406.13159	2095989.66706	37.7347520323855	-122.468692262863	(37.7347520323855, -122.468692262863)
131518	131518	208943	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	200 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			39	Width 10ft		5992457.65692	2095992.19703	37.7347619554908	-122.46851430770701	(37.7347619554908, -122.468514307707)
30943	30943	208922	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	201 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 10ft		5992403.02946	2096048.0013299999	37.7349120244605	-122.46870723116899	(37.7349120244605, -122.468707231169)
159777	159777	208923	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	201 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			32	Width 10ft		5992447.89906	2096049.02744	37.734917433899	-122.468552177239	(37.734917433899, -122.468552177239)
40168	40168	208995	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	21 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 4ft		5993486.0432	2097190.73028	37.7381121792369	-122.465045871672	(37.7381121792369, -122.465045871672)
63161	63161	208994	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	21 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 4ft		5993511.280230001	2097168.00802	37.7380512447772	-122.46495696559799	(37.7380512447772, -122.464956965598)
29388	29388	207794	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	213 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 10ft		5993149.25155	2096563.99491	37.736371894833	-122.46616478658999	(37.736371894833, -122.46616478659)
133823	133823	207795	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	213 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 10ft		5993167.32945	2096610.60875	37.7365009277821	-122.466105670558	(37.7365009277821, -122.466105670558)
167382	167382	207793	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	215 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 10ft		5993139.697869999	2096516.18073	37.7362400578338	-122.466194343712	(37.7362400578338, -122.466194343712)
25657	25657	208945	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	234 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			40	Width 10ft		5992554.30272	2095990.82137	37.73476376044329	-122.46818007286001	(37.7347637604433, -122.46818007286)
180635	180635	208944	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	234 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 10ft		5992497.26068	2095992.6782799999	37.73476556447329	-122.468377420108	(37.7347655644733, -122.468377420108)
176352	176352	208925	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	235 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			45	Width 10ft		5992554.16067	2096052.7030900002	37.734933663950294	-122.46818506409599	(37.7349336639503, -122.468185064096)
181826	181826	208924	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	235 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			44	Width 10ft		5992506.66791	2096052.3886900002	37.7349300576612	-122.468349238953	(37.7349300576612, -122.468349238953)
92772	92772	114075	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	24 HIGUERA AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26			5987903.0	2090420.0	37.7191979850677	-122.483852684784	(37.7191979850677, -122.483852684784)
138466	138466	114076	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	24 HIGUERA AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24			5987903.0	2090420.0	37.7191979850677	-122.483852684784	(37.7191979850677, -122.483852684784)
61439	61439	208913	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	25 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			52	Width 10ft		5991855.18446	2096027.3519599999	37.7348236624713	-122.470599802253	(37.7348236624713, -122.470599802253)
60463	60463	207807	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	25 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 10ft		5993231.15579	2097483.74028	37.7389020106052	-122.46594842230199	(37.7389020106052, -122.465948422302)
51382	51382	207780	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	250 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 10ft		5993075.61435	2096444.65306	37.7360399631594	-122.46641070800501	(37.7360399631594, -122.466410708005)
130074	130074	207792	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	255 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 10ft		5993127.3071800005	2096365.9249099998	37.7358267779692	-122.46622626692499	(37.7358267779692, -122.466226266925)
188685	188685	207791	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	255 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 10ft		5993127.95212	2096331.51719	37.7357323401679	-122.466221537416	(37.7357323401679, -122.466221537416)
162142	162142	207781	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	256 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 10ft		5993074.748819999	2096403.4667	37.7359268257591	-122.466410707985	(37.7359268257591, -122.466410707985)
53478	53478	207782	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	260 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 10ft		5993076.07579	2096352.6988099997	37.7357875063795	-122.466402431535	(37.7357875063795, -122.466402431535)
148956	148956	207783	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	260 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 10ft		5993078.05201	2096316.5606	37.7356883939084	-122.466392973362	(37.7356883939084, -122.466392973362)
153159	153159	207790	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	265 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			39	Width 10ft		5993131.48438	2096255.5032900001	37.735523828762005	-122.466203802777	(37.735523828762, -122.466203802777)
46031	46031	207784	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	270 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 10ft		5993081.2153199995	2096255.53806	37.735521023771604	-122.466377603044	(37.7355210237716, -122.466377603044)
33664	33664	207789	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	275 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 10ft		5993131.90761	2096210.54353	37.735400404893	-122.46619907325199	(37.735400404893, -122.466199073252)
40215	40215	207788	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	285 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 10ft		5993135.10109	2096167.2284099997	37.7352816566244	-122.46618488553001	(37.7352816566244, -122.46618488553)
3850	3850	207785	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	290 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		09/28/2017 12:00:00 AM	3	Width 10ft		5993081.87997	2096205.8056700001	37.7353845093885	-122.46637169180299	(37.7353845093885, -122.466371691803)
68451	68451	207786	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	290 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 10ft		5993081.96122	2096160.8531	37.735261085532706	-122.46636814486999	(37.7352610855327, -122.46636814487)
175986	175986	207763	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	290 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			36	Width 10ft		5993266.97338	2095443.21542	37.7333013044925	-122.46567637377599	(37.7333013044925, -122.465676373776)
137042	137042	207787	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	292 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 10ft		5993086.25016	2096104.5741400002	37.7351068050182	-122.466349227661	(37.7351068050182, -122.466349227661)
76953	76953	208935	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	3 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 10ft		5991812.79149	2095969.62922	37.7346627188958	-122.47074216493401	(37.7346627188958, -122.470742164934)
152307	152307	208936	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	3 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 10ft		5991855.38456	2095971.03212	37.7346690339426	-122.470595009771	(37.7346690339426, -122.470595009771)
164085	164085	208969	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	30 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 6ft		5993545.78483	2097101.19005	37.737869768775795	-122.46483281598302	(37.7378697687758, -122.464832815983)
71759	71759	208946	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	300 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 10ft		5992719.83793	2096001.79663	37.7348034547201	-122.467608563598	(37.7348034547201, -122.467608563598)
62516	62516	208926	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	301 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			43	Width 10ft		5992668.30531	2096054.89965	37.7349462868375	-122.467790589077	(37.7349462868375, -122.467790589077)
157860	157860	208927	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	301 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			36	Width 10ft		5992731.01578	2096057.52147	37.7349571065737	-122.46757396937299	(37.7349571065737, -122.467573969373)
165768	165768	208980	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	302 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5993091.73044	2095958.45065	37.7347059025462	-122.46631966423901	(37.7347059025462, -122.466319664239)
36907	36907	208993	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	31 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 4ft		5993535.26127	2097150.77507	37.7380053101076	-122.46487280074899	(37.7380053101076, -122.464872800749)
24602	24602	208981	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	310 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			43	Width 3ft		5993092.40274	2095921.0497	37.7346032476459	-122.466314622626	(37.7346032476459, -122.466314622626)
131911	131911	207759	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	315 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 10ft		5993145.97421	2095838.45755	37.7343795610583	-122.46612340966999	(37.7343795610583, -122.46612340967)
23367	23367	208982	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	320 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			45	Width 3ft		5993096.565780001	2095876.3159599998	37.7344806601409	-122.46629697974501	(37.7344806601409, -122.466296979745)
53855	53855	208983	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	330 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 3ft		5993097.51511	2095800.07009	37.73427136274	-122.466288158284	(37.73427136274, -122.466288158284)
162672	162672	207760	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	333 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 10ft		5993144.47081	2095802.99513	37.734282103340796	-122.46612603120501	(37.7342821033408, -122.466126031205)
150553	150553	208928	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	335 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			44	Width 10ft		5992778.536119999	2096059.1494200001	37.7349643200549	-122.467409794552	(37.7349643200549, -122.467409794552)
52363	52363	208968	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	34 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 6ft		5993576.11533	2097077.3704400002	37.737806114757795	-122.46472622025298	(37.7378061147578, -122.464726220253)
167226	167226	208947	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	340 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 10ft		5992761.11825	2096003.55707	37.734810671779705	-122.467465972472	(37.7348106717797, -122.467465972472)
173362	173362	208948	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	340 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			32	Width 10ft		5992820.42769	2095999.6816200002	37.734803454707496	-122.46726063928499	(37.7348034547075, -122.467260639285)
55842	55842	207761	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	345 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 10ft		5993145.033430001	2095739.54752	37.7341079244482	-122.46611947693701	(37.7341079244482, -122.466119476937)
130507	130507	207805	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	35 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 10ft		5993257.8737699995	2097404.51842	37.738686028527	-122.46585029007099	(37.738686028527, -122.465850290071)
169216	169216	207806	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	35 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			32	Width 10ft		5993241.00806	2097448.11917	37.738804772329104	-122.46591177043501	(37.7388047723291, -122.465911770435)
36584	36584	208984	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	354 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 3ft		5993109.71634	2095669.50335	37.7339135629453	-122.466236489538	(37.7339135629453, -122.466236489538)
158456	158456	207762	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	355 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 10ft		5993165.17049	2095669.26931	37.7339161197195	-122.46604475226499	(37.7339161197195, -122.466044752265)

Next page

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");