naics landuses table structure

The NAICS-Landuses table show a crosswalk between the NAICS industry sector and possible landuses for each sector

Table Structure

Field	Type	NULL allowed	Default Value	Foreign key	Description
naics	INTEGER	NO			A 3-digit NAICS code from the modelled sectors
land_use	TEXT	NO	“ALL”		Text describing the land use type represented by this location. Values at land_use.

(* - Primary key)

The SQL statement for table and index creation is below.

CREATE TABLE Naics_Landuses (
    "naics"         INTEGER NOT NULL,
    "land_use"      TEXT    NOT NULL DEFAULT "ALL"
);

Enums

The following enums are used in this table.

land_use

Enum Values Description

Value	Name	Description
0	LU_AGRICULTURE	0
1	LU_ALL
2	LU_BUSINESS
3	LU_CIVIC_RELIGIOUS
4	LU_CULTURAL
5	LU_DISTRIBUTION	5
6	LU_INTERMODAL
7	LU_EDUCATION_PREK
8	LU_EDUCATION_K_8
9	LU_EDUCATION_9_12
10	LU_HIGHER_EDUCATION	used to be 8, now 10
11	LU_HOTEL
12	LU_INDUSTRIAL	used to be 10
13	LU_MANUFACTURING
14	LU_SHOPPING
15	LU_MEDICAL	15
16	LU_MIXED_USE
17	LU_NONE	used to be 15
18	LU_NON_RESIDENTIAL
19	LU_RESIDENTIAL	20
20	LU_RESIDENTIAL_MULTI	20
21	LU_RECREATION
22	LU_SPECIAL_GENERATOR	used to be 20
23	TRANSIT_STOP
24	LU_SERVICE
25	LU_RETAIL
26	LU_RESTAURANT
27	LU_EXTERNAL	27, used to be 25