Street_Tree_List

Data source: data.sfgov.org

199 rows where DBH = 2 and qSpecies = 9

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

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
776	776	196857	Permitted Site 1	Pyrus calleryana :: Ornamental Pear 9	487 Tehama St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010733.79239	2111871.68352	37.7794022433647	-122.406445673949	(37.7794022433647, -122.406445673949)
1359	1359	196907	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	351 Clementina St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6011780.0	2112595.0	37.7814467742932	-122.40287726647301	(37.7814467742932, -122.402877266473)
1427	1427	196746	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	1201x 08th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6012720.73761	2107120.44123	37.7664673626982	-122.399238333493	(37.7664673626982, -122.399238333493)
15862	15862	114993	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	96X Tehama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6013204.76311	2114263.56563	37.78610772254971	-122.398065333368	(37.7861077225497, -122.398065333368)
16373	16373	114992	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	96X Tehama St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6013259.23301	2114318.42588	37.786261389694296	-122.397880730433	(37.7862613896943, -122.397880730433)
18764	18764	16103	DPW Maintained 3	Pyrus calleryana :: Ornamental Pear 9	300X Monterey Blvd	1	Median : Cutout 11	Tree 1	DPW 2		02/18/2012 12:00:00 AM	2	5		6000043.907980001	2094672.48858	37.7315736376005	-122.44219140500799	(37.7315736376005, -122.442191405008)
23095	23095	16341	DPW Maintained 3	Pyrus calleryana :: Ornamental Pear 9	890X Monterey Blvd	3	Median : Cutout 11	Tree 1	DPW 2		04/22/2008 12:00:00 AM	2	5		5996216.96756	2094693.6651599999	37.7314129368354	-122.45542333713999	(37.7314129368354, -122.45542333714)
23159	23159	16339	DPW Maintained 3	Pyrus calleryana :: Ornamental Pear 9	890X Monterey Blvd	1	Median : Cutout 11	Tree 1	DPW 2		04/22/2008 12:00:00 AM	2	5		5996276.20802	2094704.1816900002	37.7314452117282	-122.45521929265	(37.7314452117282, -122.45521929265)
23183	23183	5156	DPW Maintained 3	Pyrus calleryana :: Ornamental Pear 9	270 Divisadero St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/22/1990 12:00:00 AM	2			6001844.2525	2109252.3731	37.7717089596497	-122.43701070699899	(37.7717089596497, -122.437010706999)
23271	23271	5162	DPW Maintained 3	Pyrus calleryana :: Ornamental Pear 9	286 Divisadero St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	3x3		6001830.0062	2109354.1323	37.7719875553506	-122.43706727247	(37.7719875553506, -122.43706727247)
24820	24820	244313	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	355 Octavia St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6005485.8375	2110599.8191	37.77561503254971	-122.424510084491	(37.7756150325497, -122.424510084491)
24924	24924	196625	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	147 Minna St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6012482.23546	2114419.12647	37.7864945874895	-122.400576033651	(37.7864945874895, -122.400576033651)
24996	24996	196826	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	100 Merrimac St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014562.70735	2108760.4377599997	37.7710729141165	-122.392981999126	(37.7710729141165, -122.392981999126)
27372	27372	196638	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	11 Shaw Aly	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6013210.02974	2115178.55923	37.7886203752705	-122.398111327376	(37.7886203752705, -122.398111327376)
27776	27776	196809	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	33 El Dorado St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014501.65713	2109262.9440200003	37.7724492932359	-122.393228344136	(37.7724492932359, -122.393228344136)
28158	28158	196663	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	37 Tehama St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6013898.18924	2114895.8387	37.787882395204896	-122.395710563802	(37.7878823952049, -122.395710563802)
28479	28479	213820	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	938 Garfield St	1	: 4	Tree 1	Private 1			2	Width 3ft		5991536.52061	2090526.4339400001	37.7197010793166	-122.471300855268	(37.7197010793166, -122.471300855268)
29627	29627	196956	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	1563 Jerrold Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6015435.30899	2096897.77593	37.738548992547	-122.38913518415899	(37.738548992547, -122.389135184159)
29949	29949	136124	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	151 Alice B Toklas Pl	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6006586.92678	2114080.92935	37.7852354350031	-122.420948352578	(37.7852354350031, -122.420948352578)
30030	30030	136118	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	101 Alice B Toklas Pl	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6006893.798359999	2114122.82203	37.785367754970004	-122.419889642794	(37.78536775497, -122.419889642794)
30561	30561	182746	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	1779 30th Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5986859.1028	2103189.8409	37.754199778911	-122.488398972402	(37.754199778911, -122.488398972402)
30685	30685	141588	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	773 DIVISADERO ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6001535.0961	2110983.5445	37.7764447457756	-122.438204133681	(37.7764447457756, -122.438204133681)
30965	30965	196830	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	55 Merrimac St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014615.60719	2108793.6180000002	37.7711669580112	-122.392801337013	(37.7711669580112, -122.392801337013)
31388	31388	141035	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	169 COMMONWEALTH AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5996530.5151	2113217.856	37.782293673428	-122.45567783611601	(37.782293673428, -122.455677836116)
31467	31467	93680	Permitted Site 1	Pyrus calleryana :: Ornamental Pear 9	2550 25th Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/27/2009 12:00:00 AM	2	3x3	Permit Number 52753	5988650.712	2097745.6849	37.739355938531105	-122.481804466798	(37.7393559385311, -122.481804466798)
32091	32091	239824	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	331 Ellsworth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008095.789340001	2097107.1101099998	37.7387141800261	-122.414526606835	(37.7387141800261, -122.414526606835)
33073	33073	196833	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	55 Merrimac St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014609.63604	2108886.05645	37.7714204418376	-122.39282845968799	(37.7714204418376, -122.392828459688)
33277	33277	141327	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	625 DIVISADERO ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6001594.2196	2110564.4792	37.7752974601448	-122.437969585077	(37.7752974601448, -122.437969585077)
34134	34134	196799	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	211 Channel	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014780.254869999	2109725.1043599998	37.7737337562402	-122.392296969335	(37.7737337562402, -122.392296969335)
34268	34268	137999	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	46 WILMOT ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6003219.7744	2115020.9911	37.7876262319501	-122.43266483101101	(37.7876262319501, -122.432664831011)
34936	34936	238909	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	874 South Van Ness Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007522.03402	2104598.15696	37.7592506549067	-122.41704102042802	(37.7592506549067, -122.417041020428)
35247	35247	244413	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	261 Octavia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6005541.7456	2110237.7642	37.774624074709294	-122.424290928299	(37.7746240747093, -122.424290928299)
35697	35697	179258	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	0 Juan Bautista Cir	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			5989486.24295	2090206.2141599997	37.7187030225094	-122.478364452564	(37.7187030225094, -122.478364452564)
35909	35909	196842	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	385 Channel	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014094.5167	2109056.2947299997	37.771859253444795	-122.394622219555	(37.7718592534448, -122.394622219555)
37223	37223	182750	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	1795 30th Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5986862.6162	2103105.8758	37.7539694385611	-122.488380652039	(37.7539694385611, -122.488380652039)
37264	37264	196902	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	583 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009767.99378	2111564.3432299998	37.7785042828733	-122.40976509229401	(37.7785042828733, -122.409765092294)
37816	37816	196835	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	55 Merrimac St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014606.40021	2108954.09695	37.77160708622179	-122.39284441363998	(37.7716070862218, -122.39284441364)
37922	37922	196851	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	385 Channel	15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014284.65568	2109239.1617	37.7723719344444	-122.3939773139	(37.7723719344444, -122.3939773139)
38199	38199	196641	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	11 Shaw Aly	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6013156.89718	2115236.73251	37.7887771459954	-122.398299242536	(37.7887771459954, -122.398299242536)
39746	39746	196895	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	550 Minna St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009763.28494	2111857.29368	37.7793083918936	-122.40980206610901	(37.7793083918936, -122.409802066109)
40872	40872	196929	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	667 Natoma St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009257.6342400005	2111076.4541	37.7771360408398	-122.411496147852	(37.7771360408398, -122.411496147852)
41428	41428	88164	Permitted Site 1	Pyrus calleryana :: Ornamental Pear 9	365 Clementina St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/08/2008 12:00:00 AM	2	3x3	Permit Number 51185	6011679.3215	2112506.85635	37.7811991301856	-122.403219365087	(37.7811991301856, -122.403219365087)
42110	42110	142087	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	650 DIVISADERO ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6001637.91	2110714.8673	37.7757128725989	-122.437829223883	(37.7757128725989, -122.437829223883)
43869	43869	179217	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	2055 Sunnydale Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6005575.94717	2088046.16302	37.7136929155569	-122.42259534402001	(37.7136929155569, -122.42259534402)
45363	45363	137593	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	930 PIERCE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6002466.0869	2111750.739	37.778604175366	-122.435038459648	(37.778604175366, -122.435038459648)
45460	45460	196899	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	504 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010271.672730001	2112074.19086	37.779932417994	-122.40805863320699	(37.779932417994, -122.408058633207)
45835	45835	196813	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	33 El Dorado St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014445.95089	2109318.64473	37.772599140074895	-122.393424937713	(37.7725991400749, -122.393424937713)
46168	46168	182759	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	1760 31st Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5986602.0349	2103247.8223	37.754343977501996	-122.489292227735	(37.754343977502, -122.489292227735)
46632	46632	196628	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	147 Natoma St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6012615.71361	2114306.3585900003	37.78619239642	-122.40010630696301	(37.78619239642, -122.400106306963)
46692	46692	245907	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	205 Divisadero St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6001841.0498	2108801.5549	37.770470942747295	-122.436989504702	(37.7704709427473, -122.436989504702)
46866	46866	196841	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	385 Channel	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014074.004	2109042.91847	37.7718213847826	-122.39469223806002	(37.7718213847826, -122.39469223806)
47524	47524	196849	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	385 Channel	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014250.97804	2109206.9561799997	37.772281633521	-122.394091553888	(37.772281633521, -122.394091553888)
48135	48135	107707	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	1798X 31st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		5986607.5742	2103075.1785	37.75387026798779	-122.48926037902599	(37.7538702679878, -122.489260379026)
48706	48706	196922	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	89 Harriet St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010766.241	2111460.94746	37.7782762732654	-122.406304472273	(37.7782762732654, -122.406304472273)
49124	49124	142091	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	608 DIVISADERO ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6001658.9192	2110552.3556	37.775267850864104	-122.437744906224	(37.7752678508641, -122.437744906224)
49298	49298	239059	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	20 12th St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		6006817.9593	2109962.30931	37.7739397216626	-122.419856692526	(37.7739397216626, -122.419856692526)
49746	49746	196624	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	147 Minna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6012470.67995	2114408.88774	37.7864658298723	-122.400615293576	(37.7864658298723, -122.400615293576)
50133	50133	239977	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	4203 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6001765.33029	2102321.9131400003	37.752675121470006	-122.436787502941	(37.75267512147, -122.436787502941)
50413	50413	239041	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	370 14th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006277.54022	2107898.2644700003	37.7682418878849	-122.421579471632	(37.7682418878849, -122.421579471632)
50535	50535	42232	Permitted Site 1	Pyrus calleryana :: Ornamental Pear 9	514 Minna St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/23/2000 12:00:00 AM	2		Permit Number 42486	6010147.47945	2112226.4024900002	37.7803434009533	-122.408499015011	(37.7803434009533, -122.408499015011)
50788	50788	196804	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	211 Channel	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014868.70221	2109810.10844	37.7739720693771	-122.391996959086	(37.7739720693771, -122.391996959086)
50879	50879	83158	Permitted Site 1	Pyrus calleryana :: Ornamental Pear 9	501-503 Connecticut St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/02/2009 12:00:00 AM	2	3x3	Permit Number 52377	6013281.550319999	2104694.87415	37.7598385291488	-122.397128474512	(37.7598385291488, -122.397128474512)
50965	50965	196904	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	515 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6010247.778969999	2112023.6553700003	37.7797923215855	-122.40813772768298	(37.7797923215855, -122.408137727683)
51049	51049	239072	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	1721 Alabama St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009354.36849	2099386.87657	37.7450445474789	-122.41033594146002	(37.7450445474789, -122.41033594146)
52018	52018	196807	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	33 El Dorado St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014539.12289	2109222.91592	37.7723414663089	-122.39309594412701	(37.7723414663089, -122.393095944127)
52940	52940	196816	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	30 El Dorado St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014355.46436	2109208.21492	37.772290896541705	-122.393730211682	(37.7722908965417, -122.393730211682)
53617	53617	196834	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	55 Merrimac St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014607.32823	2108931.5726799998	37.7715452911214	-122.392839627459	(37.7715452911214, -122.392839627459)
53878	53878	196800	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	211 Channel	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014798.00795	2109743.12989	37.773784236097995	-122.392236819075	(37.773784236098, -122.392236819075)
53911	53911	196793	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	211 Channel	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014671.628219999	2109618.91734	37.773436157993004	-122.39266529927	(37.773436157993, -122.39266529927)
54733	54733	239060	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	20 12th St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		6006825.82928	2109953.07556	37.773914811354	-122.41982881355699	(37.773914811354, -122.419828813557)
55742	55742	196934	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	179 08th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6009134.08347	2110880.82057	37.776591946501206	-122.411909722665	(37.7765919465012, -122.411909722665)
55986	55986	238925	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	1376 South Van Ness Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007684.706040001	2101658.69477	37.751188712092706	-122.41627022770001	(37.7511887120927, -122.4162702277)
56021	56021	196820	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	30 El Dorado St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014434.7702	2109131.61209	37.772084968887	-122.393450521637	(37.772084968887, -122.393450521637)
56617	56617	196664	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	37 Tehama St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6013910.09834	2114905.11906	37.7879085393886	-122.39567001068899	(37.7879085393886, -122.395670010689)
58081	58081	141036	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	169 COMMONWEALTH AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5996530.5151	2113204.996	37.7822583632772	-122.455676906267	(37.7822583632772, -122.455676906267)
58570	58570	245042	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	327 Divisadero St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6001729.2773	2109584.2003	37.772613538730205	-122.437432178467	(37.7726135387302, -122.437432178467)
58914	58914	141027	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	170 COMMONWEALTH AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5996585.001	2113219.2097	37.7823005169542	-122.455489438079	(37.7823005169542, -122.455489438079)
58975	58975	239816	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	75 Van Buren St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6002009.83493	2096278.4527900002	37.736095091607	-122.435509666138	(37.736095091607, -122.435509666138)
59001	59001	139486	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	821 DIVISADERO ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6001498.3355	2111261.3411	37.7772054144764	-122.438351205496	(37.7772054144764, -122.438351205496)
59947	59947	196819	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	30 El Dorado St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014421.27301	2109141.30069	37.7721108216959	-122.393497888041	(37.7721108216959, -122.393497888041)
60608	60608	213847	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	862 Monterey Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5996471.12136	2094711.1297	37.7314754703089	-122.45454594593201	(37.7314754703089, -122.454545945932)
62033	62033	141379	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	1188 Fell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6001766.8891	2110148.7149	37.7741656931654	-122.437342505191	(37.7741656931654, -122.437342505191)
62776	62776	196846	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	385 Channel	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014189.07548	2109148.79942	37.7721185072929	-122.394301609455	(37.7721185072929, -122.394301609455)
62831	62831	196906	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	351 Clementina St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6011821.30195	2112642.26955	37.7815788715983	-122.40273770618299	(37.7815788715983, -122.402737706183)
63483	63483	196827	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	100 Merrimac St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014561.24201	2108734.73312	37.77100225348	-122.39298526908001	(37.77100225348, -122.39298526908)
63515	63515	196838	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	385 Channel	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014014.12331	2108979.4165	37.7716436931411	-122.39489492276002	(37.7716436931411, -122.39489492276)
63563	63563	196831	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	55 Merrimac St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014614.72558	2108818.43764	37.7712350582719	-122.392806123212	(37.7712350582719, -122.392806123212)
64164	64164	239798	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	580 Chenery St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6003046.45031	2095736.30593	37.7346653008605	-122.43188696941799	(37.7346653008605, -122.431886969418)
64783	64783	248566	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	181 Belvedere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5998279.3705	2107711.3091	37.7672743204829	-122.44923075860399	(37.7672743204829, -122.449230758604)
65916	65916	196661	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	37 Tehama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6013826.93389	2114819.57092	37.78766901755	-122.39595174940001	(37.78766901755, -122.3959517494)
66511	66511	196892	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	522 Minna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010060.555819999	2112138.1308	37.78009615935729	-122.40879349622101	(37.7800961593573, -122.408793496221)
66684	66684	213816	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	385 Bright St	2	: 4	Tree 1	Private 1			2	Width 3ft		5993751.51219	2089781.4395	37.7177833829643	-122.463590439447	(37.7177833829643, -122.463590439447)
66809	66809	137998	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	16 WILMOT ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6003237.1803	2115022.4416	37.7876312017567	-122.43260471370199	(37.7876312017567, -122.432604713702)
66979	66979	196863	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	434 Clementina St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6011345.37302	2112224.5151400003	37.780405231161396	-122.40435478884599	(37.7804052311614, -122.404354788846)
67658	67658	196911	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	184 06th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6010426.99479	2112057.1957400003	37.7798944486064	-122.407520103867	(37.7798944486064, -122.407520103867)
67716	67716	92641	Permitted Site 1	Pyrus calleryana :: Ornamental Pear 9	7 Vandewater St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/02/2009 12:00:00 AM	2	3x3	Permit Number 52933	6009274.4711	2121331.1603	37.8052939168226	-122.412162829753	(37.8052939168226, -122.412162829753)
68597	68597	239999	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	317 Elizabeth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004307.52807	2102165.20998	37.7523890039541	-122.42798496573201	(37.7523890039541, -122.427984965732)
68752	68752	141328	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	601 DIVISADERO ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6001600.0801	2110529.3158	37.7752012435384	-122.43794679307501	(37.7752012435384, -122.437946793075)
70115	70115	196850	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	385 Channel	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6014268.35997	2109223.57854	37.7723282408876	-122.394032591628	(37.7723282408876, -122.394032591628)
70670	70670	93700	Permitted Site 1	Pyrus calleryana :: Ornamental Pear 9	2550 25th Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/27/2009 12:00:00 AM	2	3x3	Permit Number 52753	5988645.7821	2097896.1772	37.739768864422494	-122.481832532572	(37.7397688644225, -122.481832532572)

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