Street_Tree_List

Data source: data.sfgov.org

821 rows where search matches "cherry" and qSiteInfo = 2 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

- 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, qSpecies, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude ▼	Location
67642	67642	118478	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	578 48th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5981024.51617	2111800.84509	37.7775009394111	-122.509215478972	(37.7775009394111, -122.509215478972)
154522	154522	118420	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	5501 Anza St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5981593.2087199995	2111630.13422	37.7770657300516	-122.507235548964	(37.7770657300516, -122.507235548964)
185931	185931	118627	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	494 46th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5981628.0956	2112437.91019	37.7792856992778	-122.50717480668301	(37.7792856992778, -122.507174806683)
177635	177635	118425	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	5421 Anza St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		5981790.15899	2111638.01027	37.7770989536906	-122.506554832582	(37.7770989536906, -122.506554832582)
189051	189051	118424	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	5421 Anza St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5981802.00316	2111639.4369	37.7771035681701	-122.50651396642	(37.7771035681701, -122.50651396642)
56421	56421	118423	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	5421 Anza St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		5981811.815769999	2111640.57092	37.7771072596016	-122.50648010623001	(37.7771072596016, -122.50648010623)
24630	24630	184291	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1543 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5983404.3155	2104639.3384	37.7579775103532	-122.50045345703501	(37.7579775103532, -122.500453457035)
131317	131317	117739	Undocumented 2	Prunus spp :: Cherry 84	475 39th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5983746.16527	2112679.78018	37.7800743257794	-122.49986552243	(37.7800743257794, -122.49986552243)
23912	23912	118028	Undocumented 2	Prunus x yedoensis :: Yoshino Cherry 237	51 Shore View Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		5984316.15967	2112798.24876	37.780433038793	-122.49790243493	(37.780433038793, -122.49790243493)
158401	158401	118027	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	51 Shore View Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5984327.56097	2112791.45591	37.780415056002205	-122.49786249135201	(37.7804150560022, -122.497862491352)
70321	70321	118026	Undocumented 2	Prunus x yedoensis :: Yoshino Cherry 237	51 Shore View Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5984344.44515	2112788.1845400003	37.780407063583	-122.49780384033998	(37.780407063583, -122.49780384034)
70069	70069	118023	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	455 37th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5984366.09559	2112727.46699	37.780241619998	-122.49772445801202	(37.780241619998, -122.497724458012)
41303	41303	118024	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	455 37th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5984366.776430001	2112718.2833	37.7802164441611	-122.497721424423	(37.7802164441611, -122.497721424423)
162710	162710	118025	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	455 37th Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5984366.92897	2112698.04941	37.7801608967117	-122.49771940229799	(37.7801608967117, -122.497719402298)
174540	174540	184306	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1562 38th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5984381.1972	2104548.1361	37.757784389614	-122.497068306014	(37.757784389614, -122.497068306014)
45248	45248	184305	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1562 38th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5984382.3056	2104532.0637	37.757740324240295	-122.497063286444	(37.7577403242403, -122.497063286444)
49304	49304	182263	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	1446 Kirkham St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 0ft		5984974.4693	2105337.6794	37.7599870046454	-122.49507477448	(37.7599870046454, -122.49507477448)
186494	186494	182276	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	3150 Kirkham St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5985061.2024	2105018.6781	37.759116193094	-122.494751291704	(37.759116193094, -122.494751291704)
51415	51415	182275	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	3150 Kirkham St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5985063.5912	2105018.8618	37.7591168373077	-122.49474304376001	(37.7591168373077, -122.49474304376)
152743	152743	182409	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1521 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5985259.3217	2104833.2809	37.7586187384667	-122.494052446724	(37.7586187384667, -122.494052446724)
60297	60297	182224	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1599 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5985275.2811	2104383.8376	37.7573856255252	-122.493964129886	(37.7573856255252, -122.493964129886)
159371	159371	184131	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1642 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5985330.3253	2104026.0743	37.7564065269094	-122.49374740508001	(37.7564065269094, -122.49374740508)
61059	61059	182221	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2830 Lawton St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5985427.0921	2104352.0968	37.7573073554199	-122.493436776332	(37.7573073554199, -122.493436776332)
67394	67394	182513	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1573 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5985578.9968	2104511.5721	37.757754115031794	-122.492923184352	(37.7577541150318, -122.492923184352)
54310	54310	182541	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1587 34th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5985582.1491	2104435.4669	37.7575453355233	-122.492906676836	(37.7575453355233, -122.492906676836)
183024	183024	185612	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2101 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5985702.4651	2100891.7117	37.7478221885491	-122.492229646849	(37.7478221885491, -122.492229646849)
154941	154941	184141	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1647 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5985907.4128	2104010.0255	37.756396206392104	-122.49175048083599	(37.7563962063921, -122.491750480836)
24610	24610	183977	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1693 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5985918.7806	2103713.7918	37.7555834944248	-122.49168936146002	(37.7555834944248, -122.49168936146)
48434	48434	182802	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1771 33rd Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5985936.734	2103180.0986	37.7541191684466	-122.491587990539	(37.7541191684466, -122.491587990539)
50209	50209	182801	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1771 33rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5985937.2360000005	2103186.122	37.7541357363912	-122.49158669787799	(37.7541357363912, -122.491586697878)
75705	75705	250820	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	60 Sea View Ter	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5986182.97775	2114165.47247	37.7842963089586	-122.49154499381599	(37.7842963089586, -122.491544993816)
153946	153946	250819	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	60 Sea View Ter	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5986191.04243	2114164.9353	37.7842953053345	-122.49151705368999	(37.7842953053345, -122.49151705369)
41962	41962	250796	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	290 31st Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986226.25026	2113990.91468	37.7838195522695	-122.49138243596201	(37.7838195522695, -122.491382435962)
168487	168487	250795	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	290 31st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986226.21568	2113977.7713599997	37.7837834624768	-122.491381587892	(37.7837834624768, -122.491381587892)
40381	40381	250676	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	735 El Camino Del Mar	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5986293.297259999	2114811.88275	37.786077611448	-122.49121092176	(37.786077611448, -122.49121092176)
178867	178867	250677	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	735 El Camino Del Mar	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		5986302.66224	2114812.53014	37.78607993617911	-122.49117856955	(37.7860799361791, -122.49117856955)
24861	24861	182367	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1511 32nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5986186.5787	2104935.6262	37.758953963431	-122.49085314669901	(37.758953963431, -122.490853146699)
174227	174227	181930	Undocumented 2	Prunus spp :: Cherry 84	2431 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5986090.3717	2098682.4704	37.741778875367295	-122.49072577603	(37.7417788753673, -122.49072577603)
166433	166433	250875	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	125 30th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986467.14332	2114671.0752	37.7857011507179	-122.490599105783	(37.7857011507179, -122.490599105783)
71891	71891	250874	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	125 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5986467.3841	2114682.3933599996	37.7857322411853	-122.490599105779	(37.7857322411853, -122.490599105779)
56077	56077	250876	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	125 30th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986468.29527	2114661.08637	37.7856737915584	-122.490594385245	(37.7856737915584, -122.490594385245)
132130	132130	250868	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	133 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986468.4993	2114649.30576	37.7856414573183	-122.490592812321	(37.7856414573183, -122.490592812321)
180995	180995	250869	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	133 30th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5986468.30668	2114640.25117	37.785616584774104	-122.490592812307	(37.7856165847741, -122.490592812307)
166651	166651	250870	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	133 30th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5986470.3680300005	2114630.24299	37.7855892256034	-122.490584944137	(37.7855892256034, -122.490584944137)
86116	86116	185234	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2530 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5986160.02	2098006.6727	37.739927383563	-122.49043525338301	(37.739927383563, -122.490435253383)
161072	161072	119574	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	341 30th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5986512.996119999	2113510.70001	37.782517772266004	-122.490355077371	(37.782517772266, -122.490355077371)
70024	70024	250882	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	154 29th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 4ft		5986822.39512	2114740.35297	37.7859121118945	-122.48937514824699	(37.7859121118945, -122.489375148247)
172451	172451	250881	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	154 29th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5986823.250630001	2114733.9114599996	37.78589447530229	-122.489371714655	(37.7858944753023, -122.489371714655)
126747	126747	250902	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	266 29th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 4ft		5986843.33005	2114156.49339	37.7843102232907	-122.489259776936	(37.7843102232907, -122.489259776936)
57812	57812	250934	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	259 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		5987104.958930001	2114216.89652	37.7844913413477	-122.48835908522699	(37.7844913413477, -122.488359085227)
69256	69256	250924	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	279 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		5987109.1755800005	2114089.0974	37.7841406875769	-122.488335102104	(37.7841406875769, -122.488335102104)
39369	39369	250521	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	95 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		5987685.5238	2115445.0256	37.787897288863796	-122.48644075485201	(37.7878972888638, -122.486440754852)
26752	26752	250523	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	95 26th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		5987685.92853	2115397.50584	37.78776683682629	-122.48643586433998	(37.7877668368263, -122.48643586434)
132655	132655	250524	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	95 26th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		5987685.45058	2115374.99193	37.7877049922276	-122.486435864334	(37.7877049922276, -122.486435864334)
158576	158576	181897	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2346 29th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5987356.2384	2099265.0635	37.7434523865632	-122.48639164593399	(37.7434523865632, -122.486391645934)
186044	186044	185736	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2119 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5987568.4406	2100856.1259	37.7478333870661	-122.485774665371	(37.7478333870661, -122.485774665371)
71684	71684	183874	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2253 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5987600.3776	2099940.7208	37.7453217895816	-122.485597059998	(37.7453217895816, -122.485597059998)
176116	176116	183842	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2222 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5987636.2237	2100151.1028	37.745901531101396	-122.485488547623	(37.7459015311014, -122.485488547623)
178674	178674	183731	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	2271 27th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5987911.47	2099859.2137	37.7451161136106	-122.484515389918	(37.7451161136106, -122.484515389918)
184575	184575	182425	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1538 26th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5988098.2611	2104825.7625	37.758763800953005	-122.484233676535	(37.758763800953, -122.484233676535)
25162	25162	120283	Undocumented 2	Prunus x yedoensis :: Yoshino Cherry 237	139 24th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5988317.15466	2115062.63745	37.786884157218	-122.484227400222	(37.786884157218, -122.484227400222)
135469	135469	120284	Undocumented 2	Prunus x yedoensis :: Yoshino Cherry 237	139 24th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			5988322.783340001	2115034.52421	37.7868072939982	-122.484205864007	(37.7868072939982, -122.484205864007)
46931	46931	183520	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2563 27th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5987980.9372	2097853.3266	37.739612521668896	-122.484128114644	(37.7396125216689, -122.484128114644)
167016	167016	182588	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2481 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5988271.6694	2098431.5306	37.7412170409985	-122.483165270692	(37.7412170409985, -122.483165270692)
184402	184402	182590	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2485 26th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5988273.6999	2098412.9174	37.7411660521999	-122.48315688603998	(37.7411660521999, -122.48315688604)
152759	152759	182593	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2491 26th Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5988274.3768	2098375.691	37.7410638776679	-122.483151817617	(37.7410638776679, -122.483151817617)
127835	127835	114387	Significant Tree 6	Prunus cerasifera :: Cherry Plum 16	417x ARBALLO DR	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			5988152.0	2090574.0	37.7196353223366	-122.483003277928	(37.7196353223366, -122.483003277928)
76118	76118	183529	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2590 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5988341.8215	2097699.5391	37.739211266220295	-122.482869079468	(37.7392112662203, -122.482869079468)
131356	131356	120335	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	30 West Clay St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		5988814.20904	2115019.72522	37.7867952605979	-122.48250458154399	(37.7867952605979, -122.482504581544)
174383	174383	120334	Undocumented 2	Prunus x yedoensis :: Yoshino Cherry 237	16 West Clay St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 5ft		5988822.29899	2115016.65173	37.7867872922875	-122.48247636725901	(37.7867872922875, -122.482476367259)
130710	130710	120411	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	695 23rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5988788.14465	2110619.93187	37.7747131475769	-122.48227228258301	(37.7747131475769, -122.482272282583)
136120	136120	183843	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2242 25th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5988571.2077	2100055.5134	37.745693497424796	-122.48224853862699	(37.7456934974248, -122.482248538627)
32529	32529	120326	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	738 23rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 2ft		5988846.16685	2110288.25768	37.773805837099	-122.48204727167901	(37.773805837099, -122.482047271679)
70757	70757	182690	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1725 24th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5988713.9908	2103546.8998	37.7552882198487	-122.48201054093799	(37.7552882198487, -122.482010540938)
129524	129524	120701	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	70 22nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 5ft		5988982.8407	2114887.49266	37.7864419959893	-122.48191147245501	(37.7864419959893, -122.481911472455)
156144	156144	183594	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2635 24th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5988927.7716	2097397.2142	37.738415236787	-122.48082102296999	(37.738415236787, -122.48082102297)
27002	27002	181705	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1206 22nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5989261.3602	2107107.536	37.7650965865931	-122.48037820612	(37.7650965865931, -122.48037820612)
39866	39866	182572	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2212 Ulloa St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5989118.5154	2098355.8518	37.7410584915124	-122.48023167480301	(37.7410584915124, -122.480231674803)
172286	172286	182571	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2208 Ulloa St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5989133.5167	2098356.5835	37.7410613722493	-122.480179859895	(37.7410613722493, -122.480179859895)
154672	154672	182570	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2202 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5989157.6649	2098357.6812	37.7410657893771	-122.480096445466	(37.7410657893771, -122.480096445466)
182103	182103	120755	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	25 20th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		5989558.707669999	2114980.4396	37.7867306756372	-122.479925944143	(37.7867306756372, -122.479925944143)
39106	39106	182579	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2458 23rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5989241.8181	2098602.0912	37.741741764812396	-122.479823358011	(37.7417417648124, -122.479823358011)
61750	61750	182581	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2462 23rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5989245.1110000005	2098590.7488	37.7417108128416	-122.4798111426	(37.7417108128416, -122.4798111426)
63358	63358	120753	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2 20th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5989606.296159999	2114986.48675	37.78675004409779	-122.47976174378599	(37.7867500440978, -122.479761743786)
71493	71493	183429	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2430 22nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 0ft		5989548.1117	2098806.5483	37.7423209403934	-122.478779257985	(37.7423209403934, -122.478779257985)
186339	186339	183428	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2430 22nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5989548.6064	2098792.6969999997	37.742282937054	-122.478776534673	(37.742282937054, -122.478776534673)
159311	159311	183377	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2651 22nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5989551.7412	2097288.806	37.738153824368204	-122.478655737727	(37.7381538243682, -122.478655737727)
151376	151376	122064	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	5 17th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 5ft		5990491.562030001	2115003.9867599998	37.7868494825782	-122.476700244886	(37.7868494825782, -122.476700244886)
71627	71627	121889	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	10 17th Ave	0	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		5990520.54715	2115002.72082	37.78684768786071	-122.47659987163799	(37.7868476878607, -122.476599871638)
171839	171839	218014	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2535 18th Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5990806.44931	2098163.5608	37.7406284472476	-122.47438144334299	(37.7406284472476, -122.474381443343)
75818	75818	218013	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2535 18th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5990808.63285	2098099.59564	37.740452941848	-122.474369226959	(37.740452941848, -122.474369226959)
68797	68797	218012	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2535 18th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5990808.87516	2098083.17096	37.74040785793171	-122.474367190887	(37.7404078579317, -122.474367190887)
184803	184803	121966	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	26 15th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3			5991179.292640001	2114937.5267	37.7867068686376	-122.47431602898001	(37.7867068686376, -122.47431602898)
55246	55246	121965	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	20 15th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			5991180.37033	2114963.80683	37.7867790889821	-122.474314218886	(37.7867790889821, -122.474314218886)
153167	153167	214491	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1908 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5991283.85529	2102380.71309	37.752235304435395	-122.473038230333	(37.7522353044354, -122.473038230333)
175705	175705	212902	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1926 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5991285.05682	2102275.47409	37.7519464152036	-122.47302640154301	(37.7519464152036, -122.473026401543)
137816	137816	212901	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1942 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		5991289.25239	2102186.06751	37.7517011709901	-122.473005373606	(37.7517011709901, -122.473005373606)
53420	53420	212900	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1952 16th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5991290.87185	2102118.6659	37.7515161975232	-122.47299485872101	(37.7515161975232, -122.472994858721)
28683	28683	212896	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2075 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		5991276.17965	2101331.74892	37.7493546778745	-122.472988287398	(37.7493546778745, -122.472988287398)
170872	170872	212899	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1952 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5991292.44424	2102103.11551	37.751473591244505	-122.472988287395	(37.7514735912445, -122.472988287395)

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