Look into establishing residency in whatever state you pick. That cuts down your college tuition costs. Then stay in that state after transferring to a 4-year university.
If you transferred from a NY community college to a university in California, you would be an out-of-state student in California. Your tuition would be over $35,000 per year, plus your cost of living. There is very, very little financial aid for out-of-state transfer students in California. Can your family afford such high costs?