Street_Tree_List

Data source: data.sfgov.org

598 rows where qLegalStatus = 3 and qSpecies = 47 sorted by qSiteInfo

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: qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo ▼	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
129	129	20398	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	43	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
618	618	20377	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
886	886	19568	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	100ST
1898	1898	20392	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	38	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
2144	2144	252907	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	25 Point Lobos Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				10x10		5982783.76519	2112486.06679	37.7794859217892	-122.50318049806101	(37.7794859217892, -122.503180498061)
3981	3981	18927	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2691 Sacramento St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6001960.28459	2115686.06098	37.7893808348161	-122.437070045665	(37.7893808348161, -122.437070045665)
5557	5557	20407	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	52	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
5855	5855	19776	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY18	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	50ST
6006	6006	20312	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	101X Sunset Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
6023	6023	19905	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	120ST
6115	6115	20296	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	20X Sunset Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
6147	6147	19906	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
6357	6357	20291	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	20X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
6360	6360	20424	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
6399	6399	20412	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
6517	6517	19907	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	120ST
6533	6533	19565	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	-11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	100ST
6834	6834	19955	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	2ST
6952	6952	19935	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
7006	7006	20417	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
7419	7419	97731	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1150 Francisco St	9	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		3	3x3	Permit Number 50638	6005778.11415	2120709.05822	37.803388983478605	-122.42421815984501	(37.8033889834786, -122.424218159845)
7548	7548	20317	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	101X Sunset Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
7732	7732	19948	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	25ST
7886	7886	19945	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	25ST
7938	7938	19700	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY11	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	40ST
8196	8196	20297	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	20X Sunset Blvd	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
8406	8406	20373	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
8584	8584	2988	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2266X California St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			35	3X3		6003528.90719	2115622.95537	37.7892965998021	-122.431638286196	(37.7892965998021, -122.431638286196)
8739	8739	20365	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
8750	8750	20413	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
8903	8903	19566	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	-9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	100ST
9072	9072	19804	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY22	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	20
9473	9473	20455	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	495X Sunset Blvd	20	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
9584	9584	20422	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
10571	10571	19570	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	100ST
10674	10674	19936	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
10701	10701	20452	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	495X Sunset Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
10705	10705	19569	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	100ST
10816	10816	19910	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	120ST
10949	10949	19933	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
11220	11220	19950	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
11591	11591	20428	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	485X Sunset Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	40
11826	11826	20419	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
12151	12151	19869	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY33	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	25ST
12480	12480	20434	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	485X Sunset Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
12812	12812	19953	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
13158	13158	19753	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY15	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
13184	13184	20013	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY47	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	100ST
13273	13273	20881	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1892X Sunset Blvd	31	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/21/2017 10:23:00 AM	3	60		5984852.8466778	2102317.5089788004	37.7516873322231	-122.49527267334	(37.7516873322231, -122.49527267334)
13276	13276	20799	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1792X Sunset Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/21/2017 10:19:00 AM	3			5984829.6375693	2102999.3844439	37.7535582155387	-122.49540321629601	(37.7535582155387, -122.495403216296)
13278	13278	20803	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1792X Sunset Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/21/2017 10:15:00 AM	3	60		5984829.6375693	2102999.3844439	37.7535582155387	-122.49540321629601	(37.7535582155387, -122.495403216296)
14158	14158	20429	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	485X Sunset Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	30
14206	14206	19813	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY24	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
14400	14400	19934	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
14425	14425	19694	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY7	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	12ST
14506	14506	20366	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
14521	14521	20280	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	20X Sunset Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
14597	14597	20303	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	50X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
14923	14923	20430	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	485X Sunset Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	30
14992	14992	19932	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
15767	15767	19699	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY11	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	40ST
15771	15771	19908	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
15978	15978	19943	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
16086	16086	20423	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
16424	16424	19949	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	25ST
16454	16454	20294	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	20X Sunset Blvd	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
16608	16608	19951	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
16721	16721	19947	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	25ST
16878	16878	19909	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	120ST
17092	17092	19978	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY45	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	30ST
18087	18087	21247	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2401X Sunset Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60		5985051.1945321	2098862.1753589	37.7422115377949	-122.49433209823401	(37.7422115377949, -122.494332098234)
18718	18718	21167	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2301 Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60		5985027.9083074005	2099542.6271361	37.744078511576	-122.49446276258301	(37.744078511576, -122.494462762583)
19244	19244	20545	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1303X Sunset Blvd	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	6O		5984802.8376111	2106327.3646052	37.7626943540195	-122.49574136031299	(37.7626943540195, -122.495741360313)
19606	19606	21428	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2692X Sunset Blvd	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60		5985040.0664617	2096882.0619327	37.7367740271268	-122.494224659054	(37.7367740271268, -122.494224659054)
19643	19643	21239	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2401X Sunset Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60		5985051.1945321	2098862.1753589	37.7422115377949	-122.49433209823401	(37.7422115377949, -122.494332098234)
20621	20621	21114	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2201X Sunset Blvd	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60		5985004.6737667	2100227.1692458	37.745956718592794	-122.494593556276	(37.7459567185928, -122.494593556276)
23006	23006	5050	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	5399X Diamond Heights Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			19			6001979.62541	2098516.88417	37.7422395880754	-122.43577421703002	(37.7422395880754, -122.43577421703)
23021	23021	5047	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	5399X Diamond Heights Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30			6002007.86459	2098449.21717	37.7420553943514	-122.43567173476002	(37.7420553943514, -122.43567173476)
23106	23106	5048	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	5399X Diamond Heights Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			26			6002000.04243	2098472.35983	37.7421184943815	-122.435700436623	(37.7421184943815, -122.435700436623)
23130	23130	5046	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	5399X Diamond Heights Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30			6002013.964380001	2098440.0292	37.7420305128012	-122.43564998647	(37.7420305128012, -122.43564998647)
23272	23272	5052	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	5399X Diamond Heights Blvd	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			27			6001966.9976699995	2098545.79058	37.742318241009606	-122.43581994754999	(37.7423182410096, -122.43581994755)
23275	23275	5049	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	5399X Diamond Heights Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			39			6001985.29603	2098499.31047	37.7421916569134	-122.43575335275101	(37.7421916569134, -122.435753352751)
23290	23290	5051	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	5399X Diamond Heights Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16			6001971.36584	2098533.18854	37.7422838868872	-122.43580394232	(37.7422838868872, -122.43580394232)
28418	28418	20917	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1901X Sunset Blvd	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60		5984934.4009631	2102260.4913733	37.75153555211671	-122.494986448304	(37.7515355521167, -122.494986448304)
30531	30531	21160	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2301 Sunset Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60		5985027.9083074005	2099542.6271361	37.744078511576	-122.49446276258301	(37.744078511576, -122.494462762583)
44566	44566	21326	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2501X Sunset Blvd	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60		5985074.890734901	2098188.1189419	37.740362147215	-122.494200494189	(37.740362147215, -122.494200494189)
45340	45340	20906	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1901X Sunset Blvd	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60		5984934.4009631	2102260.4913733	37.75153555211671	-122.494986448304	(37.7515355521167, -122.494986448304)
52925	52925	21108	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2201X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60		5985004.6737667	2100227.1692458	37.745956718592794	-122.494593556276	(37.7459567185928, -122.494593556276)
53596	53596	21025	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2101X Sunset Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60		5984980.9284488	2100900.997098	37.7478054765444	-122.49472533299699	(37.7478054765444, -122.494725332997)
58969	58969	20977	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2002X Sunset Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	40		5984887.616570599	2101567.3225095	37.7496295616808	-122.49509712324499	(37.7496295616808, -122.495097123245)
66637	66637	20618	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1492X Sunset Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60		5984803.7392562	2105036.6950477003	37.759150589029495	-122.495643037613	(37.7591505890295, -122.495643037613)
67562	67562	20729	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1601X Sunset Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60		5984865.3499442	2104298.7792233997	37.7571280850658	-122.49537554020701	(37.7571280850658, -122.495375540207)
74389	74389	21381	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2601X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40		5985098.343425	2097506.3093477003	37.7384914535226	-122.494069167367	(37.7384914535226, -122.494069167367)
77330	77330	20837	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1801X Sunset Blvd	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60		5984911.465596	2102939.293478	37.7533980132231	-122.495115810531	(37.7533980132231, -122.495115810531)
77616	77616	21117	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2201X Sunset Blvd	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60		5985004.6737667	2100227.1692458	37.745956718592794	-122.494593556276	(37.7459567185928, -122.494593556276)
77754	77754	21175	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2301 Sunset Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60		5985027.9083074005	2099542.6271361	37.744078511576	-122.49446276258301	(37.744078511576, -122.494462762583)
77826	77826	20716	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1601X Sunset Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60		5984865.3499442	2104298.7792233997	37.7571280850658	-122.49537554020701	(37.7571280850658, -122.495375540207)
77957	77957	20834	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1801X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60		5984911.465596	2102939.293478	37.7533980132231	-122.495115810531	(37.7533980132231, -122.495115810531)
78034	78034	20777	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1701X Sunset Blvd	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60		5984888.092725	2103630.7874996	37.7552952964732	-122.49524762816002	(37.7552952964732, -122.49524762816)
78243	78243	21452	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2701X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40		5985119.006821499	2096832.7848434	37.73664334454379	-122.49394810120701	(37.7366433445438, -122.493948101207)

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