This looks awesome. I'm the target audience. I do quite a bit of development around SQL Server and there's an endless stream of CSV and XLSX files coming and going that need spot checks and quick looks. I use ModernCSV quite a bit and would have purchased that if it built these SQL features in. I've used DuckDB directly a few times to join and query CSV and XLSX files, I'll pay my own $$ for something that quickly streamlines this.
I can import into SQL Server but there's too much ceremony needed (column types, etc) for quick looks at data I'm going to answer a question about and then discard. After a quick look at TextQuery I'm running into the same issues (although TextQuery is just a couple of clicks instead of 5+). I was also seeing an error yesterday from associating XLSX files with TextQuery but that seems to have gone away today.
My account shows 3 devices available to install on and I can disable computers on demand. Runs well on my M1 and on my 3060 and even all but the most demanding of assemblies on my little work laptop with onboard Intel graphics.
I assume files are compatible, presets are the same on both MacOS and Windows.
I've been able to run it on an Intel laptop with integrated video. I haven't been able to test the most complex models / presets, I might give that a shot this weekend and see where it falls apart.
An elderly friend of mine who lives alone keeps his most used dishes in the dishwasher. Need a clean dish? Find one in there. Have a dirty dish? Put it in the dishwasher? Can't find a clean dish? Run the dishwasher.
Maybe not quite efficient from a water/energy/soap perspective. But efficient for his time and attention.
This project is designed to showcase the first known photographs of living specimens of any species. Note that by 'first known' I'm referring to the first known photographs of a species anywhere, not just the first photographs to be submitted to iNaturalist.
Two types of observation will be included:
1) First photographic records of undescribed species
e.g. this Gasteracantha sp.
2) First photographic records of already described (but obviously relatively uncommon or cryptic) species
e.g. this wasp fly.
If the male and female of a species are sexually dimorphic, then both are valid to be added to the project. So too if a species has distinct life stages (eg caterpillar/chrysalis/butterfly), they are all valid to be separately added to the project (assuming the other rules apply).
Please only add observations depicting live organisms; this therefore excludes specimens such as pinned insects.
If you see an observation currently in the project that you know is not the first photograph of that species, and you can show the earlier photograph, please do not hesitate to message me and I'll remove it.
I think that the previous poster's point is that historical photographs are not in-scope to be added to this project: for example, this project will never include the first known photo of a living platypus (or a living cat, as noted), because such photos existed before this project began. The project collects photos posted to iNaturalist that meet the specified criteria.
It's a cool collection of modern observations of rare or remote species! But the title could also describe an entirely different research project, focused on historical media rather than modern exploration. That could also be very cool.
> ...historical photographs are not in-scope to be added to this project... because such photos existed before this project began.
That contradicts what the website itself says:
> This project is designed to showcase the first known photographs of living specimens of any species. Note that by 'first known' I'm referring to the first known photographs of a species anywhere, not just the first photographs to be submitted to iNaturalist.
> If you see an observation currently in the project that you know is not the first photograph of that species, and you can show the earlier photograph, please do not hesitate to message me and I'll remove it.
Both statements are in fact correct and non-contradictory. It's confusing, but I believe what they mean in the guidelines is that there are two criteria
- The photos must be on iNaturalist
- The photo must be the first photo of the species ever, not just the first photo on iNaturalist
That is, if a species was ever photographed anywhere before, outside of iNaturalist, that species can't be part of the project, ever.
Well his idea was that the laws of physics actually change depending on the distance from the galactic center. Far enough out, information can be transferred faster than the speed of light. Too close and life stops working. Which honestly seems much more fun than gravity slowing things down a bit.
Marketing for this was on point or I fell into the exact set of channels they were using because it seemed like I was coming across an update every few months that kept it at a base level of consciousness yet not overwhelming.
I guess I fall into perfect demographic, aging gamer developer with interest in Rust, casual games, and generative content.
Congrats to the team for such a great job and great success!
I can import into SQL Server but there's too much ceremony needed (column types, etc) for quick looks at data I'm going to answer a question about and then discard. After a quick look at TextQuery I'm running into the same issues (although TextQuery is just a couple of clicks instead of 5+). I was also seeing an error yesterday from associating XLSX files with TextQuery but that seems to have gone away today.
reply