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