Street_Tree_List

Data source: data.sfgov.org

319 rows where qSiteInfo = 10 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: SiteOrder, DBH, PlotSize

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
16896	16896	100001	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	501X 01st St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1					Address is 100 1st Street
23385	23385	225339	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3033 Castro St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			15	Width 3ft		6002890.27268	2096019.3333400001	37.73543357459229	-122.43244713645001	(37.7354335745923, -122.43244713645)
23717	23717	190342	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	101 Howard St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 3ft		6014826.26604	2116061.6193	37.7911349426626	-122.39258114252199	(37.7911349426626, -122.392581142522)
23903	23903	128508	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	415 Montgomery St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6011852.868919999	2116847.94752	37.7931284347821	-122.40292438836	(37.7931284347821, -122.40292438836)
24173	24173	190232	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	536 Mission St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 4ft		6013096.96075	2115369.31377	37.7891378442858	-122.398515922465	(37.7891378442858, -122.398515922465)
24563	24563	128713	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	555 Jackson St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 4ft		6011289.01038	2117973.50016	37.7961874301503	-122.404954668136	(37.7961874301503, -122.404954668136)
24608	24608	128760	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	145 Geary St	12	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 4ft		6010990.83089	2114854.39463	37.7876064418291	-122.405766620129	(37.7876064418291, -122.405766620129)
24865	24865	127538	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	170 O'Farrell St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 3ft		6010539.53779	2114494.20954	37.7865922116181	-122.40730261183701	(37.7865922116181, -122.407302611837)
25634	25634	128547	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	530 California St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 4ft		6011621.44747	2116740.1603200003	37.792819551831	-122.40371753735	(37.792819551831, -122.40371753735)
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)
26967	26967	127517	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	330 Geary St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 4ft		6010076.35722	2114778.73619	37.7873475198145	-122.40892519296499	(37.7873475198145, -122.408925192965)
27270	27270	126949	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3439 Sacramento St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 2ft		5998374.58367	2115190.1998	37.787814864221204	-122.449440363388	(37.7878148642212, -122.449440363388)
27365	27365	128529	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	350 California St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 3ft		6012461.93985	2116858.6183599997	37.79319172545561	-122.400817703074	(37.7931917254556, -122.400817703074)
27373	27373	127889	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1520 Mason St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 3ft		6009298.57619	2118522.06879	37.797582201307705	-122.411880784278	(37.7975822013077, -122.411880784278)
27853	27853	128263	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2 Lombard St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 4ft		6012051.14949	2120876.60895	37.80420123766179	-122.402521741194	(37.8042012376618, -122.402521741194)
27938	27938	128409	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	251 Sutter St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 3ft		6011283.06953	2115589.6115900003	37.789641511384204	-122.40480730793699	(37.7896415113842, -122.404807307937)
27957	27957	128525	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	300 California St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 4ft		6012595.64796	2116876.01852	37.7932469591239	-122.40035628434099	(37.7932469591239, -122.400356284341)
28116	28116	128527	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	350 California St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 3ft		6012510.08821	2116864.88564	37.79321161938179	-122.400651546131	(37.7932116193818, -122.400651546131)
28732	28732	127522	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	441 Mason St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 4ft		6009737.67951	2114979.8254	37.7878806856047	-122.410111154116	(37.7878806856047, -122.410111154116)
28810	28810	189783	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1712 20th St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			9	Width 3ft		6012852.355219999	2104746.67943	37.759956872734705	-122.39861649547501	(37.7599568727347, -122.398616495475)
28844	28844	128476	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	209 Front St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 5ft		6013054.34541	2116659.1488799998	37.792677054245296	-122.398753923573	(37.7926770542453, -122.398753923573)
29953	29953	128264	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2 Lombard St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 4ft		6012036.74363	2120874.77061	37.8041953857812	-122.40257146471201	(37.8041953857812, -122.402571464712)
30172	30172	176454	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1609 Burrows St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 2ft		6006663.80662	2092086.9978599998	37.7248494992863	-122.41912174768801	(37.7248494992863, -122.419121747688)
30751	30751	117574	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	838 Grant Ave	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	3x3		6010874.95685	2117476.8733599996	37.7948006593736	-122.406352374685	(37.7948006593736, -122.406352374685)
30955	30955	128524	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	300 California St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 4ft		6012616.9506	2116879.25162	37.7932570243399	-122.400282802519	(37.7932570243399, -122.400282802519)
31309	31309	128503	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	132 Bush St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 4ft		6012584.68475	2116164.76471	37.791293413119604	-122.400344237911	(37.7912934131196, -122.400344237911)
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)
31876	31876	190283	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	199 New Montgomery St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6012884.630030001	2114398.01689	37.786459058895396	-122.399182357001	(37.7864590588954, -122.399182357001)
32331	32331	127525	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	535 Post St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 4ft		6009652.45173	2115007.72817	37.787952522523604	-122.41040799874399	(37.7879525225236, -122.410407998744)
32420	32420	128487	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	201 Montgomery St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 3ft		6011932.367980001	2116321.01874	37.7916860526201	-122.40261224357701	(37.7916860526201, -122.402612243577)
33006	33006	190233	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	536 Mission St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 4ft		6013086.524119999	2115360.2171099996	37.789112285559	-122.39855139355	(37.789112285559, -122.39855139355)
34574	34574	128396	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	316 Sutter St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			19	Width 2ft		6010818.135480001	2115581.56402	37.7895934165555	-122.40641537306801	(37.7895934165555, -122.406415373068)
34732	34732	100681	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	400 California St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3			6012316.03692	2116830.7554099998	37.793107081281	-122.401320580594	(37.793107081281, -122.401320580594)
34983	34983	127970	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	362 Green St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			13	Width 2ft		6011213.49855	2119375.68536	37.800033269380705	-122.40531474949199	(37.8000332693807, -122.405314749492)
35364	35364	128452	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	251 Leidesdorff St	9	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 4ft		6012151.25811	2116572.97679	37.7923900877774	-122.401872599739	(37.7923900877774, -122.401872599739)
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)
35844	35844	128267	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2 Lombard St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 4ft		6011926.44398	2120867.47841	37.8041692046961	-122.402952654037	(37.8041692046961, -122.402952654037)
36109	36109	224807	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1468 Sanchez St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			13	Width 2ft		6003911.9159	2099717.26212	37.7456451201217	-122.42917852528099	(37.7456451201217, -122.429178525281)
37180	37180	128397	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	316 Sutter St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			18	Width 2ft		6010793.77559	2115575.52379	37.7895754687694	-122.406499230364	(37.7895754687694, -122.406499230364)
37302	37302	128464	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	341 California St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6012520.637080001	2116804.75779	37.7930471108983	-122.400610820334	(37.7930471108983, -122.400610820334)
38130	38130	176461	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	55 University St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 2ft		6007804.4952	2093798.5187099997	37.7296131398345	-122.415299613696	(37.7296131398345, -122.415299613696)
38194	38194	128461	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	341 California St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6012421.30504	2116788.3689900003	37.7929965707839	-122.40095336493	(37.7929965707839, -122.40095336493)
38476	38476	128530	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	350 California St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 3ft		6012448.833769999	2116858.16011	37.7931897361809	-122.400863019012	(37.7931897361809, -122.400863019012)
38836	38836	128483	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	330 Pine St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6012246.35245	2116465.43051	37.7921000977961	-122.401536006882	(37.7921000977961, -122.401536006882)
38890	38890	127532	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	120 O'Farrell St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 3ft		6010687.11448	2114513.1880200002	37.7866525804096	-122.406793368031	(37.7866525804096, -122.406793368031)
38934	38934	128755	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	145 Geary St	7	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 4ft		6010904.689619999	2114841.17743	37.7875653329327	-122.406063721978	(37.7875653329327, -122.406063721978)
39147	39147	128532	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	400 California St	7	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 4ft		6012207.58991	2116821.4003	37.793075343307706	-122.401695158101	(37.7930753433077, -122.401695158101)
39485	39485	127520	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	330 Geary St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 4ft		6010050.03669	2114776.41152	37.787339662444296	-122.409016092817	(37.7873396624443, -122.409016092817)
40208	40208	190282	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	199 New Montgomery St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6012894.58638	2114386.5408900003	37.7864281033285	-122.399147104454	(37.7864281033285, -122.399147104454)
40454	40454	128494	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	369 Pine St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 3ft		6012086.37369	2116397.02316	37.791903339624206	-122.40208472734	(37.7919033396242, -122.40208472734)
40545	40545	128466	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	339 California St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6012617.3816	2116817.144	37.7930865155706	-122.400276947047	(37.7930865155706, -122.400276947047)
40547	40547	127858	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1108 Broadway	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			19	Width 3ft		6008285.2726300005	2118276.37484	37.796850686473704	-122.41536969425199	(37.7968506864737, -122.415369694252)
41155	41155	190263	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	90 New Montgomery St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6012423.70042	2114824.63943	37.787604766388704	-122.400807051507	(37.7876047663887, -122.400807051507)
42227	42227	128497	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	369 Pine St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 3ft		6012145.6983900005	2116403.64758	37.7919248397015	-122.40187992831999	(37.7919248397015, -122.40187992832)
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)
42610	42610	190236	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	536 Mission St	7	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 4ft		6013048.93642	2115320.74397	37.78900180744421	-122.39867867189	(37.7890018074442, -122.39867867189)
42784	42784	190255	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	200 Jessie St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 3ft		6012186.05792	2114789.42008	37.7874948044956	-122.401626776367	(37.7874948044956, -122.401626776367)
42894	42894	128552	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	580 California St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 4ft		6011490.88451	2116722.25518	37.7927630941901	-122.404168032955	(37.7927630941901, -122.404168032955)
43095	43095	190249	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	60 New Montgomery St	10	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6012276.22435	2114985.84699	37.788039177600496	-122.401328625912	(37.7880391776005, -122.401328625912)
43991	43991	128439	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	465 California St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 4ft		6012038.72301	2116739.36453	37.792840667902205	-122.40227368028098	(37.7928406679022, -122.402273680281)
44223	44223	128534	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	400 California St	9	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 4ft		6012182.93636	2116816.5819200003	37.7930607374112	-122.40178012248	(37.7930607374112, -122.40178012248)
44891	44891	128484	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	340 Pine St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 5ft		6012215.94703	2116460.90061	37.7920859631489	-122.40164089212	(37.7920859631489, -122.40164089212)
45413	45413	127536	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	170 O'Farrell St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 3ft		6010547.33485	2114491.60788	37.7865855044578	-122.407275452313	(37.7865855044578, -122.407275452313)
45734	45734	127516	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	335 Powell St	10	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 4ft		6010248.078369999	2114825.1066799997	37.7874844595824	-122.408334342849	(37.7874844595824, -122.408334342849)
45775	45775	190241	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	60 New Montgomery St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6012114.72864	2115154.34395	37.788492819034296	-122.40189922508499	(37.7884928190343, -122.401899225085)
45900	45900	128404	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	256 Grant Ave	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 3ft		6011139.161169999	2115522.02731	37.789447896346395	-122.40530045746	(37.7894478963464, -122.40530045746)
46090	46090	124519	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2600 McAllister St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			9	Width 3ft		5996655.7016	2110825.61641	37.775732396387	-122.45507183027901	(37.775732396387, -122.455071830279)
46403	46403	190240	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	60 New Montgomery St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6012103.08796	2115166.4168599998	37.7885253187384	-122.401940349294	(37.7885253187384, -122.401940349294)
46434	46434	126951	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3415 Sacramento St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 2ft		5998522.53196	2115207.8527599997	37.7878717966889	-122.448929764319	(37.7878717966889, -122.448929764319)
47179	47179	190230	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	536 Mission St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 4ft		6013118.573340001	2115391.45981	37.7891998561378	-122.398442699681	(37.7891998561378, -122.398442699681)
47342	47342	190260	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	133 Stevenson St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 2ft		6011906.25914	2114729.61472	37.78731497604279	-122.402590622073	(37.7873149760428, -122.402590622073)
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)
47619	47619	128540	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	500 California St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 2ft		6011802.9353	2116766.16876	37.792901101453	-122.403091407767	(37.792901101453, -122.403091407767)
47719	47719	128502	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	132 Bush St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 4ft		6012604.33357	2116166.4373	37.7912991013205	-122.400276370582	(37.7912991013205, -122.400276370582)
47721	47721	127531	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	120 O'Farrell St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 3ft		6010719.61226	2114518.87728	37.7866700200467	-122.406681334082	(37.7866700200467, -122.406681334082)
47930	47930	128544	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	530 California St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 4ft		6011688.454609999	2116749.36363	37.7928485648657	-122.403486336041	(37.7928485648657, -122.403486336041)
48463	48463	127971	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	362 Green St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			10	Width 2ft		6011201.12165	2119373.80056	37.8000274021903	-122.405357445712	(37.8000274021903, -122.405357445712)
48492	48492	128717	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	533 Jackson St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 4ft		6011384.22669	2117985.2759700003	37.7962250856765	-122.404626027992	(37.7962250856765, -122.404626027992)
48622	48622	128369	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	843 California St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			15	Width 4ft		6010471.73552	2116514.30785	37.792135122785794	-122.4076796805	(37.7921351227858, -122.4076796805)
48642	48642	128399	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	316 Sutter St	7	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			18	Width 2ft		6010737.082769999	2115568.6338	37.789553378722296	-122.406694896775	(37.7895533787223, -122.406694896775)
50503	50503	127765	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1333 Pacific Ave	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			14	Width 3ft		6007766.08598	2117818.11446	37.7955632233194	-122.417133718062	(37.7955632233194, -122.417133718062)
50792	50792	128463	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	341 California St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6012488.2358800005	2116798.24071	37.793027409438295	-122.40072247297199	(37.7930274094383, -122.400722472972)
50823	50823	128752	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	145 Geary St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 4ft		6010880.59623	2114836.4857	37.7875511029568	-122.40614675006901	(37.7875511029568, -122.406146750069)
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)
51772	51772	190261	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	133 Stevenson St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 2ft		6011936.19797	2114760.72734	37.7874020753891	-122.402489228003	(37.7874020753891, -122.402489228003)
51921	51921	126780	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1999 Greenwich St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 3ft		6003378.10961	2119281.63802	37.7993338540344	-122.432421449996	(37.7993338540344, -122.432421449996)
52079	52079	190228	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	49 Stevenson St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6012841.04857	2115639.9268900002	37.789866624291705	-122.399420358065	(37.7898666242917, -122.399420358065)
52311	52311	128412	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	251 Sutter St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 3ft		6011365.53208	2115598.62793	37.7896708769491	-122.404522629328	(37.7896708769491, -122.404522629328)
52580	52580	128714	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	555 Jackson St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 4ft		6011300.18953	2117974.45497	37.796190676719796	-122.40491605306102	(37.7961906767198, -122.404916053061)
53018	53018	128375	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	737 Pine St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 2ft		6010401.69926	2116151.41193	37.7911347772081	-122.407896406291	(37.7911347772081, -122.407896406291)
53539	53539	128496	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	369 Pine St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 3ft		6012121.65939	2116400.50289	37.7919148635227	-122.401962882698	(37.7919148635227, -122.401962882698)
53753	53753	128467	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	339 California St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 3ft		6012650.63962	2116819.58835	37.793095081631606	-122.40016204337	(37.7930950816316, -122.40016204337)
53829	53829	126781	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1999 Greenwich St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			8	Width 3ft		6003391.3469	2119282.63843	37.799337351503894	-122.43237571586701	(37.7993373515039, -122.432375715867)
53915	53915	128551	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	580 California St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 4ft		6011511.008830001	2116724.7014099997	37.7927709353884	-122.404098573787	(37.7927709353884, -122.404098573787)
54111	54111	128493	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	201 Montgomery St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6011961.6023	2116106.4791900003	37.791098610068005	-122.402495999902	(37.791098610068, -122.402495999902)
54314	54314	226532	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	138 Scott St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			14	Width 4ft		6002359.73994	2109019.2730900003	37.7710982111319	-122.435210930252	(37.7710982111319, -122.435210930252)
55028	55028	100685	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	400 California St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4			6012263.39214	2116825.45731	37.7930895966627	-122.40150236324101	(37.7930895966627, -122.401502363241)
55480	55480	128498	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	333 Pine St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 4ft		6012193.280040001	2116411.15767	37.791948115965795	-122.401715822721	(37.7919481159658, -122.401715822721)
55793	55793	128501	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	132 Bush St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 4ft		6012626.68616	2116169.5344599998	37.7913088517754	-122.4001992483	(37.7913088517754, -122.4001992483)

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