squirrels

Custom SQL query returning 22 rows (hide)

select rowid, Longitude, Latitude, [Unique Squirrel ID], Hectare, Shift, Date, [Hectare Squirrel Number], Age, [Primary Fur Color], [Highlight Fur Color], [Combination of Primary and Highlight Color], [Color notes], Location, [Above Ground Sighter Measurement], [Specific Location], Running, Chasing, Climbing, Eating, Foraging, [Other Activities], Kuks, Quaas, Moans, [Tail flags], [Tail twitches], Approaches, Indifferent, [Runs from], [Other Interactions], [Lat/Long], [Zip Codes], [Community Districts], [Borough Boundaries], [City Council Districts], [Police Precincts] from squirrels where "Hectare" = :p0 and "Police Precincts" = :p1 order by [Combination of Primary and Highlight Color] limit 101

Query parameters

This data as json, CSV

rowid	Longitude	Latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	Primary Fur Color	Highlight Fur Color	Combination of Primary and Highlight Color	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long	Community Districts	Borough Boundaries	City Council Districts	Police Precincts
1763	-73.9768286349595	40.7687012827059	3D-PM-1010-05	03D	PM	10102018	5	Adult	Cinnamon		Cinnamon+	Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9768286349595 40.7687012827059)	19	4	19	13
214	-73.9772576561244	40.7679895093963	3D-AM-1006-08	03D	AM	10062018	8	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		false	false	false	true	true		false	false	false	false	false	true	false	false	approaches (food stand)	POINT (-73.9772576561244 40.7679895093963)	19	4	19	13
257	-73.9773317054464	40.7684035996758	3D-AM-1006-03	03D	AM	10062018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	on top [of] a big rock/boulder in the area	true	false	true	false	false	climbing (rock)	false	false	false	false	false	true	false	false	approaches (slightly),wary of humans	POINT (-73.9773317054464 40.76840359967581)	19	4	19	13
493	-73.9776854797916	40.7683102295663	3D-AM-1006-04	03D	AM	10062018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	false	true	runs from (boy on bike)	POINT (-73.9776854797916 40.7683102295663)	19	4	19	13
2245	-73.9774228454023	40.7686399839016	3D-AM-1006-05	03D	AM	10062018	5	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	false	true	runs from (chased by boy),wary of humans in playground	POINT (-73.9774228454023 40.7686399839016)	19	4	19	13
2280	-73.9767143644151	40.7684756941321	3D-AM-1006-02	03D	AM	10062018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	25	tree	true	false	true	false	false		false	false	false	false	false	false	true	false		POINT (-73.9767143644151 40.7684756941321)	19	4	19	13
2462	-73.9768544488742	40.7680069500977	3D-AM-1006-07	03D	AM	10062018	7	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		true	false	false	false	false	running (with food in mouth)	false	false	false	false	false	false	true	false		POINT (-73.9768544488742 40.7680069500977)	19	4	19	13
2583	-73.9769693140651	40.7684390015166	3D-AM-1006-01	03D	AM	10062018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	9	up a tree	true	false	true	true	true	digging (?)	false	false	false	true	false	false	false	true	runs from (man led his dog into the area to chase squirrel)	POINT (-73.9769693140651 40.7684390015166)	19	4	19	13
140	-73.9768652785664	40.7684838168207	3D-PM-1010-03	03D	PM	10102018	3	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		false	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.97686527856641 40.7684838168207)	19	4	19	13
514	-73.9768357173861	40.7683813358343	3D-PM-1010-12	03D	PM	10102018	12	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		true	true	false	false	true		false	true	false	false	false	false	false	false		POINT (-73.9768357173861 40.7683813358343)	19	4	19	13
1127	-73.9776445567926	40.768119107973	3D-PM-1010-07	03D	PM	10102018	7	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9776445567926 40.768119107973)	19	4	19	13
2674	-73.9771009024581	40.7688793288864	3D-PM-1010-06	03D	PM	10102018	6	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9771009024581 40.7688793288864)	19	4	19	13
1238	-73.9773692131441	40.7679771150149	3D-PM-1010-02	03D	PM	10102018	2	Adult	Gray		Gray+	Above Ground	8		false	false	true	false	false		false	false	false	false	false	false	false	false		POINT (-73.9773692131441 40.7679771150149)	19	4	19	13
1293	-73.9775465365348	40.7681943707876	3D-PM-1010-09	03D	PM	10102018	9	Adult	Gray		Gray+	Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	false	false	false	true		POINT (-73.9775465365348 40.7681943707876)	19	4	19	13
1329	-73.9772164524209	40.7688399538756	3D-AM-1006-06	03D	AM	10062018	6		Gray		Gray+	Above Ground	10	tree	true	false	true	false	false		false	false	false	false	false	false	false	false	did not run from humans,but ran straight to tree & climbed up	POINT (-73.9772164524209 40.7688399538756)	19	4	19	13
705	-73.9779228287629	40.7681019683859	3D-PM-1010-01	03D	PM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9779228287629 40.7681019683859)	19	4	19	13
1768	-73.9773696455031	40.7687241866704	3D-PM-1010-14	03D	PM	10102018	14	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10		false	false	false	false	false	crying out	true	true	false	false	false	false	false	false		POINT (-73.9773696455031 40.7687241866704)	19	4	19	13
2315	-73.9767849679735	40.768566516928	3D-PM-1010-04	03D	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9767849679735 40.768566516928)	19	4	19	13
807	-73.9777259022441	40.7682059907903	3D-PM-1010-10	03D	PM	10102018	10	Adult	Gray	White	Gray+White	Ground Plane	FALSE		false	false	false	false	true		false	false	false	false	false	false	false	true		POINT (-73.9777259022441 40.7682059907903)	19	4	19	13
1532	-73.9779263114572	40.7682681855369	3D-PM-1010-08	03D	PM	10102018	8	Adult	Gray	White	Gray+White	Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9779263114572 40.7682681855369)	19	4	19	13
1913	-73.9774630821854	40.7680626674086	3D-PM-1010-11	03D	PM	10102018	11	Adult	Gray	White	Gray+White	Ground Plane	FALSE		true	false	false	false	true		false	false	false	false	false	false	false	false		POINT (-73.9774630821854 40.76806266740861)	19	4	19	13
2628	-73.9770439076963	40.7685720141731	3D-PM-1010-13	03D	PM	10102018	13	Adult	Gray	White	Gray+White	Ground Plane	FALSE		true	false	false	false	false		false	false	false	false	false	false	false	false		POINT (-73.9770439076963 40.7685720141731)	19	4	19	13