Street_Tree_List

Data source: data.sfgov.org

556 rows where qSiteInfo = 9 and qSpecies = 47 sorted by XCoord

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord ▼	YCoord	Latitude	Longitude	Location
272	272	251264	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
277	277	251265	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
293	293	251262	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
300	300	251263	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
682	682	251365	Private 5	Cupressus macrocarpa :: Monterey Cypress 47	138x Gladeview Way	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1
712	712	251366	Private 5	Cupressus macrocarpa :: Monterey Cypress 47	138x Gladeview Way	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1
713	713	251364	Private 5	Cupressus macrocarpa :: Monterey Cypress 47	138x Gladeview Way	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1
137510	137510	118414	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	641 48th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			26			5980997.21538	2111360.64896	37.7762906814163	-122.509277221064	(37.7762906814163, -122.509277221064)
168002	168002	118630	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	349 Point Lobos Ave	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			5981637.79887	2112651.0038099997	37.7798713628306	-122.507157052361	(37.7798713628306, -122.507157052361)
165920	165920	184816	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1201 Sunset Blvd	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			57	Width 0ft		5984628.5558	2106956.7675	37.7644123094409	-122.49639057415199	(37.7644123094409, -122.496390574152)
132952	132952	184826	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1201 Sunset Blvd	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			50	Width 0ft		5984631.5936	2106918.0361	37.7643061418827	-122.49637720932199	(37.7643061418827, -122.496377209322)
72988	72988	184885	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1201 Sunset Blvd	74	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 0ft		5984635.3908	2106778.1095	37.763922165271104	-122.496353750703	(37.7639221652711, -122.496353750703)
149256	149256	184738	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			61	Width 0ft		5984659.3131	2106254.4766	37.7624858178148	-122.496232374853	(37.7624858178148, -122.496232374853)
75050	75050	184344	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1251 Sunset Blvd	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 0ft		5984661.1293	2106390.2273	37.7628586575157	-122.496236109768	(37.7628586575157, -122.496236109768)
28097	28097	184746	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			73	Width 0ft		5984670.325	2106153.0915	37.7622080878104	-122.49618680876499	(37.7622080878104, -122.496186808765)
164893	164893	184780	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	41	Sidewalk: Property side : Yard 9	Tree 1	Private 1			69	Width 0ft		5984672.982999999	2105911.7799	37.7615456694917	-122.496159811415	(37.7615456694917, -122.496159811415)
148614	148614	184757	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	30	Sidewalk: Property side : Yard 9	Tree 1	Private 1			47	Width 0ft		5984673.5526	2106021.7086	37.7618475362622	-122.496165952154	(37.7618475362622, -122.496165952154)
44201	44201	184765	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			32	Width 0ft		5984675.641	2106093.0958	37.7620436678288	-122.496163996397	(37.7620436678288, -122.496163996397)
39649	39649	184824	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1201 Sunset Blvd	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 0ft		5984678.6788	2106921.0739	37.7643172410191	-122.496214581481	(37.7643172410191, -122.496214581481)
70817	70817	184775	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	36	Sidewalk: Property side : Yard 9	Tree 1	Private 1			26	Width 0ft		5984678.6788	2105968.358	37.7617013507315	-122.49614428665701	(37.7617013507315, -122.496144286657)
164533	164533	184823	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1201 Sunset Blvd	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 0ft		5984679.4382	2106925.6305	37.7643297966428	-122.496212291183	(37.7643297966428, -122.496212291183)
171399	171399	184735	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			99	Width 0ft		5984680.1977	2106291.6891	37.7625892162308	-122.496162889393	(37.7625892162308, -122.496162889393)
38529	38529	184787	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	48	Sidewalk: Property side : Yard 9	Tree 1	Private 1			43	Width 0ft		5984684.7543	2105859.3786	37.7614024796931	-122.49611523377199	(37.7614024796931, -122.496115233772)
186424	186424	184800	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	61	Sidewalk: Property side : Yard 9	Tree 1	Private 1			64	Width 0ft		5984686.2732	2105775.8403	37.76117319587821	-122.496103817218	(37.7611731958782, -122.496103817218)
152584	152584	184346	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1251 Sunset Blvd	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			99	Width 0ft		5984686.7384	2106407.7493	37.7629082680796	-122.49614883097901	(37.7629082680796, -122.496148830979)
164855	164855	184783	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	44	Sidewalk: Property side : Yard 9	Tree 1	Private 1			38	Width 0ft		5984690.4501	2105882.5415	37.761466412150995	-122.496097243606	(37.761466412151, -122.496097243606)
159421	159421	184771	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			46	Width 0ft		5984696.1459	2106000.2545	37.7617899526918	-122.496086229193	(37.7617899526918, -122.496086229193)
71097	71097	184768	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			78	Width 0ft		5984699.3735	2106071.8316	37.761986672397	-122.496080347248	(37.761986672397, -122.496080347248)
131941	131941	184792	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	53	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 0ft		5984699.5634	2105839.2535	37.76134808921321	-122.496062531256	(37.7613480892132, -122.496062531256)
51736	51736	184793	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	54	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24	Width 0ft		5984699.9431	2105830.5199	37.7613241314326	-122.49606057370801	(37.7613241314326, -122.496060573708)
174207	174207	184747	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			54	Width 0ft		5984699.9431	2106151.5726	37.7622056521899	-122.496084260471	(37.7622056521899, -122.496084260471)
176454	176454	184779	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	40	Sidewalk: Property side : Yard 9	Tree 1	Private 1			55	Width 0ft		5984701.0822	2105928.8672	37.7615942322964	-122.496063889935	(37.7615942322964, -122.496063889935)
47567	47567	186662	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1401 Sunset Blvd	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			57	Width 0ft		5984707.1311	2105554.3882	37.7605663720512	-122.496015341954	(37.7605663720512, -122.496015341954)
36127	36127	184802	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	63	Sidewalk: Property side : Yard 9	Tree 1	Private 1			31	Width 0ft		5984710.1955	2105740.9062	37.7610786777919	-122.496018504161	(37.7610786777919, -122.496018504161)
178161	178161	186708	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1401 Sunset Blvd	65	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984718.4366	2105053.49	37.7591917076208	-122.49593928954901	(37.7591917076208, -122.495939289549)
69733	69733	186694	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1401 Sunset Blvd	51	Sidewalk: Property side : Yard 9	Tree 1	Private 1			85	Width 0ft		5984719.2741	2105229.7727	37.75967577978221	-122.495949397724	(37.7596757797822, -122.495949397724)
166337	166337	186697	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1401 Sunset Blvd	54	Sidewalk: Property side : Yard 9	Tree 1	Private 1			61	Width 0ft		5984719.6928	2105196.6935	37.75958497805411	-122.495945509363	(37.7595849780541, -122.495945509363)
66207	66207	186686	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1401 Sunset Blvd	43	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 0ft		5984721.1583	2105332.5693	37.7599581409009	-122.49595046480499	(37.7599581409009, -122.495950464805)
23418	23418	186415	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984728.3813	2104210.7037	37.756878233428004	-122.49584272637699	(37.756878233428, -122.495842726377)
62460	62460	186665	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1401 Sunset Blvd	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984729.1141	2105540.7797	37.760530294446504	-122.495938309988	(37.7605302944465, -122.495938309988)
27914	27914	186438	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			38	Width 0ft		5984733.406	2103998.8295	37.756296779959996	-122.495809720693	(37.75629677996, -122.495809720693)
39604	39604	186420	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			49	Width 0ft		5984736.3371	2104166.319	37.7567568312994	-122.49581193867901	(37.7567568312994, -122.495811938679)
148491	148491	186615	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1501 Sunset Blvd	86	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5984738.326	2104396.7218	37.7573895698596	-122.495822055914	(37.7573895698596, -122.495822055914)
186276	186276	186413	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			64	Width 0ft		5984739.2681	2104238.7582	37.75695590087879	-122.495807145737	(37.7569559008788, -122.495807145737)
137587	137587	186429	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			52	Width 0ft		5984743.4554	2104053.6823	37.7564479790635	-122.49577901297701	(37.7564479790635, -122.495779012977)
153383	153383	186439	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			43	Width 0ft		5984744.2928	2103976.6372	37.7562364836353	-122.495770433997	(37.7562364836353, -122.495770433997)
26008	26008	186451	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	39	Sidewalk: Property side : Yard 9	Tree 1	Private 1			41	Width 0ft		5984745.9677	2103899.5919999997	37.7560250369708	-122.495758958747	(37.7560250369708, -122.495758958747)
40798	40798	186419	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			52	Width 0ft		5984745.9677	2104178.462	37.7567907366139	-122.495779528729	(37.7567907366139, -122.495779528729)
62075	62075	186467	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	55	Sidewalk: Property side : Yard 9	Tree 1	Private 1			57	Width 0ft		5984746.8052	2103766.8566	37.755660631401604	-122.495746271784	(37.7556606314016, -122.495746271784)
62084	62084	186445	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			42	Width 0ft		5984746.8052	2103919.272	37.756079121840294	-122.495757514055	(37.7560791218403, -122.495757514055)
60814	60814	186596	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1501 Sunset Blvd	67	Sidewalk: Property side : Yard 9	Tree 1	Private 1			67	Width 0ft		5984749.6315	2104462.0427	37.757569584992396	-122.495787775902	(37.7575695849924, -122.495787775902)
157507	157507	186199	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984749.9407	2103491.275	37.7549041442618	-122.49571510172899	(37.7549041442618, -122.495715101729)
66132	66132	186436	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	24	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 0ft		5984750.9924	2104017.2534	37.7563483968029	-122.495750260724	(37.7563483968029, -122.495750260724)
76140	76140	186587	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1501 Sunset Blvd	58	Sidewalk: Property side : Yard 9	Tree 1	Private 1			48	Width 0ft		5984753.4001	2104537.4129	37.75777675130679	-122.495780302321	(37.7577767513068, -122.495780302321)
68859	68859	186431	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			33	Width 0ft		5984754.7609	2104041.9581	37.7564164497485	-122.495739050371	(37.7564164497485, -122.495739050371)
165302	165302	186443	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	31	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984758.9481	2103937.6958	37.756130419604204	-122.495716879396	(37.7561304196042, -122.495716879396)
183983	183983	186607	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1501 Sunset Blvd	78	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984762.1933	2104423.9388	37.757465697935096	-122.495741522143	(37.7574656979351, -122.495741522143)
117667	117667	186416	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			57	Width 0ft		5984766.0664	2104199.8169	37.7568505482742	-122.495711596199	(37.7568505482742, -122.495711596199)
29197	29197	186442	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	30	Sidewalk: Property side : Yard 9	Tree 1	Private 1			40	Width 0ft		5984767.7413	2103942.7205	37.756144730979294	-122.49568684061	(37.7561447309793, -122.49568684061)
176055	176055	186244	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	55	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984769.2252	2103216.605	37.754151105704295	-122.495628153173	(37.7541511057043, -122.495628153173)
69295	69295	186458	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	46	Sidewalk: Property side : Yard 9	Tree 1	Private 1			22	Width 0ft		5984770.6724	2103862.3256	37.7559241605194	-122.495670774259	(37.7559241605194, -122.495670774259)
186173	186173	186341	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5984771.9036	2102828.9064	37.7530867492181	-122.49559029679199	(37.7530867492181, -122.495590296792)
186330	186330	186414	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5984773.6035	2104227.8714	37.7569280195247	-122.49568759978001	(37.7569280195247, -122.49568759978)
116439	116439	186460	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	48	Sidewalk: Property side : Yard 9	Tree 1	Private 1			51	Width 0ft		5984775.2784	2103839.2958	37.7558611968	-122.495653146825	(37.7558611968, -122.495653146825)
64917	64917	186418	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984777.7907	2104185.5803	37.7568121451107	-122.49566999975	(37.7568121451107, -122.49566999975)
184555	184555	186200	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			70	Width 0ft		5984778.3318	2103452.7061	37.754799907325605	-122.49561407416701	(37.7547999073256, -122.495614074167)
149159	149159	186430	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984784.4903	2104051.17	37.7564434840539	-122.49563691664801	(37.7564434840539, -122.495636916648)
69225	69225	186207	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			54	Width 0ft		5984784.7599	2103408.7803	37.754679675647395	-122.495588604669	(37.7546796756474, -122.495588604669)
29069	29069	186197	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			66	Width 0ft		5984786.367000001	2103519.1304	37.7549827606067	-122.49559118568399	(37.7549827606067, -122.495591185684)
66755	66755	186227	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	38	Sidewalk: Property side : Yard 9	Tree 1	Private 1			59	Width 0ft		5984787.1705	2103373.8271	37.754583844985	-122.49557769038	(37.754583844985, -122.49557769038)
152560	152560	186239	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	50	Sidewalk: Property side : Yard 9	Tree 1	Private 1			64	Width 0ft		5984787.4383	2103338.7401	37.754487521465	-122.49557417650298	(37.754487521465, -122.495574176503)
136524	136524	186344	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			56	Width 0ft		5984788.5097	2102786.0519999997	37.752970055260796	-122.495529709997	(37.7529700552608, -122.495529709997)
75719	75719	186255	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	66	Sidewalk: Property side : Yard 9	Tree 1	Private 1			56	Width 0ft		5984790.3846	2103043.3124	37.753676531136705	-122.495542199313	(37.7536765311367, -122.495542199313)
24028	24028	186361	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	28	Sidewalk: Property side : Yard 9	Tree 1	Private 1			99	Width 0ft		5984795.4735	2102590.7965	37.752434345234	-122.495491228463	(37.752434345234, -122.495491228463)
42313	42313	186066	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1901 Sunset Blvd	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984796.9498	2102110.7882	37.751116460938704	-122.495450724466	(37.7511164609387, -122.495450724466)
41093	41093	186399	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	66	Sidewalk: Property side : Yard 9	Tree 1	Private 1			50	Width 0ft		5984798.0272	2102361.2847	37.7518043185405	-122.495465471731	(37.7518043185405, -122.495465471731)
133818	133818	186243	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	54	Sidewalk: Property side : Yard 9	Tree 1	Private 1			73	Width 0ft		5984798.9554	2103218.7477	37.7541587299008	-122.495525498398	(37.7541587299008, -122.495525498398)
160994	160994	186062	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1901 Sunset Blvd	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984799.1046	2102135.8379	37.7511853667035	-122.495445120336	(37.7511853667035, -122.495445120336)
62963	62963	186357	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	24	Sidewalk: Property side : Yard 9	Tree 1	Private 1			63	Width 0ft		5984799.4911	2102657.2208	37.7526169633154	-122.49548223376001	(37.7526169633154, -122.49548223376)
158656	158656	186246	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	57	Sidewalk: Property side : Yard 9	Tree 1	Private 1			59	Width 0ft		5984800.2947	2103186.8747	37.7540712938714	-122.49551851619199	(37.7540712938714, -122.495518516192)
36102	36102	186350	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			32	Width 0ft		5984802.9731	2102707.5748	37.7527554254133	-122.49547390604499	(37.7527554254133, -122.495473906045)
60710	60710	186358	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			32	Width 0ft		5984804.0444	2102633.3831	37.7525517781755	-122.495464729934	(37.7525517781755, -122.495464729934)
162604	162604	186094	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1901 Sunset Blvd	40	Sidewalk: Property side : Yard 9	Tree 1	Private 1			79	Width 0ft		5984804.2595	2101775.159	37.7501953433109	-122.49540069682199	(37.7501953433109, -122.495400696822)
49280	49280	186252	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	63	Sidewalk: Property side : Yard 9	Tree 1	Private 1			52	Width 0ft		5984805.3836	2103092.3272	37.753811990528895	-122.49549394498501	(37.7538119905289, -122.495493944985)
33235	33235	186398	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	65	Sidewalk: Property side : Yard 9	Tree 1	Private 1			48	Width 0ft		5984807.1851	2102369.0959	37.751826302179104	-122.495434378973	(37.7518263021791, -122.495434378973)
71121	71121	186351	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			38	Width 0ft		5984807.7942	2102691.5044	37.752711582820204	-122.495456048919	(37.7527115828202, -122.495456048919)
38104	38104	186079	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1901 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 0ft		5984809.2191	2101997.6508	37.7508065351253	-122.495399953486	(37.7508065351253, -122.495399953486)
148289	148289	186198	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984809.4012	2103495.5605	37.754919392995205	-122.49550978975799	(37.7549193929952, -122.495509789758)
167665	167665	186108	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1901 Sunset Blvd	54	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5984809.6117	2101640.7232	37.749826532853206	-122.495372275422	(37.7498265328532, -122.495372275422)
29091	29091	186379	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	46	Sidewalk: Property side : Yard 9	Tree 1	Private 1			80	Width 0ft		5984812.5721	2102477.6444	37.7521246619181	-122.495423755128	(37.7521246619181, -122.495423755128)
155847	155847	186256	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	67	Sidewalk: Property side : Yard 9	Tree 1	Private 1			99	Width 0ft		5984812.6153	2103003.1364	37.7535675206606	-122.49546235883498	(37.7535675206606, -122.495462358835)
24469	24469	186067	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1901 Sunset Blvd	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			51	Width 0ft		5984814.1882	2102091.1256	37.751063482205	-122.495389663196	(37.751063482205, -122.495389663196)
58233	58233	186382	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	49	Sidewalk: Property side : Yard 9	Tree 1	Private 1			49	Width 0ft		5984814.4576	2102434.5482	37.75200644201529	-122.495414056772	(37.7520064420153, -122.495414056772)
26964	26964	186346	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			47	Width 0ft		5984814.4902	2102762.482	37.752906859827704	-122.49543812761401	(37.7529068598277, -122.495438127614)
183704	183704	186061	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1901 Sunset Blvd	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			29	Width 0ft		5984814.7269	2102156.8472	37.751243967202896	-122.495392646831	(37.7512439672029, -122.495392646831)
135224	135224	186241	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	52	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 0ft		5984814.757999999	2103244.996	37.7542317258103	-122.495472785714	(37.7542317258103, -122.495472785714)
183409	183409	186360	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984814.757999999	2102602.0458	37.7524663619043	-122.495425370042	(37.7524663619043, -122.495425370042)
162125	162125	186100	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1901 Sunset Blvd	46	Sidewalk: Property side : Yard 9	Tree 1	Private 1			49	Width 0ft		5984815.9085	2101712.5063	37.750023998252395	-122.495355794424	(37.7500239982524, -122.495355794424)
66834	66834	186353	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			38	Width 0ft		5984816.0972	2102671.9521	37.752658383763496	-122.49542589419501	(37.7526583837635, -122.495425894195)
75999	75999	186371	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	38	Sidewalk: Property side : Yard 9	Tree 1	Private 1			55	Width 0ft		5984816.6124	2102531.784	37.752273550929	-122.495413775866	(37.752273550929, -122.495413775866)

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