Airports19k
extends Model
in package
uses
HasFactory
Airports19k Model for managing comprehensive airport data and facility information.
This model is used to create and manage extensive airport data including facility details, operational information, geographic coordinates, ownership details, and comprehensive airport specifications. It provides a structured interface for storing and retrieving detailed airport information such as location data, facility characteristics, operational statistics, fuel services, lighting systems, air traffic control information, and various operational metrics. The model supports comprehensive airport data management including geographic positioning, facility ownership, operational statistics, and regulatory compliance information for the airport guide platform.
Tags
Table of Contents
Properties
- $activation_date : string
- $agency_inspection : string
- $air_taxi_ops : int
- $airspace_analysis : string
- $alt_fss_id : string
- $alt_fss_name : string
- $annual_ops_date : string
- $arff_cert_type_date : string
- $atc_tower : string
- $based_gliders : int
- $based_helicopter : int
- $based_jet_eng : int
- $based_military : int
- $based_multi_eng : int
- $based_single_eng : int
- $based_ultralight : int
- $beacon_color : string
- $beacon_light_schedule : string
- $bottled_oxygen : string
- $boundary_artcc : string
- $bulk_oxygen : string
- $city : string
- $commercial_ops : int
- $commuter_ops : int
- $contract_fuel : string
- $county : string
- $county_post_office_code : string
- $ctaf : string
- $dir_city_to_airport : string
- $dist_city_to_airport : float
- $eff_date : string
- $elevation : float
- $elevation_method : string
- $elevation_src : string
- $elevation_src_date : string
- $fac_name : string
- $facility_type : string
- $facility_use : string
- $field_office_code : string
- $filler : string
- $fss : string
- $fss_on_fac : string
- $fuel_types : string
- $ga_itinerant_ops : int
- $ga_local_ops : int
- $icao_identifier : string
- $id : int
- $inspection_method : string
- $intl_customs_entry : string
- $intl_customs_landing : string
- $land_area_covered : float
- $landing_fee : string
- $last_info_request : string
- $last_inspection : string
- $lighting_sched : string
- $loc_id : string
- $local_phone_airport_to_fss : string
- $mag_var : float
- $mag_var_year : int
- $manager_address : string
- $manager_city_state_zip : string
- $manager_name : string
- $manager_phone : string
- $medical_fac : string
- $mil_joint_use_civ : string
- $mil_landing_rights : string
- $min_op_net : string
- $mitary_ops : int
- $notam_dservice : string
- $notam_wx_fac_id : string
- $npias_fed_cod : string
- $objectid : int
- $other_services : string
- $owner_address : string
- $owner_city_state_zip : string
- $owner_name : string
- $owner_phone : string
- $owner_type : string
- $pattern_altitude : float
- $position_src : string
- $position_src_date : string
- $power_plant_repair : string
- $rec_type : string
- $ref_point_lat : float
- $ref_point_lat_secs : float
- $ref_point_lon : float
- $ref_point_lon_secs : float
- $ref_point_method : string
- $region_code : string
- $repair_service : string
- $responsible_artcc : string
- $sectional_chart : string
- $seg_circle_marker : string
- $site_num : string
- $state_name : string
- $state_post_office_code : string
- $status_code : string
- $toll_free_phone_airport_to_alt_ : string
- $toll_free_phone_airport_to_fss : string
- $transient_storage : string
- $unicom : string
- $wind_indicator : string
- $x : float
- $y : float
- $fillable : array<string|int, mixed>
- The attributes that are mass assignable for comprehensive airport data records.
Methods
- __construct() : void
- Initialize the Airports19k model with the correct database table configuration.
Properties
$activation_date
public
string
$activation_date
The facility activation date
$agency_inspection
public
string
$agency_inspection
The agency inspection information
$air_taxi_ops
public
int
$air_taxi_ops
The number of air taxi operations
$airspace_analysis
public
string
$airspace_analysis
The airspace analysis information
$alt_fss_id
public
string
$alt_fss_id
The alternate FSS identifier
$alt_fss_name
public
string
$alt_fss_name
The alternate FSS name
$annual_ops_date
public
string
$annual_ops_date
The annual operations date
$arff_cert_type_date
public
string
$arff_cert_type_date
The ARFF certification type and date
$atc_tower
public
string
$atc_tower
The air traffic control tower information
$based_gliders
public
int
$based_gliders
The number of based gliders
$based_helicopter
public
int
$based_helicopter
The number of based helicopters
$based_jet_eng
public
int
$based_jet_eng
The number of based jet-engine aircraft
$based_military
public
int
$based_military
The number of based military aircraft
$based_multi_eng
public
int
$based_multi_eng
The number of based multi-engine aircraft
$based_single_eng
public
int
$based_single_eng
The number of based single-engine aircraft
$based_ultralight
public
int
$based_ultralight
The number of based ultralight aircraft
$beacon_color
public
string
$beacon_color
The beacon color information
$beacon_light_schedule
public
string
$beacon_light_schedule
The beacon light schedule
$bottled_oxygen
public
string
$bottled_oxygen
The bottled oxygen availability
$boundary_artcc
public
string
$boundary_artcc
The boundary ARTCC information
$bulk_oxygen
public
string
$bulk_oxygen
The bulk oxygen availability
$city
public
string
$city
The city name
$commercial_ops
public
int
$commercial_ops
The number of commercial operations
$commuter_ops
public
int
$commuter_ops
The number of commuter operations
$contract_fuel
public
string
$contract_fuel
The contract fuel information
$county
public
string
$county
The county name
$county_post_office_code
public
string
$county_post_office_code
The county postal office code
$ctaf
public
string
$ctaf
The common traffic advisory frequency
$dir_city_to_airport
public
string
$dir_city_to_airport
The direction from city to airport
$dist_city_to_airport
public
float
$dist_city_to_airport
The distance from city to airport
$eff_date
public
string
$eff_date
The effective date for the record
$elevation
public
float
$elevation
The facility elevation in feet
$elevation_method
public
string
$elevation_method
The elevation measurement method
$elevation_src
public
string
$elevation_src
The elevation source information
$elevation_src_date
public
string
$elevation_src_date
The elevation source date
$fac_name
public
string
$fac_name
The facility name
$facility_type
public
string
$facility_type
The facility type classification
$facility_use
public
string
$facility_use
The facility use classification
$field_office_code
public
string
$field_office_code
The field office code
$filler
public
string
$filler
The filler field
$fss
public
string
$fss
The flight service station information
$fss_on_fac
public
string
$fss_on_fac
The flight service station on facility
$fuel_types
public
string
$fuel_types
The available fuel types
$ga_itinerant_ops
public
int
$ga_itinerant_ops
The number of general aviation itinerant operations
$ga_local_ops
public
int
$ga_local_ops
The number of general aviation local operations
$icao_identifier
public
string
$icao_identifier
The ICAO airport identifier
$id
public
int
$id
The unique identifier for the airport record
$inspection_method
public
string
$inspection_method
The inspection method used
$intl_customs_entry
public
string
$intl_customs_entry
The international customs entry information
$intl_customs_landing
public
string
$intl_customs_landing
The international customs landing information
$land_area_covered
public
float
$land_area_covered
The land area covered by the facility
$landing_fee
public
string
$landing_fee
The landing fee information
$last_info_request
public
string
$last_info_request
The last information request date
$last_inspection
public
string
$last_inspection
The last inspection date
$lighting_sched
public
string
$lighting_sched
The lighting schedule information
$loc_id
public
string
$loc_id
The location identifier code
$local_phone_airport_to_fss
public
string
$local_phone_airport_to_fss
The local phone number to FSS
$mag_var
public
float
$mag_var
The magnetic variation
$mag_var_year
public
int
$mag_var_year
The magnetic variation year
$manager_address
public
string
$manager_address
The manager address information
$manager_city_state_zip
public
string
$manager_city_state_zip
The manager city, state, and zip code
$manager_name
public
string
$manager_name
The facility manager name
$manager_phone
public
string
$manager_phone
The manager contact phone number
$medical_fac
public
string
$medical_fac
The medical facility information
$mil_joint_use_civ
public
string
$mil_joint_use_civ
The military joint use civilian information
$mil_landing_rights
public
string
$mil_landing_rights
The military landing rights information
$min_op_net
public
string
$min_op_net
The minimum operational network information
$mitary_ops
public
int
$mitary_ops
The number of military operations (note: typo in field name)
$notam_dservice
public
string
$notam_dservice
The NOTAM service information
$notam_wx_fac_id
public
string
$notam_wx_fac_id
The NOTAM weather facility identifier
$npias_fed_cod
public
string
$npias_fed_cod
The NPIAS federal code
$objectid
public
int
$objectid
The object identifier for the airport facility
$other_services
public
string
$other_services
The other services available
$owner_address
public
string
$owner_address
The owner address information
$owner_city_state_zip
public
string
$owner_city_state_zip
The owner city, state, and zip code
$owner_name
public
string
$owner_name
The facility owner name
$owner_phone
public
string
$owner_phone
The owner contact phone number
$owner_type
public
string
$owner_type
The owner type classification
$pattern_altitude
public
float
$pattern_altitude
The traffic pattern altitude
$position_src
public
string
$position_src
The position source information
$position_src_date
public
string
$position_src_date
The position source date
$power_plant_repair
public
string
$power_plant_repair
The power plant repair information
$rec_type
public
string
$rec_type
The record type classification
$ref_point_lat
public
float
$ref_point_lat
The reference point latitude
$ref_point_lat_secs
public
float
$ref_point_lat_secs
The reference point latitude seconds
$ref_point_lon
public
float
$ref_point_lon
The reference point longitude
$ref_point_lon_secs
public
float
$ref_point_lon_secs
The reference point longitude seconds
$ref_point_method
public
string
$ref_point_method
The reference point method used
$region_code
public
string
$region_code
The regional code classification
$repair_service
public
string
$repair_service
The repair service information
$responsible_artcc
public
string
$responsible_artcc
The responsible ARTCC information
$sectional_chart
public
string
$sectional_chart
The sectional chart identifier
$seg_circle_marker
public
string
$seg_circle_marker
The segmented circle marker information
$site_num
public
string
$site_num
The site number identifier
$state_name
public
string
$state_name
The full state name
$state_post_office_code
public
string
$state_post_office_code
The state postal office code
$status_code
public
string
$status_code
The facility status code
$toll_free_phone_airport_to_alt_
public
string
$toll_free_phone_airport_to_alt_
The toll-free phone to alternate FSS
$toll_free_phone_airport_to_fss
public
string
$toll_free_phone_airport_to_fss
The toll-free phone number to FSS
$transient_storage
public
string
$transient_storage
The transient storage information
$unicom
public
string
$unicom
The UNICOM frequency information
$wind_indicator
public
string
$wind_indicator
The wind indicator information
$x
public
float
$x
The X coordinate for geographic positioning
$y
public
float
$y
The Y coordinate for geographic positioning
$fillable
The attributes that are mass assignable for comprehensive airport data records.
protected
array<string|int, mixed>
$fillable
= ['id', 'x', 'y', 'objectid', 'rec_type', 'site_num', 'loc_id', 'eff_date', 'region_code', 'state_post_office_code', 'state_name', 'county', 'county_post_office_code', 'city', 'fac_name', 'owner_name', 'owner_address', 'owner_city_state_zip', 'owner_phone', 'manager_name', 'manager_address', 'manager_city_state_zip', 'manager_phone', 'ref_point_lat', 'ref_point_lat_secs', 'ref_point_lon', 'ref_point_lon_secs', 'ref_point_method', 'elevation', 'elevation_method', 'mag_var', 'mag_var_year', 'pattern_altitude', 'sectional_chart', 'dist_city_to_airport', 'dir_city_to_airport', 'land_area_covered', 'fss_on_fac', 'local_phone_airport_to_fss', 'toll_free_phone_airport_to_fss', 'alt_fss_id', 'alt_fss_name', 'toll_free_phone_airport_to_alt_', 'notam_wx_fac_id', 'notam_dservice', 'activation_date', 'status_code', 'arff_cert_type_date', 'npias_fed_cod', 'intl_customs_entry', 'intl_customs_landing', 'mil_joint_use_civ', 'mil_landing_rights', 'inspection_method', 'agency_inspection', 'last_inspection', 'last_info_request', 'fuel_types', 'repair_service', 'power_plant_repair', 'bottled_oxygen', 'bulk_oxygen', 'lighting_sched', 'beacon_light_schedule', 'atc_tower', 'unicom', 'ctaf', 'seg_circle_marker', 'beacon_color', 'landing_fee', 'medical_fac', 'based_single_eng', 'based_multi_eng', 'based_jet_eng', 'based_helicopter', 'based_gliders', 'based_military', 'based_ultralight', 'commercial_ops', 'commuter_ops', 'air_taxi_ops', 'ga_local_ops', 'ga_itinerant_ops', 'mitary_ops', 'annual_ops_date', 'position_src', 'position_src_date', 'elevation_src', 'elevation_src_date', 'contract_fuel', 'transient_storage', 'other_services', 'wind_indicator', 'icao_identifier', 'min_op_net', 'filler', 'facility_type', 'field_office_code', 'owner_type', 'facility_use', 'fss', 'boundary_artcc', 'responsible_artcc', 'airspace_analysis']
This property defines the fields that can be mass-assigned when creating or updating Airports19k records. It includes all essential airport facility fields such as geographic coordinates, facility identification, ownership information, operational statistics, fuel services, lighting systems, air traffic control data, and comprehensive facility specifications. The fillable attributes ensure data integrity while allowing efficient bulk operations for comprehensive airport data management across various facility types and operational categories.
Methods
__construct()
Initialize the Airports19k model with the correct database table configuration.
public
__construct() : void
This function is used to create a properly configured Airports19k model instance by setting the database table name from the configuration constants. It ensures that the model interacts with the correct database table for comprehensive airport data information, which is essential for proper airport facility data storage and retrieval operations. The constructor dynamically assigns the table name based on the AIRPORTS_19K configuration constant to maintain flexibility and configuration-driven behavior for comprehensive airport data management.