About this Dataset

MCNA - Population Points With T/D Standards

Updated 10/6/2022: In the Time/Distance analysis process, points that were found to have been included initially, but with no significant or year-round population were removed. The layer of removed points is also available for viewing. MCNA - Removed Population Points

The Network Adequacy Standards Representative Population Points feature layer contains 97,694 points spread across California that were created from USPS postal delivery route data and US Census data. Each population point also contains the variables for Time and Distance Standards for the County that the point is within. These standards differ by County due to the County "type" which is based on the population density of the county. There are 5 county categories within California: Rural (<50 people/sq mile), Small (51-200 people/sq mile), Medium (201-599 people/sq mile), and Dense (>600 people/sq mile). The Time and Distance data is divided out by Provider Type, Adult and Pediatric separately, so that the Time or Distance analysis can be performed with greater detail.

Hospitals
OB/GYN Specialty
Adult Cardiology/Interventional Cardiology
Adult Dermatology
Adult Endocrinology
Adult ENT/Otolaryngology
Adult Gastroenterology
Adult General Surgery
Adult Hematology
Adult HIV/AIDS/Infectious Disease
Adult Mental Health Outpatient Services
Adult Nephrology
Adult Neurology
Adult Oncology
Adult Ophthalmology
Adult Orthopedic Surgery
Adult PCP
Adult Physical Medicine and Rehabilitation
Adult Psychiatry
Adult Pulmonology
Pediatric Cardiology/Interventional Cardiology
Pediatric Dermatology
Pediatric Endocrinology
Pediatric ENT/Otolaryngology
Pediatric Gastroenterology
Pediatric General Surgery
Pediatric Hematology
Pediatric HIV/AIDS/Infectious Disease
Pediatric Mental Health Outpatient Services
Pediatric Nephrology
Pediatric Neurology
Pediatric Oncology
Pediatric Ophthalmology
Pediatric Orthopedic Surgery
Pediatric PCP
Pediatric Physical Medicine and Rehabilitation
Pediatric Psychiatry
Pediatric Pulmonology
Organization: State of California
Last updated: 2025-08-23T13:16:48.141206
Tags: california-department-of-health-care-services, managed-care, mc, na, network-adequacy, networks, pop, population-points, standards

Tables

Table 1

@usgov.ca_gov_mcna_population_points_with_t_d_standards_53349.table_1

5.7 MB
87,529 rows
92 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "county" VARCHAR,
  "zip_code" BIGINT,
  "county_zip" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "census_tract" BIGINT,
  "census_block_group" BIGINT,
  "all_plan" VARCHAR,
  "county_size_type" VARCHAR,
  "people_sq_mi" VARCHAR,
  "tt_hospitals" BIGINT  -- TT, Hospitals,
  "dt_hospitals" BIGINT  -- DT, Hospitals,
  "tt_adult_pcp" BIGINT  -- TT, Adult PCP,
  "dt_adult_pcp" BIGINT  -- DT, Adult PCP,
  "tt_pediatric_pcp" BIGINT  -- TT, Pediatric PCP,
  "dt_pediatric_pcp" BIGINT  -- DT, Pediatric PCP,
  "tt_ob_gyn_primary" BIGINT  -- TT, OB GYN Primary,
  "dt_ob_gyn_primary" BIGINT  -- DT, OB GYN Primary,
  "tt_ob_gyn_specialty" BIGINT  -- TT, OB GYN Specialty,
  "dt_ob_gyn_specialty" BIGINT  -- DT, OB GYN Specialty,
  "tt_adult_cardiology_interventi" BIGINT  -- TT, Adult Cardiology Interventi,
  "dt_adult_cardiology_interventi" BIGINT  -- DT, Adult Cardiology Interventi,
  "tt_adult_dermatology" BIGINT  -- TT, Adult Dermatology,
  "dt_adult_dermatology" BIGINT  -- DT, Adult Dermatology,
  "tt_adult_endocrinology" BIGINT  -- TT, Adult Endocrinology,
  "dt_adult_endocrinology" BIGINT  -- DT, Adult Endocrinology,
  "tt_adult_ent_otolaryngology" BIGINT  -- TT, Adult ENT Otolaryngology,
  "dt_adult_ent_otolaryngology" BIGINT  -- DT, Adult ENT Otolaryngology,
  "tt_adult_gastroenterology" BIGINT  -- TT, Adult Gastroenterology,
  "dt_adult_gastroenterology" BIGINT  -- DT, Adult Gastroenterology,
  "tt_adult_general_surgery" BIGINT  -- TT, Adult General Surgery,
  "dt_adult_general_surgery" BIGINT  -- DT, Adult General Surgery,
  "tt_adult_hematology" BIGINT  -- TT, Adult Hematology,
  "dt_adult_hematology" BIGINT  -- DT, Adult Hematology,
  "tt_adult_hiv_aids_infectious_d" BIGINT  -- TT, Adult HIV AIDS Infectious D,
  "dt_adult_hiv_aids_infectious_d" BIGINT  -- DT, Adult HIV AIDS Infectious D,
  "tt_adult_mental_health_outpati" BIGINT  -- TT, Adult Mental Health Outpati,
  "dt_adult_mental_health_outpati" BIGINT  -- DT, Adult Mental Health Outpati,
  "tt_adult_nephrology" BIGINT  -- TT, Adult Nephrology,
  "dt_adult_nephrology" BIGINT  -- DT, Adult Nephrology,
  "tt_adult_neurology" BIGINT  -- TT, Adult Neurology,
  "dt_adult_neurology" BIGINT  -- DT, Adult Neurology,
  "tt_adult_oncology" BIGINT  -- TT, Adult Oncology,
  "dt_adult_oncology" BIGINT  -- DT, Adult Oncology,
  "tt_adult_ophthalmology" BIGINT  -- TT, Adult Ophthalmology,
  "dt_adult_ophthalmology" BIGINT  -- DT, Adult Ophthalmology,
  "tt_adult_orthopedic_surgery" BIGINT  -- TT, Adult Orthopedic Surgery,
  "dt_adult_orthopedic_surgery" BIGINT  -- DT, Adult Orthopedic Surgery,
  "tt_adult_physical_medicine_and" BIGINT  -- TT, Adult Physical Medicine And,
  "dt_adult_physical_medicine_and" BIGINT  -- DT, Adult Physical Medicine And,
  "tt_adult_psychiatry" BIGINT  -- TT, Adult Psychiatry,
  "dt_adult_psychiatry" BIGINT  -- DT, Adult Psychiatry,
  "tt_adult_pulmonology" BIGINT  -- TT, Adult Pulmonology,
  "dt_adult_pulmonology" BIGINT  -- DT, Adult Pulmonology,
  "tt_pediatric_cardiology_interv" BIGINT  -- TT, Pediatric Cardiology Interv,
  "dt_pediatric_cardiology_interv" BIGINT  -- DT, Pediatric Cardiology Interv,
  "tt_pediatric_dermatology" BIGINT  -- TT, Pediatric Dermatology,
  "dt_pediatric_dermatology" BIGINT  -- DT, Pediatric Dermatology,
  "tt_pediatric_endocrinology" BIGINT  -- TT, Pediatric Endocrinology,
  "dt_pediatric_endocrinology" BIGINT  -- DT, Pediatric Endocrinology,
  "tt_pediatric_ent_otolaryngolog" BIGINT  -- TT, Pediatric ENT Otolaryngolog,
  "dt_pediatric_ent_otolaryngolog" BIGINT  -- DT, Pediatric ENT Otolaryngolog,
  "tt_pediatric_gastroenterology" BIGINT  -- TT, Pediatric Gastroenterology,
  "dt_pediatric_gastroenterology" BIGINT  -- DT, Pediatric Gastroenterology,
  "tt_pediatric_general_surgery" BIGINT  -- TT, Pediatric General Surgery,
  "dt_pediatric_general_surgery" BIGINT  -- DT, Pediatric General Surgery,
  "tt_pediatric_hematology" BIGINT  -- TT, Pediatric Hematology,
  "dt_pediatric_hematology" BIGINT  -- DT, Pediatric Hematology,
  "tt_pediatric_hiv_aids_infectio" BIGINT  -- TT, Pediatric HIV AIDS Infectio,
  "dt_pediatric_hiv_aids_infectio" BIGINT  -- DT, Pediatric HIV AIDS Infectio,
  "tt_pediatric_mental_health_out" BIGINT  -- TT, Pediatric Mental Health Out,
  "dt_pediatric_mental_health_out" BIGINT  -- DT, Pediatric Mental Health Out,
  "tt_pediatric_nephrology" BIGINT  -- TT, Pediatric Nephrology,
  "dt_pediatric_nephrology" BIGINT  -- DT, Pediatric Nephrology,
  "tt_pediatric_neurology" BIGINT  -- TT, Pediatric Neurology,
  "dt_pediatric_neurology" BIGINT  -- DT, Pediatric Neurology,
  "tt_pediatric_ophthalmology" BIGINT  -- TT, Pediatric Ophthalmology,
  "dt_pediatric_ophthalmology" BIGINT  -- DT, Pediatric Ophthalmology,
  "tt_pediatric_orthopedic_surger" BIGINT  -- TT, Pediatric Orthopedic Surger,
  "dt_pediatric_orthopedic_surger" BIGINT  -- DT, Pediatric Orthopedic Surger,
  "tt_pediatric_physical_medicine" BIGINT  -- TT, Pediatric Physical Medicine,
  "dt_pediatric_physical_medicine" BIGINT  -- DT, Pediatric Physical Medicine,
  "tt_pediatric_psychiatry" BIGINT  -- TT, Pediatric Psychiatry,
  "dt_pediatric_psychiatry" BIGINT  -- DT, Pediatric Psychiatry,
  "tt_pediatric_pulmonology" BIGINT  -- TT, Pediatric Pulmonology,
  "dt_pediatric_pulmonology" BIGINT  -- DT, Pediatric Pulmonology,
  "tt_pediatric_oncology" DOUBLE,
  "dt_pediatric_oncology" VARCHAR,
  "loc_code_gcode" VARCHAR
);