FortWiki Database Project - Data Definition

Database Project Home 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