Reference no: EM131431740
Create a spatial database (in an Excel spreadsheet) containing typical business information. The first row of the file must be a header row with descriptive titles. The source of this file can be anything that is real. For example, use a list of government offices (e.g., office for tourism, military recruiters, or the IRS) for cities or counties.
Or use locations of fast food restaurants, U.S. post offices, retail stores, or malls. It is highly recommended that you do not target an area larger than a county for your database entries. For example, your database could contain all of the fast food restaurants in Adams County, North Dakota.
Mix up the type of entities to be included. For example, if the file will be a list of fast food restaurants, include in the list several competing brands. If retail stores are chosen, use several different store chains. If government offices are to be used, use several types of government offices, such as tourism offices, post offices, jails, or municipal yards.
Include the following fields or columns of data
ID = A unique line number or identifier for each line entry. This is required by some software.
Name = First name, last name, or business name. This may be used as a label on a map to identify an entity.
Address = A real street address is required
City = Use the real city name.
State = Use the state name
ZIP Code = Use the five-digit ZIP code, not the Plus 4. Leading zeros may be dropped. For example, 02148 can be shown as 2148
Latitude = Use decimal location (e.g., 40.67)
Longitude = Use decimal location (e.g., 30.32)
Type = A unique code for the type of business. For example, Sears stores can be represented by S, Macy's can be represented by M, and JCPenney can be represented by P.