Is it possible to export numbers of observations by species?

General
1

This lists numbers of observations by species. Is there a way to export this or similar to a csv?

https://www.inaturalist.org/observations?nelat=30.587335&nelng=-84.129826&subview=map&swlat=30.346777&swlng=-84.378008&taxon_id=47208&view=species

2

Click on filters.
bottom right corner “Download”

3

That gives me all of the observations, which I can get the numbers of observations from, but what I’d like ideally is to be able to export something like

Harmonia axyridis 429
Diaprepes abbreviatus 134
etc.

4

Not a great answer, but: you can hit the API that supplies this data to the web browser. This returns the data in JSON format. The parameters (what comes after the “?”) are mostly the same as in the search URL you posted, plus a “fields” param:

https://api.inaturalist.org/v2/observations/species_counts?taxon_id=47208&nelat=30.587335&nelng=-84.129826&swlat=30.346777&swlng=-84.378008&order=desc&fields=(count%3A!t%2Ctaxon%3A(id%3A!t%2Cname%3A!t))

Hopefully you can use this, or find an easy tool to convert it to CSV.

1 Like
5

Try https://kildor.name/inat/species. This will generate the list. Presentation settings on that page includes CSV output. However to get your specific location box you will need to make a place:
https://help.inaturalist.org/en/support/solutions/articles/151000175019-how-to-make-a-place-on-inaturalist

After you make the place you can grab the place ID from the place you created from the URL generated.

2 Likes
6

https://jumear.github.io/stirfry/iNatAPIv1_observations_species_counts?verifiable=true&nelat=30.587335&nelng=-84.129826&swlat=30.346777&swlng=-84.378008&taxon_id=47208

or maybe (depending on what you’re trying to do):
https://jumear.github.io/stirfry/iNat_observations_taxonomy?verifiable=true&nelat=30.587335&nelng=-84.129826&swlat=30.346777&swlng=-84.378008&taxon_id=47208

if you’re using kildor’s page, you should be able to use the additional parameters input box to specify a bounding box without creating a place.

1 Like
7

You can use additional params, so form will be like https://kildor.name/inat/species?taxon={"id"%3A47208%2C"name"%3A"47208"%2C"commonName"%3A"47208"%2C"lookupSuccess"%3Afalse}&limit=0&species_only=true&quality_grade=needs_id%2Cresearch&date_any=true&csv=true&additional=nelat%3D30.587335%26nelng%3D-84.129826%26swlat%3D30.346777%26swlng%3D-84.378008&order_by=count

2 Likes
8

I’ve run into this enough times that I’ve build some tools to get the data, at https://ca-plants.github.io/inat-tools/

Like the other suggestions, it doesn’t currently support a rectangular boundary, you need to specify a place. You can get the list for Coleoptera in Leon County, FL at https://ca-plants.github.io/inat-tools/taxa.html#{“f1”:{“place_id”:“175”,“taxon_id”:“47208”}} - there’s a link in the upper right to download as CSV.

1 Like
9

the other suggestions do support a rectangular boundary.

10

Thanks to all of you. I was just trying to give a relatively simple example and one or more of the solutions above should work perfectly. And weird, as I didn’t draw that box; that came from entering Tallahassee, FL in location.

11

in the website, if the place is not defined within iNaturalist, or if there’s a problem looking up the place in iNaturalist, then you’ll get a bounding box based on a place definition that exists in Google Maps.

1 Like
12

Interesting, in part cuz google maps has a much more intricate poly for Tallahassee.

13

iNat doesn’t currently support query by polygon. your options are by place, by bounding box, and by point and radius.

14

What I meant was that if it’s pulling from google maps and google maps has a poly that I would have expected it to treat it as a place rather than making a greatest extent box from that poly. Not complainging; just odd to me. Also surprised that no one has uploaded a Tallahassee poly of some sort as a place and I may have to make some sort of hybrid greatest extent poly and upload as a place.

15

the Google place definition doesn’t live in iNat. so you can’t query by a place that doesn’t exist. it should be easy to make a place for Tallahassee if you want. if the Tallahassee government doesn’t have a KML file available already (or something that can be translated to KML), then you can make one using OpenStreetMap boundaries or US Census boundaries. there are threads in the forum describing how to do that.

16

Thanks again. Yes, I understand that, but if it’s making a box based upon the google maps poly then in my head it could probably just use the poly. And I’ve used and made polys to create iNat places; I was just surprised no one had made one for Tallahassee.

17

again, the only way iNat can currently query by a polygon is if the place is created in the system. since Tallahassee doesn’t exist in the system, it falls back to a bounding box based on Google’s place definition.

18

Not sure why you keep repeating this as I’ve understood this from the first time you said it.

1 Like
19

This is a great tool and thanks! I was able to reproduce the results here in a usable format but is there a way to have it output subspecies?

https://www.inaturalist.org/observations?list_id=4504924&not_in_project=12294&place_id=21&subview=map&user_id=206,520,1651,1692,3050,3532,3785,4172,4435,4873,5245,5504,6075,6506,7580,7651,9560,9706,11064,12049,13118,13935,15186,16101,18222,19145,19283,19380,19563,19780,20198,21324,24628,26132,26405,27908,28651,30296,33403,34707,34850,37031,38771,39429,43255,44308,50920,52828,53313,55228,56162,56186,56498,59878,61883,63502,64568,65391,65794,65966,71842,76537,77759,79477,81145,87743,90556,90723,98208101301,101508,102165,110718,111835,112578,114140,117087,124129,126641,129987,137476,140950,149787,152221,154438,158061,161086,164476,168878,175524,176684,176687,178668,181325,183751,187893,210221,213200,213832,214943,220924,226045,227249,229868,232439,235380,236465,237718,240389,246323,248039,252354,257303,264861,266742,267639,268126,269781,273961,276802,277896,278787,279996,282507,286217,287434,288534,288706,289392,291618,292007,292489,293111,294081,296365,296408,296740,300627,302506,303557,306026,307747,307920,309089,309729,318866,320666,324756,327491,349183,363007,365249,365716,371538,376997,386641,387980,393377,395895,400025,400397,403664,410175,410467,410488,417989,421644,421879,422347,430882,434305,438477,438488,439575,441498,445259,447172,449852,450545,453191,453687,459255,459348,460307,460502,465930,466202,468528,470497,470882,475590,479031,480373,486020,486677,490628,497017,503127,505126,505269,508503,512125,514090,519970,520786,521719,521996,529327,536155,536716,541210,541766,541847,548506,551394,552318,554165,556557,579678,579740,583599,586546,589956,597776,600016,604948,607566,608484,608645,608901,611811,613626,623341,631421,641181,646847,654809,655174,658581,674664,682196,690411,698268,712290,724261,735985,737603,738948,741135,741170,741872,742241,744712,746176,746541,747059,747403,747958,749118,750849,754003,757198,757312,757765,760218,761029,761449,762080,764155,767309,767919,770371,771826,777160,781032,781589,782433,783729,787662,788316,792319,792374,796231,809273,812483,819630,836675,841173,856994,858503,875456,907409,912975,913230,916176,922012,924375,925155,931458,931800,933529,939854,939861,943599,944004,947744,956921,967448,970009,972717,972936,978321,986428,987073,994028,994868,995055,1000661,1010285,1025838,1029832,1031019,1035293,1040988,1042791,1050981,1060116,1063681,1067109,1068344,1071173,1073605,1075594,1077267,1083172,1087685,1090878,1097466,1098134,1106551,1110174,1110667,1111751,1117871,1120329,1127654,1128112,1130299,1130591,1136002,1136448,1139722,1144483,1153393,1153436,1163555,1167081,1167958,1168100,1169396,1179044,1184638,1188561,1213853,1223795,1227102,1228909,1234154,1235349,1243759,1280877,1282686,1292133,1293230,1298979,1302556,1306000,1308049,1321085,1337871,1342929,1344527,1348569,1359374,1359904,1360701,1366955,1367410,1368645,1368670,1371945,1379099,1381828,1386411,1388765,1391251,1396826,1398432,1405378,1405682,1411111,1416798,1418161,1422422,1423800,1424605,1428321,1429691,1429743,1429993,1436264,1438982,1442288,1447224,1448882,1464843,1489409,1494485,1499778,1514188,1515879,1517069,1532469,1533494,1540274,1540297,1541851,1543773,1550297,1551934,1552325,1552343,1553703,1555048,1568176,1585485,1588724,1592204,1596117,1632622,1635846,1637536,1640459,1650530,1655180,1665363,1666363,1668849,1679217,1684776,1685976,1704749,1711333,1729679,1730434,1739755,1751333,1762496,1764297,1771680,1777748,1780297,1805291,1809400,1810877,1821428,1832448,1854783,1871393,1871474,1873215,1874240,1886142,1888718,1913736,1928596,1948481,1960620,1964716,1969747,2017154,2033807,2045841,2070597,2076854,2089522,2100979,2102168,2106764,2117934,2118269,2125177,2125908,2134510,2149285,2159765,2171695,2183872,2194906,2304199,2310987,2318004,2328821,2331520,2340782,2343675,2368024,2388485,2392865,2467361,2469630,2470368,2470624,2473573,2474496,2490862,2494062,2495027,2495041,2505640,2518293,2530365,2534235,2539505,2546272,2554196,2564217,2568589,2572340,2577237,2587099,2611012,2615133,2621666,2642010,2672457,2685643,2726670,2733548,2750232,2753197,2760337,2781857,2783814,2784387,2788441,2815562,2831185,2831770,2832086,2835930,2839642,2841182,2844521,2850982,2863877,2871991,2893618,2900108,2916021,2949643,2965244,3036646,3051731,3053460,3053989,3060142,3092360,3093037,3143320,3185168,3223995,3270256,3279498,3286634,3334446,3338788,3344456,3359010,3362707,3367364,3385144,3387291,3388952,3397907,3400838,3400929,3410494,3439621,3447335,3453019,3459052,3465153,3472185,3500262,3504483,3509070,3514798,3578177,3635487,3643094,3745677,3768173,3781092,3781428,3783286,3788544,3817102,3829584,3831606,3849698,3855436,3855575,3870850,3889162,3892075,3901030,3901068,3902192,3904381,3911628,3913694,3920999,3925392,3930442,3945463,3964493,3970422,3981414,3982813,3985149,3993771,4003345,4015389,4023775,4032576,4047585,4048062,4058281,4073277,4132381,4134556,4140675,4143116,4168762,4304943,4311031,4333170,4420071,4438721,4465482,4480682,4513162,4530284,4573202,4576596,4637153,4652702,4670777,4694607,4698609,4713179,4716984,4738061,4747384,4762684,4791628,4827706,4844438,4893494,4931406,4983823,4999098,5018603,5020937,5037349,5041624,5059254,5064525,5120200,5123391,5126259,5131836,5135221,5148286,5150751,5155065,5178080,5195297,5196723,5217411,5268402,5290317,5294061,5294089,5294247,5342949,5343878,5348172,5376442,5384701,5468371,5472708,5477334,5496020,5498692,5502886,5505634,5517264,5525215,5532772,5549689,5569560,5582140,5683223,5687068,5690872,5701397,5760640,5792587,5831442,5838794,5839219,5846336,5857181,5886784,5893773,5903412,5928408,5977900,6029059,6045758,6046086,6046992,6073524,6153087,6167102,6205473,6223245,6232758,6346197,6373993,6412872,6446107,6467470,6490867,6504026,6508523,6553938,6555105,6565644,6586000,6615450,6616307,6639114,6704112,6934023,6977590,7018501,7161220,7233849,7273155,7282084,7366982,7449902,7556198,7682648,7745567,7766529,7767116,7864206,8308605,8538770,8715291,8811666&view=species

20

I’m not sure, because iNat itself doesn’t return subspecies, even if you set hrank=subspecies.