FortWiki Database Project - Data Definition

This page is under construction Data Elements Name Format Definition Table Field Type Length Sequence nnnnnnn Acquisition Number ft sequence Numeric 7 Char Country nnn 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 Name aaaaa... Fort Name ft name Alpha ~255 See nnnnnnn Primary Fort Acquisition Number ft see Numeric 7 Char Data Elements (edit list) Name Table Format Definition Type Length Notes Acquisition No Fortification nnnnnn Acquisition Number Numeric 6 Char State Fortification aa Present Day State Abbreviation Alpha 2 Char County Fortification nnn Present Day County Code Numeric 4 Char Name Fortification aaaaa... Fortification Name Alpha ~255 Char See Fortification nnnnnnn Primary Fort Acquisition Number Numeric 7 Char Type Fortification aaaaa... Type of Fortification Alpha ~255 Char From List PLat GPS aaaaaaaaaaaa Latitude Alpha 12 Char PLon GPS aaaaaaaaaaaa Longitude Alpha 12 Char GNISID Fortification nnnnnnn GNIS ID Number Alpha 7 Char Sequence GPS nnnnnnn Acquisition Number Numeric 7 Char Lat GPS aaaaaaaaaaaa Latitude Alpha 12 Char Lon GPS aaaaaaaaaaaa Longitude Alpha 12 Char Type GPS aaaaa... Description Alpha ~255 Char Key Type nnnnn Type Table Key Int Int Name Type aaaaa... Type Table Name Alpha ~255 Char Key Country nnnnn Country Table Key Int Int Name Country aaaaa... Country Table Name Alpha ~255 Char Abbr Country aaa Country Table Name Alpha 3 Char Sequence Timeline nnnnnnn Acquisition Number Numeric 7 Char Year Timeline aaaa Year Alpha 4 Char Month Timeline aaa Month Alpha 3 Char Day Timeline aa Day Alpha 2 Char DateType Timeline aaaaa... Date Type Alpha ~255 From List