Layer: Cupertino Addresses (ID:0)

View In: Map Viewer

Name: Cupertino Addresses

Display Field: APN_SPACE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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:

CreateDate:

the date the database row was initially created

type: Date, length: 8, domain: none

Longitude of address

type: Double, length: 8, domain: none

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']

Copyright Text: City of Cupertino

Min. Scale: 5000

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":"uniqueValue","field1":"Impacted","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,170,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"This address is on a property potentially impacted by bird safe guidelines","label":"This address is on a property potentially impacted by bird safe guidelines"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,92,230,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"This address should not be impacted by any bird safe guidelines","label":"This address should not be impacted by any bird safe guidelines"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,189,255],"toColor":[179,252,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,250,255],"toColor":[252,179,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,182,255],"toColor":[252,204,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,223,252,255],"toColor":[184,223,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,250,187,255],"toColor":[252,250,187,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,252,240,255],"toColor":[215,252,240,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,235,255],"toColor":[252,212,235,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,184,252,255],"toColor":[179,184,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,201,255],"toColor":[252,179,201,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,238,210,255],"toColor":[252,238,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[225,199,252,255],"toColor":[225,199,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,252,208,255],"toColor":[204,252,208,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,185,184,255],"toColor":[252,185,184,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: Impacted

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
APN_SPACE (type: esriFieldTypeString, alias: APN_SPACE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 56, nullable: true, editable: true)
CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
ZIP (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Impacted (type: esriFieldTypeString, alias: Impacted, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Types:

Impacted: This address is on a property potentially impacted by bird safe guidelines

Impacted: This address should not be impacted by any bird safe guidelines

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/4/2021 9:37:57 PM

Schema Last Edit Date: 5/4/2021 9:37:57 PM

Data Last Edit Date: 5/4/2021 9:37:57 PM

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