I have a HDR-AS100V and it can be used. It can take pictures down to one every 1 sec, but as @ligfietser writes the resolution is only HD video, ie. around 2 mega pixels. That is useable - I have uploaded around 200k photos from that camera, but for future use more mega pixels are better. Usually I would not say that, but 2 mp is very low.
I just got a Garmin Virb Elite, which can do 16 mega pixels every 2 seconds, but it can also do the time lapse videos with the low resolution down to 0.5 seconds. Or just video, which you can feed Mapillary.
The Virb is larger, but the buttons are nicer and it has a little preview screen. I would go for the Virb over any of the Sonys, now I have tried both!
Note that Virb has their own mounts and there is no tripod mount in the box.