Name: Cross Reference of 100-mile Buffer Results - TCU Locations and NPS Boundaries

Display Field:

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• UNIT_CODE (type: esriFieldTypeString, alias: NPS Unit Code, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• UNIT_NAME (type: esriFieldTypeString, alias: NPS Unit Name, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CollegeID (type: esriFieldTypeString, alias: CollegeID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CampusID (type: esriFieldTypeString, alias: CampusID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TCU_Name_with_Abbreviation (type: esriFieldTypeString, alias: TCU Name with Abbreviation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TCU_Name (type: esriFieldTypeString, alias: TCU Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TCU_Abbreviation (type: esriFieldTypeString, alias: TCU Abbreviation, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• TCU_President_April_2024 (type: esriFieldTypeString, alias: TCU President in April 2024, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TCU_Website (type: esriFieldTypeString, alias: TCU Website, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TCU_Longitude_X (type: esriFieldTypeDouble, alias: Longitude (X) (TCU Primary Location), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TCU_Latitude_Y (type: esriFieldTypeDouble, alias: Latitude (Y) (TCU Primary Location), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TCU_Mailing_Address (type: esriFieldTypeString, alias: Mailing Address - Top Row (TCU), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TCU_Physical_Address (type: esriFieldTypeString, alias: Physical Address - Top Row (TCU), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TCU_Address_Last_Row (type: esriFieldTypeString, alias: Address Last Row (TCU), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TCU_City (type: esriFieldTypeString, alias: City (TCU), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TCU_State_Abbrev (type: esriFieldTypeString, alias: State Abbreviation (TCU), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• TCU_State (type: esriFieldTypeString, alias: State (TCU), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• TCU_Postal_Code (type: esriFieldTypeString, alias: Postal Code (TCU), SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• TCU_Telephone (type: esriFieldTypeString, alias: Telephone (TCU), SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• TCU_Fax (type: esriFieldTypeString, alias: Fax (TCU), SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• TCU_Chartered_Text (type: esriFieldTypeString, alias: Chartered Text (TCU), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TCU_Chartered_Year (type: esriFieldTypeInteger, alias: Chartered Year (TCU), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TCU_Member_Status (type: esriFieldTypeString, alias: Member Status in AIHEC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TCU_Location_Type (type: esriFieldTypeString, alias: Location Type Represented by Point (ex. Campus, Admin Office), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TCU_Multiple_Locations (type: esriFieldTypeString, alias: Multiple Campuses or Locations? (TCU), SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• TCU_Add_Info (type: esriFieldTypeString, alias: Additional Information (TCU), SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• TCU_Profile (type: esriFieldTypeString, alias: Profile of Tribal College or University, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• TCU_Closest_NPSUnitName (type: esriFieldTypeString, alias: Closest NPS Unit Name to Primary Campus , SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• TCU_Closest_NPSUnitCode (type: esriFieldTypeString, alias: Closest NPS Unit Code to Primary Campus , SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• TCU_Closest_NPS_DistMiles (type: esriFieldTypeDouble, alias: Distance to Closest NPS Unit to Primary Campus (Miles, with Decimals), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TCU_Closest_NPS_DistMiles_Int (type: esriFieldTypeInteger, alias: Distance to Closest NPS Unit to Primary Campus (Miles), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Campus_Name (type: esriFieldTypeString, alias: Campus Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Campus_Type (type: esriFieldTypeString, alias: Location Type (Campus), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Campus_Longitude_X (type: esriFieldTypeDouble, alias: Longitude (X) (Campus), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Campus_Latitude_Y (type: esriFieldTypeDouble, alias: Latitude (Y) (Campus), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Campus_Mailing_Address (type: esriFieldTypeString, alias: Mailing Address - Top Row (Campus), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Campus_Physical_Address (type: esriFieldTypeString, alias: Physical Address - Top Row (Campus), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Campus_Address_Last_Row (type: esriFieldTypeString, alias: Address Last Row (Campus), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Campus_City (type: esriFieldTypeString, alias: City (Campus), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Campus_State_Abbrev (type: esriFieldTypeString, alias: State Abbreviation (Campus), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Campus_State (type: esriFieldTypeString, alias: State (Campus), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Campus_Postal_Code (type: esriFieldTypeString, alias: Postal Code (Campus), SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Campus_Telephone (type: esriFieldTypeString, alias: Telephone (Campus), SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Campus_Add_Info (type: esriFieldTypeString, alias: Additional Information (Campus), SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Campus_Closest_NPSUnitName (type: esriFieldTypeString, alias: Closest NPS Unit Name to Campus , SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Campus_Closest_NPSUnitCode (type: esriFieldTypeString, alias: Closest NPS Unit Code to Campus , SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• Campus_Closest_NPS_DistMiles (type: esriFieldTypeDouble, alias: Distance to Closest NPS Unit to Campus (Miles, with Decimals), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Campus_Closest_NPS_DistMiles_In (type: esriFieldTypeInteger, alias: Distance to Closest NPS Unit to Campus (Miles), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Campus_NPS_Within_100miles (type: esriFieldTypeString, alias: NPS Unit within 100 miles of a Campus, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Campus_NPS_Within_100miles_Num (type: esriFieldTypeInteger, alias: Number of NPS Units within 100 miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NPS_Within_100miles (type: esriFieldTypeString, alias: NPS Unit within 100 miles of a Campus, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NPS_Within_100miles_Num (type: esriFieldTypeInteger, alias: Number of NPS Units within 100 miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NPS_GNIS_ID (type: esriFieldTypeString, alias: GNIS_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NPS_State (type: esriFieldTypeString, alias: State (NPS Unit), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NPS_State_Abbrev (type: esriFieldTypeString, alias: State Abbreviation (NPS Unit), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NPS_Region (type: esriFieldTypeString, alias: NPS Region Name (NPS Unit), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NPS_Region_Abbrev (type: esriFieldTypeString, alias: NPS Region Code (NPS Unit), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• NPS_Website (type: esriFieldTypeString, alias: NPS Website, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Relationships:

• AIHEC_TCU_Loc_TO_CrossRef_100Buffer (1) -- Related To: Tribal Colleges and Universities (1)
• AIHEC_TCU_Campus_TO_CrossRef_100Buffer (2) -- Related To: TCU Campuses (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/7/2024 8:23:16 PM

Schema Last Edit Date: 8/7/2024 8:23:16 PM

Data Last Edit Date: 5/16/2024 5:37:13 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat