trees

This data as json, CSV

rowid	TreeID	qLegalStatus_id	qSpecies_id	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker_id	qCareAssistant	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location	Fire Prevention Districts	Police Districts	Supervisor Districts	Zip Codes	Neighborhoods (old)
10489	102839	4	63	1101X Portola Dr	2	Sidewalk: Property side : Yard	Tree	1
12952	20300	1	63	50X Sunset Blvd	2	Sidewalk: Curb side : Cutout	Tree	1		18	60
95203	141265	1	63	52 JORDAN AVE	2	Sidewalk: Curb side : Yard	Tree	2		12	Width 0ft	5996227.2891	2114192.1724	37.7849514808139	-122.456797345759	(37.7849514808139, -122.456797345759)	11	6	1	54	31
103192	132176	1	63	2745 Larkin St	2	Sidewalk: Property side : Yard	Tree	2		14		6006527.83964	2120663.1294	37.8033051783476	-122.421620437537	(37.8033051783476, -122.421620437537)	5	9	1	28858	32
103781	108605	4	63	1140x CHESTNUT ST	2	Unaccepted Street : Yard	Tree	2				6006369.1	2120452.7	37.8027184407042	-122.422154803739	(37.8027184407042, -122.422154803739)	5	9	1	28858	32
142225	23579	1	63	3100X Van Ness Ave	2	Median : Cutout	Tree	1		42	3x3	6005511.92719	2121098.11811	37.8044422083102	-122.425167011149	(37.8044422083102, -122.425167011149)	5	1	1	28858	32
163885	115556	4	63	3897 CLAY ST	2	Sidewalk: Curb side : Cutout	Tree	2			3x3	5996199	2115222	37.7877774871206	-122.456969730492	(37.7877774871206, -122.456969730492)	11	6	1	54	31
193997	132179	1	63	1302 Columbus Ave	2	Sidewalk: Property side : Yard	Tree	2		33		6007259.69894	2121860.76679	37.8066348265036	-122.419172811197	(37.8066348265036, -122.419172811197)	5	1	1	28858	32
8123	16369	1	63	1400X Montgomery St	2	Median : Cutout	Tree	1		18	8	6011455.2971485	2120087.0441833	37.8020000032358	-122.404528131508	(37.8020000032358, -122.404528131508)	3	1	10	308	23
92020	110148	4	63	90 WOODLAND AVE	2	Sidewalk: Curb side : Cutout	Tree	2		38	4x9	5997155.9	2105983.7	37.7624664223167	-122.452991942132	(37.7624664223167, -122.452991942132)	15	5	11	29492	12
96185	234523	1	63	90 Woodland Ave	2	Sidewalk: Curb side : Cutout	Tree	2		32	Width 5ft	5997132.36622	2105999.93621	37.7625096541183	-122.45307450849	(37.7625096541183, -122.45307450849)	15	5	11	29492	12
97194	24742	1	63	50X Point Lobos Ave	2	Sidewalk: Curb side : Cutout	Tree	1		12	12x12	5982568.63637	2112600.93828	37.7797886774071	-122.503933218017	(37.7797886774071, -122.503933218017)	11	6	2	55	26
106870	117252	6	63	2500x 34TH AVE	2	Side Yard : Yard	Tree	4			3x3	5985829	2097874	37.7395437603018	-122.491570003273	(37.7395437603018, -122.491570003273)	1	8	3	29491	35
170849	186531	1	63	1501 Sunset Blvd	2	unknown : Yard	Tree	2		9	Width 0ft	5984751.3064	2104919.289	37.7588251541556	-122.495815712177	(37.7588251541556, -122.495815712177)	1	8	3	56	35
7002	262493	1	63	1100X Portola Dr	2	Median : Yard	Tree	2			10x10	5995372	2097783	37.7398469739468	-122.458568082407	(37.7398469739468, -122.458568082407)	9	7	4	59	40
17261	261487	1	63	1100X Portola Dr	2	Median : Cutout	Tree	1	Private		3x3	5995262	2098056	37.7405902419398	-122.458968175006	(37.7405902419398, -122.458968175006)	1	7	4	59	40
30931	211072	1	63	602x Miramar Ave	2	Median : Yard	Tree	1		35		5995382.34021	2093429.07469	37.7278927511259	-122.458217288807	(37.7278927511259, -122.458217288807)	9	7	4	28861	40
32960	121406	1	63	10X Dorchester Way	2	Median : Cutout	Tree	1			8x30	5994075	2098171	37.7408376984389	-122.463080674317	(37.7408376984389, -122.463080674317)	1	8	4	59	40
49979	99473	4	63	600X Miramar Ave	2	Median : Cutout	Tree	2		30	15x280	5995435.2	2093399	37.7278132105567	-122.458032376835	(37.7278132105567, -122.458032376835)	9	7	4	28861	40
70780	211076	1	63	700x Miramar Ave	2	Median : Yard	Tree	1		74		5995394.80602	2094076.5012	37.7296711442905	-122.458221033586	(37.7296711442905, -122.458221033586)	9	7	4	28861	40
74337	211057	1	63	447 Lawton St	2	Sidewalk: Curb side : Pot	Tree	2		9	Width 3ft	5992810.26786	2104540.37946	37.7582534434534	-122.467916772063	(37.7582534434534, -122.467916772063)	1	8	4	56	12
87097	211066	1	63	500x Miramar Ave	2	Median : Yard	Tree	1		36		5995372.70371	2092704.86629	37.7259036953978	-122.458198208802	(37.7259036953978, -122.458198208802)	9	7	4	28861	40
118830	211056	1	63	1600 17th Ave	2	Sidewalk: Property side : Yard	Tree	2		20		5990908.64637	2104472.93122	37.7579582535812	-122.474488420401	(37.7579582535812, -122.474488420401)	1	8	4	56	12
178118	101028	1	63	1010X Portola Dr	2	Front Yard : Yard	Tree	1				5995923.3	2098391.5	37.7415494342357	-122.45670592621	(37.7415494342357, -122.45670592621)	1	7	4	59	40
184680	256643	1	63	2X Miraloma Dr	2	Side Yard : Cutout	Tree	1			10x10	5994995	2097925	37.7402151966004	-122.459881864698	(37.7402151966004, -122.459881864698)	9	8	4	59	40
193872	18113	1	63	1102X PORTOLA DR	2	Median : Cutout	Tree	1		24	10	5995249	2098057	37.7405922403942	-122.459013196083	(37.7405922403942, -122.459013196083)	1	7	4	59	40
15519	262098	1	63	10x Cuesta Ct	2	Unaccepted Street : Yard	Tree	1	Private		3x3	5999757	2101744	37.7509739685765	-122.443691128062	(37.7509739685765, -122.443691128062)	2	5	5	63	38
38246	111524	1	63	900x BOSWORTH ST	2	Front Yard : Yard	Tree	1		28		6001649	2095572	37.7341348351459	-122.436706663072	(37.7341348351459, -122.436706663072)	9	7	5	63	7
105484	115153	1	63	245x ARLINGTON ST	2	Median : Yard	Tree	1			3x3	6004671	2096632	37.7372166357496	-122.426334098447	(37.7372166357496, -122.426334098447)	2	7	5	63	7
134644	12968	1	63	99X Lippard Ave	2	Sidewalk: Curb side : Cutout	Tree	1		36	4X4	6001957.7757889	2095598.483465	37.7342250957668	-122.435641023763	(37.7342250957668, -122.435641023763)	2	7	5	63	7
149206	234518	1	63	1481 Noe St	2	Sidewalk: Curb side : Pot	Tree	2		5	Width 4ft	6003337.48877	2099628.14838	37.7453678996008	-122.431158447529	(37.7453678996008, -122.431158447529)	2	7	5	63	22
154451	178178	1	63	769 Cayuga Ave	2	Sidewalk: Property side : Yard	Tree	2		4	Width 8ft	6001369.37887	2092541.7115	37.725798463024	-122.43745647446	(37.725798463024, -122.43745647446)	9	7	6	28861	25
5675	261201	1	63	699x Benton Ave	2	Sidewalk: Curb side : Cutout	Tree	2			3x3	6007339	2095419	37.7340364554683	-122.417023656077	(37.7340364554683, -122.417023656077)	2	7	7	28859	2
18973	233322	1	63	51 Prentiss St	2	Sidewalk: Curb side : Cutout	Tree	2		13	Width 3ft	6008884.18383	2098343.89419	37.7421543791283	-122.411888074199	(37.7421543791283, -122.411888074199)	10	7	7	28859	2
43298	23673	1	63	319 Virginia Ave	2	Median : Cutout	Tree	1		12	12	6006936.2458165	2098250.5638735	37.741788638282	-122.418616833275	(37.741788638282, -122.418616833275)	2	7	7	28859	2
58718	234516	1	63	90x Peralta Ave	2	Median : Yard	Tree	1		15	Width 10ft	6010366.95066	2100295.32111	37.7475956480377	-122.406898611185	(37.7475956480377, -122.406898611185)	2	7	7	28859	2
176495	234508	1	63	201 Coso Ave	2	Side Yard : Yard	Tree	2		28	Width 5ft	6007691.39954	2099521.32268	37.745320345265	-122.416095727735	(37.745320345265, -122.416095727735)	2	7	7	28859	2
8023	121696	4	63	1300x De Haro St	2	Sidewalk: Curb side : Cutout	Tree	2			3x3	6012218	2102254	37.7530771598286	-122.400635326689	(37.7530771598286, -122.400635326689)	10	3	8	28856	29
12450	261565	1	63	1801 26th St	2	Sidewalk: Property side : Yard	Tree	1			3x3	6013146	2101521	37.7511162126671	-122.39737469907	(37.7511162126671, -122.39737469907)	10	3	8	28856	1
21065	201733	1	63	727 Jamestown Ave	2	Sidewalk: Property side : Yard	Tree	2		18	Width 8ft	6015510.4184	2087766.77172	37.7134812286504	-122.388238406274	(37.7134812286504, -122.388238406274)	10	3	8	58	1
65583	194443	1	63	1900 23rd St	2	Front Yard : Yard	Tree	2		28		6012732.21441	2102858.09004	37.7547645253758	-122.398899455441	(37.7547645253758, -122.398899455441)	10	3	8	28856	29
82734	201750	1	63	491 Jamestown Ave	2	Sidewalk: Property side : Yard	Tree	2		34	Width 8ft	6015853.10494	2087012.76113	37.7114298417752	-122.3870013933	(37.7114298417752, -122.3870013933)	10	3	8	58	1
106418	201754	1	63	724 Jamestown Ave	2	Sidewalk: Property side : Yard	Tree	2		15	Width 8ft	6015794.33118	2087216.37677	37.7119856767735	-122.387218726159	(37.7119856767735, -122.387218726159)	10	3	8	58	1

trees

Custom SQL query returning 43 rows (hide)

Query parameters