Street_Tree_List

Data source: data.sfgov.org

329 rows where qCaretaker = 2 and qSpecies = 51 sorted by qAddress

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
99288	99288	90134	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	100X Balboa St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/11/2008 12:00:00 AM	3	3x3		5995229.54942	2111496.31673	37.7774920413779	-122.460053813186	(37.7774920413779, -122.460053813186)
64598	64598	123720	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	101 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/12/2008 12:00:00 AM	3	Width 3ft		5995264.25203	2111440.07761	37.7773396195467	-122.459929691175	(37.7773396195467, -122.459929691175)
89034	89034	90380	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	101 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/12/2008 12:00:00 AM	3	3x3		5995315.581431	2111451.352271	37.7773735286818	-122.459752944165	(37.7773735286818, -122.459752944165)
22422	22422	7875	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1050 Franklin St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/18/2014 02:38:00 PM	3	4X4		6006070.45315	2113764.9909599996	37.7843388199314	-122.422712735214	(37.7843388199314, -122.422712735214)
20345	20345	5583	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1069 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3x3		6005153.43733	2102137.63056	37.752361098006894	-122.42505770847299	(37.7523610980069, -122.425057708473)
94498	94498	90379	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	109 Balboa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/12/2008 12:00:00 AM	3	3x3		5995291.794305	2111450.466195	37.7773697278094	-122.459835166842	(37.7773697278094, -122.459835166842)
128337	128337	90378	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	109 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/12/2008 12:00:00 AM	3	3x3		5995235.890819999	2111438.83153	37.777334567000295	-122.460027710853	(37.7773345670003, -122.460027710853)
76907	76907	180414	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1104x Alemany Blvd	4	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6003758.53299	2094425.58203	37.73110669070989	-122.42933162228	(37.7311066907099, -122.42933162228)
180303	180303	180413	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1104x Alemany Blvd	3	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6003786.93346	2094435.4492400002	37.731135391684	-122.42923414026001	(37.731135391684, -122.42923414026)
183887	183887	180412	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1104x Alemany Blvd	2	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6003814.30975	2094445.54262	37.7311646556118	-122.42914021505501	(37.7311646556118, -122.429140215055)
58391	58391	182082	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1109 Taraval St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/04/2017 12:00:00 AM	3	Width 0ft		5989746.1732	2098995.6798	37.7428517447762	-122.47810825386001	(37.7428517447762, -122.47810825386)
92825	92825	25288	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	110X Ocean Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/06/1996 12:00:00 AM	10	3x3		6000890.43944	2091777.01619	37.7236715433472	-122.43905734896299	(37.7236715433472, -122.439057348963)
127224	127224	475	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1110X Guerrero St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/11/2015 06:40:00 PM	3	3x3		6005715.8108342	2102491.4524088	37.753364362762	-122.42313807467801	(37.753364362762, -122.423138074678)
18648	18648	10186	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1130 Guerrero St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/03/2015 04:47:00 AM	3	4x5		6005723.69305	2102361.07491	37.753006821117296	-122.423101549889	(37.7530068211173, -122.423101549889)
38671	38671	180422	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1132x Alemany Blvd	10	Median : Cutout 11	Tree 1	DPW 2			1	Width 3ft		6003342.53075	2094283.93013	37.7306941860739	-122.43075970881901	(37.7306941860739, -122.430759708819)
51014	51014	180421	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1132x Alemany Blvd	9	Median : Cutout 11	Tree 1	DPW 2			1	Width 3ft		6003365.77706	2094291.48085	37.7307162356701	-122.430679881378	(37.7307162356701, -122.430679881378)
57854	57854	180417	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1132x Alemany Blvd	4	Median : Cutout 11	Tree 1	DPW 2			1	Width 3ft		6003506.26836	2094339.1696799998	37.730855136838606	-122.430197582161	(37.7308551368386, -122.430197582161)
64285	64285	180415	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1132x Alemany Blvd	1	Median : Cutout 11	Tree 1	DPW 2			1	Width 3ft		6003554.97456	2094355.58631	37.7309029717957	-122.43003036762899	(37.7309029717957, -122.430030367629)
66122	66122	180418	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1132x Alemany Blvd	5	Median : Cutout 11	Tree 1	DPW 2			1	Width 3ft		6003475.18041	2094328.74311	37.73082474696329	-122.430304314596	(37.7308247469633, -122.430304314596)
116442	116442	180419	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1132x Alemany Blvd	6	Median : Cutout 11	Tree 1	DPW 2			1	Width 3ft		6003443.67237	2094317.91582	37.7307932329079	-122.43041247068001	(37.7307932329079, -122.43041247068)
135967	135967	180423	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1132x Alemany Blvd	11	Median : Cutout 11	Tree 1	DPW 2			1	Width 3ft		6003317.211680001	2094273.79477	37.7306649221452	-122.430846517675	(37.7306649221452, -122.430846517675)
151084	151084	180420	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1132x Alemany Blvd	7	Median : Cutout 11	Tree 1	DPW 2			1	Width 3ft		6003421.2672	2094309.3598599997	37.7307684709799	-122.430489318632	(37.7307684709799, -122.430489318632)
166485	166485	180416	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1132x Alemany Blvd	3	Median : Cutout 11	Tree 1	DPW 2			1	Width 3ft		6003534.67772	2094349.44618	37.730884962851896	-122.430100099258	(37.7308849628519, -122.430100099258)
11646	11646	27701	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1136 Silver Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		09/26/2000 12:00:00 AM	6			6008329.0437900005	2093834.9235	37.729742566663106	-122.413488762206	(37.7297425666631, -122.413488762206)
18209	18209	10188	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1148 Guerrero St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/05/2016 12:00:00 AM	3	2x4		6005734.612380001	2102244.83146	37.75268825965679	-122.423055527089	(37.7526882596568, -122.423055527089)
108794	108794	28590	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1150 Ocean Ave	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/03/2003 12:00:00 AM	6	3X3		5996248.46954	2091917.7406900001	37.7237927195289	-122.45511390994899	(37.7237927195289, -122.455113909949)
117573	117573	28588	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1150 Ocean Ave	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		5996248.46954	2091917.7406900001	37.7237927195289	-122.45511390994899	(37.7237927195289, -122.455113909949)
119764	119764	28589	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1150 Ocean Ave	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/03/2003 12:00:00 AM	6	3X3		5996248.46954	2091917.7406900001	37.7237927195289	-122.45511390994899	(37.7237927195289, -122.455113909949)
21836	21836	10190	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1160 Guerrero St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/04/2015 09:38:00 AM	3	2x2		6005734.23383	2102203.6860700003	37.7525752625596	-122.42305391193001	(37.7525752625596, -122.42305391193)
12988	12988	904	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1179 Alemany Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/22/2016 12:00:00 AM	3	2X2		6003419.3756099995	2094263.29224	37.7306418725253	-122.430492572378	(37.7306418725253, -122.430492572378)
81038	81038	17707	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1195X Pierce St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2012 12:00:00 AM	3	4x4		6002295.810192	2112602.9289849997	37.78093440458979	-122.435688496636	(37.7809344045898, -122.435688496636)
98332	98332	17706	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1195X Pierce St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2012 12:00:00 AM	3	4x4		6002295.810192	2112602.9289849997	37.78093440458979	-122.435688496636	(37.7809344045898, -122.435688496636)
168366	168366	217730	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1200x Arguello Blvd	1	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		5995796.25486	2107257.89675	37.765887025696394	-122.45778663137101	(37.7658870256964, -122.457786631371)
104360	104360	28574	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1220X Capitol Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/01/2003 12:00:00 AM	3	3X3		5995089.2906	2091962.0897099997	37.72384792002239	-122.459124181231	(37.7238479200224, -122.459124181231)
101199	101199	90135	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	126 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/11/2008 12:00:00 AM	3	3x3		5995236.784291999	2111488.444802	37.77747084326629	-122.460028215119	(37.7774708432663, -122.460028215119)
144194	144194	12106	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1281X La Salle Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/23/1996 12:00:00 AM	6	3X3		6017033.141005999	2094557.4754692002	37.732211440602605	-122.383447721977	(37.7322114406026, -122.383447721977)
78777	78777	25313	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	131 Ocean Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		09/24/1998 12:00:00 AM	3	3X3		6000709.1204	2091674.68705	37.723380252154605	-122.439676803494	(37.7233802521546, -122.439676803494)
81338	81338	29886	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1332 Guerrero St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	3x3		6005784.3311963	2101201.415557	37.7498260853424	-122.422809442933	(37.7498260853424, -122.422809442933)
154	154	830	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1384 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/28/2017 12:15:00 PM	3	5.5x6.5		5981549.5887	2105676.5499	37.7607163481902	-122.506944712409	(37.7607163481902, -122.506944712409)
144739	144739	90136	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	140 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/11/2008 12:00:00 AM	3	3x3		5995114.1393800005	2111493.06072	37.7774764627193	-122.46045281608299	(37.7774764627193, -122.460452816083)
15469	15469	12131	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1400X La Salle Ave	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6016434.11275	2095220.18267	37.7339979769066	-122.38556488553499	(37.7339979769066, -122.385564885535)
22997	22997	12121	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1400X La Salle Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	3X3		6016540.00349	2094984.34395	37.733356269266295	-122.38518235797899	(37.7333562692663, -122.385182357979)
89638	89638	22703	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1410 Turk St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/19/2001 12:00:00 AM	6	3X3		6003133.70477	2112422.88036	37.7804875932729	-122.432776943127	(37.7804875932729, -122.432776943127)
140327	140327	28595	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1418 Ocean Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/03/2003 12:00:00 AM	3	3X3		5995511.49061	2092119.93233	37.724305580756	-122.45767612998999	(37.724305580756, -122.45767612999)
118689	118689	90377	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	145 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/12/2008 12:00:00 AM	3	3x3		5995096.57692	2111433.9292099997	37.7773130929711	-122.46050928420901	(37.7773130929711, -122.460509284209)
81738	81738	16859	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	150 Oak St	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/14/2012 12:00:00 AM	3	4X4	Permit Number 768229	6006257.87931	2110498.54999	37.7753805408795	-122.421832203671	(37.7753805408795, -122.421832203671)
15078	15078	2525	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1570 Burke Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/10/2016 02:24:00 PM	3	3X3		6016567.66909	2098923.0431	37.7441726718323	-122.385361080243	(37.7441726718323, -122.385361080243)
16215	16215	2527	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1570 Burke Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/10/2016 02:21:00 PM	3	3X3		6016536.91868	2098947.33995	37.7442376847211	-122.38546910231001	(37.7442376847211, -122.38546910231)
23334	23334	8279	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1601 Galvez Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			1	3x3		6015771.79311	2097687.24817	37.740735369454605	-122.388026849781	(37.7407353694546, -122.388026849781)
110986	110986	12738	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1630 Lake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/12/2013 12:00:00 AM	100	4x4		5990343.3046	2114764.5197400004	37.7861833727245	-122.47719566934299	(37.7861833727245, -122.477195669343)
122804	122804	22761	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1640 Turk St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/11/1997 12:00:00 AM	6	3X3		6002164.690701	2112286.628689	37.7800584752671	-122.436119461658	(37.7800584752671, -122.436119461658)
140395	140395	22763	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1640 Turk St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/15/2003 12:00:00 AM	3	4X4		6002164.690701	2112286.628689	37.7800584752671	-122.436119461658	(37.7800584752671, -122.436119461658)
142359	142359	22762	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1640 Turk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/31/2005 12:00:00 AM	3	4X4		6002164.690701	2112286.628689	37.7800584752671	-122.436119461658	(37.7800584752671, -122.436119461658)
92169	92169	86485	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1674 27th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/02/2016 10:49:00 AM	3	3x3		5987816.321957	2103904.0922479997	37.7562167246282	-122.48514111531401	(37.7562167246282, -122.485141115314)
83003	83003	22765	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1674 Turk St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/11/1997 12:00:00 AM	6	4X4		6002010.254376	2112254.96617	37.7799627627699	-122.436651458736	(37.7799627627699, -122.436651458736)
92194	92194	26649	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1686 Turk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/24/1998 12:00:00 AM	6	4X4		6001954.59403	2112257.165987	37.7799656396512	-122.43684416995899	(37.7799656396512, -122.436844169959)
141503	141503	22770	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1720 Turk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/14/1997 12:00:00 AM	12	4X4		6001784.069495	2112233.869511	37.7798919802951	-122.437432420828	(37.7798919802951, -122.437432420828)
92071	92071	89399	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1732 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/2008 12:00:00 AM	3	3x3		5993250.39877	2112105.36057	37.7790502810604	-122.466944583124	(37.7790502810604, -122.466944583124)
14420	14420	27150	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1735 Silver Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6011122.20395	2095139.1072200001	37.73348002049129	-122.403924187157	(37.7334800204913, -122.403924187157)
117268	117268	27148	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1735 Silver Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6011160.620490001	2095185.02583	37.7336082495359	-122.403794599522	(37.7336082495359, -122.403794599522)
2333	2333	253025	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1754 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/11/2017 12:00:00 AM	3			5993444.58369	2103545.63859	37.7555587516047	-122.465650780273	(37.7555587516047, -122.465650780273)
128364	128364	26781	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1762 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6004617.6627263	2098622.9472722	37.7426803093545	-122.426660244792	(37.7426803093545, -122.426660244792)
90093	90093	26175	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1780X Turk St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/14/1997 12:00:00 AM	3	4X4		6001669.86946	2112366.9914599997	37.78025100635529	-122.437837026039	(37.7802510063553, -122.437837026039)
90518	90518	27611	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1785 Turk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/15/2005 12:00:00 AM	3	3X3		6001483.34096	2112120.46472	37.7795634979855	-122.438464644811	(37.7795634979855, -122.438464644811)
11707	11707	28306	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1818 San Jose Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/05/2003 12:00:00 AM	3			6000533.35164	2093598.6883900003	37.7286531126447	-122.440422323457	(37.7286531126447, -122.440422323457)
12474	12474	28305	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1818 San Jose Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/05/2003 12:00:00 AM	3			6000543.0489	2093613.5897099997	37.7286945803894	-122.440389867794	(37.7286945803894, -122.440389867794)
128148	128148	12774	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1842 Lake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/15/1997 12:00:00 AM	20	6		5989637.59951	2114741.75598	37.7860799008728	-122.479635529609	(37.7860799008728, -122.479635529609)
120125	120125	89708	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1909 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/08/2008 12:00:00 AM	3	3x3		5992720.07551	2112029.7859799997	37.77881215056829	-122.468773668914	(37.7788121505683, -122.468773668914)
121201	121201	89710	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1909 Anza St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/08/2008 12:00:00 AM	3	3x3		5992788.830333999	2112037.5206509996	37.7788373596805	-122.46853638391	(37.7788373596805, -122.46853638391)
91662	91662	89403	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1920 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/2008 12:00:00 AM	3	3x3		5992698.73667	2112085.38755	37.77896358458921	-122.468851534899	(37.7789635845892, -122.468851534899)
99292	99292	89404	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1926 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/2008 12:00:00 AM	3	3x3		5992675.04364	2112084.25544	37.7789591072669	-122.46893341544799	(37.7789591072669, -122.468933415448)
101719	101719	89405	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1932 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/2008 12:00:00 AM	3	3x3		5992650.02375	2112083.7442099997	37.778956257991794	-122.469019931283	(37.7789562579918, -122.469019931283)
84485	84485	89706	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1945X Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/08/2008 12:00:00 AM	3	3x3		5992682.1024279995	2112033.696052	37.7788206927431	-122.46890531620701	(37.7788206927431, -122.468905316207)
100265	100265	89705	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1945X Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/08/2008 12:00:00 AM	3	3x3		5992682.1024279995	2112033.696052	37.7788206927431	-122.46890531620701	(37.7788206927431, -122.468905316207)
106406	106406	89707	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1945X Anza St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/08/2008 12:00:00 AM	3	3x3		5992682.1024279995	2112033.696052	37.7788206927431	-122.46890531620701	(37.7788206927431, -122.468905316207)
96062	96062	93317	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1950X Turk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/20/2008 12:00:00 AM	3	3x3		6000619.3	2112146.9	37.7795868963645	-122.44145562214399	(37.7795868963645, -122.441455622144)
125760	125760	93316	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1950X Turk St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/20/2008 12:00:00 AM	3	3x3		6000619.3	2112146.9	37.7795868963645	-122.44145562214399	(37.7795868963645, -122.441455622144)
89527	89527	12448	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1989X Pine St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/31/2006 12:00:00 AM	3	3X3		6004432.626396201	2115327.1853143997	37.7885356724235	-122.428490433403	(37.7885356724235, -122.428490433403)
125579	125579	1467	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	200 Arguello Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			90	3X3		5995559.29766	2114744.3111900003	37.786429126950104	-122.45914836167401	(37.7864291269501, -122.459148361674)
23242	23242	1673	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	200 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			4			5994963.861330001	2111486.70203	37.7774503572538	-122.460972213003	(37.7774503572538, -122.460972213003)
93068	93068	90137	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	200 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/11/2008 12:00:00 AM	3	3x3		5995004.121864	2111479.789375	37.7774336935409	-122.460832438394	(37.7774336935409, -122.460832438394)
117469	117469	90138	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	200 Balboa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/11/2008 12:00:00 AM	3	3x3		5994945.69814	2111487.08268	37.777450357249705	-122.461035072626	(37.7774503572497, -122.461035072626)
143672	143672	18582	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	200 Randolph St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/08/2005 12:00:00 AM	3	3X3		5993482.998785401	2088541.1278418999	37.7143623091404	-122.46442855867399	(37.7143623091404, -122.464428558674)
145771	145771	18583	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	200 Randolph St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/08/2005 12:00:00 AM	3	3X3		5993482.998785401	2088541.1278418999	37.7143623091404	-122.46442855867399	(37.7143623091404, -122.464428558674)
120387	120387	90376	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	201 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/2008 12:00:00 AM	3	3x3		5995005.5622849995	2111439.815319	37.7773240182898	-122.460824557776	(37.7773240182898, -122.460824557776)
128353	128353	432	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2010X Lake St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/15/1997 12:00:00 AM	30	3X3		5989200.24086	2114740.63501	37.786051407249	-122.481148573701	(37.786051407249, -122.481148573701)
79386	79386	89701	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2015 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/08/2008 12:00:00 AM	3	3x3		5992461.7466589995	2112025.799575	37.7787862776475	-122.469667031742	(37.7787862776475, -122.469667031742)
87722	87722	89704	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2015 Anza St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/08/2008 12:00:00 AM	3	3x3		5992461.7466589995	2112025.799575	37.7787862776475	-122.469667031742	(37.7787862776475, -122.469667031742)
98205	98205	89702	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2015 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/08/2008 12:00:00 AM	3	3x3		5992461.7466589995	2112025.799575	37.7787862776475	-122.469667031742	(37.7787862776475, -122.469667031742)
121331	121331	89703	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2015 Anza St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/08/2008 12:00:00 AM	3	3x3		5992461.7466589995	2112025.799575	37.7787862776475	-122.469667031742	(37.7787862776475, -122.469667031742)
88106	88106	89406	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2016 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/2008 12:00:00 AM	3	3x3		5992454.35988	2112065.560542	37.778895023507204	-122.469695480685	(37.7788950235072, -122.469695480685)
128548	128548	89408	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2016 Anza St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/2008 12:00:00 AM	3	3x3		5992454.35988	2112065.560542	37.778895023507204	-122.469695480685	(37.7788950235072, -122.469695480685)
141649	141649	89407	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2016 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/2008 12:00:00 AM	3	3x3		5992454.35988	2112065.560542	37.778895023507204	-122.469695480685	(37.7788950235072, -122.469695480685)
85717	85717	89409	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2020 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/2008 12:00:00 AM	3	3x3		5992384.83285	2112073.6126	37.7789131134856	-122.46993658655899	(37.7789131134856, -122.469936586559)
139995	139995	89410	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2026 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/2008 12:00:00 AM	3	3x3		5992351.89237	2112071.63774	37.778905786870006	-122.470050395926	(37.77890578687, -122.470050395926)
83727	83727	89413	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2040 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/2008 12:00:00 AM	3	3x3		5992290.09129	2112070.56721	37.778899274659096	-122.47026411052099	(37.7788992746591, -122.470264110521)
101814	101814	89414	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2040 Anza St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/2008 12:00:00 AM	3	3x3		5992264.76767	2112069.76613	37.7788956109976	-122.470351655835	(37.7788956109976, -122.470351655835)
124647	124647	89412	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2040 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/2008 12:00:00 AM	3	3x3		5992306.33207	2112071.26295	37.7789021239167	-122.47020797839501	(37.7789021239167, -122.470207978395)
97144	97144	89699	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2045 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/2008 12:00:00 AM	3	3x3		5992267.68335	2112010.1178099997	37.7787320015375	-122.47033722440001	(37.7787320015375, -122.4703372244)
103475	103475	89698	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2045 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/2008 12:00:00 AM	3	3x3		5992248.56439	2112009.3415	37.7787287645821	-122.470403307178	(37.7787287645821, -122.470403307178)

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