Oracle Designer - PDF document

1 Oracle Designer DSHUGHES12 May 200
Oracle Designer DSHUGHES12 May 2003s:\documents\pdfs\govu.pdf Parameter Values Workarea : Container : Tab/View/Snap Name : GOVERNMENT_UNITSTables Created On/After : On/Before : Tables Changed12 May 200312 May 2003Yes Column Details :Diagram : Includes On/After : On/Before : and Report : TABLE DEFINITIONFilename :Run by : Report Date : Total Pages : Container Version : Recurse Sub-Containers :GLOBAL SHARED WORKAREAGNISN8 12 May 2003 Page 2 of Table Definition Oracle Designer Report : cktci 8 Container :GNISVersion :Display Title : GOVUAlias :ColumnTypeNulls ?Col.Seq.Column SummaryNoStorageIndex-organized ? VolumesStart Rows :End Rows :00 The names and codes of governmental units in or associated with theUnited States as defined in Federal Information Processing Standards(FIPS) publications, including the following: Countries The unique two letter code of a country assigned by FederalInformation Processing Standards Publication (FIPS PUB) 10-4,"Countries, Dependencies, Areas of Special Sovereignty, And TheirPrincipal Administrative Divisions." For more information, see theFIPS Web page: http://www.itl.nist.gov/div897/pubs/index.htm

2 . Containsdata only for the following co
. Containsdata only for the following countries: United States, Mexico, Canada,Federated States of Micronesia, Marshall Islands, Palau, andAntarctica. States and equivalents A state, the District of Columbia, an outlying area of the UnitedStates and associated areas as defined in FIPS PUB 5-2, "Codes For TheIdentification of the States, The District of Columbia And TheOutlying Areas Of The United States, And Associated Areas." An equivalent principle administrative division of a country otherthan the United States as defined in FIPS PUB 10-4, "Countries,Dependencies, Areas Of Special Sovereignty, And Their PrincipalAdministrative Divisions." The attributes of this entity are defined in accordance with FIPS PUBs5-2 and 10-4, and the attribute values are from these publications.The table only the countries listed above and the state equivalentsassociated with them in publication 10-4. Counties and equivalents A county or county equivalent as listed in FIPS PUB 6-4, "Counties AndEquivalent Entities Of the United States, Its Possessions, AndAssociated Areas." A county equivalent may be a parish, borough,municipality, Alaska Census Area or other civil division of a State orState equivalent within the United States. Note: This table is denormalized f

3 rom separate State, and Countytables to
rom separate State, and Countytables to improve application query performance. The data isessentially static.Description : Table Name : GOVERNMENT_UNITS 12 May 2003 Page 3 of Table Definition Oracle Designer Report : cktci 8 Container :GNISVersion :FEATURE_ID references FEATURES.FEATURE_IDGOVU_FEAT_FKForeign KeysOther Unique KeysNameColumnPrimary KeyFEATURE_IDUNIT_TYPE This is a foreign key column for FEATURES.FEATURE_ID. The Feature ID number forthe governmental unit. The type of government unit. Values are COUNTY, STATE. Notes GNIS Table/Column: FEATURE.FEATURE_ID_NMBR Data Loading Instructions: Load from FEATURE.FEATURE_ID_NMBR.Column Detail1020Optional ? :No ; Number (10, 0) ;() ; ; Uppercase ? :No ; Optional ? :No ; Varchar2 (50) ;() ; ; Uppercase ? :Yes ; FEATURE_IDUNIT_TYPECOUNTY_NUMERICCOUNTY_NAMESTATE_NUMERICSTATE_ALPHASTATE_NAMECOUNTRY_ALPHACOUNTRY_NAMEGEOMETRYColumnNUMBER (10, 0)VARCHAR2 (50)NUMBER (3)VARCHAR2 (100)NUMBER (2)VARCHAR2 (2)VARCHAR2 (100)VARCHAR2 (2)VARCHAR2 (100)VARCHAR2 (240)TypeNOT NULLNOT NULLNULLNULLNULLNULLNULLNOT NULLNOT NULLNULLNulls ?Col.Seq.102030405060708090100 GOVU_PKFEATURE_IDCOUNTY_UKCOUNTY_NUMERICSTATE_NUMERICCOUNTRY_ALPHATransferable ?Mandatory ?Update Rule :Delete Rule :NoYesRestrictedRestricted Na

4 me Column 12 May 2003 Page 4 of T
me Column 12 May 2003 Page 4 of Table Definition Oracle Designer Report : cktci 8 Container :GNISVersion :COUNTRY_ALPHACOUNTRY_NAMECOUNTRY_ALPHASTATE_NUMERICCOUNTY_NUMERICCOUNTY_NAMECOUNTY_NUMERICCOUNTRY_ALPHASTATE_NUMERICSTATE_NAMESTATE_NUMERICUNIT_TYPEColumnCOUNTRY_ALPHA_ICOUNTRY_NAME_ICOUNTY_ICOUNTY_ICOUNTY_ICOUNTY_NAME_ICOUNTY_NUMERIC_ISTATE_ISTATE_ISTATE_NAME_ISTATE_NUMERIC_IUNIT_TYPE_INameBITMAPBITMAPNOT UNIQUENOT UNIQUENOT UNIQUENOT UNIQUENOT UNIQUENOT UNIQUENOT UNIQUENOT UNIQUENOT UNIQUEBITMAPIndex TypeCOUNTY_NUMERIC The unique three number code for a county or county equivalent assigned byFederal Information Processing Standards Publication (FIPS PUB) 6-4, "CountiesAnd Equivalent Entities Of the United States, Its Possessions, And AssociatedAreas." For more information, see the FIPS Web page:http://www.itl.nist.gov/div897/pubs/index.htm Notes Notes Current GNIS Table/Column: None Data Loading Instructions: If FEATURE_ID is: load value = Country Country County COUNTY State STATE Current GNIS Table/Column: COUNTY.CNTY_NMBR_CODE The three digit county code is unique within each state. Formany purposes, the two digit state code is added as a prefix.This full five digit county code is unique in the United States. Data Loading Ins

5 tructions: Load from the above column an
tructions: Load from the above column and verifywith the FIPS PUB. The table should contain all entries and onlythe entries from the FIPS PUB.Column DetailIndex Summary30Optional ? :Yes ; Number (3) ;() ; ; Uppercase ? :No ; Sort Order :A ; Seq.11510155112111 12 May 2003 Page 5 of Table Definition Oracle Designer Report : cktci 8 Container :GNISVersion :COUNTY_NAMESTATE_NUMERICSTATE_ALPHASTATE_NAME The name of a county or county equivalent assigned by Federal InformationProcessing Standards Publication (FIPS PUB) 6-4, "Counties And EquivalentEntities Of the United States, Its Possessions, And Associated Areas." 1. The unique two number code for a US State assigned by Federal InformationProcessing Standards Publication (FIPS PUB) 5-2, "Codes For The Identificationof the States, The District of Columbia And The Outlying Areas Of The UnitedStates, And Associated Areas." 2. The unique two number code for a principle administrative division ofcountries other than the United States assigned by FIPS PUB 10-4, "Countries,Dependencies, Areas Of Special Sovereignty, And Their Principal AdministrativeDivisions." For more information, see the FIPS Web page:http://www.itl.nist.gov/div897/pubs/index.htm The unique two letter code for a State or State equ

6 ivalent assigned by FederalInformation P
ivalent assigned by FederalInformation Processing Standards Publication (FIPS PUB) 5-2, "Codes For TheIdentification of the States, The District of Columbia And The Outlying AreasOf The United States, And Associated Areas." For more information, see the FIPS Web page:http://www.itl.nist.gov/div897/pubs/index.htm Notes Notes Notes Current GNIS Table/Column: COUNTY.COUNTY_NAME Data Loading Instructions: Load from the above column keyed toCOUNTY.CNTY_ID_NMBR and verify with the FIPS PUB. The tableshould contain all entries and only the entries from the FIPSPUB. Current GNIS Table/Column: STATE.STATE_NMBR_CODE Data Loading Instructions: Load from above column. Verify andadd as necessary from FIPS Pubs. The table will include onlyvalues from the FIPS Pubs. It will include all values from FIPSPUB 5-2, and selected values from 10-4. Current GNIS Table/Column: STATE.STATE_ALPHA_CODE Data Loading Instructions: Load from above column. Verify fromFIPS Pub. This column will include all values and only valuesfrom FIPS Pub 5-2.Column Detail40506070Optional ? :Yes ; Varchar2 (100) ;() ; ; Uppercase ? :No ; Optional ? :Yes ; Number (2) ;() ; ; Uppercase ? :No ; Sort Order :A ; Optional ? :Yes ; Varchar2 (2) ;() ; ; Uppercase ? :Yes ; Sort Order :A ; Optio

7 nal ? :Yes ; Varchar2 (100) ;() ; ; Upp
nal ? :Yes ; Varchar2 (100) ;() ; ; Uppercase ? :No ; 12 May 2003 Page 6 of Table Definition Oracle Designer Report : cktci 8 Container :GNISVersion :COUNTRY_ALPHACOUNTRY_NAMEGEOMETRY The name of a US State assigned by Federal Information Processing StandardsPublication (FIPS PUB) 5-2, "Codes For The Identification of the States, TheDistrict of Columbia And The Outlying Areas Of The United States, AndAssociated Areas." or The name of a principle administrative division of countries other than theUnited States assigned by FIPS PUB 10-4, "Countries, Dependencies, Areas OfSpecial Sovereignty, And Their Principal Administrative Divisions." The unique two letter code of a country assigned by Federal InformationProcessing Standards Publication (FIPS PUB) 10-4, "Countries, Dependencies,Areas of Special Sovereignty, And Their Principal Administrative Divisions."For more information, see the FIPS Web page:http://www.itl.nist.gov/div897/pubs/index.htm The name of a Country assigned by Federal Information Processing StandardsPublication (FIPS PUB) 10-4, "Countries, Dependencies, Areas of SpecialSovereignty, And Their Principal Administrative Divisions." Place holder for spatial column when spatially enabled. This column willcontain the county boundar

8 ies. Notes Notes Notes Current GNIS T
ies. Notes Notes Notes Current GNIS Table/Column: STATE.STATE_EQUIVALENT_NAME Data Loading Instructions: Load the from above column, keyed onSTATE.STATE_NMBR_CODE. Verify from FIPS Pubs. The table willinclude only values from the FIPS Pubs. It will include allvalues from FIPS PUB 5-2, and selected values from 10-4. Current GNIS Table/Column: COUNTRY.COUNTRY_ALPHA_CODE Data Loading Instructions: Load the from above column only forthe following countries: United States, Mexico, Canada,Federated States of Micronesia, Marshall Islands, Palau, andAntarctica. Current GNIS Table/Column: COUNTRY.COUNTRY_NAME Data Loading Instructions: Load the from above column only forthe following countries: United States, Mexico, Canada,Federated States of Micronesia, Marshall Islands, Palau, andAntarctica. Column Detail8090100Optional ? :No ; Varchar2 (2) ;() ; ; Uppercase ? :Yes ; Optional ? :No ; Varchar2 (100) ;() ; ; Uppercase ? :No ; Optional ? :Yes ; Varchar2 (240) ;() ; ; Domain :GEOMETRY ; Uppercase ? :No ; 12 May 2003 Page 7 of Table Definition Oracle Designer Report : cktci 8 Container :GNISVersion : Notes A county boundary data layer will be loaded to this column usingOracle Spatial.Column Detail Oracle Designer TABLE DEFINITION End of Repor