Name: Smart Location Database_V3

Display Field: CSA_Name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: A large body of research has demonstrated that land use and urban form can have a significant effect on transportation outcomes. People who live and/or work in compact neighborhoods with a walkable street grid and easy access to public transit, jobs, stores, and services are more likely to have several transportation options to meet their everyday needs. As a result, they can choose to drive less, which reduces their emissions of greenhouse gases and other pollutants compared to people who live and work in places that are not location efficient. Walking, biking, and taking public transit can also save people money and improve their health by encouraging physical activity. The Smart Location Database summarizes several demographic, employment, and built environment variables for every census block group (CBG) in the United States. The database includes indicators of the commonly cited “D” variables shown in the transportation research literature to be related to travel behavior. The Ds include residential and employment density, land use diversity, design of the built environment, access to destinations, and distance to transit. SLD variables can be used as inputs to travel demand models, baseline data for scenario planning studies, and combined into composite indicators characterizing the relative location efficiency of CBG within U.S. metropolitan regions. This update features the most recent geographic boundaries (2019 Census Block Groups) and new and expanded sources of data used to calculate variables. Entirely new variables have been added and the methods used to calculate some of the SLD variables have changed. See https://www.epa.gov/smartgrowth/smart-location-mapping for more information.

Copyright Text: EPA Office of Community Revitalization

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10434584.6131
YMin: -83867.9731000001
XMax: 3407867.6993
YMax: 6755032.8085
Spatial Reference: 102039 (102039)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[213,209,252,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[52,52,52,255],"width":1.4}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GEOID10 (type: esriFieldTypeString, alias: Census block group 12-digit FIPS code (2010), SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• GEOID20 (type: esriFieldTypeString, alias: Census block group 12-digit FIPS code (2018), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STATEFP (type: esriFieldTypeString, alias: State FIPS code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• COUNTYFP (type: esriFieldTypeString, alias: County FIPS code, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• TRACTCE (type: esriFieldTypeString, alias: Census tract FIPS code in which CBG resides, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• BLKGRPCE (type: esriFieldTypeString, alias: Census block group FIPS code in which CBG resides, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CSA (type: esriFieldTypeString, alias: Combined Statistical Area (CSA) Code, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• CSA_Name (type: esriFieldTypeString, alias: Name of CSA in which CBG resides, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CBSA (type: esriFieldTypeString, alias: FIPS for Core-Based Statistical Area (CBSA) in which CBG resides, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• CBSA_Name (type: esriFieldTypeString, alias: Name of CBSA in which CBG resides, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CBSA_POP (type: esriFieldTypeDouble, alias: Total population in CBSA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CBSA_EMP (type: esriFieldTypeDouble, alias: Total employment in CBSA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CBSA_WRK (type: esriFieldTypeDouble, alias: Total number of workers that live in CBSA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ac_Total (type: esriFieldTypeDouble, alias: Total geometric area (acres) of the CBG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ac_Water (type: esriFieldTypeDouble, alias: Total water area (acres), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ac_Land (type: esriFieldTypeDouble, alias: Total land area (acres), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ac_Unpr (type: esriFieldTypeDouble, alias: Total land area (acres) that is not protected from development (i.e., not a park, natural area or conservation area), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotPop (type: esriFieldTypeInteger, alias: Population, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CountHU (type: esriFieldTypeInteger, alias: Housing units, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HH (type: esriFieldTypeInteger, alias: Households (occupied housing units), 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• P_WrkAge (type: esriFieldTypeDouble, alias: Percent of population that is working aged 18 to 64 years, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AutoOwn0 (type: esriFieldTypeInteger, alias: Number of households in CBG that own zero automobiles, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pct_AO0 (type: esriFieldTypeDouble, alias: Percent of zero-car households in CBG, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AutoOwn1 (type: esriFieldTypeInteger, alias: Number of households in CBG that own one automobile, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pct_AO1 (type: esriFieldTypeDouble, alias: Percent of one-car households in CBG, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AutoOwn2p (type: esriFieldTypeInteger, alias: Number of households in CBG that own two or more automobiles, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pct_AO2p (type: esriFieldTypeDouble, alias: Percent of two-plus-car households in CBG, 2018, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Workers (type: esriFieldTypeInteger, alias: Count of workers in CBG (home location), 2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• R_LowWageWk (type: esriFieldTypeInteger, alias: Count of workers earning $1250/month or less (home location), 2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• R_MedWageWk (type: esriFieldTypeInteger, alias: Count of workers earning more than $1250/month but less than $3333/month (home location), 2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• R_HiWageWk (type: esriFieldTypeInteger, alias: Count of workers earning $3333/month or more (home location), 2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• R_PCTLOWWAGE (type: esriFieldTypeDouble, alias: Percent of low wage workers in a CBG (home location), 2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotEmp (type: esriFieldTypeInteger, alias: Total employment, 2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• E5_Ret (type: esriFieldTypeInteger, alias: Retail jobs within a 5-tier employment classification scheme , SQL Type: sqlTypeOther, nullable: true, editable: true)
• E5_Off (type: esriFieldTypeInteger, alias: Office jobs within a 5-tier employment classification scheme, SQL Type: sqlTypeOther, nullable: true, editable: true)
• E5_Ind (type: esriFieldTypeInteger, alias: Industrial jobs within a 5-tier employment classification scheme , SQL Type: sqlTypeOther, nullable: true, editable: true)
• E5_Svc (type: esriFieldTypeInteger, alias: Service jobs within a 5-tier employment classification scheme , SQL Type: sqlTypeOther, nullable: true, editable: true)
• E5_Ent (type: esriFieldTypeInteger, alias: Entertainment jobs within a 5-tier employment classification scheme , SQL Type: sqlTypeOther, nullable: true, editable: true)
• E8_Ret (type: esriFieldTypeInteger, alias: Retail jobs within an 8-tier employment classification scheme , SQL Type: sqlTypeOther, nullable: true, editable: true)
• E8_off (type: esriFieldTypeInteger, alias: Office jobs within an 8-tier employment classification scheme , SQL Type: sqlTypeOther, nullable: true, editable: true)
• E8_Ind (type: esriFieldTypeInteger, alias: Industrial jobs within an 8-tier employment classification scheme , SQL Type: sqlTypeOther, nullable: true, editable: true)
• E8_Svc (type: esriFieldTypeInteger, alias: Service jobs within an 8-tier employment classification scheme , SQL Type: sqlTypeOther, nullable: true, editable: true)
• E8_Ent (type: esriFieldTypeInteger, alias: Entertainment jobs within an 8-tier employment classification scheme , SQL Type: sqlTypeOther, nullable: true, editable: true)
• E8_Ed (type: esriFieldTypeInteger, alias: Education jobs within an 8-tier employment classification scheme , SQL Type: sqlTypeOther, nullable: true, editable: true)
• E8_Hlth (type: esriFieldTypeInteger, alias: Health care jobs within an 8-tier employment classification scheme , SQL Type: sqlTypeOther, nullable: true, editable: true)
• E8_Pub (type: esriFieldTypeInteger, alias: Public administration jobs within an 8-tier employment classification scheme , SQL Type: sqlTypeOther, nullable: true, editable: true)
• E_LowWageWk (type: esriFieldTypeInteger, alias: Number of workers earning $1250/month or less (work location), 2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• E_MedWageWk (type: esriFieldTypeInteger, alias: Number of workers earning more than $1250/month but less than $3333/month (work location), 2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• E_HiWageWk (type: esriFieldTypeInteger, alias: Numberof workers earning $3333/month or more (work location), 2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• E_PctLowWage (type: esriFieldTypeDouble, alias: Percent LowWageWk of total #workers in a CBG (work location), 2017, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1A (type: esriFieldTypeDouble, alias: Gross residential density (HU/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1B (type: esriFieldTypeDouble, alias: Gross population density (people/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1C (type: esriFieldTypeDouble, alias: Gross employment density (jobs/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1C5_RET (type: esriFieldTypeDouble, alias: Gross retail (5-tier) employment density (jobs/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1C5_OFF (type: esriFieldTypeDouble, alias: Gross office (5-tier) employment density (jobs/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1C5_IND (type: esriFieldTypeDouble, alias: Gross industrial (5-tier) employment density (jobs/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1C5_SVC (type: esriFieldTypeDouble, alias: Gross service (5-tier) employment density (jobs/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1C5_ENT (type: esriFieldTypeDouble, alias: Gross entertainment (5-tier) employment density (jobs/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1C8_RET (type: esriFieldTypeDouble, alias: Gross retail (8-tier) employment density (jobs/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1C8_OFF (type: esriFieldTypeDouble, alias: Gross office (8-tier) employment density (jobs/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1C8_IND (type: esriFieldTypeDouble, alias: Gross industrial (8-tier) employment density (jobs/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1C8_SVC (type: esriFieldTypeDouble, alias: Gross service (8-tier) employment density (jobs/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1C8_ENT (type: esriFieldTypeDouble, alias: Gross entertainment (8-tier) employment density (jobs/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1C8_ED (type: esriFieldTypeDouble, alias: Gross education(8-tier) employment density (jobs/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1C8_HLTH (type: esriFieldTypeDouble, alias: Gross health care (8-tier) employment density (jobs/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1C8_PUB (type: esriFieldTypeDouble, alias: Gross retail (8-tier) employment density (jobs/acre) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1D (type: esriFieldTypeDouble, alias: Gross activity density (employment + HUs) on unprotected land, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D1_FLAG (type: esriFieldTypeDouble, alias: Flag indicating that density metrics are based on total CBG land acreage rather than unprotected acreage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2A_JPHH (type: esriFieldTypeDouble, alias: Jobs per household, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2B_E5MIX (type: esriFieldTypeDouble, alias: 5-tier employment entropy (denominator set to observed employment types in the CBG), SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2B_E5MIXA (type: esriFieldTypeDouble, alias: 5-tier employment entropy (denominator set to the static 5 employment types in the CBG), SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2B_E8MIX (type: esriFieldTypeDouble, alias: 8-tier employment entropy (denominator set to observed employment types in the CBG), SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2B_E8MIXA (type: esriFieldTypeDouble, alias: 8-tier employment entropy (denominator set to the static 8 employment types in the CBG), SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2A_EPHHM (type: esriFieldTypeDouble, alias: Employment and household entropy, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2C_TRPMX1 (type: esriFieldTypeDouble, alias: Employment and Household entropy (based on vehicle trip production and trip attractions including all 5 employment categories), SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2C_TRPMX2 (type: esriFieldTypeDouble, alias: Employment and Household Entropy calculations, based on trips production and trip attractions including 4 of the 5 employment categories (excluding industrial), SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2C_TRIPEQ (type: esriFieldTypeDouble, alias: Trip productions and trip attractions equilibrium index; the closer to one, the more balanced the trip making, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2R_JOBPOP (type: esriFieldTypeDouble, alias: Regional Diversity. Standard calculation based on population and total employment: Deviation of CBG ratio of jobs/pop from the regional average ratio of jobs/pop, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2R_WRKEMP (type: esriFieldTypeDouble, alias: Household Workers per Job, as compared to the region: Deviation of CBG ratio of household workers/job from regional average ratio of household workers/job, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2A_WRKEMP (type: esriFieldTypeDouble, alias: Household Workers per Job, by CBG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2C_WREMLX (type: esriFieldTypeDouble, alias: Household Workers per Job Equilibrium Index; the closer to one the more balanced the resident workers and jobs in the CBG., SQL Type: sqlTypeOther, nullable: true, editable: true)
• D3A (type: esriFieldTypeDouble, alias: Total road network density, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D3AAO (type: esriFieldTypeDouble, alias: Network density in terms of facility miles of auto-oriented links per square mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D3AMM (type: esriFieldTypeDouble, alias: Network density in terms of facility miles of multi-modal links per square mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D3APO (type: esriFieldTypeDouble, alias: Network density in terms of facility miles of pedestrian-oriented links per square mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D3B (type: esriFieldTypeDouble, alias: Street intersection density (weighted, auto-oriented intersections eliminated), SQL Type: sqlTypeOther, nullable: true, editable: true)
• D3BAO (type: esriFieldTypeDouble, alias: Intersection density in terms of auto-oriented intersections per square mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D3BMM3 (type: esriFieldTypeDouble, alias: Intersection density in terms of multi-modal intersections having three legs per square mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D3BMM4 (type: esriFieldTypeDouble, alias: Intersection density in terms of multi-modal intersections having four or more legs per square mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D3BPO3 (type: esriFieldTypeDouble, alias: Intersection density in terms of pedestrian-oriented intersections having three legs per square mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D3BPO4 (type: esriFieldTypeDouble, alias: Intersection density in terms of pedestrian-oriented intersections having four or more legs per square mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D4A (type: esriFieldTypeDouble, alias: Distance from the population-weighted centroid to nearest transit stop (meters), SQL Type: sqlTypeOther, nullable: true, editable: true)
• D4B025 (type: esriFieldTypeDouble, alias: Proportion of CBG employment within ¼ mile of fixed-guideway transit stop, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D4B050 (type: esriFieldTypeDouble, alias: Proportion of CBG employment within ½ mile of fixed-guideway transit stop, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D4C (type: esriFieldTypeDouble, alias: Aggregate frequency of transit service within 0.25 miles of CBG boundary per hour during evening peak period, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D4D (type: esriFieldTypeDouble, alias: Aggregate frequency of transit service [D4c] per square mile, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D4E (type: esriFieldTypeDouble, alias: Aggregate frequency of transit service [D4c] per capita, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D5AR (type: esriFieldTypeDouble, alias: Jobs within 45 minutes auto travel time, time- decay (network travel time) weighted, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D5AE (type: esriFieldTypeDouble, alias: Working age population within 45 minutes auto travel time, time-decay (network travel time) weighted, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D5BR (type: esriFieldTypeDouble, alias: Jobs within 45-minute transit commute, distance decay (walk network travel time, GTFS schedules) weighted, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D5BE (type: esriFieldTypeDouble, alias: Working age population within 45-minute transit commute, time decay (walk network travel time, GTFS schedules) weighted, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D5CR (type: esriFieldTypeDouble, alias: Proportional Accessibility to Regional Destinations - Auto: Employment accessibility expressed as a ratio of total CBSA accessibility, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D5CRI (type: esriFieldTypeDouble, alias: Regional Centrality Index – Auto: CBG [D5cr] score relative to max CBSA [D5cr] score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D5CE (type: esriFieldTypeDouble, alias: Proportional Accessibility to Regional Destinations - Auto: Working age population accessibility expressed as a ratio of total CBSA accessibility, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D5CEI (type: esriFieldTypeDouble, alias: Regional Centrality Index – Auto: CBG [D5ce] score relative to max CBSA [D5ce] score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D5DR (type: esriFieldTypeDouble, alias: Proportional Accessibility of Regional Destinations - Transit: Employment accessibility expressed as a ratio of total MSA accessibility, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D5DRI (type: esriFieldTypeDouble, alias: Regional Centrality Index – Transit: CBG [D5dr] score relative to max CBSA [D5dr] score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D5DE (type: esriFieldTypeDouble, alias: Proportional Accessibility of Regional Destinations - Transit: Working age population accessibility expressed as a ratio of total MSA accessibility, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D5DEI (type: esriFieldTypeDouble, alias: Regional Centrality Index – Transit: CBG [D5de] score relative to max CBSA [D5de] score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2A_Ranked (type: esriFieldTypeDouble, alias: Quantile ranked order (1-20) of [D2a_EpHHm] from lowest to highest, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D2B_Ranked (type: esriFieldTypeDouble, alias: Quantile ranked order (1-20) of [D2b_E8MixA] from lowest to highest, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D3B_Ranked (type: esriFieldTypeDouble, alias: Quantile ranked order (1-20) of [D3b] from lowest to highest, SQL Type: sqlTypeOther, nullable: true, editable: true)
• D4A_Ranked (type: esriFieldTypeDouble, alias: Quantile ranked order (1,13-20) of [D4a] from lowest to highest, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NatWalkInd (type: esriFieldTypeDouble, alias: Walkability Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Region (type: esriFieldTypeString, alias: Region used to normalize vehicle miles traveled, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Households (type: esriFieldTypeInteger, alias: Number of households, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Workers_1 (type: esriFieldTypeInteger, alias: Number of workers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Residents (type: esriFieldTypeInteger, alias: Number of residents, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Drivers (type: esriFieldTypeDouble, alias: Number of drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vehicles (type: esriFieldTypeInteger, alias: Number of vehicles available, SQL Type: sqlTypeOther, nullable: true, editable: true)
• White (type: esriFieldTypeInteger, alias: Number of white residents, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Male (type: esriFieldTypeInteger, alias: Number of male residents, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lowwage (type: esriFieldTypeInteger, alias: Number of of low wage residents, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Medwage (type: esriFieldTypeInteger, alias: Number of medium wage residents, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Highwage (type: esriFieldTypeInteger, alias: Number of high wage residents, SQL Type: sqlTypeOther, nullable: true, editable: true)
• W_P_Lowwage (type: esriFieldTypeDouble, alias: Percent low wage workers (workplace), SQL Type: sqlTypeOther, nullable: true, editable: true)
• W_P_Medwage (type: esriFieldTypeDouble, alias: Percent medium wage workers (workplace), SQL Type: sqlTypeOther, nullable: true, editable: true)
• W_P_Highwage (type: esriFieldTypeDouble, alias: Percent of high wage workers (workplace), SQL Type: sqlTypeOther, nullable: true, editable: true)
• GasPrice (type: esriFieldTypeInteger, alias: 2020 statewide average gas price (cents), SQL Type: sqlTypeOther, nullable: true, editable: true)
• logd1a (type: esriFieldTypeDouble, alias: Log of D1a (residential density), SQL Type: sqlTypeOther, nullable: true, editable: true)
• logd1c (type: esriFieldTypeDouble, alias: Log of D1c (employment density), SQL Type: sqlTypeOther, nullable: true, editable: true)
• logd3aao (type: esriFieldTypeDouble, alias: Log of D3aao (auto network density), SQL Type: sqlTypeOther, nullable: true, editable: true)
• logd3apo (type: esriFieldTypeDouble, alias: Log of D3apo (pedestrian network density), SQL Type: sqlTypeOther, nullable: true, editable: true)
• d4bo25 (type: esriFieldTypeInteger, alias: D4b025 (1/4 mile job accessibility to fixed guideway transit), SQL Type: sqlTypeOther, nullable: true, editable: true)
• d5dei_1 (type: esriFieldTypeInteger, alias: D5dei (Regional centrality index - transit), SQL Type: sqlTypeOther, nullable: true, editable: true)
• logd4d (type: esriFieldTypeInteger, alias: Log of D4d (frequency of transit service), SQL Type: sqlTypeOther, nullable: true, editable: true)
• UPTpercap (type: esriFieldTypeInteger, alias: Unlinked passenger trips per capita for the CBSA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_C_constant (type: esriFieldTypeDouble, alias: Constant Beta value, commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_C_male (type: esriFieldTypeDouble, alias: Male Beta value, commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_C_ld1c (type: esriFieldTypeDouble, alias: Logd1c Beta value, commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_C_drvmveh (type: esriFieldTypeDouble, alias: Drivers minus vehicles Beta value, commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_C_ld1a (type: esriFieldTypeDouble, alias: Logd1a Beta value, commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_C_ld3apo (type: esriFieldTypeDouble, alias: Logd3apo Beta value, commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_C_inc1 (type: esriFieldTypeDouble, alias: Low wage Beta value, commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_C_gasp (type: esriFieldTypeDouble, alias: Fuel price Beta value, commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_N_constant (type: esriFieldTypeDouble, alias: Constant Beta value, non-commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_N_inc2 (type: esriFieldTypeDouble, alias: Medium wage Beta value, non-commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_N_inc3 (type: esriFieldTypeDouble, alias: High wage Beta value, non-commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_N_white (type: esriFieldTypeDouble, alias: White Beta value, non-commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_N_male (type: esriFieldTypeDouble, alias: Male Beta value, non-commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_N_drvmveh (type: esriFieldTypeDouble, alias: Drivers minus vehicles Beta value, non-commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_N_gasp (type: esriFieldTypeDouble, alias: Fuel price Beta value, non-commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_N_ld1a (type: esriFieldTypeDouble, alias: Logd1a Beta value, non-commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_N_ld1c (type: esriFieldTypeDouble, alias: Logd1c Beta value, non-commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_N_ld3aao (type: esriFieldTypeDouble, alias: Logd3aao Beta value, non-commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_N_ld3apo (type: esriFieldTypeDouble, alias: Logd3apo Beta value, non-commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_N_d4bo25 (type: esriFieldTypeDouble, alias: D4b025 Beta value, non-commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_N_d5dei (type: esriFieldTypeDouble, alias: D5dei Beta value, non-commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• B_N_UPTpc (type: esriFieldTypeDouble, alias: UPTC Beta value, non-commute VMT model, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_R_Households (type: esriFieldTypeInteger, alias: # of households in the county, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_R_Pop (type: esriFieldTypeInteger, alias: # of residents in the county, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_R_Workers (type: esriFieldTypeInteger, alias: # of workers living in the county, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_R_Drivers (type: esriFieldTypeDouble, alias: # of drivers in the county, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_R_Vehicles (type: esriFieldTypeInteger, alias: # of vehicles available in the county, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_R_White (type: esriFieldTypeDouble, alias: Percent white in the county, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_R_Male (type: esriFieldTypeDouble, alias: Percent male in the county, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_R_Lowwage (type: esriFieldTypeDouble, alias: Percent low wage workers living in the county, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_R_Medwage (type: esriFieldTypeDouble, alias: Percent medium wage workers living in the county, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_R_Highwage (type: esriFieldTypeDouble, alias: Percent high wage workers living in the county, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_R_DrmV (type: esriFieldTypeDouble, alias: Household drivers minus vehicles available, county average, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NonCom_VMT_Per_Worker (type: esriFieldTypeDouble, alias: Mean non-commute VMT per worker (by workplace ), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Com_VMT_Per_Worker (type: esriFieldTypeDouble, alias: Mean commute VMT per worker (by workplace ), SQL Type: sqlTypeOther, nullable: true, editable: true)
• VMT_per_worker (type: esriFieldTypeDouble, alias: Mean total work-related VMT per worker (by workplace ), SQL Type: sqlTypeOther, nullable: true, editable: true)
• VMT_tot_min (type: esriFieldTypeDouble, alias: Minimum average daily VMT per worker per worker among all block groups within the same county, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VMT_tot_max (type: esriFieldTypeDouble, alias: Maximum average daily VMT per worker among all block groups within the same county, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VMT_tot_avg (type: esriFieldTypeDouble, alias: Weighted average daily VMT per worker among all block groups within the same county, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GHG_per_worker (type: esriFieldTypeDouble, alias: Estimated average daily GHG generated by a worker in a workplace block group , SQL Type: sqlTypeOther, nullable: true, editable: true)
• Annual_GHG (type: esriFieldTypeDouble, alias: Annual_GHGTotal estimated annual GHG generated by a worker (over 260 days) within a block group, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLC_score (type: esriFieldTypeDouble, alias: SLC_score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: EPA_SLD_Database_V3
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/11/2022 6:30:48 PM

Schema Last Edit Date: 2/11/2022 6:30:48 PM

Data Last Edit Date: 2/11/2022 6:30:48 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat