Template:FWDD-List: Difference between revisions
Jump to navigation
Jump to search
John Stanton (talk | contribs) No edit summary |
John Stanton (talk | contribs) No edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{FWDBHeader|Title=Data Elements|EditPage=FWDD-List}} | {{FWDBHeader|Title=Data Elements|EditPage=FWDD-List}} | ||
{{FWDBList|Name= | {{FWDBList|Name=Acquisition No|Table=Fortification|Format=nnnnnn|Definition=Acquisition Number|Type=Numeric|Length=6 Char|Notes=}} | ||
{{FWDBList|Name=State|Table=Fortification|Format=aa|Definition=Present Day State Abbreviation|Type=Alpha|Length=2 Char|Notes=}} | |||
{{FWDBList|Name=State|Table=Fortification|Format=aa|Definition=State Abbreviation|Type=Alpha|Length=2 Char|Notes=}} | {{FWDBList|Name=County|Table=Fortification|Format=nnn|Definition=Present Day County Code|Type=Numeric|Length=4 Char|Notes=}} | ||
{{FWDBList|Name=County|Table=Fortification|Format=nnn|Definition=County Code|Type=Numeric|Length=4 Char|Notes=}} | |||
{{FWDBList|Name=Name|Table=Fortification|Format=aaaaa...|Definition=Fortification Name|Type=Alpha|Length=~255 Char|Notes=}} | {{FWDBList|Name=Name|Table=Fortification|Format=aaaaa...|Definition=Fortification Name|Type=Alpha|Length=~255 Char|Notes=}} | ||
{{FWDBList|Name=See|Table=Fortification|Format=nnnnnnn|Definition=Primary Fort Acquisition Number|Type=Numeric|Length=7 Char|Notes=}} | {{FWDBList|Name=See|Table=Fortification|Format=nnnnnnn|Definition=Primary Fort Acquisition Number|Type=Numeric|Length=7 Char|Notes=}} | ||
{{FWDBList|Name=Type|Table=Fortification|Format=aaaaa...|Definition=Type of Fortification|Type=Alpha|Length=~255 Char|Notes=From List}} | {{FWDBList|Name=Type|Table=Fortification|Format=aaaaa...|Definition=Type of Fortification|Type=Alpha|Length=~255 Char|Notes=From List}} | ||
{{FWDBList|Name=PLat|Table=GPS|Format=aaaaaaaaaaaa|Definition=Latitude|Type=Alpha|Length=12 Char|Notes=}} | |||
{{FWDBList|Name=PLon|Table=GPS|Format=aaaaaaaaaaaa|Definition=Longitude|Type=Alpha|Length=12 Char||Notes=}} | |||
{{FWDBList|Name=GNISID|Table=Fortification|Format=nnnnnnn|Definition=GNIS ID Number|Type=Alpha|Length=7 Char|Notes=}} | {{FWDBList|Name=GNISID|Table=Fortification|Format=nnnnnnn|Definition=GNIS ID Number|Type=Alpha|Length=7 Char|Notes=}} | ||
| Line 21: | Line 22: | ||
{{FWDBList|Name=Abbr|Table=Country|Format=aaa|Definition=Country Table Name|Type=Alpha|Length=3 Char|Notes=}} | {{FWDBList|Name=Abbr|Table=Country|Format=aaa|Definition=Country Table Name|Type=Alpha|Length=3 Char|Notes=}} | ||
{{FWDBList|Name=Sequence|Table= | {{FWDBList|Name=Sequence|Table=Timeline|Format=nnnnnnn|Definition=Acquisition Number|Type=Numeric|Length=7 Char|Notes=}} | ||
{{FWDBList|Name=Year|Table= | {{FWDBList|Name=Year|Table=Timeline|Format=aaaa|Definition=Year|Type=Alpha|Length=4 Char|Notes=}} | ||
{{FWDBList|Name=Month|Table= | {{FWDBList|Name=Month|Table=Timeline|Format=aaa|Definition=Month|Type=Alpha|Length=3 Char|Notes=}} | ||
{{FWDBList|Name=Day|Table= | {{FWDBList|Name=Day|Table=Timeline|Format=aa|Definition=Day|Type=Alpha|Length=2 Char|Notes=}} | ||
{{FWDBList|Name=DateType|Table= | {{FWDBList|Name=DateType|Table=Timeline|Format=aaaaa...|Definition=Date Type|Type=Alpha|Length=~255|Notes=From List}} | ||
<!--{{FWDBList|Name=|Table=|Format=|Definition=|Type=|Length=|Notes=}}--> | <!--{{FWDBList|Name=|Table=|Format=|Definition=|Type=|Length=|Notes=}}--> | ||
{{CommonFooter}} | {{CommonFooter}} | ||
Latest revision as of 08:03, 24 February 2020
| 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 |