View In:   ArcGIS Online Map Viewer

Parent Layer: CPUC_Download_KiteWorks

Name: EOY2023_Census_Blocks_2020_Oasis_FPL200_Join

Display Field: namelsad20

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: This was downloaded from CPUC Kiteworks email on 8/12/2025 for Eric Bergerson from a request from him for a table containing data at the block group level for the following Counties: CNTYNAME20 IN ('Nevada', 'Placer', 'El Dorado', 'Sierra', 'Yuba')Used Census Block Group From CPUC site, pulled the webservice, downloaded it locally and joined it to the EOY2023 census block layer. A new field was created by removing the last 3 characters from the census block GEOID20 so that the census block data could be joined to the census block group data (which contains the FPL 200% data) .

Service Item Id: 1bf9150576d744ac8e3542f8f161222d

Copyright Text: Travis Freed

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 6664649.53663975
YMin: 1947823.6578200608
XMax: 7165958.55042392
YMax: 2410930.6197276413
Spatial Reference: 102642  (2226)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [209, 225, 252, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 40
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: true
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• geoid20 ( modelName: geoid20, nullable: true, editable: true, defaultValue: null, length: 15, alias: Full Census Block Code, type: esriFieldTypeString )
• census_bg_join ( modelName: census_bg_join, nullable: true, editable: true, defaultValue: null, length: 15, alias: Census_BG_join, type: esriFieldTypeString )
• namelsad20 ( modelName: namelsad20, nullable: true, editable: true, defaultValue: null, length: 20, alias: Name, type: esriFieldTypeString )
• cntyname20 ( modelName: cntyname20, nullable: true, editable: true, defaultValue: null, length: 50, alias: COUNTY, type: esriFieldTypeString )
• plname20 ( modelName: plname20, nullable: true, editable: true, defaultValue: null, length: 50, alias: PLACE, type: esriFieldTypeString )
• aland20 ( modelName: aland20, nullable: true, editable: true, defaultValue: null, alias: Land Area (Sqare Meters), type: esriFieldTypeInteger )
• awater20 ( modelName: awater20, nullable: true, editable: true, defaultValue: null, alias: Water Area (Sqare Meters), type: esriFieldTypeInteger )
• sqmi_gis ( modelName: sqmi_gis, nullable: true, editable: true, defaultValue: null, alias: Area (Square Miles), type: esriFieldTypeDouble )
• pop_2020 ( modelName: pop_2020, nullable: true, editable: true, defaultValue: null, alias: Population 2020, type: esriFieldTypeDouble )
• hh_2020 ( modelName: hh_2020, nullable: true, editable: true, defaultValue: null, alias: Households 2020, type: esriFieldTypeDouble )
• hu_2020 ( modelName: hu_2020, nullable: true, editable: true, defaultValue: null, alias: Housing Units 2020, type: esriFieldTypeDouble )
• status ( modelName: status, nullable: true, editable: true, defaultValue: null, length: 50, alias: Fixed Broadband Served Status, type: esriFieldTypeString )
• pop_dens ( modelName: pop_dens, nullable: true, editable: true, defaultValue: null, alias: Population per Square Mile, type: esriFieldTypeDouble )
• hh_dens ( modelName: hh_dens, nullable: true, editable: true, defaultValue: null, alias: Households per Square Mile, type: esriFieldTypeDouble )
• hu_dens ( modelName: hu_dens, nullable: true, editable: true, defaultValue: null, alias: Housing Units per Square Mile, type: esriFieldTypeDouble )
• hu_range ( modelName: hu_range, nullable: true, editable: true, defaultValue: null, length: 25, alias: Housing Unit Range, type: esriFieldTypeString )
• below_101 ( modelName: below_101, nullable: true, editable: true, defaultValue: null, alias: Locations with No Availability or Maximum Broadband Speeds Below 10/1 as of December 31, 2023, type: esriFieldTypeDouble )
• btwn_101_253 ( modelName: btwn_101_253, nullable: true, editable: true, defaultValue: null, alias: Locations with Maximum Broadband Speeds Between 10/1 and 25/3 as of December 31, 2023, type: esriFieldTypeDouble )
• btwn_253_10020 ( modelName: btwn_253_10020, nullable: true, editable: true, defaultValue: null, alias: Locations with Maximum Broadband Speeds Between 25/3 and 100/20 as of December 31, 2023, type: esriFieldTypeDouble )
• above_10020 ( modelName: above_10020, nullable: true, editable: true, defaultValue: null, alias: Locations with Maximum Broadband Speeds Above 100/20 as of December 31, 2023, type: esriFieldTypeDouble )
• maxaddn ( modelName: maxaddn, nullable: true, editable: true, defaultValue: null, alias: Maximum Advertised Downstream Speed (Mbps), type: esriFieldTypeDouble )
• objectid_1 ( modelName: objectid_1, nullable: true, editable: true, defaultValue: null, alias: OBJECTID, type: esriFieldTypeInteger )
• geoid20_1 ( modelName: geoid20_1, nullable: true, editable: true, defaultValue: null, length: 12, alias: Full Census Block Group Code, type: esriFieldTypeString )
• namelsad20_1 ( modelName: namelsad20_1, nullable: true, editable: true, defaultValue: null, length: 20, alias: Name, type: esriFieldTypeString )
• aland20_1 ( modelName: aland20_1, nullable: true, editable: true, defaultValue: null, alias: Land Area (Sqare Meters), type: esriFieldTypeDouble )
• awater20_1 ( modelName: awater20_1, nullable: true, editable: true, defaultValue: null, alias: Water Area (Square Meters), type: esriFieldTypeDouble )
• sqmi_gis_1 ( modelName: sqmi_gis_1, nullable: true, editable: true, defaultValue: null, alias: Area (Square Miles), type: esriFieldTypeDouble )
• pop_2020_1 ( modelName: pop_2020_1, nullable: true, editable: true, defaultValue: null, alias: Population 2020, type: esriFieldTypeDouble )
• hh_2020_1 ( modelName: hh_2020_1, nullable: true, editable: true, defaultValue: null, alias: Households 2020, type: esriFieldTypeDouble )
• hu_2020_1 ( modelName: hu_2020_1, nullable: true, editable: true, defaultValue: null, alias: Housing Units 2020, type: esriFieldTypeDouble )
• fedpovlvl ( modelName: fedpovlvl, nullable: true, editable: true, defaultValue: null, alias: 200% Federal Poverty Level, type: esriFieldTypeDouble )
• mhi ( modelName: mhi, nullable: true, editable: true, defaultValue: null, alias: Median Household Income, type: esriFieldTypeDouble )
• pcap_inc ( modelName: pcap_inc, nullable: true, editable: true, defaultValue: null, alias: Per Capita Income, type: esriFieldTypeDouble )
• medage ( modelName: medage, nullable: true, editable: true, defaultValue: null, alias: Median Age, type: esriFieldTypeDouble )
• avghhsize ( modelName: avghhsize, nullable: true, editable: true, defaultValue: null, alias: Average Household Size, type: esriFieldTypeDouble )
• pct_25_bac ( modelName: pct_25_bac, nullable: true, editable: true, defaultValue: null, alias: Bachelor's Degree or Higher (Population 25 and Older), type: esriFieldTypeDouble )
• pct_25_hsd ( modelName: pct_25_hsd, nullable: true, editable: true, defaultValue: null, alias: Highschool Diploma or Higher (Population 25 and Older), type: esriFieldTypeDouble )
• engnotwell ( modelName: engnotwell, nullable: true, editable: true, defaultValue: null, alias: Limited English Households, type: esriFieldTypeDouble )
• ownhome ( modelName: ownhome, nullable: true, editable: true, defaultValue: null, alias: Home Ownership Rate, type: esriFieldTypeDouble )
• shape_length_1 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, required: true, modelName: shape_length_1, alias: SHAPE_Length )
• shape_area_1 ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, required: true, modelName: shape_area_1, alias: SHAPE_Area )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )
• maxspeed_10_25 ( nullable: true, editable: true, defaultValue: null, alias: Locations with Maximum Broadband Speeds Between 10/1 and 25/3 as of December 31, 2023, type: esriFieldTypeInteger )

Templates:

• Name: EOY2023_Census_Blocks_2020_Oasis_FPL200_Join
  Description:
  Prototype:
  maxaddn: null
  sqmi_gis_1: null
  ownhome: null
  hu_range: null
  hh_2020_1: null
  hh_2020: null
  aland20_1: null
  namelsad20: null
  hh_dens: null
  fedpovlvl: null
  medage: null
  avghhsize: null
  census_bg_join: null
  pop_2020_1: null
  hu_2020_1: null
  aland20: null
  pct_25_bac: null
  cntyname20: null
  hu_dens: null
  pct_25_hsd: null
  shape_area_1: null
  geoid20: null
  pop_2020: null
  geoid20_1: null
  maxspeed_10_25: null
  plname20: null
  below_101: null
  pcap_inc: null
  namelsad20_1: null
  pop_dens: null
  objectid_1: null
  hu_2020: null
  mhi: null
  engnotwell: null
  shape_length_1: null
  btwn_253_10020: null
  sqmi_gis: null
  btwn_101_253: null
  awater20_1: null
  awater20: null
  above_10020: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata