Logon | Search | Help

Home | Directory | Clubs | Fields | Links

How to add a field to the databasePrintable

Only an Administrator or League Officers can add a Playing Field to the database.

If you know of a field that is missing, please:

  1. Determine the name(s) of the field. Both the 'official' name and common nicknames are needed.

  2. Determine the street address of the field including zip code (this could be also the intersection of two roads.)

  3. Determine anything special regarding the field. (For example Stadium Field in San Carlos is NOT visible from the street)

  4. Determine if the field is grass or synthetic turf.

  5. Determine how many fields are at this location.

    A full size field that is also used cross wise for 2 8v8 fields would be 3 fields. Example:Mayfield North, Mayfield NE and Mayfield NW

  6. Send all the information to the Webmaster.

Example: Location = College Preparatory High School;
Fields = Stadium Field, Practice Field;
Address = 123 Main Street, MyFavoriteHomeTown, CA 90000;
Surface = Stadium Field is Turf. Practice Field is Grass;
Notes = No food or non-water drinks allowed on the Stadium Field. No dogs allowed on the school campus. Please park in the student parking lot on the northeast corner of the campus. Field closure hotline is 888-555-1212

Instructions to the Administrator / League Officer

There are three data tables involved in adding a Field. They are called 'Locations' and 'Fields' and 'Areas'

  1. Will this field be shared with Pensra or other RidgeStar databases?

    If Yes, the first step is to go to and register the Location and the Field(s) with RidgeStar. Go to the Location segment. For the Field you will go to the Facility segment.
    When you register a Field note the RidgeStar Field Number, (RFN)

  2. Enter the Location, Field and Area in the Redwood or CCSLCoast or Pensra database.

    The Locations Table contains the street address. It is usually the more complete name. An example is the 'Morgan Hill Complex'. A Location can have multiple Fields. As part of the Locations Table entry, after you have entered the address, click on GeoCode to determine the Latitude and Longitude. Then click on Update.

    Each Fields table entry includes the type of surface: Grass or Turf. (Turf refers to synthetic turf.) Use LeagueOfficer:Manage-Locations and LeagueOfficer:Manage-Fields to add or edit field information. A Locations entry must be present before making a Fields entry for a field not currently in the database. Include the RFN in the Fields Table.

    After you have added the Location you should make an entry in the Areas table. Do so via Manage-Areas. Areas are geographical areas that referees may be interested in working. For example San Francisco Area or Southern San Mateo County or the Coast..

Why have Locations and Fields? Primarily for the convenience of Referee scheduling. If a Referee is interested in working a Match at Sea Cloud Park, they can search for Matches with Location = 'Sea Cloud Park' and they will see all the Matches on Field= Sea Cloud #1, Sea Cloud #3, Sea Cloud #4, etc.

LeagueOfficers should be careful about making major changes to the Fields or Locations Tables. Matches and MatchResults point to specific fields. If you edit a field, say change the field name, all the past references to the old field will now reference the new field. This could lead to massive confusion

Last Updated 9/10/2011