naics landuses table structure

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"
);

The following enums are used in this table.