I would say there’s a pretty significant difference between something like phone geolocation data, which is not very practical to search, especially for Apple devices, and in any case usually requires at least a superficial level of scrutiny, and a database that any old police officer can just run a query on as and when they feel like it.
Yes, they can, however I don't believe this is quite as straightforward as just looking up the data for a particular vehicle on your police computer. Looking up the ANPR data on a vehicle is only marginally more complex than looking up a person's driving license details or similar. My understanding is that in order to do a reverse geofence request, or look up a specific device, it's a lot more complicated, and these days you're only going to get cell site information rather than precise GPS data (as was possible by asking Google in the past).
With the very welcome changes to how Google stores location history, they will no longer be capable of answering geofence warrants. The cell carrier themselves (Verizon / T-Mobile / BT / Orange etc) can still provide some tower logon information but I'm not sure if they are storing E911 GPS info.