How would i make a Arduino that get the current gps location and submit to datab

So How would I make an Arduino that get the current GPS location and submit to a MySQL database with cellular data sim card some probably some kind of gsm module

Start by getting acustomed to the Arduino, how to connect and read a GPS and how to connect and access a sim card. One step at the time.

search term: Arduino GPS Datalogger

look in the Project Hub in the COMMUNITY tab above right

start with the examples in the TinyGPS or TinyGPS library, then the SD datalogger in the examples, then learn how to merge them.

Thanks but i cant find anything that tells me how to submit the location with gsm sim card module to mysql

Would i use this in some way is there a documentation for this Arduino SIM — Arduino Official Store

Just wanted to know how I connect a gsm cellular data module to the internet so I can use this library GitHub - ChuckBell/MySQL_Connector_Arduino: Database connector library for using MySQL with your Arduino projects.

You should get an ethernet shield, first, and learn how to connect a GPS, and get data from it.

Then, learn how to get the data of interest from the mass of data available from the GPS.

Then, learn how to write a script, that runs on some server, that takes the data of interest and stores it in a database.

Then, learn how to make a GET request with just that data.

Finally, replace the ethernet shield with the GSM shield, and send the appropriate AT command to the modem, and it will send the same data to the same script on the same server.

Jumping in the deep end and swimming towards the shallow end, while wearing cement shoes, will be nowhere near as easy as paddling around the shallow end barefoot.

1 Like

danilkp12345:
bump

Not so easy, if you want a list of 'how to' instructions it might well be long.

You could try a google search on something like;

Arduino connect a gsm cellular data module to the internet

For some information on how to start.

PaulS:
You should get an ethernet shield, first, and learn how to connect a GPS, and get data from it.

Then, learn how to get the data of interest from the mass of data available from the GPS.

Then, learn how to write a script, that runs on some server, that takes the data of interest and stores it in a database.

Then, learn how to make a GET request with just that data.

Finally, replace the ethernet shield with the GSM shield, and send the appropriate AT command to the modem, and it will send the same data to the same script on the same server.

Jumping in the deep end and swimming towards the shallow end, while wearing cement shoes, will be nowhere near as easy as paddling around the shallow end barefoot.

So I will take it one step at a time but I don't want to buy incompatible parts
I would probably need a
Arduino Uno
And https://store.arduino.cc/usa/arduino-gsm-shield-2-integrated-antenna
But what GPS module would I need that would be really precise
and will the gsm shield and GPS module have a strong antenna to work inside a tractor

EDIT: Oh damn the product is retired so what alternative is there to the gsm shield

Look for a topic some year ago, "Speedometer using GPS". There a NEO-6M was used. I think the sketch showing the handling of the GPS is there. Digital I/O communication was used.
But! It is usually more difficult to understand a foreign sketch than build up Your own knowledge.

What accurazy do You look for? Some 10 meters, 35 feet is what You get.
Inside a tractor? Most likely no problem. I use the speedometer at the drivers position in railroad railcars. Out in the open nature there are no problems but on a narrow road surrounded by trees the GPS has difiiculties.

danilkp12345:
But what GPS module would I need that would be really precise

Can you tell us what 'really precise' is ?

Railroader:
Look for a topic some year ago, "Speedometer using GPS". There a NEO-6M was used. I think the sketch showing the handling of the GPS is there. Digital I/O communication was used.
But! It is usually more difficult to understand a foreign sketch than build up Your own knowledge.

What accurazy do You look for? Some 10 meters, 35 feet is what You get.
Inside a tractor? Most likely no problem. I use the speedometer at the drivers position in railroad railcars. Out in the open nature there are no problems but on a narrow road surrounded by trees the GPS has difiiculties.

properly need way more accuracy I'm gonna be using the GPS location to place a marker on a map and I need to be able to tell when another marker is less than 5 meters away from my GPS location

There are ways to get higher accurazy but that might not be available all over the world and most likely cost money, buying services from ?

Railroader:
There are ways to get higher accurazy but that might not be available all over the world and most likely cost money, buying services from ?

Won't I just need to buy a different GPS module need around 5meter at the maximum inaccuracy

No. As far as I know, there is no GPS that automaticly has the military accurazy like a few feet.

danilkp12345:
Won't I just need to buy a different GPS module need around 5meter at the maximum inaccuracy

Sure, budget for £200+, surveying type GPSs

'Around' is a imprecise as 'really precise'

Okay so I will buy the neo-6m
but what gsm shield can I get since I can't get this

but if I buy the neo-6m will I be able to see a realtime GPS change like the machine it's gonna be on is only moving 25meters in an hour

That GPS updates a several times per second.