gisdata.CUPERTINO.ADDR2ndary is a Point FeatureClass representing the locations of suite numbers, apartment numbers, unit numbers, or building numbers. Secondary addresses always have a suffix of "apt","bldg","ste", "elec", or "unit".

It is primarily used for visualization through labeleing or data collection through counts

The layer is updated as needed by using official building letters from the Building department.

The oldest geoprocessing record has a date of: 2011-09-16

gisdata.CUPERTINO.ADDR2ndary has the following fields:

OBJECTID:

Unique identifier automatically generated by Esri

type: OID, length: 4, domain: none

PRIMARY_ID:

Unique identifier necessary for third party software to display addresses

type: Double, length: 8, domain: none

APN_SPACE:

Number of parcel containing address

type: String, length: 10, domain: none

LOCATION:

Further description of address location

type: String, length: 36, domain: none

BLDG_ID:

The assetID of the building containing the address. This is found in bldg_footprint

type: Integer, length: 4, domain: none

ADDRESS:

type: String, length: 56, domain: none

HOUSE_NO:

type: String, length: 11, domain: none

PREFIX:

type: String, length: 7, domain: AddressPrefix

domain values:

['S', 'E', 'W', 'N']

STREET_NAME:

type: String, length: 23, domain: none

SUFFIX:

type: String, length: 7, domain: AddressSuffix

domain values:

['CMN', 'EXPY', 'LN', 'SQ', 'PLZ', 'PKWY', 'RD', 'CIR', 'WAY', 'BLVD', 'AVE', 'TER', 'ST', 'DR', 'PL', 'CT']

SUFFIX_DIR:

type: String, length: 11, domain: AddressPrefix

domain values:

['S', 'E', 'W', 'N']

UNIT_NO:

type: String, length: 8, domain: none

UNIT_TYPE:

type: String, length: 4, domain: UNITS

domain values:

['UNIT', 'STE', 'ELEC', 'BLDG', 'APT']

CITY:

type: String, length: 11, domain: AddressCity

domain values:

[]

STATE:

type: String, length: 7, domain: none

COMMENTS:

type: String, length: 50, domain: none

ZIP:

type: String, length: 10, domain: none

DataSource:

Description of what methods were used for data capture/migration

type: String, length: 100, domain: AddressDataSource

domain values:

['Building', 'County', 'Fire', 'Unknown', 'County Comm']

UpdateBy:

The user who last updated the database row

type: String, length: 50, domain: OPERATOR

domain values:

['MIKE', 'CURTIS', 'JAMES', 'KANE', 'JERRY', 'RICARDO', 'JOANNE', 'BEN', 'TERI', 'DAN', 'ANDY', 'ADAM', 'TIFFANIE', 'JONATHAN', 'MICHAEL', 'MAKIKO', 'ALEX', 'PAUL', 'JEN', 'JOHN', 'JASON', 'TRAVIS', 'SHAWN', 'FRANK', 'JULIE', 'NICK', 'KEVIN', 'CLIFF']

UpdateDate:

the date the database row was last updated

type: Date, length: 8, domain: none

CreateBy:

the name of the staff person who created the database row

type: String, length: 20, domain: OPERATOR

domain values:

['MIKE', 'CURTIS', 'JAMES', 'KANE', 'JERRY', 'RICARDO', 'JOANNE', 'BEN', 'TERI', 'DAN', 'ANDY', 'ADAM', 'TIFFANIE', 'JONATHAN', 'MICHAEL', 'MAKIKO', 'ALEX', 'PAUL', 'JEN', 'JOHN', 'JASON', 'TRAVIS', 'SHAWN', 'FRANK', 'JULIE', 'NICK', 'KEVIN', 'CLIFF']

CreateDate:

the date the database row was initially created

type: Date, length: 8, domain: none

X:

Longitude of address

type: Double, length: 8, domain: none

Y:

Latitude of address

type: Double, length: 8, domain: none

ROTATION:

The degrees of rotation for address label

type: Double, length: 8, domain: none

ADDID:

The assetID of the parent address. For example 10125 Stevens Creek Blvd Apt 1 will have an ADDID equal to the assetID of 10125 Stevens Creek Blvd

type: Double, length: 8, domain: none

Floor:

The floor of the address, if known

type: SmallInteger, length: 2, domain: Floor

domain values:

['1', '2', '3', '4', '5', '6', '7', '8', '9', '10']

SHAPE:

Field that stores geographic coordinates associated with feature

type: Geometry, length: 4, domain: none

GlobalID:

Unique identifier automatically generated for features in enterprise database

type: GlobalID, length: 38, domain: none

Status:

The active or construction status of the asset in the field

type: String, length: 20, domain: AddStatus

domain values:

['Active', 'Inactive', 'Temporary', 'Proposed']

AssetID:

Cupertino maintained GIS primary key. This must end with letter "A".

type: String, length: 50, domain: none

PlaceType:

type: String, length: 50, domain: AddressPlaceType

domain values:

['Educational', 'Transportation', 'Business', 'Government', 'Hospital', 'Recreational', 'Miscellaneous', 'Residential Single Family', 'Residential Multi Family']