Data formats
The nonproprietary file format used depends on the type of data set. Some data sets require multiple files in different formats to completely transfer the information. Most data sets are provided in Digital Line Graph (DLG) Version 3, Optional format. Generally, line or polygon attribute tables that could be stored entirely in integer codes were included as major/minor codes in DLG files. The noninteger attributes for many of the DLG-format files are stored in related dBASE®-format files and may be joined to the data set polygon attribute or arc attribute tables using dBASE-compatible software. The dBASE-format files include fields that may be linked to the DLG major/minor codes for each feature. Point attribute tables are provided in dBASE format only, and include the X and Y map coordinates of each point. Annotation (text plotted in map coordinates) are provided in AutoCADTM Drawing Exchange format (DXF) files. The shaded-relief image is provided in Tagged Image File Format (TIFF), format, a binary image format commonly used in desktop publishing. The TIFF-format file uses the packbit compression algorithm. The shaded-relief image is stored in the "\DATA_ARC\A_SHDRLF\" subdirectory, and consists of two files: SHDRLF.TIF, the image file, and SHDRLF.TFW, the ARC/INFO world file.
All data sets except the shaded-relief image also are provided in ARC/INFO export-file format. All DLG-format files and ARC/INFO export-format files are compressed with GZIP and are stored in subdirectories of the \DATA_PD\ and \DATA_ARC\ directories. The DBASE-format and DXF-format files are not compressed on this disc.
The DLG format and ARC/INFO export files end with ".GZ" extensions and need to be uncompressed to access the digital data. The file "\GZIP\GUNZIP.EXE" is an MS-DOS executable program included on the disc that will uncompress the data files. To uncompress a file, type "GUNZIP -aN" and the file name. This will uncompress the file and restore its original name. For example:
GUNZIP -aN CENSUS.GZ
The text files on this disc are ASCII format files. The files use MS-DOS record delimiters (carriage return, line feed) to indicate the end of lines. Conversion of record delimiters in these ASCII files may be necessary for use with operating systems other than MS-DOS. A utility such as DOS2UNIX, the FTP file transfer utility, or a text editor may be used to convert the record delimiters. UNIX users may use the following perl script to convert the record delimiters:
#!/usr/bin/perl -pi.dosbak
s/\r\n$/\n/;
The table below lists the files included for each data set. If no attribute data file is listed, all attributes are included within the geographic coordinate file.
-----------------------------------------------------------------------
Organization of data sets and related files on the Transfer formats disc.
----------------------------------------------------------------------
-A_README.1ST - Information about data sets and file structure
-A_NOTICE.TXT - Liability disclaimer
-----\DATA_ARC\- This subdirectory contains data sets in
ARC/INFO export-file format except where noted
---\A_SHDRLF\ (statewide)
SHDRLF Shaded-Relief image (TIFF format)
---\A_STATE\ (statewide)
ADMINBD Administrative boundaries
COUNTY County boundaries
LATITUD One degree lines of latitude
LONGITU One degree lines of longitude
OKNAMES Geographic names statewide
QUAD100 Index of USGS 1:100,000-scale
quadrangles
QUAD250 Index of USGS 1:250,000-scale
quadrangles
STHOUSE Oklahoma State House of Representatives
district boundaries
STSENAT Oklahoma State Senate district boundaries
USCONGR 104th U.S. Congressional district boundaries
USGSSIT Locations of USGS stream gages
and weather stations
WATRSHD Watershed boundaries and codes
WEATHER Locations of weather station
---\ADAIR\ (Data sets for Adair County. Similar directories
exist for all 77 counties, each contains
the same type of data sets. See the following
table for a listing of county names and
directories.)
BIGTXT Cities and major highway text
TINYTXT Major road and highway names
CENSUS Block group boundaries and selected
demographic data
ELEVCON Land surface elevation contours
ELEVPTS Land surface elevation points
NAMES Geographic names by county
QUAD24 Index of USGS 1:24,000-scale
quadrangles
ROADS Highways, streets, and address
locations
SCHDIST School district boundaries
STREAMS Streams, rivers, and lakes
TNRGSEC Public land survey system
---\DATA_PD\- This subdirectory contains the data sets in generic
DLG-, DXF-, and DBF-format files. Except for the
\A_SHDRLF\ subdirectory, this directory mirrors
the \DATA_ARC\ subdirectory in file contents and
organization. The \A_SHDRLF\ subdirectory is not
included because the TIFF-format file provided in the
\DATA_ARC\A_SHDRLF\ subdirectory is suitable for use
with most GIS software.
---\DOCUMENT\-
-\OVERVIEW.TXT Brief description of all data sets and
attributes
---\FGDC\ Complete FGDC Metadata files for each
data layer
---\GZIP\- This subdirectory contains MS-DOS executables
and related files for the GZIP package, that
are needed to uncompress the files that have a
".GZ" extension
----------------------------------------------------------------------Oklahoma counties and shortened file names. -------------------------------------------------------------------------
On the Tranfer formats disc, short names are used as the subdirectory name under the \DATA_ARC\ and \DATA_PD\ directories.
County name Short name County name Short name ------------------------ ------------------------ ADAIR ADAIR LE FLORE LEFLORE ALFALFA ALFALFA LINCOLN LINCOLN ATOKA ATOKA LOGAN LOGAN BEAVER BEAVER LOVE LOVE BECKHAM BECKHAM MAJOR MAJOR BLAINE BLAINE MARSHALL MARSHALL BRYAN BRYAN MAYES MAYES CADDO CADDO MCCLAIN MCCLAIN CANADIAN CANADIAN MCCURTAIN MCCURTAI CARTER CARTER MCINTOSH MCINTOSH CHEROKEE CHEROKEE MURRAY MURRAY CHOCTAW CHOCTAW MUSKOGEE MUSKOGEE CIMARRON CIMARRON NOBLE NOBLE CLEVELAND CLEVELAN NOWATA NOWATA COAL COAL OKFUSKEE OKFUSKEE COMANCHE COMANCHE OKLAHOMA OKLAHOMA COTTON COTTON OKMULGEE OKMULGEE CRAIG CRAIG OSAGE OSAGE CREEK CREEK OTTAWA OTTAWA CUSTER CUSTER PAWNEE PAWNEE DELAWARE DELAWARE PAYNE PAYNE DEWEY DEWEY PITTSBURG PITTSBUR ELLIS ELLIS PONTOTOC PONTOTOC GARFIELD GARFIELD POTTAWATOMIE POTTAWAT GARVIN GARVIN PUSHMATAHA PUSHMATA GRADY GRADY ROGER MILLS ROGERMIL GRANT GRANT ROGERS ROGERS GREER GREER SEMINOLE SEMINOLE HARMON HARMON SEQUOYAH SEQUOYAH HARPER HARPER STEPHENS STEPHENS HASKELL HASKELL TEXAS TEXAS HUGHES HUGHES TILLMAN TILLMAN JACKSON JACKSON TULSA TULSA JEFFERSON JEFFERSO WAGONER WAGONER JOHNSTON JOHNSTON WASHINGTON WASHINGT KAY KAY WASHITA WASHITA KINGFISHER KINGFISH WOODS WOODS KIOWA KIOWA WOODWARD WOODWARD LATIMER LATIMER ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ Transfer files included for each data set in the \DATA_PD\ directory on the Tranfer format disc.-----------------------------------------------------------------------------
GEOGRAPHIC ATTRIBUTE RELATED FIELDS DATA SET COORDINATES FILE DATA FILE DLG ---> DBF ------------------------------------------------------------------------------ Data sets stored in each county subdirectory BIGTXT BIGTXT.DXF CENSUS CENSUS.GZ* CENSUS.DBF MAJOR1 CENSUS_ MINOR1 CENSUS_ID ELEVCON ELEVCON.GZ* ELEVPTS ELEVPTS.DBF NAMES NAMES.DBF QUAD24 QUAD24.GZ* QUAD24.DBF MAJOR1 QUAD24_ MINOR1 QUAD24_ID ROADS ROADS.GZ* ROADS.DBF MAJOR1 TLID (1st 5 col) MINOR1 TLID (2nd 5 col) ROADADD.DBF(addresses) TLID** ROADS_ID SCHDIST SCHDIST.GZ* SCHDIST.DBF MAJOR1 SCHDIST_ MINOR1 SCHDIST_ID STREAMS STREAMS.GZ* TINYTXT TINYTXT.DXF TNRGSEC TNRGSEC.GZ* Data sets stored in the A_STATE subdirectory ADMINBD ADMINBD.GZ* ADMINBD.DBF MAJOR1 ADMINBD_ MINOR1 ADMINBD_ID COUNTY COUNTY.GZ* COUNTY.DBF MAJOR1 COUNTY_ MINOR1 COUNTY_ID LATITUD LATITUD.GZ* LONGITU LONGITU.GZ* OKNAMES OKNAMES.DBF QUAD100 QUAD100.GZ* QUAD100.DBF MAJOR1 QUAD100_ MINOR1 QUAD100_ID QUAD250 QUAD250.GZ* QUAD250.DBF MAJOR1 QUAD250_ MINOR1 QUAD250_ID STHOUSE STHOUSE.GZ* STHOUSE.DBF MAJOR1 STHOUSE_ MINOR1 STHOUSE_ID STSENAT STSENAT.GZ* STSENAT.DBF MAJOR1 STSENAT_ MINOR1 STSENAT_ID USCONGR USCONGR.GZ* USCONGR.DBF MAJOR1 USCONGR_ MINOR1 USCONGR_ID USGSSIT USGSSIT.DBF WATRSHD WATRSHD.GZ* WEATHER WEATHER.DBF * Indicates a GZIP-compressed DLG file ** TLID must be reconstructed by combining MAJOR1 and MINOR1. For example TLID = (MAJOR1 * 100000) + MINOR1 --------------------------------------------------------------------------