quickstarts/reading-tabular-data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "unauthorized-hartford",
   "metadata": {},
   "source": [
    "## Reading Tabular Data\n",
    "\n",
    "The Planetary Computer provides tabular data in the [Apache Parquet](https://parquet.apache.org/) file format, which provides a standarized high-performance columnar storage format.\n",
    "\n",
    "When working from Python, there are several options for reading parquet datasets. The right choice depends on the size and kind of the data you're reading. When reading geospatial data, with one or more columns containing vector geometries, we recommend using [geopandas](https://geopandas.org/) for small datasets and [dask-geopandas](https://github.com/geopandas/dask-geopandas) for large datasets. For non-geospatial tabular data, we recommend [pandas](https://pandas.pydata.org/) for small datasets and [Dask](https://dask.org/) for large datasets.\n",
    "\n",
    "Regardless of which library you're using to read the data, we recommend using [STAC](https://stacspec.org/) to discover which datasets are available, and which options should be provided when reading the data.\n",
    "\n",
    "In this example we'll work with data from the US Forest Service's [Forest Inventory and Analysis](https://planetarycomputer.microsoft.com/dataset/fia) dataset. This includes a collection of tables providing information about forest health and location in the United States."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "0095b4ef-638a-4e2f-b6e7-955f1ce1512c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #E1E1E1;\n",
       "        border: 3px solid #9D9D9D;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div>\n",
       "        <details style=\"margin-left: 48px;\">\n",
       "            <summary style=\"margin-bottom: 20px;\">\n",
       "                <h3 style=\"margin-bottom: 0px; display: inline;\">\n",
       "                    CollectionClient: fia\n",
       "                </h3>\n",
       "            </summary>\n",
       "            <table style=\"width: 100%; text-align: left;\">\n",
       "                <tr><td style=\"text-align: left;\">ID: fia </td></tr>\n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Title:</strong> Forest Inventory and Analysis </td></tr>\n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Description:</strong> Status and trends on U.S. forest location, health, growth, mortality, and production, from the U.S. Forest Service's  [Forest Inventory and Analysis](https://www.fia.fs.fed.us/) (FIA) program.\n",
       "\n",
       "The Forest Inventory and Analysis (FIA) dataset is a nationwide survey of the forest assets of the United States. The FIA research program has been in existence since 1928.  FIA's primary objective is to determine the extent, condition, volume, growth, and use of trees on the nation's forest land.\n",
       "\n",
       "Domain: continental U.S., 1928-2018\n",
       "\n",
       "Resolution: plot-level (irregular polygon)\n",
       "\n",
       "This dataset was curated and brought to Azure by [CarbonPlan](https://carbonplan.org/).\n",
       " </td></tr>\n",
       "                \n",
       "                \n",
       "    \n",
       "    \n",
       "        <tr><td style=\"text-align: left;\"><strong>Providers:</strong>\n",
       "        <ul>\n",
       "        \n",
       "             <li>\n",
       "\n",
       "<div>\n",
       "    \n",
       "        <a href=\"https://www.fia.fs.fed.us/\"> Forest Inventory & Analysis </a>\n",
       "    \n",
       "    (<i>producer, licensor</i>)\n",
       "    \n",
       "</div>\n",
       "</li>\n",
       "        \n",
       "             <li>\n",
       "\n",
       "<div>\n",
       "    \n",
       "        <a href=\"https://carbonplan.org/\"> CarbonPlan </a>\n",
       "    \n",
       "    (<i>processor</i>)\n",
       "    \n",
       "</div>\n",
       "</li>\n",
       "        \n",
       "             <li>\n",
       "\n",
       "<div>\n",
       "    \n",
       "        <a href=\"https://planetarycomputer.microsoft.com\"> Microsoft </a>\n",
       "    \n",
       "    (<i>host</i>)\n",
       "    \n",
       "</div>\n",
       "</li>\n",
       "        \n",
       "        </ul>\n",
       "        </td></tr>\n",
       "    \n",
       "\n",
       "                \n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>type:</strong> Collection </td></tr>\n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>title:</strong> Forest Inventory and Analysis </td></tr>\n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>assets:</strong> {'guide': {'href': 'https://www.fia.fs.fed.us/library/database-documentation/current/ver80/FIADB%20User%20Guide%20P2_8-0.pdf', 'type': 'application/pdf', 'roles': ['metadata'], 'title': 'Database Description and User Guide'}, 'thumbnail': {'href': 'https://ai4edatasetspublicassets.blob.core.windows.net/assets/pc_thumbnails/fia.png', 'type': 'image/gif', 'title': 'Forest Inventory and Analysis'}, 'geoparquet-items': {'href': 'abfs://items/fia.parquet', 'type': 'application/x-parquet', 'roles': ['stac-items'], 'title': 'GeoParquet STAC items', 'description': \"Snapshot of the collection's STAC items exported to GeoParquet format.\", 'msft:partition_info': {'is_partitioned': False}, 'table:storage_options': {'account_name': 'pcstacitems', 'credential': 'st=2022-10-26T20%3A52%3A11Z&se=2022-11-03T20%3A52%3A11Z&sp=rl&sv=2021-06-08&sr=c&skoid=c85c15d6-d1ae-42d4-af60-e2ca0f81359b&sktid=72f988bf-86f1-41af-91ab-2d7cd011db47&skt=2022-10-27T20%3A52%3A10Z&ske=2022-11-03T20%3A52%3A10Z&sks=b&skv=2021-06-08&sig=b%2BnRXutS3qkpDV7z7xr5dzvWHMId7iio9xlOjQ9iM7w%3D'}}} </td></tr>\n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>keywords:</strong> ['Forest', 'Species', 'Carbon', 'Biomass', 'USDA', 'Forest Service'] </td></tr>\n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>providers:</strong> [{'url': 'https://www.fia.fs.fed.us/', 'name': 'Forest Inventory & Analysis', 'roles': ['producer', 'licensor']}, {'url': 'https://carbonplan.org/', 'name': 'CarbonPlan', 'roles': ['processor']}, {'url': 'https://planetarycomputer.microsoft.com', 'name': 'Microsoft', 'roles': ['host']}] </td></tr>\n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>item_assets:</strong> {'data': {'type': 'application/x-parquet', 'roles': ['data'], 'title': 'Dataset root', 'table:storage_options': {'account_name': 'cpdataeuwest'}}} </td></tr>\n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>table:tables:</strong> [{'name': 'Survey Table', 'description': 'Survey table. This table contains one record for each year an inventory is conducted in a State for annual inventory or one record for each periodic inventory. <br><br>* SURVEY.CN = PLOT.SRV_CN links the unique inventory record for a State and year to the plot records.', 'msft:item_name': 'survey'}, {'name': 'County Table', 'description': 'County table. This table contains survey unit codes and is also a reference table for the county codes and names. <br><br>* COUNTY.CN = PLOT.CTY_CN links the unique county record to the plot record.', 'msft:item_name': 'county'}, {'name': 'Plot Table', 'description': 'Plot table. This table provides information relevant to the entire 1-acre field plot. This table links to most other tables, and the linkage is made using PLOT.CN = TABLE_NAME.PLT_CN (TABLE_NAME is the name of any table containing the column name PLT_CN). Below are some examples of linking PLOT to other tables. <br><br>* PLOT.CN = COND.PLT_CN links the unique plot record to the condition class record(s). <br><br>* PLOT.CN = SUBPLOT.PLT_CN links the unique plot record to the subplot records. <br><br>* PLOT.CN = TREE.PLT_CN links the unique plot record to the tree records. <br><br>* PLOT.CN = SEEDLING.PLT_CN links the unique plot record to the seedling records.', 'msft:item_name': 'plot'}, {'name': 'Condition Table', 'description': 'Condition table. This table provides information on the discrete combination of landscape attributes that define the condition (a condition will have the same land class, reserved status, owner group, forest type, stand-size class, regeneration status, and stand density). <br><br>* PLOT.CN = COND.PLT_CN links the condition class record(s) to the plot table. <br><br>* COND.PLT_CN = SITETREE.PLT_CN and COND.CONDID = SITETREE.CONDID links the condition class record to the site tree data. <br><br>* COND.PLT_CN = TREE.PLT_CN and COND.CONDID = TREE.CONDID links the condition class record to the tree data.', 'msft:item_name': 'cond'}, {'name': 'Subplot Table', 'description': 'Subplot table. This table describes the features of a single subplot. There are multiple subplots per 1-acre field plot and there can be multiple conditions sampled on each subplot. <br><br>* PLOT.CN = SUBPLOT.PLT_CN links the unique plot record to the subplot records. <br><br>* SUBPLOT.PLT_CN = COND.PLT_CN and SUBPLOT.MACRCOND = COND.CONDID links the macroplot conditions to the condition class record. <br><br>* SUBPLOT.PLT_CN = COND.PLT_CN and SUBPLOT.SUBPCOND = COND.CONDID links the subplot conditions to the condition class record. <br><br>* SUBPLOT.PLT_CN = COND.PLT_CN and SUBPLOT.MICRCOND = COND.CONDID links the microplot conditions to the condition class record.', 'msft:item_name': 'subplot'}, {'name': 'Subplot Condition Table', 'description': 'Subplot condition table. This table contains information about the proportion of a subplot in a condition. <br><br>* PLOT.CN = SUBP_COND.PLT_CN links the subplot condition class record to the plot table. <br><br>* SUBP_COND.PLT_CN = COND.PLT_CN and SUBP_COND.CONDID = COND.CONDID links the condition class records found on the four subplots to the subplot description.', 'msft:item_name': 'subp_cond'}, {'name': 'boundary', 'description': 'Boundary table. This table provides a description of the demarcation line between two conditions that occur on a single subplot', 'msft:item_name': 'boundary'}, {'name': 'Subplot Condition Change Matrix', 'description': 'Subplot condition change matrix table. This table contains information about the mix of current and previous conditions that occupy the same area on the subplot. <br><br>* PLOT.CN = SUBP_COND_CHNG_MTRX.PLT_CN links the subplot condition change matrix records to the unique plot record. <br><br>* PLOT.PREV_PLT_CN = SUBP_COND_CHNG_MTRX.PREV_PLT_CN links the subplot condition change matrix records to the unique previous plot record.', 'msft:item_name': 'subp_cond_chng_mtrx'}, {'name': 'Tree Table', 'description': 'Tree table. This table provides information for each tree 1 inch in diameter and larger found on a microplot, subplot, or core optional macroplot. <br><br>* PLOT.CN = TREE.PLT_CN links the tree records to the unique plot record. <br><br>* COND.PLT_CN = TREE.PLT_CN and COND.CONDID = TREE.CONDID links the tree records to the unique condition record.', 'msft:item_name': 'tree'}, {'name': 'Tree Woodland Stems Table', 'description': 'Tree woodland stems table. This table stores data for the individual stems of a woodland species tree. Individual woodland stem diameter measurements contribute to the calculation of the diameter stored on the parent TREE table record. <br><br>* TREE.CN = TREE_WOODLAND_STEMS.TRE_CN links a woodland stems record to the corresponding unique tree record.', 'msft:item_name': 'tree_woodland_stems'}, {'name': 'Tree Regional Biomass Table', 'description': 'Tree regional biomass table. This table contains biomass estimates computed using equations and methodology that varies by FIA work unit. This table retains valuable information for generating biomass estimates that match earlier published reports. <br><br>* TREE.CN = TREE_REGIONAL_BIOMASS.TRE_CN links a tree regional biomass record to the corresponding unique tree.', 'msft:item_name': 'tree_regional_biomass'}, {'name': 'Tree Net Growth, Removal, and Mortality Component Table', 'description': 'Tree net growth, removal, and mortality component table. This table stores information used to compute net growth, removals, and mortality estimates for remeasurement trees. Each remeasurement tree has a single record in this table. <br><br>* TREE_GRM_COMPONENT.TRE_CN = TREE.TRE_CN links the records in this table to the corresponding tree record in the TREE table.', 'msft:item_name': 'tree_grm_component'}, {'name': 'Tree Net Growth, Removal, and Mortality Midpoint Table', 'description': 'Tree net growth, removal, and mortality midpoint table. This table contains information about a remeasured tree at the midpoint of the remeasurement period. It does not contain a record for every tree. Midpoint estimates are computed for trees that experience mortality, removal, or land use diversion or reversion. The information in this table is used to compute net growth, removal, and mortality estimates on remeasurement trees. <br><br>* TREE_GRM_MIDPT.TRE_CN = TREE.TRE_CN links the records in this table to the corresponding tree record in the TREE table.', 'msft:item_name': 'tree_grm_midpt'}, {'name': 'Tree Net Growth, Removal, and Mortality Begin Table', 'description': 'Tree net growth, removal, and mortality begin table. This table contains information for remeasured trees where values have been calculated for the beginning of the remeasurement period. Only those trees where information was recalculated for time 1 (T1) are included. The information in this table is used to produce net growth, removal and mortality estimates on remeasured trees. <br><br>* TREE_GRM_BEGIN.TRE_CN = TREE.TRE_CN links the records in this table to the corresponding tree record in the TREE table.', 'msft:item_name': 'tree_grm_begin'}, {'name': 'Tree Net Growth, Removal, and Mortality Estimation Table', 'description': 'Tree net growth, removal, and mortality estimation table. This table contains information used to produce estimates of growth, removals and mortality. <br><br>* PLOT.CN = TREE_GRM_ESTN.PLT_CN links the tree GRM estimation records to the unique plot record. <br><br>* TREE.CN = TREE_GRM_ESTN.TRE_CN links the tree GRM estimation records to the unique tree record.', 'msft:item_name': 'tree_grm_estn'}, {'name': 'Seedling Table', 'description': 'Seedling table. This table provides a count of the number of live trees of a species found on a microplot that are less than 1 inch in diameter but at least 6 inches in length for conifer species or at least 12 inches in length for hardwood species. <br><br>* PLOT.CN = SEEDLING.PLT_CN links the seedling records to the unique plot record. <br><br>* COND.PLT_CN = SEEDLING.PLT_CN and COND.CONDID = SEEDLING.CONDID links the condition record to the seedling record.', 'msft:item_name': 'seedling'}, {'name': 'Site Tree Table', 'description': 'Site tree table. This table provides information on the site tree(s) collected in order to calculate site index and/or site productivity information for a condition. <br><br>* PLOT.CN = SITETREE.PLT_CN links the site tree records to the unique plot record. <br><br>* SITETREE.PLT_CN = COND.PLT_CN and SITETREE.CONDID = COND.CONDID links the site tree record(s) to the unique condition class record.', 'msft:item_name': 'sitetree'}, {'name': 'Invasive Subplot Species Table', 'description': 'Invasive subplot species table. This table provides percent cover data of invasive species identified on the subplot. <br><br>* PLOT.CN = INVASIVE_SUBPLOT_SPP.PLT_CN links the invasive subplot species record(s) to the unique plot record. <br><br>* SUBP_COND.PLT_CN = INVASIVE_SUBPLOT_SPP.PLT_CN and SUBP_COND.CONDID = INVASIVE_SUBPLOT_SPP.CONDID and SUBP_COND.SUBP = INVASIVE_SUBPLOT_SPP.SUBP links the invasive subplot species record(s) to the unique subplot condition record. <br><br>* INVASIVE_SUBPLOT_SPP.VEG_SPCD = REF_PLANT_DICTIONARY.SYMBOL links the invasive vegetation subplot NRCS species code to the plant dictionary reference species code.', 'msft:item_name': 'invasive_subplot_spp'}, {'name': 'Phase 2 Vegetation Subplot Species Table', 'description': 'Phase 2 Vegetation subplot species table. This table provides percent cover data of vegetation species identified on the subplot. <br><br>* PLOT.CN = P2VEG_SUBPLOT_SPP.PLT_CN links the vegetation subplot species record(s) to the unique plot record. <br><br>* SUBP_COND.PLT_CN = P2VEG_SUBPLOT_SPP.PLT_CN and SUBP_COND.CONDID = P2VEG_SUBPLOT_SPP.CONDID and SUBP_COND.SUBP = P2VEG_SUBPLOT_SPP.SUBP links the vegetation subplot species record(s) to the unique subplot condition record. <br><br>* P2VEG_SUBPLOT_SPP.VEG_SPCD = REF_PLANT_DICTIONARY.SYMBOL links the P2 vegetation subplot NRCS species code to the plant dictionary reference species code.', 'msft:item_name': 'p2veg_subplot_spp'}, {'name': 'Phase 2 Vegetation Subplot Structure Table', 'description': 'Phase 2 Vegetation subplot structure table. This table provides percent cover by layer by growth habit. <br><br>* PLOT.CN = P2VEG_SUBP_STRUCTURE. PLT_CN links the subplot structure record(s) to the unique plot record. <br><br>* SUBP_COND.PLT_CN = P2VEG_SUBP_STRUCTURE.PLT_CN and SUBP_COND.CONDID = P2VEG_SUBP_STRUCTURE.CONDID and SUBP_COND.SUBP = P2VEG_SUBP_STRUCTURE.SUBP links the vegetation subplot structure record(s) to the unique subplot condition record.', 'msft:item_name': 'p2veg_subp_structure'}, {'name': 'Down Woody Material Visit Table', 'description': 'Down woody material visit table. This table provides general information on down woody material indicator visit, such as the date of the DWM survey. <br><br>* PLOT.CN = DWM_VISIT.PLT_CN links the down woody material indicator visit record to the unique plot record.', 'msft:item_name': 'dwm_visit'}, {'name': 'Down Woody Material Coarse Woody Debris Table', 'description': 'Down woody material coarse woody debris table. This table provides information for each piece of coarse woody debris measured along the transects. <br><br>* PLOT.CN = DWM_COARSE_WOODY_DEBRIS.PLT_CN links the down woody material coarse woody debris records to the unique plot record. <br><br>* COND.PLT_CN = DWM_COARSE_WOODY_DEBRIS.PLT_CN and COND.CONDID= DWM_COARSE_WOODY_DEBRIS.CONDID links the coarse woody debris records to the unique condition record.', 'msft:item_name': 'dwm_coarse_woody_debris'}, {'name': 'Down Woody Material Duff, Litter, Fuel Table', 'description': 'Down woody material duff, litter, fuel table. This table provides information on the duff, litter, fuelbed depths measured at a point on the transects. <br><br>* PLOT.CN = DWM_DUFF_LITTER_FUEL.PLT_CN links the duff, litter, fuelbed records to the unique plot record. <br><br>* COND.PLT_CN = DWM_DUFF_LITTER_FUEL.PLT_CN and COND.CONDID= DWM_DUFF_LITTER_FUEL.CONDID links the duff, litter, fuel records to the unique condition record.', 'msft:item_name': 'dwm_duff_litter_fuel'}, {'name': 'Down Woody Material Fine Woody Debris Table', 'description': 'Down woody material fine woody debris table. This table provides information on the fine woody debris measured along a segment of the transects. <br><br>* PLOT.CN = DWM_FINE_WOODY_DEBRIS.PLT_CN links the fine woody debris records to the unique plot record. <br><br>* COND.PLT_CN = DWM_FINE_WOODY_DEBRIS.PLT_CN and COND.CONDID= DWM_FINE_WOODY_DEBRIS.CONDID links the fine woody debris records to the unique condition record.', 'msft:item_name': 'dwm_fine_woody_debris'}, {'name': 'Down Woody Material Microplot Fuel Table', 'description': 'Down woody material microplot fuel table. This table provides information on the fuel loads (shrubs and herbs) measured on the microplot. <br><br>* PLOT.CN = DWM_MICROPLOT_FUEL.PLT_CN links the microplot fuel records to the unique plot record.', 'msft:item_name': 'dwm_microplot_fuel'}, {'name': 'Down Woody Material Residual Pile Table', 'description': 'Down woody material residual pile table. This table provides information on the wood piles measured on the subplot. <br><br>* PLOT.CN = DWM_RESIDUAL_PILE.PLT_CN links the wood piles records to the unique plot record. <br><br>* COND.PLT_CN = DWM_RESIDUAL_PILE.PLT_CN and COND.CONDID= DWM_RESIDUAL_PILE.CONDID links the wood piles records to the unique condition record.', 'msft:item_name': 'dwm_residual_pile'}, {'name': 'Down Woody Material Transect Segment Table', 'description': 'Down woody material transect segment table. This table describes the down woody material transect segment lengths by condition class. <br><br>* PLOT.CN = DWM_TRANSECT_SEGMENT.PLT_CN links the down woody material transect length records to the unique plot record. <br><br>* COND.PLT_CN = DWM_TRANSECT_SEGMENT.PLT_CN and COND.CONDID= DWM_TRANSECT_SEGMENT.CONDID links the down woody material transect segment records to the unique condition record.', 'msft:item_name': 'dwm_transect_segment'}, {'name': 'Condition Down Woody Material Calculation Table', 'description': 'Condition down woody material calculation table. This table contains calculated values and condition-level estimates for down woody attributes by plot number (PLOT), condition class number (CONDID), and evaluation identifier (EVALID). <br><br>* PLOT.CN = COND_DWM_CALC.PLT_CN links the down woody material calculation records to the unique plot record. <br><br>* COND.CN = COND_DWM_CALC.CND_CN links the down woody material calculation records to the unique condition record. <br><br>* POP_STRATUM. CN = COND_DWM_CALC.STRATUM_CN links the down woody material calculation records to the unique population stratum record.', 'msft:item_name': 'cond_dwm_calc'}, {'name': 'Plot Regeneration Table', 'description': 'Plot regeneration table. This table contains the information for the four subplots describing the amount of animal browse pressure exerted on the regeneration of trees. <br><br>* PLOT.CN = PLOT_REGEN.PLT_CN links the unique plot record to the unique plot regeneration record.', 'msft:item_name': 'plot_regen'}, {'name': 'Subplot Regeneration Table', 'description': 'Subplot regeneration table. This table provides information on the subplot survey status and the site survey limitations, if any, for the tree regeneration study. <br><br>* PLOT.CN = SUBPLOT_REGEN.PLT_CN links the unique plot record to the subplot regeneration records. <br><br>* SUBPLOT.PLT_CN = SUBPLOT_REGEN.PLT_CN and SUBPLOT.SUBP = SUBPLOT_REGEN.SUBP links the subplot record to the subplot regeneration record.', 'msft:item_name': 'subplot_regen'}, {'name': 'Seedling Regeneration Table', 'description': 'Seedling regeneration. This table contains provides information on the seedling count by condition, species, source, and length class for the tree regeneration study. <br><br>* PLOT.CN = SEEDLING_REGEN.PLT_CN links the unique plot record to the seedling regeneration records. <br><br>* COND.PLT_CN = SEEDLING_REGEN.PLT_CN and COND.CONDID = SEEDLING_REGEN.CONDID links the regeneration seedling records to the unique condition record.', 'msft:item_name': 'seedling_regen'}, {'name': 'Population Estimation Unit Table', 'description': 'Population estimation unit table. This table contains information about estimation units. An estimation unit is a geographic area that can be drawn on a map. It has a known area, and the sampling intensity must be the same within a stratum within an estimation unit. Generally, estimation units are contiguous areas, but exceptions are made when certain ownerships, usually National Forests, are sampled at different intensities. One record in the POP_ESTN_UNIT table corresponds to a single estimation unit. POP_ESTN_UNIT.CN = POP_STRATUM.ESTN_UNIT_CN links the unique stratified geographical area (ESTN_UNIT) to the strata (STRATUMCD) that are assigned to each ESTN_UNIT.', 'msft:item_name': 'pop_estn_unit'}, {'name': 'Population Evaluation Table', 'description': 'Population evaluation table. This table provides information about evaluations. An evaluation is the combination of a set of plots (the sample) and a set of Phase 1 data (obtained through remote sensing, called a stratification) that can be used to produce population estimates for a State (an evaluation may be created to produce population estimates for a region other than a State, such as the Black Hills National Forest). A record in the POP_EVAL table identifies one evaluation and provides some descriptive information about how the evaluation may be used. <br><br>* POP_ESTN_UNIT.EVAL_CN = POP_EVAL.CN links the unique evaluation identifier (EVALID) in the POP_EVAL table to the unique geographical areas (ESTN_UNIT) that are stratified. Within a population evaluation (EVALID) there can be multiple population estimation units, or geographic areas across which there are a number of values being estimated (e.g., estimation of volume across counties for a given State).', 'msft:item_name': 'pop_eval'}, {'name': 'Population Evaluation Attribute Table', 'description': 'Population evaluation attribute table. This table provides information as to which population estimates can be provided by an evaluation. If an evaluation can produce only 22 of all the population estimates in the REF_POP_ATTRIBUTE table, there will be 22 records in the POP_EVAL_ATTRIBUTE table (one per population estimate) for that evaluation. <br><br>* POP_EVAL.CN = POP_EVAL_ATTRIBUTE.EVAL_CN links the unique evaluation identifier to the list of population estimates that can be derived for that evaluation.', 'msft:item_name': 'pop_eval_attribute'}, {'name': 'Population Evaluation Group Table', 'description': 'Population evaluation group table. This table lists and describes the evaluation groups. One record in the POP_EVAL_GRP table can be linked to all the evaluations that were used in generating estimates for a State inventory report. <br><br>* POP_EVAL_GRP.CN = POP_EVAL_TYP.EVAL_GRP_CN links the evaluation group record to the evaluation type record.', 'msft:item_name': 'pop_eval_grp'}, {'name': 'Population Evaluation Type Table', 'description': 'Population evaluation type table. This table provides information on the type of evaluations that were used to generate a set of tables for an inventory report. In a typical State inventory report, one evaluation is used to generate an estimate of the total land area; a second evaluation is used to generate current estimates of volume, numbers of trees and biomass; and a third evaluation is used for estimating growth, removals and mortality. <br><br>* POP_EVAL_TYP.EVAL_CN = POP_EVAL.CN links the evaluation type record to the evaluation record. <br><br>* POP_EVAL_TYP.EVAL_GRP_CN = POP_EVAL_GRP.CN links the evaluation type record to the evaluation group record. <br><br>* POP_EVAL_TYP.EVAL_TYP = REF_POP_EVAL_TYP_DESCR.EVAL_TYP links an evaluation type record to an evaluation type description reference record.', 'msft:item_name': 'pop_eval_typ'}, {'name': 'Population Plot Stratum Assignment Table', 'description': \"Population plot stratum assignment table. This table provides a way to assign stratum information to a plot. Stratum information is assigned to a plot by overlaying the plot's location on the Phase 1 imagery. Plots are linked to their appropriate stratum for an evaluation via the POP_PLOT_STRATUM_ASSGN table. <br><br>* POP_PLOT_STRATUM_ASSGN.PLT_CN = PLOT.CN links the stratum assigned to the plot record.\", 'msft:item_name': 'pop_plot_stratum_assgn'}, {'name': 'Population Stratum Table', 'description': 'Population stratum table. This table provides information about individual strata. The area within an estimation unit is divided into strata. The area for each stratum can be calculated by determining the proportion of Phase 1 pixels/plots in each stratum and multiplying that proportion by the total area in the estimation unit. Information for a single stratum is stored in a single record of the POP_STRATUM table. <br><br>* POP_STRATUM.CN = POP_PLOT_STRATUM_ASSGN.STRATUM_CN links the defined stratum to each plot.', 'msft:item_name': 'pop_stratum'}, {'name': 'Plot Geometry Table', 'description': 'Plot geometry table. This table contains geometric attributes associated with the plot location, such as the hydrological unit and roadless codes. <br><br>* PLOTGEOM.CN = PLOT.CN links the unique plot record between the two tables.', 'msft:item_name': 'plotgeom'}, {'name': 'Plot Snapshot Table', 'description': 'Plot snapshot table. This table combines the information in the PLOT table with information in the PLOT_EVAL_GRP and POP_STRATUM tables to provide a snapshot of the plot records with their associated expansion and adjustment factors. <br><br>* PLOTSNAP.CN = PLOT.CN links the unique plot record between the two tables.', 'msft:item_name': 'plotsnap'}] </td></tr>\n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>msft:container:</strong> cpdata </td></tr>\n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>stac_extensions:</strong> ['https://stac-extensions.github.io/item-assets/v1.0.0/schema.json', 'https://stac-extensions.github.io/table/v1.2.0/schema.json'] </td></tr>\n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>msft:storage_account:</strong> cpdataeuwest </td></tr>\n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>msft:short_description:</strong> Status and trends on U.S. forest location, health, growth, mortality, and production, from the U.S. Forest Service's Forest Inventory and Analysis (FIA) program </td></tr>\n",
       "        \n",
       "    \n",
       "            </table>\n",
       "            \n",
       "        <details>\n",
       "            <summary style=\"margin-bottom: 10px; margin-top: 10px;\">\n",
       "                <h4 style=\"margin-bottom: 0px; display: inline;\">STAC Extensions</h4>\n",
       "            </summary>\n",
       "            <table style=\"width: 100%; text-align: left;\">\n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><a href=\"https://stac-extensions.github.io/item-assets/v1.0.0/schema.json\">https://stac-extensions.github.io/item-assets/v1.0.0/schema.json</a></td></tr>\n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><a href=\"https://stac-extensions.github.io/table/v1.2.0/schema.json\">https://stac-extensions.github.io/table/v1.2.0/schema.json</a></td></tr>\n",
       "                \n",
       "            </table>\n",
       "        </details>\n",
       "    \n",
       "            \n",
       "            \n",
       "        <details>\n",
       "            <summary style=\"margin-bottom: 10px; margin-top: 10px\">\n",
       "                <h4 style=\"margin-bottom: 0px; display: inline;\">Items</h4>\n",
       "            </summary>\n",
       "            <i> Only the first item shown </i>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #DBF5FF;\n",
       "        border: 3px solid #4CC9FF;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div>\n",
       "        <details style=\"margin-left: 48px;\">\n",
       "            <summary style=\"margin-bottom: 20px;\">\n",
       "                <h3 style=\"margin-bottom: 0px; display: inline;\">Item: tree_woodland_stems</h3>\n",
       "            </summary>\n",
       "            <table style=\"width: 100%; text-align: left;\">\n",
       "                <tr><td style=\"text-align: left;\"><strong>ID</strong>: tree_woodland_stems </td></tr>\n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Bounding Box:</strong> [-179.14734, -14.53, 179.77847, 71.352561] </td></tr>\n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Datetime:</strong> 2020-06-01 00:00:00+00:00 </td></tr>\n",
       "                \n",
       "                \n",
       "                    \n",
       "                        <tr><td style=\"text-align: left;\"><strong>datetime:</strong> 2020-06-01T00:00:00Z </td></tr>\n",
       "                    \n",
       "                        <tr><td style=\"text-align: left;\"><strong>table:columns:</strong> [{'name': 'CN', 'type': 'int64', 'description': 'Sequence number'}, {'name': 'PLT_CN', 'type': 'int64', 'description': 'Plot sequence number'}, {'name': 'INVYR', 'type': 'int64', 'description': 'Inventory year'}, {'name': 'STATECD', 'type': 'int64', 'description': 'State code'}, {'name': 'UNITCD', 'type': 'int64', 'description': 'Survey unit code'}, {'name': 'COUNTYCD', 'type': 'int64', 'description': 'County code'}, {'name': 'PLOT', 'type': 'int64', 'description': 'Plot number'}, {'name': 'SUBP', 'type': 'int64', 'description': 'Subplot number'}, {'name': 'TREE', 'type': 'int64', 'description': 'Woodland tree number'}, {'name': 'TRE_CN', 'type': 'int64', 'description': 'Tree sequence number'}, {'name': 'DIA', 'type': 'double', 'description': 'Woodland stem diameter'}, {'name': 'STATUSCD', 'type': 'int64', 'description': 'Woodland stem status code'}, {'name': 'STEM_NBR', 'type': 'int64', 'description': 'Woodland stem number'}, {'name': 'CYCLE', 'type': 'int64', 'description': 'Inventory cycle number'}, {'name': 'SUBCYCLE', 'type': 'int64', 'description': 'Inventory subcycle number'}, {'name': 'CREATED_BY', 'type': 'double', 'description': 'Created by'}, {'name': 'CREATED_DATE', 'type': 'byte_array', 'description': 'Created date'}, {'name': 'CREATED_IN_INSTANCE', 'type': 'int64', 'description': 'Created in instance'}, {'name': 'MODIFIED_BY', 'type': 'double', 'description': 'Modified by'}, {'name': 'MODIFIED_DATE', 'type': 'byte_array', 'description': 'Modified date'}, {'name': 'MODIFIED_IN_INSTANCE', 'type': 'double', 'description': 'Modified in instance'}] </td></tr>\n",
       "                    \n",
       "                \n",
       "                \n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>stac_extensions:</strong> ['https://stac-extensions.github.io/table/v1.2.0/schema.json'] </td></tr>\n",
       "        \n",
       "    \n",
       "            </table>\n",
       "            \n",
       "        <details>\n",
       "            <summary style=\"margin-bottom: 10px; margin-top: 10px;\">\n",
       "                <h4 style=\"margin-bottom: 0px; display: inline;\">STAC Extensions</h4>\n",
       "            </summary>\n",
       "            <table style=\"width: 100%; text-align: left;\">\n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><a href=\"https://stac-extensions.github.io/table/v1.2.0/schema.json\">https://stac-extensions.github.io/table/v1.2.0/schema.json</a></td></tr>\n",
       "                \n",
       "            </table>\n",
       "        </details>\n",
       "    \n",
       "            \n",
       "        <details>\n",
       "            <summary style=\"margin-bottom: 10px; margin-top: 10px;\">\n",
       "                <h4 style=\"margin-bottom: 0px; display: inline;\">Assets</h4>\n",
       "            </summary>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #FED7E5;\n",
       "        border: 3px solid #FA4C8C;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div>\n",
       "        <details style=\"margin-left: 48px;\">\n",
       "            <summary style=\"margin-bottom: 20px;\">\n",
       "                <h3 style=\"margin-bottom: 0px; display: inline;\">Asset: Dataset root</h3>\n",
       "            </summary>\n",
       "            <table style=\"width: 100%; text-align: left;\">\n",
       "                <tr><td style=\"text-align: left;\"><strong>href</strong>: abfs://cpdata/raw/fia/tree_woodland_stems.parquet </td></tr>\n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Title:</strong> Dataset root </td></tr>\n",
       "                \n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Media type:</strong> application/x-parquet </td></tr>\n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Roles:</strong> ['data'] </td></tr>\n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Owner:</strong>  </td></tr>\n",
       "                \n",
       "                \n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>table:storage_options:</strong> {'account_name': 'cpdataeuwest', 'credential': 'st=2022-10-26T20%3A52%3A11Z&se=2022-11-03T20%3A52%3A11Z&sp=rl&sv=2021-06-08&sr=c&skoid=c85c15d6-d1ae-42d4-af60-e2ca0f81359b&sktid=72f988bf-86f1-41af-91ab-2d7cd011db47&skt=2022-10-27T20%3A52%3A10Z&ske=2022-11-03T20%3A52%3A10Z&sks=b&skv=2021-06-08&sig=x29ciwiYJBx66xDI4KvuZkktiCNT7kO2eOMbIg5bgYg%3D'} </td></tr>\n",
       "        \n",
       "    \n",
       "            </table>\n",
       "        </details>\n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "        </details>\n",
       "    \n",
       "            \n",
       "        <details>\n",
       "            <summary style=\"margin-bottom: 10px; margin-top: 10px\">\n",
       "                <h4 style=\"margin-bottom: 0px; display: inline;\">Links</h4>\n",
       "            </summary>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #FFF7E5;\n",
       "        border: 3px solid #FF6132;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div style=\"margin-left: 48px;\">\n",
       "        <h4 style=\"margin-bottom: 0px;\">Link: </h4>\n",
       "        \n",
       "        <table style=\"width: 100%; text-align: left;\">\n",
       "            <tr><td style=\"text-align: left;\"><strong>Rel:</strong> collection </td></tr>\n",
       "            <tr><td style=\"text-align: left;\"><strong>Target:</strong> https://planetarycomputer.microsoft.com/api/stac/v1/collections/fia </td></tr>\n",
       "            \n",
       "                <tr><td style=\"text-align: left;\"><strong>Media Type:</strong> application/json </td></tr>\n",
       "            \n",
       "            \n",
       "        </table>\n",
       "        \n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #FFF7E5;\n",
       "        border: 3px solid #FF6132;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div style=\"margin-left: 48px;\">\n",
       "        <h4 style=\"margin-bottom: 0px;\">Link: </h4>\n",
       "        \n",
       "        <table style=\"width: 100%; text-align: left;\">\n",
       "            <tr><td style=\"text-align: left;\"><strong>Rel:</strong> parent </td></tr>\n",
       "            <tr><td style=\"text-align: left;\"><strong>Target:</strong> https://planetarycomputer.microsoft.com/api/stac/v1/collections/fia </td></tr>\n",
       "            \n",
       "                <tr><td style=\"text-align: left;\"><strong>Media Type:</strong> application/json </td></tr>\n",
       "            \n",
       "            \n",
       "        </table>\n",
       "        \n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #FFF7E5;\n",
       "        border: 3px solid #FF6132;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div style=\"margin-left: 48px;\">\n",
       "        <h4 style=\"margin-bottom: 0px;\">Link: </h4>\n",
       "        \n",
       "        <table style=\"width: 100%; text-align: left;\">\n",
       "            <tr><td style=\"text-align: left;\"><strong>Rel:</strong> root </td></tr>\n",
       "            <tr><td style=\"text-align: left;\"><strong>Target:</strong> https://planetarycomputer.microsoft.com/api/stac/v1/ </td></tr>\n",
       "            \n",
       "                <tr><td style=\"text-align: left;\"><strong>Media Type:</strong> application/json </td></tr>\n",
       "            \n",
       "            \n",
       "        </table>\n",
       "        \n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #FFF7E5;\n",
       "        border: 3px solid #FF6132;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div style=\"margin-left: 48px;\">\n",
       "        <h4 style=\"margin-bottom: 0px;\">Link: </h4>\n",
       "        \n",
       "        <table style=\"width: 100%; text-align: left;\">\n",
       "            <tr><td style=\"text-align: left;\"><strong>Rel:</strong> self </td></tr>\n",
       "            <tr><td style=\"text-align: left;\"><strong>Target:</strong> https://planetarycomputer.microsoft.com/api/stac/v1/collections/fia/items/tree_woodland_stems </td></tr>\n",
       "            \n",
       "                <tr><td style=\"text-align: left;\"><strong>Media Type:</strong> application/geo+json </td></tr>\n",
       "            \n",
       "            \n",
       "        </table>\n",
       "        \n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "        </details>\n",
       "    \n",
       "        </details>\n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "        </details>\n",
       "    \n",
       "            \n",
       "        <details>\n",
       "            <summary style=\"margin-bottom: 10px; margin-top: 10px\">\n",
       "                <h4 style=\"margin-bottom: 0px; display: inline;\">Links</h4>\n",
       "            </summary>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #FFF7E5;\n",
       "        border: 3px solid #FF6132;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div style=\"margin-left: 48px;\">\n",
       "        <h4 style=\"margin-bottom: 0px;\">Link: </h4>\n",
       "        \n",
       "        <table style=\"width: 100%; text-align: left;\">\n",
       "            <tr><td style=\"text-align: left;\"><strong>Rel:</strong> items </td></tr>\n",
       "            <tr><td style=\"text-align: left;\"><strong>Target:</strong> https://planetarycomputer.microsoft.com/api/stac/v1/collections/fia/items </td></tr>\n",
       "            \n",
       "                <tr><td style=\"text-align: left;\"><strong>Media Type:</strong> application/geo+json </td></tr>\n",
       "            \n",
       "            \n",
       "        </table>\n",
       "        \n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #FFF7E5;\n",
       "        border: 3px solid #FF6132;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div style=\"margin-left: 48px;\">\n",
       "        <h4 style=\"margin-bottom: 0px;\">Link: </h4>\n",
       "        \n",
       "        <table style=\"width: 100%; text-align: left;\">\n",
       "            <tr><td style=\"text-align: left;\"><strong>Rel:</strong> parent </td></tr>\n",
       "            <tr><td style=\"text-align: left;\"><strong>Target:</strong> https://planetarycomputer.microsoft.com/api/stac/v1/ </td></tr>\n",
       "            \n",
       "                <tr><td style=\"text-align: left;\"><strong>Media Type:</strong> application/json </td></tr>\n",
       "            \n",
       "            \n",
       "        </table>\n",
       "        \n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #FFF7E5;\n",
       "        border: 3px solid #FF6132;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div style=\"margin-left: 48px;\">\n",
       "        <h4 style=\"margin-bottom: 0px;\">Link: </h4>\n",
       "        \n",
       "            <p style=\"color: #9D9D9D; margin-bottom: 0px;\">Microsoft Planetary Computer STAC API</p>\n",
       "        \n",
       "        <table style=\"width: 100%; text-align: left;\">\n",
       "            <tr><td style=\"text-align: left;\"><strong>Rel:</strong> root </td></tr>\n",
       "            <tr><td style=\"text-align: left;\"><strong>Target:</strong> <Client id=microsoft-pc> </td></tr>\n",
       "            \n",
       "                <tr><td style=\"text-align: left;\"><strong>Media Type:</strong> application/json </td></tr>\n",
       "            \n",
       "            \n",
       "        </table>\n",
       "        \n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #FFF7E5;\n",
       "        border: 3px solid #FF6132;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div style=\"margin-left: 48px;\">\n",
       "        <h4 style=\"margin-bottom: 0px;\">Link: </h4>\n",
       "        \n",
       "        <table style=\"width: 100%; text-align: left;\">\n",
       "            <tr><td style=\"text-align: left;\"><strong>Rel:</strong> self </td></tr>\n",
       "            <tr><td style=\"text-align: left;\"><strong>Target:</strong> https://planetarycomputer.microsoft.com/api/stac/v1/collections/fia </td></tr>\n",
       "            \n",
       "                <tr><td style=\"text-align: left;\"><strong>Media Type:</strong> application/json </td></tr>\n",
       "            \n",
       "            \n",
       "        </table>\n",
       "        \n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #FFF7E5;\n",
       "        border: 3px solid #FF6132;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div style=\"margin-left: 48px;\">\n",
       "        <h4 style=\"margin-bottom: 0px;\">Link: </h4>\n",
       "        \n",
       "            <p style=\"color: #9D9D9D; margin-bottom: 0px;\">USDA Open Access Data Use Agreement</p>\n",
       "        \n",
       "        <table style=\"width: 100%; text-align: left;\">\n",
       "            <tr><td style=\"text-align: left;\"><strong>Rel:</strong> license </td></tr>\n",
       "            <tr><td style=\"text-align: left;\"><strong>Target:</strong> https://www.fs.usda.gov/rds/archive/datauseinfo/open </td></tr>\n",
       "            \n",
       "                <tr><td style=\"text-align: left;\"><strong>Media Type:</strong> text/html </td></tr>\n",
       "            \n",
       "            \n",
       "        </table>\n",
       "        \n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #FFF7E5;\n",
       "        border: 3px solid #FF6132;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div style=\"margin-left: 48px;\">\n",
       "        <h4 style=\"margin-bottom: 0px;\">Link: </h4>\n",
       "        \n",
       "            <p style=\"color: #9D9D9D; margin-bottom: 0px;\">Human readable dataset overview and reference</p>\n",
       "        \n",
       "        <table style=\"width: 100%; text-align: left;\">\n",
       "            <tr><td style=\"text-align: left;\"><strong>Rel:</strong> describedby </td></tr>\n",
       "            <tr><td style=\"text-align: left;\"><strong>Target:</strong> https://planetarycomputer.microsoft.com/dataset/fia </td></tr>\n",
       "            \n",
       "                <tr><td style=\"text-align: left;\"><strong>Media Type:</strong> text/html </td></tr>\n",
       "            \n",
       "            \n",
       "        </table>\n",
       "        \n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "        </details>\n",
       "    \n",
       "            \n",
       "    \n",
       "        <details>\n",
       "            <summary style=\"margin-bottom: 10px; margin-top: 10px;\">\n",
       "                <h4 style=\"margin-bottom: 0px; display: inline;\">Assets</h4>\n",
       "            </summary>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #FED7E5;\n",
       "        border: 3px solid #FA4C8C;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div>\n",
       "        <details style=\"margin-left: 48px;\">\n",
       "            <summary style=\"margin-bottom: 20px;\">\n",
       "                <h3 style=\"margin-bottom: 0px; display: inline;\">Asset: Database Description and User Guide</h3>\n",
       "            </summary>\n",
       "            <table style=\"width: 100%; text-align: left;\">\n",
       "                <tr><td style=\"text-align: left;\"><strong>href</strong>: https://www.fia.fs.fed.us/library/database-documentation/current/ver80/FIADB%20User%20Guide%20P2_8-0.pdf </td></tr>\n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Title:</strong> Database Description and User Guide </td></tr>\n",
       "                \n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Media type:</strong> application/pdf </td></tr>\n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Roles:</strong> ['metadata'] </td></tr>\n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Owner:</strong>  </td></tr>\n",
       "                \n",
       "                \n",
       "            </table>\n",
       "        </details>\n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #FED7E5;\n",
       "        border: 3px solid #FA4C8C;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div>\n",
       "        <details style=\"margin-left: 48px;\">\n",
       "            <summary style=\"margin-bottom: 20px;\">\n",
       "                <h3 style=\"margin-bottom: 0px; display: inline;\">Asset: Forest Inventory and Analysis</h3>\n",
       "            </summary>\n",
       "            <table style=\"width: 100%; text-align: left;\">\n",
       "                <tr><td style=\"text-align: left;\"><strong>href</strong>: https://ai4edatasetspublicassets.blob.core.windows.net/assets/pc_thumbnails/fia.png </td></tr>\n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Title:</strong> Forest Inventory and Analysis </td></tr>\n",
       "                \n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Media type:</strong> image/gif </td></tr>\n",
       "                \n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Owner:</strong>  </td></tr>\n",
       "                \n",
       "                \n",
       "            </table>\n",
       "        </details>\n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "                \n",
       "\n",
       "<div class=\"jp-RenderedHTMLCommon jp-RenderedHTML jp-mod-trusted jp-OutputArea-output\">\n",
       "    <div style=\"\n",
       "        width: 24px;\n",
       "        height: 24px;\n",
       "        background-color: #FED7E5;\n",
       "        border: 3px solid #FA4C8C;\n",
       "        border-radius: 5px;\n",
       "        position: absolute;\">\n",
       "    </div>\n",
       "    <div>\n",
       "        <details style=\"margin-left: 48px;\">\n",
       "            <summary style=\"margin-bottom: 20px;\">\n",
       "                <h3 style=\"margin-bottom: 0px; display: inline;\">Asset: GeoParquet STAC items</h3>\n",
       "            </summary>\n",
       "            <table style=\"width: 100%; text-align: left;\">\n",
       "                <tr><td style=\"text-align: left;\"><strong>href</strong>: abfs://items/fia.parquet </td></tr>\n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Title:</strong> GeoParquet STAC items </td></tr>\n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Description:</strong> Snapshot of the collection's STAC items exported to GeoParquet format. </td></tr>\n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Media type:</strong> application/x-parquet </td></tr>\n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Roles:</strong> ['stac-items'] </td></tr>\n",
       "                \n",
       "                \n",
       "                    <tr><td style=\"text-align: left;\"><strong>Owner:</strong>  </td></tr>\n",
       "                \n",
       "                \n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>msft:partition_info:</strong> {'is_partitioned': False} </td></tr>\n",
       "        \n",
       "            <tr><td style=\"text-align: left;\"><strong>table:storage_options:</strong> {'account_name': 'pcstacitems', 'credential': 'st=2022-10-26T20%3A52%3A11Z&se=2022-11-03T20%3A52%3A11Z&sp=rl&sv=2021-06-08&sr=c&skoid=c85c15d6-d1ae-42d4-af60-e2ca0f81359b&sktid=72f988bf-86f1-41af-91ab-2d7cd011db47&skt=2022-10-27T20%3A52%3A10Z&ske=2022-11-03T20%3A52%3A10Z&sks=b&skv=2021-06-08&sig=b%2BnRXutS3qkpDV7z7xr5dzvWHMId7iio9xlOjQ9iM7w%3D'} </td></tr>\n",
       "        \n",
       "    \n",
       "            </table>\n",
       "        </details>\n",
       "    </div>\n",
       "</div>\n",
       "            \n",
       "        </details>\n",
       "    \n",
       "\n",
       "        </details>\n",
       "    </div>\n",
       "</div>"
      ],
      "text/plain": [
       "<CollectionClient id=fia>"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pystac_client\n",
    "import planetary_computer\n",
    "\n",
    "catalog = pystac_client.Client.open(\n",
    "    \"https://planetarycomputer.microsoft.com/api/stac/v1\",\n",
    "    modifier=planetary_computer.sign_inplace,\n",
    ")\n",
    "fia = catalog.get_collection(\"fia\")\n",
    "fia"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d30f8e6a-b67e-4137-b30a-2700470c48fd",
   "metadata": {},
   "source": [
    "The FIA Collection has a number of items, each of which represents a different table stored in Parquet format."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "a35f63f4-1c96-4f84-8ecf-adfd108d27b3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[<Item id=tree_woodland_stems>,\n",
       " <Item id=tree_regional_biomass>,\n",
       " <Item id=tree_grm_midpt>,\n",
       " <Item id=tree_grm_estn>,\n",
       " <Item id=tree_grm_component>,\n",
       " <Item id=tree_grm_begin>,\n",
       " <Item id=tree>,\n",
       " <Item id=survey>,\n",
       " <Item id=subplot_regen>,\n",
       " <Item id=subplot>,\n",
       " <Item id=subp_cond_chng_mtrx>,\n",
       " <Item id=subp_cond>,\n",
       " <Item id=sitetree>,\n",
       " <Item id=seedling_regen>,\n",
       " <Item id=seedling>,\n",
       " <Item id=pop_stratum>,\n",
       " <Item id=pop_plot_stratum_assgn>,\n",
       " <Item id=pop_eval_typ>,\n",
       " <Item id=pop_eval_grp>,\n",
       " <Item id=pop_eval_attribute>,\n",
       " <Item id=pop_eval>,\n",
       " <Item id=pop_estn_unit>,\n",
       " <Item id=plotsnap>,\n",
       " <Item id=plot_regen>,\n",
       " <Item id=plotgeom>,\n",
       " <Item id=plot>,\n",
       " <Item id=p2veg_subp_structure>,\n",
       " <Item id=p2veg_subplot_spp>,\n",
       " <Item id=invasive_subplot_spp>,\n",
       " <Item id=dwm_visit>,\n",
       " <Item id=dwm_transect_segment>,\n",
       " <Item id=dwm_residual_pile>,\n",
       " <Item id=dwm_microplot_fuel>,\n",
       " <Item id=dwm_fine_woody_debris>,\n",
       " <Item id=dwm_duff_litter_fuel>,\n",
       " <Item id=dwm_coarse_woody_debris>,\n",
       " <Item id=county>,\n",
       " <Item id=cond_dwm_calc>,\n",
       " <Item id=cond>,\n",
       " <Item id=boundary>]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(fia.get_all_items())"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "55ba61d3-5a23-4539-8f2d-453153ee19a3",
   "metadata": {},
   "source": [
    "To load a single table, get it's item and extract the `href` from the `data` asset. The \"boundary\" table, which provides information about subplots, is relatively small and doesn't contain a geospatial geometry column, so it can be read with pandas."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "82e0ddc0-0236-479d-b677-2a3048ab34ef",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CN</th>\n",
       "      <th>AZMLEFT</th>\n",
       "      <th>AZMCORN</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>__null_dask_index__</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>204719190010854</td>\n",
       "      <td>259</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>204719188010854</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>204719189010854</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>204719192010854</td>\n",
       "      <td>322</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>204719191010854</td>\n",
       "      <td>325</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  CN  AZMLEFT  AZMCORN\n",
       "__null_dask_index__                                   \n",
       "0                    204719190010854      259        0\n",
       "1                    204719188010854       33        0\n",
       "2                    204719189010854       52        0\n",
       "3                    204719192010854      322        0\n",
       "4                    204719191010854      325        0"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import planetary_computer\n",
    "\n",
    "boundary = fia.get_item(id=\"boundary\")\n",
    "asset = boundary.assets[\"data\"]\n",
    "\n",
    "df = pd.read_parquet(\n",
    "    asset.href,\n",
    "    storage_options=asset.extra_fields[\"table:storage_options\"],\n",
    "    columns=[\"CN\", \"AZMLEFT\", \"AZMCORN\"],\n",
    ")\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4c756397-e4af-4434-b363-e9f1ff817e57",
   "metadata": {},
   "source": [
    "There are a few imporant pieces to highlight\n",
    "\n",
    "1. As usual with the Planetary Computer, we signed the STAC item so that we could access the data. See [Using tokens for data access](https://planetarycomputer.microsoft.com/docs/concepts/sas/) for more.\n",
    "2. We relied on the asset to provide all the information necessary to load the data like the `href` and the `storage_options`. All we needed to know was the ID of the Collection and Item\n",
    "3. We used pandas' and parquet's ability to select subsets of the data with the `columns` keyword."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "lucky-murray",
   "metadata": {},
   "source": [
    "Larger datasets can be read using [Dask](https://dask.org/). For example, the `cpdata/raw/fia/tree.parquet` folder contains about 160 individual Parquet files, totalling about 22 million rows. In this case, pass the path to the directory to `dask.dataframe.read_parquet`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "demonstrated-crossing",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><strong>Dask DataFrame Structure:</strong></div>\n",
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SPCD</th>\n",
       "      <th>CARBON_BG</th>\n",
       "      <th>CARBON_AG</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>npartitions=160</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <td>int64</td>\n",
       "      <td>float64</td>\n",
       "      <td>float64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>\n",
       "<div>Dask Name: read-parquet, 1 graph layer</div>"
      ],
      "text/plain": [
       "Dask DataFrame Structure:\n",
       "                  SPCD CARBON_BG CARBON_AG\n",
       "npartitions=160                           \n",
       "                 int64   float64   float64\n",
       "                   ...       ...       ...\n",
       "...                ...       ...       ...\n",
       "                   ...       ...       ...\n",
       "                   ...       ...       ...\n",
       "Dask Name: read-parquet, 1 graph layer"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import dask.dataframe as dd\n",
    "\n",
    "tree = fia.get_item(id=\"tree\")\n",
    "asset = tree.assets[\"data\"]\n",
    "\n",
    "df = dd.read_parquet(\n",
    "    asset.href,\n",
    "    storage_options=asset.extra_fields[\"table:storage_options\"],\n",
    "    columns=[\"SPCD\", \"CARBON_BG\", \"CARBON_AG\"],\n",
    "    engine=\"pyarrow\",\n",
    ")\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "miniature-frequency",
   "metadata": {},
   "source": [
    "That lazily loads the data into a Dask DataFrame. We can operate on the DataFrame with pandas-like methods, and call `.compute()` to get the result. In this case, we'll compute the average amount of carbon sequestered above and below ground for each tree, grouped by species type. To cut down on execution time we'll select just the first partition."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "political-discovery",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CARBON_BG</th>\n",
       "      <th>CARBON_AG</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SPCD</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>37.864937</td>\n",
       "      <td>165.753430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>3.549734</td>\n",
       "      <td>14.679764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>9.071253</td>\n",
       "      <td>39.108406</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>19.321549</td>\n",
       "      <td>84.096184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>29.964395</td>\n",
       "      <td>130.956288</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>4.632913</td>\n",
       "      <td>22.658887</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975</th>\n",
       "      <td>38.988846</td>\n",
       "      <td>202.220124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>976</th>\n",
       "      <td>25.385733</td>\n",
       "      <td>130.583668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>12.570365</td>\n",
       "      <td>64.712301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>5.072137</td>\n",
       "      <td>25.477134</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      CARBON_BG   CARBON_AG\n",
       "SPCD                       \n",
       "43    37.864937  165.753430\n",
       "67     3.549734   14.679764\n",
       "68     9.071253   39.108406\n",
       "107   19.321549   84.096184\n",
       "110   29.964395  130.956288\n",
       "...         ...         ...\n",
       "973    4.632913   22.658887\n",
       "975   38.988846  202.220124\n",
       "976   25.385733  130.583668\n",
       "993   12.570365   64.712301\n",
       "999    5.072137   25.477134\n",
       "\n",
       "[100 rows x 2 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result = df.get_partition(0).groupby(\"SPCD\").mean().compute()  # group by species\n",
    "result"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0d1ef70b-3a26-4d0c-b46f-5a3325182456",
   "metadata": {},
   "source": [
    "### Geospatial parquet datasets\n",
    "\n",
    "The `us-census` collection has some items that include a `geometry` column, and so can be loaded with `geopandas`. All parquet datasets hosted by the Planetary Computer with one or more geospatial columns use the [geoparquet](https://github.com/opengeospatial/geoparquet) standard for encoding the geospatial metadata."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "8e2ef56c-164e-4450-867b-bf7c05ea86a8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>STATEFP</th>\n",
       "      <th>STATENS</th>\n",
       "      <th>AFFGEOID</th>\n",
       "      <th>GEOID</th>\n",
       "      <th>STUSPS</th>\n",
       "      <th>NAME</th>\n",
       "      <th>LSAD</th>\n",
       "      <th>ALAND</th>\n",
       "      <th>AWATER</th>\n",
       "      <th>geometry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>66</td>\n",
       "      <td>1802705</td>\n",
       "      <td>0400000US66</td>\n",
       "      <td>66</td>\n",
       "      <td>GU</td>\n",
       "      <td>Guam</td>\n",
       "      <td>00</td>\n",
       "      <td>543555847</td>\n",
       "      <td>934337453</td>\n",
       "      <td>MULTIPOLYGON (((144.64538 13.23627, 144.64716 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>48</td>\n",
       "      <td>1779801</td>\n",
       "      <td>0400000US48</td>\n",
       "      <td>48</td>\n",
       "      <td>TX</td>\n",
       "      <td>Texas</td>\n",
       "      <td>00</td>\n",
       "      <td>676680588914</td>\n",
       "      <td>18979352230</td>\n",
       "      <td>MULTIPOLYGON (((-94.71830 29.72885, -94.71721 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>55</td>\n",
       "      <td>1779806</td>\n",
       "      <td>0400000US55</td>\n",
       "      <td>55</td>\n",
       "      <td>WI</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>00</td>\n",
       "      <td>140292246684</td>\n",
       "      <td>29343721650</td>\n",
       "      <td>MULTIPOLYGON (((-86.95617 45.35549, -86.95463 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>44</td>\n",
       "      <td>1219835</td>\n",
       "      <td>0400000US44</td>\n",
       "      <td>44</td>\n",
       "      <td>RI</td>\n",
       "      <td>Rhode Island</td>\n",
       "      <td>00</td>\n",
       "      <td>2677759219</td>\n",
       "      <td>1323691129</td>\n",
       "      <td>MULTIPOLYGON (((-71.28802 41.64558, -71.28647 ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>36</td>\n",
       "      <td>1779796</td>\n",
       "      <td>0400000US36</td>\n",
       "      <td>36</td>\n",
       "      <td>NY</td>\n",
       "      <td>New York</td>\n",
       "      <td>00</td>\n",
       "      <td>122049520861</td>\n",
       "      <td>19256750161</td>\n",
       "      <td>MULTIPOLYGON (((-72.03683 41.24984, -72.03496 ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  STATEFP  STATENS     AFFGEOID GEOID STUSPS          NAME LSAD         ALAND  \\\n",
       "0      66  1802705  0400000US66    66     GU          Guam   00     543555847   \n",
       "1      48  1779801  0400000US48    48     TX         Texas   00  676680588914   \n",
       "2      55  1779806  0400000US55    55     WI     Wisconsin   00  140292246684   \n",
       "3      44  1219835  0400000US44    44     RI  Rhode Island   00    2677759219   \n",
       "4      36  1779796  0400000US36    36     NY      New York   00  122049520861   \n",
       "\n",
       "        AWATER                                           geometry  \n",
       "0    934337453  MULTIPOLYGON (((144.64538 13.23627, 144.64716 ...  \n",
       "1  18979352230  MULTIPOLYGON (((-94.71830 29.72885, -94.71721 ...  \n",
       "2  29343721650  MULTIPOLYGON (((-86.95617 45.35549, -86.95463 ...  \n",
       "3   1323691129  MULTIPOLYGON (((-71.28802 41.64558, -71.28647 ...  \n",
       "4  19256750161  MULTIPOLYGON (((-72.03683 41.24984, -72.03496 ...  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import geopandas\n",
    "\n",
    "item = catalog.get_collection(\"us-census\").get_item(\"2020-cb_2020_us_state_500k\")\n",
    "\n",
    "asset = item.assets[\"data\"]\n",
    "df = geopandas.read_parquet(\n",
    "    asset.href, storage_options=asset.extra_fields[\"table:storage_options\"]\n",
    ")\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1f698385-2434-47e7-b5a4-5d4ff887e4de",
   "metadata": {},
   "source": [
    "With this, we can visualize the boundaries for the continental United States."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "bb16c54d-c0ec-4676-8031-c94b34ce1655",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<img src=\"https://ai4edatasetspublicassets.blob.core.windows.net/assets/notebook-output/quickstarts-reading-tabular-data.ipynb/7.png\"/>"
      ],
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import contextily\n",
    "\n",
    "drop = [\"GU\", \"AK\", \"MP\", \"HI\", \"VI\", \"PR\", \"AS\"]\n",
    "ax = df[~df.STUSPS.isin(drop)].plot()\n",
    "contextily.add_basemap(ax, crs=df.crs.to_string())"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "explicit-novelty",
   "metadata": {},
   "source": [
    "### Learn more\n",
    "\n",
    "This quickstart briefly introduced how to access tabular data on the Planetary Computer. For more, see\n",
    "\n",
    "* The [pandas documentation](https://pandas.pydata.org/docs/user_guide/io.html#parquet) for an introduction to Parquet\n",
    "* [Scale with Dask](https://planetarycomputer.microsoft.com/docs/quickstarts/scale-with-dask/) for more on using Dask to work with large datasets in parallel\n",
    "* The [Forest Inventory and Analysis](https://planetarycomputer.microsoft.com/dataset/fia) catalog page."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.6"
  },
  "widgets": {
   "application/vnd.jupyter.widget-state+json": {
    "state": {},
    "version_major": 2,
    "version_minor": 0
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}