|
Name |
|
|
Dimensional Type |
Dimension |
|
Comment |
For storing geographical information about alums, events, etc. |
|
CKT_MD_GEOGRAPHICLOCATION |
|
Name |
|
Name |
Comment |
Domain |
Data Type |
Length |
|
MD_GeoLoc_SurrogateKey |
|
<None> |
numeric |
|
|
MD_GeoLoc_Latitude |
|
<None> |
float |
|
|
MD_GeoLoc_Longitude |
|
<None> |
float |
|
|
MD_GeoLoc_Elevation |
Elevation above sea level (in meters), i.e., mASL. |
<None> |
float |
|
|
MD_GeoLoc_KilometersFromCampus |
Great circle distance in kilometers from Carleton's main campus. |
<None> |
float |
|
|
MD_GeoLoc_Country |
|
DW_Addr_Country |
nvarchar(64) |
64 |
|
MD_GeoLoc_NonUSProvince |
|
DW_Addr_StateOrProvince |
nvarchar(64) |
64 |
|
MD_GeoLoc_USCounty |
|
DW_CodeDescLong |
varchar(64) |
64 |
|
MD_GeoLoc_USZipcode |
|
DW_Addr_5DigitUSZipcode |
char(5) |
5 |
|
MD_GeoLoc_USStateName |
|
DW_Addr_USState |
varchar(24) |
24 |
|
MD_GeoLoc_CensusYear |
Year in which the census whose information is used to populate census-related attributes in this table was taken. Tracts, blocks, etc., may shift according to the operational needs of the Census Bureau, and in order to make use of values for these attributes, we have to know the census that the data is based on. |
<None> |
int |
|
|
MD_GeoLoc_CensusDivision |
|
<None> |
int |
|
|
MD_GeoLoc_CensusRegion |
|
<None> |
int |
|
|
MD_GeoLoc_FIPSUSStateCode |
Don't ask me why, but the Census Bureau records both FIPS and "Census" US state codes, so presumably these differ. |
<None> |
char(2) |
2 |
|
MD_GeoLoc_CensusUSStateCode |
Two-digit FIPS US state code used by US Census Bureau. |
<None> |
char(2) |
2 |
|
MD_GeoLoc_CensusUSCountyCode |
Three-digit FIPS US county code used by the US Census Bureau. |
<None> |
char(3) |
3 |
|
MD_GeoLoc_CensusUSCountySubdiv |
County subdivision is one of the basic geographical areas used by the census bureau. It fits between county and census tract in their hierarchy. |
<None> |
char(5) |
5 |
|
MD_GeoLoc_CensusTract |
|
DW_CensusTract |
char(6) |
6 |
|
MD_GeoLoc_CensusBlockGroup |
|
<None> |
char(4) |
4 |
|
MD_GeoLoc_CensusBlock |
|
DW_CensusBlock |
char(4) |
4 |
|
MD_GeoLoc_CensusBlockFullCode |
|
DW_CensusBlockFull |
char(15) |
15 |
|
MD_GeoLoc_CensusPlaceFIPS |
"Place" is one of the members of the US Census Bureau's geographical hierarchy. |
<None> |
nvarchar(128) |
128 |
|
MD_GeoLoc_CensusPlaceClassCode |
|
<None> |
char(2) |
2 |
|
MD_GeoLoc_CensusPlaceClassDesc |
|
<None> |
varchar(64) |
64 |
|
MD_GeoLoc_CensusCitySize |
|
<None> |
varchar(64) |
64 |
|
MD_GeoLoc_CensusCityFIPS |
Consolidated city (FIPS) code used by Census Bureau (CONCIT). |
<None> |
char(5) |
5 |
|
MD_GeoLoc_AuditKey |
|
DW_AuditKey |
bigint |
|
|
MD_GeoLoc_Timestamp |
|
<None> |
timestamp |
|
|
Name |
Unique |
Cluster |
Primary |
Foreign Key |
Alternate Key |
Table |
|
MD_GEOGRAPHICLOCATION_PK |
TRUE |
TRUE |
TRUE |
FALSE |
FALSE |
|
|
MD_GEOGRAPHICLOCATION_AK |
TRUE |
FALSE |
FALSE |
FALSE |
TRUE |
|
Name |
|
Identifier_1 |
|
AltKey |
|
|
|