Walkability Index

U.S. Environmental Protection Agency

@usgov.epa_gov_walkability_index8

Table List

1 table(114.02 MB)

Table 1

@usgov.epa_gov_walkability_index8.table_1

The endpoint of a web service to access the dataset (REST endpoint, WMS GetCapabilities URL, or a SOAP WSDL endpoint).

114.02 MB
220740 rows
117 columns
Only the first 100 columns are shown

objectid OBJECTID	geoid20 GEOID20	statefp STATEFP	countyfp COUNTYFP	tractce TRACTCE	blkgrpce BLKGRPCE	csa CSA	csa_name CSA Name	cbsa CBSA	cbsa_name CBSA Name	cbsa_pop CBSA POP	cbsa_emp CBSA EMP	cbsa_wrk CBSA WRK	ac_total Ac Total	ac_land Ac Land	ac_unpr Ac Unpr	totpop TotPop	p_wrkage P WrkAge	autoown0 AutoOwn0	pct_ao0 Pct AO0	autoown1 AutoOwn1	pct_ao1 Pct AO1	autoown2p AutoOwn2p	pct_ao2p Pct AO2p	workers Workers	r_lowwagewk R LowWageWk	r_medwagewk R MedWageWk	r_hiwagewk R HiWageWk	r_pctlowwage R PCTLOWWAGE	totemp TotEmp	e5_ret E5 Ret	e5_off E5 Off	e5_ind E5 Ind	e5_svc E5 Svc	e5_ent E5 Ent	e8_ret E8 Ret	e8_off E8 Off	e8_ind E8 Ind	e8_svc E8 Svc	e8_ent E8 Ent	e8_ed E8 Ed	e8_hlth E8 Hlth	e_lowwagewk E LowWageWk	e_medwagewk E MedWageWk	e_hiwagewk E HiWageWk	e_pctlowwage E PctLowWage	d1b D1B	d1c D1C	d1c5_ret D1C5 RET	d1c5_off D1C5 OFF	d1c5_ind D1C5 IND	d1c5_svc D1C5 SVC	d1c5_ent D1C5 ENT	d1c8_ret D1C8 RET	d1c8_off D1C8 OFF	d1c8_ind D1C8 IND	d1c8_svc D1C8 SVC	d1c8_ent D1C8 ENT	d1c8_ed D1C8 ED	d1c8_hlth D1C8 HLTH	d1d D1D	d2a_jphh D2A JPHH	d2b_e5mix D2B E5MIX	d2b_e5mixa D2B E5MIXA	d2b_e8mix D2B E8MIX	d2b_e8mixa D2B E8MIXA	d2a_ephhm D2A EPHHM	d2c_trpmx1 D2C TRPMX1	d2c_trpmx2 D2C TRPMX2	d2c_tripeq D2C TRIPEQ	d2r_jobpop D2R JOBPOP	d2r_wrkemp D2R WRKEMP	d2a_wrkemp D2A WRKEMP	d2c_wremlx D2C WREMLX	d3a D3A	d3aao D3AAO	d3amm D3AMM	d3apo D3APO	d3b D3B	d3bao D3BAO	d3bmm3 D3BMM3	d3bmm4 D3BMM4	d3bpo3 D3BPO3	d3bpo4 D3BPO4	d4a D4A	d4b025 D4B025	d4b050 D4B050	d4c D4C	d5ar D5AR	d5ae D5AE
1	481130000000	48	113	7825	4	206	Dallas-Fort Worth, TX-OK	19100	Dallas-Fort Worth-Arlington, TX	7189384	3545715	3364458	73.5950285	73.5950285	73.5950285	1202	0.549	69	0.163120567	39	0.092198582	315	0.744680851	412	99	122	191	0.240291262	66	20	3		19	24	20	3		15	24		4	21	27	18	0.318181818	16.33262497	0.896799707	0.271757487	0.040763623		0.258169613	0.326108984	0.271757487	0.040763623		0.203818115	0.326108984		0.054351497	7.147221908	0.156028369	0.886263937	0.763386204	0.855441777	0.662091432	0.348911599	0.526295799	0.585916036	0.287128311	0.104100946	0.276150628	6.242424242	0.005287423	23.53489981		10.65527725	12.87962256	115.9817473		60.87367709	8.696239584	34.78495833	43.48119792	362.1			4.33	433601	303660
2	481130000000	48	113	7825	2	206	Dallas-Fort Worth, TX-OK	19100	Dallas-Fort Worth-Arlington, TX	7189384	3545715	3364458	119.8299095	119.8299095	119.2142	710	0.466			168	0.410757946	241	0.589242054	395	76	107	212	0.192405063	25	7		3	15		7		3	13			2	10	4	11	0.4	5.955666355	0.209706562	0.058717837		0.025164787	0.125823937		0.058717837		0.025164787	0.109047412			0.016776525	3.640505913	0.061124694	0.835014679	0.569986193	0.831686329	0.554457553	0.197047324	0.24848111	0.271309324	0.00203268	0.068027211	0.119047619	15.8	3.7363e-7	22.89336566	0.755137051	2.859482038	19.27874657	80.14560004	5.340903641	10.68180728	10.68180728	85.45445826	5.340903641	718.84		0.009516414	4.33	386504	272135
3	481130000000	48	113	7825	3	206	Dallas-Fort Worth, TX-OK	19100	Dallas-Fort Worth-Arlington, TX	7189384	3545715	3364458	26.3670526	26.3670526	26.36705	737	0.811	19	0.05775076	143	0.434650456	167	0.507598784	463	136	189	138	0.293736501																		27.95155317														13.84303515									0.367879441		1			14.21050888	6.128365271	2.611429576	5.470714031	24.27271678	24.27271678		24.27271678			398.31			3	404573	288925
4	481130000000	48	113	7824	1	206	Dallas-Fort Worth, TX-OK	19100	Dallas-Fort Worth-Arlington, TX	7189384	3545715	3364458	119.0606872	119.0606872	119.0606872	904	0.638			43	0.111979167	341	0.888020833	431	60	69	302	0.139211137	253	26		25	47	155	26		25	3	155	2	42	121	87	45	0.47826087	7.592766523	2.124966737	0.218376028		0.20997695	0.394756667	1.301857092	0.218376028		0.20997695	0.025197234	1.301857092	0.016798156	0.352761277	5.350212694	0.658854167	0.775740273	0.668186301	0.642753699	0.553831403	0.682829823	0.620718568	0.677942635	0.59635098	0.437337943	0.739766082	1.703557312	0.494821933	32.17837344	2.208593582	9.323546717	20.64623315	141.6044237	21.50163971	21.50163971	32.25245957	134.3852482	5.375409928	386.24		0.515376911	6.67	423099	298058
5	481130000000	48	113	7824	2	206	Dallas-Fort Worth, TX-OK	19100	Dallas-Fort Worth-Arlington, TX	7189384	3545715	3364458	169.9272106	169.9272106	148.74292	948	0.506	5	0.014577259	67	0.195335277	271	0.790087464	579	91	84	404	0.15716753	32		2	10	20			2	10	19			1	6	9	17	0.1875	6.373412597	0.21513629		0.013446018	0.067230091	0.134460181			0.013446018	0.067230091	0.127737172			0.006723009	2.521128401	0.093294461	0.755975243	0.516033383	0.688595255	0.459063503	0.261471982	0.247735303	0.258986283	0.007902649	0.065306122	0.104746318	18.09375	3.76946e-8	22.05865085	2.289659156	3.176070291	16.5929214	65.3079631	3.766318518		7.532637036	75.32637036	7.532637036	638.37		0.248922255	6.67	335700	238166
6	481130000000	48	113	7827	1	206	Dallas-Fort Worth, TX-OK	19100	Dallas-Fort Worth-Arlington, TX	7189384	3545715	3364458	50.6871288	50.6871288	50.68713	1336	0.588	33	0.06639839	351	0.706237425	113	0.227364185	586	143	237	206	0.244027304	3		1		2			1		2				2	1		0.666666667	26.35777563	0.059186622		0.019728874		0.039457748			0.019728874		0.039457748				11.02844055	0.006036217	0.918295834	0.395488489	0.918295834	0.306098611	0.03686198	0.036887386	0.041066091		0.004480956	0.010186757	195.3333333		23.21342269	15.03475527	6.40123769	1.777429733	8.421861922	50.50591858	12.62647964				950.85		0.094844428	3	402287	289607
7	481130000000	48	113	9301	2	206	Dallas-Fort Worth, TX-OK	19100	Dallas-Fort Worth-Arlington, TX	7189384	3545715	3364458	200.6407522	200.6407522	200.6407522	1541	0.644	11	0.029891304	20	0.054347826	337	0.91576087	481	117	227	137	0.243243243	1			1					1						1			7.680393854	0.004984032			0.004984032					0.004984032					2.252782623	0.002717391					0.027014134	0.002373852			0.001297017	0.004149378	481		13.72503494		2.457200359	11.26783459	54.23903111		6.37956141	12.75912282	31.89780705	15.94890352	1165.43		0.052817433	4	263813	205690
8	481130000000	48	113	1102	2	206	Dallas-Fort Worth, TX-OK	19100	Dallas-Fort Worth-Arlington, TX	7189384	3545715	3364458	63.9924754	63.9924754	63.9924754	583	0.69	37	0.145098039	77	0.301960784	141	0.552941176	425	49	74	302	0.115294118	52		16		26	10		16		21	10		5	11	19	22	0.211538462	9.110446132	0.812595538		0.250029396		0.406297769	0.156268373		0.250029396		0.328163583	0.156268373		0.078134186	4.797439044	0.203921569	0.934166141	0.637667594	0.916877673	0.611251782	0.453537911	0.484261845	0.53912036	0.305874791	0.163779528	0.21802935	8.173076923	0.000766959	20.41686076		1.71542818	18.70143258	83.34979959		20.00235171			70.008231	442.57			5.33	372503	254439
9	481130000000	48	113	11401	2	206	Dallas-Fort Worth, TX-OK	19100	Dallas-Fort Worth-Arlington, TX	7189384	3545715	3364458	612.654798	612.654798	576.19983	1770	0.515	42	0.082840237	177	0.349112426	288	0.568047337	597	228	235	134	0.381909548	26		1		25			1					25	12	12	2	0.461538462	3.071850958	0.045123234		0.001735509		0.043387725			0.001735509					0.043387725	1.077751099	0.051282051	0.235193382	0.101292276	0.235193382	0.078397794	0.184652094	0.209191334	0.232889104	0.002094626	0.028953229	0.083467095	22.96153846	2.89885e-10	17.24872528	2.161842563	2.806108645	12.28077407	68.97195637	8.357071579	5.223169737	4.178535789	73.12437631	12.53560737	280.29	0.000203855	0.185777299	3	253775	208423
10	481130000000	48	113	11401	3	206	Dallas-Fort Worth, TX-OK	19100	Dallas-Fort Worth-Arlington, TX	7189384	3545715	3364458	187.1542813	187.1542813	176.4912	1790	0.578	227	0.312242091	396	0.544704264	104	0.143053645	751	269	358	124	0.358189081																		10.14214873														4.714116058									0.367879441		1			16.44730515		7.05242852	9.394876635	53.59257576		13.6785543	17.09819288	41.03566291		619.6			4	233145	192620


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "geoid10" DOUBLE,
  "geoid20" DOUBLE,
  "statefp" BIGINT,
  "countyfp" BIGINT,
  "tractce" BIGINT,
  "blkgrpce" BIGINT,
  "csa" DOUBLE,
  "csa_name" VARCHAR,
  "cbsa" DOUBLE,
  "cbsa_name" VARCHAR,
  "cbsa_pop" BIGINT,
  "cbsa_emp" BIGINT,
  "cbsa_wrk" BIGINT,
  "ac_total" DOUBLE,
  "ac_water" DOUBLE,
  "ac_land" DOUBLE,
  "ac_unpr" DOUBLE,
  "totpop" BIGINT,
  "counthu" DOUBLE,
  "hh" DOUBLE,
  "p_wrkage" DOUBLE,
  "autoown0" BIGINT,
  "pct_ao0" DOUBLE,
  "autoown1" BIGINT,
  "pct_ao1" DOUBLE,
  "autoown2p" BIGINT,
  "pct_ao2p" DOUBLE,
  "workers" BIGINT,
  "r_lowwagewk" BIGINT,
  "r_medwagewk" BIGINT,
  "r_hiwagewk" BIGINT,
  "r_pctlowwage" DOUBLE,
  "totemp" BIGINT,
  "e5_ret" BIGINT,
  "e5_off" BIGINT,
  "e5_ind" BIGINT,
  "e5_svc" BIGINT,
  "e5_ent" BIGINT,
  "e8_ret" BIGINT,
  "e8_off" BIGINT,
  "e8_ind" BIGINT,
  "e8_svc" BIGINT,
  "e8_ent" BIGINT,
  "e8_ed" BIGINT,
  "e8_hlth" BIGINT,
  "e8_pub" BIGINT,
  "e_lowwagewk" BIGINT,
  "e_medwagewk" BIGINT,
  "e_hiwagewk" BIGINT,
  "e_pctlowwage" DOUBLE,
  "d1a" DOUBLE,
  "d1b" DOUBLE,
  "d1c" DOUBLE,
  "d1c5_ret" DOUBLE,
  "d1c5_off" DOUBLE,
  "d1c5_ind" DOUBLE,
  "d1c5_svc" DOUBLE,
  "d1c5_ent" DOUBLE,
  "d1c8_ret" DOUBLE,
  "d1c8_off" DOUBLE,
  "d1c8_ind" DOUBLE,
  "d1c8_svc" DOUBLE,
  "d1c8_ent" DOUBLE,
  "d1c8_ed" DOUBLE,
  "d1c8_hlth" DOUBLE,
  "d1c8_pub" DOUBLE,
  "d1d" DOUBLE,
  "d1_flag" BIGINT,
  "d2a_jphh" DOUBLE,
  "d2b_e5mix" DOUBLE,
  "d2b_e5mixa" DOUBLE,
  "d2b_e8mix" DOUBLE,
  "d2b_e8mixa" DOUBLE,
  "d2a_ephhm" DOUBLE,
  "d2c_trpmx1" DOUBLE,
  "d2c_trpmx2" DOUBLE,
  "d2c_tripeq" DOUBLE,
  "d2r_jobpop" DOUBLE,
  "d2r_wrkemp" DOUBLE,
  "d2a_wrkemp" DOUBLE,
  "d2c_wremlx" DOUBLE,
  "d3a" DOUBLE,
  "d3aao" DOUBLE,
  "d3amm" DOUBLE,
  "d3apo" DOUBLE,
  "d3b" DOUBLE,
  "d3bao" DOUBLE,
  "d3bmm3" DOUBLE,
  "d3bmm4" DOUBLE,
  "d3bpo3" DOUBLE,
  "d3bpo4" DOUBLE,
  "d4a" DOUBLE,
  "d4b025" DOUBLE,
  "d4b050" DOUBLE,
  "d4c" DOUBLE,
  "d4d" DOUBLE,
  "d4e" DOUBLE,
  "d5ar" BIGINT,
  "d5ae" BIGINT
);