Street_Tree_List

Data source: data.sfgov.org

288 rows where DBH = 2 and qSpecies = 18 sorted by Longitude

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: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude ▼	Location
150585	150585	56095	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	783 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/12/2009 12:00:00 AM	2	3x3	Permit Number 52001	5981348.38409	2110404.98623	37.7736874110676	-122.507991510924	(37.7736874110676, -122.507991510924)
31693	31693	119100	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	855 46th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5981674.98764	2109913.6134599997	37.772357483762704	-122.50682530453399	(37.7723574837627, -122.506825304534)
168858	168858	117913	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	893 40th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5983541.21756	2109770.57795	37.7720744705229	-122.500359367665	(37.7720744705229, -122.500359367665)
166746	166746	117912	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	889 40th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5983541.524809999	2109784.94999	37.772113950042794	-122.50035936764999	(37.7721139500428, -122.50035936765)
158895	158895	92228	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	819 38th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/2009 12:00:00 AM	2	3x3	Permit Number 52552	5984148.0757	2110235.49072	37.77338659024161	-122.498294572929	(37.7733865902416, -122.498294572929)
147200	147200	92229	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	831 38th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/2009 12:00:00 AM	2	3x3	Permit Number 52669	5984149.10381	2110157.50395	37.7731725212481	-122.498285255587	(37.7731725212481, -122.498285255587)
71854	71854	81961	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	485 37th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/07/2007 12:00:00 AM	2		Permit Number 49960	5984369.11349	2112553.91349	37.779765269334504	-122.49770119972901	(37.7797652693345, -122.497701199729)
175612	175612	118209	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	574 35th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 3ft		5985058.9891	2111965.86595	37.7781910764099	-122.495271274867	(37.7781910764099, -122.495271274867)
154069	154069	43063	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	490 34th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/21/2008 12:00:00 AM	2	3x3	Permit Number 51464	5985346.9900400005	2112594.40853	37.779933731493294	-122.49432133158399	(37.7799337314933, -122.494321331584)
129882	129882	95990	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	734 31st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2011 12:00:00 AM	2	3x3	Permit Number 767642	5986340.19492	2110900.5686	37.7753410020486	-122.490760773635	(37.7753410020486, -122.490760773635)
165506	165506	95992	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	858 31st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2011 12:00:00 AM	2	3x3	Permit Number 767644	5986371.40114	2110056.12968	37.7730242344515	-122.490590683906	(37.7730242344515, -122.490590683906)
154082	154082	119956	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	330 28th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5987168.10276	2113699.1852599997	37.783073538215795	-122.488102576965	(37.7830735382158, -122.488102576965)
147431	147431	96900	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	334 28th Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/05/2011 12:00:00 AM	2	4x4	Permit Number 768036	5987168.76751	2113688.0402900004	37.7830429760908	-122.488099458022	(37.7830429760908, -122.488099458022)
25818	25818	96898	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	334 28th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/05/2011 12:00:00 AM	2	4x4	Permit Number 768036	5987169.6042	2113664.32132	37.7829778993822	-122.48809482	(37.7829778993822, -122.48809482)
157195	157195	96899	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	334 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/05/2011 12:00:00 AM	2	4x4	Permit Number 768036	5987170.52326	2113675.9123	37.783009778520004	-122.488092492463	(37.78300977852, -122.488092492463)
38835	38835	119957	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	346 28th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5987171.5706	2113609.1286400002	37.7828264707534	-122.48808396026399	(37.7828264707534, -122.488083960264)
173587	173587	95934	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	674 28th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2011 12:00:00 AM	2	3x3	Permit Number 767631	5987254.50705	2111348.9878700003	37.7766256032795	-122.487630947058	(37.7766256032795, -122.487630947058)
156020	156020	95931	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	691 27th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2011 12:00:00 AM	2	3x3	Permit Number 767628	5987521.80961	2111256.95198	37.7763884852693	-122.486699521672	(37.7763884852693, -122.486699521672)
25098	25098	95928	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	758 26th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2011 12:00:00 AM	2	3x3	Permit Number 767625	5987895.384330001	2110807.039	37.775174921567796	-122.485374215588	(37.7751749215678, -122.485374215588)
182102	182102	103454	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	284 24th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		5988396.696330001	2114118.88325	37.7842975073391	-122.48388298077101	(37.7842975073391, -122.483882980771)
132561	132561	45514	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2917 26th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/20/2001 12:00:00 AM	2		Permit Number 44278	5988535.25971	2095760.7230900002	37.7338990344167	-122.482058269478	(37.7338990344167, -122.482058269478)
64761	64761	120325	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	742 23rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5988848.2342	2110250.1988	37.77370145820289	-122.482037331833	(37.7737014582029, -122.482037331833)
181843	181843	120426	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	667 22nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5989088.891559999	2110781.28528	37.7751736683191	-122.48124376819099	(37.7751736683191, -122.481243768191)
75532	75532	179037	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2945 24th Ave	1	: 4	Tree 1	Private 1			2	Width 2ft		5989055.57419	2095644.9365599998	37.733611362859605	-122.480250933435	(37.7336113628596, -122.480250933435)
119487	119487	179038	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2945 24th Ave	2	: 4	Tree 1	Private 1			2	Width 2ft		5989055.89984	2095635.51997	37.733585526248795	-122.480249118607	(37.7335855262488, -122.480249118607)
155549	155549	179039	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2945 24th Ave	3	: 4	Tree 1	Private 1			2	Width 2ft		5989055.72291	2095627.1595	37.7335625602678	-122.48024911859699	(37.7335625602678, -122.480249118597)
68028	68028	45482	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	3020 20th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/19/2001 12:00:00 AM	2		Permit Number 44263	5990295.806419999	2095116.94306	37.7322336167725	-122.475924589162	(37.7322336167725, -122.475924589162)
130781	130781	92609	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2528 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/27/2009 12:00:00 AM	2	3x3	Permit Number 52920	5990746.65563	2112013.99975	37.778654601597	-122.475599281341	(37.778654601597, -122.475599281341)
37777	37777	92608	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2524 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/27/2009 12:00:00 AM	2	3x3	Permit Number 52920	5990771.27794	2112015.60912	37.7786604478424	-122.47551422168101	(37.7786604478424, -122.475514221681)
173198	173198	214478	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1668 18th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5990610.731369999	2104039.3841	37.7567505828021	-122.475487070766	(37.7567505828021, -122.475487070766)
50816	50816	214567	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1550 Irving St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990896.39166	2106586.0775	37.763759680286604	-122.47468502841299	(37.7637596802866, -122.474685028413)
148180	148180	213391	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	850 Quintara St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5990803.9447	2101134.71558	37.748786324324996	-122.47460689170799	(37.748786324325, -122.474606891708)
123972	123972	214486	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2039 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5990959.54907	2101524.70922	37.7498661600977	-122.474097269267	(37.7498661600977, -122.474097269267)
62297	62297	213358	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	95 Beachmont Dr	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 4ft		5990836.79794	2095256.5707599998	37.7326483517269	-122.474064462004	(37.7326483517269, -122.474064462004)
156360	156360	213359	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	95 Beachmont Dr	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 4ft		5990836.58141	2095246.30718	37.7326201579899	-122.474064462004	(37.7326201579899, -122.474064462004)
26879	26879	122163	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	557 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5991250.26553	2111589.08538	37.7775170853646	-122.473826110289	(37.7775170853646, -122.473826110289)
60178	60178	214667	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	626 Rivera St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991170.18336	2100467.73914	37.7469761941154	-122.473291813962	(37.7469761941154, -122.473291813962)
44011	44011	214579	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1409 Irving St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991361.73298	2106537.8564299997	37.7636542311812	-122.473072054748	(37.7636542311812, -122.473072054748)
24236	24236	213361	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	25 Elmhurst Dr	6	: 4	Tree 1	Private 1			2	Width 3ft		5991216.12738	2094471.85178	37.730515676960394	-122.47269584493701	(37.7305156769604, -122.472695844937)
160563	160563	213398	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	621 Quintara St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5991517.42633	2101098.4611299997	37.7487280941444	-122.472137056592	(37.7487280941444, -122.472137056592)
51380	51380	213399	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	621 Quintara St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5991532.61986	2101100.8826900003	37.74873562236029	-122.472084694454	(37.7487356223603, -122.472084694454)
42855	42855	213400	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	621 Quintara St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5991548.4151099995	2101099.1787400004	37.7487318577911	-122.472029950926	(37.7487318577911, -122.472029950926)
40670	40670	213401	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	621 Quintara St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5991567.73676	2101101.51332	37.7487393860095	-122.47196330756	(37.7487393860095, -122.47196330756)
37368	37368	213397	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2011 15th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5991583.99315	2101696.28864	37.7503734254013	-122.47195043737301	(37.7503734254013, -122.471950437373)
42821	42821	124018	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	222 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991848.751540001	2113924.91675	37.7839652833195	-122.471926053095	(37.7839652833195, -122.471926053095)
164612	164612	214512	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1201 Irving St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991834.49252	2106555.8498	37.7637309964006	-122.47143825366501	(37.7637309964006, -122.471438253665)
156694	156694	123031	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	722 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991970.8857	2110474.96476	37.7744997243223	-122.47125207498101	(37.7744997243223, -122.471252074981)
169854	169854	214671	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	2472 15th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991737.91746	2098617.8202400003	37.741929649338495	-122.47119390160299	(37.7419296493385, -122.471193901603)
135163	135163	214514	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1201 Irving St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991913.63923	2106558.50977	37.7637428782486	-122.471164705988	(37.7637428782486, -122.471164705988)
87590	87590	91928	DPW Maintained 3	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1201X IRVING ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/19/2009 12:00:00 AM	2	3x3		5992070.0	2106573.0	37.7637917074669	-122.470624962715	(37.7637917074669, -122.470624962715)
98111	98111	91929	DPW Maintained 3	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1201X IRVING ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/11/2014 12:00:00 AM	2	3x3		5992070.0	2106573.0	37.7637917074669	-122.470624962715	(37.7637917074669, -122.470624962715)
72745	72745	213369	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1563 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992113.9889	2104807.12798	37.7589456327602	-122.47034421221599	(37.7589456327602, -122.470344212216)
58106	58106	213327	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	331 Byxbee St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 10ft		5991934.3542	2090733.0516599999	37.7202914059971	-122.469940735003	(37.7202914059971, -122.469940735003)
154951	154951	213325	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	351 Byxbee St	1	: 4	Tree 1	Private 1			2	Width 3ft		5991942.4704599995	2090861.00435	37.7206432019019	-122.46992199131701	(37.7206432019019, -122.469921991317)
27648	27648	214621	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1415 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992391.88162	2105788.8525099996	37.7616572533136	-122.469454599246	(37.7616572533136, -122.469454599246)
179032	179032	213338	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	280 Ralston St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 4ft		5992226.7586	2089761.9448900002	37.7176418818408	-122.46885936766701	(37.7176418818408, -122.468859367667)
69824	69824	213337	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	280 Ralston St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 4ft		5992227.25788	2089749.39386	37.717607448608796	-122.468856729068	(37.7176074486088, -122.468856729068)
153843	153843	213336	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	280 Ralston St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 4ft		5992226.96216	2089735.3394799998	37.717568841612504	-122.46885672906099	(37.7175688416125, -122.468856729061)
165191	165191	213480	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	270 San Leandro Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992360.2599	2095044.9531599998	37.7321554342216	-122.46878213389401	(37.7321554342216, -122.468782133894)
161006	161006	123799	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1900 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992759.08391	2112088.12025	37.7789745741229	-122.468642970342	(37.7789745741229, -122.468642970342)
149087	149087	123798	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1900 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992773.6819	2112088.5545	37.7789766097312	-122.468592502086	(37.7789766097312, -122.468592502086)
75708	75708	59120	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	540 10th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/23/1980 12:00:00 AM	2	3x3	Permit Number 18424	5992853.52259	2111756.57585	37.7780696980739	-122.468292145877	(37.7780696980739, -122.468292145877)
59387	59387	214520	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	955 Irving St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992757.19823	2106588.47757	37.76387391848029	-122.468249300883	(37.7638739184803, -122.468249300883)
182463	182463	214521	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	945 Irving St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992776.19936	2106588.69627	37.763875616381895	-122.468183598193	(37.7638756163819, -122.468183598193)
62678	62678	214627	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1448 11th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992756.23431	2105602.64255	37.7611670193557	-122.46818091553699	(37.7611670193557, -122.468180915537)
172699	172699	214507	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1961 11th Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5992840.594380001	2102195.17889	37.7518158822179	-122.467641337597	(37.7518158822179, -122.467641337597)
176034	176034	214504	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1961 11th Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5992841.74564	2102234.5173	37.7519239618198	-122.467640217025	(37.7519239618198, -122.467640217025)
176702	176702	214506	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1961 11th Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5992841.4998699995	2102207.4204	37.7518495465294	-122.46763909649201	(37.7518495465294, -122.467639096492)
155672	155672	214505	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1961 11th Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5992842.05434	2102218.37849	37.751879666633	-122.46763797592399	(37.751879666633, -122.467637975924)
169219	169219	124346	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	804 Balboa St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993044.54414	2111416.29684	37.777146414825204	-122.467606586696	(37.7771464148252, -122.467606586696)
41495	41495	214526	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	845 Irving St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993056.887069999	2106598.6195099996	37.7639190698192	-122.46721351391899	(37.7639190698192, -122.467213513919)
44616	44616	214708	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	300 San Benito Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992868.56396	2094867.3457099998	37.7316971208256	-122.46701192098101	(37.7316971208256, -122.467011920981)
49260	49260	213458	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	331 Dorantes Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5992978.54855	2099656.27544	37.7448526672074	-122.46697971536301	(37.7448526672074, -122.466979715363)
188584	188584	214655	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1797 10th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993099.09717	2103293.8568599997	37.754847490535795	-122.466827267677	(37.7548474905358, -122.466827267677)
49737	49737	214704	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	520 Darien Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5992936.67794	2094882.99637	37.7317440249531	-122.46677757652701	(37.7317440249531, -122.466777576527)
23502	23502	214703	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	520 Darien Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5992960.1777800005	2094882.5024400002	37.7317440249629	-122.46669629760001	(37.7317440249629, -122.4666962976)
32323	32323	214702	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	520 Darien Way	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5992979.91933	2094883.59777	37.7317481717454	-122.466628127212	(37.7317481717454, -122.466628127212)
154842	154842	213386	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1846 10th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993160.52883	2102907.84462	37.7537911459483	-122.466586765563	(37.7537911459483, -122.466586765563)
3683	3683	213464	Permitted Site 1	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	300 Dorantes Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/24/2005 12:00:00 AM	2	Width 3ft	Permit Number 48287	5993110.29995	2099700.9644	37.7449829754007	-122.46652739502701	(37.7449829754007, -122.466527395027)
172558	172558	214640	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1259 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5993284.58174	2106894.2296	37.7647438785383	-122.46644747949301	(37.7647438785383, -122.466447479493)
160182	160182	214715	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	106 Aptos Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993029.000080001	2094275.40431	37.7300810552916	-122.466414259408	(37.7300810552916, -122.466414259408)
186977	186977	213378	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1222 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993325.39992	2107141.02877	37.7654238793266	-122.466324239095	(37.7654238793266, -122.466324239095)
50571	50571	214615	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1381 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5993310.7573	2106091.15894	37.7625403677758	-122.466298577838	(37.7625403677758, -122.466298577838)
38000	38000	214644	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1256 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5993333.17302	2106942.2711	37.764878591599704	-122.466282908025	(37.7648785915997, -122.466282908025)
168168	168168	213448	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	4 Cortes Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5993184.39566	2099612.1282900004	37.7447433294416	-122.46626473273199	(37.7447433294416, -122.466264732732)
177133	177133	214642	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1290 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5993336.037169999	2106757.3858	37.764371110454604	-122.466259564335	(37.7643711104546, -122.466259564335)
61284	61284	213533	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	39 Pinehurst Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993275.112919999	2093310.10467	37.727444778145	-122.465493325775	(37.727444778145, -122.465493325775)
135210	135210	214535	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	701 Irving St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993564.21584	2106614.2357400004	37.7639912206449	-122.465459964506	(37.7639912206449, -122.465459964506)
31599	31599	218216	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	130 Lenox Way	1	: 4	Tree 1	Private 1			2	Width 2ft		5993396.63989	2098589.94545	37.7419489172986	-122.465456597447	(37.7419489172986, -122.465456597447)
130595	130595	213349	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	382 Victoria St	1	: 4	Tree 1	Private 1			2	Width 3ft		5993261.23034	2089739.3179799998	37.71763946535779	-122.465282053445	(37.7176394653578, -122.465282053445)
47651	47651	214645	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1256 08th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5993641.37954	2106958.7171099996	37.764941526166396	-122.46521810353201	(37.7649415261664, -122.465218103532)
33954	33954	214718	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	120 Westgate Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993393.66752	2093805.3618400001	37.7288114697568	-122.465119441606	(37.7288114697568, -122.465119441606)
49316	49316	123273	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	578 07th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5993791.71774	2111566.05198	37.7776007134003	-122.465032776868	(37.7776007134003, -122.465032776868)
28762	28762	123988	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	9 06th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993914.451719999	2115450.72048	37.7882740365456	-122.464890390305	(37.7882740365456, -122.464890390305)
24568	24568	214543	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	642 Irving St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993736.09449	2106681.4613900003	37.7641857161125	-122.46487037437001	(37.7641857161125, -122.46487037437)
66290	66290	214629	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1552 08th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993710.5818300005	2104918.8610799997	37.7593446043956	-122.464830603648	(37.7593446043956, -122.464830603648)
76027	76027	213474	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	125 Dorantes Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5993866.67958	2099897.14622	37.7455652594364	-122.463926229234	(37.7455652594364, -122.463926229234)
100884	100884	214775	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	36 Sotelo Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993929.10229	2101145.39334	37.7489962269912	-122.463800968038	(37.7489962269912, -122.463800968038)
49667	49667	214777	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	36 Sotelo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993930.07421	2101127.47655	37.7489470880465	-122.46379630688101	(37.7489470880465, -122.463796306881)
152578	152578	213473	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	45 Dorantes Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5994145.2265	2100030.80799	37.7459483094686	-122.462972759886	(37.7459483094686, -122.462972759886)

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