Notes on shapefiles

Import

srid: 900921
grid: 12US1 / us12k_516x444

All files get loaded with ogr2ogr with the following options:

-lco PRECISION=NO (use types FLOAT8, INTEGER and VARCHAR instead of NUMERIC(width,precision) or CHAR(width))
-nlt PROMOTE_TO_MULTI (automatically promote layers that mix polygon or multipolygons to multipolygons, and layers that mix linestrings or multilinestrings to multilinestrings)
-nln $schema.$table (sets table name)
-overwrite (delete existing and recreate)

$table is the shapefile name converted to lowercase

Once the shapefile is loaded, a new field called geom_${srid} is created, transforming the geometry to the grid projection.

If attribute is set, and geometry type is MultiPolygon, area and density columns are created automatically.

2016

Directory (emiss_shp2016)	Name	Geom Type	Attribute	Notes
Census	cb_2014_us_county_500k_Poly	MultiPolygon
Census	ACS_2014_5YR_PopHousing	MultiPolygon		add density columns
HPMS	hpms2016	MultiLineString		alter column moves2014 change FIPS 46102 to 46113 add columns length_900921, aadt_dens
PIL	pil_2019_06_24	MultiPoint
2010	ERTAC_railyard_WRF	MultiPoint
NTAD	NTAD_2014_County_Pol	MultiPolygon
NTAD	NTAD_2014_ipcd	MultiPoint
NTAD	NTAD_2014_Rail	MultiLineString		add column geoid=concat(statefips, cntyfips)
NTAD	NTAD_2014_Waterway	MultiLineString	length
NLCD	CONUS_AK_NLCD_2011_500m_WGS
TIGER	TIGER_2014_Rail	MultiLineString
EIA	EIA_2015_US_Oil	MultiPoint
USGS	USGS_2011_mines	MultiPoint
POI	POI_Factory_2015_GolfCourses	MultiPoint		file is POI-Factory_2015_GolfCourses
US	US_Airports_NEI08v2_WRF	MultiPoint	total_emis
US	airport_area	MultiPolygon	area
CMV	CMV_2013_Vessel_Density_CONUS1km	MultiPolygon	mean
USFS	USFS_2016_TimberHarvest	MultiPolygon
OilGas	AllExploratoryWells	MultiPolygon	TOTAL_EX_1
OilGas	AllProductionWells	MultiPolygon	TOTAL_PR_1
OilGas	AllWells	MultiPolygon	TOTAL_WE_1
OilGas	AssocGasProduction	MultiPolygon	ASSOCIAT_1
OilGas	CBMProduction	MultiPolygon	CBM_PROD_1
OilGas	CBMWell_Counts	MultiPolygon	CBM_WELLS1
OilGas	Completions_All	MultiPolygon	COMPLETI_1
OilGas	Completions_CBM	MultiPolygon	COMPLETI_1
OilGas	Completions_Oil	MultiPolygon	COMPLETI_1
OilGas	CondensateCBMProd	MultiPolygon	CONDENSA_1
OilGas	CondensateGasProd	MultiPolygon	CONDENSA_1
OilGas	FeetDrilled_All	MultiPolygon	FEET_DRI_1
OilGas	GasProduction	MultiPolygon	GAS_PROD_1
OilGas	Spud_Count_All_20161111	MultiPolygon	SPUD_COU_1
OilGas	GasWell_Counts	MultiPolygon	GAS_WELL_1
OilGas	OilProduction	MultiPolygon	OIL_PROD_1
OilGas	OilWell_Counts_20161111	MultiPolygon	OIL_WELL_1
OilGas	ProducedWater_All	MultiPolygon	PRODUCED_1
OilGas	SpudCount_CBM	MultiPolygon	SPUD_COU_1
OilGas	SpudCount_Gas	MultiPolygon	SPUD_COU_1
OilGas	SpudCount_HF	MultiPolygon	SPUD_HF_21
OilGas	SpudCount_Oil	MultiPolygon	SPUD_COU_1
OilGas	Completions_Gas	MultiPolygon	COMPLETI_1
EPA	ShippingLanes_2014NEI	MultiPolygon		add density columns
EPA	Ports_2014NEI	MultiPolygon		add density columns
LADCO	Cruise_Emissions	MultiPolygon	TOTEMIS	not included in package

2017

Directory (emiss_shp2017)	Name	Geom Type	Attribute	Notes
Census	cb_2017_us_county_500k	MultiPolygon
Census	acs2016_5yr_bg	MultiPolygon		add density columns
FEMA	fema_bsf_2002bnd	MultiPolygon		add various columns
HPMS	hpms2017_v3_04052020	MultiLineString	alter column moves2014 add columns length_900921, aadt_dens
PIL	pil_2019_06_24	MultiPoint
2010	ERTAC_railyard_WRF	MultiPoint
NTAD	NTAD_2016_ipcd	MultiPoint
NTAD	NTAD_d2019_Waterway	MultiLineString	length
NTAD	NTAD_2017_County_Pol	MultiPolygon		created from ntad_2014_county_pol change FIPS 46113 to 46102
NTAD	NTAD_2014_Rail	MultiLineString		add column geoid=concat(statefips, cntyfips)
NLCD	CONUS_AK_NLCD_2011_500m_WGS
TIGER	TIGER_2014_Rail	MultiLineString
EIA	EIA_2015_US_Oil	MultiPoint
USGS	USGS_2011_mines	MultiPoint
POI	usa_golf_courses_2019_10	MultiPoint
US	US_Airports_NEI08v2_WRF	MultiPoint	total_emis
US	airport_area	MultiPolygon	area
CMV	CMV_2013_Vessel_Density_CONUS1km	MultiPolygon	mean
OilGas	AllExploratoryWells	MultiPolygon	TOTAL_EX_1
OilGas	AllProductionWells	MultiPolygon	TOTAL_PR_1
OilGas	AllWells	MultiPolygon	TOTAL_WE_1
OilGas	AssocGasProduction	MultiPolygon	ASSOCIAT_1
OilGas	CBMProduction	MultiPolygon	CBM_PROD_1
OilGas	CBMWell_Counts	MultiPolygon	CBM_WELLS1
OilGas	Completions_All	MultiPolygon	COMPLETI_1
OilGas	Completions_CBM	MultiPolygon	COMPLETI_1
OilGas	Completions_Oil	MultiPolygon	COMPLETI_1
OilGas	CondensateCBMProd	MultiPolygon	CONDENSA_1
OilGas	CondensateGasProd	MultiPolygon	CONDENSA_1
OilGas	FeetDrilled_All	MultiPolygon	FEET_DRI_1
OilGas	GasProduction	MultiPolygon	GAS_PROD_1
OilGas	Spud_Count_All_20161111	MultiPolygon	SPUD_COU_1
OilGas	GasWell_Counts	MultiPolygon	GAS_WELL_1
OilGas	OilProduction	MultiPolygon	OIL_PROD_1
OilGas	OilWell_Counts_20161111	MultiPolygon	OIL_WELL_1
OilGas	ProducedWater_All	MultiPolygon	PRODUCED_1
OilGas	SpudCount_CBM	MultiPolygon	SPUD_COU_1
OilGas	SpudCount_Gas	MultiPolygon	SPUD_COU_1
OilGas	SpudCount_HF	MultiPolygon	SPUD_HF_21
OilGas	SpudCount_Oil	MultiPolygon	SPUD_COU_1
OilGas	Completions_Gas	MultiPolygon	COMPLETI_1
EPA	ShippingLanes_2014NEI	MultiPolygon		add density columns
EPA	Ports_2014NEI	MultiPolygon		add density columns