Name: Address

Display Field: PRIMARY_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>gisdata.CUPERTINO.Address_PT is a Point FeatureClass representing addresses in the City of Cupertino. Addresses are typically placed on the entrance of a building or park. Unlike secondary address points, primary address points do not have data for suite, apartment, or unit numbers. </SPAN></P><P><SPAN>As of 1/11/2018, 2ndary address points have own address number ( do not have suite, apt, unit number) moved from 2ndary to Address_PT layer.</SPAN></P><P><SPAN>It is primarily used for address matching, map labeling, locational reference</SPAN></P><P><SPAN>The layer is updated as needed using official building letters from the building department</SPAN></P><P><SPAN>The oldest geoprocessing record has a date of: 2008-08-04</SPAN></P><P><SPAN /></P><P><SPAN>gisdata.CUPERTINO.Address_PT has the following fields: </SPAN></P><P><SPAN /></P><P><SPAN>OBJECTID:</SPAN></P><P><SPAN>Unique identifier automatically generated by Esri</SPAN></P><P><SPAN>type: OID, length: 4, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>PRIMARY_ID:</SPAN></P><P><SPAN>Unique identifier used in third party software</SPAN></P><P><SPAN>type: Double, length: 8, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>APN_SPACE:</SPAN></P><P><SPAN>Number of parcel containing address</SPAN></P><P><SPAN>type: String, length: 10, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>LOCATION:</SPAN></P><P><SPAN>Further description of the location of the address</SPAN></P><P><SPAN>type: String, length: 36, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>BLDG_ID:</SPAN></P><P><SPAN>Asset ID of the building referenced by the address. This is found in bldg_footprint</SPAN></P><P><SPAN>type: Integer, length: 4, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>ADDRESS:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 56, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>HOUSE_NO:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 11, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>PREFIX:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 7, domain: AddressPrefix</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['S', 'E', 'W', 'N']</SPAN></P><P><SPAN /></P><P><SPAN>STREET_NAM:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 23, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>SUFFIX:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 7, domain: AddressSuffix</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['CMN', 'EXPY', 'LN', 'SQ', 'PLZ', 'PKWY', 'RD', 'CIR', 'WAY', 'BLVD', 'AVE', 'TER', 'ST', 'DR', 'PL', 'CT']</SPAN></P><P><SPAN /></P><P><SPAN>SUFFIX_DIR:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 11, domain: AddressPrefix</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['S', 'E', 'W', 'N']</SPAN></P><P><SPAN /></P><P><SPAN>CITY:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 11, domain: AddressCity</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>[]</SPAN></P><P><SPAN /></P><P><SPAN>STATE:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 7, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>COMMENTS:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 50, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>ZIP:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 10, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>DataSource:</SPAN></P><P><SPAN>Description of what methods were used for data capture/migration</SPAN></P><P><SPAN>type: String, length: 100, domain: AddressDataSource</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['Building', 'County', 'Fire', 'Unknown', 'County Comm']</SPAN></P><P><SPAN /></P><P><SPAN>UpdateBy:</SPAN></P><P><SPAN>The user who last updated the database row</SPAN></P><P><SPAN>type: String, length: 50, domain: OPERATOR</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['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']</SPAN></P><P><SPAN /></P><P><SPAN>UpdateDate:</SPAN></P><P><SPAN>the date the database row was last updated</SPAN></P><P><SPAN>type: Date, length: 8, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>CreateBy:</SPAN></P><P><SPAN>the name of the staff person who created the database row</SPAN></P><P><SPAN>type: String, length: 20, domain: OPERATOR</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['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']</SPAN></P><P><SPAN /></P><P><SPAN>CreateDate:</SPAN></P><P><SPAN>the date the database row was initially created</SPAN></P><P><SPAN>type: Date, length: 8, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>X:</SPAN></P><P><SPAN>Longitude of the address</SPAN></P><P><SPAN>type: Double, length: 8, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>Y:</SPAN></P><P><SPAN>Latitude of the address</SPAN></P><P><SPAN>type: Double, length: 8, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>ROTATION:</SPAN></P><P><SPAN>Refers to the rotation of the address label</SPAN></P><P><SPAN>type: Double, length: 8, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>Floor:</SPAN></P><P><SPAN /></P><P><SPAN>type: SmallInteger, length: 2, domain: Floor</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['1', '2', '3', '4', '5', '6', '7', '8', '9', '10']</SPAN></P><P><SPAN /></P><P><SPAN>ValidAddress:</SPAN></P><P><SPAN>Indicates whether the address can receive mail. Some empty plots of land are addressed, and these are NOT valid addresses</SPAN></P><P><SPAN>type: String, length: 1, domain: shdBooleanYesNo</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['Yes', 'No']</SPAN></P><P><SPAN /></P><P><SPAN>Shape:</SPAN></P><P><SPAN>Field that stores geographic coordinates associated with feature</SPAN></P><P><SPAN>type: Geometry, length: 4, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>GlobalID:</SPAN></P><P><SPAN>Unique identifier automatically generated for features in enterprise database</SPAN></P><P><SPAN>type: GlobalID, length: 38, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>Status:</SPAN></P><P><SPAN>The active or construction status of the asset in the field</SPAN></P><P><SPAN>type: String, length: 20, domain: AddStatus</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['Active', 'Inactive', 'Temporary', 'Proposed']</SPAN></P><P><SPAN /></P><P><SPAN>AddressPointType:</SPAN></P><P><SPAN>Further description of the address point's placement</SPAN></P><P><SPAN>type: String, length: 50, domain: AddressPointType</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['NonBuilding', 'Unknown', 'Driveway Entrance', 'Building Entrance', 'Other', 'Utility']</SPAN></P><P><SPAN /></P><P><SPAN>AssetID:</SPAN></P><P><SPAN>Cupertino maintained GIS primary key. This must be unique. It is used as a parent ID for secondary addresses</SPAN></P><P><SPAN>type: String, length: 50, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>PostalCity:</SPAN></P><P><SPAN>Postal city differs from City. Some addresses outside of Cupertino are labeled "Cupertino" by the post office. </SPAN></P><P><SPAN>type: String, length: 50, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>CenterlineID:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 50, domain: none</SPAN></P><P><SPAN /></P><P><SPAN>IsDuplicateAddress:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 3, domain: shdBooleanYesNo</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['Yes', 'No']</SPAN></P><P><SPAN /></P><P><SPAN>PlaceType:</SPAN></P><P><SPAN /></P><P><SPAN>type: String, length: 50, domain: AddressPlaceType</SPAN></P><P><SPAN>domain values:</SPAN></P><P><SPAN>['Educational', 'Transportation', 'Business', 'Government', 'Hospital', 'Recreational', 'Miscellaneous', 'Residential Single Family', 'Residential Multi Family']</SPAN></P><P><SPAN /></P></DIV></DIV></DIV>

Service Item Id: 33c5badec9c74525add73a7eac88c47c

Copyright Text: City of Cupertino

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 3267.120265391563

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 6092742.459297106
YMin: 1926483.7431504428
XMax: 6127642.789758772
YMax: 1951290.9999662638
Spatial Reference: 102643  (2227)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [150, 73, 100, 0]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PRIMARY_ID ( type: esriFieldTypeDouble, alias: PRIMARY_ID )
• APN_SPACE ( type: esriFieldTypeString, alias: APN_SPACE, length: 10 )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 36 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 56 )
• HOUSE_NO ( type: esriFieldTypeString, alias: HOUSE_NO, length: 11 )
• PREFIX ( type: esriFieldTypeString, alias: PREFIX, length: 7 , Coded Values: [E: E] , [N: N] , [S: S] , ...1 more... )
• STREET_NAM ( type: esriFieldTypeString, alias: STREET_NAM, length: 23 )
• SUFFIX ( type: esriFieldTypeString, alias: SUFFIX, length: 7 , Coded Values: [AVE: AVE] , [BLVD: BLVD] , [CIR: CIR] , ...14 more... )
• SUFFIX_DIR ( type: esriFieldTypeString, alias: SUFFIX_DIR, length: 11 , Coded Values: [E: E] , [N: N] , [S: S] , ...1 more... )
• STATE ( type: esriFieldTypeString, alias: STATE, length: 7 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 50 )
• ZIP ( type: esriFieldTypeString, alias: ZIP, length: 10 )
• DataSource ( type: esriFieldTypeString, alias: DataSource, length: 100 , Coded Values: [Building: Building] , [County: County] , [County Comm: County Comm] , ...2 more... )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• ROTATION ( type: esriFieldTypeDouble, alias: ROTATION )
• Floor ( type: esriFieldTypeSmallInteger, alias: Floor , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
• ValidAddress ( type: esriFieldTypeString, alias: ValidAddress, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Status ( type: esriFieldTypeString, alias: Status, length: 20 , Coded Values: [Active: Active] , [Inactive: Inactive] , [Temporary: Temporary] , ...1 more... )
• AddressPointType ( type: esriFieldTypeString, alias: AddressPointType, length: 50 , Coded Values: [Driveway Entrance: Driveway Entrance] , [Building Entrance: Building Entrance] , [NonBuilding: NonBuilding] , ...3 more... )
• AssetID ( type: esriFieldTypeString, alias: AssetID, length: 50 )
• PostalCity ( type: esriFieldTypeString, alias: PostalCity, length: 50 , Coded Values: [CalTrans: CalTrans] , [California Water Service: California Water Service] , [Cupertino Sanitary District: Cupertino Sanitary District] , ...16 more... )
• CenterlineID ( type: esriFieldTypeString, alias: CenterlineID, length: 50 )
• IsDuplicateAddress ( type: esriFieldTypeString, alias: IsDuplicateAddress, length: 3 , Coded Values: [Y: Yes] , [N: No] )
• PlaceType ( type: esriFieldTypeString, alias: PlaceType, length: 50 , Coded Values: [Residential Single Family: Residential Single Family] , [Residential Multi Family: Residential Multi Family] , [Business: Business] , ...6 more... )
• BLDG_ID ( type: esriFieldTypeString, alias: BLDG_ID, length: 50 )
• City ( type: esriFieldTypeString, alias: City, length: 50 , Coded Values: [CalTrans: CalTrans] , [California Water Service: California Water Service] , [Cupertino Sanitary District: Cupertino Sanitary District] , ...16 more... )
• Operator ( type: esriFieldTypeString, alias: Operator, length: 255 , Coded Values: [AARON: AARON] , [ADAM: ADAM] , [ADAMP: ADAMP] , ...45 more... )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata