trees

Custom SQL query returning 101 rows (hide)

select rowid, TreeID, qLegalStatus_id, qSpecies_id, qAddress, SiteOrder, qSiteInfo, PlantType, qCaretaker_id, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location, [Fire Prevention Districts], [Police Districts], [Supervisor Districts], [Zip Codes], [Neighborhoods (old)] from trees where "Supervisor Districts" = :p0 and "qLegalStatus_id" = :p1 and ([Neighborhoods (old)] > :p3 or ([Neighborhoods (old)] = :p3 and ((rowid > :p2)))) order by [Neighborhoods (old)], rowid limit 101

Query parameters

This data as json, CSV

rowid	TreeID	qLegalStatus_id	qSpecies_id	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker_id	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location	Fire Prevention Districts	Police Districts	Supervisor Districts	Zip Codes	Neighborhoods (old)
135281	253476	2	140	1222 Harrison St	2	Sidewalk: Curb side : Cutout	Tree	2		09/12/2017 12:00:00 AM	3	3x6	Permit Number 772214	6009984	2109753	37.7735428603255	-122.408890010762	(37.7735428603255, -122.408890010762)	8	2	9	28853	34
137539	113649	2	162	98X 10TH ST	1	Sidewalk: Curb side : Cutout	Tree	2				4x6	Permit Number 773574	6007947	2110424	37.7752709556829	-122.415983842901	(37.7752709556829, -122.415983842901)	8	2	9	28853	34
139476	113655	2	1	901X JESSIE ST	1	Sidewalk: Curb side : Cutout	Tree	2		02/09/2016 12:00:00 AM	3	3x6	Permit Number 773574	6007947	2110424	37.7752709556829	-122.415983842901	(37.7752709556829, -122.415983842901)	8	2	9	28853	34
152719	113648	2	11	1400 MISSION ST	6	Sidewalk: Curb side : Cutout	Tree	2		02/09/2016 12:00:00 AM	3	4x6	Permit Number 773574	6007947	2110424	37.7752709556829	-122.415983842901	(37.7752709556829, -122.415983842901)	8	2	9	28853	34
154892	113645	2	11	1400 MISSION ST	2	Sidewalk: Curb side : Cutout	Tree	2		02/09/2016 12:00:00 AM	3	4x6	Permit Number 773574	6007947	2110424	37.7752709556829	-122.415983842901	(37.7752709556829, -122.415983842901)	8	2	9	28853	34
158086	15247	2	11	1401X Mission St	2	Sidewalk: Curb side : Cutout	Tree	2		12/29/2016 12:00:00 AM	3	3X3	Permit Number 770901	6007902.55668	2110326.57547	37.7750009522643	-122.416130681693	(37.7750009522643, -122.416130681693)	8	2	9	28853	34
158927	251290	2	11	33 08th St	4	Sidewalk: Curb side : Cutout	Tree	2		04/05/2017 12:00:00 AM	3	Width 3ft	Permit Number 771124	6008734.11613	2111298.92197	37.7777175065003	-122.413322904728	(37.7777175065003, -122.413322904728)	8	2	9	28853	34
159122	253486	2	116	1x Gordon St	4	Sidewalk: Curb side : Cutout	Tree	2		09/12/2017 12:00:00 AM	3	3x3	Permit Number 772214	6009763	2109812	37.7736924789578	-122.409658650953	(37.7736924789578, -122.409658650953)	8	2	9	28853	34
159283	192594	2	11	1321 Mission St	1	Sidewalk: Curb side : Cutout	Tree	2		11/09/1995 12:00:00 AM	2	Width 4ft	Permit Number 770747	6008274.3646	2110675.08431	37.7759787734355	-122.414869184668	(37.7759787734355, -122.414869184668)	8	2	9	28853	34
160441	117453	2	1	236 Shipley St	1	Sidewalk: Curb side : Cutout	Tree	2			3	3x3	Permit Number 776408	6011539.59396	2111788.0027	37.779217520823	-122.403652162024	(37.779217520823, -122.403652162024)	14	2	9	28856	34
160922	121508	2	19	300 Folsom St	3	Sidewalk: Property side : Cutout	Tree	2			6	3x3		6012258.9126	2112729.3972	37.7818425275943	-122.401229897449	(37.7818425275943, -122.401229897449)	6	2	9	28856	34
161626	255692	2	11	510 Townsend St	2	Sidewalk: Curb side : Cutout	Tree	2		06/27/2018 12:00:00 AM	3	3x3		6012573	2109637	37.773369031352	-122.399926071367	(37.773369031352, -122.399926071367)	14	2	9	28853	34
162521	192596	2	11	1335 Mission St	3	Sidewalk: Curb side : Cutout	Tree	2		03/07/1995 12:00:00 AM	3	Width 4ft	Permit Number 770747	6008295.90964	2110693.56586	37.7760307299718	-122.414795962779	(37.7760307299718, -122.414795962779)	8	2	9	28853	34
164004	201690	2	11	324 08th St	3	Sidewalk: Curb side : Cutout	Tree	2		09/12/2017 12:00:00 AM	3	3x6	Permit Number 772214	6009863.47645	2110020.43216	37.7742704149776	-122.409325797764	(37.7742704149776, -122.409325797764)	8	2	9	28853	34
168133	121551	2	11	1125 Mission St	2	Sidewalk: Curb side : Cutout	Tree	2		01/23/2017 12:00:00 AM	3	3x3	Permit Number 778243	6009293.51408	2111653.12836	37.7787214646499	-122.411412777974	(37.7787214646499, -122.411412777974)	8	2	9	28853	34
169960	192564	2	11	33 08th St	2	Sidewalk: Curb side : Cutout	Tree	2		04/05/2017 12:00:00 AM	3	Width 3ft	Permit Number 771124	6008734.11613	2111298.92197	37.7777175065003	-122.413322904728	(37.7777175065003, -122.413322904728)	8	2	9	28853	34
169973	253496	2	116	1x Gordon St	14	Sidewalk: Curb side : Cutout	Tree	2		09/12/2017 12:00:00 AM	3	3x3	Permit Number 772214	6009763	2109812	37.7736924789578	-122.409658650953	(37.7736924789578, -122.409658650953)	8	2	9	28853	34
171171	253477	2	140	1222 Harrison St	3	Sidewalk: Curb side : Cutout	Tree	2		09/12/2017 12:00:00 AM	3	3x6	Permit Number 772214	6009984	2109753	37.7735428603255	-122.408890010762	(37.7735428603255, -122.408890010762)	8	2	9	28853	34
175654	201688	2	11	324 08th St	1	Sidewalk: Curb side : Cutout	Tree	2		09/12/2017 12:00:00 AM	3	3x6	Permit Number 772214	6009806.99553	2110077.79875	37.7744247656342	-122.409525226004	(37.7744247656342, -122.409525226004)	8	2	9	28853	34
176162	121550	2	11	1125 Mission St	1	Sidewalk: Curb side : Cutout	Tree	2		01/23/2017 12:00:00 AM	3	3x3	Permit Number 778243	6009252.51421	2111618.01515	37.7786227523886	-122.411552131552	(37.7786227523886, -122.411552131552)	8	2	9	28853	34
176904	190611	2	22	9 Washburn St	1	Sidewalk: Curb side : Cutout	Tree	2		02/07/2018 12:00:00 AM	3	Width 3ft	Permit Number 775218	6008250.0486	2110605.54207	37.7757864606069	-122.41494837717	(37.7757864606069, -122.41494837717)	8	2	9	28853	34
177182	15246	2	11	1401X Mission St	1	Sidewalk: Curb side : Cutout	Tree	2		12/29/2016 12:00:00 AM	3	3x3	Permit Number 770901	6007883.54199	2110310.54573	37.7749558692557	-122.416195322271	(37.7749558692557, -122.416195322271)	8	2	9	28853	34
178528	121507	2	19	300 Folsom St	2	Sidewalk: Curb side : Cutout	Tree	2			8	3x3		6012241.512	2112714.7441	37.7818013227969	-122.401289065763	(37.7818013227969, -122.401289065763)	6	2	9	28856	34
180989	255698	2	11	510 Townsend St	8	Sidewalk: Curb side : Cutout	Tree	2		06/27/2018 12:00:00 AM	3	3x3		6012573	2109637	37.773369031352	-122.399926071367	(37.773369031352, -122.399926071367)	14	2	9	28853	34
181014	253484	2	116	1x Gordon St	2	Sidewalk: Curb side : Cutout	Tree	2		09/12/2017 12:00:00 AM	3	3x3	Permit Number 772214	6009763	2109812	37.7736924789578	-122.409658650953	(37.7736924789578, -122.409658650953)	8	2	9	28853	34
182348	173697	2	11	1401X Mission St	4	Sidewalk: Curb side : Cutout	Tree	2		12/29/2016 12:00:00 AM	3	3X3	Permit Number 770901	6007975.5805432	2110395.7628537	37.775195030009	-122.415882976003	(37.775195030009, -122.415882976003)	8	2	9	28853	34
183224	115097	2	14	537 Natoma St	3	Sidewalk: Curb side : Cutout	Tree	2		01/12/2016 12:00:00 AM	2	2x4	Permit Number 769476	6010133.89472	2111910.59383	37.779475503918	-122.408523727481	(37.779475503918, -122.408523727481)	14	2	9	28853	34
187618	253249	2	72	570 Jessie St	3	Sidewalk: Curb side : Cutout	Tree	2		08/09/2017 12:00:00 AM	3	3x3	Permit Number 775513	6009730.1467	2112442.13768	37.7809123781536	-122.409958002933	(37.7809123781536, -122.409958002933)	14	2	9	28853	34
190069	15235	2	11	1321 Mission St	1	Sidewalk: Curb side : Cutout	Tree	2		01/27/2015 12:00:00 AM	3	3X3	Permit Number 770747	6008256.52807	2110680.03106	37.7759913537931	-122.414931236282	(37.7759913537931, -122.414931236282)	8	2	9	28853	34
190324	253494	2	116	1x Gordon St	12	Sidewalk: Curb side : Cutout	Tree	2		09/12/2017 12:00:00 AM	3	3x3	Permit Number 772214	6009763	2109812	37.7736924789578	-122.409658650953	(37.7736924789578, -122.409658650953)	8	2	9	28853	34
194194	255691	2	11	510 Townsend St	1	Sidewalk: Curb side : Cutout	Tree	2		06/27/2018 12:00:00 AM	3	3x3		6012573	2109637	37.773369031352	-122.399926071367	(37.773369031352, -122.399926071367)	14	2	9	28853	34
1080	169338	2	1	1029 Geary St	1	Sidewalk: Curb side : Cutout	Tree	2		08/15/2019 12:00:00 AM	3	Width 4ft		6006781.41851	2114264.09095	37.7857493130165	-122.420288474132	(37.7857493130165, -122.420288474132)	13	9	9	28858	36
3797	260871	2	11	198x Eddy St	4	Sidewalk: Curb side : Cutout	Tree	2		10/16/2019 12:00:00 AM	3	3x3		6009475	2113668	37.7842640010762	-122.410927291409	(37.7842640010762, -122.410927291409)	14	10	9	28852	36
5118	169123	2	11	210 Taylor St	2	Sidewalk: Curb side : Cutout	Tree	2		07/18/2019 12:00:00 AM	3	Width 4ft		6009469.52117	2113800.26568	37.7846268637924	-122.410955591431	(37.7846268637924, -122.410955591431)	14	10	9	28852	36
9750	169122	2	11	210 Taylor St	1	Sidewalk: Curb side : Cutout	Tree	2		07/18/2019 12:00:00 AM	3	Width 4ft		6009478.56357	2113738.5186	37.7844578281201	-122.410919945006	(37.7844578281201, -122.410919945006)	14	10	9	28852	36
11471	260869	2	11	198x Eddy St	2	Sidewalk: Curb side : Cutout	Tree	2		10/16/2019 12:00:00 AM	3	3x3		6009475	2113668	37.7842640010762	-122.410927291409	(37.7842640010762, -122.410927291409)	14	10	9	28852	36
12720	115537	2	133	99X Lech Walesa St	2	Sidewalk: Curb side : Cutout	Tree	2		02/08/2016 12:00:00 AM	3	3x10	Permit Number 770842	6007116.50228	2111387.72892	37.7778703965252	-122.418925098047	(37.7778703965252, -122.418925098047)	7	9	9	28852	36
13730	260870	2	11	198x Eddy St	3	Sidewalk: Curb side : Cutout	Tree	2		10/16/2019 12:00:00 AM	3	3x3		6009475	2113668	37.7842640010762	-122.410927291409	(37.7842640010762, -122.410927291409)	14	10	9	28852	36
14869	117019	2	16	168 Hyde St	3	Sidewalk: Curb side : Cutout	Tree	2		05/17/2016 12:00:00 AM	3	3x3	Permit Number 777550	6008121.68381	2113004.40875	37.782365960952	-122.415562303882	(37.782365960952, -122.415562303882)	7	10	9	28852	36
16066	260290	2	1	1029 Geary St	2	Sidewalk: Curb side : Cutout	Tree	2		08/15/2019 12:00:00 AM	3	Width 4ft		6006781.41851	2114264.09095	37.7857493130165	-122.420288474132	(37.7857493130165, -122.420288474132)	13	9	9	28858	36
18437	260868	2	11	198x Eddy St	1	Sidewalk: Curb side : Cutout	Tree	2		10/16/2019 12:00:00 AM	3	3x3		6009475	2113668	37.7842640010762	-122.410927291409	(37.7842640010762, -122.410927291409)	14	10	9	28852	36
34272	115532	2	171	100X Hayes St	2	Sidewalk: Curb side : Pot	Tree	2		02/08/2016 12:00:00 AM	3		Permit Number 770842	6007293.46404	2111265.83422	37.7775456658356	-122.418304279225	(37.7775456658356, -122.418304279225)	7	9	9	28852	36
40425	115540	2	133	99X Lech Walesa St	5	Sidewalk: Curb side : Cutout	Tree	2		02/08/2016 12:00:00 AM	3	3x5	Permit Number 770842	6007116.50228	2111387.72892	37.7778703965252	-122.418925098047	(37.7778703965252, -122.418925098047)	7	9	9	28852	36
61797	117020	2	16	168 Hyde St	4	Sidewalk: Curb side : Cutout	Tree	2		05/17/2016 12:00:00 AM	3	3x3	Permit Number 777550	6008118.25915	2113018.66588	37.7824049150971	-122.415575161466	(37.7824049150971, -122.415575161466)	7	10	9	28852	36
64870	255402	2	75	150 Van Ness Ave	1	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
68035	117021	2	16	168 Hyde St	5	Sidewalk: Curb side : Cutout	Tree	2		05/17/2016 12:00:00 AM	3	3x3	Permit Number 777550	6008114.19003	2113031.70239	37.7824404814865	-122.415590162171	(37.7824404814865, -122.415590162171)	7	10	9	28852	36
72419	255414	2	75	199x Hayes St	10	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
75364	115539	2	133	99X Lech Walesa St	4	Sidewalk: Curb side : Cutout	Tree	2		02/08/2016 12:00:00 AM	3	3x10	Permit Number 770842	6007116.50228	2111387.72892	37.7778703965252	-122.418925098047	(37.7778703965252, -122.418925098047)	7	9	9	28852	36
77658	94315	2	16	399X Turk St	1	Sidewalk: Curb side : Cutout	Tree	2		05/17/2016 12:00:00 AM	3	3x3	Permit Number 777550	6008122	2112982	37.7823044496932	-122.415559622955	(37.7823044496932, -122.415559622955)	7	10	9	28852	36
78499	255416	2	75	99x Polk St	1	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6007395	2111066	37.7770026839515	-122.417938862064	(37.7770026839515, -122.417938862064)	7	9	9	28852	36
81347	117017	2	16	168 Hyde St	1	Sidewalk: Curb side : Cutout	Tree	2		05/17/2016 12:00:00 AM	3	3x3	Permit Number 777550	6008130.7573	2112963.51283	37.7822541806174	-122.415528017206	(37.7822541806174, -122.415528017206)	7	10	9	28852	36
87472	255403	2	75	150 Van Ness Ave	2	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
93518	115534	2	171	100X Hayes St	4	Sidewalk: Curb side : Pot	Tree	2		02/08/2016 12:00:00 AM	3		Permit Number 770842	6007259.83389	2111260.26588	37.7775284833993	-122.418420222514	(37.7775284833993, -122.418420222514)	7	9	9	28852	36
97662	117018	2	16	168 Hyde St	2	Sidewalk: Curb side : Cutout	Tree	2		05/17/2016 12:00:00 AM	3	3x3	Permit Number 777550	6008125.66458	2112987.05621	37.7823185388132	-122.415547303188	(37.7823185388132, -122.415547303188)	7	10	9	28852	36
108535	255409	2	75	199x Hayes St	5	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
109022	255406	2	75	199x Hayes St	2	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
115681	115533	2	171	100X Hayes St	3	Sidewalk: Curb side : Pot	Tree	2		02/08/2016 12:00:00 AM	3		Permit Number 770842	6007275.38703	2111262.82601	37.7775363884346	-122.418366600452	(37.7775363884346, -122.418366600452)	7	9	9	28852	36
124352	255410	2	75	199x Hayes St	6	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
126056	255417	2	75	99x Polk St	2	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6007395	2111066	37.7770026839515	-122.417938862064	(37.7770026839515, -122.417938862064)	7	9	9	28852	36
130074	255415	2	75	199x Hayes St	11	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
135842	115529	2	27	101 Polk St	2	Sidewalk: Curb side : Cutout	Tree	2		02/08/2016 12:00:00 AM	3	4x4	Permit Number 770842	6007327.31765	2111347.52577	37.777771876795	-122.418192961161	(37.777771876795, -122.418192961161)	7	9	9	28852	36
136714	65940	2	37	620 Eddy St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	06/04/1990 12:00:00 AM	8		Permit Number 28961	6007431.46715	2113367.23378	37.7833233693217	-122.417975883707	(37.7833233693217, -122.417975883707)	7	9	9	28858	36
139116	255407	2	75	199x Hayes St	3	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
149074	255412	2	75	199x Hayes St	8	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
164265	115538	2	133	99X Lech Walesa St	3	Sidewalk: Curb side : Cutout	Tree	2		02/08/2016 12:00:00 AM	3	3x10	Permit Number 770842	6007116.50228	2111387.72892	37.7778703965252	-122.418925098047	(37.7778703965252, -122.418925098047)	7	9	9	28852	36
164769	255405	2	75	199x Hayes St	1	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
165740	255404	2	75	150 Van Ness Ave	3	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
165889	65944	2	22	1051 Post St	1	Sidewalk: Curb side : Cutout	Tree	2		05/12/2016 12:00:00 AM	3	3x3	Permit Number 774496	6007126.88528	2114657.80083	37.7868498044193	-122.419121190999	(37.7868498044193, -122.419121190999)	13	9	9	28858	36
167439	115530	2	14	101 Polk St	3	Sidewalk: Curb side : Cutout	Tree	2		02/08/2016 12:00:00 AM	3	4x4	Permit Number 770842	6007332.44961	2111311.79762	37.7776740647351	-122.418172674243	(37.7776740647351, -122.418172674243)	7	9	9	28852	36
167550	255408	2	75	199x Hayes St	4	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
168962	115531	2	171	100X Hayes St	1	Sidewalk: Curb side : Pot	Tree	2		02/08/2016 12:00:00 AM	3		Permit Number 770842	6007312.73746	2111269.98589	37.7775581502144	-122.41823790028	(37.7775581502144, -122.41823790028)	7	9	9	28852	36
171393	115528	2	27	101 Polk St	1	Sidewalk: Curb side : Cutout	Tree	2		02/08/2016 12:00:00 AM	3	4x4	Permit Number 770842	6007325.8351	2111377.63368	37.7778544624367	-122.418200224953	(37.7778544624367, -122.418200224953)	7	9	9	28852	36
178102	255413	2	75	199x Hayes St	9	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
179705	255411	2	75	199x Hayes St	7	Sidewalk: Curb side : Cutout	Tree	2		05/21/2018 12:00:00 AM	3	3x3		6006976	2111107	37.7770916699959	-122.419391225109	(37.7770916699959, -122.419391225109)	7	9	9	28852	36
184734	115535	2	171	100X Hayes St	5	Sidewalk: Curb side : Pot	Tree	2		02/08/2016 12:00:00 AM	3		Permit Number 770842	6007237.56945	2111260.60051	37.7775281488378	-122.418497266559	(37.7775281488378, -122.418497266559)	7	9	9	28852	36
185440	115536	2	133	99X Lech Walesa St	1	Sidewalk: Curb side : Cutout	Tree	2		02/08/2016 12:00:00 AM	3	3x10	Permit Number 770842	6007116.50228	2111387.72892	37.7778703965252	-122.418925098047	(37.7778703965252, -122.418925098047)	7	9	9	28852	36
1962	122597	2	44	42X Colin P Kelly Jr St	5	Sidewalk: Curb side : Cutout	Tree	2		12/12/2016 12:00:00 AM	3	3x3	Permit Number 779103	6015480	2112413	37.781152948088	-122.390064228941	(37.781152948088, -122.390064228941)	6	2	9	28856	6
5835	118375	2	75	340 Fremont St	2	Sidewalk: Curb side : Cutout	Tree	2			2	4x6		6014712.48727	2114662.02755	37.7872856671566	-122.392876855803	(37.7872856671566, -122.392876855803)	6	2	9	28855	6
6762	260431	2	17	181 Fremont St	1	Sidewalk: Curb side : Cutout	Tree	2		08/27/2019 12:00:00 AM	3	3x3		6013986	2115554	37.7896944377585	-122.395452879395	(37.7896944377585, -122.395452879395)	12	2	9	28855	6
6991	112084	2	75	99X Fremont St	1	Sidewalk: Curb side : Cutout	Tree	2		11/23/2015 12:00:00 AM			Permit Number 775592	6013631.8	2115864.7	37.7905278405438	-122.396700174955	(37.7905278405438, -122.396700174955)	12	2	9	28855	6
8436	260432	2	17	181 Fremont St	2	Sidewalk: Curb side : Cutout	Tree	2		08/27/2019 12:00:00 AM	3	3x3		6013986	2115554	37.7896944377585	-122.395452879395	(37.7896944377585, -122.395452879395)	12	2	9	28855	6
17276	72565	2	22	270 Brannan St	1	Sidewalk: Property side : Cutout	Tree	2			3	4x4	Permit Number 770847	6015158	2112983	37.7827001752808	-122.391218053322	(37.7827001752808, -122.391218053322)	6	2	9	28856	6
19209	122592	2	189	72 Townsend St	1	Sidewalk: Curb side : Cutout	Tree	2		12/12/2016 12:00:00 AM	3	3x3	Permit Number 779103	6015480	2112413	37.781152948088	-122.390064228941	(37.781152948088, -122.390064228941)	6	2	9	28856	6
20157	121528	2	12	333 Beale St	4	Sidewalk: Curb side : Cutout	Tree	2				6x10		6015114	2115064	37.7884116849322	-122.391515808663	(37.7884116849322, -122.391515808663)	6	2	9	28855	6
21732	121544	2	75	318 Main St	5	Sidewalk: Curb side : Cutout	Tree	2				8x15		6015095	2115307	37.7890778525244	-122.391598542205	(37.7890778525244, -122.391598542205)	6	2	9	28855	6
22052	115353	2	75	399 Fremont St	6	Sidewalk: Curb side : Cutout	Tree	2		12/28/2016 12:00:00 AM	3	4x10	Permit Number 773314	6014819.91687	2114646.31579	37.7872484927813	-122.39250406973	(37.7872484927813, -122.39250406973)	6	2	9	28855	6
25972	121523	2	12	280 Beale St	2	Sidewalk: Curb side : Cutout	Tree	2				6x10		6014751	2115177	37.7887018021562	-122.392779649259	(37.7887018021562, -122.392779649259)	6	2	9	28855	6
26350	115356	2	75	399 Fremont St	9	Sidewalk: Curb side : Cutout	Tree	2		12/28/2016 12:00:00 AM	3	4x10	Permit Number 773314	6014763.69701	2114705.74438	37.7874085478076	-122.392702738938	(37.7874085478076, -122.392702738938)	6	2	9	28855	6
27168	75842	2	44	42X Colin P Kelly Jr St	2	Sidewalk: Curb side : Cutout	Tree	2		12/12/2016 12:00:00 AM	3	3x3	Permit Number 779103	6015480	2112413	37.781152948088	-122.390064228941	(37.781152948088, -122.390064228941)	6	2	9	28856	6
27935	253392	2	31	115 Steuart St	1	Sidewalk: Curb side : Cutout	Tree	2		08/30/2017 12:00:00 AM	3	3x3	Permit Number 771767	6014754.16338	2116767.09226	37.7930680031541	-122.392879995147	(37.7930680031541, -122.392879995147)	12	2	9	28855	6
29570	105276	2	44	64 Townsend St	5	Sidewalk: Curb side : Cutout	Tree	2		12/12/2016 12:00:00 AM	3	3x3	Permit Number 779103	6015520.22928	2112423.42174	37.7811837949483	-122.389925782657	(37.7811837949483, -122.389925782657)	6	2	9	28856	6
30147	115348	2	75	399 Fremont St	1	Sidewalk: Curb side : Cutout	Tree	2		12/28/2016 12:00:00 AM	3	4x10	Permit Number 773314	6014915.48611	2114547.78532	37.7869832575075	-122.39216652446	(37.7869832575075, -122.39216652446)	6	2	9	28855	6
30239	121540	2	75	318 Main St	1	Sidewalk: Curb side : Cutout	Tree	2				8x15		6015095	2115307	37.7890778525244	-122.391598542205	(37.7890778525244, -122.391598542205)	6	2	9	28855	6
32270	118379	2	75	340 Fremont St	6	Sidewalk: Curb side : Cutout	Tree	2				4x6		6014683	2114666	37.7872949366988	-122.392979154362	(37.7872949366988, -122.392979154362)	6	2	9	28855	6
34241	122599	2	44	42X Colin P Kelly Jr St	7	Sidewalk: Curb side : Cutout	Tree	2		12/12/2016 12:00:00 AM	3	3x3	Permit Number 779103	6015480	2112413	37.781152948088	-122.390064228941	(37.781152948088, -122.390064228941)	6	2	9	28856	6
34491	187942	2	75	300 Main St	3	Sidewalk: Curb side : Yard	Tree	2			3			6015080.74918	2115307.92538	37.7890796023783	-122.391647913344	(37.7890796023783, -122.391647913344)	6	2	9	28855	6
35800	121504	2	75	299 Fremont St	4	Sidewalk: Property side : Cutout	Tree	2			5	10x4		6014396.4001	2115093.29031	37.7884522533286	-122.394000660325	(37.7884522533286, -122.394000660325)	6	2	9	28855	6
36960	113338	2	14	2X STANFORD ST	3	Sidewalk: Property side : Cutout	Tree	2		11/10/2015 12:00:00 AM		3x9	Permit Number 770912	6014727	2112481	37.7812978691674	-122.392674013487	(37.7812978691674, -122.392674013487)	6	2	9	28856	6
37189	121502	2	75	299 Fremont St	2	Sidewalk: Property side : Cutout	Tree	2			4	10x4		6014428.99687	2115060.94265	37.7883652457059	-122.393885614549	(37.7883652457059, -122.393885614549)	6	2	9	28855	6
40138	121526	2	12	333 Beale St	2	Sidewalk: Curb side : Cutout	Tree	2				6x10		6015114	2115064	37.7884116849322	-122.391515808663	(37.7884116849322, -122.391515808663)	6	2	9	28855	6
40751	121505	2	75	299 Fremont St	5	Sidewalk: Property side : Cutout	Tree	2			5	10x4		6014377.50413	2115113.61118	37.7885069995398	-122.394067461056	(37.7885069995398, -122.394067461056)	6	2	9	28855	6