Street_Tree_List

Data source: data.sfgov.org

1,505 rows where qSiteInfo = 3 sorted by PlotSize

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, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize ▼	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
731	731	251375	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	401 Portola Dr	3	Median : Yard 3	Tree 1	DPW 2						5998962.0	2100210.0	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)
747	747	251378	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	401 Portola Dr	6	Median : Yard 3	Tree 1	DPW 2						5998962.0	2100210.0	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)
749	749	251374	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	401 Portola Dr	2	Median : Yard 3	Tree 1	DPW 2						5998962.0	2100210.0	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)
757	757	251377	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	401 Portola Dr	5	Median : Yard 3	Tree 1	DPW 2						5998962.0	2100210.0	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)
763	763	251373	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	401 Portola Dr	1	Median : Yard 3	Tree 1	DPW 2						5998962.0	2100210.0	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)
764	764	251379	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	401 Portola Dr	7	Median : Yard 3	Tree 1	DPW 2						5998962.0	2100210.0	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)
785	785	251376	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	401 Portola Dr	4	Median : Yard 3	Tree 1	DPW 2						5998962.0	2100210.0	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)
1098	1098	251438	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2501X Santiago St	1	Median : Yard 3	Tree 1	DPW 2
3898	3898	212122	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300x Miramar Ave	4	Median : Yard 3	Tree 1	DPW 2			3			5995365.2918	2092257.6675200001	37.724675368963105	-122.45819147914699	(37.7246753689631, -122.458191479147)
10203	10203	106598	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	1001X SAN JOSE AVE	11	Median : Yard 3	Tree 1	DPW 2			21			6004855.0	2096548.0	37.7369963898236	-122.42569194885799	(37.7369963898236, -122.425691948858)
10408	10408	106060	DPW Maintained 3	Calocedrus decurrens :: Incense Cedar 177	12X Canyon Dr	3	Median : Yard 3	Tree 1	DPW 2			24			6003183.55845	2086355.5239400002	37.7089155261884	-122.430743733243	(37.7089155261884, -122.430743733243)
11659	11659	106061	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	12X Canyon Dr	1	Median : Yard 3	Tree 1	DPW 2			40			6003256.93175	2086330.4794599998	37.7088509162175	-122.430488359046	(37.7088509162175, -122.430488359046)
13314	13314	187669	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	554 Valley St	1	Median : Yard 3	Tree 1	Private 1						6002324.0	2099197.0	37.7441265828549	-122.434632098307	(37.7441265828549, -122.434632098307)
18076	18076	107933	DPW Maintained 3	Tree(s) :: 17	3098X Market St	1	Median : Yard 3	Tree 1	DPW 2						5999920.0	2105144.0	37.7603188321069	-122.44337164916	(37.7603188321069, -122.44337164916)
19618	19618	102860	DPW Maintained 3	Calocedrus decurrens :: Incense Cedar 177	10X CRANLEIGH DR	1	Median : Yard 3	Tree 1	DPW 2		03/06/2013 12:00:00 AM	6			5991339.0	2095700.0	37.7338949747581	-122.472360557436	(37.7338949747581, -122.472360557436)
22823	22823	251110	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	5	Median : Yard 3	Tree 1	DPW 2
22825	22825	251109	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	3	Median : Yard 3	Tree 1	DPW 2
22828	22828	251115	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	19	Median : Yard 3	Tree 1	DPW 2
22831	22831	251116	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	20	Median : Yard 3	Tree 1	DPW 2
22832	22832	251108	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	2	Median : Yard 3	Tree 1	DPW 2
22833	22833	251113	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	15	Median : Yard 3	Tree 1	DPW 2
22838	22838	251111	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	7	Median : Yard 3	Tree 1	DPW 2
22839	22839	251114	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	16	Median : Yard 3	Tree 1	DPW 2
22840	22840	251107	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1700X Quesada Ave	1	Median : Yard 3	Tree 1	DPW 2
23423	23423	195472	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			7			6014582.56054	2117381.49578	37.7947454787808	-122.39351677468099	(37.7947454787808, -122.393516774681)
23725	23725	234421	DPW Maintained 3	Phoenix spp :: Date palm (species unknown) 319	1500x Dolores St	7	Median : Yard 3	Tree 1	DPW 2			13			6005260.39309	2099383.33918	37.7448044887417	-122.42449194134701	(37.7448044887417, -122.424491941347)
23869	23869	212124	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300x Miramar Ave	6	Median : Yard 3	Tree 1	DPW 2			5			5995365.62659	2092320.18392	37.72484704325171	-122.45819484441999	(37.7248470432517, -122.45819484442)
23986	23986	204965	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	400x Miramar Ave	4	Median : Yard 3	Tree 1	DPW 2			15			5995367.63483	2092532.42925	37.725429933419	-122.458203256674	(37.725429933419, -122.458203256674)
24029	24029	250142	DPW Maintained 3	Magnolia spp :: Magnolia 89	2550x Lyon St	10	Median : Yard 3	Tree 1	DPW 2			1			5999229.6006	2117622.80882	37.7945430395703	-122.44665726921801	(37.7945430395703, -122.446657269218)
24045	24045	211638	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	605x Saint Francis Blvd	1	Median : Yard 3	Tree 1	DPW 2			12			5993404.24438	2096035.5287900001	37.7349355669295	-122.465244802603	(37.7349355669295, -122.465244802603)
24270	24270	188526	DPW Maintained 3	Acacia baileyana :: Bailey's Acacia 42	1427x Innes Ave	12	Median : Yard 3	Tree 1	DPW 2			13			6016254.90623	2096663.3838099998	37.7379507994938	-122.386285047323	(37.7379507994938, -122.386285047323)
24347	24347	222775	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	2950x Cesar Chavez St	9	Median : Yard 3	Tree 1	DPW 2			3			6009484.1227400005	2100580.43593	37.7483290712363	-122.40997151459	(37.7483290712363, -122.40997151459)
24462	24462	211631	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	605x Saint Francis Blvd	2	Median : Yard 3	Tree 1	DPW 2			21			5993552.90123	2096075.99565	37.735055250506704	-122.464733785358	(37.7350552505067, -122.464733785358)
24494	24494	233935	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	150x Dolores St	9	Median : Yard 3	Tree 1	DPW 2			30			6004826.52958	2107279.95522	37.766462234780604	-122.426554344032	(37.7664622347806, -122.426554344032)
24677	24677	111241	DPW Maintained 3	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	745X SANCHEZ ST	4	Median : Yard 3	Tree 1	DPW 2			6			6003713.0	2103768.0	37.7567562336472	-122.430155272915	(37.7567562336472, -122.430155272915)
24818	24818	191371	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	900x Carolina St	66	Median : Yard 3	Tree 1	DPW 2			13			6012518.79145	2102845.53786	37.7547181653131	-122.39963665401699	(37.7547181653131, -122.399636654017)
24866	24866	189991	DPW Maintained 3	Cercis occidentalis :: Western Redbud 246	1427x Innes Ave	18	Median : Yard 3	Tree 1	DPW 2			20			6016204.83732	2096710.6252	37.7380777432808	-122.386461454743	(37.7380777432808, -122.386461454743)
24947	24947	206807	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	11x Saint Francis Blvd	1	Median : Yard 3	Tree 1	DPW 2			12			5991689.221530001	2095992.9314700002	37.734719554257296	-122.471171081279	(37.7347195542573, -122.471171081279)
25183	25183	249466	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	900x Van Ness Ave	4	Median : Yard 3	Tree 1	DPW 2			25			6006522.49711	2113836.87509	37.7845616899264	-122.421153924138	(37.7845616899264, -122.421153924138)
25207	25207	214407	DPW Maintained 3	Prunus serrulata :: Ornamental Cherry 35	200x Terrace Dr	11	Median : Yard 3	Tree 1	DPW 2			8			5993812.00581	2096497.7556200002	37.7362282335302	-122.463868579087	(37.7362282335302, -122.463868579087)
25336	25336	197493	DPW Maintained 3	Schinus molle :: California Pepper 138	950x Kansas St	7	Median : Yard 3	Tree 1	DPW 2			25			6011595.701219999	2103803.27065	37.7572963894245	-122.402896325021	(37.7572963894245, -122.402896325021)
25604	25604	250134	DPW Maintained 3	Cordyline australis :: Dracena Palm 141	2550x Lyon St	2	Median : Yard 3	Tree 1	DPW 2			15			5999224.86929	2117537.18532	37.7943076699218	-122.446667476532	(37.7943076699218, -122.446667476532)
25922	25922	197195	DPW Maintained 3	Quercus agrifolia :: Coast Live Oak 180	1700x Quesada Ave	52	Median : Yard 3	Tree 1	DPW 2			5			6014229.96459	2095381.0032900001	37.734317354963395	-122.393196613328	(37.7343173549634, -122.393196613328)
26183	26183	195467	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			8			6014580.603680001	2117309.91593	37.7945488285163	-122.393518533752	(37.7945488285163, -122.393518533752)
26465	26465	213721	DPW Maintained 3	Prunus x yedoensis :: Yoshino Cherry 237	66x Santa Monica Way	2	Median : Yard 3	Tree 1	DPW 2			1			5993647.57824	2097426.08398	37.7387677148629	-122.46450445281401	(37.7387677148629, -122.464504452814)
26676	26676	247028	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	550x Valley St	6	Median : Yard 3	Tree 1	DPW 2			10			6002355.441269999	2099181.9915400003	37.744087157999296	-122.43452230856701	(37.7440871579993, -122.434522308567)
26840	26840	194523	DPW Maintained 3	Pinus thunbergii :: Japanese Black Pine 306	900x Carolina St	72	Median : Yard 3	Tree 1	DPW 2			3			6012512.869530001	2102814.17539	37.7546317206991	-122.399654931846	(37.7546317206991, -122.399654931846)
26953	26953	223749	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	5200x Diamond Heights Blvd	33	Median : Yard 3	Tree 1	DPW 2			52			6001564.8370199995	2098920.55277	37.743324397105	-122.43723732135099	(37.743324397105, -122.437237321351)
27106	27106	195241	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400x Evans Ave	17	Median : Yard 3	Tree 1	DPW 2			5			6016370.1217	2098002.92096	37.7416352733631	-122.38598003597299	(37.7416352733631, -122.385980035973)
27134	27134	194292	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	43	Median : Yard 3	Tree 1	DPW 2			38			6014354.24031	2095291.86255	37.734079495961396	-122.392760714642	(37.7340794959614, -122.392760714642)
27156	27156	194439	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	900x Carolina St	32	Median : Yard 3	Tree 1	DPW 2			12			6012481.17054	2103301.60211	37.755968320994704	-122.3997987802	(37.7559683209947, -122.3997987802)
27253	27253	124144	DPW Maintained 3	Metrosideros excelsa :: New Zealand Xmas Tree 2	4100x Geary Blvd	6	Median : Yard 3	Tree 1	DPW 2			14			5994110.98895	2112812.2270400003	37.7810407796467	-122.464018802579	(37.7810407796467, -122.464018802579)
27255	27255	193544	DPW Maintained 3	Melaleuca nesophila :: Pink Melaleuca 93	900x Carolina St	10	Median : Yard 3	Tree 1	DPW 2			22			6012476.687390001	2103624.0786200003	37.75685352098429	-122.39983692765499	(37.7568535209843, -122.399836927655)
27355	27355	234354	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	650x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			23			6004979.813630001	2104508.3497200003	37.7588607286626	-122.425826859935	(37.7588607286626, -122.425826859935)
27546	27546	222774	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	2950x Cesar Chavez St	10	Median : Yard 3	Tree 1	DPW 2			1			6009463.63512	2100579.86171	37.748326346280706	-122.41004232002301	(37.7483263462807, -122.410042320023)
27563	27563	197474	DPW Maintained 3	Salix matsudana 'Tortuosa' :: Corkscrew Willow 228	1700x Quesada Ave	47	Median : Yard 3	Tree 1	DPW 2			9			6014305.55494	2095325.1628400001	37.7341682275767	-122.392931365507	(37.7341682275767, -122.392931365507)
27594	27594	194293	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	46	Median : Yard 3	Tree 1	DPW 2			28			6014318.796490001	2095319.19207	37.7341525685742	-122.392885167337	(37.7341525685742, -122.392885167337)
27702	27702	191370	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	900x Carolina St	63	Median : Yard 3	Tree 1	DPW 2			15			6012517.15762	2102887.31193	37.75483277672829	-122.399645237162	(37.7548327767283, -122.399645237162)
27755	27755	211070	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	500x Miramar Ave	7	Median : Yard 3	Tree 1	DPW 2			24			5995378.929819999	2093188.4321700002	37.7272318087773	-122.45821166894699	(37.7272318087773, -122.458211668947)
27784	27784	177494	DPW Maintained 3	Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315	1002x Naples St	8	Median : Yard 3	Tree 1	DPW 2			1			6001533.96245	2088133.73568	37.7137045060241	-122.43657215399901	(37.7137045060241, -122.436572153999)
27904	27904	210220	DPW Maintained 3	Melaleuca styphelliodes :: Paperbark Tree 239	198x San Anselmo Ave	17	Median : Yard 3	Tree 1	DPW 2			15			5993632.14987	2096264.78649	37.7355781918881	-122.464473499973	(37.7355781918881, -122.464473499973)
27995	27995	211600	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	500x Saint Francis Blvd	2	Median : Yard 3	Tree 1	DPW 2			24			5993318.7926	2096075.03242	37.7350391058631	-122.465543105951	(37.7350391058631, -122.465543105951)
28030	28030	197577	DPW Maintained 3	Schinus terebinthifolius :: Brazilian Pepper 25	299x Cashmere St	5	Median : Yard 3	Tree 1	DPW 2			33			6016820.77887	2095888.49241	37.735854408739	-122.38427457691002	(37.735854408739, -122.38427457691)
28194	28194	195471	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			7			6014542.5915	2117352.94839	37.794664873444795	-122.393653075045	(37.7946648734448, -122.393653075045)
28390	28390	195474	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			7			6014565.75221	2117404.86556	37.794808712796396	-122.393576570627	(37.7948087127964, -122.393576570627)
28724	28724	199407	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	301x Cashmere St	7	Median : Yard 3	Tree 1	DPW 2			18			6016184.136419999	2096191.07332	37.736650012889	-122.386496812495	(37.736650012889, -122.386496812495)
28806	28806	217820	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1x Junipero Serra Blvd	7	Median : Yard 3	Tree 1	DPW 2			3			5991627.31768	2095659.9754599999	37.733801760145504	-122.471360849935	(37.7338017601455, -122.471360849935)
29290	29290	204967	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	500x Miramar Ave	6	Median : Yard 3	Tree 1	DPW 2			15			5995373.3226	2092827.47447	37.7262403835647	-122.45820493933	(37.7262403835647, -122.45820493933)
29345	29345	196269	DPW Maintained 3	Prunus cerasifera :: Cherry Plum 16	50x Dedman Ct	2	Median : Yard 3	Tree 1	DPW 2			12			6016851.53049	2096187.80946	37.7366779736991	-122.38418909364599	(37.7366779736991, -122.384189093646)
29553	29553	211075	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	650x Miramar Ave	6	Median : Yard 3	Tree 1	DPW 2			34			5995390.83549	2093912.64173	37.7292209976493	-122.458222905073	(37.7292209976493, -122.458222905073)
29712	29712	244826	DPW Maintained 3	Washingtonia robusta :: Mexican Fan Palm 75	500x Dolores St	8	Median : Yard 3	Tree 1	DPW 2			20			6004940.864159999	2105188.02891	37.760724766043	-122.42600994929501	(37.760724766043, -122.426009949295)
29906	29906	250138	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	2550x Lyon St	6	Median : Yard 3	Tree 1	DPW 2			101			5999227.62567	2117605.22496	37.7944946461503	-122.446662836939	(37.7944946461503, -122.446662836939)
29933	29933	188870	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	1300x De Haro St	30	Median : Yard 3	Tree 1	DPW 2			15			6012283.09076	2102020.40062	37.7524393767806	-122.40039382202299	(37.7524393767806, -122.400393822023)
30111	30111	198501	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	900x Carolina St	13	Median : Yard 3	Tree 1	DPW 2			15			6012463.03254	2103576.30053	37.7567215715659	-122.399880796574	(37.7567215715659, -122.399880796574)
30213	30213	194449	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1300x De Haro St	23	Median : Yard 3	Tree 1	DPW 2			23			6012259.687999999	2102130.23115	37.752739642445505	-122.40048246731399	(37.7527396424455, -122.400482467314)
30261	30261	239066	DPW Maintained 3	Pyrus calleryana :: Ornamental Pear 9	100x McCoppin St	9	Median : Yard 3	Tree 1	DPW 2			4			6005897.29527	2109110.01262	37.7715476104631	-122.42298083840001	(37.7715476104631, -122.4229808384)
30436	30436	203829	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	200x Terrace Dr	41	Median : Yard 3	Tree 1	DPW 2			18			5993865.8273	2096513.9581	37.7362758229773	-122.463683673072	(37.7362758229773, -122.463683673072)
30631	30631	205755	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	200x Terrace Dr	36	Median : Yard 3	Tree 1	DPW 2			5			5993878.86602	2096471.7721400002	37.7361607421118	-122.463635532375	(37.7361607421118, -122.463635532375)
30642	30642	176917	DPW Maintained 3	Lagunaria patersonii :: Primrose Tree 48	1002x Naples St	9	Median : Yard 3	Tree 1	DPW 2			3			6001514.03799	2088123.65893	37.7136757052349	-122.436640299224	(37.7136757052349, -122.436640299224)
30666	30666	189167	DPW Maintained 3	Afrocarpus gracilior :: Fern Pine 70	1300x De Haro St	18	Median : Yard 3	Tree 1	DPW 2			1			6012264.80612	2102152.7525400002	37.7528017667079	-122.40046634965	(37.7528017667079, -122.40046634965)
31115	31115	189330	DPW Maintained 3	Cordyline australis :: Dracena Palm 141	1427x Innes Ave	23	Median : Yard 3	Tree 1	DPW 2			15			6016163.75351	2096735.77367	37.7381445215441	-122.386605256348	(37.7381445215441, -122.386605256348)
31162	31162	247033	DPW Maintained 3	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	550x Valley St	11	Median : Yard 3	Tree 1	DPW 2			8			6002285.13208	2099166.02387	37.7440393230544	-122.434764280156	(37.7440393230544, -122.434764280156)
31535	31535	194476	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900x Carolina St	43	Median : Yard 3	Tree 1	DPW 2			22			6012491.75598	2103075.9348299997	37.755349278054	-122.39974632722799	(37.755349278054, -122.399746327228)
31865	31865	195466	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			8			6014635.8418	2117314.36588	37.794564116081204	-122.393327712917	(37.7945641160812, -122.393327712917)
32031	32031	190995	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	10x Cashmere St	3	Median : Yard 3	Tree 1	DPW 2			28			6017237.22965	2095860.87095	37.7358015834667	-122.38283280631599	(37.7358015834667, -122.382832806316)
32049	32049	211072	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	602x Miramar Ave	2	Median : Yard 3	Tree 1	DPW 2			35			5995382.34021	2093429.0746900002	37.7278927511259	-122.45821728880699	(37.7278927511259, -122.458217288807)
32165	32165	211633	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	605x Saint Francis Blvd	4	Median : Yard 3	Tree 1	DPW 2			14			5993517.47022	2096073.45578	37.7350462338855	-122.464856097643	(37.7350462338855, -122.464856097643)
32328	32328	211103	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	2187x 09th Ave	7	Median : Yard 3	Tree 1	DPW 2			42			5993592.96046	2100932.97127	37.7483935940092	-122.464947913926	(37.7483935940092, -122.464947913926)
32359	32359	191816	DPW Maintained 3	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	1300x De Haro St	2	Median : Yard 3	Tree 1	DPW 2			18			6012277.20441	2102232.55885	37.7530215888816	-122.40042907904899	(37.7530215888816, -122.400429079049)
32648	32648	210219	DPW Maintained 3	Melaleuca styphelliodes :: Paperbark Tree 239	198x San Anselmo Ave	16	Median : Yard 3	Tree 1	DPW 2			8			5993631.1051199995	2096269.3526	37.735590669066895	-122.46447744347601	(37.7355906690669, -122.464477443476)
32653	32653	194410	DPW Maintained 3	Photinia fraseri :: Photinia: Chinese photinia 104	1700x Quesada Ave	42	Median : Yard 3	Tree 1	DPW 2			2			6014359.990180001	2095279.52622	37.7340459422739	-122.39273997266899	(37.7340459422739, -122.392739972669)
32869	32869	189966	DPW Maintained 3	Cercis canadensis :: Eastern Redbud 299	900x Carolina St	73	Median : Yard 3	Tree 1	DPW 2			1			6012515.82864	2102790.5172099997	37.754566925442795	-122.39964303739201	(37.7545669254428, -122.399643037392)
33003	33003	194020	DPW Maintained 3	Morus alba :: White Mulberry 112	1100x Bay Shore Blvd	1	Median : Yard 3	Tree 1	DPW 2			6			6011361.40113	2093925.29225	37.7301604996095	-122.403011863611	(37.7301604996095, -122.403011863611)
33017	33017	218260	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	1400x Portola Dr	18	Median : Yard 3	Tree 1	DPW 2			12			5992795.95946	2097207.23373	37.738117677685	-122.46743301504	(37.738117677685, -122.46743301504)
33156	33156	234362	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	4	Median : Yard 3	Tree 1	DPW 2			25			6005144.45634	2101528.47617	37.7506879938715	-122.425045428228	(37.7506879938715, -122.425045428228)
33836	33836	246868	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	3090x Market St	1	Median : Yard 3	Tree 1	DPW 2			32			5999955.5697	2105338.29244	37.760854339489	-122.443262585704	(37.760854339489, -122.443262585704)
34133	34133	211073	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	602x Miramar Ave	5	Median : Yard 3	Tree 1	DPW 2			26			5995385.83715	2093544.41078	37.7282096371561	-122.458213544022	(37.7282096371561, -122.458213544022)
34159	34159	124136	DPW Maintained 3	Metrosideros excelsa :: New Zealand Xmas Tree 2	3600x Geary Blvd	1	Median : Yard 3	Tree 1	DPW 2			21			5995735.89711	2112868.88763	37.7812898666102	-122.458401576021	(37.7812898666102, -122.458401576021)
34333	34333	217817	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1x Junipero Serra Blvd	4	Median : Yard 3	Tree 1	DPW 2			27			5991627.99201	2095776.79312	37.7341225510202	-122.47136702736	(37.7341225510202, -122.47136702736)
34339	34339	194442	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	900x Carolina St	51	Median : Yard 3	Tree 1	DPW 2			24			6012500.2858	2102979.92319	37.7550861265451	-122.39971008726499	(37.7550861265451, -122.399710087265)

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