Post by RapTor_X_ on Jun 19, 2015 23:37:08 GMT
The database for racing tracks in GTA Online (PC platform) can be found in this Google Spreadsheet
Filtering:
If you want to use filters, e.g. to show only tracks with hairpins, you have to click on Data -> Filter views -> Create new temporary filter view. Then you can use the little arrows in the top cell of each column.
I have created two filter views for short laps and long laps already. If you would like your filter to show up in this list, please describe here in the forums how you have created it or you have to get write access to the spreadsheet.
Submit a new track:
Before submitting a track, please read the definition of each column in the following spoiler, since I want this database to be as consistent and accurate as possible. If you are not sure where the border between two values is, please check the database for a similar track and sort your track in accordingly.
Definitions:
Please use the following format to submit a track:
Every cell must be filled. Make sure to read and understand the column definitions listed above in the spoiler. Since I use data validation in the spreadsheet, make sure you don't have any spelling mistakes in your submission. "Avai." instead of "Avail." will lead to an input error. "Yes " (with a blank) instead of "Yes" is also bad input. Unfortunately links will be lost while copy-pasting into the spreadsheet. Provide them anyway, so I won't have to look them up. No link to original author is required, since a cell can only hold one link.
Criteria a track must meet to be suitable for the database:
Write Access:
At the moment the spreadsheet is only writeable for me. I can give out write access via Google Accounts. Tell me your personal Google Account via private forum message, then I can add you as a person with write access. You can setup a new Google Account, if you don't want to compromise your privacy by exposing your real name or your regular email address to me. Just please make sure not to choose a weak password.
Some criteria you should meet before receiving write access:
Problems:
Most information you can find on the SC page of the track like length, available car classes, areas. For other information like influence of props, is there a chicane or a hairpin, you have to race the track at least once while focusing on these categories. To fill the lap time column, you have to get a clean, fast lap in a super car. On long difficult tracks this might take some time. Question yourself, how many laps you would need to confirm that you can go under 5 minutes on The North Loop, if you haven't raced this track before? So especially with this column help is needed to fill out the track database.
Original Post with the idea:
Filtering:
If you want to use filters, e.g. to show only tracks with hairpins, you have to click on Data -> Filter views -> Create new temporary filter view. Then you can use the little arrows in the top cell of each column.
I have created two filter views for short laps and long laps already. If you would like your filter to show up in this list, please describe here in the forums how you have created it or you have to get write access to the spreadsheet.
Submit a new track:
Before submitting a track, please read the definition of each column in the following spoiler, since I want this database to be as consistent and accurate as possible. If you are not sure where the border between two values is, please check the database for a similar track and sort your track in accordingly.
Definitions:
- Title: Exact name of the track on Social Club. E.g. don't miss any "The" in the front. Link goes to track on Social Club (PC Version only!)
- Creator: Exact name of the creator on Social Club. Link goes to NoDo Forum member page, if creator is active forum user, otherwise link goes to creator's Social Club page. Post original creator in brackets behind the creator. A cell can only have one link.
- Type: Must be one of: Standard, Rally, Kart, Drag, Off-road - Standard is a normal race track with mostly tarmac streets. Rally has at least mixed (tarmac and dirt) roads or dirt only, but keeps the track mostly on roads. Kart is a very tight and mostly short track suitable for karting. Drag is just a long straight without any brake points. On Off-road tracks drivers will be forced to leave roads, climb hills and go over meadows and fields.
- Players: Maximum number of participating drivers (e.g. 30)
- km: Track length in kilometers as mentioned on the Social Club page of the track
- mi: Track length in miles (will be automatically determined by dividing km by 1.609344). If your local settings do show track lengths in miles, please multiply by 1.609344 and put the result in the km column. The only way I was able to fill the other column automatically in both direction lead to a crossreference warning in every involved, unfilled cell which does not look pretty
- Lap time: Lap time in Supers to expect in NoDo pace in 30 seconds intervals. Always use the higher value, if it's close. So Cutting Coroners GP gets 1:30, despite Broughy is short of the 1 minute barrier with the T20. If the world record in Supers is 3:59 min, then the database should show 4:30 min regardless, since only very few players will get under 4:00. It's more of an average lap time to expect for endurance races.
- Pit lane: Must be None, Limited or Full - None: There is not pit lane. Limited: There is a pit lane, but it is not really suitable for races with mandatory pit stops, since it has only 3 health items or is too short, so drivers might have to wait on the track. Los Santos Grand Prix is good example for a limited pit lane. Full: Pit lane is available and suitable for races with many drivers and mandatory pit stops.
- Car classes: Car classes you can use on this track. Depending on length either list them or use "All but ..." and name the classes that are excluded.
- Areas: List of areas which the track covers in order of time spend in this area during a lap. LSIA, Fort Zancudo, Sandy Shores Airfield, Flat LS, Hilly LS, Highlands, Vinewood Hills, Grapeseed, Sandy Shores, Desert, Paleto Bay, Highway, Harbor, Off-road
- LSIA: Los Santos International Airport - Lots of space, no curbs, wide roads, creative prop placement
- Fort Zancudo: Combine the space of a landing strip with cornering around buildings
- Sandy Shores Airfield: An airstrip surrounded by dust and sand
- Flat LS: The City of Los Santos. Mainly the southern part with train tracks next to the street. You rarely get airborne here. It's more about curb hunting and pole avoiding.
- Hilly LS: City streets going up and down the hills of the northern part of Los Santos. Braking into corners is more difficult here than in Flat LS.
- Highlands: Free flowing corners through the hills of Banham Canyon, Tongva Hills, Tongva Valley, Great Chaparral, the Galileo Observatorium and the Vinewood Sign. Also fitting in here is the El Burro Blvd. in the Palomino Highlands
- Vinewood Hills: The narrow and winding streets of Vinewood Hills, where overtaking cleanly is nearly impossible.
- Grapeseed: Free flowing corners around some farms
- Sandy Shores: The village south of Alamo Sea. You can usually find barriers in the bushes around here.
- Paleto Bay: The village in the north, where you can hit endless hydrants
- Desert: Eastern part of Route 68 and the tarmac roads north of it outside of Sandy Shores
- Highway: Long straights, wide roads
- Harbor: The container area in the south-east of the map
- Off-road: every area with no tarmac roads, Davis Quartz, all dirt roads in the hills and canyons
- Intersections: Must be None, Shared, Crossovers or Both - None: Track has no shared sections and no crossovers. Shared: Track has a shared section, where cars use the same street on different parts of the lap, but go in the same direction. Crossover: Two parts of the lap cross over at one point of the track, so crashes are likely.
- Joker lap: Yes or No. Does the track have a Joker Lap for Rallycross events?
- Off-road: Must be None, Rare, Mixed or Full - Off-road is defined here as non-tarmac section, so it can be a dirt road. None: Track does not include off-road parts. Rare: Track has small dirt sections where all four wheels go off-road on ideal racing line. (Example: The North Loop with cutting many corners through dirt) Mixed: Track has a mixture of tarmac and dirt roads. Should include at least one brake point and corner on dirt. Full: Besides crossing tarmac roads the whole track is using dirt roads or off-road terrain.
- Props: Must be None, Minor, Medium, Major or Full - indicates to which degree the flow of the track is created by setting props. The amount of total props used is irrelevant here. None: Props do not influence the racing line. They are used only to block non-used roads or as decoration and have no influence on corner lines. Minor: Lamp posts are blocked off. Barriers prevent the cutting of corners. Medium: Props are used to create Hairpins, separate wide roads into two parts, artificial chicanes are created, racing lines around corners are changed by prop placement (more than blocking lamp posts and preventing cutting). Major: same as medium, but the track design is heavily dependent on the prop placement and a major part of the track consists of props instead of cornering through objects which are always there. (e.g. most airstrip tracks) Full: every corner is defined by props (e.g. karting on a parking lot)
- Curbs: Avail. or N/A: Curb boosting is available or not available on this track. It should be set to available, if curb boosting significantly improves your lap time. If can find a single curb boost with just a tiny impact, set this value to N/A.
- Hairpins: Yes or No. A hairpin is defined as a tight corner where drivers have to turn at least 135 degrees. Further a yes requires that at least two drivers can approach a hairpin next to each other and can overtake by different braking points and racing lines. So tight corners with entries limited by props or exit lines through the previous corner in a way that only one line through this corner is reasonable, are not classified as hairpins here.
- Chicanes: Yes or No. A chicane is a combination of two combined corners of alternating direction. If you can go through these two corners in a straight line in a race, it should not be defined as a chicane. If the two corners are separated too much, so there are two separate brakepoints, it should also not be defined as a chicane. A chicane can be full-speed, but it should not be easy to go through it. You can't usually go cleanly through a chicane with two cars next to each other.
Please use the following format to submit a track:
| Title | Creator | Type | Players | km | mi | Lap time | Pit lane | Car classes | Areas | Intersections | Joker lap | Off-road | Props | Curbs | Hairpins | Chicanes |
| Los Santos Grand Prix | Broughy1322 | Standard | 30 | 4.49 | 2.79 | 02:00 | Limited | All | Flat LS, Hilly LS | None | No | None | Medium | Avail. | Yes | No |
Every cell must be filled. Make sure to read and understand the column definitions listed above in the spoiler. Since I use data validation in the spreadsheet, make sure you don't have any spelling mistakes in your submission. "Avai." instead of "Avail." will lead to an input error. "Yes " (with a blank) instead of "Yes" is also bad input. Unfortunately links will be lost while copy-pasting into the spreadsheet. Provide them anyway, so I won't have to look them up. No link to original author is required, since a cell can only hold one link.
Criteria a track must meet to be suitable for the database:
- It must allow serious racing. So no loopings, unnecessary jumps, bad checkpoint placement, climbing challenges, etc.
- It must be seen as complete and finished by the track creator. So no beta, alpha or testing versions of tracks where the creator still asks for feedback and makes changes to his track.
- It must be available for the PC platform.
Write Access:
At the moment the spreadsheet is only writeable for me. I can give out write access via Google Accounts. Tell me your personal Google Account via private forum message, then I can add you as a person with write access. You can setup a new Google Account, if you don't want to compromise your privacy by exposing your real name or your regular email address to me. Just please make sure not to choose a weak password.
Some criteria you should meet before receiving write access:
- You should be experienced with using spreadsheets with filters, formulas and data validation. I just don't want to clean up your mess, if you don't know what you are doing.
- I should know you from racing in daily playlists or events. Since this database is about PC tracks only, console-only players don't need write access in my opinion.
- You have already committed at least 3 tracks via a forum post, so I can see that your understanding of the column definitions is accurate.
Problems:
Most information you can find on the SC page of the track like length, available car classes, areas. For other information like influence of props, is there a chicane or a hairpin, you have to race the track at least once while focusing on these categories. To fill the lap time column, you have to get a clean, fast lap in a super car. On long difficult tracks this might take some time. Question yourself, how many laps you would need to confirm that you can go under 5 minutes on The North Loop, if you haven't raced this track before? So especially with this column help is needed to fill out the track database.
Original Post with the idea:
Hey everyone!
I am thinking about a database of race tracks which should make it easier to find tracks for playlists, your racing preferences or whatever.
I'm currently thinking about the columns of the spreadsheet I will later put on Google Docs for everyone.
Before starting typing all the data, I would like to hear your comments about my initial thoughts on the colums:
This is pretty much everything I came up with in a brainstorming session.
Is something missing? What is useless so we don't need keep track of it.
In the end I imagine a sortable spreadsheet with filter options and about 200 race tracks we race regularly on NoDo.
Of course this might also be interesting for the console versions, but that should be separate databases since track URLs, creators and availabilities and possibly even layouts of the tracks differ.
I'm looking forward for your input
I am thinking about a database of race tracks which should make it easier to find tracks for playlists, your racing preferences or whatever.
I'm currently thinking about the columns of the spreadsheet I will later put on Google Docs for everyone.
Before starting typing all the data, I would like to hear your comments about my initial thoughts on the colums:
- Title: Obvious... the name of the track, e.g. The North Loop
- Link: URL to the RSC entry to add it to the game
- Creator: The creator of the track: Is a link to the forum profile or RSC account more useful for potential feedback
- Players: Maximum number of participants, e.g. 30
- Length: Track length in kilometers
- Lap time: Lap time for fully upgraded supers (or fastest available verhicle) in 30 seconds steps, e.g. 5:00 for The North Loop. This should not be the world record or something. More of a good lap time with the fastest car.
- Car classes: Available car classes on this track. e.g. All / Sports, Off-roads, Classics - We can think about recommandations in brackets like for Finish Circuit: All (Muscle, SUVs, Sedans)
- Pit lane: Yes/No - tracks with pit lanes can be raced in GTA mode to be able to repair your vehicle or have mandatory pit stops
- Type: Normal Race, Rallye, Karting, Off-road
- Areas: I would like to separate San Andreas to different areas which have a different feel for racing. The spreadsheet would contain all areas the track covers ordered by portion of the track. Did I miss something? Would you group some together or separate another area? Full list of areas:
- Harbour: the container terminals
- Landing strips: LS International Airport, Sandy Shores Airfield, Fort Zancudo
- Flat LS: the flat part of Los Santos, e.g. where you can cross the train tracks
- Hilly LS: the hilly part of Los Santos where goint full speed will lead to airtime
- Grapeseed: more free flowing corners
- Sandy Shores: with its 90 degree corners everywhere
- Paleto Bay: with all its hydrants...
- Desert: every other asphalt road in blaine county,
- Highway: wide roads, fast corners, no curbs or lamp posts
- Off-road: every area with no asphalt, Davis Quarts, all sand roads in the hills and canyons...
- Highlands: the wider roads in the hills, e.g. North Loop is completely in this area
- Vinewood Hills: the very tight roads in the hills, where overtaking is nearly impossible without crashing
- Grid layout: Wide, Long, Tight
- Off-road: proportion of the track which does not use asphalt roads, Scale from 0 to 10, where Cutting Corners GP = 0, Northloop = 1, Grand Senora Rally Ring = 8, Flintstone Springfield = 10
- Props: Scale from 0 to 10 where 0 means that no props influence the racing line and 10 means the racing line is completely created by props like the kart track on the Del Perro Pier parking lot. Should indicate if roads or corners are made tighter by probs or track contains more corners through prop setting.
- Curb usage: N/A, Available, Blocked - Curb boosts are not really available (e.g. Blaine County 24 hours), are available and are used regularly (e.g. Los Santos GP), are available but blocked mainly by props (think about many of Shaggy's tracks where all curbs are blocked to avoid usage of curb boosting)
- Hairpins: Amount of hairpins or Yes/No - What do you think?
- Chicanes: Amount of chicanes or Yes/No - What do you think?
- Crossovers: Yes/No - Crossovers in the track design, may cause crashes
- Shared sections: Yes/No - e.g. North Loop has a shared section but not a crossover
- Airtime: How much does airtime influence the lap time? None, Some, Much - Some are just simple hills, where much indicates tricky sections where angle and brake point are important for speed carry and not flying off the track
This is pretty much everything I came up with in a brainstorming session.
Is something missing? What is useless so we don't need keep track of it.
In the end I imagine a sortable spreadsheet with filter options and about 200 race tracks we race regularly on NoDo.
Of course this might also be interesting for the console versions, but that should be separate databases since track URLs, creators and availabilities and possibly even layouts of the tracks differ.
I'm looking forward for your input
