Street_Tree_List

Data source: data.sfgov.org

177 rows where SiteOrder = 6 and qSpecies = 32

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, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
116	116	26163	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	220 Richardson Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		5999083.87135	2119853.9919	37.8006609458028	-122.447322173097	(37.8006609458028, -122.447322173097)
945	945	26844	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 Van Ness Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3X3	Permit Number 775213	6006969.72882	2110998.7322	37.7767940394414	-122.419405236481	(37.7767940394414, -122.419405236481)
1044	1044	189667	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2585 03rd St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			17	Width 5ft		6015923.778390001	2103213.67674	37.7559182125844	-122.38788686398199	(37.7559182125844, -122.387886863982)
2416	2416	192163	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1500 Mission St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			29	Width 5ft	Permit Number 779453	6007335.7591	2109863.52425	37.7736976385647	-122.41805852779	(37.7736976385647, -122.41805852779)
6535	6535	23531	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2750 Van Ness Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/02/1991 12:00:00 AM	12	3x14		6005745.76756	2119852.67475	37.801035747261096	-122.42426915231701	(37.8010357472611, -122.424269152317)
7085	7085	42636	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1651 Union St	6	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2	06/26/2000 12:00:00 AM	16	4x5	Permit Number 42688	6005181.30457	2118838.80185	37.7982200229931	-122.426150217479	(37.7982200229931, -122.426150217479)
8457	8457	98627	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3500X Fillmore St	6	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		6	6x6		6002279.94472	2120071.20683	37.801439470916	-122.43627801543998	(37.801439470916, -122.43627801544)
13549	13549	100271	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Federal St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	1x1		6015178.9141	2113499.10422	37.7841184410568	-122.391181785729	(37.7841184410568, -122.391181785729)
14941	14941	6814	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1400X Fairfax Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Fire Dept 11			12	3X3		6016451.12132	2097615.70854	37.7405765491786	-122.38567298313801	(37.7405765491786, -122.385672983138)
16129	16129	117218	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 04th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/06/2016 12:00:00 AM	3		Permit Number 778712	6013744.24197	2111311.0843599997	37.7780309175198	-122.395991889732	(37.7780309175198, -122.395991889732)
17353	17353	5365	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	240 Dolores St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			60	3X3		6004803.09071	2106888.71484	37.7653866572999	-122.426607552398	(37.7653866572999, -122.426607552398)
18665	18665	27515	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1212 Guerrero St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/08/2000 12:00:00 AM	20	3X3		6005757.51944	2101764.30051	37.7513701251356	-122.422942160361	(37.7513701251356, -122.422942160361)
22162	22162	5537	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900X Dolores St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	6X6		6005030.13119	2102849.86658	37.754309766104704	-122.425534806003	(37.7543097661047, -122.425534806003)
22411	22411	7889	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1187 Franklin St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6005995.918959999	2113921.74849	37.7847650320158	-122.422981743131	(37.7847650320158, -122.422981743131)
22475	22475	7869	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1000 Franklin St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	2X2		6006093.62914	2113643.3001	37.7840059943141	-122.422623903791	(37.7840059943141, -122.422623903791)
22775	22775	9873	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1450X Gough St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			36	3X3		6005447.50636	2114747.87072	37.7870023977962	-122.424937868409	(37.7870023977962, -122.424937868409)
23201	23201	69744	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1855X Evans Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/16/2002 12:00:00 AM	8	3x3		6014390.51341	2099418.69013	37.7454129250631	-122.392923937985	(37.7454129250631, -122.392923937985)
23382	23382	117409	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1 Beach St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	3x3		6009993.98375	2122279.70822	37.8079387382549	-122.40973984921101	(37.8079387382549, -122.409739849211)
24331	24331	116062	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2100x 19th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		22	3x3		6011361.02056	2105129.82914	37.7609257168785	-122.40380128939199	(37.7609257168785, -122.403801289392)
25832	25832	127666	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	330 Gough St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 4ft		6005970.65388	2110994.02831	37.776724802442004	-122.422861006441	(37.776724802442, -122.422861006441)
26102	26102	190100	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	333 Bryant St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6014854.222680001	2113468.47977	37.7840163293331	-122.39230296780501	(37.7840163293331, -122.392302967805)
26104	26104	128132	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2600 Jones St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6007860.122769999	2121829.76573	37.8065835003791	-122.417092726973	(37.8065835003791, -122.417092726973)
26888	26888	128506	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	132 Bush St	6	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 4ft		6012518.245680001	2116156.64354	37.791267409218705	-122.400573546136	(37.7912674092187, -122.400573546136)
31156	31156	127591	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	10 Ada Ct	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6008103.92464	2114232.00134	37.7857356352375	-122.415710691104	(37.7857356352375, -122.415710691104)
31208	31208	126755	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1755 Filbert St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6004642.80849	2119109.0103599997	37.7989314955529	-122.42803284027	(37.7989314955529, -122.42803284027)
31725	31725	127856	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1032 Broadway	6	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			8	Width 4ft		6008567.79894	2118317.2360099996	37.7969787562238	-122.41439497666401	(37.7969787562238, -122.414394976664)
32266	32266	128575	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	401 Washington St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6012729.63146	2117830.234	37.7958744786734	-122.39995972918001	(37.7958744786734, -122.39995972918)
32903	32903	224347	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	400 Treat Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6008472.66716	2105986.00217	37.7631147899462	-122.41385143361099	(37.7631147899462, -122.413851433611)
33502	33502	128015	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	590 Bay St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6008102.7291	2121385.50842	37.8053773269677	-122.416221655308	(37.8053773269677, -122.416221655308)
33629	33629	190203	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 Mission St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6014289.71306	2116512.0501099997	37.7923419084079	-122.394469165733	(37.7923419084079, -122.394469165733)
34231	34231	113455	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	21X Leroy Pl	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	3x3		6008333.434719999	2116505.31715	37.7919905055181	-122.415077617845	(37.7919905055181, -122.415077617845)
34852	34852	190209	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	121 Main St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6013934.1509300005	2116607.29923	37.7925836677603	-122.395706104947	(37.7925836677603, -122.395706104947)
34905	34905	192058	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	650 07th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 3ft		6011956.11586	2109139.11712	37.7719675471034	-122.402024964707	(37.7719675471034, -122.402024964707)
35122	35122	189629	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1455 11th St	6	: 4	Tree 1	Private 1			16	Width 3ft		6007461.61467	2110284.7901	37.774861417042	-122.417653036967	(37.774861417042, -122.417653036967)
35452	35452	127427	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1870 Sacramento St	6	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 5ft		6005811.11401	2116269.47164	37.791200866578	-122.423788099553	(37.791200866578, -122.423788099553)
35691	35691	128410	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	251 Sutter St	6	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 3ft		6011310.6043300005	2115591.95138	37.789649474890204	-122.40471220461399	(37.7896494748902, -122.404712204614)
35825	35825	127549	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	222 Mason St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6009877.13299	2114323.5252900003	37.786086458068205	-122.409582329368	(37.7860864580682, -122.409582329368)
37712	37712	189773	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2150 26th St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20			6012060.25758	2101403.52141	37.750733131726605	-122.401121078568	(37.7507331317266, -122.401121078568)
39417	39417	189597	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	411 Bryant St	6	: 4	Tree 1	Private 1			18	Width 3ft		6014335.70711	2113051.36538	37.7828422230287	-122.39406764630199	(37.7828422230287, -122.394067646302)
39634	39634	190118	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	101 Potrero Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6010303.28446	2107744.33666	37.7680454129972	-122.407643899151	(37.7680454129972, -122.407643899151)
39949	39949	192040	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	650 06th St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 4ft		6012673.25756	2109734.64435	37.7736427295523	-122.39958612111299	(37.7736427295523, -122.399586121113)
40877	40877	224341	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2789 25th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 4ft		6010802.179330001	2101784.31753	37.7517084500914	-122.40549846028999	(37.7517084500914, -122.40549846029)
41139	41139	128664	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	97 Broadway	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6013268.51889	2118906.92776	37.798860852911794	-122.39817064036801	(37.7988608529118, -122.398170640368)
41706	41706	128045	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	681 North Point St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6008278.49061	2121698.88203	37.8062476530568	-122.41563560941601	(37.8062476530568, -122.415635609416)
42479	42479	128398	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	316 Sutter St	6	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			18	Width 2ft		6010766.953509999	2115572.55032	37.789565803762606	-122.406591822779	(37.7895658037626, -122.406591822779)
42903	42903	127979	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	160 Bay St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6009886.2429599995	2121622.25615	37.8061275009418	-122.41006626984199	(37.8061275009418, -122.410066269842)
43556	43556	128154	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	200 Beach St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6008962.5675800005	2122188.36917	37.80763009092271	-122.413302872331	(37.8076300909227, -122.413302872331)
45875	45875	104473	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	717 Battery St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/09/2013 12:00:00 AM	15		Permit Number 767241	6012444.15256	2118566.24043	37.7978794560379	-122.400999285182	(37.7978794560379, -122.400999285182)
45935	45935	128357	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1335 Battery St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 4ft		6012155.657380001	2120650.71533	37.8035868226221	-122.402144190498	(37.8035868226221, -122.402144190498)
47106	47106	126916	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	400 Maple St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		5996738.8499	2114848.29455	37.7867823777583	-122.45507494785	(37.7867823777583, -122.45507494785)
47198	47198	127149	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2889 Washington St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6000984.36539	2116205.0394599997	37.790750294535606	-122.44048384337401	(37.7907502945356, -122.440483843374)
47446	47446	190105	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	201 Utah St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6010619.2093	2107108.07344	37.7663160589515	-122.40650630353001	(37.7663160589515, -122.40650630353)
47518	47518	190235	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	536 Mission St	6	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 4ft		6013057.91483	2115332.27231	37.7890339617916	-122.398648416899	(37.7890339617916, -122.398648416899)
48725	48725	192075	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	121 Vermont St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6011153.91308	2107606.32876	37.767714054199296	-122.4046919339	(37.7677140541993, -122.4046919339)
49747	49747	128198	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	149 Beach St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6009875.274619999	2122264.42386	37.8078901181966	-122.410149593828	(37.8078901181966, -122.410149593828)
50424	50424	127420	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1890 Clay St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			23	Width 4ft		6005703.51164	2116578.9311599997	37.7920444900078	-122.424182418992	(37.7920444900078, -122.424182418992)
51696	51696	190245	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	60 New Montgomery St	6	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6012172.724909999	2115095.9567400003	37.788335738047294	-122.40169446025801	(37.7883357380473, -122.401694460258)
51824	51824	190130	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	100 Industrial St	6	: 4	Tree 1	Private 1			6	Width 4ft		6011690.7758	2097300.73442	37.7394471418669	-122.40211037869301	(37.7394471418669, -122.402110378693)
52929	52929	127253	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2655 Pierce St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6001595.65286	2117587.37126	37.7945806069538	-122.43846790596399	(37.7945806069538, -122.438467905964)
53680	53680	126689	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Divisadero St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		6000572.85603	2117944.92717	37.7955041297654	-122.44203258116	(37.7955041297654, -122.44203258116)
54448	54448	128257	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	350 Union St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 5ft		6011249.37748	2119726.1565099997	37.8009975836439	-122.405215287157	(37.8009975836439, -122.405215287157)
54551	54551	190305	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	250 Fremont St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		6014179.480169999	2115219.9282400003	37.7887879135751	-122.394760046963	(37.7887879135751, -122.394760046963)
55808	55808	126767	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	200 Moulton St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6002256.18471	2119333.5862	37.7994128081999	-122.43630741607299	(37.7994128081999, -122.436307416073)
56352	56352	128172	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	211 Beach St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6008992.41136	2122145.2973	37.80751350191	-122.413196542783	(37.80751350191, -122.413196542783)
56711	56711	128313	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1150 Sansome St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6011987.89355	2119708.52618	37.8009904349201	-122.402658450751	(37.8009904349201, -122.402658450751)
56736	56736	189769	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2250 26th St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			6011832.10193	2101383.8726	37.750666449719404	-122.401908684142	(37.7506664497194, -122.401908684142)
58176	58176	190178	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	91 Spear St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6014066.33849	2116896.15345	37.7933841462073	-122.39526897148701	(37.7933841462073, -122.395268971487)
58828	58828	124711	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3801 Jackson St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		5996022.33056	2115833.99098	37.7894477026869	-122.45762526722	(37.7894477026869, -122.45762526722)
59872	59872	127218	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2864 Broadway	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 4ft		5999923.49955	2117118.25276	37.793197274296496	-122.44422002466001	(37.7931972742965, -122.44422002466)
60518	60518	192096	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	999 Brannan St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6010680.62429	2108593.08012	37.770396983667105	-122.406398526079	(37.7703969836671, -122.406398526079)
60556	60556	128268	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2 Lombard St	6	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			10	Width 4ft		6011908.731240001	2120863.67473	37.8041577716296	-122.40301368295201	(37.8041577716296, -122.403013682952)
60722	60722	190333	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	103 Howard St	6	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 3ft		6014709.52276	2115946.6699599996	37.790812834303004	-122.39297702767999	(37.790812834303, -122.39297702768)
61069	61069	190158	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	70 Steuart St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		6014339.8825199995	2117128.7960900003	37.794038137695395	-122.394338778414	(37.7940381376954, -122.394338778414)
61359	61359	127617	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	888 O'Farrell St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 4ft		6007115.674269999	2114017.0842	37.7850899220143	-122.41911451442301	(37.7850899220143, -122.419114514423)
61472	61472	189819	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 15th St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 9ft		6010449.36204	2107378.3567	37.7670486916722	-122.407112829708	(37.7670486916722, -122.407112829708)
61607	61607	128089	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	103 North Point St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6009929.3053	2121926.00746	37.8069639397045	-122.409938701031	(37.8069639397045, -122.409938701031)
61654	61654	39864	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	55 Laurel St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/1999 12:00:00 AM	3		Permit Number 41168	5997953.08795	2116209.11804	37.7905884228715	-122.450972154365	(37.7905884228715, -122.450972154365)
63073	63073	127334	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2519 Buchanan St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 5ft		6003631.32326	2116988.45877	37.7930517289146	-122.431381455107	(37.7930517289146, -122.431381455107)
63744	63744	192124	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	807 Mission St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	Width 4ft		6011038.85416	2113311.4371599997	37.783372530757	-122.405491758548	(37.783372530757, -122.405491758548)
63873	63873	128223	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	68 Green St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6012526.94097	2119558.19703	37.800607748201706	-122.40078253779801	(37.8006077482017, -122.400782537798)
64469	64469	103110	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	300 Post St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	3x3		6010569.23716	2115194.23983	37.78851599007729	-122.40724922448099	(37.7885159900773, -122.407249224481)
66897	66897	127066	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3252 Pierce St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 4ft		6001373.24322	2119563.45138	37.799993750456	-122.439379184512	(37.799993750456, -122.439379184512)
68082	68082	127695	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	751 Powell St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 5ft		6010039.16596	2116275.66028	37.7914556301243	-122.40915953648899	(37.7914556301243, -122.409159536489)
68907	68907	126884	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	405 Locust St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5997637.84633	2114997.8058	37.7872444296326	-122.451975438022	(37.7872444296326, -122.451975438022)
69399	69399	128027	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2601 Jones St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 4ft		6007857.44883	2121500.5557	37.805679422729796	-122.417078639064	(37.8056794227298, -122.417078639064)
69898	69898	224726	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	601 Treat Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6008500.75873	2105007.22335	37.7604288657294	-122.41368504013701	(37.7604288657294, -122.413685040137)
70142	70142	127034	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3851 Divisadero St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6000084.18121	2121482.18207	37.8051886276142	-122.443977752677	(37.8051886276142, -122.443977752677)
71657	71657	38964	Permitted Site 1	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1550 Bay St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/17/1998 12:00:00 AM	5		Permit Number 40757	6003391.6163099995	2120720.68173	37.8032858591085	-122.432477552408	(37.8032858591085, -122.432477552408)
71950	71950	127986	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	240 Bay St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 4ft		6009643.46605	2121590.90767	37.8060278156006	-122.410904227563	(37.8060278156006, -122.410904227563)
73014	73014	225355	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	133 Otis St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6006802.94235	2109264.67463	37.7720233374282	-122.41985912520599	(37.7720233374282, -122.419859125206)
73685	73685	127828	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2700 Van Ness Ave	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 3ft		6005757.99202	2119756.0775599997	37.8007712062878	-122.42421997648	(37.8007712062878, -122.42421997648)
73958	73958	128683	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	270 Washington St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6013072.617880001	2117933.47822	37.7961770789746	-122.39878017295901	(37.7961770789746, -122.398780172959)
74051	74051	189804	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2301 Alameda St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 4ft		6010161.88086	2107830.45794	37.7682739658081	-122.408139075755	(37.7682739658081, -122.408139075755)
74321	74321	127926	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Leavenworth St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		6007288.0253	2122150.87728	37.8074329910053	-122.419095373256	(37.8074329910053, -122.419095373256)
74902	74902	128148	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	580 North Point St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6007683.23621	2121673.01387	37.8061431473497	-122.417693760054	(37.8061431473497, -122.417693760054)
75919	75919	128326	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	149 Union St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6012193.5058	2119805.81438	37.801269042182	-122.401953783358	(37.801269042182, -122.401953783358)
76226	76226	115611	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	501 02nd St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	3x3		6014535.65202	2113111.2382799997	37.7830177311291	-122.393380106518	(37.7830177311291, -122.393380106518)
76374	76374	128081	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	109 North Point St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		6009658.7273699995	2121889.09987	37.8068474325394	-122.410872486877	(37.8068474325394, -122.410872486877)
76724	76724	189615	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1022 Harrison St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 0ft		6010985.3669300005	2110629.90425	37.77600667669871	-122.40548788698	(37.7760066766987, -122.40548788698)
76863	76863	127566	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	55 Cyril Magnin St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6010148.26915	2113833.31733	37.784755652982504	-122.408609672995	(37.7847556529825, -122.408609672995)

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