squirrels

84 rows where Shift = "PM" and Tail flags = "true" sorted by Longitude

View and edit SQL

Suggested facets: 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, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Tail flags

  • true · 84

Shift

Police Precincts

Link 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
2348 -73.9531965469704 40.7947437983977 38G-PM-1020-11 38G PM 10202018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false true false true true false   POINT (-73.9531965469704 40.7947437983977)   19 4 19 13
1218 -73.953375642605 40.7947144477885 38G-PM-1020-02 38G PM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.953375642605 40.7947144477885)   19 4 19 13
193 -73.9537691298752 40.7941272599797 38G-PM-1020-01 38G PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9537691298752 40.7941272599797)   19 4 19 13
1481 -73.9538867186376 40.7941409434007 38G-PM-1020-03 38G PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false true false   POINT (-73.9538867186376 40.7941409434007)   19 4 19 13
316 -73.9540616660191 40.7951556603245 38G-PM-1020-10 38G PM 10202018 10 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9540616660191 40.7951556603245)   19 4 19 13
1367 -73.9542684235907 40.7944237164092 38G-PM-1020-05 38G PM 10202018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false true false true false false true false   POINT (-73.9542684235907 40.7944237164092)   19 4 19 13
1368 -73.9542770888881 40.7943610366853 38G-PM-1020-04 38G PM 10202018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false true false true false false true false   POINT (-73.9542770888881 40.79436103668531)   19 4 19 13
2759 -73.9543373703455 40.7943889087123 38G-PM-1020-07 38G PM 10202018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false true   false true false true false false true false   POINT (-73.9543373703455 40.7943889087123)   19 4 19 13
74 -73.9546654184146 40.7947639241491 38G-PM-1020-09 38G PM 10202018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false true false false true false   POINT (-73.9546654184146 40.7947639241491)   19 4 19 13
1514 -73.9548006161673 40.7945503341011 38G-PM-1020-08 38G PM 10202018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   true false false true false false true false   POINT (-73.9548006161673 40.7945503341011)   19 4 19 13
652 -73.9570056123953 40.7878756067582 30I-PM-1006-02 30I PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9570056123953 40.7878756067582)   19 4 19 13
706 -73.9570132570934 40.7932014159087 35F-PM-1012-01 35F PM 10122018 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false true true   false false false true false false true true   POINT (-73.9570132570934 40.7932014159087)   19 4 19 13
2618 -73.95795157569 40.7961254697958 38C-PM-1014-04 38C PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   true false false true false   false false false true false false false true   POINT (-73.95795157569 40.7961254697958)   19 4 19 13
2176 -73.9583201789615 40.7913938722521 33F-PM-1012-05 33F PM 10122018 5 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false false true   true false false true true false false true   POINT (-73.95832017896151 40.7913938722521)   19 4 19 13
427 -73.9589367709165 40.7896465303483 31F-PM-1007-04 31F PM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9589367709165 40.7896465303483)   19 4 19 13
1421 -73.9595022290348 40.7831151330074 25I-PM-1007-02 25I PM 10072018 2 Adult Gray White Gray+White white belly Ground Plane FALSE   false false false false true   false false false true true false false true   POINT (-73.9595022290348 40.783115133007406)   19 4 19 13
2142 -73.9598535425706 40.7915589343685 33D-PM-1006-01 33D PM 10062018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false true false false false hanging on fence true false false true false false false true   POINT (-73.9598535425706 40.7915589343685)   19 4 19 13
2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false true   true true false true true false true false   POINT (-73.9601988871514 40.7943473161329)   19 4 19 13
1815 -73.9603268255317 40.7900154505092 31E-PM-1006-06 31E PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false true false false true false   POINT (-73.9603268255317 40.7900154505092)   19 4 19 13
1995 -73.9603366992925 40.7899612889539 31E-PM-1006-05 31E PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false true false false true false   POINT (-73.9603366992925 40.789961288953904)   19 4 19 13
379 -73.9606817053484 40.7917320450401 32D-PM-1006-07 32D PM 10062018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.9606817053484 40.7917320450401)   19 4 19 13
730 -73.9607280801601 40.7901506706248 31D-PM-1006-01 31D PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false true false false false true   POINT (-73.9607280801601 40.7901506706248)   19 4 19 13
583 -73.9612398509782 40.7950033150385 35A-PM-1013-12 35A PM 10132018 12 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9612398509782 40.7950033150385)   19 4 19 13
2134 -73.9614373639552 40.7945051962914 35B-PM-1013-01 35B PM 10132018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false did not notice dog sitting a few yards away (10-20 ft) false false false true false false true false   POINT (-73.9614373639552 40.7945051962914)   19 4 19 13
2672 -73.9614599022015 40.7945181285991 35A-PM-1013-11 35A PM 10132018 11 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9614599022015 40.7945181285991)   19 4 19 13
2026 -73.9622752768962 40.7814921913101 22H-PM-1007-02 22H PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 low branch false false false false false watching me scratching true false false true false false true false   POINT (-73.9622752768962 40.7814921913101)   19 4 19 13
1531 -73.9630381400083 40.7807571827321 21H-PM-1018-02 21H PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false true false false true false   POINT (-73.9630381400083 40.7807571827321)   19 4 19 13
2294 -73.9630820577441 40.7821632293136 22G-PM-1018-01 22G PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false true false   false false false true false false true false   POINT (-73.9630820577441 40.7821632293136)   19 4 19 13
727 -73.9634563222926 40.780992836417 21G-PM-1007-04 21G PM 10072018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false true false false false true   POINT (-73.9634563222926 40.780992836417)   19 4 19 13
887 -73.9635028497015 40.7928207574906 32A-PM-1013-05 32A PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9635028497015 40.7928207574906)   19 4 19 13
159 -73.9638270331336 40.7810450065235 21G-PM-1007-02 21G PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false true false false false true   POINT (-73.9638270331336 40.7810450065235)   19 4 19 13
94 -73.9641971813967 40.7813537959435 21G-PM-1007-01 21G PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.9641971813967 40.7813537959435)   19 4 19 13
614 -73.9642411990432 40.7779692777193 18H-PM-1014-03 18H PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9642411990432 40.7779692777193)   19 4 19 13
1616 -73.9642666013207 40.7810384867375 21G-PM-1007-03 21G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.96426660132072 40.7810384867375)   19 4 19 13
78 -73.964474836001 40.7883840104749 28C-PM-1006-01 28C PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false gathering acorns false false false true false false false true gnd to tree POINT (-73.964474836001 40.7883840104749)   19 4 19 13
1967 -73.9647247254127 40.7806136565784 20G-PM-1013-03 20G PM 10132018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true true   false false false true false false false true   POINT (-73.9647247254127 40.7806136565784)   19 4 19 13
2857 -73.9649230271173 40.7821766215675 22F-PM-1014-02 22F PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9649230271173 40.7821766215675)   19 4 19 13
784 -73.9649658099293 40.7823262369074 22F-PM-1014-03 22F PM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9649658099293 40.7823262369074)   19 4 19 13
192 -73.9651654887991 40.7777806006951 17H-PM-1007-02 17H PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9651654887991 40.7777806006951)   19 4 19 13
2217 -73.9652746477521 40.7809326848536 20F-PM-1007-07 20F PM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon cinnamon tail Ground Plane FALSE   true false false false false watching false false false true false false false true   POINT (-73.96527464775211 40.7809326848536)   19 4 19 13
2463 -73.9653343572865 40.7775286924617 17H-PM-1007-01 17H PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true true false   false false false true false false false true   POINT (-73.9653343572865 40.7775286924617)   19 4 19 13
133 -73.9664711607022 40.787896428768 26A-PM-1006-06 26A PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Tree 90th left 90th & 89 false false true false false   false false false true false false false false studying us looking for food POINT (-73.9664711607022 40.787896428768)   19 4 19 13
2444 -73.966590487009 40.7802469052891 19E-PM-1018-02 19E PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false   false false false true false false false false   POINT (-73.96659048700901 40.7802469052891)   19 4 19 13
1135 -73.9667474482967 40.7760643720793 15H-PM-1008-01 15H PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10 Oak tree false true false false false watching me false true false true false false false false observant POINT (-73.9667474482967 40.7760643720793)   19 4 19 13
1523 -73.9673103881521 40.7874267409618 26A-PM-1006-01 26A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9673103881521 40.7874267409618)   19 4 19 13
15 -73.9674285955293 40.7829723919744 21C-PM-1006-01 21C PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false false   false false false true true false false false   POINT (-73.9674285955293 40.7829723919744)   19 4 19 13
1415 -73.9678561384348 40.7782877397822 16E-PM-1018-02 16E PM 10182018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false true false false false   false false false true false false false false gets distance from people but then continues to chase #1 POINT (-73.9678561384348 40.7782877397822)   19 4 19 13
1795 -73.968004352343 40.7726669278308 11I-PM-1012-01 11I PM 10122018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false true true false false false look at humans determining POINT (-73.968004352343 40.7726669278308)   19 4 19 13
1174 -73.9682067129876 40.7779911208015 16E-PM-1018-05 16E PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false staring false false false true false true false false approaches (very close) POINT (-73.9682067129876 40.7779911208015)   19 4 19 13
2210 -73.9699124811406 40.7743016981538 12F-PM-1007-07 12F PM 10072018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true true true false true   false false false true false false true false   POINT (-73.9699124811406 40.7743016981538)   19 4 19 13
1910 -73.9699876501742 40.7742482676758 12F-PM-1007-06 12F PM 10072018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true true false false true   false false false true false false true false   POINT (-73.9699876501742 40.77424826767581)   19 4 19 13
1636 -73.9701408623121 40.7695511718541 7I-PM-1013-04 07I PM 10132018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Grass true false false true false   false false false true false false false false   POINT (-73.9701408623121 40.7695511718541)   19 4 19 13
416 -73.9702788578386 40.7694484997295 7I-PM-1013-05 07I PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rock false false false true false   false false false true false false false false   POINT (-73.9702788578386 40.7694484997295)   19 4 19 13
658 -73.9704575848926 40.7693499326095 7H-PM-1006-09 07H PM 10062018 9 Adult Black   Black+   Ground Plane FALSE by tree false false false true true   false false false true false true false true   POINT (-73.9704575848926 40.7693499326095)   19 4 19 13
2335 -73.9704679459444 40.7773384236212 14D-PM-1019-10 14D PM 10192018 10 Adult Gray   Gray+   Above Ground 20   false false true false false   false false false true false false false true   POINT (-73.9704679459444 40.7773384236212)   19 4 19 13
2185 -73.9707571364399 40.7758859812524 13E-PM-1008-02 13E PM 10082018 2 Adult Gray White Gray+White   Above Ground 10   false false false false true   false false false true false false true false   POINT (-73.9707571364399 40.7758859812524)   19 4 19 13
1959 -73.9707737073771 40.7800373465838 17B-PM-1012-02 17B PM 10122018 2 Adult Black   Black+   Ground Plane FALSE   true true false false true 2/3 chasing each other true true false true true false true false   POINT (-73.9707737073771 40.7800373465838)   19 4 19 13
569 -73.9709040623777 40.7701163892686 7H-PM-1006-03 07H PM 10062018 3 Adult Gray   Gray+   Above Ground 8 tree true false true false false   false false false true false false true false   POINT (-73.9709040623777 40.7701163892686)   19 4 19 13
2203 -73.9710531485298 40.7773757069445 14D-PM-1019-06 14D PM 10192018 6 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.97105314852982 40.777375706944504)   19 4 19 13
210 -73.9711298491132 40.7676902603543 5I-PM-1008-01 05I PM 10082018 1 Adult Black Cinnamon Black+Cinnamon   Above Ground 15 in tree by arsenal - climbing false false true true false   false false false true false false false false   POINT (-73.9711298491132 40.7676902603543)   19 4 19 13
2794 -73.9712187890707 40.7750640173134 12E-PM-1018-01 12E PM 10182018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   true false true false false   true false false true false false false true   POINT (-73.9712187890707 40.7750640173134)   19 4 19 13
2980 -73.9716414586381 40.771760114722 9F-PM-1014-06 09F PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false running (from birds) false false false true false false true false   POINT (-73.9716414586381 40.771760114722)   19 4 19 13
2852 -73.9728146482385 40.7652951714745 1I-PM-1012-03 01I PM 10122018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Black, & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true false   false false false true false false false true   POINT (-73.97281464823851 40.765295171474506)   19 4 19 13
1982 -73.9729979174723 40.7742904356698 10D-PM-1008-01 10D PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9729979174723 40.7742904356698)   19 4 19 13
1058 -73.9737100743183 40.7708360121735 7E-PM-1013-03 07E PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE Ground & Tree Base false false false false true   false false false true true false true false   POINT (-73.9737100743183 40.7708360121735)   19 4 19 13
2992 -73.9746063250438 40.7687654196811 4F-PM-1013-03 04F PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9746063250438 40.7687654196811)   19 4 19 13
2705 -73.9748962681637 40.76787782717 4F-PM-1013-02 04F PM 10132018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false true false   POINT (-73.9748962681637 40.76787782717)   19 4 19 13
1059 -73.9749457516921 40.7676712372245 3F-PM-1013-07 03F PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9749457516921 40.7676712372245)   19 4 19 13
1836 -73.9751056714758 40.7732060035215 8C-PM-1013-03 08C PM 10132018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.9751056714758 40.7732060035215)   19 4 19 13
815 -73.9753283783695 40.7733043910649 8C-PM-1013-02 08C PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9753283783695 40.7733043910649)   19 4 19 13
1333 -73.9754527701832 40.7656088463928 1G-PM-1010-02 01G PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false false false false laying on tree branch false false false true true false false false   POINT (-73.9754527701832 40.7656088463928)   19 4 19 13
2821 -73.9754536566013 40.7698604918771 5E-PM-1012-04 05E PM 10122018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9754536566013 40.7698604918771)   19 4 19 13
294 -73.9756573579063 40.7656644063024 1G-PM-1010-01 01G PM 10102018 1 Adult Gray White Gray+White   Above Ground 15   false false true true false   false false false true false false true false too busy eating in his tree POINT (-73.9756573579063 40.7656644063024)   19 4 19 13
239 -73.9758464905133 40.7725957408841 8C-PM-1013-05 08C PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9758464905133 40.7725957408841)   19 4 19 13
1403 -73.9761632586697 40.7741085606149 9B-PM-1013-05 09B PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false true false false true false   POINT (-73.9761632586697 40.7741085606149)   19 4 19 13
1198 -73.9762187733662 40.7739282973004 9B-PM-1013-08 09B PM 10132018 8 Juvenile Cinnamon Black, White Cinnamon+Black, White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9762187733662 40.7739282973004)   19 4 19 13
2505 -73.9762974698771 40.7740076116964 9B-PM-1013-06 09B PM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9762974698771 40.7740076116964)   19 4 19 13
150 -73.9763430829342 40.7686351097159 4D-PM-1008-11 04D PM 10082018 11 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3 on tree facing downward false true false false false chased #12 true false false true false false false true   POINT (-73.9763430829342 40.7686351097159)   19 4 19 13
194 -73.9764839973068 40.7691725326976 4D-PM-1008-06 04D PM 10082018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9764839973068 40.7691725326976)   19 4 19 13
2591 -73.9786351029146 40.7716114164002 6A-PM-1012-06 06A PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE elevated ground false true false false true   false false false true false false true false   POINT (-73.9786351029146 40.771611416400205)   19 4 19 13
1660 -73.9800499498034 40.7702181099573 4A-PM-1007-05 04A PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE At rock false false false false true   false false false true true false true false   POINT (-73.9800499498034 40.770218109957305)   19 4 19 13
1175 -73.9803282698463 40.7680809889384 1B-PM-1019-09 01B PM 10192018 9 Adult Gray White Gray+White   Ground Plane FALSE Tree to ground false false false false true   false false false true false false true false   POINT (-73.9803282698463 40.7680809889384)   19 4 19 13
855 -73.9808247660048 40.7689408831287 2A-PM-1019-01 02A PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false runs from false false false true false false false true   POINT (-73.9808247660048 40.7689408831287)   19 4 19 13
1956 -73.980897497712 40.7690578709841 2A-PM-1019-02 02A PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false true false false false false   POINT (-73.980897497712 40.7690578709841)   19 4 19 13

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE squirrels(
  "Longitude" TEXT,
  "Latitude" TEXT,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" TEXT,
  "Hectare Squirrel Number" TEXT,
  "Age" TEXT,
  "Primary Fur Color" TEXT,
  "Highlight Fur Color" TEXT,
  "Combination of Primary and Highlight Color" TEXT,
  "Color notes" TEXT,
  "Location" TEXT,
  "Above Ground Sighter Measurement" TEXT,
  "Specific Location" TEXT,
  "Running" TEXT,
  "Chasing" TEXT,
  "Climbing" TEXT,
  "Eating" TEXT,
  "Foraging" TEXT,
  "Other Activities" TEXT,
  "Kuks" TEXT,
  "Quaas" TEXT,
  "Moans" TEXT,
  "Tail flags" TEXT,
  "Tail twitches" TEXT,
  "Approaches" TEXT,
  "Indifferent" TEXT,
  "Runs from" TEXT,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT,
  "Zip Codes" TEXT,
  "Community Districts" TEXT,
  "Borough Boundaries" TEXT,
  "City Council Districts" TEXT,
  "Police Precincts" TEXT
);
Powered by Datasette · Query took 86.651ms