Skip Navigation U.S. Department of Health and Human Services www.hhs.gov
Agency for Healthcare Research Quality www.ahrq.gov
Archive print banner

Emergency Preparedness Resource Inventory (EPRI)

This information is for reference purposes only. It was current when produced and may now be outdated. Archive material is no longer maintained, and some links may not work. Persons with disabilities having difficulty accessing this information should contact us at: https://info.ahrq.gov. Let us know the nature of the problem, the Web address of what you want, and your contact information.

Please go to www.ahrq.gov for current information.

Table 3. The structure of Tables in the SQL Database Containing Imported Geographic Information

Table Name Column Name Data Type Comment
City id Integer (4 bytes) Primary Key
Name Character (50 bytes) This name will appear in EPRI drop down lists
Population Integer (4 bytes) Not currently used
SquareMiles Float (8 bytes) Not currently used
Latitude Float (8 bytes) Must be in decimal degrees (e.g., 40.807142). A city's latitude and longitude is used in EPRI reports that show where resources are located within a specified distance of a city.
Longitude Float (8 bytes) Must be in decimal degrees (e.g., -71.451875)
County id Integer (4 bytes) Primary Key
Name Character (50 bytes) This name will appear in EPRI drop down lists
Code Character (10 bytes) The two digit State FIPS code followed by the three digit county FIPS code (e.g., "42080").1 This code is required to implement EPRI's mapping feature (Section 3.5).
Stateid Integer (4 bytes) A link to the id field in the States table. Populate the State table first in order to get the value for the Stateid field.
Population Integer (4 bytes) Used to compute per-capita calculations in county-based reports
SquareMiles Float (8 bytes) Not currently used
Latitude Float (8 bytes) Not currently used
Longitude Float (8 bytes) Not currently used
Minx Float (8 bytes) Filled in automatically by EPRI
Maxx Float (8 bytes) Filled in automatically by EPRI
Miny Float (8 bytes) Filled in automatically by EPRI
Maxy Float (8 bytes) Filled in automatically by EPRI
State id Integer (4 bytes) Primary Key
Name Character (50 bytes) This name will appear in EPRI drop down lists
Zip Code code Character (10 bytes) Primary Key; name will appear in EPRI drop down lists
Population Integer (4 bytes) Not currently used
SquareMiles Float (8 bytes) Not currently used
Latitude Float (8 bytes) Must be in decimal degrees. By default, a location's latitude and longitude (Section 4.2) is set equal to the latitude and longitude of the ZIP code assigned to the location.
Longitude Float (8 bytes) Must be in decimal degrees

1. A list of FIPS codes, by county, is at http://www.itl.nist.gov/fipspubs/co-codes/states.htm.

Return to Document

The information on this page is archived and provided for reference purposes only.

 

AHRQ Advancing Excellence in Health Care