FortWiki Database Project - Data Definition: Difference between revisions

From FortWiki
Jump to navigation Jump to search
← Older editNewer edit →
John Stanton (talk | contribs)
interwiki
130,496 edits
No edit summary
John Stanton (talk | contribs)
interwiki
130,496 edits
No edit summary
Line 3: Line 3:
This page is under construction
This page is under construction


{| class="wikitable" width="800px"
{| class="wikitable sortable" width="800px"
|+ Data Elements
|+ Data Elements
|-
|-
Line 9: Line 9:
! Format
! Format
! Definition
! Definition
! Table
! Field
! Type
! Type
! Length
! Length
|-
|-
| FWID || sscccnnnn || FortWiki ID || Alpha Numeric || 9 Char
| Country || aaa || Country Abbreviation || ft || country || Alpha || 3 Char
|-
|-
| FWID - State || ss------- || State Abbreviation || Alpha || 2 Char
| State || aa || State Abbreviation || ft || state || Alpha || 2 Char
|-
|-
| FWID - County || --ccc---- || FIPS County Code || Numeric || 3 Char
| County || nnnn || County Code || ft || county || Numeric || 4 Char
|-
|-
| FWID - Sequence || -----nnnn || Acquisition Number || Numeric || 4 Char
| Sequence || nnnnnnn || Acquisition Number || ft || sequence || Numeric || 7 Char
|-
| Name || aaaaa... || Fort Name || ft || name || Alpha || ~255
|-
| See || aaaaa... || Primary Fort Acquisition Number || ft || see || Numeric || 7 Char
 
|}
|}
{{PageFooter}}
{{PageFooter}}

Revision as of 10:37, 25 February 2015

This page is under construction

Data Elements
Name Format Definition Table Field Type Length
Country aaa Country Abbreviation ft country Alpha 3 Char
State aa State Abbreviation ft state Alpha 2 Char
County nnnn County Code ft county Numeric 4 Char
Sequence nnnnnnn Acquisition Number ft sequence Numeric 7 Char
Name aaaaa... Fort Name ft name Alpha ~255
See aaaaa... Primary Fort Acquisition Number ft see Numeric 7 Char
Retrieved from "https://fortwiki.com/index.php?title=FortWiki_Database_Project_-_Data_Definition&oldid=90283"