Layer: Parcel_4000_NAICSselect (ID:0)

View In: Map Viewer

Name: Parcel_4000_NAICSselect

Display Field: SITUS_STNAME_SHP

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

2025 Oakland business license data set joined to parcels with 4000 series Use Code (dataset extracted from Assessor's parcel GIS 4/2/2026). Only those NAICS codes related to trucking have been included here:

2362XX Nonresidential Building Construction

31XXXX Manufacturing

32XXXX Manufacturing

33XXXX Manufacturing

42XXXX Wholesale Trade

4841XX General Freight Trucking

492110 Couriers and Express Delivery Services

Copyright Text: Alameda County, Oakland Planning & Building Department

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,197,255,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":0.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_12

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID_12 (type: esriFieldTypeOID, alias: OBJECTID_12, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
APN_GROUND (type: esriFieldTypeString, alias: APN_GROUND, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
SORTPARCEL (type: esriFieldTypeString, alias: SORTPARCEL, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
PRINTPARCEL (type: esriFieldTypeString, alias: PRINTPARCEL, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
SHP_LANDVALUE (type: esriFieldTypeDouble, alias: SHP_LANDVALUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SHP_IMPRVMTS_VALUE (type: esriFieldTypeDouble, alias: SHP_IMPRVMTS_VALUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SHP_USECODE (type: esriFieldTypeString, alias: SHP_USECODE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [7000: Vacant apartment land, capable of 5 or more units], [7090: Vacant apartment common area], [7100: Five or more single family res homes], ... 116 more ...)
SITUS_STNUM_SHP (type: esriFieldTypeString, alias: SITUS_STNUM_SHP, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
SITUS_STNAME_SHP (type: esriFieldTypeString, alias: SITUS_STNAME_SHP, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
SITUSUNIT_SHP (type: esriFieldTypeString, alias: SITUSUNIT_SHP, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
SITUSCITY_SHP (type: esriFieldTypeString, alias: SITUSCITY_SHP, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SITUSZIP_SHP (type: esriFieldTypeString, alias: SITUSZIP_SHP, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
PC_NO_UNITS (type: esriFieldTypeInteger, alias: PC_NO_UNITS, SQL Type: sqlTypeOther, nullable: true, editable: true)
PC_BLDG_CLASS (type: esriFieldTypeString, alias: PC_BLDG_CLASS, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
PC_NO_BUILDINGS (type: esriFieldTypeInteger, alias: PC_NO_BUILDINGS, SQL Type: sqlTypeOther, nullable: true, editable: true)
PC_NO_STORIES (type: esriFieldTypeDouble, alias: PC_NO_STORIES, SQL Type: sqlTypeOther, nullable: true, editable: true)
PC_BLDG_AREA (type: esriFieldTypeInteger, alias: PC_BLDG_AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
PC_BLDG_YEAR (type: esriFieldTypeString, alias: PC_BLDG_YEAR, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
PC_CONDO_TYPE (type: esriFieldTypeString, alias: PC_CONDO_TYPE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
MAP_BOOK (type: esriFieldTypeInteger, alias: MAP_BOOK, SQL Type: sqlTypeOther, nullable: true, editable: true)
SUB_BOOK (type: esriFieldTypeString, alias: SUB_BOOK, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
BLOCK (type: esriFieldTypeInteger, alias: BLOCK, SQL Type: sqlTypeOther, nullable: true, editable: true)
PARCEL (type: esriFieldTypeInteger, alias: PARCEL, SQL Type: sqlTypeOther, nullable: true, editable: true)
SUB_PARCEL (type: esriFieldTypeInteger, alias: SUB_PARCEL, SQL Type: sqlTypeOther, nullable: true, editable: true)
FORMAT_PARCEL (type: esriFieldTypeString, alias: FORMAT_PARCEL, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
APN_1 (type: esriFieldTypeString, alias: APN_1, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
PRIMARY_CODE (type: esriFieldTypeInteger, alias: PRIMARY_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SECONDARY_CODE (type: esriFieldTypeInteger, alias: SECONDARY_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SITUS_HOUSE_NUMBER_A (type: esriFieldTypeString, alias: SITUS_HOUSE_NUMBER_A, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SITUS_HOUSE_NUMBER_N (type: esriFieldTypeInteger, alias: SITUS_HOUSE_NUMBER_N, SQL Type: sqlTypeOther, nullable: true, editable: true)
SITUS_STREET_NAME (type: esriFieldTypeString, alias: SITUS_STREET_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SITUS_UNIT (type: esriFieldTypeString, alias: SITUS_UNIT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
SITUS_CITY (type: esriFieldTypeString, alias: SITUS_CITY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
SITUS_ZIP_CODE_5 (type: esriFieldTypeString, alias: SITUS_ZIP_CODE_5, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
SITUS_ZIP_CODE_4 (type: esriFieldTypeString, alias: SITUS_ZIP_CODE_4, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
LAND (type: esriFieldTypeDouble, alias: LAND, SQL Type: sqlTypeOther, nullable: true, editable: true)
IMPROVEMENTS (type: esriFieldTypeDouble, alias: IMPROVEMENTS, SQL Type: sqlTypeOther, nullable: true, editable: true)
CLCA_LAND (type: esriFieldTypeDouble, alias: CLCA_LAND, SQL Type: sqlTypeOther, nullable: true, editable: true)
CLCA_IMPROVEMENTS (type: esriFieldTypeDouble, alias: CLCA_IMPROVEMENTS, SQL Type: sqlTypeOther, nullable: true, editable: true)
MACHINERY_EQUIPMENT (type: esriFieldTypeDouble, alias: MACHINERY_EQUIPMENT, SQL Type: sqlTypeOther, nullable: true, editable: true)
BUSINESS_PERSONAL_PROPERTY (type: esriFieldTypeDouble, alias: BUSINESS_PERSONAL_PROPERTY, SQL Type: sqlTypeOther, nullable: true, editable: true)
HOUSEHOLD_PERSONAL_PROPERTY (type: esriFieldTypeDouble, alias: HOUSEHOLD_PERSONAL_PROPERTY, SQL Type: sqlTypeOther, nullable: true, editable: true)
HOME_OWNER_EXEMPTION (type: esriFieldTypeDouble, alias: HOME_OWNER_EXEMPTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
OTHER_EXEMPTION (type: esriFieldTypeDouble, alias: OTHER_EXEMPTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
ASSESSED_VALUE (type: esriFieldTypeDouble, alias: ASSESSED_VALUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
LAST_DOCUMENT_YEAR (type: esriFieldTypeString, alias: LAST_DOCUMENT_YEAR, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
LAST_DOCUMENT_NUMBER (type: esriFieldTypeString, alias: LAST_DOCUMENT_NUMBER, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
LAST_DOCUMENT_DATE (type: esriFieldTypeDate, alias: LAST_DOCUMENT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LAST_DOCUMENT_INPUT_DATE (type: esriFieldTypeDate, alias: LAST_DOCUMENT_INPUT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
MAILING_ADDRESS_ZIP_4 (type: esriFieldTypeString, alias: MAILING_ADDRESS_ZIP_4, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
BAR_CODE_WALK_SEQUENCE (type: esriFieldTypeString, alias: BAR_CODE_WALK_SEQUENCE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
BAR_CODE_CHECK_DIGIT (type: esriFieldTypeString, alias: BAR_CODE_CHECK_DIGIT, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
MAILING_ADDRESS_EFFECTIVE_DATE (type: esriFieldTypeDate, alias: MAILING_ADDRESS_EFFECTIVE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
MAILING_ADDRESS_SOURCE (type: esriFieldTypeString, alias: MAILING_ADDRESS_SOURCE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
ECONOMIC_UNIT (type: esriFieldTypeString, alias: ECONOMIC_UNIT, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
DEACTIVATION_DATE (type: esriFieldTypeDate, alias: DEACTIVATION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
EXEMPTION_CODE (type: esriFieldTypeString, alias: EXEMPTION_CODE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
SBE_CONST_CODE (type: esriFieldTypeString, alias: SBE_CONST_CODE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [A: Structural Steel], [B: Reinforced Concrete], [C: Masonry], ... 5 more ...)
SBE_SHAPE_CODE (type: esriFieldTypeString, alias: SBE_SHAPE_CODE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [A: Rectangle with Four Corners], [B: L Shape with Six Corners], [C: C or U Shape with Eight Corners], ... 3 more ...)
SBE_QUAL_CODE (type: esriFieldTypeString, alias: SBE_QUAL_CODE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
OBJECTID_1 (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
FULL_SITUSADDRESS (type: esriFieldTypeString, alias: FULL_SITUSADDRESS, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
NAICS (type: esriFieldTypeInteger, alias: NAICS, SQL Type: sqlTypeOther, nullable: true, editable: true)
NAICS_1 (type: esriFieldTypeString, alias: NAICS_1, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
DBA (type: esriFieldTypeString, alias: DBA, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Business_name (type: esriFieldTypeString, alias: Business name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Full_bus_address (type: esriFieldTypeString, alias: Full bus address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Bus_address (type: esriFieldTypeString, alias: Bus address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
USE_CODE (type: esriFieldTypeString, alias: USE_CODE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [7000: Vacant apartment land, capable of 5 or more units], [7090: Vacant apartment common area], [7100: Five or more single family res homes], ... 116 more ...)
PC_LOT_SIZE (type: esriFieldTypeDouble, alias: PC_LOT_SIZE, 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:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/30/2026 5:59:04 PM

Schema Last Edit Date: 4/30/2026 5:59:02 PM

Data Last Edit Date: 4/30/2026 5:55:49 PM

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